OSHI CHOPRA

Under the Statistically Capable Supply Chain (SC2) initiative, developed a centralized data warehouse using Google BigQuery to collect data from multiple sources like Oracle, SAP & Sharepoint and integrated it to existing downstream BI tool (Power BI) to streamline the insights generation process and build foundations for future AI/ML workloads. Orchestrated business logic SQL and Python transformations using Cloud Composer to process the data from different staging layers in GCP. Maintained dependencies between different pipelines using code based ETL framework like Apache Airflow. Used Cloud Ops Monitoring for creating Alerting Policies. Other services like Source Repositories and Google Cloud Storage to ensure the data is available faster and easier to analyze.

Sourcing, processing, managing and distributing business driven and actionable visual reports using Tableau for key stakeholders in Supply Chain domain. Architectured multiple data pipelines, end to end ETL and transformation in GCP. Design and Develop SQL queries to perform ETL processes. Created Stored Procedures in BigQuery for various Business Requirements and Data Security. Implemented Query optimisation and Performance Tuning in Database Application Development. Provide resolution to the issues raised on design and code reviews. Extraction of data from various source system from SQL Server, Oracle, Teradata. Migrated mappings, sessions, and PLX workflows from Development to testing and then to Production environments. For moving and processing data in workflow management, used Python libraries such as pandas & petl. Used TensorFlow in Data Analysis and Big Data applications.

Provided Quality Assurance for the web application(Siebel CRM) under Telecom Domain. Automated the integration services using ReadyAPI / SOAPUI PRO. Design test cases according to user requirements and specifications. Extensive use of MySQL for fetching data from the databases. Reporting defects and tracking it according to the Defect Life Cycle using the Defect Management Tool(HP-ALM). Troubleshooting of all application and cloud server level errors in the ALM cycle. Worked in Testing Applications like OSS/BSS, FMW, BRM, OSM, SQL Databases. Indulged in Deploying pipelines using Jenkins. Performed Regression Testing, UI Testing, GUI Testing, Smoke Testing using Automated scripts via Selenium IDE in different Environments like SIT, UAT, PROD. Skilled in Test Driven Development, Agile Development, SOA project.