Sep 2020 – Present · 5 yrs 8 mos

• Designed, developed, and maintained end-to-end data pipelines for the Product Financial Management Cycle (PFMC) Data Warehouse using Python, SQL, and Unix Shell. Performed ETL operations to integrate data from multiple sources (IBM Db2, Oracle, MySQL) into centralized data warehouse environments. Developed and tuned complex SQL queries, stored procedures, and joins, enhancing query performance and reducing report generation time. Automated recurring tasks in Weekly and Monthly Batch Processes using UNIX shell scripting and scheduling tools (Cron, Autosys), improving operational efficiency. Supported schema modifications (DDL/DML) and managed deployment across Development, QA, and Production environments following ITIL Change Management. Partnered with cross-functional teams to implement data configuration changes, troubleshoot production incidents, and optimize data. Conducted Exploratory Data Analysis (EDA) using Pandas, NumPy, and Matplotlib to identify performance bottlenecks and data quality issues. Contributed to migration of on-premises ETL processes to Snowflake and AWS ecosystem integrating AWS Glue, S3, and EMR for scalable data processing. Created comprehensive data workflow documentation, standard operating procedures, and knowledge transfer material for ongoing support. Worked with ServiceNow and Jira for incident management, root-cause analysis, and change tracking. Provided technical support and knowledge transfer to customers and internal stakeholders, ensuring effective incident resolution and minimizing downtime.