SUMMARY:

• IT professional with the ability to implement Database and Business Intelligence Solutions from the ground up. Proficient as BI Architect/Developer, Data modeler, Database Developer and DBA. Deep technical knowledge of the Microsoft Data Platform and Business Intelligence. (On Premises and Cloud)

TECHNICAL SKILLS:

Technology and Tools: Big data: Apache Spark, Apache Hadoop (Hive), Scala, Python, R, Data bricks. Data warehousing and OLTP technologies, Data vault, Dimensional modeling / ER modeling, ETL/ELT, OLAP Microsoft SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000/7.0 (Business Intelligence, Architecture, Development, Administration) Microsoft Analysis Services (Multidimensional and Tabular Model), MDX, DAX, Microsoft Integration Services (SSIS), Microsoft Reporting Services, Service Broker, Business Intelligence Markup Language (BIML) SharePoint for Business Intelligence: SharePoint 2013 and SharePoint online. PerformancePoint, Excel Services Windows Azure, Azure SQL Database, Azure SQL Data warehouse, Azure Data Lake, Azure Data Factory, U - SQL, Azure Data Bricks, Cosmos DB Power BI, Power View, PowerPivot, Power Query ESSBASE, Oracle Crystal Reports IBM Clarity Performance Management Strong troubleshooting and optimization skills Erwin, Visio PowerShell, Korn Shell Strong OOP / OOD, Design Patterns, Microsoft Patterns and Practices .Net (C#, VB.Net, ASP.Net, Web Services, XML, XSD, LINQ) Python, Scala, Borland Delphi, C++ Web programming (HTML, ASP, VB Script, Java Script) Visual Source Safe, MKS, Team Foundation Server (TFS), GIT, System Administration Microsoft Access, Microsoft Office (including automation

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Responsibilities:

• Created database design for physical models of an enterprise data warehouse. Analyzed source systems, executed data profiling and defined mappings between source system and data warehouse tables.
• Deployed physical model to SQL Server databases.

Skills: SAP Power Designer, SQL Server, IBM BB2, IBM Data Studio, DQ Analyzer

Confidential

Data Architect

Responsibilities:

• Architected a BI solution for several source systems: claims, underwriting, accruals, etc.
• Envisioned and designed the migration from the old accounting system to the new one, helped document the mappings and built the SQL Server queries to map from the old chart of accounts to the new one, as well as queries to translate data for general ledger, journal entries and subledger.
• Automated the creation of the data warehouse tables and SSIS packages and ETL in general using BIML
• Built an SSIS ETL framework with logging and error handling to be used for loading the enterprise data warehouse and the data marts.
• Designed a Kimball style financial data mart for the reporting solution, which needed to provide drill down capabilities from the general ledger to the source transactions like claims, policies, etc.
• Implemented analysis services tabular cubes and DAX calculations to be used in the reporting solution
• Implemented Power BI reports to validate the requirements were being met
• Assisted in the SQL Server performance tuning of other parts of the source systems.
• Created deployment bundles and production deployments for the Database and SSIS projects of the solutions
• Participated in the design and implementation of MDS / master data management and data quality strategy for the project.

Skills: SQL Server 2016, Oracle, Oracle EBS, Visual Studio 2015, SSIS, Attunity, SSAS Tabular, DAX, VeritiPaq Analyzer, Master Data Services / Master Data Management, BIML, BIML Express, BIML Studio, C#, Visio, WhereScape RED, WhereScape 3D, Data warehousing, Data Vault, Kimball methodology, dimensional modeling, Erwin, GIT.

Confidential

Data Architect

Responsibilities:

• Architected and implemented a data analytics solution for loss analysis where the main challenge was to achieve scalability in the loading of thousands of files simultaneously. Worked with business and IT personnel to establish the business and technical requirements. Wrote architecture document that included Kimball dimensional model, detailed design, physical design. Implemented the data warehouse database, ETL and SSAS Cube. Achieved parallelism in the ETL by writing C# code to use the Task libraries in .NET. Implemented new features in SQL 2014, such as clustered columnar store indexes, in memory tables. Wrote deployment guides and assisted in QA, UAT and production deployments.
• Participated in the design and initial implementation of a company data lake using Microsoft Azure technologies, such as Azure storage, Data Lake Analytics, Azure Data Factory and Cosmos DB.
• Loaded data to the company data lake using Apache Spark, Azure Data Factory, Polybase.
• Deployed a risk database solution to Azure SQL Database and Azure SQL Data warehouse (Data as a Service - DAAS) to explore feasibility of deploying this solution to Windows Azure.
• Architected and Implemented a file validation solution using SQL Service Broker. Prepared deployment scripts and provided support during UAT phase.
• Designed a NoSQL solution for capturing drone data in the cloud. (Azure Table Storage, Azure Cosmos DB)

Skills: SQL Server 2014/2016, Visual Studio 2015, SSIS, SSAS, Service Broker, C#, Visio, Data warehousing, Kimball methodology, dimensional modeling, Erwin, Azure, Azure SQL Database, Azure SQL Data warehouse, GIT, Tableau, R.

Confidential

Business Intelligence Architect

Responsibilities:

• Implemented a BI solution to track workflow. Implementation included: requirements analysis, architecture document, Kimball dimensional model including mappings to the source system tables. Creation of the VS solution with Database Project (DWH), SSIS project (ETL), SSAS project (OLAP Cube). The OLAP cube included 4 measure groups and around 20 conformed dimensions.
• In this project I was able to generalize some of the user requested measures into a simpler fact table that provided more information through a set of new abstractions that were not used in the source system but were helpful to cover analytical needs.
• Wrote deployment instructions and Assisted developers in deploying to multiple environments.

Confidential

Business Intelligence Consultant - Architect / Developer

Responsibilities:

• Designed a hybrid reporting solution using Microsoft Office 365, SharePoint Online, Azure, Power BI, Azure SQL Database (Data as a Service)
• Participated in several proof of concept solutions that involved SQL Server, SharePoint and Microsoft Azure technologies such that, Visual Machines (IaaS), Power BI, Azure SQL Database, Azure Storage.
• Created detailed technical design and implementation plan for a data warehouse for a multitenant CRM implementation in Legal Aid Ontario. This included design and documentation of a dimensional model, SSIS, SSAS and Reports
• Implemented and enriched the SSIS framework to serve as the basis for the SSIS packages that load the data warehouse
• Helped design the master data management (SQL Server MDS) strategy and implemented Data Quality Services (DQS) for deduplication of customers and address data.
• Implemented SSIS packages and SSAS cubes for the above solution. Prepared documentation to assist in deployment of SSIS and SSAS components
• Created detailed design and documentation for a custom SSRS Reports solution to be used in a multitenant CRM implementation
• Assisted in troubleshooting SQL Server performance problems and provided recommendations for tuning and high availability
• Implementation of new functionality to a legacy Access application. This included interacting with the stakeholders to create the Business Requirements Document and Administrator’s manual for the solution. Implemented the code changes in the access database. Coordinated testing and deployment of the solution.
• Migrated/Modernized part of the functionality of this application to Azure SQL Database.
• Implemented a reporting solution using Power BI
• Implemented new SSRS reports using SharePoint as a data source. Deployed the reports in UAT

Skills: SQL Server 2014/2012, SSRS, SSIS, SSAS, Visio, Data warehousing, Kimball methodology, dimensional modeling, Microsoft Access, Microsoft CRM, Visio, ERWIN, Power BI, Power Pivot, SharePoint Online, Office 365.

Confidential

Business Intelligence Consultant

Responsibilities:

• Implemented new data loads for existing data mart
• Implemented SSRS Reports and planned their deployment
• Troubleshot production issues related to data loads
• Migrated loan database to new version of data mart
• Optimized stored procedures and SSIS packages used to load data marts

Skills: SQL Server 2012, SSIS, SSRS

Confidential

Business Intelligence Consultant

Responsibilities:

• Architected and implemented a BI solution for stock trading transactions, including design of the Kimball Dimensional Model, Documentation, implementation of the SQL Server databases, SSIS Packages, Analysis Services Cubes, Excel Services Reports and Performance Point dashboards. Assisted in the deployment of the entire solution including the SharePoint components. Implementation of the job scheduling using AutoSys.
• Architected and implemented an Analysis Services cube for GL reporting, integration of several financial processes by conforming the dimensions and adding new fact tables. Implemented part of the ETL, dimensions, new measure groups and MDX calculations for financial analysis.
• Helped define, document a master data management and data quality strategy for companywide data like Clients, Legal Entities, etc. Explored SQL Server’s Master Data Quality Services and built prototype.
• Implemented processes that interfaced with data provided through FTP sites and loaded them into an Operational Data Store. Investigation and formalization of the requirements, overall design of the data integration strategy, creation of SQL Server tables and stored procedures. AutoSys jobs and PowerShell scripts to orchestrate the process. Creation of SSIS Packages and Reporting Services Reports
• Designed and implemented an audit trail solution to persist the change history in SQL server tables
• Investigated data loads within an Oracle database for certain data not appearing in the reports
• Designed and implemented new functionality in Essbase cubes.
• Rewrote and troubleshot parts of various Access applications
• Implemented changes in a feed file reformatting engine to allow for dates validation
• Migrated several database projects in VS2010 to VS2013 (SSDT)
• Troubleshot, identified and fixed performance issues in SQL server databases, Analysis Services cubes and SSIS packages
• Participated in UAT and Production deployments
• Created and modified several SSRS
• Created PowerShell scripts to automate the deployment of SSRS reports and permissions to SharePoint sites

Skills: SQL Server 2008R2, SSIS, SSRS, SSAS, MDX, TFS, SharePoint 2013 (Excel Services, PerformancePoint Services), AutoSys, C#, PowerShell, XLCubed, Oracle, Essbase, Microsoft Access, Dimensional modelling, Erwin Data Modeler, Agile methodology, troubleshooting, performance tuning.

Confidential

Business Intelligence Architect

Responsibilities:

• Planned and executed deployment of Windows Azure, Office 365 and Power BI. Set up Virtual Machines for SharePoint and SQL Server 2012 on Windows Azure.
• Implemented several prototype cubes using Tabular data model.
• Implemented Self-Service BI using Power Pivot and Power View.

Skills: SQL Server 2012 (Power View, Power Pivot, Tabular Model), SharePoint and Office, Microsoft Solution Framework for Delivering BI solutions, Windows Azure.

Confidential

Business Intelligence Consultant

Responsibilities:

• Planned, lead and executed the migration of Confidential to IBM Clarity 7. On the technical side included the creation of new web and database servers, installing Clarity 7, moving databases, SSIS packages, SSAS Cubes, SQL Server Agent Jobs, converting around 30 reports to the new format. Provided support during the first days of Go Live, engaged with IBM in troubleshooting issues in the new version and provided documentation.
• Migrated Analysis Services cubes to be sourced from a different ERP system. This implied creating data dictionaries, mappings between new and old database, SSIS packages and MSAS cubes and Clarity Reports.
• Created data dictionary for the new operational database and mappings between the tables in the old and new operational system.
• Implemented and documented a Payroll Budgeting Application using Clarity.
• Implemented and documented the Yearly Budgeting Process using Clarity.
• Provided documentation.
• Provided assistance and recommendations for user acceptance testing.
• Troubleshot performance problems in the ETL loads and MDX Calculations and Optimized SQL Server jobs, Analysis Services Cubes and Clarity Server.
• Performed typical SQL Server Administration tasks like, tuning of indexes, backup strategies, placement of files, resource allocations.
• Troubleshot and fixed problems in the Sybase database server.

Skills: IBM Confidential, IBM Clarity Studio, Microsoft Excel, VBA, Pivot Tables, PowerPivot, VBScript, Java Script, Corporate Performance Management, Documentation, Visio, Dimensional Modeling, T-SQL, Database Administration, SQL Server 2012/2008/2005, Integration Services (SSIS), Analysis Services (SSAS), MDX, Clarity Studio, VBScript, Sybase, Red Gate tools SQL Compare, SQL Database Compare.

Confidential

Data Architect

Responsibilities:

• Database modeling, implementation and deployment of several data marts for Bonds, Credits and Rates, Market data, trading risks.
• Migrated Excel Spreadsheets to SQL Server data marts for risk valuation.
• Implemented changes to existing data marts and Reports, Unit test the ETL/Database/Reports.
• Participated in the implementation of the new database security standards. Creation of the required documentation. Development of scripts for the deployment of the security policies.
• Implemented the security mechanisms and best practices in several Access databases.
• Provided production support of existing Risk valuation applications.
• Created documentation for several applications and business processes, including existing databases and mappings used in the transformations. Implemented a mechanism to create a data dictionary from the extended properties of sql server tables the Risk data marts.
• Implemented SSIS packages that contained logging and configurations. Implemented MDX Calculations and KPIs, created Reporting Services reports. Implemented Change Data Tracking.
• Troubleshot and optimized many SQL Server environments, applications, databases, queries and cubes.

Skills: SQL Server 2008/2005, SSIS 2008, SSRS 2008, SSAS 2008, Team Foundation Server, Microsoft Excel, VBA, Pivot Tables, VBScript, Performance tuning, Microsoft Access, Oracle, MKS. Red Gate tools SQL Compare, SQL Database Compare, and Visio.

Confidential

Business Intelligence Architect

Responsibilities:

• Architected, designed and implemented an Enterprise Business Intelligence solution, including project management, documentation, data warehouse, ETL, OLAP cubes development, MDX calculations and .Net development of a deployment utility that modified the packages and cubes configurations at deployment time. Created several Microsoft Reporting Services Reports. SQL Server 2008/2005.
• The ETL implementation was done using the traditional pattern of having an ExecutionLog table with custom logging through PreExecute, PostExecute and OnError Events on the packages.
• Implementation of several C# classes for validating XML files against XSD schemas using C# and LINQ to XML. Implementation of the necessary SQL Server stored procedures and C# classes to validate and import data to the SQL Server databases. Implemented regression testing functionality to validate the results.

Skills: Visual Studio 2008, C#, XML, XSD, LINQ, SQL Server 2008, Team Foundation Server, XML Spy.

Confidential

Business Intelligence Consultant

Responsibilities:

• Independent Health Insurance. Architected, designed and implemented a Data Mart and a budgeting OLAP cube. Responsibilities included designing and implementing the staging and data mart tables. Data Load Process and Analysis Services cube----- Skills: SQL Server 2005, Integration Services, Analysis Services, Dimensional modeling. VB.Net.
• Canada Pension Plan Investment Board. Identified the data sources in Microsoft Great Plains, created data dictionaries for the source system tables and data mappings source to data marts. Implemented Currency Conversion using Integration services an Analysis Services ----- Skills: SQL Server 2005, Integration Services, Analysis Services, Dimensional modeling, SQL Server Profiler.
• Bell Canada. Implemented a budget units transfer algorithm and alternated reporting hierarchies in an OLAP cube. Troubleshot performance problems related to the write back mechanisms in OLAP cube. ----- Skills: SQL Server 2005, MSAS, Perl, MDX, Troubleshooting.
• Other clients for which troubleshooting different problems was the main activity are:
• Confidential Corporation, Impark Corporation, Eastern Mountain Sports, South West Airlines, Affirmative Insurance

Skills: C#, Visual Studio Tools for Office (VSTO). SQL Server 2005, Analysis Services, Essbase.

Confidential

Software Engineer

Responsibilities:

• Worked as part of a team in the development of .Net applications. Responsibilities included creation of SQL Server tables, views and stored procedures. Data access layer and business objects classes, as well as user interface using Windows Forms and help.
• For every project it was necessary to participate in the testing process by creating use cases and automating them in .net
• Investigated feasible solutions to several implementation problems in Visual Studio, SQL Server, and Crystal Reports. Engaged with Microsoft support when necessary.
• Helped some customers to migrate data from their previous inventory applications to MI9 Retail

Skills: Net Development, SQL Server 2005/2000, Crystal Reports, Reporting Services 2005, Visio 2005, Visual Source Safe, Win CVS, Infragistics Controls, Troubleshooting, Object Oriented Programming, Design Patterns.

Confidential

Senior Software Developer

Responsibilities:

• Designed and developed a Data mart for the finance department, analyzed source systems to identify the data to be used, designed and created the databases using the Kimball methodology, implemented the data extraction and OLAP cubes, as well as MDX calculations. ----- Skills: Data warehouse, SQL Server 2005, Integration Services, Microsoft Analysis Services, MDX.
• Designed and developed a Data Warehouse for the enterprise. Interviewed with users, gathered the requirements and defined the data to be extracted from the source systems, designed and created the database, implemented the data extraction and the reporting parts. Recommended strategies to guarantee the accuracy of the data warehouse data. ----- Skills: Data warehouse, SQL Server 2000 and 2005. ASP, Microsoft Access, DTS, Microsoft Reporting Services.
• SQL Server Administration. Skills: SQL Server 2005, backups, configuration, replication, performance tuning.
• Accounts Payable Application. Interviewed with users and lead them to accurately define their objectives. Gathered requirements, designed and developed the windows forms application. Implemented a very general reporting engine. ----- Skills: UML, SQL Server 2005, C#, ADO.Net, Dev Express Controls, Microsoft Application Blocks, Design Patterns.
• Design and development of a smart client inventory application using a multilayered architecture. Introduced a mechanism for replenishment.
• Delivered lectures to coworkers on Enterprise application development. Motivated the audience to become acquainted with design patterns
• Contract Processing. A database application to create and keep track of the contracts and merchandise orders for the enterprise. Migrated the application from Access to SQL Server and .Net.
• Developed a Web application as a subset of the Contract processing to view and update the most important data from remote locations. -----

Skills: ASP.Net, C#, ADO.Net, Reporting Services, Developer Express Controls, Design Patterns, SQL Server 2000.

Confidential

IT Specialist

Responsibilities:

• Design and implementation of several database applications using Microsoft Access
• Set up of the Accounting infrastructure. Including installation of Accounting and Payroll applications.
• Administration of the Local Area Network.

Skills: Access, VB, Network administration, Win NT, IIS.