Anand

Profile SUMMARY:

ö  Over 16 years of experience in Automation, Reporting, Dashboard, Statistical analysis, Business Intelligence & Analytics.

ö  Proposing technical solutions and implementing BI and self-serving BI & Analytic techniques.

ö  Worked closely with leaders, Global clients & key decision makers. Cross-functional collaboration to understand consumer insights.

ö  Estimation & project plan and Cost benefit analysis for tool & technique implementation

ö  Expertise in Power Platform, Power BI, Tableau, Text Mining, Sentiment Analysis, Excel/MS Access into VBA, R, and Python code, Azure.

EXPERIENCE SUMMARY

ö  Expertise in Data Visualization using Power BI, Tableau, Crystal Report, SSRS, Paginated Reports, Excel VBA

ö  Proficient in Implementing Text Mining, Sentiment Analysis, Chat Bot implementation.

ö  Forecasting using Excel, R, Power BI

ö  Expertise in implementing Power Platform using Power BI as visualization layer and Power Automate for

Data cleaning and robotics.

ö  Expertise in DAX and M language in Power BI and Data Flows.

ö  Expertise in integrating O365 with Power Platform.

ö  Proficient with Azure Analysis services and Azure data Gen 2 for Cube creation.

ö  Expertise in MIS automation using VBA Excel and report delivery.

ö  Acted as solution architect and team manager.

SOFTWARE SKILLS:

Power Platform
Power BI Desktop, PowerBI.com (services), DAX, M-language, Power App, Power Automate
Tableau
Tableau, Tableau Prep
Excel BI Skill
VBA (MS Excel), Power BI, Power View, Power Pivot, Power Query, Power Map)
Languages
VBA M-Lang (Power Query), DAX (Power Pivot), T-SQL, R (Programming) , Python
Database/Azure
SQL Server, SSAS Tabular, Azure Analysis Services, Statistical data modeling. Azure Data bricks, Azure SQL, Amazon Web Service  (Redshift ,Athena)
ETL
SSIS, Power Query, Tableau Prep, Python Script, Data Flow
Visualization
Crystal Report (Business Objects), SSRS, Power BI, QlikView, Tableau, Spotfire, Python
Ø  DOMAIN: Insurance, BPO/KPO, OIL& GAS, Telecom, Contact Centre

Academic Qualification    : Msc

Professional Experience Details:

Employer:    IPacesetters LLC (From Apr 2019 to till Date)

Team Size: – 8

Designation          :   Power BI Architect

Domain                  : Contact Centre, Sales, On Line Digital Marketing,
HealthCare

Technology à   Power BI, Power Platform, Power Automate, Dashboards, Python, R, SQL Server

Participation:

ö  Automation & Dashboard using Power BI, R & Python.

ö  Administration of Workspaces and licences.

ö  Sales Analytics in Power Platform (Power BI, Power Automate, Apps)

ö  Decision Analytics feasibility using Azure SSAS, Data bricks and Synapse in Azure.

ö  Sentiment Analysis for Chat bot

ö  Customer Churn Analytics using Power BI , Python & Azure Data bricks

ö  Successfully migrated several projects from Qlik / Tableau to Power BI
guiding the team and writing complex DAX and data modelling.

ö  Technical Lead for the team of 10 members at Client side as Solution Architect for Self Service BI.

ö  Case study for implementation of RPA technologies.

Employer: Sun Life Financial (From Apr 2018 to April 2019)

Team Size: – 8

Designation           : Manager Reporting & Analytics

Domain                 : Insurance, Analytics, Data visualization

Technology à   Power BI, Dashboards, Tableau, Tableau Prep, MS Access, SQL Server

Participation:

ö  Technical Lead for the team of 10 members at Client side as Solution Architect for Self Service BI.

ö  Business Forecasting and Planning & Strategy execution of Reports.

ö  Back office Automation, Reporting & Visualization using Power BI & Tableau 10.5 i.e. Self-Service BI.

ö  HR Analytics for organizational structure. Automation & Dashboard using Tableau R & Python.

ö  Comparison of different Analytical Tools for Visualization and execution with R & Python.

ö  Case study for implementation of RPA technologies.

Employer:            Cognizant (From Aug 2016 to Apr 2018) (Client XL Catlin)

Designation        : Manager

Team Size          : 10-12

Domain               : Insurance, Analytics, Actuaries

Technology à   Power BI, Dashboards, Tableau, SSAS Tabular, AZURE Analysis services, VBA (Excel Macros), MS Access, SQL Server

Participation:
ö  Technical Lead for the team of 12 members at Client side as Solution Architect.

ö  Business Forecasting and Planning & Strategy execution.

ö  Implemented Text Analytics using R (NLP & Open NLP) with Power BI to for sentiment analysis.

It solved the problem of high-rise claims for certain geographical areas. It involved Time Series

Analysis as well.

ö  Implemented Power + R + SSAS tabular + Azure Analysis services with Office 2016 for reporting
and data insight.

ö  Work allocation among team members for SQL, VBA, BI, Application data reconciliation support.

ö  Client interaction for on time delivery of modules.

————————————————————————————————————————————————–

ö  Interaction with Microsoft on behalf of Client for implementation and comparison of latest Analytics tools such as POWERBI + SSAS Tabular + R+ Python

ö  Analyse and implement Data Visualization techniques for Actuarial Team members.

ö  Solution Architect for complex Excel VBA + SQL applications and guide the team to adapt Excel BI features like Power Pivot, Power Query.

Employer:       SAMSUNG HEAVY INDUSTRIES (From Aug 2011 to Aug 2016)

Designation:     Sr Executive (M2G3)
Domain        :      Oil & Gas, Engineering (Project Management & Planning)
Team Size: 10

Technology à   VBA, MS Access, SQL Server 2008, Power Pivot, Power BI, Dashboards, Crystal Reports, Tableau

Participation:

ö  Implemented Tableau, Power BI (Desktop), Excel Power BI for quick dash boarding and in sighting for PEM and Planning related to Project and activities data.

ö  Forecasting availability of Man-hour based on different scenarios.

ö  Developing Applications for Finance, HR for recruitment process as well as for different Engineering Departments for their calculation and Reporting process.

ö  Developed application for the entire HR Recruitment module. From resume collection to interview log, to joining of candidate.

ö  Manage entire organizations HR reports for monthly manpower analysis, attrition and Variance.

ö  Actively involved in salary survey dashboard for to industry i.e. find the mean across different dimensions and eliminating the outliners.

ö  Handling a small team meant for the same purpose.

ö  Financial Calculations & Dashboards like OT expanse, Project Costing, Travel Deputation.

Built Reports and Input Templates in support of Finance, Accounting Operations

(SQL, DAX, VBA and Plain old Excel formulasfunctions)

ö  Worked with finance team to monitor Asset Management system.

ö  Linear programming implementation for analytics and manpower utilization.

ö  Manage & Analyze the Organization’s Transport Management System (TMS) using

Sql Server & Excel & Power BI Dashboard.

Employer: HCL Technologies Ltd (From Sep 2006 to Aug 2011)

Designation:  MIS Executive
Domain: Application for BPO/KPO operation.

Team Size: 10

Client:  Accenture (US) – Process – PHOENIX

TechnologyàVB6, SQL Server 2K, Access, Data Report, VBA (Excel Macros), Sybase (Symposium Database)

Participation:

ö  Major part of entire project done by me included Requirement gathering, Code, Report

Generation and training the operation team about the product.

This application was transferring data from Symposium   Database (Sybase) to SQL Server

And   providing Reports which was generating interval wise data operation Majors like

Service Level, AHT, Calls, Offered Handled etc. Moreover, it was stating associate wise

Performance details. Almost entire Voice Operation was dependent on the application. It

Generated several automated MIS reports which helped in the analytical process.

ö  Coordinated with SL desk team & WFM team for the smooth functioning of Voice Operation so that the Real Time reports could be generated and analyzed.

ö  Developed VBA application for Overtime Calculation of employees working in the Phoenix Calling Process.

Client:  Thames Water UK – Process – TW

Technologyà  VBA (Excel Macros), SSRS2005, Dialer (ASPECT), SQL Server 2000/2005.

Participation:

ö  Create VBA programs to automatically update Excel workbooks from external databases like SQL Server, Sybase   (Symposium Database), Ms Access.

ö  Generate Reports in SSRS 2005 (MS BI Tool) to integrate with MSCRM4. Instant reports generated enabled operation in smooth decision making for collection process.

ö  Implemented automated Data Scrubbing system

ö  Ensure MIS reports are completed on time and within budget.