Keerthana Haribalakrishnan
Data Analyst - Apple
Location: Leander, Texas 78641 Mobile: +1-425-***-****
Email: *************************@*****.***
Professional Summary
More than 4 years of data science, analytics, consumer insights and engagement experience in various industries
Experience in industry as programmer analyst using Python, SQL and Tableau to design, develop and enhance system operation metric
Experience in working with both Agile and Waterfall methodologies
Expert in writing SQL queries and optimizing the queries in SQL Server and MySQL
Adept at relationship management and providing strong analysis, visualizations, and recommendations to key decision-making stakeholders
Experienced in data preparation like data cleaning and formatting
Hands-on development in assisting users by creating and modifying worksheets to get best data visualizations
Worked on several Python packages like NumPy, Matplotlib, Pandas, TensorFlow etc.
Well experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Configuration Management
Good knowledge of Statistical analysis, data wrangling, data exploration, data Visualization and Modeling with Machine learning techniques like Clustering, Classification, Regression, SVM and Random Forest, Gradient Boosting etc.
Proficiency in multiple databases like MySQL and MS SQL Server
Expert in Tableau Desktop, Tableau Reader and Tableau Server and Experienced in analysis, modeling, design, and development of Tableau reports and dashboards for analytics
Design & Implementation of Data Extraction, Transformation & Loading (using Informatica), Analyze SQL Server Data & Migration of the same
Comfortable working in individual contributor roles and with teams
Capable of forming and maintaining positive and productive working relationships in internal/external and team environments with excellent communication skills, strong team-building and conflict management skills
Core Skills
Languages:
Python and SQL
Libraries:
Pandas, NumPy, Matplotlib, Skicitlearn, Keras, Linearregression, Randomforest, Kmeans, Seaborn, Pytorch and Tensor Flow
Databases:
MySQL and SQL Server
Tools:
Tableau, Informatica, Oracle DB
Data Analysis Techniques:
Data warehousing, Data Visualization, Data Manipulation and Data Cleaning
Others:
Machine Learning and MS Office Suite
Methodologies:
Agile and Waterfall
Operating System:
Windows and Mac OS
Education
Masters of Engineering in Computer Science Engineering Aug 2016 - May 2018
Anna University, India
Bachelors of Technology in Information Technology Aug 2012 - May 2016
Anna University, India
Experience
Apple, Austin Mar 2023 – Present
Role: Data Analyst/problem Manager
Responsibilities: -
Involved in creating dashboards for Stack holders from Quarterly Business Reports using Tableau.
Involved in creating dashboards for Stack holders from Quarterly Business Reports using Tableau and Power BI
Analyze data and tickets for incident management team and generate reports.
Reviewing Problem Management System database schema using MiroBoard and automating report generation from Cloud using Python script.
Extracting data from document store using Python and storing data into Database using SQL.
Analyzing and reviewing QSR and WSR using MS Excel(Macros, Pivot Tables).
Involved In working with Python libraries panda, matplot lib, scikit-learn
Managed and communicated with the team whether the incidents are below service level agreement
Worked in servicenow ticketing system also worked in incident and change management
Documented Incident management process in Confluence
Support consistent communication inscope of the process and service
Worked In Machine Learning packages such as Pandas,. Numpy, Keras, Skicit learn and Tensor flow
Used Un-Structured Data such as pdf’s, html and converted audio to text using Langraph framework.
Validated my Data using Tensorflow package in Python
Worked in LLM integration in Langraph and deployed to platforms like AWS
Worked with Autogen framework that can handle complex workflows
Did Data Analysis using machine learning packages
Used Clustering and Regression Algorithms to classify the data
Trained and Tested my data with 90% Accuracy
Evaluated my model based on confusion Matrix
McKesson, TX Jan 2022 – Dec 2022
Role: Data Analyst Intern
Responsibilities: -
Involved in budgeting, planning, resourcing for the product enhancements
Analyze, Design and develop Data discovery dashboards in Tableau to present the data story to the business stakeholders
Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables) and Power point presentations
Developing and maintaining database, reorganizing data in a readable format
Data cleansing and uploading the data into data warehouse and the performance indicators and accuracy of the classifier is compared using the python
Developed the reports on the different journals based on the year of publication using Tableau
Object detection in invoice project using TensorFlow
Dell Technologies, India Dec 2019 - Jan 2021
Role: Data Analyst
Responsibilities: -
Analyzed Data Set with Python programming and Excel
Imported the claims data into Python using Pandas libraries and performed various data analysis
Excellent technical skills in SQL to extract data from the database for data analysis and testing
Performed Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification, identifying data mismatch, Data Import and Data Export through the use of ETL tool like Informatica
Solved complex problems with multi-layered data sets, as well as optimizing existing machine learning libraries and frameworks
Good understanding of Relational Database Design, Data Warehouse concepts and methodologies
Good knowledge of Statistical analysis, data wrangling, data exploration, data Visualization and Modeling with Machine learning techniques like Clustering, Classification, Regression, SVM and Random Forest, Gradient Boosting etc
Generated MySQL and SQL Server scripts for data manipulation, validation and materialized views for remote instances
SQL Relational SQL to check the accuracy correction for the report logic due to the non-availability of a reporting database
Involved in Requirement Elicitation and maintaining requirements from Inception through Construction phase
Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software, Conducted Data Analysis
Developed Machine Learning algorithms to analyze huge volumes of historical data to make predictions
I also had 8 months of working with D&B database in order to find the business information and also has salesforce and google Analytics certification
Trigent, India Jan 2019 - Nov 2019
Role: Jr. Data Analyst
Responsibilities: -
Tested and modified databases to determine and correct issues
Developed data models and database designs to plan projects
Partnered with project management teams on development of scope and timelines
Designed complex reports to validate the synchronization of the application with other applications, including the customer information system, asset management system, and mobile workforce management system
Designed complex reports to monitor and analyze assets, events, communications, energy, service orders, customer information, and other related data
Specified user access levels for each database segment to protect database integrity and company information
Designed, built and deployed data, financial and accounting BI solutions utilizing Excel and Tableau (e.g., reporting tools)
Manipulated digital images through advanced computer skills, video editing and image retouch and promoted technical quality of final output
Designed and developed various dashboards/ reports utilizing Tableau advance visualizations like Bars (Horizontal, Stacked, Side by Side), Lines (Continuous, discrete), Bullet Graphs, Scatter Plots, Circle Views, Pie-Charts, Packed Bubbles, Funnel Charts, Geographic Maps (Symbol, Filled) to represent different datasets.
The building, publishing customized interactive reports and dashboards, report scheduling using Tableau
Wrote MySQL queries from scratch and created views on MySQL for Tableau.
Responsible for creating and structuring critical financial analysis models such as break-even analyses, volume/rate/mix analyses, and scenario modeling.