Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Sanghamitra Das Adhikari

Data Analyst
Kolkata,WB

Summary

Detail-focused Data Analyst ( 8 years of work experience) working with vast dataset to extract information and solve business problems. Skilled in Predictive models,data mining,data generation and data masking. Proficient with the Machine learning predictive models. Proven ability to understand customer requirements and translate into actionable project plans. Have ability to identify opportunities and strategizing methods for improvement. Delivered predictive analytics solutions and intelligent applications efficiently to the customers.

Experienced in Data Management,

Programming Skills: Python, Jupyter notebook, SQL, Java, Xcode

Databases: DB2, MySQL,SQLServer

Tools: Jupyter notebook, Microsoft Word, Microsoft Excel & Microsoft PowerPoint, Informatica, Abinitio

Overview

4
4
Certifications
6
6
years of post-secondary education
8
8
years of professional experience

Work History

Associate-Projects

Cognizant Technology Solutions
Kolkata, West Bengal
05.2018 - Current
  • Currently, working as the Quality Assurance Analyst as part of the strategic IT program involving the Database testing.
  • As a part of John Hancock Life Inforce Project, I have been involved in creating ,tuning and optimize complex SQL queries. I was sole responsible for generating different reports by writing queries joining multiple tables of multiple schemas with high complexity.
  • Worked as the member of the Test Data Management team for one of the eminent Insurance companies of North America Geo, Manulife.
  • As part of Test Data Management team, worked extensively on test data generation,data mining and data sub-setting using Informatica tool.
  • As part of the test data generation process, NEW test data is generated using the business transformation logic and loaded to the Test environment. This needs a thorough knowledge on the business.
  • As part of data sub-setting, sub-set of the production data is loaded to the test environment based on certain criteria after masking the data. This also requires an expert knowledge on the data and their correlations.
  • Performed statistical analysis on various types of data from different heterogeneous sources to analyze and interpret large data sets. Also as a part of the maintenance task, performed cleaning the databases removing redundant, missing, duplicate and unnecessary data.
  • Delivered predictive analytics solutions and intelligent applications efficiently to the customers.
  • As part of Quality Assurance testing, involved in creation of regression suites to perform regression testing on databases to ensure all the modules are unaffected except the intended change after each load.
  • Maximized productivity by identifying and rectifying areas for improvement.
  • Evaluated customer information to explore issues, develop potential solutions and maintain high-quality service.

Senior System Engineer

Infosys Technologies
Bhubaneswar, Odisa
03.2013 - 05.2018
  • Worked as the member of the Test Data Management team for one of the distinguished Healthcare companies of North America Geo, Aetna Inc.
  • As part of Test Data Management Team, worked independently in Data Generation, Data Mining and Data Masking.
  • Developed masking codes in mainframe RUMBA, using Job Control Language (JCL) to create jobs that mask PHI, such as credit card, Social Security numbers with a non-sensitive substitute, in a way that preserves the integrity of the data. This data includes Relational data, flat files and Virtual Storage Access Method (VSAM) datasets.
  • For Data mining projects, extracted useful information from huge production files. It also involved exploring and analyzing large blocks of information to glean meaningful patterns and trends.
  • Attended tickets created by end customers (primarily, client executives) and provided immediate and efficient solutions including (but not limited to) the walk-through of various application functionalities to the users.
  • Performed regular maintenance of the organization transactional database by Cleaning and validating the data to ensure accuracy, completeness, and uniformity .

Education

Master of Science - Applied Computing

Wilfrid Laurier University
Waterloo, Canada
09.2020 - Current

Bachelor of Technology - Electronics And Instrumentation

Heritage Institute of Technology
Kolkata,India
08.2008 - 04.2012

Higher Secondary - Science

Ballygunge Siksha Sadan
Kolkata,India
05.2006 - 04.2008

Skills

    Databases

undefined

Accomplishments

    Detection of Fraudulent Credit Card Transactions

    September 2020 – December 2020

    Technology: Python, NumPy, Scikit-learn, Pandas, Matplotlib

  • Performed explanatory data analysis
  • Created correlation charts in Jupyter Notebook to perform preliminary analysis, cleaning data thus helping in visualizing data points using Matplotlib
  • Predicted fraud transactions with 98.88 % accuracy using decision tree, 86 % using Random Forest Classifier that helps financial institutions to prevent such illegal attempts

Certification

Principles of Insurance by Life Office Management Association(LOMA)

Timeline

Machine learning from Udemy

04-2021

Master of Science - Applied Computing

Wilfrid Laurier University
09.2020 - Current

Principles of Insurance by Life Office Management Association(LOMA)

01-2019

America's Health Insurance Plans Premier

08-2018

Associate-Projects

Cognizant Technology Solutions
05.2018 - Current

D IBM certification on ‘Test Data Analyst’

04-2014

Senior System Engineer

Infosys Technologies
03.2013 - 05.2018

Bachelor of Technology - Electronics And Instrumentation

Heritage Institute of Technology
08.2008 - 04.2012

Higher Secondary - Science

Ballygunge Siksha Sadan
05.2006 - 04.2008
Sanghamitra Das AdhikariData Analyst