PROFESSIONAL IT SUMMARY:

• 15 years of experience in the IT industry.
• 8 years of experience in Designing and Implementing OLAP Cubes.
• 8 years of experience in building ad hoc BI solutions using technologies within the Microsoft Business Intelligence Platform in the banking, post-secondary education, and food manufacturing industries.
• 4 years of experience in installation of SharePoint 2007 and 2010.
• 4 years of experience in data migration.
• Designed, developed and implemented Roambi Mobile Dashboards.
• Developed and implemented SQL Server Reporting Services SSRS to build reports based on T-SQL and MDX queries.
• Developed ETL process using SSIS to build and implement Data Warehouse solutions and Data Modeling.
• Expert in operational acceptance testing with new systems.
• Proficient in day to day maintenance of server infrastructure.
• Skilled in software related troubleshooting.

TECHNICAL SUMMARY:

Business Intelligence Tools:

SQL Server Analysis Services SSAS 2005/2008R2/2012, SQL Server Integration Services SSIS 2005/2008R2/2012, SQL Server Reporting Services SSRS 2005/2008R2/2012, ProClarity, PerformancePoint Server, PerformancePoint Services, Roambi Mobile, PowerPivot, PowerView, ReportPortal, Oracle Business Intelligence Enterprise Edition OBIEE , Artus, QlickView, Tableau, Panorama, SAP SybaseIQ, SharePoint 2007/2010.

Database Technologies:

SQL Server 2005/2008R2/2012, Oracle, Microsoft Access

Programming Technologies:

C, C , ASP/ASP.NET, .NET FRAMEWORK 2.0/3.0/3.5

Operating Systems:

Windows 2000/Server 2003/Server 2008/XP/Vista/7, Linux SUSE

PROFESSIONAL SUMMARY:

Sr. Business Intelligence Specialist

Confidential

• Developed and implemented ETL process in SSIS to collect daily information from Sybase into SQL Data warehouse for different OLAP models and Reporting Services portal.
• Designed, developed and implemented an Insurance Model, creating SSIS ETL process for Dimensions update, Fact Table calculations, to improve sales based on trend analysis.
• Created OLAP cubes and dimensions for the Insurance Model using SSAS.
• Mentored my team on principles, best practices and analysis of OLAP cubes and dimensions.
• Migrated the SSIS ETL process for a specific business unit from SQL to IQ based source. This implementation was required for the Financial Unit to support projections and trend analysis for executive decisions.
• Designed and implemented the SSIS ETL process and development of stored procedures for the Tactical System Information, which is the source platform of information for the organization.
• Designed and implemented OLAP Cubes and dimensions for the Tactical System Information model using SSAS.
• Designed and developed multiple reports using SSRS, including multiple levels such as global, detailed, trend, comparative, etc.
• Performed administration for the OLAP Cubes within OBIEE.
• Detailed a plan for capacity and sizing of BI infrastructure in order to achieve high availability and optimum performance.

Sr. Business Intelligence Specialist

Confidential

• Designed and implemented a worldwide financial portal using SharePoint 2007, with information of branches in USA, Europe, Asia, Mexico, Central and South America and the Consolidated Corporate.
• Developed interactive dashboards and reports.
• Designed and implemented an ETL process based on 80 excel files located in 30 different locations and for Medical Insurance Analysis using SSIS.
• Designed and developed OLAP cubes to be the main source of information for the Board of Directors using SSAS. This tool was used monthly to make decisions based on trends and projections.
• Created multiple reports using SSRS Report Suites for the World Financial Portal.
• Developed multiple reports with a dashboard look and feel for the Medical Insurance Analysis using SSRS.
• Collaborated with the HR department to analyze expenses, cost, and recurrence in employee's illness by building an OLAP cube using SSAS.
• Designed and developed a time tracking portal using Access Database and aspx pages to track project's timeline and deliverables.
• Provided maintenance of corporate reports using SSRS Report Suites for Gruma Headquarters and its different branches.
• Designed and developed a time tracking portal using Access Database and aspx pages to track project's timeline and deliverables.
• Designed and developed multiple reports in SSRS 2008R2 as a source for Roambi Mobile Solution.
• Designed and implemented Roambi Mobile Dashboards.

Sr. Business Intelligence Specialist

Confidential

• Performed a migration from Windows Server 200 and 2003 to Windows Server 2008R2.
• Migrated the Academic, Teacher, and Student models from SQL Server 2000 DTS to SSIS 2005 DTSX packages.
• Consolidated previous cubes of Academic, Teacher, and Student models into one School Hypercube Model using SSAS.
• Developed and provided maintenance for multiple reports using SSRS Reports Suite for the School Hypercube model for desktop and mobile users.
• Designed and implemented Analytical Dashboard for the School Hypercube Model using Microsoft ProClarity and PerformancePoint for desktop and mobile users.
• Helped the accounting department design and implement the ETL process for the School Accounting Model to analyze incomes and expenses in college divisions.
• Designed a real time OLAP cube using SSAS for the School Accounting Model.
• Designed, developed, implemented, and maintained the SSRS Reports Suite of the School Accounting Model for desktop and mobile users.
• Designed analytical dashboards for School Hypercube Model using Microsoft ProClarity and PerformancePoint Server for desktop and mobile users.
• Designed, developed, and implemented the ETL process for Enrollment Analytic Model, which served as the basis of a predictive model used by directors.
• Designed a real time OLAP cube using SSAS for the Enrollment Analytic Model.
• Designed, developed, implemented, and maintained the SSRS Reports Suite of the Enrollment Analytic Model for desktop and mobile users.
• Responsible for the installation, configuration, test and administration of analytic tools such as QlickView, Tableau, Panorama and ReportPortal.
• In charge of installing and configuring SharePoint 2007 and 2010.
• Provided on-site and remote post-production support to the OLA Models and Analytic tools users.