Summary
Overview
Work History
Education
Skills
Software
Certification
Timeline
Generic
Chaitanya Patil

Chaitanya Patil

Pune

Summary

Seasoned Business Intelligence Analyst with a proven track record of delivering valuable and actionable data to employers for over 11 years, resulting in significant profit growth. Committed to assisting stakeholders in achieving maximum efficiency through the implementation of technology solutions. Possesses a creative mindset and the ability to solve problems in real-time, excelling in architecting innovative solutions to address complex challenges.

Overview

12
12
years of professional experience
5
5
years of post-secondary education
2
2
Certifications
3
3
Languages

Work History

Assistant Vice President CRES MI CoE

Barclays
04.2022 - Current

responsible for designing and developing end-to-end data analytics solutions, including data extraction, transformation, and visualization. This role combines expertise in both Tableau for creating interactive and insightful dashboards and Alteryx for automating data preparation, transformation, and integration. The developer will work closely with business analysts, data engineers, and stakeholders to deliver data-driven insights and automated data workflows that support decision-making and business operations.

Key Responsibilities:

Skills and Qualifications:

  • Proficiency in Tableau:Extensive experience in developing Tableau reports, dashboards, and visualizations.
    Ability to design complex Tableau calculations, filters, and aggregations.
    Familiarity with Tableau Server or Tableau Online for deployment and user management.
  • Proficiency in Alteryx:Strong experience in building and optimizing Alteryx workflows for ETL processes, data transformation, and automation.
    Familiarity with Alteryx Server and Alteryx Gallery for workflow deployment and scheduling.
  • Data Integration & Querying:Strong SQL skills for querying and integrating data from relational databases.
    Experience working with various data sources (SQL, Excel, CSV, APIs, cloud data platforms).
    Knowledge of integrating Alteryx workflows with Tableau for automated data preparation.
  • Data Analysis & Performance Optimization:Ability to analyze large datasets and optimize data pipelines for performance.
    Experience improving Tableau workbook performance and troubleshooting slow queries.
  • Communication & Collaboration:Strong communication skills for interacting with business stakeholders and technical teams.
    Ability to translate business requirements into technical solutions and articulate complex data issues to non-technical users.

Senior Data Analyst

Credit Suisse
08.2019 - Current

Alteryx Developer : Automated around 20+ processes through Alteryx and delivered web based solutions to user resulted in saving of 3.5 FTE. Also trained stakeholders from each team. Below are some Major Deliverables:

  • Posting Rule Simulator: Developed alteryx based Simulator to Design, Validate and Extract complex Posting Rules for Detailed Ledger resulted in saving of 1 FTE
  • 3 - Way Reconciliation : Developed reconciler which populates data from 4 data sources and compare based on key resulting in reduction of manual efforts to ~10 mins from 6 hours.
  • Data Extraction and Churning: Large volume of Data Extraction for analysis purpose and churning of data as per business need. Also, maintaining key metrics for project.



R Developer :

  • IC Topside Automation : Automated very critical and complex process through R which resulted in Saving of 1 FTE
  • ICLC L5 L6 Reporting: Developed R based solution which generates L5 L6 reports resulted in saving of 20 hours/Month on critical business days.

Qlik and Tableau Developer :

  • COO Headcount Dashboard : Automated COO Head count dashboard in Qlik-Sense which had Drill Down functionality.
  • Products Performance Dashboards : Automated Performance dashboards for CS products for higher management in Qlik.
  • Fund Allocation Dashboards: Automated Sector-wise, Country-wise and region-wise fund allocation dashboards in Tableau.

Data Analyst

Tata Consultancy Services
02.2013 - 07.2019
  • Azure Data Factory Developer: Data from around 25 source systems being ingested in Datalake Gen1 using Data Factory as Mirror Layer. Built an external tables on top of it.
  • Client Reporting Analyst: Developed and maintained critical Client reports and Marketing material. Reporting Tool : FMC, Xinnovation, DWH
  • Report Rebranding Projects : Was responsible for rebranding of ~1200 client reports and internal reports for SSGA.
  • Data Analyst : Supported around 22 application for Portfolio Management team. Worked in Master data Management team . Tools: Salesforce, Tamale, Bloomberg, Factset

Education

Bachelor of Engineering - Electronics & Telecommunication

KIT's College of Engineering
06.2008 - 06.2012

Certificate in Business Analytics - Business Analytics, Data Science

Indian School of Business (ISB)
02.2016 - 02.2017

Skills

Alteryx

Tableau

Data Governance

Process Excellence

Automation

MS Access

R

SQL

Powerapps

Excel

Azure data factory

Software

Alteryx,Tableau, MS Access,R Studio, Anaconda, SQL Developer

Certification

Six Sigma Green Belt

Timeline

Assistant Vice President CRES MI CoE

Barclays
04.2022 - Current

Senior Data Analyst

Credit Suisse
08.2019 - Current

Certificate in Business Analytics - Business Analytics, Data Science

Indian School of Business (ISB)
02.2016 - 02.2017

Data Analyst

Tata Consultancy Services
02.2013 - 07.2019

Bachelor of Engineering - Electronics & Telecommunication

KIT's College of Engineering
06.2008 - 06.2012
Chaitanya Patil