Jill Stern Email & Phone Number

Stamford, Connecticut, United States

Manchester, New Hampshire, United States

Contracted through Alexander Technology Group. Supported cross-functional teams during the transition to a Banner-based environment.• Supported Team Leads, business analysts, data architects, and other colleagues.• Developed, rebuilt, and optimized SQL data sources and Power BI wireframes.• Dashboards for Marketing and Admissions tracked metrics such as New Start Melt Rate, Admission Lead Conversion, and progress towards Enrollment goals.• Student Finance reports ensured completeness and accuracy of data on Pell Grants, Direct Loan disbursements, Satisfactory Academic Performance, and FAFSA records.• Reconciled cases where wireframe metrics displayed unexpected volumes, rates, or trend lines.• Adapted data sources, reports, and dashboards to an ever-evolving environment.

Great River, New York, United States

Provided IT Support for Saint George's University, a medical school and university in Grenada, West Indies. Collaborated with colleagues in IT and functional users across the University to answer key business questions, improve processes, and support day-to-day operations.• Developed, enhanced, and troubleshot operational reports to provide timely and accurate information to Financial Aid, Registrar, Office of the Dean, and the School of Medicine.• Provided departments with the tools to track academic performance and identify at-risk students.• Developed, implemented, and maintained UC4 processes and Oracle APEX applications to efficiently update student records, reducing data entry and freeing time for other work.• Adapted reports and ETL processes to ERP updates, changes in curricula, or new academic terms.• Served as Subject-Matter Expert in user interfaces and back-end databases of several applications, including Ellucian Banner, Sakai (Learning Management System), and StarRez (Housing Management).• Developed PL/SQL packages used in ETL processes, as well as packages used in tracking Clinical students’ rotation weeks and progress towards graduation requirements.

Garden City, Ny

Business Intelligence• Collaborated with management, BI build team, and subject-matter experts during development, implementation, and enhancement of physician scorecards, HEDIS Outreach List, and ETL processes.• Wrote and reviewed functional requirements.• Designed and reviewed ETL processes based on stored procedures and SSIS packages.• Troubleshot data quality issues and found new data sources.• Performed data profiling and data modeling.Reporting and Programming• Designed and enhanced ad hoc reporting, illustrating trends in provider productivity and clinical quality.• Met with management and end users to determine reporting and analysis needs.• Created and enhanced user-friendly financial reports, pivot tables, and dashboard charts.• Wrote SQL Server scripts and stored procedures.

Garden City, Ny

Designed, implemented, and troubleshot reporting solutions for programs that attained PCMH certification for medical offices, increased HEDIS compliance, and tracked physician productivity. Collaborated with medical directors, executives, and corporate staff to develop financial reporting. Provided scheduled and ad hoc reports. Updated key financial and demographic tables in data warehouse.

Performed on-site support, troubleshooting, and technical support during implementation of EMR. Provided classroom training, new hire orientations, and other support to staff and physicians. Wrote and edited training manuals and user guides. Taught proprietary applications as they applied to QLIMG job roles.

Master Of Science - Ms, Analytics, 3.91

Ba, Government, 3.73

Activities and Societies: Phi Beta Kappa