Hector Garcia Email and Phone Number

Led the design and implementation of a robust data platform for Lingo, supporting all aspects of product administration—including sales, marketing, and product development—while providing dataservices and insights for UK and US users, solidifying Lingo’s position as a market leader in healthcare technology.• Architected scalable data pipelines for real-time ingestion from multiple sources, ensuring high availability and performance, which enabled real-time analytics for critical functionalities.• Collaborated with cross-functional teams to define requirements and evaluate feasibility for improved knowledge sharing. Developed data models aligned with key business objectives, which translatedinto productivity gains of about 25% across departments.• Implemented best practices in data governance and compliance to ensure the integrity and security of sensitive information. Automated key processes to facilitate the navigation of the complex regulatoryenvironment, resulting in a 15% reduction in version deployment.• Drove continuous improvement initiatives that optimized system performance and reduced operational costs by approximately 20%.• Mentored and developed the data engineering team, fostering a culture of innovation and significantly enhancing technical capabilities, resulting in a 10% increase in project delivery efficiency.

• Architected the People Analytics Data Warehouse, designing robust data models and developing integrated pipelines from diverse sources such as Workday, Salesforce, and Qualtrics. This warehouseis the central hub for all people-related analyses, including recruiting, hiring, compensation, performance, and attrition.• Spearheaded the modernization of the workforce domain within the People Analytics Data Warehouse. Rearchitected processes and data models to enable near real-time updates from Workday, resulting ina 15% improvement in efficiency and accuracy of position data compared to the previous snapshot-based approach.• Developed the company sentiment survey infrastructure, enabling targeted engagement, mass communication, participation tracking, and data consolidation. Enhanced the process for monthly datacollection, providing a dynamic view of employee sentiment.• Transformed the Onboarding and Technical Development programs into a data-driven organization by overhauling data models and redefining processes to improve training programs for engineeringteams.• Collaborated with senior analysts to automate the distribution of workforce insights, including hiring metrics and attrition, ensuring timely access to essential data for business leads.• Engineered infrastructure for timely analytics, providing workforce planning analysts with streamlined tables for interactive dashboards and enhancing collaboration between planning and engineeringteams.

• Led the research effort to convert legacy SAS code from Mainframe into open systems. Creating code-parsing routines to identify code complexity, generate an inventory of programs and functions, and analyze algorithms. Successful conversion of legacy code to a new processing infrastructure • Architected a solution to migrate electricity demand data from Mainframe to open systems. Designed revamped ETL processes and proposed new processing infrastructure, and led the process to standardize data for a new Enterprise Data Warehouse.• Developed a working prototype to perform ad-hoc analysis on electrical demand data. The prototype used different technologies (RoR, Elasticsearch, Redis) to analyze pattern usage for millions of customer records and generate on-the-fly analytics.• Designed and implemented a REST system interface to provide customers with historical electric and gas usage. The solution facilitated integration among different systems in the company allowing seamless integration and a total deprecation of Mainframe systems.• Developed a framework to process customer usage information. The framework could process about 1GB of uncompressed information per minute to generate concise usage information, consolidated reporting, statistical analysis, and data stratification.

• Led the architecture, design, and development of the HR Analytics Reporting System. The project required an in-depth analysis of SAP R/3 systems to extract employee and workforce data for integration into a flexible HR Enterprise Data Warehouse.• Led an integration project comprising various external systems (@Task, Taleo, Salesforce) to enrich the analysis of HR data streams into the EDW. Multiple technologies were necessary to accomplish this integration, such as SOAP, REST, SQL connectivity, and SFTP.• Led the architecture, design, and implementation of the Billing / Honesty Reporting System. The system allowed matching installations against purchases to detect counterfeiting and illegal activations. The system processed around 50+ million weekly records and provided multiple data slices such as customer, product, location, and activations.• Developed a solution to replace an existing SAP BW application responsible for generating executive reporting. The new solution implemented a fully featured API for accessing information and producing meaningful reports and statistics not previously available.• Led the project to develop a Client Services / Professional Services Business Intelligence Reporting System. The effort included integrating information from various systems and coordinating resources allocated in CA, UT, and India. It allowed the creation of a 360-degree view of activities for clients and professional services for the Omniture products at Adobe.

• Led the rearchitecting process of the Risk Data Management system, which entailed reengineering data collection strategies and information processing for key financial portfolios. An overall improvement of 30% allowed faster decision-making and analysis of an increased number of risk management scenarios.• Coordinated changes in different modules throughout the system to increase efficiency and data quality and extend functionality to address new business requirements.• Designed and implemented a financial data mart to have visibility and insights about financial trading operations. The datamart enabled reporting and alerting mechanisms in line with existing financial trading policies.• Collaborated in integrating additional lines of business into the existing system to consolidate reporting in a single location and minimize the financial exposure/risk of the company.• Designed the conversion of existing data processing routines from PL/SQL to Informatica for easy maintenance and operational efficiency, gaining additional performance of 50% for specific processes as a result of this implementation.• Responsible for the evaluation and upgrade of the ETL infrastructure. • Implemented QA standards for performing functional and regression testing when incorporating new functionality or fixing detected code defects.• Designed and implemented a Disaster Recovery strategy that could resume and sustain reliable operations within 2~8 hours.• Collaborated with operational teams to provide visibility into ETL operations and training to respond to processing errors and restart processes within a short timeframe.

• Architected and developed a solution to process around 5~10 billion/day (~1.5 TBytes) weblog records to create a business intelligence solution for the Live Update team. The solution required a non-traditional approach using different techniques such as parallel processing, minimal database-staging loads, dimension consolidation routines, and tight interaction of modules as the basis for the solution's core. The project resulted in increased efficiencies and savings above 6 million dollars annually.• Responsible for collaboration with analysts, technical teams, and other business development teams for requirements gathering and definition of metrics.• Coordinated with vendors to define source file standards formats, value encoding, and delivery times to increase data processing efficiencies.• Designed the QA strategy and collaborated with the QA Team to work incrementally in a phase-release fashion to test the solution.

• Architectural design, coding and implementation of Data Management Solution Datamart. The Datamart included integration for several source systems into building an enterprise view of the chain supply management information handled by the company.• Design and developing of necessary ETL process strategy (data loading process) using Informatica PowerCenter/PowerMart.• Conceptualization, design and coding of around 100 ETL mappings and data integration processes. • Reconfigured solution after prototyping phase in order to achieve maximum performance while handling large data volumes. Achieved an average performance increase of around 300% for the overall system. Data loading went from 3 to 1 hour for large data sets and for small data sets the gain was even more pronounced going from 1 hour to less than 10 minutes.• Performed consultant role for the team responsible to create decision support reporting, dashboards and key performance indicators from the data available in the datamart. Suggestion were made for appropriate designs for summary tables, data joining and standardizations so reports could benefit from low waiting times, consistency and accuracy.• Responsible for the design of a new version of the prototype datamart so it could be offered as a company-sponsored product for the healthcare community. Special emphasis was made on being able to provide customers measurable and accurate information about their spending for healthcare related items. • Served as technical consultant for multiple meetings where the scope of new offerings was analyzed. Assisted program managers with concepts about data integration, data consolidation and general data management processes so information around the company could be consolidated into new offerings for internal and external products.

• Architectural design, coding and implementation of Corporate eMarketing Data Warehouse. Total redesign of existing data mart and conversion into a full data warehouse solution which included better flexibility, integrity, accuracy, availability and scalability. • Design and developing ETL process strategy (data loading process) using Informatica .• Creation, development and enhancement of more than 300 various ETL process.• Architected and implemented solutions that had direct impact on processing times bringing the overall data refresh from 72 hours down to 9 hours through and exhaustive analysis and reegineering the entirely ETL infrastructure while providing, at the same time, foundation for future growth. Task was accomplished in less than 3 months and provided immediate benefits to Corporate Marketing efforts that resulted in 60% increased in marketing campaign generation and cost-cutting measures.• Creation and developing PL/SQL packages and procedures to improve ETL process.• Architected solution to gather, evaluate and route sales leads from external vendors to internal sales area which resulted in having sales leads available for call centers in less than 4 hours after the initial contact was made.• Creating and maintenance Business objects Security Domain, Universe Domain, and Document domain. Creating variety Universe (Lead Reporting Universe, Booking Universe, Process Rejections Universe). Creating complicated on-line reports based on the business requirements using Business Objects and Web Intelligence. Created Sales reports with drill-down feature using a wide variety of hierarchies.• Technical support and train internal user.• Technical Lead for development of additional deliverables coordinating an onsite team and offshore team in India.

• Strong experience on designing and developing complicated data loading process using Informatica. Maintained and enhanced an Operational Data Store which took care of extensive data consolidation of court-appointed information generated in the Judicial Courts of California.• Creation of additional functionality to the system to make it web-enabled and easier for external users to input information which in turn, was collected and consolidated using Informatica PowerMart.• Analysis of existing functionality of the system and creation of a scheduler to launch ETL processes that allowed precise synchronization and minimized waiting times, providing an effective and immediate result in performance gaining of around 25%.• Application System Administrator Job. Performing Business Objects Administrator job. Creating repository, security domain, universe domain, and documentation domain. Installation business objects on Client side (internal user).• Performance tuning performed to complicated queries and report to speed response time (50%). Trained and provided technical support to internal users.• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging, and documenting programs using Informatica Velocity methodology to make sure all the development and enhancement was done according to industry standards.

• Architectural design, coding and implementation of the First Select Data Warehouse. Data Warehouse included consolidation of several systems such as dialer sequences, payments, promises to pay, finance and a centralized customer inventory. • Creation of Logic and Physical Design for additional projects incorporated into the eMarketing Data Warehouse. Created DDL scripts based on physical modeling, as well as creation of tables, determination of primary-keys, indexes, foreign keys to maintain Data Warehouse Referential Integrity.• Generation of detailed information for each source system included such as: Source system analysis, source data analysis, target structure definition, data standarization and proposed scrubbing sequences. • Creating ETL process for more than 100 mappings which loaded dimension and fact tables using Informatica PowerMart. The consolidation process was done according to a business rules flexible engine capable of allowing users to modify parameters to define degrees of granularity on the resulting data.• Performance tuning data loading process to reduce loading time more than 50% after the initial release through an exhaustive analysis and process consolidation tasks.• Creating/developing various Universes using Business Objects. Creating/developing/maintenance Security Domain, Universe Domain, and Documentation Domain. - Creating/developing more various reports based on business user's requirement.• Fine tuned accesses to reporting structures and Data Warehouse critical tables to allow effective Data Mining exploration to discover trends in payments and promises to pay. The Data Mining capabilities were the primary reason for the creation of this Data Warehouse and proved to be the most significant achievement of this project since the collection of outstanding debt increased in more than 30% through the creation of specialized campaigns derived from understanding of customer behavior.

• Architectural design, coding and implementation of the Financial Planning Data Warehouse. Integration and consolidation of 12 old internal financial system into a data warehouse. Logical and physical data model design and development. • Design and development of several data loading ETL processes. Creating ETL processes for extracting data from various source systems using informatica PowerCenter/PowerMart. Creating/developing/maintenance ETL batch job for data loading process. Performance Tuning for Informix database, mapping, program to reduce loading time more than 60%.• Planning, Development and Deployment of a Web-enabled Decision Support System utilizing consolidated data created in the Data Warehouse. System was created in Cold Fusion in conjunction with DHTML to allow easy navigation.• Responsible for analysis, design, coding and testing of a small Data Mart aimed toward the creation of Executive Reporting using Informatica PowerCenter. The data collection effort involved consolidation and data gathering at different times throughout the entire lending process.• Led the migration of data from an outdated system into a newly purchased Loan Origination System. The data migration involved detailed analysis of the third-party application and data structure used internally to plan the migration process. The ETL procedure was done through a series of Visual Basic scripts to extract, cleanse, standardize and improve the quality of data in the conversion process.• Produced QA scripts created specifically to verify the functionality and accuracy of the data migration process.