Alex Perez Email & Phone Number

Remote

Austin, Texas Area

> Data Warehousing: Started, led, and completed a project to build a Data Warehouse for the entire organization using the full Azure Dev Ops stack: T-SQL, SSIS, Repositories (GIT), Boards (Ticketing system), CI/CD Pipelines (Continuous Integration/ Continuous Deployment).> Results Driven: Helped the organization meet pay-for-performance goals: from 34% to 92% success rate by communicating with multiple departments and providing them actionable reports and dashboards.>… Show more > Data Warehousing: Started, led, and completed a project to build a Data Warehouse for the entire organization using the full Azure Dev Ops stack: T-SQL, SSIS, Repositories (GIT), Boards (Ticketing system), CI/CD Pipelines (Continuous Integration/ Continuous Deployment).> Results Driven: Helped the organization meet pay-for-performance goals: from 34% to 92% success rate by communicating with multiple departments and providing them actionable reports and dashboards.> Dashboards & Reporting: Developed dashboards for each service line providing doctors and the business with the information necessary to know how each doctor is performing, including trending. Showing detail information on which patient needed attention and detailing why, specifically, each patient needed that attention. > Business Process Improvement: Created a web application to guide our call center staff through a decision tree based on symptoms to schedule visits. This accomplished consistency and uniformity in the call center’s scheduling decisions and lowered significantly the onboarding process for new staff. > Statistical Analysis: Developed a chi-squared study that dispelled outdated assumptions from providers on the potential use of anti-contraceptives based on patient’s race and ethnicity. > Vendor Management: Negotiated contract for the data warehousing project as well as an ongoing contract to provide support and assistance with BI development. > Standardization: Implemented a system for over one hundred reports produced by the Clinical Analytics team to follow the same methodology and process (even across multiple technologies).> Talent Development: Retained, motivated, and engaged existing team members and recruited, on boarded, and trained new hires.> Remote Leadership: Managed a remote team since March 2020 increasing productivity while keeping a high esprit de corps as well as the individual personal connections with each team member. Show less

Austin, Texas

> Process Improvement: Coordinated multiple teams to automate the process of adding new members to our programs: cut processing time from up to three weeks to less than three days and optimized it to handle ten times the volume.> Operational Efficiencies: Created Visio workflows for all of the company’s clinical processes and worked with our internal programmers to build them into the new Salesforce platform while also optimizing the process (removing extraneous steps): wrote… Show more > Process Improvement: Coordinated multiple teams to automate the process of adding new members to our programs: cut processing time from up to three weeks to less than three days and optimized it to handle ten times the volume.> Operational Efficiencies: Created Visio workflows for all of the company’s clinical processes and worked with our internal programmers to build them into the new Salesforce platform while also optimizing the process (removing extraneous steps): wrote requirements, answered developers’ questions, built test scenarios, and led a team doing User Acceptance Testing (UAT).> Clinical/Operations ROI Review: Developed various studies on different tasks performed by our clinical/operational teams to determine ROI and where to best focus resources.> Predictive Analytics: Created a SAS model that predicted future membership into our CMS risk sharing program (ESCO) up to three months in advance.> Data Visualization: Created a Tableau mapping tool that allowed upper management to better identify markets for growth opportunities with different layers by county, metro area, etc.> Data Analytics: Performed several ad-hoc studies on the cost of care for the population depending on different demographic or clinical characteristics to determine the highest-risk populations and geographical areas.> Critical Business Function: Developed and maintained all of the automated reports (thru SAS, UNIX) that impact business continuity directly: many teams’ entire schedule depends on these reports.> Talent Development: Trained new junior analyst who was new to SAS/SQL in less than six months to be able to work on programming tasks independently. Ran the intern program for the Actuarial Analytics department.> Mentoring: Made myself available to my team by advising them on everything they needed from career progression and defusing tense situations to teaching about SAS, SQL, and MS Office including macros. Show less

Austin, Texas Area

> Leadership: Led a team of five highly engaged employees through positive connections and knowledge sharing.> Process Improvement: Developed a methodology for processing incoming checks more efficiently by removing redundant steps, resulting in improved processing timelines from two to three days to within 24 hours for most deposits.> Project Management: Migrated team to a new system for depositing checks which resulted in increased float on funds, elimination of vendor risk… Show more > Leadership: Led a team of five highly engaged employees through positive connections and knowledge sharing.> Process Improvement: Developed a methodology for processing incoming checks more efficiently by removing redundant steps, resulting in improved processing timelines from two to three days to within 24 hours for most deposits.> Project Management: Migrated team to a new system for depositing checks which resulted in increased float on funds, elimination of vendor risk, and allowed for faster research of transactions by internal teams.> Standardization: Streamlined processing of outgoing wires by standardizing requests and creating Excel tools/macros that allowed for the elimination of manual inputs/typing within our team. Show less

> Process Improvement: Cut processing time by 50% of the monthly in-force database with policyholders demographic and benefit details by using automation of Access queries/macros.> Project Management: Coordinated two actuarial departments and outside consultants to update assumptions and test the results of a model ran on a quarterly basis. > Budgeting: Created the financial forecast for the Long-Term care division presented directly to the President and CFO.> Financial… Show more > Process Improvement: Cut processing time by 50% of the monthly in-force database with policyholders demographic and benefit details by using automation of Access queries/macros.> Project Management: Coordinated two actuarial departments and outside consultants to update assumptions and test the results of a model ran on a quarterly basis. > Budgeting: Created the financial forecast for the Long-Term care division presented directly to the President and CFO.> Financial Statement: Responsible for calculating the gross premium valuation (GPV) reserves on a monthly basis and explaining variances from forecast personally to the CFO. Show less

Houston, Texas Area

Austin, Texas Area

Austin, Texas Area

Bs, Mathematics: Actuarial Sciences

Business Foundations Certificate from the McCombs School of Business

Hs, Jc