Oracle PL/SQL, Data warehouse Developer

Thangam Sankar

***** ***** ****** ***, ******, tx - 75063

(C): 469-***-****

( ********@*****.***

Summary

Solutions-focused project lead with experience leading project engagements

for major companies focused on software development and customization. 19+

years of experience in IT. Exceptionally adept at systems analysis and

design, ETL, file processing, Unix Shell Scripting and Datawarehouse..

Worked in systems processing large volumes of data. Skilled in fine tuning

PL/SQL, SQL, query optimization. PMP certified. Worked in Agile Scrum

environment. U.S Citizen.

Computer Skills

Applications: JDA Space Planning Module, JDA Merchandising System

Retek Merchandising System,

MS Project, VISIO, Powerpoint, Business

Objects XI, Unica Affinium

Campaign Tool, MQ, Broker

Languages: PRO*C, PL/SQL, PowerBuilder, C, C++, HTML, ASP, UNIX Shell

Scripting, UNIFACE, UML, Java

(Beginner), Oracle Financials

Databases: Oracle 11G, Netezza, Oracle 10G, Oracle 9i

Tools: SQL Loader, Explain Plan, ERWIN,

Toad, SQL Developer

Systems: Windows, Unix

Data warehousing Tools: Sagent, Informatica

Professional Experience

ADT Security Systems, Irving, TX

Contract Oracle Database Developer, IFS

Sep'2012 Till Date

In an Agile environment, develop and support IFS Releases

. Re-architected the complete process that handled Commissions pay-outs to

sales reps. Reduced 5000 lines of PL/SQL code to a few hundred lines by

modularizing and eliminating redundancy.

. Fine tuned the Commissions process and reduced the execution time from 15

minutes to 18 seconds

. Designed more efficient ways for creating data extracts from OLTP data

thru a 3 step pre-processing, data validation and extraction

. Developed shell scripts, cron jobs, Oracle stored procedures and packages

to process data efficiently from different data sources and feed

different platforms like AS400, Unix, Windows.

. Developed stored procedure, package and Shell script to feed potential

sale opportunities to SALESFORCE.COM thru CRON jobs

. Developed lookup procedures to provide faster lookup on site information.

Look up time improved greatly from 2 minutes to 10 seconds

. Designed and developed procedures to be invoked by MQ and the procedures

returned data to MQ as ref cursors

. Developed process using PL/SQL collection objects to assign Price Classes

to customers to facilitate Rate Escalation

. Provided mentorship and guidance to junior team members on writing better

queries and Shell scripts

. Provided accurate sizing and burn down information for Scrum

Epsilon, Irving, TX

Database Developer, Strategic Database Marketing Division

2009 - Sep'2012

Team of 20, maintain and enhance the Database Marketing Application for a

major client

. Develop Unix Shell Scripts, Oracle PL/SQL packages and stored procedures

for ETL processing of data files from multiple data sources

. Used SQL*Loader to load files into staging tables and invoked Oracle

stored procedures to perform data transformation, validation and loading

into final Oracle tables

. Develop shell scripts to read data files and load them into staging

tables for processing using Netezza

. Design and develop processes using shell scripts in Linux/Unix to extract

suppression information from OLTP system on Oracle and load them into the

de-normalized data warehouse tables in Netezza

. Develop reports in accordance to client requirements

. Support ad-hoc requests by writing code in PL/SQL and Shell scripting

. Provide on-call support

. Prepare technical design documents and program specifications for coding

. Develop test cases and perform unit and system testing

Michaels Arts & Crafts, Irving, TX

Leading Arts & Crafts retailer

Senior Application Systems Analyst, Information Systems Division

2006 - 2009

Team of 6, maintain and enhance the newly implemented JDA Space Planning

System for creation of plan-o-grams

. Reduced time and cost of Financial Planning system by developing module

for systemic update. Led a team of 3 developers for this project.

Interacted with users to gather business requirements, prepared project

plans using MS Project, functional and technical documents in VISIO,

monitored the progress of project, prepared test plans and cases and

coordinated user acceptance testing.

. Actively involved in design, planning, testing and implementation of

Phase 3 of Space Planning Module:

o Managed an external vendor JDA, making sure that the requirements

were being clearly understood and the deliverables met within

established timeframes. Established and communicated exception

handling methodologies to the vendor.

o Manage all aspects of peer verifications and quality assurance

testing before execution..

o Conduct post-project analysis and distribute information to cross-

functional groups.

o Develop PL/SQL packages and programs in Oracle 10G, batch programs

in Unix Shell Scripting.

. Troubleshot issues relating to plan-o-grams in the Space Planning and

Retek systems.

. Communicated system issues to programmers and provided guidance to

solving those.

. Improved performance and efficiency of the system handed over by JDA by

re-designing portions of the software

. Create business analysis technical documentation such as design specs and

flowcharts.

. Reduced store labor hours by 1,040,000 saving $10,400,000 annually, by

developing a system called Advanced Shipment Notice. This involved

developing packages and procedures in Oracle 9i with Shell Scripting for

batch processing. It enabled stores to receive based on cartons instead

of scanning individual SKUs. Did system testing, integrated testing with

store systems and coordinated user acceptance testing.

. Developed interfaces for feeding the Oracle Financial system

. Used CHAMPS (Michaels' application change control board) to submit change

requests, assign tasks and track task completion

Footstar, New Jersey, NJ

Leading footwear retailer

Programmer Analyst, Information Systems Division 2000 - 2005

Team of 6, maintained and enhanced JDA Merchandising System using Oracle on

Unix, Windows XP, Uniface for tracking sales and inventory and for senior

management reporting.

. Received Best Performer Award in 2001 for timely delivery and support of

JDA software, by mapping newly acquired company to Footstar hierarchies,

to integrate their products.

. Received Employee of Month Award for outstanding performance in rolling

out software for ShoeZone which was new line of business for Footstar,

ensuring Sales Registers were fully available from first day of Go-Live

and supporting business during month-end close.

. Designed new Sales Audit system and led team of Programmers for Athletic

Division JDA migration project. Design specifications required no

modifications, ensuring user satisfaction.

. Modified JDA system to handle 53 Merchandise Weeks in JDA which provided

business with accurate reports for TY/LY (This Year/Last Year) sales and

in feeds to Planning Module.

. Provided business analysis, design and development enabling PowerBuilder

Application to process manual transactions in JDA, greatly reducing

processing time, and ensuring data integrity and accuracy by elimination

of manual intervention

. Developed PL/SQL Programs, Reports, UNIX Batch Jobs, PRO*C Programs and

PowerBuilder applications, including changing MCA (the Data Warehouse

portion of JDA) back-end software to handle On Hand Inventory.

Drugstore.Com, Seattle, Washington

Online pharmaceutical sales

Consultant, Data Warehouse Team 1999 - 2000

Developed data warehouse software to provide tracking reports for online

pharmaceutical purchases.

. Used Sagent, Informatica Datawarehouse tools, ERD, ASP and VB Script for

developing and enhancing the software.

Citibank N.A., India

Project Manager, Technology Division 1999 - 1999

Led team of 6 Programmers developing credit cards software applications

with 1.6 million customer base.

. Led team in launch of new Diners Club International credit card.

Ramco Systems Ltd., India

Division of Ramco Group, diversified industrial conglomerate.

Systems Analyst 1997 - 1998

Performed analysis of software requirements, preparation of design

documents, test plans, and test cases, coding, testing, support and defect

fixing for accounts payable module

. Carried out Performance Tuning of sub-modules to improve responsiveness

and reliability.

Citibank N.A., India

Project Manager, Technology Division 1995 - 1997

Managed team of 10 programmers, and performed analysis of software

requirements, preparation of functional and design specifications, testing,

support for mutual funds system.

Computech, India

Systems Analyst 1994 - 1995

Analyzed software requirements, prepared design documents, coded, and

implemented enhancements to sale order processing system.

Education

MBA, Bharathiar University, Coimbatore, India

Bachelor of Engineering, PSG College of Technology, Coimbatore, India

CERTIFICATION

Certified Project Management Professional

Contact this candidate