I have extensive experience on Oracle Technologies, Datastage, Teradata with knowledge in Retail, Banking, Supply Chain Management, Order management, Inventory, Purchase Order.

Highly proficient IT professional with proven analytical abilities and organizational skills having 10 years of international industry project experience involving leadership and consulting on Oracle technologies, writing Stored Procedures Package, Functions, Trigger.
Performance tuning using Explain Plan, TKprof, Autotrace, Materialized views, DBMS_Stats
Extensive experience with Database Design and Architecture.
Bug fixing & Production Support, enterprise application integration, Enhancement.
Extensive experience on Datastage 8.1 in developing Parallel, Seq, Server jobs etc.
Experience with Teradata, Bteq Scripting, Tload
Well-rounded, communicative, creative technical problem-solver.
Fast learner and have consistently cited ability to achieve rapid comfort level in new environments and almost immediately develop optimal solutions.
Innovative, self-motivated, tutor, trainer, team-builder, and technical leader.
Rigorous, quality-conscious contributor with solid analytical and writing skills.

RDBMS: Oracle-9i, 10g, SQL- Server, Teradata, MS-Access-2000
Oracle-9i/10g SQL*Plus, SQL, PL/SQL, SQL*Loader, Export/Import
Front-end: Developer-2000, Developer-6i, Forms, Reports, ASP, VB-6
ETL Datastage - 8.1, 7.5
Programming Languages: PL/SQL, Pro*C, C, JAVA, Shell Scipting
Job Scheduler Appworx, Autosys Job Scheduler, ESP, Concurrent Manager
Source Code Management Merant Version Manager & Tracker, Visual Source Safe (VSS), PVCS, Subversion
Other Tools & Applications and OS: UML, MS-Project, Remedy, Toad, PL/SQL Developer, SQL Navigator, Discoverer, Crystal Reports, Erwin, Lotus Notes, Mercury, Unix, Linux, AIX, EDI

Sr. Developer, Confidential, US Mar-2008 to Current

Office depot runs suite of applications to support the strategic functioning of its Merchandising Department and its business partners.

RDF 13.1 Upgrade: - Office Depot upgraded to RDF 13.1 to replace its existing RDF 9.4 version. Unlike RDF 9.4, RDF 13 solution uses a configuration that will be customized using Configuration Tools to fit business requirements like Hierarchies, Data Interfaces, Measures, Rules and Workbooks. Curve, Final and Source Levels, Grade and Promote will also be customized using Configuration Tools Automation. The various interface data resides on different databases across different platforms. The necessary data was extracted, transformed and FTP to the RPAS server in a format readable and loaded to the Multidimensional RDF database. Forecasts produced by the Demand Forecasting system enhance the retailer’s supply-chain planning, allocation, and replenishment processes, enabling a profitable and customer-oriented approach to predict and meet product demand.

Oracle Retail Merchandising System: - Office Depot implemented Retail Merchandising system to Define and use the

• Organizational Hierarchy structure
• The Merchandise Hierarchy structure
• Describe the supplier structure and financial interface
• Describe the differences in the new item types
• Create transfers, returns to vendor and mass return transfers
• View Inventory
• Process cost changes
• Describe the supplier structure and financial interface

I have supported, maintained and enhanced the RMS System through its various phases of life cycle.

Confidential: - Office Depot implements promotional pricing across channels. Office Depot has many active promotional vehicles running concurrently. The retail channel promotions include weekly inserts, Run of Press (ROPs), Direct Mail (multi-channel), Grand Openings as well as in-store only promotions. The direct channel promotions include Catalogs, Direct Mail, as well as on-line promotions.
Single source for all promotions – fits with our simplify objectives of being channel agnostic.
Processes, workflow & security around promotion creation, approval, etc. would be consistent and managed by a single team vs. creating another team for contract. 
Validation with other promotions that are already in the system to prevent ‘doubling up’
Single feed of all promotions to QP & POS from IPS
Purchase Information Pack A vendor Purchase Information Pack (PI Pack) serves as a written documentation of Office Depot’s agreement with a vendor regarding products or services for resale and the processing of vendor program funds. The financial terms outlined in the PI Packs are used by the merchants to forecast vendor program funds. Hence, the ability for merchants to provide a more accurate forecast depends on the accuracy of fully negotiated and approved PI Packs. The existing PI Pack process is very manual. The PI Packs are captured via chains of e-mails between merchants, vendor programs, supply chain, legal, accounts payable, merchandising vice presidents, vendor relations and the vendors. This level of involvement in the review and approval process creates many opportunities for error, delays and may impact our ability to accurately bill vendor program funds. Indeed, the effects of the errors and delays can be felt by other operational groups as well. In addition, an opportunity exists to improve the accuracy of program forecast by automating the manual process of linking the PI Pack terms to the new Vendor Program Forecast application.
HP Sales Reporting via EDI867: - HP requested their sales data from Office Depot (reseller) be sent to them for compensation of its sales force. The Sales data resided in Teradata Data warehouse. The project involved extracting the sales and other relevant attributes and formatting in 867 format and sending messages to MQ. The messages were later received and interfaced to GENTRAN for EDI transmission.

Environment : Oracle 10g, Toad, PL/SQL, UNIX, Datastage, Teradata, SQL-Server 2000. ESP scheduler, Queryman
Role : Developer, Designer, Architect

Technical Leader, Confidential, US Oct 2006 to Feb-2008 
Client:-Confidential, Hanes Brands International (HBI) global consumer goods company with a portfolio of leading apparel essentials. Hanes brands, was spun off from Sara Lee Corporation in 2006.
The HBI Supply Chain consists of following sub systems

• Finished Goods Planning System (FGP)
• Advanced Planning and Scheduling (APS)
• Material Requirement Planning (MRP)
• Purchasing (PUR)
• Shop Floor Control (SFC)
• Saralee Intimate Inventory Control (SLIIC)
• Specification Management System (SMS)
• Engineering Data Management (EDM)
• Costing System (CST)
• Product Standard Costing (PSC)

The scope of the project was to provide overall production support to the each of the subsystems and provide continuous enhancement and break fixes.
Environment  : Oracle 9i, PL/SQL, SQL* Plus, SQL Navigator, Datastage, AutoSys Job Scheduler, HP-UNIX, AdvantageGen-6.5, Mercury, IQ
Role : Architect, Technical Leader, Developer
Team Size : 7

• Responsible for overall production support issues
• Create functional and technical design specifications for enhancements and bug fixes.
• Develop stored procedures, packages, triggers, and other Oracle database logic.
• Performing code review for the code changes from offshore.
• Performing Unit Testing, Integration testing for the new bug fixes and Enhancements on Development & Test Environments.
• Providing estimates for completion times.
• Responsible for overall all the deliverables and coordination from offshore.

Catalina helps its retailers and manufactures reach their potential by proposing behavior-based marketing solutions – leveraging actual shopper purchase behavior to reach the right consumer at the right time. Catalina comes up novel coupons to boost the sales of the retailers or to launch new products for its manufacturers. There are various application involved like the 3D, 3D Portal CSDB, ODM, ,ODM Viewer, Store System.
The Catalina Order Management which mainly constitutes of 3D & CSDB.

CSDB (Central Store Database) holds all the retailers and manufacturers that have association with Catalina.3D creates order for printing coupons and receives retailer and manufacturer information from CSDB.

Environment : Oracle 10g, Toad, PL/SQL, UNIX, VB-6, ASP, .Net, Discoverer, Erwin, XML
Role : Technical Leader, Developer
Team Size : 5

Create functional and technical design specifications for enhancements and bug fixes.
Develop stored procedures, packages, triggers, and other Oracle database logic.
Performing code review for the code changes from offshore. 
Performing Unit Testing, Integration testing for the new bug fixes and Enhancements on Development & Test Environments.
Providing estimates for completion times.
Responsible for overall all the deliverables and coordination from offshore.

Confidential, US, Technical Leader Jan-2006 to Oct-2006, Systems Analyst May-2003 to Jan-2006

Project: - Distributor Process and Systems (DP&S): - Consists of two major applications - Business Management System (BMS) and National Distributor Host (NDH). 28 North American distributors of Cummins - 23 in US and 5 in Canada - use this application. Each Distributor has a corporate office which houses the database and several branches are connected to it via WAN. NDH is the central repository that contains information common to all distributors and is located in Columbus, IN. The scope of the project is to provide production support to BMS and NDH applications deployed at all distributor’s locations, and construction of new modules. There are various modules in the systems such as Service (WO, Warranty and Time Management), Finance (AR, AP, Financial Close), Sales (Project Management, Preventive Maintenance), Parts and Inventory (Inventory and Core Management).
Environment: Oracle 9i, PL/SQL, SQL* Plus, SQL Navigator, Reports-6i, Forms-6i, AIX, Appworx, EDI, FTP
Role: Technical Leader
Team Size: 30

Gathering high-level requirements from client. Analyzing and translating those requirements into written plans.
Translate high-level business requirements into low-level tasks and then design Oracle PL/SQL code to accomplish these objectives.
Create functional and technical design specifications for development efforts. 
Develop complex Stored Procedures, Functions, Packages, Triggers, and other Oracle database logic.
Developed new Forms and Reports and modified existing ones to incorporate new business needs. 
Design, analyze, and develop efficient table and index design, monitor and tune performance and execution plans to improve performance.
Designing components and performing complex Coding/Programming, De-
bugging and Testing within a Data-Management system
Worked with development team to improve Oracle application performance and resolve real-time problems as they occur.
Prepare requirements specifications, design documents and unit test plans. 
Performing Unit Testing, Integration testing and infant care for new modules and enhancements in production.
Providing estimates for completion times and required resources for assigned projects and program initiatives.
Providing mentoring and/or guidance to others on Oracle PL/SQL.
Performing code Reviews and Design Reviews.
Participating in user group meetings to understand new enhancements and existing problem areas.
Resolving user issues/tickets and consistently maintained high SLA.
Responsible for overall production support issues for modules such as Inventory, Purchase Order management, Sales Order Management & NDH.

Confidential, Software Engineer Aug-2000 to May-2003

Associates India is the premium NBFC (Non Banking Financial Corporation) in providing loans to individual customers and corporate customers on attractive interest rates and different schemes. 
Project: - Loan Branch Change: As a part of customer care and to serve its customers better the module was incorporated. Incorporation of Branch Change System will address the following areas:

was transferred.
The Module allows following types of Branch Changes

• Enabling 180 days overdue cases to AMU (Asset Management Unit)
• Loan seeding (Branch Change due to customer request/Management decision for proper servicing)

Project:- Daily Status Report: The MIS required various reports displaying the previous figures of No of loans booked under its various product groups like Auto New, Auto Used, Personal loans, Home Equity etc and also the data corresponding to the current date for previous six months based on the working days remaining for the month. The report were generated to gives the management a fair idea of their performance wrt their previous month’s performance.

• Branch
• Region
• Country

Project: - Loan Renewal: The loan parameters are governed by the requirements of the customers and the schemes, Associates offers. Every loan goes through various stages like data entry, credit approval, disbursal and authorization. 
Earlier System did not allow a change of loan parameters post Authorization
The Module will allows the change of following Financial Parameters

• Change in EMI
• Change of Interest Rate
• Additional Disbursal
• Change in due date
• Change in tenor
• Installment Type
• Option of Part Prepayment
• Option of Additional Disbursal

& Non Financial parameters

• Branch Change
• Scheme Change
• Product Change

Environment : Oracle-8i, PL/SQL, SQL* Plus, Toad, Crystal Reports, ASP, VB Script, COM, DCOM, Windows-NT
Role : Software Engineer
Team Size : 4
Duration : Feb 2000 – May 2003

Develop Stored Procedures, Packages, Triggers, and other Oracle database logic.
Performing Unit Testing, Integration testing for development efforts.
Prepare Unit test and Integration Test Plan.
Prepare User Training Guides and provide User Training.

BS-Computer Science in US.