Resume
Sign in
Email

Senior Oracle pl/sql Developer

Location:
United States
Posted:
October 02, 2013
Email:
ab9lv2@r.postjobfree.com
Contact Info:
*************@*****.***


PRAVEEN SINGAMSETTI
*** ******* **. ***# ***
Burbank, CA 91504 ab9lv2@r.postjobfree.com
734-***-****

Profile:
. 17 Years - IT experience
. 17 Years - PL/SQL Programming experience
. 7 Years - Data Modeling experience
. 8 Years - Unix Shell Scripting experience
. 9 Years - Query Optimization and Application Tuning experience
. 8 Years - Oracle Forms 4.5/6i, Reports 4.5/6i experience
. 7 Years - Project Lead experience (1996-2003)
. 3 Years - On-site Coordinator (2004-2007)
. 7 Years - Oracle DBA (1996 - 2003)
. 8 Years - Domain experience in banking and insurance sectors
. 5 Years - Domain experience in Healthcare sector

Summary:
. Expertise in Data Analysis, Data Extraction, Transformation, Loading,
Performance Tuning of Applications and overall management of mission
critical database related applications
. Excellent team member with trouble shooting and problem solving
capabilities, quick learner, highly motivated, result oriented and an
enthusiastic team player.
. Well experienced in SDLC of projects on Client Server, Web based and
Data warehouse based applications in Oracle 8, 8i, 9i, 10g
. 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.
. Expertise in Application Tuning by incorporating query optimization
techniques such as using Bulk SQL, Bulk binding, Collections,
providing hints, table partioning.
. Good experience of On-site Coordinator and effective handling of
offshore team.

Technical Skills
Oracle PL/SQL, SQL, Oracle Forms 6i/4.5/3, Reports 6i/3/2.5,
Database Design (Physical and Logical), Database
Modeling, Performance Tuning, Query Optimization,
Export/Import Utilities
Databases Oracle 10g/9i/8i/8.x/7.x
Programming SQL, PL/SQL, Developer 2000 (Forms 6i/4.5, Reports
6i/3), Korn Shell Scripting, SQL*Loader, SQL*Plus,
Pro*C, SQR
Environment MS DOS 6.22, Windows 3.x/95/98/2000, Windows NT 4.0,
Red Hat Linux, DOS, Windows 98/NT/2000/XP, AIX, Unix
Reporting and BI Informatica, Cognos, Impromptu
tools
Data Modeling Erwin, Toad Data Modeler, Microsoft Visio 2003
Tools
Version Control Peregrine, PVCS, Star Team, Subversion 1.6
Tools

PROFESSIONAL EXPERIENCE

ADP Camarillo, CA Jun'13
to Sep'13
Senior Developer, Data Modeling
Environment: Oracle 11.2.0.3.0, PL/SQL, Unix 10
Responsibilities
. Data Migration from Easy Labor Management to Work Force Now and Easy
Labor Management to Time Labor Management
. Part of Development team for Data Migration in Agile Environment and
attending daily Scrum Meetings
. Optimizing the queries and inculcating performance related features
for faster execution of procedures
. Work closely with other team members and client representatives to
meet the system requirements and business objectives of the client
. Identified the areas for improving the performance of Data Migration
. Enforced Bulk Collect features for faster execution
. Added features of Locking and un-locking the client during Data
Migration
. Participate in Design and technical meetings
. Created script for Verification of Data after migration from
WorkForceNow2 to WorkForceNow5.
. Designed Workflow tables in TLM5 (Time Labor Management) Schema using
Toad Data Modeler
. Designed Process Flow for migrating clients from Easy Labor Management
to TLM5 (Time Labor Management)

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
. Query Optimization
. Part of UFO Refactoring project team
The existing system contains data that is non-relational and de-
normalized with one record per business listings. Due to increasing
volume, Refactoring has been initiated so as to manage the data
effectively. This has been achieved by moving the columns to its
component tables and each component table being identified either by
yipid or listing id.
Indexer_full table has all the partitions with full set of data for
each partition and indexer_full_today table has the capability to
point to the latest partition and available for exposing to downstream
systems.

MAXIMUS, Austin, TX Nov. '10 to Feb '13
Senior Systems Analyst
Environment: Oracle - DB Server 10.2.0.4, App Server - 10.1.3.5, PL/SQL,
Sun Solaris Unix 10, Java JDK 1.5, Flex, Microsoft
Visio 2003, Forms 6i
Responsibilities
. Perform Production monitoring and Support for MAXeIE System
. Work on enhancements/development of MAXeIE related SR's(Software
Request)
. Evaluation of upgrading Oracle 10g to 11g in progress
. Help other developers during development/enhancements by providing
flowcharts and use cases wherever necessary.
. Interaction 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 Oct. '10
Software Engineer
Environment: Oracle 10g, PL/SQL, Unix, SQR, Oracle Forms, Java, J2EE, Korn
shell scripting
Responsibilities
. Responsible for all the enhancements/maintenance work relating to
Prior Authorization Reports/Letters and MedPreferred Application.
. Designed and developed Screen Programs in forms 6i
. Developed back end interfaces using PL/SQL stored packages,
procedures, functions, Collections, Object Types, DB triggers, Indexes
and Collections.
. Performing data analysis and generate ad-hoc reports for the queries
by the business users and business analysts relating to Claims
processing and Prior Authorization Modules.
. Providing technical assistance to other team members who are in need
of help.
. Voluntarily performing application tuning by increasing the
performance of different processes by optimizing the queries,
incorporating Bulk SQL and Bulk Binds and using Explain Plan.
. Creating Run Books for application support team to understand the
application and providing solutions for the expected problems.

Fiserv (formerly InsureWorx), Denver, CO Oct '06 -
July ''07

On-Site Coordinator/Oracle Consultant
Environment: Unix, Oracle 10g, PL/SQL, Power Builder 7
Responsibilities
. Managing offshore development team and doing code review.
. In charge of gathering Business Specifications directly from the
Clients and converting the Specifications into technical documents for
offshore team.
. Holding Client meetings on a weekly basis to collect requirements and
suggested modifications.
. Code Review, Verification and Testing of the Code before delivery
. Performing Application tuning to increase the performance using
Explain Plan.
. Holding teleconference calls with offshore team at nights to explain
the requirements and providing technical guidance.

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

Oracle Consultant
Environment: Unix, Perl, Oracle 9i, PL/SQL, Developer 2000 Forms 6i,
Reports 6i, Shell Scripts, SQR
Responsibilities
. Gathering Requirements, Analyzing, Designing and Developing GUI -
Forms 6i and Reports 6i by creating Libraries, Program Units, Menu
items, etc.
. Major contribution on HELOC (Home Equity Line Of Credit) Project in
Forms designing and coding.
. Performing Performance tuning on Hedge Accounting System project by
using Explain Plan.
. Developed Perl scripts and used PL/SQL to code database objects.
. Took up additional responsibility of creating RFC's, helping SCM in bi-
weekly production releases.
. Working on multiple projects simultaneously - PreClose and WholeSale
Minors (MUPIT, MOAI Applications).
. Performing application level performance tuning using Explain Plan.

GE-Aircraft Engines, U.S. May '03 to Mar.
'05
Lead Developer
Environment: Unix, Perl, Oracle 9i, PL/SQL, Developer 2000 Forms 6i,
Cognos, Informatica
Responsibilities
. Designing and developing Forms 6i, Reports 6i, writing PL/SQL code for
DB objects - Packages, Procedures, Functions and triggers.
. Managing the entire SDLC of one project single handedly.
. Materialized Views creation
. Performing Query optimization on materialized views and queries in
packages and procedures.
. Holding client meetings and interviewing the users during requirement
phase.
. Documenting the requirements, creating technical specs. and assigning
work to the offshore team
. Handling the roles of On-site Coordinator at onsite and Project Leader
at offshore.
. Doing code review, creating test plans and testing.
. Creating reports using Cognos reporting tool.
. Creating Database triggers to incorporate the business logic.
. Taking additional responsibility of mentoring and providing training
on query optimization and performance tuning using Explain Plan to
different teams.

New India Assurance Company Ltd, Mumbai, India Nov.'01 to
May '03
Project Leader, Oracle DBA
Payroll and HRMS System
Environment: Unix, Oracle 9i, Visual Basic 6.0, Crystal Reports 7.0
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.
. Requirement gathering and client interaction throughout the SDLC of
the Project.
. Designing and Developing of Income Tax module and also incorporating
application level tuning principles for payroll process optimization.
. Performing Data extraction from the old system, validating the
extracted data, applying Business rules to this data and then loading
the data into the new system.
. Performing Oracle DBA activities - Database creation, importing of
data, Performing Backup on regular basis and Recovering of database
during DB crash.
. Assigning tasks and doing code-review of other team members.
. Developing DB objects - Packages, Procedures and Functions using
PL/SQL.
. Writing Unix shell scripts.
. Suggesting lot of enhancements to the Payroll system during
maintenance phase and thereby bringing more revenue to my employer.
. Incorporating new changes as per Indian Tax laws for the new financial
year.
. Preparing User guide for this application.

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
. Gathering requirements from users and Data Modeling using Er-Win.
. Performing the roles of Oracle DBA and implementing the new system at
the client site.
. Extracting of data from the existing databases and uploading into the
new system after performing necessary validations.
. Creating database objects - Database triggers, Packages, Procedures
and functions using Pl/SQL.
. Implementing the new system at the client site.

Reserve Bank of India, Mumbai, India Apr. '00 to Jul.
'01
Oracle DBA, Project Leader, Data Modeler
RBI - Master Office File system
Environment: Oracle 8i, Developer 2000, Forms 6.0, Reports 6.0, SQL*Loader

Responsibilities
. Designing and developing most of the Forms, Reports and various
backend objects.
. Performing Oracle DBA activities.
. Implementing the system at the client location and providing post
implementation support.
. Performing data extraction from existing system and loading data into
the new system after data verification
. Involving in the entire SDLC of the project.
. Providing Form access security in all the screen programs.
. Optimizing all the procedures by incorporating PL/SQL tables and
other optimizing techniques.
. Independent handling of two modules - Census Updation and Bank
Merger.
. Implementing the system at the client location and providing post
implementation support.
. Creating Control files for SQL *Loader to load and validate the data
in interface tables.
. Extracting the data from existing system and after data verification,
loading into the new system.
. Preparing user manual and steps to be taken for regular backup and
recovery of the system.

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
. Designing and developing forms to capture data relating to employee
details, leaves, loans & savings.
. Incorporating master detail relationship in the forms wherever
necessary, so as to ensure proper insertion & updation of data in
different tables and to maintain the integrity of data.
. Developing reports of attendance ledger, muster roll, pay slip, Bank &
LIC statements.
. Performing performance tuning by applying optimization techniques.
. Getting associated with the entire SDLC of the project.
. Doing code mapping of various allowances and deductions in payroll
system- Assigning new codes to the existing codes in different
systems/ locations.
. Attending client meetings and designing the system using data modeling
tool - Er-Win.
. Assigning work to other team members and providing technical
assistance when needed.
. Incorporating security features at the application level to restrict
or permit users for accessing information/forms/reports depending upon
his or her authorization level.
. Incorporating Professional Tax logic to the employees working at
Sonadih.

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
. Requirement gathering, designing and developing screen programs for
equipment details, complaint handling, Annual maintenance contract
details, rectification details and spares changed.
. Extracting the required data from different databases and uploading
into the new database after performing validations using SQL*LOADER.
. Extracting the required data from different databases and uploading
the same into the new database after performing validations.

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
. Gathering requirements from the client and feasibility study.
. Designing the tables using Er-Win.
. Coding Screen programs - Forms, Reports and different database objects
in Pl/SQL.
. Writing Unix Shell Scripts to capture the weight from the weightment
system and inserting in database table.
. Creating test plans, performing unit and integration testing.
. Implementing the System at the client site and providing post
implementation support.

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.

Awards/ Achievements/ Publications
Awarded a letter of appreciation by
1. TISCO (client) for developing Computer Aided Weightment System, July
2007
2. NIACL 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,
September 2002
3."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).