PROFESSIONAL SUMMARY:

• I am having 8+ years of experience in System Analysis, design, development and implementation of Relational Database(Oracle, DB2 9.5, SQL Server and Teradata) and Data Warehousing Systems using IBM Information Server DataStage 11.3/8.7/8.1/7.x (Information Analyzer, DataStage Designer, Director, Administrator ).
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema methodologies to develop data marts.
• Excellent knowledge in Data quality assessment (DQA) methodology like Missing data, default values, Spelling errors, data in wrong fields and (Different or inconsistent standards) in structure, format and values.
• Excellent knowledge in IBM WebSphere DataStage ETL jobs for extracting data from heterogeneous source system, transform and finally load into the target system.
• Excellent knowledge in DQ/ETL development, DW lifecycle, Exposure in OLAP tools and highly experienced in Designing and Development of Mappings using DataStage Designer /Quality Stage.
• Excellent knowledge in IBM WebSphere Information Analyzer 8.x function dependencies like Column Analysis, Primary Key Analysis, Foreign Key Analysis, cross domain Analysis and Baseline Analysis.
• Excellent knowledge in Implementing Functional rules and Business rules by using Information Analyzer Development tool (Audit Stage and Data Quality).
• Experience in Tuning Jobs process identifying and resolve performance in Parallel Jobs and Sequential Jobs.
• Good Experience with DataStage connectivity PACK for SAP R/3, Salesforce and Siebel.
• Experience in monitor the DataStage server for paging, memory usage, CPU usage, network usage, storage usage and shared memory segments by using netstat, vmstat, topas, df, lsof, prstat and ipcs commands.
• Performance tuning of ETL applications using configuration file tuning in areas involving processes such as I/O, scratch space optimization, sort, lookup, join and memory configuration.
• Involved in Unit Test Case, Integration Test, User Acceptance Test (UAT), Load Test and System Testing preparation and testing of the applications.
• Experience in Level L3 DataStage Developer support and troubleshooting problems in the production environment.
• Strong Processing Experience in Tivoli1.3, DS JobSequence, Autosys and Crontab for Scheduling the ETL Jobs.
• Generated statistical & analytical report for user management by using ONEREViEW and Business Objects tools.
• Creating DML scripts for Database Operational Management and Monitoring database activities.
• Expertise in writing UNIX Shell Scripts, Stored Procedures, Packages, Functions, Triggers and other database objects.
• Expertise in Erwin, Toad, SQL Navigator, Clear Case, Clear Quest, Test Directory and PVCS.
• Good Exposure in Telecom, Insurance, Banking and Financial Services domains.
• A versatile, determined & extremely self - motivated individual who thrives on meeting tight deadlines and is comfortable in a pressurized environment.

TECHNICAL SKILLS:

Operating System: WINDOWS 98/2000/NT/XP, IBM-AIX 5.3, HP UX, Linux.7.1/7.2/8.

Language: SQL, PL/SQL, C, C++, JAVA, MQSeries, JCL, Shell(bash,ksh), HTML, COBOL, Control -M & Perl Scripts.

RDBMS: ORACLE 8i/9i/10g/11, DB2/AIX64 8.2.3/9.5.3, Sybase, MS SQL Server, Teradata.

ETL Tools: IBM InfoSphere Information Server (DataStage, Information Analyzer and

Data Model Tools: ERWin 4.1, Microsoft Visio.

OLAP tools: Business Objects, Cognos

Database Tools: Toad 7.6/9/10g, AQT 8.1, PL/SQL Developer, DB2 Load Utility, SQL * Loader.

GUI: D2K, Visual Basic 6.0, Power Builder 5/6.5/7.

Version Control Tools: SharePoint, Rational Clear Case, Datastage Version, CVS, Test Directory, PVCS.

Scheduling: Tivoli Workload Scheduler, Job sequencer, Crontab, AutoSys, Informatica workflow

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Sr. Datastage Developer.

Responsibilities:

• Designed the ETL jobs using IBM Infosphere DataStage 11.3/8.7 to Extract, Transform and load the data into staging, ODS and EDW.
• Involved with Business users and ETL Leads from different teams to implementETL Frame WorkusingData Stage Parallel jobs and migration of data from various sources.
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture (CDC), Modify, Row Generator and Aggregator.
• Responsible for full lifecycle of IBM Infosphere Change Data Capture and Change Data Delivery, including installation, support and upgrades. We have both version 8.7 and 11.3
• Responsible for generation of DDL statements, which are executed, for database creation.
• Responsible for preparing Physical/logical data models.
• Responsible for data analysis, requirements gathering, report analysis, source-to-target mapping, frequency analysis, process flow diagrams, and documentation.
• Extracted data from various sources likeOracle Database, Flat Files, CSV filesand loaded to target warehouse.
• Handled Performance Tuning of Jobs to ensure faster Data Loads.
• Performed the Integration and System testing on the ETL jobs.
• Assist with migrations of both CDD/CDC .
• Analyse the PROD data in case of discrepancies if any, to get the defect/bug fixed.
• IBM Tivoli scheduler to schedule and load the Job batches.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata).
• Created Shell scriptsfor scheduling the Data stage jobs using wrappers.
• Involved in preparing test cases and Reporting bugs in the design / configuration and fixing
• Defined strategy for the Installation and configuration of the new environment.
• Installation of Information Server Patches for Service, Engine and Client Tiers.
• Involved in preparation of scripts and their deployment in Development and System Test environments.
• Extensively worked on scripts to schedule jobs to run from Tivoli Scheduler.
• Extensively used Basic Teradata Query Utility (BTEQ) for executes SQL commands.

Environment: IBM Web Sphere DataStage 11.3/8.7,Citrix, UNIX Shell Script,Teradata 14.00,SQL,ORACLE, IBM Tivoli,Job sequencer, Crontab, SVN.

Confidential, Houston, TX

Sr. Datastage Developer.

Responsibilities:

• Participate in Project scoping activities and Understanding requirements as per the Client Business Logic’s.
• Done Analysis on Column Analysis, Primary Key Analysis, Foreign Key Analysis and cross domain Analysis) and Baseline Analysis using IBM WebSphere Information Analyzer function dependencies.
• Implementing Functional rules and Business rules by using Data Quality development.
• Excellent knowledge in Publishing Analysis Results and Generating Analysis Reports as per Business Requirement by using Information Analyzer Development tool.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source system, transform and finally load into the Data Warehouse.
• Participated in the meeting with the Business Users, Support Analyst and OLAP for getting the more information and understanding of the Applications.
• Demonstrated the design and document conversion and system interface specifications.
• Reviewed the Development work which was done by the offshore team and resolved concerns and given the guidelines in the Development work.
• Conducted a Review session with the Offshore Team for Consistency, readability and appropriateness on ETL jobs.
• Monitor the DataStage server for paging, memory usage, CPU usage, network usage, storage usage and shared memory segments.
• Coordinated with the IT team to provide the necessary support to the DataStage environment.
• Maintained a backup of the DataStage in case of emergency.
• Edited dsenv file and .profile file for suitable use of data-stage command line based interfaces. Provided advisory to other teams working on DataStage.
• Extensively handled slowly changing dimension (SCD) and created the parameter sets in the IBM WebSphere Data stage Designer and made use of these in the Data stage jobs.
• Involved in development of UNIX shell scripts for Batch jobs etc to run the Jobs.
• Prepared test docs which involved preparation of test data, test case and unit testing of the jobs.
• Extensively used lookup, history processing and transformations.
• Experience on Performance Tuning.

Environment: IBM InfoSphere Information Server 8.0.1/8.1.2, Citrix, UNIX Shell Script, DB2 Load Utility, SQL, ORACLE, Db2 9.5.3, Mainframe, Business Objects Xi, IBM AIX 5.3, Windows XP/Windows 2000, Web OLAP, Job sequencer, Crontab, SCP, Telnet, Erwin 4.3, Rational Clear Case, Quest, Datastage Version, PVCS, CVS and SED&AWK Aps

Confidential

ETL Developer

Responsibilities:

• Involved in understanding Business Process and coordinated with Business Analysts to get specific user requirements to build the Data Marts.
• Modeled the Star Schema Data Marts by identifying the Facts and Dimensions using Erwin Data modeling tool. Created policy, premium and claim data marts.
• Designed and developed the DataStage server as well as parallel jobs for extracting, cleansing, transforming, integrating, and loading data using DataStage Designer.
• Used the DataStage Director to schedule and monitor the running jobs.
• Extensively developed ETL code using DataStage parallel edition utilizing Sequential files, Join, Merge, Lookup Stage, Aggregator, Row generator, Dataset, Funnel Stage, Remove Duplicate Stage, Copy Stage, Change Data Capture and Column generator.
• Used several stages like Sequential file, Hashed File, Aggregator, Funnel, Change capture, Transformer, Merge, Join, Lookup, Complex Flat File stages during the development process of the DataStage jobs.
• Used Slowly Changing Dimension stage for Implementing Type-1,Type-2 Slowly Changing Dimension.
• Used Shared Containers for reusability and reducing job complexity.
• Redesigned and modified existing program logic to improve overall system performance.
• Analyzed data with discrepancies through Error files and Log files for further data processing and cleansing.
• Data received from files and transactional systems and then converted to DB2 database using Data stage Client tools.
• Maintained a backup of the DataStage in case of emergency.
• Edited dsenv file and .profile file for suitable use of data-stage command line based interfaces. Provided advisory to other teams working on DataStage.
• Involving in Performance Tuning Jobs process identifying and resolve performance Issues.
• Used Data Stage Director for running and monitoring & scheduling the jobs.
• Worked with Data Stage Manager for Export & Import Jobs and Importing the Metadata from repository.
• Used Business Objects for reviewing the front-end reports.
• Performed Unit Testing, System Testing, UAT Validation
• Performed with System integration testing using job sequence

Environment: Ascential Data Stage 7.5x2,IBM Information Server (DataStage, Information Analyzer) 8.1, Business Objects 6.5,Affirm, Onereview, oracle 8i/9i,DB2, IBM AIX, Windows XP, Tivoli, Shell Programming.

Confidential

Program Developer

Responsibilities:

• Created DDL and DML scripts for Database Operational Management.
• Creating PL/SQL Stored Procedures, Functions and Triggers.
• Created Validation SQL’s for QA.
• Created Packages, Object Types.
• Created Validation reports for Business.
• Tuning the PL/SQL code and SQL queries.
• Worked on Performance improvement on Database applications.
• Doing Unit Testing on Forms, PL/SQL Stored Procedures, Functions, Triggers and Packages.

Environment: oracle 8i/9i, Oracle Developer 2000(Forms-Reports),HP-Unix, Windows XP and Shell Programming