Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project
EXPLORE
Data Entry Data Processing Excel Visual Basic Visual Basic for Apps
Profile cover photoundefined
You're now following .
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$60 USD / hour
Flag of INDIA
nagpur, india
$60 USD / hour
It's currently 11:50 PM here
Joined October 10, 2012
106 Recommendations

Jay P.

@jaylancer43

annual-level-four.svgpreferred-freelancer-v2.svg
5.0 (899 reviews)
9.2
9.2
$60 USD / hour
Flag of INDIA
nagpur, india
$60 USD / hour
100%
Jobs Completed
99%
On Budget
100%
On Time
29%
Repeat Hire Rate

#1 in Excel-VBA Macros-Python-Web Scraping-Gsheets

Hello, I am Full Time Expert Techno-Functional Freelance Analyst having in-depth Experience in various programming languages including Macro Programming for entire MS Office suite including: - Excel - Word - Powerpoint - Outlook - MS Access As Excel Expert I can build complete solution for your various complex problems running on click of button. I build automated Web Scrappers by means of most efficient and fastest methods. I perform end to end functional testing of applications and websites. Additionally I have expertise in PHP, MySQL, HTML, CSS and Java too. I provide long term support for the developed solutions. I am always reachable on freelance chat. Please Hire Me if you would like to further discuss any prospect. Thanks, Jay
Freelancer Excel Experts India

Contact Jay P. about your job

Log in to discuss any details over chat.

Portfolio Items

Successfully completed Business Analyst certification affiliated from George Washington University, US. Course included techniques and method on how to carefully gather user requirements to eliminate gaps and cover full scope of work that need to be done. It requires good comprehensive skills associated with technical knowledge and subject matter expertise for the job.
2. George Washington University, US
I did my MBA affiliated with University Of Wales, UK with a dedicated research and dissertation submitted on the topic "Impact of portable ICTs on learning and productivity" measuring how the portable information and communication technology devices impacts on learning and productivity. The research constituted of reviewing questionnaire and feedback from 100+ live users from different arenas like Healthcare, Finance, IT, Sales, Marketing, Finance, Human Resource etc.
1. MBA - University Of Wales, UK
Jewellery auctions scrapper for antique jewellery costing more that $100,000 hosted on London, Hong Kong, Milan, Vegas, New York. The scrapped data included images and gem and price analysis with origin. The brands were shortlisted for Cartier, Van Cleef & Arpels, BULGARI, Harry Winston.
Jewellery auctions scrapper
Automatically fetching from API on click of button for multiple stock exchanges like AMEX, NASDAQ, NYSE. Provision to specify custom dates and custom parameters to fine-tune the results.
AMEX NASDAQ NYSE Scrapper
Automatically fetching from API on click of button for multiple stock exchanges like AMEX, NASDAQ, NYSE. Provision to specify custom dates and custom parameters to fine-tune the results.
AMEX NASDAQ NYSE Scrapper
Automatically fetching from API on click of button for multiple stock exchanges like AMEX, NASDAQ, NYSE. Provision to specify custom dates and custom parameters to fine-tune the results.
AMEX NASDAQ NYSE Scrapper
Created a fully automated product catalog that generated index and product sheets automatically upon adding new products to all products tab. Based on the category the products are either created on new tab or appended to existing tab.
Automated Products Catalog
Assisted with the creation and updates of a dynamic userform based application to input and track industrial filter cleaning activity for a set of multiple staff working on different position and different shifts
Multi Level, Multi Tabbed Userform

Reviews

Changes saved
Showing 1 - 5 out of 50+ reviews
Filter reviews by: 5.0
£250.00 GBP
Jay P has delivered another fantastic project on time to the highest standards, Jay took the time to fully understand my project before committing himself to the project. Jay maintained full communication responded to all my queries within a reasonable time. Jay takes pride in his work and he is very passionate about his work and knows his stuff. Thanks again.
Excel Web Scraping Excel VBA Excel Macros Selenium Webdriver
W
Flag of James T. @wonderfulmanuk
18 days ago
5.0
$15,300.00 AUD
Brilliant work from Jay ... always willing to assistance beyond the scope and the detail in the output is first class.
Visual Basic Data Processing Data Entry Excel Web Scraping
+1 more
D
Flag of Derryn B. @dbrook1
2 months ago
5.0
$500.00 USD
Jay Did an amazing job and worked with me in a time crunch.
Visual Basic Data Processing Data Entry Excel Web Scraping
+1 more
A
Flag of Antonio D. @antoniod2
2 months ago
5.0
$500.00 USD
It is always a pleasure to work on excel projects with Jay!
Visual Basic Data Processing Data Entry Excel Web Scraping
+1 more
A
Flag of Antonio D. @antoniod2
2 months ago
5.0
$750.00 USD
Jay worked with me on this complex project and delivered exactly what we needed, highly recommended!
Visual Basic Data Processing Data Entry Excel Web Scraping
+1 more
A
Flag of Antonio D. @antoniod2
3 months ago

Experience

Business/Data/Reporting Analyst

iPersevere Solutions
Mar 2016 - Present
I am expert techo-functional analyst having 10+ years of experience in Excel and VBA Programming. I have sound knowledge of other programming fields like PHP, HTML, SQL and accordingly I am an expert Software Tester too. I manage a team of related associates who are equally proficient in all the above mentioned fields.

Business Analyst

Capgemini Consulting India Pvt Ltd
May 2010 - Jan 2016 (5 years, 8 months)
I worked as Business Analyst into several domains, programming fields and ERPs like Oracle Apps, IFS Apps

Fluous Solutions Pvt Ltd

Business Analyst
Mar 2007 - May 2010 (3 years, 2 months)
Worked as Business Analyst for a Product Based Software Company.

Education

Masters in Business Administration

University of Wales, Cardiff, United Kingdom 2006 - 2008
(2 years)

Bachelor of Engineering

Nagpur University, India 2000 - 2004
(4 years)

Qualifications

How to gather and document requirements

The George Washington University School Of Business
2013
How to gather and document user requirements

Business Analyst

George Washington University
2012
Completed Business Analyst certification successfully.

Publications

Impact of Portable ICTs on Learning and Productivity.

MBA Dissertation
Impact of Portable ICTs on Learning and Productivity.

Contact Jay P. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

preferredfreelancer-1.png Preferred Freelancer Program SLA 1 94% numeracy_1.png Basic Numeracy 1 90% javascript_1.png JavaScript 1 88% us_eng_1.png US English 1 88% employer_orientation.png Employer Orientation Exam 1 85%

Top Skills

Excel 865 Visual Basic 535 Data Processing 495 Visual Basic for Apps 381
Data Entry
177

Browse Similar Freelancers

Excel Experts in India
Excel Experts
Visual Basic Developers
Data Processing Executives

Browse Similar Showcases

Excel
Visual Basic
Data Processing
Visual Basic for Apps
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection
Loading preview