Sukhdevsinh Dhummad

Experience

• 

  ProcessMAP

  Jul 2006 - Nov 2013

  Lead Data Engineer and Application Development

  Collaborated with business teams to gather requirements, developed data models for 50+ databases, and created system mapping reports for data relationships.Developed and optimized 1000+ database objects, including tables, stored procedures, views, indexes, user-defined functions, linked servers and triggers.Improved query performance by double digits through index optimization and query / code refactoring. Enhanced the performance of SSIS packages, reducing data processing time from hours to minutes.Developed multiple data pipelines to transfer data across the modules within the system. Additionally, built data pipelines using SSIS to create Data marts and a Data warehouse from the OLTP system.Developed 10+ standard templates for customers to provide their data. Created 10+ generic SSIS packages to migrate customer data from their existing systems to ours. Successfully migrated data for 40+ multinational companies, consisting of millions of rows.Created and deployed custom SSRS and Crystal Reports to meet customers' compliance needs.Developed templates for technical and functional specification documents. Created code review best practice documents.Led a diverse team of 10, successfully delivering 30+ projects on time.Led requirement gathering and impact analysis for almost all enhancements, working closely with stakeholders to ensure that business objectives are met.Conducted thorough test case reviews. Collaborated with the testing team to create 1,000+ scenarios and test cases for multiple modules.Ensured 100% of issues and defects were addressed. Actively collaborated with developers and testers to prioritize issues based on severity.Provided functional and technical consultation to 10+ internal teams, leading training sessions that significantly improved team productivity. Show less

• 

  FactSet

  Dec 2013 - Mar 2015

  Lead Data Engineer - CCS DB Unit

  Developed and maintained fi nancial data feeds, ensuring accurate and timely delivery of critical data to clients.Collaborated with cross-functional teams to gather requirements, analyze data flows, and implement solutions that improved data accuracy and accessibility.Conducted performance tuning and optimization of SSIS packages, resulting in improved data processing times and resource utilization.Upgraded approximately 900 DTS packages to SSIS, enhancing performance and scalability of data integration processes within the organization. Developed the best practices upgrading the packages to ensure minimal impact on existing processes.Contributed to the development of an in-house orchestration tool to configure and manage over 2,000+ SSIS data pipelines, streamlining data workflows and improving efficiency.Participated in on-call rotation, providing support for production issues and ensuring minimal downtime for critical financial applications.Conducted basic T-SQL programming workshops and over 100+ people participated. Show less

• 

  Publishers Clearing House

  Apr 2015 - now

  Systems Architect - Enterprise Data Development

  Created and maintained comprehensive data architecture blueprints, including data models, standards, and guidelines.Designed, developed, and refactored the database schema, ensuring optimal performance and maintainability. Developed over 300 stored procedures and 500+ overall database objects to streamline operations and enhance functionality. Developed and implemented ETL pipelines using SSIS as well as Google Dataforms managing the integration of close to 1 TB of data across billions of rows.Managed integration for approximately 30 different systems, including Oracle, DB2, and Filemaker Pro, ensuring seamless data flow across diverse platforms. The project supports over 50 APIs for enhanced functionality and data exchange.Implemented complex business logic in database procedures. Collaborated with stakeholders to define system enhancements, acting as a technical lead with functional knowledge.Leveraging Google BigQuery and Google Dataform to design, develop, and optimize objects that support large-scale data analysis. This includes writing complex SQL queries, creating views and tables to aggregate and analyze billions of rows of data.Developed comprehensive fraud reporting processes and created nearly 10 Looker dashboards.Developed proprietary code for conducting drawings and winner fulfillment processes adhering to compliance guidelines.Led the development of the product roadmap, aligning database initiatives with business objectives and ensuring timely project delivery. Conducted various PoC and technology evaluations for tools to enhance data processing and reporting capabilities, driving innovation within the team.Generated over 500 ad hoc reports in Excel and other formats using T-SQL, providing critical insights for decision-making and supporting various business units with data-driven analysis. Show less