SUMMARY

• 10 years of functional and technical experience in Oracle Finance and SCM Modules (AP, AR, PO, GL, AGIS, FA, Cost Management, OM, Inventory) as a Senior Oracle Techno - Functional Consultant.
• Has worked in several Oracle modules assignments as a team lead/coordinator that included various Implementations, Developments, Enhancement to existing Implementation, R12 Upgrades and Support.
• Solid Expertise in Oracle 11i and R12 e Business Suite modules like AP, AR, PO, GL, SLA and AGIS.
• Worked on both 11i and R12 environments as Techno Functional Consultant.
• Has implemented end to end cycle for AGIS process of my Client and also automated whole AGIS process by designing various AGIS Interfaces in order to integrate wif AP,AR and GL modules.
• Has worked in Inventory and PO Module as part of SCM assignments in both 11i and R12 environment.
• Has worked on India Localizations Development projects.
• Strong Knowledge and domain experience in Oracle Finance and SCM modules wif Technical and Functional expertise.
• Successfully worked wif clients in the Manufacturing, Shipping and Travel Industries.
• Technical Expertise in PL/SQL, Interfaces (Inbound and Outbound),Conversions, Oracle 6i,Oracle Workflow, Oracle XML Publisher Reports and RDF Reports
• Expertise in Performance Tuning of Various Components from AR, GL, SLA, AGIS and Cost Management Modules.
• Extensive experience in all phases of full life-cycle Oracle Application implementation (me.e. Definition, High Level Design, Detail Design, Development, Deployment, Testing, Integration and Maintenance
• Proficient wif documentation using Oracle AIM Methodology (me.e.MD50, MD70, MD120, TE20) or any other client specific implementation methodology.
• Created detailed test plans/scripts and has successfully coordinated all the testing cycles; unit testing, system integration testing, system testing and user acceptance testing (well versed wif both manual and automated testing).
• A strong team player wif excellent planning, analytical and interpersonal skills related to gathering of business requirements, documentation, developing functional designs, providing functional solutions, system configuration and training end users.
• Strong communication skills wif a proven ability to interact wif end users, developers, project management and executive management.
• Exceptionally well organized wif strong work ethics and willingness to work persistently to achieve employer objectives and always delivered on time.
• Ability to quickly adapt to changing environments professionally and personally.

TECHNICAL SKILLS

Operating Systems: Windows 7/ME/XP/2000/98/95, Linux

ERP Package: Oracle Applications (12.1.3, 12.1.2, 11.5.10.2,11.5.10) R12-AP,AR, PO, GL, OM, AGIS, Cost Management R11 - AP, AR, PO, GL, Inventory, OM

Programming Languages: SQL,PL/SQL, Unix

Database: Oracle9i, Oracle 10g, Oracle 11g

Oracle Tool: SQL Developer, PL\SQL Developer, Report Builder, Work Flow Builder, XML Publisher

Other Tools Worked on: Microsoft Office Suite 2003,07,10 - MS Office, MS PowerPoint, MS Excel, MS Access, MS Project, MS Vision, Data Loader Professional, SQL Loader

Ticketing Tool: BMC Remedy 7.1, BMC Remedy 8.1

Special Tools: Serena Dimension Express Code Repository, Kintana Migration Tool, WinScp, Putty, HPQC Quality Centre (Defect Management Tool), Citrix Job Scheduler Tool, Clear Case Version Control Tool.

Documentation Methodology: Aim- Application Implementation Methodology, Agile, etc

Technical Area: Oracle Interfaces, Oracle Conversions, Oracle Workflow, Oracle XML Publisher Reports, Oracle RDF Reports, Oracle SQL Loader

Basic Understanding: System Administration, Oracle (SQL,PL/SQL),XML Publisher

PROFESSIONAL EXPERIENCE

Confidential

Oracle Techno Functional Lead

Responsibilities:

• Supported Existing Standard and Custom system functionalities.
• Worked on Support assignments in Oracle modules which involve working and resolving wif tickets, Creating Change Requests for migration of resolved incidents and tickets to Production environment.
• Analysed business requirements through MD50s for new enhancements.
• Developed components as per the business requirements.
• Conducted Unit Testing as per the Unit test cases given.
• Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms.
• Worked on performance tuning of few components in Oracle.
• Worked on small enhancements in Oracle 11i SCM modules.
• Worked directly wif clients to gather business requirements, understand their issue and to halp them in understanding Oracle functionalities as and when needed.
• Mentored juniors and team members and halped them in issues related to various assignments in Oracle Modules.
• Helped Team members in understanding the business requirement documents and designing Technical design document of various components.
• In depth knowledge of Oracle Applications modules, including functionality and underlying database tables.
• Interacted wif Oracle Support Team for various Oracle standard Issues. Created SR wif Oracle and followed the steps mentioned by Oracle for many Oracle standard issues.

Confidential

Oracle Financial Functional Consultant

Responsibilities:

• Analysed business requirements through BRDs.
• Prepared MD50 as per the business requirements.
• Prepared CV40 for many conversion assignments.
• Conducted Integration testing in order to integrate developed individual components wif each other.
• Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms.
• Monitored and worked on defects registered in ALM tool during SIT testing.
• Did Gap analysis and Impact analysis for Finance Modules
• Provided complete training to end users and other internal team members.
• Helped Team members in understanding the business requirement documents and designing Technical design document of various components.
• In depth knowledge of Oracle Applications Finance modules, including functionality and underlying database tables.
• Interacted wif Oracle Support Team for various Oracle standard Issues. Created SR wif Oracle and followed the steps mentioned by Oracle for many Oracle standard issues.

Confidential

Oracle Financial Techno Functional Lead

Responsibilities:

• Analysed business requirements through BRDs.
• Developed many components as per the business requirements.
• Conducted Unit Testing as per the Unit test cases given.
• Conducted Integration testing in order to integrate developed individual components wif each other.
• Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms
• Did Gap analysis and Impact analysis for Finance Modules
• Worked on R12 development assignments in various Finance modules which involves designing interfaces, Reports, enhancements etc.
• Worked on performance tuning of few Reports in 11i Oracle.
• Worked on Support assignments in Oracle 11i finance modules which involve working and resolving wif tickets, Creating Change Requests for migration of resolved incidents and tickets to Production environment
• Worked on small enhancements in Oracle 11i in AP, AR, PO, GL, FA etc.
• Mentored juniors and team members and halped them in issues related to various assignments in Oracle Modules.
• Helped Team members in understanding the business requirement documents and designing Technical design document of various components.
• Migrated of data from legacy system to Oracle Applications which involved following processes.
• Collection of client data in Oracle Apps specific templates.
• Data conversion from templates to staging tables.
• Removal of errors and discrepancies, if any.
• Loading of data from Staging Table to Apps Tables.
• Validation of data after loading.
• Removal of errors and discrepancies while consolidating client data.
• In depth knowledge of Oracle Applications Finance modules, including functionality and underlying database tables.
• Interacted wif Oracle Support Team for various Oracle standard Issues. Created SR wif Oracle and followed the steps mentioned by Oracle for many Oracle standard issues.

Confidential

Oracle Financial Techno Functional Lead

Responsibilities:

• Analysed business requirements through BRDs, MD50s.
• Designed MD70, MD120, TE20 Documents for Each and Every Assigned Component.
• Analysed CV40s for Various Conversion assignments and developed the conversion code as per the given requirement.
• Developed many components as per the business requirements that include various finance interfaces, XML Publisher Reports, enhancements to existing process etc.
• Involved in conducting Unit testing through TE20 test cases and Integration testing of all the components designed by me.
• Migrated all objects of assigned components to different Oracle instances using Kintana (HP PPM Migration Tool).
• Monitored and worked on defects in Mercury Quality Centre tool during integration and UAT testing phases.
• Did Gap analysis and Impact analysis for Finance Modules
• Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms
• Worked on Performance tuning of many components in Oracle AR, GL, SLA modules.
• Worked on customization of few workflows.
• Being tech lead me was halping my team members in understanding the client requirement by MD50 go through and halping them in designing the MD70.Also worked wif them to halp them in technical queries they were facing during various developments.
• Migrated of data from legacy system to Oracle Applications which involved following processes.
• Collection of client data in Oracle Apps specific templates.
• Data conversion from templates to Staging tables.
• Removal of errors and discrepancies, if any.
• Loading of data from Staging Table to Apps Tables.
• Validation of data after loading.
• Removal of errors and discrepancies while consolidating client data.
• In depth knowledge of Oracle Applications Finance modules, including functionality and underlying database tables.
• Application Testing for data integrity and Executing the Test Plans is done using the TESTING tool.
• Prepared the cutover plan and lead all the cutover activities successfully by conducting meetings wif clients and end users.
• Ensured a smooth and successful go live.
• Provided post go live support for all the components
• Provided complete training to the end users and other Internal Team members.
• Interacted wif Oracle Support Team for various Oracle standard Issues.

Confidential

Oracle Finance Offshore Technical Lead

Responsibilities:

• Analysed and Reviewed business Requirements through MD50.
• Prepared MD70 for various newly developed components on AP,AR,GL
• Developed several inbound and Outbound Oracle Interfaces and Conversions.
• Done Unit Testing, Integration Testing and User acceptance testing of all the developed components.
• Provided functional support during the user acceptance testing
• Worked during Data Conversion requirements from Legacy and 11i Systems.
• Co-Ordinated wif legacy System named BIZTALK smooth integration between Oracle and Legacy System.
• Trained the Super Users, End Users, BIZTALK Team Members about Oracle Financial Processes and queries.

Confidential

Oracle Financial Consultant

Responsibilities:

• Analysed and Reviewed business Requirements through MD50.
• Prepared MD70 for various newly developed components on AP,AR,GL
• Done Impact Analysis on Oracle Finance and Oracle Project Modules upgradation
• Developed several inbound and Outbound Oracle Interfaces and Conversions.
• Done Unit Testing, Integration Testing and User acceptance testing of all the developed components.
• Provided functional support during the user acceptance testing
• Co-Ordinated wif legacy System named for smooth integration between Oracle and Legacy System.
• Trained the Super Users, End Users, Team Members about Oracle Financial Processes and queries.

Confidential

Oracle EBS Developer

Responsibilities:

• Analysed business requirements through BRDs,MD50s
• Designed MD70,MD120,TE20,Documents for Each and Every Assigned Components
• Developed many components as per the business requirements on OM and Various SCM Modules like Inventory and MFG
• Did Gap analysis and Impact analysis for Finance Modules
• Conducted User Acceptance Testing to provide training to the client about Oracle Applications navigation and forms
• Migrated of data from legacy system to Oracle Applications which involved following processes.
• Collection of client data in Oracle Apps specific templates.
• Data conversion from templates to Staging tables.
• Removal of errors and discrepancies, if any.
• Loading of data from Staging Table to Apps Tables.
• Validation of data after loading.
• Removal of errors and discrepancies while consolidating client data.
• Prepared the cutover plan and lead all the cutover activities successfully.
• Ensured a smooth and successful go live.
• Provided post go live support for all the components
• Provided complete training to the end users and other Internal Team members.
• Interacted wif Oracle Support Team for various Oracle standard Issues.