Val Herrera Email & Phone Number

Texas, United States

Pinehurst, US

• Health Care Services Corporation manager working with a team of six developers to support medical provider analytics. As a manager my primary responsibilities include leading developers in the development and.
• Provided guidance and practical skillsets to the team to improve growth, delivery of better outcomes, improving habits, and increase follow through.
• Set strategic direction and clear expectations to projects to get results quicker, remove barriers, and improve delivery results.
• Development of applications using MS Power Apps to provide a rapid development environment to address business needs. Current in-progress and completed applications include Provider Data Management, Credentialing.
• Leading the implementation and standardization of MS SQL Server best practices with respect to Tables, Views, Procedures, and naming conventions.
• Presented lunch and learns in topic related to: Data Visualizations, SQL Server Procedures, and DW Star and Snowflake Schemas.

Austin, Texas, US

• Everly Health (EH) direct-to-consumer (DTC) analytics manager leading a team of senior developers to support marketing, finance, sales, and laboratory. Work experience includes:
• Developed the “DTC Success Metrics Playbook” which identifies the Enterprise's Key Performance Indicators (KPIs) across various business units.
• Interacted with business users to gather requirements and design the conceptual project solution for the implementation of the KPIs.
• Worked on several projects that crossed multiple lines of business as part of the initiative to integrate data to provide a comprehensive view of our customers.
• Managed team Jira Sprint cycles and prioritization.
• Worked with analytic team members to document reports, data loads, data validation, and processes.

Dallas, Texas, US

• Baylor Scott & White Quality Alliance (BSWQA) manager leading a team of developers to provide Analytics support to medical providers, administrators, and committee liaisons. Work experience includes:
• Principal leader overseeing design, implementation, and maintenance of solutions to Business Intelligence (BI) and Analytics reporting deliverables.
• Developed SQL scripts (procedures, functions, tables, views) using SQL Server Management Studio (SSMS) to query, store, and analyze data from Data Warehouse, and various Baylor Health Care source systems.
• Principal leader in design, recommendation, and implementation of the reporting database architecture.
• Provide reporting and data visualization expertise and share data warehouse expertise with the companywide Analytics team.
• Managed BI/Analytics projects, requirements gathering, and business analysis.

Dallas, TX, US

• BI Reporting team member which provides reporting (SSRS, SSAS, Tableau) to our company’s various groups: Sales, Finance, Operations, Marketing, Products, Customer Care, Legal, and IT. Work experience includes:
• Created complex reports that included: Member Enrollment Rates, Member Retention, Enrollment by Promotion Types and Version, and Sales by Month and Promotion.
• Developed SQL scripts using SSMS to obtain data from OTLP and DW databases. Complex scripts included analytic, built-in, aggregate, and ranking functions. Scripts included a change history log, debug statement.
• Created and modified existing SSRS reports using Visual Studio for a native mode reporting environment. Daily experience included working with Tabular and Matrix reports with complex groupings, expressions, and.
• Created Tableau worksheets and dashboards that included hierarchies, parameters, actions, calculated fields, index, filters, rank, sort, bar charts, line graph, and custom palette. Deployed data sources and dashboards.
• Developed MDX scripts to query the Analysis Services cube for reporting. Experience included using named sets, calculated members, and slicers. Knowledgeable in cube perspectives, calculations, measures, dimensions.

Plano, Texas, US

• Member of the Data Mart team which provided BI for our company’s Sales, Finance, Operations, Partner Panel, and IT departments. Work experience includes:
• Provided BI reporting using Oracle Reports, OBIEE, SSRS, and business analytics using SSAS cubes. Created dashboards and scorecards using SharePoint Performance Point.
• Assisted in the design of the Salesforce dimensional models. Gathered requirements to identify business and process knowledge to create facts, qualifiers, and hierarchies to a matrix document.
• Created Informatica ETL loads to populate the dimensional models created to support reporting.
• Worked in various stages of the Kimball SDLC. Conducted meetings to gather requirements, understand reporting needs, and advise on the various business processes. Collaborated with teams to conduct data analysis and.
• Company subject matter expert for OBIEE reporting requests and issues. Principal lead in the creation of the initial OBIEE Oracle Repository, and the OBIEE Catalog for all development, test, and production environments.

IN

• A leader in providing administrative and cost control services for the risk management industry.Impromptu Web Reports (IWR) AdministratorMember of the BI Reporting team whose primary duties included setup, monitoring.
• Adding approximately 15-20 external clients to the company BI Reporting portal per month. This includes gathering client requirements from forms, emails and telephone conversations with account managers/client.
• Coordinate and assign tasks to other BI Reporting team members: DBA’s (security), Query Administrator (Cubes and Catalog).
• Respond to Client Representatives and Account Managers issues, comments or suggestions via an issue tracking process.
• Created a monthly workflow check list for setting up external and internal clients.
• Created an internal reference document that details all client information.

Frisco, Texas, US

• Analytics SpecialistMember of the Analytics team whose primary duties were to facilitate the design, creation, and implementation of internal and external client reports that enable the end user to better understand a.
• Designed and modified Impromptu reports using data retrieved from procedures.
• Published Impromptu reports and PowerPlay cubes to the internal web site.
• Used PowerPlay Transformer to produce PowerPlay cubes used for cross tab analysis and other comparison analysis.
• Created PowerPlay reports with user predefined percentages, suppressions, exceptions, ranks, and sorts. In addition, graphs were created for desired report sets.
• Facilitated the roll out of Impromptu reports and PowerPlay cubes to the end users. In addition, Cognos classes were conducted to assist the end users in understanding and working effectively with the Cognos BI Suite.

Plano, Texas, US

• A start-up email and web-based direct marketing program that rewards enrolled members for reading and responding to advertising and market research.Analytics SpecialistMember of the e-Rewards Data Warehouse team whose.
• Created and managed the E-Rewards Customer Profiling Data Warehouse.
• Installed, configured and tested the Informatica PowerMart (version 4.5-4.7) software on both client and server.
• Created development, testing and production folder mappings for loading departmental areas.
• Created mappings and batch processes to run nightly scheduled incremental loads and validated using check mappings.
• Created documentation that outlined procedures to correct and reload data.

Dublin 2, IE

Data Warehouse AnalystClient engagements involved working for PageNet, Hewlett-Packard, Harley-Davidson, and the United States Postal Service. Combined experiences include: interviewed business users and technical managers to define organizational, technical and functional capabilities and requirements. Identified repositories' source and target data.

Phelebotomy, Blood Bank, Microbiology, Hematology, Chemistry.

Arlington, Virginia, US

Phelebotomy, Blood Bank, Microbiology, Hematology, Chemistry.

Bachelor Of Science (Bs), Mechanical Engineering

Education record