Latha Mysore Krishna

1. Project: Bombardier Recreational Products | April 2022 – present.

• Providing ELT solutions using Snowflake and dbt.
• Used Snowflake as a data warehouse.
• Performed various data transformations using dbt.
• Handling deployment and data pipeline using Azure DevOps.
• Created macros to provide dynamic solutions to complex requirements.
• Dynamically handled a complex table containing SCD type 1 and type 2 columns.
• Overwritten global macros to resolve business requirements.

2. Project: MOSAIC |April 2022 – present.

• The solution and architecture for the Mosaic Information Centre is supported by VisualBI. As part of this project, the production monitoring is also maintained by VisualBI. MIC Data Lifecycle supports both batch and real-time ingestion.
• Monitor the Azure Data Factory pipelines and activities, and record the status of the jobs.
• Coordinating with the Scrum team for any data-related issues and for changes or dependencies.
• Perform a POC on database activities, such as deadlock issues and runtime/connectivity issues.
• Shadowing during ticket resolution.
• Working on incidents/services created by users.

1. Project: OPTUS - RAC REPORTING|Dec. 2016 - Jan. 2017

• The solution will be the new source of rate plan and billing data, residing on the data warehouse platform as a second source. This would mean the new source would need to be combined with the existing source(s) to provide a single, complete view for the customer: Reporting, Analytics, and Campaigns. The data in the DWH is processed into OLAP data marts for reporting and analysis purposes.
• Prepared and ran SQL queries to verify target data.
• Verifying the data in the target database after the ETL process.
• Prepared test data for testing.
• Interactions with the BA and Dev teams to resolve the issues.
• Defect Analyzing and Reporting in QC.
• Ensure on-time delivery of the assigned work.

2. Project: GENERAL ELECTRIC - COMMERCIAL FINANCE | Feb 2013 - Dec 2016

• All GE Commercial Finance businesses are engaged in the Consistency for Growth Initiative. The main aim of this initiative is to drive sustainable growth and returns, with more efficient allocation of capital via transparent, data-driven processes.
• Discuss with the PMs for any clarifications, if any.

Project: PAYPAL- Wallet Optimization | April 2012 - Sep 2012

• This project is to develop a scalable decision framework to intelligently deliver the right offer when a customer is checking out, based on a newly developed multifactor segmentation strategy that will drive profitable consumer engagement.
• Involved in the analysis of project requirements.
• Follow-ups with the data modeling team for data definitions.
• Developed the code using Teradata, Informatica, and UC4 scheduler.
• Involved in creating and executing test cases.
• I worked on fixing the production issue.

2.Project: PayPal - Retool Mediaplex| Feb 2012 - Mar 2012

• In this project, Mediaplex captures the event-level data that defines clear precision and methodology in how PayPal should implement onsite tracking for future offsite (and onsite) attribution analysis. The event-level data are provided as feed, which we load into our tables.
• Took complete ownership and responsibility for the delivery of this medium-level project.
• Preparation of test data and test cases covering all business scenarios.
• Involved in the analysis of project requirements.
• Follow-ups with the data modeling team for data definitions.
• Developed the code using Teradata, Informatica, and UC4 scheduler.
• Involved in creating and executing test cases.