Sql Developer Oracle Pl

Umesh Kumbhalkar

Flat ***, Aster A Wing, Rose Valley,

Pimple Saudagar,Pune-411027

Email: ***************@*****.***

Mobile No.: +91-779*******

PROFESSIONAL SUMMARY:

Over 18+ years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle PL/SQL Development and Data Modeling.

Around 10+ years of Team Leadership experience.

Strong PL/SQL,MSSQL,Performance tunning of objects and Data modelling skills.

Expertise in working with complex SQL queries with joins, date functions, inline views, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports and analyzing existing data.

Performance Improvement of SQL/PL SQL code and improving memory utilization of Relational Database and Data Warehousing Systems. Also, expertise in performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.

Proficient in debugging/testing PL/SQL packages/procedure/function to troubleshoot issues and fixing production issues.

Stong hands on in Conceptual, Logical and Physical data modelling using ERWin and SQL developer Data Modeler.

Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers, Views, Materialized Views.

Complete ownership of database release deployments.

Defined Database Standards and Practices to ensure entire team follows a single standard convention while creating and modifying work products.

Managed an entire application development team as Team Lead for supporting applications and provided end to end support in all phases of SDLC

Oracle Certified Oracle Database SQL Expert.

EMPLOYMENT HISTORY:

Name of the Company

From

To

Duration (months)

Larsen & Toubro (through Fluous Solutions),Mumbai.

Sep 2006

Aug 2008

23

Larsen & Toubro (through Businet-Infinity India),Mumbai.

Aug 2008

Nov 2009

16

Collabera Technology,Mumbai

Apr 2010

Dec 2011

21

Accenture services, Pune

Dec 2011

Feb 2018

73

Zensar Technologies, Pune

Mar 2018

Feb 2020

23

Synechron Technologies,Pune

May 2020

Feb 2021

11

Coforge solutions/ On demand agility,Pune.

Mar 2021

Jun 2025

51

EDUCATIONAL QUALIFICATIONS:

Degree

Institution

Year of Passing

B.E.

C.O.E.A.T, Akola,Amravati University

2001-2005

TECHNICAL SKILLS:

Skills

PL/SQL Development

Data Modeling

Crystal/SSRS report.

Application Database Administration

Production Support

ETL – Informatica power center/SSIS

Application DBA

Databases

Oracle Databasee

MS SQL

T-SQL

Green-Plum

Software:

TOAD for Oracle

SQL Developer

Erwin Data Modeler

SQL Developer Data Modeler

Putty

CantrolM

CERTIFICATIONS:

Oracle Certified Associate (May 2011): Oracle Database SQL Expert

& Program with PL/SQL.

PROJECT EXPERIENCE:

Project Title : Emax move analysis explain market risk

Client: Credit Suisse/UBS,Pune.

Project Duration: ODA/Coforge - Mar 2021 to Jun 2025

Role: Plsql development, Performance tuning and Data Modelling

Role Description: I worked on Oracle PL/SQL development and Data modelling.

Key Responsibilities: Developing PL/SQL verious objects to achieve report creations and other functions.

Created reports configuration at backend and it will be showing front end to analysis.

Developing PL/SQL verious objects to achieve report creations and other functions.

Performed data modelling tasks with ERWIN tool.

Created conceptual, logical and physical data model.

Created Mapping sheet for all entities source and destination with predefined logics.

ETL-Data fetched from the production environment and data loaded into EMAXMR database to generate various reporting.

Created data model with reverse engineering process.

Worked on OLTP/OLAP.

Project Title : Olympus data migration

Client: CITI Bank,Pune

Project Duration: Synecron - May 2020 to Feb 2021

Role: Data Modelling,Plsql development & Performance tuning,

Role Description: I worked on Oracle PL/SQL development and Data design.

Key Responsibilities: New OLAP system (Olympus) created from the existing production environment (OLTP).

Created reports configuration at backend and it will be showing front end to analysis.

Data loaded and generate various reporting

Performed data modelling tasks with ERWIN tool.

Worked on OLTP/OLAP.

Project Title : IAEA.

Client: Vienna(VIC),Astria

Project Duration: Zensar - Nov 2019 to Feb 2020

Role: ETL with MDS(Master Data Services), Data Modelling & Database performance tuning,

Role Description: I worked on ETL, Oracle PL/SQL development and Data modelling.

Key Responsibilities:

ETL-Data fetched from the production environment and data load into CIM(central) database to generate various reporting

Used SSIS tool to Extract data and pushed in the target databse through MDS tool.

Created conceptual, logical and physical data model.

Involved in Data modelling tasks with ERWIN tool.

Worked on OLTP/OLAP

PL/SQL objects creation.

Project Title : Assurant dual store.

Client: ASSURNT

Project Duration: Zensar - Jun 2018 to Sep 2019

Role:PLSQL developer, Performance tuning

Role Description: I worked on Oracle PLSQL development. Also worked on performance tuning.

Key Responsibilities:

Involved in the PL/SQL coding and responsible for end to end deliveries.

Created Crystal report and SSRS reports.

Database performance tunning existing and issues/time taking objects.

Project Description: Dynamic CRM Sales Module Implementation.

Client: AMSOIL

Project Duration: Zensar - Mar 2018 to Jun 2018

Role: Data Modeler and PLSQL developer

Role Description: Data pushing from JD Edwards system to CRM system via Datawarehouse database. I managed data model. Forward Engineered models to generate deployment scripts.

Key Responsibilities:

Analyzed the CRM and DWH objects.

Created required objects for ETL process.

Created conceptual, logical and physical data model.

Used ERWIN tool for data modelling.

Created table/column mapping sheets for all entities.

Worked on OLTP/OLAP

Created database objects with the help of forward engineering process.

PLSQL coding for existing and new objects.

Contributed in SSIS package development and complex SQL query writing.

Project Title: Burlington Coat Factory

Project Description: Order allocation & order assignment.

Client: Burlington DC

Project Duration: Accenture - Apr 2016 to Jan 2018

Role: Oracle Development Team Lead

Role Description: Managed a team of Oracle and Java developers for 8 Applications. As senior developer, designed blueprint of various modules, worked on conception, physical and logical modeling. Forward Engineered models to generate deployment scripts. Involved in end to end project delivery and managed all phases of SDLC.

Key Responsibilities:

Engaged in transporting business needs into conceptual, logical and physical data models.

Created Database design and Data model with help of sql developer data modeler tool.

Created data model with reverse engineering process.

Used ERWIN tool for data modelling.

Created database objects with the help of forward engineering process.

Involved in the PL/SQL coding and responsible for end to end deliveries.

Managed the resources and assignments and get they delivered on time.

Hosted status calls with clients.

Project Title: BT - British Telecom

Project Description: Batch Job Processing.Develope PL/SQL batch jobs for processing bulk data and generate reports.

Client: British Telecom

Project Duration: Accenture - Apr 2014 to Apr 2016

Role: DB Development Team Lead

Role Description: As a senior developer, I created the plan and constructed a number of batch procedures. In addition, I oversaw a group of developers, helping them with a variety of deliverables.

Key Responsibilities:

Responsible to deliver all reports and pl/sql code changes.

Working on development and automation of daily and weekly processes.

KT to new members

Project Title: Order and Server Management

Project Description: Develop and Enhance modules related to CRM system for Vodafone Spain.

Client: Vodafone Spain

Project Duration: Accenture - Jun 2012 to Apr 2014

Role: Production Support team lead

Role Description: Lead a team of Oracle developers to handle complex deliveries for application development and defect resolutions.

Key Responsibilities:

Performance Improvement of SQL/PL SQL code and improving memory utilization of Relational Database and Data Warehousing Systems.

Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning

Performance tuning on oracle database objects.

Project Title: GCAS Web, EDGE, FORCE, NDRT

Project Description: Manage telephone and internet services Installation and Repair Jobs and assign them to field technicians

Client: AT&T

Project Duration: Collabera Technology - Apr 2010 to Jun 2012

Role: Oracle Developer and Application DBA

Role Description: Provide development and Application DBA support for 4 complex applications. Gather Requirement, Data modelling, Schema Deployment and production release deployments.

Key Responsibilities:

Database designing and Data modelling.

Conceptual, Logical and Physical data modelling with Erwin tool.

Oracle pl/sql coding and oracle release deployment

Debugging/testing PL/SQL packages/procedure/function to troubleshoot issues

Forward and Reverse Engineering in Oracle Database.

Project Title: Superannuation Provident Fund (SAF) & Provident Fund

Project Description: Manage provident fund of employees including PF Slips/Statement, EPS Slip/Statement, Masters, Member Query, Integration/Data fetching, merging modules.

Client: Larsen & Toubro Limited

Project Duration: Businet infinity - Aug-2008 to Nov-2009

Role: Oracle PL/SQL Developer

Role Description: Develop and enhance PL/SQL code

Key Responsibilities:

Worked on new developments and code changes requests.

Support existing as well as new applications.

Major changes and existing code defects/bugs fix.

Worked on requirement and full phase implementation

Project Title: Provident Fund Activity (PF) and SAF

Project Description: Development and Enhancement of various Provident Fund modules including PF Slips/Statement, EPS Slip/Statement, Masters, Member Query, Integration/Data fetch, merging

modules.

Client: L&T, Bank of Baroda, Andhra Bank

Project Duration: Fluous solution - Sep-2006 to Aug-2008

Role: Oracle PL/SQL Developer

Role Description: Develop and enhance PL/SQL code

Key Responsibilities:

Worked on new developments and code changes requests.

Support existing as well as new applications.

Identify and work on code changes and defects/bugs fix.

Worked on requirement and full phase implementation.

Additional Work for current organization

Hiring Oracle Database resources

Training New Hires and Application Development Team

AWARDS AND RECOGNITION:

Star Award in July 2020 from Synechron.

Won 250+ Celebrity points from Zensar.

Won 1800+ Celebrity Points for my performance in Accenture.

Spot Awards:

July - 2011 for EDGE/GCAS development work from the database standpoint.

Jan - 2012 for complex work writing the packages, procedures with very good quality and valuable contribution in a team.

Pinnacle Awards:

July - 2011 for EDGE/GCAS development work from the database standpoint.

Jan - 2012 for complex work writing the packages, procedures with very good quality and valuable contribution in a team.

Stellar Constellation Team Award for ‘Organizes Quality Work Efforts!’

Accenture highest Individual Award “Accenture Ace Numero Uno”, 2012

Accenture highest Team Award “Delivery Excellence”, 2013

ABOUT ME!

I am a can-do guy and love to embrace new challenges. I am always keen to learn things and excel in them. I believe in learning through experiences and love exploring new avenues.

I love gardening. My motto of life is “Explore your potential”.

Contact this candidate