Executive Summary
Programmer/Analyst/Tech Lead with over fourteen years of experience in Programming, System Analysis, Database Design and Development. In these years I have worked on various fields like Enterprise Date Warehouse, Warehouse and Inventory Management systems, including Customer Orders and Returns, Sales and Distribution, Account Receivable, General Ledger and Invoicing Process. Also has over six years experience as ETL Lead with PL/SQL and INFORMATICA Power Center includes extensive design and development knowledge. I possess a very good understanding of logical and physical data modeling and creation of star schema for Enterprise Data Warehouse with multi-dimensional data modeling.

Education
Master Degree in Computer Application

Technical Skills

• Operating System UNIX 11i, LINUX, Windows 2000/XP
• Languages INFORMATICA Power Center 6.1/7.1/8.5, METADATA REPORTER, Shell Scripts,

Perl, PL/SQL, SQLPLUS, SQL Loader, C, PRO*C

• RDBMS Oracle 8, Oracle 9i, Oracle 10g, SQL Server
• Tools SQL Navigator, TOAD, AQT, COMODO, ERWIN 4.0, AUTOSYS, Tidal, Cos Batch

Training

• Data Modeling/ Architecture training from TDWI.
• Certified Informatica 7.1 from Informatica Corporation.
• INOFORMATICA Power Center 6.1(Developer and Administrator)
• Certified PL/SQL from Oracle Corporation
• Software Development Training (C, UNIX, ORACLE)

Technical Profile

INFORMATICA (Power Center 6.1/7.1/8.5), ERWIN 4.0

PL/SQL, SQL PLUS, SQL Loader

Unix Shell Scripts, Perl Scripts, Batch Program

ORACLE 7/8/8i/9i/10g

SQL Server

Pro * C

SQL NAVIGATOR, TOAD, Rapid SQL, AQT

Work Experience
_________________________________________________________________________________________________________
Confidential, Plymouth, Minnesota
Data mart ETL Lead/ Senior ETL Developer May 2007 to Present
I analyzed, designed and implemented MEDICA Data warehouse, Data marts (member) and File Validation Process. Led the technical design meetings, wrote the standard and production support manual, helped/mentored INFORMATICA team members and responded to client’s business need. I worked extensively in file validation process from design to implementation. I was responsible for supporting the production environment and solving issues in the timely manner.

Confidential, Bloomington, Minnesota
Senior Data Analyst /ETL Lead November 2005 to April 2007
As a Senior Data Analyst I analyzed, designed and implemented ODS, Data marts, Data warehouse and operational databases. Led the technical design meetings, wrote the standards, helped/mentored INFORMATICA team members and responded to client’s business need. I worked in several data marts over one terabyte in size. I was responsible for supporting the production environment and solving issues in the timely manner.

Confidential, Bloomington, Minnesota
ETL Lead/Senior System Analyst July 2005 to October 2005
As an ETL Lead I analyzed, designed and implemented Data warehouse and operational databases. Led the technical design meetings, and responded to client’s business need. I was involved in data conversion from Legacy, Oracle and Mainframe system. I created source to target documents for ETL developers. Design dimensional mapping using Type1 logic. Wrote shell scripts and schedule them in APPWORX.I was involved in Rapid application and development project with AGILE principles. I was responsible for supporting the production environment with the Sarbanes-Oxley methodology.

Confidential, Inver Grove Heights, Minnesota
Data Architect/ETL Lead/Informatica Administrator/Developer Jan 2001 to Jun 2005
As a data architect I analyzed, designed and implemented Data mart and operational databases. Led the technical design meetings, and responded to client’s business need. I developed metadata maintenance model and standards. I am involved in data conversion from Legacy, Oracle and JDE system. I was responsible to create source to target documents for ETL developers. Installed, configured, and monitored Informatica Power Center 6.1/7.1 on Hp 11i UNIX operating system. I administered Development and Production repositories using Oracle 9i database. Develop and design Informatica process for their Financial, Sales and Retail Data Warehouse. Design dimension mapping using Type1, Type2 and Multi-day logic. Wrote shell scripts to manage source files and workflows. I wrote the mappings to bring the data from different sources such as JDE, Oracle Financials, Oracle databases and Flat files into the staging area. Tuned mappings, transformations and SQL query to gain optimum performance. I recommended coding and naming standards to the developer’s community. I worked with UNIX support to schedule all the scripts in AUTOSYS. We successfully migrated, Informatica power center 6.1 into 7.1. I was involved to Install Informatica Metadata reporter.

Confidential, Inver Grove Heights, Minnesota
Programmer Analyst/Billing Lead June 1998 to December 2000
I was responsible for the modification and enhancement of the various components of the Agronomy Computer Environment Distribution System (ACE). Components include Customer Orders and Returns, Shipping Orders, Inventory Adjustments, Shipping Notification, and Customer Invoicing Process. The Customer Invoicing Process will process all the shipping orders during that day, including specialized accounts involving discounts, etc. Uploaded data from Mainframe to Oracle tables through SQL Loader, prepared the test plan for testing customer invoicing, and wrote shell scripts to schedule the jobs for batch processing through AUTOSYS. I wrote programs to generate Invoices and Prepay Statements for the customers.

Confidential, Louisville, Kentucky
Programmer/Analyst/On-Site Coordinator May 1997 to May 1998
As a Programmer/Analyst/On-Site Coordinator, was responsible for client liaison, troubleshooting, analysis, coding, testing, and support. Responsible for designing and developing the Warehouse Management System Upgrade used to track warehouse activities. Included in the upgrade were the Consolidation and Batching of customer orders, counting of the Inventory and FedEx System Process, and the Interface programs between UNIX and MVS. I was responsible for performance tuning for faster processing.

Confidential, Mumbai, India
Programmer/Analyst February 1996 to April 1997
As a Programmer/Analyst, was responsible for analyzing, coding, and testing the Warehouse Management System. Tasks included Receipt Handling, Inventory Management, Customer Order Processing, Cycle Count, and Quality Control. Used Pro*C and C to modify existing code of Order Processing, Cycle Count, and Quality Control modules. I used CRONTAB Scheduler to schedule batch jobs. Used PL/SQL 3.0 to write stored procedures and packages, and for report writing.

Confidential, Bhubaneswar, India
Programmer Analyst March 1995 to September 1995
As a Programmer Analyst, was responsible for designing, developing, coding, and testing the Integrated Export Promotion & Marketing Information System. Used PL/SQL, Pro*C and C to write application code for rate contracts and decision making functions.