Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Khushnood Viccaji | Elance
 
176985602337900
Last Sign-in: May 26, 2015

Khushnood Viccaji

Data analytics expert, Excel solutions developer
   India
  |   Mumbai, MAH
  |  7:12 pm Local Time

Overview

Minimum Hourly Rate $20

More than 15 years' experience in Data Analytics and Business Intelligence Can manage complex requirements, and deliver great results; matching, and often exceeding client expectations Specialize in converting raw data into usable business information on which clients can take action.

Specialties:
- Analysis, Audit & Reconciliation of complex and large data sets

- Design & Development of Applications based on advanced Excel features and VBA

- Management Information Systems (MIS) : Design, development and implementation

-...

Read More »
May 19, 2014|Data Analysis|$200|Working
Apr 3, 2014|Data Analysis|$750|Working
Mar 6, 2014|Data Analysis|$40|Completed
|
5.0
Mar 5, 2014|Data Analysis|$80|Completed
|
5.0

View All »

Portfolio

Client required analysis of data gathered from an in-house survey conducted...
Created the interface for navigating in the Excel file, with snippets of description...
Raw data from CSV file converted into a structured, formatted Excel table for enabling...
This sheet showed the Region & Country-wise distribution of survey respondents....
This sheet analysed the opinion of survey respondents to important issues on a scale of...
Created the interface for importing, processing data, & navigating in the system to...
Automated import of data from CSV file, with Data Import feature using VBA
Imported data from CSV file, processed for further use in XLS table, with advanced...
Advanced formulas to perform 'reverse HLOOKUP' on processed data. The screenshot shows...
Processed data from CSV file, collated for further use in a separate XLS table, with...
Created the interface sheet for users to navigate the sales report file which contains...
Setup a Pivot Table based on the Sales Report Database. Radio buttons help to filter...
Setup Multiple PivotTables showing top-level summary information from the Sales Report...
This is the source database, which is created from multiple data sources, using Excel...
A hidden, protected sheet for master data used while processing the Sales Report. Data...
Designed and developed the Invoice template based on information from multiple Sales...
Designed and developed the Order Acknowledgement template based on information from...
Designed and setup the Master Control sheet for the Sales Order Processing System. This...
Client required audit, verification and analysis of data relating to billing for mobile...
Prepped raw data files for batch processing.
Combined raw data from 600+ files into a single table using VBA and Advanced Formulas....
Combined data based on selected columns from stage-2 data. Setup hyperlinks to raw...
Designed and setup Pivot Tables and Charts based on processed data. Analysis of trends...
Designed and setup detailed, site-wise presentation of conditionally formatted data,...
Designed and setup a tracking file for the 600+ source data files. Setup hyperlinks to...

Skills (10)

Tested
Data Analytics
Microsoft Excel
Microsoft Excel 2010 Test
My Score
avg
VBA
Knowledge of Microsoft Office
Knowledge of Microsoft Office Skills Test
My Score
avg
Software Documentation
Enterprise Resource Planning (ERP)
Data Cleansing
Microsoft Word
Microsoft PowerPoint
Editing

Service Description

- Data Analytics
Business data analysis Data consolidation from multiple discrete sources, audit, analysis and presentation in an easy-to-use interface

- Data migration
Extract, Transform and Load (ETL) of corporate data, based on standard or customized business rules and logic

- Custom applications development in Excel using VBA
Sales & Distribution system Customer Master data (mailing lists) Business Receivables Management system Fixed Assets data migration CSV data conversion & analysis

- Design and development of interactive reports from multiple data sources

- Business Process Documentation
System requirements studies, analysis and reports

Samples of my project work are showcased in the portfolio section of my profile.

Read More »

Employment

KZIPL
Director
2012 - Present
Data Analytics Large Volume Data Analysis & Management Systems Requirements Studies Management Information Systems (MIS) Training on MS-Office English language services Editing ...
BrightBridge Advisors
Associate Director
2009 - 2012
Data migration Management Information Systems (MIS) Large Volume Data Analysis & Management Management consulting
KZIPL
Consultant
2008 - 2009
Technical Writing for Business Intelligence & ERP systems
Transweigh (India) Ltd. - TIL
Special Projects Leader
2005 - 2008
Project Leader for implementation of Manufacturing ERP system (IMMS from SourcePro Infotech)
Parker Hannifin India
IT Manager
1999 - 2005
Started as an Information Technology Consultant, developing custom apps in Excel using VBA Project leader for custom Sales & Distribution ERP system design and implementation IT Manager for...

Education

Jamnalal Bajaj Institute of Management Studies
Master's Degree in Financial Management
1990 - 1993
Jai Hind College, University of Bombay
Bachelor of Commerce (Major in Accounting)
1981 - 1986

Keywords

Data analytics
Data analysis
Excel
Excel VBA
Data consolidation
Data de-duplication
Data transformation
Data migration
Master Data Management (MDM)
Survey and Research data analysis
ETL
English language services
My Snapshot
IT & Programming
2
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
5
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
KViccaji
Type
Individual
Member Since
September 2013
Elance URL
Verifications
0
Groups
Khushnood Viccaji | Elance

Khushnood Viccaji