Data Analyst Information Systems

MOHIT JAIN

240-***-**** • *******@***.*** • linkedin.com/in/mohit-2702-jain • College Park

EDUCATION

University of Maryland, Robert H. Smith School of Business Aug 2023 – Dec 2024 Master of Science, Information Systems, GPA 3.8/4.0 Related Coursework: Finance Information Systems, Business Process Analysis, Predictive Analytics, Big Data MediCaps University Aug 2017 – May 2021

Bachelor of Technology, Electronics & Communication Engineering, GPA 3.7/4.0 Related Coursework: Data Analytics, Data Structures, Statistics, Project Management, Data Models WORK EXPERIENCE

University of Maryland, College Park, MD, USA September 2023 – Present Graduate Assistant - Data Analyst

● Implemented data transformation techniques with Microsoft Excel, utilizing VBA, pivot tables, and array functions for process improvement, cutting manual workload by 45% and boosting data accuracy by 30%.

● Enhanced operational efficiency by 15% through analysis of large-scale data sets using SQL and Python, optimizing shift scheduling, resource allocation, and establishing KPIs for actionable insights

● Designed and maintained interactive Tableau dashboards, enabling real-time data visualization and data-driven decision-making for university departments, boosting reporting efficiency by 20%. Tata Consultancy Services, Pune, MH, India May 2021 – July 2023 Data Analyst

● Engineered real-time Power BI dashboards for stakeholders across cross-functional teams, tracking essential KPIs such as comment actions and response times, enhancing data-driven decision-making, and increasing reporting efficiency by 30%.

● Directed the project lifecycle with Agile methodologies, leading sprint planning, scoping changes, and documenting user stories, coordinating teams via Jira, achieving a 30% faster completion rate.

● Led a team of 3 analysts to implement an AI-driven moderation system using AWS Lambda, boosting the moderation rate by 40% through machine learning and predictive modeling techniques.

● Collaborated with the database team to implement optimized indexing and query techniques, reducing expenses by 50%, and improving performance through strategic cluster upgrades. Techsolvo, Indore, MP, India Jun 2020 – Apr 2021

Business Analyst Intern

● Automated data collection, validation, and integration into the data warehouse with a Python script, improving data processing efficiency by 45% and enhancing data quality for BI analysis.

● Designed and implemented data pipelines, reducing data processing time by 50%, enabling streamlined data flow, and supporting price volatility insights through EDA, time series analysis, and outlier detection.

● Built a POC Machine Learning model using Scikit-learn, achieving 85% accuracy in price prediction, enhancing forecasting capabilities and decision support through effective data modeling. SKILLS

Data Analysis: Python, SQL, R, Tableau, Power BI, Microsoft Excel (VBA, pivot tables), SAS Data Science: Regression Analysis, Statistical Analysis, Time Series Analysis, Financial Analysis, Risk Analysis, Data Modelling, ETL, Data Warehousing, Machine Learning, Hadoop Databases & Cloud: PostgreSQL, MySQL, MongoDB, NoSQL, AWS (DynamoDB, Redshift, Quicksight, EC2) Project Management & Tools: Git, Jira, Confluence, Agile, Google Suite, Microsoft Office PROJECTS

Predictive Analysis of TCS Stock Market Data

● Conducted statistical and market analysis on 10 years of TCS stock data using Pandas, NumPy, and Matplotlib, performing time series analysis to derive key performance metrics, inform financial forecasting, and improve investment strategies.

● Created a supervised machine learning classifier, processing over 10,000 data points using feature engineering techniques to predict trading calls with 90% accuracy, significantly enhancing decision support capabilities. CERTIFICATIONS

● AWS Certified Cloud Practitioner

Contact this candidate