Uploaded File
Agustin
agustin.86c@gmail.com
407-545-4621
Novi, MI 48374
BI Developer
13 years experience W2
0
Recommendations
Average rating
27
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
BI Developer
Information Technology
Aug 2019 - present
  • Capacitation in internals process and agile methodologies.
  • Internal project.
Agile Methodology BI Developer
Remove Skill
BI Developer
Information Technology
Jan 2017 - Aug 2019

PriceTravel Holding is a company dedicated to the commercialization of travel products, under a multi-channel, multi-product and multi-country business model. The diversification of products and services is one of the keys of his success, in addition with the satisfaction of his customers and suppliers.

Responsabilities

  • Involved in Project Cycle from Design and extraction to Implementation of Visualizations.
  • Management of the ETL’s around the company and all the areas, focused in the Financial area
  • Development and Maintenance of the DWH through Kimball methodology.
  • Worked with other functional teams within IT and the Business to identify opportunities for process improvement and assist in the implementation of those agreed.
  • Involved in Analysis, profiling and cleansing of source data using SSIS and understanding the business process.
  • Develop and maintenance of ETLs from the API of Google AdWords and Google Analytics to the DWH.
  • Compiled spreadsheets and Excel validations using pivot tables and VLook up formulas.
  • Design and develop Tableau visualization solutions and prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
  • Development of Dashboards, reports and Visualizations in DataStudio.
  • Extensively involved in creating graphs by using measures and dimensions by using data blending concepts and blend related data from different sources.
  • Performed tuning and optimization of complex SQL queries using SQL Server MS .
  • Knowledge in BSP, IBIP, iatas, etc.
  • Tools used: SSAS, SSIS, Tableau Desktop, Tableau Server, Canvas Analytics, DataStudio, C#, API Google Analytics
  • Environment: Windows Server, MSSQL 2018/2016/2012, Tableau 10.x
Agile Methodology BI Developer C# Google Analytics SQL SQL Server SSAS SSIS Tableau Tableau Desktop Tableau Server Windows Windows Server
Remove Skill
BI International Subsidiaries
Information Technology
May 2015 - Oct 2016

Mx. Cosmocel is a Mexican Company dedicated to the production and marketing of specialty products in the PLANT NUTRITION sector, for the horticultural, ornamental, fruit markets and grains. develop innovative products ensuring the highest quality and performance through standardized processes and under strict quality standards. We currently have presence in America, Africa, Asia, Europe and Oceania. Responsibilities:
• Extract, transform and load with SSIS of the information of the partners around the world from multiple ERP systems and DBMS, like SAP, HPro, Microsoft Dynamics, SQL Server, Pervasive, MySql, Oracle etc. in countries like South Africa, Spain, Thailand, Brazil, Argentina, etc.
• Created complex SQL Joins and statements for Applications by using T-SQL.
• Created complex reports like detail level Transaction reports, Monthly aging YTD cash goal reports, consolidated reports by country, etc.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and clean data and store in Centralized SQL Database.
• Development and maintenance the reports and Cubes with Cognos Report Studio, Cognos Transformer for the Sales and Financial areas.
• Leader for the Financial Consolidation Project with TM1.
• Develop of several Feeders and Turbo Integrator TM1 rules.
• Maintenance of multiples TM1 cubes for the Financial Consolidation with TM1.
• Automation of the process of load for the monthly closings in the International Subsidiaries
• Developing Shell scripts and batch scripts to automate DBMS Jobs to deliver the data across the web from the multiples subsidiaries across the world with FTPS Server. Nexolution

Cognos Oracle SQL Server SSIS
Remove Skill
BI Consultant
Banking/Financial
Oct 2013 - May 2015
San Pedro, CA
Nexolution is a consulting firm in Business Intelligence, Datawarehousing, Planning and Budgets and Financial Consolidation. Have more than 10 years of experience in the market and work with some of the most important companies in Mexico. We are IBM Business Partners, specialized in Cognos and InfoSphere. Responsibilities:
• (Project) Development of several Active Reports in SCA.
• (Project) Development the DWH and several reports and dashboards of Human Resources area of Skyworks Inc. in Mexicali plant.
• (Project) Migration of several old packages of SSIS to newer version and set up the protection level to packages making the sensitive data safer.
• Hands of experience with multiples olap cubes and datamarts with SSAS.
• Extraction, Transformation and Load with several ETL tools like Datamanager, Datastage, Toad, Pentaho, ODI, SSIS with several RDBMS like Oracle, MSSQL, My SQL.
• Evaluate project requirements, design and configure the most efficient and cost-effective solution using SSAS, Tableau, Cognos.
• Interacting directly with the business users and understand the requirements and create the functional/technical specifications and mapping documents.
• Created database Objects like Tables, Views, Stored Procedures, Indexes and Triggers.
• Design and development the Dashboard and several reports. Tools used: SSAS, Tableau, Cognos Framework Manager, ETL Cognos Datamanager, Cognos Transformer, Report Studio, Cognos Connection, Active Reports, Toad, Datamanager, Datastage, SSIS, OBIEE, ODY,
• Enviroment: Windows, Windows Server, Unix, Oracle SQL Server R2, Ms Office DeAcero
Business Intelligence Cognos ETL OBIEE Oracle SQL Server SSIS Tableau TOAD
Remove Skill
SQL - BI Application Developer
Information Technology
Oct 2008 - Dec 2011
Mx Neitek Solutions is a Software company focused IT engineering and consulting. Founded in, it has expanded and now is based also in the United States, providing services to worldwide & well-known business located across the American continent. Responsibilities:
• (Project) IT Consultant in DeAcero
• Data Mining expert, looking for breaches of company policies.
• Developer in SQL Server, language TSQL, SP, DTS, Triggers, Jobs, etc.
• Risk Areas analysis in the quality policies and company systems over all the departments (purchasing, shipping, accounting, and financial, manufacture).
• Develop of SP for the system RYA "Risk and Audit". Tools used: SQL Server Management Studio, SP, DTS, Triggers, Artus
• Enviroment: Windows, Windows Server, SQL Server 2000 Grupo Ei
Data Mining SQL SQL Server Triggers Windows Windows Server
Remove Skill
BI Application Developer
Information Technology
Oct 2005 - Oct 2008

Group committed with the development of export and import organizations in Mexico and abroad. Starting in year 2000, formed a team that offers services of excellence in global logistics through innovative solutions to current requirements in the supply of the productive chain. Responsibilities:
• Leader of the BI area, Data warehouse manager with Artus.
• Design and development of information maps, creating sessions and workflows to load the DWH
• Data transformation, extraction, mapping, data modeling of the Data Warehousing
• Configuration and support to the Firewalls, voice over IP links
• Strong ability in developing SQL queries, Cristal Reports, Store Procedures, Triggers, DTS.
• Responsible of the DWH Data Base, Administration and maintenance.
• Windows Server Administration and maintenance.

Crystal Reports Data Warehousing SQL Triggers Windows Windows Server
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
System Administrator Engineer -UANL
not provided
Record has not been verified.
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