Yugesh Shrestha

• Acted as an ETL lead on building a new data warehouse solution based on the Snowflake database using native Snowflake and Azure tools.
• Collaborated with functional and technical team members on the client-side to understand different data source systems and their functionalities.
• Cooperated with data architects and clients to understand current business challenges and find optimal integration solutions.
• Used native Snowflake tools to integrate with Azure data lake storage, Snow pipes, Streams, and tasks.
• Created documentation for technical design, production deployments, test scenarios, and functional data documents for all integrations built.
• Provided guidance and reviewed the work of team members to ensure quality and timeliness of delivery.

• Created the technical structure in Best Buy's big data platform in Hadoop and Google Cloud Platform (cloud service) to house data from various sources, such as Oracle Retek, Teradata EDW, and Logistics, to prepare and process data efficiently.
• Processed data in Hadoop to prepare and get different data aggregations from multiple analytical and statistical processing sources and visual insights.
• Created processes and programs to integrate data between other technologies, including Hadoop, GCP, Teradata, and Oracle.
• Developed programs in R to perform statistical analysis on various levels and the nature of retail data and create visualizations for exploratory analysis and reports.
• Developed interactive visualizations in Google Data Studio to process massive file systems and get valuable insights.
• Participated in business and data meetings with different departments at Best Buy to understand the quality of data availability and a viable way to process data for advanced analytics and data science.

This project is an end-to-end implementation of a Snowflake-based data warehouse and business intelligence solution for an enterprise-level finance company.

• Handled client and team communications to derive business requirements into technical design and implementation.
• Performed Azure Data Factory end-to-end pipeline development to ingest data from different sources into Snowflake and automate ETL.
• Built ETL transformations and frameworks using Snowflake stored procedures for multiple domains.
• Built interactive Power BI Dashboards to monitor and analyze data quality parameters.
• Used Azure DevOps-based deployments using CI/CD pipelines.

• Served as a BI developer to implement, develop, verify, and validate retail data model (LRDM) data warehouse.
• Performed unit testing and integration testing for QA validation of ETL data loading scripts.
• Developed wrapper scripts for integration of ETL loading scripts using Korn shell scripting and Teradata database.
• Used Teradata fast load utility to import data from a database system of different sources into the Teradata database.
• Participated in mapping various retail functional areas concerning the RMS source system and respective script development.

Created a Tableau-based application to perform analytics on customer behavior. The data source was Snowflake, which sourced data from Shopify, and the application required dynamic calculation of customer segments based on user selections.

• Developed new customization for new functionalities in Oracle Xstore using XML configurations and Java Spring-based codebase changes.
• Fixed bugs for defects raised by QA and business users.

• Authored and executed test cases on RMS modules (foundation hierarchy, foundation items, purchase orders, stock counts, and future cost) on Oracle test manager for ADF screens.
• Detailed test case design, authored, and executed RMS's Oracle retail trade management (Import) module.
• Executed HPQC-based QA test cases in various ADF RMS screens to find defects in the ADF application.
• Ensured the ADF application had correct GUI and functional behavior. Cross-validated the functional behavior of the ADF-based RMS application with that of conventional forms-based RMS.
• Carried out ad-hoc testing in ADF-based forms to ensure the application does show any unusual behavior and cover the tests that predefined test cases cannot solely cover.
• Raised and managed bugs in Bug DB regarding defects found during manual test execution.
• Created different data set scenarios as input data for automation test execution on various RMS ADF screens.

• Led the project from gathering requirements to successfully going live and post-production support on implementing the Robling Retail Data Model and BI reporting solutions using Tableau and Power BI.
• Designed and developed ETL pipelines and scripts required for the data warehousing solution customized for the client using Python.
• Drove the requirement-gathering phase with clients to facilitate discovery mapping sessions.

• Supported projects consecutively for three Oracle RA clients: Hot Topic (USA), Gander Mountain (USA), and SSC (Pakistan) for monitoring and issue fixing of Oracle RA nightly batches.
• Provided fixes in any batch failures due to data or program issues and documentation on detailed analysis and fix resolutions.
• Created reports for the reconciliation of data between a source system and target warehouse regularly.
• Performed data level analysis for questions from businesses based on data inconsistencies in corporate reports.

• Developed a data integration system for Petco’s Teradata-based ODS system to and from different systems using the ODI 11g data integration tool.
• Led the development team in delivering the project code and prepared technical design documents for the overall integrations developed in the project.
• Performed unit, integration, and deployment testing on the integration codes developed.
• Prepared code deployment documents and assisted the QA team in deploying the delivered codes in the required environments.

This project was based on enhancements made to an existing in-house-built data warehousing environment entirely based on the Microsoft BI suite. Enhancements included building or upgrading existing components on T-SQL stored procedures, new ETL pipelines using SSIS jobs, SSRS reports, MDX queries, and SSAS Cube calculations.

My specific roles were:
• Led a team of offshore team members to work on requirement gathering, project delivery planning, tracking, and quality assurance.
• Worked as a BI developer to change existing T-SQL stored procedures, SSRS reports, and MDX Queries.
• Collaborated with the business team to conduct and support UAT sessions.
• Created or updated schedules for ETL pipelines based on Automic UC4 workflows.