PROFESSIONAL SUMMARY:

• Seek a challenging work environment where professional growth and diverse technical platforms will challenge my expertise and keep the learning process afresh, resulting in career growth.
• Highly technical professional with over 8 years of experience analyzing, designing, and implementing Decision Support Systems (DSS). Possesses exceptional communication and liaison skills proven by effective interaction with management, subordinates, and business partners.
• Around 7 years of experience in Data warehousing using ETL tool Datastage 11.3/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 the life cycle of data warehouse design, development and implementation and Experience in designing and implementing ETL solutions.
• In depth experience in working with user community. Good mentoring & devising training documentation
• Ability to handle multiple tasks and changing priorities while working with a high degree of accuracy
• Strong skills and Extensive hands on experience using SQL, PL/SQL, various Database utilities including DB2 Autoloader, SQL Loader, and NETTEZE
• 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 that 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 11.3/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, NETEZZA

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, Plano, TX

Sr. Infosphere Datastage Developer

Responsibilities:

• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using DataStage to populate tables in Data Warehouse and Data marts.
• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Proven track record in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
• Proficient in writing, implementation and testing of triggers, procedures and functions inOracle.
• Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioned and Link Collector.
• Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
• Coordinate with team members and administer all onsite work packages.
• Schedule and plan all DataStage tasks.

Environment: IBM Info Sphere DataStage 11.3, Quality stage, Oracle 11g, FTP, Windows 2007, XML, SQL developer

Confidential, Schaumburg, IL

Infosphere Datastage Developer

Responsibilities:

• Functioned on production support (24X7) on a rotation basis.
• Maintaining the end to end process.
• Designed and developed DataStage jobs to extract from legacy systems to Stage and from Stage to ODS and finally to EDW.
• Extensively worked on DataStage stages namely Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Extensively used DS Director for monitoring Job logs to resolve issues.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• DataStage as an ETL tool to extract data from sources systems, loaded the data into the Oracle 11g database.
• Aggregator stages to sum the key performance indicators used in decision support systems.
• Scheduled job runs using DataStage director, and used DataStage director for debugging and testing.
• Created shared containers to simplify job design
• Tools: Unix-MP RAS, Datastage 8.5, Ferret, Oracle 11g, Teradata V2R14.

Environment: IBM Info Sphere DataStage 8.7/8.5 Quality stage, Oracle 11g, PUTTY UNIX, SFTP, Windows 2007, XML, SQL Server 2005, SQL, Shell Scripting.

Confidential, Peoria, IL

Infosphere 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 the Project.
• Performed Unit Testing on the 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 the Audit job details like Job Name, Record Counts, and Job Status, Source and Target Table names, Job Start and End time etc., for all the Datastage jobs.
• DataStage as an ETL tool to extract data from sources systems, loaded the data into the NETEZZA 7.0 database
• 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.
• Created complex Stored Procedures, triggers, functions, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• 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 the job details and Scripts using Power Shell Scripting to Split the Complex Flat Files based on Date and Theatre Number.
• Created and Used Several Parameter sets in DataStage jobs and worked extensively on Creating DataStage XML Jobs.
• Import and Export developed and executable ETL job components to maintain
• Production backup and version Control.
• Involved in the preparation of detailed design documents, Technical Application Design documents and Mapping documents and Unit test cases documents for DataStage jobs.

Environment: IBM WebSphere DataStage 9.1/8.7/8.5 (Designer, Director, Manager, Administrator), Windows 2007, XML, NETEZZA 7.0, T-SQL Server 2005, SQL, Shell Scripting, PUTTY, UNIX.

Confidential, Metawa, IL

ETL Datastage Developer

Responsibilities:

• As a team leader I ensure my team always working on the highest priority of work.
• Ultimately responsible that the progress of work the team is undertaking is clearly visible both to the team and to our customers.
• Used the DataStage Designer to develop processes for extracting, cleansing, Transforming,Integrating, and loading data into data warehouse database.
• Analyzed the performance of the jobs, project and enhance the 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 with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively used the CDC (Change Data Capture) stage to implement the slowly changingDimensional.
• Migrated projects from 8.5 to 8.7
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Used the DataStage Director for testing and debugging its components and monitoring the results.
• Extensively worked with Job sequence stage such as Job Activity, Email Notification andSequencer Wait for File activities to control and execute the DataStage Parallel jobs.
• Created PL/SQL Procedures, Functions on Database tables before loading to check some
• Validations.
• Providing effort estimates depending on the design complexity.
• 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.
• 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 with 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 the same report.
• Extensively developed DataStage server routines using Datastage Basic Language as part of theDevelopment process.
• Performed Unit testing and Integration testing in testing environment

Environment: IBM Info Sphere DataStage 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 the business rules for developing Data Warehouse.
• Involved in data modeling activities using ERWIN.
• Involved in architectural design and sharing of thoughts.
• Developed Buildops for custom static requirements.
• Creation of physical data model by Reverse Engineering.
• Generated DDL scripts to deploy the model to a database.
• Comparing the objects in the database and to generate DDL script.
• Working with DBA to monitor the DataStage server performance.
• Develop ETL source data to the standard values and format the data warehouse.
• Designing of different jobs using the DataStage designer for extracting, transformingand loading the data into data marts.
• Working on how to import some DataStage jobs and run in the tool.
• Designing the shared container jobs for reusing it.
• Creating the data flows in the design studio by considering various stages andconnectors.
• The apache open server to replicate data from file stream.
• 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 with reporting team for generating reports and developing of user
• Interfacedashboards.

Environment: IBM Infosphere DataStage 8.1(administrator, designer and director),IBM info sphere warehouse 9.7, Apache/Tomcat web server, windows XP, ERWIN, WebSphere AdministrationConsole, MS Visio, Auto-Sys.

Confidential, Newark, NJ

Datastage Developer

Responsibilities:

• Followed all the CMM Quality process.
• Data Analysis, to study the data base data that is required for the different source System.
• Data model review with the client, because the model was given by the client.
• Erwin was used to create the Logical and physical data model
• Involved in understanding the scope of application, which was already implemented, And for new development.
• Involved in the Architecture review.
• Involved in the high level design (ETL design Plan) & low level design (Mapping Docs).
• Used DataStage designer to create mappings to load various dimensions that 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 the DataStage director.
• Used XML Input stage for the extracting the data and XML transformer to load the
• Data to the staging area.
• Used Version Control to backup the source code.
• QualityStage was used to standardize/integrate the data from different sources.
• Reviewing the Report design and improving the query for the performance.
• Used the Broadcast agent to broadcast the report.
• Used Control M for scheduling the jobs.
• Unit testing of the Jobs developed.
• Use Quality stage to Standardize match and correct the data.
• Coordinating with all onsite technical professionals and Project Manager.

Environment: DataStage 7.x, Confidential UNIX, Oracle 9i, Control M

Confidential

Software Developer

Responsibilities:

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