Muhammad N. Profile

5.0

(10 reviews)

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.

$12 USD / hour

islamabad,

pakistan

$12 USD / hour

It's currently 1:09 AM here

Joined September 13, 2014

1 Recommendation

Muhammad N.

@mna9226

5.0

(10 reviews)

3.2

100%

$12 USD / hour

islamabad,

pakistan

$12 USD / hour

100%

Jobs Completed

100%

On Budget

59%

On Time

18%

Repeat Hire Rate

Excel/VBA | Google Sheets/Script | Data Analyst

Over the last 5 years, I have developed a wide range of Excel reports by using different features. My core competency lies in developing automated Excel (from the ground up or building on existing bases) which are intuitive to use and user friendly, yet very powerful. I am seeking opportunities to automate tedious and complex Excel processes so that you and your business can be more productive. I have extensive experience working with a leading solar company as a senior data analyst in the supply chain department also a superuser of SAP b1. Due to my dedicated focus on analytics solutions, I deliver top-quality, process-driven, and most professional deliverables in the shortest turnaround time. 1. I processed the external audit of approx. 7.4 Million dollars worth and 212 Thousand excel rows and 22 columns of data. 2. Designed a centralized WMS(Warehouse management system) at online google for more than 1000 transactions daily from different regions. 3. Designed a fully automated user-friendly VBA-based excel utility for the production line and its inventory management. 4. I come with extensive domain expertise in Electrical, Solar, Industrial Automation, PLC & supply chain industries, warehousing, production, and Logistics. Please feel free to contact me for references, portfolio, and case studies.

See all Excel Experts in Pakistan

Contact Muhammad N. about your job

Portfolio

Accounting Software

This dashboard is fully automated and completely designed by myself for my valued client by using functions, Pivots, Slicers, Charts, and Form Controls.

Excel Dynamic Dashboard

Although there's the standard functionality of adding, updating, and deleting records manually or by using functions in excel. This straightforward simple and user-friendly Excel database is used to autogenerate invoice and send through email by single click with a QR code.
Below are the main features of this utility.

There is a drop-down menu with having product list.
Users can select products from the drop-down and enter the rest fields.
VBA macro button named "Save pdf and Send Outlook" is available in the main sheet.
The application comes with crystal pdf report extraction and sends through an email with one click with a QR code.

The latter has been proven to be a real helper for me as well.

Invoice with QR Code Excel VBA

GPS Tracker project VBA excel based

Production line project with quotation pdf export

Although there's the standard functionality of adding records manually or by using functions in excel. This straightforward and user-friendly Excel database is used for online food order database management.
Below are the main features of this utility.

Multiple macros enable buttons are displayed one after another on the dashboard.
Export the client email to excel and structure according to data manipulation requirements.
Process the data manipulate the information of the client.
Design the food menu based on client email.
Export the food menu and client in pdf format file by selecting the path.

User interactive VBA based food court database

Accounting Software

Excel Dynamic Dashboard

Invoice with QR Code Excel VBA

GPS Tracker project VBA excel based

Production line project with quotation pdf export

User interactive VBA based food court database

Reviews

Changes saved

Showing 1 - 5 out of 10 reviews

Filter reviews by:

5.0

$40.00 USD

improve an Excel Visual Basic code

excel vba expert. his service is very fast and good. thank you.

Visual Basic

Data Processing

Excel

Visual Basic for Apps

Excel VBA

Ciro I.

@devspeedvisionit

•

1 year ago

5.0

€10.00 EUR

SQL and Excel small challenge

Great data analysis work performed with Excel and pivot tables.

Excel

SQL

Robert G.

@robalegria

•

1 year ago

5.0

£25.00 GBP

Excel VBA expert required

Very good job. It took a little more time but that was fine because the end result was excellent. Communication was very impressive. Step by step communication and if anything was not fully understood, it was raised straight away. Excellent freelancer. It was a pleasure to work with Muhammad.

Visual Basic

Data Processing

Excel

Visual Basic for Apps

Closed User

@Footballdata

•

2 years ago

5.0

$40.00 CAD

VBA Macro 40$ I need my VBA re-coded which doesnt work anymore import, format files, copy paste

Muhammaed worked very hard in order to complete my project and delivered it while listering carefully to directions. Thank him very much for the great effort. Pleasure working with you

Visual Basic

Data Processing

Excel

Software Architecture

Visual Basic for Apps

Hot P.

@hotpastas

•

2 years ago

5.0

$30.00 USD

Design Report - Excel Sheet -- 2

I really enjoyed working with Muhammad. I gave him raw data and idea, and he gave me a great product back. The technical information as well as the design were both great. Thanks for your great work and ensuring my needs are met with the file. I would definitely recommend your work to anyone asking for freelancer and I will be coming back to you for more work as this was really satisfactory, I'm not exaggerating. Sincerely Fadil

Fadil R.

@fadilrexhepi

•

2 years ago

Experience

SKY ELECTRIC (Pvt) Ltd / Islamabad Pakistan

May 2019 - Present

 SAP Data analysis of Sales, Operations, production, warehousing and procurement as SAP Super User.  Create and formulate working instructions for inbound and outbound operations.  Inventory management, designing of Inventory control process, SOP’s and implementation.  Frequent inventory cycle counts, to resolve all discrepancies by consistently conducting reconciliations.  Technical reports writing, business correspondence and procedure manuals.

fb energy Limited

Sep 2021 - Aug 2022 (11 months, 2 days)

• Developing and maintaining databases, and data systems – reorganizing data in a readable format. • Using statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for the diagnosis and prediction. • Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.

SKY ELECTRIC (Pvt) Ltd. / Islamabad Pakistan

Dec 2018 - May 2019 (5 months, 1 day)

 Contribute to Development, Quality Management and/or Testing improvements.  Provide technical guidance to Engineering support and Development team members  Read, analyze and interpret technical documents such as work instructions, correspondence or procedure manual.  Write reports, business correspondence and procedure manuals.  Identifies inconsistencies of production parts.  Supervise & Trained technicians.  Check List, Inspect & Testing the assembled systems.