Oracle pl/sql Developer

PRAVEEN SINGAMSETTI

*** ******* **. ***# ***

Burbank, CA 91504 *************@*****.*** 734-***-****

Senior Oracle PL/SQL Developer with 20 years of extensive experience in System Analysis, Design and development of complex custom applications using Oracle databases and tools in UNIX and Window environments.

Expertise achieved during these many years - 20 years in Oracle PL/SQL, 15 years in Oracle Forms and Reports, 10 years in Unix, 4 years in Data Modeling, 4 years as Oracle DBA, 6 years as Project Leader, 12 years in Query Optimization and Application Tuning, 3 years as on-site Coordinator.

Domain experience – 8 years in Health, 5 years in Manufacturing, 3 years in Banking and 3 years in Insurance Sectors.

Expertise in Data Analysis, Data Extraction, Transformation, Loading, Performance Tuning of Applications and overall management of mission critical database related applications.

Well experienced in SDLC of projects on Client Server, Data warehouse and Web based Applications in Oracle 8, 8i, 9i, 10g and Developer 2000 and Data Modeling.

Extensive experience in developing database objects such as Constraints, Database links, Database triggers, Indexes, Materialized views, Packages, Sequences, Stored functions and procedures, Synonyms, Tables and Views.

Expertise in database query tuning using Dynamic Performance views, Application Performance Tuning by utilizing DBMS_XPLAN and troubleshooting issues on OLTP and DSS systems.

Extensive experience in analyzing the query plans, incorporating query optimization techniques such as Bulk binds, Collections, hints, table partitioning, Result Cache, Analytic functions, to name a few.

Experience in UNIX Shell Scripts using Korn shell for executing PL/SQL code and performing other activities in UNIX.

Experience in leading and managing teams.

Excellent team member with trouble shooting and problem solving capabilities, quick learner, highly motivated, result oriented and an enthusiastic team player.

Possess strong analytical, programming and tuning skills, strong communication and inter personal skills.

Adaptable to perform multi-role activities/projects simultaneously.

Capable of handling deadlines, taking ownership of tasks and multi-tasking.

Ability to stay focused on meeting key deliverables and due dates while remaining responsive to requests for assistance.

Good experience as On-site Coordinator and effective handling of offshore team.

TECHNICAL SKILLS

Database : Oracle 8, 8i, 9i, 10g,11g, 12c

GUI : Developer 2000 Forms 3.0, 4.5, 6, 6i Reports 2.5, 6, 6i

Development/Design Tools : SQL * Plus, SQL * Loader, ERwin, Toad, PL/SQL

Developer, MS Visio 2003, Cognos

Version Control Tools : TFS, Peregrine, PVCS, Star Team, Subversion 1.6

Language : PL/SQL, SQR, Korn Shell Scripting

Operating System : Unix, AIX, Solaris

PROFESSIONAL EXPERIENCE

L.A. Care Health Plan, CA Sep’13 to Dec ‘16

Senior Pl/SQL Developer

Environment: Oracle 11g, Oracle 12c, PL/SQL, UNIX 10

Responsibilities

Single handedly designed and Developed Health Risk Assessment project for SPD, DSNP, CMC, HBEX and Medi-Cal members.

Optimization techniques have been incorporated (during the coding phase) for faster processing such as making use of Bulk processing, providing hints to the queries,

DBMS_XPLAN has been used to analyze the performance of the SQL statements and fine-tuned the queries to minimize the cost.

New performance related features of Oracle12c have been incorporated in pl/sql code for faster execution.

Designed external tables to handle data loading from Flat files and csv files.

XMLTABLE feature was used in queries to extract data from xml files and subscequently loading the data into different tables.

Collaborated with cross functional Business and Technology teams to define project requirements

Incorporated performance related features such as usage of WITH clause for using functions in the query, so as to speed up loading, processing and file generations of Historical Claims, Assessments, Payment files of enrolled members

ADP Camarillo, CA Jun. ’13 to Sep. ‘13

Senior Developer

Environment: Oracle 11.2.0.3.0, PL/SQL, Unix 10

Responsibilities

Performed Data Migration activities to move the data from Easy Labor Management to Work Force Now and Easy Labor Management to Time Labor Management

Identified the bottleneck of slow performing processes and applied tuning techniques to speed up the processes that included query optimization, enforced the usage of cursor variables, Bulk Collection features, bind variables, result cache, etc.

Created data validation scripts to execute after migration from WorkForceNow2 to WorkForceNow5 to ensure accuracy.

Yp.com (yellowpages.com), Glendale, CA Feb. ’13 to Jun. ‘13

Senior Database Engineer

Environment: Oracle RAC 11.2.0.3.0, PL/SQL, Unix 10

Responsibilities

Production support for Listing Database

Performed Query Optimization

Team member in UFO Refactoring project

MAXIMUS, Austin, TX Nov. ’10 to Feb. ‘13

Senior Developer

Environment: Oracle10g, 11g, App Server, PL/SQL, Unix 10, Forms and Reports 10g, MS Visio

Responsibilities

Designed and Developed backend components using pl/sql and forms/Reports for MAXeIE Application .

Evaluated and suggested code changes to increase performance of pl/sql code during Oracle upgrade from Oracle 10g to Oracle 11g.

Interacted with different cross-sectional teams – Configuration Management, DBA and client facing Business Analyst teams for implementation of enhancements/changes.

Medimpact Healthcare Systems Inc., San Diego, CA Jul ’07 to Nov. ‘10

Software Engineer

Environment: Oracle 10g, PL/SQL, Unix, SQR, Oracle Forms and Reports 9i, Java, J2EE, Korn shell scripting

Responsibilities

Designed and Developed backend objects such as stored packages, procedures, functions, Collections, Object Types, DB triggers, Indexes and Collections for MedPreferred Application using pl/sql by enforcing performance features to speed up processing and minimizing context switches between pl/sql and sql engines.

Designed and Developed Prior Authorization Reports/Letters using Oracle Reports.

Extensively used DBMS_XPLAN to identify performance issues in queries.

Fiserv (formerly InsureWorx), Denver, CO Oct ‘06 – July ‘07

On-Site Coordinator/Oracle Consultant

Environment: Unix, Oracle 10g, PL/SQL, Oracle Forms and Reports 9i

Responsibilities

Managed offshore development team and doing code review.

Responsible for gathering Business Specifications directly from the Clients and converting the Specifications into technical documents for offshore team.

Performing Application tuning to increase the performance using DBMS_XPLAN.

ABN AMRO Mortgage Inc., Ann Arbor, MI Apr.’ 05 to Oct. ’06

On-Site Coordinator/Oracle Consultant

Environment: UNIX, Perl, Oracle 9i, PL/SQL, D2K Forms 6i, Reports 6i, Shell Scripts, SQR

Responsibilities

Analyzed, Designed and Developing GUI – Forms 6i and Reports 6i by creating Libraries, Program Units, Menu items, etc.

Designed and Developed HELOC (Home Equity Line Of Credit) Project in Forms 6i.

Identified performance issues using DBMS_XPLAN in Hedge Accounting System- HAS, MUPIT, MOAI applications and resolved them by optimizing the queries and modifying procedures and functions accordingly.

GE-Aircraft Engines, Cincinnati, OH, U.S. May ’03 to Mar. ‘05

Lead Developer

Environment: Unix, Perl, Oracle 9i, PL/SQL, Developer 2000 Forms and Reports 6i, Cognos, Informatica

Responsibilities

Designed and Developed Forms 6i, Reports 6i, created DB objects - Packages, Procedures, Functions and triggers in pl/sql enforcing optimizing techniques.

Performed Query optimization on materialized views and queries in packages and procedures using DBMS_XPLAN.

Handled the roles of On-site Coordinator and Project Lead effectively.

Created reports using Cognos reporting tool.

New India Assurance Company Ltd, Mumbai, India Nov.’01 to May ‘03

Project Leader, Oracle DBA

Payroll and HRMS System

Environment: Unix, Oracle 9i, Forms and Reports 6

Responsibilities

Project Lead and solely responsible for implementing this project at Head office and coordinating with other 26 regional offices (located across India) for implementing and then providing post implementation support.

Designed and Developed Income Tax module incorporating performance related features for faster payroll processing.

Performed Data extraction from the old system, validated the extracted data, applyied business rules and then loaded into the new system.

Performed Oracle DBA activities – Database creation, importing of data, Performing Backup on regular basis and Recovering of database during DB crash.

Unit Trust of India Investor Services Limited (UTIISL), Mumbai, India Jul. ’01 to Oct. ‘01

Oracle DBA, Data Modeler, Lead Developer

UTIISL Call Center System

Environment: Linux 7.1, Web Server: Apache 1.3.19, Application Server: Tomcat

Database Server: Oracle 8i Development Tool: Java 2, Database Design Tool: ER-Win 3.51

Responsibilities

Co-ordinated the meeting with Business for requirements and designed the system using Er-Win.

Performed Oracle DBA activities and implemented the new system at the client site.

Extracted the data from the existing databases and uploaded into the new system after required validations.

Reserve Bank of India, Mumbai, India Apr. ’00 to Jul. ‘01

Oracle DBA, Project Leader

RBI – Master Office File system

Environment: Oracle 8i, Developer 2000, Forms 6.0, Reports 6.0, SQL*Loader

Responsibilities

Designed and developed the Forms for various modules, created Oracle Reports and various DB objects.

Performed Oracle DBA activities and optimized the queries and fine tuned packages.

Performed data extraction from existing system and loaded into the new system after data validation using Control files for SQL *Loader.

Laffarge Cement, Jamshedpur, India Jan. ’99 to Dec. ‘99

Project Leader, Data Modeler, Oracle DBA

Payroll system

Environment: IBM RS-6000, Oracle 8i, Developer 2000 - Forms 4.5, Reports 2.5, ERwin

Responsibilities

Designed and Developed forms to capture data relating to employee details, leaves, loans & savings.

Incorporated master detail relationship in the forms wherever necessary, so as to ensure proper insertion & updation of data in different tables and to maintain data integrity and done performance tuning by applying optimization techniques.

Tata Steel, Jamshedpur, India Jan. ’98 to Dec. ‘98

Lead Developer, Oracle DBA, Data Modeler

Equipment Maintenance System

Environment: Oracle 8, Developer 2000 (Forms 4.5, Reports 2.5), ERwin

Responsibilities

Gathered Requirements, designed and developed screen programs for equipment details, complaint handling, Annual maintenance contract details, rectification details and spares changed.

Extracted the required data from different databases and uploaded into the new database after performing validations using SQL*LOADER.

TISCO Collieries, Dhanbad, India Nov. ’96 to Oct. ‘97

Lead Developer, Oracle DBA, Data Modeler

Computer Aided Weightment System

Environment: Unix 5.3.2.1, Oracle 8, Developer 2000 (Forms 4.5, Reports 2.5), Er-win

Responsibilities

Requirements gathering, feasibility study and Designing the tables using Er-Win.

Coded Screen programs - Forms, Reports and different database objects in Pl/SQL.

Implemented the System at the client site and providing post implementation support.

Awards/ Achievements

Awarded a letter of appreciation by

1.TISCO (client) for developing Computer Aided Weighment System, July 2007

2.New India Assurance Company for Development, Implementation and Production Support/Enhancements of the Payroll Module across all regional offices and increasing the performance of Salary and Income Tax processes in September 2002

3.Award from Maximus Management for MAXeIE Project.in October 2012.

4.Bravo Awards from L.A. Care Health Plan for different projects.

Education

Completed M.C.A. (Master of Computer Applications) from National Institute of Technology, (Formerly R.I.T) Jamshedpur, India in 1996.

Studied Masters (Master of Science) in Physics with Laser and their Applications as a major in the years 1991-1993 at National Institute of Technology, (Formerly R.I.T) Jamshedpur, India.

Publications

."Fresnel's Biprism as an interferometer" - Communications in Instrumentation, Praveen S and Ananda Rao S., C.S.I.O., Chandigarh, India. 6:1, pp 34-39(1998).

Contact this candidate