Attachments
no-image-1009
Contact Author Add Favorites Print Share Report
joined 02 years, 01 months, 27 days, ago.
Add Favorites Description

Business Analyst /Data Analyst/Market Research

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

Technical Skills :-

 

           Operating System: Windows Xp, Windows
7.

            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).

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
team

·        
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
analysis

·        
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 –
Data
Analyst ,Date of Employment: April 2011 to March 2012

 

HR Recruitment & Operations. Global
Business

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
Partners

·        
Creating Dashboards for effective HR Decision
making

·        
Analysis of Employee Satisfaction Surveys

·        
Span of Control Analysis

·        
Analysis for HR Reengineering

·        
Analysis for Talent Assessment & Succession
Planning

·        
Automating reports using MS Excel macros (VBA)

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

·        
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
    Macros).

 

Reuters India Pvt Ltd. – Bangalore-
2006 to 2007

 

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

·        
Uploading
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.

·        
Providing
the details to the SOX team based on the data that was uploaded into the
database.

 

EDUCATION / SELECTED PROFESSIONAL
AFFLIATIONS

·        
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)

 

OTHER GENERAL COMPUTER DIPLOMAS:-

1.       Foundation in Window applications from
SPAN COMPUTERS EDUCATION.

2.      
Advance
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
    2006-2007.
  • Won
    best team at zyme solutions Pvt ltd for consistent deliverables &
    automation.
  • Awarded
    with numerous client appreciations

 

 

 

 


Get more with Add-ons

  • no extras
Contact Author Add Favorites Print Share Report