Senthil. M.C
BI Tech Lead HTC Global Services
************@*****.*** +91-984*******, 917-***-**** senthil-chandrasekar-a9547984
** ***** ** ********* ********** in IT Industry as Business Intelligence Lead/Architect using Power BI, Tableau, Business Objects, Crystal Reports, SSRS with end-to- end experience in Data Warehousing, Business Intelligence Data Visualization for Banking, Insurance, Clinical Research business. Worked with client such as World Bank, Hartford Insurance, Plante Moran.
Experienced in providing estimations for BI reporting projects, design and development and creating design documents for reporting and authoring complex business reports as per business needs and managed complete project Worked on many implementation and support projects and worked with end to end reporting life cycle from requirements gathering to go live. BI Tools Expertise:
SKILL STACK
Power BI
Tableau
SAP Business Objects
& Crystal Reports
MS SQL Server
Have in depth understanding for SDLC methodologies in BI domain and experienced in projects using Waterfall & Agile methods.
Experienced in implementing end to end data warehousing projects which includes Data Extraction, loading, Modeling, Visualizing and Deployment and Migration.
Experience in requirement analysis, designing, developing, implementing and executing projects.
Developed complex PowerBI & Tableau Dashboards from various data sources such as Azure SQL, Web, CSV, service now and different databases.
Good knowledge in Power BI Desktop, Power BI service, Power BI Mobile.
Experience in creating and maintaining Reports and Dashboards by using different Charts, Maps, Slicers, Bookmarks, Performance Analyzer.
Preparing Dashboards using calculations, parameters in Tableau.
Excellent Analytical and problem-solving ability coupled with good communication skills to interact with End users
Demonstrated Leadership, Teamwork & Ownership while executing projects. 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
• Tablueu
Server/Tableu
Online
Tableau
• SAP BO XI R3.x, 4.x
• UDT & IDT
• Crystal Reports XI
R2
• BI Launch Pad
• Desktop & PBI
Services
• PowerAutomate
• PowerQuery
• PowerBI Mobile
JOB EXPERIENCE
1. HTC Global Services (India) Private Ltd Technical Lead Chennai Feb 2021 – Present day
Project #1: Assurance Consulation – Plante Moran
Power BI, SSRS, Power BI Service, Microsoft Azure
Plante Moran is one of the largest Audit, tax, consulting, and wealth management firms in the United States. The purpose of this project is to modernize an existing application developed previously on K2 platform.
Roles & Responsibilities:
Worked closely with Business Users/Stakeholders and Business Analysts
to collect the business requirements.
Design and Develop the Power BI and Paginated reports as per the requirements. Prepare the detail level requirement as per the business needs.
Worked with testing team and identifying the bugs and resolved the bugs immediately.
Environment : Power BI Desktop, Paginated Reports, MS-SQL Server, GitHub, Azure DevOps.
Major Achievements : Followed the Best Practices in all phases of life cycle (Dev, QA, Stage, Prod).
Provided Optimized the reports to end users to meet the business requirements.
Other Achievements : While working on Project, parallel worked on
different POC projects and implemented those features in current Project.
Managed 4 members of the team.
Project #2: 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 Sql Server, 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.
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
Feb 2021 to
till date
Sep 2015 to
Jul 2020
May 2011 to
Sep 2015
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 #3: 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.
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.
Working in an agile methodology
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 junior resources.
3. Cognizant Technology Solutions Associate - Projects Chennai May 2011 - Sep 2015
Project #4: 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.
Worked on the BO XI R3.1 and BO R4.0 Reports and Universe.
Migrate the report from BO R3.1 to 4.0.
Responsible for all BO tickets Resolution and Change Requests. 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 : 984**-*****