SUMMARY:

• Over 6 years of professional experience in system analysis, design and development, testing and implementing of software applications using IBM DataStage 8.5/8.0.1/7.5.2 (InfoSphere, WebSphere and Ascential DataStage).
• Implementing DataStage ETL best practices and methodologies.
• Expert in Data Warehousing concepts like Slowly Changing Dimension (SCD), surrogate key assignment and CDC (Change Data Capture).
• Technical expertise in Software Development Life Cycle (Analysis, Design, Implementation, Testing, and Debugging new and existing Client/Server based applications, Production Support) with knowledge in ETL, Data Warehousing technology and Data Migration.
• Strong knowledge of Relational Database Management Systems (RDBMS) concept in several databases like SQL Server 2008/2005 and Oracle 9i/8i.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Worked onUNIX ShellScripts for file deletion, job run, file processing, Initial Load, batch loads, Cleanup, Job scheduling and Reports.
• Worked closely with Business Analyst to understand business rules and developed DataStage Jobs.
• Expertise in ETL, Database Design and building Enterprise Data Warehouse/Data Marts using STAR schemas designs.
• Excellent knowledge of preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs and ensuring that milestones are met.
• Experience in Dimensional Data Modeling like Star Schema, Logical and Physical Design.
• Experience in performance tuning of SQL queries by providing hints, obtaining Explain Plan, Analyzing tables and adding indexes.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in integration of various data sources like Oracle, DB2, Teradata, SQL Server, Flat files and Complex Flat files into the Staging Area using DataStage Designer.
• Proficient in analyzing Business/ System Requirement documents
• Excellent Project Management, Time Management and People Management skills
• Excellent Interpersonal and Cross-functional skills, Strong Leadership and Motivational skills
• Effective verbal and written communication skills.
• Willing and able to adapt to new environments and learn new technologies quickly.

EDUCATION QUALIFICATION:

Masters in Information Technology Management
Bachelors in Technology of Computer Science

TECHNICAL SKILLS:

ETL Tools:

WebSphere 8.0 (DataStage, Information Server, QualityStage, Information Analyzer, Metadata Server), Ascential DataStage 8.5/8.1/7.5.2(Designer, Manager, Director, Administrator and Parallel Extender)

Operating Systems:

Windows 98/2000, 2003, Windows NT 4.0, HP-UX, Linux, AS400 and IBM AIX 4.0

Databases:

Oracle 10g/9i/8i , DB2 7.2 ,Teradata and SQL Server 2008/2005/2000

Tools:

Edit Plus, Putty

Languages:

SQL, Unix/LINUX shell programming and scripting, XML, XSLT, JAVA.

Database Tools:

SQL developer, Toad, SQL*Loader, Import, Export

Scheduling Tools:

Tivoli, Control-M, Autosys

EXPERIENCE

Confidential,Owings Mills, MD Feb 2012 - Till date

DataStage Developer

Confidential,is a regional leader in providing health care coverage and related services in the Mid-Atlantic region. The scope of the project was to implement a data warehouse that collects, organizes and stores data from different operational systems to provide a single source of integrated and historical data for the purpose of reporting, analysis and decision support.

Responsibilities:

• Interacted closely with business users to analyze the requirements and create mapping and transformation documents.
• Developed Teradata BTEQ to extract data from the source tables and load to the target tables.
• Used Oracle PL/SQL for writing stored procedures, packages for extracting the data.
• Created source table definitions in the DataStage repository and designed jobs for transforming and finally loading into data warehouse.
• Developed Parallel Jobs using Stages, which includes Aggregator, Join, Transformer, Sort, Merge, Filter, Lookup, Teradata Enterprise and OCI etc.
• Used QualityStage stages such as Investigate, Standardize, Match and Survive for data quality and data profiling issues during the designing.
• Created re-usable job parameter sets and Shared Containers for reusability of the code.
• Developed common UNIX shell scripts that can be used for calling DataStage sequencers just by passing sequencer name as the parameter.
• Created and executed Unit Test Plans and created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Used Performance Analyzer to improve the performance and Trouble-shoot the designed jobs using the Data Stage Debugger.
• Used Data Stage Director Runtime engine to schedule and execute developed jobs and job sequences, and log events to monitor job progress and performance.
• Developed various Reports for the end-user as per their requirements using Cognos.
• Created required technical documentation for deployment of code.

Environment:
IBM DataStage 8.0.1, Debugger, IBM AIX 5L, Windows XP, Oracle 10g/9i, SQL*Loader, SQL Plus, Teradata, TOAD, Cognos 8, MS Visio, MS Access, MS Office.

Confidential,Philadelphia, PA Feb 2010 –Oct 2011

DataStage Developer

Confidential,headquartered in Philadelphia is one of the region’s largest health insurers. IBC is an independent, local organization. IBC is also an independent licensee of the Blue Cross and Blue Shield Association. This structure allows it to offer their members the best of both worlds: a community focus paired with the stability of the most recognized and trusted health insurance brand and the strength of the nation’s most comprehensive health services network.

Responsibilities:

• Analyzed the transactional data model and data elements. Interacted with business analyst, SME (subject matter experts) on day-to-day basis to create technical specifications for data conversion programs.
• Involved in the Development, Implementation of the backend systems for the Database.
• Translated business processes into DataStage jobs for building Data marts.
• Worked with different Sources such as Oracle, DB2, MS SQL Server, MS Access and Excel, Flat files.
• Used DataStage Administrator to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Designed DataStage Jobs to extract data from XML files using XML input stage, Used XML transformer stage to cleanse and transform the data to load it into the Data Mart.
• Created source table definitions in the DataStage repository by studying the data sources.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects using DataStage Manager.
• Created Error files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Involved in troubleshooting the designed jobs using the DataStage debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Used the DataStage Director and its run-time engine to schedule and run the jobs, testing and debugging its components and monitoring the resulting executable versions on a scheduled basis.
• Created job sequences to control the flow of jobs.

Hardware/Software:
Ascential DataStage 7.5.2 (Designer, Manager, Director), Quality Stage, Oracle 10g, MS SQL Server 2005, MS Access, DB2, Crontab, XML files, CSV files, Sequential files, Solaris UNIX, Windows NT, LINUX.

Confidential,Mumbai, India July 2008 – Jan 2010

DataStage Developer

The MEASURE project caters the needs of Billing Administration department of All State Insurance to measure the performance of the Billing & Collections, Commissions and Policies departments. These departments are the vantage point for the decision makers. This project involves the maintenance of existing applications and adding new applications if their scope changes. The reports generated are critical to the business users in taking major decisions. The reports have visibility and are being accessed by the business users in day-to-day operations.

Responsibilities:

• Used Parallel Extender for partition parallelism, the same job would effectively will run simultaneously by several processing nodes, each handling separate subset of total data.
• Used DataStage Manager for importing metadata into repository and also used for importing and exporting jobs into different projects.
• Used the DataStage Designer to develop jobs for extracting, cleaning, transforming, integrating, and loading data into data warehouse database.
• Used Parallel Extender for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance.
• Extensively used DataStage XE Parallel Extender to perform processing of massive data volumes.
• Created stored procedures, functions using PL/SQL for implementing business rules and transformations.
• Prepared unit test, integration test, and performance test plan documents. Performed unit test, integration test, and performance test per the approved test plan, and documented test results.

Environment:
Ascential DataStage 7.5, Oracle 9i, SQL, PL/SQL, Erwin, Unix Shell Scripts, IBM AIX 5.1, Windows 2000, Autosys 4.5

Confidential,Hyderabad, India June 2006 – June 2008

Database Developer
Confidential,is a largest cellular provider of India in terms of customers. It also offers fixed line services and broadband services. It also acts as a carrier for national and international long distance communication services. The job involved to design, develop, enhance and retrieve data from the database for decision support system.

Hardware/Software:
MS SQL Server 2000, SQL, DTS, Erwin 3.5, Windows 2000

Responsibilities:

• Gathered functional requirements and written the technical specifications
• Installed and maintained MS SQL Server 2000.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Worked as a developer on MS SQL Server 2000.
• Developed complex SQL code for data retrieval.
• Responsible for backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for data retrieval by extensive use of multiple joins normalization and views.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, and other SQL joins and statements for applications.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Responsible for transferring the data from different servers using DTS packages.