SUMMARY:

• Expert Microsoft (MS) Access Skills, creation of complex queries in TSQL
• User - Friendly Interface Design
• Data Mining, Analysis and Documentation
• Significant Health Care, Telecomm, and Financial Industry Experience
• Extensive experience integrating MS Access with MS Excel
• Development of financial and other models in MS Excel
• Automating Reporting Processes using VBA, design of detailed reports using MS Access reporting platform and MS Excel

TECHNICAL SKILLS:

Tools: MS Access, MS Excel, MS Office, Brio Query, Visio, VBA, TSQL

PROFESSIONAL EXPERIENCE:

Confidential

MS Access Developer

Responsibilities:

• Designed and created a tool to improve the tracking of inventory and automate the billing process for TDS Customers.
• Developed user interfaces and dashboards making future data entry easier along with insuring the integrity of the information being entered.
• Previously their records were being stored using MS Excel. The quarterly billing process previously took 3 employees over 2 weeks to complete. After migrating all their data to MS Access, the entire process, including the automated mailing of statements to all customers, now takes under 3 minutes with more accurate and reliable results.

Confidential

Data Analyst / MS Access Developer

Responsibilities:

• Designed, created and maintain MS Access application to track appointments and assigned workload for HPACT - ED. This application was built with scalability in mind and served well until a more rigorous web based application could be developed.
• Designed, created and maintain MS Access application to track contact with veterans for Tele Health. This application also facilitated the daily download of data from vendor sites. Production was increased from contacting 10 - 20 Confidential ts daily to over 80 Confidential ts which was full capacity. Allowed thorough reporting and capturing of metrics which were not being logged previously.
• Supported Integrated Community Care by improving the methods used to track staffing needs, changes and projections along with automating their reporting processes.
• Used MS Access to develop a questionnaire to track feedback from veterans that were enrolled in Confidential t Mindfulness courses.
• Supported the HUD-VASH unit by creating and maintaining MS Access applications that tracked housing availability
• Upgraded and migrated numerous processes being tracked using Excel to more functional, user friendly and reliable MS Access applications

Confidential

Sr. Reporting Analyst with Sales and Marketing QA

Responsibilities:

• Created weekly dashboard using MS Access to gather and clean quality data from vendors stored in various locations, and then automatically export data and create report in MS Excel, displaying previous rolling 52 weeks of metrics along with detailed interactive charting
• Improved and automated process of reporting variance between vendors scoring of customer calls and Confidential auditors scoring.
• Collected, cleaned and stored historic POS escalation data. Created automated POS escalation reporting to be distributed to vendors and high levels of management
• Responsible for process of having vendors review point of sale escalations received by the Office of the President. After reviewing vendor’s finding, I was responsible for affirming finding, reversing the decision or referring the escalation for further investigation.

Confidential

Sr. Data Analyst

Responsibilities:

• Took ownership of existing daily management reports and the process of data extraction, data cleaning using MS Access, and then exporting, formatting and distributing the reports using MS Excel. This process which was taking over 3 hours of labor each day was fully automated using VBA, and the daily reporting process is now being completed in less than 10 minutes.
• Creation of new reports along with enhancing and adding charts to existing reports.
• Documentation of reports and created a template for the department to document future reports.
• Created a simple system for tracking all of department’s report distribution and current ownership.
• Created desktop applications in MS Access to assist auditors.
• Assisted staff in rewriting and fine tuning SQL statements. Rewrote pass-through queries to allow the use of variables. Source for office staff in the use of MS Office applications.

Confidential

Reporting / Systems Analyst

Responsibilities:

• Created PCS Credit Tracking application using MS Access. System for tracking Private credit portfolio and current status of each credit. Automated the generation of reports in MS Excel. Worked with IS department to migrate system to company intranet. Created and designed reports for Intranet system using SSRS.
• Conducted formal classes instructing supervisors and staff in using advanced skills of MS Excel such as pivot tables, filters, scenarios, creating macros along with the use of advanced functions such as VLookup, named ranges, absolute cell s, date and time functions.
• Created File Tracking system for tracking inventory and current location of all files on site along with those that have been archived off site.
• Mined data from City Data II and Infoshare Web interface and then automated distribution of reports created in MS Access and MS Excel.
• Designed automated Excel workbooks that would easily upload information from Tax Analysis exports.
• Designed system for automatically calculating employee efficiency by gathering data from multiple sources including extensive use of VBA coding in designing interfaces that allow users to customize values and edit key performance indicators.
• Automated local REACT reporting procedures
• Simplified and automated the construction of reports and report distribution from Reports 2000 data exports for Operations team.
• Extensive querying of SQL Server and Oracle databases for ad hoc reporting.

Confidential

Systems Analyst

Responsibilities:

• Wrote custom functions to implement business rules on reporting calculations
• Cleansing of data for more accurate reporting results
• Taught staff in the use of Pivot tables and charts to enhance their own ability to create reports
• Created and maintained MS Access applications that linked data using ODBC; performed required calculations and then automated the exporting and creation of over 35 separate daily reports using MS Excel
• Designed and maintained an MS Access application to automate data entry and reporting for numerous processes supporting Loss Mitigation, OTC Sales, Human Resources and WLD Reporting.
• Maintained, modified, and enhanced inherited MS Access databases by converting Macros into VB Modules, re-coding forms and objects, redesigning queries for better performance
• Automated existing monthly and weekly reports

Confidential

Report Analyst

Responsibilities:

• Salvaged Watchlist data that was corrupted while being stored in Excel. Migrated the data into an MS Access database in order to maintain the Watchlist.
• Created MS Access database for use by auditors who downloaded loan information and manually entered data

Confidential, THOUSAND OAKS

Support Analyst with OIS, Project Coordinator

Responsibilities:

• Redesigned existing Excel tools for tracking performance ratings, greatly improving efficiency and reducing file size.
• Designed Excel application to automate the reporting of recruiting and staffing statistics.
• Created pivot tables and wrote VBA code to reformat pivot charts to client’s style p upon refreshing of data.
• Built switchboards and menus for easy navigation between worksheets and applications

Confidential, Los ANGELES, CA

Responsibilities:

• Supported Claims Supervisors, Operations Manager and Priority Affairs Manager
• Created and maintained MS Access database to audit claims examiners.
• Created and maintained MS Access database to enable monitoring and auditing of member services representatives.
• Designed MS Access database for isolating, logging and reporting all overdue claims for the processing of penalty interest payments.
• Conducted classes instructing supervisors in advanced skills using MS Office.

Confidential, Glendale, CA

Human Resources Representative

Responsibilities:

• Supported District General Manager while reporting directly to Southern California Vice president of Human Resources.
• Created and maintained MS Access database for Human Resources Department.
• Responsible for all payroll reporting and record maintenance
• Conducted all new hire orientations, background and checks, along with collection and reporting of EEOC data.
• Mediated conflicts between supervisors and employees.
• Maintained Workers Compensation reporting and maintenance of logs