THIRUKKUMARAN SOMASUNDARAM
Senior Data Analyst
Chennai
Summary
Seasoned BI developer, consultant, and solutions expert with 11+ years of IT experience in Chennai, India. Skilled in team leadership, project management, automating scripts for data analysis, and presenting insights to stakeholders. Proficient in Requirement Gathering, analysis, design, development, data quality checks, and performance tuning using Agile methodologies. Experienced in project planning and coordination in onsite-offshore models for Banking, Healthcare, and Insurance industries. Completed IIT Madras certified "Introduction to Data Analytics" program. Strong in client interactions, documentation with MS Office and MS PowerPoint.
Overview
11
11
years of professional experience
Work History
Lead Analytics Consultant
Wells Fargo
Chennai
01.2022 - Current
- Working for the Customer Remediation Analytics Team under Credit card products to identify and analyze the customers who are impacted and complete the remediation process.
- Actively worked with stakeholders to know the financial impacts, Harm amounts and Loss of Use Compensation.
- Worked with business partners and engaging in decision forums to identify the impacted customers and help remediate the customers accordingly.
- Contributed on the Peer review process of the work done by the Stakeholders and raised concerns if they do not meet the standards of the process.
- Building the Population Identification and Data Analytic approach to meet the check points and proactively raise issues if the standards are not met.
- Managed to complete around 10 remediation with end to end support of entire life-cycle.
Associate - Projects
Cognizant Technology Solutions
Chennai
07.2018 - 01.2022
- SAS Load programming based on the business requirement. Handled a team of three members.
- Automation of the existing process to reduce the overhead of redundant tasks.
- Minor enhancements of the existing applications. Modified existing SAS Macros in various codes for the clients in accordance with the requirements specified by the clients.
- Automation of manual data reading by Data Analyst into a report which generates report for all the clients for statistical analysis by Data Analysts.
- Worked on extracting data from Flat files, Excel spreadsheets, 834 file – a standard file used in health care for transfer of data.
- Aetna Voluntary handles the supplementary products.
Associate Consultant
Capgemini India Pvt Limited
Chennai
11.2016 - 06.2018
- Designed and developed interactive Tableau dashboards to visualize key business metrics, enabling data-driven decision-making.
- Translated business requirements into actionable data visualizations, streamlining reporting processes across departments.
- Utilized Tableau Desktop to connect to various data sources (SQL, Excel, cloud-based) and create dynamic dashboards.
- Leveraged calculated fields, parameters, and filters to build flexible and user-friendly dashboards.
- Validated data by using Base SAS Procedures PROC SORT, PROC FREQ and PROC CONTENTS.
- Providing Reports on the Analysis done with day to day activities and also various enhancements which involves calculation of credit scores on various parameters specified and performing analysis on the data results.
- Managed multiple projects simultaneously while maintaining attention to detail, organization, and adherence to deadlines.
Senior Systems Engineer
Infosys Limited
Bengaluru
05.2014 - 10.2016
- Experience in Extraction and Migration of data, statistical Analysis using various Analysis procedures like PROC UNIVARIATE and PROC FREQ.
- Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets etc.
- Providing comprehensive solution that provides a consistent approach to an organization's budgeting and financial management needs.
- Mentored junior engineers in advanced concepts, fostering professional development within the team.
Education
B.E - Electrical and Electronics Engineering
RMD ENGINEERING COLLEGE
Chennai04.2014
Skills
Proficient in SAS 913
Proficient in Base SAS
Proficient in SAS/MACRO
Data analysis with SAS/SQL
Experience with UNIX and SAS integration
Experienced with Tableau software
Data visualization
Expertise in advanced Excel functions
Data visualization
Timeline
Lead Analytics Consultant
Wells Fargo
01.2022 - Current
Associate - Projects
Cognizant Technology Solutions
07.2018 - 01.2022
Associate Consultant
Capgemini India Pvt Limited
11.2016 - 06.2018
Senior Systems Engineer
Infosys Limited
05.2014 - 10.2016
B.E - Electrical and Electronics Engineering
RMD ENGINEERING COLLEGE