ETL Tool Administrator

Thennarasan Sudanthiran

Email: *****.*****@*****.***

Mobile: 704-***-****

https://www.linkedin.com/in/thennarasansudanthiran

Data Warehousing IBM DataStage ETL Tool Admin - Sep 2014 to Present

Data Warehousing Business Intelligent Quality Analyst - May 2010 to Aug 2014

Client/Server Production Support Specialist - Feb 2007 to May 2010

Software Developer - Jun 2005 to Jan 2007

Overall, 13 years and 5 months of Information Technology Experience

8 years and 6 months of experience in Data Warehousing ETL Process and Data Management

2 year and 7 months of experience in Data Warehousing ETL Tool Administrator

3 Years of experience in Business Intelligence in Software Quality Audit and Quality Assurance Department

3 Years of experience as Production Support Specialist in the Client Server architecture support model

1 Year and 7 months as Core Software Developer and involved in the entire Software Development Life Cycle model

TECHNICAL SKILLS

Operating Systems: Windows Servers 2008 and Sun Solaris UNIX

Database: Microsoft SQL Server 2008 and ORACLE 11g

ETL Tool: IBM InfoSphere Information Server DataStage (Versions 9.12 and 11.7) and Informatica

Applications Tools: Microsoft Visual Basic

And Microsoft .Net Visual Studio

BI Tools: Crystal Reports 8, Business Objects and OBIEE 11

Programming Language: VB.Net, C#, UNIX Shell Scripting

Process Management Tool: IBM Rational Tools Jazz and JIRA

Defect Management Tool: HP Quality Control and HP ALM 11

EDUCATIONAL QUALIFICATION

Degree : Bachelor of Technology in Information Technology

Education Institute : V.LB. Janakiammal College of Engineering and Technology

University : Anna University

Location : Coimbatore, TamilNadu, INDIA

Year of Graduation : 2005

Degree : Diploma in Electronics Engineering

(With Specialized in Instrumentation)

Education Institute : V.LB. Janakiammal Polytechnic College

University : Director of Technical Education, Anna University

Location : Coimbatore, TamilNadu, INDIA

Year of Graduation : 2002

PROFESSIONAL EXPERIENCE

HARMONIA Holdings Group LLC, Kansas City, Missouri, USA

ETL Tool Administrator Sep 2014 - Present

• Deploying DataStage package to higher environments

• User access and roles management

• DataStage Production Jobs monitoring and Issue Analysis

• Involved in Product Upgrade and Server Upgrade

• Developed shell scripts for automation

• Implemented varies Process Improvements Ideas

• Server backup process monitoring

• Server Health check process monitoring

• Setting up environment for Development Team and Testing Team

• Migrating projects to Production with required environmental variables

• Document activities in all migrations and production deployment

• Supporting and Coordinating Development team and client users

• Application monitoring to ensure all the daily, weekly and monthly jobs are running without any errors and warning.

• Dashboard updates with individual business subject areas

Cognizant Technology Solutions

Associate Feb 2007 to Aug 2014

I had been worked for many different clients in various business domain and different technological clients for Cognizant. Highlighted Key Clients and my major roles and responsibilities

TIAA-CREF - Charlotte, NC, USA: ETL Batch

• Validating the mapping document with the DataStage Job execution results.

• Accurately and effectively communicate product risks to project team and client QA leadership

• Validating the custom reports and ad hoc reports built in OBIEE

• Validated the slowly Changing Dimension type IV based on the requirement

• Involved in Effort estimation and tracking of the project plan for QA activities

• Prepare test phase summary report and send to business approval.

• Involved in onshore offshore co-ordination of project

• Preparing QA Test Strategy, test plan

And impact analysis document for new project / change request (CR).

• Used Data Stage Director to execute the Sequence/Parallel jobs. Debugging any issues in job using Data stage designer addressing exact issue while raising defects.

• Performing data validation by running ETL Job, managing batch jobs using Autosys

• Designed mock up test data using excel to test the application with positive and negative scenarios.

• Used SQL Developer to run SQL queries to check data is populating as expected from tables.

• Performing in data validation, data profiling, data scrubbing, and data frequency analysis

Xerox Corporation US: Xerox EPPIC

• Responsible for gathering Business Requirements and Functional Requirements

• Developed Test Cases for Staging, Operational Data Store, Data Marts, Standard Reports,

• Validated the Slowly Changing Dimension (SCD) type 2 based on the requirement

• Validated Data Stage ETL jobs for the data quality and record count

• Managed the defect tracking process using QC. Conducted defect review meeting on daily basis to prioritize the defects.

• Preparing the complex Queries to test the data warehouse

• Executing the queries in Oracle SQL Developer and record the results

AAA (American Automobile Association) – KTLO (Keep the Lights On) Production Support

• Developed Test Cases for Staging, Operational Data Store, Data Marts, Standard Reports,

• Involved in effort estimation and tracking of the project plan for QA activities.

• Validated Data Stage ETL jobs for the data quality and record count

• Tested the Data Validations in application using the SQL Queries in SQL Developer

• Involved in ETL testing using Oracle SQL Developer & UNIX batch jobs

• Prepared & reviewed Test scenarios, Test cases and Test Data, Test case Design & Execution

• Managed the defect tracking process using QC. Conducted defect review meeting on daily basis to prioritize the defects.

• Preparing the complex Queries to test the data warehouse

• Preparing the high level test result document and related document preparation

WellPoint: RHI (Resolution Health Incorporation)

• Involved in effort estimation and tracking of the project plan for QA activities.

• Involved in creating Test Strategy document and detailed test plan.

• Validated Data Stage ETL jobs for the data quality and record count

• Tested the Data Validations in application using the SQL Queries in SQL Developer

• Involved in ETL testing using Oracle SQL Developer & UNIX batch jobs

• Participated in project meetings and lead the team members in delivering quality solutions

• And assisted them in better understanding of the project requirements.

• Root-cause analysis and co-ordination meetings and also participates in quarterly process audits

• Preparing the complex Queries to test the data warehouse

• Executing the queries in Oracle SQL Developer and record the results

Xerox UK- Legacy Applications - CS MIT Support

• Tested the Data Validations in application using the SQL Queries in SQL Developer

• Involved in ETL testing using Oracle SQL Developer & UNIX batch jobs

• Prepared & reviewed Test scenarios, Test cases and Test Data, Test case Design & Execution

• Participated in project meetings and lead the team members in delivering quality solutions

• And assisted them in better understanding of the project requirements.

• Root-cause analysis and co-ordination meetings and also participates in quarterly process audits

• Preparing the complex Queries to test the data warehouse

• Executing the queries in Oracle SQL Developer and record the results

• Preparing the test result documents

Interweb I Tech (INDIA) Private Limited Jun 2005 – Jan 2007

Software Engineer

• Requirements gathering and developing the Visual Basic .NET applications software by covering all the business use cases and Review the SQL stored procedures and implementing the fixes

• Developing and testing the Crystal reports

• Installing the latest build into the client places and R&D on Enhancements to existing ERP systems

Contact this candidate