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******