PROFESSIONAL SUMMARY:

• 5+ years working with MSBIand Power BI/Tableau/QlikView/SpotFireetc in Toronto.
• Transformational business intelligence developer and architect with a proven track record of delivering innovative, high performance, and scalable solutions to complex business problems.
• Expertise includes leveraging broad and in - depth knowledge of state-of-the-art design technologies, data warehouse architectures, and BI strategies and methodologies to deliver a single version of the truth.
• BI Development with Financial an Marketing/Sales data, performing data modelling, data forecasting, data regression, different machine learning techniques including clustering analysis, text mining, natural language processing and dashboard/report design using a variety of tools such as Tableau, Power BI, SSRS, SSAS, and SSIS
• 5+ years of experience with relation databases such as MS SQL, and MS Access performing design tables, SQL queries and designing SQL reporting services as a SQL Reports Developer.
• Complex business process improvementsthru data analytics such as data forecasting and finding data correlations
• And Knowledge of MS Power BI tool (Power Pivot, Power Query, Power Map), Working knowledge Web Services in SSIS data flow component using URL, Working knowledge of bits ticket ticketing system support for internal incident/ change management system.
• Microsoft certified professional in Power BI and PMI certified
• Refined relationship-building skills and experience, working collaboratively with vendors, cross-functional teams, customers, and customer-facing staff.

TECHINICAL SKILLS:

BI Tools: Microsoft Power BI, SSRS, Tableau 10.4

Databases: MySQL, MS SQL Server 2008/2012, PostgreSQL, Azure Table Storage, Azure data lake Data warehouse, ETL, SSAS, SSIS

OS: Windows/Linux/Unix

Application/Tools: SharePoint 2016/2013/Online/Office365, Microsoft Access, R Studio, VS Studio, SQL Studio

Language: C#, C++, JavaScript, VB script, VBA(macro), SQL script, Python, mdx, R, Machine Learning R with R

MS Power BI: Business Analytics and Visualization Service(s)

Project Management: Microsoft Project with PMI-CAPM

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Provided consulting and services on designing dashboards and configurations using Tableau/Power BI for Business school candidates in one-on-one basis
• Provided Power BI templates upon request
• Advised on financial modeling including IC, IS, and CF sheets in Power BI
• Teaching GMAT Math and Verbal course for Business school candidates

Confidential

BI Developer/Office 365 Developer

Responsibilities:

• Provided business insights thru data analytics such as data forecasting and finding data correlations using Power BI, Tableau, and R
• Created Power BI dashboards (5+)/Tableau dashboards (2+), financial and marketing/sales reports(10+) and templatesregularly and shared with the organization with internally and externally.
• Multi million recordsof data sets based on Canada Labour market survey data
• Reports were prepared with blending input sources, filters, parameters, and navigation with actions, displaying market cluster analysis, sales forecast, and correlation plot using market lead information from scratch using R integration. Data modeling was done by Power Query(M) and DAX in Power BI and Excel. Data sources regularly refreshed by Power BI Services scheduling
• Data set aggregation from Microsoft Azure Table storage services, and data fresh. Created reports for dashboard. Created bookmarks for story-based dashboards and ad-hoc changes.
• Spearheaded a project to implement company standards and establish procedures to ensure a unified data management approach.
• And Worked closely with marketing team and deployed Power BI reports and publishing them on the Power BI Services
• Designed UI from site template and developing Office365/SharePoint add-in packages using CSOM and REST services, running on SharePoint online and azure IIS web server, including visual part and business logic to enhance security feature for document library as a custom action

Environment: Tableau 10.4, Power BI, R studio, Office 365, SharePoint 2016, NAPA, jQuery, CSOM, JavaScript, Visual Studio .NET 2015/2017, client-side programming, AES encryption/description, Azure web services, Azure storage services

Confidential

Tableau report designer

Responsibilities:

• Led academic financial and marketing projects and designed reports in Tableau
• Participated in Tableau workshop using retail data brought by Tableau company

Confidential

Sr. Programmer Analyst

Responsibilities:

• Responsible for financial reporting at Whole Sale (GWS) banking operations and Confidential & bank customers.
• Identified the existing and gathering data requirements into BRD
• Performed data modeling, data normalization of SQL data, created stored procedures, data fix, SQL query from SQL management studio
• Added/Modified excel macro(VBA) into excel files for data validations
• Prepared data set by data import and export for Excel and Microsoft Access
• Created financial reports with P&L with connection to market data; Results: GWS settlements team was sending MTM reports to thousands of third party companies on this tool
• Evaluated Power BI desktop/server Scotia Capital; Results: Customer was seeking Power Pivot in SharePoint. However, customer found a Power Pivot migration solution to Microsoft Power BI online version Tools: POWER BI, Data modeling, Microsoft Power BI online version, DAX programming, Custom visual by modifications
• Created SCD Type 1 SSIS projectfor SharePoint user profile performing database change from HR feeds; Results: Easy to see user profiles
• Social networking web(Jive) on red hat on VMWare
• Practiced risk measurement in Python
• Regularly SQL server management
• Tools: C#, SQL Store procedure, SSIS, Data View • Scheduling Jobs and Alerting using SQL Server Agent.
• SharePoint project development, migrations, web site customizations with CSS, HTML, DHTML, web part code deployment via change management system into SharePoint in-house(on-Premise) server, SharePoint 2003, 2007, 2013, on-line, office 365, and Confidential virtual servers
• Created KPI using data modeling and SSAS and SharePoint

Environment: Windows 2003/2012, SQL Server 2005/2008/2012 , Visual Source Safe, Visual Studio, SQL Management Studio, SharePoint Designer, SharePoint 2003/2007/2013/ Online, SQL reporting services, SSIS, SSAS, POWER BI

Confidential

Microsoft SharePoint Consultant

Responsibilities:

• Built SSAS for KPI and SharePoint integration servers, SSAS, SQL Server, and AD Servers and provided its consultations on Virtual servers
• Performed SharePoint farms and its data migrations
• Created Microsoft Lync solutions integrated with SharePoint environment
• Review changes, manage documentation and customer presentations.
• Adhere to best practices and standards in application development.
• Manage checkpoint meetings, demos, and daily communications with the client
• Tools: SharePoint, ASP.NET, IIS7, C#, SQL Data, SSRS, SQL; stored procedures, database normalization

Environment: Windows 2003, SQL Server 2005, Visual Source Safe, Visual Studio, SQL Management Studio, SharePoint Designer, SharePoint 2007, asp.net c# 2.0