A dynamic and results-oriented professional with a postgraduate degree in computer science and five years of hands-on experience in Microsoft Business Intelligence (MSBI). Proficient in a variety of ETL tools and visualization tools such as SSIS, PowerBI, SSAS, and SSRS, with a strong understanding of data warehousing techniques, data integration, and OLAP. Skilled in building and testing ETL flows, SQL development, and constructing OLAP cubes/Reports using SSIS, SSRS, MDX, and DAX. Possesses robust capabilities in SQL and Power BI report development, coupled with practical experience working in Agile methodologies. Committed to delivering high-quality solutions and leveraging technology to drive business success.
Hi, I’m
RUCHA YANDE
Data Engineer
Summary
Overview
6
years of professional experience
Work History
Deloitte USI
Integration Consultant
08.2022 - Current
Job overview
- Built data pipelines and infrastructures to support the needs of business
- Ingested the data from SFTP and API endpoints
- Created Inbound API in o9 platform and integrated them with SQL Server Management Studio (SSMS) for seamless data exchange and application connectivity
- Conducted thorough testing of API requests to validate functionality, identify and resolve issues, and ensure compliance with project requirements and standards
- Implemented enhancements to existing solutions, such as optimizing ETL processes by leveraging parallelism techniques and implementing mechanisms for bad record extraction, resulting in improved performance and data quality
- Collaborated with cross-functional teams including business analysts, developers, and stakeholders to gather requirements, analyze data needs, and propose effective solutions
- Analyzed and interpreted client requirements, ensuring clear understanding and effective communication throughout the project lifecycle
- Facilitated client interactions to gather feedback, address concerns, and ensure alignment with project objectives and deliverables.
IBM
Software Engineer
01.2022 - 08.2022
Job overview
- Analyzed project requirements to create a detailed data mapping sheet, streamlining data management and system integration
- Applied advanced expertise in the supply chain domain to inform decision-making and enhance operational efficiency
- Generated and maintained various documents, such as integration guidelines and data flow diagrams, ensuring clear communication and alignment among stakeholders
- Conducted comprehensive knowledge transfer sessions for new team members, equipping them with essential skills to accelerate their integration and boost team productivity.
TietoEvry
Junior Software Engineer
08.2019 - 01.2022
Job overview
- Developed and deployed SSRS reports, providing actionable insights for stakeholders and supporting decision-making
- Conducted comprehensive testing of DW reports and ETL processes to ensure accuracy, integrity, and performance
- Implemented SQL queries, procedures, and indexes to optimize data retrieval and manipulation for BI solutions
- Managed data loading service requests, ensuring timely delivery of accurate information to stakeholders
- Leveraged Power BI and SQL Server/Tabular SSAS for report/dashboard development, enhancing actionable insights
- Led migration initiatives to enhance Power BI report responsiveness and data freshness, transitioning reports from import mode to direct query
- Oversaw deployment activities, including production, QA, and test deployments of ISPAC files, SSIS Catalog, and multidimensional cubes, ensuring seamless execution.
Allianz
Analyst
05.2018 - 08.2019
Job overview
- Creating wide range of reports using SSRS like Drill down, drill through, sub reports, using different report parameters like charts etc
- Managed the deployment of reports utilizing SSRS, ensuring seamless integration into the production environment and timely availability to end-users
- Contributed to data testing efforts, assisting in the validation of data accuracy, completeness, and reliability within reports, while also learning SQL for data testing purposes
- Provided support in monitoring SSIS jobs, helping to oversee job execution and performance, and gaining valuable experience in SSIS job monitoring processes.
Education
University of Pune
Master of Science from Computer Science
04.2001
University Overview
Distinctions: True
- Graduation with Distinction
- Ranked 2% in Class
Skills
ETL Tool - SSIS
Job Monitoring - Sql server , Control M
Cloud Service - Azure(Basic)
Visualization Tool-Power BI, SSRS
Query Language : SQL,MDX,DAX
Data Warehouse TechniquesOLAP : SSAS (Multidimensional/Tabular Model)
Programing Language - Python
Accomplishments
Accomplishments
- Integration Using SSIS & Reference Product Integration R2021.10
- DA100 – Analyzing data with Microsoft Power BI
- AZ900 – Microsoft Azure Fundamental
- DP900 – Microsoft Azure Data Fundamental
- ITIL V4
Timeline
Integration Consultant
Deloitte USI
08.2022 - Current
Software Engineer
IBM
01.2022 - 08.2022
Junior Software Engineer
TietoEvry
08.2019 - 01.2022
Analyst
Allianz
05.2018 - 08.2019
University of Pune
Master of Science from Computer Science
04.2001