Data Analytics Professional - SQL, Python, Power BI, DW Modeling

Rohan Ravi

Detroit, Michigan *********@*****.*** LinkedIn: Rohan-Chandran GitHub +1-224-***-**** Open To Relocation PROFESSIONAL SUMMARY

Dynamic and detail-oriented Data Analyst with 3+ years of experience in data analysis, data modelling, and dashboard development to deliver actionable business insights across eCommerce, retail, and operations domains. Skilled in SQL, Python, Power BI, and Excel, with expertise in designing optimized relational databases, building scalable data models and automating data workflows for improved efficiency. Proficient in data integration, cleansing, and validation from diverse sources including APIs, cloud storage, and ERP systems, ensuring accuracy and reliability of analytics. Experienced in creating interactive dashboards and visualizations to track KPIs, identify trends, and support data-driven decision-making. Adept at collaborating with cross-functional teams, translating complex datasets into clear, strategic insights that drive business growth and operational excellence.

EDUCATION

Master of Science, Information Systems – Data Analytics Central Michigan University GPA - 3.7 / 4.0 Aug 2023 - May 2025 Relevant Coursework: System Design, Project Management, Database Management Systems, Data Analytics, Machine Learning, Data Visualization and Reporting Bachelor of Technology, Electronics and Computer Engineering Jawaharlal Nehru Technological University Aug 2017 - May 2021 Relevant Coursework: Programming Languages, Operating Systems, Data Structures and Algorithms, Cloud Computing, Systems and Signals, TECHNICAL SKILLS

Languages: Java, Python (NumPy, Pandas, Matplotlib), C++, SQL, R, SSIS, SAS Database and Cloud: AWS (S3, Redshift, EC2, Glue), MySQL, Snowflake, Azure (Data Factory, Synapse), Google Big Query, DataBricks, PostgreSQL, Oracle Developer Tools: Git, Docker, Kubernetes, Visual Studio Code, Jupyter Notebooks, Microsoft Office ML and AI: Scikit-Learn, TensorFlow, PyTorch, A/B Testing, Predictive Modeling Data Visualization & BI Tools: Tableau, Power BI, Looker, AWS Quicksight, Microsoft Excel (VLOOKUP, HLOOKUP), SAS, Alteryx PROFESSIONAL EXPERIENCE

Graduate Research Assistant Central Michigan University Mount Pleasant, MI Jan 2024 – May 2025

• Developed complex SQL solutions using window functions, CTEs, and recursive CTEs to analyze longitudinal student performance data, generating insights that improved retention strategies and increased first-year success rates by 18%.

• Conducted in-depth root cause analysis with academic teams using SQL and Python, identifying key factors behind student course withdrawals, reducing withdrawal rates by 12% and increasing overall course completion.

• Created cohort analyses leveraging SQL and Python to track first-year student performance trends, presented actionable insights to policymakers, improving first-year student retention rates by 15% and informing strategic academic decisions. Data Analyst Tata Consultancy Services Hyderabad, India Nov 2021 – Jun 2023

• Cleaned and transformed 5M+ customer transaction records using SQL and Python, resolving data integrity issues and cutting processing time by 40%, which enhanced the marketing team’s ability to make data-driven decisions.

• Designed executive-facing Tableau dashboards for stakeholder reporting, aligned KPIs with teams, and delivered insights that improved leadership decisions by 25% and cut reporting time by 93% (3 days to 1 hour).

• Applied causal inference and multivariate analysis using ERP systems and Alteryx to identify revenue drivers across ticket sales and merchandise, optimizing strategies that contributed to a $50K uplift in semester revenue.

• Streamlined ETL pipelines and enhanced data integration with Snowflake, cutting data processing latency by 25% and boosting market responsiveness by enabling a 20% faster adaptation to business trends and customer needs.

• Collaborated with BI developers and business users to define data transformation logic, implement change data capture and create reusable data processing components.

• Monitored and optimized KPIs through automated dashboards and alerts, identifying anomalies and improving operational decision-making efficiency by 20%. Junior Data Analyst MatchWell Technologies Hyderabad, India Oct 2020 – Oct 2021

• Developed predictive models using Python and scikit-learn to forecast customer churn, retaining 150+ at-risk customers and boosting subscription renewals through targeted engagement and early intervention campaigns.

• Engineered AWS Redshift data pipelines by integrating 5+ data sources and optimizing queries, decreasing report generation time by 15 seconds per query and supporting 10+ internal team members with timely insights.

• Designed and implemented interactive Power BI dashboards and creating custom DAX with 10+ KPIs and drill-through features, reducing manual reporting time from 4 hours to 30 minutes and enhancing decision-making for two business units.

• Automated data validation workflows using SQL and Alteryx, ensuring HIPAA compliance by validating 50K+ healthcare records weekly, reducing data errors by 20%, and protecting sensitive patient information.

PROJECTS

Vehicle Inventory Data Management System Python, MySQL, Figma

• Developed a Python-based vehicle inventory system with user-friendly Figma interfaces, managing 500+ vehicles efficiently and tracking stock in real-time.

• Implemented secure login, role-based access, and real-time analytics dashboards, improving managerial monitoring and decision-making by 30%.

• Designed and optimized an MSSQL/PostgreSQL database integrated with Python backend, handling 1,000+ vehicle records and reducing retrieval time by 25%. Data Lake with Structured & Unstructured Data AWS/GCP/Azure, PySpark, Delta Lake, Airflow

• Architected a scalable data lake on S3/ADLS, storing 50M+ raw logs, social media, and transactional records efficiently.

• Processed large-scale structured and unstructured datasets using PySpark, creating downstream analytics datasets for multiple business teams. Subscription Plan Performance Analysis Apache Hive, Excel VBA, Power Query

• Queried large subscription datasets using HiveQL, uncovering actionable plan insights that improved retention metrics by 15% for executives.

• Automated Excel reports with VBA and Power Query, streamlining performance tracking and reducing manual reporting time substantially.

• Recommended subscription plan adjustments based on trend analysis, increasing user retention and contributing to measurable long-term revenue improvements. AI Model Performance and Customer Usage Analytics AWS, Spark, Snowflake, Power BI

• Consolidated 20M+ daily AI inference logs using Spark ETL pipelines into Snowflake, enabling reliable model performance and usage analysis.

• Visualized AI metrics through Quicksight dashboards, tracking precision, recall, and latency, reducing model optimization cycles by 35%.

• Enhanced customer satisfaction by 18% through analyzing usage trends and providing actionable insights to stakeholders for strategic decisions. EXTRACURRICULAR ACTIVITIES

Adobe Student Ambassador Central Michigan University

• Promoted Adobe tools, organized workshops, and guided peers in creative and analytics projects using Adobe suite applications.

Contact this candidate