Business Intelligence Consultant / Data Engineer
BNP Paribas
- Req
- Gathering, Analyst, Modeler, Developer.
Carlos Lucero
Montreal,Canada
Summary
- Highly experienced IT Professional with over two decades of expertise in spearheading large-scale projects for prestigious global enterprises. Proficient in all phases of project management, from initial requirement gathering to final implementation and support, with a strong focus on customer satisfaction. Demonstrated proficiency in troubleshooting, decision-making, and continuous learning, coupled with exceptional communication and soft skills. Recognized for outstanding leadership qualities, adept at fostering solid relationships with stakeholders, peers, and clients across diverse industries and geographic regions.
- 20 years of experience with BI Platforms like Power BI, MicroStrategy, Tableau and Snowflake
- Experience in the ETL side having worked with the most important ETL Platforms as Alteryx, DataStage and Informatica PowerCenter
- Built ETL Solutions based on Oracle Stored Procedures
- 10+ years of experience working with Oracle Databases for top, very large companies worldwide
- 10+ years of experience working in English-speaking environments
- Experience providing robust, creative and scalable business intelligence solutions involving interactive Dashboards and Reports
- Design, development and test Business Intelligence scripts to import data from the source systems and test Business Intelligence dashboards to meet the end-user requirement
- Experience working directly with business units to define and prototype business intelligence dashboards following standard practice
- Deliver projects in fast-paced environment and work with different technology and business groups to produce quality and timely solutions
- Primary data architect and report developer
- Experience as a BI application administrator, BI Best Practices and documentation
- Ability to understand the underlying data model
- Experience with MicroStrategy Desktop, Architect, Integrity Manager, Command Manager, Enterprise Manager
- Worked directly with business analysts to ensure the technical feasibility of requirements
- Experienced in SQL Server with an emphasis on Stored Procedure development
- Experience in relational DB design / Strong requirements gathering, interpersonal and relationship building skills
- DW modelling for multiple industries
- Experience in team management.
- Led a 7-people Team in Citi Group for 2 Projects consisting of the Migration of the whole Reporting Platform from Business Objects to MicroStrategy for Mexico and Argentina
- Experience in every phase of a BI project from Start to Delivery and Support
- Former MicroStrategy Employee in Argentina as Technical Support Engineer for LATAM
- 3+ years of experience with the AWS Cloud, supporting different services like VPC, EC2, S3, AMI Factory, LAN & DMZ Segregation (Elastic Ips) and Networking like Route Tables, Peering, Gateways
- Working also in Data Streaming and Storage, like ECS, Kinesis Streams and Firehose plus managing Database on Aurora, DynamoDB, Redshift, Oracle, MS-SQL
- Also setting up and supporting End-User Solutions with WorkSpaces and AppStream, Introducing on Infra as Code and Automation with Terraform, GitLab, Docker, Ansible, etc.
- Worked with Pre-Sales Teams in the build of POCs to connect on-premise Applications to the Cloud. Having participation in Cost Management to reduce monthly costs for companies migrating their Infrastructures to the Cloud
Work History
Business Intelligence Consultant / Data Engineer
MyLightCloud
- Req
- Gathering, Analyst, Modeler, Developer, Lead
Business Intelligence Consultant / Data Engineer
Emirates
- Req
- Gathering, Analyst, Modeler, Developer, Lead
Business Intelligence Consultant / Data Engineer
Citibank
- Req
- Gathering, Analyst, Modeler, Developer, Lead
Business Intelligence Consultant / Data Engineer
IBM
- Backend & Frontend Consulting and Development
Business Intelligence Consultant / Data Engineer
Michelin
- Backend & Frontend Consulting and Development
Business Intelligence Consultant / Data Engineer
CableVision-Fibertel
- Backend & Frontend Consulting and Development
Business Intelligence Consultant / Data Engineer
MicroStrategy
- Technical Support Engineer
Business Intelligence Consultant / Data Engineer
Gobierno de la Ciudad de Buenos Aires
- Backend & Frontend Consulting and Development, Modeling
Business Intelligence Consultant / Data Engineer
Farmacity
- Consulting
Business Intelligence Consultant / Data Engineer
Turner Media
- Consulting, Analysis, KPI Definition, Report Development
Business Intelligence Consultant / Data Engineer
Banco Macro
- Support, Development, Administration
Business Intelligence Consultant / Data Engineer
Telecom
- Administration, Support, Development
Business Intelligence Consultant / Data Engineer
Repsol-YPF
- Consulting, Analysis, Development, Administration
Business Intelligence Consultant / Data Engineer
Arcor
- Consulting, Analysis, Modelling, Administration
Business Intelligence Consultant / Data Engineer
TeleTech Corp.
- Lead, Consulting, Development
Business Intelligence Consultant / Data Engineer
Tenaris
- Lead, Consulting, Development
Business Intelligence Consultant / Data Engineer
Coto
- Lead, Consulting, Analysis, Development, Modelling
Education
Skills
- Windows
- Linux
- AIX
- MacOS
- SQL
- PL/SQL
- Python
- Cobol
- Unix Shell Scripts
- Backlog
- Jira
- Oracle
- SQL Server
- Essbase
- Teradata
- Postgre
- MySQL
- Power BI
- Snowflake
- Tableau
- MicroStrategy
- Business Objects
- Hyperion
- Crystal Reports
- Agile
- JIRA
- Waterfall
- Alteryx
- DataStage
- Informatica PowerCenter
- SSIS
- Google Drive
- Gmail
- Evernote
- TeamViewer
- Slack
Personality
10, 10, 9, 9, 9, 10, 9, 8, 8
Certifications Training
- MicroStrategy Certified Project Designer (CPD)
- MicroStrategy Certified Report Developer (CRD)
- MicroStrategy Certified Dashboard and Mobile Designer (CDMD)
- MicroStrategy Certified Platform Administrator (CPA) (MicroStrategy Argentina)
- AWS Certified Solution Architect Associate 2021
- Artificial Intelligence Foundations: Thinking Machines (LinkedIN)
- Smalltalk Object Oriented Programming Universidad de Morón)
- Relational Databases (Universidad de Morón)
- AIX Administration, UBM (Universidad de Morón/IBM)
- C Programming, UBM (Universidad de Morón/IBM)
- Micro-Focus Cobol Workbench (Micro-Focus)
- Oracle Technological Seminar (Oracle)
- SQL Plus / Developer 2000 / SQL
- Forms / SQL
- Reports (Oracle)
- Project Management / Risk Management (Instituto Tecnológico de Buenos Aires) (ITBA)
- Data Analytics Real-World Projects in Python (Udemy)
- Data Stage 5.2, (Focus BS, Ascential Partner in Argentina)
- Crystal Enterprise (TeleTech Corp.)
- Data Mining (Universidad de Buenos Aires)
- Business Analyst - Project Management Techniques and Tools (Udemy)
- SQL – MySQL for Analytics and Business Intelligence (Udemy)
- Advanced SQL: MySQL for E-Commerce & Web Analytics (Udemy)
- AWS Certified Solutions Architect Associate 2021 (Udemy)
- Marketing Foundations (LinkedIN)
- Mastering Data Modeling Fundamentals (Udemy)
- Alteryx Bootcamp (Udemy)
- Tableau Prep for Business Intelligence (Udemy)
- Tableau for Data Visualization and Storytelling (Udemy)
- PowerBI Masterclass (Udemy)
- AWS Certified Solutions Architect Associate (Udemy)
- Snowflake Datawarehouse & Cloud Analytics (Udemy)
- Snowflake Masterclass (Real Time Demos, Best Practices & labs) (Udemy)
Job Experience Summary
- BNP Paribas, Banks / Financial Services, Global Banking Americas, Alteryx ETL / Tableau Dashboarding Development, Req. Gathering, Analyst, Modeler, Developer.
- MyLightCloud, IT Consulting, Odondo (Call Centers), MicroStrategy Development and Administration, Req. Gathering, Analyst, Modeler, Developer, Lead
- Emirates, Commercial Aviation, Commercial Business Intelligence, Ticket Sales Management, Req. Gathering, Analyst, Modeler, Developer, Lead
- Management Cockpit, Definition of KPIs for Finance, Operations, People and Customer, Consultant, Developer, Designer
- Citibank, Banks / Financial Services, Migration, Migration of the Reporting Platform from BO to MicroStrategy, Req. Gathering, Analyst, Modeler, Developer, Lead
- IBM, Information Technology, CableVision-Fibertel (leader Cable TV & Internet Company in Argentina), ETL and Reporting for the Client, Backend & Frontend Consulting and Development
- Michelin, Tires, Brazil, Oracle DB and MicroStrategy Development, Backend & Frontend Consulting and Development
- CableVision-Fibertel, Cable TV & Internet, Sales, Oracle DB and MicroStrategy Development, Backend & Frontend Consulting and Development
- MicroStrategy, Business Intelligence Software, Support, LATAM, Technical Support Engineer
- Gobierno de la Ciudad de Buenos Aires, Government, Government BI, Functional Analysis, ETL & Dashboard Development, Reverse Engineering on DW Models, Backend & Frontend Consulting and Development, Modeling
- Farmacity, Pharmacies / Retail, Benchmark, Benchmark on overall Performance of the BI Platform, Consulting
- Turner Media, Media, Planning BI, Frontend Development with Hyperion for the Planning Area, Consulting, Analysis, KPI Definition, Report Development
- Banco Macro, Banks / Financial Services, Support, Support and Development for the Reporting Suite, Support, Development, Administration
- Telecom, Telecommunications, BI & ArcGIS Administration, Administration for MicroStrategy and ArcGIS, Administration, Support, Development
- Repsol-YPF, Oil & Gas, BI / Analytics, Backend and Frontend Development, Consulting, Analysis, Development, Administration
- Arcor, Food, Corporate Data Warehouse, Data Warehouse Integration for 5 Export Bases (Argentina, Brazil, Chile, Peru, Mexico), Consulting, Analysis, Modelling, Administration
- TeleTech Corp., CRM & BPO, Newgen Results, Development for the Marketing Area, Lead, Consulting, Development
- Tenaris, Engineering, Corporate Data Warehouse, Administration for the Reporting Platform, Lead, Consulting, Development
- Coto, Supermarkets / Retail, Corporate BI, Lead for Corporate BI Project, Lead, Consulting, Analysis, Development, Modelling
Business Intelligence Analytics Project Experience
- Spearheaded end-to-end processes encompassing requirement gathering, analysis, design, development, and implementation of robust business intelligence solutions.
- Identified and defined key performance indicators (KPIs) to furnish insightful data for informed decision-making.
- Crafted comprehensive plans and reports pinpointing opportunities for digitalization and operational enhancements.
- Fostered transparent communication with stakeholders and power users at every project stage to ensure alignment and collaboration.
- Proficiently identified and evaluated metrics essential for measuring business performance.
- Presented business requirements to involved teams through meticulous documentation, ensuring clarity and alignment.
- Leveraged deep understanding of ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes to streamline data integration and warehouse loading, tailored to specific analytical needs.
- Applied project management expertise to resolve resource allocation challenges, mitigate risks, and adhere to project deadlines.
- Demonstrated adeptness in managing multiple projects concurrently, adeptly prioritizing tasks and delegating responsibilities.
- Developed engaging demos and presentations to showcase project progress, facilitate requirement discussions, communicate changes, and negotiate deadlines with project stakeholders.
- Proficiently tackled complex problems and transformed data into actionable insights, empowering management with the information needed for strategic decision-making.
- Collaborated effectively with both business and technical teams to ensure accurate translation of business requirements into technical solutions.
- Implemented industry best practices to optimize project outcomes and minimize risks.
- Committed to adding value, with a keen understanding of business strategy to enhance products and services and achieve customer satisfaction.
Timeline
Business Intelligence Consultant / Data Engineer
BNP Paribas
Business Intelligence Consultant / Data Engineer
MyLightCloud
Business Intelligence Consultant / Data Engineer
Emirates
Business Intelligence Consultant / Data Engineer
Citibank
Business Intelligence Consultant / Data Engineer
IBM
Business Intelligence Consultant / Data Engineer
Michelin
Business Intelligence Consultant / Data Engineer
CableVision-Fibertel
Business Intelligence Consultant / Data Engineer
MicroStrategy
Business Intelligence Consultant / Data Engineer
Gobierno de la Ciudad de Buenos Aires
Business Intelligence Consultant / Data Engineer
Farmacity
Business Intelligence Consultant / Data Engineer
Turner Media
Business Intelligence Consultant / Data Engineer
Banco Macro
Business Intelligence Consultant / Data Engineer
Telecom
Business Intelligence Consultant / Data Engineer
Repsol-YPF
Business Intelligence Consultant / Data Engineer
Arcor
Business Intelligence Consultant / Data Engineer
TeleTech Corp.
Business Intelligence Consultant / Data Engineer
Tenaris
Business Intelligence Consultant / Data Engineer
Coto