Data Analyst
Resume:
Kevin Theoret
Macomb, MI *8042
************@*****.***
PROFESSIONAL PROFILE
Accomplished Information Technology professional with more than 10 years of experience with data analysis, analytics, and reporting experience. Outstanding customer service skills, very detail oriented, and an effective team member with a strong ability to work independently.
WORK EXPERIENCE
General Motors, Warren, MI (August 2014 – Present)
Warranty Data Analyst
Responsible for working with business users to analyze BI and reporting requirements, develop value-added BI solutions, and produce a variety of reports and dashboards. Streamline or automate processes for Cognos tools and report creation. Participate in requirements collection, analysis, definition and documentation activities. Provide first line of support for reporting issues and enhancement requests. Advanced report authoring using the Cognos Report Studio tool and customer view creation, as well as creation of templates and burst reports.
UnitedHealth Group, Southfield, MI (May 2013 – April 2014)
IT Data Analytics Analyst
Organize, sort and filter data in order to distinguish patterns and recognize trends. Develop and maintain data preparation and validation routines to support data mining and creating complex data mining algorithms. Selecting, recommend and applying appropriate analytic and statistical methodologies and techniques to execute against an analysis plan or research objectives. Evaluate new analytics tools and methodologies for possible deployment. Create data warehouses/marts and/or develops data mining analyses to support business decisions.
General Motors, Warren, MI (August 2011 – May 2013)
Warranty Data Analyst
Responsible for working with business users to analyze BI and reporting requirements, develop value-added BI solutions, and produce a variety of reports and dashboards. Streamline or automate processes for Cognos tools and report creation. Participate in requirements collection, analysis, definition and documentation activities. Provide first line of support for reporting issues and enhancement requests. Advanced report authoring using the Cognos Report Studio tool and customer view creation, as well as creation of templates and burst reports.
• Worked on a team that developed and deployed a suite of tools to go towards giving the field teams and dealers more Sales Empowerment with our customers.
• Created a daily report tracking the status of these new tools for the field teams.
Ascension Health Information Services, Auburn Hills, MI (May 2010 – August 2011)
Service Desk Analyst
Responsible for assisting customers over the phone and troubleshooting if necessary. Recorded & maintained accurate information regarding customers issues, associated incidents to known errors, and triaged problems. Escalated incidents within established guidelines, worked to meet or exceed customer satisfaction, provided status updates to customers and verified the quality of service when incidents are closed and contributed to the knowledge databases
Kelly Services World Headquarters, Inc., Troy, MI (Jan. 2006 – Dec. 2009)
KSN Report Administrator / Software Engineer (promotion)
Responsible for accepting and resolving IT cases relative to requests from field office and corporate personnel including documentation. Gathered requirements from the customers for new reports. Participated in projects as required by management. Ran weekly, monthly, and quarterly reports using Toad, Cognos Impromptu and Kelly Services Staffnet Reporting. Determined functional escalation of cases, created reports using Toad, SQL Scripts and Cognos 8.0 Query Studio or Report Studio for various projects/requests, and tested all new reports prior to go-live.
• Ran reports and analyzed data pertaining to a tax audit. This saved the company over $4 million from its original assessment.
• Conducted multiple tests on a new standard report to enhance customer satisfaction and promote retention.
• Analyzed Report data by creating pivot tables, macros and database querys
Hotline Analyst
Answered incoming calls from corporate and field users who experienced difficulty with normal business processes and instructed them on how to properly enter information. Created full documentation on issues, resolved case or escalated accordingly to a higher queue.
EDUCATION
Bachelors of Science in Product Design Technology
Wayne State University, Detroit, MI
Computer Skills:
- Microsoft Office 365 (Word, Excel, PowerPoint, Access, Teams, OneNote)
- Microsoft Office 2016 (Word, Excel, PowerPoint, Access, Visio)
- Cognos 8.0 / 10.0 / 11.0 Query Studio - Cognos 8.0 / 10.0 / 11.0 Report Studio
- Cognos Impromptu - Toad for Oracle
- Rally Software – SharePoint
- Power BI
Contact this candidate