SUMMARY

• Over 7 years of experience in design, development, implementation and production support of business applications wif 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 wifusers and functional team for gathering teh 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 wif 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 wif 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 teh population of teh 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 teh 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 teh 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 wif parallel extender for parallel processing to improve job performance while working wif bulk data sources
• Experience in Debugging, Troubleshooting, Performance tuning, Analysis & Optimization of ETL jobs.
• Hands on experience to design teh Datawarehouse7, created ER diagrams using Erwin
• Excellent communication skills wif 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 wif business users for requirement gathering and analyzing teh scope of teh project.
• Design/modify teh exiting ETS
• Created teh Architecture & Design of teh interfaces to teh application.
• Created source-to-target mapping documents by working wif 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 teh 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 wif 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 wif business users regarding teh agile methodology requirements and back logs of teh previous sprints to analyze and design integration approach.
• Used Infosphere DataStage designer tools for creating parallel jobs and importing and exporting teh jobs.
• Worked wif 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 teh monthly regular run of DW cycle in both production and non-prod environments.
• Created Technical design document
• Created teh data mappings and conversion logic to cleanse teh 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 wif 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 teh priority.
• Extensively worked wif Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute teh 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 teh data mappings and conversion logic to cleanse teh data
• Data Analysis to resolve defects wif migrated data
• Performed POC in implementing DataStage instead of Pl/Sql in some of teh existing modules.
• Participated in effort estimation.
• Responsible to converting old legacy systems into one integrated environment. Fetched teh data from legacy system and cleansed teh old data and convert according to new business logic and loaded into new systems.
• Worked wif 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 wif Development and QA to clarify teh 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 teh data from legacy system and cleansed teh old data and convert according to new business logic and loaded into new systems.
• Production support for teh applications for all sorts of trouble shooting.
• Created teh data mappings and conversion logic to cleanse teh data
• Worked wif 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 teh Oracle Data warehouse and data marts using DataStage as teh ETL tool.
• Development of ETL jobs to migrate bulk volume of data.
• Involved in performance tuning of Jobs.
• Regularly did teh Data Quality Checks on teh source system.
• Coordinating and allocating teh team for Development of jobs.

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