Sr. Business Intelligence Engineer Resume
Miami, FloridA
SUMMARY:
More than 8 years of experience in Business Intelligence. Excellent problem solving and negotiating skills. Able to make decisions independently and quickly with minimal escalations. Excellent communications skills. Proactive, energetic, focused team leader/player. Diverse industry experience including video streaming, retail, banking and manufacturing. Fluent in English and Spanish (native - speaker).
SKILLS:
- Microsoft SQL Server, Analysis Services, Integration Services, Reporting Services (2000/2005 / 2008/2012 )
- Database management: AWS RedShift, MySQL, Teradata, Microsoft Access. PostgreSQL. T-SQL advanced, Store Procedures, Functions, Views, PL/SQL.
- Reports and dashboard design using Tableau
- Strong knowledge of data warehousing concepts and best practices, data warehouse schemas (Snow Flakes and Star / Dimensional models). Business Intelligence, ETL, Reporting, Balanced Scorecard.
TECHNICAL SKILLS:
BI Tools: Tableau Desktop, Tableau Online, QlikView, Cognos 8, Cognos 10, Panorama Novaview, Report Portal, Deck Control.
Analysis Services Tabular: AWS ecosystem (Redshift, DynamoDB, Cloudwatch, AWS Quicksight), Python scripting, R-Studio
Desktop Applications: SQL Workbench/J, SequelPro, MySQL WorkBench, PyCharm, DataGrip, Slack.
Cognos (version 8 and 10): Framework Manager, Transformer, Cognos Configuration, Cognos Connection, Report Studio, Analysis Studio and Query Studio.
Office Package: MS Word, MS Excel, MS Access, MS PowerPoint, MS Visio, MS Outlook, MS Project, Oracle, UML, VMWare, Virtualbox, Jira Agile, scrum, Git, Virtualbox
Operating systems: Windows, Mac OS.
PROFESSIONAL EXPERIENCE:
Sr. Business Intelligence Engineer
Confidential, Miami, Florida
Responsibilities:
- Design, implement and support data infrastructure using AWS Redshift
- Conduct ad hoc data analysis and data quality investigations.
- Create and deliver dynamic dashboards, using Tableau, to enhance executive decision-making, based on business requirements (“Content”, “Editorial”, “Finance”, “Marketing”, “QA”, “Payments”, etc.)
- Design, build and produce KPI metrics and dashboards related to User Engagement.
- Develop and maintain efficient ELT and data integration processes.
- Troubleshooting and escalating data related issues and validating data to improve data quality.
- Apply best practices for tables, data models, and storage.
- Make recommendations for new metrics, techniques, and strategies.
- Determine opportunities to redesign business processes.
- Prepare technical documents
Sr. BI Consultant
Confidential, Miami, Florida
Responsibilities:
- Maintain and ensure the accuracy of existing projects.
- Migrate SQL Server, SSIS, SSAS and SSRS from 2005 to 2008.
- Develop and maintain various ad-hoc reports
Sr. BI Consultant
Confidential, Miami, Florida
Responsibilities:
- Maintain and ensure the accuracy of existing projects.
- Solve user problems encountered in the application, reports via requests and tickets, and communicate changes to users.
- Analyze, design, build, produce and update metrics related to each Client Portfolio.
- Effectively present analytical findings and lead discussions with upper Managers to identify, and streamline processes.
- Design, develop and maintain various ad-hoc reports and produce analysis based on department needs.
- Document new metrics and design specifications
- Analyze and determine opportunities to redesign/automate business processes to achieve better business results
Project Manager and BI Consultant
Confidential
Responsibilities:
- Business Intelligent Consultant at Confidential .
- Understands, translates and designs the best way of applying COREBI’S offer to the client’s business needs.
- Provide pre-sales support to Sales teams regarding Strategic Outsourcing Services Model.
- Participate in preparation of compelling and competitive business solutions in response to client’s business requirements.
- Define information architecture strategy for projects, assist in defining project scope.
- ETL / Data Warehouse Analyst.
- Technical writing and project documentation.
- Product Manager of Report Portal. Perform product demos. Installation and configuration of Report Portal for several customers.
- Implementation of Online Dashboard Line Testing (Microsoft Reporting Services 2005)
- Trainer in Sql Server Analysis Services (SSAS) for several customers.
Second - Rate teaching Assistant
Confidential
Responsibilities:
- Taught “Data Management” subject for third year class in the “Information Systems Engineering” career.
Analyst Programmer
Confidential
Responsibilities:
- Managed project designed to manage employee’s assistance.
- Conducted the analysis of requirements, programming and creation of the database.
Tools: C #, .Net environment Visual Studio 2005, SQL Server 2000, SQL Server DTS, Rational Rose.
Analyst and Freelance Programmer
Confidential
Responsibilities:
- Participated in the migration of an ERP made in Visual FoxPro 9.0 and Visual Fox 8.
- Edited and added new features and reports to the new ERP.
Tools: Visual FoxPro 9.0, Visual Fox 8, MySql and MySql queries.
