Project Schedule Visualizer
→
Summary
Designed a project planning simulator mimicking MS Project scheduling logic, enabling time impact analysis through interactive dashboards.
About
Highly analytical Data Analyst with 4 years of experience transforming complex datasets into actionable insights to drive business outcomes. Expert in SQL, Power BI, Python, and Excel, with a strong foundation in data modeling, reporting automation, and visualization. Proven ability to streamline processes, collaborate cross-functionally, and deliver data-driven solutions that significantly impact organizational efficiency and decision-making.
Work
Eastern Illinois University
|Research Assistant - Department of Computer Science
Charleston, IL, US
→
Summary
Led data analysis and visualization efforts for faculty-led research projects, ensuring data accuracy and supporting academic publications.
Highlights
Conducted statistical data analysis for faculty-led research projects utilizing SQL, Python (Pandas), and Excel, informing research directions and outcomes.
Developed automated Power BI dashboards to visualize enrollment trends and research outputs, enhancing data accessibility and insights.
Cleaned and organized large datasets from institutional and survey sources, improving data accuracy by 30%.
Supported publication efforts by generating charts, tables, and insights for technical papers and presentations, contributing to academic dissemination.
Designed Qualtrics survey instruments and processed responses for custom analysis in R and Python, including sentiment classification using Python scripts.
Vsmart Minds and Solutions
|Data Analyst
Hyderabad, Telangana, India
→
Summary
Developed and automated SQL-based reporting systems and dashboards, significantly enhancing project tracking and resource management efficiency.
Highlights
Developed SQL-based reporting systems to track project progress, resource utilization, and timelines, improving operational visibility and control.
Automated recurring project reports using Power BI and Alteryx, reducing manual effort by 60% and increasing reporting efficiency.
Designed Gantt charts and dashboards to support project managers in identifying risks and dependencies, enabling proactive issue resolution.
Led schedule variance analysis and delivered key performance indicators (KPIs) for weekly stakeholder reviews, providing critical insights for decision-making.
Integrated SharePoint and Excel data sources, cutting data preparation time by 50% and facilitating self-service analytics through training sessions on BI tools.
Tech Mahindra
|Systems Engineer Intern
Hyderabad, Telangana, India
→
Summary
Supported development teams through technical documentation, resource allocation, and cross-functional coordination to ensure project alignment.
Highlights
Assisted with technical documentation and resource allocation for development teams, contributing to improved project efficiency and resource utilization.
Coordinated between clients and internal teams to gather requirement timelines and updates, facilitating smooth project execution and stakeholder alignment.
Utilized ticketing and tracking systems such as Jira and ServiceNow to monitor team task flows and ensure timely progress on deliverables.
Collaborated with the Change Advisory Board to secure approvals for infrastructure changes, maintaining operational continuity and compliance.
Education
Eastern Illinois University
Charleston, IL, United States of America
→
Master's
Computer Science
Grade: 4.0/4.0
JNTU, India
Hyderabad, Telangana, India
→
Bachelor of Technology
Information Technology
Grade: 7.2/10.00
Certificates
Foundations of Project Scheduling
Issued By
Coursera
Microsoft Certified: Power BI Data Analyst Associate
Issued By
Microsoft
Excel for Business
Issued By
Macquarie University via Coursera
Skills
Analytics & Visualization
Power BI, Tableau, Excel, Alteryx, Power Query, DAX.
Programming & Querying
SQL, Python, MySQL, M-Query.
Project & Data Tools
Jira, Trello, SharePoint, GitHub, Confluence.
Other Skills
Data Modeling, ETL, Report Automation, Dashboard Design, Data Cleaning.
Projects
Client Reporting Suite
→
Summary
Developed Power BI dashboards integrated with SQL to display customer engagement KPIs and delivery timelines, ensuring regular updates.
Accounts Receivable Tracker
→
Summary
Built Excel automation using formulas and pivot tables to monitor financial claim timelines and follow-ups.