Data Analyst

Ganesh Kumar Murugandi

linkedin.com/in/ganeshkumar24 ****************@*****.*** 512-***-****

Education

The University of Texas at Dallas Aug ‘16 – Dec ‘18

M.S., Business Analytics

Sastra University Aug ‘09 – May ‘13

B.S., Information Technology

EXPERIENCE SUMMARY

I’ve around 4.5 years of experience performing data analysis, design, development, and Implementation of Business Intelligence Projects using Python, Tableau & Informatica

Have used Tableau data visualization tool to analyse and obtain insights from large datasets & create visually compelling and actionable interactive reports and dashboards

Have good understanding and used statistical methods, data warehousing and Project Management techniques during several projects

Have written complex SQL queries and optimized the queries in Oracle, SQL Server and Teradata

Have good experience in programming, statistics, and analytics. Excellent understanding of business operations and analytic tools for effective analysis of data

Have good experience working with Data Analytics, Data Reporting, Ad-hoc Reporting and PivotTables

I’m passionate, collaborative & result-oriented analyst with knowledge across data warehousing, data transformation, data visualization and data analysis.

Intermediate proficiency with SQL, Tableau, Python, SDLC and Agile methodology

Have extensive experience in Data Visualization including producing tables, graphs, listings using various procedures and tools such as Tableau

Have worked and extracted data from various database sources like Oracle, SQL Server, DB2, accessing JIRA tool and other internal issue trackers for the Project development

I’m very knowledgeable in transforming raw data into actionable strategic knowledge to gain insight into business using statistical analysis processes

I’m highly knowledgeable in Networking and Linux and providing support to customers in need

Have good understanding of SQL Server and Oracle Architecture in terms of ETL and query processing, structure and performance and table partitions

Have experience working in Healthcare, Banking and Transportation domain

Have good knowledge Data Model with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules

Skills

Data Visualization

Tableau 9.x, 10.1, Power BI, Seaborn, Matplotlib, Pivot Table and Chart

Python Libraries

Pandas, SciPy, NumPy, Seaborn, SciKit Learn

Language & scripting

Python, SQL, JSON, Java, bash Shell scripting, Power DAX Query

Database Tools

Microsoft Access, My SQL, SQL Developer, SQL Server, Oracle 10g,

Tools

Erwin, Jira, MS Excel, EC2, STATA, Jupiter Notebook, MS Office, Selenium

Extract Transform Load (ETL)

Informatica 9.x,10

Certification

Google Analytics, Google Adword

Subject Matter

Statistics, Advanced Excel, SEO, UML, AWS, Data Analysis and Modelling, Marketing

Professional Experience

Primoris System

Client: Odoo

Data Management Analyst (Tableau Developer) June ‘ 20 to Feb ’21

Project Summary

The objective of the project is to manage client relationships while implementing Odoo SaaS solutions. Analyse all aspects of clients' business operations to map their processes to Odoo's solutions. Quantify the resources required for the implementation of their business solution

Responsibilities

Created Interactive Tableau Dashboard after gathering and analysing the data from the warehouse to illustrate the metrics of the business process

Created a data mart from the warehouse using Informatica to transform data using Transformation like Source Qualifier, Expression, Joiner and Filter transformation for generating report

Involved in gathering, analysing the information, documenting the business requirement

Developed interactive Tableau visualizations after gathering Business Requirements to illustrate KPI and Performance metrics of the business processes.

Created and updated project schedules using automated project management software

Identified the project risks and issues and supported team members in creating and executing mitigation plans

Extracted data from the database using Excel/Access, SQL procedures and created Python datasets for statistical analysis, validation and documentation

I’ve used drill downs, filter actions and highlight actions in Tableau for developing dashboards in Tableau

Responsible for building and maintaining effective working relationships with business teams, as well as other external vendor and customer data management team

Identified inconsistencies in data collected from different sources and worked with business owners/stakeholders to assess business and risk impact, provided solution to business owners

Manipulating the data using excel, Access to ensure data quality

Compiled data from multiple data sources used SQL and Python packages for data extraction, loading and transformation

Environment: Oracle Database 11g, Oracle BI tools, Tableau, MS-Excel, Python, MS Access, JIRA, SQL

owners/stakeholders to assess business and risk impact, provided solution to business owner

Premier Inc, Charlotte

Client: University Hospitals

Project Data Analyst Nov ‘19 to May ‘20

Project Summary

The objective of the project is to improve the business processes of the university hospitals by figuring out the ways to improve their daily practises by implementing ways to generate patients reports effectively

Responsibilities:

Performed several roles across technology, budgeting and project management status using Tableau and MS Excel

Prepared weekly and monthly project status reports using JIRA and SQL and delivered it to appropriate project team members and stakeholders.

Analysed and provided documentation for transforming existing data from legacy applications and loading of this data into a new target application environment.

Collaborated with the development team to analyse and understand business or user requirements to create detailed database design models as well as write programming code using SQL for applications to interact with databases

Hands on experience working with MS Access to create database, tables defining the relationship, write sql queries and to create report

Identified the data integrity issue and assisted in prioritizing and developing plan to improve data quality

Ability to carry out priorities in an organized and efficient manner

Documented, tracked, and updated risks, issues, and change requests. Created and executed project work plans and revised as appropriate to meet changing needs and requirements

Worked with product owner to understand the business needs and help translate into story backlog

Have experience in writing technical documentation. Managed the workflow of the timesheet entry process to ensure the quality.

Developed documentation and presentation material to communicate project status and plans. Involved in troubleshot, coordinate and maintenance of production applications

Documented the plan for migrating data from Oracle to Teradata system and helped the team to efficiently develop ETL jobs which reduced the budget cost by 5 % per sprint.

Environment: Python 2.x/3.x, SQL (Structured Query Language), Jupyter Notebooks, Jira Tableau Desktop, Excel Pivot Table, MS Access and Oracle database

Dikita Enterprises, Inc, Dallas

Client: Dallas Area Rapid Transit Network

Jr. Research Data Analyst Jun ’17 to Nov ‘19 (18 months)

Project Summary

The objective of the project is to derive insight from the survey data collected and provide actionable insight to the management team. To improve the efficiency of the transit service by providing detailed actional insights

Responsibilities:

Worked extensively with databases related to transit projects, analysed data patterns and ensured data quality is attained.

Performed data analysis on survey data using Regression and Classification machine learning algorithm on Jupyter notebook using python to infer insights related to day-to-day ridership counts and revenue generated.

Performed data analysis and provided recommendations for developing strategies that lead to an increase in revenue by 7% and passenger count by 5%.

Evaluated various types of datasets by performing machine learning models using algorithms and statistical modelling techniques such as Classification, Regression, Decision trees using Python libraries.

Performed Data Cleaning, features scaling, features engineering, feature prioritization using pandas and NumPy packages in Python

Analysed data using statistical techniques to identify, analyse, and interpret trends or patterns to gain insight

Ensured data quality is maintained by removing duplicates, imputing missing value while pre-processing the data. Prepared digital marketing campaign report

Created visualization using Tableau using charts and shared it with internal and external stakeholder.

Involved in the marketing campaign for the pilot bus service

Handled anomalies in the data - removing duplicates, imputing missing values and treating null values using Python Scikit- learn

Performed Industry analysis and forecasting of trends

Collaborated with other teams to identify, assess their data need, design, build and present appropriate output

Performed data manipulation, data preparation, normalization, and predictive modelling. Improve efficiency and accuracy by evaluating model in Python

Performed ETL data extraction, transformation, cleansing and preparation of analytical datasets from structured formats such as RDBMS tables, Excel, CSV files

Helped to identify that the newly added route generated less than forecasted revenue in Plano county and provided vital insights on updating the route to be profitable.

Environment: MS SQL Server, SQL Enterprise Manager, Python, MS Excel, Tableau, MS Access, MS office, MS Word, MS Power point Outlook, Jupyter notebook, Informatica

Tata Consultancy Service, Chennai

Client: Lloyds Bank

System Engineer (Analyst) Aug ’13 to Oct ‘14

Project Summary

The objective of the project is to provide services to Lloyds bank to help them improve the efficiency of the online banking process. Provide support services and implement additional features to the system

Responsibilities

Provided maintenance support for the Lloyds banking software used by millions of users to create account, open overdraft.

As a part of servicing support team, helped end users by resolving the issues faced by them while performing operations such as opening new accounts. Performed a vital role in improving the usability of banking software

Involved in various activities of the project like information gathering, analysing, documenting the functional or business requirements.

Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the change in the proposed system.

Designed Fact tables and Dimension tables for star schemas and snowflake schemas using ERWIN tool and used them for building reports.

Collaborated on cross-team and cross-product technical issues by working with resources from other groups as needed to resolve customer issues

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and data flow diagrams using UML and Business Process Modelling

Designed and developed several mappings that involves active and passive transformations like Source Qualifier, Lookup, Router, Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable logic using Informatica

Designed Fact tables and Dimension tables for star schemas and snowflake schemas using ERWIN tool and used them for building reports

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop

Provided production support by monitoring the daily running workflows or processes

Collaborated on cross-team and cross-product technical issues by working with resources from other groups as needed to resolve customer issues

Generated ad-hoc reports for the project management team using SQL queries

Environment: MS SQL Server, SQL Enterprise Manager, MS Excel, Erwin, ETL, MS Access Java, Jira MS office, Outlook, Informatica

Leadership Experience & Organization

Professional Chair at UT Dallas, Alpha Kappa Psi Feb’17 to Dec ‘17

Associate Chair at UT Dallas, Investment Club Jan ’18 to July’18

Contact this candidate