ac1qyf@r.postjobfree.com Harika Rao +1-678-***-****

SUMMARY

Over 7 years of experience in IT industry have experience in Analysis, Design, Development, Conversions, Interfaces and Implementation of business applications using Oracle Applications R12.2/R12.1.3/11.5.x R11i, SQL, PL/SQL, Oracle 11g/10g/9i, Developer 2000/6i and Discoverer

Outstanding Functional/Technical knowledge in Oracle Applications. Oracle Financials like (GL¬-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management),

PO-Oracle Purchasing, OM (Order Management/Advanced Pricing), Manufacturing (INV-Inventory, WIP-Work in Progress), iprocurement, iReceivables and AOL (Application Object Library)

Developed customization for Bulk Invoice Printing (All Invoice types) and delivery to the customer using XML Publisher technology

Have hands on development experience in SQL, PL/SQL (Procedures, Packages, Functions, and Triggers), Oracle Reports 9i/10g and Forms 9i/10g, XML Publisher, Writing and Tuning complex SQL statements

Having skills in Oracle 9i,10g,11g environments using SQL, PL/SQL, Developer2000 Oracle (Forms 9i/10g and Reports 9i/10g)

Experience in Designing and developing reports using XML/BI Publisher, Discoverer

Expertise in Design, Development and Customization of RICEW (Reports, Interface, Conversions, Extensions and Workflows) using SQL*Loader, PL/SQL, UTL File etc.

Ability to learn and implement the setups needed for financial, distribution and supply chain modules

Experience in Customization, Upgrade, Implementation and Production Support of Oracle Financials and Oracle Supply Chain modules

Analyzed business process workflow and assisted in the development of ETL procedures for moving data from source to target systems

Used workflow manager for session management, database connection and scheduling of jobs

Extensive Experience with AOL to develop Flexfields, Reports, Validation sets, Concurrent programs and registered in AOL

Experience using DATALOAD loading external data into Oracle Applications UI for

Strong implementation knowledge of O2C (Order to Cash), P2P (Procure to Pay) and Drop Ship end to end Cycles

Experience in all aspects of Software Development Life Cycle including Software Design, Development, Implementation and Testing

Excellent analytical, problem solving, communication skills and interpersonal skills and consistently being organized by management and peer for producing high quality work

TECHNINCAL SKILLS

Languages

SQL, PL/SQL, JAVA, C, C++, XML, HTML, Shell, Perl

Databases

Oracle 11g/10g/9i/8i, SQL Server, T-SQL, Microsoft Access

Tools

SQL*Loader, TOAD, SQL*PLUS, PuTTy, WinSCP, Forms 10g/9i, Reports 10g/9i, SSRS, Cognos, Informatica, Discoverer, OEM, ODI

ERP

Oracle E-Business Suite R12.x, 11i -OM, INV, GL, AP, AR, Application Object Library, System Administrator, WIP, HRMS, Approvals Management Engine

Other Tools

ServiceNow, ITSM, Tivoli, Autosys Web, JIRA, Oracle Application Server

Operating Systems

Windows, Mac OS, UNIX, LINUX, Solaris 5.8

Version Control

Perforce, Sharepoint, PVCS, SVN,GitHub, Star Team

WORK HISTORY

Target Corporation, Minneapolis, MN Aug 2015 - Present

Role: Sr Oracle Technical Consultant

Environment: Oracle E-Business Suite R12.x / 11.5.x, ORACLE Database 11g, Oracle Enterprise Manager (OEM), SQL* Loader, SQL* Plus, PL/SQL Developer, Toad, Reports, Forms, Avature, JAVA

Responsibilities:

•Produced Functional (MD50) and Technical design documents (MD70) based on Business requirements

•Produced Installation Instructions documents (MD120)

•Gathered functional user inputs and produced TE020 document

•Involved in multiple CRP’s and UAT’s to meet business users requirements

•Gathered Business requirements, designed and developed custom Forms and Reports

•Developed inbound interfaces to interface expense invoices data from concur to Oracle EBS

•Understanding the existing Functional Flow and relate it to the technical aspects

•Responsible for all deliverables including Data extract programs, Reports and Concurrent Programs

•Mapping client requirements with Oracle standard functionality, finding gaps and delivering solutions in terms of Customizations, Workarounds, re-engineering and forms personalization

•Setup multiple quick codes for AP, AR and GL. E.g.: (Discount Amount Basis, AR Transaction Type Categories, Account Types etc. to meet current business requirements)

•Application Enhancements and Support for AP, AR and GL modules

•Experience in data mapping external source files with oracle columns in Oracle Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL) and Fixed Assets (FA) modules

•Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports

•Developed and executed test cases. Involved in Functional, Technical, Performance and Regression testing Gathered Business requirements, designed and developed multiple reports using XML BI Publisher

•Developed Inbound and Outbound HRMS interfaces to insert employee data from external application system called Avature

•Extensively leveraged XML Bursting Process to e-mail reports to multiple Business users across different operating units globally

•Developed many PL/SQL program units - Procedures, Functions, Packages, Triggers and Public API’s

•Performed Forms personalization in AP and AR, created special menus to view Invoice Image file, populate voucher number and budget fiscal year for AR invoices

•Extensively leveraged XML Bursting Process to e-mail reports to multiple Business users across different operating units globally

•Developed XML publisher reports importing sub templates into the main template

•Worked on OAF personalizations to meet business requirements

•Responsible for status update reports to higher management on weekly as well as monthly basis

•Responsible for providing solutions to Business using Oracle Applications EBS and thus making them understand the functionality provided by Oracle EBS to accomplish their day to day operations successfully

•Level 2 and 3 Production support for Oracle EBS, Release 12.1.3 (to support Application Services group if they cannot resolve the Production issues)

Nielsen Holdings, Tampa, FL Aug 2013 – Jul 2015

Role: Oracle PL/SQL Developer

Environment: Oracle E-Business Suite R12.x / 11.5.x, ORACLE Database 11g, Oracle Enterprise Manager (OEM), SQL* Loader, SQL* Plus, PL/SQL Developer, Toad, Reports, Forms, JAVA, SOA

Responsibilities:

Prepared numerous Technical specification documents (MD70) for Reports, Interfaces (CV) and forms customized.

Built Functional spec (MD50) documents on reports developed in Purchasing (PO), Accounts Payable (AP), Order Management (OM) and Accounts Receivables (AR) while interacting with the end users.

Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to load Applicants data from external Applicant Tracking systems into Oracle HRMS

Designed and Developed outbound interfaces to provide data to external systems.

Built numerous custom value sets and defined values for value sets.

Developed Post Dated Cheque (PDC) interface process for Thailand and Philippines operating units.

Developed the extension for Customer Statement to advise customers of their current payment obligations and inform them of the payments that have been applied.

Developed Outbound Interfaces to pass the information from Oracle Applications to the third party system by making use of Integrated SOA Gateway functionality to invoke an external web service using Service Invocation Framework.

Unit tested these web service using SOAPUI

Exposed Interfaces as web services by generating WSDL and provided security authentication for the web services in EBS using integrated repository responsibility.

Registered concurrent programs, scheduled requests and defined request sets.

Proficient in PL/SQL program units - Procedures, Functions, Packages, Triggers and Public API’s.

Understanding the existing Functional Flow and relate it to the technical aspects.

Added dynamic Approver Groups for the transaction type ‘OKC Contract approval’ in AME.

Worked closely with functional team and business to resolve bugs and defects and UAT.

Prepared Test case documents on all components developed.

Developed OAF Controller & VO extensions in MES & MSCA modules to meet several business requirements.

Designed and Developed Payment Inbound interfaces using Payables Interface programs to import data from external systems like Concur.

Involved in Functional document (MD50) review and preparation of Technical document (MD70) based on the business requirement.

Prepared Installation document MD120 and Involved with the functional user in preparing TE020.

Prepared Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.

Developed Outbound Interfaces to pass the information from Oracle Applications to the third party system by making use of Integrated SOA Gateway functionality to invoke an external web service using Service Invocation Framework.

Unit tested these web service using SOAPUI

Exposed Interfaces as web services by generating WSDL and provided security authentication for the web services in EBS using integrated repository responsibility.

Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API (Interfaces) to import the data from legacy system into OM using Order Import Concurrent Program.

Performance tuning of the queries in consolidated billing invoice report.

Developed a custom PL/SQL procedure to suit the Pick Release Requirements of the Client.

Created PL/SQL procedures, packages and functions used to load and verify data from vendor feeder system into an Oracle Database.

Designed, documented and developed an Interface between Mainframe based application and Accounts Payable (AP) for Invoices. Developed staging tables, conversion routines, PL/SQL API’s, shell script for this Interface. Used SQL loader to load data from legacy system (Mainframe) and developed PL/SQL programs to dump the data from staging tables to the Interface Tables and concurrent programs to get data into Oracle Base tables.

Registration of Concurrent Programs and Request Sets in AOL and System Administration.

Involved in writing the technical specification document and code development for Order Import and line level validation.

Designed, documented and developed in an interface from payroll system to General Ledger for importing journals every month.

Designed and developed an interface between third party billing system and Accounts Receivables (AR) for Invoices using Auto Invoice.

Responsible for Functional testing and Process setup.

Customized several standard Oracle reports as per business requirements.

Developed several PLSQL packages to implement the business processes.

Modified the approval rules in AME for contract approval workflow based on payment terms and conditions.

Worked on several OAF customizations for Buyers Work Center page.

Created indexes to enhance the performance of the applications.

Knowledge on Oracle hints to improve the performance.

Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.

Involved in bug fixing reported from QA and End users.

Infosys Limited, India

Client: Pepsi Bottling Group May 2010 – Jul 2013

Role: Oracle Application Developer

Environment: Oracle E-Business Suite R11.5.x, ORACLE Database 10g, Oracle Enterprise Manager (OEM), SQL* Loader, SQL* Plus, PL/SQL Developer

Responsibilities:

•Involved in the system study, Requirements and Gap analysis and design documentation

•Involved in Functional Document review and Prepared Technical Requirement (MD 70) Specifications based on the Business Requirement

•Involved in Building Customizations and Enhancements using Reports and Form

•Involved in Code Review Process to make sure that code follows AIM methodology

•Designed and developed Technical Specifications for the Inbound Interfaces as per the Functional Specifications in OM

•Imported data from legacy system into staging tables using SQL*LOADER, perform validations prior to transferring data into OM Open Interface tables

•Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables

•Created new concurrent request set and scheduled the Order Import interface program to run periodically

•Designed and Developed Customer and Invoice conversion program through Standard (AR) Oracle Receivables Interfaces

•Imported data from legacy systems to Oracle Receivables tables using SQL*Loader. Used Auto invoice to import regular, debit memo, credit memo invoices from legacy systems into (AR) Oracle Receivables

•Uploaded Transactional data such as Item cost and Price list in Oracle Applications using DATALOAD

•Create custom Data entry Screen to view serial number information, Inventory Manifest Information, Inventory Availability Form using Forms 6i

•Customized reports in AR such as: Customers Profile Report, Aging Report

•Customized reports in OM and Inventory (INV) such as: Pick Slip Report, Warehouse Performance Report, Open Orders with deliveries, Inventory Reserve Report

•Registration of concurrent programs, defining value sets and parameters for customer reports

•Performed system administration functions such as creation of users, Responsibilities, Menus and Functions

•Involved in Unit testing and wrote test cases for QA, also involved in UAT (User Acceptance Test) Involved in bug fixing reported from QA and End users

•Involved in Post Production Support, work involved supporting Apps, support in reporting & tickets Involved in Functional Design Review and preparing the Detail Design Document

•Involved in Customization of Standard Oracle Reports as per client requirement

•Analyzed and designed customer specific forms, reports and meet Business Users requirement. Reports such as Item where used Report, Weekly Inventory Report, Inventory Aging Report Etc and Data entry screens like Quick Customer lookup using BI Publisher

•Developed Interface Program for loading Items information from legacy system to Inventory (INV) interface tables using SQL*Loader and PL/SQL and ran Item Import to populate the Inventory Base tables

•Developed a custom conversion program to validate customer information before loading them into AR Base Tables

•Involved in importing BOM and Costing Data from legacy system

•Used Order Management API to populate the data into various base tables

•Registered concurrent programs, request groups for reports and concurrent requests

•Involved in Unit testing and Bug Fixes, Involved in UAT Process (work involved helping Test Team to come up with test cases and Bug Fixes)

Project: Employee Portal Jan 2010 – May 2010

Role: PL-SQL Intern

Environment: Pro C, UNIX and PL/SQL developer, Windows XP, C, Oracle 9i, Toad, Putty

Responsibilities:

Analyzing the complete Application requirements

Developing the both High-level design documents and low-level design documents

Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements

Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus Editor or TOAD

Preparing the Test plans and executing them for Unit Testing

Provided solutions to billing issues faced during SIT and UAT (User Acceptance Testing)

Detected and Corrected bugs during system integration and user acceptance testing

Participated in status update meetings and scrum meetings

Educational Qualifications

Bachelor of Engineering, Computer Science GPA: 4.0/4.0

Osmania University, India 2010

Contact this candidate