Yash Desai
Mumbai
Summary
Results-driven ETL/Power BI Developer with expertise in SQL and cloud integration, with 3 years of experience in Information Technology and data warehousing, honed at Avenir Innovation Solutions.
Proven track record in optimizing data pipelines and enhancing data accuracy, while effectively managing project timelines. Adept at collaborating in agile teams, demonstrating strong problem-solving skills and a commitment to data integrity.
Overview
4
4
years of professional experience
1
1
Certification
Work History
ETL/Power BI/Application Developer
Avenir Innovation Solutions Pvt Ltd
Navi Mumbai
03.2024 - 02.2025
- Company Overview: SBI
- Extracted and integrated data from core banking systems, transaction databases, and external financial sources to ensure seamless data flow.
- Transformed raw banking data into structured formats, implementing cleansing techniques to improve accuracy, resolve duplicates, and handle missing values.
- Hands-on experience with data models, DB performance tuning in PostgreSQL.
- Worked in an agile environment and was actively involved in all agile ceremonies. Designed and configured DataStage solutions in line with technical specifications. Developing and implementing custom ETL jobs using DataStage.
- Developing and implementing custom ETL jobs using DataStage
Associate Consultant (ETL Developer)
Jupiter Analytics Pvt Ltd
Mumbai
07.2021 - 04.2023
- Company Overview: Genpact
- Maintaining and updating custom ETL jobs as needed due to software upgrades or modified requirements.
- Documenting configurations, custom code, and ETL processes.
- Proficiency in IBM DataStage development, migrations, and administration.
- Experience working with Python.
- Developed training materials and user manuals for new systems and processes.
- Managed project timelines and deliverables, ensuring timely completion within budget.
- Experience working with databases and SQL scripting.
- Experience in shell script development.
- Troubleshooting and Maintenance: Identify and resolve issues within ETL processes, ensuring data integrity and reliability.
- Perform regular maintenance to keep the data pipelines functioning optimally.
- AWS S3 Integration: Utilize AWS S3 for scalable data storage, ensuring secure and efficient data storage solutions that facilitate easy access for Power BI reporting.
- Documentation and Compliance: Maintain comprehensive documentation of ETL processes, and ensure that data handling complies with relevant data protection regulations or standards.
Education
Master of Science - Computer Applications Development
TIMSCDR
Mumbai02-2021
Bachelor of Science - Information Technology
Reena Mehta College
Mumbai01.2017
Skills
- Data integration
- Data transformation
- Database management
- SQL scripting
- Agile methodology
- Technical documentation
- Project management
- Troubleshooting techniques
- Effective communication
- Team collaboration
- Problem solving
- Decision-making
- ETL development
- MatPlotlib
- Seaborn
- NLP
- Deep Learning
- Time and Series Analysis
- Tree based Analysis
Certification
- Certification in Data Science and Machine Learning, Data is Good, NumPy, MatPlotlib, Seaborn, NLP
- Employee of the Year, Jupiter Analytics, 2022-23
- Badges in IBM Infosphere DataStage Developer, Combining Data
- Certificate in Amazon Web Services Course, Great Learning Academy
- D-Link Certification Exam in Switching
Accomplishments
- Subhead of the Treasure Hunt event in the college's annual fest, TIMSCDR Vista 2020
- The Employee of the Year award for the year 2022-23 from Jupiter Analytics
- Completed badges in IBM InfoSphere DataStage Developer, combining data
- Certificate in Amazon Web Services course from Great Learning Academy
- Completed the D-Link Certification Exam in Switching
Projects
State Bank of India (SBI), Navi Mumbai GITC, 03/01/24 - 02/28/25
- Working as an ETL/BI Developer in the Microsoft Power BI tool and IBM DataStage InfoSphere, SSMS, responsible for the creation, maintenance, and support of SBI Yono Dashboards, and to load the data onto the dashboards and make it live for the users and business units (BUs)
Genpact India, 09/01/21 - 04/30/23
- Working as a DataStage Developer for the past 1.8 years at IBM, using DataStage, Infosphere, SSMS, AWS Glue, AWS S3, MSSQL, DB2, and AWS Redshift
- Responsible for the creation, maintenance, and support of the Enterprise Data Warehouse, and modification of ETL packages and IBM DataStage 11.5 and 11.7 to load the data.
Timeline
ETL/Power BI/Application Developer
Avenir Innovation Solutions Pvt Ltd
03.2024 - 02.2025
Associate Consultant (ETL Developer)
Jupiter Analytics Pvt Ltd
07.2021 - 04.2023
Master of Science - Computer Applications Development
TIMSCDR
Bachelor of Science - Information Technology
Reena Mehta College
Similar Profiles
Naveen SinghalNaveen Singhal
Finance Lead - P2P Controller, Financial Planning at Baxter Innovation & Business Solutions Pvt LtdFinance Lead - P2P Controller, Financial Planning at Baxter Innovation & Business Solutions Pvt Ltd
MALATI GOUDAMALATI GOUDA
Talent Acquisition Coordinator at Baxter Innovation and Business Solutions Pvt Ltd(parent Company-ScaleneWorks People Solution LLP)Talent Acquisition Coordinator at Baxter Innovation and Business Solutions Pvt Ltd(parent Company-ScaleneWorks People Solution LLP)
NANCY DUITCHNANCY DUITCH
CEO at Avenir Wellness SolutionsCEO at Avenir Wellness Solutions