OBJECTIVE:

ETL developer in a Challenging Environment.

PROFESSIONAL SUMMARY:

• Over 7 yearsof total experience in IT including 5+ years of professional experience in system analysis, design and development, testing and implementing of soft applications using IBM DataStage 8.5/8.1/8.0.1/7.x/6.x/5.x (InfoSphere, WebSphere, Ascential DataStage).
• 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 & OLTP/OLAP technology and Data Migration.
• Extensively worked on IBM DataStage Components like DataStage Designer, DataStage Manager, DataStage Director, DataStage Administrator and Parallel Extender.
• Expertise in developing SQL scripts and creating tables, triggers, functions and procedures.
• Expert in working on various operating systems like UNIX and Windows and extensive experience in UNIX Shell Scripting.
• Experienced in tuning Oracle Database & DataStage environments and Proficient in creating containers, triggers, routines, functions and custom transformations.
• Experienced in using Enterprise and Plugin stages in reading data from Oracle, DB2, Teradata and SQL Server databases.
• Strong knowledge of data warehouse architecture and designing star schema, snowflake schema, Fact and Dimensional Tables, Physical and Logical Data modeling using Erwin.
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogate key assignment and CDC (Change Data Capture).
• Experienced with legacy systems and good understanding of SQL,Object-Oriented technologies.
• Good experience in writing Unix shell scripts and proven track record in troubleshooting of Datastage jobs and addressing production issues.
• Interacted with business users to analyze the business requirements and provide technical solutions
• Having excellent track record as a strong team player with effective communication, analytical and multi-tasking skills, resourceful, result driven and self-motivated.
• 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.

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005/2008

Operating Systems: Windows Server 2008/2003/2000, Windows Vista, Windows XP Windows 7.0, Mac OS, Linux (Red Hat), UNIX, AIX, SOLARIS.

Tools: TOAD, Oracle SQL Developer, SQL Loader, Oracle Data Modeler, Oracle Designer, SQL Server Profiler, Query Analyzer, Visual Studio, Adobe Dreamweaver, Adobe Photoshop

Languages: SQL, C, HTML,XML

Applications: Microsoft office 2003/2007/2010

EDUCATION

• Bachelors of Technology

Project Summary:

Confidential, Orlando, FL May 2011- Sep 2012 DataStage Developer
FedEx Corporation, originally known as FDX Corporation, is a logistics services company based in the United States. The goal of the project was to build and maintain an Active Enterprise Data Warehouse (AEDW) that handles data from internal system, vendor source file and outbound feed.

• Migrated from 8.1 to 8.5 which were 40 percent faster in opening a job, running a job and runtime performance also improved.
• Created the logical models and generated the physical models in the databases using Erwin data modeling tool.
• Analyzed the various sources and designed and developed DataStage jobs for extracting data from different databases such as SQL Server, IBM DB2 mainframe, Teradata, flat/CSV files and sequential files.
• Used DataStage Designer for developing various jobs for Cleansing, Transforming, Integrating and Loading data into the data marts.
• Designed parallel jobs using stages like Aggregator, Transformer, Filter, Funnel, Modify, lookup, join, merge, surrogate key generator and remove duplicates etc.
• Developed shell scripts which can be used to load data from staging area.
• Developed user defined subroutines in BASIC to implement some of the complex transformations, date conversions, code validations and calculations using different DataStage supplied functions.
• Developed jobs in Quality Stage to standardize the data and used Info Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
• Using shard containers created reusable components for local and shared use in the ETL process.
• Analyzed data with discrepancies through error files and log files for further data processing and cleansing.
• Extensively used Autosys for automated scheduling of UNIX shell script jobs on daily, weekly monthly basis with proper dependencies.
• Worked on performance tuning and enhancement of DataStage job transformations

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

Confidential, Melville, NY May 2010 -Mar 2011
DataStage Developer
Capital One is a diversified bank that offers a broad array of financial products and services to consumers, small businesses and commercial clients. The bank\'s initial goal is to build the capability to better analyze the bank\'s accounts. Business users want the ability to slice and dice individual accounts, as well as residential household groupings to which they belong. The project is about integrating accounts information from heterogeneous source systems and loading it into centralized data warehouse.
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.
• Used shell for automating job execution.

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

Confidential,Salt Lake City, UT July 2009-Mar 2010
ETL Developer
The requirement of this project was to develop a data mart for the Health sciences claims division by consolidating multiple data sources to generate reports.
Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Created the logical models and generated the physical models in the databases using Erwin data modeling tool.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Analyzed the given source dimensions and target fact table structures to develop surrogate key tables referencing required dimensions.
• Worked with DataStage RTI (Real-time Integrator) for converting XML data files from various sources into sequential files as well as loading into target databases.
• Using shared containers created reusable components for local and shared use in the ETL process.
• Imported and exported repositories across DataStage projects.
• Analyzed data with discrepancies through error files and log files for further data processing and cleansing.
• Worked on performance tuning and enhancement of DataStage job transformations.
• Used DataStage Director Runtime engine to schedule and execute developed jobs and job sequences. Used log events to monitor job progress and performance.
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walkthroughs among various teams and documenting the proceedings.

Environment Data Stage 7.5(Designer, Manager, Director), IBM DB2 Universal Database, Oracle 9i, XML, UNIX, Windows NT and ERwin 3.5.

Confidential, has implemented CEDP (Client Enterprise Data Hub) Project, for the movement of "business end of day" Client Profile data from various source systems (KD/CAM, PATH and SFDC) into a designated staging area.
Responsibilities:

• Involved in system analysis and design of Enterprise Data Warehouse (EDW)
• Staged data to Sybase database and moved data from Sybase to Oracle data warehouse.
• Used Both Pipeline Parallelism and Partitioning Parallelism for improving performance.
• Used lookup stage with reference to Oracle table for insert/update strategy and for updating Slowly Changing Dimensions (SCD). Involved in meetings relating to the business issues in investment industry. Also, have the knowledge of investments sector. Performance tuning of the ETL process and performed the data warehouse testing.
• Developed jobs in Parallel Extender using different stages like Transformation, Aggregation, Source dataset, External filter, Row generation, Column generation and Vector stage.
• Implemented CRC-32 data stage function for change data capture.
• Obtained detailed understanding of Data sources, Flat files and Complex Data Schemas.
• Used DataStage as an ETL tool to extract data from sources systems and aggregate the data and load into the Oracle database.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Extensively used Data stage Director for Job Scheduling, emailing production support for troubleshooting from LOG files.
• Implemented profile stage for source data analysis and data profiling.
• Extensively worked on Error handling, Cleansing of data, Creating Hash files and performing lookups for faster access of data.
• Designed XML stages for reading XML log files for capturing data stage jobs audit data.
• Extensively used DRS, Merge, remove duplicates, IPC stages.
• Reduced the response time by aggregating the data, data conversion and cleansing large chunks of data in the process of transformation.
• Extensively worked with Quality stage to standardize data by trimming the spaces, removing nonprinting characters, incorrect spellings using transfer, parse, collapse, select, unijoin and build stages.
• Used Quality Stage to developed jobs which involved converting the variable length record to fixed length records, parsing the fields to single domain data fields, identifying the most commonly used pattern for each field, selection of subset of records, standardizing the data by converting each field into a most commonly used format.
• Implemented Profile stage for profiling source DB2 AS/400 system.
• Developed jobs to identify the null values, incorrect spellings, and invalid data using the Select stage.
• Knowledge of Eagle PACE.
• Implemented meta stage for impact analysis, process analysis and data lineage
• Used Version Control for Datastage to track the changes made to the Datastage project components and for protecting jobs by making read only.

Environment: Ascential DataStage 7.5/EE/PX (Enterprise Edition/Parallel Extender), Sybase, Meta Stage, Profile Stage, Quality Stage, People Soft Applications, AS/400 DB2 V5R4, Oracle 9i/8i, SQL Server 2000, PL/SQL, SQL*Loader, Eagle PACE, UNIX Shell Scripting (Korn /KSH), SQL*plus, Business Objects 6.5

Confidential,Bangalore, India Aug 2007-July 2008
The project was to transform the data coming from various sources through multiple stages before being loaded into the data warehouse and maintenance.
Responsibilities:

• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source. Mainly involved in ETL developing.
• Defined and implemented approaches to load and extract data from database using Datastage.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Executed jobs through sequencer for better performance and easy maintenance.
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer.
• Involved in unit, performance and integration testing of Data Stage jobs.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Involved in performance tuning of the jobs.

Confidential,Hyderabad, India Jul 2006- Jun 2007
Employee Management System (EMS)
SQL Developer
The objective of this project is to automate the process of employee management within the organization.
Responsibilities:

• Involved in Business requirement analysis, detailed Design Reviews and discussions.
• Translating user requirements into data flow diagrams and ER-diagrams.
• Creation of Tables with table and column level constraints, views, synonyms and Sequences.
• Involved in coding and testing of the system.
• Coding of SQL procedures, functions, packages and database triggers to implement business logic. Unix Shell scripting & Batch processing. Data Porting from Legacy applications to this application using SQL*Loader.
• Designed various automated batch process and manual batch process for user-friendly interface using SQL Scripts.
• Unit testing & Migrating to Production.

Confidential,Bangalore, India Apr 2005-Jun 2006
SQL Developer
Videocon International Pvt. Limited engages in the manufacture, assembly, marketing, and distribution of consumer electronic products and home appliances in India. Financial Accounting System consists of data entry module for Master, Parameter and Daily transaction entry routine (i.e. Supplier, Customer, General ledger, Profit/Cost Center, Cash/bank transaction, Sales related data, Purchase related entry). Developed databases to provide the entire information about the material availability, order details, invoices and catalog information.

Responsibilities:

• System study, interaction with users and management, performance of analysis, designing, coding, and testing and implementation of the system.
• Extensively involved in Coding PL/SQL, Packages, Procedures, Functions and Database Objects according to Business rules.
• Designed and implemented number of Data Entry Forms using Developer 2000. Various management reports like Cash Flow statement, Cash/Bank statement, Account statement, Balance sheet, Sales/Purchase register.
• Designed and prepared specifications and did module level testing using over 45 forms (Forms 4.5), 40 reports (Reports 2.5), 35 stored procedures and database triggers for company's reconciliation.

Environment: Oracle 7.3/8i, Sybase, SQL, PL/SQL, Developer/2000(Forms 4.5, Reports 2.5) and Sun Solaris/Windows-NT.