SWETA SHIVANI

EDW Decommissioning - Data Migration (On prem to GCP ) ( Client - British telecom)

• Reverse-engineered and analyzed existing Tableau dashboard queries using on-prem Oracle/SQL data to optimize performance and improve data flow understanding.
• Converted Oracle PL/SQL logic to Google BigQuery (BQ) to support Qlik Sense reporting, enabling seamless migration and integration of reporting tools.
• Designed and modeled data across multiple streams to deliver strategic, reusable, and consumable data products in BigQuery, enhancing reporting efficiency and scalability.
• Compiled, cleaned and manipulated data for proper handling.
• Analyzed large datasets to identify trends and patterns in customer behaviors.

AVON - Migration of Netezza data to BQ (Historical load). client (British Telecom)

• Collaborated regularly with BT Legal team to gather and refine business and technical requirements for data solutions.
• Developed Ab Initio pipelines to transfer data from Netezza to Google BigQuery, ensuring no data retention policies at the table level to preserve historical records.
• Enabled Pub/Sub messaging and logging in Google Cloud Console to trigger email notifications on DAG failures, improving monitoring and incident response.

TMUK DWH Decommissioning - Data Migration from Netezza to Big Query ( Client - British Telecom )

• Streamlined ETL scheduling using Apache Oozie, eliminating manual intervention, reducing human error by 90%, and saving 10 hours of manual work per week.
• Collaborated with diverse teams to analyze potential risks and develop mitigation strategies, achieving a 99.9% successful transition rate and a 50% reduction in migration-related downtime.
• Automated data transfers from Netezza to Google Cloud Platform (GCP), cutting migration time by 50%, and implemented reporting mechanisms to ensure accurate data synchronization and validation between platforms.
• Implemented effective debugging strategies, resulting in fewer software defects and increased reliability..
• Consistently met project deadlines by effectively managing time and prioritizing tasks according to importance.

CUSTOMER MASTER FILES ( Client - British Telecom)

• Working in DevOps for Customer Master Files, developing and testing Oracle-PL/SQL procedures to resolve data quality issues.
• Involved in component integration, bug fixing, and providing 2nd and 3rd line support during live issues.
• Streamlined the maintenance of British telecom customer data from various streams and storing in data lakes and data warehouse by performing ETL methodologies using hadoop ecosystem.
• Refactored legacy codebases for improved maintainability, paving the way for easier future updates.

Mvola Telecom ( Client - Madagascar, Africa)

• Optimized system performance, improving stability and efficiency and collaborated with stakeholders and the solution architect throughout the release process.
• Migrated oracle pl/sql stored procedures to Postgres sql.
• Developed postgres stored procedures for managing loan accounts customers and generating EMI notifications periodically.
• Used kafka for streaming live data of customers.

TMUK Data Warehouse ( Client - British Telecom)

• Implemented effective debugging strategies, resulting in fewer software defects and increased reliability.
• Developed enhancements, optimized performance, and implemented add-ons to meet evolving project needs.
• Collaborated in designing technical requirements and contributed to technical discussions for development and improvement.
• Reduced system downtime and improved reliability by proactively identifying and addressing potential system vulnerabilities.
• Technology - Ab-Initio, Shell Scripting, Netezza