Pedro Castillo Email & Phone Number

Land O' Lakes, Fl, Us

Coral Gables, Florida, Us

• Create impactful and physician-facing Power BI reports/dashboards communicating different performance metrics.• Developed report packages which consisted of a suite of physician facing SSRS reports that reduced the number of monthly data driven subscriptions by 90%.• Significantly increased team report development efficiency by creating SSRS report templates with predefined datasets, parameters, and design/branding.• Developed SSRS reports focusing on different business domains such as HCC Suspects, Stars, Eligibility, Claims, Revenue/Deficit, and Pharmacy that increased patient health outcomes, reduced costs, and increased revenue through physician reward programs.• Increased reporting disaster recovery capabilities as well as collaboration and accountability by setting up Azure DevOps version control Git repositories and providing Git training to team members.• Mentored junior developers by fostering independence, critical thinking, and problem solving using various teaching techniques and promoting independent research improving productivity and increasing personal and team morale.

Coral Gables, Florida, Us

Coral Gables, Florida, Us

• Provide training and guidance to a Jr. SSRS Report Analyst.• Gather business reporting requirements and specifications to provide appropriate reporting solutions, primarily with SQL Server Reporting Services (SSRS).• Develop advanced T-SQL/Azure SQL queries and stored procedures for SSRS reporting which include using common table expressions (CTEs), window functions, merge, subqueries, loops, etc.• Develop reports that are used by physicians to help them monitor different metrics of their panel.• Develop wide ranges of reports, such as: Stars/Quality Gaps, Fund Pool, Surplus-Deficit, Membership, HCC Suspects, and Pharmacy.• Lead Developer for the Explanation of Capitation and Monthly Provider Payment Report used to issue capitation payments to providers for DCE LOB on a monthly cadence.• Standardize SSRS reporting layout across all LOBs.• Implement departmental and reporting folder structure on the SSRS web portal.• Devise data-driven subscriptions and jobs for report automation.• Integrate and arrange Azure DevOps Server (formerly Team Foundation Server (TFS)) version control for SSRS reports.

Las Vegas, Nv, Us

• Create SSRS and Power BI reports using the pulled data from Dynamics 365 to meet client requirements.• Manage all SSRS/Power BI reports on our departmental SQL Server instance.• Configure Azure DevOps version control to maintain and keep track of SSRS and SSIS files and train colleagues on using version control.• Create SSIS packages to pull data from Dynamics 365 (dataverse) using KingswaySoft for reporting purposes.• Satisfy ad hoc SSRS/Power BI reporting requirements in an efficient and timely manner.

Scottsdale, Arizona, Us

• Review PowerPoint slide deck and provide feedback on curriculum.• Build demonstration environment which includes setting up the following: SQL Server Express Database Engine, SQL Server Management Studio, restore an AdventureWorks database, Visual Studio Community 2022, and SSRS configuration/set-up.• Prepare SSRS demonstrations to go along with their relevant content in the slides deck which involves preparing necessary datasets, stored procedures, views, tables, and reports/visualizations/dashboards.• Set up studio recording equipment/environment with the help of a producer.• Answer student questions related to T-SQL querying and SSRS.

Hampton Roads, Va, Us

• Download/import all Stars related data such as Disenrollment, Part C Appeals, CTM, SNP HRA, Part D Acumen, and Part C HEDIS on a monthly basis.• Manage and maintain all Stars related Excel reports and Tableau dashboards.• Develop provider-facing Tableau Stars Dashboard and Gap List to illustrate open gaps and measure rate trends.• Develop a Tableau Membership Dashboard to monitor monthly membership as well Annual Wellness Visit trend.

Minnetonka, Mn, Us

· Write TSQL queries, stored procedures, and functions to meet client and management report requirements.· Create SQL Agent jobs for process and report automation.· Develop and design reports according to user ticket specifications using TFS version control, Visual Studio, and SQL Server Reporting Services.· Develop small scale applications with Access as front-end and SQL as back-end to meet customer requirements, which includes data modeling and normalization, creating tables, views, and stored procedures.· Develop TSQL Stars measure-specific reports by reading and interpreting the NCQA HEDIS specifications.· Engage with users and collaborate with colleagues to meet report demands and requirements.· Prepare KPI visualizations and dashboards, with filters and parameters, to gain insight and view trends using Tableau Desktop and publishing to Tableau Server.

Minnetonka, Mn, Us

· Develop Access database solutions for Call Center Stars initiatives and update periodically – specifically for measures including OMW and MRP· Develop reports regarding the initiatives in the Access databases· Interpret HEDIS specs in order to help develop complex measure-specific reports with Data Services· Perform Stars data analysis using Excel and SQL Server (T-SQL)· Communicate data analysis results with leadership and team members· Fulfill ad hoc T-SQL dataset requests for colleagues

Minnetonka, Mn, Us

· Project Manage several initiatives to collect medical records for Hedis/Stars· Manage and present the Hedis/Stars Initiatives Dashboard to all Managers and Executives weekly· Analyze data in Excel for accuracy before it’s submitted to our Hedis vendor· Coordinate biweekly meetings with our vision vendor regarding Hedis/Stars

Minnetonka, Mn, Us

Minnetonka, Mn, Us

Bachelor'S Degree, Data Analytics

Master'S Degree, Exercise And Sports Science

Bachelor'S Degree, Exercise And Sports Science