SUMMARY

• About 8 years of total IT experience in the Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) using DataStage, QualityStage, Information Analyzer, Oracle, Teradata, DB2, Erwin and Unix.
• About 5 years of Programming experience in development and support of applications in various flavors of Unix/Linux using C/C++
• In - Depth knowledge in Data Warehousing & Business Intelligence concepts with emphasis on ETL Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling, physical and logical Data modeling using Erwin 4.2/4.1/3.x.
• Experience working with Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources. Worked with most of the parallel stages applying different partitioning techniques
• Excellent experience in using Stages like Complex Flat File, Dataset, Copy, Fileset, Oracle Enterprise, CDC,Join, Sequencer, Aggregator, Merge, Filter, Transformer, Lookup, Funnel, Compress etc.,
• Implemented slowly changing dimension SCD2 using change data capture stage.
• Extensive knowledge of data warehousing, business intelligence and ETL processing.
• Having good exposure to complete Software Development Life Cycle (SDLC), Business analysis to development, testing, Development and Documentation.
• Flexibility and adaptability in regards with new technologies and environments
• Experienced in executing shell scripts developed in UNIX.
• Performed Debugging, Troubleshooting and performance tuning of DataStage Jobs.
• Good understanding of Database Management Systems (Oracle, SQL Server).
• Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS

ETL: Web Sphere DataStage 8.X/7.X (Designer, Director, Manager, Administrator), Parallel Extender

Data Warehouse: Data marts, OLTP, OLAP, Normalization, Dimensional ModelingFacts,Dimensions, Star schema, Snow Flake Schema

Languages: SQL, PL/SQL,C,C++, Perl, Shell Script

Databases: DB2, Oracle 8i/9i,10g,11g SQL Server 2000, Teradata

Operating Systems: Windows NT/9X/2000/XP, UNIX, LINUX, MS-DOS

Oracle Tools: PL/SQL Developer, SQL*PLUS, SQL LOADER, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Tampa,FL

Sr.Datastage Developer

Responsibilities:

• Business requirements gathering.
• Converting functional requirements to detailed ETL technical designs (Low level design).
• Designing ETL jobs incorporating complex transform methodologies using DataStage tool resulting in development of efficient interfaces between source and target systems.
• Providing effort estimates depending on the design complexity.
• Writing UNIX scripts for running and validating the job.
• Writing PL/SQL scripts for logging the E2E(End to End) events for Datastage jobs.
• Creating server and parallel jobs using DataStage Designer to perform the ETL operations.
• Preparing the deployment packages for the code and checking in code to repository.
• Following up deployment process of DataStage code migration on different environments (development, test and production) with admin team.
• Co-coordinating with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.

Environment: IBM WebSphere DataStage Enterprise Edition 8.1, Oracle 10g, Maestro Scheduler scripts, AIX, PL/SQL, Webservices.

Confidential, Parsippany, NJ

Datastage Developer

Responsibilities:

• Involved in data Extraction and Transformation from source database and Loading to EDW(Enterprise Data Warehouse) with DataStage
• Worked closely with the Sales team and gathering the functional requirements and working with the project manager to give a high level design and the cost associated with the project
• Worked with datastage Designer and Director to design job to extract data from external files, tables.
• Developed jobs to aggregate the source data using Aggregator and handled duplicate records using Remove Duplicate stage
• Used Parallel Extender to create jobs using stages like Aggregation, Transformation, join, merge, surrogate key generator and vector stage etc.
• Involved in the Design, Development and Production support of Data Warehouse
• Worked closely with Clear Case for secure Import and Export of DataStage Jobs
• Designed DataStage jobs using the stages like ORAOCI, ODBC, Transformer, Join, Merge and Sort to populate and incrementally load the source data into Data Ware House tables
• Worked on the project from scratch that is from Mapping till the Exportation of the Developed Jobs to other environments SAT and PROD.
• Created jobs to produce unit test data using Row Generator, Column Generator, Sequential file and Dataset to perform UTP(unit test plan)
• Involved in design, planning andimplementation of test strategies.
• Created Stored Procedures for faster data extraction from databases
• Created data validation scripts to verify the loading process from source to ODS to DW
• Documented Source-Target mapping and Unit Test plans and scripts for the DS jobs.

Environment: IBM Websphere DataStage 8.0.1, Oracle 10g, ERwin, WinSQL, TOAD, SQL*Plus, SQL*Loader, UNIX Shell scripts,Autosys.

Confidential, Cleveland, OH

Datastage Developer

Responsibilities:

• Preparing technical design/specification for data extraction, Transformation and Loading and Data Cleansing.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database
• Created Jobs in ETL tool DataStage to populate the data files with lookup values. Used Sequential File stage, ODBC Stage, Hashed File stage and Transformer stage. Used constraints to get accurate values and to throw errors.
• Extensively used DataStage Parallel Extender (Orchestrate) and Integrity for creating and implementing jobs.
• Responsible for creating extract queries from oracle
• Wrote DataStage jobs using DataStage Designer and DataStage Manager and in depth experience in dealing with different stages (Hash, Ftp, Merge, Sort, Aggregator, Lookup)
• Used DataStage Manager to create many custom transforms and table definitions
• Responsible for creating DS job run scripts and scheduling them
• Published DataStage Meta data standards and definitions to end users for easy understanding of critical business data
• Performed Import and Export of DataStage components and table definitions using DataStage Manager
• Worked on database connections, SQL joins, views, aggregate conditions, parsing of objects and hierarchies
• To obtain better performance, tuned Data Stage jobs by creating Data Stage Hash files for staging the data and lookups.
• Worked on Production issues and User Acceptance issues pertaining to data from Source to target

Environment: Data Stage 7.5.2 (Designer, Director, Administrator, Manager, Parallel Extender), Oracle 9i, SQL, PL/SQL, SQL* Loader, Shell Scripts, ERWin, MS SQL Server 7.0, Business Objects 5.0, Windows NT/2000

Confidential, Kansas.

ETL Datastage Developer

Responsibilities:

• Analysis and design review of the existing and new system.
• Mapping and migrating legacy system data to new n-tier system.
• Design and development Confidential source system data and finally make the data available to satisfy the reporting and analytical requirements of the long distance entry effort.
• Designed ODS to quick operations on individual data.
• Loaded data into load, staging and lookup tables.
• Performance tuned DataStage to reduce batch run time.
• Designed the DataStage jobs to extract the data from Text files, transform the data according to the business requirements and load them into Oracle tables.
• Worked with Business Analysts to prepare ETL Mapping Documents.
• Extensively used Stage variables and Hash files.
• Wrote Oracle stored procedures and called the stored procedures in Data Stage.
• Create and enhance the existing process of the PL/SQL procedures and Packages.
• Extensively worked with Dimensional Data Modeling, Star and Snowflake Schema.
• Implemented Slowly Changing Dimensions and Surrogate keys for designing the Data Marts Closely worked with the System analyst and application development teams Implemented Best Practices of DataStage.

Environment: DataStage 7.5, Oracle and MS SQL Server 2005, UNIX and shell scripts, Erwin, SQL Loader.

Confidential, SFO, CA

ETL DataStage Developer.

Responsibilities:

• Involved in source system analysis & design of data warehouse and data mart.
• Extracted data from oracle database and populated data warehouse and data mart.
• Designed Business Rule Spread sheet document between source and target.
• Involved in identifying facts and dimensions.
• Involved in Design, Source to Target Mappings between sources to operational staging targets, using Star Schema.
• Wrote complex SQL queries and UNIX scripts for integrating the jobs.
• Improved the performance of the jobs and the SQL queries by passing appropriate hints.
• Built conversions Business Rules and Mapping documents by interacting with the Business Users.
• Used Both Pipeline Parallelism and Partition Parallelism for improving performance.
• Used shell scripts for running DataStage jobs.
• Implemented Shared and Local Containers for reusable code.
• Worked extensively with DataMarts like customer accounts and transactions.
• Used the Datastage Director and its run-time engine to schedule running the job, testing and debugging its components, and monitoring the resulting executable versions.
• Implemented Slowly Changing Dimensions and Surrogate key.
• Performed Unit Testing on the developed jobs to verify the given requirements.
• Used Best practices for easy job processing.

Environment: Datastage 7.x, Data Stage Version Control,Oracle 9i, Microsoft Visio Standard 2002, SQL, PL/SQL, UNIX and Shell Scripts.

Confidential

Senior Member - Technical Staff.

Responsibilities:

• Worked on enhancement and support of VES
• Played a vital role in the designing & developing Event logger, Database polling, Application load balancing, preforking using C++,mysql on Linux
• Involved in implementation of Compression of applications
• Worked on doing requisite modifications/enhancements for the existing installations and providing code patches using C++ on Linux.
• Worked on porting the existing application from Linux Fedora Core 2 to Open BSD and RHEL(64bit)
• Worked in unit and integration testing of VES
• Extensively worked in Design, Development and Product Support of High availability and Load balancing
• Wrote test cases and interacted with the QA team and simulated all the test conditions
• Training the Marketing and Customer support teams in the concepts and working of product

Environment: Linux Fedora core 4,NFS,Ultra monkey, C++, Shell Scripts, MySQL, Windows, VC++, HTML, XML, Jdk 1.4, PERL, Python, Apache, IPVS NAT MODE, VPN.,CGI,LDAP

Confidential

Technical Officer

Responsibilities:

• Involved in coding, customization and commissioning.
• Maintenance and customization of applications to user requirements
• Created test cases and running them simulating various testing conditions
• Was involved in commissioning of the system at various locations
• Training the system users
• Member of the AMSS Acceptance test team
• Installation and configuration of unix system and application

Environment: SCO-Unix 5.0.5,C,Shell Scripts, Unix IPC,COP B,X.25,LAN Communication, Serial Port communication,Remote Communication, Message Switching, Windows 2000,Visual Studio 6.0,Oracle,Sockets