Business Intelligence Developer Resume Plano, TX - Hire IT People

SUMMARY

Develop enterprise level decision support systems using industry leading business intelligence tools, such as Microsoft Business Intelligence Stack (SSMS/SSAS/SSIS/SSRS)
12 years of successful enterprise level business intelligence development and implementation experience in diversified environments including real estate, hospitality/gaming, entertainment, advertising, telecommunications, transportation and the federal government, service, textile and mining

TECHNICAL SKILLS

Specialty: BI/Data Warehouse development, deployment & support, ETL & Data modeling

Platforms: SQL Server SSIS/SSAS/SSMS/SSRS 2005/2008/2012/2014/2016 , PowerBI

Languages: SQL, MDX, VB.NET, ASP.NET, C# Scripting

Systems: OLTP, OLAP Reporting Systems

Certification: Microsoft Certified Database Administrator (MCDBA), MCP, A+, Network+

Software: MS BI Stack, SalesForce /Service Max, Wherescape Red

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Business Intelligence Developer

Responsibilities:

Develop SSRS reports in Microsoft SQL Server environments (2008, 2012, 2014 & 2016) to 300+ internal within the Payment Card Industry.
Develop merchant facing reports for 26,000+ external users that provide transactional level details for credit and debit card processing and gift and reward card settlements.
Maintain strict payment Card Industry Data Security Standards (PCI - DSS) compliance.
Write stared procedures to extract data and authenticate users.
Prototype SSRS 2016 SSRS Reporting and PowerBI in Azure.
Train business analysts in self-service BI using PowerBI.

Confidential, Dallas, TX

Business Intelligence Consultant

Responsibilities:

Develop, test and maintain ETL processes using stored procedures and SSIS packages to support go-live operations in emerging global markets (Asia, South America and Eastern Europe) for Confidential core applications (CRM, Order Entry, Consultant, Customer RDMS) in an agile environment.
Develop, test and maintain ETL processes using SSIS packages to audit data flows. Perform root cause analysis and take remedial action.
Develop and manage BI job scheduling and monitoring using Control-M.
Provide support to global deployment of SSAS cubes. Take corrective action when cubes fail to process.
Develop SSRS reports to provide details on SSIS audit packages that fail.

Confidential

Business Intelligence Consultant

Responsibilities:

Maintain existing multidimensional cubes while implementing new Analysis Services (SSAS) Cubes (facts tables, dimensions, measure groups, cube partitions, etc.) to support enterprise reporting.
Work with business users and other stakeholders to understand business processes and translate them into functional and non-functional specifications to enhance BI solutions.
Develop SSIS packages and modify existing packages to support new data requirements for SSAS cubes per the requirements.
Provide training for new SSAS users using Power Pivot.
Develop business intelligence client and server-based visualizations using Microsoft technologies (PowerPivot, SSRS).
Develop and monitor daily and intra-day SSIS jobs and resolve any production issues in a timely manner
Support and maintain existing Tableau dashboards and scorecards.

Confidential, Chapel Hill, NC

Business Intelligence Consultant

Responsibilities:

Develop and maintain Analysis Services cubes (SSAS) for reporting and analysis in a variety of industries including wineries, textile, mining and chemical companies.
Quickly develop functional prototype SSAS cubes to present to customers.
Create reports, dashboards and analytics using SSRS.
Create dimensional data warehouses in SSMS for multiple companies.
Use SSIS and SSMS to cleanse source data.
Provide SSMS DBA services to smaller IT shops.