概要

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


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


项目

Dynamics Ax 2012 R2

工作经历

公司标识
Database Consultant / Administrator Database Consultant / Administrator
JeevaySoft (Head Office at United States)
Apr 2021 - 代表 | Santa Ana, California, USA

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. 

公司标识
Senior Database Admin/ Developer
Nova Diagnostics Labs
Apr 2021 - 代表 | Santa Ana, California, USA

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.

公司标识
Assistant General Manager I.T
Metro Shoes
Jan 2020 - Aug 2020 | Rawalpindi, Pakistan

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.

公司标识
Sr. Manager MIS
Metro Shoes
Oct 2015 - Dec 2019 | Rawalpindi, Pakistan

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).

公司标识
Manager MIS
Metro Shoes
Aug 2011 - Oct 2015 | Rawalpindi, Pakistan

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

公司标识
Assistant Manager I.T
Metro Shoes
Feb 2011 - Aug 2011 | Rawalpindi, Pakistan

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.




公司标识
Oracle Programmer
Stylo Shoes
Apr 2009 - Feb 2011 | Rawalpindi, Pakistan

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.

公司标识
Oracle Developer
Ghazi Fabrics International Limited.
Jul 2008 - Apr 2009 | Rawalpindi, Pakistan

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.




公司标识
Computer Operator
Govt. Office of Water Management | Pakistan
Jul 2005 - Jul 2008 | Rawalpindi, Pakistan

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

公司标识
Consulting Programmer/Database Administrator
Boss Textile Mills | Pakistan
Aug 2003 - Jul 2008 | Rawalpindi, Pakistan

Provide consultancy for installation and implementation of system. 
                                       



学历

The University of lahore
硕士, MSc, ‎
2003

技能

熟练 Bi Developer
熟练 Crystal Reports
熟练 CVs Screening
熟练 Data Modeling Design
熟练 Database
熟练 Database Admin
熟练 Database Applications
熟练 Database Design
熟练 Database Integration
熟练 DDL
熟练 DML Script
熟练 Integration
熟练 Linux Platform
熟练 Microsoft RMS 2.0 & POS
熟练 Microsoft SQL Server
熟练 MS Access
熟练 MS Dynamics ax 2012 R2 & R3
中级 MS Power BI
熟练 MS SQL 2005 & 2008 R2 (SSMS, SSAS, SSR
熟练 MS SQL Server
熟练 MS SQL Server Admin
熟练 MSSQL
初学者 MySQL
中级 Oracle
中级 Oracle (EBS 11) Functional.
中级 Power BI
熟练 RDBMS Command
熟练 SQL
熟练 SQL Development
熟练 SSRS
熟练 Troubleshooting
熟练 VB 6.0
中级 VB.Net
熟练 VBA (MS Access , MS Excel)

语言

初学者 旁遮普语
初学者 信德语
中级 英语
熟练 乌尔都语