ABHAYPRATAP SINGH
KALYAN
Summary
Software engineer with 9 years of experience in data warehousing, reporting, and ETL tools. Proficient in industry-accepted methodologies and procedures to deliver high-quality solutions. Collaborates directly with onshore clients, ensuring seamless communication and understanding of project requirements. Committed to consistently exceeding client expectations by delivering exceptional results.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Associate
TIAA GLOBAL CAPABILITIES PVT LTD
02.2023 - Current
- Led an initiative to automate the finance report reconciliation process by transitioning from DataStage to PySpark, enhancing data processing efficiency and scalability.
- Developed optimized data pipelines using PySpark, significantly reducing the time for reconciliation tasks and improving overall process automation.
- Applied strong knowledge of data warehousing concepts to design and implement scalable data models, ensuring accurate and timely financial reporting.
- Working on a Proof of Concept (POC) to predict recurring issues in Production Support using Machine Learning algorithms like Random Forest, improving issue resolution efficiency.
- Developed and fine-tuned Machine Learning models to identify patterns in historical data, enabling early detection of recurring problems.
- Working on OAC for report generation and Production support fixes
Senior BI Consultant
ORACLE GSC
01.2022 - 02.2023
- End to end development of OBIEE reports which includes requirement gathering, Solution thinking, ETL , RPD development and report development.
- worked on extremely complex Profit and Loss report for Retail banking client
- Creating hierarchies in RPD
- Worked on ETL development and data loading in ODI
- Automation of file handling using python before loading in ODI
- Created Data model and RTF templates in BI Publisher for Automated mailers which were needed for Compliance
- Provided training to business team about usefulness of reports and how to access the various aspects of OBIEE reports
- Increased customer satisfaction by resolving issues.
Analyst
TIAA GBS INDIA PVT LTD
08.2019 - 12.2021
- Loading data to Hadoop using PySpark. Solving data level issues
- Debugging PySpark code for data issues
- Enhancement and Production Support Project which requires resolving OBI report level issues,server related issues
- RPD changes as per requirement
- Generating BI Publisher reports for clients which includes Data model and RTF templates
Software Engineer
L&T Infotech
05.2015 - 07.2019
- Worked with multiple clients (4 clients) for OBIEE reporting and ETL development and support.
- Worked at Client location for P&G in Costa Rica from April 2018 to Dec 2018. Primary responsibilities were gathering requirement from client, creating reports in OBIEE for P&G shipments and Open Orders.
- Worked for client Eaton Corporation in Pune. Primary responsibilities were handling Admin related work in OBIEE, Informatica and DAC.
Education
Bachelor of Science - Computer Science
RAMNARAIN RUIA COLLEGE
MBA - Businee Analytics
MANIPAL ACADEMY OF HIGHER EDUCATION (Pursuing)
ONLINE05-2025
Skills
- OBIEE/ OAC (Oracle Analytics Cloud)
- ETL - Datawarehousing (ODI, Informatica)
- PySpark and Hadoop
- Python
- Snowflake
- Machine Learning
Certification
- AWS Certified Cloud Practitioner
- Oracle Cloud Foundation Associate
- Oracle Autonomous Database
Additional Information
1. USA Business Visa (B1/B2) valid till Oct 2026
2. Worked at Client location in Costa Rica (Central America) in 2018
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Marathi
Upper intermediate (B2)
Timeline
Associate
TIAA GLOBAL CAPABILITIES PVT LTD
02.2023 - Current
Senior BI Consultant
ORACLE GSC
01.2022 - 02.2023
Analyst
TIAA GBS INDIA PVT LTD
08.2019 - 12.2021
Software Engineer
L&T Infotech
05.2015 - 07.2019
Bachelor of Science - Computer Science
RAMNARAIN RUIA COLLEGE
MBA - Businee Analytics
MANIPAL ACADEMY OF HIGHER EDUCATION (Pursuing)
Similar Profiles
Yashraj MohiteYashraj Mohite
Senior Associates at TIAA Global Capabilities Pvt LtdSenior Associates at TIAA Global Capabilities Pvt Ltd
BABU DASBABU DAS
Senior SOC Controller at TIAA Global Capabilities Pvt. Ltd.Senior SOC Controller at TIAA Global Capabilities Pvt. Ltd.
Ishita GuptaIshita Gupta
ASSOCIATE, SPECIALIST - FULL STACK DEVELOPMENT at TIAA Global CapabilitiesASSOCIATE, SPECIALIST - FULL STACK DEVELOPMENT at TIAA Global Capabilities