Having a strong knowledge about Databases development in MS Servers & Oracle , System Integration, Dashboard & Reporting development, Microsoft Dynamics ax 2012 functional and 20+ years experience in Information technology field.
Special Skills:-
Databases:-
1-MS SQL (SSMS, SSAS, SSRS, SSIS)
2-MySQL( Replication)
3-Oracle
4-MS Access.
ERPs:-
1-Dynamics ax 2012.
2- Oracle (EBS 11) Functional.
Retail.
1. Microsoft RMS.
2. Microsoft Dynamic ax. Developments
Tools:-
1- VB.Net
2- VB 6.0
3. VBA.
4. VBS.
5. Oracle Developer Forms 6i.
6. Oracle EDI.
7. MS Crystal Reports (RDP & RDC)
8- MS Power BI
Managing Databases (MS SQL Server, My SQL) of different clients at different locations in Health Sector. Designing System Automated Reports and Dashboards. System Integrations and auto alerting reports.
On the behalf of Jeeway Enterprises (Pvt) Ltd
I am Remote working at NovaDx.
NovaDx is a leading diagnostics lab that is working under FDA and BIOHAZARD.
I have successfully integrated (real-time) web based LIMS System with MS Server at NOVS DIAHNOSTICS LABS
(https://novadiagnosticslabs.com/)
Developed an automated reporting structure (Dashboards & Alert system), by using SFTP , MS Power BI , SSAS, SSIS, SSMS, SSRS skills.
My core development in this origination is auto sending the different types of reports in different formats (excel as well as HTML) to all clients (nominated Authorities).
System is working same like a reporting person as well as AI DBA.
Additional functions of this developed system are:-
1- Auto database performance tuning,
2- System consumed and remaining space for database analysis take.
3- Auto actions and inform to Database Admin by email.
Its work same like a artificial intelligent System.
Leading Metro Shoes I.T Department at country (Pakistan) level. I was monitering 55+ outlets in 27 cities. I was developed a comprehansive BI tool and Dashboard for the company during this session.
Supervising all types of customizations in dynamics ax 2012 R2, new developments as per End user requirements Data movement and troubleshooting in company ERP (AX 2012 R2).
Metro Shoes is one of the leading ladies fashion footwear retail brand in Pakistan dealing in Ladies Shoes and Hand bags. It is operating in 12 cities with 40+ company operated outlets. I was responsible for Database and Retail Software, during my job I have developed under mentioned utilities. • MS AX 2012 R2 PO Status Integration with web portal. • MS GP 2010 Check Printing • SQL Intelligent • MS RMS & MS GP2010 Vendor Integration Customization • MS RMS 2.0 & MS GP2010 Purchase Order Integration Customization. • DBA Assistant (MS SQL Server 2008 R2) • Reorder/ Negative Stock Alert • RMS Article Life Cycle/ Discount Stage • RMS Integration with Metro Web
During my job I was responsible for whole Metro Shoes Database/ Software, during my job I have developed under mentioned utilities.
. • PO Planner. • RMS Assistant.
During my job I was responsible for Oracle EBS (Financial) & MS RMS Databases; I have developed lot of reports and under mentioned utilities.
• Integration between Oracle EBS & MS RMS module (AR, AP, Expenses) • DBA Assistant.
I was responsible for Development and Troubleshot on Existing running (Accounts, Payroll, Inventory, Personal, Inward /Outward and Dispatch System) Modules in Oracle 10g, Form 6i and Reports 6i according to End Users.
Collect telephonically current status of watercourses compile that status and send the summery to Head Office at Lahore, Regional office PMU Gujranwala & District Co-ordination Officer Mandi Bahauddin
Provide consultancy for installation and implementation of system.