Analytics Consultant Resume Charlotte, NC - Hire IT People

SUMMARY:

IT professional with extensive experience in a variety of technical and professional environments.
Current specialties include Access/VBA, MS Office, Six Sigma and Monarch. Industry experience includes human resources, health care, consulting, media development and financial services.
Skills include extensive end user, supervisory and leadership experience and excellent written/spoken communications ability.
Passionate about creating environment where team members are encouraged to grow, develop and actively communicate.

COMPUTER SKILLS:

Operating sys: DOS, Windows 3.1/95/98/XP/Vista/7/8

Languages: VB 6, VBA, SAS, various API’s

Databases: Access 2/ 95/97/00/03/07/10/13 , SQL Server

Spreadsheets: Excel 95/97/00/03/07/10/13

Other applications: MS Word/SharePoint/PowerPoint, Monarch, Crystal Reports, Tableau

EMPLOYMENT HISTORY:

Analytics Consultant

Confidential, Charlotte, NC

Responsibilities:

Identify customer needs through identification of business or regulatory requirement.
Closely examine processes for possible improvements and efficiencies.
Analyze process to determine inputs required, outputs needed and processes to develop them.
Create ODBC path to data on Sybase, Oracle or SQL Server when needed within appropriate Office application.
Develop system using VBA code as needed to integrate Office applications.
Create SQL queries to select, extract and modify data from varying sources for reporting and analysis.
Provided status and development details to internal tracking database.
Deliver to user with appropriate training and documentation.
Integrates data from differing sources to provide seamless reports/dashboards.
Modify as needed to accommodate changing business and regulatory needs.
Build, as needed, Excel spreadsheets and ran VBA code against them to establish proper formatting.
Set up Excel PivotTables with data fed from Access systems to allow data analysis for self and customers’ use.

Consultant

Confidential, Charlotte, NC

Responsibilities:

Took leadership role in managing a critical component of large scale Windows XP migration.
Created Access applications to remediate and repair end users’ Access and Excel applications.
Modified existing applications to expedite scan and analysis processing.

Programmer/analyst consultant

Confidential

Responsibilities:

Created contract - tracking system in Access 2000, migrated from Confidential, for contract tracking department.
More than doubled available fields and quadrupled available reports.
Considerably improved ease of use and created multi-user capability.
Built problem-tracking system in Access 97 for utility construction group.
Allowed entire group to track problems as they occurred and as they were fixed.

Programmer/analyst

Confidential

Responsibilities:

Assisted in development of remote sales support system using Access/VBA.
Reduced data delivery time for sales automation system by half.
Automated data delivery process, reducing staff time needed to export data.
Imported Access databases into Confidential, installed Confidential in multi-user environment and trained users.
Modified job tracking/invoicing system for HVAC contractor
Implemented 3rd party software for window cover installer.
Improved reporting and search functions for HVAC contractor.
Increased Confidential users’ efficiency and ability to share data.

Programmer/analyst

Confidential, Chapel Hill, NC

Responsibilities:

Provided IT development, database/system administration and programming support to inbound call center.
Modified VB 6 programs and designed reports in MS Office 2000 for audit control, management and outside clients.
Established procedures and trained employees to run fulfillment process in Access, Excel and Word.
Redesigned call center fulfillment process to reduce manpower required by over 50% while improving performance.
Improved report creation and generation processes.