SUMMARY

• Oracle Developer with over 15+ years of IT experience, experienced in all stages of the Software Development Life Cycle: from requirements/prototyping to implementation.
• Extensive experience includes functional and technical design for backend development using SQL and PL/SQL (packages, stored procedures, and functions) for Oracle 10g and SQL server 2005.
• Wide exposure in mapping legacy databases to ERP databases using Extract, Transform, and Load (ETL) into Oracle Database using SQL Loader and PL/SQL.

TECHNICAL SKILLS

Servers: Windows NT4.0/Windows 2000, UNIX, ALPHA VMS

Database: Oracle 7/8i/9i/10g, SQL Server 7.0,2000,2005

Languages: SQL, PL/SQL, T - SQL, Visual Basic 6.0, Java 2, C++ and Pro*C

Oracle Tools: Oracle 11i ERP, Oracle Business Intelligence (OBIEE), Procedure Builder, SQL*Plus, SQL*Loader, SQL*Net, Net8, OEM, IMPORT/EXPORT, RMAN and Oracle Forms 6i, Reports, Graphics and Procedure Builders.

Other Tools: Oracle Designer, Oracle Business Intelligence (BI) Discoverer plus, Rational Rose, Erwin Data modeling tool, MS Office 2000, MS Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Katy, TX

Oracle Retail Admin Oracle

Responsibilities:

• As Oracle retail admin, responsibility to set up security matrix and assigned roles to users.
• Revised earlier set up roles according to OID so no user can connect through database using sql developer
• Designed, developed and implemented Oracle 11g interface in oracle form 11g to change password for Allocation system as Allocation system is not integrated with OID as other module like RMS, ReIM, RPM
• Assigned various department to buyer as per instructed by business.
• Providing level 3 support for debugging and analyzing data issue by writing complex quires and generating validating reports.
• Reprocessing RIB Failure inventory transaction messages by correcting data in xml

Confidential, Minneapolis

Consultant

Responsibilities:

• Conducted Discovery Session for implementation of Standalone Retek Sales Audit - ReSA.
• Prepared presentation to give overview on ReSA and export and import process from ReSA.
• Created SR for Allocation system 13.2.4 and attended OWC call for various SR and testing of custom patches provided by oracle and educated Toy R' Us team
• Designed, developed and implemented stock ledger data from OLTP system to Warehouse system.
• As a integration technical consultant, prepared technical specification on custom interface for sending Replenishment Attributes and Reclassification Items to warehouse system.
• Reviewed code received from off shore team.
• Conducted Smoke test on RMS 13.2.6,RPM 13.2.6, ReIM 13.2.6 and tested RMS, RPM and ReIM batches on SIT environment.

Confidential, Jacksonville FL

Oracle Integration Contractor

Responsibilities:

• As a key contributor responsible Oracle Integration Contractor, responsible for integration between Ecommerce application on Oracle 11 g and Oracle retail Merchandize system(RMS) . Completed Mapping documents and technical design for PL/SQL packages in Oracle 11 g.
• Designed, developed and integrated ReconNet Accounting consolidation application interface between Third party vendor and Retek Sales Audit ( ReSA) in Oracle 11 g and PL/SQL.
• Completed Mapping documents for In and out data ETL for Warehouse Management System (WMS) and Retail Merchandize system (RMS).
• Tuned complex SQL queries for SSIS packages which was used as a ETL tooled between data transfer from Oracle 11 g to SQL server 2008 R2 (Reporting server for Micro strategy)

Confidential, Centreville, VA

Technical Oracle Consultant

Responsibilities:

• Designed, developed and implemented ETL process to convert vehicle history data from various agencies.
• Designed, developed and implemented various Business reports using OBI
• Developed Certified Pre Owner (CPO) program for Auto dealers writing Oracle Packages. Stored procedures and function.
• Designed, Developed and Implemented various customized interfaces using PL/SQL on Oracle 10g
• Tuned nightly batch processes to complete during nightly off time.
• Provided level 2 supports to business user and modified existing reports Oracle Business Intelligence.
• Wrote shell scripts to execute daily, weekly and monthly process through Control M.

Confidential, Montvale, NJ

Oracle/ETL Developer

Responsibilities:

• Oracle Developer using Oracle application 11i, Oracle database 10g.
• Vendor Deals/Promotion Customization.
• Responsible for creating mapping documents (Excel sheets) for source database (Legacy) to destination (Oracle) Database.
• Designed and developed external tables in Oracle Database to load flat files from legacy database into Oracle ERP tables.
• Wrote DBMS PL/SQL packages to validate data of external tables and transform and load into real ERP Tables.
• Wrote shell scripts for populating data from Flat files into Temporary tables into Oracle Database.
• Used DTS package of SQL server 2005 for one time loading of data from SQL server to Oracle.
• Finalized the architecture design for a customized program.
• Developed PL/SQL packages to populate temporary tables every night and wrote shell scripts to be executed through scheduler in nightly batches.
• Designed and developed daily reports for business users using Oracle reports.
• Product out Application.
• Redesigned and replaced old application giving statistics of product received in store and warehouse on daily basis on Oracle 10g.
• Wrote PL/SQL packages and database triggers to implement business rules and functions.
• Migrated application from SQL Server 2005 to Oracle 10 g using DTS of SQL Server 2005.
• Wrote shell scripts to populate temporary tables every night.
• Designed, developed and implemented application with Oracle Forms 6i and Oracle reports for supplier database.
• Oracle Financial/Retek Supplier Xref.
• A&P implemented Oracle Financial Application. The new interface is designed to maintain cross reference between Oracle Financial databases with Retek database.
• Designed and developed business views for workbook and worksheet of Discoverer for business users.
• Designed and developed reports using Oracle BI Discoverer for deal accounting.

Confidential

Oracle Developer

Responsibilities:

• Converted foundation data from legacy system and SQL server to Oracle 9i.
• Responsible for creating, executing and testing of conversion programs for sales history to RMS.
• Designed, developed and executed three years of sales history to RDW.
• Designed, developed and implemented various customized interfaces using PL/SQL including UPC items from RMS to AIS system, DFA sales’ Flash interface and RMS to intellitrack.
• Custom reports.
• OpenPO detail and MerchPO detail.

Confidential

Oracle Developer (Retail Systems)

Responsibilities:

• Executed mini-project for data pilot processes to set up RPM development environment, which included data load, executes, data validation, synchronism between RMS and RPM.
• Integration support.
• Provided level 2 support during various levels of testing cycles which included educating tester for RPM functionality and identifying technical bugs and raised SR with Oracle.
• Worked on Java batches to generate worksheet of prices changes through RPM.
• Modified base Retek RETL extract form, full extract, delta extract.
• Tuned others extract to be completed prior to RDW starting and RPM/RMS on-line being available.
• Received “Monster Effort” Award from Application Architecture Team for Outstanding performance and contribution.
• Store Deal Management Customization - Helped design creation of Store Deals, addition of items to Store Deals and finalizing Store Deals as per corporate business practice into RMS.
• Designed, developed and tested PL/SQL Packages to implement business rules and function for Store Deals.

Confidential

Software Consultant

Responsibilities:

• Developed and maintained forms using Forms 6i.
• Developed and modified reports using Reports 6i.
• Created reports which generated .txt, .xls, .pdf outputs.
• Developed SQL reports using SQL* PLUS.
• Wrote stored procedures, functions, database triggers, ref cursors and views using SQL* Navigator for writing Database Triggers.

Confidential, NJ

Software Programmer/Consultant

Responsibilities:

• Developed Order Management System on Oracle 9i, Forms 6i on Window 2000.
• Installed Oracle 9i on Window 2000 and set up development and testing environment.
• Created Order Entry and Query Forms using Oracle Forms 6i and PL/SQL.
• Designed various business reports on Oracle Report 6i.
• Automated Concurrent Engineering System (ACES) Sponsored by US Army, NJ.
• Migration of ACES on Oracle 8.1.7 from MYSQL.
• Installed Oracle 8.1.7 on Window NT server and set up Oracle Client on 10+ workstations for new development purpose.Created development and testing environment with related roles and privileges.
• Redesigned database using Erwin Data Modeling Tool and populated old data into new database.
• Developed “Knowledge Editor”, a web based application, for ACES using java and JDBC connection for back end Oracle Database.
• Omnibuilder Data management Case Tool.
• Designed and developed a functionality to migrate repository on SQL Server from Oracle Server.
• Designed and developed the following custom wizards using PL/SQL: