Below are the 6 Data Analysts & 4 Data Architects with multiple systems/technical expertise. The Thor Group® provides data analysts & data architects with your systems & industry experience on a consulting, contracting or direct hire basis.

Is impacting your organization with an application/data analyst who worked in a children’s hospital and a correctional healthcare facility a current business consideration? Academic credentials involve Bachelor of Science in Management Information Systems. Technical skills consist of Lawson SCM, SQL, Oracle, HTML, CSS, SAP and Crystal Reports. Areas of expertise consist of Technical Planning Experience, Technical Report Writing, Implementation Consultation, Data Analysis, Application Support, Fast-Paced Server Troubleshooting, Technical Process Improvement, Conflict Management as well as Customer Service & Client Relations.

While employed in a children’s hospital, served as an application analyst/engineer in performing a wide variety of analytical and reporting work for the hospital. Also, determined appropriate analysis documentation based on project needs such as user stories, process flows, and functional specifications to ensure that all features and functions are tested and validated. Moreover, developed and maintained a variety of report types including but not limited to tabular, drill down, matrix and charts using SAP Crystal reports; utilizing SQL server database to write queries, views, or stored procedures to extract data.

Part of the job as a data analyst was to analyze and manipulate data within SQL server database to create enhancements to existing and new reports. In addition, translated technical language and concepts to end user comprehension as well as successfully developed and maintained the EHR solutions for the company.

Does hiring a data analyst with work experience in telecommunications, automotive and publishing industries, match your business needs? Technical background mainly consists of using Sage (particularly Saleslogix), MS Dynamics, Intuit QuickBase, and Oracle Business Intelligence Enterprise software. This Psychology graduate has Master’s degrees in Business Administration and in Community Health (concentration in health-care management). In addition to having licenses in notary public appointment and real estate, accomplishments include: scoring 32 in Medical College Admission Test; scoring 115 in Defense Language Aptitude Battery; and completing Army Basic Training – Specialist.

Being a data analyst for a telecommunications company, key duties were creating new methods and procedures in customer satisfaction surveys to improve the sales process, install and post-install customer relationship management (Sage CRM, MS Dynamics). Conducting business data collection, process analysis, workflow analysis, quality assurance reviews and other technical and business related studies using Intuit QuickBase and Oracle Business Intelligence Enterprise software, were also performed. Additional responsibilities were composed of analyzing complex customer reported issues using Remedy to create innovative solutions involving engineering, installation, sales and technical support departments to identify solution components.

Working for a publishing company, the analysis of market research data using Sage Saleslogix (industry standard CRM tool), was carried out. Part of the job was to manage the CRM database and maintain client contracts. Other tasks involved serving as a primary contact for clients and advertising agencies regarding schedules, pricing as well as budgets.

How can your organization gain an advantage with the help of a data analyst who is skilled in JD Edwards SCM and Oracle with work background in manufacturing and business services industries? Technical skills cover JD Edwards SCM, Oracle, PL/SQL and Cognos. Areas of expertise include manufacturing inventory, logistics, and distribution; data analysis; and supply chain business analysis. Educational attainment includes Bachelor in Business Administration (Major: Management Information Systems) and AS in Computer Information Systems (Major: Computer Information Systems). This individual obtained Certifications in CNA (Novell Administration) and Computer & Information Systems.

While working for a manufacturing company, one of the main functions of this data analyst was composed of performing diverse roles in cross-functional teams involving master data management, sales & operations planning and advanced supply chain planning. This individual was responsible for full SKU life cycle set up by assigning and registering new SKU’s, basic and full system SKU setup in JD Edwards. Business analysis, project evaluation and achievability determination of data feed requirements for news products were conducted. Aside from organizing new product launches, support was provided until the product was available for sale.

Duties involved ensuring that the organization did not use multiple (potentially inconsistent) versions of the same master data in different parts of its operations and working closely with supply chain planning team to ensure ERP Master Data elements were accurate and updated in a timely manner. Notable tasks included creating and maintaining status reports and issue logs for various projects. The project plan was maintained by updating inputs from project team members and stakeholders.

How can your organization benefit from hiring a data analyst who analyzed and cleaned up data in the current sales database, and is proficient in Sage 50/Peachtree, Siebel and Salesforce with a work background in media production and marketing industries? Technical skills include Sage 50/Peachtree, Solomon, R&R Report Writer, Crystal Reports, LMS Legal Accounting Software, AS/400 (IBM) commands/processes/utilities, Siebel, Salesforce and Microsoft Office Suite (including macros). Educational attainment includes Bachelor of Business Administration, Accounting with a cumulative GPA of 3.7/4.0.

While working for a media production company as a data analyst, part of the job was to work in a team of 16 to analyze and clean up data in the current sales database (Siebel), in order to facilitate moving forward with a data conversion to a new sales database program (Salesforce). The use of Excel and Access in analyzing data to find data defects, were also employed. Furthermore, this specialist corrected data defects while recording and cataloguing all the changes made.

In an HVAC company, main functions involved planning and successfully implementing the conversion of four companies’ financial data from Sage 50/Peachtree to C/F Data Structures software, including setting up financial statement formats and reporting. Responsibilities involved performing all accounting functions, as well as handling month-end closings, journal entries, financial statements and all specialized monthly reporting. Troubleshooting and solving software issues for 40+ users in 3 locations, were additional contributions. Variance analysis was also performed, comparing company cost and variances, sales reconciliation, payroll and accounts receivable reconciliation.

Does a data analyst who is knowledgeable in Lawson ERP with experience in medical center, pharmaceutical and university industries pique your interest? Technical knowledge includes Lawson ERP, PeopleSoft, Sage MAS 90, Sage MAS 200, Sage MAS 500, American HealthTech LTC, McKesson Horizon Homecare, Mestamed, EDI implementation and more.

Major position responsibilities encompassed supporting all enterprise-wide software systems such as Lawson and providing ad hoc finance reports that allowed successful period closes in 3 months since the conversion to Paragon EMR software. Automating benefits information FTP transfer process that had been broken more than 6 months and replacing all Lawson A/P reporting capabilities with SQL SSRS reports were major personal contributions. In addition, this data analyst upgraded the plant operations TMS software for the first time since original installation.

Other responsibilities involved using the proprietary SQL Server analytic model for the improvement of SSIS ETL packages, processing 15 insurance client’s casework data and updating all specification documentation for the integration team. Moreover, tasks consisted of creating documentations for client data file processing and generating a backup plan should initial SSIS package processing fail. Several gigabytes of client input data were also inspected and cleaned.

How can a Salesforce.com data analyst with work experience in real estate, banking and financial services industries help your organization? Educational attainment is composed of BS Management Information Systems and MBA Corporate Finance & Entrepreneurship. Technical skills involve Salesforce CRM, SSIS, SQL, Java and Visual Basic.

Working with challenging issues such as extracting, profiling and migrating data from various different systems into Salesforce using tools like Data Loader and Demand Tools have vetted this specialist’s work experience. While working in a real estate company as a Salesforce.com data analyst, travelled domestically and internationally to various markets as needed for data migration, as well as built and maintained reports and dashboards as required. Some of the tasks were performing ad hoc data analysis as required, as well as building relationships and gaining cooperation with stakeholders to drive business results. Also, contributed insights to the team for native and third-party applications from SFDC which would help solve a business issue/problem.

With a “can do approach” in the area of providing process design improvements, implementation and optimization for Enterprise Salesforce.Com CRM tool have been career objectives. While employed as a Salesforce.com analyst/administrator in a bank, proficient in using tools like Demand Tools, People Import, etc. for efficient Data Management and maintaining the integrity of the data entered in Salesforce.com. Part of the job was to provide support to the sales teams for efficient leads pipeline management to drive business results and ensure accountability.

Does recruiting a data architect with work background in engineering, IT and telecommunications industries match your organization’s requirements? Computer knowledge covers Salesforce CRM and Oracle, as well as MySQL, MongoDB, R Language, Splunk, Oozie, Clodera, Hadoop, and Informatica. Core competencies also consist of Big Data, business intelligence, ETL, and data warehousing. Educational background includes B.S (Computer Science) and Executive MBA (Master in Business Administration).

Duties of this data architect involved designing, developing, and implementing BI solutions using Oracle’s OBIEE suite of products to support the company’s reporting, analysis, and visualization requirements. In addition to designing and developing OBIEE metadata and dashboards based on user requirements, part of the job was managing Salesforce.com CRM application by formulating and executing approach for solution implementation within the CRM (Salesforce.com) application platform, including application configuration, user setup and familiarization, workflow setup, data conversion/ validation, configuration of reporting and user dashboards. Performing logical data modeling, physical data modeling (including reverse engineering) was done, along with maintaining the data dictionary using Erwin.

While in another job, the professional was involved with product development using Hadoop, Hive, HDFS, Sqoop, Impala, MySQL & Tableau. Other tasks were researching, recommending, and implementing enhanced technologies, as well as helping teams in the design, planning and governance of implementing projects of any kind. In a financial services firm, tasks were designing, constructing, modifying, integrating, implementing and testing event-based data models and database management systems in OLAP system. Technical requirements were defined for the data warehouse and recommended/selected data warehouse technologies (e.g., ETL, DBMS, Data Quality, BI).

Does a data architect who is knowledgeable in JD Edwards BI, Oracle and PeopleSoft, with experience in financial services, IT and software industries pique your interest? Technical competencies involve JD Edwards, HP UNIX, PL/SQL, Oracle, C, C++, UNIX Shell Programming, Perl, ERwin, PeopleSoft and more. Educational background includes a Degree in Medical Technology. This specialist is a Medical Laboratory Technician.

Relevant tasks encompassed analyzing the JD Edwards source system to understand source data/JD Edwards table structure, along with having a deeper understanding of business rules and data integration checks. Requirements gathering sessions with business users and sponsors were attended to understand/document business requirements/goals of the project. In addition, the conceptual model for the EDW (Enterprise Data Warehouse) was created and reviewed with business users.

Other duties involved identifying various facts/dimensions from the source system/business requirements to be used for the data warehouse, in addition to creating the dimensional logical model with approximately 10 facts, and 30 dimensions with 500 attributes using ER Studio. Implementing the slowly changing dimension scheme (type II) for most of the dimensions and implementing the standard naming conventions for the fact/dimension entities/attributes of a logical/physical model were also handled. This specialist reviewed the logical model with business users, ETL team, DBA’s and the testing team to provide information about the data model/business requirements.

Does a data architect who performed all data modeling and physical database definitions with skills in Sage 300/Timberline, Oracle and Informatica as well as work background in telecommunications, food processing and professional services industries, fit in your organization? Technical skills encompass Sage 300/Timberline, Microsoft SQL Server, Oracle, Sybase System, IBM DB2, ERwin, ER/Studio, RDA, Informatica, Toad, ProClarity, MicroStrategy, Microsoft Office Suite and ETL. Educational attainment includes BS Computer Science with Minor in Economics. This specialist is a Certified Project Management Professional.

Duties in a telecommunications company covered managing SharePoint application and BI solutions, as well as handling the client’s technical team and deliverable schedule. Reporting solutions were developed for finance, sales and operations. Responsibilities covered business analysis, Scrum sessions and rollout of a sales proposal tracking system, capital and revenue forecasting solution, SharePoint workflow site, Operations project management solution and developing reports and analysis solutions using Microsoft BI stack with data sourced from Sage Timberline and SpatialNet systems. In addition, database structures were developed in MS SQL Server and Analysis Services, reports using MS SQL Reporting Services, ProClarity and Excel Services. Dashboards were built using PerformancePoint Server and deployed under MS SharePoint.

As a data architect for a professional services company, a task involved working with business SMEs to define data requirements. Some of the duties were performing all data modeling and physical database definitions as well as providing ongoing consultation and guidance to ETL, reporting and application development teams. Additional responsibilities involved developing MS SQL Server 2008/2012 and utilizing ERwin for data modeling and architecture documentation.

How can your organization gain an advantage with the help of a data engineer who is skilled in Salesforce Lightning, Azure DevOps and Oracle with work background in a health network? Technical skills cover Salesforce CRM, Salesforce Lightning, Azure DevOps, Oracle, SQL Server, Azure Cosmos DB, HTML, CSS, JavaScript and Python. Educational attainment includes MS in Management Information Systems and B. Tech in Information Technology.

While working for a health network, one of the main functions of this data engineer involved creating a reporting framework to transform JSON data from Mongo DB to a Power BI reportable format using Azure Data Factory pipelines. This individual built and maintained scalable automated reports and dashboards in Power BI that communicated the status of incoming data to business leaders. Key alerts were integrated from reports to Slack channels to notify issues in a timely manner. Standardizing metrics across the organization and establishing KPIs that reported progress/ performance of a participant were some of the duties.

Notable tasks included creating ETL workflows to extract and transform data from multiple incompatible data sources (JSON, CSV, XML) and storing them in an SQL Data Warehouse for analyzing cost efficient programs and improving decision-making. Responsibilities consisted of designing and developing APIs using Azure API management to connect the web interface to the SQL Server backend tables in real time to request data. Accomplishments in another position covered reducing the lead time by 75% replacing a manual error detection system, along with implementing multiple views, procedures and user defined functions to consume raw data files into SQL Server database tables for preprocessing and cleansing incoming data.