Power Bi Data Analytics

Senthil. M.C

BI Tech Lead HTC Global Services

************@*****.*** +91-917*******, 984******* senthil-chandrasekar-a9547984 Passionate BI & Data Analytics expert with 12+ years of experience in Designing and Developing efficient Business Intelligence solutions, Successful BI practitioner with a track record of delivering complex BI solutions across multiple industry domains. Transform raw data into insightful visualizations and actionable Dashboards with enhanced performance which has enabled business users in making informed decisions for their Business. Have great exposure in the field of Data Analytics. Specialized in implementing analytics solutions using multiple technologies. Led and contributed to projects across a variety of industries such as Banking, Insurance, Healthcare, Tax & Auditing for clients such as World Bank Group, Hartford Insurance, Monsonto, PlanteMoran, ICON Clinical.

BI Tools Expertise:

SKILL STACK

Power BI

Tableau

Crystal Reports

MSBI (SSRS, SSAS,

SSIS)

Experienced in implementing end to end data warehousing projects which includes Data Extraction, loading, Modeling, Visualizing and Deployment and Migration.

Responsible for requirement gathering, validation, functional and technical documentation and fulfilling the requirement gaps. Experience working in full life cycle development which includes analysis, design, development and testing.

Developed complex PowerBI & Tableau Dashboards from various data sources such as Azure SQL, Flat file, CSV, service now and different databases.

Experience in creating and maintaining Reports and Dashboards by using different Charts, Card visuals, Maps, Gauge Charts, Pie charts, Slicers and Hands on experience in creating Calculated Columns and Measures by using DAX. Good experience on Filters, Slicers, Book marks, Selection Pane, Edit Interaction, Performance Analyzer.

Publishing reports to PBI Service, Tableau Server and Sharing dashboards to Users and Good Knowledge on Schedule refresh by using Gateways in PBI service

Proficiency

Visuazlizations

DAX Queries

Power BI Service

Tableau Server

PowerAutomate

PowerBI Gateway

BO Universe

Azure DevOps

Data Operational

Skills

Extraction

Transform

Loading

Modeling

Visualizing

Deployment

Migration

Power BI

SAP BO

• Reports

• Dashboards

• Tableau

Server/Tableu

Online

Tableau

• SAP BO XI R3.x, 4.x

• UDT & IDT

• Crystal Reports XI

R2

• BI Launch Pad

• Desktop & PBI

Services

• Power Automate

• PowerQuery

• PowerBI Mobile

CAREER LATTICE

Feb 2021

to till date

Sep 2015

to Jul 2020

May 2011 to

Sep 2015

JOB EXPERIENCE

1. HTC Global Services (India) Private Ltd Technical Lead Chennai Feb 2021 – Present day

Project #1: ICSID – World Bank Group

Power BI, Power BI Service, Microsoft Azure

The World Bank Group (WBG) is a family of five international organizations that make leveraged loans to developing countries. This project deals with collecting the data from different sources like excel, ICSID website, case management and transforming and performed data cleansing the data and loading into PowerBI and creating data insights by better visualization for the business users and delivering reports/dashboards as per the business needs.

Roles & Responsibilities:

Gathering the requirement from the Business Analysts.

Loading the Data source, Extracting, Transforming and cleaning the dataset and loading into Azure SQL.

Connecting data from PBI and creating models, Creating DAX queries, calculated columns, measures as per the business needs and creating meaningful visuals.

Created Technical specification and functional documentation.

Lead a team of 4 developers

2. ICON CLINICAL RESEARCH INDIA PVT LTD., Sr. Application Support Analyst Chennai Sep 2015 – Jul 2020

Project #2: ICOTrial & Planview Enterprise Cloud

Power BI, Power BI Service, Tableau, Tableau Server, Business Objects ICOTrail is a web based in-house application in ICON which offers clinical development services to the biopharmaceutical and medical device companies, including investigator sites, study monitoring and data collection, case report form

(CRF) preparation, statistical analysis, patient safety monitoring, risk-based monitoring, clinical data management, interactive response technologies and corresponding reports.

HTC Global Services ICON Clinical Research

Technical Lead

Cognizant Technology

Specialties

Mentoring

Recruitment

Quick Learner

Other Skills

Planview

Confluence

ServiceNow

Database Proficiency

Tables & Views

Stored Procedures

Joins

Domain Knowledge

Insurance

Clinical Research

Banking

Add-ins

Documentation skills

Presentation ability

Client Communication

Good Email Etiquette

Roles & Responsibilities:

Developed more than 30 dashboards for the Leadership team from various data sources which gives insights to help them to take decision on the management of the organisation.

Understanding the client’s requirements and analysing the data from various data sources such as SQL, Excel, CSV and Service Now

Working in an agile methodology

Prototyping and creating stories through visuals.

Worked on the BO report development, Universe maintenance and publish the report to BO repository and performed BO admin activities like creating user, groups and schedule the reports to the end user as different frequencies.

Mentor a team of 3 designers.

3. Cognizant Technology Solutions Associate - Projects Chennai May 2011 – Sep 2015

Project #3: Customer Reporting – The Hartford Insurance Business Objects Web Intelligence, Universe Designer, Infoview, CMC The Hartford, is a United States-based investment and insurance company. The Hartford is a Fortune 500 company headquartered in its namesake city of Hartford, Connecticut. This Project involves development of Business Objects Reports to the Business User, Individually handle the project by end to end. Roles & Responsibilities:

Gathering the requirement from the Business Analysts.

Build the new report based on the BRD(Business Requirement Document)given by the end user. Modifying the existing report based on the requirement.

Regular interaction with client for reviewing the reports and getting inputs for different reports.

Worked on the BO XI R3.1 and BO R4.0 Reports and Universe.

Migrate the report from BO R3.1 to 4.0.

Developed simple and complex reports and involved in the BO administrations activities such as Publishing and scheduling

Enhancement of BO Webi Reports and Universes

Responsible for all BO tickets Resolution and Change Requests.

Presented the BO walkthrough to the Client Business team and coordinated with client business team.

Analyzing the data defects of the Production and finding the root cause and fixing it in designed time frames.

ACHIEVEMENTS

Microsoft Certified Power BI Data Analyst Associate (Certificate Number : I205-7075)

Certified ITIL Foundation level V3.

Certified Data Science with Python in SimpliLearn.

Received Inspired Award for successfully completed the Planview migration project.

Received client appreciations for VRA and Finding Modules Dashboards and Application Support Team dashboard.

EDUCATION

Course Institution

Percentage

/CGPA

Year

M.E

SSM College of Engineering,

Komarapalayam, Namakkal Dist

7.4 2015

B.E

KSR College of Engineering, Tiruchengodu,

Namakkal District

72.3% 2005

D.C.T

Kongu Polytechnic College, Perundurai,

Erode District

84% 2002

HSC

Diamond Jubilee Higher Secondary School,

Gobichettipalayam, Erode Dist

61% 2000

SSLC

Diamond Jubilee Higher Secondary School,

Gobichettipalayam, Erode Dist

72% 1998

PERSONAL INFORMATION

Name : M.C Senthil

Parent’s Name : M.S Chandrasekar – C. Subbulakshmi Gender : Male

Date of Birth : 13-Jul-1983

Languages known : English & Tamil

Email : ************@*****.***

Phone : 917-***-****

Contact this candidate