SUMMARY

• Over 7 years of IT experience with specialization in Data Warehousing, Decision support Systems and extensive experience in implementing Full Life cycle Data Warehousing Projects.
Strong ETL experience using Informatica PowerCenter 8.x/7.x/6.x/5.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations.
• Strong skills in IBM-Ascential DataStage 8.X 7.5/7.0/6.0(DataStage Enterprise Edition(PX)& Server Edition), SQL, PL/SQL, Stored Procedures and Triggers, Performed Debugging, Troubleshooting and performance tuning.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
• Developed complex mappings in Informatica & Datastage to load the data from various sources into the Data Warehouse, using different transformations/ Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup , Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
  Expertise in tuning existing mappings, identifying and resolving performance bottlenecks at various stages.
• Extensive experience in designing and developing jobs using DataStage Designer, Data Stage Manager, and DataStage Director.
• Thoroughly proficient in SQL and PL/SQL development in Oracle 8i/9i.
• Expertise in Data Modeling, Designing of Logical and Physical datamarts.
• Experienced in designing and writing on-demand UNIX shell scripts.
• Exceptional analytical and problem solving skills. Good team player with the ability to communicate effectively at all levels of the development process.

EDUCATION

Bachelor of Technology

TECHNCIAL SKILLS

ETL :Informatica 8.x/7.x/6.x/5.x ,DataStage 7.5.2/7.0/6.0 (Data stage Enterprise Edition & Server Edition)
Databases: Oracle 10g/9i/8i/7.x,Teradata, DB2 UDB 8.2/7.2/6.1, MS Access
Operating Systems: IBM AIX 5.2/5.1, SunOS 5.8, SuSe Linux V9.0, Windows XP/NT/2000/98
BI TOOLS : Siebel Analytics 7.x, Business Objects 5.x, 6.x, Cognos Impromptu 6.0/7.0/7.1, Cognos Power Play 6.0/7.0/7.1, and Crystal Reports 9.0.
Languages: C, C++, Visual Basic, SQL, PL/SQL, Pascal, FORTRAN and COBOL
Version Controls: Rational Clear Case, CVS and DataStage Version Control

WORK EXPERIENCE

Confidential, TX Nov ’08 – Till date
DataStage Developer

The REPORT initative’s objective was to provide a standardized means for transforming, calculating and reporting of the customer survey data received from various sources for client reporting purposes. This system will provide standardized reporting process for customer study data. The project objective was to integrate different departments/DB into the new specialty department DSS data repository. The integration effort was divided into a multiple phase approach.

Responsibilities :

• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Worked with Data Modeler and DBAs to build the data model and table structures.
• Actively participated in discussion sessions to design the ETL job flow.
• Compiled source to target mapping documents to design the ETL jobs.
• Prepared detail design documents which contain job designs and functionality of each job.
• Developed DataStage extract jobs using Oracle stages and load the data into a staging area in the form of flat files/Data Sets.
• Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.
• Worked extensively with Parallel Stages like Row Generator, Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages etc extensively.
• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Extensively used DataStage Sequences to place the jobs in sequence to achieve final goal.
• Used DataStage Director for scheduling the jobs, monitoring the running jobs, compiling the jobs and viewing the job logs.
• Created Unix Shell scripts to automate the data load processes to the target Data Warehouse.
• Developed SQL Scripts to validate the data after the loading process. Modified and tested PL/SQL stored procedures
• Coordinated tasks with onsite and offsite team members.
• Provided 24x7 production support. Trained end users on application.

Environment: IBM DataStage 7.5.3 and DataStage V8.0, Oracle 10g, SQL, PL/SQL, Unix, Windows XP.

Confidential, NJ Mar ’08 – Oct ‘08
DataStage Developer

The project involved the creation of the Sequence Data Warehouse. The data warehouse captures data from Prudential’s customers and transactions databases maintained under client/server architecture. The project on Data Warehouse involved developing a Data Warehouse system and OLAP tools and configuring the server and clients. The project also involved developing few data marts such as Assets, Portfolios etc. to serve the information needs. An OLAP interface is proposed which can be useful for managers in taking appropriate decisions.

Responsibilities:

• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Created Informatica mappings using the designer, respective workflows and worklets using the Workflow manager to extract, transform and load source data from various heterogeneous sources to the associated Facts and Dimensions
• Created cubes, dimensions, hierarchies, mappings and complex mapplets using Informatica PowerCenter designer
• Stored reformatted data form relational, flat file, XML files using Informatica (ETL).
• Consolidated variant feeds with different formats to fields with a specific delimiter using shell.
• Loaded consolidated data using SQL*Loader.
• Performed Event Based Scheduling to trigger a session using indicator files created by shell scripts.
• Developed various UNIX shell scripts for data scrubbing while weekly or monthly loads are in progress.
• Mentored mainframe personnel in using Informatica and Teradata tools.

Environment: Informatica Power Center 8.1/7.1, Teradata, Oracle 9i, MS SQL Server, SQL, PL/SQL, Toad, SQL*Loader, UNIX, Windows 2000/NT.

Confidential, NY Jan ’07 – Mar ‘08
DW Developer

The Data Warehousing development for Guardian involves a development of Data Mart which will feed downstream reports, development of User Access Tool using which users can create ad-hoc reports, and run queries to analyze data in the proposed Cube. The current project replicated the functionality incorporated in the Underwriting Measures Cube, but with daily update, a more robust architecture, and enhanced reliability.

• Aided in the design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system.
• Involved in Design and development of Data Marts for specific Business aspects which include Policy, Claim, Enterprise Billing and eQuote .
• Worked with Business Users and designed report layouts
• Developed and implemented ETL (Extract, Transform and Loading) Components based on the filter rules to obtain needed data from different source systems for calculating required metrics using Informatica Power center, UNIX, PL/SQL.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Worked extensively with mappings usingexpressions, aggregators, routers, lookupandproceduresto develop and feed Data Mart.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Modified and tested PL/SQL stored procedures.
• Developed UNIX Korn shell scripts to load the flat files from the source system into the tables in staging area.

Environment: Informatica Power Center 6.1/5.1 (ETL), Oracle 9i, DB2/UDB, UNIX AIX, Unix Shell Scripting, PL/SQL, SQL, PVCS, TOAD, ERWIN

Confidential, NY Nov ’05 – Dec ‘06
Data Warehouse Developer/Analyst

The Wall Street Channel manages aspects of the sourcing and pricing of Bulk and mini-bulk Acquisitions. The Operations group manages the file transfers, processing and funding of the loans to be purchased. There are currently three channels of business that source and purchase bulk and mini-bulk acquisitions, Citi Home Equity (CHE), Citi Financial Mortgage Company (CFMC), and Citi mortgage (CMI). Each channel currently has their own set of products and processes. This project will encompass multiple business units and result in a heightened need for a central data repository. The discrete practices and multiple data storage locations/systems utilized today result in less than adequate reporting and analysis.

Responsibilities :

• Assisted in gathering business requirement from end users.
• Coordinated tasks with onsite and offshore team members in India.
• Developed Shared Containers for reusability in all the jobs for several projects.
• Used stages like Transformer, sequential, Oracle, and Hash for Lookup, Aggregator, Folder,
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
• Involved in creating different projects parameters using Administrator.
• Used Datastage Director for running, monitoring and scheduling the Jobs.
• Used Audit Sequence Jobs to run Each and Every DataStage job which generates Audit key which will be used in Audit purpose.
• Familiar with import/export of DataStage Components (Jobs, DSRoutines, DSTransforms, Table Definitions etc.) between DataStage Projects, use of DataSet Management (DSM) utility and multiple job compile utility with use of Data Stage Manager.
• Used Shared container for simplifying design and easy maintenance purpose.
• Experienced in fine tuning, Trouble shooting, bug fixing, defect analysis and testing of DataStage Jobs.
• Used Unix shell scripts to invoke DataStage jobs from command line.
• Involved in Unit testing, Functional testing and Integration testing. Designed the Target Schema definition and Extraction, Transformation and Loading (ETL) using Datastage.
• Developed SQL queries to performed DDL, DML, and DCL.

Environment: IBM WebSphere DataStage EE/7.0/6.0 (Manager, Designer, Director, Administrator), Ascential ProfileStage 6.0, Ascential QualityStage 6.0, Erwin, TOAD, Autosys, Oracle 9i, PL/SQL, SQL, Unix Shell Scripts, Sun Solaris, Windows 2000.

Confidential, India Apr ’04 – Oct ‘05
Database Developer/Analyst

The aim of the project is to gather a great deal of medical data related to its members and participating independent medical facilities. The data came from several of its databases as flat files, the task, however, was to integrate the data into an Apollo database to provide a single vision and single platform that enables healthcare providers to analyze and use the information to improve healthcare services they provide.

Rsponsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Responsible for extracting, transforming and loading data Using UTL_FILE, SQL LOADER.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Involved in writing Unix Shell Scripts.
• Responsible for Unit level testing, Module level testing and Application testing.

Environment: Oracle 9i, UNIX Shell Scripting, SQL Loader, PL/SQL, TOAD, Windows 2000, UNIX.

Confidential, India Aug ’02 – Mar ‘04
Database Developer

FT’s data is obtained from different operational sources and is transformed and loaded into CDW (Centralized Data Warehouse) for various strategic business reports. The main focus was to keep track of the investments and keeps a check of the flow of money by monitoring the quality of marketing in the project.

Responsibilities:

• Participated in all aspects of the software development Life cycle, design the solution, present for design review, develop code, perform unit/integration testing and support the product by serving as the top-tier customer support.
• Responsible for writing PL/SQL packages, procedures, functions and triggers.
• Improved application performance by tuning SQL statements and fixing proper indexes, Designed data models.
• Involved in writing Unix Shell Scripts.
• Responsible for extracting, transforming and loading data Using UTL_FILE, SQL LOADER.
• Responsible for writing test plans and testing procedures.

Environment: Oracle 8i, Erwin, UNIX Shell Scripts, PL/SQL, TOAD, Windows 2000, UNIX.