Professional Summary

• Business Intelligence Developer with over 6 years of professional and technical experience.
• Extensive abilities in writing T-SQL queries and developing SQL databases.
• Create OLAP cubes from relational data warehouses to develop measures, dimensions, and business-critical KPIs, in addition to representing aggregations in different ways hierarchically and using custom groupings with SSAS .
• Develop detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to end user business requirements using SSRS.
• Designand implement new ETL processes and adapting current ETL processes to accommodate changes in source systems/new business user requirements SSIS .
• Extensive Visual Studio ,SSDT and Microsoft SQL Server 2012 using the complete BI Tool Set
• Deployment and developmentof Performance Point and SharePointServer.
• Experience with Master Data Management Data Quality concepts and applications, i.e. SQL Server MDM DQS
• Advanced skills in creating Reports, Dashboard and perform Data Visualization using Tabluea 8.2
• Proficient emotional intelligence employability skills including Integrity, Adaptability, Strong Work Ethic, and the ability to work well in teams.

Technical Skills

• SQL Server 2008 and SQL Server 2012
• Management Studio Microsoft
• Integration Services SSIS
• Microsoft SQL Server Analysis Services SSAS
• Microsoft SQL Server Reporting Services SSRS
• SQL Server Business Intelligence Studio
• SQL Server, MDX CUBES, SQL Plus
• SQL Developer
• T-SQL
• MS Visio
• MS Access
• Oracle 9i, 10g, 11g and PL/SQL
• Performance Point Server and SharePoint Sever
• Master Data Management Data Quality concepts and applications i.e. SQL Server 2012 MDM DQS,Tableau 8.2

Experience

Confidential

Reports /Business Intelligence Developer

• Developed SSRS reports, SSIS integration packages, SSAS analysis cubes using Microsoft BIDS/SSDT andTableau 8.2
• Designed and implement multi-dimensional models, including the construction of Data Views, Dimensions, and Cubes while adhering to enforced development methodologies.
• Created SharePoint dashboards with Dashboard Designer and PerformancePoint Services.
• Developed SQL Queries, Views and Stored Procedures.
• Managed data crosswalks between multiple source systems feeding the data warehouse.
• Worked with project lead and business users to gather requirements, conduct analysis and prepare specifications.
• Translated project requirements into functional and non-functional specifications for BI reports and applications.
• Contributed to and support the organization's Business Intelligence strategy.
• Developed and implemented tactical and strategic data warehousing solutions including corporate Data Warehouse.
• Developed, implemented and maintained test strategies and plans.
• Converted existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
• Designed and implement required interfaces for the data warehouse including to BI tools and other applications used by the business
• Developed accurate time estimates for assignments.
• Developed and implement test plans to determine if functional requirements have been met.
• Utilized and established programming, testing and release standards. Participate in the refinement and maintenance of current standards and the establishment of new standards.
• Participated in the evaluation of new techniques, technologies and tools.
• Designed and implement the data loading ETL and publishing processes within the DW/BI environment
• Designed and developed with Master Data Management Data Quality concepts and applications, i.e. SQL Server MDM DQS.

Confidential

Business Intelligence Developer

• Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse and OLAP Cube using the entire Microsoft BI Stack with emphasis on, but not limited to, SSIS, SSAS, SSRS and SharePoint Server.
• Contracted during design phase of project to help complete the redesign of end client SQL Server 2012 Data Warehouse.
• Created Star Schemas for BI applications.
• Assisted in design/modeling of star schema for new California Tax Assessors officer with data warehouse concept flow.
• Utilized SSIS to extract data from main frame to load data into the new data warehouse.
• Created eight OLAP cubes from relational data warehouse with various measures, dimensions, and business critical KPIs and representing aggregations in different ways hierarchically and using custom groupings using SSAS.
• Using Star schema in a SQL/SERVER environment, stored Insite Data Model in a SQL/SERVER data warehouse.
• Created forty various reports using SSRS from OLAP cubes and publish and secured with SharePoint Server.
• Developed Reports based on User input and published using SharePoint Server.

Confidential

Business Intelligence Developer

• Utilized SSIS to extract data from Access, Seibel and Excel forms to perform the transformation, cleansing and loading into the data warehouse.
• Created OLAP cubes from relational data warehouse to develop measures, dimensions, and business critical KPIs and representing aggregations in different ways - hierarchically and using custom groupings using SSAS.
• Provided the application analyses, data modeling, metadata management, and integration testing functions for existing applications and the new performance assessment and invoice visibility applications.
• Created MDX queries according to business requirements.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to end user business requirements using SSRS.
• Assisted in design and data modeling of tax applications.

Confidential

Business Intelligence Developer

• Utilized SSAS to create cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance.
• Performance tuning, backup/recovery and data modeling support Power Designer on Legacy Application IBM IDA.
• Provided dimensional modeling and OLAP cube creation using SSAS.
• Designed reports using SSRS base on end user requirements.
• Extracted data from customer rational databases using SSIS to load data warehouse.

Confidential

Business Intelligence Develop

• Designed and implemented new ETL processes. Adapted current ETL processes to accommodate changes in source systems and new business user requirements. SSIS .
• Developed reports interactive business and with drill down abilities reports using Microsoft SQL Server Reporting Services SSRS based on existing data sources.
• Installed, configured, and troubleshotSQL Server 2008.
• Created logical and physical data models in both normalized 3rd NF .
• Designed data warehouses and detailed multi-dimensional i.e. OLAP databases necessary to using SSAS.
• Designed, developed, and optimized OLAP cubes used for reporting and analytics, including PPS pages/web parts, SSRS reports, and Excel report templates connected to OLAP cubes.
• Wrote TSQL and MDX queries in support of reporting and analytic solutions.

Confidential

Business Intelligence Master's Program

• Completed 'Set Focus Business Intelligence Master's Program' Intensive, hands-on, project oriented program where participants add SME Subject Matter Expert knowledge of and valuable experience putting the Business Intelligence skill set to use in a simulated work environment.
• Implemented a labor analysis business intelligence solution for a national construction company.
• Existing data from diverse data sources was consolidated into a uniform SQL Server 2008 database.
• ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data, and to define database maintenance plans and send emails.
• Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
• Created score cards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a construction company extracting data from SQL Server 2008 OLAP data source and deployed to SharePoint sites. The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.
• Key product areas utilized also included data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.
• Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions.
• Utilized strong knowledge of writing, tuning and optimizing T-SQL queries.

Confidential

Database Developer

• Extracted data from Oracle,DB2, and other various databases using SSIS for the Blue Cross contract.
• Performed system data analysis. Created, modified, documented, and enhanced data specifications included identifying and mapping data elements from source systems into staging areas, the data warehouse, data marts, and OLAP cubes .
• Created reports using with SSRS.
• Performed administration, troubleshooting, configuring, monitoring, support and optimization of Oracle 10g and SQL Server 20008databases.
• Implemented and installed new SQL 2008 and Oracle products and features.
• Developed, tested, and deployedOracle database backup and restore procedure using RMAN.
• Optimized T-SQLqueries utilizing SQL Profiler.
• Performed SQL Server 2005/2008 database development, support, and administration tasks.
• Administered SSAS servers. Installed and upgraded SSAS servers. Configured SSAS settings, security, processing, deployments, migration, backing ups and cube restorations.
• Performed ASM storage management and ASM performance analysis.
• Performed upgrades, patches and installations of Oracle 10g RDBMS,Clusterware and RAC components.
• Collaborated with enterprise architecture and application teams to design solutions.
• Supported Oracle and SQL Server 2008,2005 databases including creation of databases, stored procedures and functions , OLAP engines.
• Asked questions of nontechnical people to fully understand ideas or needs.

Confidential

Database Administrator

• sted the Technology Coordinator for Saint Louis University Facilities department with database administration and maintenance.
• Performed Oracle and SQL Server 2005 database administration in the UNIX and Windows environment.
• Assisted in database design, performance monitoring and tuning, capacity planning, database backup and recovery, SQL statement tuning.
• Used Oracle Enterprise Manager, Data Pump, RMAN, and GRID Control.
• Performed Oracle database upgrade from 9i/10g to 11g conversion and migration.
• Used database clustering technologies including RAC, Microsoft SQL Server 2005.
• Performed application development, and administration of Maximo database and Unitimeapplication.
• Designed and developed databases in SQL Server 2005, along with the ETL applications required to build them.
• Used VMware 3.0 ESX, Windows Server 2000 and Windows Server 2003 to consolidate the department servers.