Data Analyst Reports Developer

Professional Summary

Experienced IT professional with 15+ years doing analysis of business needs, assemblage of data, and reporting to support business development and problem solving

Aptitude to turn data into information and information into knowledge

Creates functional and relevant solutions including Pivot-Tables/Charts and Dashboards

Possesses strong data analysis skills with large data sets and has the ability to determine anomalies

Expert with Access, Excel and is at the intermediate level of knowledge with Tableau and SSRS

Designed and built dashboards/scorecards utilizing Excel, Tableau and SSRS

Flow-charted data flow and business processes and written training manuals

Extensive experience in the area of MS Access database theory, design and development of Tables, Queries, Forms, Reports, Macros and ODBC connections

Skilled in the import and export of data between multiple programs as needed and from other outside sources, MS SQL Server, Oracle, or any ODBC compliant source

Technical Summary

MS Office 95 – 2010 Specialty Focus on Access and Excel, Queries/Expressions, Macros and VBA,

Excel Power Pivot, SQL Management Studio (SSMS)

Minor experience with SSRS, Visual Studio, Tableau, Lotus Notes, Adobe Page-Maker, Share Point 2013, Visio 2013, Crystal Reports; MS Project, Some experience with SAP, AS400 & ISO documentation

Microsoft Excel Pivot-Tables, Graphs, Charts, Macros, Formulas including V-Lookup and VBA programming, Power-Pivot for large data sets & building data models/sets.

Professional Experience

Wells Fargo, Remote 04/2020 – 07/2020

Business Analyst/Data Analyst

Developed MS Access database that utilized numerous complex VLookUps, Formulas & Expressions

Automated the Excel spreadsheets with Macros & VBA code to aggregate the data making the process much more automated and efficient.

Wells Fargo, Remote 04/2019 – 08/2019

Business Systems Analyst 5

Developed MS Access database from Excel Spreadsheets that utilized numerous complex VLookUps on several tabs converted the Excel spreadsheet VLOOKUPs in reports to a MS Access database to have Access aggregate the data and output the finished results to Excel making the process much more automated and efficient.

Cigna Medical Group, Phoenix, AZ 10/2018 – 12/2018

Systems Analyst Specialist – Contract thru Insight Global

Devised a method to add new Lines of Business (Insurance Products) – LOB field in the TSL database

Add new Specialties to the TSL database

Determined and fixed VBA programming error for SureFit Product (LOB)

Plan and build process for new Medicare Alliance Sub-Network from SharePoint into the TSL Access Database thru to the SQL back-end

Fixed error messages and enhance the main TSL user form thru VBA to catch and handle the error messages on null values and have an email be automatically sent with the pertinent info.

Gothic Landscaping, Phoenix, AZ 11/2017 – 02/2018

Database Analyst- Excel Developer/Programmer Contract

Update and modified Structure & Data in their Sage-Estimating Database Editor.

Enhance modify and improve the VBA Code and functions in their Bid Pricing Excel application.

Transition one of their Excel spreadsheets to have the data stored in an Access database and configure numerous Pivot-Tables to run off the Access tables and queries, produce a dashboard with Excel.

Evaluate the ‘On-Screen Takeoff Pro’ (OST) application and determine how to integrate with Gothic’s Sage-Estimating database.

Research and learn how to utilize the Integration of OST within the Sage Estimators database.

Configure OST conditions and Style Library

Modify existing code and develop new code for the Sage-Estimating ‘Assemblies’

Build Sage Estimating ‘Models’ to run and utilize the ‘Assemblies’ to produce the finished Estimate.

CVS, Scottsdale, AZ 05/2017 – 10/2017

Data-/Research/Application Analyst-Report Developer Contract

Analyze current reporting structure to determine a more efficient workflow

Streamlining and consolidating reports currently housed in multiple applications to help the Pharmacy Directory team operate more efficiently.

Developing solutions to help the team improve turnaround times on report requests.

Supporting Pharmacy Directory staff with ad hoc reporting requests.

Wells Fargo, Chandler, AZ 03/2016 – 01/2017

Data/Network-Research Analyst Contract

Researched Network equipment and attached devices for two Projects (Project PHX and FWAM2)

Understanding of the relationships of data elements in the various systems of records used

Determined correct data source; Mines, Compiles & Evaluates/Analyses data from a variety of sources.

Collected and analyzed data for specific projects to provide metrics to support project teams

Utilized MS Access & Excel to make connections to SharePoint databases & lists.

Responds to requests for specific customized reports, produces Macros utilizing Pivot-Tables, VBA, VLOOKUPs.

Systems used were: Pac2000-Asset & CMDB Management Console, DevicePro2, Tech Tools, Triage, Tangoe Matrix CMP

Cognosante, Phoenix, AZ 12/2015 – 02/2016

Data Analyst/Health-Tax Researcher - Contract

Researched & Investigated discrepancies and anomalies’ in consumer’s tax form 1095-A

Determined a conclusion and write analysis

Followed strict adherence to HIPP laws – PPI and PHI

Compared data to three different database sources

Responsible for data validation and determined correct version of data

Ran BUU (Batch Update Utility as needed)

Wells Fargo, Telecommute Position 10/2015 – 11/2015

MS Access Consultant (Contract)

Fixed broken Access Databases, improve macros and automate reports to be Exported to Excel

Reverse engineer Wells Fargo badly constructed MS Access databases

Map data from source to finished report - Data validation

Redo the back end of Tables-Fixing Data types, Field sizes

Correcting joins in queries, correcting erroneous expressions & code

Upgrading the Forms for Data Validation, Input masks

Vemma, Tempe, AZ 07/2013 – 12/2014

Reports Analyst

Communicated with users to understand data required and business needs and determine a solution

Researched, Validated and Analyzed source data

Developed, Administrated and Converted MS Access databases to SQL Server

Ran Access & Excel Reports, Pivot-Tables and Dashboards directly off SQL Server thru ODBC connections

Large Data Sets 12,000,000 plus records requiring Power Pivot to run MS SQL queries into data models for large data-set Power Pivot reports and dashboards

On migration team to SQL Server, imported Access Tables into SQL-setting data types, field sizes

Reports Automation utilizing Access, Excel, SSRS and SQL Server, Developed Excel Dashboards

QBE Insurance Group, Chandler, AZ 12/2012 – 06/2013

Business Data and Reporting Analyst (Contract)

Gathered requirements from users and management to understand reporting needs

Analyzed source data for redundancy, data quality, and analyzed Reporting Methods/Procedures

Automated Excel Spreadsheets reporting into new Access Databases

Developed Excel Macros and VBA code to enhance spreadsheets functions and developed Access and SQL queries running off MS SQL Server

Documented policies and procedures

DES – Division Benefits and Medical Eligibility, Phoenix, AZ 07/2012 – 09/2012

Business Intelligence Data Analyst (Contract)

Learned Tableau on the job quickly

Developed relationships with users to understand layout and presentation of Tableau dashboards

MS Access-Excel data preparation for import into Tableau

Produced Distance Calculation with Tableau mapping

Developed Radius Distance Filtering

Developed Fraud Tracking-Detection-Mapping process with Tableau

Analyzed source data for redundancy and data quality

Industrial Commission of Arizona, Phoenix, AZ 04/2012 – 07/2012

Access BI Database Analyst (Contract)

Participated in meetings to understand business needs to develop accurate dashboards.

Reverse engineered, condensed, consolidated and centralized 2–3 dozen Access Databases

Mapped data flow from source SQL tables to end report

Validated data and analyzed source data for redundancy and data quality

Fixed erroneous queries, macros, and codes (SQL and VBA)

Security and Permissions – Access to Data and Reports

Intense Documentation of Data Flow

Chase Bank, Phoenix, AZ 09/2011 – 01/2012

Data Analyst/Reports Developer (Contract)

Worked on MS Access Ad-Hoc database development – Queries, Forms, Reports, Macros, SQL

Responsible for report automation using MS Excel Pivot-Tables, Charts, Graphs, Macros, and VBA

Retrieved data from Oracle database and company’s servers for Access and Excel

Fine Tuned Oracle SQL queries to run quicker (run time from 1.5 hours down to less than 8 minutes)

Analyzed source data for redundancy and data quality

Tuned MS Access queries’ to make them run more efficiently retrieving data from the companies servers by Importing, Linking and Appending data

American Express, Phoenix, AZ 01/2011 – 07/2011

Programmer/Access Excel Report Developer (Contract)

Responsible for Report Automation utilizing MS Access and Excel

Created Ad-Hoc Reports utilizing MS Access Databases

Developed MS Access and MS Excel Macros, utilizing SQL and VBA

Responsible for providing Spreadsheet formulas, Pivot-Table, Charts, Graphs

Independent Contractor/Consultant, Phoenix, AZ 11/2006 – 01/2011

MS Access Database and Excel Specialist

Outlined business requirements and analytical prerequisites

Automated client’s Excel Reports and Developed MS Access Databases

Created macros, reports, pivot tables, graphs and charts, utilizing Excel

Developed reports as a result of consultation with all levels of end-users

Trained end-users to use the Access Databases and Excel

Analyzed source data for redundancy and data quality

Clients included: RSC Rentals, BioTech ePhilosophy, and Adaptive Curriculum

Kitchell Construction, Phoenix, AZ 08/2006 – 11/2006

MS Access Database Developer/Administrator

Analyzed GradeBeam Construction Estimators database to determine accountability

Worked closely with the VP and Managers to determine requirements and make recommendations

Analyzed ProLog Project Management database to retrieve valid data – Crystal Reports vs. Access Reports

Utilized JD Edwards – Attended training classes and researched/analyzed the reporting capabilities and the possibility of incorporating JD Edwards with a MS Access database

Cryovac Corp. Iowa Park, TX 01/2000 -02/2006

MS Access Database & Excel Specialist

Created macros, reports, pivot tables, graphs and charts, utilizing Excel

MS Access Database administration and programming for bag, film and salvage databases

Constructed MS Access Databases for use on the company server

Streamlined the work of generating reports as required from both Excel and Access

Trained end-users to use the Access Databases and Excel

Prepared reports in Access and Excel for the SAP tech to analyze for input into SAP

Awards: Received the Keys to Success Silver Award for being on the CMIS team in May 2002

Education

Vernon College, Vernon, TX

oAssociate of Applied Sciences Computer Information System - Networking

oTaken and passed the Cisco Certified Network Associate (CCNA) test at Vernon College

oPlus many hours (about 120) at Midwestern State University, Wichita Falls, TX

Training

Mesa Community College

oExpert Certification courses for MS Access 2007 and Excel 2010 Refresher Courses

oMS Office 2007 Applications – Refresher especially Access, Excel, Word and PowerPoint

oNetwork Security

oComputer Forensics

oSQL Server 2008 for Developers

oMany courses on database theory, management & administration, including MS Access, MS SQL Server and Oracle.

Contact this candidate