Chirag Hamirani

Automation Analyst

University of Texas at Dallas - Parking and Transportation Services•  January 2020 - Present

• Automated 80% of incoming parking permit approvals which helped department save $1000 per month on manual labor alone by optimizing data processing and output time by 400% of previous method with high accuracy and good visualization • Designed 7-table relational database from scratch using MS Access to successfully manage workflow considering forward compatibility and developed VBA Macros code to perform ETL on live Outlook data, including data cleaning and business validations • Trained and lead a team of 5 to assist in the process of individual modules with MS Access, report generation and file transfer • Created set of 10 comprehensive documents to cover business, functional, technical requirements, and user training modules

Branch Manager

MM Tutorials•  April 2018 - April 2019

• Increased 30% sales by improved student enrollment in 1 academic year, implementing creative ideas and strategic business marketing • Assessed performance for 7 batches of students and designed 40 reports monthly for comparative evaluation using MS Excel • Scheduled lectures & exams, being the program manager for staff of 30 people using excellent communication and interpersonal skills • Held career guidance seminars and cost-free teaching sessions periodically for community outreach

Data Analyst

Infosys•  October 2016 - April 2018

• Gained High Performer rating (top 1%) in Business Intelligence training on python, algorithms, data structures, analytical techniques, and data visualization tools like MS SQL Server, Informatica PowerCenter ETL, IBM Cognos Reporting and Tableau • Completed 8-month SAP MDM project for full project lifecycle including design – documentation, development over 7 repositories with 12 tables, exhaustive testing covering total 120 scenarios, data migration for 10 million records, and deployment with hyper-care support • Received Appreciation Certificate for this project management whilst leading 5 employees & coordinating with development team of 30 • Accomplished 100% target to manage incidents, enhancements in SAP MDM and ERP systems by collaborating with support team of 10