DATA ANALYST / SENIOR ETL DEVELOPER (RESUME)

NAME

Sowndar Sundararaj

QUALIFICATION

Master of Computer Application

CERTIFICATION

IBM Certified Datastage Developer, IIBF

DATABASES

Teradata, Oracle, SQL Server and Netezza

OPERATING SYSTEM

Windows, UNIX (AIX)

ETL TOOL

IBM Datastage, Microsoft SSIS

REPORTING TOOL

Tableau

SUMMARY

Have over 4.10 years of experience in data warehousing and business intelligence in a large scale Banking enterprise and Retail enterprise. Worked at client place and experienced with client-facing consulting activities

1+ year of experience in client location(Commomwealth Bank of Australia)

Having good knowledge on Datawarehousing concepts.

Involved in complete life cycle of ETL process and having extensive experience in ETL job development and performance tuning using IBM Datastage and MS-SSIS.

Extensive experience in integration of various data sources like Oracle, SQL Server and Teradata into operational data store and warehouse environments.

Extensive experience in simple and complex SQL development and performance tuning in different database.

Broader experience in analyzing business needs, creating the business report using Tableau based on adhoc request from business.

Extensive experience in complete project development life cycle including requirement gathering, analysis, design, build, test and support.

Communication with customers and offshore team members effectively.

Involved in giving training to the new team members in the project and assigning them the tasks to handle.

Working closely with the Business Analyst to get the final output reviewed on a timely basis to deliver the code in accordance to the Business Requirements.

EXPERIENCE SUMMARY

Cognizant Technology Solutions(CTS) – Programmer Analyst– Jul 2011 – Jan 2014

oLocation worked (address) : 2nd Cross Street, Madras Export Processing Zone, Chromepet, Chennai, Tamil Nadu 600044, India

oContact person (HR \ Project Manager): Ragu

oContact phone No : +919*********

HCL Technologies Limited – Senior Software Engineer– Feb 2014 – April 2015

oLocation worked (address) : SEZ UNIT,ETA TECHNO PARK-Special Economic Zone,Block-4,No.33,OMR,Navallur Village,Kanchipuram,Chennai-606103.INDIA

oContact person (HR \ Project Manager): Dhayalan R

oContact phone No : +91-770*******

HCL Australia Services Pty Ltd – Senior Software Engineer –May 2015 – Till Date

oLocation worked (address) : Level 5, 10 Dawn Fraser Avenue, Sydney, NSW 2172

oContact person (HR \ Project Manager): Dhayalan R

oContact phone No : +91-770*******

PROJECT DETAILS

CTS – NEXUS

Client: Academy Sports, USA Role: ETL Developer Duration: Jul 2011 to Apr 2012

The project involved handling of source data (from SQL Server, Netezza) and loads into target (Oracle). Datastage is used to read data from various source system and load into Oracle. SSIS is used to interact with the complex flat files and SQL Server to provide the reasonable data to target.

The project also involved considerable expertise in developing SQL scripts and executed using SSIS package to achieve our target. UNIX scripts were developed for runtime parameters.

Roles & Responsibilities:

In Datastage, design and development of complex jobs and sequence to convert data from different source systems to target application to meet its business rules.

Create complete SSIS package, build, deploy and execute the packages in different environments to come up with the uniformed data.

Analysis and cleansing of data along with performance tuning of the code to handle huge data volume.

Developed the reconciliation framework to ensure successful conversion from end to end.

Creating value add assets by developing automation scripts using shell to review the malicious Datastage code and parameter files and documenting specific complex module implementations.

Performance tuning of SQL and ETL code.

CTS - DATA MIGRATION

Client: Academy Sports, USA Role: Senior ETL Developer Duration: May 2012 to Feb 2014

Academy Sports is retail major in USA specializing in Sports & Outdoor Goods. It has six legacy source systems in different Database (SQL Server, Netezza and Oracle). The challenge was to build a Business Data Warehouse for the data from all these legacy systems using Oracle.

The complex thing was the project involved different sources like Oracle, SQL Server, Netezza and Flat Files, Those data needs to migrated into Oracle database

Roles & Responsibilities:

As a senior resource, I was given with the responsibility to understand the flow of the existing process and plan all the build activities for the team of 5 members

Developed a template for data flow and control flow which was to be used as the base for further ETL development

Created efficient Jobs, SQL Mail Agent and schedule SSIS packages

Analysis of data from different source systems

Clearly understand the existing packages and its data flow for each source system in SSIS

Documented my understandings about the process and published it to the team

Was involved in day–to-day ETL development, but was mainly given the responsibility to oversee, sort out issues and review the jobs and packages developed by the team

HCL - B&D - ILT

Client: CBA, Australia Role: Senior ETL Developer Duration: Mar 2014 to Nov 2014

The ILT Programme aims to move IB&M lending products and facilities onto the SAP platform. Replace the Bank’s non-SAP systems supporting the Corporate Banking Solutions suite of Institutional Lending products to meet business requirements (provide multi borrower, tranche, currency, facility option and jurisdiction capability)

Roles and Responsibilities

Gathering and analyzing business requirements

Analyzing and understanding the source system data

Determined the load strategy for the data load

Designed and developed the mappings for each source system

Unit testing and capture the test results

Prepared PRT and Production release notes

Prepared the run book for the complete data load activities which discussed about the order of executing the jobs

HCL – BAU (business as usual – 3rd line support)

Client: CBA, Australia Role: Senior ETL Developer Duration: Dec 2014 to Feb 2015

BAU is the bank business as usual, where the team supports the business in fixing the critical incidents. The team understands the business functionality and provides the fix on the existing code to articulate the functional requirement. The T&I resources review the technical solutions, deploy the technical components to E2E environments by both business & testing team. The T&I team also facilitates the testing & production implementation.

Roles & Responsibilities:

As a senior developer I am responsible for coding and testing the fix by nullifying the defects

Involved in writing test scripts, unit testing and documentation

Involved in enhancements and defect fix for existing mappings

Involved in Migration of ETL Code between DEV, QA Environments

Coordinated the work from Offshore

Lead my team in analyzing & fixing the incidents by reviewing their fixes

HCL - B&D – PODS

Client: CBA, Australia Role: Team Lead / Senior ETL Developer Duration: Feb 2015 to Till Date

Policy ODS is the data hub for all policy related information. The data from various policy application systems gets loaded into PODS by ETL batch jobs, for consumption by various users. The data in PODS is not consistent with the source system data due to numerous reasons, making it unusable. The overall objective of the project is to remediate the data in policy ODS.

Roles and Responsibilities:

Understanding the gaps with the existing ETL design and defining an overall ETL architecture to overcome the data integrity and consistency issues

Performance tuning in datastage code and database objects to meet the SLA

Leading the technical team from onshore, holding responsibility for all the technical deliverables

Planning task for development team based on deliverables

Managing the daily huddles to resolve any development issues and coordinating with design team to obtain clarification for any design concerns raised

Creating datastage ETL jobs, database objects and writing UNIX scripts

Creating and maintaining technical specification document and operations manual

Reviewing the code and test cases

Organizing walkthroughs with the engineering group to socialize and obtain sign-off for technical documents

Key Technical Activities

Implemented jobs in RCP to reduce project cost

Implemented technical reconciliation for PODS to ensure data harmony is maintained

Performed physical tuning of database objects by applying partitioning and compression on tables, removing redundant indexes etc.,

Added control tables to jobs to log data load statistics

Implemented error handling and data validation checks to trap source issues

Optimized the jobs by pushing majority of data processing to database, in order to utilize the indexes and partitions

ADDITIONAL INFORMATION

Objective is to supersede own performance with an improvement in overall quality and presentation

Fast learner. Experiment new ideas and bring innovation in working

Risk based proactive approach. Identify the processes, bottlenecks and way to improve it and the point to which we can take to attain that level of output without compromising on quality

Believes in in-depth study and implementation

PERSONAL INFORMATION

Date of birth : 05-Aug-1988

Nationality : Indian

Marital Status : Single

Mobile Number : +61-452******

Contact this candidate