I am a Data Analyst & Analytics Engineer with a Master’s in Information Systems, specializing in turning raw data into actionable business insights. I bridge data and strategy using Python, SQL, and Power BI to drive revenue recovery and automate complex ETL pipelines. I have delivered impact across Syracuse University, TCS, and Orion Studios by building automated data pipelines, dashboards, and governance models that enhance reporting speed, ensure data consistency, and support executive decision-making. I am open to relocation across the United States and enjoy solving complex data problems that enable smarter decisions.

AMAN KESKAR

I am a Data Analyst & Analytics Engineer with a Master’s in Information Systems, specializing in turning raw data into actionable business insights. I bridge data and strategy using Python, SQL, and Power BI to drive revenue recovery and automate complex ETL pipelines. I have delivered impact across Syracuse University, TCS, and Orion Studios by building automated data pipelines, dashboards, and governance models that enhance reporting speed, ensure data consistency, and support executive decision-making. I am open to relocation across the United States and enjoy solving complex data problems that enable smarter decisions.

Available to hire

I am a Data Analyst & Analytics Engineer with a Master’s in Information Systems, specializing in turning raw data into actionable business insights. I bridge data and strategy using Python, SQL, and Power BI to drive revenue recovery and automate complex ETL pipelines.

I have delivered impact across Syracuse University, TCS, and Orion Studios by building automated data pipelines, dashboards, and governance models that enhance reporting speed, ensure data consistency, and support executive decision-making. I am open to relocation across the United States and enjoy solving complex data problems that enable smarter decisions.

See more

Language

English
Fluent

Work Experience

Research Data Analyst at Syracuse University
June 1, 2025 - Present
Engineered automated budget and grant utilization reports by integrating data from disparate university systems, reducing monthly reporting cycle time by 50%. Developed a predictive resource allocation model to identify under-utilized department funds, improving budget efficiency by 15%. Designed and maintained SQL-based data pipelines to track research KPIs, ensuring data consistency across administrative dashboards for senior leadership.
Data Analyst at Tata Consultancy Services (TCS)
July 1, 2022 - July 1, 2023
Conducted granular forensic analysis using advanced SQL (Window Functions, CTEs) to uncover $1.2M in revenue leakage, collaborating with operations to implement controls and recover lost margin. Engineered dynamic financial dashboards in Power BI and Excel, optimizing SQL queries to reduce load times by 86% (from 4 hours to 30 mins) and enabling real-time variance analysis. Developed automated data governance models with Row-Level Security (RLS) for 5 cross-functional teams, reducing ad-hoc data requests by 60% while ensuring audit compliance.
Data Analyst at Orion Studios
March 1, 2020 - April 1, 2022
Consolidated 800K+ transaction records using Python (Pandas) and SQL to model engagement trends, providing quantitative inputs for strategic content forecasting. Automated weekly financial reporting pipelines using Power Query and VBA, reducing manual data preparation time by 30% and eliminating manual entry errors. Built interactive Tableau dashboards to visualize Campaign ROI and User Acquisition Cost (CAC), accelerating executive decision-making cycles by 25%.

Education

Master of Science in Information Systems (CAS in Data Science) at Syracuse University
January 11, 2030 - May 1, 2025
Bachelor of Engineering in Computer Engineering at Savitribai Phule Pune University
January 11, 2030 - June 1, 2022

Qualifications

Add your qualifications or awards here.

Industry Experience

Software & Internet, Education, Professional Services, Media & Entertainment