SUMMARY:

• Experienced IT professional with 15+ years doing analysis of business needs, assemblage of data, and reporting to support business development and problem solving
• 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 within that data
• 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
• Flowcharted data flow and business processes and written training manuals
• Strong Business Analysis & Research skills with the ability to determine the source of the data and what data is relevant for the particular business need
• Aptitude to turn data into information and information into knowledge
• 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 SKILLS:

• MS Office 95, 2010 Specialty Focus on Access
• Excel
• Queries/Expressions
• Macros
• VBA
• Excel PowerPivot
• SQL Management Studio (SSMS)
• Minor experience with SSRS
• Visual Studio
• Tableau
• Lotus Notes
• Adobe PageMaker
• SharePoint 2013
• Visio 2013
• Crystal Reports
• MS Project
• Some experience with SAP
• AS400 & ISO documentation

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Database Analyst/ Excel Developer/ Programmer Contract

Responsibilities:

• Update and modified Structure & Data in their Sage-Estimating Database Editor.
• Enhance and improve the Bid Pricing Spreadsheet, modifying and developing VBA code and Excel functions.
• 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 within that Excel spreadsheet.
• Evaluate the application ‘On-Screen Takeoff Pro’ (OST) 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.

Confidential, Scottsdale, AZ

Data-/Research/Application Analyst-Report Developer Contract

Responsibilities:

• 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.

Confidential, Chandler, AZ

Data/Network-Research Analyst Contract

Responsibilities:

• Researched Network equipment and attached devices for two Projects.
• 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

Confidential, Phoenix, AZ

Data Analyst/Health-Tax Researcher

Responsibilities:

• Researched & Investigated discrepancies and anomalies’ in consumer’s tax form 1095-A
• 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)
• Determined a conclusion and write analysis

Confidential

MS Access Consultant

Responsibilities:

• Fixed broken Access Databases
• Reverse engineer Confidential 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
• Improving and correcting the static reports.
• Fix and improve Macros & Automate reports to be exported to Excel

Confidential, Tempe, AZ

Reports Analyst

Responsibilities:

• Communicated with users to understand business needs, Data Required and determine a solution
• Researched, Validated and Analyzed source data
• Developed and administrated databases both MS Access and SQL Server
• ODBC connections to SQL Server - MS Access and Excel
• Large Data Sets 12,000,000 plus records
• 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
• Converted MS Access to SQL Server - Ran Access & Excel Reports directly off SQL Server
• Utilized Power Pivot to run MS SQL queries into data models for large data-set dashboard
• Developed Excel Dashboards

Confidential, Chandler, AZ

Business Data and Reporting Analyst

Responsibilities:

• 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

Confidential, Phoenix, AZ

Business Intelligence Data Analyst

Responsibilities:

• 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

Confidential, Phoenix, AZ

Access BI Database Analyst

Responsibilities:

• Participated in meetings to understand business needs to develop accurate dashboards to support business needs.
• 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

Confidential, Phoenix, AZ

Data Analyst/Reports Developer

Responsibilities:

• 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

Confidential, Phoenix, AZ

Programmer/Access Excel Report Developer

Responsibilities:

• 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 development and modifications

Confidential, Phoenix, AZ

MS Access Database and Excel Specialist

Responsibilities:

• Outlined business requirements and analytical prerequisites
• Pinpointed and recommended potential data sources
• 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

Confidential, Phoenix, AZ

MS Access Database Developer/Administrator

Responsibilities:

• Analyzed GradeBeam Construction Estimators database to determine accountability
• Worked closely with the VP and Managers to determine requirements and make recommendations on analyzed data
• 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

Confidential, Iowa Park, TX

MS Access Database & Excel Specialist

Responsibilities:

• 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