Muhammad Omar Email & Phone Number

Canada

Clearstream Energy Services

Working as a DBA and Application Architect to support & maintenance of MS Dynamics GP ERP , and ERP related Add-on and customize application, in addition to support and maintain15 GP dynamics companies databases and other third party application databases.• Worked as a ERP support analyst and played a key role in series of Dynamic GP upgrade form version 10 to GP Dynamics 2013. • Designed & support Dot Net (C#) application “ Mass Time Entry” to support MS Dynamics GP (Jovaco) project accounting module and project invoicing …• Support and troubleshoot daily ERP (PA, A/P, A/R,INV, financial and Payroll) related help desk calls/tickets• Develop and maintain ERP security tasks and roles to ensure end users precise accesses. • Develop and maintain SRS and smart list reports as per requirement…• Support and troubleshoot 3PL warehouse (Oil pipes) management application developed in ASP.net.• In house support of third party application ATS (Application tracking system) • In house support of third party application Cleartrak (Oil pipe fabrication system)• In house support of third party application Dispatch Maintenance (Clearstream Transportation)• Document and understand all third party application business process like requirement analysis, process re-engineering, looking after customization, reports template designing, and backup and recovery strategy.• Maintain all company databases servers’ backups , maintenance , and alert jobs..• Develop and maintain different type of software related documents such as UAT, AS IS and TO BE etc..

Karachi

• Worked as a technical project manager and played a key role in deployment SAP Business one ERP with consultants like requirement analysis, process re-engineering, looking after customization, reports template designing, database selection, hardware selection, infrastructure designing, and backup and recovery strategy.• ERP patch upgrade activity did individually like SAP 2007A to 8.8 then 8.81.• Support Alnoor Group all SAP B1 sever management i.e production server, backup server, development and test server.• Developed high-level solution designs compliant with target architectures and standards for their specific domain of expertise to support the end-to-end business solutions.• Designed Relational Databases based on SQL Server 2005/2008 32 and 64 bit. Developed and optimized stored procedures for those databases. Drove the technical support for all Applications developed on the framework. Led and mentored other technical staff.• Deploy and support SAP business object enterprise to render report scheduling services, document management solution, and dashboard services.• Design to manage hundred of crystal reports on SAP B One and crystal report server for validation, performance testing, and scheduling.• To deploy high availability solution for company databases such as database mirroring, log shipping, replication of different company databases • Database automation tasks scripting scheduling self and with the help on in SAP RSP manager like database backups, gather database statistics, health check and indexing.• Management and quality insurance of database objects store procedure, function and views.

Implementation and support of company databases on Oracle 8i and Sql Server 2000/ 2005.Deployed and developed applications on ASP and oracle developer suite.E-commerce online boutique www.tazeenhasan.com (website support & e-commerce conventional mrktg., affiliation marktg, banners, Search engine listing etc..)Report development on different platforms such as oracle report designer and crystal report Developed different softwares 7 years such as VSR ( Garment buying house software), ABS Apparel costing software, ABS sourcing database and online boutique.Deployed Microsoft Back Office 2000 ,its support and configure different database on it. Designed system infrastructure to meet project requirements.Data Gathering, Evaluation and Reports Development for Management Review.

• Software analysis , requirement engineering an designing of energy plant (power house) to provide actual picture of energy production and fuel consumption.• Support oracle base comprehensive payroll and HR system to calculate attendance , overtime and wages shift wise.• Data loading from MS FoxPro tables to Oracle via sql loader.• Designed Online MIS Reporting System for management.

Master Of Science (Msc)

Bsc (H)

Ms

Diploma In Supply Chain Management

Diploma In Financial & Cost Accounting

Diploma Computer Science