Below are the 2 Data Analysts, 4 Data Architects & 4 Data Engineers with strong technical skills and multiple CRM systems expertise. The Thor Group® provides data analysts, data engineers & data architects with your CRM systems & industry experience on a consulting, contracting or direct hire basis.

How can a data analyst who worked in IT services and manufacturing industries help your organization? Educational background is composed of Bachelor of Science (BS) in Computer Information Systems and Master of Business Administration (MBA) with concentration in Information Systems. Software applications skills include Microsoft Dynamics CRM, SQL Server, Bugzilla, Sybase, SQL Anywhere, VMware, Oracle SQL Developer, SQL, XML, HTML, Java, COBOL and Visual Basic.

Working with challenging issues such as coordinating and communicating with business analysts, solution architects, developers and stakeholders (Medicaid and CHIP) on to gather, maintain and analyze information needs and elicit data requirements were part of this specialist’s work experience. As a data analyst in an IT service management company, evaluated information gathered from multiple sources, reconciled conflicts and distinguished between data requests and underlying data needs. Part of the job was to develop and execute SQL queries to analyze and validate data as it flows through various stages of the system. Moreover, determined root cause of data inconsistencies and identify potential solutions.

With a “can do approach” in the area of developing data documentation such as data requirements documents (DRD), source to target data mapping documents, data dictionaries, data flow diagrams, etc. have been career objectives. This specialist utilized Microsoft Team Foundation Server (TFS) to track and manage work items, tasks and data requirements. Furthermore, followed the principles of Scrum working in an AGILE environment, as well as participated in daily stand-up, refinement, sprint review, planning and retrospective meetings. Tracking progress and reviewing project tasks were done to make sure certain deadlines were met appropriately.

Would it be beneficial for your organization to employ a sales data analyst with experience working in computer software and insurance industries? Educational attainment is composed of Associate of Applied Science in Computer Information Systems. Professional certifications involve Microsoft Office Specialist Excel 2013 Certification. Skills summary consist of Salesforce.com, HTML, XML and CSS. Other experiences involve Salesforce.com dashboard, workflow, form design, reports, as well as Microsoft Dynamics CRM dashboards, workflow, form design, and reports.

Serving in a computer software company as a sales data analyst, worked as the Salesforce administrator for outside and inside sales, technical support, and maintenance sales teams. Part of the job was to create all dashboards, queries, data imports and exports, report creation or testing if report was done outside Salesforce. Data imports included large quantities of data. When a company was acquired, data had to be cleaned and put into proper format prior to importing. Additionally, created a renewal sales team of 12 reps exceeding sales goals for 9 years in a row, as well as created the process, policies, and hired team members wherein 9 reps were in the same office, 2 reps in France and 2 reps in the UK.

In an insurance company, this specialist determined mapping level and created XML code for transforming data to target system. Furthermore, provided data analysis on information provided by product managers and provided it in format for developers to work with.

Would hiring an enterprise data architect with experience working in retail, biotech/pharmaceutical and banking industries help meet the needs of your organization? Software skills involve Salesforce.com, Teradata, Sybase, Oracle RDBMS, Netezza, PeopleSoft, SQL Server, WebLogic, Informatica and SAP.

In a retail company, acted as Data Architect Subject Matter expert (SME) and mentored as well as assisted technical staff in data governance and best practices for data modeling; ODS, Data Warehouse, Data Lakes, Business Intelligence and analytics, including database design and optimization and related activities. This professional created, implemented and tested procedures for backing up and recovering databases. Also, designed, created and implemented a Data Lake infrastructure for the Consumer Research initiative for a company using MemSql for Cloud data ingestion and integration. Moreover, worked with other architects to design data integration solution using Salesforce data from the Cloud with the traditional on-premise data stores using Jason, XML Schema and XML standards.

While working for a biotech & pharmaceutical company as an enterprise data architect, worked with other architects to design data integration solution using Salesforce data from the Cloud with the traditional on-premise data stores. Some of the tasks were developing and implementing test cases as required to accomplish the data transformation and conversion process. In addition, reviewed data warehouse applications design, build, and test plans to ensure they meet the functional and technical design specifications using standards. Furthermore, designed and developed Big Data infrastructure/ technology platform strategy by bridging the gap between the requirements of the application as it conformed to the client’s reference architecture with both onshore and offshore teams.

Is impacting your organization with a data architect who worked in application software, telecommunications, and insurance industries a current business consideration? Educational attainment is composed of Bachelor in Artillery Science, Master in Engineering and PhD in Computer Science. Software skills involve NetSuite CRM, Salesforce, ETL architecture, Big Data, Host Analytics, Informatica Cloud, IMM, MDM, MicroStrategy, MS SQL, SFDC, BO, SSIS, Informatica, MDM, Power BI, SAS BI, AWS, and Java.

While employed in an application software company as a data architect, responsibilities were managing and supporting Informatica Cloud, Informatica Cloud Real Time, IMM and MDM in CRM Cloud applications including Salesforce, ETL architecture, Big Data, NetSuite, Host Analytics and reports. This professional led design and supported functional and technical cloud CRM Salesforce using Informatica Cloud, IMM and MDM. Additionally, utilized Java scripts to manage inbound/outbound files around development, testing, and runtime environments.

Part of the job as an enterprise data architect in a telecommunications company was to be responsible for maintaining and managing telecommunication wireless CRM service system, production ETL billing cycle database integrated environment and business reports. Also, architected and maintained wireless Enterprise Data Warehouse utilizing (Kimball) Bottom/Up approach. Moreover, maintained Telecommunication billing systems and created billing cycles descriptive and analytics reports. Furthermore, provided technical support to AMDOC Telecom management system and monitored data load and extracts.

What can a data architect with specializations in NetSuite CRM, Informatica, MySQL, ETL, BI and MS SQL, as well as work background in software, Internet and biotechnology industries bring to your organization? Technical specializations involve NetSuite CRM, Informatica, MySQL, ETL, BI, MS SQL, PL/SQL, T-SQL, Visual Basic, Java, EJB, C, C++, JSP and JavaScript. Educational attainment includes Computer Science.

Working with areas such as working with a small team in building company’s first data warehouse and BI platform, as well as architecting and implementing the BI platform using Tableau Report Server were some of the responsibilities of this data architect. Duties involved Tableau KPI Dashboard creation, architecting and implementing data warehouse ETL using SSIS, Informatica and Netezza. This individual was responsible for NetSuite Data Integration with the Data Warehouse and was responsible in setting up SSIS Servers, Tableau Servers and Informatica PowerCenter Servers. Managing ETL, BI reporting releases and support was carried out, along with designing and implementing the end-to-end process for CCDA and immunization Registry HL7 doc.

Functions in other jobs consisted of architecting, designing, developing/coding, operating, and maintaining in-house BI platform and its ETL that measured social influence of hundreds of millions of users and brand campaigns results. The job covered redesigning and building the company’s in-house BI platform using Microsoft technologies (SSIS, SSAS, MS SQL) and Tableau Report Server, along with integrating with existing MySQL databases. Tasks involved being part of knowledge management (KM) group, working with different R&D units of the company to unify data from different KM applications into a centralized data warehouse and enabling analytical reporting across all the data.

What opportunities can having a data architect who served IT, financial services and engineering industries give your organization? Technical expertise includes the use of Salesforce CRM and Oracle, as well as Pentaho, Business Objects WebI, Agile, Informatica, DB2, TeraData and SAP BW.

In a computer firm, this data architect was into developing Business Objects universes and reports. Gap analysis was performed between existing data and new data sources. Other duties included documenting strategy for data movement from data sources. Assistance was given to ETL developers, as required; volume test data was created. Part of the job was documenting source to target data mappings with business rules and transformation rules. Requirements were gathered and documented from source entities, process developers and data consumers. The individual developed data models: ERWin for Salesforce and CISCO, Embarcadero with NVIDIA. Project Plans were created, and contributions were given to existing plans.

Duties in another job involved transforming case management data and account data from current Case Management tool into Salesforce. The job called for developing functional specifications for all data migration objects which migrated from Case Management system into Salesforce. Use-case functional specifications were built for Case Management. Other tasks were training, coaching, and mentoring new data analysts, developers and QA analysts on source to target mapping documents. Additional functions were designing, developing, and maintaining a table used to store pick-list values for different objects, fields, and mappings. The individual designed migration strategy for Case Management data, as well as validated account data after loading into Salesforce. The job required participating with a team of data architects in the development of a canonical data model.

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.

Could the future success of your organization be helped by this senior data engineer with experience working in publishing and information services industries? Educational attainment is composed of BS in Physical Sciences and PG Diploma in Applied Statistics. Technology skills include Salesforce CRM, Oracle, Cloud Data Warehouse, MySQL, Netezza, Postgres, Cassandra, MongoDB and Kafka.

Contributed to the organization by successfully completing an automated data pipeline for research and book publication events of data. Serving in a publishing company as a Enterprise Advance Analytics Platform (EAAP) senior data engineer, strongly handled different types of data sources and moved data seamlessly to ODS (Operational Data Store) and EDW (enterprise data warehouse). This was an ELT type data pipeline.

Supported organizational goals and objectives by effectively developing and designing a marketing data enrich pipeline. Acting as a senior data engineer and pipeline architect, technologies used were Salesforce, ELT, Python, REST API, Snowflake Data warehouse, Docker, AWS, and SAP-HANA API. The purpose was to support the marketing team to enrich marketing data which enabled understanding of the future trends. This was an ETL type pipeline. As a lead data engineer (data ingestion and processing) in an information services company, designed, developed, tested and deployed fast data pipelines, as well as designed and implemented source event schema which was useful for data science teams to produce wealthy analytics and insights as outputs.

Could the future success of your organization be helped by this data engineer with experience working in financial services and banking industries? Educational attainment is composed of Bachelor of Science in Business Administration/Psychology. Professional certifications include A+ and MCP. Software knowledge consists of MS Dynamics CRM. Programming language skills include T- SQL, VBA, DAX, MDX, C#, R and Python. Expertise in DBMS involve SQL Server 2008, 2012, 2014, 2016, Azure SQL Database, MS Access and Oracle.

Contributed to the organization’s success by restructuring ETL of Wealth Management and Daily FCC file load and SFTP transfer to Terrapin. Serving in a financial services company as a data engineer, created SSIS package for Wealth Management Exchange Traded Funds data in Visual Studio 2017 that automated the import of Excel file source files into destination tables and emailed SSRS report via subscription to stakeholders. This professional used variables, script tasks in C#, and checkpoints in package. Moreover, created ACBS facility and loan portal in SSRS to compensate for lack of ACBS user licenses. Furthermore, created Data Warehouse using star schema approach, abstracted from Dynamics CRM, and used as the primary data source for SSAS Tabular Model.

Supported organizational goals and objectives by creating ACH transaction SSRS reports to relieve Treasury Management of manual ad-hoc BIC reporting. Part of the job was to design process to deliver historical daily deposit account data for Central Deposit Operations to use in audit scenarios. SSIS packages were created to load Data Warehouse, with bank account and pipeline data, on a daily basis.

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.