Candidates About

KARY

Education: Bachelors in Computer Science from Mumbai University.

SUMMARY

• Eight years of experience as oracle Consultant where I was involved with End to End Implementation, Configuration, Customization, Conversion, Interface, Extension, Development, Production support and Testing in Oracle E-Business Suite (EBS) 11i and R12.
• Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info. 
• Experience in Functional/Technical Knowledge in Oracle Financial Applications with Distribution and Supply Chain Modules like (OM-Order Management, PO-Purchasing, INV-Inventory, WSH-Shipping) and Financial modules like (AP-Oracle Payables, AR-Oracle Receivables, GL-General Ledger). 
• Expertise in Oracle Cloud Fusion business processes and latest releases like Release 11 and Release 12.
• Provided full system application development life cycle (SDLC) experience ranging from analysis & design, development, testing, implementation, documentation and production support.
• Skilled in designing, developing and maintaining UNIX shell scripts to collect and monitor database metrics and Stats pack snapshots and reports as well as monitored and provided weekly reports on the server's memory, disk and CPU I/O using HP tools and UNIX command-line utilities. 
• Functional knowledge with great practical experience in the field of Account Receivables (AR), Fixed Assets (FA), advanced collection, Cash Management and Credit Management (CM).
• Led monthly Treasury analysis processes (liquidity, cashflow impact, bank benchmarking), financial review processes (actual vs. plan and forecast), annual operating plan establishment, and periodic forecast through usage of SAP (ERP), Hyperion (Financial Planning, Smart View, Essbase), and multiple treasury management systems. 
• Extensive experience in developing and Customization of the Oracle Fusion Business Intelligence reports as well as experience in Oracle Fusion Security and roles defining like Data roles and Organization security profiles. 
• Experience in Oracle E-Business Suite architecture and integrations between modules specifically related to HRMS.
• Strong experience in various rounds of System Testing, Functional Testing, Integration Testing and User Acceptance Testing.
• Proficient in mapping processes with specific use cases and actors using UML diagrams, 
  SWIM lane diagrams, flowcharts, and workflow models. 
• Served as a liaison between the business and IT to provide Oracle ERP functional and technical business solutions that meets needs of client managers and other stake holders.
• Defined Supply chain business process (Order to Cash, procure to pay Manufacturing, Logistics, supply and demand planning).
• Strong skills are in PL/SQL, Oracle8i, 9i, 10g, Forms4.5, 6i, Workflow2.6, VB, Excel Macro, ASP, SQL Server, Manual testing, preparing test plan and test cases using QC.
• A highly motivated, energetic individual and a team player with excellent analytical & problem solving, communication and interpersonal skills.
• Large number of successful implementation, global rollout, upgrade and improvement projects with detailed oracle expertise.
• Highly motivated team player with positive attitude, goal oriented and excellent business and interpersonal skills.

TECHNICAL SKILLS

• Primary Skills: Oracle EBS Technical Development (RICEW Components), Supply chain, Interface (Inbound and Outbound), Conversions, OA Framework, BI Publisher, Workflow builder.

• Packages (Incl ver): Oracle EBS 12.2.2, 12.1.1, 12.0. 
• Modules: Purchasing (PO), Account Payables (AP), Inventory (INV), FA, Credit Management, Sub-Ledger Accounting (SLA), General Ledger (GL), Advance Collection, Fixed Assets, HRMS and Absence Management Modules. 
• Operating Systems: Win 8, Win 7, UNIX. 
• Languages: Oracle SQL, PL/SQL, Java, UNIX Shell Scripting.
• Development Tools: Toad, SQL * Plus, SQL Developer, JDeveloper, BI Publisher, Putty, Win-SCP. 
• Database: Oracle 11g, 10g.
• Documentation: MD050, MD070, CV040, CV060, TE020, BR100.

WORK EXPERIENCE

7-Eleven, Dallas, TX                                                                                   

Sr. Oracle Fusion Consultant                                                                             February 2016 to Present

Description: Oracle EBS R12 Procure to Pay Implementation project to add Oracle Procure to Pay as a new functionality to their existing Oracle Application system including crucial enhancement in the Oracle Fusion HCM modules as well as GL, AP, AR, Cash Management, Asset Management. The main goal of this project was to help Client move from their old legacy system that supported their distribution processes, to new Oracle EBS R12 system. Worked as Senior Oracle R12 Technical Consultant contributing in design and development of Interfaces, Conversions and Reports for various Oracle modules including PO, INV, AP, AR, HRMS, SLA and GL. 

Responsibilities:

• Led the whole team through the software development life cycle for successful implementation of major Financial supply chain applications.
• Set up the WMS system under Oracle to comply with the new warehouse facility. 
• Implemented Order to Cash (O2C) modules: Order Management (OM), Inventory (INV), Warehouse, Purchasing, Receiving and module integrations with Order Management (OM), General Ledger (GL), Accounts Receivables (AR), Cash Management (CM) and Inventory (INV) with in EBS System.

• As a Senior Oracle EBS Technical Consultant, contributed in design and development of the Implementation of Oracle R12 Procure to Pay, from end to end. 
• Performed benefits and work structures data population within Fusion HCM using spreadsheet based loaders. 
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration etc.
• Worked on Fusion Workforce Deployment (Global HR) and Workforce Development (Talent Management). 
• Designed, Customized and Setup approval flow with Approval Management Engine (AME) which involves defining attributes, conditions and rules according to the requirement. 
• Applied quarterly security patching to Windows and UNIX Oracle databases.
• Led the implementation team on the outbound fulfilment side of the Order to Cash cycle in solution design, specifically related to WMS Rules Engine and the sales order picking process.
• Wrote Custom PL/SQL packages for the Project Costing and Billing extensions and developing various reports for Invoicing, Billing and Man-hour reports.
• Utilized the WMS rules engine for picking, task management and label printing.
• Worked cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications.
• Successfully implemented very complex Oracle Advanced Collection, Oracle Projects, eBTax modules and Imaging solution including Weblogic and Middleware Fusion and Webcenter. 
• Installed/Configured using GUI based installers on windows and using VNC viewers in Linux for Oracle Forms and Reports using Oracle Fusion Middleware 11g on a Windows and Linux Based operating systems.
• Involved in implementation, testing and post production support of Oracle Applications Procure to Pay R12 modules - Purchasing, Payables, iProcurement, Sourcing, Inventory and Approval Management Engine (AME). 
• Supported the application with focus on accounts payable (AP), accounts receivable (AR), general ledger (GL) and fixed assets, translating high-level business requirements into functional specifications.
• Developed oracle PL/SQL packages, Unix shell scripts, concurrent programs, dollar u jobs as per business requirements to achieve the required functionality. 
• Designed and developed Supplier, Supplier Site and Supplier Contact Conversions to migrate legacy Supplier data to Oracle R12 EBS system. 
• Designed corporate financial process model with proficiency in Use Case development, UML Modeling with Activity diagrams, SWIM lane diagrams using MS Visio. 
• Worked in Payables Interface tables and Supplier Open Interface Import programs to meet the Conversion requirements of Supplier records from legacy to Oracle. 
• Stabilized the Oracle Advanced Collection applications and its extensions by proactively leading teams to fix all the existing issues. 
• Involved in developing PL/SQL stored procedures to meet the Interface and Conversion requirements.
• Configured Data upload tools to seamlessly upload data into Oracle application. Coordinated with onshore/offshore team during design, development and support phase of the project. 
• Involved in fixing code issues raised during SIT (System Integration Testing) and UAT (User Acceptance Testing) and worked with oracle support team through Service Requests (SR's) on seeded performance Issues.
• Identified areas of Improvements and changes wherever applicable to custom codes and development standards, in-order to mitigate gaps and thereby improving overall quality of deliverables. 
• Actively Involved in Pre-and Post-go-live activities, including deployment. 

Oracle Business Analyst

GE Transportation, Erie, PA                                                                     January 2014 to January 2016

Description: Worked as a Project lead on Oracle EBS Implementation and Upgrade projects by intensely working on Oracle R12 Interfaces, Conversions, OA Framework custom web pages build and standard extensions, BI Publisher reports, Oracle Workflow customization, UNIX Shell Scripting, SQL*Loader and UTL_FILE. 

Responsibilities: 

• Worked as a Lead for Oracle 11i to R12.2.2 upgrade for various Oracle Financial modules including Purchasing (PO), Payables (AP), Sub-Ledger Accounting (SLA), Credit Management, General Ledger (GL) and Receivables (AR).
• Designed various extensions for Oracle Order Management, Payments, Accounts Receivables, Cash Management, Credit Management, Advanced Collections and other modules to integrate custom business processes for Order-to-Cash. 
• Used Oracle Fusion Functional Setup Manager (FSM) to implement offerings like workforce deployment, workforce development. 
• Involved in analysis of the Oracle 11i custom Code remediation suggestions generated by Panaya tool on upgraded Oracle R12 system.
• Developed programs to trouble shoot, fix the data issues in WMS Receiving and shipping areas. 
• Involved in creating Project tracker to track and monitor the Oracle 11i custom code changes compatible with Oracle R12 standards. 
• Developed Unix Shell scripts to process data. Generated tab delimited file with required attributes in sequence and copied flat file to the main server. 
• Defined rules, strategies in WMS application to improve the performance of the equipments and pickers. 
• Worked with Oracle Fusion Middleware/OSB console/SOA adaptors to create Orders in Order Management. 
• Researched and worked with the business and developers on Production issues impacting the General Ledger, invoices, Account Receivables, other financial transactions, and reports.
• Configured and setup Oracle Fusion HCM Core HR as per business requirement. 
• Prepared solution design for various process improvements and interfaces in Oracle across many modules (HR, AR, AP, Advanced collection, Field service). 
• Took part in Development, Testing, Implementation and Documentation of ALC, AUDITS Projects, Project Costing and GL, AP, AR, FA, Oracle EBS Modules.
• Designed and Implemented secure SFTP file transfer model considering archive and success/failure notifications strategies between Oracle Fusion SFTP server and external/internal payroll systems to transfer output Integration files. 
• Workflow changes were made as well as system administration menu changes, AME (Approval Management Engine) updates and interface updates working with on-shore, off-shore and Oracle On-Demand (OOD). 
• Actively implemented Oracle provided standard views (e.g. PO_HEADERS_ALL#) to replace _ALL tables to meet Oracle R12.2.2 standards of online patching. 
• Developed Oracle PL SQL stored procedures, functions, packages using the debugging features of TOAD and SQL Navigator. 
• Involved in customization of Oracle workflows wherever a change in Oracle 11i codes is necessary to meet Oracle R12 standards. 
• Created Basic Flow, SWIM-Lane, Work Flow, Use Case, Entity Relationship and Data flow diagrams. 
• Worked on fixing multiple Performance issues due to existing Oracle 11i codes by introducing new Indexes and modifying PL/SQL join conditions. 
• Integrated OAF with BI Publisher reports, enabling download of search results from Advanced Tables by implementing XDO Utilities.
• Worked on Oracle standard workflows (PO Approval) and customize it to meet specific requirements of Approval channelizing based on Approval amounts.
• Implemented Decryption utilities in UNIX shell scripts to decrypt the secured legacy HR data during HR conversion to Oracle.
• Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project. 

Oracle Business Analyst

National Oilwell Varco, Houston, TX                                                 January 2012 to December 2013

Description: Worked as a Senior Oracle EBS R12.0 Implementation project of Oracle Projects Accounting (PA), Project Contracts (OKE) and HRMS (HR). The project also included proper implementation of various Oracle Financial modules like GL, AP, AR, Credit Management and Advanced collection. Designed and developed multiple Interfaces, Conversions, custom webpages, BI Publisher Reports, UNIX Shell Scripts, SQL*Loaders, Workflows.

Responsibilities:

·         Worked extensively in Production support, Upgrade & Testing on Financials modules, AP, AR, GL, CM, FA, SLA, EB Tax, iExpenses, iPayments and knowledge on O2C, P2P & Inventory on Oracle Applications.

·         As a Business Analyst, I am responsible for the smooth operation of the Oracle ERP in the production environment. Day to day activities included: Monitoring activities related with General Ledger, Account payables, Account Receivables, Credit Management and Cost Management modules accounting processes and Interfaces from OM to AR and fix the issues and cleared the transactions.

·         Involved in data conversion effort to facilitate good quality of data from Oracle EBS to Oracle Fusion HCM. 

·         Built and enhanced WMS labels such as unit and LPN labels using label solutions and C programs. 

·         Worked on various enhancements and developed packages using oracle PL/SQL, UNIX shell scripts, concurrent programs and scheduled them using dollar universe. 

·         Worked on gatherings for configuration, conversion and enrolments in Fusion Benefits.

·         Implemented procedures for execution and tuning of Oracle Fusion Middleware products such as SOA and Coherence, providing technical assistance for the implementation of FMW components.

·         Worked on the Integration of Oracle Fusion financial like GL, AR, AP, PO etc.

·         Provided post go-live support for WMS, Order Management, Shipping, along with all inventory related interfaces.

·         Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements. 

·         Used Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management.

·         Worked in close collaboration with other teams to rollout WMS application, MQ broker, and Oracle EBS code.

·         Authored training documentation and led end-user training for WMS mobile applications.

• Performed Planning for Financials setups, enhancements and customizations. (Payables, Receivables, Fixed Assets, Cash Management, Credit Management for multiple bank accounts, Inventory, General Ledger, Project Accounting, Order Management and HCM).

·         Monitored AR & GL Interfaces, fixed the issues in GL, AP, AR, CM, EB Tax, SLA, O2C to help in month end closing.

·         Played a vital role in project discovery, conducting JAD sessions, requirements gathering, swim lane logic flows, use case development. 

• Reconciled all balance sheet General Ledger accounts for the fiscal year monthly.

·         Updated Suppliers' & Customer Master Data in Production including Banks, Suppliers, Suppliers Sites, Customers & Customer Sites information etc. Fixed OM to AR Interface issues.

Oracle EBS Business Analyst

Adobe Systems, San Jose, CA                                                          October 2009 to November 2011

Description: Excellent command over functional aspects in setup, implementation, Configuration, unit and integration testing of Oracle Purchasing, iProcurement, Inventory, Credit Management, Cash management, Order Management, customizations on solutions designed for meeting gaps in client requirement and application. Proven expertise in implementing Ariba-Oracle ERP integration. Experience in planning, preparation of test plans, test scripts, test cases using Quality Center.

Responsibilities: - 

·         Successfully converted 5 legacy systems to Oracle EBS suite. Acted as a primary go to person for all the Purchasing and Payables requirements. 

·         Configured the application modules based on the business requirements and performed Purchasing and Payables setups like Payment Terms, PO Lookups, Purchasing Options, Payables Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.

·         Worked on Auto-lockbox, bank statements and transactions as part of Payables(AP), Receivables (AR) and cash management(CA).

·         Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files. 

·         Served as point of contact for Oracle EBS modules (AR, FA, AP, GL, Advanced Collection, Project Accounting and Cash Management).

·         Analysed functional requirements for Multi Org, Purchasing, Payables, iProcurement, Order Management, Inventory, AME. 

·         Helped creating General Ledger (GL) and Operating Unit (OU) and captured the business processes in form of scenario matrix for testing various process alternatives.

• Analysed the general ledger, maintained balance sheet accounts and created journal data entries

·         Good understanding on Approval hierarchy and Approval Management Engine (AME). Ability to interact directly with client and/or end users / Super users to solicit information and define solution requirements.

·         Provided post Production Support and assisted user community with all the issues. Established and drove Conference Room Pilots (CRP) from start to finish. 

·         Conducted User Acceptance Testing (UAT - End to End Integration testing and developed and maintained supply chain management saving dashboard.

·         Conducted meetings with Super Users/SME's to gather requirements for financial modules.

·         Worked closely with finance user team and oracle finance consultant on issues like Intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.