Below are the 3 Database Administrators, 4 Data Engineers & 4 Business Intelligence Developers with MS Dynamics CRM & other systems experience. The Thor Group® provides MS Dynamics CRM database administrators, data engineers, business intelligence developers, software engineers, developers, systems analysts and solutions architects on a consulting, contracting or direct hire basis.

How can your organization gain an advantage with the help of a senior database administrator who is skilled in MS Dynamics CRM, Azure VM, Azure Cloud, Azure AD Network and Azure VNet, with work background in marketing, IT and financial services industries? Technical skills cover MS Dynamics CRM, Azure VM, Azure Cloud, Azure AD Network, Azure VNet, ASP, C# and SQL Server. Educational attainment includes B.S. in Computer Information Systems.

While working for a marketing company, one of the main functions of this senior database administrator involved completing premise servers to Azure VM, Azure cloud, Azure AD network and Azure VNet. Support was provided in handling multiple database applications written in ASP and C#. Designing Restful pool of data from Point of Sale to SQL Server, along with designing SSRS reports and SSIS ETL were some of the duties. Other roles covered maintaining the SQL Server Azure instance, SQL Server and MySQL, employing transaction log shipping and replication, along with using Microsoft Dynamics CRM.

Notable tasks in other jobs included developing methodology for analyzing transaction system real-time financial transaction processor using partitioning strategy, in addition to upgrading test, QA and production SQL Servers. Responsibilities consisted of designing DR, designing SSRS reports and SSIS ETL, along with maintaining SQL Server Azure VM. Functions involved designing the C# application for DevOps to run SQL Server jobs in .NET 4.5, doing SharePoint server administration and providing assistance with HA as well as data replication of multiple SQL Servers. Work was provided within Team Foundation (GIT) with Agile method.

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.

Could your organization use a database administrator who is proficient in MS Dynamics CRM and Salesforce, as well as experienced in the engineering industry? Technical proficiencies cover MS Dynamics CRM, Salesforce, Pivot Table, Vlookup and SQL. Educational background includes Master’s in Information System Management (MISM); Bachelor in Technical Management (specialization in IT); and AAS degree in Marketing. This individual is a Salesforce Certified Administrator.

Some impact contributions of this database administrator included managing and administering the company’s homegrown database system in Lotus Notes platform. This individual carried out improvements, incorporated changes, prepared and analyzed various reports for the corporate management or sales teams as required on weekly, monthly, quarterly, and yearly basis. Key roles involved maintaining the integrity, accuracy, consistency, and security of the databases, while also carrying out all database administrator tasks. The sales team was assisted in marketing and sales promotion and process. Duties involved preparing and compiling prequalification documents as well as sales/ marketing presentations. The proposal team was assisted in the preparation of proposals and pre and post tender as well as contract documentation.

Skills involved serving as a Salesforce.com administrator and data integrity manager (DIM) and taking care of the accuracy, consistency, and security of the databases systems in Salesforce.com as well as Microsoft Dynamics CRM platforms. The job consisted of preparing and analyzing various reports/ dashboards for corporate management or sales leadership as required on weekly, monthly, quarterly and yearly basis. Areas of expertise include helping organizations maximize their CRM System application adoption, integration with existing sales systems to troubleshoot, configure and update as needed, to meet the specific business requirements.

Could your organization use a data engineer who is proficient in MS Dynamics CRM, MS SQL Server and MongoDB, as well as experienced in transportation, recreation and technology industries? Technical proficiencies cover MS Dynamics CRM, MS SQL Server, MongoDB, T-SQL, Cloud AWS, Agile and Jira. Educational background includes Master’s in Electrical and Computer Engineering. This individual is a Microsoft Certified Solutions Associate, Amazon Web Services Certified Developer (Associate) and Certified MongoDB Developer.

Some impact contributions of this data engineer included helping in planning and developing data migration or performance tuning to achieve cost efficiency/ effectiveness of the system. This individual extensively worked with SSIS ETL Tool in creating and designing mappings using various transformations tasks like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column. Key roles involved utilizing business rules for data profiling, data analyzing and cleansing, as well as creating ETL procedures to transfer data from legacy sources to staging area and from staging area to data warehouse. Expertise in data migration from SQL on Perm to Cloud AWS was applied.

Skills involved applying hands on experience in building apps using C# which could extract the PDF report from tableau server and sending an e-mail to restricted email group. Functions covered building the data source for Tableau Reports based on requirement, along with attending practical sessions on NoSQL, Hive, Scala and Spark. Other competencies included database design, programming, development and implementation of client-server applications and database systems using MS SQL Server 2014/2012, Microsoft Dynamics CRM, MongoDB and expertise in moving data into S3 file storage.

Would a data engineer who is skilled in MS Dynamics CRM, MS Dynamics Great Plains, PeopleSoft and SAP, as well as familiar in IT services and business services industries help your organization achieve greater success? Technical specializations cover MS Dynamics CRM, MS Dynamics Great Plains, PeopleSoft, SAP, Salesforce, SQL Server, Oracle and Access. Educational attainment includes Bachelor of Science in Financial Management & Business Administration (minor in International Business).

Making a positive difference with acting as one of 10 integration engineers who managed over 400 vendors by updating and organizing clients into manageable tiers was one of the key focuses of this data engineer. Responsibilities covered resting, loading and processing files on a team of 5 integration engineers in Microsoft SQL Server including validation. Tasks consisted of identifying, evaluating and executing test requirements for test cases, as well as designing test coverage plans. Holding and facilitating test plan/case reviews with cross-functional team members were also carried out. Duties covered coordinating internal development and operation teams to define data requirements to support analysis needs.

Notable tasks included testing, designing and adding SharePoint tickets in Axosoft, in addition to analyzing tickets in Smartsheet. This individual executed completion of live dates through maintenance reporting which consisted of error reporting, billing, invoicing, account structuring, EDI implementation and data reporting. Functions involved executing the completion of reporting instructions through Microsoft Outlook for sales automation directors, sales reps and sales analyst through following and SAP Business Objects through Excel (XL Connector) within 45 minutes for completion.

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.

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 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).

What can a BI developer with specializations in MS Dynamics CRM, Oracle and SQL Server, as well as work background in banking, business services and nonprofit industries bring to your organization? Technical specializations involve MS Dynamics CRM, Oracle, SQL Server, Query Analyzer, SSIS, SSAS, SSRS, SQL Profiler and Query Optimizer. Educational background includes BA Electrical & Computer Engineering. This individual is a MCSD (Microsoft Certified Solution Developer) with certifications in ITIL-RCV, ITIL-OSA and ITIL-Foundation.

Working with areas such as understanding the user requirements, developing ETLs using SQL Server Integration Services and getting involved in technical specification documentation were some of the skills brought to the table by this BI developer. Duties covered developing SQL SSIS packages development and unit testing, as well as deploying SSIS packages with SQL Server data tools. This individual was responsible for monitoring monthly scheduled jobs, checking status mails and taking course of actions, if required. Implementing custom logging in ETLs was completed using SSIS. Skills used involved SQL Server and designing/deploying SSRS custom report/dashboard, specifically with MS Dynamics CRM entities.

Part of the responsibilities consisted of creating highly complex SSIS packages using various data transformations like conditional splitting, for each loop, multi cast, data type conversion, script components and error handling. Tasks involved writing and integrating stored procedures to generate the special reports per client’s need. An additional function consisted of creating tabular reports, matrix reports, list/ chart reports, parameterized reports, sub reports, drill down reports as well as interactive reports per business requirements in time restricted environment. Data sets were generated for analysis teams for their analysis input as per the business requirement.

Could the future success of your organization be helped by this BI developer with MS Dynamics CRM, ProClarity, SharePoint and Access proficiencies, as well as work experience in manufacturing, business services and logistics industries? Technical competencies involve MS Dynamics CRM, ProClarity, SharePoint, Access, SSRS, Power BI and SSAS Multidimensional and Tabular Models. Educational attainment includes Bachelor’s degree with a minor in Business Administration.

Important contributions of this BI developer included spearheading all operational reporting processes including back office, ad hoc and transactional, as well as fulfilling all requests from leadership staff and creating the report content. Tasks covered managing the reporting environment for ProClarity, Performance Point, SharePoint, Access, SSRS, Power BI, SSAS Multidimensional & Tabular models, in addition to transitioning from previous reporting system through coordinated setup procedures to implement new reporting environments. Aside from updating the new company logos/themes, all reports were tested, including SRRS, Power BI and MS Dynamics CRM.

Part of the key roles also involved serving as business Subject Matter Expert for the development of new data warehouse, data marts, and tabular models for Dynamics CRM/ERP System. Developing and managing KPI reporting and dashboards in collaboration with sales, finance, and operations were included in the list of duties. In addition, this specialist validated SSAS models and warehouse data after implementation in new SQL environment. Achievements involved successfully creating the new Power BI reporting environment to replace the deprecated ProClarity/Performance Point and QlikView reporting, in addition to helping to streamline processes and improving efficiency measures.

Does a senior BI developer with MS Dynamics CRM, SQL Server and Oracle skills, as well as experienced in media, retail and manufacturing industries pique your interest? Technical knowledge involves MS Dynamics CRM, SQL Server, Oracle, T-SQL, Visual Basic, Python and SQL Profiler. Educational attainment includes Master of Engineering in Wireless Communication, as well as Bachelor of Engineering in Electronics and Communication. This individual is pursuing AWS Certified Solution Architect Associate and AWS Certified Developer Associate certifications.

Major responsibilities of this senior BI developer included leading the offshore team to deliver enhancements and new development on linear ad sales, as well as carrying out daily interaction with business analysts and project managers for production issues, new enhancement, QA and delivering in production. Experience was applied in pragmatic works components like Task Factory Secured FTP Task, TF Email Task (to download email or process attachments), BIxPress for SSIS Auditing framework, Error Logging, Package execution monitor, and DocxPress to generate database/ ETL documentations for tracking changes. Experience on Microsoft Dynamics CRM connections was applied using 3rd party tool named KingswaySoft for integration between BI Data and CRM Dynamics portal.

The job covered working with the Oracle team to understand and optimize query, using them as a source and loading data to SQL destinations. Functions consisted of working on production SSIS packages to update dynamic connection for log/error files and working on Tableau Reporting Services to generate business reports by directly using SSAS cube and using data extract method. An additional function involved handling the master data management system for different advertisers and agency mapping from different sources to map correctly.