SUMMARY

• Seek a challenging work environment where professional growth and diverse technical platforms will challenge my expertise and keep teh learning process afresh, resulting in career growth.
• Highly technical professional wif over 7 years of experience analyzing, designing, and implementing Decision Support Systems (DSS). Possesses exceptional communication and liaison skills proven by TEMPeffective interaction wif management, subordinates, and business partners.
• Around 6 years of experience in Data warehousing using ETL tool Datastage 9.1/8.7/8.5/8.0.1/7. x (Designer, Director and Administrator)
• Proficient in building staging environment, Operation Data Store (ODS), data warehouse and data marts. Integration of various data sources and automation of ETL processes and data cleansing using Quality Stage
• A strong knowledge of data warehousing concepts and Dimensional Modeling. Experience in teh life cycle of data warehouse design, development and implementation and Experience in designing and implementing ETL solutions.
• In depth experience in working wif user community .Good mentoring & devising training documentation
• Ability to handle multiple tasks and changing priorities while working wif a high degree of accuracy
• Strong skills and Extensive hands on experience using SQL, PL/SQL, various Database utilities including DB2 Autoloader, SQL Loader
• Introduced development process practices for code migration, testing, and overall development lifecycle. Automated routine tasks and streamlined procedures to improve productivity.
• Designed and developed parameters - driven multi-instance DataStage programs and UNIX functions to perform source files validation and verification rules, data cleansing, data integration, and complex business rules.Datastage container modules were used to implement validation rules dat ranged from simple primary key validations to complex threshold acceptance rules.
• Performed benchmarking analysis and performance tuning of ETL processes; implemented code updates to achieve disk space and processing time savings.

TECHNICAL SKILLS

Data Warehousing: IBM DataStage 9.1/8.7/8.5/8.18.0.1/7.5 (Manager, Designer, Director, Administrator), OLAP, OLTP, SQL*Plus, Toad 9.0

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer

Databases: Oracle 11g/10i/9i, PL/SQL, UDB DB2, Sybase SQL Server 11.0, MS Access 7.0/97/2000, Excel

UNIX Tools: Shell Scripting, Bourne Shell, AWK, VI, SED

Languages: HTML, SQL, PL/SQL

Environment: Windows NT 4.0/2000/XP/2007, Sun Solaris, AIX, Win 95/98/3.1, MS DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, Peoria, IL

Sr. Datastage Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Involved in creating High and Low Level Architectural Design Documents which Are used across teh Project.
• Performed Unit Testing on teh Jobs developed by creating test files based on test cases.
• Used Datastage Designer to design and develop jobs to cleanse, extract, transform, integrate and load data into facets from various Sources.
• Involved in creating batch architecture script which captures all teh Audit job details like Job Name, Record Counts, and Job Status, Source and Target Table names, Job Start and End time etc., for all teh Datastage jobs.
• Created Datastage Parallel jobs to generate Complex Flat Files like Fixed Width Multiple Record Type Files and CSV Files.
• Developed Parallel jobs using Stages, which includes Transformer, Sort, Join, Merge, Lookup, Filter, Pivot, Aggregator, Funnel, Change Data Capture, Column Export, Column Import, etc.
• Extensively used Row Generator and Column Generator stages to create test data and Peek Stage for debugging purpose.
• Developed jobs to read XML files as source and load it into table.
• Extensively used different Sequencer Stages like Job Activity, Sequencer, Execute Command, Nested Condition, Notification Activity, Routine Activity, User Variable Activity, and wait for File Activity, Start Loop Activity, End Loop Activity, and Terminator Activity.
• Developed user defined Routines using Universe Basic to capture teh job details and Scripts using Power Shell Scripting to Split teh Complex Flat Files based on Date and Theatre Number.
• Created and Used Several Parameter sets in Data Stage jobs and worked extensively on Creating Data stage XML Jobs.
• Import and Export developed and executable ETL job components to maintain Production backup and version Control.
• Involved in teh preparation of detailed design documents, Technical Application Design documents and Mapping documents and Unit test cases documents for Data stage jobs.

Environment: IBM WebSphere Data Stage 9.1/8.7/8.5 (Designer, Director, Manager, Administrator), Windows 2007, XML, Oracle 11g, 10g,10i, SQL Server 2005, SQL, Shell Scripting.

Confidential, Metawa, IL

ETL Datastage Developer

Responsibilities:

• Used teh Data Stage Designer to develop processes for extracting, cleansing,
• Transforming,Integrating, and loading data into data warehouse database.
• Analyzed teh performance of teh jobs, project and enhance teh performance using standardTechniques.
• Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify,Compare, Oracle Enterprise, Surrogate Key, Aggregator, Transformer, Decode, Row GeneratorStages.
• Extensively worked wif Join, Look up (Normal and Sparse) and Merge stages.
• Extensively used teh CDC (Change Data Capture) stage to implement teh slowly changingDimensional.
• Migrated projects from 8.5 to 8.7
• Extensively worked wif sequential file, dataset, file set and look up file set stages.
• Used teh Data Stage Director for testing and debugging its components and monitoring teh results.
• Extensively worked wif Job sequence stage such as Job Activity, Email Notification andSequencer Wait for File activities to control and execute teh Data stage Parallel jobs.
• Created PL/SQL Procedures, Functions on Database tables before loading to check some
• Validations.
• Providing effort estimates depending on teh design complexity.
• Writing PL/SQL scripts for logging teh E2E (End to End) events for Data stage jobs.
• Creating server and parallel jobs using Data stage Designer to perform teh ETL operations.
• Worked on loading of data from several flat files sources using Teradata MLOAD.
• Transfer of large volumes of data using Teradata Fast Export, Multi Load, and T-Pump.
• Maintaining and coordinate wif off shore team. Migrated jobs from development to QA toProduction environments.
• Defined UNIX -shell scripts for file watcher and file archiving process.
• Developed complex queries using different data providers in teh same report.
• Extensively developed Data stage server routines using Data stage Basic Language as part of theDevelopment process.
• Performed Unit testing and Integration testing in testing environment

Environment: IBM Info Sphere Data Stage 8.7/8.5 Quality stage, Oracle 11g, UNIX, SFTP, MSOffice Suite, Erwin, MS Visio, PL/SQL, SQL Server, Toad, flat files.

Confidential, Grand Rapids, MI

Datastage Developer

Responsibilities:

• Responsible for understanding of business rules and standards and act accordingly.
• Involved in identifying teh business rules for developing Data Warehouse.
• Involved in data modeling activities using ERWIN.
• Involved in architectural design and sharing of thoughts.
• Creation of physical data model by Reverse Engineering.
• Generated DDL scripts to deploy teh model to a database.
• Comparing teh objects in teh database and to generate DDL script.
• Working wif DBA to monitor teh data stage server performance.
• Develop ETL source data to teh standard values and format teh data warehouse.
• Designing of different jobs using teh data stage designer for extracting, transformingand loading teh data into data marts.
• Working on how to import some data stage jobs and run in teh tool.
• Designing teh shared container jobs for reusing it.
• Creating teh data flows in teh design studio by considering various stages andconnectors.
• Working on different stages like LOOK UP, JOIN, FUNNEL, FILTER, and ROW GENERATOR, COLUMN GENERATOR, SLOWLY CHANGING DIMENSION, And REMOVE DUPLICATES.
• Developing some sequence jobs to extract and load jobs on schedule basis.
• Writing SQL scripts, Shell Scripts for delta processing and to trigger an event.
• Involved in unit testing and system integration testing.
• Working wif reporting team for generating reports and developing of user Interface dashboards.

Environment: IBM Info sphere Data Stage 8.1(administrator, designer and director),IBM info sphere warehouse 9.7, windows XP, ERWIN, WebSphere AdministrationConsole, MS Visio, Auto-Sys.

Confidential, Newark, NJ

Datastage Developer

Responsibilities:

• Followed all teh CMM Quality process.
• Data Analysis, to study teh data base data dat is required for teh different source
• System.
• Data model review wif teh client, coz teh model was given by teh client.
• Erwin was used to create teh Logical and physical data model
• Involved in understanding teh scope of application, which was already implemented,
• And for new development.
• Involved in teh Architecture review.
• Involved in teh high level design (ETL design Plan) & low level design (Mapping
• Docs).
• Used DataStage designer to create mappings to load various dimensions dat include
• Products, Product Categories, Coverage Type, Coverage Level, and Risk Level
• Dimensions.
• Involved in Creating Jobs, Hash files, sort, and transformer, Lookups, Run, and
• Monitor Using teh Data Stage director.
• Used XML Input stage for teh extracting teh data and XML transformer to load teh
• Data to teh staging area.
• Used Version Control to backup teh source code.
• QualityStage was used to standardize/integrate teh data from different sources.
• Reviewing teh Report design and improving teh query for teh performance.
• Used teh Broadcast agent to broadcast teh report.
• Used Control M for scheduling teh jobs.
• Unit testing of teh Jobs developed.
• Use Quality stage to Standardize match and correct teh data.
• Coordinating wif all onsite technical professionals and Project Manager.

Environment: Data Stage 7.x, HP UNIX, Oracle 9i, Control M

Confidential

Software Developer

Responsibilities:

• Installed teh database and overseen teh implementation of users and security of teh Application’s database.
• Set teh environment of teh client database using teh export files.
• Involved in requirement analysis and design documentation.
• Designed and developed database tables necessary along wif teh necessary Constraints to enforce business rules.
• Created and modified several Database Triggers, especially for Audit and Security Purposes.
• Developed teh Stored Procedures, Packages, and Cursors and involved in teh Performance tuning of PL/SQL.
• Developed packages for various financial analyses.
• Performed several imports on teh same database instance.
• Resolved several hardcore business rules and issues at teh client site.
• Developed several Complex Reports for various requirements using to increase teh Functionality and usability.
• Designed PL/SQL libraries for various multi-functional usages.
• Involved in production support for teh client.
• Corrected teh major form bugs, errors through client and end user interaction.

Environment: Oracle8, PL/SQL, SQL, Designer 2000, Oracle Import, Developer 2000, Windows 2000/NT, UNIX.