Data Warehouse SME / Senior SQL and Unix shell scripting Developer

CURRICULUM VITAE

CONTACT INFORMATION

FIRST NAME : Francisco

LAST NAME : Fominaya

ADDRESS : ** ********* *****

Stepaside, Dublin 18, D18 K039

COUNTRY : Republic of Ireland

PHONE : +353-**-***-****

E-MAIL : *****************@*****.**

*********@*****.**

EDUCATION

Bachelor of Telecommunications Engineering Degree (1992)

Universidad Politécnica de Madrid (Polytechnic University of Madrid)

Mark: Outstanding

Master’s Thesis: Distinction.

LANGUAGES

Spanish (mother tongue)

English (negotiation)

SUMMARY

I have 25 years of experience as data warehouse architect, developer, analyst, consultant, data modeller, application tester and system and database administrator. I have also 6 years of experience as Information Systems Manager.

In business applications, I have specialised in large billing systems, like Arbor/BP, for big telecommunication companies like Telefonica, Vodafone and Orange.

In Business Intelligence, within Data Warehousing, I have 12 years of experience with Teradata. My skills range from development of ETL processes and complex business processes with Teradata Load Utilities and SQL programming, database administration and monitoring, logical and physical data modelling.

I have worked in the following sectors: Telecommunication, Banking, Government, Retailing and Pharma.

I am used to working with various Operating Systems, like Microsoft Windows, VMS, UNIX, Linux and MVS, developing in UNIX shell scripting and JCL scripting.

Regarding database systems, I have worked with Teradata, Sybase and Oracle. I have used SQL Server locally.

I have also vast experience in dealing with business users, understanding their needs, working in close collaboration to develop high quality and reliable business processes to help, enhance and support their day-to-day work.

TECHNICAL SKILLS

Language

Experience

Databases

Experience

SQL Teradata 14.10

Expert

Teradata 14.10

Expert

Teradata load/export utilities (TPT, Fastexport, Fastload, Multiload) 14.10

Expert

Oracle/Sybase

SQL Server

Medium

Basic

UNIX Shell scripting

Expert

Tool

Experience

JCL scripting

Advanced

Teradata Tools Utilities

Expert

HTML

Medium

Teradata Viewpoint

Expert

Perl

Basic

Office 2010

Expert

Python3

Basic

Erwin

Medium

Java

Basic

Cygwin(curl)/Postman

Medium

SAS

Basic

Informatica PowerCenter v9

Medium

Operating Systems

Experience

Jenkins

Medium

Unix HP-UX, Solaris

Expert

BMC Control-M v8

Medium

Linux

Advanced

BitBucket

Advanced

Veeva Vault Regulatory Information Management (RIM) - Medium

Veeva Vault Quality Docs - Medium

CERTIFICATIONS

Teradata Professional V2R5 Jan 2009 Prometric

Teradata Professional V12.0 Jun 2011 Prometric

Teradata SQL V12.0 Dec 2011 Prometric

Teradata Professional V14.10 Sep 2014 Prometric

Teradata SQL V14.10 Jan 2015 Prometric

ADDITIONAL TRAINING

oAdvanced dBase IV in Metro de Madrid (Dec 1991).

oVMS Administration in Digital (Jan 1993).

oUNIX HP-UX 9.0 series 800 Administration in Hewlett Packard (Mar 1995).

oProgramming Tools for Progress v.8 in PROGRESS Software (Feb 1997).

oOracle Designer 2000 (Mar 1998).

oArbor/BP from Kenan Systems, in Telefónica Sistemas del Perú in Lima (Perú) (May 1998).

oVantive Sales and Vantive Support in Telefónica Sistemas del Perú in Lima (Perú) (Jun 1998).

oArbor/BP and Arbor/OM from Kenan Systems, in Kenan Systems offices in Madrid (Jul 1999).

oTCP/IP (Feb 2000).

oMaster in Java (100 hours), in Instituto Novatech in Madrid (Aug 2004)

oSAP Administration (Sep 2005)

oInfranet PORTAL in Oracle (Feb 2007)

oTeradata 101 (Teradata, San Diego, CA, Feb 2010).

oTeradata Access Layer (Teradata, Praha, Mar 2013).

oSAP Data Services (Teradata, Madrid, May 2014).

oTeradata Unity (Teradata, Madrid, Jan 2015).

oEquinox. New billing and CRM model (Vodafone Ireland, Jan-Feb 2019)

oAWS Certified Developer Course (Whizlabs, June 2020)

WORK EXPERIENCE

1)June 2021 – February 2022: Valiance Partners Europe

Migration Lead and Migration Specialist. Working in migration projects for the Life Sciences Industry to the Veeva Vault platform.

Projects:

oBAYER Consumer Health. Vault Regulatory Information Management.

oBoehringer Ingelheim. Vault Quality Docs.

2)May 2019 – May 2021

Tech Lead in the EDW Application Support Team working for Bank of Ireland. Using the following tools: Bitbucket, Jenkins, Python 3, Informatica PowerCenter v9.6.1, Teradata v14.10, Teradata Global Control Framework (GCFR), BMC Control-M v8 and UNIX Shell scripting.

Activities:

oAnalysis of root cause for issues in batch jobs.

oData modelling and development of Application Support tasks.

oUnderstanding of Teradata FSDM and ETL processes.

oConfiguration Management using Bitbucket

oMonitoring automated Deployment using Jenkins (DEVOPS)

oSQL development and query performance tuning and monitoring

oUnix shell scripts development

3)Jan 2018 – April 2019: Vodafone Ireland

Tech Lead in the Business Intelligence and Analytics Department.

Activities:

oAnalysis of root cause for issues in batch jobs.

oSQL development and query performance tuning

oJob and script development in Unix Shell

oData modelling and ETL development of EVOlve Project

oTeradata Job Control, monitoring (Viewpoint) and statistics management

oJIRA as issue and development tracking tool.

Note: from Jan 2018 to May 2018, I worked as a contractor (Greenleaf Consultant Ltd.)

4)May 2017 – Dec 2017: Contractor (Greenleaf Consultant Ltd.)

Teradata Developer in Allied Irish Banks (AIB) in Dublin, working in the Risk Analytics Department (Model Enablement).

Project: Masterscale (unified credit rating model) and IFRS9. Using Teradata v14.10, SAS Enterprise Guide 7.1 and UNIX Shell scripting.

Activities:

oData modelling for Masterscale project

oDevelopment of complex business processes

oDevelopment of ETL Processes

oQuery tuning

oDevelopment of SAS programs, embedding the SQL code

oExtensive documentation including:

-Technical Specifications

-Unit and integrated testing

5)September 2016 – April 2017: Contractor (Greenleaf Consultant Ltd.)

Teradata Data SME in Bank of Ireland in Dublin, working in the EDW Application Support Team through HCL. Using Informatica PowerCenter v9.6.1, Teradata v14.10, Teradata Global Control Framework (GCFR), BMC Control-M v8, Tableau v9, UNIX shell scripting.

Project: BI Programme, Releases 1 and 2 for Strategic Liquidity

Activities:

oRoot Cause Analysis of failures in the daily BI batch processes (300+ jobs).

oMonitoring and understanding of the Teradata Global Control Framework (GCFR)

oUsage and audit reporting from Teradata DBQL

oTuning of long running queries

oAnalysis and improvement of statistics collection and loading and control scripts

oMonitoring and understanding of Informatica workflows

oMonitoring and understanding of Control-M smart folders and job dependencies.

oWeekends and bank holidays batch support.

6)July 2015 – August 2016: Contractor (Greenleaf Consultant Ltd.)

Teradata Developer in Allied Irish Banks (AIB) in Dublin, working in the Data Delivery Department. Using Teradata SQL 14.10 and Teradata Load Utilities on Mainframe.

Projects:

oConsolidated financial balances.

oCollateral Assets.

oSBEE (Regulatory Pod).

oHyperion Finance Management Migration.

Activities:

oCollaboration with the analysts to fully understand business requirements based on detailed mapping documents.

oDevelopment with Teradata SQL 14.10 and Teradata Load Utilities on Mainframe

oSQL Performance analysis and optimization.

oDevelopment of JCL scripts in Test and Production Systems, adhering to Teradata and JCL Coding Standards and Best Practices from AIB.

oManage complex Job dependencies.

oExtensive documentation including Application Support Cards, Technical Specifications, QA Strategy, Change Descriptions, Unit Testing and Deployment Strategy

oWorking with agile development SCRUM methodology (sprints)

oCommitment to tight regulatory timelines.

7)January 2009 – June 2015: TERADATA IBERIA, S.L.U.

Teradata Developer, Senior Consultant and DBA. Working in the Professional Services Department.

Participating in the following projects:

oCorporate Data Warehouse for Prosegur (Multinational Security Company)

oCustomer Track, Data lab, Customer Segmentation, New ETL Platform with Teradata and PowerCenter for Vodafone Spain

oBest Tariff Plan Recommendation for Vodafone Spain

oData Warehouse Administration Service for Test and Development environments for Vodafone Spain.

oMigration data from DB2 to Teradata for Auchan in Lille (France).

oCorporate Data Warehouse for GISS (Spanish Social Security System)

Activities:

oRequirement gathering and analysis

oLogical and physical modelling (third normal form and dimensional)

oSetting up a framework for developing and executing load jobs

oDevelopment of loading scripts (bteq, multiload and TPT) and SQL scripts.

oData Warehouse Administration

oConfiguring and using Viewpoint

oUnitary and integrated tests

oDocumenting Technical Designs and Operating Manuals

8)November 2007 – November 2008: ALTEN-TIC

Analyst and Developer. Member of the Billing Development Department from France Telecom Spain (Orange). Using PVCS, Rational Clear Case, Rational Clear Quest, DB Artisan and $Universe.

Activities:

oImpact and viability analysis of new Sybase developments for Arbor/BP (Billing engine)

oFunctional Analysis, Unitary and Integrated Tests.

oProblem solving in Production Environment

oDocumenting $Universe chain processes

oSybase and UNIX shell-scripting developments.

9)January 2005 – October 2007: CAP Gemini

Senior Consultant. Member of the Integration and Testing Department for France Telecom Spain. Using PVCS (Software Version Control and Repository), TestDirector (test documentation), Lotus Notes, DB Artisan and Dollar Universe (for creating, submitting and monitoring jobs).

Validating in-house software developed for Arbor/BP and Collections applications, working with Sybase and UNIX.

10)December 2000 – December 2004: AXPE Consulting

Analyst and Developer. Using Sybase version 11, with HP-UX 11.0 operating system.

Participating in the following projects related to the billing engine Arbor/BP for the Spanish company UNI2 (Wireline & Internet Telecommunications Company):

oArbor/BP migration from version 8.1 Single Server Architecture (SSA) to version 9.1 Multi Server Architecture (MSA).

oMigration for EURO currency of Arbor/BP version 9.1 MSA.

Activities:

odeveloping Unix shell-scripts and Sybase procedures

operformance and functional testing of in-house developments relating to Arbor/BP

odevelopment and maintenance of processes with Dollar Universe tool

11)February 1999 – November 2000: TPTI (Telefónica subsidiary company)

Analyst and Developer.

Participating in the following projects:

oSizing of Arbor/BP for Company Segment Billing (Nov 1998 - Mar 1999).

oMigration of Arbor/BP for Company Segment Billing (May 1999 - Jun 1999)

oConfiguration of Arbor/BP for Company Segment Billing (Jun 1999 - Jan 2000)

The main tasks in these projects consisted of giving functional, hardware, software, architecture and data model support of Arbor/BP.

12)March 1998 - February 1999: Digitex

Analyst and Developer.

Participating in Project SCI (Integrated Commercial System) for Telefónica del Perú, integrating management systems of all business lines of Telefónica del Perú (wireline, data links, wireless and cable TV). The workplace was Telefónica de Sistemas del Perú offices in Lima (Perú) from April 1998 to September 1998.

As a member of the Billing & Collections Group, the main tasks were collecting, analysing and elaborating the functional and detail requirements of the business lines of Telefónica del Perú.

Working together with Kenan Systems Corporation and Telefónica del Perú in the IPA (Integration Point Analysis), evaluating Arbor/BP as a billing and collections solution for Telefónica del Perú.

13)October 1992 - March 1998: radiobip - C.E.R.S.A. (Compañía Europea de Radiobúsqueda, S.A.). (European Paging Company)

Information Systems Manager

Main responsibilities:

oManage a team of six people.

oOrganize and perform maintenance tasks of two big corporate applications:

1.A.B.S. (Autofile Billing System), from CRAY SYSTEMS, of Vodafone Group, software for managing and billing paging customers

2.SUN ACCOUNTS, from SUN SYSTEMS (accounting application)

oAdministration of a MicroVAX 3100-80 minicomputer under VMS 5.5-2.

Developing programs and interfaces to complement A.B.S. software, using Pascal, DCL, Rapid-Genius (4GL) and dBase IV. Generation of hundreds of reports for all the departments in the company. Supervising the development of in-house software using Oracle Forms 4.0 and Oracle Reports 2.0 under Oracle version 7.

14)December 1990 - October 1992: Metro de Madrid (Madrid Subway)

Senior Technician

Working in the Installations Department of the Projects Division. Taking part in the following projects:

oRadiotelephony in Subway Stations, collaborating with ALCATEL

oStudy of the Line 6 Power Supply.

oTrain Signalling Systems and security systems ATP (Automatic Train Protection) and ATO (Automatic Train Operation).

Developing software using dBase IV and updating FORTRAN programs. Translating articles and documents from English into Spanish.

Contact this candidate