vSUMMARY:

• Over 26 years of I.T. experience overall
• 22 years of full - cycle, Architect,Data Warehousing and Business Intelligence experience
• Architecture / modeling: 17 years designing data warehouse architecture with Erwin and Power Designer
• Ample experience designing star and snowflake schemas as well as ODS and ABC (Audit, Balance, Control) databases
• Ample on Google Cloud Platform (GCP)
• Knowledge and on BPM and Appian (2019)
• Knowledge of TOGAF principles
• Extensive experience defining vision and guiding principles, writing specs (ETL, reporting, infrastructure, overall architecture, source to target matrix, etc.) defining standards, naming conventions, error-handling strategies, data governance, data analysis, requirement gathering, conducting gap analysis, proof of concepts, helping with vendor selection, migration strategies, test cases, maintenance and SLAs.
• ETL: 12 years of Informatica PowerCenter, 4 years of Astera Centerprise
• Certified Informatica Consultant (Level III).
• Experienced in the design, development, testing and deployment of Informatica mappings, sessions, workflows, reusable objects, complex transformations, etc.
• Experienced in administration, installation, configuration, security, migration and testing of PowerCenter server, repository and repository server.
• Experienced in the design, development, testing, upgrading and enhancing of SQL scripts
• Experienced and trained in Velocity.
• Reporting: 18 years of Confidential, 3 years of Business Objects, Cognos, and some Tableau.
• Experienced in the design, development, testing and deployment of simple and complex Confidential projects, including full architecture, reporting objects and Command Manager Scripts.
• Experienced in the Administration, installation, configuration, security, migration and troubleshooting of Confidential Intelligence Server
• Experienced in project and object promotion with Object Manager
• Experience with Confidential Narrowcast server development and administration
• Experience developing universe and reports in Business Objects and reports in Cognos
• DBMS: Oracle, Sybase, SQL Server, DB2, Teradata, MySQL, Postgres and 13 years of SQL programming
• Over 3 years of programming experience, mainly with Power Builder, Visual Basic, C and Perl
• Other applications include DataFlux, Exact Target, Crystal Reports and Marketing Research software
• International experience (Mexico, Canada and the USA) on different industries
• Fluent in English, French and Spanish

PROFESSIONAL EXPERIENCE:

Confidential

Manager, Sr. Data Architect

Responsibilities:

• In charge of designing and building an EDW that incorporates data from internal sources such as SAP and Hyperion, as well as external sources like Confidential and data scraped from the web through Python. Successfully helped prepare a presentation and booth for the 2018 Confidential Partner conference, where we showcased some of our work in Data and Analytics. Working and managing a team of 12, comprised or data scientists, analysts, Tableau and ETL developers. Also involved in Architecture consulting with GCP and Appian. I’ve also created an intern and a mentorship program and help in recruitment activities.

Environment: SQL Server, SAP HANA, Tableau, SSIS / Centerprise, Python / Jupyter Notebooks, JIRA, Confluence, Alteryx.

Confidential

BI/Data Ware/Integration Architect

Responsibilities:

• Hands-on Architect. Built a world-class Business Intelligence / data warehousing system from scratch. My tasks included researching the market for current and upcoming trends and technologies (Data Federation / Virtualization, Data Visualization tools, ETL tools, HADOOP, etc.) architecture design, best practices, establishing standards, naming convention, error handling and audit processes, data governance, planning, sizing, costing, tool evaluation and selection, data modeling, ETL and report design, etc. Our data warehouse was successfully rolled out in May 2016 and the first reports were built in the fall.

Environment: Agile, Confidential 10.6, Astera Centerprise 7, Toad Data Modeler, Linux, MySQL, Postgres.

Confidential

Sr.Data Ware/BI Developer/Architect

Responsibilities:

• I designed, enhanced, fixed and developed Confidential reports and Informatica ETL mappings for the Maestro (Amdocs) project. I also provided reporting and ETL specs, as well as an ongoing analysis on Cognos 8 reports. I developed Confidential Mobile / dashboards for the iPad and iPhone, using the multisource option. I worked closely with end users and helped create a framework to deploy reports in a more efficient manner. I also helped with performance tuning for the Confidential reports, redesigning many of the database structures and reports.

Environment: Informatica 8.x and 9.x, Confidential 9, Teradata.

Confidential

ETL specialist

Responsibilities:

• As ETL specialist, I designed, developed and re-engineered Informatica mappings, shell scripts and Confidential reports. I also worked on a project to migrate Loyalty One’s mainframe-based application to a web-based application (developed by Tata). I was in charge of migrating the underlying data into MySQL, created a source and target inventory, gathered and documented requirements, documented source file layouts (fixed-width), create source to target mapping specifications, designed and developed ETL mappings, worked as a liaison between the mainframe and Tata teams and helped with the testing process (using JIRA as ticketing system).

Environment: Informatica 8.x and 9.x, Confidential 9, UNIX, Oracle, Netezza, MySQL.

Confidential

Data Warehouse Architect

Responsibilities:

• Data modeling work: I developed a new data model (Erwin) to replace an old data warehouse. I took key elements from the old model and incorporated new requirements and came up with an enhanced version, to serve the reporting needs for years to come.
• ETL / infrastructure work: I successfully designed and rolled out a new, modern infrastructure for the new needs. I designed the ETL processes, data quality, data governance, naming and otherstandards, error-handling strategies, audit processes, metadata management strategies, etc. I also developed mappings, and I completely migrated our data warehouse from DB2 to Greenplum, leveraging MPP capabilities through push-down optimization in Informatica. For this migration project, I upgraded the Informatica repository from 8.1 to 9.2 and made all code changes related to switching from DB2 to Greenplum. I installed and configured the new Informatica Linux boxes, and moved the repository to DB2 from SQL Server. I conducted the migration of all Confidential projects from a DB2 DataMart to Greenplum. I also conducted a proof of concept for 2 open source ETL tools: Pentaho and Talend that included installation and configuration, as well as building some mappings.
• Reporting work: I enhanced and re-designed the existingreporting infrastructure, leveraging Confidential 9 features. I made many enhancements using custom views in the database, and I developed several dashboards and Blackberry reports. I also did extensive Administration work in Confidential and Narrowcast Server. I successfully rolled out a completely new Confidential ad-hoc reporting facility.

Environment: Confidential, Informatica, Pentaho, Talend, DB2, Greenplum. ErWin, Linux, TOGAF

Confidential

ETL

• Worked as ETL lead on an ETL conversion project from Cognos Data Manager to Informatica 9.0.1 at Confidential . Responsible for designing and documenting mappings, with 3 people under my supervision.
• Worked on the design phase of an Informatica project for Manulife. I helped design the architecture, archiving, audit and reprocessing strategies and produced documentation based on Velocity templates (Informatica methodology), such as the source to target matrix. The project focused on replacing their SQL Server-based ETL process with Informatica.
• Designed and developed Landing to Staging to EDW to Datamart mappings, sessions and workflows on Informatica 8.6 for Genworth Canada.

Environment: Confidential, Informatica, SQL Server, Cognos.

Confidential

BI Developer

Responsibilities:

• Reporting work: I helped Confidential design and develop Confidential solutions, including planning, analysis and design, writing functional and technical specs, regression testing, test plans, enforcing standards and the LCL methodology as well as Confidential development (architecture and reports). I also met with business people to gather requirements and consulted with systems analysts to make sure functional specs would meet development standards and business requirements.

Environment: Confidential, Oracle, Teradata

Confidential

ETL Developer

Responsibilities:

• ETL work: I installed and configured Informatica 8.6 on AIX and migrated an old Informatica repository in Solaris from version 5.x to 8.6. I tested, adapted and enhanced the logic on the older objects to maximize the capabilities of the new version. I also reviewed all mappings and sessions, and replaced all DB2-specific SQL with Netezza SQL. I replaced DB2 targets with Netezza’s, setup user accounts and security, fixed issues stemming from the upgraded repository, helped with the regression testing and upgrading of shell and SQL scripts from Solaris to AIX. I created a set of Informatica mappings to bulk load all the data from the DB2 warehouse into the Netezza database I’d previously created.

Environment: Informatica, DB2, Netezza. AIX

Confidential

ETL/BI Developer

Responsibilities:

• ETL work: I developed all Informatica mappings, sessions and workflows for the ActiveTrack project. I specifically developed objects from Landing to EDW and EDW to DataMart (Netezza). I tested and executed all objects and did the initial load and production release.
• Reporting work: I designed and developed the Customer Management project (CMM) in Confidential from scratch. My development included Flash dashboards and presenting a prototype to company executives. I met with business users on a regular basis to gather their requirements.
• Data modeling work: I designed the Logical Datamart for the CMM project based on user requirements.

Confidential

ETL/BI Developer

Responsibilities:

• ETL work: I developed ETL mappings for the LifeToDate System using Informatica PowerMart. My work included regression testing and writing documentation.

Confidential

ETL/BI Developer

Responsibilities:

• ETL work: I headed all ETL-related initiatives. As a hands-on lead with 4 people under my supervision, I both built complex mappings and Informatica objects, and oversaw the creation of many others. I migrated MS DTS ETL mappings to Informatica and maintained Perl scripts. I was also the PowerCenter administrator and as such, I installed and configured the tool, repository, user accounts, upgraded software versions and fixed all server issues. Overall, my team was responsible for feeding our Enterprise Data Warehouse, the Epiphany database for Campaign Management and several Web Methods Services.
• Reporting work: I developed Confidential reports and worked as a backup administrator.
• Data modeling work: I designed and maintained the data model for our EDW using ErWin, which included Slowly Changing Dimensions (SCD). I also designed an ODS in SQL Server to be fed from our source systems.
• Other work: My team was also in charge of maintaining ExactTarget for email campaigns and DataFlux for data cleansing. I coordinated with my staff to make sure we adequately supported it. I helped the director to estimate times, effort, cost and volumes for all our initiatives. I provided mentoring and help develop staff. I coordinated work across departments to ensure cooperation and timely delivery, met with users and licenses on a regular basis to gather and refine requirements. I helped implement DataFlux to ensure the data quality of our user table by removing duplicates and identifying household patterns, with the aim of preventing fraud and promotion money duplication. I was also called by our 24x7 team whenever our nightly load fail, and I was in charge of investigating, fixing the issues, coordinating with other departments and resuming the load.
• Our environment consisted of SQL Server, MySQL and Postgres databases for the source systems and ODS, Oracle for our EDW, Informatica 7.x and Confidential 8.x

Confidential

Sr. Consultant

Responsibilities:

• ETL work: Developed Informatica mappings for Fellow DSS, the company’s insurance flagship product.
• Reporting work: Developed Confidential reports and all underlying schema and public objects for Industrial Alliance, National Life, Confidential, ONHWP (now Tarion) and HBC. For HBC I also customized their Confidential Web interface.
• Data Modeling work: Designed an ODS for Industrial Alliance
• Other work: Conducted stress tests for Industrial Alliance, to help select their new db platform (Sun Solaris or IBM AIX). I regularly met with business users in all my assignments to gather and refine requirements.

Confidential

Responsibilities:

• Reporting work: My work included Confidential 7 upgrading, report building, system assessment and administration for the CRM department. I also made recommendations aimed at improving the performance and operation of the system, which included changes to the data model and database tuning.

Confidential

Responsibilities:

• Reporting work: As a senior e-CRM specialist, my work consisted on implementing CRM solutions using Impact, an internal product based on Confidential technology. My project involved the creation of a system that introduced campaign management and web-traffic analysis for the LCBO. I gathered requirements and adapted the data model, staging area (for ETL) and the reports.

Confidential

Sr. Production Consultant

Responsibilities:

• Reporting work: I worked on projects focusing on system and data analysis. I provided support on prototypes, pre-sales presentations and HTML customizations. I conducted stress tests, SQL tuning, recommendations and enhancements for clients like Opal Sky. Mentoring coworkers and clients, writing proposals, gathering requirements and producing weekly status reports were also part of my work. Some of these projects included developing a warehouse for PharmaPlus (with market basket-type analysis) and a report infrastructure assessment for Aeroplan.
• I reviewed a system developed by Retek at Sears, making recommendations, product upgrades and deployment strategies. I developed reports and provided support for setting up a clustered environment with load balancing. I designed a broadcasting strategy to deploy a massive system, including recommendations on PGP encryption with Broadcaster. I was named the consultant of the quarter in the Canadian district, for 3 quarters in a row.

Confidential, Denver, CO

R&D engineer

Responsibilities:

• At the R&D department, I created several datamarts showcased in Confidential DSS World '99, as part of the product suite offered by Cornerstone, called Attaché. These datamarts were accessed by Confidential, Cognos Impromptu and PowerPlay, SAS and MS OLAP services (through MDX). The purpose was to show how our portal could integrate solutions from different platforms. I also developed a program to work with Confidential Broadcaster's API, to push content from diverse platforms to cell phones, web pages, faxes, etc.

Confidential

Consultant

Responsibilities:

• ETL work: Developed SQL scripts and stored procedures in Sybase. I also did some Sybase Administration.
• Reporting work: Developed reports in Confidential for CN, Confidential (with Crystal Report integration) and TVA. I developed a Confidential prototype for BMO (Bank of Montreal) that evolved into a full-blown Enterprise Data Warehouse.
• Data modeling work: I designed a prototype data model for Confidential MIND project that later became their -winning EDW. I met with business users in all my assignments to gather and refine requirements.

Confidential

Consultant

Responsibilities:

• I worked on the Implementation of a financial/transactional data warehouse for JP Morgan Mexico.
• ETL work: I wrote SQL scripts to perform manual data extractions from DB2 to our data warehouse.
• Reporting work: I worked with Business Objects and Confidential vendors to build their prototypes so they could show the client their capabilities. I developed reports and underlying objects for each tool, setting up the universe in B.O. and architecture in Confidential .
• Data modeling work: I met with business users to gather requirements and worked with Laura Reeves, a data warehousing expert from the U.S. to develop the data model for JP Morgan’s data warehouse initiative.
• Other work: I developed an application in Power Builder for manual entries to the data warehouse.

Confidential

Systems Analyst

Responsibilities:

• I developed financial applications in Visual Basic for Factoring and Leasing Serfin through MS Access, SQL Server and Sybase. These included OLE integration with Excel, Word and Crystal Reports, as well as Transact SQL programming.

Confidential

Systems Analyst

Responsibilities:

• I developed, processed and analyzed marketing research applications and information using Quantum, INF*ACT and VBA. I coordinated surveys on the field for the marketing research department.