SQL Developer
ROHAN RANPISE
Senior Manager At Axis Bank (BIU)
New Mumbai
Summary
11+ years Of experience in Banking and NBFC domain. Currently working as Senior Manager at Axis Bank with a proven track record in Oracle PL SQL and code optimization, significantly reducing critical business code execution from hours to minutes. Expert in data engineering and Informatica, I led a team of 5 in PL-SQL/Informatica/Unix/Big Data, enhancing productivity and morale. My leadership and technical skills have been pivotal in automating processes and optimizing code performance.
Overview
12
12
years of professional experience
Work History
Senior Manager
Axis Bank
11.2021 - Current
- Working as Data Engineer in Axis bank. Handling F&A Daily and Monthly reports via Datamart.
- Created Loan fact and dimension table using Informatica ETL for reporting.
- Expert in oracle so always focus on process Automations and code optimization. Fine Tuned critical business code from 1hr/2hr to less than 10 min using oracle collections and parallel process execution.
- Conducted session on PL-SQL Concept/SQL Query writing/Code optimization to entire BIU team(400+ people).
- Provided strong leadership to enhance team productivity and morale.
Senior Consultant
Virtusa Consulting Services
01.2019 - 11.2021
- Worked for the BNP Paribhas as axiom/Oracle developer on regulatory reporting for US and CANADA.
- Primary responsibility are develop the regulatory report logic mentioned in JIRA.
- Optimized existing report complex queries to boost report performance.
- Good knowledge of data Source, Data model, portfolio, Shorthands, workflows.
- Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
Software Engineer
Melstar Information Technology Ltd
11.2015 - 11.2018
- Worked for L&T finance in FINNONE lending application (PL, Retail Loan, Micro Finance)
- Worked on create procedure ,functions, complex queries, SQL Loader for business requirements.
- Created Dimension and Fact for Micro Finance loans.
- Worked with analytics team to build Early Warning Signal system. This help company to check customer financial health.
- Learned code optimization and implemented in procedures and complex queries.
Application Support Engineer
Beltronic Consultancy Pvt Ltd
12.2012 - 10.2015
- Worked for SBI in debit card department
- Managed multiple assignments simultaneously, ensuring all tasks were completed efficiently and accurately.
- Actively involve in card production stages like batch Process, PAN-generation, Pre production, Embossing.
- Generate MIS using SQL and delivered critical reports to banker as and when required.
- Created shell script for process automation.
- Addressed technical issues and guided end users through resolution.
Education
BE (IT) -
Sinhgad College Of Engineering Vadgaon
Pune 04.2001 -
Skills
Oracle PL SQL
Oracle Code Optimization
Informatica
Banking and NBFC Domain
Data Warehousing
Software
Informatica
Unix
Timeline
Senior Manager
Axis Bank
11.2021 - Current
Senior Consultant
Virtusa Consulting Services
01.2019 - 11.2021
Software Engineer
Melstar Information Technology Ltd
11.2015 - 11.2018
Application Support Engineer
Beltronic Consultancy Pvt Ltd
12.2012 - 10.2015
BE (IT) -
Sinhgad College Of Engineering Vadgaon
04.2001 -
Similar Profiles
Lakshay SharmaLakshay Sharma
Deputy Manager at Axis Bank (On Payroll Of Axis Bank)Deputy Manager at Axis Bank (On Payroll Of Axis Bank)
Preethi VPreethi V
Relationship Associate at Axis Bank - Axis Max Life InsuranceRelationship Associate at Axis Bank - Axis Max Life Insurance
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
ANIL BASAKANIL BASAK
Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)
Akash DhumalAkash Dhumal
Jr.BIM COORDINATOR at RA-TECH EngineeringJr.BIM COORDINATOR at RA-TECH Engineering