Raul Olvera Email & Phone Number

Seattle, Wa, Us

Provo, Ut, Us

Seattle, Washington, Us

As a consultant we meet with clients to understand their business needs, listen and propose ideas to help their business.Across the different projects I have been involved and managed I have dealt with the following.* The creation or modification of ETL processes usually built in SSIS packages which consumed data from different sources (API's , Flat files, Excel , other databases , etc.) , depending on what the data is going to be used there can be multiple stages of data transformation so that it gets to the state where its the best for the solution that is going to consume the data, these ETL processes are usually automated to run in a set schedule and have error handling in place.*Create SSRS reports for data analysis * Big Data Analytics , understand business needs and create models to play with the data and get answer that otherwise will not be possible with the current reporting software available, meet with executives to understand their business and suggest different analysis of user behavior to measure or better a campaign or KPIs *HTML 5 Reporting , create a fun and simple environments for reporting where user can have a better view to understand how their KPIs are working and how they relate, with the help of HTML5 these reports behave without any feeling of refresh time and are interactive to the user.* API's , Quickly learn how to retrieve data and create connectors for different APIs available (Facebook, Twitter, Youtube, etc.) .*Keep up to date with different technologies, specially the ones related to reporting, Currently learning Power BI tools , PowerMap and Mahout

Burbank, Ca, Us

Analize big data logs (Omniture, Freewheel, Uplynk) for user behavior analysis, connect different datasources for a better understanding , create automated process to extract data for report creation.Data Quality, identifying issues with the log data to pin point the cause.

Burbank, Ca, Us

Developed a Social Media tracker for fan growth analysis of multiple pages and channels , worked with the different APIs where available to gather the data on a daily basis. Create SSRS reports for data visualization and a automated monthly report delivery for executive.Access the Insights API and Facebook Tables (using FQL) to gather more in-deepth user and campaign analysis

Mexico City, Mexico City, Mx

Developed an internal wiki to use it as a knowledge repository of the team members, wiki had search capability, tagging, draft modes and auto saving (Ruby on Rails (http://wiki.innku.com)Managed a team of 7 a carpooling application for Innku’s "Aventones" (http://www.aventones.com/) . Users should be able to create or request rides and search through a whole route for a match. Company should be able to specify the domains that can register in order to use the application. (Ruby on Rails ,Google Maps API, MySQL)

Dublin 2, Ie

Worked with the end customer to gather requirements and develop a solution for requesting resources and assigning them to projects with an authorization process (digital signing), also managing financial information of each project, giving the user ability to forecast and keep track of the finances, (Development VB.Net, SQL Server)