SUMMARY:

• Almost 16 years of experience in Oracle Applications in operations area on versions Release 12 and 11i, specializing in Technical and functional knowledge of Oracle Financials, manufacturing modules.
• Expertise in Conversion, Implementation and Customization of various modules including Accounts Payables(AP), Purchasing, General Ledger(GL), Accounts Receivable(AR), HRMS, OTL, Order Management, Confidential, Inventory and AOL
• Customization, Enhancement of Oracle Applications release 12 and 11i (11.5.3/5/7/8/10 ) Forms and Reports.
• Define, customize and setup of Flex fields, Oracle Alerts, Oracle Workflows.
• Experience in migration, Conversion, developing interfaces between Oracle Financials, Order management and Manufacturing with legacy systems.
• Extensively used API’s in conversions - followed map, validate, error trapping, loading processes.
• Used AOL (Applications Object Library) and Template for all custom GUI development.
• Experience in successful implementation and customization of oracle applications Release 12 and 11i (11.5.x).
• In-depth knowledge of Oracle Applications interface tables and API’s.
• Strong SQL and PL/SQL development experience (creation of packages, procedures, functions, database objects, etc.).
• Worked with business team for creating functional (MD050) and technical (MD070) design document for implementing the Order to Cash cycle.
• Developing and executing unit test scripts to ensure correctness of the implementation.
• Preparation of documentation for design, source code, unit test plans, integration testing, release notes, requirement reviews, design reviews, technical, user Manuals and User Training.
• Strong interpersonal skills, ability to interact with people at all levels.
• Experience in dealing with clients, understanding their requirements and also handling a Team.

TECHNICAL SKILLS:

ERP: Oracle Applications Release 12 and 11i ( OM, INV, Confidential, GL, AP, AR, HRMS, OTL and AOL etc.)

RDBMS: Oracle 10g/9i/8i/8.x/7.x

Programming Languages: SQL, PL/SQL

Software: SQL, PL/SQL, Oracle, Developer 2000 (Forms 4.5/6/6i/10g, Reports 2.5/6/6i/10g).

Development Tools: Developer 2000, TOAD, Cognos Impromptu, Discoverer, Formscape, PVCS, Merant, SVN

Migration Tool: Kintana

Methodologies: Application Implementation Methodology (AIM)

Operating Systems: Windows XP/NT/2000/98/95, UNIX, Sun Solaris.

WORK EXPERIENCE:

Confidential

Project Manager

Responsibilities:

• Team management
• L1/L2 effort Estimation
• Code Reviews
• QA/UAT support
• Modeling functional requirements into Technical solutions
• Preparation of Techincal design documentsDevelopment and unit testing of misc. RICE components.
• Heading technical team and implementing the AGILE methodolody using sprints to deliver periodic releases to production environment.

Environment: Oracle Applications 12.2.4 - Order Management, Inventory, Receivables, PL/SQL, TOAD, Oracle Forms/Reports 10g.

Confidential, Carlsbad CA

Programmer/ Analyst

Responsibilities:

• L1/L2 effort Estimation
• Code Reviews
• QA/UAT support
• Modeling functional requirements into Technical solutions
• Preparation of Techincal design documentsDevelopment and unit testing of misc. RICE components.
• Heading technical team and implementing the AGILE methodolody using sprints to deliver periodic releases to production environment.

Environment: Oracle Applications 12.0.6 - Order Management, Financials, Inventory, Receivables, PL/SQL, TOAD, Oracle Forms/Reports 10g, Oracle BI Publisher.

Confidential, San Jose CA

IT Analyst

Responsibilities:

• Subject matter expert for Software Attach Rate, Software Installation Identifier(SIID) and RMA EE(Excluded Entitlement), responsible for interacting with business for analysis, design, development and implementation.
• Responsible for coordination between onsite and offshore team.
• Meet with business to provide status updates and for any new requirements/enhancements.
• Enhancement and maintenance of Entitlement Business Control (EBC) repository from Oracle Service Contracts, Customer Support (SR), RMA (Service Orders) and Install Base and help business to control false entitlement attempts made by customers. Design and implement ETL strategies for SIID(Software Installation Identifier), Software Attach Rate and TAC C+PFG weekly reporting.
• Enhancements on Sales Ops Repository to support Siebel Analytics reporting capabilities.
• Impact analysis of various code releases with in C3/CIBER/EDW/ODS/SWIFT with respect to EBC repository.
• Analysis of contract segmentation for various program rollouts.
• Enhancement to Entitlement Email Engine (E3), The Entitlement e-mail Engine provides communication channel mainly to notify customer about the issues related to Entitlement. Additionally, it escalates data integrity issues found during Entitlement Processing to Cisco internal team, which has helped the business to communicate and understand failed entitlement attempts.
• Design & develop various reports for Confidential - Entitlement Team.
• Analysis of various third party tools which can be integrated with EBC.

Environment: Oracle Applications 11.5.10 - Order Management, Service Contract (OKS), Core Contracts (OKC), Installbase (IB), PL/SQL, TOAD, SQL*Loader, Sun Solaris

Confidential

Responsibilities:

• Writing interface programs
• Migration of Customized Forms, Reports and Legacy Interfaces
• Also working as onsite coordinator for Interface track with responsibility to help resolve any open issues/queries with development/testing of interface objects and chairing meetings, with the developer and the functional owner, for initial knowledge transfer, query resolution and playback session.
• Writing stored procedures and functions using PL/SQL - Involved in bug fixing, development of new code (if needed) to close any open issues, surfaced while unit/system testing.
• Technical design/Unit Test Plan creation & Unit/system integration Testing
• Writing technical design documents based on the functional designs provided by the client. Also involved in creating test plans using test director and performing unit/system testing. Involved in creating promotion packages in Mercury’s IT Governance tool.
• Loading the legacy journals into 11i using the customization on the Journal Import program (GL Bus), used External tables to load legacy data into 11i instead of SQL*Loaded along with the GL conversion team, designed Journal error correcting form for correcting the error records and reporcessing them using Gl-bus.
• Involved in writing materialized views for the Operational Data Store team, wrote PL/SQL package for periodic refresh(fast/complete) of the materialized views.
• Unit, Integration and System Testing of custom components including forms, reports and Interfaces.

Environment: Oracle Applications 11i, Developer 2000, Windows XP, Linux, Toad, PVCS, Kintana, Citrix server

Confidential

Technical Team Lead

Responsibilities:

• Writing interface programs, Reports, Promotion packages - was involved in writing interface programs for various modules.
• Developed several reports using Reports 6i
• Creating promotion packages to migrate the custom objects to different instances using FNDLOAD and unix shell scripts.
• Writing stored procedures and functions using PL/SQL - was involved in writing database packages for various reports and interfaces.
• Unit Test Plan creation & Unit/system integration Testing - was involved in creating unit test plans and executing them, was also involved in peer testing and reviewing of the objects created by fellow developers.
• Onsite/Offshore co-ordination - worked as onsite coordinator for a couple of months and was involved in helping developers (working offshore) to get the queries answered from their onsite counterparts in time, was also responsible for conducting regular team meetings, to get the object statuses, and to update the managers about the progress on the project and to give them some visibility about the expectation from the client.
• As a technical team lead, was responsible for timely delivery for quality objects, code and quality review of the objects, chairing team meetings, helping developers technically and emotionally.

Environment: Oracle Applications 11i, Developer 2000, Windows XP, Linux, Toad 7.6, PVCS.

Confidential, San Jose, CA

Track Lead

Responsibilities:

• Writing interface programs
• Writing stored procedures and functions using PL/SQL
• Unit Test Plan creation & Unit/system integration Testing
• Bug fixing and issue resolution for the objects in SIT and CRP instances, closed various defects
• Re-Registration of AOL Components such as Concurrent programs, Messages & Profiles.
• Unit, Integration and System Testing of custom components including forms, reports and Interfaces.
• Overseeing the Quality procedures related to the project.

Environment: Oracle Applications 11i, Developer 2000, Windows 2000, Unix, Test Director 8, Toad 7.6, PVCS.

Confidential

Programmer Analyst

Responsibilities:

• Design & development of modules for different departments like sales, planning, stores etc and integrating it, was involved in information gathering from the user from various departments, educating them on the new system and providing support to the non-technical users.
• Designing of forms and reports - developed various forms and reports using Forms 4.5 and Reports 2.5 for the different departments of defense production division of ITI.
• Loading data from legacy system into Oracle - used sql*loader to load legacy data into oracle, wrote control files, and packages for required custom validations in oracle.
• Writing triggers, stored procedures and functions using PL/SQL

Environment: Developer 2000 Forms (4.5/6) and Reports (2.5/6), Oracle 7.x/8