Summary

• An excellent technical expert who knows inner working of behind the Oracle Application suite Fusion middleware, Forms, reports, Database, PL/SQL,SQL etc.
• Written tens of thousands lines of PL/SQL code for packages, procedures and functions to support various UI and batch processing.
• Many years of finance/insurance industry working experience which were built on excellent education in the relevant fields.
• An avid explorer of which provides oracle various instances/versions of Oracle ERP suite.
• Expert in financial modules: General Ledger GL , Accounts Payables AP , Accounts Receivables AR , Fixed Assets FA , Cash Management CE , iExpenses, Workflow and System Administration from an upgrade and production support of Oracle Financials Modules perspective.
• Oracle expert with 18 years of intense hands-on experience in architecting and designing complex oracle applications.
• Application Lead Enhancements and Maintenance for Hartford's policy administration system VISTA which contains over 1200 Oracle tables, 14,000 columns and over 100 million records. The front-end has approximately 140 windows Oracle Forms and over 4000 components. 50 interfacing systems Upstream Downstream
• Expertise in leading on-site/offshore teams and significant contributor to developing onsite-offshore working models that vastly improve project execution efficiency.
• Proven track record in troubleshooting complex and arcane Oracle stability and performance issues for high-transactional databases.
• Strong knowledge of UNIX, Shell and Corn scripting languages.
• Excellent experience in Oracle upgrade Key contributor for 8i to 9i as well as 9i ,10g to 11g migration for The Hartford group .
• Expert in data modeling using multiple tools Rational model and Microsoft Visio .
• Masters Degree in IT Computer Applications.

Tools

• Applications: Lotus Notes, Microsoft Word, Excel, PowerPoint, Project, Access , VISIO, Test Director, PVCS Tracker and Version Manager, VISTA Visual Integrated Systems Technology for Annuities , VAS DST , Business Engine Network BEN , Rational Rose, TOAD, SQL Navigator,SAS, Datastage and Informatica. Oracle Application: General Ledger, Accounts Receivables, Accounts Payable, Purchasing, Fixed Assets, iProcurement, iExpense, Order Management, Cash Management, Oracle Application Processes: Procure to Pay P2P Order to Cash O2C ,AIM: RD20, BP40, BP80, BR100, TE040
• RDBMS: Oracle 6.0/7.1, 7.3/8.0/9i/10g/11i, ENSCRIBE VER D20, Release ID 20.00
• GUI: Developer 2000, Oracle Forms 4.5/5.0/6.0/9i/10g/11g, Oracle Reports 2.5/3.0/6.0/9i/10g/11g, Designer 2000, Visual FoxPro 3.0/5.0, Delphi 3.0, JAVA, VISUAL BASIC, JDeveloper Oracle ADF Business Components and ADF Faces
• Operating Systems: Digital UNIX, Windows 3.x/95/98/NT/2000/XP, Novell NetWare 3.x/4.x, MS-DOS, Tandem's Guardian 90/Himalaya K114 non-stop environment
• Languages: TAL, Tandem COBOL, SCOBOL, C, C , C Builder, Pascal, FORTRAN, Clipper, PL/SQL, SQL and SQL Plus

Professional Experience

Confidential

Developer Lead/Technical Architect

• Senior Oracle Forms 11g Developer/Lead for Converting older version of the forms 6i-10g as well as doing new development using the Oracle ADF/11g. Technology
• Platform: JDeveloper PL/SQL, Oracle ADF Business Components and ADF Faces and Eclipse IDE Strut2, Java and JSP

Confidential

Technical Lead/Specialist

• Selected Achievements:
• Responsible for leading a team of developers and designers in architecting, developing and supporting secure, stable enterprise database applications with heavy transaction loads and significant retrieval operations. Main platform: Oracle DB and developer suite Version 10g and 11g
• Designed and implemented relational database models and storage objects for building Hartford's policy administration system using oracle 1g and 11g application suites forms, reports and PL/SQL .
• Designed and implemented highly scalable/available batch systems using Oracles Advanced Queues.
• Spearhead design and code review sessions for Oracle based applications with offshore vendors for core applications.
• Performed database capacity planning for IT organization.
• Evaluated technology and effort estimates for complex projects and provided expert analysis.
• Significant contributor to the design of on-site-offshore working model for HLI's sourcing vendors IBM, Cognizant, Satyam and Infosys .
• Designed defect management strategy for team.
• Assisted the Project/Program Managers in creating project plans, setting agenda, conducting team meetings and in drafting weekly status reports for distribution to senior management.

Confidential

Senior Developer

• Selected Achievements:
• Lead developer for a number of Oracle applications on a 9i 10g platform and utilized Oracle Forms, Reports, PL/SQL
• Led the development of numerous enhancement and marketing products using Oracle developer suite PL/SQL, Forms, Reports under SDLC methodology
• Gate keeper of Design/Coding standards during application development.
• Assisted in the design and development to convert Oracle applications to support web deployment.
• Evaluated database performance/responsiveness and made necessary changes to improve performance.
• Coded, tuned and optimized SQL queries, functions, triggers, and stored procedures.
• Performed code installations, and upgrades for application databases.
• Configured secondary servers and other highly available environments.
• Wrote advanced scripting utilities to automate batch processes.
• Created and maintained, quality documents for various environment configurations
• Assisted business analysts in scoping and requirements gathering attended meetings with business customers .
• Conducted performance tuning training sessions for junior developers. Resolved complex performance challenges.

Confidential

Oracle Developer

Senior Oracle consultant

Selected Achievements:

• Established Oracle coding standards for IT department.
• Audited code for scalability, robustness, performance, object handling session management.
• Involved in designing and developing backend scripts for interfacing with other systems.
• Involved in altering the database structure and storage parameters this also includes separating the table spaces, creating and altering table spaces .

Confidential

Project Lead

Led a team of 10 developers in developing Y2K conversion modules for the company's most visible and sensitive applications RPG .