Data Technical
Resume:
Srinivas Vangari,
Communication Address:
West Allis,WI 53227
Ph No: 510-***-****
Mail to:********.*******@*****.***
PROFESSIONAL SUMMARY:
Over 10 years of extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
Extensive experience in implementation, data migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Bill of Material (BOM), Work in Progress (WIP), Quality,Quoting, Advanced Pricing, Purchasing (PO), Project Accounting (PA) and Accounts Receivable (AR).
Hands-on experience in Data Conversion,Report Generation and Developing Interfaces within several modules in Oracle Applications.
Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
Worked on OAF page development, customization using Jdeveloper.
Experience in Order to cash (O2C) and Procure to Pay (P2P) life cycles and Supply Chain business flows.
Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
Expertise on designing and implementing Oracle Alerts and Lookups
Fair knowledge in customizing oracle forms and reports as per business needs.
Experienced in Customizing Oracle Forms with Forms Personalization and Custom.pll.
Have good knowledge in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations
Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs etc.
Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
Experience in customizing oracle workflows such as the Order/Line Flow to send user notifications based on the business requirement.
Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
Interacted with users, fixed the bugs, developed test plans and provides daily production support.
Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF and HINTS.
Excel in team collaboration, quick adaptation and problem solving with good communication skills.
Professional Experience:
Organization: Infosys Technologies Limited
Customer: Emerson Process Management JDI Global forms development, Dec 2015 –Till date
Role: Oracle applications Technical consultant
Location: Bloomington, MN, USA
Responsibilities:
Worked on the development of interfaces, data migrations, developing new Forms, Reports, Customizing Oracle Reports in order to Cash cycles touching various modules such as Quoting, Order management and AR.
Working on customization of quote form and sales order form including mass adjustment form, mass change form and unit related data form.
Developed the OAF page and customized the page using Jdeveloper.
Enabled the quote form in archive schema to query and execute the quote.
Working on upgrading the multiple forms to R12.2.4 enviornment
Organization: Infosys Technologies Limited
Customer: Emerson Process Management R12 Upgrade-June 2015 to Nov 2015
Role: Oracle applications Technical offshore lead
Location: Hyderabad, India
Responsibilities:
Worked in R12 upgrade activities like finding and replacing the R12 equivalent objects for the obsolete tables, columns and APIs.
Involved in Unit testing and bug fixing.
Involved in day to day activities of team building, coordination and testing the objects.
Developed pl/sql interfaces and modified the interfaces for standard APIs.
Developed the payment format reports in R12.
Responsible for Order import using Order Management OE_ORDER_PUB API to update sales order into respective base tables.
Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
Extensively participated in developing technical documents (MD70).
Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.
Organization: Infosys Technologies Limited
Customer: Emerson Process Management Regulators Italy and France-Feb 2014 to May 2015
Role: Oracle applications Technical onsite lead
Location: Bologna, Italy
Responsibilities:
Handled the two regulator sites Italy and France at on site for implementation of supply chain modules.
Extensively involved in requirements gathering and design of conversions, interfaces, reports, data warehouse reports and oracle forms.
Developed a complex fiscal delivery note form and report for regulator Italy with respect to fiscal guidelines.
The form and report is approved by Italian fiscal organization.
Involved in data migrations of Item creation, category, sales orders, purchase orders, quality modules, BOM, item specifications and demand history.
Developed the queries for the complex data ware housing.
Extensively involved in designing of WINSTORE inbound and outbound interfaces.
Developed a program to load external data from legacy system into PO_HEADERS_INTERFACE and PO_LINES_INTERFACE
Developed delivery note form using TEMPLATE.FMB and registered them in Oracle Application.
Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
Developed validation packages to Load data to interface tables (OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, OE_CUSTOMER_INFO_IFACE_ALL)
Developed PL/SQL scripts for validating the data and Storing the data into MTL_TRANSACTIONS_INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
Used Bulk Collect feature to improve performance.
Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
Used Version Control (PVCS) to maintain code changes.
Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace
Environment: Oracle Apps Financials EBS 11i, PO, INV, BOM, OM, SQL, PL/SQL, Orcale Reports 10g, BI/XML Publisher, UNIX, TOAD,forms.
Organization: Infosys Technologies Limited
Customer: EPM Regulators-Cluj Romania-Oct 2013 to Jan 2014
Role: Oracle applications Technical offshore lead lead
Location: Shanghai,China
Responsibilities:
Gathering and analyzing user requirements and proposing solutions for the same.
Preparing High Level Documents and Detailed Level Documents.
Designating and mentoring technical team for day to day activities and providing required technical and domain knowledge help
Identifying and coding RICE items for Regulators specific requirements.
Unit testing the developed RICE components and coordinating with users for the SIT, UAT testing and getting their sign-off.
Organization: Infosys Technologies Limited
Customer: EPM Remote Automation Solutions-Feb 2012 to Sep 2013
Role: Oracle applications Technical offshore lead
Location: Shanghai,China
Responsibilities:
Offshore Technical Track Lead.
Gathering and analyzing user requirements and proposing solutions for the same.
Preparing High Level Documents and Detailed Level Documents.
Designating and mentoring technical team for day to day activities and providing required technical and domain knowledge help
Identifying and coding RICE items for RAS specific requirements.
Unit testing the developed RICE components and coordinating with users for the SIT, UAT testing and getting their sign-off.
Reviewing the Quality Assurance related documents
Emerson Process Management – LLLP Project Accounting Module Implementations
Job title: Oracle applications Technical onsite lead-- Sep 2011 to Feb 2012
Location: Shanghai,China
Responsibilities:
Offshore Technical Track Lead for the project accounting module.
Requirement Analysis, Preparing High Level Design and Low Level Design Documents.
Developing custom components as per the Approved Design documents.
Managed the Data migration for Projects module, making sure to meet the project milestones.
Helping the team in performing reconciliation once the data is migrated to target instances.
Coordinating with geographically distributed user team for validating and testing of data.
Emerson Process Management - JDI
Job title: Oracle applications Technical Developer Apr-2011 to Aug 2011
Responsibilities:
Requirement Analysis, Preparing High Level Design and Low Level Design Documents.
Developing custom components as per the Approved Design documents.
Developing the Interfaces to Oracle, making sure to meet the project milestones.
Helping the team in performing reconciliation once the data is migrated to target instances.
Coordinating with geographically distributed user team for validating and testing of data.
Emerson Process Management – SNAP Project
Job title: Oracle applications Technical Developer Jul-2010 to Mar 2011
Responsibilities:
Requirement Analysis, Preparing High Level Design and Low Level Design Documents.
Developing custom components as per the Approved Design documents.
Performing Data migrations as per the given data files.
Developing the Interfaces to Oracle, making sure to meet the project milestones.
Helping the team in performing reconciliation once the data is migrated to target instances.
Coordinating with geographically distributed user team for validating and testing of data.
Emerson Process Management-Support
Job title: Oracle applications Technical Developer Mar 2007 to Jun 2010
Responsibilities:
Tuning analyst for the entire Emerson account
Checking and providing the solutions for the bad performance Pl/Sql programs.
Preparing Detailed Level Design Documents.
Unit Testing of RICE components.
Education
Qualification
Board/University
Percentage Obtained
SSC (1997-98)
SVVN School, Godavarikhani, Karimnagar, Telangana, India
80
IPE (1998-2000)
SVISS JR college, Godavarikhani, Karimnagar, Telangana, India
83.4
BTECH (2001-2005)
JNTU College of Hyderabad, Kukatpally,Hyderabad, Telangana, India.
68.7
Technical Knowledge
Operating System
Windows 95, Windows 98, Windows 2000, Windows XP
RDBMS
Oracle 9i,Oracle 10g
Programming Languages
PL/SQL, SQL, C and Core Java
I hereby declare that all the above-mentioned particulars and details are valid and true.
Signed
Srinivas Vangari
Contact this candidate