Management Oracle

Shivani Chanan Sharma

E-mail: *************@*****.***

Phone# 510-***-****

PROFESSIONAL SUMMARY

• An experienced and highly skilled IT professional with 5+ years of experience and

expertise as an Oracle 11i APPS 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 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.

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

WineDirect, Inc Aug2008-April2012

Napa, CA

Title: 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 11.5.10(OM,INV,BOM,AR,AP) Oracle Database 9i, SQL,

PL/SQL, Oracle TOAD, Windows XP.

Oracle Consulting Mar2007-Aug2007

Quantico, VA

Title: Oracle Techno/Functional Analyst

Responsibilities:

• Analysis 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.

• Interact with end client to understand their business needs.

• Mainly involved with OM and Inventory modules.

• Developed Design Documents (MD50) based on the business requirements.

• Configuration of 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).

EDUCATION

Masters of Science in Information Systems Graduated 2006

Course Highlights: Database Concepts, Database Management, CIS Management,

Networking Concepts, Networking Management, System Analysis and Development,

Programming Management, CIS Risk Management, CIS Strategic Management

Bachelors of Science in Technical management Graduated 2004

Contact this candidate