Charles Shafer

Charles Shafer Email and Phone Number

Senior Consultant at Access Data Solutions @
Charles Shafer's Location
Raleigh, North Carolina, United States, United States
Charles Shafer's Contact Details

Charles Shafer personal email

About Charles Shafer

• 20+ professional IT experience; progressing from programming to IT management; remains hands-on and enjoys relational database development and SQL database development.• IT Management positions and experience in Systems, Operations, Networking, Database along with Finance and Business Management. • Eight years experience in client-facing roles; working directly with clients and solving their business issues; strong ability to gather client requirements, perform gap analysis; translate to functional and technical specifications• Known for Hands-on, detail oriented problem solving and solution oriented approach. Excellent overall technical skills with extremely strong emphasis in Database architecture, SQL and report generation (many platforms). Quick to understand the business needs and develop and deliver an IT solution. • Very strong technical skills in database development on MySQL, DB2 & MS Access platforms; very strong SQL, stored procedures, views, joins; QMF queries; Very strong in Excel, pivot tables, lookups, advanced functions.• Strong ability to identify process/revenue/expense improvements and implement sensible & cost effective IT solutions• Very strong and professional communications, ability to perform in team and individual contributor rolesSpecialties: Data Analytics, DB2, MySL, Microsoft Office, Project Management, Problem Solver, Logic thinker. Project Management, Programming (cobol, rpg, rex,assembler, java, javascript), Application Generators, Report Generators

Charles Shafer's Current Company Details
Access Data Solutions

Access Data Solutions

Senior Consultant at Access Data Solutions
Charles Shafer Work Experience Details
  • Access Data Solutions
    Senior Consultant
    Access Data Solutions Mar 2011 - Present
    Raleigh, Nc
    Successfully working as an independent consultant/contractor. Currently engaged in developing two medical database systems on MySQL. Providing complete database functions from design to execution to analytics.- Developing a post surgery database and will perform analytics on the effectiveness of surgery and generate critical success factors. Building processes to extract billing information from doctor’s offices, developing patient survey process into a consolidated database.- Developing medical claims database for doctors to analyze there business volumes and negotiate better rates with insurance companies. Pulling together performed procedures data from doctors office, CPT codes from AMA, Medical Fee Schedules and Insurance companies data utilizing MySQL and Microsoft Excel.
  • Ibm / Corporate
    Business Manager, Database Analytics
    Ibm / Corporate Jan 2004 - Mar 2011
    Spearheaded the identification and implementation of nationwide cost-saving initiatives supporting a 110,000-employee workforce. Delivered an average of $4 million in annual cost savings by identifying and leading projects to capture cost-saving opportunities-honored with President's Award. Initiated, planned, designed, implemented, and maintained a DB2 user profile analytic database compiling detailed spending / usage records for all U.S. employees from 9 sources into a single-view database with 20+ million records-database was instrumental in targeting cost reduction opportunities and improving business decision making. Saved $4 million annually by implementing monthly management communications listing staff with out-of-compliance high mobility expenditures, identifying employees with multiple overlapping services, and determining unused communication services for elimination. Developed an analytic model to determine most cost-effective minute plans for 15,000 cell phones and BlackBerry devises with pooled minutes-resulted in $1.5 million in first-year savings.
  • Global Voice Infrastructure
    Business Manager
    Global Voice Infrastructure Jan 1999 - Jan 2004
    Managed a newly formed 10-member global team across 10 countries responsible for $600 million voice portfolio. Oversaw development of business management standards, including labor tracking, expense accounting, asset tracking, and portfolio management. Implemented and oversaw global cost savings program-surpassed first-year savings target by 65%, generating $58 million in savings, and consistently exceeded subsequent annual savings targets. Reduced voice switch lease and depreciation costs by $5 million through improved asset tracking.Saved $2 million (a 66% cost reduction) on hand sets by implementing a more stringent approval process. Enhanced voice resource management efficiency by standardizing labor tracking, voice expense / asset tracking, expense recovery, and financial management processes.
  • Ibm
    Business Manager / Mobility Team Leader, Sales And Distribution Voice / Mobility Team
    Ibm Jan 1995 - Jan 1999
    Led business management functions for a $120 million portfolio. Managed team of 3 in developing and managing expense tracking processes and cost reduction initiatives. Created voice expense DB2 database to improve analytic capabilities. Revamped all tracking processes for each voice expense category. Delivered business accounting controls / improvements instrumental in delivering $15 million in annual cost savings, eliminating unneeded equipment, circuits, and 800 numbers. Improved identification of spend problem areas by introducing discrete accounting codes for each type of expense and developing usage / cost metrics for all 12 different spending categories. Enhanced asset management / tracking capabilities by establishing business justification supporting transition of voice asset tracking from a lot allocation to serial number asset tracking process. Created business justification for successful implementation of a follow-me platform for mobile workers, including mobility cost impact analysis comparing real-estate savings, voice infrastructure costs, and mobility costs. Developed a mobility cost impact comparison of home-based vs. office-based employees-earned recognition through publication of part of mobility cost impact analysis by the Gartner Group.
  • Ibm
    Systems / Database Manager, Direct Marketing
    Ibm Jan 1993 - Jan 1999
    Led development and implementation of IT solutions for a 120-employee direct marketing organization. Managed a regional customer contact database supporting telesales and campaign telemarketing. Delivered a 17-point jump in user satisfaction index to highest level across the U.S. by establishing ownership roles and responsibilities for database team / user community and implementing several quality improvement projects to regain user confidence. Restructured database team and outsourced systems support and operations-improved service, reduced costs $300,000 annually, and increased system availability to 100% during prime shift. Implemented a campaign strategy database review process to ensure consistent organization-wide tracking of marketing campaigns and customer targeting activities. Improved data management processes, eliminating duplicate records and unnecessary client communications.

Charles Shafer Skills

Project Management Management Leadership Process Improvement It Management Outsourcing Databases Analysis Networking Ms Project Sql Analytics Access Microsoft Excel

Charles Shafer Education Details

Frequently Asked Questions about Charles Shafer

What company does Charles Shafer work for?

Charles Shafer works for Access Data Solutions

What is Charles Shafer's role at the current company?

Charles Shafer's current role is Senior Consultant at Access Data Solutions.

What is Charles Shafer's email address?

Charles Shafer's email address is cs****@****ail.com

What schools did Charles Shafer attend?

Charles Shafer attended Michigan State University.

What skills is Charles Shafer known for?

Charles Shafer has skills like Project Management, Management, Leadership, Process Improvement, It Management, Outsourcing, Databases, Analysis, Networking, Ms Project, Sql, Analytics.

Not the Charles Shafer you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.