Francisco (Frank) Lopez

CEO

Satellite Beach, Florida, United States32 yrs 1 mo experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Expert in Data Ecosystem Architecture and Implementation.
  • Proven track record in AI and ML project leadership.
  • Strong customer interaction and business priority alignment.
Stackforce AI infers this person is a Data Architecture and Cloud Solutions expert in Fintech and SaaS industries.

Contact

Skills

Core Skills

Data WarehousingAiSaasCloud SolutionsData ArchitectureArchitectureProject ManagementSystems Architecture

Other Skills

Agile MethodologyAnalysisAnalyticsArchitecture DecisionsArchitecture DesignAzureBusiness DevelopmentBusiness Intelligence (BI)Business ProcessBusiness Process AnalysisBusiness Process ImprovementCRMClinical Data CaptureCloud ImplementationCommercial Operations

About

Has notable experience in managing, supporting and delivering solutions in Data Warehousing, Big Data, AI, ML, Analytics and Business Intelligence. He has been closely involved in every aspect of project scope, designing and implementing large data repositories, analytical applications and e-business solutions. He is very comfortable with all levels of customer interaction and has a strong understanding of business priorities and how they drive technological decisions. He also has the technical expertise and management skill to fill most any role in project resource allocation. Specialties: Entire Data Ecosystem Architecture Design and Implementation including Data Warehousing, Big Data, Business Intelligence, Systems Architecture and Integration, ETL and Master Data Management.

Experience

32 yrs 1 mo
Total Experience
3 yrs 6 mos
Average Tenure
4 yrs 3 mos
Current Experience

Microsoft

Principal PM Mgr - Lead Data Architect

Mar 2022Present · 4 yrs 3 mos

Epam systems

Managing Principal / Technology Consulting

Oct 2021Jun 2022 · 8 mos · United States

  • Leading a modern Data Warehouse ecosystem project at a born-in-the-cloud loan company
  • Creating a fraud detection product in partnership with a Federal partner using advanced AI and ML to predict and discover malfeasance in new programs
  • Leading a full cloud implementation effort at a financial services firm
  • Rearchitecting the data ecosystem for a large hospital system as part of a cloud modernization to Azure
  • Designed the cloud ecosystem on AWS for a leading oil and gas firm
Data WarehouseAIMLCloud ImplementationFraud DetectionData Warehousing

Eightfold.ai

Global Head of Solution Architecture, Professional Services

Jan 2021Oct 2021 · 9 mos

  • Scaled up the Expert Services team to provide implementation services for a rapidly growing SaaS platform
  • tripled the size of the department in 4 regions around the globe
  • instituted a more scalable model that resulted in highest customer satisfaction numbers recorded
  • resolved issues leading to overwork and burnout among existing staff
  • instituted a training and certification program for internal colleagues and partners
  • lowered both resource and customer churn; aiming for 0 turnover rate H2 2021
  • on track to exceed expert services earnings targets for FY 22
  • created a resource pipeline including intern and new college hires
SaaSTeam ScalingCustomer SatisfactionTraining Program

Microsoft

2 roles

Principal Cloud Solutions Architect (CSA)

Promoted

Jul 2017Jan 2021 · 3 yrs 6 mos

  • Currently working in the National CSA team as a Principal Cloud Data Solutions Architect my passion is building teams, sharing my experience with others and making my customers and teammates the most successful they can possibly be. I am mentoring many of the junior CSAs, lead several internal and cross-functional teams and most recently managed the Southeast Region while my Director was out of the country. I also empower my clients to expand their commercial and operational systems by leveraging Azure, Microsoft's cutting edge cloud hosting IAAS, PAAS and SAAS solutions. I specialize in:
  • Full-cloud and hybrid cloud / on-premise architectures
  • OLTP and OLAP DBMS via Azure SQL and SQL Server, Oracle and MySQL on VMs
  • Cloud and hybrid data storage using Azure COSMOSDB and Blob Storage
  • Big Data on Azure using Azure SQL DW, Azure Data Lake, Databricks, HDInsight (Hadoop) and Cloudera
  • ETL utilizing SSIS, Azure Data Factory and Informatica
  • Advanced Analytics using Azure Machine Learning, Stream Analytics and Azure Data Lake Analytics
  • Business Intelligence using Power BI, SSAS, Excel and Looker
  • AI and Bots utilizing the CNTK and Bot frameworks
Cloud SolutionsTeam LeadershipAzureETLAnalytics

Cloud Data Solutions Architect (DSA)

Oct 2015Jun 2017 · 1 yr 8 mos

  • Working in SMS&P as a Cloud Data Solutions Architect I empower my high potential clients to expand their commercial and operational systems by leveraging Azure, Microsoft's cutting edge cloud hosting IAAS, PAAS and SAAS solution. I specialize in:
  • Full-cloud and hybrid cloud / on-premise architectures
  • OLTP and OLAP DBMS via Azure SQL and SQL Server, Oracle and MySQL on VMs
  • Cloud and hybrid data storage using Azure DocumentDB, Table and Blob Storage
  • Big Data on Azure using Azure SQL DW, Azure Data Lake, HDInsight (Hadoop) and Cloudera
  • ETL utilizing SSIS, Azure Data Factory and Informatica
  • Advanced Analytics using Azure Machine Learning, Stream Analytics and Azure Data Lake Analytics
  • Business Intelligence using Power BI, SSAS, Excel and Looker
Cloud SolutionsData StorageETLAnalytics

Biopharma client

E2E Architect / Data Architect / Sales Operations SME / Sr. Systems Architect - Commercial Ops

Jun 2015Oct 2015 · 4 mos · NYC / Boston

  • Working with a team of designers, developers and SMEs to create a full Commercial Operations architecture and systems design to support FDA approval of their first commercial compound. This includes:
  • Configuration of a fully cloud hosted environment on Microsoft’s Azure platform.
  • Incorporating best-of-breed OTS software to support initial MSL release.
  • Creation of an Enterprise Customer Master database and ETL processes.
  • Creation of a CRM and MDM system with mobile components utilizing full production data.
  • Analysis and comparison of various data sources to determine which had the most applicable data for the product indications, cost effectiveness and competitive advantage.
  • Creation of a Sales and Marketing Data Warehouse to support Sales Operations and IC.
  • Creation of a BI / Analytics design to support ongoing operations.
  • Master Data Management system design to support full Commercial Operations.
Commercial OperationsData ArchitectureCRMETL

Teradata

Sr. E2E Architecture Consultant

Jan 2015Jun 2015 · 5 mos · Unilever / Englewood Cliffs

  • Working directly for Teradata's clients managing their end to end architecture decisions and implementations including:
  • Determining and documenting standards and best practices
  • Resolving design and performance issues
  • Designing high and low level architecture and processes
  • Coordinating multiple departments, employees and consultants in order to deliver solutions
  • Optimizing existing systems and solutions
Architecture DecisionsDesign StandardsPerformance OptimizationArchitecture

Unilever

E2E Solution Architecture & Design Manager (Americas)

Jan 2015Jun 2015 · 5 mos · Englewood Cliffs, NJ

  • As part of a three person team reporting to the Global Technical Design Authority (TDA) Lead , responsible for all Global End-to-End Architecture Design and Oversight. Americas-based manager (other 2 are based in India and the UK providing global oversight).
  • Responsible for:
  • Determining and documenting standards and best practices
  • Resolving design and performance issues
  • Designing high and low level architecture and processes
  • Coordinating multiple departments, employees and consultants in order to deliver solutions
  • Optimizing existing systems and solutions
  • Technologies include:
  • Teradata v14.10 MPP RDBMS
  • Hortonworks HPD v2.6.0 (Apache Hadoop and YARN)
  • MongoDB
  • Cloud Computing and Hosting via Amazon AWS and Microsoft Azure
  • Microsoft SSAS / SSIS
  • Tableau
  • SAS
Architecture DesignStandards DocumentationSystem OptimizationArchitecture

Carecentrix

Data Warehouse Architect / Project Lead

Mar 2014Dec 2014 · 9 mos · Stamford / Tampa

  • Responsible for the design and delivery of the Enterprise Information Warehouse. Working under extremely tight timelines and resource constraints in order to deliver the foundation for CareCentrix's new data ecosystem. This project is using a phased approach along with agile project management methodology in order to rapidly deliver the solution to users. Responsibilities include:
  • Project plan creation and resource allocation
  • High-level design (end to end architecture)
  • Business process analysis to create the conceptual data model
  • Requirements gathering and analysis
  • Logical model design and implementation
  • Operational systems inventory and analysis
  • ETL process design
  • Physical model design and implementation
  • System optimization
  • Testing / Training and Deployment
Data Warehouse DesignAgile MethodologyBusiness Process AnalysisData Warehousing

Pfizer

Principal Consultant / Systems Architect

Nov 2013Dec 2013 · 1 mo

  • Systems Architect / Business Analyst / Technical Analyst for Field Sales Roster and Alignment System
  • Accomplishments include working with a team of designers, developers and SMEs to:
  • Create a full Commercial Operations architecture and systems design to support FDA approval of their first commercial compound. This included:
  • Creation of an Enterprise Customer Master database and ETL processes.
  • Creation of an SFA system POC with mobile components utilizing full production data.
  • Analysis and comparison of various data sources to determine which had the most applicable data for the product indications, cost effectiveness and competitive advantage.
  • Creation of a Sales and Marketing Data Warehouse POC to support Sales Operations and IC.
  • Creation of a BI / Analytics design to support ongoing operations.
  • Master Data Management system design to support full Commercial Operations.
Systems ArchitectureData WarehouseETLData Architecture

Trius therapeutics

Principal Consultant / Systems Architect

Jun 2013Oct 2013 · 4 mos

  • Sales Operations SME / Systems Architect for Commercial Operations
  • Accomplishments include working with a team of designers, developers and SMEs to:
  • Create a full Commercial Operations architecture and systems design to support FDA approval of their first commercial compound. This included:
  • Creation of an Enterprise Customer Master database and ETL processes.
  • Creation of an SFA system POC with mobile components utilizing full production data.
  • Analysis and comparison of various data sources to determine which had the most applicable data for the product indications, cost effectiveness and competitive advantage.
  • Creation of a Sales and Marketing Data Warehouse POC to support Sales Operations and IC.
  • Creation of a BI / Analytics design to support ongoing operations.
  • Master Data Management system design to support full Commercial Operations.
Commercial OperationsData WarehouseETLData Architecture

Merck

PMO and IC Project Manager (Callidus Software)

Sep 2011Mar 2012 · 6 mos

  • PMO and PM of the Callidus implementation and support team. Responsibilities include:
  • Process optimization.
  • System redesign and best practices.

Genentech

PMO, Project Manager, IC Systems Architect

Feb 2011Jun 2013 · 2 yrs 4 mos · San Francisco Bay Area

  • PMO, Project Manager and IC Architect of the Callidus Incentive Compensation Systems. Responsible for managing the overall client and vendor teams in order to redesign and optimize the existing IC implementation. Responsibilities include:
  • Process optimization.
  • System redesign and best practices.
  • Operational and Analytics database redesign and optimization.
  • Reporting redesign and best practices.
Commercial OperationsData WarehouseETLData Architecture

Callidus software inc

Implementation Partner

Jan 2007Jun 2013 · 6 yrs 5 mos

Project ManagementData ArchitectureAnalytics

Pfizer

Sr. Consultant and Systems Architect

Jan 2004Dec 2011 · 7 yrs 11 mos · NYC

  • IC Architect and Technical Lead for outsourcing of the Incentive Compensation Systems. Responsible for investigating and helping determine the appropriate outsourcing vendors for Pfizer’s IC Systems. Served as the primary technical design resource for Sales Operations responsible for ensuring that the design met both the short term and long term requirements. Provided architecture oversight and feedback to the design and implementation teams for all applications.
  • Systems Architect and Development Manager for FASST, Pfizer’s Field and Sales Support Tool.
  • Systems Architect, Development and Production Manager for the Incentive Compensation Systems. Re-architected, developed and re-deployed as part of a phased project plan the entire ICS. The existing system was suffering from years of disjointed development without an overall design or plan and resulted in severe maintenance and management issues.
Project ManagementProcess Optimization

Forest laboratories

Consultant

Aug 2003Sep 2004 · 1 yr 1 mo

  • Chief Architect on a clinical electronic data capture project.
  • Chief Architect on an electronic document management system project.
Systems ArchitectureOutsourcingTechnical Design

Medco

Consultant

Nov 2000Jun 2003 · 2 yrs 7 mos

  • Headed an initiative that created an enrollment tracking and reporting database for all Health Management and Financial products.
  • Managed design and creation of an integrated pharmacy reporting data mart and application used for analysis and billing purposes.
  • Re-engineered reporting and analysis systems for the Marketing department of pharmacy benefits TPA. Created design for incorporating disparate systems onto DW platform.
Clinical Data CaptureDocument ManagementSystems Architecture

Quantum consulting group, llc

Owner

May 2000Jan 2021 · 20 yrs 8 mos · Sparta, NJ

  • Owner
  • Over 25 years of notable experience in large systems design and integration. Utilizes his strong technical and managerial experience for all aspects of design, project management and implementation of Data Warehousing, Decision Support, Incentive Compensation, Transaction Processing and Business Intelligence solutions. Responsible for system architecture, business development, project planning, resource allocation, business user and stakeholder interaction, database design, executive level sales and requirements gathering. Is very comfortable with all levels of customer interaction and has a strong understanding of business priorities and how they drive technological decisions.
Systems DesignProject ManagementData Warehousing

Medco health solutions

Sr. Programmer / Analyst

Jan 1991Jan 1997 · 6 yrs

Database DesignReportingData MartData Architecture

Stackforce found 100+ more professionals with Data Warehousing & Ai

Explore similar profiles based on matching skills and experience