SUMMARY

• 11+ years’ experience Working as a Microsoft Power BI, BI Development, data modelling, Tableau etc.
• 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, 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 MS SQL performing normalization of SQL data, SQL queries and designing SQL reporting services as a SQL Reports Developer.
• Complex business process improvement experiences
• 2+ years’ experience in BI Development using Tableau and Power BI
• Project management in Agile and Waterfall
• 1+ experience Designed InfoPath Forms and SQL Reporting Services forms
• Provided business process improvements and financial reporting services for banking operations and various & bank customers using Asp.net c#, SharePoint, Power BI, and SSIS
• And Knowledge of MS Power BI tool (Power View, Power Pivot, Power Query, Power Map), Working knowledge Web Services in SSIS data flow component using URL, Working knowledge of BMC Remedy ticketing system support for internal incident/ change management system.
• Implemented the 2nd phase of a document security enhancement on office 365. Shared project status and market lead information on tableau and power bi dashboards

TECHNICAL 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, Richmond Hill CA

Lead of Power BI and CMS

Responsibilities:

• Led and generated good project ideas for customers and employees and monitored on call customer supports & gathering requirements while in progress
• Created Power BI/Tableau dashboards regularly with filters, parameters, and navigation buttons with actions, implementing market segment by cluster analysis using market lead information from scratch;
• Data aggregation from Excel sheets, Azure Table storage services, and a web connector. Created worksheets for dashboard. Created story-based dashboards and ad-hoc changes.
• Published Tableau online to share dashboards to other persons
• Created Power BI Dashboards with interactive views, trends and drill downs along with user level security.
• Created new SSIS packages and made improvement to the existing packages.
• Designed and developed different type of reports including: Drill through reports, Sub reports, drill down reports based on business requirements
• Developed and deployed Dashboard and visualizations using MS Power BI.
• Spearheaded a project to implement company standards and establish procedures to ensure a unified data management approach.
• Upgraded the development and test systems from SQL server 2012 to SQL server 2008 and have made performance improvements to some of the existing systems and deployed databases to Azure cloud.
• And Worked closely with Analytics department reporting team and deployed Tableau reports and publishing them on the Tableau server.
• Designed UI from site template and developing 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
• Technology used: SQL Server 2012 & 2008, SSIS, SSRS, XML, C#, MS Power BI.

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

Confidential

Sr. Power BI Analyst/SharePoint Developer

Responsibilities:

• Responsible for financial reporting at Whole Sale (GWS) banking operations and various & 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 SSIS project for SharePoint user profile performing database change from HR feeds; Results: Easy to see user profiles
• 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 various 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 POC of SharePoint 2007(MOSS 2007) servers, SQL Server, and AD Servers and provided its consultations
• 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

Confidential

InfoPath Forms and SQL Reporting Services Developer

Responsibilities:

• Provided Information form design and SQL reporting services for marketing department
• Built office sales report in SSRS/asp.net/sql dataviews
• Designed and developed several data warehouse initiatives using SQL Server in the Office Marketing team. Worked on the redesign effort of the ETL systems involving InfoPath and various incentive reports using SSRS.
• Utilized SQL and SSRS, created process monitoring system providing alerts and charts to track, analyze and optimize critical SQL Server job agents across multiple production servers.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports.
• Published SSRS reports in Asp.NET IIS server
• Used SQL Hints and Indexes as needed to improve SQL performance.
• Review changes, manage documentation and stakeholder presentations.
• Adhere to best practices and standards in application development.
• Manage checkpoint meetings, demos, and daily communications with the client
• This gained 200% improvement with many existing applications resulting in a great customer satisfaction
• 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 2003, SQL reporting services, asp.net c# 2.0