System and Analytic, Reporting Analyst
St Joseph Health System
Total years of experience :26 years, 1 Months
Develop duplicates and erroneous data filters/alert system in our SQL database. It schedules to run hourly to ensure data integrity.
•Develop KPI vendor performance report in SharePoint VFPA engine, SQL Database, and Excel Service.
•Develop live reports using Excel Services, Power Pivot tables inside SharePoint environment for Vendors Management team in Revenue Cycle Services (RCS).
•Construct and maintain dynamic SharePoint Excel Services Reports such as daily issues log report; issues log age-bucket report, Placement and Return report, Vendor Automation Process History report, File Control Master report, and month and weekly Step Down report, and Vendor Performance report.
•Clean up datasource, apply filters and calculations, aggregated functions, eliminate duplicates, build appropriate data structures, and create views using SQL queries from Management Studio (SSMS).
•Develop and maintain SharePoint forms, list, workflow, and library.
•Execute queries periodically in our Access database system for updating the vendors’ account activities.
•Create Ad-hoc reports base on the datasource from BenchMark, Compass, issue log history, and Vendor File Performance Automatic database.
•Construct and maintain SharePoint communication log between vendors and RCS departments.
•Build and maintain document and report library in SharePoint so that the information can be across departments and vendors.
•Constant communications with different hospital's vendors for up-to-date reports and data.
Jack in the Box, Business Intelligence, BI Analyst (Contracting with TekSystem) 2012
• Actively participate in many team-oriented reporting projects in portal for Corporation and Restaurant Franchise Operators. Projects include standards assessment (SA), SA consecutive failure, regional marketing performance, Coupon evaluation, Speed of Service, and Voice of Guest.
• Create and execute packages using Integration Services (SSIS) for disaster recovery project.
• Create Weekly Business Indicators report on our BI portal using Report Services SSRS.
• Validate sophisticated reports using either SQL queries, ProClarity, or excel formulations.
• Use Microsoft SQL management studio 2008 to generate reports, write SQL queries (create views, generate summary reports, execute operations), and perform advanced excel analysis.
• Create and construct report pages on our BI portal using Microsoft SharePoint.
Collaborate with team members to develop innovative Excel solutions for database applications.
•Actively participate in several team-oriented projects such as Epic-PeopleSoft crosswalk, Provider-Based Billing testing, and Department Report Card project.
•Generated SQL queries to retrieve data for the reports according to the client’s request. Experience with Microsoft SQL, Microsoft Access database and Toad servers.
•Conducted 10 MS Excel training sessions for 40 employees within Revenue Cycle Groups. Team members became more Excel proficiency in shortcuts, formulas, functions, vlookup, charts, and pivot table. Developed MS Excel exercise, training materials, and detail manuscript.
•Demonstrate ability to acquire and apply new concepts quickly. Understand terminology and concept of revenue cycle and hospital billing; Capable of navigating and generating reports from Epic applications.
Established partnership with a San Diego/Tijuana manufacturing company. Developed and executed selling strategies through several websites such as EBay, Amazon, and Mexico Mercado Libre.
•Observed market trends and conducted research analysis and financial analysis; developed strategic planning and market requirement specifications.
•Estimated revenues and costs, established pricing, and managed inventory. Maximized profits.
Optimized relational tables and reconstructed SQL queries such as table joining, advanced filtering, and table manipulating to improve performance
•Restructured a dynamic, database-driven, programming-rich website. As a result, it improved internal communication, and yielded higher publicity and revenue for the organization.
•Initiated weekly e-newsletters (from constantcontact.com) to promote activities, exhibitions, and time schedules to thousands of members.
Created and maintained two dynamic and high-traffic websites.
•Produced and presented weekly web-performance reports.
•Developed and interpreted summary reports on median pricing of San Diego real estate.
•Performed data analysis, trends analysis, regression, and forecast analysis using Microsoft Excel.
Established and designed rational Microsoft Access database, SQL Queries, and web programming for two dynamic websites. SQL experiences included Wildcard card, joining, filtering, creating, updating, and deleting table.
•Created an internal website, an alternative communication channel, contained forms, documents, newsletters, and safety guidelines. Researchers were able to access information more effectively.
•Developed ability to incorporate marketable website from user prospective as well as managerial prospective. Managed multiple projects and performed highly demanding tasks as web administrator.
Generated, collected, interoperated, and reported experimental data from Surface Energies, Calcium, and Fluoride measurement using MS Excel spreadsheet.
•Developed strong quantitative, analytical, and problem solving skills by conducting scientific research. Developed excellent presentation skills from national scientific meetings.
in
, Major in