DATASTAGE ETL DEVELOPER Summary I 6 years ETL experience extensive experience business system analysis across multiple platforms using full software development life cycle. I worked role Data Warehouse Specialist,ETL Datastage developer Production Support Analyst requiring subject matter expertise dealing mainframe sources COBOL/ASCII File structure ,Distributed sources (RDBMS) handling business intelligence data DB2, Netezza, Oracle, SQL Server Hadoop Hive Data Warehouses I worked developing supporting major Banking Credit card conversion Member Debt solutions project Unites Services Automobile Association. These projects involved Requirement analysis, Risk assessment management, Data planning driving, Process Implementation, Team management, Project tracking, Customer interaction, Release Management, Defect tracking, Deliverable Warranty support. Over period, I established exemplary record providing successful system support delivering business value mid-level large business intelligence applications. I demonstrated excellent leadership skills handling multiple offshore, nearshore project assignments multiple resources delivered requirements time. Skills Expertise IBM Datastage (8.5,9.1 11.5 versions) perform ETL ELT operations data Proficiency Unix Shell Scripting Proficiency writing debugging complex SQL Informatica ETL Support experience (Version 9.1) Hands experience IBM DB2 /Netezza/ SQL Server/Oracle Data archival IBM BIGINSIGHTS HIVE tables Experience Control-M Scheduling Tool Accomplishments IBM Certified Solution Developer-InfoSphere Datastagev8.5 IBM Certified Solution Developer-InfoSphere Datastage v9.1 Certified Oracle Database 11g: SQL Fundamentals I. Experience DATASTAGE ETL DEVELOPER Jan 2016 Current Company Name － City State MEMBER DEBT SOLUTIONS PROJECT Project involved conversion un-scalable SQL sandbox data scalable Netezza Collections data capable large scale analytics. Developed Datastage Jobs load Collections data multiple sources Aspect,CACS,Strata,FICO,Fidelity FDR respective Dimensions Fact tables required business transformations. Involved phases SDLC, created detailed Analysis-Design documents source target mappings. Developed maintained accurate project documentation data model diagrams provide management proper understanding organizational needs. Prepared technical data flow proposals enhancements integration existing third-party data.Communicated business users project management get business requirements translate ETL/ELT specifications. Provided technical support business team user departments projects. Handled multiple offshore, nearshore resources project delivered requirements time. ​​ BIGINSIGHTS DATA ARCHIVAL As part raw data archival I worked project developing framework load raw files foundation layer. Coding done Unix Shell Scripting. All data loaded foundation layer BIGSQL compatible Hive tables built top it.The Hadoop data read Hive query language used discovery purpose. ​ DATASTAGE 11.5 MIGRATION PROJECT Worked migrating Datastage jobs InfoSphere Information Server, Version 9.1 InfoSphere Information Server, Version 11.5. My primary task gather migration requirements, design topology/playbook, test jobs QA server ver 11.5 production implementation/support. DATASTAGE ETL DEVELOPER Feb 2013 Jan 2016 Company Name － City State CREDIT CARD CONVERSION PROJECT Large project integrate single entity credit cards dual entity credit cards. This migration enabled cross-border portfolio view credit card applications enabled maintaining plastic number across history analytics usage. Developed Datastage jobs ETL transformations requirement provided load respective Dimensions Fact tables. Lead Offshore team throughout project created detailed accurate project documentation. Application SME (subject matter expertise) project implementation offshore. INFORMATICA TO DATASTAGE ETL CONVERSION Migrated 180 mappings Informatica ETL tool Datastage tool part ETL conversion project. Analysed Informatica workflow/mapping converted Datastage jobs Industry standards. Performed test case scenario/production implementation support. DATAWAREHOUSE MIGRATION TO IBM NETEZZA Migrated 100 TB Data IBM Netezza platform multiple DB2/SQL Oracle warehouses. Involved Requirement gathering,Table design, ETL Design/testing implementation. DATASTAGE SERVER MIGRATION PROJECT Worked migrating 1000+ Datastage jobs InfoSphere Information Server, Version 8.1 InfoSphere Information Server, Versions 8.5 9.1 years. PRODUCTION SUPPORT ANALYST Jan 2012 Feb 2013 Company Name － City State DATA MANAGEMENT RETURN TO SERVICE The primary objective project maintain Extract Transform Load (ETL) portfolio projects enterprise level.In production support role, provided quick problem resolution daily, weekly, monthly processing cycles executing Datastage/Informatica. Over period, I established exemplary record providing successful system support delivering business value mid-level large business intelligence applications. Also worked Service Requests developing ETL Datastage jobs small business requirements. Education Training BACHELOR OF TECHNOLOGY 2011 ANNA UNIVERSITY － City State INDIA BUSINESS INTELLIGENCE TRAINING 2011 TATA CONSULTANCY SERVICES － City State INDIA SEPTEMBER 2011 DECEMBER 2011 This course provides overview gives business information technology professionals confidence dive right business intelligence data warehousing activities. Hands-On training provided ETL tools Informatica/Datastage data warehousing environment 90 days. DATASTAGE TRAINING 2012 GREENS TECHNOLOGIES － City State INDIA This course designed introduce ETL developers Datastage Development, Data Warehousing Data Modeling training's real-world ETL process implementations. Activities Honors DISTINGUISHED ACHIEVER AWARD- TATA CONSULTANCY SERVICES [FEB 2015]