SUMMARY

• Over 7 years of experience as Oracle functional in Oracle E - Business Suite Applications
• Implementation expertise in Oracle Applications R12/11x, across the Discrete and Financials Modules such as General Ledger (GL), Payables (AP), Receivables (AR), Purchasing Order (PO), Inventory (INV), Order Management (OM), Bill of Materials (BOM), Work in Progress (WIP), Quoting and System administration (AOL)
• Day-to-day technical contact for Oracle Advanced Benefits (OAB) for the Benefits department.
• Experience Oracle HCM suite upgrades from 11. .1.2 for clients from requirements gathering to implementation
• Working Knowledge of accounting principles (GAAP) and extensive experience in account analysis for both design and troubleshooting purposes
• Experience in designing, coding, testing custom applications with an integration to Oracle Applications or other custom applications.
• Expertise in Oracle Payroll configuration with Oracle Time and Labor and Oracle Benefit modules in Multi-Org environments.
• Experience in developing inbound and outbound Interfaces for Oracle General Ledger, Accounts Receivables, Purchasing, Quoting, Order Management and Inventory modules.
• Experience in Customizing standard Oracle Reports using Reports 10g/6i in GL, AP, INV, OM, AR and PO modules as per business user requirements.
• Experience in developing custom Oracle Forms using Oracle Forms 10g/6i.
• Experience in customizing Oracle workflows such as the PO Approval process, Order/Line Flow to send user notifications based on the business requirement.
• Experience in converting the standard Oracle reports to a more fancier reports using XML publisher
• Expertise in Oracle compensation workbench (CWB)management, Salary review, designing of especial earning rules using Fast formulas.
• Expertise in building Reports in Discoverer 10g/4i Administrator and Desktop Edition, including Business Areas and Work Books.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Strong knowledge of SQL, PL / SQL, Forms 10g/6i, Reports 10g/6i, Discoverer 10g/4i, Oracle Workflow and XML Publisher
• Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Prepared Technical Design Documents for customizations and conversions using AIM documentation methodology
• Experience in Manufacturing, CRM and Distribution domains.
• Excellent problem solving skills with an ability to identify problems and implement connective solutions.
• Experience in providing Level 2 support to resolve high priority production and support tickets

TECHNICAL SKILLS

ERP Suite: Oracle E-Business Suite R12/11.x; GL, AP, AR, PO, OM, WIP, BOM, Quoting, INV, Advanced Pricing, AOL

Database Tools: SQL *Plus, SQL * Loader, Toad, SQL Navigator

RDBMS: Oracle 10g/9i/8i, SQL Server 6.5/7.0/2000

Oracle Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i, Oracle Workflow Builder 2.6.3.5, Developer 2000, XML Publisher, Oracle JDeveloper

Data Warehouse: Informatica Powercenter 8.1

Other Languages: C/C++, Java, JSP, JDBC, J2EE

Document Methodologies: MD.070, MD.050, CV.060

Operating Systems: SCO UNIX (Shell Scripting), Windows XP/NT/95, DOS, Mac OS X

Other Tools: Mercury Quality Center, Serena ChangeMan Version Manager, TortoiseSVN, CVS, MySQL Workbench, IBM Lotus Notes, SoapUI, BMC Control-M

PROFESSIONAL EXPERIENCE

Confidential - Norfolk, VA

Oracle EBS Functional Analyst

Responsibilities:

• Responsible for the expansion of the Oracle footprint to include the Oracle R12 HCM modules throughout the business.
• Developed a custom program to update the B2B Purchase Orders and PO Requisitions as soon as the Sales Order is updated.
• Worked as Lead (UAT) during Oracle R12 E-Business implementation of P2P, O2C functional modules.
• Was involved in defining Compensation Work Bench (CWB) setup like Defining Distribution Budget, Budget Reserve, Worksheet Budget, Worksheet Amount, Recommended Amount, And Eligible Salary.
• Worked for migration of financial Data over to EBS from SAP
• Implented both full life cycles and upgrades of Oracle Compensation (CWB) and Advanced Benefits (OAB) for the project
• Achieved disclosures to ensure conformance with GAAP and SEC regulatory requirements
• Facilitate orientation sessions on Advanced Benefits and Payroll to provide an in-depth overview of the system functionality.
• Participated in detailed Payroll requirement information gathering needed for Reports Customization
• Provided Support for detailed functional, technical design & testing of Oracle HCM Suite.
• Was involved in setting up bonus Compensation Plan (CWB) by defining distribution budget, eligible salary and worksheet details.
• Worked with business users to sequence and prioritize test scripts for Procure to Pay and Order to Cash End to End business flows
• Was responsible in defining Advanced Benefits, Eligibility Factors, Eligibility Profiles, Programs, Plan types, Plans and Options, Enrollment Requirements, Flex credits, Benefit Pools, and Standard Rate Calculation.
• Part of a team implementing Oracle R12 HRMS modules HR, Advance Benefits (OAB), Paid Time off, compensation (CWB), OTL and Payroll. Assisted in Business process mapping and prototyping, gap analysis, solution design, HRMS setup, testing and user training.
• Provided direction on developing business flow test scripts for various Oracle EBS modules such as OM, AP, AR and GL.
• Created Alerts to send emails to employees on new hired, enrolment or termination of benefits, open enrolment, timesheet entry issues and year-end processing notices.
• Provided support to all HR activities especially payroll and PaidTime off processes
• Responsible to create test plans, also execute testing of all custom and Standard R12 Components as part of CRP1, CRP2, SIT and UAT cycles.
• Designed applications extensions for custom retro pay process based on payroll interface
• Developed shell scripts to schedule Oracle concurrent programs from BMC Control-M.
• Developed an outbound interface program to transfer Invoice and GL extracts from Oracle to Peoplesoft.
• Developed various HR and payroll modules for Oracle processes.
• Extensively worked on 401K interface for payroll bi-weekly employees.
• As part of Conversions from the legacy main frame systems, developed Sales Order and Item conversion based on the business requirements
• Designed M50 documentation for payroll and HR conversions involving PaidTime off
• Worked on the OM Order Header Workflow to modify the Standard Sales Order closing logic.
• Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and BI/XML Publisher

Environment: Oracle Apps R12.1, AOL, AR, PO, INV, OM, E-Commerce Gateway, PL/SQL, Reports 10g, XML/BI Publisher, Soap UI and Workflow 2.6.3.

Confidential, Boca Raton, FL

Oracle Techno-Functional Analyst

Responsibilities:

• Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs.
• Worked with Oracle Purchasing, Oracle iSupplier Portal, Oracle iProcurement, Oracle WMS/MSCA (Inbound), Oracle Inventory Management,
• Assist Functional team in Business Requirement Specification (BR100) for HR and Payroll
• Developing custom interfaces between various Applications for integration.
• Developing reports through Oracle Reports and XML Publisher.
• Conducted meetings and presentations to make the client aware of the balances to be converted from legacy to Oracle for mid-year payroll process and Oracle Paid Time off
• Responsible for the hr 11i implementation and set up of the oracle standard benefits.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Maintaining the interfaces for Oracle Advanced Benefits.
• Gather requirements for Oracle Advanced benefits implementation
• Managed successful implementation of Oracle Advanced Benefits (OAB)
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Worked for Procure to Pay (P2P) Process and Order to Cash (O2C) Processes and module integrations with AR, GL, AP, OM, WMS and INV with in EBS System.
• Analyzed and mapped legacy balances with Oracle payroll elements and prepared technical specification for Payroll Balance Upload.
• Designed employee date tracked report with payroll balance, new hire report, employee work history report, organization wise payroll summary report which match expanse accounts and prorate regular earnings, over time earnings report for payroll, sick leave report to show payroll deduction history, regular hours worked and earning using PL/SQL, Oracle Concurrent Manager and UNIX Shell scripts
• Worked with Compensation workbench (CWB), Paid time off and Benefits modules of oracle to implement a better and faster approach to the project
• Collecting Business requirement and Leveraging with Oracle Applications.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, executable.
• Customization and development Reports as per client requirements.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite R11i (11.5.10), Oracle Financials Modules like AR, AP, Developer 2k, UNIX and SQL.

Confidential, Endicott, NY

Oracle Analyst

Responsibilities:

• Customized and Developed BI Reports per business requirements.
• Involved in Report development using XML Publisher
• Modified the seeded HR workflow processes as per the their needs for Oracle Self Service and Payroll.
• Gather Business Requirements, design, build and implement several core advanced benefit programs
• Created reports were created for Payroll, HR, Advanced Benefits and finance teams to meet their daily needs
• Developed and configured several Fast formulas in Oracle Payroll.
• Writing Unit Test cases and testing after completion of the Object.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Developed the documents so as to train the end users.
• Worked on with Payroll processing steps and setups.

Environment: Oracle BI Publisher

Confidential, New York

System/Business Analyst

Responsibilities:

• Techno functional consultant in Oracle financials.
• As an onsite co-coordinator, Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs.
• Investigated and resolved major payroll issues, created and monitored TARS or developed work-arounds to issues that could not be resolved quickly.
• Developing custom interfaces between various Applications for integration.
• Develop custom reports based on the Business requirement
• Developed data fix scripts for identifying the issues related to Invoices that are stuck in the interface table.
• Assisted Payroll group with implementing payrolls for 25,000+ employees
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Setup Payroll group procedures for running Oracle Payroll.
• Created and Registered concurrent executable and concurrent programs.
• Interacted with users to resolve any issues during the production, development and enhancement phases.
• Setup Payroll group procedures for running Oracle Payroll and Quick Pays.
• Coordinating with Oracle Support through Meta link to resolve issues
• Scheduled maintenance of business specific processes.
• Supported all go-live activities and post-production troubleshooting.
• Technical and Functional support for Period close and Quarter close for Confidential .
• Worked on listing the POXML WF errors, that occurs when transmitting the Pos to the external supplier.
• Preparation of technical specifications. Coding, testing and test plan preparation.
• Prepare/Report the daily/Weekly status reports

Environment: Oracle 11i financial modules - AP, Iexpenses, Iprocurement, PO, GL, P2P cycle, SQL, PL/SQL, Oracle 10g, UNIX

Confidential, Madison, WI

Oracle Analyst

Responsibilities:

• Onsite Techno-functional Analyst for Oracle Applications, where the responsibility is to design, develop and test various conversions, interfaces and batch programs, along with reports.
• Involved in mapping of data of legacy system to oracle EBS co-coordinating with functional member.
• Registering various procedures and programs as Concurrent Requests.
• Code Review & Testing of programs developed by peer members.
• Implemented and designed Oracle Reports for HR and Payroll groups.
• Technical Consultant for Oracle Applications, where the responsibility is to map the data, design, develop and test various conversions, interfaces, fast formulae and batch programs
• Development of various programs to move the legacy data to Oracle EBS using db-link, oracle job and SQL loader.
• Involved in preparation of Shell Script which invokes above programs and archive successfully transfer of data.
• Developed and maintained imports into the Oracle system for recurring and non-recurring elements necessary for payroll processing.
• Registering various procedures and programs as Concurrent Requests.
• Extraction of data into flat files by developing various outbound interfaces and develop shell program to ftp the flat files from EBS server to client machine.
• Functional add-on for Oracle Applications 11i for Oracle Inventory, Purchasing & order management modules
• Ran production payrolls and Quick Pays
• Analysis of Functional Specification (MD50) for various Conversion, interfaces, batch programs & reports
• Involved in conversion of Data from flat file using SQL Loader programs.
• Involved in development of PL/SQL package for validation of data in staging table.
• Involved in preparation of Shell Script for the above programs.
• Developed customized error report for the various conversion programs & Interfaces.
• Preparation of Technical Specifications (MD70) for above conversion, Interface & reports.
• Development, Registration and Testing of Reports.