Shri Harsha S

• Handled 2-member team of onboarding and worked on delivering business insights to stake holders through Power BI reports
• Used various functions of Success Factor data as data source for developing and visualizing data
• Along with Power BI reports Worked on various Ad-hoc requests as per the business needs
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports
• Project#1 : HCCBPL Mandatory Compliance Course Dashboard

Domain: Human Resource (L&D team)

Environment: Power BI, Excel, DAX

Description:

This report gives an overall completion percentage of various Mandatory compliance courses across various verticals of HCCBPL in real time. Auto scheduled data refresh so that so that stake holders can see real time data and take necessary action.

Roles & Responsibilities:

· Participated in requirements meetings to understand the Report Requirements.

· Identified and documented detailed business rules.

· Connected to the HR data sources share folder to extract data for data cleaning.

· Transformed and shaped the data to meet the specific requirements of the dashboard.

· Mainly used Excel and CSV files as data source.

· Configured Data Gateways to Refresh and Scheduled Refresh of the Dataset.

· Created interactive and highly informative Power Bi report using DAX.

· This Bi report was built to get the overall course completion percentage of various mandatory courses like POSH, Cybersecurity, Security Essentials, COBC etc...

· Developed mobile view of report.

· Worked on UI/UX design of reports and Custom Power BI theme creation.

• Project#2 : Women Representation Dashboard

Domain: Human Resource (HRBP)

Environment: Power BI, Excel, DAX

Description:

This report covers datapoints of Women Representation across various HCCBPL functions. Auto scheduled data refresh so that so that stake holders can see real time data and take necessary action.

Roles & Responsibilities:

· Participated in requirements meetings to understand the Report Requirements.

· Identified and documented detailed business rules.

· Connected to the HR data sources share folder to extract data for data cleaning.

· Transformed and shaped the data to meet the specific requirements of the dashboard.

· Mainly used Excel and CSV files as data source.

· Configured Data Gateways to Refresh and Scheduled Refresh of the Dataset.

· Created interactive and highly informative Power Bi report using DAX.

· This Bi report was built to get the overall datapoints of Women Representation across various HCCBPL functions based on category wise, Tenure wise, generation wise, Gender diversity, Talent Export, Promotions, YoY comparison, etc...

· Developed mobile view of report.

Worked on UI/UX design of reports and Custom Power BI theme creation

• Project#1: Work force Trend Dashboard

Domain: Human Resource (HRBP)

Environment: Power BI, Excel, Oracle Database, DAX

Description:

This report gives an idea on Headcount of past financial years and also compares the headcount between current and previous financial year. It also showcases various workforce parameters like New Joiners, Leavers and Exit Pipeline (Actual + Expected Exits) for current and past financial years.

Roles & Responsibilities:

· Participated in requirements meetings and Scrum Calls to understand the Report Requirements.

· Identified and documented detailed business rules.

· Connected to the HR data sources (Oracle SQL server and EXCEL WORKBOOK) that stores Headcount, Attrition and Joiners data.

· Transformed and shaped the data to meet the specific requirements of the dashboard.

· Cleanse and filter the data to ensure its accuracy and reliability.

· Created relationships between different tables to establish connections b/w related data.

· Created New Columns, New Measures and New Table over data models Used DAX functions like CALCULATE, SAMEPERIODLASTYEAR, USERELATIONSHIP, ETC…

· Used “LINE CHART” for headcount trend, “CLUSTERED COLUMN CHART” for New Joiners, Leavers and Exit Pipeline, and “CARD” Visual for representing Total Headcount along with Gender wise sorting.

· Configured Data Gateways to Refresh and Scheduled Refresh of the Dataset.

· Managed access to Reports, Dashboards, and Data for individual users using roles.

· Implemented Row Level Security as part of Security.

· Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

· Worked on UI/UX design of reports and Custom Power BI theme creation.

• Project#2 : Financial Dashboard

Domain : Project Management Office (PMO)

Environment : Power BI, Oracle Database, DAX

Description:

A project management office (PMO) is a group, agency or department that defines and maintains the standards of project management for a company. The PMO retains the documentation and metrics for executing projects and is tasked with ensuring projects are delivered on time and within budget.

Roles & Responsibilities:

· Created interactive and highly informative Power Bi report using DAX.

· Implemented RLS based on various Roles / Hierarchy.

· Was responsible for performing data analytics and gathering insights as per the business requirements.

· Used Oracle SQL server as data source for developing BI report.

· Configured Data Gateways to Refresh and Scheduled Refresh of the Dataset.

· This Bi report was built to get the overall idea of parameters like OD, PBDD, RAR, UBR, UER and Effort Revenue along with drill through.

· Used buttons and actions to view the detailed factors which are contributing to the showcasing values.

· Created Microsoft Power BI Dashboards in Power BI Service using Reports.

· Developed mobile view of report.

· Worked on UI/UX design of reports and Custom Power BI theme creation.

• Project#3 : Operations Controller Dashboard

Domain: BIA

Environment: Power BI, Oracle Database, DAX

Description:

Operations controller is a department with a vision of achieving Profitability and Cost Management excellence. The scope and impact of this department encompasses company-wide decision support involving operations parameters.

Roles & Responsibilities:

· Involved discussion with business users for gathering the requirements and driving daily call with clients and Translating End- User requirements into Efficient Dashboards.

· This Bi report was built to get the overall idea of parameters like Headcount, Applied Ratio and Yield along with drill through.

· Publishing reports to Power BI server and providing the access to required users.

· Used Power Query / Query Editor for Data transformation as per the reporting needs.

· Created Data Model in Power Pivot by Establishing the Relationship Between the tables.

· Created New Columns and New Measures over data models for the purpose of enhancing Power BI visuals using DAX.

· Participated in weekly and daily meetings, reviews meeting as well as communicate with business teams.

· Integrated Custom Visuals based on business requirements using Power BI desktop.

· Created Hierarchies and Drilldown Reports.

· Configured Data Gateways to Refresh and Scheduled Refresh of the Dataset.

· Implemented Row Level Security as part of Security.

· Managed access to Reports, Dashboards, and Data for individual users using roles.

· Worked on UI/UX design of reports and Custom Power BI theme creation.

• Project#4: Talent Acquisition Dashboard

Domain: Human Resource (TA)

Environment: Power BI, Oracle Database, DAX

Description:

The talent acquisition team is responsible for identifying, attracting and hiring skilled workers to meet an organization's needs. This report provides insights of how recruitment strategies, sourcing candidates, managing the interview process are happening in the organization and guided the senior management team to take necessary action to achieve the necessary targets.

Roles & Responsibilities:

· Created interactive and highly informative Power Bi report using DAX.

· Used Oracle SQL server as data source for developing BI report.

· Integrated Custom Visuals based on business requirements using Power BI desktop.

· Used Power Query / Query Editor for Data transformation as per the reporting needs.

· This Bi report was built to get the overall idea of parameters like Open positions, Offers released, CV received, Attrition, Hired, Cancelled, yet to join, Headcount etc.…

· Created Hierarchies and Drilldown Reports.

· Configured Data Gateways to Refresh and Scheduled Refresh of the Dataset.

· Worked on UI/UX design of reports and Custom Power BI theme creation.

· Managed access to Reports, Dashboards, and Data for individual users using roles.

• Company Overview: Intrado, formerly West Corporation, is an American telecommunications company which used to provide Enterprise Communications globally along with various other services like Cloud Collaboration, Life and Safety, Digital Media and Health and Wellness
• Used to work on various distinct client excel reports and audio conference files which were later encrypted with a specific passcode before forwarding it to client
• Performing Quality check on the agent’s reports which were sent out to the clients and suitably giving suggestions to agents to improve quality of the task
• Handling VIP clients (US, APAC, EMEA) live and post conference work with at most precision
• Handling Customer replies and suitably responding to their queries within the specified TAT
• Handling Chargeback cases
• Knowledge of Root cause analysis of Customer Complaint
• Working knowledge of internal ICRM, Citrix and Sales force applications
• Have played a role of Trainee for the process which I am working
• Creating case history of the customer with utmost precision
• Proactively took up the project to develop and visualize the data using Power BI
• Experience on gathering and translating end user requirements into effective & efficient dashboards that aid decision-making
• Worked on numerous Ad-hoc requests from various internal departments to deliver better business insights using power BI with Excel as data source