Muhammad Anwer Email & Phone Number

Vaughan, Ontario, Canada

- Designed & developed bi-lingual web application that allows the staff to report an Incident of injury, property damage etc. with all the details required as per company’s policy.- Designed & developed a web application that allows the transport staff to build & finalize a trailer for different stores based on the manifests of the purchased items.- Designed and created SSIS packages to download various excel files from ftp server, moved the data to SQL Server tables, applied business… Show more - Designed & developed bi-lingual web application that allows the staff to report an Incident of injury, property damage etc. with all the details required as per company’s policy.- Designed & developed a web application that allows the transport staff to build & finalize a trailer for different stores based on the manifests of the purchased items.- Designed and created SSIS packages to download various excel files from ftp server, moved the data to SQL Server tables, applied business logic to transform and massage this data, generated the resultant excel files and send them by email to AS400 team, so that they run a process using this file to update Arrival Dates and other details.- Designed and created SSIS packages to read data about the Outstanding Invoices from Payments database using a Linked Server, applied business logic to massage the data and updated the required tables in the ERP system.- Designed and created various SSRS reports along with the email subscriptions that included but not limited to Risk Management Report, Performance Report, Incident Report etc. Show less

Pakistan/Canada

Worked as a contractor on different projects for the clients listed below: Client: ALMAS - Developed Daily Cash Control & Accounts Management module for the retail chain and worked on data entry forms as well as reports. - Using web scrapping & other Data extraction methodologies built a data mart and created dashboards for this RealtorClient: Zaka Pharma - Redesigned existing data entry forms and added new ones to accommodate new business requirements provided by users (in… Show more Worked as a contractor on different projects for the clients listed below: Client: ALMAS - Developed Daily Cash Control & Accounts Management module for the retail chain and worked on data entry forms as well as reports. - Using web scrapping & other Data extraction methodologies built a data mart and created dashboards for this RealtorClient: Zaka Pharma - Redesigned existing data entry forms and added new ones to accommodate new business requirements provided by users (in their existing ERP (Pharma) system), - Created a data-mart and loaded data using ETL from ERP and third party GL and payroll systems.Using this new data mart, created new reports and dashboards.Client: ALMAS - For A3 Retail System, analyzed, designed and developed required new features in Point-of-Sale application as well as new reports related to Invoices, Sales Trends and Returns. Integrated all Sales and Return transactions with Government Revenue department’s system using Restful APIs Show less

Toronto, Canada Area

Key design and development role in CASSI's Online and Outage modules, their implementations for various clients and future roadmap

Edmonton, Toronto Canada

Alberta Mineral Information (AMI)-Enterprise Level System Managing Royalty Agreements, Oil Wells and Other Mineral Contracts

Toronto, Canada Area

Patient Tracking System (RF Devices Integration)- Designed and developed MVC based front end application (Patient Activity Monitor)- Worked closely with the client to elicit the requirements and designed the overall architecture.- Wrote classes to integrate RF Scanner with the front end application.- Designed and developed the database.- Created and implemented SSIS packages to import doctors’ and patients’ data from EMR (Electronic Medical Record) systems into our… Show more Patient Tracking System (RF Devices Integration)- Designed and developed MVC based front end application (Patient Activity Monitor)- Worked closely with the client to elicit the requirements and designed the overall architecture.- Wrote classes to integrate RF Scanner with the front end application.- Designed and developed the database.- Created and implemented SSIS packages to import doctors’ and patients’ data from EMR (Electronic Medical Record) systems into our database.- Using code first strategy in entity framework, designed the Model classes Infusion Soft Data Import Utility- Wrote a console application using the Infusion Soft API in order to import the newly added data into the cloud. Created classes to read and massage data from flat files. Show less

Pakistan

- Worked closely with users, senior management and development team to elicit business requirements for the development of in house ERP and BI Solutions.- Defined and documented business processes and developed Functional requirement specification documents.- Worked with marketing department and developed the BI solutions for the marketing team.- Designed, developed and implemented Web based Marketing, Distribution and Sales Execution modules.- Developed SSIS System to integrate… Show more - Worked closely with users, senior management and development team to elicit business requirements for the development of in house ERP and BI Solutions.- Defined and documented business processes and developed Functional requirement specification documents.- Worked with marketing department and developed the BI solutions for the marketing team.- Designed, developed and implemented Web based Marketing, Distribution and Sales Execution modules.- Developed SSIS System to integrate sales & stock data from different heterogeneous systems running at distributors’ offices- Developed and implemented Reporting System, having various sales analysis and trend analysis reports for the marketing department to help them in marketing strategies and campaigns.- Integrated in house developed modules with third party software- Wrote complex algorithms for the calculations of incentives of the Sales Force - Created extensive BI reporting using Crystal Reports and SSRS for different departments - Wrote extensive SQL Server stored procedures and triggers Show less

Pakistan

- Worked with other developers to implement CRM application using the UnifyCRM technology for a real estate builder in Dubai. Also developed property website for this client- Worked on different modules of UnifyCRM as designer and developer.

Greater Chicago Area

- During my employment with Wintel Systems, I worked as a consultant on different projects for few clients.

Pakistan

- Analysed the existing manual system for Ordering, Invoicing and Returns in Schazoo.- Designed, developed and implemented this system in Accounts, Sales and Inventory sections.- Developed and implemented Distribution Retail System for Retail Zaka Mall.

Greater San Diego Area

- Worked on various projects including MEPS and infomart as software engineer.- Designed and developed databases, data entry forms, web pages and reports.

Master Of Science (M.Sc.), Computer Science

Education record