Jack Shahnazarian Email & Phone Number

Purchase, Ny, Us

- Design, manage, and deliver global pay reporting processes- Management of PostgreSQL database warehousing compensation, benefit, and demographic data- Support design and delivery of year-end compensation adjustments, bonuses, and stock grants- Providing analytics, reporting, and insights for data-intensive projects across Total Rewards (compensation, benefits, time off & leave, and global mobility)- Building intuitive, practical tools in VBA and PowerAutomate for teammates’ benefit

Purchase, Ny, Us

- Oversaw development of SQL database to aggregate de-identified benefit, compensation, SDOH, and demographic data to deliver real-time insights on utilization of benefits, employee and company spending, and emergent trends.- Managed relationships with several benefit vendors. Aimed to deliver seamless employee experience, maintain robust and competitive benefits, and attract/retain key talent. Launched SSO integrations for several key vendors. - Played a key role onboarding new benefit vendors, ensuring accurate interface between Workday and external platforms, and off-boarding outbound vendors.- Developed, delivered, and presented both internal and employee-facing communications, policies, and plan documents.- Ensured compliance with internal policy, as well as local, state, and federal laws.

Denver, Colorado, Us

- Leveraged Oracle SQL to pull, re-price, and analyze tens of millions of rows claims experience, enrollment, and eligibility data to develop per-member, per-month capitated payment ranges- Analyzed financial statements, utilization data, network adequacy, and cost trends to provide key talking points when negotiating rates with Colorado's 8 Regional Accountable Entities (RAEs)- Performed reconciliations. Coordinated between departments (Finance, Controls, Budget) to facilitate. - Improved and automated several manual processes by use of VBA- Worked with procurement to ensure adequate liquidity and support for out-of-scope projects- Aggregated data, created dashboards, and provided weekly updates on Substance Use Disorder utilization and estimated cost to the department's Executive Leadership

Denver, Colorado, Us

- Extensive use of Oracle SQL, Microsoft Excel/Word/VBA, Tableau, and others to deliver analyses- Support development of monthly capitated benefit rates for the statewide Behavioral Health Benefit (covering roughly 1.2 million State Medicaid Participants)- Retrieve, analyze, and deliver Medicaid enrollment, eligibility, and other demographic information- Perform reconciliations based on medical loss ratio (MLR), quality metrics (KPIs), and risk corridor agreements- Work with Office of Quality & Compliance, external auditors to develop auditing criteria, execute audits- Work collaboratively with external stakeholders to develop new specifications for recurring encounter file submissions- Facilitate communications with executive leadership, 8 Regional Accountable Entities (RAEs), contractors, internal and external auditors, federal partners (CMS), and state partners (CDHS, Governor's Office)

Baltimore, Maryland, Us

Intern in the Terminal Funding department (unit of Transamerica's Defined Benefits Operations). Project Manager for an undertaking to reallocate $19 million in reserves for 1,900 plan participants, providing:- Tracking and Updating to multiple departments (Legal, Actuarial, Finance, Risk, Control, Unclaimed Property, and Operations) - Training and Coaching team members; Quality-Checking team member outputs to ensure accuracy and consistency within project parameters- Support as a primary point of contact for questions, issues, and conflicts; having the resourcefulness to resolve such instances- Analysis and Manual Calculations of payee amounts via use of actuarial conversion factors, interest tables, and present values- Implementation of more efficient protocols for specific applications when possible- Development of standard operating procedures for future projects of similar scopeAt this internship, I have had considerable exposure to multiple facets of the corporate world, sought out and seized leadership opportunities, and utilized my experiences to refine my skillset. Since beginning the internship, I have:- Gained additional proficiency in Microsoft Excel (VLOOKUP, Pivot Tables), Outlook, and Sharepoint, and become proficient in Microsoft Access, Teams, and Visio (as well as exposure to VBA and SQL). - Developed the skills necessary to resolve intricate client requests via phone and email- Learned, then applied concepts pertaining to defined benefits, project management, and customer service- Balanced working part-time with attending school full-time

Began as a waiter in Summer 2016, assumed managerial duties in Winter 2016 (reconciliation, catering & special events, tip distribution, schedule and personnel management, error resolution, guest satisfaction). Additionally, tasked with training new hires and ensuring compliance with local health codes.

Denver, Co, Us

Organized and facilitated both hot & cold entrée expedition in a high-pressure kitchen environment. Worked with emphases on formal service, allergen training, and proper communication.

Greenwood Village, Co, Us

Front Desk Staff for Denver's most exclusive and prestigious health club. Promoted to Shift Manager in January 2014. Prioritized client satisfaction; operated and reconciled point of sale terminals; embraced responsibility for opening and closing shifts.

Master Of Business Administration - Mba, Concentration In Business Analytics

Bachelor Of Arts - Ba, Economics

High School Diploma