Noman A. - Excel Expert | Analytics Expert | Data Analyst

Noman A.

Excel Expert | Analytics Expert | Data Analyst

Pakistan | Asia/Karachi (USD)

$9/hr
Part-time:10-30 hrs/week
0, Followers

ABOUT ME

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, portfolios, and case studies.

SKILLS

  • MS Excel
  • Excel Experts
  • Microsoft Excel
  • Excel
  • AutoCAD
  • Home Automation

    • EMPLOYMENT HISTORY OUTSIDE OF TOOGIT

    Deputy Manager SCM

    Deputy Manager SCM - Sep, 2021 to present, Islamabad Pakistan

    Assistant Manager SCM

    SKY ELECTRIC (Pvt) Ltd - May, 2019 to Sep, 2021, Islamabad Pakistan

    Technical Lead

    SKY ELECTRIC (Pvt) Ltd - Dec, 2018 to May, 2019, Islamabad Pakistan

    SR. ELECTRICAL TECHNICIAN

    SKY ELECTRIC (Pvt) Ltd - Feb, 2017 to Nov, 2018, Islamabad Pakistan

    OWNER/CEO

    AQ TECH - Aug, 2014 to Nov, 2016, Islamabad Pakistan

    ASSOCIATE ENGINEER

    TALHA ELECTRIC COMPANY - Dec, 2013 to Jun, 2014, Islamabad Pakistan

    EDUCATION HISTORY

    B-Tech (Hons), Electrical

    (2013 - 2015) Preston University, Islamabad Pakistan

    B-Tech (Pass), Electrical

    (2011 - 2013) Preston University, Islamabad Pakistan

    BS, Computer Science

    (2009 - 2010) Virtual University, Islamabad

    DAE , Electrical

    (2005 - 2008) International Islamic University, Islamabad Pakistan

    F.sc, Pre-Engineering

    (2007 - 2009) Allama Iqbal Open University, Islamabad

    Matric, Science

    (2002 - 2004) FBISE, Islamabad
    Although there's the standard functionality of adding, updating, and deleting records manually or by using functions in excel. This straightforward and user-friendly Excel database is used to handle GPS tracker records. Below are the main features of this utility. The user import the file extracted from the GPS tracker. Manipulate the data and do the calculations. The attractive dashboard visualizes the data of the GPS tracker. Multiple macros enable buttons are displayed one after another. The user may extract different reports with a double click. The latter has been proven to be a real helper for me as well.
    Although there's the standard functionality of adding, updating, and deleting records manually or by using functions in excel. This straightforward and user-friendly Excel database is used to handle Inventory. Below are the main features of this utility. The user may add/Update/delete records by single-clicking on the desired button on the main page. Multiple macros enable buttons are displayed one after another. The application comes with quotation extraction in pdf format file with one click based on production. The latter has been proven to be a real helper for me as well.
    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.
    Complex and automated online google based excel utility for the management of material resource planning(MRP) forecasting about 1100 inventory items with inventory level, lead time.
    This is a complex and powerful summarize Excel database of complete year for inventory audit of approx. 7.4 Million dollars (1183 Million Pakistani Rupees) worth having 212 Thousand excel rows x 22 columns of data. Which consists of inventory movement flow with their financial aspect.
    This is a professional summarized weekly based nationwide warehousing report, where different transactions are displayed on a single page with aging and progress, thus providing a clear and direct picture of a big variety of separate metrics that can reveal risks and issues that could become a real problem in the near future.
    A fairly simple database for a production line department. Attachments have been added to meet the client's need to manage the production process.
    Complex and automated online google based excel utility for the management of material resource planning(MRP) about 1100 inventory items with inventory level, lead time, inventory status & ordering status with conditional formatting alerts.
    An online excel inventory ledger database that integrates a lot of useful information with daily basis inventory movement, Opening, and Closing balance.
    Although there's the standard functionality of adding, updating, and deleting records manually or by using functions in excel. This straightforward and user-friendly Excel database is used to handle Inventory. Below are the main features of this utility. User restricted with password protection by using user input from and macros. The user may add/Update/delete records by single-clicking on the desired button on the main page. Multiple macros enable buttons are displayed one after another. The application comes with different crystal report extraction and email sharing option with one click. The latter has been proven to be a real helper for me as well.

    Hire similar freelancers

    Explore and buy related freelance services