MADHUPARNA BHATTACHARJEE
*********@*****.***
Present Address
Gurgaon, Haryana, India
91-882******* (M)
OBJECTIVE
To utilize and enhance my professional skill set by finding a position in
your organization with an opportunity to make valuable contributions in
accordance with your organizational objectives.
Key Skill Set: SAS Analytics
Expertise:
. Statistical procedures like PROC FREQ, PROC MEANS, and PROC
UNIVARIATE.
. Generate reports either in HTML, PDF or RTF formats according to the
client specifications.
. Analyze the results obtained from various statistical procedures like
PROC ANOVA, GLM.
. Problem of Estimation and Testing of Hypothesis, t-tests, Chi - square
Tests and Analysis of Variance.
. Ability to use analytic tools such as PROC GCHART, PROC GPLOT, PROC
BOXPLOT.
TRAINING AND PROFESSIONAL CERTFICATION
Certifications: SAS Analytics Certification from Orange Tree Global.
Professional Trainings: SAS (Basic, Advanced), Analytics
SKILLS AND ABILITIES
. Strong data collection, analysis and interpretation skills
. Strong analytical, pattern detection and problem solving abilities.
PROFESSIONAL EXPERIENCE
(1) Reporting and Data Analyst, LeanOpsys Business Consultants Pvt. Ltd.
(February 2012-Present)
Project 1: Outpatient waiting time reduction in hospital
The two primary objectives were
. To study the patient's waiting time in the outpatient clinic, with a
view to identify the factors that affect waiting time and recommend
ways of minimizing the delay.
. To use the six sigma technique to identify the delay and improve
management capabilities.
Responsibilities
. Gather data required to conduct analysis from several sources, compile
it together in prescribed format and enter the data in several data
analysis software.
. Interpret the collected data and make comparisons with the planned
activities.
. Creation of SOP's and conducting training programmes to smooth the
process flow.
. Evaluate the given problem,investigate for solutions using data
analysis practices.
Project 2: Data Management for Paediatrics and surgery department
The two primary objectives were
. Optimise database and write SQL procedures to develop multidimensional
reports
. SAS was used for the purpose
Project 3:Reduction in the delay bill submission
The main objective were:
. To increase productivity, control and stability of the billing
process. Eliminate non-value added work efforts. Improve capability to
train and reduce impact of attrition and Enhance Business continuity
planning.
. Introduce process control tools (Templates and Training Documentation)
and improve reporting.
Responsibility:-
. Gather data required to conduct analysis from several sources, compile
it together in prescribed format and enter the data in several data
analysis software.
. Describing the problem and identifying potential causes and group them
into major category with the help of fishbone diagram
. Studying audit reports to find defects related to billing and
performing Pareto analysis.
(2) Trainee at Orange Tree Global
Project 1: Credit Risk Modeling at OrangeTree Global
Description: Worked on a project related to Financial Markets wherein I had
to examine the trust worthiness of a prospective customer and his/her
possibility of defaulting on loan.
. The task was to build a Behavioural Credit Risk Model based on a large
sample of data by applying Logistic Regression on the SAS platform.
. The data had various information related to behaviour transactional
details of the customers and their performance in repayment.
. 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.
. There were number of goodness of fit statistics which we had
considered like Percent Concordant, Hosmer - Lemeshow test, Wald - chi
square and score tests.
Project 2: Testing of hypothesis on automobile data
Description: Worked on a case study related to Automobile Industry for
finding out which Automobile company is more efficient in product delivery.
. Applied ANOVA technique to analyze the data collected from three
leading automobile companies on the delivery speed.
. Performed a detailed F-test on the data to determine the most
efficient delivery speeds.
EDUCATION
. Master of Science in Economics, University of Calcutta, Kolkata, W.B,
India (2011)
Project: Women employment in NREGA (A district level study in
West Bengal) [12 member group]
. Bachelor of Science in Economics, Basanti Devi College, University of
Calcutta, Kolkata, India (2009)
. Higher Secondary Education, Shishu Bihar School, Tripura School Board,
Agartala, Tripura, India (2006)
. Secondary Education, Shiksha Niketan School, Tripura School Board,
Agartala, Tripura, India (2004)
Languages: Bengali (Native), English (professional proficiency), Hindi.
AWARDS, ACTVITIES
. Visharad (Vocal) in Indian classical music from Bhatkhande Sangeet
Vidyapith, Lucknow, India.
. Knowledge of Rabindrasangeet, Nazrulgeeti, folk songs.
. Painting and crafting.
Date of Birth:16th February,1988
REFERENCES
Available on request
DECLARATION
I pledge and pronounce that all the above information is true to the best
of my knowledge.