Data Warehouse & Business Intelligence
- Charlotte, North Carolina
- Information Technology and Services
|Recommendations||6 people have recommended Rafael|
Join LinkedIn and access Rafael's full profile. It's free!
As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.
- See who you know in common
- Get introduced
- Contact Rafael directly
Rafael is a speaker, published authored and blogger with +15 years of relevant IT experience across multiple industries. He specializes in Business Intelligence and information architecture and is the recipient of multiple industry awards, including Microsoft Most Valuable Professional (MVP) and The Data Warehouse Institute best practices. Rafael is also an active member in the SQL Server technical community and maintains a blog at www.rafael-salas.com.
Manning PublicationsOctober 2011
SQL Server MVP Deep Dives, Volume 2 picks up where the first volume leaves off, with completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization. The chapters fall into five parts: Architecture and Design, Database Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence.
CBIG is a technical user group focused on Business Intelligence topics and local chapter of PASS.
Translated customer business requirements into effective marketing and customer intelligence solutions, design and delivery for B2B and B2C organizations. Managed a team of professionals through +$2M projects in an agile environment. Leveraged expertise in data integration and data quality to develop innovative data warehouse solutions including the architecture of reporting, dashboarding and end-user components. Harvested intellectual property to identify and develop innovative solutions and products. Established rapport and conducted in-depth client needs assessments to understand customer needs and provided relevant solutions, ensuring on-time and on-budget delivery of projects while improving profit margins for the company.
Served as a lead technical consultant and architect, securing and managing business intelligence and data warehousing projects to school districts throughout the U.S. Generated proposals, risk assessments, statements of works and responded to RFPs. Delivered technical demonstrations to support sales efforts and create customized solutions. Developed and enforced coding standards, facilitated dimensional modeling design and review sessions with technical and business audiences. Assessed intellectual capital, developed products and authored industry reference data warehousing modeling to support corporate initiatives in strategic market positioning. Developed detailed project development plans, scope statements, cost proposals and risk assessments.
Designed, built and managed data warehouse systems and supporting ETL processes to satisfy client business requirements. Conducted ongoing review and modification to adjust and improve performance of data integration process. Created and developed requested reporting capabilities, enabled geo-spatial-based analysis services and implemented Cognos Noticecast agents to alert users when reporting thresholds were met. Developed scripts and stored procedures to address outstanding data quality issues. Educated and supported end-users on data warehouse and business intelligence concepts and capabilities.
Participated in an initiative to build a system to forecast long term demand of materials and services in oil exploitation projects. Installed and configured Oracle Warehouse Builder (ETL), and Oracle Discoverer (data analysis). Estimated resources to build the ETL component of the system. Analyzed legacy systems structures and created ETL data mapping documents. Participated in the technical review committee of the logical and physical database models. Used tools: Oracle RDBMS 9i, SQL*plus, Oracle Discoverer 4i, Oracle Warehouse Builder.
Corporate Data Warehouse Project: Educated users on data warehouse concepts and capabilities. Gathered, analyzed and unified business requirements across departments. Identified and designed data warehouse facts and dimensions following start schema modeling rules. Performed gap analysis between source systems and target database. Developed ETL processes to integrate information from legacy systems into corporate data warehouse database
Honors & Awards
Most Valuable Professional - MVP
The Microsoft MVP Award is an annual award that recognizes exceptional technology
community leaders worldwide who actively share their high quality, real world expertise with users and Microsoft.
Rafael has been MVP award recipient since 2007
- Business Intelligence
- SQL Server
- Analysis Services
- Information Architecture
- Data Quality
- Software Project...
- Microsoft SQL Server
- Agile Methodologies
- Data Warehousing
- Data Integration
- Dimensional Modeling
- SQL Tuning
- Database Design
- Database Administration
- Performance Tuning
- Data Modeling
- Enterprise Architecture
- Stored Procedures
- Data Warehouse...
- Solution Architecture
- Data Architecture
- Business Intelligence...
- Master Data Management
- Requirements Analysis
- Software Development
- Relational Databases
- See 33+ See less
Search by name
Over 300 million professionals are already on LinkedIn. Find who you know.
Find a different Rafael Salas
Executive Transport and Logistics Manager - 3PL - 4PL - Temperature Controlled Transport (Companies: STEF, Salvesen)
Madrid Area, Spain
Sevilla Area, Spain
Houston, Texas Area
EAE Business School Student
Country Risk Officer at Zurich Insurance Company Ltd.
Belo Horizonte Area, Brazil