ASHWIN JOE VARGHESE
Mississauga,ON
Summary
Accomplished Senior Data Analyst with 5 years of experience in the finance industry and an overall 12 years of IT experience, specializing in data-driven decision-making and advanced analytics. Proficient in SQL and Python, with a strong background in statistical analysis . Proven ability to transform complex data into actionable insights that enhance business strategies and improve operational efficiency.Has experience in building Data Warehouse/Data Marts using ETL Solutions through extensive data analysis, creating solution & data flow documents according to business requirements, generating reports to publish it to stakeholders through data visualization tools.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Capgemini – Discover Financial Services, US
Mississauga, Canada
12.2022 - Current
- Lead a team of analysts in conducting complex data analyses using SQL and Python to support strategic auditing initiatives, resulting in a 30% improvement in project turnaround times.
- Designed and implemented interactive dashboards in CASPER (an internal tool), enabling real-time compliance tracking of vendors and improving decision-making processes across departments. processes across departments.
- Created Python scripts for data cleaning and preprocessing, reducing data preparation time by 40%, and increasing overall productivity.
- Collaborated with cross-functional teams to define business requirements and translate them into analytical solutions, driving a 15% growth in operational efficiency.
- Involved in analysis of data, mappings with different systems, and guiding developers with the data mappings and requirements.
DATA ANALYST
TCS – Citi Bank
Toronto, Canada
09.2020 - 11.2022
- Conduct detailed analyses of financial data using MSSQL to identify and assess credit and market risk, leading to a 20% improvement in risk mitigation strategies.
- Created data ingestion scripts in Python to load data extracts from source to Data Lake, so that proper analysis can be carried out.
- Developed ETL pipelines using Ab Initio, ensuring data loading as per business standards to specialized data marts.
- Created custom data queries using Advanced SQL to meet the reporting needs of stakeholders.
- Trained a team of 15 resources in ETL solution design, data report generation, which helps in improving overall team output, and improved response time by 30%.
DATA ANALYST/ DATA ENGINEER
TCS –Sainsbury’s Supermarket
London, UK
10.2016 - 08.2020
- Inducted primarily to work with various stakeholders, including business users and SMEs, to understand analytical and operational reporting needs.
- Analysis of various campaign and segmentation data which increased the marketing strategy.
- Created data pipelines to ingest data into the AWS S3 and load into the warehouse platform in Snowflake using Ab Initio ETL.
- Migration of data flows from various legacy systems to a modern, cloud-based data and analytics platform.
- Practiced Agile Methodology by working in teams and used JIRA to plan and coordinate project tasks.
- Led a team of five to successfully deliver various aspects of projects during the tenure.
ETL DEVELOPER
TCS
Chennai, India
12.2011 - 10.2016
- Developed ETL packages using ab initio to extract, transform, and load data from multiple sources into a data warehouse.
- Resolved complex issues related to ETL process through debugging existing code or writing new programs.
- Implemented best practices while developing ETL packages like error handling, logging.
- Developed scripts for automating daily jobs like backups, reindexing.
- Performed troubleshooting of existing production jobs when needed.
Education
BACHELOR OF ENGINEERING - ELECTRONICS AND COMMUNICATIONS
Karunya University
INDIA01.2011
Skills
- SQL
- Data Analyst
- Python
- ETL
- Ab Initio
- Unix
- Excel
- MS SQL Server
- Snowflake
- AWS Services
- Unix
- Business Analysis
- Agile - Scrum
- Data Warehousing
- ETL development
Certification
- Snowflake - SnowPro Core Certification
- AWS Certified Solutions Architect Associate
- AWS Certified Developer Associate
- AWS Certified Sysops Administrator - Associate
Timeline
Senior Data Analyst
Capgemini – Discover Financial Services, US
12.2022 - Current
DATA ANALYST
TCS – Citi Bank
09.2020 - 11.2022
DATA ANALYST/ DATA ENGINEER
TCS –Sainsbury’s Supermarket
10.2016 - 08.2020
ETL DEVELOPER
TCS
12.2011 - 10.2016
- Snowflake - SnowPro Core Certification
- AWS Certified Solutions Architect Associate
- AWS Certified Developer Associate
- AWS Certified Sysops Administrator - Associate
BACHELOR OF ENGINEERING - ELECTRONICS AND COMMUNICATIONS
Karunya University
Similar Profiles
Justin SicienskiJustin Sicienski
Principal Product Manager (Commercial Payments) at Discover Global Network - Discover Financial ServicesPrincipal Product Manager (Commercial Payments) at Discover Global Network - Discover Financial Services
Essence OwoEssence Owo
Digital Account Manager at Discover Financial Services, DFSDigital Account Manager at Discover Financial Services, DFS
Allan GloverAllan Glover
Department Manager | CAR at Discover Financial Services, DFSDepartment Manager | CAR at Discover Financial Services, DFS