Currently I am working as Techno Functional Team Lead at Pakistan Fruit Juice Head Office. Four companies are managed in SAP (one for each business unit) and I am responsible for all functional and technical responsibilities of all four companies. At PFJ SAP is implemented with HANA database at backend. I am also working on high end Analytic and Decision Making Reports and Dashboards and Reports development using Power BI.Also implemented integrate of Sales & Distribution 3rd Party Software with SAP by coordinating with S&D Team and SAP Consulting Firm (HCC). My job responsibilities include the following:• Complete Preparation of HANA Server (Installation of SUSE Linux, HANA Database, SAP ERP)• Auto Mail Configuration on HANA and SAP ERP• System Analysis, Design and Implementation• Implement checks and controls using stored procedures• All Stored Procedure writing as per SAP implementation team requirements.• Uploading data using Data Transfer Workbench (DTW)• UDF and UDT design as per system requirements.• Automatic Data display in particular fields by using FMS• Crystal Reports development as per User, Management and system requirements with expert skill level• Scheduling Reports auto mail• HANA database backup monitoring.• SAP user creation and granting required rights.• SAP Dashboard design as per higher management requirements.• SAP KPI design as per higher management requirements.• High End Analytic Dashboard development using Power BI.• SAP user problem troubleshooting.• Conducting End User Trainings

Currently I am working as Techno Functional Team Lead at Samad Group at Samad Apparel Unit. I am fully participating in SAP ERP implementation in SAMAD Apparel which involves process study and implementation support with SAP implementation team with HANA database at backend.I am also working on high end Analytic and Decision Making Reports and Dashboards and Reports development using Power BI.This work include the following:• System Analysis, Design and Implementation• Implement checks and controls using stored procedures• All Stored Procedure writing as per SAP implementation team requirements.• Uploading data using Data Transfer Workbench (DTW)• UDF and UDT design as per system requirements.• Automatic Data display in particular fields by using FMS• Crystal Reports development as per User, Management and system requirements with expert skill level• HANA database backup monitoring.• SAP user creation and granting required rights.• SAP Dashboard design as per higher management requirements.• SAP KPI design as per higher management requirements.• High End Analytic Dashboard development using Power BI.• SAP user problem troubleshooting.• Conducting End User Trainings

Worked as Assistant Manager to overcome the database development and maintenance needs of the organization. This work includes, create and maintain databases and database backups (hot backups and cold backups) using RMAN and manually, database recovery in case of failure, create and maintain online and offline standby databases, recover standby databases when needed, create and maintain scheduled jobs for the databases, create and maintain materialized views, create and maintain procedures according to the requirements of the development team, create database users and maintain their database privileges, database installation and patching and create and maintain new database objects, configure and maintain data replication using streams.• Active member of a large DBA team to entire satisfaction of seniors and organization.• Working for 24/7 database availability on Windows 2003 Server and Linux operating systems.• Configure and deploy Oracle Servers on Windows and Linux OS.• Oracle Dataguard implementation and maintenance.• Configure and maintain RMAN backups and Recovery using RMAN backups.

Worked as Officer DBA to overcome the database development and maintenance needs of the organization. This work includes, create and maintain databases and database backups (hot backups and cold backups) using RMAN and manually, database recovery in case of failure, create and maintain online and offline standby databases, recover standby databases when needed, create and maintain scheduled jobs for the databases, create and maintain materialized views, create and maintain procedures according to the requirements of the development team, create database users and maintain their database privileges, database installation and patching and create and maintain new database objects, configure and maintain data replication using streams.• Active member of a large DBA team to entire satisfaction of seniors and organization.• Working for 24/7 database availability on Windows 2003 Server and Linux operating systems.• Configure and deploy Oracle Servers on Windows and Linux OS.• Oracle Dataguard implementation and maintenance.• Configure and maintain RMAN backups and Recovery using RMAN backups.

Worked as Senior I.T. officer to overcome the software development needs of the organization. This work includes, Database backup (DB Exports), Deployment using Oracle 9i as back-end database and Developer 6 as data entry forms and reports development tool and day to day maintenance of the previously developed modules.Key Achievements• Developed complete Export module for the organization and worked on MIS reports from Export module.• Developed MIS reports for Fixed Assets module.• Worked on MIS reports for the Packing module of the organization• Worked on Payroll module under supervision of I.T. manager

Worked as a Developer to assist Senior Developer in module development for the organization. This work included the module development using SQL Server as back-end database, Visual Basic 6 as front-end development tool and Crystal Reports as reporting tool. This work also included maintenance duties for the previously developed modules. During this period worked on Payroll, Weighing Bridge, Stock Management and Finance modules. Also responsible for database instance installation, administration, maintenance, backup and recovery. This work also include user creation, rights assignment to users and creation of stored procedures.Key Achievements• Part of the project work was the implementation of Payroll, Weighing Bridge, Stock Management and Finance module. As the Developer, I worked, deployed and tested above mentioned modules under the supervision of I.T. manager.