Total Years of Experience: 25 Years, 11 Months
January 2013
To Present
System and Analytic, Reporting Analyst
at St Joseph Health System
Location :
United States
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.
•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.
April 2012
To December 2012
BI analyst
at Jack in the Boz
Location :
United States
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.
• 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.
January 2011
To October 2011
Application/Business Analyst
at Rady Children’s Hospital
Location :
United States
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.
•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.
January 2009
To January 2010
E-commerce consultant
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.
•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.
January 2008
To January 2009
Website Developer
at Reuben H. Fleet Science Center
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.
•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.
January 2006
To January 2008
Technical and Website Manager/Graduate Research Assistant
at University of San Diego, Trans-Border Institute/Business School
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.
•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.
January 2001
To January 2005
Web Administrator
at Polymers, National Institute of Standards and Technology
Location :
United States
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.
•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.
January 1996
To January 2001
Research Associate
at American Dental Association Health Foundation
Location :
United States
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.
•Developed strong quantitative, analytical, and problem solving skills by conducting scientific research. Developed excellent presentation skills from national scientific meetings.
Share on Facebook
Share on Twitter
Share Via Email