Below are the 6 Data Analysts/BI Developers & 7 Database Administrators with multiple systems/technical expertise & other systems experience. The Thor Group® provides Big Data engineers, data warehouse managers, database managers, BI analysts, data scientists, data modelers, database developers, data analytics pros, data migration specialists, ETL experts, BI developers and more on a consulting, contracting or direct hire basis.

Does a data architect who is knowledgeable in PeopleSoft Supply Chain, with experience in software, IT and professional services industries pique your interest? Technical knowledge includes PeopleSoft FSCM – BI, AR, PO, AP, GL , Exp, e-Proc, AM, INV, CM, PC, Supplier Contract, eSupplier, Catalog Management, SRM Dashboard (Rel 8.x – 9.0), PeopleSoft HCM & CRM – Payroll, Student Financials and more.

Responsibilities in a software company encompassed implementing PeopleSoft Receivables, Cash Management, Suppliers Contract, eSupplier, Catalog Mgmt, and SRM in addition to understanding business processes, system/third party applications and gathering requirements. Setting up and configuring PeopleSoft Application in Development, SIT, UAT and Production instance comprised other tasks. Aside from conducting solution workshops/CRPs based on high level requirements, this data architect conducted fit-gap analysis, solution design and prepared future process model documents.

Job descriptions covered preparing functional specifications for development/customizations, creating Component Interface, uploading Master Data through Excel-to-CI tools and preparing/publishing test plans and test scripts. Skills brought to the table involved preparing training manuals, conducting end user training as well as handling system integration testing between PeopleSoft and third party applications. Carrying out necessary changes to UAT/production based on end-user input and preparing for Go-Live were part of the assigned tasks.

Could your organization use a BI developer who is proficient in MS Dynamics CRM, Oracle and SSRS Reports, as well as experienced in IT services, accounting and business services industries? Technical proficiencies cover MS Dynamics CRM, Oracle, SSRS Reports, SQL, T-SQL and Power BI. Educational attainment includes B.S. Engineering (Electrical/Computer Engineering, minor in Business Management). This individual obtained a Microsoft Certification (MCSA) for SQL Developer.

Primary tasks of this BI developer included developing, testing and deploying SSRS Reports supporting governmental financing client. Developing custom, extensive T-SQL scripts and SSRS calculations for combining Microsoft Dynamics CRM application data into custom “hybrid” source SSRS reports thru client-side publishing via internet hosting was also handled. Key roles covered interpreting report requests for feasibility of report writing and publishing across company’s IT platforms.

Contributions in other jobs involved performing ad-hoc T-SQL queries in SQL Server 2008 R2, 2012, 2014, and 2016 in support of state leaders, in addition to updating and maintaining periodic dashboards, Tableau, Power BI, and Excel reports. Developing ETL processes in SQL Server 2008 R2 thru 2016, in addition to writing T-SQL scripts and SSIS integration packages were managed. This individual performed data investigations, systems documentation using Visio diagrams; data dictionaries were built. Skills brought to the table involved handling application installations ERP tech support, ERP process debugging and crash recovery, along with completing data systems development operations. Aside from data warehouse design, BI Platform analysis and recommendations were carried out. SQL Scripting, ETL migration and ad hoc queries were efficiently managed. MS Business Intelligence ETL utilities were developed using MS BI stack (SSIS, SSRS, SSAS).

How would a data analyst who is skilled in Peoplesoft HR, with background in IT, oil and gas industries match the needs of your organization? Technical specialties include: PeopleSoft, PeopleCode, SQL, SQR, SQL Server, Oracle, UNIX, HR, Payroll, Base Benefits and more.

Key contributions covered successfully implementing PeopleSoft HCM with modules HR, Payroll, Benefits Administration, Absence Management, Manager of Self Service and Employee Self Service for approximately 8000 users. Customizing the delivery direct deposit SQL interface and writing custom Positive Pay app engine interface were some of the assigned tasks. This data analyst wrote custom inbound and outbound app engine interfaces for a retirement savings provider.

Overseeing, designing, developing and testing modules for HR within PeopleSoft were part of this professionals expertise at their last position. The approval workflow engine was used to initiate and approve/deny four separate types of position requests, each having their own unique approval chain. Contributions involved successfully resolving numerous defects found during the testing phase of the implementation through troubleshooting, research, as well as assistance from Oracle.

Would a data analyst proficient with Oracle for the financial services industry be of great value to your company? Professional skills include Oracle, MS SQL Server, SQL Server Reporting Services (SSRS), SAP BusinessObjects Web Intelligence and IBM QualityStage. Besides being an Oracle Database SQL Certified Expert (Oracle certification 1Z0-047), the analyst has B2T Training Business Analyst Development Program, as well as B2T Training Joint Application Development Certificate.

Forming part of a financial services company, responsibilities included data analysis and profiling of acquisition data; validation and quality assurance of ETL from a wide range of data sources. Design and data flow documentation were developed that made an extraordinarily complex process understandable. Resolving data quality issues guaranteeing a smooth transition of acquisition data was also performed.

While working for another financial services company, main duties involved analytic studies to determine data quality, integrity, completeness and accuracy. Part of the job was documenting and reporting on incoming data to support business decisions. High level negotiations with states and audited companies were supported with time-sensitive, complex SQL queries in the Oracle database. Other duties were performing data analysis in support of ad hoc and standing user requests, as well as doing data cleanup, de-duplication and validation, including data from legacy mainframe systems.

Does a detail-oriented data analyst with vast years of experience in providing excellent customer services in the financial, healthcare and charity industries fit in your organization? Areas of expertise include SAP ERP 6.0 DMO (data management organization), data entry, benefits analysis, account management and customer service.

While working for a professional services company as a data analyst, part of the job was to create a plan and strategy with the business department to ensure the transfer of the customer master data from QAD software to SAP ECC 6.0. In conjunction with the data services team, the preparation of customer master data upload files for SAP ECC 6.0 applications was carried out. Additional responsibilities involved making sure all data had been generated correctly and evaluating SAP Master Data to ensure it conformed to the requirements of the company as documented in the data standards.

Serving in a financial services company, main functions included analyzing over payment issue, including researching data in various systems to identify discrepancies to participants via pension, IRA accounts and 401(K) savings plans. Understanding and developing processes to effectively facilitate and meet company goals were also some of the duties accomplished. Another task was leading complex projects regarding multi-client’s accounts and other tasks as needed.

What can a data engineer with specializations in MS Dynamics CRM, Oracle and Informatica, as well as work background in marketing, software and financial services industries bring to your organization? Technical specializations involve MS Dynamics CRM, Oracle, Informatica, Teradata, Access, MySQL, SQL Server Integration Services and Power BI. Educational background includes Master of Science in Computer Science and Bachelor of Technology in Computer Science.

Working with areas such as understanding functional requirements and translating technical documents and data mappings were some of the skills brought to the table by this data engineer. Duties covered working on all phases of data warehouse development lifecycle, from gathering requirements, implementation, testing and support, as well as getting involved in dimensional modeling of the data warehouse to design dimensions, facts, Star Schema and Snowflake schemas. Contributing to building out reporting architecture was done to provide business intelligence to business managers and higher management. Developing, deploying and scheduling SSIS packages to load data from different sources like Salesforce, MS Dynamics CRM, SQL server and flat files into data warehouse were some of the tasks.

One of the responsibilities consisted of managing SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations to load in to DW. Tasks involved developing reports and dashboards, in addition to creating subscriptions for internal business users, HR team, clients and for higher management using SSRS, POWER BI and Tableau. Creating the standard process template for all the SSIS packages (which was later used throughout the company) was also managed.

Does your organization require the expertise of a DBA who is skilled in PeopleSoft ERP with background in online education, pharmaceutical and software industries? Technical knowledge involves PeopleSoft ERP, Oracle Server, MS SQL, Hyperion Essbase, EC2, EP, S3, VPC and more.

Important contributions included PeopleSoft ERP implementation, upgrading and providing production support from onsite/offshore. Performance tuning of PeopleSoft applications, components and Oracle databases were also accomplished. Other duties involved working on Peoplesoft HR upgrade from PT849/HR89 to PT854/HR9.2, configuring Oracle SES (Secure Enterprise Search) framework and PeopleSoft Update Manager setup/maintenance.

Key roles consisted of performing PeopleTools 8.53 upgrade for PeopleSoft Financials 9.0 and analyzing MS SQL server upgrades for data warehouse solution/Oracle 11g for homegrown applications. The job entailed working as PeopleSoft/Application/Database administrator in production support role, providing on-call support 24X7 on rotations. Issues uncovered during the debugging process were tested and resolved.

Is impacting your organization with a database administrator with experience working in telecommunications, consumer products and IT industries a current business consideration? Educational attainment is composed of Bachelor of Engineering in Production (BE Production). Professional certifications consist of Oracle Certified Professional (OCP) and ITIL Foundation Certification. Technical skills involve JD Edwards, Oracle Real Application Cluster (RAC) Databases /10gR2 /11g, and Single Instance Databases 8i / 9i / 10gR2 / 11g.

While employed as a database administrator, managed JD Edwards, PDS, INTOOLS, and PRIMAVERA Application, as well as responsible for installation and upgradation of Oracle databases. Some of the tasks were monitoring and maintaining the production databases and responsible for databases on a 24 x 7 basis aside from maintaining uptime and allocating system storage requirements for the production database system. Part of the job was to enroll users and maintain system security, audit the database objects and system privileges, as well as manage user privileges and roles.

Part of the job as a sr. Oracle DBA was to be responsible for installation and upgrade of Oracle databases. Other duties were monitoring and maintaining the production databases and being responsible for databases on a 24 x 7 basis in addition to maintaining uptime and allocating system storage requirements for the production database system. Furthermore, enrolled users and maintained system security, as well as audited the database objects and system privileges.

Could your organization use an Oracle DBA who is experienced in software and manufacturing industries with knowledge in Oracle Financials? Technical proficiencies encompass Oracle Financials, Linux, TKProf, SQLT, Trace Analyzer, Enterprise Manager and more.

Primary responsibilities included real time production monitoring using OEM 12c for any SQL which caused loads on the production database, as well as identifying the SQL that caused the load. Other functions were generating and identifying missing or invalid indexes. Monitoring the Oracle GoldenGate replication and identifying the root cause for any lag in replication invalid stats were skills brought to the table. Notable tasks consisted of reviewing Veridata reports, identifying the cause for out of sync tables and fixing issues through manual sync ups wherever appropriate.

Heavy usage of the Oracle Partitioning feature was maintained to conform with high transactional tables (Log tables). Periodic truncation of 6-8 month old partitions and recycling of the spaces for future data storage were part of the job. Compliance with all PCI audit requirements from database standpoint was also ensured.

What can a database administrator with specializations in Microsoft CRM, Great Plains Dynamics and Salesforce, as well as work background in energy, IT services and retail industries bring to your organization? Technical specializations involve Microsoft CRM, Great Plains Dynamics, Salesforce, SharePoint, VMWare, ASP.NET and JSON. In addition to having experience working with SQL Server for more than 20 years and its associated toolset, the professional has been in many lead positions, managing both development teams and projects alike.

Working with areas such as consolidating databases and designing much more manageable and sustainable ETL processes while improving performance were some of the responsibilities of this database administrator. The SQL code was integrated into the Team Foundation Services (TFS).

An additional function involved working as part of a web developer’s team and within an Agile process. Developing QA stored procedures, ensuring database integrity/ design, backup, restore/ refresh dev, test and staging areas were some of the tasks. The job covered serving as data architect, data workflow developer, business intelligence architect & developer, .NET developer (C#, VB.NET) and DevOps development team manager. Improvements were carried out to SDLC, process improvement proposals, data science practices, application lean processes (i.e. parallel, disconnected metric and reporting), data migration to Azure, data security, data encryption, reporting/analytics team lead and training. Production support, performance tuning, backup restore, disaster recovery, fail-over and sync strategies were efficiently handled. Skills brought to the table consisted of Azure migration, integration and management, .NET development C#, VB.Net (Web/Windows Forms), SQL development and administration. SSAS Tabular Development/MDX Cubes, ETL (SSIS) development, SQL ETL and Data Warehouse/Data Mart Development, SQL Data Lake and Data Factory were efficiently handled.

Would your company benefit from a DBA who is proficient in SAP ERP with industry experience in utility, technology and software? Technical skills cover SAP ERP, Oracle, SQL Server, Sybase, DB2, MySQL and more.

Major functions consisted of architecting database environments and supporting/maintaining large scale MS SQL Server and Oracle database environments. Functions covered building technical solutions/roadmaps for database environments, disaster recovery and leading business continuity planning efforts. Investigating and researching new technologies were handled to plan for future database landscapes. Backups, recovery, security, imports, exports, database duplication (clones), OEM 12c and application support were also provided.

Notable tasks included managing/administering all SQL Server database environments which included installation, maintenance, security, optimization and design of standalone Microsoft clustered environments. Architecting/creating the database infrastructure, researching and building in-memory solutions while working with many high availability solutions were skills brought to the table.

Could the future success of your organization be helped by this database administrator who worked in IT services, banking and defense industries, as well as proficient in Deltek and PeopleSoft? Technical competencies involve Deltek, PeopleSoft, Cognos, Visual Basic, AS/400, SQL Server and SharePoint. Educational attainment includes a General Diploma.

Important contributions of this database administrator included administering the Deltek operation system, password resets, adding project set-up codes and user updates, as well as creating, maintaining and updating financial databases and spreadsheets. Various financial reports were generated as required. The accounting department was supported for financial tracking, monitoring and reporting financial data as requested. Aside from developing database utilities and automating reporting, the Access database was designed for data warehousing, restoring and recovering corrupted databases. Wire and GL entries were prepared. Analysis of system cut-off activity was performed and compared to the remittance methodology. Tasks covered managing the monthly close and adjusting journal entries, in addition to assisting with special projects within the department. Management was supported in the identification of reporting trends and key deficiencies were analyzed. Key roles involved developing complex query/data extraction from multiple data sources in support of various business needs and creating automation reports via Access database.

In another job, designing, testing, implementing and maintaining reporting or operations databases were included in the list of duties. In addition, this specialist created SQL, Access, PowerPoint and Excel Links to run automation reports and conducted advanced statistical analysis of data to identify patterns and trends. Abode entry forms were created to fill out and digitally sign.

What opportunities can recruiting a database administrator (DBA) with experience working in the retail, apparel and food services industries offer your company? Computer experience is in Sage MAS 90/200, Sage 100, MS SQL Server, BusinessWorks and many other applications. This DBA has bachelor degrees in Management Information Systems (MIS) and Accounting. Aside from being a Microsoft Certified Professional, the individual also has MCSE Windows NT4.0 Certification.

While working in a clothing store, this DBA focused on Sage MAS 90/200 and Sage 100. Other concerns were providing technical support and performing report design.

For a food services company, this database administrator also served as project manager. Duties were evaluating and selecting software, hardware, as well as vendors. The individual also provided training and support for end users.