Freelancer logo
Log In Sign Up
Post a Project
EXPLORE
Data Processing
Excel
Testing / QA
Visual Basic
Visual Basic for Apps
Profile cover photo
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
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

Jay P.

@jaylancer43

annual-level-four.svgverified-v2.svgpreferred-freelancer-v3.svg
5.0
1016
9.5
9.5
100%

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

$60 USD / Hour
・
Flag of
India (9:41 AM)
・
Joined on October 10, 2012
$60 USD / Hour
・
Hello, I am Full Time Expert Techno-Functional Freelance Analyst having in-depth Experience in various programming languages including VBA/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
Verifications
On time
100%
On budget
99%
Accept rate
88%
Repeat hire rate
29%
Freelancer Excel Experts India
See all Excel Experts in India

Portfolio

Portfolio

5936316
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
2905037
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
9499732
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
9500105
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
9500053
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
9485717
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
5936316
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
2905037
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
9499732
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
9500105
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
9500053
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
9485717
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
Changes saved
5.0 · 1016 Reviews
Reviews
W
Soccer Fixtures Data Collection from Coral • £400 GBP
Jay P is an amazing freelancer, who delivers to the highest standards every time without fail. My project was completed within the time agreed and communication was maintained. The macro does exactly what it is required to do effortlessly. Thanks again
James T.
@wonderfulmanuk
•
Flag of
Chesterfield, United Kingdom
•
6 days ago
Share
S
Excel Automation for Rolling-over valuations & PDF • £150 GBP
Great Excel skills, delivered my project quickly and great communication.
Shahid S.
@Shahid900
•
Flag of
Newham, United Kingdom
•
7 days ago
Share
S
Horse Mortality Insurance Quote Worksheet • $11,300 USD
Jay was professional and a pleasure to work with. His timeliness and attention to detail were huge assets in this project.
Sarah R.
@SMRajoy33
•
Flag of
Aiken, United States
•
9 days ago
Share
User Avatar
Split CSV File into Smaller Parts • $100 USD
This was a great project from start to finish. Jay communicated well, worked quickly and delivered on time and as promosed. A+
Jeff C.
@kawiconsulting
•
Flag of
Gallatin, United States
•
14 days ago
Share
J
Job Data Scraping into CSV • $700 AUD
Incredibly fast delivery and work 100% to specifications plus above and beyond customer service. Thanks Jay! Would highly recommend.
Jackie T.
@Jackdees2023
•
Flag of
Ashgrove, Australia
•
27 days ago
Share
Experience
Business/Data/Reporting Analyst
Mar, 2016 - Present
•
8 years, 9 months
iPersevere Solutions
Mar, 2016 - Present
•
8 years, 9 months
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.
Mar, 2016 - Present
•
8 years, 9 months
Business Analyst
May, 2010 - Jan, 2016
•
5 years, 8 months
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
May, 2010 - Jan, 2016
•
5 years, 8 months
Fluous Solutions Pvt Ltd
Mar, 2007 - May, 2010
•
3 years, 2 months
Business Analyst
Mar, 2007 - May, 2010
•
3 years, 2 months
Worked as Business Analyst for a Product Based Software Company.
Mar, 2007 - May, 2010
•
3 years, 2 months
Education
University of Wales, Cardiff
2006 - 2008
•
2 years
Masters in Business Administration
Flag of
United Kingdom
2006 - 2008
•
2 years
Nagpur University
2000 - 2004
•
4 years
Bachelor of Engineering
Flag of
India
2000 - 2004
•
4 years
Qualifications
How to gather and document requirements
2013
The George Washington University School Of Business
How to gather and document user requirements
2013
Business Analyst
2012
George Washington University
Completed Business Analyst certification successfully.
2012
Publications
Impact of Portable ICTs on Learning and Productivity.
MBA Dissertation
Impact of Portable ICTs on Learning and Productivity.
Certifications
P
Preferred Freelancer Program SLA
Basic Numeracy - Level 1
Basic Numeracy
JavaScript - Level 1
JavaScript
US English - Level 1
US English
E
Employer Orientation Exam
SQL - Level 1
SQL
Data Entry
Data Entry
US English - Level 2
US English
UK English - Level 1
UK English
Freelancer Orientation
Freelancer Orientation
Google Drive - Level 1
Google Drive
Requirements Engineering - Level 1
Requirements Engineering
PHP - Level 1
PHP
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo South Africa / English
Help & Support
Freelancer
Categories Projects Contests Freelancers Enterprise AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App
About
About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers
Terms
Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges
Partners
Escrow.com Loadshift Warrior Forum
Apps
Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 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.