SUMMARY

• 7 years of experience as DataStage ETL developer for data management applications including Design, Development, Testing, and Implementation of ETL processes
• Excellent experience using IBM InfoSphere DataStage 8.1/7.x Designer, Director, Information Server Manager and Administrator components
• Experience in Domains such as Insurance, Healthcare, Finance and Retail.
• Worked extensively on large Enterprise Data Warehouse (EDW), Operational Data Store (ODS) and DataMarts for data integration including data loading, transformation, migration, and cleansing
• Proficient in using DataStage Enterprise Edition, developing Parallel & Server jobs
• Proficient in working with Oracle, Access, SQL Server, Teradata and DB2 Databases
• Strong communication skills for interaction with business users in understanding requirements and providing most efficient business intelligence deliverables in areas of Data Warehousing, Data Migration, Reporting and Architecture
• Skilled in documenting requirements including functional and technical (both high level and detailed), translating user requirements to technical specification
• Developed scripts using UNIX Shell scripts to automate the process of scheduled ETL jobs, and loading, pushing and pulling of data from & to different servers
• Worked as on - call person for production support and also responsible for executing and monitoring weekend database jobs including data migration, data summarization, data purge, and updating statistics
• Technical expertise in all phases of Software Development Life Cycle (SDLC)
• Good knowledge of Data Modeling and Dimensional Modeling techniques, proficiency in design and implementation of Star and Snowflake schemas using ERWIN
• Highly organized, detail-oriented professional with strong Technical and Communication skills.

TECHNICAL SKILLS

• IBM InfoSphere DataStage 8x/7x
• Information Analyzer
• Business Objects XI R2
• Oracle 10g/9i/8.x/7.x
• DB2 9.x/8.x/7.x
• Teradata
• SQL Server 2008/2005/2000 and MS-Access
• TOAD
• UNIX
• AIX
• Linux
• Windows 9x/NT/Win2000
• Mainframe DB2
• AS400
• SQL
• PL/SQL
• C
• C++
• JAVA and Visual Basic
• UNIX Shell Scripting
• HTML
• SQL*Loader
• Erwin 4.0
• Visio.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Sr. DataStage Consultant

Responsibilities:

• Actively participated in the Team meetings to gather the business requirements and developing the specifications.
• Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading
• Worked extensively with Designer, Director, Manager, Administrator components of IBM InfoSphere DataStage to extract, cleanse, transform, integrate and load data to operational data store and Data Warehouse
• Extracted data from various sources performed Data transformations and loaded into the target database.
• Extensively worked with various stages of Parallel Extender like Sequential file, Dataset, lookup, peek, transformer, Merge, Aggregator, row generator, surrogate key generator and many more to design jobs and load the data in to Fact and Dimension tables
• Worked extensively on various partitioning and collecting methods like Hash, Entire, Same and Round Robin
• Developed data joins and lookups using Join and Lookup stages
• Developed user-defined Transforms, Routines, Stage Variables and Stored Procedures.
• Used local and shared containers to increase object code reusability and to increase throughput of the system.
• Developed job sequences with restart ability check points, and implemented proper failure actions.
• Designed complex DataStage mappings between source to Operational staging targets
• Developed interfaces using UNIX Shell scripts to automate the process of loading, pushing and pulling data from & to different servers
• Worked as a on-call person for production support
• Implemented various performance tuning techniques with available DataStage stages and user defined routines
• Involved in the UAT of various data warehouse processes and responsible for generating reports for developers, involved in the development of those processes
• Involved in analyzing scope of application, defining relationship within and between groups of data, star schema and snow flake schema and analysis of present schema and data model
• Utilizing specialized expertise in areas of very large Database Management, Dimensional Data Modeling, Metadata Management and Third Party Information Delivery Tool Sets
• Participated in the review of Technical, Business Transformation Requirements Documentation.

Confidential, Milwaukee, WI

DataStage Developer

Responsibilities:

• Participated in discussions with Team leader, Group Members and Technical Manager regarding any Technical and Business Requirement issues.
• Worked extensively with Designer, Director, Administrator components of IBM WebSphere DataStage to extract, cleanse, transform, integrate and load legacy data to data warehouse and various data marts
• Extensively worked with various stages of Parallel Extender like Sequential file, Dataset, lookup, peek, transformer, Merge, Aggregator, row generator, surrogate key generator and many more to design jobs and load the data in to Fact and Dimension tables
• Developed job sequences by identifying independent and dependent flows with proper rollback strategies incorporated in the sequences.
• Wrote shell scripts to generate custom built reports and e-mails for detailed job logs from production environment to different developers with out having access production environment. It facilitated effective communication between developers to monitor various production processes
• Used Data Warehouse techniques like Star-Schema, snowflake schema based on the environment.
• Created jobs using DataStage Designer and used Datastage Director to validate schedule run and monitor the DataStage jobs.
• Metadata was stored in the repository and is imported using the DataStage Manager.
• Worked extensively with Business Objects to generate reports for testing and implementation purpose
• Worked closely with architects and DBAs in understanding the underlying databases to create most effective ETL processes to increase efficiency and facilitated the use of appropriate stages/components in Datastage depending on the type and volume of data that is being processed
• Involved in the UAT of various data warehouse processes and responsible for generating reports for developers involved in the development of those processes
• Involved in debugging of various ETL processes for problem resolutions and performance enhancement

Confidential, Falls Church, VA

DataStage Developer

Responsibilities:

• Actively participated in collecting enterprise module design requirements and discussions
• Worked with various sources such as Oracle DB, Access mdb, Flat files to extract data and used IBM WebSphere DataStage to load the data into Data Warehouse built on Teradata.
• Designed various ETL procedures for getting the data from operational systems in to Data Warehousing system.
• Used the designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Developed various jobs using DataStage stages like ODBC, Hashed file, Aggregator, Sequential file, transformer
• Used the director for scheduling, validating, running and monitoring the jobs
• Used administrator for creating projects and managing the users
• Performed automation of file manipulation and for different procedures involving data cleansing Using Shell scripts
• Utilized SQL *Loader to load bulk data into target data warehouse
• Implemented performance-tuning techniques along various stages of the ETL process

Confidential, Irvine, CA

DataStage Developer

Responsibilities:

• Involved in various phases of the Data warehousing life cycle - logical and physical design, ETL process, performance tuning, and maintenance.
• Actively participated in collecting enterprise module design requirements and discussions
• Designed various Parallel and Server jobs based on the business logics that run daily, weekly and monthly basis.
• Developed various jobs using DataStage stages like ODBC, Hashed file, Aggregator, Sequential file.
• Created shared containers to use in multiple jobs.
• Used manager for importing metadata into repository and also used for importing and exporting jobs into different projects
• Designed and implemented Star schema and Snow flake Schema by using data modeling tool Erwin.
• Used the designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Used the director for scheduling, validating, running and monitoring the jobs
• Used administrator for creating projects and managing the users
• Used almost all stages like sequential file, hash file, OCI9i, ODBC stage etc. and also extensively involved in creating custom routines and transforms
• Performed automation of file manipulation and for different procedures involving data cleansing Using Shell scripts
• Utilized SQL *Loader to load bulk data into target data warehouse
• Implementing performance-tuning techniques along various stages of the ETL process

Confidential, Milwaukee, WI

DataWarehouse Developer

Responsibilities:

• Actively involved in interacting with the users, identifying the requirements, design, development, testing and implementation of various modules
• Involved in creation of stored procedures, functions and packages
• Created dimension tables and fact tables based on the warehouse design
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer.
• Designed and developed various Pl/Sql scripts to meet the business requirements.
• Used Erwin for data modeling
• Created PL/SQL packages, triggers and SQL scripts
• Used DataStage Director to run and monitor the jobs for performance statistics.