OBJECTIVE:

My goal is to partner with a progressive organization and work towards mutual objectives of growth, efficiency and cost containment by leveraging my analytical, organizational and management skills

• Over 18 years of extensive experience in complete SDLC including Analysis, Design, Development, Integration, Deployment, QA, Documentation, Support and Migration.
• Experience in managing all phases of the Project Life Cycle right from initiation through to planning, execution and closure; managed project scope, schedules & timelines, indentified SMEs, facilitated meetings, captured and summarized outcomes.
• Customer Interaction and support experience on production and implementation of large projects.
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
• Technical expertise in Business Intelligence (BI) and Data Warehouse (DW) solutions using Teradata and DB2.
• Proficient in Architect, Design, Development and Maintenance of Teradata tables and views.
• Adept in logical and physical design data analysis, extract transform and load (ETL), normalization and modeling.
• Experience in writing SQL, PL/SQL, Materialized Views, Optimization tuning techniques using Explain plan, SQL Trace.

TECHNICAL SKILLS:

RDBMS: Teradata V2R5/V12/V13, DB2

Teradata Utilities: MLOAD, FAST LOAD, FAST EXPORT

ETL Tool: Informatica

OS: Windows, DOS, MVS, TSOZ, MVS, UNIX

Languages: Teradata SQL, PL/SQL, COBOL,

Other Tools: MS Office, MS Access, MS Projects, MS Visio, Teradata SQL Assistant

Quality Software: HP Quality Center

Industry: Retail, Finance, Banking,

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Held increasing roles namely programmer, Senior Programmer, Systems Ananlyst, ETL Architect, ETL Tech Lead, Team Lead.
• Created High level design and Solution Specification documents as per the requirements for off - shore team to develop.
• Involved in creating efficient data model design for better performance.
• Managed off-shore resources in developing the better solution, testing and implement the changes.
• Extract, Transform and Load data from various sources to teradata using MLOAD, FAST LOAD, FAST EXPORT and BTEQ
• Created Tables, Views and Materialized Views for better performance.
• Assisted off-shore team to prepare the Unit test plans and execution of unit test plans.
• Involved in Business user acceptance test to implement the changes to production.
• Guided team members in resolving technical issues and fine tuning the application.
• Proficient in tracking issues using HP Quality Center software for defects.
• Maintained and created the workflows for project deliverable documents using SharePoint software tool.
• Used PGP encryption of the sensitive data using Protegrity software.
• Involved in implementation of the application without any major issues.
• Provided production and day-to-day support and resolved many issues.
• Involved in Baseline and Benchmarking tests for software upgrades.
• Handled lot of maintenance and enhancement tasks

Confidential

Flexible Fulfillment

• Flexible Fulfillment (FF) will enable Lowe’s to better meet the needs of its customers by leveraging its existing network’s inventory via enhanced customer order management capabilities.
• The goal of Flexible Fulfillment is to put the systems and processes in place to enable the sale of product at any location (Retail store, in-home, web, 800 #) to be fulfilled/delivered from the appropriate node in the Lowe’s network for delivery to the customer’s home (or store/installer) as governed by business rules.
• Key project objectives are to better leverage inventory and reduce costs by enabling central delivery of large items such as appliances, while also providing a means to offer value-added services to Lowe’s customers.

Confidential

EPP Sales and Out for Repairs

• This project is providing Extended Protection Plan for the products customer bought and provides the repair service for the items they bough.
• Verify the eligibility of the Protection plan, receive defective product, sent it to the local service providers, tracking of the service, inform the status of the services to customers and payment of the extended protection plan claims to customers and provide payments to service providers and building the customer asset purchase history in teradata for end business users reporting.

Confidential

• Lowe’s partnered with Confidential and Confidential and issued co-branded credit cards to its customers.
• Created the teradata tables to build the customer information and their spending.
• Created various MicroStrategy reports for the business users for the analytical purposes.
• Customer sensitive information was decrypted using PGP encryption software.

Supply Chain Data Management

Confidential

• Supply Chain Data Management aims for the centralized storage of data elements and analytical reporting allowing the business to focus on using accurate information.
• This centralization of the data and reporting will also reduce redundancies in reporting, reliance on non - standard tools and data extraction and help ensure that performance measurement definitions are accurate and agreed upon by all users of the information.

Confidential

• Confidential describes the method for obtaining and storing data needed to support the Canadian stores Plan Re - Plan Reporting effort.
• This reporting will provide visibility to Sales, Vendor Order, Shipment, Inventory and DC-related forecasts. It will provide forecast analysis and comparisons as well as forecast accuracy reports.

Confidential

• The GBI North Sales Application will receive sales transactional data transferred from Canadian store locations to the host mainframe environment through MQ Series and place them into a consolidated sales data repository with appropriate country code information.
• The country code will be used to identify the sales transaction is either from a US store or a Canadian store.
• All the downstream applications that receive sales data will be feed in two currencies.
• The sales data feeders will be split into two to feed the sales data for the US Stores and for the Canadian Stores.
• The sales Data Repository will be changed to include some of the new requirements such as Product Code on a item level to calculate tax correctly and GST and PST for the Canadian stores.

Environment: Teradata V13, Teradata Utilities V13, VSAM, TSO/ISPF, MS office, HP Quality Center.

Confidential

• Confidential is to implement a Sales Tax system that will meet Canadian regulations and improve Lowe’s Sales Tax capabilities and compliance domestically.
• The goal of the project is cost reduction, increasing return on investment capital, effectively managing risk, and improving Lowe’s control environment.
• This project will position the Finance organization and specifically Sales and Use Tax for Canadian expansion along with enhancing current domestic shortcomings.

Confidential

• Confidential project was a re-write of the existing Sales processing systems which had many challenges and issues.
• Programs written in Assembler and SAS codes. Sales data from stores were transferred on daily at end of each day and the reporting was done on next day.
• The sales transactional project provided the sales data to a near real time and the business and Executives can see the sales totals and volume on an hourly basis.
• This project used MQ series, DB2 tables and batch jobs to process the data and make necessary validations before it get reported.

Confidential

• Confidential project is to expand Purchase Order number, Vendor number, Item number, Location number, Salesman number, Region and District numbers to accommodate the company expansion.
• Prepared Impact Analysis for the impacted programs/files.
• All batch and online programs has to be modified for the above purposes.
• Some VSAM file references were replaced with DB2 tables.
• Prepared program change document, code, testing and implementation of the programs.
• Did production support for the batch programs.

Environment: VSAM, DB2, MQ Series, TSO/ISPF, MS office, BMC.

Confidential

Consultant

• Credit card system project involved in the User requirements sessions and gathered the requirements and assessed the requests.
• Prepared system requirements and program Specification documents for the Credit Cards System.
• All programs coded with Y2K compliance. Designing function and condition lists, program flow charts.
• Managed a team of 5 members Conducted code walk through, system test and implementation of the system.

Confidential

Consultant

• Prepared of technical specification for the user request.
• Development of the programs in accordance with the standards.
• Assisting the team members, unit testing, preparation of the technical documentation of the program, Code walkthrough with the User.
• Implementation of the system and provided support.

Confidential

Programmer Analyst

• Worked as offshore analyst for analyzing PCR (Project Change Request).
• Prepared technical specifications and completed the Impact analysis. Code change, reviewing the progress, code walk through, Preparation of test data, Test Plan, Unit testing and system testing.
• Release and monitored the application changes in production. Did various production systems’ support for Confidential .