We provide IT Staff Augmentation Services!

Application Programmer Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Senior Oracle database developer with over 12 years of experience in PL/SQL development and performance tuning of large enterprise databases.
  • Experienced Oracle Retail technology professional seeking consulting opportunity to utilize experience in integration of Oracle retail modules using Oracle 10g/11g, Oracle Forms 6i/10g, Reports 6i/10g, PL/SQL, Pro*C. Also well versed with ETL, BI and WMS tools and technologies.
  • Subject Matter Expert/Consultant (Functional and Technical) in integration and implementation of Oracle Retail (Retek) modules such as RMS, REIM, RDW and RPM and enterprise e - Commerce systems.
  • Proven hands-on experience with strengths in Enterprise Data Integration (ETL), Data Warehouse Management Systems (WMS) and Business Intelligence (BI) using OBIEE and IBM Cognos 8.0.
  • Expert level understanding of commonly used EDI Transaction codes and their integration with RMS.
  • Worked on all stages of software development life cycles (SDLC) from requirement, analysis, prototype, development and implementation.

TECHNICAL SKILLS:

Oracle Retail Modules & Functional Expertiese: RMS v 10, 11, 12, 13, ReIM v 12, 13, RPM v 11, 13, RDW v 10.2.2, 11, ReSA v 13, RIB 13.2.4, Allocation 13.2.6, Foundation Data (hierarchies, suppliers, buyers), Item Maintenance, Pricing Management, Cost Changes, Invoice Matching, Customization of RMS screens using Oracle Forms 6i, 10g and 11g, Implementation of customized screens in RMS, Integration of third party vendor Warehouse Management System such as Manhattan PKMS and Highjump with RMS, Integration of commonly used EDI Transaction codes such as 888 (Items), 850 and 860 (Purchase Orders), 856 (Vendor ASN), 810 (Invoices).

Database: Oracle 9i/10g/11g, SQL Server 7.0/2008.

Tools: Oracle 11i ERP, Oracle Business Intelligence (OBIEE), Procedure Builder, SQL*Plus, SQL*Loader, SQL*Net, Net8, OEM, IMPORT/EXPORT, RMAN and Oracle Forms & Reports 6i/10g, Graphics and Procedure Builders, Oracle Designer, Oracle Business Intelligence (BI) IBM, Cogons 8.0, Erwin Data modeling tool, MS Office, MS Visual Source Safe, JIRA Ticketing System.

Platform: Linux/UNIX, Windows.

Languages: SQL, PL/SQL, T-SQL, Pro*C, UNIX Shell Scripts, Visual Basic 6.0, Java, XML.

PROFESSIONAL EXPERIENCE

Confidential

Application Programmer

Responsibilities:

  • Working in Agile/Scrum, responsible for maintaining and supporting RMS 12.9 version and all interfaces through Retail Integration Bus (RIB) with external applications like such as Purchase Order system, Product Information Management System (PIM), Warehouse Management System.
  • Worked on backend/custom data models for Promotions, Pricing and Clearance (PPC) system that provides single view of information across all business to include various pricing types such as green label, etc. Also, worked on integration of this system with RMS data model.
  • Worked on Truck Scaling application to optimize space utilization and simply distribution to various stores reducing overflow and streamlining logistics from distribution center to retails stores.
  • Developed, designed and implemented various interfaces for ETL from OLTP system to data warehouse using Oracle, SQL, PL/SQL.
  • Automated system using SQL Loader for uploading excel documents to different OLTP systems like RMS, Allocation, etc. to easily provide relevant information to business users.
  • Handling large xml objects(file) and parsed data into Oracle table and generating XML file from Oracle tables.

Confidential, NY, NY

Sr. Oracle Developer

Responsibilities:

  • Involved in project of merging of four brands Lord and Taylor, Off fifth, Saks Fifth Avenue and Confidential Company (HBC) under one global system as Confidential as ecommerce and one database.
  • Performed day to day activities of ETL processing with exchanging data with external vendors using SQL loader.
  • Hands on experience in converting all batch processing from Oracle 11 to Oracle 12c database.
  • Developed purchase order form for all banners using Oracle forms 10g.
  • Designed and developed User Defined Attribute (UDA) form using Oracle forms 10 g.
  • Developed various business reports using Oracle Reports 10 g like RFS extract, Flash sales etc.
  • Provided L2 support for 24X7 help desk supporting internal business systems and trained end users for newly developed functions. Also, responsible for daily and nightly/weekly processing support.

Confidential, Katy, TX

Oracle Retail Consultant

Responsibilities:

  • As Oracle retail admin, set up security matrix and assigned roles to users and linked to OID.
  • Implemented Oracle retail database patches for RMS, RPM, ReIM and ReSA Oracle retail Modules version 13.2.4.
  • Explained and implemented base database retek policy and set up filter merch group base tables.
  • Designed, developed and implemented Oracle 11g form 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 RMS, Allocation, ReIM, ReSA issues.
  • Reprocessed RIB Failure inventory transaction messages by correcting data in xml and debugging RMSSUB and RMSMFQ PL/SQL Packages.
  • As a key person responsible for creating high level/architect design document for transferring operational data from RMS to an enterprise data warehouse(EDW) used for reporting and data analysis.
  • Reviewed detail requirement from business analyst and filled in gap for any data missing from RMS to EDW.
  • As a key RMS expert, recommended full or delta extracts according to size of data. For example, data from ITEM LOC SOH were extracted full at initial and delta on words.
  • Prepared documents for validation of synchronizing data between RMS and EDW.
  • Worked on reporting design documents using OBIEE for Item, Purchase orders, Sales, Account payable reports.

Confidential, Minneapolis

Consultant

Responsibilities:

  • As part of OLR team, worked as a Technical consultant on following projects.
  • Conducted Discovery Session for implementation of Standalone 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.
  • Worked on Post production issue for ReSA and resolved issue on extract from ReSA to RMS
  • 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:

  • Provided expert level consulting of RMS functionality in area of Item, Purchase orders to data integration team and resolve any issues during design, development and integration of systems.
  • Created mapping documents for Inbound and Outbound interfaces from RMS and third party vendors for e-Commerce and TMS systems.
  • Created complex queries to extract data out of RMS for building front end systems such as Web Store for e-Commerce.
  • Created high level techno functional design for integrating e-Commerce with RMS.
  • Designed and developed mapping documents, in both XML and CSV formats, for various entities like Store, Warehouse, Supplier, Items, Purchase Orders, Allocations Orders and BOM for HighJump WMS and Mercury Gate TMS.
  • Assisted development team for creating and tuning complex queries for SSIS ETL packages.
  • Designed and integrated data interface for reconsolidation application between Oracle Retail Sales Audit and third party vendor product ReconNET (Trintech Solution).
  • Assisted functional team to explain configuration of ReSA and all tender types.
  • Generated daily extract for ReconNet after completion of Stock ledger extract from ReSA to JDE financial system and loaded log in SA Export Log.

Confidential, NY

Senior Oracle Consultant

Responsibilities:

  • Upgrade ReIM from v 12.8 to v 12.11.1.3 and integrated with JD Edwards ERP system.
  • Resolved issues with ReIM due to that match invoices are not being posted.
  • EDI Invoices received before shipment, go to unresolved status directly. This issue is resolved by introducing PL/SQL job in ReIM Chain.
  • Designed interface/Screen to give functionality in RMS so User can query on Order, Get invoices detail from (Im doc head) and receipt info (from Shipment).
  • Designed and developed all Invoices reports like Invoice received but not paid, Accrual report.
  • Generate email program for rejected Invoices from EDI and send to vendor accordingly.
  • Designed, developed and integrated Vendor Compliance/Restriction module consisting of data model changes, various user interface screens and PL/SQL packages using Oracle Forms 10g. This module allowed error free order execution to take place from procurement to pay.
  • Developed a program using PL/SQL and DOM to parse XML files containing PIX (perpetual inventory transactions) transactions from third party ecommerce vendor and insert data (receipts and inventory adjustments) after formatting into main repository of Retail Management System.
  • Implemented a Product Catalog module to help buyers and merchandize planers balance between demand and supply of certain products. It allowed users to query product/orders data and export and email customized reports using Oracle forms, Screens and SMTP PL/SQL packages.
  • Based on Conference Room Pilot CRP, enhanced and customized order entry screens and inventory management screen for day to day business operations.

Confidential

Technical Consultant

Responsibilities:

  • Designed, developed and implemented ETL processes to extract and format vehicle history data from various third party systems into Confidential ’s warehouse.
  • Tuned Certified Pre Owner (CPO) reporting system for optimal performance. Developed and/or modified Oracle packages, stored procedures, functions using PL/SQL and generated reports using Cognos.
  • Redesigned nightly batch processes in order to complete during maintenance hours and meet SLAs.
  • Migrated almost 200 reports from cognos 7 to cognos 8.
  • Developed Shell scripts via Control M scheduler to execute to meet different schedule.

Confidential, Buffalo, New York

Oracle Systems Analyst

Responsibilities:

  • Created architectural design for various vendor deals/promotions programs such as off invoice, bill back or scan back deals. Implemented using PL/SQL packages and interfaces.
  • Redesigned and replaced a legacy application providing statistics of products received in store to Oracle using Oracle forms. The system allowed tracking of product inventory for various stores.
  • Implemented system to cross reference vendor data between Oracle Financials and Oracle RMS.
  • Developed Order Delivery and Invoice Management system between master and associated suppliers and distributors.
  • Converted DFA Foundation data - store information, item data and vendor details - from legacy systems to Oracle 9i.
  • Created conversion programs to convert large volume of sales history data to RMS.
  • Developed various customized interfaces using PL/SQL to convert UPC item data from Oracle RMS system to AIS system and intellitrack.
  • Implemented ETL processes to transforms Retek Pricing Management (RPM) data into Retek Data Warehouse (RDW) and generate various reports for promotion and clearance analysis.
  • Provided L2 Support during different phases. Helped troubleshoot issues and created SR with Oracle as required.
  • Designed and developed Store Deal Management system. The system helps create store deals, add/delete items to store details and finalize store deals as per business requirements and corporate guidelines into RMS. Also, developed reports for Promotions and Deals using Oracle Report 6i.

Confidential

Programmer/Consultant

Responsibilities:

  • Implemented Order Management System for an engineering tools retailer using Oracle 9i, Forms 6i on Windows 2000. Also, developed reporting system using Oracle Reports 6.
  • Created HMS Web Application for Merrill Lynch using Visual Basic 6.0, COM/DCOM and Active Server Pages (ASP). Created database triggers and stored procedures to support business rules. Designed UI using Visual Basie to translate existing ERWIN data model into Omnibuilder Business object. Developed use test cases to support QA based on business functions and requirements. Also, assisted in performance tuning and change management with the system.
  • Designed and developed functionality to migration of repository to SQL Server from Oracle. Improved performance of OmniBuilder tool by fine tuning indexes on repository table, modifying data retrieval SQL and modifying some processes and program flows.
  • Defined and implemented access policy using SQL on SQL Server database for users of NHLPA system of NHLPA System Security.

We'd love your feedback!