Below are the 7 Data Analytics Pros & 3 Data Analysts with multiple systems/technical expertise. The Thor Group® provides data analysts & data analytics Pros with your systems & industry experience on a consulting, contracting or direct hire basis.

Would a data analytics manager who conducted a company-wide rollout/implementation of SQL Server Reporting Services to replace Crystal Reports, resulting in significant licensing savings, match the needs of your organization? This specialist has worked in the manufacturing, insurance and software industries. Technical skills include Sage 50/Peachtree Accounting Software, Solomon IV, Visual FoxPro, Crystal Reports Great Plains, SharePoint, Visual Basic, PeopleSoft, Sybase, DB2, IBM WebSphere MQ, IBM Message Broker, Microsoft SQL Server and Oracle. Educational background includes a Master Degree, Bachelor Degree and Bachelor of Science Degree.

As a data analytics manager working in an insurance company, successfully managing and leading a team of 10 technical associates in an agile business intelligence environment, were some of the duties carried out. Moreover, conducting a company-wide rollout/implementation of SQL Server Reporting Services to replace Crystal Reports, resulting in significant licensing savings, was one of the remarkable accomplishments. One of the key achievements involved successfully migrating the association from Sage 50/Peachtree Accounting to Solomon IV for SQL Server.

Part of the job as a database administrator in a manufacturing business, was to lead a project team for IBM UDB DB2 replication, resulting in successful system integration and significant cost reduction. Coordinating change management review and auditing efforts resulting in higher quality information technology implementations, were some of the notable contributions. Technologies that decreased costs, increased performance and positively affected the bottom line, were implemented. In addition, database solutions that improved business functionality were also implemented.

Is employing a data analytics professional who worked in professional services, IT and real estate industries, a primary business consideration? Software skills are mainly on Sage 100 ERP, QuickBooks, Crystal Reports, various accounting programs, other ERP software solutions, and more. Other proficiencies are in the areas of warehouse management systems software, bar code scanning, EDI, document management, website automation, data imports, data analysis, data analytics, and data mining. This licensed broker also has certifications in Sage MAS 90/200 accounting modules, distribution modules, inventory management, system administration, installation and implementation.

While working for a business management consulting company as a data analytics professional, some of the duties were installing, setting up, customizing, troubleshooting and training on Sage 100 ERP (formerly MAS 90/ MAS 200) software. Another task was working on WMS (warehouse management systems) software, bar code scanning, EDI, document management, website automation, data imports, data analysis, data analytics, data mining and many other ERP software solutions.

Serving in another consulting services company, providing training to client organizations for all aspects of Sage MAS 90/MAS 200, was a primary responsibility. This initiative included initial program installation, set up, upgrades, training in one-on-one and group settings, problem analyzing and solutions recommendation.

Could the future success of your organization be helped by this data analytics specialist, with work background in the construction and pharmaceutical industries? Technical skills include the use of Sage 300/Timberline, Timber Scan, Great Plains, PeopleSoft, Net Suite (ERP), Click Time, Keane (A/P system), Peachtree, QuickBooks Enterprise 2010, Celerant (point of sale system), and QuickBooks Pro 2008/2006. Some of the notable accomplishments involve developing a technique that resulted in reduced costs in worker’s comp insurance, as well as implementation of controls and process enhancements for costs control that increased productivity. Educational attainment includes BBA in Accounting and Finance (double major).

Contributed to the organization through doing month-end closing with cash management, sales tax filing, GL reconciliation and bank reconciliation (Timberline). The position called for having strong analytical skills (data analytics & ad hoc-reporting). Previous experience as an IT programmer with working knowledge of SQL, data management/data analytics using Excel, was a key strength.

Supported organizational goals and objectives by developing a technique that resulted in reduced costs in worker’s comp insurance. Part of the job was to process weekly payroll (QuickBooks), remitting payroll taxes and performing reconciliation, GL JEs, job costing (Construction Accounting), extensive monthly, quarterly and annual reporting as well as AP/AR and month end closings. An additional responsibility was assisting in worker comp audits, project/job costing and office management.

The future success of your organization could be helped by this data analytics specialist with work background in the education sector and environmental services industry. Technical skills include Sage 50/Peachtree, SQL Management Studio (SSMS), SAS Enterprise Guide, Visual Analytics, Social Network Analysis (SNA) and Tableau. Core competencies comprise of fraud and forensic accounting, intellectual property valuation, internal/external financial accounting and SEC reporting. Educational attainment includes Master of Business Administration, Bachelor of Science and Associate Research Scholar. Certifications: CFE (Certified Fraud Examiner) and Certified Public Accountant (in progress).

While working for a technical community college, one main function was to instruct individual taxation, principles of accounting, intermediate/advanced financial accounting, as well as payroll and computerized accounting using Sage 50/Peachtree. Working with an outside advisory committee to redesign accounting curriculum in order to establish tracts of specialization and additional transferable accounting courses, was also one of the duties accomplished. This specialist was responsible for day to day management and personnel selection of accounting and adjunct faculty. As a business representative to the faculty senate, an important role was played by serving in marketing and graduation committees.

As a data analytics specialist for an environmental services company, performing analytic, data mining activities as well as manipulating data to interpret financial patterns and discover unusual activity, were some of the key tasks accomplished. The management of a team that involved 11 direct reports, supporting 80 fraud analysts, forensic accountants, investigators and consultants, was also part of the job. Weekly performance briefings to C-Suite executives were efficiently handled.

Would your organization benefit from hiring a data analytics professional with experience working in a tertiary care hospital and a critical access hospital? Technological background comprises of PeopleSoft 7.5 and 8.9 HRMS, PeopleSoft Query Manager, ADP v5.03, ADPR Report Writer, SQL Navigator, Microsoft Office Suite, SQL Plus, Meditech HRMS, Concentric R&R Report Writer and PS Query 2-Tier.

Serving in a tertiary care hospital as a data analytics professional, part of the job was to work on HR data analytics, data verification and validation of ePCN data entry. Some of the responsibilities involved HR system test data selection, plans development and system testing. Moreover, this specialist was responsible for PeopleSoft connection analytics and review of nightly BAS activity ePCN data entry run.

Being employed in a critical access hospital, the use of Meditech HRMS for new employee HRIS data entry, applicant tracking and applicant phone screening was employed. Other tasks involved hiring manager interviews, resume disbursement coordination and new hire process onboarding compliance coordination.

Could the future success of your organization be helped by this data analytics specialist who worked in a children’s hospital? Technical skills include PeopleSoft ERP, Lawson, Microsoft Office Suite, Oracle, Solaris, UNIX, AIX, Windows XP, Java, .NET, IBM AS/400, COBOL, Visual Basic, Cognos and Visio.

Acting as a data analytics specialist, some of the duties consisted of administering and coordinating data quality processes focused on client billing compliances using SharePoint. The development of Excel spreadsheets, dashboards and macros with VBA codes in order to access and analyze large amounts of billing data and metered data was also carried out. Moreover, the use of PI and eDNA to perform data quality analysis and trends of real time data were employed.

Working in a children’s hospital, part of the job was to load requirements to quality measured SharePoint sites for data analytics and process measurements. Supporting Oracle PeopleSoft HR applications and reports processing for the department was also performed. An additional task was gathering requirements for Oracle SQL reporting of Epic and Clarity clinical hospital data.

Does a detail-oriented data analytics professional with extensive experience in IT and has significant background in SAP BI 7.0 BW 3.5, BODS 4.0 and ABAP fit in your organization? Highlights of expertise include proficiency in creating restricted and calculated columns in analytical privileges, procedures, functions, attribute views, analytic views and script/graphical calculation views with aggregation types available like min, max and sum. Technical skills are composed of SAP HANA SP4/SP5, Oracle, MS SQL Server, DB2, MS Access UNIX (Sun Solaris and Linus) and MS Windows.

While working for a teaching hospital as a data analytics professional, creating and configuring data flows in SAP Landscape Transformation 2.0 for data replication between SAP ECC, SAP BI InfoCubes/DataStore Objects and SAP HANA were some of the duties completed. Part of the job was to create tables, table types, analytical views, attribute views, calculated columns and restricted columns with variables and input parameters to satisfy reporting requirements.

An additional responsibility was to conduct data model analysis on SAP ERP application tables related to purchasing. Gathering the reporting requirements by meeting with user community as well as analyzing and comparing them with available business content to determine the gaps were also some of the duties carried out. Moreover, this specialist extensively worked on transporting objects between BI/BW system environments and corresponding SAP R/3.

Is impacting your organization with a data analyst with vast IT experience in the development, testing, design, maintenance, administration and analysis of software solutions and reporting systems/applications, a current business consideration? Technological knowledge includes Sage 300/Timberline, BI MicroStrategy, MS IIS, MS Visual Studio Application Suite, SQL Developer for Oracle, Toad, Wise for Windows Installer, CorVu Application, Sage Saleslogix and Microsoft Office Suite. Core competencies include skills in designing, developing, and testing in Crystal Reports, as well as creating necessary views and database objects to increase performance of the reports. This specialist also designed and developed workbooks using Crystal Reports on an operational data store. Educational attainment consists of Bachelor of Science in Informatics and Computer Engineering.

Being employed in a telecommunications company as a data analyst, one key task was to design ad-hoc reports for the service delivery team utilizing CSG (Oracle) and OM/CBOM (MS SQL) verified data for a smart application that involved various data analysis. Also, the creation of data analytical databases (MS Access) from complex operational data was carried out. Furthermore, this specialist was involved in the development of batch files to connect to Oracle externally and generated the SQL queries in order to extract data and load data into temp tables using TOAD.

Part of the job as a data analyst for an insurance company was developing SQL for stored procedures used for an agent online reporting system. The analysis of business requirements and the development of quality assurance SQL to verify ETL process results, were also carried out. Other tasks involved developing test scripts for various projects as well as creating ad-hoc reports with Microsoft Excel for data analysis.

Is impacting your company with a data analyst who created custom objects to track the competitor’s products/pricing and worked in food, pharmaceutical and manufacturing industries a current business consideration? Technical experience includes JD Edwards, Oracle, Saleslogix, Salesforce.com, MAS 90, MAS 200 and Crystal Reports. Educational attainment includes a Bachelors degree in Electronic Engineering. Certifications include Oracle BI Administration, Oracle CRM On-Demand Administration, Oracle BI Power User, SalesLogix 7.x LAN development, SalesLogix 7.x LAN installation, SalesLogix 7.x training, SalesLogic 7.x LAN administration, Salesforce.com administration, Crystal Reports 11 and Sage MAS 90/MAS 200.

Major functions involved integrating JD Edwards’s data into OBIEE, administering and supporting the CRM. The job entailed developing reports and dashboards based on business requirements for executive management on sales performance on daily, quarterly or yearly basis. Reports on sales were prepared for the sales management team. The job involved performing requirements gathering with management and users to identify business processes and definition for OBIEE. Key roles consisted of designing and implementing reports and dashboards that used complex visualization techniques such as scatter plots and histograms to communicate key metrics.

This data analyst administered CRM (fields, users, security), worked with sales to customize CRM and increase productivity. Working in Agile environment, creating custom object to track competitor’s products/pricing, training users on best practices and writing custom training programs were skills utilized. Training users on CRM manuals, supporting Oracle BIEE and designing the Star Schema database were included in the list of tasks accomplished.

Can the future success of your organization be helped by this data analyst with extensive knowledge in application support, business analysis and project management? Technical skills include JD Edwards EnterpriseOne modules such as Order Management, Inventory, Procurement, Warehouse Management and Financials. Application knowledge covers Oracle, IBM iSeries, AS/400, MS SQL, Sharepoint and other tools. This analyst has a strong understanding of the relational database and experience with SQL for database queries/analysis. Training courses taken are in JD Edwards EnterpriseOne Report Writing (Release 8.94) Ed 1; JD Edwards EnterpriseOne Development Tools Part 1 Release 8.94; BI Publisher for JD Edwards EnterpriseOne Release 8.98 Update 1; and other subjects.

Acting as programmer/data analyst (JD Edwards EnterpriseOne XE) for a food services company, one main function was to assist in defining the “to-be” process flow for data moving between the web portal and Order Management system in JDE XE environment. Defining the file structure and field mapping used to house front-office data on a SQL Server was also performed. Moreover, the development of custom table conversion, UBE and application programs for seamless upload of sales orders along with promotion items from an external source (i.e. web portal, Excel) into JD Edwards Order Management system was carried out.

As data analyst (JD Edwards EnterpriseOne XE/9.0/9.1), analyzing, documenting and creating “as-is” interface/EDI process flows used for middleware along with JD Edwards projects’ purposes were key responsibilities accomplished. Analyzing the existing EDI Remittance Advice (820) process, while successfully designing and implementing a resolution to a recurring issue in JD Edwards 9.0 consolidated environment were notable contributions.