Teaching common types of available health care data, along with different types of analytic tools used to report from that data. • Instructing on SQL and various data storage options such as relational databases and flat files • Course Materials also include:- Use of health care data for operations and management, quality, benchmarking, performance improvement, outcomes assessment and marketing - Health Information Exchange (HIE), Patient Portals, HL7 and EHRs - Population health management - Legal issues (HIPAA, fraud, lawsuits aimed at bad analysis)

Utilizing ETL and cloud database technologies including BigQuery, Matillion, MySQL, Jython/Python, and Bash to develop data pipelines for clients.

Utilizing ETL and BI tools including SSIS, Matillion, SQL Server, Snowflake, AWS, and Tableau to create automated actionable dashboards

• Using Tableau to build reporting dashboards for various departments• Creating Stored Procedures and Functions to generate SSRS and Tableau reports for the California Department of Healthcare Services and internal management• Data warehouse management and development• Using Pivot tables and power pivot to generate data summaries• Responsible for utilizing Electronic Medical Record and Claim data to build regulatory and internal reports based on parameters such as ICD9, ICD10, CPT, Diagnosis, LOINC, and HCPCS codes

- Creating SSRS reports and managing subscriptions in Report Manager - Creating GUI applications using IDE and C# - Creating Software Requirements Specification documents for developers utilizing the system development life cycle (SDLC) methodology- Using SQL to pull and report on relevant data- Working with Providers, Clinics, and Hospitals across southern California to manage and securely transfer member EMR (electronic medical record) data- Maintaining HIPAA standards and confidentiality of protected health information- Analyzing and auditing HEDIS measures data to support key business decisions- Working with NCQA vendors, consultants, and auditors to improve business practices- Using TriZetto QNXT to update and analyze member data

Responsible for annual Russell Index Reconstitution and equity research supporting all US and Global Index products currently benchmarked by 11 trillion dollars in assets.• Managed daily equity research supporting the US, Global, and all custom index products.• Assisted Index development teams in managing vendor data feeds and implementing proprietary databases.• Worked closely with Index Product Managers and Client Service teams to ensure high quality product offerings and exceptional customer service.• Managed and trained Reconstitution Interns, offshore research teams, and contractors.• Utilized Thomson Reuters Eikon, Bloomberg Terminal, Corporate Filings, SQL Server, Vendor data, and proprietary databases for equity research. • Aiding in the migration and quality assurance of data from Russell databases to FTSE after the London Stock Exchange’s acquisition of Russell Investments

Key contributor to product enhancements and outreach strategies for expanding Asian-style published free-to-play, micro-transaction based computer and mobile games to the western markets. Gathered and reviewed analytics on users and markets, enhanced testing and quality assurance, and executed robust social media strategies. Created SQL queries and used SSRS to create reports for player activity. Collaborated with operations, advertising, marketing, and technicians in the analysis of data and strategies for increasing the ROI of each game server and presented programming recommendations to game developers for attracting the western audience. * Data analytics on player behaviors played a key role in development changes that led to the 90% increase on ROI in the Dragon Atlas Server 5 game and a 300%+ ROI in Dragon Atlas Server 6. * Analytics related to player activity, demographics, and engagement were a critical component in design improvements, which resulted in a 75% increase in user engagement.

Audited deposits and researched departmental overages/shorts. Trained and supervised a team of 3 Auditors in transactional verification and inputting data into Rapid Transaction Processing (RTP) software. Performed in-depth analysis of operational data sets in order to identify potential cost savings. *Performed a variety of financial analyses in Excel to identify inefficiencies and potential costs savings related to workforce optimization and operational streamlining.

Prepared bank deposits, verified and balanced customer credit card transactions. Researched and resolved discrepancies within the RTP system.

In the Department of Biology, supervised and led experiments on chemical composition with the goal of creating new genetic strains of chrysochromulina algae with increased lipid production for the efficient creation of bio-fuels. Conducted statistical analysis of research results using Excel pivot tables and graphical analysis.

Within the department of Ophthalmology, buffered and prepared solutions for research. Utilized Microsoft Excel to input and analyze research data.