Manager Data
Resume:
Suresh Babu Kadiam
*******.***@*****.***
Professional Summary
Twelve plus years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Data Warehousing Systems.
Experience in ETL Datastage using IBM InfoSphere DataStage (v11.5/9.1/8.7/8.5/8.1/7.5.2/7.1/5.1), Server Edition, Enterprise Edition (Parallel Extender).
Experience using IBM InfoSphere QualityStage v8.7 in Name, Address, Area, Phone and Email Standardization, Unduplicate and Reference Matching.
Experience in ETL Informatica PowerCenter (v8.1) and extensively used PowerCenter Designer, Worflow Manager, Workflow Monitor and Repository Manager.
Experience in Talend Open Studio for Data Integration (v6.1) and used several components like tFileInputDelimited, tFileOutputDelimited, tOracleInput, tOracleOutput, tRowGenerator, tMap, tSort, tAggregator, tFilter, tConvertType, tSample, tLogRow, pHiveRow, tHiveConnection, Context Variables and Groups etc.
Having strong knowledge in Data warehousing, Banking, Retail, Health Care and Insurance domains.
Worked with Business Analysts and users to understand the business requirements and have good experience in system analysis, effort estimation, design, development and implementation of various data warehousing projects.
Extensively used Datastage components like Datastage and Qualitystage Designer, Director, Manager and Administrator in Data Warehouse development.
Extensively used Informatica Designer components like Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
Experience in integrating Big data components with Talend and have worked with components like tHiveRow, tConnection, tHDFSInput. tHDFSConnection etc.
Extensively used DataStage 8.5/9.1 ETL to load data from IBM DB2 (Z/OS), Oracle and Flat files into the target ORACLE/DB2 database.
RDBMS experience with Oracle 10g/9i/8i, SQL Server, DB2, Teradata, Netezza, Greenplum, Sybase and PL/SQL programming.
Developed jobs to parse the data in XML tags, using XML Hierarchical, XML Input and XML Output Stages, and extensively worked with Flat files and CSV files.
Extensively worked on QualityStage Investigate, Standardization, Unduplicate Match, Reference Match, Survivor, CASS, Address Verification stages and PREP rulesets to standardize US and Canadian data.
Conducted detailed data analysis / reporting using IBM Web Sphere Information Analyzer for the multiple sources from various systems.
Excellent knowledge and experience in all stages of the Software Development Life Cycle (SDLC).
Broad understanding of dimensional data modelling like Star schema, Snow flake schema, Fact and Dimension table design.
Designed Mappings between sources to data staging area and target data warehouse, using Star Schema, Implemented logic for Slowly Changing Dimensions.
Extensively worked on Parallel Jobs using various stages like Join, Transformer, and Lookup. Pivot, Modify, Change Data Capture, Difference, Filter, Funnel, Copy, Sort, FTP, Sequential File, Complex Flat File, Data set, DB2 enterprise/connector, Merge, Aggregator, Row Generator, Shared Container, Remove Duplicate, Make Vector, Column Export, Column Import and External Source Stages.
Extensively used various transformations like Source Qualifier, Expression, Filter, Router, Connected and Unconnected Lookup, Update Strategy and Sequence Generator.
Extensively Worked on Job Sequences to control the execution of the job flow using various activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities.
Created Shared containers, Multi instance Jobs and Parameter sets to increase the reusability.
Worked with UNIX shell scripting for Job control, file management and scheduling DataStage jobs.
Administrator experience includes creating users, creating roles, granting privileges, creating projects.
Involved in Unit Testing, Functional Testing, Integration Testing and Regression Testing.
Experience working in Agile and Waterfall Models.
Experience in scheduling tools like Control M Enterprise Manager, Robot Scheduler, cron tab for automating and scheduling jobs run.
Involved in Production Support and Enhancement Activities in one of my earlier projects.
Experience in Leading the Teams, problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.
Certifications
IBM Certified Infosphere DataStage V8.5
Six Sigma Certified in Banking Competence
Education
Bachelor of Engineering in Electronics and Instrumentation Engineering, Andhra University, INDIA
Technical Skills/Tools
ETL Tools
IBM InfoSphere DataStage 11.5/9.1/8.7/8.5/8.1/7.5.2/7.1/5.1 (Designer, Director, Administrator), Parallel Extender, Server Jobs
IBM InfoSphere Quality Stage 8.7
IBM Information Server Web Console
IBM InfoSphere Metadata Asset Manager
Informatica 6.1,8.1, Talend 6.1, Base SAS v8
OLAP
Cognos 6.0(Impromptu, Administrator, and Power Play Reports).
Data Modeling
Star Schema, Snowflake schema, FACT and Dimensions, Erwin 4.5/4.0, Physical and Logical data modeling.
Databases
Oracle 10g, 9i, 8i and Ms-SQL Server 2005, DB2, Teradata
Programming
UNIX Shell Scripting, SQL, PL/SQL, Perl
Database Tools
Oracle SQL developer, SQL developer, TOAD, DB2 Control Center, Teradata Studio, Advance Query Tool
Other Tools
Control M Enterprise Manager, Robot Scheduler, Jmeter, Eclipse, ESP Job Control, PVCS, SVN
Contact this candidate