TECHNICAL SKILLS:

Database platforms: SQL Server (SSIS, SSAS, and SSRS) Sybase Oracle IBM DB2

Languages, and tools: SQL MDX DAX SQL Server Business Intelligence Development Studio (BIDS) SQL Server Management Studio (SSMS) XML for analysis services (XMLA) SharePoint

BI platform design, and development: 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

Analytics, and reporting platforms: SQL Server Reporting Services (SSRS) Report Builder Tableau Alteryx Excel Power Pivot ProClarity Qlik Sense

Domain knowledge: 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

Responsibilities:

• 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

Confidential

Business Intelligence Consultant

Responsibilities:

• The SQL Server Kimball style STAR schema dimensional data mart is consumed through an intermediate layer of views in the data source view (DSV) of the Universal Dimensional Model (UDM) of Business Intelligence Development Studio (BIDS).
• 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.

Confidential, New York

SQL Server BI Consultant

Responsibilities:

• This project is an end to end data warehousing project that involves the analysis of source systems, relational data warehouse design, extraction transformation, and loading (ETL) from source systems to the target data warehouse, building of online analytical processing (OLAP) cubes, building sophisticated set of end user reports, and building a portal based delivery mechanism for the distribution of information to the enterprise.
• The technology platform includes Microsoft SQL Server 2005, Microsoft SharePoint Server, Transact-SQL, MDX, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), ASP, and C#.

Confidential, New York

SQL Server BI Consultant

Responsibilities:

• Part of the strategic P&L project team involved in the development and management of partitioned high volume data environment to handle accounting and P&L data for credit related products. This Microsoft SQL Server data warehouse handles the loading and storage of daily trade and accounting data. Partitioned environment and a relational OLAP based design enables the handling and effective searching of large volume of data.
• Participated in the development and management of the risk engine database platform; The risk engine database stores the risk data for credit related products using a Microsoft SQL Server based partitioned data environment. Responsibilities include credit default swaps support, database modeling, database design, database development, performance monitoring, and query tuning.

Confidential, New York

Database Consultant

Responsibilities:

• Responsibilities include enterprise wide database administration, database modeling, database design, database development, performance monitoring, query tuning, SQL Server 2005 server upgrade, database migration, and ASP.NET development using C#. The platforms include SQL Server 2000 and SQL Server 2005.
• Tools include SQL Server Enterprise Manager, SQL Query Analyzer, SQL Server 2000 Data Transformation Services (DTS), SQL Server 2005 Management Studio, Business Intelligence Development Studio, ERWIN and Visual Studio.

Confidential, New York

Vice President

Responsibilities:

• Designed and developed issuer performance report for commercial mortgage backed securities structured products research group using VB and Microsoft SQL Server 2000. Designed and developed a loss estimate data management platform using Excel, VBA and Microsoft SQL Server 2000.
• Designed and developed a database platform for the delivery of usage reports for the fixed income sales and research applications.
• Participated in the enhancement of credit default swaps trade capture application using C# and Microsoft SQL Server 2000.
• Designed and developed a generic database archival platform using Microsoft SQL server 2000.
• Delivered database services to the credit life insurance trade capture application.
• Participated in the enhancement of a data warehouse application using Microsoft Analysis Server, Microsoft SQL Server 2000, dimensions, measures, fact tables, MDX and data transformation services (DTS) packages.
• Provided support to the credit default swaps trading and middle office groups. This includes P&L applications that compute risk, derivatives order management system, credit spreads marking tool and market data system.

Confidential, Princeton, NJ

Database Architect and Developer

Responsibilities:

• Designed and developed a database platform for reinsurance system using Microsoft SQL Server 2000. This system uses stored procedures, user defined functions, rules, defaults, constraints and SQLXML to accomplish a robust database system.

Confidential, New York

Senior Database Administrator, and Developer

Responsibilities:

• Participated in the server migration from SQL Server 7.0 to SQL Server 2000, and business process development, and optimization on the database layer in the HMO business arena.

Confidential, New York

Senior Database Administrator and Developer

Responsibilities:

• Participated in the design, development, and administration of distributed database solutions using Microsoft SQL Server 2000, and other Microsoft server, middle-tier, and presentation layer technologies for delivering the next generation of technology, and content driven internet media sites.

Confidential, New York

Director of Database Development

Responsibilities:

• Instrumental in the design and development of a highly scalable database platform that forms the backend infrastructure for the MTV Internet Radio Product. Technologies used include MS SQL Server 7, Sybase, ODBC, Java, ASP, ERWIN, Windows NT, and Internet Information Server. Radio Sonicnet, a personalized streaming service to millions of users is MTV’s premier internet radio product.
• This is also the backbone for the universal registration service for all of MTV’s internet properties. Redundancy, fault tolerance, scalability, and application load balancing allow for potentially limitless growth of this database architecture. The system incorporates horizontal partitioning to achieve scalability, and clustering, and a multiple node network of database servers to achieve fault tolerance, and load balancing.
• SQL Server replication technology is used to deliver common programming content to multiple distributed database servers. Several performance monitoring tools, decision support, and data accumulation methodologies, data synchronization tools, replication procedures, and database administration procedures have been developed, and adopted, to deliver this mission critical system.

Database Architect, and Database Administrator

Confidential, New York

Responsibilities:

• Design, develop, and administer n-tier SQL Server based intranet, and internet based business systems using MS SQL Server 7, Sybase, VB 6, ASP, COM, ERWIN,
• Windows NT, and Internet Information Server. The host of databases supports several critical business to business web sites and print magazines. Cahners Business Information is the largest publisher of business to business information, publishing more than a hundred magazines, and hosting more than a hundred internet web sites.

Confidential, Hackensack, NJ

Member of Technical Staff

Responsibilities:

• Performed the roles of Database Administrator, and Database Developer in multiple projects, advisor to Client DBAs, and company SQL Server Technology Coordinator.
• Developed a Replication Subsystem using Microsoft SQL Server 6.5, SQL Distributed Management Objects, Visual Basic for Applications, and Microsoft Access. This fully configurable system is currently used to manage the setup, and changes of replication on 30 SQL Server databases spread across 9 SQL Servers.
• Developed an Upsizing Tool for upgrading a Microsoft Access database to Microsoft SQL Server using Microsoft SQL Server 6.5, and Microsoft Access 2.0. This table driven system includes initial data validation and massaging, object creation, object permissions, data transfer, and data transfer correctness verification. This system allows for changes to existing tables structures, and is easily configurable.
• Developed a Downsizing Tool for creating a stand-alone Microsoft Access database from an existing Microsoft SQL Server database using Microsoft SQL Server 6.5, Microsoft Access 2.0, and ODBC. This table driven system includes initial data validation and massaging, object creation, object permissions, data transfer, and data transfer correctness verification. This system allows the clients to take the SQL Server data on the road.
• As part of a team, participated in the design, development, maintenance, and upgrades of a Real Estate Management System for the Nations most prestigious Commercial Real Estate Company using Microsoft SQL Server 6.5/4.21, Microsoft Access 8/2, Microsoft Visual Basic 4/3, Oracle and ODBC.
• Developed a Database Installation Tool using Access 2/8, and Visual Basic for Applications to manage the rollout, and administration of a multiple user, multiple Access MDB environment.
• As part of a team, participated in the design, and development of an Order Processing, and Customer Management System using Microsoft SQL Server 4.21, and Paradox 4.0.As part of a team, participated in the design, and development of a Data Integrity Management System using Microsoft Visual Basic, Sybase, and Microsoft Access for a major insurance company.