Business Intelligence Analytics Project Experience
Timeline
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
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
BNP Paribas
Req
Gathering, Analyst, Modeler, Developer.
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
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.