SUMMARY:

• Distinguished Oracle Techno - Functional Analyst with 8+ years of combined relevant experience working on multiple projects on time, under budget with superior customer satisfaction through consistent management of tasks with a defect ratio less than 20%
• Possess multiple industry working experience - Banking, Retail, Pharmaceuticals, Manufacturing, Media
• Experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies using Agile and Waterfall methodologies.
• 3 full life cycle Oracle EBS implementations, 1 full life cycle Oracle Fusion/Cloud implementation, 1 Oracle reimplementation (11. .1.3), 3 upgrade projects and Production Support roles across multiple Oracle ERP platforms (Oracle Cloud/Fusion, Oracle EBS R12,11i)
• Strong knowledge in Oracle Financials like (GL­-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management, EB-Tax - E-Business Tax and iExpenses (Internet Expenses), PO (Purchasing), OM (Order Management), WSH- Shipping, WMS - Warehouse Management System, Service Contracts, Install Base, Manufacturing (INV-Inventory, WIP-Work in Process, BOM-Bills of Materials and AOL (Application Object Library)
• In depth understanding of OTC (Order to Cash), P2P (Procure to Pay), Record to Report cycle, Drop Ship process in the Oracle ERP platforms
• Proficient in understanding of MOAC and TCA architecture in Oracle Applications.
• Experience in creating clear and precise documentation from user requirements and system analysis using AIM Methodology (Document types include BR100, MD50, MD70, MD120 etc.)
• Strong programming knowledge in creating Packages, Procedures, Functions, Triggers and other database objects using SQL, PL/SQL and Shell Scripts.
• Working Knowledge on RICE components (Reports, Interfaces, Conversions, Extensions) along with workflows, OAF (Oracle Application Framework), ADF, JDeveloper, XML Publisher Reports
• Lead Conference Room Pilot and other testing with Business Users to validate system and process solutions
• Experienced in working with Clients and Managers in identifying key release deliverables, schedules and priorities and supervising work done by offshore teams.
• Experienced in data modeling, Normalization, database design, data loading, data retrieval, modification and archival techniques.
• Experience in using version control tools like Visual Source Safe, PVCS.
• Good knowledge with designer tools like Microsoft Visio and Rational Rose and UML designing and Statistical Modeling
• Hard working, result oriented with excellent organizational and leadership skills with a huge capacity for innovation and thriving on continuous learning and change

TECHNICAL SKILLS:

Languages: SQL, PLSQL, Shell Scripting, C, JAVA, .NET (VB)

ERP Packages: Oracle Cloud Fusion release 11/12, Oracle EBS - versions R12/11i

Web Languages: HTML, DHTML, XML, JSP

Databases: Oracle Databases, MS Access, SQL Server Studio, MS SQL

CASE Tools: Oracle Forms, Oracle Reports, Oracle Discoverer, MS Office Suite, Microsoft Visual studio, Rational Rose, FrontPage, Adobe Photoshop, Flash, TOAD, BI Publisher, and Oracle OBIEE

OS: All windows Platforms, UNIX

WORK EXPERIENCE:

Confidential, St Louis, MO

Sr. Oracle Applications Consultant

Responsibilities

• Responsible for working on any enhancements, PROD break fixes and building the base configurations in the Oracle ERP system for the following modules: Purchasing, Sourcing, Inventory, Advanced Supply Chain Planning, Projects, Financial Modules that include GL, AP, AR, iExpenses, Cash Management, Fixed Assets
• Experience providing day-to-day end-user support of the following functional areas: Procurement, Material Planning, and Inventory Management.
• Developing and customizing workflows using Oracle Workflow Builder and/or Approvals Management (AME).
• Working knowledge of Oracle Application Framework (OAF): personalization, html pages, and java class extensions within the context of the Oracle e-Business Suite.
• Working knowledge of Oracle Forms, Reports, and/or BI Publisher along with OBIEE and/or OBIA.
• Working on implementing and developing technical solutions in the EBS application along with appropriate functional setups and configurations required
• Preparation of Solution Approach document and Technical Architecture documents
• Create system documentation for solution design, technical design, functional setups, test scripts, and training documentation in Oracle SCM and Finance modules
• Lead Conference Room Pilot and other testing with Business Users to validate system and process solutions
• Address any issues with various key stakeholders involved and explain set standards to both internal and external parties

Environment: Oracle Applications R12.1.3, Oracle Workflow Builder 2.6.3, Oracle Databases 11.2.0.1, PLSQL, SQL Developer, Toad (11.6, 12.1), SQL * Loader, Putty, Microsoft Visio

Confidential, Quincy, MA

Sr. Oracle Applications Consultant

Responsibilities

• Involved as the Functional lead for implementing and setup of Oracle Financials with primary focus on iExpenses and Oracle EB-Tax as part of the Oracle ERP Upgrade from R12.1.3 to R12.2.6.
• Working closely and adhering according to the Project Plan for making the foundational configurations in the Finance Modules (iExpenses, EB-Tax, AR, Cash Management, AP, GL)
• Create system documentation for solution design, conversion design, functional setups, test scripts, and training documentation in Oracle financials.
• Provide clear direction to various teams involved on how to design the iExpense and EB-Tax module, based upon global design, as defined by GPO as part of Confidential 's new Global Accounting Rollouts (GARP).
• Involved in Oracle Global Implementation (Rollouts) across multiple countries starting out by building the United Kingdom and Poland.
• Involved in retirement of legacy Reporting tool (Oracle Discoverer) which will be replaced by the traditional Oracle XML/BI Publisher reports.
• Responsible for handling necessary technical and functional changes for Localization/Globalization specific features used by Confidential in EB-Tax and Receivables for Italy, Brazil, Saudi Arabia, Poland along with implementing existing regulatory, localization and language requirements
• Configure and Test EBS application and custom software components for effective Solution design of Oracle EBS Financials solution
• Work with cross functional teams to develop and implement an end to end Solution across all business areas.
• Develop and maintain documentation for Business requirements, Solution design, System Setup, Gap analysis and Functional design for all RICE components
• Review leading practices and standard out of box processes and capture requirements in BRDs and configuration
• Plan cutover activities from both technical and functional domain and perform Post Production support activities

Environment: Oracle Applications R12.2.6/R12.1.3, Oracle Discoverer, Oracle Databases 11.2.0.1, Oracle Forms 6i, Reports 6i, PLSQL, SQL Developer, Toad (11.6, 12.1), Discoverer Reports 11.1.1, SQL * Loader, Putty, Microsoft Visio

Confidential, Jamesburg, NJ

Oracle Applications Specialist - Supply Chain Management

Responsibilities:

• Worked as an Oracle Supply Chain Functional Consultant in the Business Process Reengineering (BPR) team which is responsible for all the seeded and custom components in the SCM sphere for all of Canon's EBS workspaces.
• Responsible for working on Enhancements, PROD break fixes and building the base configurations for the following modules: Purchasing (PO), Inventory (Inv), WIP, BOM, Order Management (OM), WSH (Shipping), Oracle VCP, Quality Plan and work with counterparts associated to the Financial Modules (AR, AP, GL etc.)
• Handle month end activities related to inventory closure for checking the Stuck Transactions, Pending and uncosted Transactions.
• Analysis and documentation of business processes, Systems Requirements, conceptual designs, working on the functional design specifications (FD's, MD50’s etc.) for proposed system capabilities.
• Migrating the code, configurations, custom objects and patches in the existing 11i EBS system and involved in migration of custom components as part BAU activities.
• Performed business requirements gathering, AS-IS & TO-BE Study, GAP Analysis, Configuring CRP Applications, Test Plan Preparation, Unit testing, UAT and Post GO-LIVE Support for projects assigned to.
• Automation of PO Receiving for some of Canon’s vendors for third party items including EDI PO Generation and PO Acknowledgement
• Handled programs to create Dropship PO’s for Equipment orders and Waste Liners in copy machines that were created based on the PO qualifiers, which was in turn handled by grouping of the requisition numbers.
• Writing complex pick rules to meet requirements for picking material from specific sub Inventories, Lot numbers, zones and Customize the Picking and Shipping process based on the client requirement.
• Part of Design team to create a new process for Service Contracts/IB flow creating Requisition/PO’s for product installation software (UNIFLOW, Colorlynx)
• Developed Test plans associated to the Custom Object list which had to be executed in HP Quality Center 12.01

Environment: Oracle Applications 11.5.9, Oracle Forms 6i, Reports 6i, PLSQL, SQL Developer, Toad (11.6, 12.1), Oracle Databases 11.2.0.1, Discoverer Reports 11.1.1

Confidential, Quincy, MA

Oracle Applications Functional Consultant

Responsibilities:

• Worked as an Oracle Apps Functional Consultant in the ADM-CSO team which is responsible for the overall build of any EBS environment/instance.
• Responsible for building the base foundational configurations of all Financial Modules (GL, AR, AP, CE, FA, iExpenses etc.) and Procurement modules (PO, iProcurement etc.)
• Involved in Oracle Implementation across multiple Business Units (Europe and Middle East Asia (EMEA), India, North America) for Confidential ’s Oracle Financial applications.
• Analysis and documentation of business processes, Systems Requirements, conceptual designs, working on the functional specifications (BR100’s, MD50’s and MD120’s) for proposed system capabilities.
• Configuration of the Payment Process Profiles in Oracle AP and setup of AME rules (Approval Management Engine) through workflow.
• Worked on the setups of the GL Ledgers (Primary and Secondary), defining Ledger Sets, Data Access Sets, Translation, Revaluation, Designing of the Chart of Accounts, setting up cross validation rules and security rules, etc.
• Worked on the setups and configurations for of the Sub Ledger Accounting module - Accounting Method Builder, Line Types, Account Derivation rules, Journal Line Types, Sub Ledger Accounting methods, Application Accounting Definitions, etc.
• Performed analysis on Configuration migration tools like Config Snapshot, Rapid E-Suite etc. across multiple EBS platforms to enable our team to automate the configuration migration involving large volumes of data.
• Also performed analysis on Oracle GRC CCG (Configurations Control Governor) to detect key changes in application setups, ensuring the application integrity and associated audit requirements are met.
• Implemented GST and TDS as part of the Oracle Implementation in India.

Environment: Oracle Applications R12.1.3, Oracle Forms 6i, Reports 6i, PLSQL, SQL Developer, Toad (11.6, 12.1), Oracle Databases 11.2.0.1, Discoverer Reports 11.1.1, SQL * Loader, Putty, Microsoft Visio

Confidential, Waltham, MA

Oracle Fusion Analyst

Responsibilities:

• Part of Oracle Fusion Implementation, working as an SCM Functional/Testing Analyst.
• Worked on the Business Requirement Specifications to bridge the gaps between the out of box functionalities offered by Oracle and the Business needs of Confidential
• Involved in Process design specifications from a Supply Chain perspective in Oracle for Client's new product launch in US - namely Zejula, Varubi, Varubi (IV).
• The cloud fusion projects followed the rapid implementation methodology through the core Agile business throughout the project tenure.
• Worked on configuring Inventory Management module of Oracle Fusion Order to Cash
• Experience in Oracle Cloud security and workflows in SCM and Finance domains.
• Worked on the setups of Oracle i-Procurement - defined the Requisition Templates for Oracle i-Procurement Public Lists, Define Information Templates, Define Shipping Networks and Customer Locations for Internal Requisitions, Set Up Content Security, Create Commodity-Based Expense Account Rules
• Worked on the Configuration of Oracle i-Procurement Punchout's to supplier sites - defined content zones, setup transparent and direct punchout's.
• Conducted User Acceptance Testing (UAT) and collaborated with the associated teams during the development of associated test plans, test cases and test data.
• Hands on experience using Oracle integration cloud services to build integration with Confidential ’s new ERP system.
• Worked on GxP requirements based on Pharmaceutical Industry standards in Supply Chain Management.
• Analysis and Documentation of business processes, Systems Requirements, conceptual designs, working on the functional and Testing Document specifications
• Attended Training sessions on Oracle Cloud platforms associated to the clients requirements from an Implementation standpoint.

Environment: Oracle Cloud Release 11, Cloud Web ADI Applications, Microsoft Visio

Confidential, Quincy, MA

Oracle Applications Lead Systems Analyst

Responsibilities:

• Worked as an Oracle Apps Systems Analyst and involved as the Functional lead for the Receivables and Cash Management modules as part of Confidential ’s R12 FinApps Reimplementation project. The Financial Applications are currently in Oracle Apps 11.5.10 and the Procurement system in R12.1.3
• Setup the initial foundational configurations; define the fundamental setups for all the Financial Modules (AR, AP, CE, MarkView etc.) involved, creating the associated Responsibilities as per the business need and also setting up any associated DFF’s.
• Analysis and documentation of business processes, Systems Requirements, conceptual designs, working on the functional specifications (BR100’s, MD50’s and MD120’s) for proposed system capabilities.
• Involved in the Implementation phase on various projects, creating the Business Requirements (BRS) and also in the overall end-to-end Functional based testing for the associated Projects.
• Hands on experience on AR Electronic Interfaces between Oracle and source systems like Navision, CBS, MyBilling.
• Worked on GL PDE Customization from a Sub ledger perspective (AR & AP) to prevent a Future dated Journal entry from Posting.
• Moving the existing AME rules, Global Workflow Rules and also possibly work on the design, build and deliverables (which may also support both Global Procurement and Global Finance business rules).
• Migrated the code, configurations, custom objects and patches from existing 11i EBS system to R12 System.
• Requirement analysis, Data Mapping Templates & Data File formats for Conversions (in Cash Management and Account Receivables).
• Involved in the Effort Estimation for Technical deliverables and various Gaps identified in the existing customizations.
• Participate in Design Workshops conducted by the Business for the associated workstreams

Environment: Oracle Applications R12.1.3/R11.5.10, Oracle Databases 11.2.0.1, Oracle Forms 6i, Reports 6i, PLSQL, SQL Developer, Toad (11.6, 12.1), Discoverer Reports 11.1.1, SQL * Loader, Putty, Microsoft Visio

Confidential, Malvern, PA

Oracle Applications Techno-Functional Consultant

Responsibilities

• Working as an Oracle Apps SCM Techno-Functional IT Consultant, involved in various Implementations, Upgrade project from R12.0.6 to R12.2.4 and also in the Production Support Environment.
• Heavily involved in working on the Custom Object list and end to end testing of both the Seeded Forms/Functionalities along with the Custom Objects post upgrade.
• End to End flow in the Order to Cash (OTC) modules: OM (Global Order Processing - GOP), Oracle VCP (Value Chain Planning), Inventory, Warehouse, Purchasing, Receiving and also WIP Process for all the Discrete Jobs during the assembly process for various ATO, PTO items.
• Possess experience with other standard and custom module integrations that deal with the following modules: WIP, BOM, WSH, WMS
• Functional IT lead in the Defense related Project for the United States Air Force (USAF) called the ‘AFWAY Order Process’
• Worked on Mobile applications interfacing with Oracle during the WIP Job process (WIP Issue, WIP Move and Completion).
• Worked on planning module ASCP during the R12 Upgrade activities to check impact on custom components.
• Functional IT Analyst in an internal project related to Dropship Process (Baja Direct Shipment) for the Inventory flow across two entities. The project is dealing with moving out the existing process which is in a legacy system (NSP) to Oracle R12.
• Drafted out the project scope and the Requirement Specifications for physical shipment of Inventory and also the IT solution for the Dropship process.
• Involved in the design of the following interfaces:
• PO Outbound Interface to R12 from RCL (External Network)
• Order Status/Advanced Shipment Notice into R12

Environment: Oracle Applications R12.2.4/R12.0.6, Oracle Forms 6i, Reports 6i, PLSQL, SQL Developer, Toad (12.1), SQL * Loader, Putty, Microsoft Visio

Confidential, Ann Arbor, MI

Oracle Applications Techno-Functional Consultant

Responsibilities

• Working in Confidential Production support team as an Order to Cash and Supply Chain (SCM) support consultant.
• Production Support Techno-Functional Consultant with hands on experience in the Order to Cash (OTC) modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations with OM, GL, AP (Account Payables), AR, PO (Purchasing/Sourcing), INV, WIP, BOM, WSH, WMS within the EBS System.
• Resolving a high number of Production Support Tickets/ Work Orders with a high SLA
• Collaborate in definition of business processes, documentation of business processes and systems requirements, conceptual designs and/or feasibility studies for proposed system capabilities.
• Integral part of the team handling any kind of user related issues, any production related task to monitor the activities for the various business processes to function accordingly.
• Working on several key issues in the areas of manufacturing, shipping and LPN receiving along with 3PL related issues.
• Worked on custom iStore module called ProCAB and resolved issues related to the Sales Orders placed from ProCAB.
• Created a high number of SQL scripts and written procedures using the PLSQL programming to load the data from flat files into custom tables for various cases (Using UTL and SQL Loader)
• Explain Plan, TKPROF to analyze the performance aspect of several different long running programs and scheduled jobs using the standard tuning tools and also a custom Tuning tool called HOTSOS.
• Created and developed several XML/BI Publisher report according to the requirements which included the changes to be made to several custom reports after the Upgrade.

Environment: Oracle Applications R12.0.4, Oracle Forms 6i, Reports 6i, PLSQL, Toad (11.5, 12.1), SQL * Loader, WinSCP, Putty

Confidential, Ann Arbor, MI

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Part of the Data Conversion/Migration project O2C OU Consolidation which was to essentially migrate the data from different operating units of Confidential from UK and Spain into the US Operating Unit
• Developed Item Master, Service Contracts and Sales order Conversion scripts and developed an API to apply holds to the original orders in open status that were converted in the UK and Spain Operating Units
• Analysis and design of Application Security Documents and Multi Org Structure, Multiple reporting currencies.
• Developed scripts including custom APIs in order to convert all the orders in ‘Closed’ status (Closed order conversion) in order to bring the closed orders into the US Operating Unit in ‘Open’ status where customized programs were already in place to automatically book those orders, Invoice those particular orders, Run the AR adjustment criteria, Run the Revenue Recognition and eventually generate the desired reports.
• Completed Technical and functional feasibility studies for Service Contracts module.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
• Developed XML/BI Publisher report to identify the order deliverables that were held during the migration process

Environment: Oracle Applications R12.1.3, O2C (OM, AR, INV, GL), Forms 6i, Reports 6i, PLSQL, SQL* Loader, Toad 11.5, WinSCP

Confidential, Memphis, TN

Information Technology Analyst

Responsibilities:

• Worked with the Information Technology professionals dealing with the software Releases used in the stores and Distribution Centers of AutoZone.
• Utilized technical knowledge and partnered with the Business Systems Analysts and helped translate business and functional requirements into detailed design from overall system architecture down to code level design.
• Assisted the project manager in the business-oriented programming projects, including analysis, design, coding, testing, debugging, implementation and administration.
• The translational analysis involved working on the code using UNIX shell Scripting, analyzing and redesigning it into a detailed flow chart
• Worked as a QA intern for the release management website intranet ‘ReleaseNet’.

Environment: Shell scripting, QA Analysis, Microsoft Visual Studio (C#), MS SQL SERVER 2008, Oracle 10g