| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Analyst Human Resources Richmond, VA Data Analyst Machine Learning Glen Allen, VA Senior Data Analyst Richmond, VA Data Analyst Social Media Mechanicsville, VA Data Analyst Richmond, VA Geographic Information Systems Analyst Richmond, VA Data Entry, Quality Assurance, Document Analyst, HR Manager Richmond, VA |
|
Click here or scroll down to respond to this candidateEducationMaster of Science in computer Information Systems, Rivier University Street Address /2021 08/2022New Hamshire, USABachelor of Technology in Computer Science & Engineering, Jawaharlal Nehru Technological UniversityStreet Address 2018Hyderabad, IndiaProfessional ExperienceData Analyst, ADPWorked 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 presentNew Jersey, USACreated 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 Exceland SQL Server, streamlining data accessibility.Created an Automatic Agent Productivity Dashboard employing Python, SQL, Tableau/Power BI to provide insights intoperformance 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 performhypothesis testing with libraries like Scipy.Data analyst, WiproDeveloped 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/2020IndiaDeveloped 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 DData AnalystEMAIL AVAILABLE PHONE NUMBER AVAILABLE Richmond,Virginia LINKEDIN LINK AVAILABLECreated 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 ProjectsLogistic 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 SkillsMethodologiesSDLC, Agile and waterfallETL Tool:SSRS,InformaticaTools/IDE/Build tools:PowerBI,Excel, Tableau, Pycharm, Sublime text,Google colabData Analytics:Data cleaning, Data Masking, Data Manipulation,Data visualizationOperating System:Windows,LinuxLanguagesPython,R,SQLAnalytics TechniquesRegression, Time series analysis, Clustering &Classification (Logistic regression, Decision Trees PlatformsAWS, AzureFileformatsParquet,Avro,ORC,JSONSQLMySQL and SQL server |
