Prince Pastakiya
I am aData AnalystData Analyst & Analytics Engineer who builds scalable data pipelines and turns complex data into actionable business insights. Skilled in Databricks, PySpark, SQL, AWS, Azure, and BI Tools.
About Me
Get to Know Me Better
I’m a Data Analyst who builds scalable, analytics-ready data pipelines – and I speak the language of business intelligence. My work directly supports risk monitoring, fraud detection, churn analysis, and executive dashboards in financial services, telecom, and healthcare.
In my current role (Zennith Technologies):
- Design Databricks ELT pipelines processing 5TB+ of daily financial data
- Reduce batch processing time by 40% through Spark & cluster optimization
- Save 200+ hours/month by automating manual Excel reports (Python/VBA)
- Deliver Power BI dashboards that increased customer retention by 5% and campaign ROI by 10%
My technical toolkit:
Databricks, PySpark, SQL, Python, Delta Lake | AWS (S3, Glue, Redshift, Lambda) | Azure Data Factory | Power BI, Tableau | Excel (VBA, Power Query)
I hold an AWS Certified Solutions Architect – Associate certification and a BS in Computer Science from Troy University.
I’m currently open to Data Analyst, Analytics Engineer, or Data Engineer roles – remote or on-site, anywhere in the US.
Work Experience
My Professional Journey
Data Engineer – Analytics & Platforms
Zennith Technologies Inc.
•full-timeSummary:
Delivered enterprise-level ETL pipelines and BI solutions by transforming and analyzing large-scale financial transaction datasets using SQL, Databricks, and PySpark. Designed scalable data architectures that reduced processing time by 40% and enabled real-time analytics for 50+ business users across finance, risk, and marketing teams.
Key Responsibilities:
- Designed and optimized ELT pipelines processing 5TB+ of daily financial data, enabling real-time analytics and reporting for 50+ business users
- Built star schema data models (raw/refined/curated layers) and integrated them with Power BI, cutting time-to-insight from 2 days to 1 hour
- Implemented incremental ingestion with Auto Loader and Delta MERGE, eliminating 12+ hours of weekly manual reloads
- Maintained 100% data consistency for real-time dashboards by applying SCD Type 1 logic and automated reconciliation checks between source systems and Delta Lake
- Automated a manual Excel reconciliation report using Python and VBA, reducing a 4-hour daily task to 8 minutes and saving 200+ engineering hours per month
- Built Power BI dashboards for churn analysis and customer segmentation, increasing customer retention by 5% and campaign ROI by 10%
- Partnered with Risk, Fraud, and Product teams to translate business and regulatory requirements into actionable datasets
- Mentored junior engineers and established practical coding standards through code reviews and documentation
Achievements:
- Reduced batch processing time by ~40% and cloud costs by 20% through Spark job optimization, cluster tuning, and Z-ordering in Delta Lake
- Delivered near real-time dashboards improving executive decision-making and operational visibility
- Improved pipeline reliability by 30% through automated validation and monitoring scripts
- Cut reporting turnaround time by 50% for 50+ finance and marketing users
Skills & Expertise
A Comprehensive Overview of My Technical Skills and Tools
Ai Ml
6Backend
5Cloud
6Database
7Design
3Devops
6Frontend
3Other
5Soft Skills
6Testing
5Tools
6Education
My Academic Background
Bachelor of Science
Troy University
Computer Science
Comprehensive computer science education with a strong foundation in programming, data structures, databases, and software development. Coursework emphasized analytical problem-solving, system fundamentals, and practical application of computer science concepts, supporting a transition into data analytics, data engineering, and modern web technologies.
Achievements & Honors
- ▸Honors Scholarship Recipient, Troy University
- ▸Runner-up, Troy Hackathon 2024 (Web Development)
- ▸Demonstrated strong problem-solving and full-stack development skills in competitive team environment
Featured Projects
Some of My Best Projects
Climate Change Analytics – Global Monitoring Dashboard
Real‑Time Tracking of Climate Indicators, Extreme Weather & Economic Impact
Enterprise Data Warehouse & Analytics Platform
Enterprise data warehouse built using Medallion Architecture to transform ERP & CRM data into analytics-ready insights with optimized SQL models.
Certifications
Professional credentials and certifications
July 7, 2024
CERTIFICATE
for
AWS Certified Solutions Architect - Associate
Validates expertise in designing scalable, secure, and cost-efficient cloud solutions on AWS. Demonstrates strong understanding of core AWS services, architecture best practices, and cloud-native design.
Amazon Web Services
Credential ID:
0c21dccacb46490e9e4ba20bcf0b3e6d
March 20, 2024
CERTIFICATE
for
Google Data Analytics
Demonstrates practical knowledge of the end-to-end data analysis process, including data cleaning, analysis, visualization, and storytelling to support business decisions.
Coursera
Credential ID:
GCP-PCA-67890-2023
Achievements & Awards
Milestones and Recognitions
Featured Achievements
Data Warehouse Architecture & Implementation (MySQL, SQL)
GitHub
Recognized for independently designing and implementing a structured data warehouse, applying professional data modeling and optimized SQL queries to support scalable reporting.
Learn More
Runner-up — Troy Hackathon 2024 (Web Development)
Troy University
Achieved second place in the web development track by building a full-stack application under time constraints, demonstrating strong problem-solving and teamwork.
Learn More
AWS Certified Solutions Architect – Associate
Amazon Web Services (AWS)
Earned industry-recognized certification validating knowledge of cloud architecture, scalability, and security best practices.
Learn MoreHonors Scholarship Recipient
Troy University
Merit-based scholarship awarded for consistent academic excellence and strong performance in Computer Science coursework.
Learn MoreAll Achievements
Google Data Analytics Professional Certificate
February 2025
Completed hands-on training in data analysis, SQL, visualization, and business insights. Recognized for practical application of analytical skills.
Advanced Data Analytics & Dashboard Development (SQL, Visualization)
Microsoft PowerBI
August 2023
Demonstrated applied analytics skills by delivering professional dashboards that convert complex datasets into actionable insights for data-driven decision-making.
Get In Touch
Let’s connect and explore opportunities to work together.