SUMMARY

• Over 8+ Years of experience in IT including Oracle E - Business suite. - specializes inthe development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, and implementation.
• Experience in upgrade 11i To Oracle E-Business Suite Release 12.2.4.
• One full cycle implementation In AP, Payments
• Extensive testing in R12 upgraded environment.Rich skills in understanding business process and procedure, implementation, support and customization of various modules in like OM, Advance Pricing (QP), Shipping Execution (WSH), EDI, WMS, WIP, BOM, Inventory (INV),Costing (CST), Project Accounting (PA), Alerts, Receivables (AR), General Ledger (GL), Sub Ledger Accounting (SLA), Payable (AP), Purchasing (PO), Quality (QA), Engineering (ENG).
• Hands on experience in upgrading Discoverer reports to OBIEE reports, Repository build up, deployment and analytics
• Apply patches to prepare for the 12.2.4 upgrade.
• Excellent Techno-Functional experienceinO2C, Q2C, P2P, SCM, WMS, Demand Planning and its modules.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work around, interfaces, user training.
• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Good Experience in implementing Procure-to-Pay Business Process flows..
• Experience in setting up MOAC (Multi-Org Structure), SLA in R12 environment
• Setting up new Payment Formats in r12 environment
• Handling Multiple Countries in single instance
• Multiple Country Rollouts
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations.
• Experience in database programming using Oracle 10g databases.
• Experience in various development tools like SQL Developer, and TOAD.
• Experience in developing and loading data into staging tables.
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Excellent communication skills, adapt in client interaction and understanding business applications.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.
• Strong Release Management knowledge & R12 full life cycle and upgrade implementation experience within the Oracle Mfg suite
• Ability to leverage data to drive business insights through sophisticated modeling, statistics, and other highly analytical methods
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

TECHNICAL SKILLS

Java Technologies: JSP, EJB, JDBC, Java Script, and Visual Age.

Application/Web Servers: WebSphere 7.0, WebLogic 8.1, Oracle 10g/9i, JBoss 5.0, Tomcat

Databases & DB Languages: PL/SQL, SQL

Management Tools: ALM/Quality Center, MS Project, SharePoint, JIRA

Methodologies: Oracle's Application Implementation Methodology (AIM)

UML: Diagrams Architecture Diagram, Entity Relationship Diagram, Use Cases, Class Diagram, Sequence Diagram, Activity Diagram

IDE/Tools: NetBeans 6.5, JDeveloper, Eclipse, WebLogicOracleEM

Office Suites: MS Excel, MS Access, MS Word, MS Visio, MS Outlook

Operating Systems: Solaris, Linux, UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Financial Functional Lead

Responsibilities:

• OracleApplications: R12.1.3 Implementation Project (INV, OM, AR, GL, CM, AP) for a complex project with good number of customizations
• Worked in OUM (oracleUnified Methodology)
• Gathering business requirements, analyzing the existing system and providing optimum solutions.
• Design the solution, test the solution/processes and drive UAT sessions to get the acceptance of the component from end Business users.
• Helping to close the month end with support in various month end activities and processing the pending transactions if any for the month end.
• Designing functional design document AN100 for the new component based on Business Requirements.
• Worked on the design of customizations to settlements for large external clients which derives most of the business to the client (Consignors).
• Good knowledge in SQL that helps in providing potential solution to the developer for the components and also helps in analyzing the issue when found.
• Supporting the daily production activities and helping Business users by providing workaround when issues are found.
• Partnered with DEV leads in design of Technical Specification (DS140) for the new components
• Configure System to reflect changes for the new component. Update BR100 to record change if the design requires a config change with the code change.
• Worked with various third party vendors and tools like Next gear, Deal-shield, CDT, UVIS and PEGA systems.
• Worked on Deal-shield returns solution by integrating Macola ERP toOracle.
• Design API's when needed an API to meet the Business requirements and decides the input and Output parameters needed to call API by providing procedures of GET/POST/UPDATE
• Partnered with other teams in designing Contract decisions of API's betweenOracleand the calling Applications.
• Highly proficient in debugging the issues and provide root cause analysis to the developer which helps in quick resolution to the defects/issues.
• Analyzing and fixing the issues/bugs that were found in QA testing and responsible for the delivering the component in provided time.
• Responsible for creation of SOP (Standard Operating Procedures) for the new components.
• Involved in training the End Users on new components and supporting production activities for the components in the initial days after GO LIVE.
• Worked on the gate pass rules for vehicle release from lot with PEGA systems where all Gate pass rules are housed.
• Identifying the functional requirements for custom programs and communicating required updates to developers.
• Execution of change management using end user training and consultation to align business with the new designed process.
• Testing and Implementing solutions including communicating with a wide number of customers, partners and suppliers.
• End to endOracleApplications (OM, AR, CM) implementation project from assessment to production support as a functional analyst.
• Coordinated with development (onshore/offshore) and Business for solution design.
• Continually identify opportunities to increase internal client satisfaction and deepen client relationships.
• Oversee the day-to-day operation of applications including software support, training, & special projects.
• Provided 24*7 Issue resolution and Root Cause analysis support for all Order management, shop floor manufacturing, planning activities.
• Responsible for everyday Incident Management, Change Management,Configuration Management, Problem Management, Data Governance, and Service Request Management; participated in regular status meetings.
• Managed reporting, work progress and provided status updates to stakeholders, drove Change adoption; updated Integrated Master Schedule/project plan.
• Possess extensive experience performingFunctionalresponsibilities with leadership as well as end users.
• Assistedproduct support: create operational support documentation and transition to operations/business.
• Organize, manage, and led multipleproject implementationsin a fast-paced IT environment across multiplefunctional teams.
• Actively participate and led cross-functional team resolving functional or technicalissues.
• Developed remedial action plans, resolved problems, developed test cases/scripts, and performed system testing.
• Build strong and lasting relationships with internal and external customers, and key delivery partners by meeting with them on a regular basis to listen to their needs and concerns, to advocate IT capability.
• Experienced in planning, estimation, presentation and developing design documentation using the AIM Technique, MS Visio, MS Project, Office etc.
• Practiced AIM methodology in all aspects of process including writing design/functional documents (MD50), Technical specification (MD70), Business Requirements Mapping Documents (BR-100) etc.

Environment: Oracle Applications R12 (PO, AR, AP, GL and SLA), TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 6i, XML Publisher, Workflow Builder, WINDOWS XP.

Confidential, Denver, CO

Receivable Functional Analyst

Responsibilities:

• Led numerous requirement gatherings, designing, documenting and functional testing of various RICE components for R12 Customizations.
• Worked on Supply chain area usingOracleApps R12 (Order Management, Inventory, Accounts Receivables, Accounts Payables and Cash Management).
• Worked as a Receivables Functional Analyst with designing components and supporting production.
• Responsible for implementation tasks including Requirements Gathering, Solution Design, System Configuration, Data Migration, Testing and Post Production Support.
• Analyzed the current and new business process using Business Requirements Document (RD050) and Solution Design (MD050) usingOracleAIM methodology.
• Responsible for Configuration of Inventory item master with data loader scripts
• Involved in defining Lookups, Transaction Types, Organization Parameters and Sub inventories
• Worked with development team to provide expertise and ensured successful delivery of extensions, reports and interfaces.
• Worked on different EDI interfaces to provide custom solution to receivables interfaces
• Worked with various Cross Functional Tracks to resolve technical and data issues.
• Responsible for BR100 updates when there is a configuration change involved for new components or change in existing components
• Coordination with offshore team to enable them to understand the process and to familiarize them with the issues that normally generate and the probable ways of resolving them.
• Participated in ongoing Process Enhancements and Change Management meetings and deep dive sessions with Business and Doing impact analysis.
• Worked on Defects logged in HPQC, and ensured that they were fixed on time with the technical team.
• Created Test Plans as per business scenarios and planned testing strategies.
• Wrote Test Cases and Test Scripts (TE040) for functional testing.
• Tested and implemented the requested changes in existing environment.
• Performed Root Cause Analysis of Month end related issues and provided a solution to reduce the month end services.

Environment: Oracle Applications R12(12.1.3) (GL, HR, OTL and OTM), Forms 10g, Reports 10g, Oracle EBusiness Suite, SQL, PL/SQL, Advanced PL/SQL, Oracle Forms, Oracle Reports, XML/BI Publisher, TOAD, Forms Data Loader, UNIX, Oracle 10g

Confidential, Gaithersburg Maryland

Oracle Functional Consultant

Responsibilities:

• Personalized the standard and custom forms
• OracleGlobal Techno-Functional Production Support inOracleModules like Procure-to-Pay (P2P), Order to Cash (O2C).
• Worked on customizations of Pack slip and Pick Slip reports to fulfill the customer requirements
• Designed solutions to enhance standard oracle flows for Order to Cash (O2C), Procure to Pay (P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Performed end to end testing for the entire process flow for AP, AR and GL modules and documented the test results.
• Preparation of user training documents - prepared the training document for the users, specific to the clients’ business and covering their critical business process flows.
• Defining Fiscal years, depreciation methods, Prorate conversions, Asset Categories, Asset Warranties
• Worked on customizations based on the user requirements and Business demand.Working on many customizations and enhancement requests based business demand.
• Managed/Supported a team to fill the GAP in the Order to Cash and Procure to pay flow.
• Worked in 11i and R12 production support
• Design and developed Supplier and Item Conversions
• Worked on Customization of XML reports
• Worked onOracleAlerts to send Email, based on some changes in the custom table
• Developed inbound and outbound interfaces betweenOracleand legacy systems.
• Performed transferring invoices and payments to General Ledger and tested period end balances.
• Define Sales tax location key flex field, Order import sources, Sales persons, System Options, Customers
• Setup payment terms apart from the default ones
• Auto Accounting Setups, Transaction types, Credit Memo and Invoice, transaction Source
• Define Collectors, Approval limits, Receivable activities, internal Bank accounts
• Setup Receipt classes and Payment Methods and Setup Sources
• Define custom designed Statement Cycles, Customer Profile classes

Environment: Oracle Applications R12 -General ledger (GL), XML Reports, Oracle 11g/10g, SQL, PL/SQL,SQL Loader, UNIX Shell Scripting, Form Personalization, Oracle Workflow, Oracle Application Framework.

Confidential - Houston, TX

Functional consultant

Responsibilities:

• Defined Chart of Accounts, Accounting Calendar and Set of Books.
• Defined Account Code Combinations based on the business rules for capturing financial transactions.
• Defined Security Rules and Cross Validation Rules for restricting users to enter transactions for unauthorized Account Code combinations.
• Creation of mass allocation journals.
• Configured Payables financial Options for defaulting accounting information on AP invoices distributions and for accounting Purchase Order rate variances.
• Defined Suppliers and Supplier Sites for capturing Supplier Information.
• Payment terms for determining the Credit period and AP Invoice due dates.
• AP Distributions Sets for defaulting multiple expense accounts on AP Invoices.
• AP Invoice Hold and Releases for putting on Hold and Releasing AP invoices.
• Expense Report Templates for importing Employee Expense Invoices.
• Banks for processing Supplier’s Invoice payments and defaulting GL Accounts such as Cash, Cash Clearing, Bank Charges for AP Invoice payments.
• Defining Customers and Customer Sites for capturing Customer Information.
• Statement Cycle for generation of periodic customer’s balance statements.
• Dunning sets for sending balance outstanding reminder letters to the customers.
• Application Rule Set for applications of cash receipts against the customer AR invoices.
• Receipt Classes to determine the required processing steps for receipts. These steps include confirmation, remittance and reconciliation.
• Receipt Sources to provide default values for the receipt class, payment method, and remittance bank account for receipts.
• Auto accounting for deriving Accounting segment values for Receivables, Revenue by the Auto Invoice Program.

Environment: Oracle e-Business Suite 12.1.3, Oracle Data base 11g, Sun Solaris Platform, Special Software: Oracle Apps R12.1.3, PL/SQL Developer, Toad, Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader.

Confidential

Associate Functional Consultant

Responsibilities:

• Personalized the standard and custom forms
• OracleGlobal Techno-Functional Production Support inOracleModules like Procure-to-Pay (P2P), Order to Cash (O2C).
• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet the business/client requirements.
• Support sales order processing for both standard and return orders, order fulfillment, work with users to resolve issues around item availability and ship confirm process
• Working with Buyers on daily basis to resolve issues with Requisitions, Purchase orders, cancelling PO's, receipts, and discrepancies between PO and invoices.
• Worked on the OM, Scheduling, Planning, Sourcing, WIP, Logistics, PO and INV module.
• Worked on the RMA Process in the Oracle OM Module.
• Designed and implemented rule-based inventory re-balancing for sales locations across the globe.
• Identify gaps in existing Oracle standard functionality and help support creation of functional specification document.
• Analysis of business needs and requirements, identifying the gaps and issues for Order managements, inventory, AR and Purchasing modules
• Managed/Supported a team to fill the GAP in the Order to Cash and Procure to pay flow.
• Worked in 11i production support
• Design and developed Supplier and Item Conversions
• Worked onOracleAlerts to send Email, based on some changes in the custom table
• Developed inbound and outbound interfaces betweenOracleand legacy systems.