Summary
Overview
Work History
Education
Skills
Projects
Certification
Technical Proficiencies
Timeline
Generic

Tirth Panchal

Dallas,USA

Summary

  • Experienced Data Analyst with over 5 years of expertise in data engineering, complex data analysis, and deriving actionable insights.
  • Proficient in SQL, Python, and R, with strong skills in statistical analysis, forecasting, and predictive modeling.
  • Adept at collaborating with stakeholders and cross-functional teams to achieve business objectives.
  • Proven track record in identifying process improvements and cost-optimization opportunities through data-driven, problem-solving, and critical-thinking strategies.
  • Skilled in designing efficient data pipelines and managing data on both on-premises and cloud platforms.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Sr. Data Analyst

CVS Health
Dallas, Texas
09.2023 - Current
  • Streamlining Data Processing Operations: Spearheaded the implementation of automated ETL pipelines, optimizing data extraction, and achieved a remarkable 400% efficiency in reporting turnaround using the Google Cloud Ecosystem.
  • Process Enhancement and Strategic Planning: Engaged with senior leaders and stakeholders to identify key areas for enhancing system functionalities and future innovation within the departmental hierarchy inside the Five9 instance of Verint.
  • Advanced SQL Optimization and Reporting Enhancement: Delved into extensive, disparate datasets encompassing call recordings and screen captures, scrutinizing business KPIs to unveil actionable insights for critical decision-making, facilitated by comprehensive dashboarding in Microsoft Power BI.
  • Salesforce Sandbox Ticket Management Excellence: Exhibited unwavering consistency in achieving a 100% resolution rate within SLA parameters, effectively mitigating operational disruptions, and ensuring seamless service delivery to customers.

Data Analyst

CBRE
Dallas, Texas
06.2022 - 04.2023
  • Partnership and Stakeholder Engagement: Partnered with senior executives to gather and validate data, ensuring accuracy, to effectively translate data insights to non-technical audiences.
  • Advanced Analysis for Business Challenges: Optimized CBRE's Premium Capacity Subscription data to identify areas of improvement in refresh failures and durations, delivering a notable average daily time savings of 18 minutes, leveraging Microsoft Power BI and Power Automate.
  • API Integration for Cost Reduction: Deployed APIs to assess the age of inactive subscriptions, which led to a 20% reduction in cost for the capacity inventory.
  • Data Mapping and ETL: I teamed up with Data Engineers on data mapping and ETL operations using copy activity pipelines in Azure Data Factory to improve visibility by 45%.
  • Data Consolidation and T-SQL Scripting: Consolidated data from ServiceNow incidents and wrote T-SQL scripts for user-defined functions and stored procedures on Azure Synapse Analytics, which resulted in efficient data management.

Sr. Data Analyst

Precision Engineers
Mumbai, India
08.2019 - 07.2021
  • Automated ETL Workflows: Implemented automated ETL workflows using Alteryx to optimize data management for daily banking transaction data and insurance claims records, reducing reporting time by 50% to improve data accuracy.
  • Predictive Modeling for Business Strategies: Led the development of predictive models using Dataiku to anticipate customer churn in the insurance sector, for proactive retention strategies to be implemented, and reducing customer attrition by 12%.
  • Resolution of User Interaction and Registration Issues: Managed mission-critical user interaction and registration issues for 120,000 users. Implemented scripts in SQL Server and applied problem-solving skills, ensuring an optimal customer experience, and addressing any obstacles that may hinder customer engagement.
  • Price Elasticity and Cost Control Analysis for Optimal Profit: Executed an in-depth price elasticity and cost control analysis for multiple stores using the MS Excel Solver tool, optimizing pricing strategies, and uncovering cost-saving opportunities. Drove a 9% profit increase, maximizing revenue, and sustaining a competitive market position.

Data Analyst

Precision Engineers
Mumbai, India
08.2018 - 07.2019
  • Cross-Functional Collaboration: Partnered with cross-functional marketing teams to present KPIs for ad campaign metrics, utilizing Google Analytics to provide insights into customer demographics and campaign effectiveness.
  • Technical Documentation: Developed comprehensive documentation for data validation processes, campaign performance analysis, and anomaly detection methodologies, ensuring consistency and cross-team knowledge sharing.
  • Data Quality Assurance: Assisted senior developers in validating and cleaning a large dataset of customer transaction records to flag irregularities in transaction amounts, and performed outlier identification to identify and investigate potential data anomalies.

Education

Master of Science - Information Technology Management

The University of Texas At Dallas
USA

Bachelor of Engineering - Electronics and Telecommunication

The University of Mumbai
India

Skills

  • Data analysis
  • Data visualization
  • Business intelligence
  • Stakeholder engagement
  • Cross-functional collaboration
  • Predictive modeling
  • Data quality assurance
  • Project management
  • Technical documentation
  • Effective communication
  • Problem solving
  • Strategic planning
  • Business solutions development
  • Business strategy
  • Analyze trends
  • Problem-solving abilities

Projects

Cooperative Agro-Farming Management System 

  • Dataset Preprocessing with Python Libraries: Transformed a large dataset comprising 59,090 tuples. This dataset presented various challenges, including null and irregular values. Leveraged Python libraries such as NumPy and Pandas, to implement robust data cleaning for handling missing and inconsistent data.
  • Resolving Complex SQL Queries and Designed Tableau Dashboard: Expertize SQL query solution for 200+ commodities' inflation analysis, providing valuable insights for pricing, inventory, and market competitiveness. Designed intuitive dashboard, enabling users to identify unusual trends, and seize lucrative opportunities.

Certification

  • Google Universal Analytics Essential Training
  • Advanced Big Query
  • Google Analytics - Google
  • Alteryx Designer Core
  • Modern-day Big Data Analytics
  • Professional Reporting using Power BI
  • Data Management and Governance

Technical Proficiencies

  • Languages and Databases - Python, R, MySQL, PostgreSQL, TSQL, SQL Server, Azure Synapse, Google Big Query, Teradata, Amazon Redshift, Snowflake, Oracle, MS Access, EPIC (Chronicles, Clarity, Caboodle)
  • Packages - Pandas, NumPy, MatplotLib, SeaBorn, TensorFlow, Scikit-Learn
  • Data Engineering Tools - Alteryx, Azure Data Factory, Azure Databricks, Dataiku, Google Cloud Data Flow, AWS Glue, Amazon Athena, Informatica
  • Data Visualization Tools - PowerBI, Tableau, Adobe Analytics, Spotfire, Google Analytics, Qlik Sense, SAP Analytics, Looker
  • Big Data Technologies - Spark, Hive, Hadoop, Pig, MapReduce, Apache Kafka, Apache Airflow, Impala, Flume, Sqoop
  • ML Techniques - Clustering, KNN, Predictive Modeling, Deep Learning, Regression, Logistic Regression
  • Project Management - SDLC, Agile, Waterfall, Scrum, MS Project, JIRA, Smartsheet, Kanbanize, Trello, Monday.com,
  • Business Intelligence and Operations - SLA Management, Stakeholder Management, Adaptability, Technical Documentation, Incident and Issue Tracking, AI literacy
  • Other proficiencies - SSIS, SSAS, SSRS, DAX, M, ServiceNow, PM Board Analytics, HR and People Analytics
  • Core Values - Strive for Excellence, Act with Integrity, Continuous Improvement, Teamwork and Collaboration

Timeline

Sr. Data Analyst

CVS Health
09.2023 - Current

Data Analyst

CBRE
06.2022 - 04.2023

Sr. Data Analyst

Precision Engineers
08.2019 - 07.2021

Data Analyst

Precision Engineers
08.2018 - 07.2019

Master of Science - Information Technology Management

The University of Texas At Dallas

Bachelor of Engineering - Electronics and Telecommunication

The University of Mumbai

Similar Profiles

CREATE PROFILE
Tirth Panchal