Omkar Mahipati Deshpande

Designed enterprise-grade Data Vault 2.0 models for a Fortune 100 client in the manufacturing sector.

Collaborated with client SMEs and vendor teams to create scalable data solutions.

• Developed comprehensive conceptual, logical, and physical models using Erwin Data Modeler.
• Produced source-to-target mapping documentation detailing transformation logic and business rules.
• Conducted data profiling and gap analysis to identify quality issues in legacy systems.
• Facilitated requirement gathering and model validation with business and technical stakeholders.
• Resolved integration gaps by bridging disparate purchase order data formats.
• Generated DDL scripts for Snowflake to support model integration with development teams.

• Oversaw team of 5 engineers, providing mentorship to enhance project delivery and collaboration.
• Designed and implemented core Snowflake tables, aligning with business requirements and data architecture.
• Optimized data models and schemas in Snowflake to enhance query performance and scalability.
• Utilized Erwin Data Modeler to develop data models, ensuring accurate entity-relationship mapping.
• Collaborated with stakeholders to gather requirements and translate them into effective data solutions.
• Ensured seamless integration of Snowflake tables within overall data pipeline processes.
• Migrated data from multiple sources to Azure DataLake using Nifi CIF framework.
• Created daily scheduled jobs to transfer millions of records to Azure DataLake in ADLS Gen2 formats.

• Automated daily and monthly corporate report generation, providing essential references for business analysis.
• Resolved synchronization issues between the Salesforce application and the persistent database to support sales operations.
• Developed and unit-tested Ab Initio graphs using GDE for efficient ETL processes from source to target.
• Applied business logic using various Ab Initio components to maintain SCD2 dimensional tables effectively.
• Configured DBC files in the Input Table component to extract internal and external data from multiple databases.
• Executed Ab Initio graphs through wrapper scripts, ensuring accurate data loading into the warehouse, with count verification.
• Mapped metadata from legacy systems to target fields while creating DMLs and complex transformations in Ab Initio.
• Enhanced the existing codebase to align with updated requirements, following coding standards and best practices..

Facilitated reliable synchronization of data between the Salesforce application and the persistent database.

Resolved synchronization issues for the sales team, ensuring seamless data transfer.

Modified and enhanced the existing codebase to meet evolving business requirements.

Analyzed business requirements to implement functional changes in applications.

• Ensured proper integration of the application with Salesforce and database systems.
• Adhered to best practices and coding standards for high-quality code delivery.
• Investigated and troubleshot issues to maintain data consistency across platforms.