SUMMARY

• Over 16 years of experience and proficientin Oracle Applications (Inventory, Order Management, Receivables, Purchasing, Payables, Payments, Cash Management, Enterprise Asset Management, Projects and Bills of Material).
• Experience and proficient in Oracle Applications, implementation, customization, upgradation, migration, interfacing, Conversions and production support.
• Experience in RICE (Reports, Interfaces, Conversions, and Extensions) components design and development.
• Implementation/validation of business logic to populate OM, AR, PO, AP, INV, CE, EAM, BOM application modules interface tables.
• Designing conversion programs to import data from legacy systems and validated the data using PL/SQL packages.
• Expertise in using tools like BI/XML Publisher and Oracle Workflow Builder
• Actively involved in preparing Technical Documentation using AIM (Application Implementation Methodology).
• Extensively worked on various interfaces and API’s to load the data from legacy systems into the oracle application tables using various interfaces like Payable Open Interface, Customer Interface, Autoinvoice Interface, Standard PO Interface, BOM Interface, Advanced Pricing API, and Order Import API etc. by performing data validations and messaging at staging tables.
• Experience in Reports 6i/2.5, Forms 6i/5.0, Developer 2000 for both development and customization of several forms and reports as per client specifications and experienced in backend programming.
• Strong Experience in Oracle Development - SQL, PL/SQL, Packages, Procedures and Triggers.
• Expertise in using tools like TOAD, PLSQL Developer, SQL*Loader and Data Loader.
• Expertise in creating Unix shell scripts.
• Having good knowledge in OBIEE 11G.
• Experience working in production support environment.
• Actively involved in resolving pre or post-implementation problems and work around.
• Experience and technical proficiency in building Data Warehouses, Data Marts, Data Integration, Operational Data Stores and ETL processes for clients in Financial and Automobile domains
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experienced in overall data warehouse, database, ETL and OLAP tuning for better performance
• Experience in debugging, performance tuning of sources, targets, transformations and sessions.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Good experience with Hadoop, HDFS, sqoop, pig and Hive

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i

Database: ORACLE 8i/9i, 10g/11g, PostgreSQL, Redshift

ETL Tools: Informatica Power Center, OBIEE 11G and ERwin

Big Data Tools: Hadoop, HDFS, Pig, Sqoop and Hive

Operating System: Windows 2000/NT/98/95, UNIX, LINUX

Language: PL/ SQL, JAVA, C, C++, UNIX Shell Scripting

Oracle Tools: Forms 6i/9i, Reports 6i/9i, Oracle 7x/8i, 10g/11g, JDeveloper, Oracle Workflow Builder and BI/XML Publisher.

Database Tools and Utilities: SQL*Plus, SQL* Loader, Toad, PLSQL Developer

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Technical Consultant

Environment: Oracle 11g, Oracle Applications R12, TOAD, WinSCP, Putty, UNIX

Responsibilities:

• Creating the design documents for the interface between the legacy and proposed system and implementing the same in Production environment.
• Implementing the scenarios for testing, Mapping data and performing data validations.
• Involved in the preparation of following documents MD070 MD120
• Developing Interface Programs for Item Import Conversion Program
• Payables Open Interface
• On Hand quantity Transaction Open Interface

Confidential, Fountain Valley, CA

Senior Technical Consultant

Environment: ORACLE 11g, Oracle Applications R12, Forms 10g, Reports 10g, PLSQL Developer, Informatica Power Center 9.5.1

Responsibilities:

• Creating the design documents for the interface between the legacy and proposed system and implementing the same in Production environment.
• Developing Oracle Application Custom Reports, Alerts, API’S and Interfaces.
• Creating the design documents for the New Reports and implementing the same in Production environment.
• Implementing the scenarios for testing, Mapping data and performing data validations.
• Involved in the preparation of following documents MD070 MD120
• Developing Interface Programs for Payable Invoices General Ledger Interface ETL Interfaces
• Transactional Data Store (TDS)
• TDS reads five incoming flat files such as lease, retail (loan), dealer, credit and funding; validates and loads into 12 relational database tables.
• Dealer Number Translation
• Reading flat files, translating dealer number and creating new flat files.
• DataScan WMS Interface
• Reading flat files and splitting the files into HCA and HCCA based on corp codes.

Confidential, San Diego

Senior Technical Consultant

Environment: Oracle 11g, TOAD, Perforce & Linux

Responsibilities:

• Development of Oracle objects like Packages, PL/SQL procedures and Triggers.
• Developing and Managing PL/SQL packages to interface data between CLMS and core DW.
• Creating the detail design documents for the new programs development.
• Implementing the scenarios for testing, Mapping data and performing data validations
• Creating JOB SCHEDULER for data migration.
• Providing production support.
• Verifying client schemas data refresh through JOB SCHEDULER
• Preparing Implementation and Verification Document

Confidential, Birmingham

Techno-Functional Consultant

Environment: ORACLE 11g, Oracle Applications, Forms 6i, Reports 6i, PLSQL Developer, Workflow Builder

Responsibilities:

• Creating the design documents for the interface between the legacy and proposed system and implementing the same in Production environment.
• Oracle Reports converted to BI Reports.
• Developing Oracle Application Custom Reports, Alerts, API’S and Interfaces.
• Creating the design documents for the New Reports and implementing the same in Production environment.
• Implementing the scenarios for testing, Mapping data and performing data validations.
• Involved in the preparation of following documents MD070 MD120 CV070
• Developing Interface Programs for Item Import Conversion Program Item price update Interface EAM Resource Transaction Interface On Hand quantity Transaction Open Interface

Confidential

Senior Technical Consultant

Environment: ORACLE 10g, Oracle Applications 11.5.10, Forms 6i, Reports 6i, TOAD

Responsibilities:

• Developed Oracle Application new and Custom Reports and Interfaces.
• Developed Oracle Application Custom Reports, API’S and Interfaces.
• Customized Purchasing Requisition workflow for OAF Notification message.
• Developed Interface Programs for Bank Statement Open Interface API for create Ship To sites and trading partner informations API for loading receipts

Confidential, Florida

Senior Technical Consultant

Environment: ORACLE 8i, Oracle Applications 11.5.8, Developer 2000 (Forms & Reports), TOAD

Responsibilities:

• Creating the design documents for the interface between the legacy and proposed system and implementing the same in Production environment.
• Developed Oracle Application Custom Reports, Alerts, API’S and Interfaces.
• Creating the design documents for the New Reports and implementing the same in Production environment.
• Implementing the scenarios for testing, Mapping data and performing data validations.
• Developed Interface Programs for Purchase Order Interface Price List - Application Program Interface Bills Of Material Interface Payables Open Interface Suppliers Interface

Confidential

Technical Consultant

Environment: ORACLE 8i, Oracle Applications, TOAD

Responsibilities:

• Creation of responsibilities, request groups & menus, Creation of users & assignment of responsibilities.
• Experience of basic AOL Sysadmin tasks like creation of users, assigning responsibilities and adding the Programs in Request group etc.

Confidential

Technical Consultant

Environment: ORACLE 8i, Oracle Applications 11.5.8, Developer 2000, TOAD

Responsibilities:

• Generated the new Reports and customized the existing reports.
• Data Migration from Legacy to Apps Database. (PORTING)
• Involved in the preparation of following documents MD070 TE040
• Developed Interface Programs for Customer Interface Autoinvoice Interface Price List - Application Program Interface Payables Open InterfaceSuppliers Interface

Confidential

Analyst

Environment: Oracle PL/SQL, TOAD

Responsibilities:

• Database design and maintenance
• Purchase and purchase return
• Sales and sales return
• Development of PL/SQL procedures and Triggers.
• Development of Packages, PL/SQL procedures, Functions and Testing,
• Preparing test cases,
• Loading test data’s (In the TD)

Confidential

Senior Programmer

Environment: Oracle, Forms, Reports, TOAD

Responsibilities:

• OLB Creation.
• Form Design & Validation.
• Development of Packages, PL/SQL procedures and Triggers.
• Creation of Reports.

Confidential

Senior Programmer

Environment: Oracle, Forms, Reports, TOAD

Responsibilities:

• Database design(table) and maintenance
• Development of Packages, PL/SQL procedures and Triggers.
• Creation and Customizing the Reports
• Patient test category and parameter selection
• Purchase and purchase return
• Sales and sales return
• Optometrist forms designing and Validation