Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Karthick Obuliraj

Karthick Obuliraj

ETL Consultant
San Antonio,TX

Summary

Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Overview

13
13
years of professional experience
1
1
Certification

Work History

ETL Consultant

Tata Consultancy Service
San Antonio, TX
06.2023 - Current
  • Client : United Services Automobile Association (USAA)
  • Performed cost-benefit analysis of proposed changes to business processes.
  • Collaborated with stakeholders across departments to define requirements for new projects.
  • Created detailed process flows and user stories to document system requirements and design solutions.
  • Identified gaps between current state and desired future state operations.
  • Created automated scripts to ensure the accuracy of ETL jobs in production environment.
  • Troubleshooted issues related to data integrity, performance or functionality during ETL process.
  • Implemented best practices for creating robust and scalable ETL pipelines using SQL and Cloud databases.
  • Migrated existing legacy applications from various sources into a single platform via ETL processes.
  • Configured and maintained scheduling tools like Autosys, Control-M. for running batch jobs.
  • Recommended data analysis tools to address business issues.
  • Analyzed customer data to determine trends in purchasing behavior.
  • Drafted functional specifications documents outlining project scope, objectives and deliverables.

Technical Lead

Tata Consultancy Services
Chennai, India
07.2021 - 06.2023
  • Client : United Services Automobile Association (USAA)
  • Developed and maintained technical documentation for software systems.
  • Provided technical guidance on development projects as well as implementation of new technologies.
  • Collaborated with other team members to troubleshoot complex issues and develop solutions.
  • Conducted code reviews to ensure high-quality code was produced that adhered to coding standards.
  • Performed root cause analysis for production incidents and identified permanent fixes.
  • Resolved conflicts between stakeholders by proposing creative solutions that balanced competing interests.
  • Facilitated communication between different teams to ensure successful completion of projects.
  • Trained technical personnel according to USAA Company industry standards.
  • Ensured compliance with established processes, procedures, policies, guidelines, and standards.

Technical Lead

Tata Consultancy Service
San Antonio, TX
06.2017 - 07.2021
  • Client : United Services Automobile Association (USAA)
  • Environment : Data stage 11.7, Oracle 10g, Hadoop, The CORPSYS project aims at providing corporate data mart, a various data source from corporate systems like HR, Financial planning and advice
  • Developed ETL processes and objects such as jobs, transformations, mappings, sessions using IBM DataStage 11.7
  • Developed and implemented ETL processes for data ingestion from multiple sources into the Data Warehouse.
  • Designed and developed complex mappings with multiple sources and targets to extract data from multiple systems.
  • Created error handling logic for all the mappings to capture any errors during the ETL process.
  • Created shell script to invoke datastage job and scheduled the jobs in Control-M and testing the jobs
  • Created complex mappings using SQL, PL and SQL, Unix shell scripts to facilitate ETL operations.
  • Involved in SIT (System Integration Testing) Support activities such as SIT issues logging and track until the issues are closed
  • Involved in Unit Testing, Error handling, and also prepared technical document like Unit Test
  • Responsible for providing production environment support and application maintenance
  • Identified bottlenecks in ETL process and resolved them by analyzing the session log files.

BI Developer

Tata Consultancy Service
Newark, NJ
04.2015 - 04.2017
  • Client : AIG Global Services, Inc
  • Commercial IT Production Support Reporting dashboard is a ticketing system to manage application workload, Track issues, and control on Ticketing SLA
  • Developed data models and ETL processes to extract, transform, and load data from various sources into the BI platform.
  • Designed and implemented dashboards using QlikView to provide interactive visualizations of business data.
  • Collaborated with stakeholders to identify key performance indicators for reporting purposes.
  • Performed data analysis tasks to uncover trends and insights from large datasets.
  • Maintained documentation on all aspects of the BI environment including data models, ETL processes.
  • Designed, developed, implemented, and supported QlikView dashboards and Datastage Job to
  • Used SQL, PowerPoint and Excel daily to generate various performance reports for analysis
  • Created and oversaw dashboards with QlikView.
  • Provided technical support for users experiencing issues with the BI platform or toolsets.

ETL Developer

Tata Consultancy Service
Chennai, India
04.2013 - 03.2015
  • Client : AIG Global Insurance ( UnderWriting )
  • This project aims to upgrade the Underwriting Application Datastage project from 8.5 server to1 server Calculating various policy measures based on the business rules and storing them in appropriate table for downstream application to create reports
  • Sending files to various interfacing systems and process the files which are received from those interfaces such as XMITS, CLAIMS, ALERTS
  • Understanding the Business rules and design of the 9.1 Data stage Jobs
  • Move the Datastage DSX,Scripts,Env variable files from 8.5 server to 9.1 server
  • Validate the new datastage server compatibility , and Modify the jobs based on Director logs
  • Designed ETL processes using Datastage to load data from Flat Files to DB2 database
  • Created error handling logic for all the mappings to capture any errors during the ETL process.
  • Designed and developed complex mappings with multiple sources and targets to extract data from multiple systems.

ETL Developer

Wipro Technologies
Chennai , India
07.2011 - 03.2013
  • Client : CITI Bank Credit Cards
  • Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
  • Credit card transaction data will be pushed into the reporting database by ETL jobs based on the different business conditions mentioned in the job
  • Created SQL Server Integration Services packages for incremental and full loads of data from various sources.
  • Analyzing the existing system and preparing the feasibility/Understanding document
  • Performing Data Profiling and Data sizing based on the business requirement of the new data arrival
  • Performing Peer code review for the graphs developed by the team mates
  • Performing Unit, Integration, End to End testing and etc
  • Preparing Deployment Documents and co-ordinating with other teams like QC and Testing
  • Production Support and etc.

Operations Analyst

Yallamanchili Software
Chennai , India
06.2010 - 07.2011
  • Client : Visa Cards
  • Analyzed and documented existing business processes to identify inefficiencies and recommend process improvements.
  • Designed reports to track key performance indicators such as cost savings and production throughput.
  • Prepared financial models to forecast future cash flows and profitability metrics.
  • Generated regular reports summarizing the status of ongoing projects or initiatives.
  • Created test cases and scenarios for documentation and root cause analysis of bugs.

Education

Master of Computer Applications - Computer Science

Anna University
Chennai
07.2009

Skills

  • Datawarehouse Tools : DataStage 115 ,117 , DBT
  • Snowflake
  • Database : Oracle 11g, DB2 SQL Server
  • Automation Tools: UIPath , QTP 92
  • BI Tools : Qlikview 12, Microsoft BI
  • Scripting : Unix Shell Scripting, Python,Vb
  • Scheduling Tool: Control-M 8,Autosys
  • Code Repository Tool: GIT, IBM Rational Software Architect
  • Project Planning : Agile methodology , Safe Agile Scrum

Certification

Educational Qualification Master of Computer Applications (M.C.A.), K.S.R college of Engineering, Anna University, Chennai

  • SnowPro Core Certified - SnowFlake -2023
  • SAFe 6.0 Agilist Certified - SAFe -2021
  • Database Program with PL/SQL - Oracle -2017
  • IBM Certified Solution Developer - InfoSphere DataStage v11.3 , - 2015

Timeline

ETL Consultant

Tata Consultancy Service
06.2023 - Current

Technical Lead

Tata Consultancy Services
07.2021 - 06.2023

Technical Lead

Tata Consultancy Service
06.2017 - 07.2021

BI Developer

Tata Consultancy Service
04.2015 - 04.2017

ETL Developer

Tata Consultancy Service
04.2013 - 03.2015

ETL Developer

Wipro Technologies
07.2011 - 03.2013

Operations Analyst

Yallamanchili Software
06.2010 - 07.2011

Master of Computer Applications - Computer Science

Anna University

Similar Profiles

CREATE PROFILE
Karthick ObulirajETL Consultant