- Can build the system to manage the Warehouse stock based on the location.
- Also additionally have the Order processing, so that as the PO raised and fullfilled, the inventory adds up to the respective Warehouse Stock.
- Based on the stock movements, Purchasing and Sales the running Inventory could be maintined.
- Reorder level for stocks could be set to identify those that are nearing to be Ordered.
- Generation of Purchase Order, Invoicing, printing per the format required, to enable the complete Warehouse management.
- Have done projects related to Inventory, Stocks, Portfolios and provided MS Access and Excel solutions.
Access Skills:
- I have very good expertise in MS Access - GUI, Data entry forms, calculations and reportings.
- Worked on projects Database designing from business proposal, ER diagram, creating Entity relationship, normalization, constraints, indexes.
- Please review my portfolio on the recent projects in Excel and MS Access.
- MS Access - Database creation, tables, forms, queries and reports. Form designing, report designing, Reports generation.
Excel Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Mathematical functions, scientific calculations, index, array, fo