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.• Developed interactive Power BI dashboards and customized visualizations: Delivered actionable insights and designed KPIs to monitor recruitment, enrollment, and operational performance effectively.• Collaborated with stakeholders to align analytics solutions with business goals and performed exploratory analysis for meaningful insights.• Optimized performance of data pipelines and analytics processes, ensuring efficient resource utilization in cloud environments.• Mentored junior team members on best practices, industry standards, and technical expertise in data architecture.• Proficient in developing SSIS packages, stored procedures, and strategies for high-performance data integration and management.• Stayed abreast of advancements in cloud, analytics, and machine learning technologies to enhance clinical trial data solutions.

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 across traditional database technologies (e.g., Oracle, MS SQL Server, Sybase) by improving automation on the cloud environments.• 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 enterprise.• Basic knowledge and experience with modern infrastructures automation platforms such as VMware vRealize Automation (vRA) and VMware vRealize Orchestrator (vRO) that enables private and multi-cloud environments on Cloud infrastructure. • Helped shape team vision, establish team goals and work with direct reports and leaders across the organization on strategies for executing, measuring progress, and sharing results.• Provided daily monitoring, management, troubleshooting, and issue resolution for both Delphix and MongoDB platforms hosted on the Cloud.

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. • Architected and designed how to assess the performance of data solutions, how to diagnose performance problems, and tools used to monitor and tune performance. • Established automated, elastic scaling of cloud services, automated deployment and remediation.• Collaborated with Product owners to drive adoption and optimization of the analytics platform. • Defined analytics standards and best practices. • Identified and delivered process improvements based on analytics, metrics and skills.• Experienced across all phases of data modeling, from conceptualization to database optimization.

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 applications, and moving data from one database platform to another.• 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 subscription-based offering downloads by 100 percent.• 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.• Create detailed documentation for functional or technical design that can be understood and used by all business partners and customers.• Globally responsible for the performance, development, and execution of the strategic partner alliance business, with secondary focus on managing customer support, which included hiring, training, and supervising technical support personnel.

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 performance insights into assets (e.g., servers) with potential operational, financial, and reputational impact.• 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 aggregating data, and creating database objects.

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 Application Services at Deutsch Bank.• 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. • Planned and/or conducted major hardware, network, software, and operating system upgrades and migrations.• Collaborated with stakeholders to ensure all audit & compliance issues were closed on time and no outstanding risks or gaps on the scorecards.• Ensured all essential maintenance CTB projects were delivered on time and within budget; oversaw CTB delivery that is regulatory mandated to ensure deadlines were met.• Established and managed the Data and Analytics Center of Excellence (COE) team in the organization to support business process re-engineering, business intelligence, enterprise data collection and management, data governance, and data visualization initiatives.• Defined a comprehensive change management activity for all projects to adhere to when onboarding of applications to the shared services platform.

• 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 technical solutions.• 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.• Designed data warehousing data storage/techniques (ODS, MOLAP, ROLAP, etc.).• Performed RDBMS installation, configuration, and tuning.• Designed and implemented backup and recovery strategies in both Unix and Windows environment.• Resolved technical issues and provided best practices for the monitoring, supporting, and maintaining of an RDBMS (e.g., Oracle, MS SQL Server).• Developed Extraction, Transformation, and Loading (ETL) procedures using programming languages such as Vbscript, Perl, Proc*C, Oracle PL/QL, and SQL Server procedures and ETL tools including Oracle Data Integrator 10g (formerly known as Sunopsis), Informatica, MS SQL Server 2000 DTS, MS SQL Server 2008 SSIS, and Transformation Server for MS Windows NT.• Created presentation quality reports into zero-client application using Qlikview, Tableau, Cognos, and Business Object Reports.

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, Counterparties, etc.) from the Endur application. In addition to the development role, helped build the data warehousing services of the company and trained and mentored internal staff on data warehousing. Tasks included conducting requirement analysis; the design and development of a dimensional data model (star schema); the creation of a database, in both Oracle8i and SQL Server 2000; the development of ETL processes (PL/SQL, DTS Packages); the creation of several multidimensional cubes; the development of a web reporting application; client training and documentations. The following tools and/or technologies were used in the development: MS Windows 2000 Server, Sun Solaris, Oracle8i, SQL Server 2000 (DTS and Analysis Services), PL/SQL, MS Office Web Components, Erwin, FrontPage 2000, Oracle Enterprise Manager.

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 integrated customer data from various enterprise channels (web clickstream, catalog, retail, etc.) in providing various executives from key business area with a consistent view of the customer enterprise data; most importantly, the planning, execution, and measurement of the effectiveness of marketing campaigns and website navigation.• 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 developed the dimensional data model (star schema); created the logical and physical structures of an Oracle8i database in a Sun Solaris environment; developed the ETL processes using Oracle PL/SQL, Perl, and Informatica.• 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 corporate Oracle applications.

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 the financial industry; determined initial table size and aggregation, partitioning, indexing, backup and recovery strategies.• 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 production environment; performed software and patch updates; Implemented standard naming convention for database objects and version control.• Designed and developed multi-dimensional data models (star schema) using Erwin and Powerdesigner to support various key business activities (sales, marketing, inventory, procurement, accounting) of an organization.• Modeled and built multi-dimensional applications using Cognos and Business Object products. • Provided additional project support and maintenance of an Electronic Order Entry (EOE) web-based application on MS IIS using MS Site Server and SQL Server for a client in the consumer product industry; enhanced and developed HTML, JavaScript, and Vbscript source code

• 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 creation.• 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;• Built several Essbase applications to store client’s financial data; development included building multi-dimensional database outlines, rules for loading data, scripts to calculate data, scripts to generate reports, and a comprehensive user group security strategy.• Provided additional support in the integration of various components of the development of a C++ application, evaluation and acquiring of new installation software for productivity enhancements, and functional and/or technical support of an MS Inter-application (Visual Basic, Excel, and Access).

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 service orders to be sent and received from a Mobil Telecommunication application, thus allowing Field Personnel to view customer service order on their PC Radio (laptops).• 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, EHLLAPI, and IBM C Set/2.

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 users on the Wang 100 system.

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).