Dinesh Prajapati — Business Analyst | Data Engineering & Analytics

About Me

Turning complex data into
competitive advantage

16+ Years of
Experience

Business Analyst & Data Consultant with 16+ years delivering AI-powered, production-ready solutions — from ETL pipelines and cloud platforms to ML models and executive dashboards.

As a freelancer and consultant, I develop scalable data solutions that simplify business processes, sharpen decision-making, and drive measurable growth. My expertise spans the full data lifecycle — architecture, engineering, machine learning, and analytics — always anchored to business outcomes, not just technical output.

Let's collaborate to unlock the full potential of your data. Reach out today — and let's make data work for you.

Name Dinesh Prajapati

Email shaan.dinesh@gmail.com

Availability Open to opportunities

Download CV LinkedIn Profile

What I Bring to the Table

SQL & Data Engineering

End-to-end ETL pipelines, warehouse architecture, and high-throughput data processing across SQL Server, Oracle, and Python — at production scale.

Machine Learning & AI

Predictive models, NLP pipelines, and anomaly detection using scikit-learn, TensorFlow, and PyTorch — translating model outputs into real business decisions.

Cloud & Big Data

Scalable lake-house architectures on Azure, AWS, and GCP — Databricks, Synapse, and Delta Lake with CI/CD, RBAC, and autoscaling built in from day one.

BI & Visualisation

Executive dashboards and self-service analytics in Tableau and Power BI, backed by SSAS semantic models and automated real-time data refreshes.

Career

Work Experience

Business Analyst Lead

American Express

Sep 2016 — Present Gurgaon, India

Built ML-based forecasting models to generate business insights and drive operational decisions.
Designed and maintained ETL pipelines connecting Avaya, eWFM Aspect, Oracle RightNow, and Genesys sources into a centralised server environment via SSIS.
Performed data integrity checks, archiving, and routine data loads; corrected quality gaps in production data.
Developed VBA programs to auto-update Excel workbooks and built VB.net database application forms backed by SQL stored procedures.
Delivered Tableau / Excel dashboards for call-center workforce analytics and KPI reporting.

SQLSSISPythonHiveTableauVBASplunkMS Access

Senior Associate

MetLife

Sep 2014 — Sep 2016 Noida, India

Developed VBA-based automation tools that significantly increased productivity and reduced reporting errors.
Created and managed historical data processes; produced monthly and quarterly reports using MS Access and SQL stored procedures.

VBAMS AccessSQL

Senior MIS Executive

DishTV

Jun 2013 — Sep 2014 India

Automated report generation using VBA, reducing manual effort for daily and periodic reporting.
Managed complex multi-source SQL Server queries for reporting and data manipulation in MS Access.

SQL ServerVBAMS Access

Senior MIS

Vcare Corporation

Feb 2008 — May 2013 Noida, India

Managed historical data repositories and produced operational reporting and analysis for call-center management.
Implemented VBA automation to streamline recurring reporting workflows.

VBASQLReporting

Education

Academic background and foundation in computer science and data analysis.

Master of Science — MSc (Computer Science)

Maharshi Dayanand University, Rohtak

Master of Computer Applications — MCA

Swami Vivekananda Subharti University, Meerut

Certifications & Achievements

Commitment to continuous learning and professional development.

Advanced Certification in Data Science & AI

Indian Institute of Technology, Madras

Tableau Data Scientist Certification

Tableau

Tableau Developer Certification

Tableau

Executive PG Certification in Cloud Computing & DevOps

Indian Institute of Technology, Roorkee

GitHub for Data Scientists

GitHub

Executive PG Certification in Full Stack Web Development

Indian Institute of Technology, Roorkee

Hi, I'm Dinesh
Prajapati