Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Karpagam Moorthy

Chennai

Summary

Data analytics professional seeking a challenging and dynamic role to utilize and enhance skills, experience, and abilities. Resourceful, innovative, and flexible with a strong desire for growth.

Overview

8
8
years of professional experience

Work History

Software Engineer

Splunk Technologies
11.2022 - Current

Having 2 years of experience in BI tools like Power BI Desktop, Power BI Service , Tableau and SQL Server.

Experience in Power BI Reports using different DAX queries, visuals, filters, and configuring Dashboards with drill-down

Capabilities.

Working knowledge on Power BI objects like Dashboards, Reports, Power Views, Creating Workspaces, Sharing dashboards, Row Level security Implementation.

Experienced in Azure Data Bricks to drive data analytics machine learning capabilities and visualization.

Knowledge in SQL querying, connecting and exporting the data from various data sources.

Develop Dashboards and KPIs using MS Power BI platform and publish schedule reports and dashboards to meet business requirements.

Created constructive and interactive dashboards and enhanced the existing dashboards as per client requirements by creating effective Data Modelling, filters and slicers as per client requirements.

Created roles to implement Security (RLS) for the Reports. Provided UI/UX Wireframe for design approval.

Used DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions based on requirements.

Experienced in creating the hierarchy to drill down drill through the reports and cross report drill through.

Performed various level of testing which includes unit testing functional, regression, integration and performance testing.

Created and updated the task in Jira as a ticket tracking tool and Confluence as a documentation.

Experienced in Project Management like Agile Methodologies.

Having good skills in trouble shooting On-Premises Gateway to refresh the dashboards/ reports.

Workforce Real Time Analyst/Associate CS Internet

Sutherland
Chennai
11.2021 - 11.2022
  • Developed reports on employee productivity, overtime utilization, and attendance trends.
  • Analyzed current workforce management practices to ensure compliance with applicable laws and regulations.
  • Collaborated with Human Resources to implement new policies related to staffing levels and scheduling requirements.
  • Provided data-driven recommendations to management regarding staffing strategies and operational efficiencies.
  • Developed new-hire training materials regarding all attendance and schedule matters.
  • Handled all schedule-related requests, including PTO, shift swaps and overtime.

Junior Officer Processing in Audit and Service Quality

HDFC Bank
10.2008 - 01.2012
  • Auditing the account opening documents for eastern and Southern regions
  • And other activities of Central Processing Unit as per Internal & RBI guidelines
  • Monitoring for the claim certificate to be issued to RBI for the redemptions/Interest pay-outs
  • KYC Audit and Auditor for Reserve Bank Relief Bonds for Pan India
  • Monitoring the TAT for Processing of application, updation and redemption of Investments for pan India

Education

Bachelor of commerce -

AnnaiVeilankanni’scollege
Saidapet
01.2007

Skills

  • Power BI Desktop Power BI
  • Tableau Desktop
  • SQL
  • DAX Calculations, Data Visualization
  • Dashboards
  • Data Analysis
  • Power query editor
  • Power Platform
  • Interpersonal Communication

Projects

Project Title : Life Science & Health Care 

Designation : Power BI Developer 

Environment : Power BI (Desktop & Server) and SQL Server

PROJECT 1

ROLES & RESPONSIBILITIES

· Created interactive dashboards in Power BI for the Clinical project, providing stakeholders with real-time insights into clinical trial data.

· Defined KPIs to gauge the company's overall long-term performance.

· Delivering reports to the business team promptly.

· Integrated data from multiple sources, including EHR (Electronic Health Records) & Clinical Trial data bases to create a comprehensive view of Trial data.

· Provided training and support to users to ensure they could effectively utilize the dashboard for their clinical data analysis needs.

· Creation of POWER BI Filter like visual Level filters and page level filters.

· Created Dashboards and applied Drill down Drill through functions and created tooltip on sheet level as per requirement and create drill down and drill through reports.

· Updating weekly status and keeping track of overall development status for the project. Participating Weekly, Daily and Ad- hoc meetings

· Experience in performance analyzer for performance tuning and query optimization.

· Extracting data from multiple sources like flat files, Excel, and SQL server and validating data and loading into Final Destination.

· Created calculated columns and measures using Dax and prepared report and dashboards in power bi.

PROJECT 2

Client Profile Summary

Johnson & Johnson is an American multinational medical device, pharmaceutical and consumer packaged goods manufacturing company founded in 1886. Its common stock is a component of the Dow Jones Industrial Average and the company is ranked No. 37 on the 2018 Fortune 500 list of the largest United States corporations by total revenue.

ROLES & RESPONSIBILITIES

· Understanding the user requirements, functional specifications, and technical requirements.

· Working with other team members to estimate, plan and schedule tasks to meet assigned target dates.

· Developed Tableau data visualizations and dashboards using Tableau.

· Developed dashboards and visualizations to empower decision makers.

· Developing views using Actions, Sets, Marks, and various techniques.

· Creating views and interactive Dashboards for the views developed

· Connecting to Multiple data Sources and designing reports.

· Created and applied various filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

· Developed various dashboards, used context filters, sets.

· Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports. Generated dashboards to compare the expected weekly sales vs. projected sales, using dual axes for comparison

· Prepared different views for Small business Health Care Professional.

Timeline

Software Engineer

Splunk Technologies
11.2022 - Current

Workforce Real Time Analyst/Associate CS Internet

Sutherland
11.2021 - 11.2022

Junior Officer Processing in Audit and Service Quality

HDFC Bank
10.2008 - 01.2012

Bachelor of commerce -

AnnaiVeilankanni’scollege

Similar Profiles

CREATE PROFILE
Karpagam Moorthy