Uploaded File
add photo
Harold
Harold.loys@yahoo.com
loysrasc@yahoo.com
305-409-3345
230 NW 135 Ave
Miami, FL 33182
BI Developer
17 years experience W2
0
Recommendations
Average rating
19
Profile views
Summary

  • Data Engineer/ Scientist with Management Programming and Educational backgrounds.
  • Cloud: Certified Aws Cloud Practitioner, S3, Redshift , Athena, Sage-Maker, Amazon ML.
  • Open Source: Python-Pandas-Numpy- Scikit-learn, Spark, Py-Spark, R
  • Microsoft Suite: SQL Server, SSRS, SSIS, SSAS, Power BI
  • Statistics: SSAS, SPSS,
  • Data Architecture: Informatica Metadata Manager, Informatica Analyst, Erwin
  • Data Visualization: Toad, OBIEE, Tableau , Tableau Data Prep

Experience
AVP BI Developer III
Banking/Financial
May 2017 - present
  • Work closely with internal clients to examine and analyze data flows, reporting requirements and business models.
  • Participated in several Projects as Data Scientist and Data Engineer: Customer Churn Model, Customer Relationship Model (Vertex), Upselling and Cross Selling Model, using Python for Data Manipulation and Statistical Analysis
  • Work closely with data architects, data analysts and a variety of end users to ensure technical compatibility and user satisfaction.
  • Establish data architecture and BI best practices, standards and data models recommended data warehouse and reporting performance-tuning techniques.
  • Work with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
  • Enforced naming standards and data dictionary for data models.
  • Develop test scripts for ETL processes and reports.
  • Train end-users on usage of Business Intelligence applications, Tableau and OBIEE
  • Identify and fix performance issues regarding reports in SSRS
  • Oversee the deployment of reports, dashboard and scheduling agents.
  • Develop and maintain repository metadata dictionaries using Informatica Metadata Manager.
  • Analyze data using R-Studio and Provide insights to the Business User.
  • Contribute to the migration of the Bank United Data Platform from Oracle to AWS Redshift.
  • Conducted several POC for Data visualization using Apache Zeppelin, Network Libraries and Graphic Databases
  • Design Enterprise Deposit Data-Mart
  • Design and maintain Customer 360 Data-Mart
Apache AWS BI Developer Business Intelligence Data Analysis Data Visualization Data Warehousing ETL Informatica OBIEE Oracle Python SSRS Tableau AWS Redshift Data Architecture Data Dictionary Data Engineering Data Science Database Design Metadata
Remove Skill
Director Risk & Business Analytics
Information Technology
Oct 2012 - May 2017
  • Monitored Risk, Credit Quality and Performance of the Portfolio by developing and measuring daily, weekly and monthly KPIs. Forecasted Company Wide metrics (Revenue, Defaults, Profitability).
  • Introduced SAS as a statistical Analysis Tool and Reporting Engine.
  • Merged vastly different data sets in order to obtain homogeneous tables for further Analysis.
  • Ran logistic Regressions in order to Identify Variables that influence Auto Loan Defaults.
  • Ran Linear Regressions in order to test the influence on specific independent variables on Auto Loan Defaults.
  • Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
  • Based on the Analysis, Proposed Pricing Tiers in order to increase ROI.
  • Establish data architecture and BI best practices, standards and data models recommended data warehouse and reporting performance-tuning techniques.
  • Managed the Microsoft SQL Server Management Studio Platform in order to improve data flow and visualization for Business Stakeholders and decision makers.
  • Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
Data Warehousing Project Management SQL Stakeholder Engagement Business Requirements Analytics Data Architecture SAS SQL Server Linear Regression Logistic Regression Analysis
Remove Skill
Business Development Analyst
Banking/Financial
Jun 2011 - Oct 2012
  • Collaborated in the creation of a Model to Analyze Cost of Sale by top Channels and accounts.
  • Evaluated Capital Allocation Project, provide NPV calculation and present recommendations .
  • Responsible for the allocation of the Annual Guest Plan by Channel based on historical information.
  • Worked as a liaison with the Data Warehouse and Financial Departments.
  • Performed various analysis related to booking trends and booking Curves, interpret results and provide written recommendations to the entire Sales Organization.
  • Conducted ongoing analysis and develop new tracking mechanisms for sales promotions, product lines as well as ad-hoc travel agency analysis for Marketing, Revenue Management and Senior Management.
Data Warehousing Business Development Analysis
Remove Skill
Analyst, Yield Management
Information Technology
Mar 2008 - Jun 2011
  • Designed and maintained an Inventory Control System for CBS Interactive.
  • Forecasted monthly Traffic Trends, analyzed bookings Curves, proposed time and tier based Pricing.
  • Established a weekly communication with the Sales Teams to inform of current Opportunities in order to leverage our Inventory position and maximize revenue.
  • Worked as part of the Sales Operations Team setting the Rate Card (Pricing)
  • Member of the transition teams in charge of migrating data from different systems, including the implementation of micro-strategy.
  • Supported the implementation of Salesforce.com on CBS Interactive.
Salesforce Inventory Control
Remove Skill
Consultant
Information Technology
Mar 2007 - Mar 2008
  • Managed the Media/ Ad Operations Team
  • Implemented an Inventory Control System and create daily and weekly Performance Reports
  • Analyzed Advertising Expenditure among different media outlets (internet, TV).
  • Recommend strategies in order to increase ROI
  • Merged Publisher's and advertisers' reports in a comprehensive set in order to optimize ad revenue.
  • Worked closely with the PMO and IT team to implement all ad traffic and sales tracking requirement during a transition from Cold Fusion to a Java Platform.
Java PMO Inventory Control Cold Fusion
Remove Skill
Manager Research and Ad Operations
Information Technology
Jan 2004 - Mar 2007
  • Implemented a dynamic pricing structure (Rate Card) using the principles of price discrimination contributing to Increase total revenue by 120% since Q1-2005
  • Analyzed trends and seasonal patterns of Supply (Traffic) and Demand (Campaigns).
  • Developed a multivariate Demand Forecast Model.
  • Automated and Published weekly and monthly web traffic Reports.
  • Forecasted Expected Revenue by Site, Channel, Industry and Events.
  • Supervised Ad Operations and Research Team, recruited and trained new members
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Economics
Florida International University 2002
Record has not been verified.
Bachelor's in Economics
Florida International University 2000
Record has not been verified.
Skills
Data Warehousing
2021
9
Data Architecture
2021
8
Analysis
2017
5
Analytics
2017
4
Business Requirements
2017
4
Inventory Control
2011
4
Linear Regression
2017
4
Logistic Regression
2017
4
Project Management
2017
4
SAS
2017
4
SQL
2017
4
SQL Server
2017
4
Stakeholder Engagement
2017
4
Apache
2021
3
AWS
2021
3
AWS Redshift
2021
3
BI Developer
2021
3
Business Intelligence
2021
3
Data Analysis
2021
3
Data Dictionary
2021
3
Data Engineering
2021
3
Data Science
2021
3
Data Visualization
2021
3
Database Design
2021
3
ETL
2021
3
Informatica
2021
3
Metadata
2021
3
OBIEE
2021
3
Oracle
2021
3
Python
2021
3
Salesforce
2011
3
SSRS
2021
3
Tableau
2021
3
Business Development
2012
1
Cold Fusion
2008
1
Java
2008
1
PMO
2008
1
AWS S3
0
1
Erwin Data Modler
0
1
IBM SPSS
0
1
MS Power BI
0
1
Spark
0
1
SSAS
0
1
SSIS
0
1
TOAD
0
1