Hello, I'm
Mohit Taparia
About Me
"The goal is to turn data into information, and information into insight."
— Carly Fiorina
I am a Data & Product Analyst with over 3 years of experience in analytics, data engineering, and BI development. I hold a Masters in Data Science from the University of Arizona, where I specialized in bridging the gap between complex raw data and actionable business insights.
My expertise lies in building end-to-end ETL workflows, optimizing SQL pipelines, and designing real-time dashboards using tools like Tableau, Alteryx, and Python. I thrive on solving real-world operational problems and driving efficiency through automation.
What I Do
Bridging the gap between engineering and analytics to deliver high-quality data solutions.
Data Engineering
Building scalable ETL pipelines and automating workflows using SQL, Alteryx, and IBM DataStage.
Business Intelligence
Designing interactive dashboards in Tableau & Power BI to drive operational and financial insights.
Data Analytics
Transforming complex raw data into actionable KPIs and strategic business reports.
Current Focus
Financial Data Systems
Developing real-time reconciliation dashboards and transaction monitoring frameworks.
Pipeline Automation
Orchestrating automated data loads with Control-M to reduce manual reporting effort by 70%.
Data Quality Assurance
Implementing robust validation frameworks to ensure accuracy across global systems.
My Journey Timeline
First Citizens BankCURRENT
Data Analyst / Data Engineer
- Engineering end-to-end ETL workflows in SQL, Alteryx, and IBM DataStage.
- Building automated Control-M jobs to orchestrate nightly data loads, reducing manual effort by 70%.
- Designing Real-time Reconciliation Dashboards in Tableau for Core, FIS, and Fraud data.
University of ArizonaGRADUATED
Masters in Data Science
- Graduated with a GPA of 3.84.
- Specialized in bridging the gap between raw data and actionable business insights.
- Focus on Machine Learning, Big Data, and Cloud Computing.
DXC Technology
Data Analyst II
- Automated enterprise reporting pipelines using SQL and Power BI, saving $2M annually.
- Optimized SQL scripts and ETL workflows, improving data retrieval speed by 40%.
- Implemented data validation frameworks to ensure global compliance.
Software Engineer
Associate Software Engineer
- Developed task-tracking platforms for 5,000+ employees to increase process visibility.
- Optimized complex MySQL queries, cutting data retrieval time by 30%.
- Automated SQL and Excel reports to minimize manual dependencies.
Knowledge Institute of Technology
B.E. in Electronics & Communication
- Graduated with a GPA of 3.62.
- Built a strong foundation in engineering logic and analytical problem solving.
Featured Projects
A selection of my work in Data Science, Machine Learning, and Analytics.
Formula 1 Race Prediction
Constructed a Random Forest model achieving 95% accuracy in predicting F1 race outcomes. Engineered features from 10+ variables (weather, grid position, etc.) and built an interactive Shiny dashboard for result visualization.
Cricket Score Prediction
Developed a machine learning model to predict first-innings cricket scores based on current match conditions (runs, wickets, overs). Utilized Ridge Regression to minimize error and deployed the model using Flask.
Retail Banking Solution
A predictive machine learning model to optimize telephonic marketing campaigns. Analyzed client demographics (age, job, credit) to predict term deposit subscriptions, helping banks target high-conversion customers.
Sales Analysis Dashboard
Exploratory Data Analysis (EDA) on large-scale sales datasets. Utilized Python visualization libraries to uncover customer purchase behaviors, seasonal trends, and top-performing product categories.
Real-time Face Mask Detection
Developed a computer vision system capable of detecting face masks in real-time video streams. Implemented deep learning techniques to ensure safety compliance during the pandemic.
My Resume
Download My ResumeMy Education
University of Arizona
Master of Science (M.S.)
Data Science
Anna University
Bachelor of Engineering (B.E)
Electronics and Communication Engineering
Work Experience
Data Analyst / Data Engineer
First Citizens Bank
★ Key Achievements
- →Engineered end-to-end ETL workflows in SQL, Alteryx, and IBM DataStage, transforming raw data into analytical views and improving data quality by 30%.
- →Built automated Control-M jobs to orchestrate nightly data loads, reducing manual effort by 70% and ensuring on-time delivery.
- →Designed RTP Reconciliation Dashboards in Tableau for Core, FIS, and Fraud data, accelerating issue resolution by 3X.
- →Developed real-time KPI metrics and transaction monitoring frameworks, enhancing reconciliation accuracy by 35%.
Tools & Technologies
Key Skills
Data Analyst II
DXC Technology
★ Key Achievements
- →Automated enterprise-level reporting pipelines using SQL and Power BI, reducing manual processes and saving $2M annually.
- →Designed and optimized SQL scripts and ETL workflows, improving data retrieval speed by 40% across global systems.
- →Built Power BI dashboards for 10+ client applications, providing real-time insights that improved decision-making efficiency by 25%.
- →Implemented data validation frameworks, reducing reporting errors by 15% and ensuring compliance across regions.
Tools & Technologies
Key Skills
Associate Software Engineer
Tech Company
★ Key Achievements
- →Developed a task-tracking platform for 5,000+ employees, increasing process visibility and completion rates.
- →Optimized complex MySQL queries, enhancing data reliability by cutting data retrieval time by 30%.
- →Automated SQL and Excel reports, saving $35K annually by minimizing manual reporting dependencies.
Tools & Technologies
Key Skills
Technical Expertise
Tools and technologies I use to drive data decisions.
Licenses & Certifications
Validation of my technical expertise in Cloud, Data Engineering, and Analytics.
Microsoft Certified: Azure Fundamentals
Microsoft
Snowflake Hands-On Essentials
Snowflake
Oracle Certified Foundations Associate (Java)
Oracle
Get In Touch
Let's Connect!
If you're looking for a motivated, adaptable, and skilled data professional, I'd love to hear from you.