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 teh 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 teh 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 dat meet teh business needs of teh customer.
• Strong Release Management noledge & R12 full life cycle and upgrade implementation experience within teh 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, Maryland

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 teh existing system and providing optimum solutions.
• Design teh solution, test teh solution/processes and drive UAT sessions to get teh acceptance of teh component from end Business users.
• Helping to close teh month end with support in various month end activities and processing teh pending transactions if any for teh month end.
• Designing functional design document AN100 for teh new component based on Business Requirements.
• Worked on teh design of customizations to settlements for large external clients which derives most of teh business to teh client (Consignors).
• Good noledge in SQL dat helps in providing potential solution to teh developer for teh components and also helps in analyzing teh issue when found.
• Supporting teh 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 teh new components
• Configure System to reflect changes for teh new component. Update BR100 to record change if teh design requires a config change with teh 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 teh Business requirements and decides teh 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 teh calling Applications.
• Highly proficient in debugging teh issues and provide root cause analysis to teh developer which helps in quick resolution to teh defects/issues.
• Analyzing and fixing teh issues/bugs dat were found in QA testing and responsible for teh delivering teh component in provided time.
• Responsible for creation of SOP (Standard Operating Procedures) for teh new components.
• Involved in training teh End Users on new components and supporting production activities for teh components in teh initial days after GO LIVE.
• Worked on teh gate pass rules for vehicle release from lot with PEGA systems where all Gate pass rules are housed.
• Identifying teh 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 teh 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 teh 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 teh 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 teh 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 teh process and to familiarize them with teh issues dat normally generate and teh 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 dat they were fixed on time with teh 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 teh requested changes in existing environment.
• Performed Root Cause Analysis of Month end related issues and provided a solution to reduce teh 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 teh 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 teh 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 teh entire process flow for AP, AR and GL modules and documented teh test results.
• Preparation of user training documents - prepared teh training document for teh users, specific to teh 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 teh user requirements and Business demand.Working on many customizations and enhancement requests based business demand.
• Managed/Supported a team to fill teh GAP in teh 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 teh 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 teh 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 teh 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 teh 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 teh customers.
• Application Rule Set for applications of cash receipts against teh customer AR invoices.
• Receipt Classes to determine teh required processing steps for receipts. These steps include confirmation, remittance and reconciliation.
• Receipt Sources to provide default values for teh receipt class, payment method, and remittance bank account for receipts.
• Auto accounting for deriving Accounting segment values for Receivables, Revenue by teh 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 teh 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 teh 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 teh OM, Scheduling, Planning, Sourcing, WIP, Logistics, PO and INV module.
• Worked on teh RMA Process in teh Oracle OM Module.
• Designed and implemented rule-based inventory re-balancing for sales locations across teh globe.
• Identify gaps in existing Oracle standard functionality and help support creation of functional specification document.
• Analysis of business needs and requirements, identifying teh gaps and issues for Order managements, inventory, AR and Purchasing modules
• Managed/Supported a team to fill teh GAP in teh 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 teh custom table
• Developed inbound and outbound interfaces betweenOracleand legacy systems.