Writing Kannada Poems & Stories
Pavan Kumar Ramanna
PLSQL Designer & Developer
Bengaluru,KA
Summary
- 10 years of Total experience in Oracle PLSQL design & development with 2.5 years experience in oracle EBS.
- Experienced oracle PLSQL developer trained in Advanced SQL/PLSQL, GCP, BigQuery, Teradata, QlikSense & Java.
- Built PLSQL product integration with MARKIT to automate report analysis, validation and generation of CRS/FATCA report.
- Conceptualized & delivered onboarding of more than 200 customer & account files spanning across more than 20 source systems.
- Conceptualized & delivered Data Quality Issue Management system to track & record Data Quality issues and their corrections through Star schema.
- Lead a squad of 9 people as a Scrum Master to coach and facilitate adoption of Agile way of working.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
3
3
Certifications
Work History
PLSQL Developer
ANZ Operations & Technology Ltd
Bengaluru, Karnataka
07.2017 - Current
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
- Conceptualized & delivered onboarding of more than 200 customer & account files spanning across more than 20 source systems through ETL.
- Built more than 100 high performing PLSQL packages & functions responsible for 50-60% of user stories in the squad.
- SME of squad for functional and technical solutions.
- Lead squad as Scrum Master to coach & facilitate in adopting Agile way of working.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Developed reusable components such as Report Delivery Framework and Artifacts for exploitation in coding and documentation.
- Awarded with Star recognition several times for requirement gathering through brainstorming, conceptualizing & delivering complex ideas into solutions, sharing knowledge with the team.
Senior Oracle Application Developer
IBM India Pvt Ltd
Bengaluru, Karnataka
11.2014 - 07.2017
- Actively listened to customers, handled concerns quickly and escalated major issues to supervisor.
- Led PLSQL team in delivery of Single Customer View project, resulting in more than 30 java integrated fast, reusable APIs.
- Developed and implemented performance improvement strategies and plans to promote continuous improvement resulting in 60-70% increase in query performance.
- Analyzed existing screens, conceptualize designs by reverse engineering & convert existing non-reusable codes to re-usable APIs.
- Awarded Manager's choice awards, Deep Skill Adder awards and recognized in IBMers appreciation programs.
Senior Systems Engineer
Infosys Pvt Ltd
Mangaluru, Karnataka
03.2012 - 06.2014
- Built Oracle Reports, OAF pages, Concurrent Programs, PlSQL packages, Alerts, Workflows, Lookups through Oracle EBS.
- Technical Consultant on P2P & Account Payables modules.
- Created Detailed Level Designs on Oracle EBS components.
- Awarded BRAVO award for being quick learner and bug free coder.
Education
Bachelor of Engineering - Electronics And Communications Engineering
Ghousia College of Engineering
Ramanagara 07.2007 - 08.2011
Skills
PLSQL Programming
SQL Tuning
Technical Analysis
API design knowledge
Technical Writing
Data Analysis
Agile
GCP
Teradata
UDeploy
QlikSense
Shell Scripting
Certification
Professional Scrum Master
Interests
Mountain biking, Hiking & Trekking
Reading Kannada Books & Novels
Timeline
GCP Professional Data Engineer
12-2021
Teradata Vantage Certified Associate 1.1
01-2021
Professional Scrum Master
04-2018
PLSQL Developer
ANZ Operations & Technology Ltd
07.2017 - Current
Senior Oracle Application Developer
IBM India Pvt Ltd
11.2014 - 07.2017
Senior Systems Engineer
Infosys Pvt Ltd
03.2012 - 06.2014
Bachelor of Engineering - Electronics And Communications Engineering
Ghousia College of Engineering
07.2007 - 08.2011