SUMMARY:

• An experienced and highly skilled IT professional with 7+ years of experience and expertise as an Oracle 11i and R12 APPLICATIONS Business/Functional Analyst, firm understanding of the business process with extensive experience in requirement gathering, documenting, workflow preparations and project implementation.
• Comprehensive knowledge of Software Development Life Cycle (SDLC)
• Comprehensive knowledge of AIM (Application Implementation Methodology).
• Experience in Analysis, Design, Development, Data Conversions, Interfacing and Implementation of Oracle E - Business Suite.
• Proficiency in GAP Analysis, work includes identifying gaps and documenting.
• Extensive experience in gathering requirements and documenting them.
• Highly proficient in translating business requirements into functional specifications or High Level Design Document (MD50), Business Requirement Documents (BRD100).
• Programming experience in SQL and PL/SQL.
• Made Oracle Applications SOX (Sarbanes-Oxley) compliance.
• Experienced working with OTC (Order to Cash) process.
• Experienced in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Extensive experience in Application Object Library (AOL) and System Administration for Registration of Forms, Reports, concurrent programs and creation of Users, Responsibilities and Menus.
• Experienced working with OTM (Oracle Transportation Management).
• Highly motivated with strong interpersonal, communication skills and an effective team player/leader.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite 11i (11.5.3,11.0.3,10.7) and R12.

ERP Modules:: System Administration, AOL (Application Object Library) Order-Management, Inventory, Account Payables, Account Receivables and Bill of Materials.

Oracle Tools:: Forms 6i, Discoverer 4i, SQL*Loader, TOAD, SQL*PLUS, Workflow Builder.

RDBMS: Oracle 8i/9i, SQL Server 2000/2003/2005, Access, MySQL

Language: SQL, PL/SQL, Visual Basic, JAVA, HTML, C/C++.

OPERATING SYSEMS: UNIX, WINDOWS 9X, WINDOWS NT, XP, 2003 SERVER.

WEB DESIGN TOOLS: Macromedia studio MX 2004(Dream weaver, Flash, Fireworks, and Adobe Photoshop).

REPORTING TOOLS: SQL Report, Noetix, and Discoverer

Modeling Tools:: Rational Rose, UML

OFFICE TOOLS: MS OFFICE (Word, Powerpoint, Excel, Access) MS Project.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Business Analyst /Oracle financial Functional Consultant

Responsibilities:

• Responsible for functional design and End to End process for Credit card transactions in Receivables
• Responsible for setting up integrated payables with Comerica
• Responsible for setting up Check, Wire, ACH payments in Oracle Payments
• Responsible for setting up AP/AR Netting functionality
• Responsible for setting up Automatic receipts functionality for Credit Card transactions
• Responsible for end to end lockbox process for Comerica
• Responsible for integrating client services with receivables for creating customers and attributes
• Responsible for configuring various setup in purchasing module.
• Performed GAP Analysis with technical team.
• Responsible for documentation (BRD, FRD) AS-IS AND TO-BE PROCESS FLOW, test scripts.

Environment: Oracle Applications R12 -12 (GL, AP, Purchasing, Oracle Payments, Fixed Assets, CM, System administrator)

Confidential

Business Analyst/Oracle Applications Functional Analyst

Responsibilities:

• Worked with business process owners to gather requirements.
• Created BR100 and worked extensively on MS Visio to create process flow charts.
• Created MD50 (Functional Design Documents) for various OM functional requirements.
• Configured Order Management and Advanced Pricing Setups such as Order Type, Line Type, Processing Constraints, Custom Holds and modifiers.
• Create Security Design documents for various Oracle Supply Chain Management modules.
• Working with SOX team to design, modify and set Oracle security roles and responsibilities.
• Worked on configuration, troubleshooting, roll out to production, maintenance of EBS security in relation to user access, responsibilities, menus and functions.
• Worked on AOL (Application Object Library) related requirements.
• Involved in various types of testing processes (System Testing, Link Testing and UAT Testing).
• Worked on SCM(OM/ Inv /Advance Pricing).
• Performed Oracle Application form personalization.
• Lead daily status meetings regarding open defects/tickets.
• Performed Quarter end Oracle Security related validations.
• Worked on Quality Center (bug tracking tool).
• Worked on OTM (Oracle Transportation Management) application to create new roles/Menus.
• Worked on OTM related production issues such as end users not able to login to correct domain or users not able to view screen sets under the respected roles.
• Developed SQL reports as per end-users requirements.

Environment: Oracle Application 12.1.2(INV, BOM, PUR, ASCP, PRICING) Oracle Database 10g, SQL, PL/SQL, Oracle TOAD, Windows XP.

Confidential

Oracle Applications Techno-Functional Analyst

Responsibilities:

• Gathered both Technical/Functional requirements from business users.
• Created Functional/Technical Design Documents (MD50 and MD70) to capture all information regarding the requirements.
• Developed various Outbound and Inbound Interfaces related to HR and Payable Modules.
• Developed Outbound Interface related to third party Expense System (Concur).
• Modified existing AP procedures to meet business requirements.
• Defined various lookups, value sets and Descriptive Flex fields for requirements.
• Defined Concurrent programs and request set in Custom Schema.
• Worked with UNIX to place Control files, Program files and Data files.
• Configured SCM related setups in OM and Inventory.
• Developed various Design documents for Custom Interfaces.
• Created Flow-Charts for design documents using MS Visio.
• Worked with MS Project.
• Extensively used Jira tool for pre/post production bugs.
• Configured Procure to pay (PTP) process.
• Created new screen sets and assign it to a menu in OTM.
• Provided production support for OTM.
• Participated in Creating UAT Test Cases for System Testers.
• Implementing and training users with the new Oracle/custom process.
• Worked on SQL*Loader Scripts.
• Participated in developing Confluence pages.

Environment: Oracle Application 12.1.2(HR, AR, AP, FA, GL) Oracle Database 10g, SQL, PL/SQL, Oracle TOAD, Windows XP.

Confidential, Napa, CA

Oracle Application Techno-Functional Analyst

Responsibilities:

• Participated in designing process and Data mapping.
• Created MD50 based on business requirements.
• Participated in designing and developing new enhancements.
• Supported mission critical systems including standard and custom Oracle applications for inventory management, order processing, and financials.
• Worked with Business Management team to understand their more critical business needs.
• Worked on data mapping between legacy system and Oracle. Developed templates for conversion.
• Gathered requirements by interacting with End-Users, documenting them and have them reviewed by IT manager.
• Participated in UAT testing created test cases with different scenarios to get expected results.
• Worked on Technical requirements, such as reports, Conversions and Extensions.
• Worked on Various PL/SQL development requirements.
• Worked on Various functional requirements.
• Worked on various SCM (Supply Chain Management) modules.
• Worked on CTO (Configure to Order) end-to-end process.
• Documented and configured OTC (Order to Cash) process.
• Helped configure OM, Inventory and AR related setups.
• Created Custom Alerts, Holds to meet business needs.
• Created various different reports regarding their fulfillment Statistics.
• Helped Compliance team to customize the existing reports.
• As part of the SOX (Sarbanes-Oxley) compliance defined new responsibilities, users and menus to segregate the business functions in every organization within the company.

Environment: Oracle Application R12 (HR, AP, AR, GL, FA) Oracle Database 9i, SQL, PL/SQL, Oracle TOAD, Windows XP.

Confidential, Quantico, VA

Oracle Techno/Functional Analyst

Responsibilities:

• Analyzed and documented all the requirements for implementation.
• Customized and developed various reports in different modules.
• Involved in historical data conversion. Imported Flat file data into the staging tables. Created packaged procedures to validate and load the data from temporary table to interface tables. Using Oracle standard order import interface, data were loaded into Oracle base tables.
• Involved in complete life cycle of testing e.g. Unit testing, Integration Testing, System testing, and UAT. Provided help to various teams to make them understand the customizations.
• Created various (Back-end) PL/SQL code to implement business rules through triggers, procedures, functions, and packages.
• Performed system administration functions such as creation of users, creation of responsibilities, defining value sets, creation of concurrent programs and executable, registering applications.
• Involved in process of setting up new responsibilities, new menus etc. per SOX recommendations.
• Created AS IS and TO BE (Gap Analysis documents) system documents to show the current and proposed functionalities of the system by brainstorming with developers, architects and business users.
• Used AIM (Application Implementation Methodology) in pre production stages.
• Involved in Designing phase, support analyzing and scoping business requirements process.
• Worked on SCM custom Alerts.
• Involved in Extension team, worked as Liaison between Functional and Technical team.
• Involved in Supply Business Flow Setup Planning, Costing and RMA Flows.
• Reviewed the Business Requirements documents with the business and development teams to understand the architecture and functionality of the application.
• Worked extensively on Order Management requirements.
• Interacted with end client to understand their business needs.
• Involved with OM and Inventory modules.
• Developed Design Documents (MD50) based on the business requirements.
• Configured General Ledger module, Order Management, Accounts Receivables and Account payable.
• Developed several Business Requirement Documents such as Revenue status report, closed period open invoices report.
• Hands on Experience using MS Visio for Flow Charts and MS Project for time tracking and updating it upon completion of any deliverables.
• Supported in AR system setups. Various new customer setups.
• Setups of Transaction types, Pricelist and Order type defaulted in Customer level.
• Setups of Transaction types, Auto accounting, Accounting and Invoicing rules, Approval limits, Payment Terms
• Setup of Modifiers for discounts, surcharges and the corresponding Qualifiers in the Pricing.
• Performed UAT on Order to Cash before go live.

Environment: Oracle Application 11.5.10 (OM, INV, BOM, AR, AP) Oracle Database 9i, SQL, PL/SQL, Oracle TOAD, SQL*Plus, Windows XP, UNIX (Sun).