SUMMARY:

• Business Analyst, Data Analysis & Reporting, Advanced Excel “Guru” position with a dynamic company who seeks a person of integrity, great communication skills and the ability to manage and complete multiple tasks/projects on time.
• 12 plus years’ experience with MS Excel, MS Access, MS Word, MS Power Point and predecessors
• Oracle Business Intelligence Suite database queries (Hyperion BRIO Query)
• CyberQuery, Monarch Pro v11, Keane Optimum Medical, Medi - Analytics/COMPASS
• Extensive history developing and reviewing large, multi-department budgets. Expert data analysis and reporting skills. Comfortable in a regulated/quality systems environment (government, ISO, healthcare, etc)

PROFESSIONAL EXPERIENCE:

HR Data Analyst

Confidential

Responsibilities:

• Analyzed existing data that had been added and maintained over several years by numerous clerical employees. Information had been randomly entered, duplicated and combined into a date field, person and company name field, and an address information field.
• Used various formulas to extract combined information into separate fields to include date, first name, last name, company name, position/title, address, city, state, country, email address and notes.
• Created pivot tables and VLOOKUP’s to identify duplicate entries and split data into an address worksheet and related action worksheet. Assigned a unique field for both companies and individuals. dis enabled transfer of data to an MS Access database for future needs.
• Position required careful attention to detail, website research for current information and coordination with the needs of the current Administrative Editor tasked with ownership of future use, maintenance and updates.

HR Data/Reporting Analyst

Confidential, Denver, CO

Responsibilities:

• Queried large Oracle Business Intelligence database for sensitive personnel information for a variety of users. Downloaded data into MS Excel/Access for analysis and forwarded to requesting Business Managers for their review. Participated in analysis and reporting of large, yearly company employee survey comparing results from previous years to current year.
• Compared trends on how well high-level managers and organizations were doing based on employee survey results. Along those lines, also used a program called Vovici Survey
• Software (byVerint), to download self-assessment vs. manager assessment of key employee skill sets to evaluate future needs within participating departments. Results were reported using MS Excel pivot tables, charting, and heat maps using complex formulas like Match/Index combinations. Reason for leaving: Completed extended contract period.

HR Reporting Analyst

Confidential

Responsibilities:

• Reviewed, validated and cleaned data for import into MS Excel worksheets. Manipulated, formatted and updated employee info to eventually be imported into Oracle HR application.
• Extensive use of vLookups, pivot tables and filtering. Special projects included ADP Virtual Edge HR Recruiting software query generation with downloads to Excel and an update and redo of a Power Point Yearly Project Status Report. Reason for leaving
• Position turned out to be very part-time and anticipated ad hoc reporting did not materialize due to turbulence in department caused by company take-over and transition.

Business Analyst/ Patient Data

Confidential

Responsibilities:

• Asked to develop a variety of Ad Hoc reports on patient data and trends to include specialty areas like High Dollar Patients, Generic vs. Branded drugs, Diabetes, Cardiac (CAD), 3+ ER visits, multiple Providers and Prescribers.
• Downloaded huge data sets obtained from a large Insurance Third Party Provider into MS Excel. Imported CSV Text files, cleaned and validated data to include CPT-9 Codes and Diagnosis Codes and added computed/concatenated columns for specific reporting requirements.
• Developed charts and pivot tables and the new “slicer” analysis tool to enhance drill-down views of patient data. Responsible for safeguarding sensitive data. Reason for leaving: Onerous daily commute to Boulder along with the completion of startup/implementation duties.

Business Data Analyst

Responsibilities:

• Acted in the capacity of MS Excel “Reporting Guru” in preparation for the Annual Ernst & Young Audit of User Access for Adventist Health Care Systems. These systems included Human Resources Information System, CERNER Medical and Novell eDirectory. Tasked to combine multiple databases of employee
• Business Partner, and contractor information using VLOOKUP tables and complex formulas. Performed standard data cleansing techniques to insure key fields were suitable for correct matching of information from multiple tables.
• me then analyzed previous year’s reports and simplified the look and feel of numerous files sent to several regional locations and over 1200 medical departments. Created several MACROS and reviewed VBA code to speed up processes. me applied worksheet password protection schemes to eliminate unauthorized modification of update files. Used a combination of conditional formatting, formulas and data validation lists to limit work center response which greatly reduced errors and time required to complete dis big project.
• Identity Services was commended by Field Supervisors for our innovative efforts in making dis year’s reporting requirements much simpler to use, faster, and more intuitive. Reason for Leaving: Successfully completed dis intense, time-sensitive, short-term, contract.

Business Analyst

Confidential, Stockton, CA

Responsibilities:

• Accepted responsibility for daily Financial Dashboard and Key Performance Indicator reporting of revenue sources from various hospital departments. These sources included private pay, as well as insurance providers to include San Joaquin Health Plan
• Blue Cross, Aetna, Medicare/Medi-Cal, Veterans Administration and others. Downloaded data daily from Keane Optimum Medical Patient Accounting System using CyberQuery tools,
• Data Services Group using GUI and ODBC connections and MediAnalytics using COMPASS executive level reporting tools. Provided first level data validation and logic checks of financial data then transferred data into MS Excel and formatted, charted and enhanced several hospital reports. Another program that proved to be helpful in working with “green-bar” reports was
• Monarch Pro v11 which me used to capture “green-bar” text files and import data into MS Excel. Additionally, asked to run numerous ad hoc reports for supervisors and managers. During my tenure, me has streamlined data gathering procedures which has added to the accuracy and timeliness of high-level reports going to top management.

Business Analyst

Confidential, Oakland, CA

Responsibilities:

• Responsible for extracting data from one Project Tracking Software Application and converting to a new Project Tracking and Accounting Software Application for several locations within Kaiser National Facilities Service Regions. Selected appropriate database fields and queries and downloaded existing financial and project data using a Graphical User Interface (GUI), into large CSV and text files. Uploaded text files into
• MS Excel using the Text Import Wizard specifying field delimiters and data formats like General, Text or Date fields (a critical step). Analyzed, corrected and validated thousands of rows of data using VLookups, Pivot Tables and complex multi-nested formula equations. Researched original data within existing Project Tracking Applications to include contracts, changes and invoices. Cross-d several data sources and explained or corrected anomalies when validation checks failed. Re-ran reports to insure all data entered into the new application matched previous system data and totals were reconciled.
• Participated in developing a reporting system and archiving data from the previous application to facilitate audit trails for future and to meet SOX compliance requirements. Reason for leaving: Implementation process successfully completed during extended contract period.

Business/Database Reporting Analyst

Confidential, Mountain View, CA

Responsibilities:

• Responsible for reporting baseline metrics on incidents and outages for Hotmail, MSN Storage, and Windows Live. Worked with Confidential ’s Problem Ticket Tracking system.
• Pulled data from a large data warehouse using a proprietary GUI - XML Interface (like MS SQL). Met with Program Managers to determine their reporting needs. Reviewed database schema, data field definitions and available fields.
• Created queries and pulled data into MS Access 2007 and MS Excel 2007 for analysis and reporting. Developed complex formulas that corrected erroneous or missing date/time stamps. Used built-in formulas like COUNTIF, SUMIF, SUMPRODUCT and IFERROR.
• Created Pivot tables and charts to trend data for director-level briefings. Transferred/linked Excel worksheets to PowerPoint slides and archived files to MS Share Point. Reason for leaving:Completed short-term contract.

Marketing/Business Analyst

Confidential, San Ramon, CA

Responsibilities:

• Advanced MS Excel worksheet manipulation, VLOOKUP and Pivot Tables, Macros (VBA code), advanced filtering and complex formula development. Worked with file data imports from large extract files (to include data from a Customer
• Relationship Management (CRM) application like Salesforce.com), transferring data between Access and Excel. Routinely created MS Access tables, queries, joins and exported data to Excel for ad hoc Marketing/Sales reports
• Analyzed and repaired complex, linked worksheets that would no longer process data or were extremely slow and unstable. Developed a monthly Excel-based Marketing/Sales Dashboard for multiple BAY Regions consisting of numerous interconnected worksheet tabs showing visually appealing data in both tabular and chart formats.