SUMMARY:

• Over 12 years of professional IT experience, which includes Functional Consulting experience of providing solutions for implementation, maintenance, upgrade and support of Oracle Applications E - Business Suite Releases 11i and R12.
• Highly accomplished IT professional with expertise in a broad range of skills including, Business & IT Alignment Strategy and Execution, Product Engineering, Complex System Architecture, Large Scale IT implementation, Business Process Engineering, Business Operations Management, ERP & CRM, Effective Collaborator, High Performing Team Builder, Vendor Management & Contract Negotiations, Functional and process knowledge in Sales, Finance, Supply Chain, e-commerce, Quote to Cash, Channels & Distribution, Release Management, Business Continuity & Resiliency .
• Diversified functional expertise in Oracle Applications R12 & 11i, with extensive exposure in Design, Development, Configurations, Implementations, Production Support and Upgrades in Supply Chain Management and Financial Modules.
• Strong experience in Oracle SCM & Financial applications implementation lifecycle phases of project planning, business requirement gathering, blueprinting, testing, implementation, go-live, monitoring and post implementation support.
• Expertise in business process analysis, requirement analysis, (AS-IS) system analysis, (TO-BE) mapping, Fit - Gap Analysis and Solution Designing, CRP testing, Integration testing, User Acceptance Testing (UAT), system configuration, data conversions, master data loading, Go-live support & Post-Production support.
• Strong knowledge of Quote to Cash (Q2C), Procure to Pay (P2P) and Forecast to Build (F2B) business processes and cycles.
• Proficient in all phases of Oracle Applications 11i and R12 implementation with major focus in Oracle Supply Chain Modules (Inventory (INV), Order Management (OM), Purchasing (PO), WIP, BOM, WIP, ICM, PIM/PDH), Financials (General Ledger GL, Accounts Receivable (AR), Accounts Payable (AP), Cash Management (CM), Fixed Assets (FA), AOL, Advance Pricing, Shipping and System Administration module.
• Experienced in Oracle EBS integration with Oracle Fusion Middleware SOA Suite, Mulesoft Any point platform, Sales force, Oracle Fusion CRM, Oracle Integration Cloud service, Via B2B Gateway/third party EDI translators with trading partner’s systems, PeopleSoft, Hyperion, Web-Methods, Financial Planning / Reserving and Reporting applications and other custom applications.
• Strong knowledge in configuring and implementing Oracle EBS suite API’s as REST services.
• Expertise in using Application Implementation Methodology (AIM) for authoring various documentations across various stages of a project such as RD-20, BR-100, BR-150, BR-30, TE-020, TE-040, MD-050, CV-040 and creation of Standard Operating Procedures/Process flows (BP-080).
• Experienced in preparation of Business requirement documents, Functional Specification documents, Test scripts, Data conversion documents, Configuration documents and sysadmin setups documents.
• Experienced in Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Conversion Mappings (CV40) and Conversion Test Plans (CV70).
• Experienced in designing and developing project plans for complete SDLC process right from feasibility analysis, requirement gathering and analysis, gap analysis to post production support.
• Experienced in preparing Test Plans, Unit Testing, System Integration Testing and Documentation and Providing support for SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Experienced in Design, analysis, configuration, testing, training, delivery, deployment and support of Oracle applications.
• Worked closely with Oracle Support and logged several SRs and coordinated with Oracle Support, Technical and Development teams by conducting Oracle Web Conference (OWC) sessions for highly prioritized open issues across various projects.
• Experienced in data mapping & conversions from legacy systems to Oracle and in implementing Data Migration procedures for 11i upgrade to R12 by coordinating with cross functional teams.
• Expertise in ILM (Information Lifecycle Management), Data Governance & SOLIX EDMS (Data Archival, Data Subsetting, and Data Masking Tool.
• Experienced in working in true Agile/Scrum/XP environment and possess in depth knowledge of rational unified process (RUP), Agile (Scrum methodologies), risk engineering concepts and adept in expressing requirements as user stories as an effective approach in time constrained projects and adept at working with cross functional teams in Agile environment.
• Expertise in IT service management (ITSM) based on ITIL best practices and on ITIL service support areas of Incident, problem, change, release, configuration management and service desk.
• Excellent skills in Business Analysis, OO Analysis, Data Analysis, Requirement Analysis, Project Portfolio Analysis, Business Modeling and Use Case Development using UML methodology.
• Expertise in preparation of functional specification Design/physical design documents, process flow design documents, use case diagrams, user interface specifications, data mapping and detailed design documents, mockups, wire frames, designing using UML with Rational rose and MS Visio.
• Extensive experience in identifying product gaps and coordinating with development teams by creating TAR/SR and obtained one-off fixes. Managed and monitored TAR’s for several P1 issues.
• Expertise in System Administration (AOL) i.e., in defining users, menus, responsibilities and maintaining concurrent programs. Defining Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities and Financial Statement Generator.
• Excellent knowledge of Business Process Execution Language (BPEL)/ (WS-BPEL) and Business Process Modeling language (BPML).
• Extensive experience in Functional Analysis, Application Implementation and Upgrades Including Understanding Business Process reviews and Requirement Definition, Gap Analysis, Customization Analysis, Configuration Documents, Preparation of Training Material, Data Conversion, Pilot Planning, Preparation of Test Strategies and Test Plans, Training and Post Implementation Support.
• Good Knowledge of Oracle Reports XML/BI Publisher Reports, Inbound/Outbound Interfaces, EDIs, Data Conversions, Forms Personalization/Customization for various RICEW components

TECHNICAL SKILLS:

Oracle Applications: E - Business Suite- 11i & R12.

Oracle Apps Modules: Oracle SCM & Financials (OM, PO, INV, GL, AP, AR, FA, CM) (P2P & O2C), FSG Reports.

Oracle tools: Oracle 9i/10g/11g/12c, SQL*Loader, Toad, Developer 6i/2000 (Forms 6i/4.5, 8.0, Application Object Library

Operating Systems: IBM/AIX, HP UNIX, Sun Solaris, Red hat Linux, Windows 95/98/NT/XP/Vista/7, Unix, Solaris, RHEL/Linux.

Programming languages: SQL, PL/SQL, C, C++, Java

METHODOLOGIES: Applications Implementation Methodology (AIM), TTM methodology, Oracle Unified Methodology (OUM), Agile, V model, Iterative and Waterfall methodologies, Six Sigma, UML, Rational unified Process (RUP), RAD (Rapid Application development), Agile/scrum, Waterfall software development, Service oriented Architecture (SOA).

Other Tools and Utilities: PVCS Version Manager, Kintana, Mercury Test Director, HP Quality Center, MS Visio, MS Word, MS Office, MS Excel, MS Power Point, Oracle Utilities Oracle Workflow, XML reports, D2K (Reports, Forms), XML/BI Publisher, Web ADI and Workflow Builder, Mulesoft Anypoint studio (Integrated development environment).

PROFESSIONAL EXPERIENCE:

Confidential, BROOMFIELD, CO

IT ANALYST / ORACLE APPLICATIONS EBS ANALYST

Responsibilities:

• Provided end to end Solution for EDI Integration: EDI810 AP Invoice Interface.
• Provided end to end Solution for EDI Integration: EDI850, 860, 855 & 856 in PO Module with OpenText.
• Checked R12.2.4 & R12.2.5 data Reconciliation and Data validation for LATAM Organization.
• Tested Each business process thoroughly and replicated them in upgrade instance of R12.2.5.
• Involved in pre-upgrade and post-upgrade activities.
• Provided End to End P2P and O2C Cycle Functional Support to the LATAM Org End Users.
• Worked closely with business users to resolve day to day issues with requisitions, order entry, shipping and material transactions.
• Identified and resolved issues encountered in Upgraded environments. Raised SR's and followed up with Oracle Support for assistance required in fixing the issues.
• Participated in integrated system-level testing to compare actual results with expected results.

Confidential, DEERFIELD, IL

IT ANALYST / ORACLE APPLICATIONS EBS ANALYST

Responsibilities:

• Participated in Conference Room Pilot (CRP) sessions.
• Actively involved in end to end Implementation and delivery of ORACLE SCM Modules like PO, INV, & OM across Various AIM Phases like Definition, Operation Analysis, Solution Design, Build, Transition and Production.
• Involved in GAP analysis and identification and implementation of any custom requirements with Various Oracle EBS Modules and other home grown custom applications.
• Involved in authoring of AIM documents like BP040, BP080, BR100, RD020, RD050, MD050 etc. to create integrated business process and business flow.
• Responsible for preparing Setups, Test Scripts (TE40 Doc), User Manuals, End-User Training.
• Carried out User Acceptance Test (UAT), Go-live activities and Post implementation support.
• Built strong relationship with the client & other cross functional services across the organization.
• Communicated with the Users through E-mails, Phone calls, NetMeeting to discuss the various issues, and provided the resolutions for the same based on the Severity Level of the tickets/incidents.
• Raised the necessary SR’s and participated in oracle we conference.
• Participated in Troubleshooting of any issues within the time boundaries based on the Severity.
• Tested various scenarios in the Development Instance for the End-users.
• Involved in resolving any functional issues and setups as per client specific requirement.
• Participated in the Status Update Meetings with the Client end users and super users
• Reported to project leads and business owners on the status of the Helpdesk Tickets and on other project activities.

Confidential, San Jose, California

IT ANALYST / ORACLE APPLICATIONS EBS ANALYST

Responsibilities:

• Worked as the Cisco EBIS / EB2B team’s IT Analyst / Oracle Applications EBS analyst, to perform the impact assessment of Cisco’s 11i to R12 migration on Cisco’s EB2B /EBIS team’s custom and legacy applications and systems, and was responsible to develop an IT framework post R12 migration to ensure that Cisco’s millions of customers and large set of B2B partners were notified as per their respective pre-selected notifications criteria as selected on their Cisco’s CCW portal.
• Worked as an IT analyst and served as the single point of contact for the Order distribution 3.0 (OMLSS - EB2B R12 Integration), Served as the Cisco EB2B team’s point of contact with Cisco’s Order management team (OMLSS), the supply chain management team SCLSS and other teams which were responsible for publishing of Order and other related data pertaining to each of the above mentioned notifications to the EB2B team from where the relevant customers would be notified with the appropriate data elements as per Cisco standard customer notification templates/layouts as approved by the cisco business owners and management.
• Analyzed the set of legacy notifications in the current 11i environment to identify the 11i standard and custom attributes pertaining to the data elements needed by the EB2B team for sending out notifications to customers and B2B partners and mapped these legacy 11i attributes onto the Oracle out of box R12 attributes and identified the corresponding R12 business and change events that needed to be raised by the order management, Supply chain Management and Finance teams during various phases of the order to invoice cycle for publishing the relevant date to the EB2B team.
• Requirements elicitation from the EB2B(E-Business to Business team) to identify the data elements needed by EB2B team from various cisco’s departments going forward for sending out customer notifications and B2B partner notifications post R12 migration, and to identify the Oracle out of box business and change events that need to be raised from Order management, OMLSS R12 (i.e. Post R12 migration), Supply chain Management SCLSS R12, and other Finance teams within Cisco and to identify the data publication metrics, performance metrics and data format types etc.
• Authored the corresponding Business Requirements Documents (BRD) and Functional specifications documents (i.e. MD 50 as per current Cisco standards AIM methodology for Oracle projects ) and worked towards getting the necessary sign-off’s from the OMLSS, SCLSS, Finance teams, Order distribution and EB2B teams as appropriate.

Environment: Oracle Apps 11i, R12 (OM, SCM, Financials, Finance etc.), Oracle Fusion Middleware (BPEL), Oracle Adaptor, EBIS Web-services, Oracle territory manager, PL/SQL, TOAD, SQL, Forms 6i, Reports 6i, XML Publisher, Oracle 11g, Windows, Unix, MS Visio, Requisite Pro, Oracle SOA Fusion Middleware.

Confidential, San Jose, California

IT ANALYST / ORACLE APPLICATIONS EBS ANALYST

Responsibilities:

• Cisco Order Management team’s IT Analyst / Oracle Applications EBS analyst responsible for the impact assessment of the 11i QTC / BV decommissioning program and the Order management migration to the new R12 Platform i.e. CG1 environment.
• Cisco Order Distribution team’s IT Analyst responsible for the impact assessment of the 11i to R12 migration on Cisco order management’s downstream integrations like sales credit integrations etc., which were pivotal to Cisco’s seamless business functioning post migration to Oracle EBS R12.
• Reviewed the QTC/ BV PROD object inventory and worked with the necessary teams to put a plan for transform, lift & shift and decommission of QTC/BV. Worked with multiple tracks within in Cisco who could have been impacted due to QTC / BV decommissioning and worked as part of a team to put a plan in place to take care of the impacts.
• Worked with the Cisco ‘s teams including Infra, Development, Business, QA, RMO, ERMO, and transition and gave periodic updates to OC (Operating Committee), Steering committee, Executive Management. Participated in CCB Meetings and provided impact assessment to Changes proposed
• Initiated, Planned, Executed, Monitored, Controlled and put a closure to all program & Project level activities.
• Ensured proper unit testing& System integration testing was completed in dev environments before being deployed to stage for QA execution.
• Worked with the QA Team to define a plan and reviewed the QA test cases proposed both by IT and the business team and minimized defects by extensive review of scope, architecture, design & code.
• Work with the Infra teams to close out on all the environmental requirements / Issues and ensured exit criteria for TCA, TCB etc are met as per ERMO guidance and ensured applications meet performance criteria.
• Responsible to communicate program status to various stakeholders. Resolved internal & external conflicts among projects. Managed the Critical path and aligned teams on the path for on time delivery.
• Worked as an IT analyst and served as the point of contact for the Order distribution 3.0 (OMLSS - Goal-to-Commission Sales credit R12 Integration and on the Order distribution 2.0 (OMLSS - Goal-to-Commission Sales credit 11i Integration and R12 Integration.
• Analyzed the existing legacy 11i order management and sales credit interfaces to identify the data elements currently being published to the sales credit team in the AS-IS 11i environment to identify their relevance to the sales credit team.
• Requirements elicitation from the Goal to Commission team to identify the data elements needed by the sales credit team going forward, and the Oracle out of box business and change events that need to be raised from Order management OMLSS R12 (i.e. Post R12 migration) to enable such data publishing onto the sales credit team and to identify the data publication metrics, performance metrics and data format etc.
• Mapped the existing AS-IS data elements of interest to the sales credit team in the 11i environment to Oracle Out of the Box R12 attributes including the existing 11i custom attributes.
• Negotiated the need for publishing any custom attributes to the sales credit team post R12 migration as per OMLSS alignment and broader scope.
• Authored the Business requirement and Functional specifications documents (i.e. MD 50as per current Cisco standards AIM methodology for Oracle projects ) and worked towards getting the necessary sign-off’s from the OMLSS, Order distribution and G2C teams as appropriate.
• Performed impact analysis on retirement of certain sales credit custom objects that resided on the 11i Environment to firstly identify the list of teams that would be impacted once these custom objects would be retired as per Order management team (OMLSS) alignment regarding R12 Migration. And, identified the list of impacted objects by each downstream team that would be impacted post retirement of these objects.
• Assisted the QA team in preparing the detailed test plan for the above mentioned technical foundational integrations and provided the necessary sign off on the same.
• Worked closely with QA (QACC team) and OD Architects & Developers to clarify/understand functionality, track defects, resolve issues and provide feedback to eliminate bugs using HP Quality Center.
• Incorporated the requirement changes by creating change requests (CR).
• Organized any necessary team meetings to resolve any issues, to mitigate risks etc. with the internal and cross functional architectural and development teams.
• Distributed the project status reports pertaining to the above integrations to Management and presented the corresponding status in period project status meetings involving various stakeholders.

Environment: Oracle Apps 11i, R12 (OM, SCM, Financials, Advanced pricing), Oracle territory manager, PL/SQL, TOAD, SQL, Forms 6i, Reports 6i, XML Publisher, Oracle 11g, Windows, Unix, MS Visio, Requisite Pro, Oracle SOA Fusion Middleware.

Confidential, Jasper, Indiana

Responsibilities:

• Implementation of setups across various Oracle Functional Apps: Purchasing, Order Management, Accounts Payables, Accounts Receivables and General Ledger.
• Involved in setup of Ledger (Chart of Accounts, Calendar and Currency).
• Involved in Setup Segments & assigned Flex Field Qualifiers
• Defined Cross Validation and Security Rules.
• Defined Definition Access Sets and data access sets
• Involved in Setup of recurring journals and Auto post criteria.
• Documentation of end user training materials and hands on training for all the modules implemented.
• Prepared various documents like RD020, BP080, BR010, TE040, BR100 as part of implementation.
• Worked on various customizations and data fixes in PO, OM, AP, AR and GL.
• Managed the implementation of new development work with system developers and was responsible for testing and documentation prior to the go-live release.
• Collected business process information and requirements for each business process.
• Prepared documentation for the User community for the various business processes.
• Business Requirements Mapping for PO & AP modules.
• Understanding the AS IS Process and TO BE Process and trained the end users for testing the test cases under various scenarios.
• Provided trainings on the oracle modules like General Ledger, Accounts Payable, Accounts Receivables, Fixed Assets, Cash Management and Internet Expenses.
• Analysis, design and implementation of seamless integration to 3rd Parties.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice sessions
• Supported production environments and users daily by responding to emergency requests

Confidential, Chicago, IL

Responsibilities:

• Worked on the project by using AIM methodology by gathering business requirements from the client.
• Designed Item template, freight carriers, Approval Groups, Approval Assignments, Approved Supplier List, Sourcing Rules, Price List, Sales Order Types, Document Sequences, Release Rules & Picking Rules.
• Setting up Shipping Parameters & Purchasing Options.
• Involved in preparation of Conversion Document CV40, and power point presentation documents for both configuration and process steps with navigations for end users.
• Designed the solution to meet the business requirements as part of To Be Flows(BP80)
• Defining setup steps for OM, PO & INV.
• Conducting CRP and UAT.
• Prepared BR 100 Setup Documents.
• Prepared data migration documents for SCM modules.
• Prepared documents for UAT and Test strategies
• Setup of Transaction types and Transaction sources.
• Configured setups in Dev, CRP1, CRP2, UAT, and Production Instances
• Entering Suppliers and Customer masters.
• Requirement gathering for Reports related to OM, INV & PO Testing and Delivery.
• Gave End User training and Prepared User Training Manuals for all Financial Modules.
• Supporting and solving day to day end Users problems
• Attended weekly status meetings with customers and Onsite co- ordinates.
• Attended and monitored the tickets raised in the service desk.
• Raised Tar in Meta link, follow up with Oracle and attending OWC
• Created new tax codes, Segment values, suppliers and Customers.
• Involved in Setting up Cross validation rules and Security rules.
• Converted User Requirements into Formal Functional Specifications and Interfacing with Users

Confidential

Responsibilities:

• Resolved day to day business issues and handled enhancement requests in Oracle Purchasing, OM, Inventory, AP & AR by closely following up with the business and raising SR’s with Oracle Support.
• Production support in P2P and O2C cycles.
• Preparing the functional design documents for enhancement request.
• Performing functional testing and preparing the test cases for enhancement requests.
• Conducting user training on new process changes.
• Supporting users in period end process.
• Monitoring the monthly EBS off releases that are part of implementing the enhancements and patches by production support team in different modules.
• Interacted with the business users through regular meetings and provided updates on all open issues.
• Performed Physical Inventory, Annual Standard Cost update and Month end closures
• Identified the missing setups and configurations and resolved issues in Purchasing and Order Management modules.
• Provided business adhoc reports on need basis from the production
• Performed troubleshooting and found out Root Cause Analysis (RCA’s) to the issues.
• Creation and follow up of Service Requests (SR’s) with Oracle Team during support phase.
• Prepared Functional Specification Documents to fulfill new business requirements of the client during support phase.
• Interacted with DBA Team to get debug/log files from the server and apply the patches.
• Interacted with Technical Team to map the new requirements.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of hierarchies across different plants.
• Provided support on OM issues like sales order stuck in workflows.
• Working in an onsite- offshore delivery model