Maria Nieves Garcia Somoza

Responsible for the migration of 270 assets from PowerCenter to IICS in a large-scale project. Performing as daily tasks and main skills of the role: • Migrating PowerCenter jobs to IICS (within an Azure serverless architecture) using the Informatica conversion utility RSA as well as Migration Factory. • Working with various data sources including databases (Oracle, SQL Server, Salesforce, etc.), APIs, and flat files • Dealing with complex SQL queries and working on data modelling and database design tasks • Working in Agile/Scrum methodology. • Collaborating with other team members to deliver high-quality solutions on time.

Responsible for new developments within Oliver Wyman’s client to feed the SSOT (Single Source of Truth) database and all downstream internal subsystems, from Financial Force system (Certinia). All new initiatives are created in Informatica Intelligent Cloud (IICS) and existing processes are maintained in SSDT. The project consists of extracting all the data for Clients, Accounts, Legal Entities, Projects, Opportuni-ties, Timecards and Assignments from Sales Force (as CRM system will be shutting down) and storing it an SQL Server DB. It also requires to analyzing the impact upon all existing downstream systems and building the new ETL processes if needed or adjusting existing ones.

Responsible for the development for project at Merck Poland customer in order to implement a solution to analyze the quality of information coming from source systems and KPI analysis. The whole project was created in Informatica Data Quality (IDQ). The project consisted of implementing validation rules and configuring acceptance or rejection thresh-olds according to business rules and data quality standards. All information that did not meet the quality standards was reported in a user interface implemented in APEX, where users could make modifications to the information reported there as a result of the validation rules executed by the automatic processes in IDQ.

Responsible for coordinating and managing all data enhancements and new initiatives for all internal systems of Banco Santander Río Uruguay. The main objective was to change the culture of the com-pany by providing new technological tools so that they can have a better quality and integrity of data, having a positive impact in reducing the operation time in the business areas. The project also required the migration of the Informatica PowerCenter platform, as well as all the data-bases and their ETL processes.

Responsible for data improvements and new initiatives for all data systems within KCP LAO. I am currently working on reducing the time spent for data delivering from the moment we receive the information from distributors until we store the data in the HANA system, where users consume sell-out and sell-in data through Tableau or PowerBI dashboards. The main objective is to improve data quality and integrity of the data by redesigning the architecture and the way in which the different systems interact with each other. Technical skills and competences: ▪ Data management / Data quality ▪ Technical design and data architecture ▪ Data governance ▪ SCRUM methodology ▪ Team coordination Tools used: ✓ Azure Data Studio v1.9.0 ✓ SQL Server Management Studio v18.2 ✓ SAP HANA Studio v2.3.41 ✓ MySQL Workbench 8.0 ✓ Visual Studio 2019 / 2017 ✓ Microsoft SQL Server Integration Services (SSIS) ✓ PowerBI ✓ Tableau (Analysis for Microsoft Excel plugin) ✓ SAP R3 and CRM ✓ Sales Force ✓ Teams ✓ JIRA

Responsible for ETL developments in Informatica PowerCenter platform. I'm currently working on a large project where the main objective is to populate Hadoop NoSQL database with all the data obtained through various systems in order to provide Big Data team with all the data they need. - Technical Design and construction of mappings and workflows based on business needs - Project sizing and effort estimation - ETL process developments through Informatica PowerCenter platform v10.1.1 - Populating HDFS system of Hadoop framework - Implementation and performance of unit testing of developed workflows - Performance of Integral Testing in different environments (Dev/QA/Prod) - Troubleshooting and bug fixing Tools used: . Informatica PowerCenter Tool version 10.1.1 . Hadoop Distributed File System (HDFS) . WinSQL and Microsoft Management Studio 2012 . PuTTY SSH client for Windows and SFTP . WinSCP File Transfer Tool . Maestro Job Scheduler – IBM Tivoli Workload Scheduler . HP ALM (Application Life Cycle Management) version 12

Responsible for the development of Business Intelligence solutions to support the BTS-DSSG department within an investment bank in USA. In addition to leading and coordinating the local team in Argentina. I've developed a lot of solutions from scratch, from design of the system architecture to the modeling of ETL processes, as well as creation of database objects to meet the requirements and all the requested features. The projects were small and took around 4 months each. One of the most exciting and biggest projects was the creation of a solution to support the merge between two banks in order to consolidate the old bank's data in the new one and avoiding the end users being affected by the migration to the new system. - Understanding of Requirements specification (BRD – Business Requirement Document walkthrough) - Technical Design and construction of mappings and workflows based on business needs - Project sizing and effort estimation - ETL process developments through Informatica PowerCenter platform v9.11 - Creating database objects (DML / DDL operations) in Oracle as well as SQL Server databases - Implementation and performance of unit testing of developed workflows - Performance of Integral Testing (in SIT environment) - Deployment into different environments (Dev/SIT/QA/UAT/Prod) - Troubleshooting and bug fixing - Change request creation and follow up Tools used: . Informatica PowerCenter Tool version 9.11 . TOAD for Oracle, SQL and Teradata v11.6 and Microsoft SQL Server Management Studio 2010 . PuTTY SSH client for Windows and SFTP . IPSwitch File Transfer Tool . Load Sharing Facility (LSF) – IBM platform scheduler . TFS (Team Foundation Server 2011) . Pac2000 Remedy – BMC Software

As a technical lead, I was in charge of leading and coordinating all the ETL developments as part of Business Intelligence practice within the CoE department. All projects were developed from scratch since the team was new including all its initiatives. Most of the projects were conceived to satisfy business decisions by delivering strategic information, such as product sales, market share, evolution index and growth, to Sales and Marketing departments so that they can make the best suitable decision as possible. In order to do so, the team built a new DW along with all the ETL processes to populate the data on it and build reports and dash-boards for internal consume within the laboratory. - Team coordination, planning and tasks estimation - Requirement analysis, feasibility studies, coordination and planning project - Understanding of Requirements specification - Project architecture and data modeling - ETL process developments through Informatica PowerCenter platform - Design and construction of mappings and workflows based on business needs - Troubleshooting of mappings and transformations. - Creating database objects (DML / DDL operations) - Implementation and performance of unit testing of developed workflows - Performance of Integral Testing - Follow up of deployment to different Testing and Production environments - Data Migration processes - Reengineering of existing processes

I was responsible for all the back-end developments as part of a BI project for a local client within Oracle consultant department. The project consisted of creating a technical solution which provides the information of how many bags of grain were sold by the main grain producers in such a way as to know which producer should to pay for the extended guarantee based on their harvests. - Team coordination, planning and tasks estimation - Requirement analysis, feasibility studies, coordination and planning project. - Understanding of Requirements specification - Project architecture and data modeling - ETL process developments through Oracle Warehouse Builder tool - Design and construction of mappings and flows based on business needs. - Troubleshooting of mappings and transformations. - Creating database objects (DML / DDL operations) and DB maintenance - Data Migration through OWB - Implementation and performance of unit testing of developed workflows. - Performance of Integral Testing - Deployment to different Testing and Production environments

As a Senior developer I’ve participated in a huge project for Latin America within the IT department in Merck Sharp & Dohme client. The project was to provide strategic business information, such as product sales, market share, evolution index, growth, sales force compensations, product prescriptions, etc. to Sales and Marketing departments so that they can make the most suitable business decision. One of the most complex projects was the one where we had to calculate sales commissions for the sales force depending on their fulfillment of objectives and sales within their districts. - Developer Senior on Informatica PowerCenter - BILA (Business Intelligence Latin America) Project Architect as Consultant at Merck Sharpe & Dohme Co. - Data architecture and data modeling - Requirement analysis, feasibility studies, coordination and planning project. - ETL process developments through Informatica PowerCenter tool - Design and construction of mappings and workflows based on business needs. - Troubleshooting of mappings and transformations. - Implementation and unit testing of developed workflows. - Performance of Unit Testing - Creating database objects (DML / DDL operations) and DB maintenance - Data Migration - Deployment to different Testing and Production environments - Implementation of Multilayer virtualization through Composite Studio 5.2.0 tool.