KEERTHANA S
Sandefjord
Summary
Data Analytics Professional with 7 years of IT experience in Data Integration and Data Delivery Solutions. Expertise in Creating Data Pipelines and Data Models using Various Technologies such as INFORMATICA, PLSQL.Proficiency in Creating Interactive dashboards and Reports using PowerBi , Tableau.
Overview
8
8
years of professional experience
Work History
Specialist
COMCAST (TATA ELXSI)
Chennai
04.2021 - 04.2022
- Worked on Creating data pipeline which extract data from heterogeneous sources ,transformed as per Business Rules using Informatica
- Created a datamart with extended star schema having multiple Dimensions and Facts.
- Developed Text Analytics dashboard in PowerBI which gives all the information about the Customer sentiment
- Created Heuristic machine dashboard which provides the details about the customer traffic in the website. This helps to understand the issues in the pages.
- Created Highly Interactive dashboards using PowerBI desktop for the digital marketing and the support teams.
- Developed a Ticketing dashboard to assist the support team in analyzing the tickets and comparison of the previous days and the weeks to optimize the team's performance
- Communicated regularly with both IT and Non IT teams to ensure knowledge transfer between cross functional teams
- Actively supported business users for change requests
- Designed and Implemented report layouts according to reporting standards of the department
Lead Engineer
CISCO (HCL Technologies)
Chennai
09.2017 - 04.2021
- Transformed data into user friendly visualizations to give users complete view of their business using PowerBI
- Using a query editor in PowerBI performed certain operations like fetching data from different file
- Created KPI to show the difference between actual and forecast data.
- Worked with import and direct query , Created custom tables in PowerBI
- Merge queries and append queries , remove columns and split columns ,Choosing required columns in the data
- Developed and published reports and dashboards using PowerBI and written effective DAX formulas and Expressions
- Created several user roles and groups to the end users and provided row level security
- Worked on Tableau to PowerBI Migration initiative as Subject Matter Expert and primary point-of-contact for project management staff.
- Migrated dashboards are shown a 50% increase in performance
Senior software Engineer
Prodapt solution Pvt Ltd
09.2014 - 09.2017
- · To do Reliability, Performance, Functional and configuration testing on CPE and ACS.
- · To manage and perform GUI as well as CLI Automation to minimize manual effort of testing.
- · To do Functional, Configuration testing on Home Automation Devices.
- · Execution of CD-Router scripts and analyzing results.
- · To troubleshoot when any issues arises in testing LAB Environment.
- · To install and maintain Servers such as PPP, DHCP and IPv6
- · To manage people by assigning activities and helping them in doubts and share results to customer.
Education
Bachelor of Engineering - Electronics And Communications Engineering
Anna University
Salem , India03.2014
Skills
- Data visualization and modeling
- Data Analytics
- Microsoft Power BI Desktop
- Tableau Desktop and Server
- Business Objects
- Data warehouse(SQL Server, Redshift)
- ETL : Informatica
- Programming : SQL, DAX , Python
Timeline
Specialist
COMCAST (TATA ELXSI)
04.2021 - 04.2022
Lead Engineer
CISCO (HCL Technologies)
09.2017 - 04.2021
Senior software Engineer
Prodapt solution Pvt Ltd
09.2014 - 09.2017
Bachelor of Engineering - Electronics And Communications Engineering
Anna University