TECHNICAL SKILLS:

• SQL Server (SSIS, SSAS, and SSRS)
• Sybase
• Oracle
• IBM DB2
• SQL
• MDX
• DAX
• SQL Server Business Intelligence Development Studio (BIDS)
• SQL Server Management Studio (SSMS)
• XML for analysis services (XMLA)
• SharePoint
• Kimball style dim - fact dimensional modeling
• ETL design, and development using structured mapping documents using SSIS, and Alteryx
• SQL Server Analysis Services multidimensional cube design, and development
• SQL Server Analysis Services tabular model design, and development
• Delivery of self service business intelligence, and reporting solutions.
• Data warehouse design, and architecture
• Data modeling using ER Studio
• Agile analysis, and development using market leading reporting, and analytics tools
• SQL Server Reporting Services (SSRS)
• Report Builder
• Tableau
• Alteryx
• Excel
• Power Pivot
• ProClarity
• Qlik Sense
• Investment Banking, Financial Services, Prime Services, Securities Lending, Credit Default Swaps, Mortgage Backed Securities, Health Care, Reinsurance, Media and Entertainment, Publishing, and Real Estate.

WORK EXPERIENCE:

Confidential

Business Intelligence Consultant

Responsibilities:

• Design, development, and support of the core derivatives enterprise reporting platform for the capital markets group. This system is also used to generate sub-ledger, and general ledger entries to support reconciliation with the people soft system for the accounting department. This database platform serves as a golden source of end of the day data, and supports all financial, and regulatory reporting.
• The system captures, and reports on Counterparties, Deals, Cash flows, PV, Potential exposure, Collateral details, and Credit for all types of transactions including Swaps, Bonds, ETDs, Futures, and Options.
• Several core derivative, and accounting regulatory reports, and dashboards have been built using SQL Server, Qlikview, and SQL Server Reporting Services.
• The technology used to deliver the reporting platform includes SQL Server, SQL Server Integration Services, SQL Server Reporting Services, Qlikview, Excel, and Tidal. Reporting data is aggregated from several source systems residing on Oracle, Informix, Sybase, and SQL Server using SQL Server Integration Services, Transact SQL, Stored Procedures, and Tidal.

Confidential

Business Intelligence Consultant

Responsibilities:

• As part of the Enterprise Data Warehousing, and Business Intelligence Team, participated in the design, and development of Staging, Warehouse, and Datamart environments
• The data was loaded from multiple enterprise wide data sources using master, and child SSIS packages, Transact SQL, and Stored Procedures.
• Fact, Dimension, and Bridge tables have been loaded incorporating best practices of modular development, logging, configurations, and history.
• Participated in full life cycle development in development, QA, UAT, and production environments including database table design, development of stored procedures, script management, and sql server agent jobs.
• The technical platform includes SQL Server 2012, SQL Server 2016, Transact SQL, SQL Server Integration Services (SSIS), SQL Server Agent based job scheduling, Visual Studio, Team Foundation Server, and Tableau, and Qlikview.

Confidential

Business Intelligence Consultant

Responsibilities:

• Designed, and delivered a self-service reporting platform using several SSAS tabular models, Tableau, and Excel for finance, accounting, content, and monitoring groups.
• Designed, and implemented star schema based dimensional models working closely with the business using best practices incorporating business process matrix, appropriate fact tables based on the correct grain, conforming dimensions, ETL mapping, Transact SQL, and SSIS based pipe line data flow implementation of full load, and incremental loads in SQL Server environment.
• Designed, and developed multidimensional cubes using SQL Server Analysis Services (SSAS), and MDX to handle very high volume, and many to many relationships using bridge tables.
• As a SQL Server subject matter expert, and developer, implemented several business processes using transact sql stored procedures, and functions with focus on data integrity, and performance.
• The very high volume in memory tabular models host hundreds of millions of rows of data.
• Several high performance SSAS Tabular logical end user reporting models that support self-service reporting have been accomplished using tables, relationships, calculated columns, measures, DAX, and role based security.
• Built several reporting, and analytical solutions using Tableau, and excel pivot tables connected to SQL Server Data Warehouse, and SSAS tabular models.
• Designed, and developed several scheduled Tableau, and SSRS reports using the data from SSAS tabular models.
• Mentored, and trained users in Tableau, Excel, Report Builder, and SQL Server Reporting Services.

Confidential

Business Intelligence Consultant

Responsibilities:

• Architect, and developer for a visual analytics solution for the finance department using Tableau Desktop 9.0, Tableau Reader, Excel, SQL Server, and Alteryx.
• Integrated a set of business reporting data sources, and managed system data sources in to a uniform data layer for the next generation Tableau visualization solution using worksheets, dashboards, and stories.
• Implemented user based security, and a key code based solution to deliver a customized solution platform for the business units using a single Tableau workbook.
• The Tableau guided analytics solution uses data sources, joins, data source relationships, data blending, parameters, quick filters, action filters, row based calculated columns, set based computed columns, bar charts, line charts, donut charts, high light tables, and custom formatting to deliver interactive worksheets, dashboards, and stories.

Confidential

Business Intelligence Consultant

Responsibilities:

• Designed, and implemented self service business intelligence, and reporting solutions for various departments as part of the enterprise business intelligence team.
• The solutions in corporate in memory technologies of SQL Server Analysis Services Tabular Models, and Power Pivot. The source data present in Oracle is modeled as a dimensional model deployed on a SQL Server Analysis Services Tabular platform. Excel pivot table services, SQL Server Reporting Services (SSRS), and Power View are used as end user reporting tools. The reports are shared using a SharePoint environment.
• Participated in the development of a set of multidimensional models for a high volume self service reporting platform by implementing Kimball dimensional models, SQL Server data marts, SQL Server Analysis Services (SSAS), MDX, and SQL Server Reporting Services (SSRS).
• Developed innovative performance dashboards using Tableau desktop, and Tableau server to monitor all aspects of data integration, and loading of data from source systems.
• Developed actions based dashboards for delivering visualizations to the business using all Tableau features including work books, work sheets, data sources, blending, extracts, filters, parameters, dimensions, measures, calculated measures, table driven aggregated calculations, different chart types, and custom formatting.

Confidential

Business Intelligence Consultant

Responsibilities:

• Designed, and implemented a data warehouse platform for the Residential Mortgage Backed Securities trade, and loan information in a SQL Server environment.
• The project includes the data warehouse design, and implementation, ETL design, and implementation, and the design, and implementation of reports using Microsoft SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power Pivot, Power View, and Share Point to support trading, and regulatory reporting requirements.

Confidential

Business Intelligence Consultant

Responsibilities:

• Designed, and delivered a dimensional data mart, and OLAP cubes for a large multiple facility health care group using SQL Server 2008 R2, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power Pivot, Power View, and Share Point.
• Incorporated the extensive domain knowledge present in the team to design a set of kimball style star schemas to support self service reporting.
• The appropriate ETL procedures have been written to accomplish a periodic load of source system data in to the SQL Server data mart tables using change data capture (CDC), and SQL Server Integration Services (SSIS).
• Multiple SQL Server Analysis Services (SSAS) cubes have been designed, and built consuming the shared data mart containing a conforming set of dimensions, and fact tables. This includes dimension design, setting up measure groups, establishing attribute relationships, managing role playing dimensions, and relating dimensions to measure groups directly, and using many to many relationships. MDX is used appropriately in extending the cube design for calculations, role based security, implementing dynamic conversion using scope statement, and creating named sets.
• The end user business analysts consume the data using SQL Server Reporting Services (SSRS), report builder, and excel, and deploy the reports to a shared reporting services environment. The design has been appreciated by the key stake holders for its ability to democratize information within the group by using self service slice, and dice reporting tools.

Confidential

Business Intelligence Consultant

Responsibilities:

• Designed, and developed a global compliance data mart, analytics, reporting, and forecasting system integrating individual country regulations, client information, employee information to deliver a flexible partner rotation system across business lines.
• Technical platform includes SQL Server 2008 R2, SQL Server 2008 R2 Analysis Services (SSAS), SQL Server 2008 R2 Integration Services (SSIS), SQL Server 2008 R2 Reporting Services (SSRS), SQL, MDX, C#, and ASP.NET.
• Core responsibilities include
• Data mart design, and implementation in SQL Server 208 R2.
• Cube based OLAP design, and implementation using SQL Server 2008 R2 Analysis Services (SSAS).
• Lead, and mentor a team in the design, and implementation of extraction, transformation, and loading (ETL) layer using SQL Server 2008 R2 Integration Services (SSIS) to move data across different systems.
• Lead, and mentor a team in the design, and development of analytical, and forecasting reports using SQL Server 2008 R2 Reporting Services (SSRS), and SQL Server 2008 R2 Analysis Services (SSAS).
• Evaluated source system data, and reporting artifacts to arrive at a star schema dimensional model containing dimension tables, fact tables, and bridge tables based on the kimball methodology. Evaluated, and implemented the data mart in SQL Server 2008 R2.
• Designed, and implemented an OLAP cube based analytics platform containing data source, data source view, measures, measure groups, dimensions, attributes, dimension usage, and calculated members.
• Integrated a known package development, and logging framework using SQL Server 2008 R2 Integration Services (SSIS) in to the project environment. Directed a team to implement the packages to accomplish the extraction, transformation, and loading (ETL) of source business data containing clients, employees, regulations, roles, member firms, and status information.
• Development of analytical, and forecasting reports using SQL Server 2008 R2 Reporting Services (SSRS), and SQL Server 2008 R2 Analysis Services (SSAS). The parameterized reports use data sources, data sets, and custom MDX to connect to SSAS OLAP cube.

Confidential

Business Intelligence Consultant 09/2011 - 02/2012

Legal, and compliance project to manage, and report on firm wide portfolio, and relationships

• Designed, and implemented a data warehouse to accumulate firm wide portfolio, and relationships data using SQL Server 2008.
• Architected, and implemented SQL Server Integration Services (SSIS) based ETL environment on SQL Server to manage, and accumulated data from multiple systems.
• Designed, and implemented a STAR schema based data mart to enable reporting using SQL Server 2008.
• Designed, and implemented custom dimensions including appropriate attribute hierarchies, custom hierarchies, parent child hierarchies, attribute relationships using BIDS, and deployed in to the SQL Server Analysis Services (SSAS) environment.
• Implemented, several measure groups from the underlying fact tables to accomplish the exposure of business critical measures to the end user tools in SSAS.
• Role based security has been implemented in the SQL Server Analysis Services (SSAS) using custom dimension security, and MDX expressions

National Benefit Fund

Business Intelligence Consultant

Responsibilities:

• Designed, and implemented custom dimensions including appropriate attribute hierarchies, custom hierarchies, parent child hierarchies, attribute relationships using BIDS, and deployed in to the SSAS environment.
• Implemented, several measure groups from the underlying fact tables to accomplish the exposure of business critical measures to the end user tools in SSAS.
• The conforming set of dimensions are related to the appropriate measure groups at the correct grain level in the dimension usage area of the BIDS, and deployed to SSAS.
• Concepts of fact dimensions, and many-to-many relationships are implemented in the dimension usage area of BIDS.
• Implemented role playing cube dimensions using database dimensions to handle different types of date values in the fact tables in SSAS.
• Role based security has been implemented in the SQL Server Analysis Services (SSAS) using custom dimension security, and MDX expressions.
• Aggregations have been built, and maintained in order to enable performance in SSAS.
• A custom measure group partitioning scheme has been implemented in order to enable processing, and performance in SSAS.
• Custom calculations have been implemented using MDX to accomplish incremental business requirements using the basic measures. Custom dimensions have been implemented using the scope concept in the calculations area of the cube.
• The dimensions, and measure groups are processed using scheduled SSIS packages.

Confidential

Business Intelligence Consultant

Responsibilities:

• Built a next generation reporting, and visual analytics platform to deliver securities lending, client performance, and spreads analysis information to support the prime services business.
• The technology platform includes Microsoft SQL Server 2005, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Tableau.

Confidential

Database Consultant

Responsibilities:

• Part of the data migration team, working on an enterprise wide data migration, and integration project in the role of a database architect.
• The core ratings database containing hundreds of database tables is being migrated from Sybase to DB2.
• The source data and data models have been re-architected to suit the business needs.
• Primary responsibilities include ETL planning, source to target mapping, data analysis, and transact SQL coding. The tools, and technologies used to accomplish the project include Sybase, DB2, ER Studio, Rapid SQL, Transact SQL, and datastage.