SUSMITA GAWDE
Mumbai
Summary
Experienced data warehouse engineer with 5+ years of expertise in data modeling and implementing technical solutions for real-time data streaming. Proven track record of making significant contributions to multiple projects, resulting in streamlined day-to-day activities. Over the next 5 years, my goal is to contribute to impactful data-driven solutions, utilizing my expertise in data modeling, ETL pipelines, and data warehousing. I aim to continuously enhance my skills and collaborate with diverse teams to create innovative, scalable, and efficient data solutions.
Overview
6
6
years of professional experience
Work History
Senior Software Engineer
BNP Paribas India Solutions Pvt. Ltd
Mumbai
06.2019 - Current
- Managed corporate and investment banking operations.
- Involved in development activities to enhance the effectiveness of due diligence, regulatory reporting, referential, and compliance topics through the Informatica PowerCenter 10.5.3 , Oracle queries and Shell Scripting.
- Implemented strategies for the seamless functioning of compliance modules, and served as the Anti-Money Laundering, Reval projects SPOC, with additional knowledge of referential systems like ATLAS2.
- Created and managed data pipelines using Informatica and Oracle to implement the required business solutions to seamlessly process the payments and postings data for the AML project. Successfully scheduled the workflows by analyzing dependencies using Unix Shell scripting and the DollarU application.
- Successfully implemented an automated process for intraday payments data.
- Automated the end-to-end data integration process for the Reval project by using shell scripting. From getting files from the provider, renaming them according to the standards followed by the data warehouse, integrating, creating extracts using the necessary business logic for payments, and finally sending the extracts to the corresponding downstream, all of these processes are automated by creating four Unix services, which reduces manual intervention by 80%.
- Optimized the workflows by 40%, which resulted in taking less run time and using fewer resources.
- Analyzed and resolved L3 support issues, ensuring business continuity. Optimized database resource usage by streamlining batch processes.
- Skilled in overseeing the entire data warehouse life cycle, encompassing tasks such as technical specification design, data flow development, report creation, performance optimization, testing procedures, production transition facilitation, as well as post-production assistance.
- Developed and implemented data pipelines while migrating Informatica code with Python.
- Proficient in developing, deploying, and testing SAP BusinessObjects universes using designer tools and the Oracle database.
- Developed and managed BOXI 4.0 Designer and CMC, gaining valuable experience in report development.
Education
Masters - Computer Application
University of Mumbai
Mumbai05-2019
Bachlor of Science - Information Technology
University of Mumbai
Mumbai05-2015
Skills
- Oracle
- Informatica Powercenter
- PL/SQL
- Unix
- SAP BO
- Python
- Pandas
- Shell scripting
- Data pipeline development
- Performance tuning
- Other tools : GitHub, Autosys, Oracle SQL developer, MS SQL server, WINSCP
Timeline
Senior Software Engineer
BNP Paribas India Solutions Pvt. Ltd
06.2019 - Current
Masters - Computer Application
University of Mumbai
Bachlor of Science - Information Technology
University of Mumbai
Similar Profiles
Shilpa RoyShilpa Roy
Senior Business Analyst at BNP Paribas India Solutions Pvt LtdSenior Business Analyst at BNP Paribas India Solutions Pvt Ltd
Prathmesh SangarPrathmesh Sangar
Software Support Analyst at BNP Paribas India Solutions Pvt ltdSoftware Support Analyst at BNP Paribas India Solutions Pvt ltd
Jayaramachandran JJayaramachandran J
Cyber Security Framework Expert – Manager at BNP Paribas India Solutions PVT Ltd.Cyber Security Framework Expert – Manager at BNP Paribas India Solutions PVT Ltd.