SUMMARY

• Over 6.5 years of experience as a Techno - Functional Consultant on Oracle Applications
• Have experience on Oracle E-Business suite version 11i and R12.
• Worked in multiple modules of Oracle like GL, AP, AR, FA, PO, PA, HRMS
• Lead of the team at onsite and offshore.
• Worked wif clients from multiple geographies like US, UK, Spain, Canada, Portugal, India
• Involved in client interactions, requirement gathering, Designing, Development, creating test cases, testings, creating user manuals and user trainings.
• Responsible for sign-offs and approvals of multiple deliverables like BR100, MD200, MD50, MD70 etc.
• Involved in effort estimations for enhancement and support components.
• Impact analysis and documentation.
• Involved in maintaining and publishing status reporting and traceability matrix.
• Involved in multiple CRP, SIT, UAT, migrations and roll overs.
• Suggested multiple process improvements and value adds which saved many PDs for client.
• Experience wif Oracle development tools and utilities such as SQL*Plus, SQL*Loader, PL/SQL, Oracle Reports 6i, Oracle Reports 10G, XML Publisher, Discoverer, AME, ADI.
• Having knowledge of development of reports, Form Personalization, Interfaces and Conversions as per Client requirement.
• Worked on support of production environment 24/7 condition.
• Worked on Auto Lockboxes for multiple banks such as Wachovia, Bank of America, Suntrust etc.
• Familiar wif Oracle Bank statement and Reconciliation process.
• Worked on Suntrust Check payment and Positive Payments.
• Knowledge of Oracle Direct debit process for AR receipts.
• Worked on GL interface for Concur, Solomon, ADP etc.
• Worked on Workday Employee interface.
• Created multiple custom reports like AP Trial Balance, Account Analysis, Aging reports.
• Worked on Discoverer Upgradation from 4i to 11g.
• Performed multiple Disaster Recovery drills as per client’s DRT plan.
• Responsible for internal quality process: EQA, IQA and FI.
• Good understanding of Oracle Application Implementation Methodologies (AIM).

TECHNICAL SKILLS

ERP Package: Oracle E Business Suite release 11i and R12

RDBMS: ORACLE 9i, Oracle 10g, Sql server 2005

Language: PL/SQL, Shell Script(Unix), C,C++

Functional Modules: General Ledger, Account Receivables, Account Payables, Purchasing,, HRMS, Oracle Projects, Fixed Asset

Tools: D2k Report, D2k form, Toad, Sql Developer, PL-SQL Developer, SQL Loader, XML Publisher, ADI, Web ADI

PROFESSIONAL EXPERIENCE

Confidential, US

Techno-Functional, Onsite Lead

Responsibilities:

• Coordination wif offshore team.
• Project status update to the client on daily call.
• Worked wif the client to study their business processes.
• Impact analysis and documentation.
• Mapping the business processes from 11i to R12.
• Maintaining and publishing status reporting and traceability matrix.
• Creating AS-IS functional setup documents for GL and AR from 11i to enable us to give a reference point after R12 upgrade.
• Module configuration and setups in R12.
• Creating Rifleshot documents to test the supplied R12 instances for its sanity.
• Creating and taking approvals MD200s and user manuals.
• Required module configuration and setups.
• Rifleshot testing on upgraded R12 instances, report and fix the function issues if any.
• Creating CRP test cases and presenting to the business owners.
• Creating test cases for custom components which will be supplied to users during UAT.
• Retrofitments of components like custom interfaces, custom reports, form personalizations.
• Wachovia Lockbox changes and testing as per R12.
• Oracle Ebiz sales tax load in R12.
• Clinet’s custom application integration wif Orace Apps.
• Responsible for SIT and UAT.

Confidential, US

Techno-Functional Offshore

Responsibilities:

• Worked wif the client to study their business processes.
• Creating MD200 Documents and taking sign-off from users.
• Compiling the list custom components to be tested in DB Upgrade.
• Rationalization of custom components.
• Maintaining status log and traceability matrix for application side.
• Sanity check of application after each Iteration release of upgraded database.
• Checking the custom file system after each Iteration of upgraded instance.
• Preparing rifleshot and test cases.
• Testing the components and fixing the issue, if any.
• Participation in SIT and UAT. Taking the user approval.
• Reprocessing of back up data after go-live and cutover.

Confidential, US

Techno-Functional Offshore Lead

Responsibilities:

• Worked wif the client to study their business processes.
• Coordinated wif onsite team.
• Creating MD200 Documents and taking sign-off from users.
• Resolving daily issues of business users based on priority of tickets.
• Providing 24/7 support for sev1 issue.
• Running month end processes and providing extended support on month end to enable the users to close the accounting and GL periods smoothly.
• Monitoring daily scheduled programs.
• Raising Oracle SRs and depending on issue priority and monitoring.
• Performing the Disaster Recovery drill as per client schedule, mostly once in 6 months.
• Understanding the requirement from customer for new enhancement components.
• Effort estimates for enhancement components based on team bandwidth.
• Designing, Development and testing of new components on test instances.
• Migration of newly created components in Production environment wif the halp of DBAs.
• Creating User trainings manual and conducting user trainings.
• Suggesting and implementing process improvements and value adds for the client.
• Performing Year end 1099 process.
• Worked on Auto lockboxes for multiple banks like Wachovia, Suntrust, BOA, Wells Fargo. CIBC.
• Supported CIBC Pos Pay and CIBC Check Pay.
• Created multiple inbound interfaces like Concur travel and Expense GL and AP interface, ADP invoice interface, Lotusnotes system to Oralce AR invoice interface etc.
• Workday Employee interface for CORP and UK
• AR Customer, transaction and receipt Interface.
• AP Supplier and invoice Interface.
• Created transaction writeoff program.
• Program to notify users for pending requisition approval every three days if its in their Que.
• Print invoice reports for companies like IXI, Workload, ADP etc.
• Invoice Print Process Report which is developed by bursting method so that the invoice is automatically mailed to their respective customer for whom it is billed.
• Outbound interfaces like Hyperion, RDW, MDR etc.
• Created and modified multiple custom reports like account analysis, aging, supplier master, customer master, APTB, Adjustment register, Transaction register etc.

Confidential

Development of D2K Reports, AME for HRMS

Responsibilities:

• Assessment of Business Requirements as per the organization structure.
• Assessment of Re-implementation scenarios.
• Worked wif the client to study their business processes.
• Co-coordinated and worked wif the users and super users to collect the requirement.
• Customizing approval as client’s requirements.
• Created D2K report for HR AP department as per given requirements and format.
• Created AME workflow for the Iexpense approvals as per given logic.

Confidential

Supporting in-house Oracle Apps and developing new reports

Responsibilities:

• Assessment of Business Requirements as per the organization structure.
• Assessment of Re-implementation scenarios.
• Worked wif the client to study their business processes. Co-coordinated wif onsite team of functional consultants.
• Co-coordinated and worked wif the users and super users to collect the requirement.
• Attended Weekly and monthly review meetings wif Client and sent the updates about the schedules.
• Prepared document on complete requirement gathering and documentation.
• Created Reports as per requirement in Oracle Discoverer.
• Created integration from custom HRMS to Oracle HRMS
• Customizing workflow and approval as client’s requirements.
• Participated in User Acceptance Testing (UAT).
• Developed New Forms for People: Enter and Maintain (Special Info, Assignment, Special Info, Extra Info, and Address) in HRMS.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Created MD50 documents as per user requirements.
• Co-coordinated and worked wif the users and super users to collect the requirement.
• Prepared document on complete requirement gathering and documentation.
• Worked on Development of Reports in the above-mentioned modules using Oracle Report Builder and XML generator.

Confidential, India

Technical Consultant

Responsibilities:

• Co-coordinated and worked wif the users and super users to collect the requirement.
• Prepared document on complete requirement gathering.
• Worked on Development of Reports in the above-mentioned modules using Oracle Report Builder and Oracle Discoverer.
• Created MD70 Document.
• Created MD200 Document.

Confidential

Technical Consultant

Responsibilities:

• Assessment of Business Requirements as per the organization structure.
• Co-coordinated and worked wif the users and super users to collect the requirement.
• Attended Weekly and monthly review meetings wif Client and sent the updates about the schedules.
• Documentation of MD50,MD70 and MD200
• Created Reports as per requirement in Oracle Discoverer.
• Created integration from custom HRMS to Oracle HRMS
• Customizing workflow and approval as client’s requirements.
• Participated in User Acceptance Testing (UAT).
• Resolving of day-to-day technical issues.
• Training to end-users.

Confidential

Trainer

Responsibilities:

• Trained technical staff of client on Oracle Discover Desktop and Oracle Discoverer Administrator.
• Resolve their queries.
• Train End Users on how to use discoverer desktop and create reports.