Innovative and versatile IT engineer with 8 years of experience in Business Intelligence solutions focused in optimize and improve the business strategy. Highly analytical skills used to accomplish corporate goals and objectives. Extensive background in Microsoft BI tools. In a different field, decent knowledge and expertise of PLC & HMI programming in automation and control systems.
2008 - 2011
2002 - 2007
B.E. Electronics and Communication Engineering
Graduated with Professional Experience Modality
Jan 2012 - Present
Senior Business Intelligence Analyst/Developer
- Responsible for defining, recommending and delivering Business Intelligence strategies and roadmaps to improve the business strategy.
- Improved ETL and SQL stored procedures in some projects that helped to reduce around 30% the month end processing time.
- Support Latin America region BI applications including data mart, ETL, reports and dashboards, reducing bugs in 60%.
- Develop business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity.
- Apply technical skills using Tableau and Roambi to procure data from databases structures to report and provide solutions to manager requests.
- Developed an ETL solution for Colombia data warehouse, implementing multiple SSIS transforms and data flows in 3 months.
- Implemented an address validation for orders shipping reducing customers complaints from 15% to 2%.
Mar 2011 - Jan 2012
Automation Service Engineer
- Designed, programmed and tested automation projects with PLCs.
- Fault detection for PLC in automation processes.
- PLC programming experience: Allen Bradley, Siemens, Toshiba.
- HMI programming experience: SCADA, Wonderware, Panel View, RSView32.
Jul 2007 - Mar 2011
Business Intelligence Analyst
- Developed Business Intelligence solutions to support better decisions.
- Designed and developed ETL´s for data extraction and transformation to create 5 data warehouses with SSIS.
- Developed data marts and cubes used in BI analysis. (Analysis Services)
- Implemented around 30 dynamics reports with SSRS focused on managers to support business decisions.
- Database Management with SQL Server 2008 and T-SQL.
- Developed Dashboards in PerformancePoint Dashboard Designer.
Aug 2006 - Jan 2007
Test Engineer (Internship)
- Performed operation tests in DirecTV and SKY set-top boxes.
- Developed C language code modules to verify some tests.
- Designed and created KPI reports about the tests results.