Vikas D. Email & Phone Number

Pune, Mh, In

Pune, Mh, In

Pune, Maharashtra, India

• Designing and implementing data integration solutions: Designed and developed data warehouses with star and snowflake schemas, incorporating Slowly Changing Dimensions (SCD) to track changes over time. This enabled enhanced reporting capabilities and improved data accuracy.• Integrated Heterogeneous Data Sources: Successfully integrated data from both cloud (Azure SQL Database, Azure Blob Storage) and on-premise sources (SQL Server, Oracle) using Azure Data Factory. Leveraged PySpark within Azure DataBricks for large-scale data processing, ensuring seamless data flow and unified views across diverse systems.• Developed Modular Integration Frameworks: Engineered reusable ETL frameworks using PySpark in Azure DataBricks, and Azure Data Factory by following modular, parameterized, and template-driven principles - reducing development time and improving data processing efficiency. These frameworks were critical in standardizing data ingestion processes across multiple pipelines.• Built Automated Data Reconciliation Frameworks: Created automated reconciliation frameworks using Azure Data Factory, Power BI, and SQL, significantly reducing data discrepancies and manual verification efforts. These frameworks were pivotal in ensuring data consistency and accuracy. They were essential in ensuring that regulatory reports were accurate, especially during audits, and led to a 25% reduction in discrepancies reported during quarterly reviews.• Designed Analytical Dashboards: Developed interactive and insightful dashboards using MS Power BI and Tableau, providing real-time analytics and visualizations improving operational efficiency and client satisfaction.

London, United Kingdom

• Involved in design & development of ETL (Informatica workflows and mappings) solutions, debugged & tuned data integration processes, analyzed data processing, process controls, troubleshot and recommended improvements• Designed & developed BI solutions by presenting information through reports, dashboards, and visualizations using BusinessObjects, Power BI, and Tableau; examined & enhanced existing BI systems• Involved in code & design reviews to align all solutions to established architectural and requirement specifications• Provided technical insight & design recommendations; developed Oracle PL/SQL procedures; extended L3 support for ETL & BI processes to ensure timely availability of accurate data in the database for BAU processing and reporting use• Designed and developed value adds like One-Click (automated deployment tool for ETL/DBcodebase), Auto-Reconcile (a reconciliation tool to detect & report transactional anomalies between prod and prod-alike databases), JIRA Metrics (generate advanced metrics using JIRA & PowerBI)

Pune, Maharashtra, India

• Setup Informatica PowerCenter on the project in collaboration with the Informatica Admin team and trained the client on the tool capabilities• Designed & developed Informatica workflows/mappings with XML and flat files interactions; delivered in tight deadlines• Mentored technical resources on standards to be used during design, development, and unit testing• Liaised with Business Stakeholders, Developers, Infrastructure teams, and project management teams• Wrote Unix shell scripts to perform parsing operations on the data files for sanctity prior to ETL layer ingestion

North Carolina, United States

• Delivered round-the-clock L3 technical support to diverse ETL and Business Intelligence applications• Supported over 4000 critical daily jobs loading data to various databases such as Teradata, Oracle & DB2 using ETL tools (Informatica, DAC, Composite, Datastage) & Mainframe• Assisted business users on queries related to the Micro strategy reporting, ensuring timely availability of accurate historical data for use in reports for Legal requests within tight deadlines• Implemented regular enhancements on existing processes to improve the performance, and incorporate upstream & downstream system modifications• Collaborated with support teams for driving timely releases with minimum/zero impact on day-to-day processes

Massachusetts, United States

California, United States

Pune, Maharashtra, India