PROFESSIONAL SUMMARY:

• 8+ years of experience as a Techno - Functional Consultant on Oracle Applications with expertise in using Oracle E-Business suite (EBS) versions of 11i and R12.
• Involved in Client Interactions, Requirements gathering, Designing, and Development, creating test cases, testing, troubleshooting, debugging creating user manuals and user training.
• Worked in multiple modules of Oracle like Finance (GL, AP, AR, FA) PO, PA, HRMS/HCM.
• Worked in Full life-cycle Implementation project environments performing System upgrade from 11i to R12, Database upgrade 9i to 11g and Support/Enhancement.
• Extensive experience in writing Data Extraction, Interfaces, Conversions and Reports. Very good knowledge of Procure to Pay (P2P/PTP) and Order to Cash (O2C/OTC) processes.
• Have Experience in Subledger Accounting (SLA), Multiorg Access Control (MOAC), Trading Community Architecture (TCA) in R12. Fair knowledge in implementing and understanding of security in Oracle EBS.
• Have configuration knowledge of AutoInvoice, AutoAccounting setups.
• Have work experience with external systems like Workday, ADP Global View payroll system, Taleo and custom systems.
• Extensive knowledge of Oracle Application Implementation Methodologies (AIM). Responsible for sign-offs and approvals of multiple deliverables like BR100, MD200, MD50, MD70 etc.
• Involved in Effort Estimations, Impact analysis and documentation for new developments, enhancements and support components.
• Experience in working as a Team Lead for multiple projects with onsite and offshore development model.
• Have experience of multiple HRMS and Finance API’s, Interfaces and reports. Have extensive experience in RICE components.
• Experienced in executing multiple CRP, SIT, UAT, Production Migrations and Roll overs.
• Have worked with Oracle on multiple Metalink SRs of different severity. Detailed knowledge of Technical reference manuals (TRMs) for HRMS, Payroll, OAB and Finance modules.
• Involved in maintaining and publishing status reporting and Traceability Matrix. Have detailed knowledge of HRMS and Finance tables’ structure and relationship with each other.
• Suggested multiple process improvements and value ads which saved many PDs for client.
• Experience with Oracle development tools and utilities such as SQL*Plus, SQL Loader, PL/SQL Developer, Oracle Reports 6i, Oracle Reports 10G, Oracle Forms, XML Publisher, Discoverer, EDI, AME, ADI, Workflow builder, Data Loader.
• Having knowledge of development of D2K and Discoverer reports, Form Personalization, Interfaces and Conversions as per Client requirement. Discoverer Upgradation from 4i to 11g.
• Maintaining and writing Fast Formulas in Oracle HRMS.
• Worked on Auto Lockboxes for multiple banks such as Wachovia, Bank of America, and SunTrust etc.
• Familiar with Oracle Bank statement and Reconciliation process. Worked on SunTrust Check payment and Positive Payments. Knowledge of Oracle Direct debit process for AR receipts.
• Responsible for internal quality process: EQA, IQA and FI.
• Performed multiple Disaster Recovery drills as per client’s DRT plan and maintaining log for the same.
• Worked with clients from multiple geographies like .
• Worked on support of production environment 24/7 condition.
• Have very good knowledge on MS Office Suite (MS Word, MS Excel, MS Access, MS Power Point, VISIO and MS Projects)

TECHNICAL SKILLS:

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

Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++, HTML.

Databases: ORACLE 9i/10g/11g, SQL Server 2005, 2008

Functional Modules: General Ledger (GL), Account Receivables (AR), Account Payables (AP), Purchasing (PO), Oracle Projects(PA), Fixed Assets(FA),Core HRMS,HRMS Benefits(OAB), Payroll, SSHR,

Operating systems: UNIX (Solaris 9, IBM-AIX, HP-UX), Linux, Windows 2000/2003/2007.

Development tools: Toad, SQL Developer, Oracle Report Builder, Oracle Discoverer, Oracle XML Publisher, SQL*Loader, SQL * Plus, Oracle AME, Oracle Workflow Builder, Oracle Form Builder, Oracle ADI, Oracle EDI

Development Methodologies: Oracle Application Implementation Methodology (AIM)

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved extensively during interactions with Customers/End users for performing Requirements Analysis and frontend development teams for Functional/Technical Specifications, Understand Architecture, Development and Testing phases of project.
• Involved in daily standup meetings with Clients and Business to evaluate the project status and discuss specific updates during the current Iteration.
• Extensively involved in providing Evaluations of Requirements and Estimating time and effort required for HR and Resolved Service Requests raised by users.
• Worked as a Team Lead to delegate tasks and deliverables to the developers and coordinated on critical issues reported by End Users.
• Developed PL/SQL-Packages , Procedures, Functions, and SQL Scripts to populate the historic data in the tables by applying business logic.
• Worked with objects secured with Multi-Org Access Control (MOAC).
• Worked on multiple Auto lockboxes for multiple banks like Wachovia, SunTrust, and BOA.
• Worked with reports like Account Analysis , Account Payables Trial Balance ( APTB ), and Aging Reports etc.
• Created multiple interface for AR and AP modules like customer interface, supplier interface, Item Master etc.
• Involved in brainstorming sessions to understand complexity, build Design Documents and suggest possibility of reusing stored procedures, functions and packages by updating the code accordingly.
• Created interfaces to default benefits plans for employees. Worked on Oracle to Sunlife Employee Benefits interface. Worked on generating Mappings from Oracle to ADP Global View Payroll using Interfaces.
• Maintained and developed numerous reports using Oracle D2K , Oracle Discoverer , and XML Publisher for various business requirements.
• Created outbound interface to send employee data such as Employee personal information, dependents information, Employment data, and Benefits information to client.
• Involved in Documentation and Data Extraction to enable Oracle to Workday migration.
• Created Database Objects and wrote complex SQL, PL-SQL queries to improve Performance.
• Creating new components using Oracle APIs and writing new interface .
• Worked as primary contact for migration of projects to SIT, UAT and Production Environments.

Environment: Oracle Apps 11i, HRMS, Payroll, Benefits, Interfaces, API, D2K Reports, Oracle Discoverer, XML Publisher, TOAD,SQL, PLSQL, Unix, Oracle Forms 10g, AME

Confidential, GA

Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved extensively with super users for business processes study and gathering requirements. Analyzing impact on system with regards to new requirement and designing solutions.
• Worked as a Team Lead at onsite to delegate tasks and deliverables to offshore development team. Responsible for daily client call for project status update.
• Created multiple AS-IS functional setup documents for HRMS, GL and AR modules from 11i enabling us to give a reference point after R12 upgrade.
• Involved in creating MD200 documents for Oracle modules, user guides and training documents for upgraded system.
• Mapping 11i business process with regards to new R12 system, configuring any new required setups for AR, GL or HRMS modules and creating new components as needed.
• Responsible for Creating CRP test cases and presenting to the business owners, answering any question regarding new process flow and taking their sign off for the modules.
• Involved in creating list of present components in the 11i system, identifying and selecting components which are no longer needed and taking approval for retirement of the same.
• Maintaining daily project status report in order to track progress against schedule. Also updating traceability matrix for the upgrade components which can be in statuses of completed, in-process or error.
• Monitoring the test results of migrated HRMS and Finance interfaces and reports in R12. If needed, involved in retrofitments of components like custom interfaces, custom reports, and form personalization’s.
• Involved in creating test cases and desired results for custom components which has been used during SIT and UAT.
• Worked on several Metalink SRs and follow-up with Oracle for solutions. Ran multiple oracle provided scripts in the system to gather configuration and table data to diagnose the issue.
• Involved in Retrofitment of Oracle HRMS to workday interface program, Wachovia Lockbox, Concur Interface, RDW interface, Hyperion interface etc. in R12.
• Configured Oracle E-Business tax (EB Tax) module in R12 and loaded location based tax data from 11i to R12.
• Involved in retro-fitment of Order to Cash (O2C) process from 11i to R12.
• New implementation and configuration of Multi-Org Access Control (MOAC), Subledger Accounting (SLA) and Trading Community Architecture (TCA).

Environment: Oracle E-Business Suite 11i, R12, AR, GL, HRMS, TOAD, SQL, PLSQL, Shell Script, Oracle D2K Reports builder, Oracle Discoverer, XML Publisher, PUTTY, Stored Procedures, API, Interfaces, AME, Oracle Workflow Builder

Confidential

Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in Impact analysis of Database upgrade on Oracle Application and custom modules and submitting report for the same.
• Involved in compiling list components and processes needed to be tested during DB Upgrade to maintain the sanity of the system after upgrade.
• Maintaining daily project status report in order to track progress against schedule. Also updating traceability matrix for the upgrade components which can be in statuses of completed, in-process or error.
• Creating baseline documents and test cases for Sanity check of application after each Iteration release of upgraded database.
• Involved in Migration of data from Oracle HRMS and Finance module to the 11g database and have rollback plan ready in case of any exception.
• Monitoring and confirming custom files in the system after each Iteration of upgraded instance and making sure that all integrity of customization and personalization’s are not compromised.
• Extensively involved in End to End application testing, maintaining issue log and fixing the issue.
• Owner for SIT and UAT testing and user approval for whole application.
• Taking backup of daily data files generated from multiple external systems for the duration of cut-over and reprocessing of back up data after go-live before Oracle starts processing current.

Environment: Oracle E-Business Suite 11i, AR, GL, HRMS, TOAD, SQL, PLSQL, Shell Script, Oracle D2K Reports builder, Oracle Discoverer, XML Publisher, PUTTY, Interfaces, AME, Oracle Workflow Builder

Confidential

Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• Working with Business users for requirement gathering and documenting the same in Oracle AIM methodology format. Creating BR100, MD50, MD70 and MD200 Documents and taking sign-off from component owners.
• Participate in weekly status calls with client program manager for enhancement and support tickets status. Coordinating with onsite team for task distribution.
• Monitoring and resolving daily issue tickets based on priority. Have experience in working in highly critical situation like 24 /7 support for severity one issue and Production migration .
• Running month end processes and providing extended support on month end to enable the users to close the accounting periods of AR, AP and GL smoothly.
• Maintaining and monitoring daily scheduled programs . Keep track of alert generated from program runs.
• Raising and following up Oracle SR s, if needed attending OWC with Consultant from Oracle. Running diagnostic scripts to gather configuration and table data.
• Performing the Disaster Recovery (DR) drill as per client schedule, mostly once in 6 months and creating log for the same.
• Involved in full SDLC stages like Requirement gathering, Designing, Development, testing and deployment.
• Created several User training manuals and conducted user training for new processes or components.
• Monitoring and maintaining Oracle HRMS to workday daily interface for UK and US instances. Creating HR Report like daily joinees and Resignees, daily headcount etc.
• Worked on multiple Auto lockboxes for multiple banks like Wachovia, SunTrust, BOA, and WellsFargo. CIBC. Supported CIBC Pos Pay and CIBC Check Pay
• Maintaining and supporting Procure to Pay (P2P/PTP) and Order to Cash (O2C/OTC) processes.
• Created several inbound and outbound interfaces like Concur travel and Expense GL and AP interface, ADP invoice interface, Lotusnotes system to Oracle AR invoice interface, AR Customer interface, AR transaction interface, AR Receipt Interface, AP Supplier interface, AP Invoice Interface.
• Maintaining and supporting Oracle EDI for Invoice and Purchase order i.e. transactions 810 and 850 from external sources.
• Suggested several value adds to client such as Transaction writeoff program, Program to notify users for pending requisition approval every three days if it’s in their Que etc.
• Created multiple Print invoice reports for companies like IXI, Workload, and ADP etc. Also incorporated XML Bursting, enabling invoices to be e-mailed to the customer as attachment
• Designed and maintained external (Legacy) system Outbound interfaces like Hyperion, RDW, and MDR etc.
• Created and modified multiple custom reports like account analysis, aging, supplier master, customer master, APTB, Adjustment register, Transaction register etc.

Environment: Oracle E-Business Suite 11i, AR, GL, HRMS, TOAD, SQL, PLSQL, Shell Script, Oracle D2K Reports builder, Oracle Discoverer, Oracle Form Builder, XML Publisher, PUTTY, Interfaces, AME, Oracle Workflow Builder, Oracle ADI, Oracle EDI

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Working with Business users for requirement gathering and documenting. Assessment of re-implementation scenario.
• Customizing Oracle AME workflow as per new requirement for HRMS and Oracle i - Expense Module.
• Creating multiple Oracle D2K documents and reports such as New Hire Joining dockets, Service certificate, Daily head count reports etc.
• Modified multiple seeded report logic and formats such as Active Users, Active Responsibility Report, Account Payable Trial Balance (APTB), Supplier Details report etc.
• Created several User training manuals and conducted user training for new processes or components

Environment: Oracle E-Business Suite 11i, AP, HRMS, Payroll, TOAD, SQL, PLSQL, Oracle D2K Reports builder, XML Publisher, PUTTY, Oracle AME, Oracle Workflow Builder

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Working with Business users for requirement gathering and documenting. Assessment of impact on current system with the help of functional consultant.
• Involved in Weekly and monthly review meetings with Client and track the status of assigned tasks.
• Created Several Reports in Oracle Discoverer, Oracle D2K Report Builder and XML Publisher.
• Involved in designing and executing integration from custom HRMS system to Oracle HRMS.
• Customized several approval Workflows using Oracle Workflow Builder for HRMS and Project (PA) modules to incorporate custom business logic.
• Active Participation in System Integration testing and User Acceptance Testing (UAT).
• Developed New Custom Forms for storing additional employee information in HRMS.
• Creating and maintaining new definitions for Special Info , Additional Info, and Extra Info in HRMS.
• Creating and maintaining DFF, KFF, Quick codes and user tables in Oracle AOL.
• Created several User training manuals and conducted user training for new processes or components.
• Trained several new team members over the time in Oracle Application and technologies.

Environment: Oracle E-Business Suite 11i, PA, HRMS, SSHR, TOAD, SQL, PLSQL, Oracle D2K Reports builder, XML Publisher, PUTTY, Oracle AME, Oracle Workflow Builder

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in requirement gathering and creating MD50 documents for GL, PO and AP modules.
• Facilitate end users with required data extraction from Oracle database as per their requirements.
• Re-Designing multiple seeded reports like Account Analysis , Account Payables Trial Balance ( APTB ), Aging Reports etc. in Oracle XML publisher with MS Excel output type, making it easier for end users to work on it.
• Created several custom reports in XML publisher for GL, AP and PO modules like Purchase order detail Report, Supplier master, AP invoice details, AP Payment details etc.

Environment: Oracle E-Business Suite R12, GL, AP, PO TOAD, SQL, PLSQL, Oracle D2K Reports builder, XML Publisher, PUTTY.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Understanding end user requirements, designing solution and creating MD70 and MD200 documents.
• Involved in designing and developing conversions programs for Supplier master load, Item master load, Customer load and transaction load from legacy systems.
• Facilitate end users with required data extraction from Oracle database as per their requirements.
• Created several Oracle Report Builder and Discoverer reports for custom requirements and formats. Reports include Project Detail Report, Task Details, Item Master, Customer Master, Purchase Order details Report, Open transactions Report etc.
• Involved in migration of components from UAT to Prod environment using FNDLOAD scripts.
• Formatting and Loading legacy system data in Oracle using Data Loader .

Environment: Oracle E-Business Suite R12, GL, AP, AR,HRMS, Payroll, SSHR, PO, PA, TOAD, SQL, PLSQL, Oracle D2K Reports builder, Discoverer, PUTTY.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Attending weekly status calls with internal team and provide update on assigned tasks and ticket statues. Maintaining ticket log with current status and estimated completion time.
• Analyzing requirements and provide estimation of Man Days required to complete.
• Facilitate end users with required data extraction from Oracle database as per their requirements.
• Assigning priority and Resolving daily tickets logged through internal ticketing tool. Contacting SR logger to understand exact problem and provide solution based on that.
• Performing Oracle system administrator tasks such as creating user, resetting passwords, assigning new responsibilities to users, creating new responsibilities and menus etc.
• Created multiple Discoverer reports such as Daily Joinees Report, Attrition report, Daily Head count, Visa Ready report, incomplete information list of new joinees etc.

Environment: Oracle E-Business Suite 11i, GL, AP, AR,HRMS,, SSHR, PA, TOAD, SQL, PLSQL, Oracle D2K Reports builder, Oracle Form Builder, Oracle Discoverer, PUTTY.