Oracle PL/SQL DEVELOPER

Srinivas Rao Vytla

Email: *********@*****.***

Phone: 703-***-****

SUMMARY

Over 15 years Experience in Oracle PL/SQL Programming using Oracle 9i / 10g/11g and Developing Oracle Forms using Oracle Forms 6i/10g and Developing Reports using Oracle Reports 6i/10g that involves Design, Development, Implementation, Support, and User Training for various Business Applications.

3 years Oracle federal financial technical and functional development expertise.

OCP Certification Completed in Oracle 9i SQL, Oracle 9i PL/SQL, Oracle Forms and Reports.

3 years’ experience in Data Quality using IDQ.

4 Year experience in Informatica Power Center and Responsible for all activities related to the development, implementation, administration and support of ETL processes using Informatica Power Center.

3 Years of experience in MOAC and Oracle Sub-Ledger Accounting(SLA) in Oracle APPS R12.1.3

9 years of experience working in Conversions and Interfaces in Financial and Distribution modules.

7+ years experience in production support and enhancements.

7 years’ experience working on Forms Personalization and developing custom forms using Oracle forms 10g and registered to request groups.

6 Years of experience in Developing XML Publisher reports.

6 Years of experience in J2EE.

5 Years of experience in Data Modeling using Erwin.

3 Years’ experience in Spring framework and OAF

10 years of experience in Order-to-Cash, Procure-2-Pay Business flows

8 years of experience in performance tuning and Experience with database query optimization and performance tuning using Explain Plan, SQL-Trace, AWR Reports,TK-Prof Oracle utilities.

Modified Oracle forms using Custom pll and Form Personalization.

8 years’ experience in Developing Oracle Reports and registering them as Concurrent Programs in Oracle applications using AOL

5 years’ experience in Developing Workflows by using Oracle Workflow Builder.

6 years’ experience in creating simple, complex and custom folders and also creation of numerous complex workbooks to develop reports using Oracle Discoverer 10g/11g.

Create, maintain, and manage Technical Assistance Requests (TARs) or SR’s Respond to issues raised during testing

Providing assistance in logical/physical Data Modeling using Erwin.

4 years experienced in writing UNIX Shell Scripting.

Excellent analytical skills and communication skills with good team spirit.

8 Years of hands on experience in gathering business requirements, GAP analysis, process mapping, solution design, configuration, setups and user training.

Hands on experience in Functional Testing, Integration Testing and Regression Testing in CRP1, CRP2 and user acceptance testing (UAT) phases.

TECHNICAL SKILLS

ORACLE APPLICATIONS: AOL, SYS ADMIN, AP, AR, GL, PO,

HARDWARE: Intel, HP, IBM

OPERATING SYSTEMS: MS-DOS, Windows (95/ 98/ NT Server/Windows XP),Linux 7.2

LANGUAGES: JAVA J2EE,SQL AND PL/SQL

DATABASE: ORACLE 7.3 /8i /9i /10g/11g

GUI: ORACLE APPS 11i/R12.1.3,Test Director, PVCS, KINTANA,STAT, Developer 2000 Forms 6i/10g and Reports 6i/10g,Oracle Work Flow.

WEB RELATED: Oracle Applications 11.5.10.2 / R12 1.3

TOOLS AND UTILITIES: MD Office, MS Excel,D2K Forms 6i/10g and Reports 6i/10g,Autosys,Oracle 9i/10g/11g/12c,MySQL, Toad, UNIX,Putty,SQL Plus, SQL * Loader, SQL Server, Java, PVCS, Kintana, Test Director, Oracle XML Publisher, Toad,Informatica Power center 9.6,Informatica MDM,Eclipse,Oracle Applications, Data quality.

EDUCATIONAL DETAILS

BE Degree in Mechanical Engineering

PROFESSIONAL EXPERIENCE

Tracfone Wireless Inc, Miami,FL FEB-2016 –Till Date

Sr Oracle PL/SQL / Informatica Developer

Responsibilities:

Developing Database objects packages, procedures, functions, and triggers for eBay Project creates sales orders from eBay.

Design and developed the scripts to create table, views, indexes and sequence.

Automated sqlldr using shell scripting.

Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Router, Expression and Sorter

Optimized the queries to improve the performance of the application.

Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.

Worked on complex database package using Ref Cursor, External Tables

Environment: Oracle 11g/12c, PL/SQL, Informatica Power Center 9.6.1,Toad,Unix,Putty,JAVA,Oracle Forms 10g and Reports 10g

LinkedIn, Sunnyvale, CA JUL-2015 –DEC-2015

SR Oracle PL/SQL Developer

Responsibilities:

Worked as Production support lead and identify issues and fixing the issues as per priority.

Worked on outbound interfaces using Oracle supplied Packaged like DBMS_SQL,DBMS_JOB and UTL_FILE.

Worked on various complex queries, sub queries and joins to check the validity of loaded and imported data.

Worked on complex database package using Ref Cursor, External Tables

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.

Worked on database query optimization and performance tuning using Explain Plan, SQL-Trace, TK-Prof Oracle utilities.

Created mappings, session and workflows to load data from source tables into Staging tables using Informatica Power Center.

Used Informatica Power Center 9.6.1 for extraction, transformation and loading (ETL) of data from source systems into target tables

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Developed materialized views for data replication in distributed environments.

Worked on Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Worked on database links and also Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.

.

Environment: Informatica Power Center 9.6.1, Oracle 11g/12c, PL/SQL, Autosys,Informatica Power Center 9.6.1,Toad,Unix,JAVA,JDKPutty,Oracle Forms and Reports

FDA, Rockville,MD FEB-2014 – JUL-2015

SR Oracle PL/SQL Developer

Responsibilities:

Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.

Worked in Production support and maintenance team for Bizapps project.

Design and Developed data base to move data from legacy system into oracle database.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Developed materialized views for data replication in distributed environments.

Designed and developed a number of complex INFA PowerCenter mappings using various transformations like Source qualifier, Lookup, Expressions, Update Strategy, Router, Filter, Sequence Generator, Aggregator, Joiner, Union, App Multi-Group Source Qualifier, Application Source qualifier.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience in SQL performance tuning using Cost-Based Optimization (CBO)

Worked on Performance tuning and optimized SQL Queries to minimize SQL reports execution time.

Used Informatics Power Center 9.0.1 for extraction, transformation and load (ETL) of data in the data warehouse.

Data Integration from disparate source systems like FMS, FMLS, Oracle, MS SQL Server, flat files (fixed width, delimited) into a staging area with Data Cleansing.

Developed custom program to import the invoices in AR module using AR Auto invoice program.

Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.

Developed new reports for Oracle Payables as per the user requirements.

Developed custom form in Oracle Applications using TEMPLATE.fmb.

Developed conversion program to convert Fixed Assets from legacy system to Oracle Fixed Assets.

Developed custom interface program to import vendor, site and contact information into AP module.

Created custom templates with data definitions for XML publisher and developed the reports using reports and registered as XML reports in applications.

Environment: Oracle Applications 11i/R12, Oracle /10g/11g PL/SQL, Toad, Data Quality, IDQ, Informatica Power Center 9.6,SQL Plus, Crystal Reports, JAVA,Oracle Forms 10g,J2EE,SQL Server, XML, UNIX, LINUX, My SQL, Erwin.

VERISIGN INC Nov, 2012 – Jan, 2014

SR Oracle PL/SQL Developer

Responsibilities:

Responsible for gathering business requirements, gap analysis and creation of technical and functional design documents using AIM methodology.

Worked in Production support and fixes day to day issues.

Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

Developed custom interface program to import Payable Invoices from external system into AP module.

Developed Asset Retirement Report, Asset Additions Report, FX Rate Comparison Report, and Credit Card Outstanding Report using XML Publisher.

Developed custom forms using TEMPLATE.fmb and registered into Oracle Applications.

Automation of Creating GL Daily Rates using Interface program.

Developed Custom Interface Program for Creation of AR cash receipts in AR modules using standard API.

Customized invoice approval workflow notification using OAF.

Developed validation program to load currency rates data into interface tables and run the standard program to Load foreign currency rates into GL.

Created concurrent program and registered stored procedure to concurrent program and attached to request sets.

Customized Fixed Assets Retirements and Additions report using XML Publisher.

Created Data Definition and Data template using XML publisher and attached data definition to data template.

Created custom program to create AP invoices for VeriSign employees PCARD transactions and recorded those transactions into AP module.

Customized standard Positive Pay payment process and created e-Text outbound template and Payment format and attached Positive pay payment format to check printing Payment Process Profile.

Developed Custom program to process all travel and entertainment expenses transactions and pay to the card issuer an interface was developed that will feed daily transactions from card program into iExpense (credit card open interface table) module. These transactions will need to be validated in the interface table prior to loading into iExpense.

Customized standard ACH Payment Process and Created e-Text outbound custom template and Payment Format and attach the Template to Payment format and Create Payment process profile and attach the payment format to the Payment Process Profile and also responsible creating functional Setups.

Modified standard APCCARD workflow and created custom program that will check if there are any unused credit card transactions loaded in the system that belong to any inactive or terminated employee. If unsubmitted transactions exist for an inactive employee, the workflow process should notify the credit card admin and set card admin as the delegate of that employee for iExpense.

Worked on SQL Loader and shell scripts for the interfaces and custom programs to load data into custom tables.

Customized Oracle Reports in AP and FA module.

Created PL/SQL Stored procedures, Packages, Functions, Database triggers and, Views.

Environment: Oracle Applications R12.1.3(AP,AR,GL,FA,PO), Oracle 11g PL/SQL, Oracle Forms 10g,Oracle Reports 10g,Oracle XML Publisher, OAF,J2EE,Eclipse, Oracle Workflow, Unix, Spring Framework and STAT,Toad.

US Securities & Exchange Commission, Washington DC Dec, 2011 – Oct, 2012

Oracle Apps Techno Functional Consultant

Responsibilities:

Created Custom, Simple, Complex folders, Business Areas, workbooks and assigned privileges and registered the reports on Oracle Applications.

Customized workbooks by adding additional functionality (conditions, calculations, parameters, sorting) and scheduling them for the users.

Written shell script to move CSV file from shared drive to server and then load them in to the temp tables using SQL LOADER.

Developed validation program to load invoices data into interface tables and run the standard program to create invoices into AR.

Created workbook for fed traveler host paid report. This workbook allows users to query the information about the sponsored portion associated with the travel by federal employees.

Created AR invoice aging reports. The invoice aging report provides the customer details, invoice details, original amount and remaining amount by invoice number.

Environment: Oracle Applications 11.5.10.2/R12.1.3(AP,AR,GL, FA,PO), Oracle 11g PL/SQL, Oracle Forms 10g,Oracle Reports 10g,Autosys,UNIX,Oracle Discoverer 10g/11g, Oracle XML Publisher, UNIX.

Curtiss Wright, Cleveland OH Sep 2011 – Nov 2011

Oracle Apps Techno Functional Consultant

Responsibilities

Developed validation program to load into interface tables and run the standard Routing Import program.

Added the button on toolbar in standard form and called “SO Line” using form Personalization.

Created NOVA CGD Sheet report using XML Publisher when Quality planning report is printed CGD report also prints along quality planning report

Tracfone Wireless Inc, Miami FL July 2009 – Sep 2011

Oracle Apps Techno Functional Consultant

Responsibilities:

Oracle Applications upgrade from 11.5.10.2 to R12.1.3

Gap Analysis for Upgrade from 11.5.10.2 to 12.1.3

Modified Procedures and Packaged according to new Oracle standard tables in R12.1.3.

Developed custom interface program for automation of Items into inventory.

Functional setups done in PO, AP and GL module.

Developed custom interface program for creation of Bill of materials.

Developed custom interface program for creation of Purchase Orders.

Developed custom program to create suppliers and sites using interface program.

Created TAR/SR to Oracle for fixing upgrade issues in AP and fixed assets modules.

Developed the program to import invoices into receivables using AR Auto invoice program.

Developed Custom interface program to import Vendor and Site information into AP Module.

Developed validation program to load into requisition interface tables and run the standard Requisition Import program to load into Requisition Standard tables.

Environment: Oracle Applications 11.5.10.2/12.1.3(AP,AR,GL, FA,PO, OM, INV,BOM,WIP), Oracle 11g PL/SQL, Oracle Forms 10g,Oracle Reports 10g,Oracle XML Publisher, UNIX,PVCS, Noetix

Cisco Systems, Morrisville, NC Mar-2008 – Jun 2009

Oracle APPS Consultant.

Responsibilities:

Developed PL/SQL Stored Procedures, Functions, Packages and Database Triggers.

Worked on the Journal Import in General Ledger (GL) module and on the GL-AR link.

Design and Developed Oracle APPS Forms using Forms 10g and BPEL.

Worked on Order Import interface program.

Developed custom reports using Oracle XML Publisher Reports.

Environment: Oracle Applications 11.5.10.2(AP,AR,GL,CM,PO, OM, INV, Project Accounting), Oracle 10g PL/SQL, Oracle XML Publisher, Oracle Workflow, KINTANA, PVCS and TOAD

Satyam Computers, India, Hyderabad Mar 2006 – Jan 2008

Oracle PL/SQL Developer

Responsibilities:

Developed PL/SQL Stored Procedures, Functions, Packages and Database Triggers.

Worked on Payable open interface program transfers invoice details from flat file into Payables.

Resolving Production Support related issues that are specific to Finance sub-ledger modules viz., PO, AR, AP & GL modules.

Sierra Atlantic, India, Hyderabad May 2003 – Feb 2006

Oracle PL/SQL Developer

Responsibilities:

Developed PL/SQL Stored Procedures, Functions, Packages and Database Triggers.

Migrated Reports2.5 to Reports6i and upgrading /Creating the Packages, Functions, Procedures from Oracle Apps 10.7 to

Oracle Apps 11.5.9 in GL Module

Ram Informatics Ltd, India, Hyderabad Mar 1999 – May 2003

Oracle PL/SQL Developer

Responsibilities:

Developed PL/SQL Stored Procedures, Functions, Packages and Database Triggers.

Worked on Upgrading oracle forms from 4.5 to 6i and Reports from 2.5 to 6i.

Contact this candidate