Contact Author Add Favorites Print Share Report
joined 03 years, 11 months, 26 days, ago.
Add Favorites Description

Business Analyst /Data Analyst/Market Research

  • 1 days Will deliver in:
  • 100% Rating (0 review)

Technical Skills :-


           Operating System: Windows Xp, Windows

            Databases: Microsoft Sql
server 2000, 2005 and MS-Access 2010

             Additional tools: MS Word- 2010/MS
Excel-2010/MS-Power point- 2010 / MS-Visio-                                  2007/MS-Project-2007

Statistical Tools: – SPSS, R and Excel
(Visual Basic for Applications (VBA) or Macro Level Language for Excel, Advance

Excel Addins: – Asap Utilites

Professional Experience

Company –   Nichepro Technologies Pvt Ltd (Outsourcing
Partner for major US clients for medical devices, Pharma, insurance)

Designation – 
 Senior Team leader

Date of Employment: 18th June 2012 till Date


Worked with data for major US medical devices
and pharma companies like (GSK, Abbott, bayer,) and insurance giant like Colonial
Life & Accident Insurance Company.

Requirements gathering and project planning

Team Handling and Project Management

Managing Rewards & Recognition process of my

Preparing PowerPoint presentations &
presenting in front of Business Leaders/Higher Management

Coaching/Mentoring junior members of the team
size 5

Designing the database, creating database,
writing sql queries like joins , subqueries, T-Sql  Statements( Cursors, Triggers, Stored
procedures), Uploading data using CSV format file into Sql Server database.
Creating database using MS-access for reporting purposes.Pulling data from
various data source using SQL queries, cleaning and preparing that data for effective

Automating recurring analytical tasks using R/MS
Excel/MS Access/VBA

Providing trainings on Statistics/Excel to
members within and outside of my team

Creating statistical models (using correlation,
standard deviation, mean, Regression-Coefficient, intercept) to forecast
revenue at different units of sale and present data using scatter diagrams
using statistical tools like Excel, R.

Construct model from sample sizes to calculate Chi
square test , anova statistical analysis to accept or reject the sample.

Forecast sales using moving averages (like 3,4
moving average), statistical models for weighted average for sales, unweighted
average for sales, percentage for sales. This is done to analyze actual and
forecasted sales.

Forecast sales using exponential smoothing and
present forecast of data at alpha levels.

Construct data using different graphs like
scatter plots, histogram, bar-chart, trend lines, box-plot  using Excel and R.

Forecast weekly sales, monthly sales and quarter
to quarter sales comparisions using the different statistical calculations.

Good knowledge of various statistical formulas
like mode, median, average, chitest, linest, trend ,variance, averageif,
correl, rank , slope, confidence etc..

Construct  statistical models to predict the revenue
spent for each quarters and models constructed to understand the behavior of
customer on purchases based on income using Excel and R.

Analyzing the characteristics of Categories and
grouping them based on Cluster Analysis and Correlation study using Excel.


Company – ORACLE
INDIA PRIVATE LTD ( Mafoi- On contract basis) Designation –
Analyst ,Date of Employment: April 2011 to March 2012


HR Recruitment & Operations. Global

Major Responsibilities/Projects:

Analysis of Human Resource data

Working with HR Business Partners and US, EMEA
(European) Counterparts

Requirements gathering and End to End execution
of analytical projects

Predicting attrition risk using Logistic
Regression, Descriptive statistics.

T-test/ANOVA analysis to uncover Gender bias,
Ethnicity bias, etc.

Creating Balanced Scorecards for HR Business

Creating Dashboards for effective HR Decision

Analysis of Employee Satisfaction Surveys

Span of Control Analysis

Analysis for HR Reengineering

Analysis for Talent Assessment & Succession

Automating reports using MS Excel macros (VBA)

Building MS Access based application (both
backend and frontend) for capturing and analyzing Merger & Acquisition

Ad-Hoc & Business As Usual Analysis

Providing trainings on Excel/Access/VBA to
members within and outside of my team

Also involved in large amounts data mapping,
cleaning ,validation project.


Company – Zyme
Solutions Pvt Ltd ,Designation – Senior Business Analyst ,

Date of Employment: 2007 to  2011


I have worked as a Senior Analyst in
Various Client Projects like RSA (Owned by EMC2), Sling Media (The broadband
& home entertainment solution provider in U.S.) & Logitech (The
computer peripherals giant).

To Support the Six Sigma Team with their
Analysis tasks. Used DMAIC and DMADV models

Processing all the issues related to
the portal running for the claims and rebates

Execute the production process
according to process documentation, quality assurance procedures to ensure
sustainable, high quality deliverables.

Have written manual and documentation
of the process using the MS-Power point & MS–Word. Also played active role
in meeting the SAS 70 audit compliance guidelines.

Helped to analyze and create management
reports for Sales that helped the client to forecast the sales, inventory &
Year-On-Year revenue comparison for that particular week.

Designed the data consolidation and
reconciliation process for every distributor. Automated the process using the
MS-Excel Macros. Achieved 100% accuracy in processing work this process
became foundation for six sigma green belt project. Involving various factors
like time (Client SLA) and accuracy in processing.

  • Developed
    customized GUI (Graphic User Interface) application using MS-ACCESS
    database tool & named the application as ‘Exception Handler tool’. This database would store huge amount
    of Client SKU’s (stockable units) and data can be downloaded in various
    formats like Excel, Notepad & word based on the date queries when it
    was uploaded into the main database. MS-Excel was used as the interface to
    upload the data into the database & prepared the documentation so that
    other team members can use the application at ease.
  • Knowledge
    and implementation of power point templates presentations and excel
    features like Report manager, Pivot table, Lookup, Vlookup,  Hlookup, 
    Countif, Sumif, Validations, Array formulas, database formulas,
    Trim, Right, left and various other formulas used in the day to day
    business. Designing the worksheet with various GUI objects, charts and
    other basic logical and group formulas. (Creating and recording the


Reuters India Pvt Ltd. – Bangalore-
2006 to 2007


Worked in their
accounts Payables process supported for four different regions NA, EMEA, EMBU

the data into Oracle applications, testing the database (involved in UAT),   preparing the reports, Creating and
designing the MS-Access database based on the business requirement.

the details to the SOX team based on the data that was uploaded into the



Master of Commerce (M.Com) from Akhila
Bhartiya Shiksha Sansthan (A.B.S.S.), New Delhi-44 with 63% of Marks (2002-2004)
(Duration of 2 Years).

Post Graduate Diploma In Business Administration
(P.G.D.B.A & P.G.D.C.A) (In Finance) from Akhila Bhartiya Shiksha Sansthan
(A.B.S.S), New Delhi-44 with 66% of Marks ( 2000-2002) (Duration of 2 Years).

Bachelor Degree In Business Management
(B.B.M) (In Finance) from Bangalore University with 58% of Marks (1996-1999)
(Duration of 3 Years).

(Akhila Bhartiya Shiksha Sansthan
(A.B.S.S) is an autonomous body not approved, Recognized  by UGC & AICTE, But recognized under SR
ACT –1860)



1.       Foundation in Window applications from

Diploma In Computers from Software Technology Group (STG)


Organizational Achievement :-


  • Awarded
    for best process improvement in Nichepro
    Technologies Pvt Ltd for the year 2013-2014
  • During
    my tenure in Reuters won the best team for Payables processs for the year
  • Won
    best team at zyme solutions Pvt ltd for consistent deliverables &
  • Awarded
    with numerous client appreciations





Get more with Add-ons

  • no extras
Contact Author Add Favorites Print Share Report