SUMMARY

• Over 7 years of experience in design, development, implementation and production support of business applications with Data Warehouse/Data Mart Applications and Client/Server Applications on Windows and Unix platforms using ETL tool IBM Info Sphere DataStage(Enterprise Edition, Parallel Extender) 8.7/9.1, IBM Quality Stage 8.7/9.1, Ascential DataStage 7.5.x, Profile Stage 7.5.1.
• Expertise in interaction withusers and functional team for gathering the business requirements, functional specifications and estimation of efforts.
• Extensively used ETL methodology for Data Extraction, Transformation & Loading of ODS & EDW using Data Stage parallel jobs and sequences.
• Involved in Data Preparation, Data Analysis, Data Cleansing, Data Profiling and Data Modeling.
• Expertise with IBM Infosphere DataStage (Manager, Designer, Director, Administrator and Parallel Extender).
• Involved in several phases of SDLC (Software Development Life Cycle).
• Hands on experience on both Waterfall model &agile process of Software projects.
• Good knowledge in Data Warehousing concepts with emphasis on ETL and including Requirement, Analysis, Design, Development, Data Analysis, Data Migration, Data Integration, Testing, Implementation, Deployment and Support.
• Worked on derivations and business rules to be used by ETL for mapping source data for the population of the warehouse and data marts
• Experienced in Data cleansing and standardizing tools BODS, Quality Stage.
• Hands on experience in data modeling like Star schema, Snow flake schema, and dimension table design.
• Experience in Information Analyzer, Fast - track, Metadata Workbench and Infosphere Information Service Director.
• Hands on experience in Relational Databases Oracle 10g/9i, Teradata.
• Experience in most of the parallel stages Lookup, Join, Merge, Aggregator, CDC, Sort, Remove Duplicates, Funnel, Sort, Dataset, CFF and Databases connectors likeDB2, Oracle Connector, Netezza and Also used Pivot, XML etc and applying various partitioning techniques.
• Experience in most of the Sequence functionality like Loops, Execute Sequencer, User Variable Activity, Exception Handler, and Wait for file Activity etc.
• Experience in UNIX shell scripting.
• Experience in working with parallel extender for parallel processing to improve job performance while working with bulk data sources
• Experience in Debugging, Troubleshooting, Performance tuning, Analysis & Optimization of ETL jobs.
• Hands on experience to design the Datawarehouse7, created ER diagrams using Erwin
• Excellent communication skills with highly motivated individual and willing to adapt and take up new challenges.

TECHNICAL SKILLS

Operating Systems: Windows NT/XP, Unix/Linux, Sun Solaris, HP-UX

ETL/Middleware: Unix Shell Scripting, SQL Server, IBM WebSphere Data stage 8.1, IBM infosphere Datastage 7.5,8.5,8.7/9.1, Profile stage 7.5.1, IBM Quality Stage 8.7/9.1

Languages: Java, SQL, PL/SQL, UNIX Shell Script

Databases: Oracle 9i/10g/11g, DB2, Teradata, Netezza, Microsoft SQL Server

DB Tools: TOAD, SQL* Loader

PROFESSIONAL EXPERIENCE

Confidential, IL

Senior ETL/IBM Info sphere Data Stage Developer

Responsibilities:

• Interacted with business users for requirement gathering and analyzing the scope of the project.
• Design/modify the exiting ETS
• Created the Architecture & Design of the interfaces to the application.
• Created source-to-target mapping documents by working with business Analyst.
• Designed and developed DataStage (9.1) jobs and UNIX scripts.
• Performed ETL coding using Datasets, Sequential file, Transformer, Sort, Merge, Lookup, Remove duplicate stages compiled, debugged and tested.
• Used Infosphere DataStage designer tools for creating parallel jobs and importing and exporting the jobs.
• Controlled jobs execution using sequencer, used notification activity to send email alerts
• Played key role in design of scalable, reusable and low maintenance ETL templates
• Involved in building Audit process, Process Registration components s
• Created Technical design document, Migration Documents
• Creating Unit Test Plan Scenario
• Performed various performance tuning techniques.
• Coordinating with Team, Planning and scheduling activities
• Production Support and incidents handling s

Environment: IBM Infosphere Data Stage9.1, UNIX, Db2, Teradata

Confidential, CA

IBM Infosphere DataStage Specialist

Responsibilities:

• Interacted with business users regarding the agile methodology requirements and back logs of the previous sprints to analyze and design integration approach.
• Used Infosphere DataStage designer tools for creating parallel jobs and importing and exporting the jobs.
• Worked with business owner to understand business requirements in order to transform business requirements into TEMPeffective technology solutions.
• Performed column analysis, primary key analysis, and cross-domain analysis using Information Analyzer.
• Used Control-M job scheduler for automating the monthly regular run of DW cycle in both production and non-prod environments.
• Created Technical design document
• Created the data mappings and conversion logic to cleanse the data
• Worked as administrator and provided support on migration for all non-prod and prod env’s.
• Prepared documentation on provided support.

Environment: IBM Infosphere DataStage v8.5, Quality Stage, Information Analyzer, Oracle, Teradata, Control-M, UNIX, Team foundation

Confidential, NY

Sr. DataStage Developer

Responsibilities:

• Responsible for all BP2 Interfaces which get feed from SAP to SPODS and ODS to SVG interfaces which send data out to various downstream system from SPODS.
• Designed and built ETL jobs to load SP ODS data model in EDW.
• Development of ETL jobs to migrate bulk volume of data
• Worked with business owner to understand business requirements in order to transform business requirements into TEMPeffective technology solutions.
• Involved in Analysis, Development, Testing and Implementation of complex ETL jobs like SKU, SKU CUST, Price, and Cost.
• Worked on Unix script to implement different requirements s
• Worked on issues and provided fixes based on the priority.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Data stage Parallel jobs.

Environment: IBM Infosphere DataStage v8.5, Quality Stage, Information Analyzer, Oracle, Teradata, Control-M, UNIX, Team foundation

Confidential, IL

DataStage Developer

Responsibilities:

• Created the data mappings and conversion logic to cleanse the data
• Data Analysis to resolve defects with migrated data
• Performed POC in implementing DataStage instead of Pl/Sql in some of the existing modules.
• Participated in effort estimation.
• Responsible to converting old legacy systems into one integrated environment. Fetched the data from legacy system and cleansed the old data and convert according to new business logic and loaded into new systems.
• Worked with Business Analyst to understand business requirements from business owners in order to transform business requirements into TEMPeffective technology solutions.
• Perform DataStage performance tuning, maintain and support.
• Worked closely with Development and QA to clarify the requirement issues.

Environment: IBM Infosphere Datastage V8.5, UNIX, SQL Developer, Oracle 11g

Confidential, CA

DataStage Developer

Responsibilities:

• Responsible to converting old legacy systems into one integrated environment. Fetched the data from legacy system and cleansed the old data and convert according to new business logic and loaded into new systems.
• Production support for the applications for all sorts of trouble shooting.
• Created the data mappings and conversion logic to cleanse the data
• Worked with Business Analyst to understand business requirements from business owners in order to transform business requirements into TEMPeffective technology solutions.
• Implemented slowly changing dimensions on customers table using SCD stage.
• Involved in data loading as and when required from disparate sources to the Oracle Data warehouse and data marts using DataStage as the ETL tool.
• Development of ETL jobs to migrate bulk volume of data.
• Involved in performance tuning of Jobs.
• Regularly did the Data Quality Checks on the source system.
• Coordinating and allocating the team for Development of jobs.

Environment: IBM Infosphere Datastage V8.5, UNIX, SQL Developer, Oracle 11g