SUMMARY

• An experienced and highly skilled IT professional with 6+ years of experience and expertise as an Oracle 11i APPS Business/FunctionalAnalyst, firm understanding of the business process with extensive experience in requirement gathering, documenting, workflow preparations and project implementation.
• Comprehensive knowledge ofSoftware 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 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.
• 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)

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, 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 Application Security Analyst

Responsibilities:

• Worked with business process owners to gather requirements.
• Created BR100 and worked extensively on MS Visio to create process flow charts.
• 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.
• Documented user requirements, perform testing.
• 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.
• 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 Application Developer

Responsibilities:

• Worked on Various PL/SQL development requirements.
• Developed various Outbound and Inbound Interfaces related to HR and Payable Modules.
• Developed Interface related to Concur Expense System.
• Customized existing programs.
• 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.
• 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.
• Participated in Creating UAT Test Cases for System Testers.
• 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 Analyst

Responsibilities:

• 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.
• 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.
• Helped configure OM, Inventory, 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.
• 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).