click
Arpan K.
Drop Here

Arpan K.

Excel/VBA/SQL/Data Mining & Visualization

$6.00/hr

Assam, India


Arpan K. has added 6 portfolio piece. Create an account to review them.

*** Awarded Top 25 Provider on oDesk for Sep 2009 ... more*** *** Top Rated status on oDesk for consistent & high-quality work *** - More than 10 years of Access/VBA/Excel/SQL development experience in the areas of finance, IT and retail markets. - Microsoft Excel & SQL experience in application architecture design, table design, and writing queries/stored procedure, forms, and VBA code. - Extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA. - Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry. - Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries. - Extensive experience in developing tools using VBA, Excel environment. - Very strong communication and interpersonal skills, worked with people across the globe including APAC, US and EMEA regions on day-to-day basis. - Automated the process of extracting data from SAP - Strong organizational, presentation and negotiation skills; highly motivated, team player, quick learner. Technical Skills: - KPI Dashboard creation/automation, ad-hoc reporting & analysis - QlikView: QlikView Designer & Developer Version 11.2 - Database: Microsoft SQL-Server 2008, MS-Access - MS Office: Excel (advanced and VBA macros), Outlook & PowerPoint automation - Project Management/Team Management less

Overview

*** Awarded Top 25 Provider on oDesk for Sep 2009 *** *** Top Rated status on oDesk for consistent & high-quality work *** - More than 10 years of Access/VBA/Excel/SQL development experience in the areas of finance, IT and retail markets. - Microsoft Excel & SQL experience in application architecture design, table design, and writing queries/stored procedure, forms, and VBA code. - Extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA. - Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry. - Create VBA programs to automatically ... moreupdate Excel workbooks, encompassing class and program modules and external data queries. - Extensive experience in developing tools using VBA, Excel environment. - Very strong communication and interpersonal skills, worked with people across the globe including APAC, US and EMEA regions on day-to-day basis. - Automated the process of extracting data from SAP - Strong organizational, presentation and negotiation skills; highly motivated, team player, quick learner. Technical Skills: - KPI Dashboard creation/automation, ad-hoc reporting & analysis - QlikView: QlikView Designer & Developer Version 11.2 - Database: Microsoft SQL-Server 2008, MS-Access - MS Office: Excel (advanced and VBA macros), Outlook & PowerPoint automation - Project Management/Team Management less

Arpan K.
Drop Here

Arpan K.

$6.00 /hr

Excel/VBA/SQL/Data Mining & Visualization

Assam, India

Overview

*** Awarded Top 25 Provider on oDesk for Sep 2009 *** *** Top Rated status on oDesk for consistent & high-quality work *** - More than 10 years of Access/VBA/Excel/SQL development experience in the areas of finance, IT and retail markets. - Microsoft Excel & SQL experience in application architecture design, table design, and writing queries/stored procedure, forms, and VBA code. - Extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA. - Proven background translating cell formulas in Excel into ... moreVBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry. - Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries. - Extensive experience in developing tools using VBA, Excel environment. - Very strong communication and interpersonal skills, worked with people across the globe including APAC, US and EMEA regions on day-to-day basis. - Automated the process of extracting data from SAP - Strong organizational, presentation and negotiation skills; highly motivated, team player, quick learner. Technical Skills: - KPI Dashboard creation/automation, ad-hoc reporting & analysis - QlikView: QlikView Designer & Developer Version 11.2 - Database: Microsoft SQL-Server 2008, MS-Access - MS Office: Excel (advanced and VBA macros), Outlook & PowerPoint automation - Project Management/Team Management less

Arpan K. has added 6 portfolio pieces. Create an account to review them.

Work History and Feedback

  • Data Analysis, Data Clean Up & Data Reporting Project

    May 2016 - Present
    Job in progress

    12 hours

    $8.00 / hr
    $97.33 earned

  • Are you a web Sherlock Holmes?

    Sep 2014 - Present
    Job in progress

    200 hours

    $4.44 / hr
    $888.00 earned

  • Seeking Admin Assistance for various projects

    Nov 2013 - Dec 2013
    5.00

    2 hours

    $3.33 / hr
    $6.66 earned

  • Virtual Assistant for Start-Up

    Oct 2013
    5.00
    Hired for test task and did a great job. We just ended up working with another contractor for now.

    1 hour

    $5.56 / hr
    $7.41 earned

  • Statystical Analyst Exceptional Excel VBA Skills

    Jan 2013 - Aug 2013
    3.90
    Arpan has great Excel / VBA skills

    72 hours

    $6.11 / hr
    $200.14 earned

  • Researcher of Nursing Schools

    Jul 2010 - Feb 2013
    No feedback given
    $2.78 earned
    Fixed Price

  • Data Entry and Admin work

    Jan 2011 - Feb 2013
    No feedback given

    43 hours

    $3.89 / hr
    $167.94 earned

  • assistant needed immediately

    Feb 2010 - Feb 2013
    5.00

    331 hours

    $3.33 / hr
    $1,100.53 earned

  • Compilation of Press Cuttings into Report

    Feb 2012 - Nov 2012
    No feedback given

    302 hours

    $5.56 / hr
    $1,676.41 earned

  • Part Time Virtual Assistant Wanted ASAP

    Sep 2010 - Jan 2011
    5.00
    Arpan is a great VA. He followed instructions carefully and timely. The reason I am ending this contract is because I do not have enough work for him at the moment.

    17 hours

    $5.56 / hr
    $94.52 earned

  • 3 articles needed on warrior leveling guide for world of warcraft

    Apr 2010
    5.00
    Job was delivered promptly and met expectations Thank you
    $11.11 earned
    Fixed Price

  • Forum Commenting, 50 Quality Backlinks

    Nov 2009 - Dec 2009
    5.00
    $17.50 earned
    Fixed Price

  • View More (7)

Arpan K. has more jobs to show. Create an account to review them.

Tests

NameScore (out of 5)Time to Complete
English Spelling Test (U.S. Version)5.001st Place!22 mins
Upwork Readiness Test for Independent Contractors and Company Managers5.001st Place!2 mins
Data Interpretation Test4.00Top 10%10 mins
MS Excel 2000 Test3.15Top 10%27 mins
Microsoft PowerPoint 2010 Test3.40Above Average14 mins
Advertising Skills Certification3.20Top 20%6 mins
Help Desk Certification3.40Top 30%29 mins
Microsoft Excel 2010 Test3.90Top 20%10 mins
MS Excel 2003 Test3.40Top 20%27 mins
Organizational Behavior Test2.75Above Average36 mins
Microsoft Word 2010 Test2.75Top 30%9 mins
MS Word 2007 Test3.75Top 20%12 mins
Internet Marketing Test4.10Top 30%7 mins
Windows XP Test4.00Top 10%7 mins
Management Skills Test2.60Above Average6 mins
Search Engine Optimization Test3.10Top 30%9 mins
English Spelling Test (UK Version)4.50Above Average23 mins
Email Etiquette Certification4.00Above Average19 mins
Call Center Skills Test3.60Above Average12 mins
U.S. Word Usage Test2.60Below Average16 mins
Telephone Etiquette Certification3.45Below Average19 mins
Office Skills Test3.75Above Average34 mins
U.S. English Basic Skills Test3.40Below Average17 mins
or
Invite to Job
What's the difference?

74% Job Success
Work History
4,498 hours worked
61 jobs
Availability
Available
More than 30 hrs/week
24 hrs response time
Profile Link
Verifications
Phone Number: Verified
Associated with
Agency logo
InteliBuzz Analytic LLP
Rising talent
115 hours
Search for others