SUMMARY:

• Around 9 yearsof total experience in IT including 6+ 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).
• Experience in using Informatica PowerCenter (7.1.3/8.6.1 )
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• 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.

TECHNICAL SKILLS:

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, PL/SQL, C, HTML,XML

Applications: Microsoft office 2003/2007/2010

PROFESSIONAL SUMMARY:

Confidential, Nashville, TN

Sr. ETL Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Used Quality Stage to check the data quality of the source system prior to ETL process
• 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.
• Used DataStage Designer for developing various jobs for Cleansing, Transforming, Integrating and Loading data into the data marts.
• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• 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.
• 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.
• Using shard containers created reusable components for local and shared use in the ETL process.
• Extensively used Autosys for automated scheduling of UNIX shell script jobs on daily, weekly monthly basis with proper dependencies.
• 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.
• Worked on performance tuning and enhancement of DataStage job transformations.

Environment: IBM DataStage 8.0.1,9.1,11.3, IBM AIX, Windows 7, Oracle 11g/10g, SQL*Loader, SQL Plus, TOAD, MS Visio, MS Access, MS Office, DB2, Shell, XML files, CSV files, Sequential files, UNIX, LINUX

Confidential, West Des Moines, IA

ETL Developer

Responsibilities:

• Migrated from 8.1 to 8.5 which were 40 percent faster in opening a job, running a job and runtime performance also improved.
• 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.
• High proficiency in developing Oracle PL/SQL packages
• Tested and debugged Oracle PL/SQL packages
• Built database objects like Tables and Views
• Designed parallel jobs using stages like Aggregator, Transformer, Filter, Funnel, Modify, lookup, join, merge, surrogate key generator and remove duplicates etc.
• Excellent expertise in Shell and Unix scripting
• 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, Windows 7, Oracle 11g/10g, SQL*Loader, SQL Plus, Teradata, TOAD,MS Visio, MS Access, MS Office, DB2, Shell, XML files, CSV files, Sequential files, Solaris UNIX, Windows NT, LINUX

Confidential, Orlando, FL

ETL Developer

Responsibilities:

• 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.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in different Scheduling tools like AutoSys for automating and scheduling jobs run.
• 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

DataStage Developer

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.3 (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

ETL Developer

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

ETL Developer

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.

Environment: Datastage (Designer, Director), Oracle, SQL, Windows.

Confidential

 SQL Developer

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.

Environment: Oracle, SQL, UNIX shell scripts, Windows NT.