RESUME

Anchor 1

Professional information

I'm having 15 years of analytics and research experience. My Academic performance indicators (API) score is 77. I have explored and applied number of operational research and statistical techniques using statistical & optimization tools like SPSS, R, Advance Excel, Lingo, Matlab, SQL query and SAS.

I have closely worked with pre-sales team of Analytics and Insights for POC (Proof of concepts) and business case studies development. Remained in client facing roles.

Work experience

Job position : Assistant Manager (A&I Unit) with TCS BPS

June 2012 - present

Domain - Pharma Analytics : Worked on an Observational Research Protocol Design. Applied Survival Analysis, Logistic Regression, Time to Event Analysis, Kaplen Meier (KM) Survival Curves Analysis & COX (Stepwise and without stepwise methodologies) Proportional Hazards Modeling, T-Test, Fisher’s exact test, Descriptive Stats Analysis.
Domain - Health Care Analytics : POC Development, Data Analysis, Reports Exploration, Power Point Presentations, Development of Excel Templates, Documentation
- Brand Switching Analysis
- Conjoint Analysis
- Choice Based Conjoint Analysis
- Data Envelopment Analysis (DEA)
- Churn Analysis
Domain - Market Research : Universe estimation & Sample Designing for Retail Services using Statistical sampling techniques from cleaning data to design an optimal retail sample size as per client watch builder standards
- Geographical stratification
- Outlier detection using Automatic and Manual Outlier detection method, Statistical Control Limits / Charts
- Technique (usually 2 Sigma approach), Box Plot, Scatter Plot, Histogram, Regression Model
- Trend checks & level checks, Missing values detection and fulfillment
- Calculating projection factors – Numeric method Z factor and Ratio expansion X factor
- Estimators applied : Applied Horwitz – Thompson estimator and Composite estimator
- Optimal allocation applied for defining the optimal sampling rate with disproportional samples to deal with stratification problems
- Clustering used for controlling the sample precision & increasing efficiency
- Using MS Excel – Pivot tables, Vlookups, Creating Templates for Optimal Sample Design using Solver
- For UK client, Geography – RUSSIA
- Note: Created voice based training asset for Neilsen MSci for optimization

Job position : Analytics Manager with IMRB International, Delhi

Jan 2008 - May 2012)

Abacus, IMRB International (Division of Thompson Associates Private Limited, Delhi, India).
- Expertise - Cleaning / Tabbing / Editing of data (Weighting, Data conversions) / Data handling / Quality Checking of output using ‘Quantum / MS Excel’ under DOS environment
- Technicalities - Proficient in scripting and checking of
  - Cross Tabs, Summary Tables, Grids, Jaccards Analysis, Significance Testing, TURF Analysis
  - Scripting of data, Reward-Penalty Analysis, Regression Analysis using SPSS
- Type of projects handled – Link (Ad Test), Adhoc, Product Test, Product Concept Test and Dipstic (3-6 months rotational ATP / Tracker job). Handled More than 110 projects.
- ISO Auditor taking care of Internal audits for two branches Delhi and Gurgaon and making sure that all the projects are getting well documented.

Job position : Junior Analyst

July 2006 - Dec 2006

Annik Technology Services Pvt. Ltd. (KPO), Gurgaon, India.
Expertise - Cleaning/Tabbing/Quality checking of output using ‘Quantum’ under UNIX environment

Expertise

Analytics, Reporting, Presentation, Research papers and white papers writing, Thesis writing.

Software Skills

Worked on SQL, SPSS, Quantum, Quanvert, Lingo, Basic Matlab, Basic R, MS Office (Word, Advance Excel -VBA, Power Point Proficient), DEA Solver

My Competencies

Analytical Ability(L0, L1)
BPS : Building Effective Teams(L0, L1)
BPS : Customer Focus(L0)
BPS : Drive for Results(L0, L1)
BPS : Innovation Management(L0, L1)
BPS : Interpersonal Effectiveness(L1)
BPS : MS Excel (E1)
BPS : People Development(L0, L1)
Initiative / Proactiveness(L0, L1)
Innovation & Creativity(L0, L1)
Lean Six Sigma (LSS)(E1)
Problem Solving(L0, L1)
Process : Environmental Management and Engineering (ISO 14001)(E0)
Quality Management for Delivery(E0)

My Certifications

LDP : Leading Change Foundation
LDP : Critical Thinking Foundation
LDP : Analytical Ability Foundation
LDP : Innovation & Creativity Foundation
LDP : Initiative & Proactiveness Foundation
LDP : Problem Solving Foundation

Languages known

Education

I'm having 24 years of consistent full time education record with throughout first division from one of the best universities in India.

Dept. of Operational Research, Delhi University : Ph.D. (Optimization in Software Reliability) ; 2006-12

Academic performance indicators (API) score – 77 ; Award – Non-NET UGC fellowship (2007-2008).
Thesis title – “Contribution to Some Optimization Problems of Component Selection for Modular Software System and Release Time for System Testing”. Thesis reviewed by IIT Kharagpur, India & by Dr. Hoang Pham, Professor in the Department of Industrial and Systems Engineering, Rutgers University, State University of New Jersey, US.
4 papers published in 'International Journals', 6 papers published in 'National / International Conference Proceedings', 1 is published in Thesis of Deepali Gupta, Department of Operational Research, Delhi University. Attended 4 Workshops, 9 International Conferences & 3 National Conferences on Optimization, Mathematical Modeling & Software Engineering. Presented 12 Research Papers in ‘National & International Conferences’ organized in different states of India.

Kirorimal College, Delhi University : M.Sc Operational Research ; 2004-06

Mewar Institute of Management, Meerut University : B.Ed. ; 2002-04

Vivekananda College, Delhi University : B.A. Mathematics (Hons) ; 1999-02

Hindi and English

My Strengths

Learning and research attitude
Statistical and tools based technical skills
Multiple projects handling skills
Extremely good at documentation of any technical / non-technical record
Communication skills.