Professional Summary:

• Tools/Methods
• SQL,
• PL/SQL,
• XML,
• UNIX Shell Scripting
• Discoverer 4i/9i/10g Admin, Desktop, Viewer and Plus ,
• Reports 10g/9i/6i/2.5,
• Forms 10g/6i/4.5,
• XML, Publisher 5.6.x
• Oracle 11g/10g/9i/8i,
• MS Access
• TOAD, SQL PLUS,
• SQL Developer, SQL Navigator,
• Clear Case, Clear Quest,
• JIRA, Tortoise
• MS DOS, UNIX, Linux,
• Windows 9x/NT/2000/XP/Vista
• clients
• Wells Fargo Home Mortgage
• Ucare
• Priority Health Insurance
• Iowa Foundation for Medical Care
• BESTIT
• Humana Inc
• Blackfoot
• BMC Software
• ITC-ILTD
• Education
• Bachelor of Technology
• Computer Science Engineering,
• JNTU, India.
• relevant Experience
• 11 years of experience in Analysis, Design, Development and implementation of Business Applications using the Oracle Relational Database Management System.

SKILLS INVENTORY

• Expertise in developing and debugging advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Involved in 4 complete SDLC's Software Development Lifecycle performing detailed analysis, requirements gathering, documenting requirements, technical development, unit testing, integration and system testing.
• Hands on experience working in Oracle Data Warehouse environment.
• Hands on experience on Discoverer 10g/9i/4i, Reports 10g/9i/6i/4.5, XML Publisher 5.6.x and Forms 6i/4.5 and also migrated Forms and Reports based on 6i to 10g.
• Strong technical expertise on databases Oracle 8i/9i/10g.
• Experience in performance tuning PL/SQL using SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Good understanding and hands on experience with TOAD, PL/SQL, SQL Plus, SQL Loader, Control Files, Metalink etc.
• Strong analytical skill and problem-solving ability coupled with excellent written, verbal and inter-personnel communication skills.

EXPERIENCE

Senior Oracle Developer

Confidential

• Gathered requirements from Business and Data Analysts.
• Co-ordinated with the architects to make sure that all the Demands and Change Requests have been covered for that particular release.
• Performed an active role in Datastage Decommission project by converting existing modules from Datastage into PL/SQL.
• Re-Designed existing modules to support newer functionalities such as Home Equity Line of Credit and Down Payment Assistance programs.
• Was on production support for completed projects which required both technical and business knowledge.
• Used sql loader and external tables to load data from the files received from Decision Engines onto our database.
• Was point of contact for Data Mapping Repository maintenance to support mapping rule storage and for business approval tracking
• Supported QA and production support team by analyzing the issues that have been raised and transferring them to the appropriate owner.
• Performed unit testing and user acceptance testing.

Environment: Oracle 11g, SQL LOADER, TOAD, Tortoise SVN, Report Builder 10g, PL/SQL, SQL, SQL PLUS, UNIX

Senior Oracle Developer

Confidential

• Gathered requirements from Users and Business Analysts to perform technical analysis.
• Update existing data model to accommodate changes required for new projects.
• Update existing code to make sure that they are more developer friendly.
• Utilized UTL FILE packages to create RAPS files to send to CMS on a monthly basis.
• Performance tuned the existing modules using Explain Plan and SQL Trace to reduce the execution time by fixing sql queries, using partitioning concepts, indexes and hints.
• Performed unit testing and user acceptance testing.
• Present changes to the governance team for approvals and coordinate with the admins for the changes to be promoted to production.

Environment: Oracle 11g, SQL LOADER, TOAD, Tortoise SVN, Report Builder 10g, PL/SQL, SQL, SQL PLUS, UNIX

Senior Oracle Data Analyst

Confidential

• Gathered requirements from Business Analysts to create data mapping rules for developers.
• Co-ordinated with the architects to make sure that all the Demands and Change Requests have been covered for that particular release.
• Re-designed existing data model to eliminate the need for creating individual files for every subject area.
• Converted Datastage modules into PL/SQL packages and rewrote slow performing ETL modules for optimum performance.
• Played a key role in reducing the batch cycle execution time by redesigning and tuning the individual processes to attain more than 300 improvement compared to previous year. This required modification of the load process to load only the data that is being sent downstream, identifying indexes that are supposed to be put in, parallel execution of mutually exclusive processes, fixing SQLs that had bad Explain Plans and by using Bulk Collects.
• Used SCN System Change Number to eliminate the need for staging schema.
• Used sql loader and external tables to load data from the files received from Decision Engines onto our database.
• Supported QA and production support team by analyzing the issues that have been raised and transferring them to the appropriate owner.
• Performed unit testing and user acceptance testing.

Environment: Oracle 11g, SQL LOADER, TOAD, Tortoise SVN, Report Builder 10g, PL/SQL, SQL, SQL PLUS, UNIX

Senior Oracle Engineer

Confidential

• Follow and help establish Application Development, Software Quality Interface, IT policies, procedures, and processes.
• Create various extract processes to send data to external vendors in the form of flat files for auditing purposes in order to adhere to the compliance policies defined by CMS.
• Create APEX pages to provide control to the user to reduce the need for IT involvement for yearly updates to commission rules.
• Created reports such as Commission Verification and Provider Member Count using Report Builder 10g.
• Performance tuned the existing modules to reduce the execution time using indexes, BulkCollect and Associative Arrays.
• Used sql loader and external tables to load data from the files received from partners onto our database.
• Assisted in creation of filemover scripts to automate the movement of files between Oracle UTL directory and the ones that are accessible for business users.
• Performed unit testing and user acceptance testing.

Environment: Oracle 11g, SQL LOADER, TOAD, Tortoise SVN, Report Builder 10g, PL/SQL, SQL, APEX SQL PLUS, UNIX

Senior Oracle Engineer

Confidential

• Gathered requirements to understand the standard procedures being followed to validate data files and run reports.
• Modified existing data model to incorporate lookup tables and loaded them with the reference data from the subversion using sqlloader to improve the overall performance by reducing redundancy.
• Created procedures and functions to perform validation and load error log tables with the records that failed the same.
• Created reports such as submission detail report and submission summary report using Report Builder 10g.
• Performance tuned the existing modules to reduce the execution time using BulkCollect and Associative Arrays.
• Created test cases and performed unit testing and stress testing from time to time to monitor the effect of changes made on the performance of the system.

Environment: Oracle 11g, SQL LOADER, TOAD, Tortoise SVN, Report Builder 10g, PL/SQL, SQL, SQL PLUS, UNIX

Senior Oracle PL/SQL Developer

Confidential

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Coded conversion scripts to and data model patches and coordinated with DBAs for their execution and validation.
• Created custom packages and procedures to perform ETL processes like data loading, transformation, extraction, validation and reporting.
• Utilized UTL FILE packages to create flat files and used SQL loader to load tables for downstream users.
• Modified existing modules by using Bulk Collect, Pl/SQL tables, varrays and other collection types to improve the performance of the system.
• Supported Teamworks developers and created views and stored procedures to aid with their reporting needs.
• Created custom reports such as LIS Reject, Missed Closing Reasons, Loan Tag History etc using Report Builder and Discoverer
• Performance tuned the PL/SQL modules using Explain Plan and SQL Trace.
• Performed unit testing and user acceptance testing and provided support to QA and other downstream systems.
• Wrote technical documents giving an outline of job flows and the process involved.
• Worked with various tools like CDTS Clear Quest , JIRA, Tortoise etc for defect tracking and version management.

Environment: Oracle 10g, SQL LOADER, TOAD, Tortoise SVN, Report Builder 10g, Discoverer 9i, PL/SQL, SQL, SQL PLUS, Datastage, Autosys, UNIX

Senior Oracle PL/SQL Developer

Confidential

• Coordinated with the users in Ecuador and the functional team in Arizona to gather the requirements.
• Designed, Created Tables Constrains, Primary Keys, Foreign Keys, Check Column Values Validities
• Raised Service Requests SR with Oracle and followed up with oracle support and the DBAs for the installation of patches required for XML Publisher.
• Extensively used SQL LOADER utility to load data from flat files obtained from various legacy systems into oracle database.
• Worked on generation of scripts for creation of tables, indexes, views, synonyms, grants, roles and privileges.
• Created a Custom package which exports the invoice data and saves it as pipe delimited format.
• Wrote PL/SQL packages to handle Extract, Transform and Load ETL process
• Developed custom reports such as Annexed Transactions, Withholding Certificates, and Liquidation of Goods and Services etc from scratch using XML Publisher and Report Builder.
• Interfaced invoice data with the Ecuador Government program which required data in XML format.
• Wrote packages to perform invoice validations and load the validated data into Account Payables tables.
• Customized the AP Check Print report by redefining the format and layout to match the Spanish environment.
• Performed printer style setups and layout customization to make sure the character mode report output fits perfectly on pre-printed forms defined by the government.
• Wrote report triggers, format triggers and other pl/sql program units to control the reports execution. Also wrote custom package to export the data in pipe delimited format.
• Performed pl/sql tuning to improve the performance of the reports.
• Documented every setup change and wrote technical Design documents MD-70 for all the reports that have been developed.

Environment: Oracle Applications 11.5.10.2, Oracle 10g, SQL LOADER, Report Builder 9i, XML Publisher 5.6.2, PL/SQL, SQL, SQL PLUS, UNIX

Senior Oracle PL/SQL Developer

Confidential

• Involved in developing warehouse, including requirements gathering, requirements definition, operations analysis, technical design and implementation.
• Used SQL LOADER with the help of Control Files to load data from flat files into ORACLE staging tables
• Designed ER diagrams and performed database normalization.
• Used Bulk Collect, Pl/SQL tables, varrays and other collection to improve the performance of the system.
• Deeply involved in writing ORACLE database objects like STORED PROCEDURES, FUNCTIONS, and PACKAGES using PL/SQL.
• Customized a number of financial reports like Invoice History Report, Invoice Aging Report, Payment Register Report etc in AP using ORACLE Report Builder 9i.
• Worked with Discoverer 10g so users would have the ability to generate ad-hoc reports and also show the data in the form of Excel Files.
• Migrated old forms and reports from 6i to 9i and resolved issues during the process.
• Performed PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Created indexes to improve performance and developed test cases for user acceptance testing and unit testing.

Environment: Oracle 10g, Informatica 7.1, Report Builder 9i, Discoverer 10g, Designer 6i, PL/SQL, SQL, SQL PLUS, UNIX

Oracle PL/SQL Developer

Confidential

• Wrote Control Files to make SQL LOADER push the customer information from external systems into the staging table and merged them.
• Wrote Unix shell script to automatically email error log files generated by stored procedures
• Used SQL loader to load XML data into oracle XML DB
• Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices.
• Used JDBC 3.0 for Oracle database connection and written number of stored procedures for retrieving the data and validated that data against the business rules.
• Interacted with End Users to discuss the design aspects of Discoverer Reports.
• Created new End User Layer EUL for Oracle Discoverer 9i. Created views, business, areas and reports.
• UTL FILE was used to populate into temporary tables, from where PL/SQL program validated and loaded the data into open interface.
• Exported, Imported Oracle DB tables from one schema to another, Used Oracle Data Pump utility, remapping schemas
• Was involved in planning, identifying and mitigating risks during the course of the project
• Used Oracle's latest development tools Oracle Reports, Oracle Discoverer, Oracle Forms and PL/SQL to develop reports, forms and procedures.
• Migrated Forms from 6i to 9i by resolving the issues with attached libraries.
• Reviewed PL/SQL programming logic to enforce client business requirements.
• Performed necessary unit and system testing and document the changes.
• Was involved in writing AIM Finance documents like MD-50,MD-70 etc
• Monitor support related issues for Oracle Financial modules GL, AP, AR and CM

Environment: Oracle Database 9i, XML DB, JAVA, SQL, PL/SQL, Reports 6i, XML Publisher 5.6.2, Discoverer 9i, TOAD