Ravi Sharma

Dallas, TX

Telephone: +1-214-***-**** [Central Time]

Email : adarpz@r.postjobfree.com

Lead - IT Systems

Professional Summary:

●15+ years of IT experience in Design, Consulting, Implementation, upgrade and Support of Various Oracle Financials modules (AR/AP/FA/CM/GL/OIE/LNS).

●Well versed with Order to Cash (O2C) and Procure to Pay (P2P) business flows in Oracle Applications.

●Familiarity with the Record to Report and Hire to Retire flows in Oracle ERP.

●Very Good insight into the data model of Oracle Financials modules like Oracle Receivables, E-Business Tax, Oracle Payables, Oracle Purchasing, I-expenses, Oracle Projects, Oracle Assets, Cash Management, HRMS (foundation) and Oracle General Ledger.

●Experienced in performing personalization and extensions in self-service-based modules like iSupplier, iprocurement, iExpenses.

●Experienced with Order Management, Oracle Inventory, Oracle Projects, Cost Accounting, Service Contracts, Trading Community Architecture, iProcurement, iSupplier and Oracle HRMS (data model only) modules.

●Currently working in Omnitracs (Formerly QES-Qualcomm Enterprise Services Division) as Financials Systems Lead with sole responsibility of Oracle ERP finance modules, Sales & Use Tax and Enterprise Reporting Systems within finance.

●Experienced in Reporting Tools and Techniques (IBM Cognos, Oracle Discoverer, GL Wand, Noetix Views, BI Publisher etc.)

●Closely worked with the key Business users (office of CFO, CAO, Controller etc) and have good understanding of routine & special business needs & audit requirements.

●Basic Knowledge of Data warehousing techniques (worked on ETL methodology), Facts, Dimensions tables and Reporting Repository (DDS, MDS etc.).

●Functional - Involved in Core Process Analysis (AS-IS Study), Requirement gathering, TO-BE process Mapping, functional gap analysis, custom application design, configuration, module setup, test script generation, writing training guides, training end users and production support of various financial modules.

●Started working with Oracle Corporation as a software engineer/developer; then began working in Oracle E-Business Consulting for Clients as a functional lead/SME.

●Functional responsibilities: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.

●Interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, leading developers, scheduling, producing documentation, and providing production support etc.

●Exposure to various business processes and applications implementation methodologies (AIM).

●Playing PM/BA role for the small ad-hoc projects in the finance area.

●Best practices to be followed for customizations and enhancements within the ERP.

Education:

Master of Business Administration – Systems & Finance

University of Southern California - Marshall School of Business

Los Angeles – CA (U.S.A)

Bachelor of Electronics and Communications Engineering

National Institute of Technology

Durgapur – WB (India)

Technical Skills:

Programming Languages: SQL, PL/SQL (Advanced level)

Development tools : Oracle Discoverer, 9i, Oracle Workflow Builder, Web ADI, Toad,

SQL Navigator, SQL Loader, Data Loader, Oracle Applications Object Library.

BI reporting tools : Oracle Discoverer, Oracle XML Publisher

Databases : Oracle 8/9i/10g/11g/12c

Professional Experience:

Apr2013 Onwards

Company: Omnitracs LLC (Formerly QUALCOMM Inc.)

Title: Lead - IT Systems

Description: I am the functional lead for core Oracle R12 finance modules, Tax (Vertex) & BI Reporting systems within Finance at Omnitracs.

Major Projects undertaken at Omnitracs (Role: IT Lead for Finance)

oCarveout of Omnitracs ERP 11i Instance from Qualcomm during divestiture.

oR12.2.4 Implementation, Implementing Consolidation Ledger, Advanced Global Intercompany setup, FA Corporate Book etc.

oExtensively worked with the banks (both within & outside USA)

Automated the entire payment process from Oracle to BoA for the ACH, Wires & Check Printing (positive pay).

Establish the Lockbox process for the newly acquired companies (Involved in the entire process starting from opening/requesting the bank a/c to going live with the lockbox)

Experience in credit card transactions feed from US Bank into Oracle iExpenses for an AT&T subsidiary in southern CA

Automation of Payment Processing in the Oracle AR by partnering with the third parties vendors like merchant e solutions, united tranzactions

Worked on Bank Statements upload and auto-reconciliation in Oracle Cash Management module

oPartnered with the third-party invoice print vendors/collection agencies to improve business processes through automation and systemic solutions

Created Customer Invoice Global delivery process (Electronic delivery).

Dunning letters and customer statements automation via ABC Amega.

Check Printing from Pirracle by AvidXchange.

oImplemented the Egencia and the Concur for the employee travel & expenses, PCards – Provided the required IT support for the project.

oBI Reporting Upgrade – Lead a team of Cognos, Informatica developers.

oFunctional Lead for Trintech Record-to-Report application for Account Rec’s, Adaptive Insights for FP&A reporting, GL Wand Implementation,Noetix Reporting.

oMerged the newly acquired companies (XRS, Roadnet, Turnpike, Shaw, Sylectus) within Omnitracs Financials systems. IT Lead for the sunset of their systems and migrating their finances (A/c balances, Fixed Assets, Open Transactions, Orders, Contracts etc).

oUpgraded Vertex software from Q to O Series for Indirect Sales Tax (O2C)

oImplementation lead for Adaptive Insights for FP&A reporting (in 2015)

Worked with the Adaptive Insights to architect the solution, create the design for Omnitracs Adaptive Instance, configure the adapters, create extracts for ERP & ADP-payroll, enable seeded FP&A reports, develop custom reports on ADP, manage environment refresh, provisioning & Billing, administer data agent, write sql to modify the loader etc.

Responsibilities:

●Gather functional requirements from the business groups and develop business cases for new IT projects or process changes.

●Perform the solution design, coordinate the UAT, perform the post go-live support.

●Documented standard operating procedures (SOP) for Oracle System Administrators and Procurement Analysts.

●Developed procedural documents such as user guides, job aids and process flow diagram.

●Leading a team on developers and analysts (onshore and offshore) supporting various projects within ERP & BI.

Tata Consultancy Services Ltd Jan2007 – Sep2011

CMC Americas Inc Feb2012 – Apr2013

Summary: Worked in TCS Oracle ERP Practice and supported various US clients.

Developed proof-of-concepts, demonstrated product solutions and provided responses to RFP’s/RFI’s focusing on Oracle ERP products as a part of the TCS Oracle Practice. Served as SME to support multiple Lines of Business such as Sales, Pre-Sales, Delivery for US based clients.

Client: Cricket Communications, Inc.

Title: Associate Consultant (TCS Oracle ERP Practice)

Description: As a member of ERP team in Cricket, my role involved gathering business requirement from the client and delivering the solution. This involved the solution design, unit testing and coordinating with DBA/SYADMIN teams to migrate the solution in UAT/Prod Environments.

Responsibilities:

●Led Global ERP implementations, Solution Architecture and Design, Requirement analysis, Application configuration

●Experienced with Managed Services, Time & Material Delivery Models, Staff Augmentation, RFP/RFI based deal management, Oral Proposals, Pre-Sales support

●Supported Account Management teams in ensuring deal-level profitability tracking for the Oracle team.

●Oversaw project management work for development team, worked with the resource management, effort estimations and task prioritization.

●Implemented Governance, Risk and Compliance (GRC) processes as applicable to the ERP Systems

●Lead and mentored teams of business analysts and developers responsible for designing, developing and maintaining an Oracle ERP implementation across the Finance, Business Operations and Supply Chain organizations.

●Designed a complete custom application and integrated with standard iSupplier functionality. This Application enabled iSuppliers to create Non-PO Invoices in the system. This overcomes oracle’s limitation where-in the isuppliers can only create PO based invoices using the standard oracle iSupplier Module. As a part of this project, I developed the database design, GUI design for OA Framework pages, workflow mechanism and custom programs to interface the data from Custom Applications into Oracle Payables using Oracle Payables Open Interface.

●Worked on Fixed Assets conversion project to transfer Fixed Assets data from one Corporate Book to another corporate Book/tax book. This involved Install base API’s to handle EIB items by updating the item instances/retiring the Asset in EIB module.

●Worked on various Alerts/ Notification projects in Oracle Procurement & Sourcing.

●Designed some key Oracle Discoverer Reports in P2P viz Invoice on Holds Report, AP Payment Schedules Report, EIB Decimal Items Report etc.

Oracle Corporation June2002 – Jan2006

Title: Senior Applications Engineer (Accounts Receivables Product Development Team).

Summary: I was a part of Oracle Receivables Product Development team, developing new features for the product as well as providing business solutions to any inherent gaps within the product reported by existing clients. As a developer, I was involved in coding some of the complex transactions, receipt workbenches & customer module forms/libraries in Oracle Receivables.

Major Projects undertaken at Oracle Corporation

●Receivables API’s: I was responsible for developing & maintaining the various API’s provided by AR (Invoice API, Adjustment API, Deposit API, and Receipts API).

●Data Task force: - As a part of the Data Task force, my job involved analyzing various data issues being faced by the customers and rectifying the faulty piece of code. I was engaged in creating generic data fix scripts for the known causes of data corruption as well as creating the necessary patches to make sure customers don't end up with data integrity issues.

●Enhancements in Transactions/Receipts workbench: Worked on various enhancements and maintenance in the Core AR module for Global customer base. This included Complete Re-architecture (UI make over) of Transactions and Receipt form for 11.5.10. Worked on multiple forms in AR to implement feature of operating unit field as per the new MOAC functionality requirement in R12.

●Worked on developing various other new features and resolving defects in current released version of Accounts Receivables Module While working in product development team in Oracle. I was involved in various enhancements in Receipts and Transactions workbench of Oracle Accounts Receivables (AR) module.

Skills:

●Excellent track record in demonstrating strong analytical and problem-solving skills.

●Good understanding of Software development process, from initial planning through deployment & post go-live.

●Involved in recruitment process, technical training, effort estimation, Orals, resource management (onsite, offshore, contingent workforce) and preparing scope of work/project plan etc.

●Good communication skills, preparing and delivering presentations and business/client handling abilities.

●Like to enjoy outdoor activities, cricket, solving puzzles, follow financial markets & emerging technologies in the tech space.

Contact this candidate