Janet Yang Email & Phone Number

Working on Medicare and Medicaid claims for health care services.Serving ad-hoc analytic requests, providing timely reports and analysis.Utilizing Cognos, SSMS, Access (VBA) to generate regular, ad-hoc, and financial reports.Using Medicaid Management Information System (MMIS) to identify other insurance and resources for third-party reimbursement of Medicaid expenditures.Identifying opportunities to improve and enhance existing reporting programs.Developing user-friendly database applications using Access queries and VBA code.Reviewing data to ensure integrity, accuracy and validity.

• Provided analytical data-driven solutions to the healthcare and pharmaceuticals industry. In my role as Strategic Data Analyst, worked to analyze customer’s business needs, establish data models accordingly, leverage our database strength, and generate solutions for our clients.• Produced customized deliveries for various business needs, such as social-networking, targeted product marketing, internal process streamlining /efficiency improvement, etc. • Organized and managed data production process using SQL, VBA, and in house tools.• Cooperated across various teams (Core Data science, Sales, Marketing, Project Management) to achieve project goals.

Danbury, Ct, Us

• Worked on Commercial Claims Data such as Health Insurance Claims, PharMetrics, Medicare and Medicaid data using SAS language for clients in the managed care and pharmaceutical industries with large-scale patient-level medical claims databases. • Organized and managed data production process that supplied analytic data to health plans using SAS program. • Analyzed analytic data on patient demographics, costs, utilization of healthcare services, drug therapies, and procedures used to treat a specific disease of interest from complex data sources in SAS, SQL.• Utilized SAS programming, statistical knowledge to analyze healthcare claims data and provide custom solutions that address market research needs for clients. • Processed & generated data outputs such as reports, tables and figures for project specific client needs.• Automated data processing applications using SAS macros.• Responsible for companywide global databases quality control tests.• Developed disease model to analyze data trend and pattern for certain diseases such as: Coronary Artery Disease.• Cooperated with internal clients and team members on project delivery schedules, special customer requirements, and new approaches.

Boston, Ma, Us

• Worked on large and complex health care data from clinical personal and oncology databases in a data-warehouse environment.• Wrote queries to extract datasets according to Clinical Trial Specifications of inclusion and exclusion criteria • Developed and managed SAS/VBA-based reliability analysis and reporting system in automation process for instrument that provided methods with analyses reports for data sample auto read in, disease pattern detections in medical health samples, and clinical research.• Reviewed, and retrieved data using SAS and SQL languages from data warehouses for completeness and consistency.• Generated data analysis records and accurate data reports (tables, graphs) to clients.• Communicated with clients through phone and E-mail to ensure high quality client service and customer satisfaction.• Documented business and technical records for various data processes using Microsoft Office (Access, Word, advanced Excel features like Pivot tables and charts, PowerPoint), Crystal reports.• Promoted as manager to provide resources and supports to team members for ongoing projects.

Ca

• Worked in Network Data Management group as project leader. Responsible for end-to-end grasp of entire software development life cycle including analysis, correct errors, development and testing of software applications.• Added new features and enhancements across different platforms to continue improve product performance with Java, C, and Perl script.• Applied peer code review to guard junior team members against programming error to ensure the high quality of products.• Worked as a liaison between clients and engineers, resolving client issues in a timely manner.

M.S., Computer Science

Sas®9 Certified Base Programmer, Data Processing And Statistical Analysis