We provide IT Staff Augmentation Services!

Database Consultant Resume

Pasadena, CA

SUMMARY:

Exceptional ability to analyze, manipulate, and extract insight from data, particularly Clarity data, using Oracle and Teradata SQL, Microsoft Excel, and Crystal Reports. Comfortable communicating and presenting data insights to all levels of an organization. Demonstrated leadership in training team members, introducing new applications to improve team efficiency, and setting team standards. Driven to help hospitals and health systems understand and use data to improve patient care, operational efficiency, and patient safety.

RELEVANT EXPERTISE AND COMPETENCIES:

  • Oracle/Teradata SQL
  • Crystal Reports
  • SAP Business Objects/Web Intelligence
  • Microsoft Office Suite
  • TOAD/RazorSQL
  • Subversion/Box
  • Hive/Impala

PROFESSIONAL EXPERIENCE:

Confidential, Pasadena, CA

Database Consultant

Responsibilities:

  • Led Clarity data extraction for two major, on - going regional projects of the Business Enablement team:
  • Influenza-Like Illness (ILI) Predictor - predicts beginning of flu season 2 weeks in advance w/ accompanying Tableau flu story, tracking progression of flu throughout SoCal region.
  • Developed ED to Inpatient patient flow logic; a major pain point and source of inaccuracy for the model previously.
  • Implemented logic to eliminate high-utilizers (excludes multiple encounters from any rolling 2-week period) from ILI encounters for heatmapping.
  • Created queries to pull positive lab tests for the flu; increased positive result identification to >99% through notes search.
  • Developed query to identify patients vaccinated for flu, excluding multiple vaccinations within a single flu season.
  • LGBTQ Patient Log and Registry - effort to identify and track transgender patients to improve surgical and non-surgical outcomes for the population.
  • Developed logic to identify, with >99% accuracy, transgender patients in the Confidential system via diagnoses, mental health notes, gender assessments, and referrals.
  • Created query to accurately identify non-standard mental health letters of recommendation for transgender surgery.
  • Refined queries for referrals, demographics, and surgical encounters for transgender patients.
  • Developed query to find potential domestic abuse victims among children <2 years of age through use of Best Practice Advisories.

Confidential, Los Angeles, CA

Senior Reports Specialist

Responsibilities:

  • Designed, coded (in Oracle SQL, Crystal Reports, and SAP WebIntelligence), and documented reports for a wide-range of customers using the Epic Clarity Data Model (Phoenix, PB/HB, Radiant, Inpatient, Ambulatory, OpTime, ADT, and ASAP modules, primarily) and Confidential - Confidential ’s internal databases.
  • Responsible for creating and maintaining 14 CA IHA Pay-For-Performance (P4P) project - an important annual hospital benchmark for CA and revenue source for individual hospitals.
  • Led initiative to implement Subversion version control to improve team efficiency and code accountability, trained team members in its use, and oversaw its adoption.
  • Led creation of team Wiki to share knowledge and establish team coding standards.
  • Led effort to standardize design and presentation of P4P reports to assist doctors and administrators in raising P4P benchmark performance.
  • Responsible for mentoring two new employees: teaching them SQL, Crystal Reports, and Business Objects; introducing them to the report development process; and being an ongoing go-to for Clarity questions.
  • Awarded 3 Standing Ovations, given by customers for outstanding work and service.

Confidential, Los Angeles, CA

Co-Founder

Responsibilities:

  • Co-designed SootheMate, a thermo-insulated cold sleeve to prevent and relieve tennis/golfer’s elbow.
  • Took responsibility for all sales - including cold-calling, selling to local stores, and presenting product to store buyers.
  • Increased sales 300% over 6 months - revenue from ~$500 to ~$2000/month - by implementing Google Adwords and Facebook campaigns and tracking website performance/user interaction with Google Analytics.
  • Designed/coded SootheMate website designed posters, product labels, and mail flyers.

Confidential, Washington, DC

Research Systems Analyst

Responsibilities:

  • Analyzed and created reports of monthly process accounting data and software usage (coded in SAS).
  • Created regression test for software packages maintained by group, wrote script in Perl and shell script.
  • Provided SAS code support for economists in Research and Statistics and Monetary Affairs divisions.
  • Provided Unix and Windows software and systems support (including for SAS, EViews, Ruby, and Exceed).

Confidential, Washington, DC

Intern

Responsibilities:

  • Created and maintained tracking reports for prime loss severity models (gross severity and for various cohorts).
  • Analyzed default rates, costs, and government reimbursements for pools of FHA-insured loans.
  • Created report of foreclosure fees and costs for REO cases completed April-June 2008.
  • Examined loan-level data and company treatment of loans with subordinate financing.
  • Worked with loan modification data, tabulated default rates, tracked performance of various cohorts and vintages of modified loans.

Hire Now