Sr. Etl Developer

Dilip Kesavan

*** ****** **, **********, *********** 06040

Phone: 860-***-****, e-mail: *********@*****.***

Profile Summary

• 10 Years of IT experience pre-dominantly in Data Warehousing ETL and Insurance domain.

• Performed data integration developer, production support engineer, system analyst, data analyst and tech lead roles for Claim Business intelligence projects. Experienced in Scaled Agile/Waterfall models.

• Skill set includes ETL, SQL and UNIX. Strong working knowledge of Data Warehousing techniques and experience including ETL processes, Star Schema.

• 9+ years of experience in Abinitio (GDE, Express>IT, EME), UNIX and Teradata.

• Experience in code design and management with Talend 7.1 and SSIS.

• Contributes to overall architecture, frameworks and patterns for processing and storing large data volumes.

• Implementation of modernization/conversion of legacy projects with different tools and technologies.

• Contributed to creation of High Speed Pipeline for ETL code deployment using Github, Jenkins and UCD.

• Contributed to creation of ETL Test Automation framework using Python and Flask.

• Solid experience following Agile/Scrum/Kanban methodologies and processes. Skills

ETL: Abinitio, Talend, Informatica

Languages: C, C++, Java, SQL, Basic Shell Scripting, Python IDE: Visual Studio Code

Version Control: GitHub, SVN

CICD: Jenkins, UCD

Database: MS SQL Server 2016, Teradata 16.10, DB2 10, Oracle 12.2/19c Scheduling: CA7 AutoSys

Education

Bachelor of Technology, Computer Science and Engineering June 2005-June 2009 Government Engineering College, Thrissur, University of Calicut, Kerala, India Experience

Sr ETL Developer, Client - Travelers Insurance Inc., Hartford, CT May 2018-Current Cognizant Technology Solutions US Corp

Technologies Used – Abinitio, Talend, Unix Shell scripting, Teradata, DB2, Oracle, Cognos, Connect Direct, Autosys, SSAS and MS SQL Server

• ETL Development using Abinitio ETL by directly interacting with business stakeholders and building a complete product, via data analysis and feasibility studies. This allowed upfront assessment of risks and complexities in the project. Also acted as a liaison between Business and IT team.

• Working as a Subject Matter Expert to the IT team by mentoring/transitioning them on the business requirements, data and the Abinitio ETL code built.

• Preparation of low level, high level ETL design documents.

• ETL Administration and code development support for Talend ETL applications.

• Design and strategize the conversion of Legacy ETL applications from Abinitio to Talend.

• Use Agile methodologies such as Scrum, Kanban and SAFe to interact with product owner and business.

• Design, implement and present POCs for clients as per business requirements.

• Design test automation strategy and frameworks.

• Design frameworks to enable CICD strategy.

• Work with offshore and review their work to ensure quality. ETL Lead Developer, Client - Travelers Insurance Inc., Hartford, CT Oct 2015-Apr 2018 Cognizant Technology Solutions US Corp

Technologies Used – Abinitio, Unix Shell scripting, Teradata, DB2, Oracle, Cognos, Connect Direct, Autosys, SSAS and MS SQL Server

• Involved in Tier II On Call Support (24/7) and Tier I Email Alert Support as part of the monitoring of production jobs.

• Performed analysis, assigns and provides resolution of customer issues logged through HPSM for all supported applications.

• Coordination of Production fixes identified through customer issues or production monitoring.

• Performed estimation, created requirements documents and high level design documents. Assigned and coordinated the implementation of Business requests for enhancements of supported applications.

• Provided support for execution of Major/Minor infrastructure upgrades for which the primary activities included assessment, analysis, scope/impact evaluation, coding, testing and roll out of application changes

• Onshore point of contact for production issues, ETL code reviews, work status updates and Primary SME for all ETL applications.

ETL Lead Developer, Client - Travelers Insurance Inc., Hartford, CT Feb 2012-Sep 2015 Cognizant Technology Solutions, India

Technologies Used – Abinitio, Unix Shell scripting, Teradata, DB2, Oracle, Cognos, Connect Direct, Autosys, SSAS and MS SQL Server

• Involved in Tier II On Call Support (24/7) and Tier I Email Alert Support as part of the monitoring of production jobs.

• Performed analysis, assigns and provides resolution of customer issues logged through HPSM for all supported applications.

• Coordination of Production fixes identified through customer issues or production monitoring.

• Provided support for execution of Major/Minor infrastructure upgrades for which the primary activities included assessment, analysis, scope/impact evaluation, coding, testing and roll out of application changes

• Offshore point of contact for production issues, ETL code reviews, work status updates and Primary SME for all ETL applications.

ETL Lead Developer, Client - Travelers Insurance Inc., Hartford, CT Nov 2011-Jan 2012 Cognizant Technology Solutions, India

Technologies Used – Abinitio, Unix Shell scripting, Teradata and DB2

• Involved in coding, analyzing, component testing, debugging, documenting and implementation of Abinitio graphs. Developing standard framework used for new requirement by parameterization for maintainability and for rapid development and enhancements.

• Involved in preparing Detailed Development documents for the project. Identifying performance bottlenecks and making adjustments to processes so that the performance is to be independent of Data volume for Abinitio.

• Worked on strategic code development in Abinitio by creating graphs, plans and psets to ensure the effective execution of the process from end to end as part of Catastrophe Application Redesign project.

• Involved in testing, fixing defects to ensure quality of the code. ETL Developer, Client - Travelers Insurance Inc., Hartford, CT Jan 2011-Oct 2011 Cognizant Technology Solutions, India

Technologies Used – Abinitio, Unix Shell scripting, Autosys and MS SQL Server

• Involved in requirements analysis and creation of High Level and Low Level design documents.

• Worked on strategic code development in Abinitio by creating graphs, plans and psets to ensure the effective execution of the process from end to end as part of Catastrophe Application Redesign project.

• Involved in testing, fixing defects to ensure quality of the code. ETL and BI Tester, Client – Abbott Laboratories, USA Oct 2010-Dec 2010 Cognizant Technology Solutions, India

Technologies Used – Informatica, Oracle SQL, SQL Server, Cognos

• Involved in creation of System Test cases as part of System Integration Testing.

• Involved in building and executing test queries in Oracle and reporting and tracking of defects.

• Involved in integration testing of Cognos reports. ETL Tester, Client – ING Malaysia Jul 2010-Oct 2010 Cognizant Technology Solutions, India

Technologies Used – Informatica, Oracle SQL, UNIX

• Involved in creation of System Test cases as part of System Integration Testing.

• Involved in building and executing test queries in Oracle and reporting and tracking of defects.

Contact this candidate