Deepak Pandey Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

In my role as a Sr. Associate (Sr. Analyst / Asst. Manager), I tackle big-data analytics and ETL solutions, providing critical metric reports for various functional areas and geographies. My responsibilities extend beyond reporting as I actively generate new ideas, identify critical problems, and mentor my peers and juniors. In this role so far, I have -1. Delivered reports for US acquisition strategy teams using Hadoop, Hive, and MS BI Stack, to facilitate critical reporting on… Show more In my role as a Sr. Associate (Sr. Analyst / Asst. Manager), I tackle big-data analytics and ETL solutions, providing critical metric reports for various functional areas and geographies. My responsibilities extend beyond reporting as I actively generate new ideas, identify critical problems, and mentor my peers and juniors. In this role so far, I have -1. Delivered reports for US acquisition strategy teams using Hadoop, Hive, and MS BI Stack, to facilitate critical reporting on strategies expected to drive more than 80% of new acquisitions.2. As part of the modernization initiatives of AmEx systems, the organization went on to decommission older data source systems, under the scope of this activity, I was allowed to perform holistic analysis on 300+ variables being used across 40+ critical MIS reporting, the findings from which were used by 12+ developers to migrate their data pipelines under record time successfully.3. Worked on enhancing analytical product delivery workflow initiatives to reduce release timelines, reducing the average delivery timelines by 40%. Also, I proposed & developed a JIRA time tracking tool, using Python, JIRA Rest API & Tableau to provide complete oversight, & visibility on JIRA tickets for the wider organization.4. Mentored & managed two newly joined interns for the 2023 batch. Show less

Gurugram, Haryana, India

In my role as an Associate/Analyst, I was responsible for creating big-data ETL solutions to automate MIS reporting using Excel pivots & Tableau dashboards. In this role, I have -1. Created reports on the $ 200B+ USA personal loans market using Experian and AWS, delivering key insights on 17+ companies to strategy teams.2. Saved 60+ hours of monthly manual effort by migrating Excel, & PowerPoint reports to Tableau with automated big data pipelines.3. Migrated critical… Show more In my role as an Associate/Analyst, I was responsible for creating big-data ETL solutions to automate MIS reporting using Excel pivots & Tableau dashboards. In this role, I have -1. Created reports on the $ 200B+ USA personal loans market using Experian and AWS, delivering key insights on 17+ companies to strategy teams.2. Saved 60+ hours of monthly manual effort by migrating Excel, & PowerPoint reports to Tableau with automated big data pipelines.3. Migrated critical reports to new data sources by analyzing over 20K+ lines of codes (LOC), optimizing codes to reduce execution time by 35%, and reducing 4k+ LOC in the process.4. Collaborated with leaders to draft a next-gen analytical framework for the central BI team of the AmEx risk department, targeted to improve data quality by 40% and establish a communication framework to handle >99% of engagements.5. Worked on maintenance, migration, automation, and enhancement of key reports by actively collaborating with strategy teams and other stakeholders, using big-data stack (Hive, HDFS, PySpark), python, bash & MS BI stack (SSMS, SSIS, & SSAS). Show less

• Engineered a micro-segment insights engine using Python and PySpark to identify the top 1% of high-risk groups from over 1 million segment permutations.• Eliminated over 100 hours of monthly manual effort by building automated data pipelines with Bash, Python, Hive, and an internal orchestration tool for Amex risk team leadership.