Ana Zapata Email & Phone Number

Broomfield, CO, US

Charlotte, NC, US

Broomfield, CO, US

• Built, mentored and led a high performing team of ten data engineers and data analysts, overseeing the development of data assets and reporting while actively contributing to advance data analytics for Analytics &.
• Managed annual OPEX and CAPEX budgets, in partnership with IT, Finance, Procurement and Legal. Owned vendor contracts with analytics technology partners like Tableau, Snowflake and FiveTran.
• Supported the development of an Enterprise Analytics data maturity framework and operating model to understand the current and future state of data in the P&L.
• Led a multi-year Data Driven Roadmap program in partnership with IT and Marketing to migrate data assets to the Enterprise Data Lake including the rollout of new CDP.
• Acted as a key member of the Data Governance Council, contributing to decisions on data strategy, policies and practices.
• Co-Directed the creation of a centralized one-stop-shop dashboard for Mountain Executives, improving efficiency for decision making.

Broomfield, CO, US

• Led and developed a team of four data engineers and data analysts to support data pipelines and self-service reporting across multiple lines of business (Season Pass, Visitation, Ski Lessons & Mountain Ops) with a.
• Led Tableau monthly Community of Practice “All things Data” meetings to support our data driven strategy and connect with analytics teams across the organization, grew our Tableau user community and usage by 200% in 1.
• Reimagined processes, ways of working and documentation to help streamline workflows to improve team efficiency, visibility and work quality.
• Managed stakeholder communications and defined reporting priorities on a monthly and quarterly basis for the team, as well as defining reporting requirements including new data or kpis needed from the business.
• Supported Data Integration projects, as part of Vail Resort resorts acquisitions, in testing of data ingested into the Enterprise Data warehouse to be used for reporting.
• Developed strategic partnerships with other teams and departments to identify future opportunities for enhancing business impact and advancing our data assets and technology, fostering a culture of continuous.

Denver, Colorado, US

• Led Colorado data engineering team, collaborated with offshore Brazil team. Oversaw Google Looker Reporting Development, data pipeline and web software development.
• Contributed to development of LookML Models for diverse healthcare data categories including Claims, Stop Loss, Membership, and Finance.
• Played a key role in AWS Cloud ETL development and architecture utilizing AWS Glue and Athena.
• Partnered with the Product Team to define Reporting Requirements and roadmap to improve prioritization & planning the work for the teams.
• Conducted code reviews, GitHub Pull requests, and facilitated Agile ceremonies for the teams which significantly improved team collaboration and success in delivering their work each sprint.

Oakland, California, US

• Led a major multi-year BI initiative, managing onshore and offshore teams for ETL and Tableau Report Development.
• Oversaw a multimillion-dollar IT Finance Reporting System project, consolidating financial data from 20+ systems into KP's unified Financial Data Warehouse for reporting, reducing manual data loads and improving data.
• Directed the creation of 150+ Tableau Reports, providing guidance on design, formatting, security, and best practices.
• Collaborated closely with Business, Solution Architects, and Data modelers to analyze requirements and devise optimal data integration solutions.
• Conducted comprehensive code reviews for both ETL and Report Development teams, ensuring adherence to best practices, security requirements, and design patterns.
• Reviewed team documentation, including source-to-target mapping, data lineage, and data flows.

Oakland, California, US

• Contributed to the development and automation of data analytics solution for Demand Planning and Inventory Optimization enabling data ingest to Hadoop platform, data transformation via SQL bash scripts and data.
• Contributed to Cognos Upgrade v10 to v11 and Motio CI implementation to incorporate automated test cases. This upgrade was needed to stay current on technology and agile adoption.
• Developed in 4 weeks a proof of concept that allowed our group to get funds and buy in from the KP Pharmacy Supply Chain team.
• Led and developed integrated Tableau Dashboard metrics for Inventory Turns, Days of Supply, Returns, Purchase Orders and Fill Rate which are key performance indicators for the Pharmacy and Supply Chain business owners..
• Served as Agile coach on multiple projects, which results in early delivery of project and reduced process waste caused by lack of common understanding.

US

• Led Data Migration for Cedars Sinai client from an older version of bConnected CRM to Salesforce.com via creation of Informatica ETL jobs for data mapping, replication to reporting databases and migration.
• Developed and Implemented a data archiving solution for UnitedHealthcare, working with over 5 years of data, 150+ tables. bash script tool allowed client to archive over 68% of the data and resolve production.
• Led Data Migration project for Kaiser Permanente. Migration of over 7 years of data from an older to newer schema. Large project that consisted of moving client from older CRM application to newly written HTML5.
• Worked with the multiple database administration teams within Optum to ensure databases, accounts, backups, configurations for the different environments were setup to meet environment, client, reporting, data.
• Supported various development teams on data modeling, schema changes, creation of complex SQL queries, query optimization, index and performance tuning.
• Contributed to development of Play Authenticator Standalone application to allow bConnected Play Framework to Authenticate users, to be reused by other Java Play Communities.

US

• Worked as part of the software development and engineering team in an agile-scrum software development environment creating web application for the private Health Insurance Exchanges with use of web services and.
• Assisted on the architecture migration of the bConnected CRM Platform using Groovy, Grails, backbone framework and HTML5.
• Led and Developed RSVP to Meetings in your community portal for UHC and AARP Medicare Plans. Site was developed using Google API and Groovy Grails.
• Developed enhancements and deliver new features for the Flex based bConnected CRM Platform and Web based application following a monthly or quarterly release plan for individual customers including USAA, My Custom.
• Developed new API’s for use of DRX Data for getting Provider and Medicine Cabinet RX Data for use of all our bConnected CRM customers.
• Developed custom Qualification logic for USAA customer on our CRM application. Logic would help drive Plan Qualification depending on State, Smoking Rules and other rules required by the customer.

US

• Worked as part of the software development team creating web applications for the private Health Insurance Exchanges with use of web services and model-view-controller (MVC) architecture.
• Developed enhancements and delivered new features for the Flex based bConnected CRM Platform following a release plan for major health insurance companies (Kaiser Permanente, UnitedHealthcare, ADP, Walgreens, Optum and.
• Developed and successfully Implemented new functionality for community meetings tool integrated into UnitedHealthcare's medicare solutions and AARP medicare plans web sites with use of jQuery Tools, Google Map API.
• Collaborated with project managers, business analysts and quality assurance specialists to review business requirements, define scope and deliver successful implementation of bConnected software releases.
• Provided ongoing support and direction to the multiple development teams in regards to schema changes and query tuning.
• Updated bConnected ERD, logical & physical data models.

Covington, Louisiana, US

• Developed and implemented web based timekeeping application to allow employee time tracking and integration with financial system using scheduled automated data exports and imports to automate payroll process.
• Worked onsite with Chevron, Exxon Mobil, Apache and Valero project managers in gathering of requirements of numerous types of reports that were customized for the client to provide instant insight into projects.
• Created a module within the application to perform performance evaluations and rate changes for employees, the system would automatically send an email request to HR for processing on Manager approvals.
• Built fundamental web application for district managers and the engineering team to enable tracking of bids, jobs, customer information, master service agreements, purchase orders, billing information, labor and.

• Worked closely with project managers and software development team in the development and creation of a multi-language social networking web portal for Venezuelan kite surfers and extreme sports community with feeds.
• Worked with graphic designer in defining sizing of images for banners and landing pages of both venakite and venamax portals.
• Developed and implemented multiple sections of the website including videos, classifieds, polls related to the tv show, user profile, blogs, newsletters, events, store catalog and content management system.
• Documented system requirements and portal functionality based on customer business needs.

Master Of Business Administration (Mba), Computer Information Systems

Bachelor Of Engineering, Systems Engineering, Computer Software Engineering