Candidates About

Experience Profile

Fusion Alliance, Columbus, OH                                                                                                     11/2016 – 12/2017

Client: American Electric Power (AEP)

Onboarding Support

·         Located on site at AEP working with the MyAccess Team.

·         Worked with internal clients to determine metadata values to onboard applications into the MyAccess application.

·          Used SQL to compare new applications to previously onboarded applications for accuracy and consistency comparisons.

Fusion Alliance, Columbus, OH                                                                                                     12/2014 – 6/2016

Client: Nationwide Insurance

Report Analyst

·         Located on site at Nationwide Insurance working with the Infrastructure Delivery Analytics and Reporting (IDAR) Team.

·         Worked with IDAR Team to develop and maintain complex Microsoft BI workbooks and Data Models.

·         (Fusion Alliance, Client: Nationwide Insurance, continued)

·         Worked with Risk Prevention to create dashboards for their existing data set.

·         Used DAX and Visual Basic modified and updated existing macro enabled workbooks and Microsoft BI documents.

·         Gathered Requirements for report visualizations.

·         Analyzed business rules from internal clients to determine business logic.

·         Created SQL queries to support Microsoft Power BI data models and dashboards based on gathered requirements.

·         Referenced gathered requirements, business rules and data models creating visualizations to communicate important information effectively.

SGA, Columbus, OH                                                                                                          12/2013 - 12/2014

Client: JP Morgan Chase

Data Analyst/Report Developer

·         Located on site at JP Morgan Chase working with the Data Management Reporting Team.

·         Worked with subject matter experts in various lines of business to analyze business rules and determine how Key Performance Indicators should be communicated.

·         Analyzed business rules to determine business logic.

·         Wrote complex SQL Queries against various databases to create required data sets based on individual line of business needs.

·         Maintained team’s internal SharePoint site for documentation and training material.

·         Developed QlikView dashboards for internal clients based on business rules and requirements. 

·         Facilitated QlikView dashboard demonstrations and training session for business users.

·         Combined and converted existing Microsoft Excel based reports and scorecards to create new QlikView Dashboards.

·         Developed and maintained complex Excel spreadsheets and visualizations as required.

Central Ohio Transit Authority, Columbus, OH                                                                       05/2009 – 10/2013

Analyst/Report Developer

·         Modified canned reports and developed Ad Hoc reports against existing databases and Data marts.

·         Wrote SQL queries for trouble shooting and report writing.

·         Gathered and distilled user interviews to elicit report and system enhancement requirements from business units (requirements elicitation & validation).

·         Managed Business Objects universes and wrote reports from those universes at the request of business units.

·         Served as the technical lead on optimization team. 

·         Coordinated User Acceptance Testing (UAT).

·         Charged with helping to implement technical and process changes developed from requirements.

·         Served as System and User Administrator for Ellipse ERP system. 

·         Documented process and system upgrades for Ellipse, as well as created SOP documentation and test scripts for other projects.

·         Communicated with stakeholders and management regarding system events, status and upcoming changes.

Value City Department Stores, Columbus, OH                                                                          06/2008 – 01/2009

IT Business & Report Analyst

·         Modified canned reports and wrote Ad Hoc reports from information Gathered from stakeholders.

·         Wrote SOP documentation and test scripts for projects.

·         Spearheaded user training initiative for system enhancements.

·         Communicated with stakeholders at all levels regarding requirements and system changes.

(Value City Department Stores, Columbus, OH, continued)

·         Acted as a liaison between the IT and Logistics teams, including transportation, distribution centers and facilities management. 

·         Tasked with connecting stakeholders in logistics with the IT resources they needed to be more effective.

·         Served as technical lead on the EDI program.

·         Gathered information on the current EDI program

·         Provided process documentation for EDI.

·         Expanded the EDI program.

Cowan + Associates, Worthington, OH                                                                                        03/2005 – 06/2008

Systems Administrator

·         Changed vendors, as well as purchasing and maintenance procedure, saving the company over $15K in the first year alone.

·         Maintained network with two Windows 2000 Servers, 35 workstations and a number of network attached storage appliances.

(Cowan + Associates, continued)

·         Evaluated and recommended vendors.

·         Maintained vendor relationships.

·         Evaluated and recommended software and hardware systems.

·         Provided desktop support for 38 onsite and remote users.

·         Delivered application support for AutoCAD.

·         Utilized Microsoft Office Suite, including Microsoft Access

·         Supported Windows NT, 2000, XP Professional and Vista operating systems.

·         Designed, built and tested a disaster recovery system using off the shelf parts.

·         Built and maintained servers and workstations. 

·         Migrated AutoCAD drawing and project archives to a faster and more reliable system allowing for more efficient retrieval of past projects.

·         Bachelor of Arts, Communication, The Ohio State University, Columbus, OH

·         Bachelor of Science, Computer and Information Systems, DeVry University, Columbus, OH