Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project
EXPLORE
Data Processing Excel Testing / QA 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 10:41 PM here
Joined October 10, 2012
132 Recommendations

Jay P.

@jaylancer43

annual-level-four.svgpreferred-freelancer-v2.svgverified.svg
5.0 (913 reviews)
9.3
9.3
$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 AUD
Good understanding of project. Timely communication and delivery.
Data Entry Excel Web Scraping Data Mining HTML
N
Flag of James C. @NanoVacuum
23 days ago
5.0
$1,170.00 AUD
Great freelancer very knowledgeable with Excel!!
Data Processing Data Entry Excel
L
Flag of Rhys W. @latitude28
2 months ago
5.0
$150.00 USD
Fantastic work as always! Very clean and works fast A+
Visual Basic Data Processing Data Entry Excel Web Scraping
+1 more
R
Flag of Daniel F. @rafiki1347
2 months ago
5.0
£200.00 GBP
Jay has completed another project for me to the highest standards within the time agreed. The macro does exactly what I need it to do without any issues. Thanks again Jay.
Excel Web Scraping Excel VBA Excel Macros Data Scraping
W
Flag of James T. @wonderfulmanuk
2 months ago
5.0
€900.00 EUR
thoroughly and faster than promised
Data Entry Web Scraping Data Mining
User Avatar
Flag of Marjolein M. @MarjoleinMos
2 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 877 Visual Basic 539 Data Processing 502 Visual Basic for Apps 381 Testing / QA 312

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 © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.