Oracle PL/SQL Developer

APARNA BELHE

**** ********* **, **** *************: U.S. Permanent Resident (Green Card)

Herndon, VA 20170 Clearance Eligibility: Public Trust Clearance

Cell: 540-***-**** *****.******@*****.***

Over 10+ years of outstanding experience in Software Analysis, Design, Development and Maintenance, Database Recovery and Backup.

Highly skilled in identifying Performance issues, Debugging, Performance tuning, Query tuning using Hints, EXPLAIN PLAN, TKPROF, SQL Trace, Indexing, Partitioning.

Substantial Experience in writing Complex SQLs, PL/SQL Functions and Procedures, Packages, Cursors, Normalization, Database Design, creating Indexes, Triggers.

Proficient in advanced concepts like Data Collections, Bulk Collect and Forall Loop, Dynamic SQL, Exception Handling, Global Temp Table, Nested Tables, External Tables, Advanced Queuing, Analytical Functions and REF Cursors.

Experience in creating mappings/workflows to extract data from source database into various Business Entities using ODI (9i and 10g) as well as SSIS (BIDS).

Excellent knowledge of Agile fundamentals, extensive experience of working in and managing Agile project groups, Task Planning, Workflow Scheduling, Team Mentoring, Customer-in-loop Development.

Technical Skill Set

RDBMS: Oracle 10g/11g/12c, MS SQL Server 2008/2012, MySQL 5.7

Languages: SQL, PL/SQL, C, C++, C#, Perl, Shell scripting (Korn, Bash, C Shell)

Database Tools: Toad, PL/SQL Developer, SQL Developer, RMAN, SQL* Loader, Oracle E-Business

Suite, Data Pump, Erwin, Toad Data Modeler, SSIS, ODI (ODI 9i and 10g), APEX 5.0

Operating Systems: Windows, UNIX (HP/UX, Solaris, AIX, Linux)

Certifications: Oracle 10g Certified SQL Programmer (10g), Oracle 10g Administrator Certified

Associate (OCA), Oracle 10g Administrator Certified Professional (OCP)

Professional Experience

Tata America International Corp (TCS), Washington DC Oct 2016 - Present

Sr. Oracle Developer

Client: World Bank Group

Worked on development and maintenance of 8 different high volume OLTP databases on Oracle RAC

Development and support to all system interfaces and coordination with all project managers/teams/stakeholders to provide specifications for all core modules.

Coordinate with various developers, project teams and analysts to prepare designs for new applications/existing application enhancements and document all processes to ensure effective evaluation of all applications.

Analysis of all technical design documents and development of various PL/SQL packages to provide support to all application developers.

Monitoring complex PL/ SQL packages and designing various relational database objects according to business needs.

Conduct performance tuning using query Optimizer, AUTOTRACE, Execution Plans

Analysis of Oracle sessions, tablespace usage and indexes.

American Reliable Insurance Company, Scottsdale, Arizona June 2015 – Oct 2016

Sr. Database Developer

Developed and maintained Maximsoft – the billing system for property and casualty insurance industry,

Created complex PL/SQL packages and procedures, indexes, triggers to improve the Commissions Process which automated settlement of commissions between the agents, sub-agents and the company.

Conducted performance tuning of complex queries using Explain Plan and TKPROF, thus reducing the execution time of daily processes including the Invoice and Printing Cycle.

Provided production support to iReli and Accounting Design, perform code refactoring, data cleaning (scrubbing).

Worked with Business Analysts and QA team to implement Agile development practices including

project scoping, analysis, design, development, testing, and implementation of applications.

Built Unit and Regression test cases using tools like PL/SQL Developer, Code Tester and managed packaging of applications to QA, UAT and Production Environments.

Accomplishments:

Led the team of 4, for successful development of the Automated Recurring Payment Project.

It involved development of several time-sensitive and complex processes dealing with critical information related to automated payments via Electronics Funds Transfer and insured bank account information.

Improved the insurance agent-insured-company interaction and streamlined the overall payments process.

Discoverture Solutions Inc, Scottsdale, Arizona Sep 2011 – May 2015

Sr. Oracle Consultant

Client: Assurant

Served as a technical lead for a team of 5 for design and development of the Operational Data Storage (ODS) using database objects and complex PL/SQL packages.

Reverse migrated data from DCT, processing it in ODS, migrating it to the downstream system AS/400

Troubleshot, fixed and implemented bug fixes within tight deadlines for ODS.

Researched emerging technologies, development tools and techniques to improve current applications, architectures and processes.

Client: Utica National Insurance Group

Designed Data Warehouse tables and used Oracle Data Integrator(ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses

Configured ODI modules and ELT tools and supported accessible applications

Developed and edited ETL jobs in DW tables, Data Mart tables and Oracle Data Integrator.

Conducted ETL development tuning, examined uncertain glitches, supported Integration testing conditions.

Client: StoneRiver

Managed a team of 4 by performing Requirement Analysis, Modeling and database architectural solutions.

Performed Data Requirement Analysis, Data Modeling and Data Architecture

Developed multiple Stored Procedures using T-SQL & PL/SQL.

Coordinated with the onshore and offshore teams, provided assistance and technical guidance to less experienced team members.

Accomplishments:

Led multiple geographically dispersed teams, for successful implementations of various projects.

Managed the successful completion of over 5 software development projects, involving multiple teams of Business Analysts, Development, QA and UAT

Thrived working in a fast-paced challenging environment, learned and implemented new technologies and gained extensive experience in onsite-offshore business model, Coordinated with multiple off-shore teams

VTLS Inc., Blacksburg, Virginia Sep 2008 – Aug 2011

Oracle Developer / Analyst

Designed and implemented databases for every quarterly release of VIRTUA

Implemented of ERDs using Toad Data Modeler.

Worked in data compiling and analysis using PL/SQL and shell scripts

Maintained Data (Loading, Transfer, Reorganization, Statistics analysis) using SQL* Loader,

Data Pump Export and Import Utilities

Created and maintained, worked on backup and maintenance of development databases using RMAN

Upgraded Oracle 10g databases to Oracle 11g

Provided training and production support to Customer Support Analysts after every release.

Accomplishments:

Successfully developed an automated software framework for migration of the complete product database to a newer version which involved complex shell scripts and PL/SQL packages parsing an XML file and executing the DDL, DML, external executables and scripts in it. It also integrated Hudson to restore a test database using RMAN every hour, running the migration script in above process and checking it against a database state file.

This automation helped VTLS save roughly over 500 annual man-hours previously needed by the development team to manually migrate and test a product database.

Welligent Inc., Norfolk, Virginia April 2007 – May 2008

Oracle Consultant

Developed and maintained - FOCiS, (an Electronic Health Records database product aimed at Maternal Child and Family Support Network) with extensive use of PL/SQL Web Toolkit, PL/SQL stored procedures and JavaScript

Accomplishments: Added a meta data layer between the database and application layers, to automate creation or Oracle web page. It provided the developer with a GUI requiring input of all objects on the page and then automatically created the webpage.

Kirloskar Oil Engines Ltd, Pune, India Sep 2004 – Dec 2005

Oracle Developer / Analyst (Oracle 9i, 9iAS)

Developed and maintained an intranet site for the organization using Oracle 9iAS Portals

Developed Performance Appraisal Application, Capital Expenditure Requisition Application, Leave Application using JSP and implemented it in Oracle E-Business suite (EBS) / Applications

Designed and Developed of ETL mappings using Informatica.

Old Dominion University, Norfolk, Virginia Jan 2006 – Aug 2008

M.S. (Computer Science)

University of Pune, Pune, India Aug 2000 – Aug 2004

B.E. (Computer Engineering)

Contact this candidate