Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Industryexperience
Disclaimer
Timeline
Manager

KHUSHBOO PATIL

Pune

Summary

Business Intelligence professional having 11+ years of experience in Data Analysis, Process Automation, User Requirements Analysis, Data Engineering, and Optimization.

Proficient in Alteryx, Tableau, and Data Warehousing (Teradata), with a focus on delivering actionable insights for business growth.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Manager

Mastercard
06.2023 - Current
  • Automated KPI reports for legal contracts using Alteryx and Tableau; managed deployment and user support.
  • Created dashboard to track assignment time and details per ticket, reported ticket quality ratings on SharePoint with Alteryx; created email notifications for US and Canada revenue accounting; scaled for other regions.
  • Developed data extracts and dashboard for reconciling data between SAM and Oracle.
    Provided technical breakdowns of user requirements; collaborated with global teams on data strategies and flows.
  • Documented reports for management and stakeholders, presented progress and annual plans in client meetings.
  • Accomplished multiple tasks within established timeframes.
  • Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
  • Cross-trained existing employees to maximize team agility and performance.

Process Manager

EClerx
06.2021 - 06.2023
  • Automated regulatory reports for clients and management, supported UAT and production deployments, and maintained systems; used Alteryx and OCR to integrate business requirements for Standard Chartered Bank.
  • Managed data collection and transformation; collaborated with global teams on data strategies and flows.
  • Trained 100+ global team members in Alteryx and earned EClerx's Rising Star and SCB's Employee of the Quarter awards.
  • Reduced production costs through optimization of resources and elimination of waste.

Assistant Manager

State Street Corporation
08.2018 - 05.2021
  • Creating Daily/Monthly/Quarterly reports for Clients and management committee.
  • Developed workflows for data integration and ad hoc reports
  • Managed high-volume data collection and transformations for various business units, including Asset Owners and Insurance, focusing on KPIs such as fund accounting and risk reporting. Produced reports to illustrate impacts at client, business, and regional levels.
  • Analyzed and integrated data using Alteryx, creating Tableau inputs for monthly and weekly reports that highlight trends, top responsible parties, and root causes.
  • Conducted employee performance evaluations, providing constructive feedback for growth and development.
  • Facilitated team-building activities, enhancing team cohesion and morale.

Consultant

Capgemini
10.2012 - 08.2018
  • Analyzed business requirements and guided the design team in implementing data transformation logic before loading into target tables.
  • Experienced in full SDLC: requirements gathering, development, testing, deployment, and support.
  • Served as SPOC for design, build, and test teams, resolving requirement-related queries (up to Teradata 15).
  • Conducted ETL testing including test planning, case design, data prep, execution, defect logging, and reporting using HP QC.
  • Facilitated data requirement meetings, resolved conflicts, and made decisions on Source Master Data by translating business level documents to low level mappings.
  • Developed source-to-target data mapping sheets and managed Logical to Physical Data Model mapping.
  • Knowledgeable in Star-Schema, Snowflake Schema, Fact and Dimension tables, and slowly changing dimensions.
  • Created and analyzed SQL queries in Teradata; managed technical risks and deployments using GIT and JIRA.
  • Performed unit testing, supported UAT, and analyzed data in CDW; optimized code based on high-level mapping documents.
  • Collaborated with BAs, data modelers, and designers; reported status in Daily Scrums, and handled post-deployment sanity and smoke tests.

Education

B.E(Information Technology) -

Sagar Institute of Research & Technology (RGTU)
Madhya Pradesh
06.2012

Higher Secondary School (12th) -

Jawaharlal Nehru School
Madhya Pradesh
08.2008

High School (10th) -

Jawaharlal Nehru School
Madhya Pradesh
06.2006

Skills

  • Alteryx (Designer and server), Tableau dashboards, Teradata15 (SQL assistant and Studio), SQL writing, Optimization/Debugging/Performance Tuning, Data Warehousing ,Oracle (toad) SQL database (SSMS) connectivity, Software Development life cycle (SDLC), Requirement Gathering, Data Analysis, ETL Testing(STLC) with using HP QC , Defect monitoring, SharePoint (lists and libraries), Agile and Waterfall working approach, Project management using JIRA, Postman, Microsoft Office (Excel,Powerpoint,Word), Json read, Power BI (beginner)
  • Team Leadership, Project Management, Hiring and Training, Flexibility, Verbal and written communication, People management, Stakeholder management, Work Planning , Prioritization and tracking
    Process Improvement, Global experience

Websites

Certification

  • Alteryx Foundational Micro Credential
  • Alteryx Core Certified (Achieved in 2023)

Personal Information

  • Notice Period: 30 days
  • Date of Birth: 01/06/1990
  • Marital Status: Married

Industryexperience

Banking, Legal contracts

Disclaimer

The information furnished above is true to the best of my knowledge.

Timeline

Manager

Mastercard
06.2023 - Current

Process Manager

EClerx
06.2021 - 06.2023

Assistant Manager

State Street Corporation
08.2018 - 05.2021

Consultant

Capgemini
10.2012 - 08.2018

B.E(Information Technology) -

Sagar Institute of Research & Technology (RGTU)

Higher Secondary School (12th) -

Jawaharlal Nehru School

High School (10th) -

Jawaharlal Nehru School

Similar Profiles

CREATE PROFILE
KHUSHBOO PATIL