Objective: To obtain a challenging career opportunity, that would utilize my extensive experience to make highly valuable contributions to an organization.

Technical Skills: Oracle 11g, Reports Developer, PL/SQL, SQL, Toad, Oracle Forms 6i,
APEX, Oracle Application Server 10g,Oracle Reports 6i, Oracle Forms 4.5,
Oracle Reports 2.5, Cygwin, Unix Shell Scripts, Vim, XML, Apache.

Work Experience:

Confidential, Information Technology Department, Chandler, Arizona
Oracle Applications - LeadApr 2011 Current

Responsibilities include the management of incident queues, development and maintenance of Oracle HR and Payroll modules.

• Actively involved in the upgrade of Oracle Applications from 11i to Release 12.
• Developed a PL/SQL program to migrate the fast formulas across instances, this program ensured accuracy and saved 2 man days of manual migration during the time-critical UAT and production.
• Developed a PL/SQL process to migrate the accrual balances from 11i instance to Release 12 using Oracle API’s.
• Developed Oracle Reports for Oracle payroll users to automatically transfer the employer contributions to retirement systems.
• Automated the Cash Management process to load the files from external vendors to a reconciliation table.
• Developed a PL/SQL process to automatically move the benefits with assignment changes.
• Actively involved in developing a Enterprise-wide reporting solution.

Confidential,Chase Home Lending, Phoenix, Arizona
Database Analyst - Team Lead Aug 2003 March 2011

Responsibilities include the management of the data infrastructure team. The tasks include the design, development, implementation and maintenance of data processes and procedures for Chase Home Lending.

• Built an ETL process to manage business rules for Home Lending Originations, this Information is the backbone of the Business Intelligence System.
• Developed a Scheduling Engine using Oracle Scheduled jobs with flexible frequency and dependency built in to the system. The scheduled processes run automatically to provide timely, accurate data everyday by 6AM EST SLA set by the business.
• Developed more than 500 reports using Oracle Reports builder 10g for applications that were originated through E-Commerce Channel. The SQL in these reports were tuned to consistently run under 1 minute.
• Designed and developed a subscription service in Oracle PL/SQL for executive business report users. This design allows the users to get the reports as pdf via e-mail on pre-determined frequencies.
• Designed, developed and implemented a flexible, accurate and reliable Home Equity Portfolio Forecasting model using Oracle PL/SQL, APEX and Essbase. Prior to the development of this new forecasting model, the finance team was using excel spreadsheets based process that was manual, time-consuming, cumbersome and inaccurate.
• Designed and developed views to automatically load the data to analytical OLAP cubes in Essbase. The creation of these views makes the process streamlined, efficient and accurate.
• Designed and developed an application for the maintaining forecasting variables/parameters in APEX.
• Participated on project teams for origination system releases, provided insight on potential issues and suggested possible solutions.
• Managing the Data Infrastructure team. The tasks involved designing new ETL process to build to ensure data integrity and accuracy, guiding team members on projects and assigning new development requests and modifications to team members.
• As a team lead I am responsible for proactively tuning the PL/SQL ETL process to be on top of performance issues if any.

Confidential, Development Services Department Phoenix, Arizona
Programmer/Analyst May 1999 - June 2003

Supported the Development Services Department by automating manual processes and by developing new systems.

• Developed PL/SQL stored procedures and database triggers to populate data from Enterprise Oracle server to MIRS Database.
• Developed a lightweight client application on an Oracle Lite 9i database using Oracle Forms 6i.
• Developed Oracle PL/SQL Spatial stored procedures for calculation of accurate Impact fee amounts from GIS thereby collecting millions of dollars in fees which may have been left out during the issuance of the permit.
• Developed Smart Permitting using Oracle XML to facilitate the sharing of information between the utility companies and the cities thereby speeding up the permitting process and enabling B2B transfer of business information using Java, J Developer and PL/SQL.
• Developed new screens and reports for the KIVA permitting system using Oracle 9i, PL/SQL, Oracle Forms 6i and Oracle reports 6i.

Northwestern Mutual Life Milwaukee, Wisconsin
Programmer/Analyst July 1998 Apr 1999

• Developed Application Input Module in Oracle 7.3 and Oracle Forms 5.0, to automate all the processes involved in floating the Variable Joint Life product.
• Developed Inquiry History Module in Oracle 7.3 and Oracle Forms 5.0 for an improved user interface and to prevent the users from accidentally changing the plan.
• Developed stored procedures in PL/SQL for the Oracle Forms since data was accessed from both Oracle and Sybase databases.
• Developed cron jobs for daily, week-end and month-end reports. Performed system testing and implementation of Inquiry History and Application input modules to meet the product launch plans

Confidential,England Birmingham,UK
Programmer/Analyst March 1997 - June 1998

• Developed Online screens for the customer maintenance modules in Oracle Forms 4.5.
• Developed PL/SQL procedures and database triggers for customer maintenance modules.
• Analyzed and tuned SQL queries in batch operations for improved performance.
• Development of Pure performix scripts for multi-user simulation and volume testing.

Confidential, Pune India. Sep 1995 - Mar 1997

• Preparation of Program Logic Specification, Unit Test Plan of Price & Promotion Module.
• Coding and Unit testing of the forms and reports in the Price and Promotion Module.
• Development and testing of batch procedures and triggers for the Price & Promotion Module.
• Prepared of the Integration and System Test Plans for both the total BERE product and the Price and Promotion Module.
• Impact analysis of change requests raised by the customers.
• Implementation of the Change requests in Stock Adjustments, Miscellaneous Transfer, Sales Analysis, Price & Promotion and Multistage modules.
• Created views for faster access of BERE query screens. The views were based on multiple tables to improve the system performance.
• Analyzed and grouped standalone Oracle PL/SQL procedures and functions in the database into packages for better performance.

Education: Confidential,Institute of Tech & Sciences
M.sc(Tech) Emphasis: Information Systems

Certifications:

Oracle Certified Developer