Oct 2018 – Jan 2024 · 5 yrs 3 mos · Bangalore

• Directed a team of 10 professionals in the successful execution of critical projects, including Substitutability, Emerging Marketplaces Reporting, and Customer Analytics Infrastructure.
• Engineered and deployed scalable data solutions for Amazon's Delivery Experience (DEX) platform, enhancing operational efficiency.
• Developed comprehensive dashboards and analytics tools utilizing QuickSight and Tableau, empowering various business teams with data-driven insights for strategic decision-making.
• Generated substantial financial savings, approximately USD 20M for the finance team and USD 40M for the Delivery Experience team, through the successful implementation of automation.
• Streamlined operations by automating FulCPU processes, saving 3 months of Finance Analyst bandwidth, and optimized Customer Analytics Infrastructure, leading to a reduction of 6 FTE.
• Demonstrates expertise in data modelling, ETL processes, and data warehousing concepts, coupled with hands-on experience in maintaining petabyte-scale compute and analytics clusters.
• Recognized with four distinct awards, notably for presenting the DYOA (Do Your Own Analysis) tool at Amazon's Analyticon conference across the APAC and EMEA regions.
• Collaborated extensively with cross-functional teams to deliver complex, large-scale projects and oversee ongoing Keep-The-Lights-On (KTLO) activities. Effectively interfaced with cross-functional leaders to articulate strategies and achieve measurable business outcomes.
• Provided expert guidance to teams for building and maintaining robust data pipelines, supporting petabyte-scale data management in strict adherence to organizational data strategy and high data processing standards.
• Possesses proven experience operating within Agile development environments and a strong understanding of CI/CD pipelines and DevOps practices.

Oct 2016 – Sep 2018 · 1 yr 11 mos · Bengaluru, Karnataka, India

• Worked as Associate Technical Architect (DWBI & Big Data)
• Expertise in Modelling & Designing Data warehouse and Data Marts
• Attended training and complete POC using Big Data Technologies using Elastic search, NiFi, Kibana & Kafka.
• Knowledge of Big data and Hadoop Ecosystem.
• Experience in working with both OLTP and OLAP systems
• Worked as Data Architect to design fact, dimension and complete Business Model in BI cycle
• Experience in working with variety of Databases namely Oracle, JD Edwards and Sybase
• Expert in Financial Analytics, Procurement & Spend Analytics, HR Analytics implementation
• Expert in Project Planning starting from requirement gathering, high level design, low level design, actual code implementation
• Worked on OBIA 7.9.6.4 with Informatica 8.6.1/9.6.1, DAC 10g/11g, OBIEE 10g/11g
• Experience in leading and guiding team for variety of implementations

Jul 2015 – Oct 2016 · 1 yr 3 mos · Noida, Uttar Pradesh, India

• Worked as Associate Consultant (Oracle BI Applications)
• Expert in Financial Analytics, Procurement & Spend Analytics implementaion
• Worked on OBIA 7.9.6.4 with Informatica 8.6.1/9.6.1, DAC 10g/11g, OBIEE 10g/11g
• Experience in leading and guiding team for variety of implementations
• Expert in Data modelling and Data Warehousing.
• Expert in ETL-Informatica starting from requirement gathering, high level design, low level design, actual code implementation
• Expert in Scheudling tool DAC for ETL run
• Knowledge of all three layers of OBIEE, Creation of Report and Dashboards in BI, BI Security.

Apr 2013 – Jun 2015 · 2 yrs 2 mos · Noida, Uttar Pradesh, India

Jan 2011 – Mar 2013 · 2 yrs 2 mos · Noida · Hybrid

• An experienced Client Owner for US H&W process with a proven track record of successful ETL development and project delivery.
• Developed and implemented ETL logic based on business requirements, transforming raw data into final files for business use.
• Expert in developing mappings and utilizing appropriate transformations to meet project specifications.
• Provided valuable project suggestions and value additions that were successfully incorporated into requirements and code.
• Exceptional in resolving production issues raised by the business, ensuring operational continuity and client satisfaction.
• Analyzed Business Requirements Documents (BRDs) before acceptance and provided guidance to the team on implementation.
• Successfully completed the OE process and managed ongoing tasks, demonstrating strong project management.
• Received individual and team awards (‘Feather in the Cap’ and ‘Eagle Squad’) for excellent performance and contributions.
• Conducted H&W training across teams, sharing knowledge and improving team capability.
• Served as a Client Owner for multiple clients, managing their requirements and ensuring successful project outcomes.
• Collaborated closely with clients and onsite teams in daily calls to understand requirements and improve processes.
• Worked directly with business and client sides to implement changes to requirements for the betterment of the overall process.
• Guided the team in implementing code and logic, ensuring quality and alignment with the BRD.
• Received appreciation from customers and the team, highlighting strong communication and leadership skills.

Nov 2008 – Jan 2011 · 2 yrs 2 mos · On-site

• Developed and implemented ETL logic for Healthcare Effectiveness Data and Information Set (HEDIS) and Provision Data Model to support a financial data mart, integrating premium, membership, and acquisition data from various sources.
• Expert in developing ETL mappings using a variety of transformations, including Sorter, Filter, Aggregator, Joiner, and Lookup, to meet specific project requirements.
• Created mappings directly from SQL code provided by the client, demonstrating a strong grasp of technical translation.
• Delivered change requests for existing code with thorough testing, ensuring quality and stability.
• Contributed valuable additions to projects that were incorporated into both requirements and code, enhancing overall project efficiency and outcome.
• Conducted source code reviews and unit testing, and prepared detailed documentation, including Unit Test Documents and PowerCenter Design Specification Documents.
• Handled the Immunization Process for the HEDIS project, a critical quarterly data extraction program for healthcare performance metrics.
• Received appreciations from both the customer and the team, highlighting strong performance and collaborative skills.
• Completed HIPAA certification to implement physical, technical, and administrative safeguards to protect Protected Health Information (PHI) from unauthorized access, misuse, or disclosure.