Data Analyst Information Systems

Education

Master of Science in computer Information Systems, Rivier University 01/2021 – 08/2022

New Hamshire, USA

Bachelor of Technology in Computer Science & Engineering, Jawaharlal Nehru Technological University

2014 – 2018

Hyderabad, India

Professional Experience

Data Analyst, ADP

•Worked on tax payroll and healthcare filings to calculate tax credits for the federal governments CARES program.

•Utilized SQL and Python scripting for efficient data extraction from various HR databases.

10/2022 – present

New Jersey, USA

•Created visually appealing and informative dashboards using tools like Tableau, presenting key HR metrics for executive decision-making.

•Automated data cleaning procedures, reducing manual effort by 20% and ensuring data consistency across HR datasets.

•Utilized Amazon Athena for interactive querying and analysis of data stored in Amazon S3, enabling ad-hoc analysis.

•without the need for complex infrastructure.

•Conducted comprehensive research, analysis, and organization of Call Detail, Call Center, and Workforce data utilizing Excel

•and SQL Server, streamlining data accessibility.

•Created an Automatic Agent Productivity Dashboard employing Python, SQL, Tableau/Power BI to provide insights into

•performance metrics.

•Enhanced traditional ETL processes by integrating Hadoop, significantly accelerating data access.

•Managed and tracked project issues, defects, and tasks within JIRA, facilitating timely resolution and preventing project bottlenecks.

•Conducted statistical analysis using Python to derive meaningful insights, calculate summary statistics, and perform

•hypothesis testing with libraries like Scipy.

Data analyst, Wipro

•Developed and maintained interactive dashboards and reports using Excel, My SQL, Tableau, and Power BI to support data-driven decision-making, resulting in a 20% increase in overall efficiency.

•Identified trends, patterns, and anomalies in large datasets through detailed analysis, leading to improved business processes and a 15% reduction in production costs.

08/2018 – 08/2020

India

•Developed and maintained data processing pipelines on Linux systems, ensuring data integrity and reliability.

•Created pivot tables in Excel by getting data from Teradata and Oracle. Dheeraj D

Data Analyst

*************@*****.*** 804-***-**** Richmond,Virginia www.linkedin.com/in/dheeraj12

•Created database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

•Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded data into target tables by performing different kinds of transformations by SQL Server Integration Services (SSIS) & T- SQL.

•Used Power BI and tableau to create interactive dashboards showcasing regression results, risk metrics, and sensitivity analyses.

•Efficiently used Python libraries such as Pandas to clean and preprocess raw data, handling missing values, outliers, and ensuring data quality.

•Effectively presented findings to cross-functional teams through clear communication skills, facilitating collaboration and resulting in a 10% increase in team productivity.

•Retrieved and analyzed data using SQL queries to identify trends and patterns, resulting in a 15% increase in customer satisfaction scores and a 10% reduction in operational costs.

•Created test plans, scenarios, cases, and data to ensure the accuracy of data analysis and reporting, contributing to the achievement of daily, weekly, and monthly goals before deadlines by 95%.

•Maintained databases of customer profiles, booking information, and inventory data with a high level of accuracy to support decision-making processes and improve overall customer experience.

•Created reports and dashboards using data visualization tools such as Tableau to effectively communicate insights to cross-functional teams.

•Developed physical data models, data warehouse models & created DDL scripts to create database schema & database objects.

•Involved in troubleshooting the production issues and providing production support.

•Performed unit testing against the developed packages and scheduling, creating snapshots and subscriptions for the reports using SSRS. Academic Projects

Logistic Regression for Heart Disease Prediction:

Designed and implemented a machine learning model using logistic regression to predict the likelihood of heart disease in patients, achieving a 95% accuracy rate. University Accommodation Database Design and Implementation: Designed and implemented a comprehensive database system to manage university accommodation services, utilizing ER diagrams and SQL for schema development. Efficient Food Redistribution Web Platform: A PHP-Based Solution for Food Waste Reduction During COVID-19:

The project is developed using PHP and is designed to run on an Apache web server. It utilizes MySQL for database management and features a web-based user interface for seamless operation Skills

Methodologies

SDLC, Agile and waterfall

ETL Tool:

SSRS,Informatica

Tools/IDE/Build tools:

PowerBI,Excel, Tableau, Pycharm, Sublime text,

Google colab

Data Analytics:

Data cleaning, Data Masking, Data Manipulation,

Data visualization

Operating System:

Windows,Linux

Languages

Python,R,SQL

Analytics Techniques

Regression, Time series analysis, Clustering &

Classification (Logistic regression, Decision Trees Platforms

AWS, Azure

Fileformats

Parquet,Avro,ORC,JSON

SQL

MySQL and SQL server

Contact this candidate