Sheetal Bagga

• Designed and delivered a “one-stop shop” for insights curation that provides “on-demand insights” to those facing off with the C-Suite. As part of the discovery workstream, worked with various business units to identify potential use cases.
• Managed the implementation of data pipeline and automation for AWS and Azure sources, discovery of future use cases, and development and delivery for 300+ ACP Clients in lower and higher environments.
• Created architecture design for overall data pipeline and data model, leveraging AWS Data Pipeline for seamless integration and management of various data sources.
• Proven leadership in managing technical teams, pursuing opportunities, pricing, and resource allocation for successful project delivery. Received multiple Applause awards for the leadership impact and delivery.

As a resident domain expert, I ensured top-notch data quality, security, and asset management for Supply Chain/Commercial.

• Accountable for the "Company 360" data asset, I Collaboratively partnered with application development teams, stakeholder groups, and regional hub stewards, and effectively translated data requirements into precise engineering specifications.
• I created comprehensive artifacts and documentation that empower application development and asset teams to construct seamless data flows across source systems, asset-derived APIs, Kafka topics, and Postgres databases.
• Taking charge of end-to-end design and delivery, I successfully migrated MyMon to MyCrop app while implementing impactful portal enhancements. Received client appreciations for being the most impactful Steward.
• With advanced technical expertise in SAP HANA, Oracle, and Teradata, I leverage cutting-edge data warehousing tools to deliver the most efficient solutions.

• Successfully executed a seamless migration of data from Teradata to Hadoop, employing Hive scripts to efficiently manage HDFS storage.
• By automating monthly data removal and archival in Hadoop and On-Premise, I ensured compliance with GDPS regulations.
• Designed an end-to-end pipeline using Teradata SQL and Unix Shell Scripts for the Callback Level 3 process and ARMS Level 3 process, enabling the business to access Catastrophe Reports from the data warehouse via Report Web.
• Optimized SQL queries in Teradata, designed data load scripts, and performed seamless deployments using Git and Jenkins.

• Led an offshore team of 6-8 members for migration of ERP data from Teradata to HANA and build framework for directly fetching SAP data to HANA using S4 HANA Architecture.
• Led the Testing team and Optimized Stored Procedures to work with New acquired data from Time Warner Cable.

• Performing tuning at various levels in SQL and procedures using SQL Assistant and Teradata Viewpoint and job scheduling with understanding of dependencies using IBM Workload Scheduler.
• Maintaining source code repository such as BitBucket using Git, Atlassian Suite and Jenkins for all projects.
• Developed data load scripts using ETL, SQL, and SCALA, Python and Shell Scripting.

• Developed Dashboards using SSRS, Dundas and Microstrategy for Insurance and Banking KPI.
• Implemented SCD2 logic for various scenarios requiring incremental data storage in various databases like Oracle, Sql Server and Teradata.
• Developed jobs using DataStage Designer, DataStage Manager, DataStage Director and DataStage Debugger. Wrote SQL scripts for backend databases, custom stored procedures, macros and Packages along with Referential Integrity triggers.

• I crafted dynamic and interactive dashboards using SSRS, Dundas, and Microstrategy, empowering the insurance and banking sectors with insightful KPIs. Employing SCD2 logic, I ensured incremental data storage across diverse databases like Oracle, SQL Server, and Teradata.
• Leveraging DataStage tools, I developed robust jobs and utilized SQL scripts, stored procedures, macros, and triggers to enhance backend databases.
• Developed and implemented SpogOps, an all-inclusive operations app, which reduced the time spent on event consolidation from multiple monitoring tools by 20%, resulting in enhanced efficiency using Splunk.