Alex C.
Data Engineer

Skills

Microsoft Sql Server

Oracle Database

Sap Erp

Mysql

Alex is available for hire

Meet Alex C.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A Bachelor in Information Systems and an MBA in Business Intelligence & Analytics, with extensive experience in the implementation of Data Warehouse, Big Data, Data Lake, and Business Intelligence projects. Specialization includes methodologies, architecture, and database programming technologies such as Teradata, Oracle, Azure, SQL Server, Cassandra, ScyllaDB, Hive, and Spark. Proficient in requirement gathering, dimensional modeling (Star Schema and Snowflake), and transactional noSQL modeling. Skilled in redesigning data governance processes, employing ETL methodology with tools such as PowerCenter, DataStage, and SSIS, and mastering Business Intelligence tools including MicroStrategy, SAP Business Objects (BI), SAS, and Power BI. Programming expertise encompasses Python, PySpark, JupyterLab, and DevOps practices, with capabilities in OpenShift administration within Azure and AWS environments, including sizing considerations. An adept Git Maintainer, skilled in creating pipelines using Jenkins and proficient in Linux administration. With over 20 years of IT experience focused on Business Intelligence and Data Engineering, contributions have been made across various significant companies.

Senior Specialist in Business Intelligence | ETL, DW and Big Data | Architect & Innovation | Power BI
10/2/2019 - 9/2/2020

Defined and implemented BI architecture incorporating ODS, Data Warehouse, Data Marts, and Big Data using tools such as Power BI, SSIS, Stored Procedures (ETL), and Microsoft SQL Server. Modeled the dimensional base to enable faster daily analysis for monitoring financial and operational KPIs. Created and automated reports and dashboards with Power BI for business areas.
Technology and Business Intelligence Manager
4/2/2019 - 10/2/2019

Managed the Business Intelligence and Analytics area, demonstrating expertise in data analysis and visualization tools. Oversaw the Technology and Support area, ensuring the smooth operation and maintenance of technical systems. Conducted customer visits to gather requirements and provide technical support. Authored comprehensive technical manuals to facilitate user understanding and streamline processes. Developed strong leadership and project management skills through effective team coordination and strategic planning.
Business Intelligence Manager | Database
7/2/2015 - 4/2/2019

Managed the Business Intelligence and Analytics area, defining and implementing a BI architecture composed of Data Warehouse and Data Marts using tools such as MicroStrategy (OLAP) and Power BI. Developed ETL processes with SSIS and Stored Procedures on Microsoft SQL Server. Customized and implemented a requirements collection methodology, enabling the storage of only relevant data and modeling of the dimensional base. This customization facilitated more agile daily analyses for monitoring Media KPI's across multiple platforms including Facebook, Google Analytics, DCM, DBM, AdWords, Twitter, Adobe Analytics, Tubemogul, Stilingue, and Globo (Offline). Maintained the current BI environment while developing and implementing new projects and technologies, leading to the elimination of information silos through the creation of a unified database. This database improved information reliability and accelerated decision-making processes. Implemented automated report distribution and strategic, tactical, and operational dashboards, democratizing access to information. Developed a Corporate TV Dashboard project for critical campaign and media performance monitoring, both on client sites and internally. Managed the DBA team, overseeing database administration activities such as installation, recovery, performance analysis, settings and updates, security, maintenance, migration, and reorganization of databases.
Technical Leader Specialist in Business Intelligence, DW and ETL Oracle | SAP BO | Developer
6/2/2009 - 6/2/2015

Worked collaboratively with Strategic Planning, BI-MIS, Risk-Finance, Audit, Products, and Marketing teams. Developed proficiency in Oracle 10g and 12c (Exadata) and SAP Business Objects XI 3.1 and 4.X, as well as Dashboard technologies. Responsibilities included requirement gathering and providing technical assistance to the BI team. Expertise in developing, maintaining, and automating stored procedures using PL/SQL (ETL), along with business improvements and support. Demonstrated skills in Data Warehouse (DW) administration, SQL query tuning, DW architecture, dimensional modeling, and process automation. Exceptional capability in constructing and maintaining universes and reports (DesktopI, WebI, LiveOffice). Managed the installation and configuration of the B.O. server and executed user administration for SAP BO (CMC) XI 3.1 and 4.X. Implemented security policies and provided user support through trainings and workshops. Led dashboards development and successfully managed the migration from BO 3.1 to 4.X.
Senior Business Intelligence Consultant (ETL - DW - Teradata - SAP BO Developer)
1/2/2008 - 6/2/2009

Developed proficiency in SQL Server, SAP Business Objects (SAP BI) Versions 5.1.9 and XI, and Teradata. Demonstrated expertise in developing and maintaining reports, as well as creating and maintaining Universes. Provided comprehensive user support and created technical manuals for training in Business Objects. Experienced in the installation and configuration of B.O. server version XI, along with leading a migration project from version 5.1.9 to XI. Administered Supervisor, conducted workshops, and performed DBA responsibilities, ensuring the smooth operation and maintenance of database systems.
Senior Business Intelligence Consultant (ORACLE - ETL - DW - SAP BO Developer)
10/2/2006 - 1/1/2008

Developed proficiency in Oracle 10g and Business Objects XI. Constructed PL/SQL routines for loading CPP, Cards, Middle, and CRM Data Marts. Created control panels, management reports, and dashboards using Xcelsius. Built Universes and administered user accounts in Business Objects Version XI, implementing security policies. Provided user support and customized the portal based on gathered requirements.
Business Intelligence Consultant - DW – SAP BO
2/2/2005 - 10/2/2006

Developed proficiency in SQL Server and SAP Business Objects Versions 5.1.9 and XI. Engaged extensively in report development and maintenance, as well as the creation and maintenance of Universes. Provided user support and created technical manuals for training in Business Objects. Led the installation and configuration of the Business Objects server version XI and managed a migration project from version 5.1.9 to XI. Administered Supervisor and conducted workshops. Performed database administration (DBA) tasks.
Junior Business Intelligence Consultant - DW – SAP BO - MicroStrategy
1/2/2003 - 2/2/2005

Gained expertise in SQL Server, SAP Business Objects Versions 5.1.9 and XI, Cognos, and Teradata. Developed and maintained reports in Full Client version while overseeing Report maintenance. Created technical manuals for SAP Business Objects training, including installation and configuration of B.O. Server version 6.5. Managed the administration of the Supervisor and handled maintenance and creation of Universes. Demonstrated skills in dimensional modeling, including Star Schema, Snow Flake, and Hybrid models. Contributed to documentation, developed Test Plans, and created Dashboards.