Sep 2016 – Dec 2019 · 3 yrs 3 mos · Gurugram, Haryana, India

• Part of the Data Team, using Analytics to solve Business problems. Building the next Generation Data platforms and pipelines which can scale horizontally and Vertically on both Storage and Compute with a decoupled architecture. Automated on-premise data migration from Teradata to Cloud (S3, EMR-Qubole, Snowflake). Created data pipelines using AWS API’s, kinesis streams, Spark to get the data in warehouse for reporting usage.

Aug 2012 – Sep 2016 · 4 yrs 1 mo · Pune

• Key member of BI team.
• Developing Database Objects, Packages, PL/SQL stored procedures, functions,collections etc.
• Creating technical designs, data warehousing/datamart designing,data modelling.
• Involved in performance optimization initiatives. Worked on Performance Tuning, Query Optimization, design optimization,space optimization.
• Optimizing and tuning queries.
• Provide Root cause analysis for an issue.
• Provide impact analysis for a proposed change.
• Discussion with business managers/business analyst for gathering requirements, preparing technical designs, code development, implementation and post production support.
• Handle escalated/Level 3 and beyond issues.
• Performed System Migration from Production Site to DR site.
• Performed Autosys Migration from v4.5 to v11.3.
• Enabled key less, password based SSH setup between upstream/ downstream and system.
• Creating DDL, DML statements for large warehouse environment.
• Taking overall responsibility of database health from application side, monitoring the daily load & providing solution for load time & query execution time reductions.Involved in technical discussion with customer and third party vendors (OS,Databases) during handling an issue.

Jan 2010 – Aug 2012 · 2 yrs 7 mos · Gurugram, Haryana, India

• Key member of BI team. Involved in data modelling and design of data marts. Meetings with product for gathering requirements, preparing technical designs and providing the technical solutions.

Aug 2009 – Jan 2010 · 5 mos · Mumbai Metropolitan Region

• EDS stores derivatives and equity instrument data across stock exchanges worldwide. The data is sourced from various exchange feed files, Bloomberg, Reuters and other upstream systems.
• Gathered requirements & prepared technical designs, data model for storing new data into database from new upstream systems.
• Worked upon Bloomberg & Reuters Terminal to check/reconcile data from various sources(like exchange feed files).

Apr 2006 – Aug 2009 · 3 yrs 4 mos · London Area, United Kingdom

• Worked on BI systems, Informatica, Data-warehousing and got exposure to Capital markets & reference data by working on EDS application - which is a data repository for storing equity data generated by stock exchanges over the globe. Data is obtained from various sources (e.g. Bloomberg, Reuters, Fusion, DMS-I, NASDAQ, etc.) and EDS provides a single point access to this data for the traders in UBS.

Mar 2006 – Aug 2009 · 3 yrs 5 mos · Pune/Pimpri-Chinchwad Area