Jan 2023 – Feb 2025 · 2 yrs 1 mo · Bengaluru, Karnataka, India · On-site

Apr 2021 – Jan 2023 · 1 yr 9 mos

Apr 2020 – Mar 2021 · 11 mos

Jun 2019 – Apr 2020 · 10 mos · Bengaluru, Karnataka

• Deployed optimized spark scripts for data ingestion for incremental and full data loads
• Designed and built datamart for internal team requirements to facilitate reports/metrics for day to day reports
• Built data ingestions pipelines on Nifi to copy data from different data sources and organize them in datalake
• Enabled superset dashboards for internal analytics community and business heads

Jan 2017 – May 2019 · 2 yrs 4 mos · Pune Area, India

• Worked with pharmaceutical companies in designing and building technology solutions to improve commercial effectiveness, which requires expertise in Data Warehousing and pharma domain
• Responsibilities included end to end delivery, involved in all phases of project from requirement gathering, constant client interactions, planning, building insights, automation, business analytics, sales reporting along with mentoring and collaborating with team
• Working with multiple stakeholders from client side to ensure smooth and timely project delivery
• Part of architecture design discussions for overall project, which involves working on POCs, designing reusable frameworks with constant outlook for innovation
• DW and Reporting Analytics for a pharmaceutical company:
• ➢ Cloud based data warehouse solution to integrate multiple data sources and
• conforms it with master data to form a single source of truth
• ➢ Worked on all phases of a project in integration of multi-channel marketing sources
• for US and EU region
• ➢ Lead team of 7 for database design, data modelling and build of Data Warehouse
• Solution for Spain and Portugal market
• ➢ Developed modular python scripts, interact between s3, Redshift, Aurora, RDS and
• SnapLogic to orchestrate and automate end to end data load process
• ➢ Built robust, scalable and configurable frame works for ETL processes in python to
• assist swift integration of data sources
• ➢ Lead design and build of dynamic integration of CRM data from Salesforce(using
• SnapLogic and python)
• ➢ Extensively worked on improving system performance by using different tool and
• techniques Achieved overall ~40% improvement in system performance and
• reduced 30% manual effort in processes by various initiatives
• Field reporting solution for merger:
• ➢ Involved in building a merger solution using PL/SQL that is easily scalable and
• reduces the future development and enhancement effort
• ➢ Developed and pro-actively contributed in data profiling and project build

Aug 2014 – Dec 2016 · 2 yrs 4 mos · Pune Area, India