Fernando Sanchez Email & Phone Number

Buffalo, New York, US

• Designed cloud-based data and analytics solutions for the clinical trial industry, addressing data compliance (e.g., HIPAA), structured/unstructured data, and specific research needs.
• Led a team of Data Engineers to refactor application architecture and implement scalable cloud solutions.
• Developed and managed robust ETL pipelines using Azure Data Factory (ADF) and SSIS for integrating and processing data from EHR, patient records, and lab results.
• Built scalable data pipelines using Azure Databricks for advanced data processing, transformation, and analytics.
• Deployed Azure services, including Azure API for FHIR, Azure Data Lake Storage Gen2 (DLS Gen2), and configured Role-Based Access Control (RBAC) assignments to ensure secure and compliant data access.
• Created and optimized cloud-based data architectures for storage, processing, and analysis of clinical trial data using Azure technologies, ensuring security and privacy.

Zurich, CH

• Led the Cloud Engineering team responsible for supporting the Delphix and MongoDB platform globally within the Group Chief Information Officer Division of the bank in providing a stable infrastructure as a service.
• Worked closely with the operational team, project/program management, and domain leadership with onboarding of database applications to the Delphix and MongoDB platforms.
• Managed the Delphix and MongoDB platform book of work (e.g., issues, releases, bugs) using the agile project management tool - Atlassian JIRA Project Management software.
• Performed installation and configuration for both the Delphix and MongoDB (e.g., ReplicaSet, Shard) platform on a Cloud infrastructure.
• Participated in high-level enterprise architecture analysis, evaluation, design, integration, documentation, and development.
• Work collaboratively across the database regional and leadership team to drive the adoption of standard NoSQL toolsets to reduce complexity and support operational goals for increasing Cloud automation across the.

Florham Park, New Jersey, US

• As a team lead, worked closely with business stakeholders to architect and develop Cloud Data & Analytics solutions in Azure and Snowflake.
• Architected, designed and maintained high performing ETL processes using such tools as Azure Databricks, Python, and Azure Data Factory.
• Established data management metrics like data cataloging, data storage and archival, data lineage within Azure Data Lake.
• Database, storage, and other back-end services in fully virtualized environments
• Collaborated with other resources around security, encryption, etc. for cloud Data Analytics environments.
• Utilized framework driven approach to ETL development to deliver scalable and reusable solutions.

Raleigh, North Carolina, US

• Helped customers in how to use the company’s software product in building data transformations with SQL Server Integration Services (SSIS) including importing data from files, sourcing from SharePoint and other CLOUD.
• Prepared and managed multiple database server environments (both physical and virtual) in order to troubleshoot/resolve customer technical issues which included creating database schema objects.
• Developed strategies for data acquisitions, management, governance, use, and retention of data assets for clients in various industries.
• Developed and published (e.g., blogs, articles) best practices for data integration using Microsoft SQL Server Integration Services (SSIS) and company’s software product usage; Thus, increasing company’s.
• Selected, purchased, and implemented a cloud-based helpdesk ticketing system (e.g., Zoho Desk) with knowledge base articles in order to automate frequent tasks, improve customer response, and process efficiency.
• Participated in industry events, speaking with partners, prospects and customers, which included product technical demonstrations.

Zurich, CH

• Served as the Lead Data Warehouse Architect/Developer for a custom-built analytics and data warehouse solution at Credit Suisse, supporting capacity management and resource planning. The solution provided critical.
• Conducted detailed requirements gathering, designed dimensional data models, and developed source-to-target mappings.
• Set up development and UAT environments, and designed ETL processes using SQL Server 2008 SSIS, native database languages, PowerShell, VB Scripting, and Python.
• Built interactive Tableau dashboards to present insights from the data repository effectively.
• Developed SSIS packages to produce Tableau Data Extract (TDE) files, enabling seamless integration with Tableau Dashboard applications.
• Led a small offshore vendor team in migrating and planning several terabyte-sized databases to a Data Lake environment (e.g., Cloudera). This included developing data acquisition processes (ETL), cleansing and.

Frankfurt Am Main, Hessen, DE

• Led the analytics engineering team responsible for supporting the QlikView platform - over 4,700 users globally, 264 QlikView applications, and 124 Windows 2008 servers across multiple locations - within the Shared.
• Worked closely with project / program management and business leadership with onboarding of applications to the shared platform.
• Analyzed business requirements and implemented delivery of advanced capabilities on an enterprise-wide BI software product based on Data Virtualization tool, QlikView.
• Collaborated with internal teams of Business Analysts, Project Managers, Architects and Developers, supporting all BI efforts globally to deliver projects / initiatives on time and within budget.
• Served as a Subject Matter Expert to educate the Deutsche Bank user base on new features and provide support to achieve successful adoption of the platform.
• Oversaw C-level stakeholder relationships worldwide; managed risk issues and escalations for day-to-day operations, while maintaining platform stability and ensuring compliance with the Bank and regulatory standards.

• Worked closely with clients as team leader on various data warehouses / data analytics projects in understanding their data processing and business requirements in providing highly available / reliable innovative.
• Gathered and translated business requirements into technical specifications using structured techniques and data warehousing methodology.
• Coordinated with internal resources, clients and third parties / vendors for the execution of projects tasks/activities.
• Developed detailed technical blueprints for the integration of data analytics solutions; performed tools evaluation and selection for various client projects.
• Created RFP responses and client presentations; prepared and communicated status, issues and opportunities for business executives.
• Planned, designed, and implemented database (Oracle) applications exceeding Terabyte in size in both Unix and Windows environment.

New York, NY, US

Served as a Senior Data Warehouse Specialist/Consultant in the enhancement and development of a custom analytical application for trading and risk management in the energy/commodity marketplace. The development efforts of the analytical application consisted of integrating various subject matter data (Profit & Loss, MTM, Exposure, Cash Flows, Impact.

New York, New York, US

• In addition to the Database Manager role, served as a Project Lead and Business Intelligence Architect in the implementation of a web-based Enterprise Customer Relationship Management (eCRM) reporting application which.
• Conducted requirement analysis with key business analyst in developing requirements and solution definition; created project plan and managed up to three resources to successfully meet delivery milestones; designed and.
• Provided additional support and maintenance for several Essbase applications, including the creation of new outlines, load rules, and calc scripts, and supervised three resources in the daily operation of several.

US

• Successfully led a team of five members in the gathering of requirements, design, development, and implementation of a data warehouse/business intelligence solution for a client in the sports & recreation industry.
• Assisted sales teams in responding to RFP, drafting technical solutions and presentations;
• Developed and/or prepared conceptual system blueprint in delivering enterprise data warehouse architecture; resource and capacity planning; evaluation and selection of technical components;
• Worked closely with various project managers in defining project tasks and/or activities, including resource coordination, status tracking, and communication of project progress and issues.
• Installed, configured, and implemented an Oracle Optimal Flexible Architecture (OFA) compliance database to support the Profitability Reporting Facility (PRF) application in a Sun Solaris environment for a client in.
• Directed and guided a team of three members in the architecture and implementation of an Oracle database exceeding a Terabytes in size on a Sun Solaris and EMC environment; established various development, test, and.

• Designed, developed, and implemented a three-tier client/server application that consisted of a Decision Support System (DSS) for a client in the computer hardware industry (printing & imaging equipment).
• Assisted the project manager in defining project tasks and/or activities, including resource coordination, status tracking, and communication of project progress and issues.
• Performed detail data analysis (source-to-target) and developed a multi-dimensional data model using ERWIN; translated the multi-dimensional data model into physical table structures in Oracle, which included script.
• Installed, configured, and implemented Oracle Optimal Flexible Architecture (OFA) compliance databases in a Unix environment; determined initial aggregation, partitioning, indexing, backup and recovery strategies.
• Constructed and automated the extract, transformation, and load processes from the source-to-target using Oracle native language (PL/SQL), ODBC, Pro*C, Cshell, and SQL*Plus.
• Installed and configured the Essbase software in both development and production environment;

Minneapolis, MN, US

• Designed, tested, and implemented several distributed processing programs using Advance Program-to-Program Communication (APPC) for a client in the utility industry. The distributed processing programs allowed customer.
• Programs were created using Cobol CICS, Microsoft C, and Vermont Views in a IBM 3090, IBM OS/2, and MS/DOS platform environment.
• Provided additional support in the enhancement and development of the Mobil Telecommunication application using Turbo C/C++ in a MS/DOS environment.

Armonk, New York, NY, US

• Designed, Developed, and implemented an Information Delivery System (IDS) for the technical support department to remotely access customer information from a portable terminal at IBM Corporation.
• Designed, developed, and administrated the DB2 database application, which included the creation of schema objects.
• Designed and developed the distribution program using IBM C Set/2 to process requests and retrieve customer information from the repository from an IBM portable terminal.
• Other tasks included the coordination and planning of meetings, conducting requirement analysis, and automating production jobs.
• The development of the IDS was done under OS/2 2.11 using the following front-end tools and/or technologies to retrieve and manipulate data from various database systems: OS/2 Presentation Manager, RF Communication.

Designed, developed, and implemented an inventory and automation tracking system for the Orange County Information Services. The development was done on a Wang 100 system. Tasks included logical and physical layout of the database, coding of programs to load the database, interviewing the user community, documentation of reference manual, and training end.

Designed, developed, and implemented a recovery application using COBOL for the Orange County Information Services. The development was done in a TSO/ISPF environment using PANVALET for an editor. The recovery application ran on an IBM 4381 (MVS/XA).