Senior Data Architect & Tech Lead

Customer: Wells Fargo Bank, N.A
Department : BTS-DSSG (Business Technology Services)
Role: BI Technical Lead & DWH/ETL Sr. Developer
Location: Buenos Aires, Argentina
Duration: 5 years (Mar 2014 - Oct 2019)

Responsible for the development of Business Intelligence solutions to support the BTS-DSSG (Business
Technology Services) organization within an investment bank in the USA. In addition to leading and
coordinating the local team in Argentina. I developed many solutions from scratch, from the design of the
system architecture to the modeling of the ETL processes, as well as the creation of database objects to meet
the requirements and all the requested features. The projects were small and lasted about 4 months each.
One of the most exciting and large projects was the creation of a solution to support the merger between two
banks in order to consolidate the data from the old bank with the new one and avoid end users being affected
by the migration to the new system. On the other hand, I participated in an interesting project where the bank
wanted to manage all the ATMs it owned or leased. The solution brought remarkable benefits, such as tracking
the life cycle of an ATM and provided information on whether the ATM was profitable enough or not.

Department : IT
Role: ETL Manager
Location: Buenos Aires, Argentina
Duration: 2 months (June 2019 - July 2019)

Responsible for ETL developments on the Informatica PowerCenter platform. I worked on a large project
where the main goal was to populate the Hadoop NoSQL database with all the data obtained through various
systems to provide the Big Data team with everything they needed.

Technical skills and competences:
* Understanding of the requirements specification
* Technical design and construction of mappings and workflows based on business needs
* Development of ETL processes through Informatica PowerCenter platform
* Populating HDFS system of Hadoop framework
* Implementation and performance of unit testing of developed workflows
* Troubleshooting and bug fixing
* Support the Infrastructure team when deploying into different environments
Tools used:
* Informatica PowerCenter Tool version 10.1.1
* Hadoop framework version 3.0.0
* WinSQL Database Query tool version 11
* PuTTY SSH client for Windows and SFTP
* WinSCP SFTP and FTP Client Tool (version 5.11.3)
* Maestro Job Scheduler - IBM Tivoli Workload Scheduler
* HP ALM (Application Life Cycle Management) version 12

Department : Business Intelligence
Role: BI Technical Leader
Location: Buenos Aires, Argentina
Duration: 8 months (Aug 2013 - Feb 2014)

As technical lead, I was in charge of leading and coordinating all ETL developments as part of the Business
Intelligence practice within the CoE department. All projects were developed from scratch, as 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 rate and growth, to the Sales and Marketing departments so that they
can make the most appropriate decision possible. To do this, the team built a new datawarehouse along with
all the ETL processes to populate the data in it and build reports and dashboards for internal consumption
within the lab.

Technical skills and competences:
* 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
* Reengineering of existing processes
* Data Migration
Tools used:
* Informatica PowerCenter Tool version 9.1
* Microsoft SQL Server Management Studio and TOAD for Oracle
* AllFusion Erwin Data Modeler
* Microsoft Project 2010
* Reflection for UNIX and OpenVMS
* WinSCP Free SFTP and FTP Client for Windows
* PuTTY SSH client for Windows and SFTP
* FileZilla Free Edition
* UC4 Scheduler Tool

Customer: ArPOV (Argentine Association of Protection of New Varieties of Plants)
Department : Oracle Consulting
Role: BI Technical Leader
Location: Buenos Aires, Argentina
Duration: 6 months (Mar 2013 - Aug 2013)

I was responsible for all back-end developments as part of a BI project for a local client within the Oracle
consulting department.
The project consisted of creating a technical solution that provided the information of how many bags of grain
were sold by the main grain producers so that they know which producer should pay the extended guarantee
based on their harvests.

Department : Solutions Delivery
Role: Sr. ETL/DWH Developer & Data Quality
Location: Buenos Aires, Argentina
Duration: 2 months (Jan 2013 - Mar 2013)

The project consisted of providing operational support to the current team, such as data loading,
troubleshooting and error correction, making small changes in the current processes, as well as the inclusion
of improvements to provide the best operational services from the Argentina office. The main achievement I
got in this opportunity working for this client was the knowledge acquired about the Teradata platform.

Department : Solutions Delivery




Role: Sr. ETL/DWH Developer & Data Quality
Location: Buenos Aires, Argentina
Duration: 3 years and 4 months (Sep 2009 - Dec 2012)

As a Senior Developer I have participated in a large project for Latin America within the IT department at the
client Merck Sharp & Dohme.
The project consisted in providing strategic business information such as product sales, market share,
evolution rate, growth, sales force compensation calculations, product prescriptions, etc. to the Sales and
Marketing departments so they can make the most appropriate business decision. One of the most complex
projects was the one where we had to calculate sales commissions for the sales force based on target
achievement and sales in their districts.

Technical skills and competences:
* Project architecture and data modeling
* Requirement analysis, feasibility studies, coordination and planning tasks
* 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 performance of unit testing of developed workflows.
* 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
Tools used:
* Informatica PowerCenter - Enterprise Data Integration Suite (version 8.6.1 and
9.1.0)
* SQL Navigator 5.5 Standard Edition
* Reflection for UNIX and OpenVMS
* AllFusion Erwin Data Modeler
* WinSCP Free SFTP and FTP Client for Windows
* PuTTY SSH client for Windows and SFTP
* FileZilla Free Edition

Customer: Merck Sharp & Dohme Co., Inc.
Department : Solutions Delivery
Role: Jr. ETL/DWH Developer
Location: Buenos Aires, Argentina
Duration: 2 years and 1 month (Jul 2007 - Aug 2009)

The role of Junior Developer was to participate in a large project to service all countries in the Latin America
region within the IT department at client Merck Sharp & Dohme.
The project consisted in providing strategic business information such as product sales, market share,
evolution rate, growth, sales force compensation, product prescriptions, etc. to the Sales and Marketing
departments so they could make the most appropriate business decision. My main responsibilities were
focused on improvements and small changes to existing ETL processes.

Department : Solutions Delivery
Role: Technical Analyst
Location: Buenos Aires, Argentina
Duration: 10 months (Sep 2006 - Jun 2007)

As an Oracle DBA, I was responsible for the maintenance of the two existing data warehouses. The project
was about to create a new DW to replace the old one. The old datawarehouse had ETL processes built in
PL/SQL instead of new, robust and reliable processes built by the PowerCenter software tool. While this
migration was taking place, I was in charge of populating the data in the old database, as well as performing
operational DBA tasks on both.