Project Quality Assurance
Resume:
DEBOJYOTI SINHA.
Email Id: **********@*****.*** Phone: +91-915******* : +91-843*******
Excellent team player working as Quality Assurance Assistant in an organisation of repute with a sound knowledge of SQL, SAS/Base, SAS/Advance and an intermediate knowledge of MS Excel, MS Word, Modelling,Segmentation etc.
Summary
• Extensive use of PROC SQL and Oracle SQL Developer to perform queries, join tables, etc.
• Statistical procedures like PROC FREQ, PROC MEANS, PROC UNIVARIATE and PROC SUMMARY.
• Generate reports either in HTML, PDF or RTF formats according to the client specifications.
• Problem of Estimation and Testing of Hypothesis, t-Tests, Chi – square Tests and Analysis of Variance.
• Correlation and Linear Regression, categorical data analysis and Logistic Regression.
• Cluster, Factor, Time Series Analysis. Building of ARIMA MODEL.
Academic Credentials
Examination School/College Board/University Year of Passing Percentage
B.Sc (Phy,Chem,Maths) Dinobandhu Andrews College University Of Calcutta 2010 64.20
A.I.S.S.C.E. Guru Tegh Bahadur public School C.B.S.E. 2006 74.40
I.C.S.E. Pearls Of God I.C.S.E. 2004 80.50
Technical Skills
• Software packages known like Oracle SQL Developer, SAS/Base, SAS/Advance, SAS/Analytics, MS Excel and MS Word.
Professional Experience
From July 2011 to till date: QA Assistant in ICRA Techno Analytics Ltd. (ICTEAS) in Kolkata
Key Responsibilities:
• Data extraction from the database using Oracle SQL developer and Proc SQL as per the requirement.
• To trace the reason of data anomaly and resolve the same.
• Generating reports and analysing data using Base SAS and Statistical procedures.
• Generation of reports and graphs.
• Concerned mainly with the Sales GP Report of the client and calculation of Volume Sold (in pack, case, litres), COGS, NSA and Margin.
• Front end and data level testing by writing queries and fetching out the desired data from the Castrol Database and matching the same in the front end. Preparation of test cases for the same.
Professional Training: SAS/Analytics
Projects Undertaken on analytics:
Project on Credit Risk Modelling
The task was to build a Behavioural Credit Risk Model by applying Logistic Regression on the SAS platform. There were number of validation checks which were performed to test the robustness of the model under taken in terms of various goodness – of – fit statistics like Per cent Concordant, Hosmer – Lemeshow test etc.
Project on Customer Satisfaction Survey
The task was to find out the key factors influencing Customer Satisfaction Survey using OLS Regression. Apart from the various validation checks we looked into Adjusted R square, F statistics, and VIF values for goodness of the model and for selecting the optimum number of variable to be considered.
Project on Employee Satisfaction Survey
The task was to find out the key factors influencing Employee Satisfaction and the factors need to be considered to retain the employees using Factor Analysis. There were some step wise checking like includes Correlation coefficient matrix, KMO MSA Test, Scree Plot, Eigen values and Varimax Rotation
Project on Time series Forecasting base on Airline data
Worked on a project on Demand Forecasting for an Airline based on past data sets on number of passengers using Time Series Analysis. It involved methodologies like ADF test, ARMA and ARIMA to come to a series of forecasted figures of the future time period using SAS. For the order of ARMA and ARIMA we have considered the ACF and PACF plots.
Project on segmentation in Sports Analytics
The objective of the study was to find out the segments having best batsmen and best bowlers from the data using Cluster Analysis. This included the drawing of Dendogram (Tree Plot) to get the initial idea about the number of clusters in the data and ultimately the number of clusters that can be formed.
Project on Analysis of Two-Way ANOVA on Clinical Trial Data related to weight gain of individuals.
The project involved a Two – way analysis also which talk about an interaction between the two factors i.e. diet amount and diet type. The Tukey’s mean test was applied to find out which categorical variable, out of ‘diet type’ and ‘diet amount’ has a significant impact on the weight gain of individuals.
Personal Details
Date of Birth : 25th August 1988
Gender : Male
Nationality : Indian
Marital Status : Single
Address : C/O Debasish Sinha
Jibdharpara, P.O. – Kandi,
Dist- Murshidabad
Pin- 742137, West Bengal
Mobile : 915-***-****
Contact this candidate