SUMMARY

• Around 10 years of IT experience with special emphasis on Development, Administration, Analysis and Design of ETL methodologies in all the phases of the Data Warehousing life cycle with knowledge in ETL, DSS and Data warehousing & OLAP technology.
• Experience in IBM InfoSphere Information Server 8.x/9.x (Data Stage, Quality Stage, Information Services director and Information Analyzer) using components such as DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator.
• Used Quality Stage for standardizing and improving the quality of the data.
• Developed Data stage jobs using the stages including Standardize, Investigate, Match Frequency and Survive.
• Experience in Migration of mappings and transformations from one environment to another.
• Work within the Information Systems environment to re - engineer processes to minimize support issues.
• Identified the areas where to improve efficiency in Data Extraction Process.
• Performed administration tasks like role setup, connectivity, security, configuration of projects, user registries, create or update users and groups, mapping credentials, configuring DSN and TNS entries, parallel, compiler, reporting, operator and user-defined environment variables.
• Specialization in project management, design, development and deployment of batch and real-time solutions for Data Integration, Data Warehouse, Data Mart, BI (Business Intelligence), Web sphere Information Services Director (WISD) and MDM (Master Data Management) applications utilizing IBM Web sphere DataStage, Quality Stage and Information Analyzer.
• Strong skills in performing Column Analysis, Column Analysis Review, Table Analysis, Table Analysis Review, Primary Key Analysis, Primary Key Review, Cross Table Analysis, Relationship Analysis and Review, Removing redundant domains, Accept Relations, Normalization, Generating specification using Profile Stage.
• Experience in Database Design and Modeling and Software development Life Cycle (SDLC).
• Expertise in writing UNIX shell scripts and SQL queries
• Used Autosys & Control-M Scheduling tool to Schedule the jobs.
• Prepared discussion diagrams, process diagrams, to explain and support business and IT management decision making.
• Designed and Customized data models for Data Warehouse supporting data from multiple sources with Erwin.
• In depth knowledge of Dimensional Data Modeling, Star Schema & Snowflake.
• Create ETL processes to ensure data integrity (Error Handling) and document appropriate procedures.
• Strong experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages
• Expert in maintaining Metadata at the database level using a combination of DS PX jobs
• Expertise in Integration of various data sources like DB2, Oracle 9x/8.x/7.x, SQL Server, MS Access, Teradata, and Sybase
• Strong analytical, organizational, presentation and problem solving skills, as well as excellent inter-personal and communication skills.
• Responsible for Preparation of Design Documents / Test Case Specifications / Performance Review and Coding and getting it signed off from client.
• Worked on production support, attending calls, troubleshooting the application and resolving bugs.
• Team player with excellent communication and problem solving skills in resolving production issues without crossing SLA.
• Willing to adapt to new environment and learn new technologies.

TECHNICAL SKILLS

ETL/Reporting Tools: DataStage 8.x/9.x IBM Info Sphere Information Server (Information Services director, Fast Track, Quality, Profile, Audit and Data Stage)

Database Tools: TOAD, SQL Builder, IBM DB2 Command Editor

Reporting Tools: SSRS, Crystal Reports

Operating Systems: UNIX (AIX, SOLARIS, HP-UX), Linux, MS-DOS, Windows 9x/NT/2K, Visual Basic 6.0

Methodologies: E-R Modeling, Dimensional Modeling

Database: SQL Server 6.5, Oracle8i, Oracle 9i,DB2, Teradata

Platforms: Windows 9X/NT/2000/XP, UNIX AIX 5.0/4.3/4.0(Sun Solaris 7.1) & SUSE Linux

Design Tools: Erwin 4.1

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

DataStage Developer

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Implemented dimensional model (logical and physical) in the existing architecture using Erwin.
• Studied the PL/SQL code developed to relate the source and target mappings.
• Helped in the preparation of mapping document for source to target.
• Worked with Datastage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, 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.
• Used QualityStage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• 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.
• Used Autosys job scheduler for automating the monthly regular run of DW cycle in both production and UAT environments.
• Verified the Cognos Report by extracting data from the Staging Database using PL/SQL queries.
• Wrote Configuration files for Performance in production environment.
• Participated in weekly status meetings.

Environment: IBM DataStage 9.0 (Designer, Director, Manager, Parallel Extender), Oracle 10g,SQL Server 2008, Flat files, Sequential files, Autosys, TOAD 9.6, SQL*Plus, AIX UNIX, IBM Cognos 8.0

Confidential, Pleasanton, CA

ETL Designer/ DataStage Developer

Responsibilities:

• Data stage 8.5 was used to transform a variety of financial transaction files from different product platforms into standardized data.
• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
• Used Quality Stage to check the data quality of the source system prior to ETL process.
• Worked closely with DBA's to develop dimensional model using Erwin and created the physical model using Forward Engineering.
• Worked as Datastage Administrator for creating projects, defining the hierarchy of users and their access.
• Set up the projects, roles, users and privileges in different environments.
• Setting up job parameter defaults and environment variables.
• Defined granularity, aggregation and partition required at target database.
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the SQL Server database.
• Imported table/file definitions into the Datastage repository.
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign DataStage jobs for performing the required integration.
• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• Ensured that the data integration design aligns with the established information standards.
• Used 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.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment: DataStage 8.5 Enterprise Edition, Quality Stage, Flat files, Oracle9i, SQL Server -2005/2008, Erwin 4.1, PL/SQL, UNIX, Windows NT/XP

Confidential

Datastage Developer

Responsibilities:

• Implemented data mapping from source to target in view of the physical data models.
• Used the DataStage Designer to develop processes for Extracting, Cleansing, Transforming, Integrating, and Loading data into Data warehouse.
• Worked closely with DS Administrator to understand the roles and responsibilities and performed as back up admin.
• Requirement analysis and gathering to provide technical and architectural support to the team.
• Documented the Purpose of Mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Primarily involved in Job Design, Technical Reviews and Troubleshooting of jobs. Extensively involved in different Team review meetings and conferences with remote team.
• Developed various Server and Parallel jobs using Oracle, ODBC, FTP, Peek, Aggregator, Filter, Funnel, Copy, Hash File, Change Capture, Merge, Look up, Join, Sort, Merge, Lookup stages.
• Developed PL/SQL Procedures, Functions, Packages, Triggers, Normal and Materialized Views.
• Worked with Reporting team for extensively reporting using Data mart for Slice & Dice, Drill Down and Drill through.
• Defect Tracking, unit testing, defect reporting, analyzing results and documentation.

Environment: DataStage 8.1, Oracle 8i, SQL, Informix, PL/SQL, Shell Scripts, Erwin, UNIX.

Confidential

Assistant System Engineer

Responsibilities:

• Used the DataStage Designer to develop processes for Extracting, Cleansing, Transforming, Integrating, and Loading data into Data warehouse.
• Requirement analysis and gathering to provide technical and architectural support to the team.
• Documented the Purpose of Mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Primarily involved in Job Design, Technical Reviews and Troubleshooting of jobs. Extensively involved in different Team review meetings and conferences with remote team.
• Developed various Server and Parallel jobs using Oracle, ODBC, FTP, Peek, Aggregator, Filter, Funnel, Copy, Hash File, Change Capture, Merge, Look up, Join, Sort, Merge, Lookup stages.
• Developed PL/SQL Procedures, Functions, Packages, Triggers, Normal and Materialized Views.
• Worked with Reporting team for extensively reporting using Data mart for Slice & Dice, Drill Down and Drill through.
• Defect Tracking, unit testing, defect reporting, analyzing results and documentation.

Environment: DataStage 8.0, Oracle 8i, SQL, Informix, PL/SQL, Shell Scripts, Erwin, UNIX.

Confidential

System Engineer

Responsibilities:

• Getting requirements from the client to update database.
• Making changes in the SQL database, which involves querying like INSERT, UPDATE and DELETE options.
• Testing the changes every time before updating the database.
• Supporting the Weekly and Month end jobs.
• Developed Stored procedures to improve database efficiency.
• Testing each phase and reporting to client.
• Involved in preparing application documentations. I outlined the different processes of the application, and a list of the common problems encountered and how they can be solved using VB Scripts. This then was used during the support of the applications.
• Interacting with onsite on daily basis for status reporting on tickets raised by clients.
• Attending status report calls with clients every week to discuss about the issues involved in solving tickets.

Environment: VB 5.0, SQL server 6.5