SUMMARY:

• Over 8+years of total IT Experience.
• 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.
• Good understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT& dimensions tables, physical & logical data modeling.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces wifin several modules in Oracle Applications.
• Experience in designing teh Design Documents for loading data into Data Warehouse and Data Mart tables.
• 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.
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• 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 teh PO approval process, Order/Line Flow to send user notifications based on teh business requirement.
• Experience in working wif multiple RDBMS including Oracle 11i/9i/8i, SQL Server, Teradata and MS Access.
• Strong in Performance Tuning, UNIX shell scripting.
• Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Ability to quickly adapt to teh emerging new technologies
• Good communication, language and analytical skills

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PLSQL Developer, Novi, MI

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Responsibilities:

• Coordinated wif teh front end design team to provide them wif teh necessary stored procedures and packages and t Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP he necessary insight into teh data.
• Worked on SQL*Loader to load data from flat files obtained from various sources.
• Created PL/SQL scripts to extract teh data from teh operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned teh fact tables and materialized views to enhance teh performance.
• Used teh advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Prepared migration document to move teh mappings from development to testing and then to production repositories.

Confidential

Oracle Applications Technical Consultant, Pittsburg, PA

Environment:  Oracle Apps EBS R12, GL, AR, AP, PO, INV, BOM, OM, SQL, PL/SQL, Oracle Reports 10g, UNIX, TOAD

Responsibilities:

• Worked on Equalization SAM, by creating a scheduling program.
• Worked on Data Migrations such as Customer Interface, Fixed Assets.
• Worked on creation of Installation documents, Technical Documents.
• Developed PL/SQL procedures, functions, packages, triggers to validate teh data and insert teh validate data into Oracle Standard interface tables.
• Developed validation packages to Load data to interface tables (OE HEADERS IFACE ALL, OE LINES IFACE ALL, OE CUSTOMER INFO IFACE ALL)
• Customized Sales Order form to add customer fax, email and phone number contacts.
• Worked on developing technical documents (MD70).
• Worked on SQL tuning, troubleshooting, debugging and fixing teh code and made teh changes according to teh new business requirements.

Confidential

Oracle Applications Technical Consultant, Farmington Hills, MI

Environment: Oracle Apps 11.5.10.2,Oracle 10g, Forms 10g, Reports 10g, SQL*Loader, PL/SQL, TOAD,WINDOWS XP, UNIX.

Responsibilities:

• Analyzed teh existing reports and made necessary modifications in Reports Re-Structuring.
• Developed many custom reports on various modules like PO, WIP, GL, INV, Depot Repair.
• Worked on Alerts and Conversions.
• Worked on additional requests in creating concurrent programs and creating Migration Documents.
• Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, and Open Purchase Orders from legacy system to Oracle Applications.
• Worked on Item Conversion in teh INV Module.
• Customized teh Sales Order Invoice Detail Report in Order Management.

Confidential, Cincinnati, OH

Oracle Applications Technical Consultant

Environment: Oracle Apps R12

Responsibilities:

• Involved in teh analysis of teh assigned support tickets including replicating teh issue, analyzing teh custom processes/API’s/reports/forms and updating teh ticket wif teh appropriate information
• To provided resolution to teh issues which are mostly related to order management.
• Always Meeting deliverables assigned.
• To work closely wif Functional team to gain teh functional knowledge on various modules.
• Worked on several ad-hoc enhancements and documenting teh corresponding changes accordingly.
• Closely worked wif ‘Oracle on Demand’ and support teams to fix any production bugs.
• Monitoring ASCP programs in day-to-day production environment.
• Worked on teh complete Order Management cycle, right from creating an order till invoicing.
• Possesses good knowledge on Auto invoice issues and MRP issues.

Confidential

Oracle Apps Associate Consultant Trainee

Responsibilities:

• Handled teh development and support activities at Offshore.
• Worked on both teh Inbound and Outbound Interfaces and conversions for AR and PO modules.
• Developed complex Shell programs.
• Worked on Setup Configurations including defining Flex Field Values & Value Sets and Workflows.
• Coordinated activities wif implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines.
• Responsibilities also included understanding other financial module setups and workflows including Oracle Payables, Receivables, GL etc., Preparation of Migration Documents (MD), and creation of Custom Business Areas/Folders.
• Creating table scripts, UNIX shell programs and PL/SQL procedures as per teh requirement.