SUMMARY:

• 8 Years and 5 Months of total IT experience in all phases of the software Development Life Cycle including project definition, business requirements gather, analysis, integration, Functional and Technical design, coding, migration, testing, implementation and support, business process improvements under Oracle EBS on 11i and R12.
• 2 years of Onsite (Ohio) experience of leading, mentoring, co - ordinating and supporting with other teams in an Onsite-Offshore model.
• Proficient in RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion.
• Played team role in application set-ups, implementation, conversions, interface development, testing and end-user training.
• Good experience in AIM methodology for implementing Oracle Applications. Familiar with all the Standard Documents (MD050, MD070, MD120, CV040, CV060)
• Hands of experience in implementation, support and upgrade projects on Oracle Applications. Worked extensively as Oracle Apps Functional Consultant in modules like Accounts Receivables (AR), Accounts Payables (AP), General Ledgers (GL), Cash Management (CE) and Advance Collection (AC). Good Experience in ERP Oracle Applications E-Business suite on R11 and R12.
• Hands experience in development, support and upgrade projects on reporting tools. Developed various business reports and customer facing documents using Oracle BI Publisher, XML Publisher and Oracle Reports 6i.
• Experience in creating RTF templates using XML Publisher.
• Comprehensive knowledge of various implementation methodologies and good understanding of Business flows in O2C.
• Knowledge of key concepts such as Multi-Org structure, Multiple Reporting Currencies model, Oracle Trading Community Architecture, Intercompany transactions, Period closures, Reporting, Taxation etc.
• Detailed knowledge and complete understanding about the functionalities of the core Oracle Financial modules (AR, AC and AP) and their interplay in the overall accounting structure of an organization.
• Experience with end-to-end complete ERP implementation and support. Very strong Business/Functional knowledge, experience. Multiple full life cycle implementations of Oracle Applications.
• Expertise in Requirements Gathering, Functional Design, Modelling Business Structures, Configuration, Testing, User Training, User Manual and Production Support.
• Implementation experience in Account Receivables, General Ledger, Accounts Payables.
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications 11i.
• Around 6 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports
• Strong Exposure in writing simple SQL, PL/SQL functions and procedures and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections
• Extensive knowledge and work experience in design and development of database/web applications in Client/Server environment using Oracle Developer tools Forms (6i & 9i), Reports (6i & 9i), PL/SQL Developer and UNIX shell script.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder, and XML Publisher.
• Designed, developed and implemented various Business reports using Oracle BI Publisher
• Good knowledge in front-end development using oracle forms/reports6i/9i/10g. Experience in developing forms based on views, tables and procedures in tabular and form layouts
• Experience in business documentation including test plans, use cases, project plans, requirements documents and user manuals.
• Expertise in knowledge over Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc.
• Strong Exposure in writing simple SQL, PL/SQL functions and procedures and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections
• Experience in creating RTF templates using XML Publisher.
• Efficient in UNIX Shell Scripting in UNIX Environment
• Handled several queries raised by end users, given full support on post-production maintenance and with Oracle Service Request team to resolve the issues.
• Extensively used AIM. Worked closely with Oracle Support and logged several Tars.
• Self-motivated with the ability to effectively manage time and multiple projects.
• Strong analytical and communication skills.
• Oracle E-Business Suite Financials (11i and R12), OracleDatabase10g, 11G, Oracle Performance tuning, PL/SQL Developer, TOAD
• Oracle Reports 6i/ 10g, Oracle BI Publisher, XML Publishers
• SQL Loader
• HP Quality Centre
• HP Project Portfolio Management
• Serena Version Manager
• Solid experience in Oracle 11g/10g
• Reporting tools experience on BI Publishers, Oracle Reports for generating the business reports
• Programming language experience on SQL, PL/SQL using Stored Procedures, Packages, Functions and Triggers.
• Experience in Oracle Application Framework (OAF).
• Experience in Oracle workflow development.
• Understanding of SDLC methodologies like Waterfall, Agile methodology.
• Strong problem solving and issue tracking ability.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Environment: Oracle Application R12.1.3 (Modules worked on: AP, AR, GL and CE)

Techno Functional Consultant

Responsibilities:

• Designed inbound and outbound Interfaces for Confidential Inc. for different legacy system.
• Resolved of functional & technical issues.
• Involved in preparation of test scripts (TE40) for all business areas in GL, AP, AR
• Developed various Interface for Bank Statement (Cash Management) and Sub-ledger Accounting Report for Confidential Legacy System.
• Design and Developed Airline Forecast report and GL Interface for Legacy system.
• Designed OAF page to upload files into server from local system.
• Created MD070, CV060 (Technical design document) for all enhancement requirements.
• Worked on handling of TARs for various issues.
• Did IQA for all developed components like CV027, CV060, MD050, MD070 and code scripts.
• Adhering to policy all defects, issues releases are tracked and providing solutions.

Confidential

Environment: Oracle Application R12.2.4 (Modules worked on: AP, AR, FA and GL)

Technical Team Mentor

Responsibilities:

• Implement Oracle EBS R12 Finance modules.
• Design inbound and outbound for Interface for Confidential Corporation for different legacy system.
• Design different extension, integration and localization level components.
• Worked with R12 implementation team in Accounts Payables (AP), Account Receivable (AR), Fixed Asset(FA), General Ledger (GL)in Multi-Org environment
• Developed and issue resolution of inbound and outbound for Interface for Confidential for different legacy system.
• Assisted functional analyst to conduct CRP1 and CRP2.
• Resolution of functional & technical issues for EP.
• Involved in preparation of test scripts (TE40) for all business areas in GL, AP, AR
• Developed various Interface and conversion programs for Suppliers, Supplier Invoices, Employees, Customer, Customer Invoices and GL Balance from EP Legacy System.
• Designed and Developed enhancement program for attached legacy invoice pdf copy to oracle AR transaction
• Designed and Developed enhancement program for credit check update for customer
• Designed and Developed custom invoice print and statement print for EP
• Created MD050, CV027 (Functional design documents) specification for Reports.
• Created MD070, CV060 (Technical design document) for all enhancement requirements.
• Responsible for creating Request sets and Concurrent Programs and scheduling various tasks as per requirements.
• Designed and Developed Invoice, Statement print program
• Worked on handling of TARs for various issues.
• Did IQA for all developed components like CV027, CV060, MD050, MD070 and code scripts.
• Adhering to policy all defects, issues releases are tracked and providing solutions.

Confidential

Environment: Oracle Application R12.1 (Modules worked on: AP, AR)

EBS Financials Development Analyst

Responsibilities:

• Design inbound and outbound for Interface for Confidential for different legacy system.
• Developed and issue resolution of inbound and outbound for Interface for Confidential for different legacy system.
• Worked on Integration issues during month-end and Interface issues with external systems and oracle modules.
• Resolution of functional & technical issues for Corporate.
• Training users on the functionality of various Oracle R12 modules.
• Developed documentation related to Extensions and Development tasks taken up.
• Worked on handling of TARs for various issues.
• Adhering to policy all defects, issues releases are tracked and providing solutions.

Confidential, Columbus, OH

Environment: Oracle Application R11.5.10 (Modules worked on: AP, AR, AC, CM), HP PPM, HP QC, SERENA PVCS, Toad, XML Publishers, Oracle Reports, Oracle BI Publisher

Financials Consultant (Onsite Lead)

Responsibilities:

• Production Support for AR, AP, CM and AC and Reports
• Worked on Integration issues during month-end and Interface issues with external systems and oracle modules.
• Developed and issue resolution of the BI Publishers Reports and Oracle Reports which include Customer facing Documents (Invoice, Credit Memo, Debit Memo, Order Status Documents, Order Quotes and Checks) and also Oracle Reports as per business requirements.
• Resolution of functional & technical issues assigned to the Support team.
• Oracle Patching & Critical Security Patch updates
• Extensions & Development activities related to Oracle Applications R11 suite
• Training users on the functionality of various Oracle R11 modules.
• Developed documentation related to Extensions and Development tasks taken up.
• Trained new hire and updated professionals for Oracle Financials, AR, AP, CM and AC and User Support, Prepared lesson plans, created curriculums, and provided counselling on one-to-one basis.
• Worked on handling of TARs for various issues.
• Implement the Chase Orbital Gat way for Credit Card transaction in Oracle Application R11
• Implement Tokenization in Oracle Application R11
• Implement PayPal payment get way in Oracle Application R11
• Adhering to policy all defects, issues releases are tracked and providing all possible help to offshore

Confidential

Environment: Oracle Application R11.5.10 (Modules worked on: AP, AR, AC, CM, GL), HP PPM, HP QC, SERENA PVCS, Toad, XML Publishers, Oracle Reports, Oracle BI Publisher

Financials Lead (Functional and Technical)

Responsibilities:

• Understanding the functional specifications and requirement analysis.
• Writing the technical design / Solution documents.
• Coordinating between offshore and other teams at onsite.
• Handling all escalations and tracking the defects/issues to closure.
• Managing the whole team and assigning work to each team member.
• Responsible for all incidents, service requests reported
• Participating in all sorts of client calls
• Reporting all issue and status to client on daily basis and weekly basis.
• Responsible for creating and negotiating timeline and effort for all releases.
• Requirement Capture and Analysis by conducting workshops (pre foundation, pre solution and solution) with Customer SMEs
• Gap Analysis and to be Process and Solution Design
• Manage integrity of interfaces from various external systems
• Developed and issue resolution of the BI Publishers Reports and Oracle Reports.
• The reports include Customer facing Documents (Invoice, Credit Memo, Debit Memo, Order Status Documents, Order Quotes and Checks) and also Oracle Reports as per business requirements.
• Oracle ERP Application to create custom application that includes custom finance workflow, business process, and integration with downstream system like Tibco, SOA, EDI and PDH.
• Involved in configuration of set up for AR, GL and AP apart from conducting feasibility analysis & configuration of finance suite based on understanding of business requirements.
• Managed and Co-ordinate work efforts among offshore and onshore teams to resolve any issues during SDLC lifecycle.

Confidential

Environment: Oracle Application R11.5.10 (Modules worked on: AR, AP, CM, GL, AC), HP PPM, HP QC, SERENA PVCS, Toad, XML Publishers, Oracle Reports

Functional and Technical Consultant

Responsibilities:

• Involved in configuration of set up for AR, GL and AP apart from conducting feasibility analysis & configuration of finance suite based on understanding of business requirements.
• Ensured translation of functional requirements to the technical team during developing testing functionality, reports and other customizations.
• Developed test scenarios & performed testing in addition to supporting various testing instances like system testing, SIT, UAT etc.
• Gap Analysis and to be Process and Solution Design
• Developed test scenarios & performed testing in addition to supporting various testing instances like system testing, SIT, UAT etc.
• Managed and Co-ordinate work efforts among offshore and onshore teams to resolve any issues during SDLC lifecycle.
• Analysing the business requirements and updating the functional specification for various applications.
• Analysis and closure of defects raised by different external teams.

Confidential

Environment: Oracle Application R11.5.10 (Modules worked on: AR, AP, CM, GL, AC), HP PPM, HP QC, SERENA PVCS, Toad, XML Publishers, Oracle Reports, Oracle BI Publishers

Technical Consultant

Responsibilities:

• Gathered requirements from business partners.
• Developed and issue resolution of the BI Publishers Reports and Oracle Reports.
• Involved in business process flow and functional design document preparation, documentation, system configuration and implementation for AR, AP
• Configure custom SLA rules AR to standardise their accounting process as per the business requirement
• Also defined custom source’s and called a PL/SQL package to define the SLA rules
• Documented Functional design for technical team.
• Provided support for areas of Finance; A/R and A/P.
• Attended and participated in the meetings with business users representing all sectors.
• Attended meetings with Track Lead and discuss the gaps and plan of actions.
• Work with finance team to understand the financial impact and determine the scope of RICE components.
• Prepare TO-BE process flows and review them with the project team.
• Participate in the “Deep Dive” sessions to understand and challenge the current business processes.
• Organize meetings with business leads and track leads to discuss and find a common agreeable solution on different scenarios.
• Also prepared Functional and technical design documents for conversion components in AP, AR Supplier and Customers.
• Developed and also lead a team for all conversion components developments.

Confidential

Environment: Oracle Application R11.5.10 (Modules worked on: AR, AP, CM, GL, AC), HP PPM, HP QC, SERENA PVCS, Toad, XML Publishers, Oracle Reports, PL SQL Developer

Financials Technical Consultant

Responsibilities:

• Developed XML Publishers Reports.
• Detailed requirement gathering and Development of Reports using Oracle reports 10G builder and XML Publishers
• Preparing PL/SQL packages for implementing the business requirements for Conversion using PL/SQL and UNIX in Oracle EBS R11.
• Preparing all necessary documentation for the various phases of the implementation e.g. Technical Design Document (TD), Migration Document, and Reconciliation Scripts etc.
• Preparing PL/SQL packages for implementing the business requirements for Conversion using PL/SQL and UNIX in Oracle EBS R11.
• Participation in the status call every week where discussions with the issue are held various concern of the team members are addressed by client.
• Developing medium and small scale development / enhancement in form of Service Request (SR) using PL/SQL
• Taking active part in RAC (Root Cause Analysis).
• Creating and executing one-shot PL/SQL scripts to generate reports required by the client.