Amardeep G. Email & Phone Number

Woodbridge, Ca, Us

Ann Arbor, Mi, Us

San Diego, Ca, Us

Developed the Proof of Concept for the project-tracking tool within one month, documented the requirements, and wrote user stories. Analyzed stakeholders’ needs; worked with development to ensure that requirements were met, and that the product was launched on time. Increased the number of fields reported on by 90% over the prior technology.- Conducted the product testing; reduced bugs by setting up Azure DevOps.- Helped enable the tool to connect with other technologies (including procurement tracking and SAP) to extract data.- Worked as the point of contact for clients when they had questions. Proactively reached out to them, wrote SQL queries,and mentored them on using technologies. Helped them conduct 2-week Agile sprints.- Managed >300 site setups for electronic vehicle programs.- Reduced query times 50% by cleaning data on >10K survey results. Decreased run times to obtain >600K results.- Worked with 4 host providers to support drivers as their number increased from 3K to 4K; ensured the quality of data.Improved data accuracy on their performances, and created reports for management.- Reduced man-hours by generating automated reports, using SSIS, SQL, and MDS Analytics. Created >20 recurring utilitydata reports, using SQL, SSIS, Excel, and Excel Macros.- Worked as the data expert for legacy database transition to SAP HANA EE.

• Facilitated and documented meetings with technical and operational teams to analyze business objectives and performance• Researched market trends through usability testing various design concepts to ensure client satisfaction for 3 products • Gathered product requirements for enhancement/revamp of existing software offerings for 3 different products through bi-weekly communication meetings with Product Management, Stakeholders and Lead Systems Architects• Ensured seamless integration of features at a Suite level so that the Inform products could be number one in the Public Safety Sector• Won a $50 million contract for the company due to the Mobile Refresh initiative that my team and I worked on

Centennial, Co, Us

• Helping transition out-of-date system to robust and dynamic Fast System with ongoing enhancements• Conducting over 10 status checks with over 5 clients and their teams to assess progress against plan• Extensive use of SQL to minimize client data retrieval time • Translating client business needs into efficient technical solutions

Falls Church, Va, Us

• Assisted and supported product planning, sourcing and ongoing tasks using MS Visio and Project• Developed outline for a script to automate a routine, which would free up to 30 minutes of manual tasks daily• Designed blueprint to identify problems causing low transfer speed issues between 4 sites• Setup inventory for over 4 different projects being worked upon

Atlanta, Georgia, Us

• Performed in depth data analysis to create an process flow chart of order approval automation process • Worked within Excel, Access, and SAP to create over 5 reports to show loss of profit over the course of a year • Created multiple business processes, which decreased time of order approvals from over 30 minutes to 2 minutes• Presented research of profit loss of over $50,000 and a solution to prevent this loss to the President of the company• Worked with developers to establish new business avenues, resulting in increased efficiency and accelerated returns

Provided customer service via phone calls and in person, performed case audits, input data into IMIS (Integrated Management Information System), performed a mock inspection, and accompanied COSHO’s on inspections to various companies. Throughout my interning I was asked to do research on the Integrated Management Information System and see whether the system could be made faster and more efficient. Although I only had a chance to work with the user interface, I suggested trying to reset the complaint number after each year or month so they were easier to track and also faster to produce a new number. I couldn’t go into much detail with the improvements due to the fact that I never got to interact with the back-end directly.

Bachelor’S Degree, Computer Science

Associate'S Degree, General Studies

High School, College/University Preparatory And Advanced High School/Secondary Diploma Program