Agustin
agustin.86c@gmail.com
407-545-4621
Novi, MI 48374
BI Developer
19 years experience W2
0
Recommendations
Average rating
123
Profile views
Summary

Around 9 1/2 years of experience as a BI Developer for Data Analytics, Design and Implementation of Business Applications using Kimball Methodology and multiples BI tools like Tableau, SSAS, IBM Cognos 10/11, OBIEE, Google Data Studio, Artus.
• Experience in MS SQL Server 2018/2008 R2 with MSBI stack SSIS, SSAS, and SSRS. Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools and worked on OLAP, OLTP and Data Warehouse Reports.
• Expertise in OLTP/OLAP System Study, Analysis, developing schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Involved in all phases of the Software Development Life Cycle (SDLC) from analysis, design, development, testing, implementation and maintenance with timely delivery, requirements gathering, functional gap analysis, module setup script generation testing and production support.
• Have Excellent Skills in Data Warehouse, Datamining, Relational and Multi-Dimensional databases, Data Migration, System & Data Integration, Reporting Analysis and Software Development and Data Management.
• Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.
• Experience in working with ETL tools - Toad, Pentaho, Oracle Data Integrator, Datamanager, DataStage, Analytic Canvas, Microsoft SQL Server Integration Services interacting with different databases like - Relational Database Management System (RDBMS) like Microsoft SQL Server, Oracle 11g, MySQL, Pervasive SQL, DB2, MySQL.
• Experienced in Data loading using PL/SQL, SQL Server Integration Services packages (SSIS), developed dashboard reports using SQL Server reporting services (SSRS).
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database
• Experience working with API Google Analytics and Google adWords, extracting data and loading in the Data Warehouse.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Dimensional Modelling and Data Visualization using IBM Cognos, Tableau desktop, Data Studio and Artus designer.
• Hands on experience with Datamining, Drill-down, Drill-through and Cascading reports.
• Hands on experience with PowerShell Scripting automating multiple servers and jobs to deliver the data in a central server with SFTP for a Project of Financial Consolidation.
• Hands on experience with multiples statistical and visualization techniques like lineal regression, Multidimensional scaling (MDS), Data Mashup, Data presentation, Data Blending, etc
• Experience in creating reports by using Dashboards strategy Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10, 2018, 2019
• Experience working in Agile and Waterfall model working methodologies like Scrum.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and soft skills.
• Hands on experience working with Excel charts, Pivot tables, Look up formulas, etc.

Experience
Education
System Administrator Engineer -UANL
not provided
Skills
SQL Server
2019
7
Triggers
2011
6
SQL
2019
5
Windows
2019
5
Windows Server
2019
5
SSIS
2019
4
Tableau
2019
4
Cognos
2016
3
Crystal Reports
2008
3
Data Mining
2011
3
Data Warehousing
2008
3
Oracle
2016
3
C#
2019
2
Google Analytics
2019
2
SSAS
2019
2
Tableau Desktop
2019
2
Tableau Server
2019
2
Agile Methodology
2021
1
BI Developer
2021
1
Business Intelligence
2015
1
ETL
2015
1
OBIEE
2015
1
TOAD
2015
1
.NET
0
1
Data Integration
0
1
Data Visualization
0
1
DB2
0
1
HTML
0
1
IDE
0
1
in-memory databases
0
1
Java
0
1
JScript
0
1
Microsoft SMS Server
0
1
MS Power BI
0
1
mSQL
0
1
MySQL
0
1
PowerShell
0
1
Scrum
0
1
Stored Procedure
0
1
T-SQL
0
1