Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic
Dipsikha Ray

Dipsikha Ray

Kolkata

Summary

Motivated and analytical professional with experience in evaluating dashboards, developing reports and managing servers. Certified Excel Specialist proficient in SQL, Excel, Python, Power BI, Tableau, Spotfire, Qlik, ETL Tools. Additional growing fluency in artificial intelligence and product life cycle analytics. Focused collaborator dedicated to interdisciplinary communication. Due to outstanding performance in project, project manager awarded me as Best Team Player.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Analyst

Cognizant Technology Solutions
05.2022 - Current
  • Developed machine learning algorithms to address complex business challenges, leveraging tools and languages such as Python, SQL, Advanced Excel, Power BI, and data visualization tools and database including SAP HANA, MySQL, PL/SQL
  • Developed customized reports, summarizing and presenting data in visually appealing format using Tibco Spotfire, Qlik Sense, Power BI, SQL, Informatica etc.
  • Provided technical support for troubleshooting analytics and reporting issues and
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.

Programmer Analyst Intern

Cognizant Technology Solutions
01.2022 - 04.2022
  • Developed a data retrieval project tailored for the Retail Industry, utilizing SQL, Oracle, and Informatica Powercenter for efficient data extraction and encompassing Unix Scripting, AWS, and Big data to facilitate comprehensive data management.
  • Created block diagrams and logic flowcharts to plan coding projects and developed as well as maintained system applications customized to suit daily needs of end-users.

Education

Master of Technology - Computer Science And Engineering

Kalinga Institute of Industrial Technology
Odisha
05.2022

Skills

  • C
  • C
  • Java
  • R
  • Test Case Scenarios
  • Tableau Expertise
  • Data Warehousing
  • Advanced Mathematics
  • Python
  • Linux
  • Unix Shell Script
  • Bigdata(MongoDB,Spark,Hive)
  • Analytical Thinking
  • MS Excel(VBA,Macros)
  • Excel Proficiency
  • MS Power BI
  • KPI Tracking
  • R Programming
  • Big Data Analytics
  • Machine Learning
  • Quantitative Research
  • Statistical Modeling
  • SQL
  • Azure
  • Amazon AWS
  • Data Validation
  • Data Visualization and Presentations
  • Reporting Tools
  • Report Preparation
  • A/B Testing
  • Predictive Modeling
  • Data Analysis

Projects

Projects Online Heart Disease Predictor using Machine Learning and NLP Technology

 Developed the Online Heart Disease Predictor, a web-based platform that leverages expert-generated data to predict and address heart-related issues and created an interactive space where users can provide their health details and receive predictions regarding heart disease, facilitating early detection and intervention using Logistic regression and Naive Bayes algorithm. • Implemented a feature that enables users to book appointments with qualified doctors based on the predictive results, ensuring timely access to healthcare professionals. 

Tata Data Visualization: Empowering Business with Effective Insights Job Simulation on Forage - December 2023 

● Completed a simulation involving creating data visualizations for Tata Consultancy Services using Power BI and KPI Trackings and created visuals for data analysis to help executives with effective decision making .

PwC Switzerland Power BI Job Simulation on Forage - December 2023 

● Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualization needs and demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions. ● Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis. ● Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.

Deloitte Australia Technology Job Simulation on Forage - December2023

 Completed a job simulation involving data analysis for Deloitte's Technology team and created a data dashboard using Tableau ● Wrote a proposal for a client project to create a functioning dashboard and used Excel to classify data and draw business.

Excel-Employee Dashboard  

Created Pivot Table to compare invoice due dates with actual payments allowing accounting department to improve cash flow model. ● Using VBA, automated the discovery of duplicate entries in employee-generated databases to increase accuracy of customer count by 15%

Certification

  • CLOUD COMPUTING training by WEBTAK LABS PRIVATE LIMITED
  • INFORMATICA MDM certificate by INFORMATICA
  • SQL Certified winner from Hackerrank
  • Python Internship from Internshala

Timeline

Analyst

Cognizant Technology Solutions
05.2022 - Current

Programmer Analyst Intern

Cognizant Technology Solutions
01.2022 - 04.2022

Master of Technology - Computer Science And Engineering

Kalinga Institute of Industrial Technology
Dipsikha Ray