Data Analyst Microsoft

CHARLES W. REED

PO Box ******

Nashville, TN ****7

Cell: 615-***-**** Email: ******@*****.***

INTRODUCTORY

Seeking a Sr. Level Data/Reporting Analyst role in which I can fully utilize my 10+ years working in a highly technical environment and to work for a progressive company with an emphasis on the production of various complex reports.

ACCOMPLISHMENTS

Saved over $60,000 as a result of data analysis and recommendations based on member demographics. (APS Healthcare)

Assisted in 20% decrease in TAT (turn-around-time) by creating 3-month analysis reporting. (Medsolutions)

Designed Microsoft Access database used by 10+ users to store and track “do-not-call” members. (APS Healthcare)

Created multiple automated reports to reflect current demographics for State membership base (APS Healthcare)

Created (from scratch) many complex reports to highlight revenue, enrollment and call-center metrics. (APS Healthcare)

Created and maintained multiple call center reports to assist with workforce/staffing decisions. (Medsolutions)

Designed Microsoft Access database that automated a previous manual process (saves 4.5 man hours). (Nissan)

Designed Microsoft Access database for handling over 600,000+ transactions per year (Various)

Assisted Director of Finance to forecast budgeting based on historical and future data analysis. (APS Healthcare)

Created email and fax interface ability within Microsoft Access System. (Windsor Medicare)

Created various QA and State-level reports to ensure data quality and compliance. (APS Healthcare)

Created system to manage daily calls of up to 3,000+ members to track revenue. (APS Healthcare)

Created various reporting to facilitate the management of a Internal Reporting System (Cognosante)

Successful Management of two (2) Reporting Analyst and development of new MS Access System. (Cognosante)

Created various Employee-related H/R reports and automated various processes (HCA)

PROFESSIONAL EXPERIENCE SUMMARY

10 years as a Microsoft Access developer (Access 2000, 2002, 2003, 2007, Access 97', 2.0) creating systems, complex queries, forms, reports, macros, tables, relationships, Access Visual Basic (VBA)code, ODBC links, SQL/server, multi-user environments. Extensive experience connecting to & transferring data from SQL databases. 6 years in the support of COBOL (ANSI-85). 1+ years experience in a training/development environment with SQL Reporting Services.

4 years experience with SQL and SQL Navigator. (Not a SQL DBA)

4+ years experience with Oracle Business Objects / Business Intelligence System (OBIEE) complex reporting systems.

7+ years experience working in the Healthcare field, emphasis on Reporting/Data analyst.

3 years working with Sharepoint, more specifically uploading and managing reporting systems.

1+ years working as a Business Analyst in determining & evaluating current systems and making recommendations as needed. Upgrades from FoxPro to Access and/or Access to SQL/server.

1 year experience with working with Salesforce Reporting tool.

1 year experience working with CRM and SRSS Reporting tool. (Less than 2 months working with SSIS packages)

1 year working in Human Resources utilizing Lawson, Case Management and other H/R Systems.

8 years experience in the Information Technology field with emphasis on the HP3000 mainframe computer system. (MPE operating system with experience with IMAGE databases, Adager, JCL, Reflections, FTP).

2 years EDI experience (EDI mapping and interface, creating trading partners, ANSI X12, EDIFACT, etc.)

7 years experience developing and supporting Powerhouse/Cognos applications (Quiz, Quick, QTP, QDD).

1 year experience working with Crystal Reports and 6 months experience working with Tableau.

SOFTWARE, HARDWARE & PROGRAMS (TECHNOLOGY)

Various Software: Salesforce, CRM (SRSS), Visio-Flowcharting 5.0, Microsoft Office 2000,2003, 2007, 2010,2013 (Word, Excel,

Powerpoint), Microsoft Exchange, Microsoft Project, Sharepoint, SQL Server 2012/2014, SQL Navigator,

Crystal Reports, Extensive knowledge and experience with VLOOKUP/Pivot Tables/Charts/Graphs in Excel.

4th GL & Misc: Cognos/Powerhouse (Quiz, QTP, Quick, QDD), Versions 5.26, 7.09, & 7.29, Reflections, FTP, (databases/web)

EDI applications, Image databases, COBOL applications, JCL, Visual Basic 6.0, Oracle 7/10g databases, FoxPro,

CRM (SRSS), ODBC, Front Page/HTML.

EDUCATION & CERTIFICATIONS

Indiana Institute of Technology Ft Wayne, Indiana Associate of Science Computer Information Systems

Gary Career Center Gary, Indiana Two-Year Certification Computer Information Systems

EPIC Leap Madison, Wisconsin Epic Certification Cadence/Business Intelligence

WORK HISTORY & EXPIERENCE

Business Intelligence Developer Vanderbilt University April 2016 - Present Obtain and secure EPIC Certification with a specialty in Cadence/Reporting. Convert and test various reports to ensure accurate data and complete functionality in new EPIC system, meet with end-users to confirm all reporting needs are met. Integrate reports into EPIC dashboards, design new Crystal reports and modify existing Crystal reports on an as needed basis. Reason = Seeking to Relocate.

Sr. Data Analyst/Reporting HCA August 2015 – April 2016 Data analyst skills using ORACLE Business Intelligence (OBIEE) by creating complex queries, heavy use of Lawson Payroll System and various reporting duties working with Business Objects. Produce various sensitive HR and critical reports for 166+ hospitals and ensure the highest level of quality when delivering data and reports. High use of Microsoft Access databases. Reason = New Management/Direction.

Sr. Data Analyst/Reporting(Manager) Cognosante May 2014 – June 2015 Data analyst skills using SRSS Reporting tools to extrapolate critical data from CRM System (web-based), import into Microsoft Excel and Access. Produce many complicated, critical reports, upload into Sharepoint and ensure on-time and accurate delivery of all reports to the State of Tennessee regarding TENNCARE and create pivot tables to professionally display various data. Directly manage two(2) Reporting Analysts and indirectly manage and facilitate other employees and business decisions. Reason = Company closed, massive layoffs.

Charles W Reed

PAGE 2 – ADDITIONAL EMPLOYMENT

Data Analyst/Coordinator Nissan CORP USA November 2013 – November 2014 (dual)

Data analyst skills using Business Objects and Microsoft Access to extrapolate critical data from various TSP data feeds, produce reports and translate data into meaningful and impactful results. Utilize Excel and Salesforce to create new reports and modify existing reports that provides critical data to all business departments that greatly impact Corporate decision making. Create various data charts, pie charts and pivot tables to professionally display various data. Reason = 6 month contract only.

Sr. Operations Analyst APS Healthcare March 2011 – October 2012 Reason = Company closed, layoffs.

Data analyst skills using Business Objects to report on all levels of data for Corporate decision making decisions, develop various in-house applications to support web-based system’s deficiencies, work with Management team to strategize on future work flows and directly contribute to various revenue generation concepts, in addition, to ensure health care staff are positively impacting members lives in the field of health & wellness. Upload various reports to Sharepoint, maintain Access databases and use SQL.

Programmer/Analyst Windsor Medicare July 2007 – April 2010 Reason = Position Eliminated.

Maintain and major overhaul of existing, complex Access database and applications, utilize SQL-Navigator to modify, search for existing data, Oracle database updates as needed, project lead on various projects, maintain & update information using Sharepoint and meet with business unit to ensure proper changes are made & documented. Conversion of major applications from Access 2003 to Access 2007 and create separate queries for filtered data, add security menu and general reporting. Business analyst duties.

Programmer/Analyst & Business Analyst (Advance Finance/Sole Proprietor) June 2003 – June 2007

Create various Access databases, support various small “in-house” systems, order computers, printers, assist with desktop support applications, develop customize system utilizing Access 2000, FTP process for receiving data from remote locations. Travel to each remote location as needed to support systems, train employees, access internet/web and post various updates for remote location upgrading systems as needed. Business Analyst experience in modifying systems and making recommendations for future systems.

Reason = Sole Proprietor / Business Saturated / Needed to Secure Future and Enhance Skills.

Access DBA / Project Lead State of TN/Majestic Systems Jan 2001 – Feb 2003

Duties: Primary function is to work in a team environment and develop, support, & test various Microsoft Access 97 & 2000 applications. Project lead in various projects during entire project development life cycle. Use other technologies (FoxPro, Visual Basic, Excel) and travel 20% to remote locations and install new applications. Utilize Microsoft Excel to prepare for export to Access and printing various spreadsheets containing large amount of data. Connect to SQL. Environment: Windows NT Applications: Fiscal Services (Utility bill system, advance registration system). Reason = 6 Month Contract only (extended 2 years).

Programmer/Analyst / Access DBA Noranda Aluminum 11/1998 – 1/2001

Duties: Primary function is to develop, support, & test various Microsoft Access 97’ applications and Oracle databases. Design tables, queries, reports, utilize SQL statements, link Access (front-end) to various Oracle tables, import/export various file formats (FTP), and train various users on new system and system enhancements. Provide documentation, develop ASP (Active Server Pages) using Front Page 98, create & modify excel spreadsheets with pertinent employee payroll information and some work on HP & UNIX mainframes. Cognos/Powerhouse development and maintenance of various programs. Data transfer from SQL databases.

Environment: Windows NT Applications: Payroll/HR (GEAC), Safety, Various Plant departments.

Reason = Relocation to Nashville, TN (larger city/better technology).

Contact this candidate