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

Would hiring a data architect with work experience in a university medical center and a healthcare services provider help meet the needs of your organization? Educational attainment is composed of BS in Engineering and Graduate Work in Master of Business Administration. Professional certifications include Licensed Professional Engineer (PE) and TOGAF architecture certification. Expertise in ETL and modeling tools were Oracle Data Architect, TOAD Data Modeler, SSAS, SSIS, Informatica PowerCenter, Erwin and IBM Data Stage. Other applications skills consist of Oracle E-Business Suite, JD Edwards, PeopleSoft, SAP and multiple EMRs as well as popular cloud-based engines.

Acting as a data architecture consultant in a university medical center, has built an Oracle Data Warehouse using OBIEE toolset, transforming the data from twelve departments into an industry leading business intelligence system and management focused decision support system for the 2000 bed, 1200 provider hospital. Some of the tasks were managing transformation of data, building the star schemas and dimensions tables for the new system, as well as developing reports and user interfaces.

While working for a healthcare system as a data architect, was responsible for the delivery of a clinical and financial warehouse taking data from five internal applications including financial data, clinical data, and insurance claim data aside from analyzing it for decision support metrics. Other duties were developing project plans, tracking project, and meeting delivery timelines. This professional has designed data and table standards, conformed and normalized data, collected data from outside entities and transformed the data for use by different departments. Part of the job was to develop logical, physical, and relational models from business requirements as well as design the source and subject area marts using SQL, integration and analytical services, or scripting if necessary.

What opportunities can hiring a senior database architect who worked in the professional services and IT industries offer your business? This management information security graduate’s computer proficiency covers Sage, SQL Server, Oracle, MySQL, HP Vertica, SSIS, Pentaho Data Integration, Jaspersoft ETL and other applications. Expertise is also shown in Big Data analytics, business intelligence and data warehousing. The individual also has a master’s degree in computer science.

In support of an IT company, this senior database architect was hands-on database architect working on transactional databases as well as large scale data warehousing, enterprise reporting and business analytics systems. The job called for designing the schema for the data warehouse system using SQL Server, as well as the ETL processes for the data warehouses. This architect was concerned with performance tuning MySQL databases for the SaaS product and the SQL Server databases for the data warehouse system. Enterprise reporting for analytics system was performed using SQL Server BI suite and SAP Business Objects. Other key concerns included all aspects of data management, such as schema management, capacity planning, data retention policy, security, data quality and governance.

In a technology solutions firm, another job required serving as hands-on data architect working on both OLTP and OLAP systems of network security products. Data analytics was performed using R and Apache Spark Machine Learning libraries. The work required doing Vertica database design and performance tuning. Troubleshooting database system issues were also performed.

The future success of your organization could be helped by this data architect who is proficient in SAP Supply Chain, with experience in a general hospital. Technical competencies involve SAP Supply Chain, SAP BusinessObjects, Crystal Reports, Design Studio, Qlikview, Tableau, Oracle, UNIX, Crystal Xcelsius and more.

Important contributions included gathering requirements from senior management, defining the scope of the project for executive operations and ensuring quality dashboards. Apart from improving reporting analytics, the job entailed designing, developing and implementing strategic solutions. ETL was used in transferring the data from different sources to Epic’s Enterprise Data Warehouse Cogito for all reporting needs. Other functions encompassed installing, administering and upgrading versions of BO in both desktop and server products.

Key roles encompassed using SAP Supply Chain, creating master universe using IDT, writing ad hoc reports and architecting the quality and patient safety dashboards using Query Browser connectivity. Supporting the design and development of 6 level drilldown dashboards using heavy excel functions, dynamic visibility and flash variables, in addition to converting the existing scorecard and administrative Universe from .UNV to .UNX were part of the job descriptions.

Is recruiting a senior data analyst with background in professional services, communications and energy industries a good move for your organization? Technical skills involve the use of JD Edwards, SAP, Great Plains, VB.NET, MS SharePoint, Crystal Reports, Cognos Report Studio and SQL Server 2000 environment. The individual has proficiency with data presentation and reporting, as well as completing special projects involving complex data from multiple sources through extensive use of pivot tables/ graphs, solver and statistical analysis/modeling. Educational background includes Bachelor of Science in Business Administration with an emphasis in Mathematics.

This senior data analyst was responsible for maintaining the quality and integrity of many end-user MS Access databases that support the organization. Other concerns were building and operationalizing processes to ensure timely data updates plus data accuracy in line with project scope/ recommendations. Change management activities were supported & executed around testing, implementation, and training. Tasks also involved maintaining mapping files, as well as uploading/ downloading data and verifying results. Part of the job was actively participating as a project team member to ensure operational readiness of new system deployments and system enhancements.

Responsibilities in another job were for business financial processes, such as consolidating multiple financial reporting presentations monthly utilizing MS Excel knowledge. The individual served as DBA/developer of MS Access database of continuous improvement data; MS Excel reporting interface was created utilizing pivot tables. Tools used included SAP R/3, SAP BW/BCS, SAP BCP, and JD Edwards. Variance commentary of detailed financial budget and forecast reports was also created.

Could your organization use a data analyst / engineer who is proficient in MS Dynamics 365 CRM, Power BI, JavaScript and Report Builder, as well as experienced in government, aerospace and business services industries? Technical proficiencies cover MS Dynamics 365 CRM, Power BI, JavaScript, Report Builder, JSON, ASP.NET, ADO.NET and Visual Studio. Educational attainment includes Associate of Science in Computer Programming. This individual is a Certified Scrum Master with additional training in MS Dynamics 365 CRM (MB 210, 220 and 230).

Primary tasks of this data analyst included interviewing solution providers and analyzing proposals in selecting an appropriate provider to create a department wide project in creating a central identity management portal for the departments’ 19K users. Creating and documenting all requirements while working closely with the selected vendor’s development team were also handled. Key roles covered communicating adjustments to constantly changing structures, processes and requirements to the department heads or directors, as well as leading functional reviews, user acceptance testing and all data transformations. One of the duties involved leading the development and implementation of a Microsoft Dynamics CRM student relationship module.

Part of the contributions involved developing many features by creating custom entities, workflows, queues and reports, automating the scholarship processing based on student qualifications, award ranking and scholarship budgets thus significantly reducing the workload to process the thousands of scholarship applications annually. Automating the scholarship application process for students was done by providing self-service features such as account creation, enrollment registration and automated correspondence. This individual created web services providing integration and synchronization with the departments’ scholarship entitlement database and public facing web portal.

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 SAP CRM data analyst with vast IT experience in SAP CRM and ABAP fit in your organization? Core competencies include good CRM functional knowledge in business partner processing, alerts and rule policies, technical master data, meter orders, meter readings, billing, supply scenarios, invoicing, security deposits, payment plans and more.

While employed in an energy company, some of the responsibilities included analysis, coding and testing of various processes in CRM web UI as per client requirements. Part of the job was to work on CRM middleware and data replication between CRM and ECC systems. Some of the duties carried out were developing an automation script to delete bad TMD data like ‘Connection Objects’ from CRM and replicate them again from ECC to CRM system through middleware. This initiative was one of the critical tasks which saved business hours and made processes of contract replication smoother.

Serving in a retail company, one main function was to develop custom component and add views like table views to display data coming from vendor’s interface. One requirement was to display important information related to shipments of goods in CRM 7 for quick access to information. Also, the development of a view to display list of billing documents from ECC was completed. This was achieved by pulling data from ECC using RFCs.

Would it be beneficial for your organization to employ a data management analyst with work experience in education and financial services industries? Educational attainment involves Bachelor of Technology in Electronics & Communication Engineering as well as Master of Science in Management Information Systems – Major in Data Analytics. Technical skills include NetSuite, Oracle, Teradata, SQL Server, MySQL, DB2 and Tableau Server.

Serving in a financial services company as a data management analyst , has acted as a liaison between client area and technical organization by planning, conducting, and performing the analysis of highly complex business problems to be solved with automated systems. This professional has worked with user groups to provide training, resolve questions, assess user needs, and recommend changes. Also has performed data profiling and worked with source systems to understand data, as well as prepared deliverables including Functional Solution Design and Source to Target Mapping according to high-level design specifications and design patterns. Key achievements were analyzing and resolving production defects, as well as using excellent quantitative, analytical, and problem-solving skills.

As a data management analyst-business intelligence, has conducted quality check on data, identifying outliers, normality, and standardizing the data. Moreover, has created tables, stored procedures, views, triggers, and user-defined functions. Furthermore, has generated Risk Stratification reports using Tableau to manage high cost treatment plans, as well as improved the quality by highlighting the risk summary and impact ability by chronic conditions. Key achievements were initiating annual savings of over $150K by decreasing dependency on excessive NetSuite licenses through the creation of Income Statement Dashboards using Tableau-based data extraction from the NetSuite database.

Could the future success of your organization be helped by this sr. data modeler/analyst with work experience in a university medical center? Educational attainment is composed of Bachelor of Technology in Computer Science. Skills in databases include Oracle (11g, 10g/9i/8i/7.x), Teradata, SQL Server (2005/2008), Sybase, MySQL, Microsoft Access and DB2.

Contributed to the organization’s success by performing ETL design and implementation such as data extraction, transformation and loading (using Oracle Warehousing Builder, SQL and PL/SQL). Serving in a university medical center as a sr. data modeler/analyst, was involved in capturing data lineage, table and column data definitions, valid values and other necessary information in the data models. Duties consisted of documenting all the information of application and saving them for future reference, as well as identifying the facts and dimensions including grain of the fact; aggregate tables, etc. for Dimensional Models.

Supported organizational goals and objectives by creating logical and physical model database and schema in Oracle. Acting as a data modeler/analyst in a healthcare services provider, has reversed engineering existing database to conduct source data analysis to identify the relationship between data sources. Some of the tasks were working with DBA to finalize the DDLs, as well as working on rationalizing the requirements across multiple product lines. Part of the job was to carry out brain storming sessions with application developers and DBAs to discuss about various de-normalization, partitioning and indexing schemes for physical model.

Would your organization benefit from hiring a data analytics specialist with expertise in directing program management of data center migrations and enterprise implementations using data analytics, PeopleSoft SCM, Financials, HR/Payroll and Kronos? Technological knowledge encompasses PeopleSoft ERP 9.0, BusinessObjects, Canadian Payroll, Advanced Query, CITRIX, CMMI and more.

While employed in a healthcare organization as a PMO program director of data analytics, responsibilities included directing the program/project management of multiple hospital site ERP conversions to PeopleSoft HCM, SCM and Finance. Other duties were integrations and upgrades of PeopleSoft HCM, SCM, and Finance 7.5 – 9.1 as well enterprise deployment of Kronos Workforce Management 6.3 to 45K+ employees. Furthermore, the management of large implementation teams of 30+ for data center migrations & cloud services remote hosting was carried out.

While working for a retail company as a global senior portfolio manager, managing high profile projects including Hyperion BI, ERP Lawson HR/Payroll & Supply Chain Management upgrade, Kronos Workforce Management Pilot and Global Treasury Work Station were primary tasks completed. Building teams, designing portfolio structures and innovating project management processes and templates were carried out. Moreover, this manager led a 10 plus- member team of project managers, business analysts and onsite/offshore developers.

Would your organization benefit from a data analytics specialist who is experienced in healthcare solutions, insurance, as well as manufacturing and computer hardware industries, with proficiency in Lawson ERP? Technical skills cover Lawson ERP, Salesforce, Dynamo, Waterfall, Agile/Scrum, JIRA, Load Runner, Informatica, DataStage, SSIS, SAP BusinessObjects and ETL tools.

This individual’s primary functions consisted of establishing effective practices/behaviors in effective data structures to drive Big Data, Data Warehouse, Data Analytics and Business Intelligence strategies, as well as developing the conceptual/logical data models for all investment systems. Designing and developing an enterprise data warehouse using Microsoft BI Stack to provide the organization the ability to handle healthcare administrative data were also skills brought to the table.

Other designated duties included providing dynamic access to inpatient/outpatient diagnoses, comorbidity, utilization, formulary, outcomes, complications, financial and competitor metrics going beyond typical trend analysis/benchmarking within a hospital. The position also covered Lawson analysis, as well as analyzing specific membership base, employee population, national landscape or any other confluence of target audience considerations.