HARISH VENTRAPRAGADA

ac3i1z@r.postjobfree.com

732-***-****

Career Overview

Total 9+ Years of Experience as Oracle EBS Consultant Providing Solutions of Upgrade, Maintenance, Testing and Production Support in 11i and R12.

Experience in Financial Modules such as Account Payables (AP), General Ledger (GL), Account Receivables (AR), Fixed Assets (FA), Purchasing (PO), Project Accounting (PA), Oracle Project Management (OPM), Oracle Internet Expenses (iExp), Oracle Time and Labor (OTL), Sub-Ledger Accounting (SLA), Trading Community Architecture (TCA), Cash Management (CM), iSupplier.

Functional Responsibilities: Requirement Gatherings, Functional Gap Analysis, Configuration, Training End Users, Writing Training Guides.

Technical Responsibilities: Designing Custom Technical Solutions, Code Fix and Data Fixes

Experience working on end-to-end Procure to Pay (P2P) and knowledge of Order to Cash (OTC).

Proficient in SQL and PL/SQL.

Experience working on RICE Components.

Knowledge of Setups. E.g. COA, Calendars, Currency Rates, Cross Validation Rules. And Ledgers

Experience of developing conversion programs and Interfaces (Inbound & Outbound).

Experience in using tools like SQL *Loader, Data Loader, FND LOAD.

Knowledge of Writing/Modifying UNIX Shell Scripts.

Creating WEB ADI’s to load data in to oracle upon business requirement.

Proficient in Performance Tuning SQL statements using SQLTRACE and TKPROF.

Involved in QA Testing process and coordinated with end users for UAT.

Experience of writing Technical/functional specification documents using AIM Methodologies.

Performed Fundamental administrative tasks Including registering Concurrent Programs, Flex Fields, Value Sets, responsibilities and Menus.

Coordinated with Oracle support to resolve application issues, bugs and TAR/SR management.

Production support, bug fixing and enhancement.

Working Experience at Different Locations (United Kingdom, Poland, USA, India).

Coordinated and Planned with Various Teams for Release Roll Out plans and Maintenance Plans in Support Projects.

Exceptionally well organized with Strong Communication, Inter-personnel, Analyzing Skills and a desire to learn new technologies and tools.

Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

Education:

Bachelor of Technology – Computer Science & Engineering from Jawaharlal Nehru Technological University, India, Hyderabad, 2007.

Technical Skills:

ERP : Oracle Applications Release 11i & R12

Databases : Oracle 9i, 11g.

Programming Languages : SQL, PL/SQL, UNIX & OAF

Development Tools : Forms & Reports 6i/10g, Xml Publisher, Workflow builder

ERP Modules : AP, AR, GL, SLA, PA, TCA, FA, iExpenses, OTL, CM, PO

Version Control : Clear case

Migration Control : Kintana, Serena

DB Tools : Toad, SQL Developer

Additional Tools : BMC Remedy, Service Now, Master Craft and Hyperion Brio, OBIEE, HP QC

Certifications:

IBM Achieved Certification: IBM Certified Administrator – Cognos 10 BI

Project Experience:

Project Name: R12 Enhancement and Maintenance

Client: Chicago Park District

Duration: Feb'15- Till Date

Location: Chicago, USA

Role: Oracle EBS Consultant

Chicago Park District owns more 81,000 acres of green space making it one of the largest municipal park managers in the nation. They have recently upgraded from 11.5.10 to R12.1.3 and the current systems basically holds modules like AP, FA, PO, GL, HR and Payroll. This project is intended for business required enhancements and maintenance of the Production System.

Responsibilities:

•Created New Rollup Groups, Summary Templates and tested the Funds Checking Functionality as part of

Budget Organization changes requested by the Business.

•Knowledge of defining Accounting flexfield Structure, Cross-Validation rules and Ledgers.

•Preparing MD-50(Functional Design Document) for Various Reports and Interfaces to understand functional

Requirements.

•Performing Functional testing for AP,GL,FA and PO Modules to understand and document the existing

Business process.

•Responsible for handling daily Production issues related Financial Modules.

•Implementation of Withholding Invoices Functionality for Foreign Supplier.

•Creation of Shell Script to FTP Files to Third party vendors.

•Supporting Business for UAT (Finance Modules) after every Patching Activity to verify the Functionality.

•Knowledge of Defining Fixed Asset setups like Category/Asset key/Location key flex fields.

•Knowledge of Defining Fiscal Year, Calendar and Depreciation methods locations and book Controls in Fixed

Assets.

•Resolving Issues in FA related to differences in Corporate and Tax books.

•Web ADI Creation for Fixed Assets Module.

•Migrating WEB ADI templates from one Instance to another using FND LOAD.

•Developing Custom BI Publisher Reports as per Requirements.

•Writing/Executing Scripts to perform various extracts from database.

•Implemented Positional Hierarchy Workflow in Purchasing as per business requirements.

•Modification of Existing OBIEE reports for CAFR as required by business.

•Preparing User Manuals and assist users in UAT Enhancement Testing

•Monitoring critical issue progress in order to avoid SLA violations and customer escalations.

•Tracking recurring issues and provide Permanent fixes.

•Documenting Issue Resolutions.

•Coordinating with DBA for the Maintenance Activities.

•Working along with Oracle Support through metalink for escalated issue analysis and resolution.

•Provide Month/Year end Closing Support

Environment: - Oracle E-Business Suite R12.1.3 (AP, FA, PO, CM and GL, HR, PAYROLL) Window 7, Oracle 11g, Toad, Serena, BMC Remedy Software, Unix, Forms & Reports 10g, Xml Publisher, Workflow builder, OBIEE

Project Name: MSI – Zebra Separation Project

Client: Motorola Solutions Inc

Duration: Oct'14-Dec’14

Location: Schaumburg, USA/Hyderabad, India

Role: Oracle EBS IT Analyst

Motorola Solutions Inc. (MSI) recently sold its EMB Business (Enterprise Mobile computing, Bar-code scanning technology) to Zebra Technologies. According to Transition Service Agreement, MSI should provide support to Zebra for performing the Operations. This project was initiated to perform the logical separation of both the organizations.

Responsibilities:

•Involved in requirement gathering with Motorola Solutions Business.

•Presenting Technical/Functional Documents to business users and Approvals from Business.

•Converted required Motorola Solutions Projects to Zebra Operating Units using Microsoft Projects Integrator.

•Created New Project Templates for Zebra Operating Units.

•Created New Projects Under Zebra Operating Units.

•Created Resource Assignment for New Zebra resources for Zebra Projects.

•Coordinated and supporting business user during CAT (Customer Acceptance Testing).

•Provide Post Production Support and Extended care support.

•Prepared User Manuals as per Business requirement.

•Worked on Production Issues related to other Financial Modules (AP, GL, FA, AR, iExp) when required.

•Developing Reports as Per Business Requirements.

•Preparation of GL Extract for the Legal Audit Purpose.

Environment: - Oracle E-Business Suite R12.1.3 (Oracle Project Management (OPM) Window 7, Oracle 11g, Toad, BMC Remedy Software, Service Now

Project Name: Trilogy R12.1.3

Client: Motorola Solutions Inc

Duration: Jun'12 to Sep'14

Location: Krakow, Poland /Hyderabad, India

Role: Oracle Apps Techno Functional Consultant

Motorola Solutions is one of the leading Telecom giant which has recently implemented Oracle E-Business Suite R12.Finance Transformation Program is a Motorola Global-Initiative to replace the existing Focus 11.5.10 oracle ERP finance functionality with Oracle Applications R12.

Responsibilities:

•Working on Daily Production Issues across Finance Modules (AP, GL, IEXP, PA, AR, OTL, and OPM).

•Analyzing the system and raise RFC for Enhancements and Performance.

•Implemented Setups and Profile Options related to iExpense.

•Done Setup for Assigning Signing Limits and supervisors for iExpense Approvals using AME.

•Performing Data Fixes and Code Fixes.

•Preparing/Modifying Reports as per user Requirements.

•Knowledge of Setting Up Suppliers and Setting Up of Invoice tolerances

•Tracking recurring issues and provides Permanent fixes.

•Preparing Status Tracking Report on the Current issues and Permanent Fixes.

•Provide Month/Quarter/Year end closing support.

•Documenting Issue resolutions.

•Personalized iExpense attachment upload page to include “Note” to the users at the organization level.

•Coordinating with DBA for the Maintenance Activities.

•Coordinating with Oracle through Service Request for standard bugs and working towards Resolution.

•Supporting the Month end/Quarter End/Year End Closure Activities.

•Supporting Motorola Custom Applications.

•Primary Escalation Contact for the EMEA region.

Environment: - Oracle E-Business Suite R12.1.3 (PA, AP, GL, OTL, OPM, IEXP, FA) Window 7, Oracle 11g, Toad, BMC Remedy Software, Kintana, Unix, Forms & Reports 10g,OAF

Project Name: iFOCUS EMEA get well

Client: Motorola Inc

Duration: Feb'12 to May'12

Location: Basingstoke, United Kingdom

Role: Oracle Apps Consultant

Motorola Solutions is one of the leading Telecom giant, which has many legacy systems in place. EMEA Get Well project is initiated in order to address the EMEA region issues of Business in Finance systems mainly in PA and OPM involving integration with other applications which are in 11i.The work involved receiving, identifying the Requests for change in Existing system for better customer Satisfaction.

Responsibilities:

•Responsible for analysis of functionality integrating other system with the Project Accounting Modules.

•Coordinating with Business users during CAT (Customer Acceptance Testing) for Motorola R12.1.3 upgrade.

•Implementing Code/Data fix and testing the Functionality after Implementation.

•Preparation of Technical Design Documents for the newly/modified component in the existing system.

•Worked on Production Issues and Alerts to meet customer needs.

•Worked on Form Personalization Issues.

•Preparation of as-Is document and To-Be documents.

•Worked on 11.5.10 minimum baseline patch upgrade to the Internet Expense for Oracle Support.

•Handling Client Meetings and providing status to Motorola Management.

•Providing data extracts as per user requirements.

•Converting Existing RDF reports in to XML Publisher Reports.

Environment: - Oracle E-Business Suite 11.5.10(PA, OPM, OTL, AP, AR) Window 7, Oracle 9i, Toad, BMC Remedy Software, Kintana, HP QC

Project Name: iFocus

Client: Motorola Inc

Duration: Aug'08 to Jan'12

Location: Hyderabad/Chennai, India

Role: Oracle Apps Support Analyst

iFOCUS oracle ERP 11.5.10 is the Motorola Inc global financial system. IFOCUS is the one application takes care of all finance activities like AP invoice creation, vendor payments, customer invoice creation, printing, AR statement printing, Project accounting, treasury maintenance, fixed assets maintenance, inter-company invoice creation, trail balance generation in and all other finance activities.

Responsibilities:

Responsible for handling Production issues related to Financial Modules and Custom Applications.

Extensively participated in Month/Year End Closing Activities.

Providing adhoc reporting data from business users during critical year-end, Month end process.

Clearing the Error Interface transactions.

Responsible for handling Customized interfaces issues

Monitoring critical issue progress in order to avoid SLA violations and customer escalations

Working along with Oracle Support for escalated issue analysis and resolution.

Communicating to all the stakeholders, getting the approval for the down time. Presenting the weekly status, SLA reports to Motorola team.

Working on Data fixes and Code Fixes.

Co-ordinate with business users to complete the User Acceptance Testing and log the defects in the PPM client Tool.

To identify and to implement best practices to ensure continuance of business operations and to reduce the risk and impact of potential disaster scenarios. Extensive Disaster Recovery tests are conducted every year.

Documenting Issue Resolutions.

Problem Management: To assist the Incident Management team to drive downs the number of incidents by identifying the root cause. Perform Post Incident Review on major incidents.

Supporting Motorola Custom Applications (FIRE, e-BAM, e-Check, e-Sar).

Preparing the Release Rollout plan and make sure that proper code is migrated across various instances via Kintana and Clear-Case tools.

Tracking the various stages in the life cycle of the project using the Client Specific tool COMPASS.

Following Change management, release management processes to ensure quality during production migration.

Gaining knowledge on the Inbound and outbound applications and resolving cross application tickets.

Environment: - Oracle E-Business Suite R11.5.10 (AP, AR, OM, GL, PA, iEXP, FA, Motorola Custom Applications) BMC Remedy, Kintana, Clear-Case, Oracle 9i, Toad, SQL* Plus, UNIX, PL/SQL, Forms & Reports 6i/10g, Hyperion Brio

Project Name: Initial Learning Program (ILP)

Client: Tata Consultancy Services Ltd. (TCS)

Duration: Feb'08 to Jul'08

Location: Thiruvanthapuram, India

Role: System Engineer

Tata Consultancy Services Ltd. (TCS) is a leading Multi National Company, which provides Information Technology Service, Consulting and Business Solutions. This project is internal project as part of training that people undergo after being recruited through Campus recruitment before placing on a Client Project.

Responsibilities:

•Underwent rigorous training in Oracle PL/SQL, SQL, and Unix Shell Scripting.

•Trained to analyze customer business systems and requirements.

•Trained to Document Functional/Technical Design Documents as per AIM.

•Testing the Existing Business Process and Documenting Test Results.

•Trained on Communication Skills and User etiquette.

•Understanding Project SDLC and implemented the same for in-house projects.

Environment:-Oracle 8i/9i, Toad, SQL* Plus, UNIX, PL/SQL, SDLC concepts, Master Craft

Contact this candidate