DWH for IBM Maintenance Contracts
In this project, I assumed the BI architect position to create and maintain a robust data warehouse that would gather data from different sources (sales, contracts, maintenance, customers, ledgers, and more) and combine them to retain data integrity.
The project took approximately four months to launch the initial version which was already fairly complete and it is ongoing with minimal maintenance needs. As it was completed in an IBM environment, I chose to use DB2 10.1 as the database manager, SQL scripts were managed by IBM Data Server Manager for the ETL, and Cognos 11 was used for the data visualization.
As this is a private project there is no link to share.
Data Visualization for IBM Badges Program
Once IBM had launched the IBM Open Badge Program (IBM.com/training/badges), we realized that no current app fit our needs. We needed one that would gather all employee data, match it to the badge data, and compare it to the market.
This realization led me to start the development of this project on my own, and I was ablnice model and ETL scripts to handle data transformation. I constructed an IBM Data Server Manager to manage these transformation jobs and a MySQL database hosted on Cloud (IBM Bluemix).
Visualization Project Details (Two Methods):
1. I, with the help of a web-developer friend, was able to put beautiful charts on a page with a D3.js library (advanced analysis).
2. For the second way, I used a Watson Analytics tool (web-Tableau-like) to create control dashboards for first-line managers.
The target audience of this side project consisted of high-level managers so that they could plan their team development as well as assign the right people to the right projects.
I launched this project within three months of IBM Open Badge program launch, and the timing was just perfect. The upper executive management officially recognized me.
I've attached a couple of screenshots of the managers' dashboards as this data is public.
Performance Marketing Spend Tracking
In this project, my team and I created a cube for the performance marketing team to control their spending and to develop budgets for the more performant campaigns. I extracted data from many sources like Google Analytics, AppsFlyer, AdWords, Criteo, Bing, Facebook, and combined them with sala data to be able to calculate metrics like Conversion Rate, Churn, Cost per Sale, LTV, CPA, CAC in many dimensions.
Together with the marketing team, we defined transformation rules for the UTMs in the web, and deep links in mobile, to aggregate it by the group channels (i.e., SEO, retargeting, social media, and so on).
Most of my work consisted of extensive and interactive collaboration with the marketing team to validate this data, which ended up with several changes to the UTM classification for proper control enablement. I had the opportunity to learn a lot of digital marketing and deeply understand how is the data analysis related to performance marketing.
Our new product replaced all of the worksheets and manual work of obtaining data from the source; it also sent all this data to an automatized dashboard and a cube to slice and dice the data.
Unfortunately, I cannot share a link as this is a private project.
Decommission, Deployment, and Upgrades of DB2 Databases
For two years, I was in charge of various types of server management for American Express projects.
I needed to determine whether to shut down a database due to lack of usage—which would save money—along with if there was a need for new databases for existing/new projects. I was also the focal point of the database migration and upgrades, which used to happen during the weekend maintenance hours.
In this position, I was responsible for 100+ decommissions, 20+ upgrades, and 200+ database creations. I worked as part of a big database team that handled a significant data center migration.
Subscription Model KPIs
At PlayKids, one of the companies of the Movile group, I had the opportunity to restructure all indicators and KPIs so that high-level management could have a more accurate view of the business.
I suggested a new methodology that is specific for the subscription business model that creates market KPIs without the noise that you'd have if you used a traditional data model like the ones for eCommerce. We also recalculated the active user base, churn, conversion, and trial success rate along other indicators.