Manager Sql Server

Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

E X P E R I E N C E S U M M A R Y

Over 17 years of experience includes working in different positions coordinating, managing and leading projects of different sizes and across different industries within Pakistan, USA, and UK.

Experience in managing technology teams, planning, designing, procuring, negotiating, implementing and managing the technology solutions.

Experience of leading the whole project/product roadmaps and to ensure that all KPIs (Functional and Non Functional) around product, customer and portfolio are successful met or exceeded.

Proficient in Distributed(SOA and SaaS) Software Systems, Workflow Based communiation Systems, Complex Taxation/Financial Systems, Data Integration and BI Dashboards, and Mobil Apps.

Experience of Heading the IT operations of software development company.

Background includes multi-technologies and platforms, as well as a broad range of hardware, software, and database product experience.

Extensive Experience in different Software Development Life Cycle (SDLC). Agile Software Development using Scrum,and CMMI.

Extensive experience in build, configuration and Deployment planning for salable multi-server web servers and database Servers.

Hands on Experience in Application Security, Performance Tuning, Code Optimization, Coding Standards Implementation,Code Architecture implementation, and Change Management. A R E A O F E X P E R T I S E

Strategic Planning

Solutions Architecture

Project Costing and Budgeting

Middleware and SOA.

Integration and BI

Team Building

Test Planning and Execution.

Deployment Planning.

Software Development Life Cycle

(SDLC)

Project Delivery and Integration

Smart Phone/Mobile App

Development.

Leadership and Team Building.

Process Improvement

Project and Product Management

Conflict Resolution and Managing Crisis

Situations

KPI Identifying and Monitoring

Performance Planning and Evaluation

Business Analysis

Financial control

P E R S O N A L S K I L L S

Self-motivated, Initiative, high level of

energy

Influencing, leading, negotiating and

delegating abilities

Leadership skills

Problem analysis, use of judgment and

ability to solve problems efficiently

Business Analysis

Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

Excellent Personal Communication skills

Tolerant and flexible to different

situations

Conceptual Thinking

Decision making, critical thinking,

organizing and planning

A C H I E V E M E N T:

Recently completed two projects. Livestock & Dairy Development of Punjab (SPMS). SPMS is SMS and USSD driven distributed system, with comprehensive Graphical/BI Dashboard and

Implementation of Microsoft Dynamic CRM in FBR for its Taxpayer Relation Management System to cover all the interactions with Taxpayers like phone, email, web and walk in. Different BI Dashboards have been created for different roles for trend analysis and for day to day operational monitoring.

I have twice developed full team for Software Development Projects. In 2007 with Allainet I started the fresh company with few people and when I left for US there were over 50 people team covering full domain of software development. Later in SNL have development a full team of software developers and played my role for creating the career paths of my team.

Member of Software Engineering Process Group in PRAL which is preparing PRAL of CMMI level 3 certification, Data Governance Group and Architecture Task Force. I have also participated in creating the company strategy using balanced scorecard framework.

Represented PRAL in Easy of Doing Business a Project of World Bank. Interacting with World Bank, FBR, Ministry of Finance, SECP and other government organizations and played my part of identifying the factor to be improved.

T E C H N O L O G Y P R O F I L E

Software Development: .NET, Android, Java, Visual C++, Visual Basic, PHP, JSP, WML, XAML Development Suite: Visual Studio Team Suite, Eclipse, Visual Studio .Net, Android Studio, J-Builder, Code Wright, Visio, Rational Rose (UML), Microsoft SharePoint 2012, TFS 2010 & 2012.

Database: Oracle, Microsoft SQL Server 2000-13, MySQL 4-5, Microsoft Access Technologies: Middleware, SOA, Distributed application, SODA, Integration, XMPP, SMPP

Quality Assurance: Mercury Load Runner, Win Run, Quick Test BI, Integration & Workflow: Microsoft Dynamic CRM, Microsoft SharePoint 2010-13, Microsoft BizTalk, WSO2 Middleware Platform, HighCharts.

Project Management Microsoft Project, JERA, dotProject.net and OpenProject. OS: Windows 7x, Window NT, Windows 2000-12, Linux, Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

J O B H I S T O R Y

Senior Manager Software Development October 2012 to Date Pakistan Revenue Automation Pvt. (PRAL) http://www.pral.com.pk Leading multiple project(s) in a Technical & Business Leadership Role, Complete Ownership of projects, Solution Architecture, Team Planning, Project Planning, Cost Management, Task management, Communication with all the Stack Holder. Manager Software Department July 2011 to October 2012 SNL Financial http://www.snl.com

Manages the developer group dedicated to the development of sophisticated data entry systems, intranet applications, real time data acquisition process, CRM systems, data delivery systems, analytical systems, and other applications as required. Manages the implementation of assigned projects, their performance, quality and reliability. Leads and directs Software Developer staff. Manager Software Development Sept 2009 to July 2011 Pakistan Revenue Automation Pvt. (PRAL) http://www.pral.com.pk Lead multiple project(s) in a Technical & Business Leadership Role, Team Planning, Project Architecture, Task management, Coordination for QA and Deployment, Maintenance and Project Enhancement.

Analyst/Programmer May 2008 to Sept 2009

NCI Network Communication Inc USA, http://www.nci.com Architecture Design and Development.

Technical Project Manager Sep 2005 to March 2008

Allainet Pvt. http://www.allainet.com

Managing the complete process including Idea conception, Feasibility Plan, Competitor Analysis, Software Architecture, Database Design, Team Planning, Task management, Graphics Design, Marketing Planning, SEO, Security, QA and Testing, Deployment Plan, Maintenance and Project Enhancement. Looking after Network, HR and Administration. System Analyst Feb 2001 August 2005

E-Strats, E-commerce Solution providers Pakistan http://www.estratcom.com Software Architecture, Database Design, Team Planning, Task management, Coordination with QA for Testing

Analyst/Programmer Jan 2004 to Aug 2004

NC NUST consulting http://www.nustconsulting.com

Architecture Design and Development

Software Engineer Jan 2000 to Jan 2001

Buraq Integrated Solution (BIS) http://www.buraq.com Software Analysis, Design and Development

Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

S U M M A R Y O F P R O F E S S I O N A L P R O J E C T

NET Projects Summary.

SMS and USSD driven enterprise level system for the automation of all the field operations of Livestock department of Punjab government. (.NET, SQL Server, SMPP).

VOSS a Single portal for the Registration of Businesses on SECP, FBR, EOBI and with provincial authorities (JAVA, IBM BPM, .NET and MYSQL).

EPARS is distributed system with multiple applications and components together facilitate Tax Payer to submit taxes directly through their bank accounts (.NET platform, ORACLE and SQL Server).

SNL Financial (web portal) is the premier provider of breaking news, financial data and expert analysis on business sectors (Banking, Insurance, Real Estate, Energy, etc.). (.NET and SQL Server). http://www.snl.com

eFBR a web portal for the return filling to FBR for the all types of taxes (Income Tax, Sales Tax, and Customs) (.NET platform and SQL Server) http://e.fbr.gov.pk

US based project SHERPA a web based Advertiser Management System using (.NET platform and SQL Server).

Multiple applications based on single architecture for social medial marketing. (.NET platform and SQL Server).

Web Tracker web based product for Insurance industry. (.NET platform and SQL Server).

MONS Medical Office Management System using (.NET platform and SQL Server).

Biometric based time and attendance system (Bio Knots) (.NET platform and SQL Server).

Smart Phone Project Summary.

EyesCross a game based on social media. Both in Android and iPhone.

Saluteinerba iOS based app for online store build with Magneto.

IS2000 Android based app for a security company in USA.

SaafPani Android app for Punjab government.

SharePoint Projects Summary

Broadening of Tax base (BTB) is workflow based SharePoint application with very comprehensive BI and Graphical Reporting being developed for the Broadening to Tax Base of FBR. (SharePoint 2013, .NET and SQL Server 2012).

PRAL Leaves Management System to manage statuses and approval workflows for leaves having extensive Reporting in SSRS. (SharePoint 2010, .NET and SQL Server 2012).

LAMP Projects Summary.

Weblo a big community and casual gaming portal (LAMP) http://www.weblo.com.

Multiple Web Sites using LAMP environment Shopit.com, MaybeNow.com, BuyOldWebsite.com Swapedo.com OverPopular.com etc.

JAVA Projects Summary.

KopyKake customize software used for the designing of frosting paper cake (JAVA) Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

Customized Offline Application for Underwriting Library (Mozilla and JAVA)

National Rate Fee Calculator (NRFC) (using JAVA and XML)

Other Technalogies Projects Summary.

Customize Web Browser Hanson, Bowie and Planet Football. (Visual C

Document Tracking System for the Pakistan Telecommunication Authority (PTA) (Visual C++ and SQL Server).

Different Web Sites using classic ASP and SQL Server Next Rental (www.nextrental.com), Bandai Entertainment, DJ Co-ops Advertising (www.djcoops.com) etc.

QA work related for FAST Transaction System(Win Runner 7.0) E D U C A T I ON

Master of Computer Science (MCS) Sep 1999. Al-Khair University (AJK).

BSc (Double Math’s, Physics) Dec 1996 University of Punjab. P R O J E C T S (Few Selected Ones)

Virtual One Stop Ship (VOSS).

Organization/Client: PRAL/Implementation & Economic Reform Unit(IERU) Ministry of Finance. Tools & Technologies:

.NET C#, MYSQL, IBM BPM, JAVA Services.

Environment: Windows 2012 Server,.NET Framework, IIS 7, MYSQL, IBM BPM DB2 Start Date – End Date Jan 2015 – Feb 2016.

To Create a Single portal for the Registration of Businesses on SECP, FBR, EOBI and with provincial authorities. In first phase we did the integration of SECP, FBR, and EOBI. The second phase in planning stage.

Responsibility:

Lead the project as Technical Project Manager Role.

• For Communication across all (IERU, SECP, EOBI and within PRAL)

• For its Design Development and Implementation.

• For Team Creation, Task and Time Management.

Involved in Architecture Design, Database design. Strengthening of Performance Management System. (SPMS). Organization/Client: Live Stock and Dairy Development Department of Punjab Tools & Technologies:

ASP.NET 4.5, C#, SQL Server 2012, TFS 2013, AJAX, MVC, Entity Framework, BI Graphic Reporting using High Chart.

Environment: Windows 2012 Server, .NET Framework, IIS 7, SQL Server 2012. Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

Start Date – End Date Dec 2014 – Oct 2015 Right now in Support Phase. A very unique idea of automating the field operations of L&DD using SMS and/or USSD. All the employee of L&DD across Punjab interact with the system with their cell phone by sending SMS and/or USSD. The workflows have been implemented using SMS/USSD interaction with backend window services based on SMPP protocol. On top of this Management Portal gives the User Interface for management, administration and reporting.

Responsibility:

• Lead the whole project as Project Manager Role.

o For its Architecture Design and Development,

o For Business analysis and interaction with Business Analysis Team. o For Team Creation, Hosting and Deployments, Tasking and Time & Cost Management. o For Support and Continuous addition of new modules and new features in the product. Broadening of Tax base (BTB).

Organization/Client: PRAL/FBR

Tools & Technologies:

SharePoint 2013, .NET C#, SQL Server 2012, TFS 2013, Graphic Reporting using SharePoint.

Environment: Windows 2012 Server, SharePoint 2013, .NET Framework, IIS 7, SQL Server 2012.

Design Pattern: Workflow & BI based SharePoint application Start Date – End Date April 2013 – Jan 2014 Right now in Support Phase. A Data Collection, Data Analysis, BI, Approval Flows and Communication with potential Tax Payers to bring them in the Tax Base.

Responsibility:

• Leading the product as Product Manager.

o For its Design, Development, implementation and Support, o For Requirement Analysis, scope defination, communication with stackholders. o For Team Creation, Task and Time Management.

o For Support and Continuous addition of new modules and new features in the product.

Microsoft Dynamic CRM as TaxPayer Relationship Management System in FBR. Organization/Client: PRAL/FBR

Tools & Technologies:

Microsoft Dymanic CRM 2016.

Environment: Windows 2012 Server, Dymanic CRM 2016, IIS 7, SQL Server 2012. Design Pattern: BPM/ Workflow, BI Dashborads and data integration. Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

Start Date – End Date Oct 2016 – Jan 2016 Still in its implemetation stage. CRM Dymainc 2016 is being configurated & Implemented for FRB. CRM is covering all the different ways(through email, phone calls, Walkin Tax Payers and Letters) of getting qureies and complains from Tax Payers and implmenting the full workflow and tracking for each qureies/complains . Covering three tier support teams with highly Powerfull BI based Dashboard and Graphic Reporting. Responsibility:

• Leading the product as Product Manager.

o For its Design, Development, implementation and Support, o For Requirement Analysis, Scope defination, communication with stackholders. o For Team Creation, Task and Time Management.

o For Support and Continuous addition of new modules and new features in the product.

Implementation and Refinement of Leave and Inventory Management System. Organization/Client: PRAL/PRAL

Tools & Technologies:

SharePoint 2012, .NET C#, SQL Server 2012, TFS 2013, Graphic Reporting using SharePoint.

Environment: Windows 2012 Server, SharePoint 2013, .NET Framework, IIS 7, SQL Server 2012.

Design Pattern: Workflow based SharePoint application Start Date – End Date July 2015 – Till Now.

Those are the internal System of PRAL for the Leave Management of PRAL employees and Inventory Management of PRAL assets. The Project is the implementation of these already created systems across PRAL by communication with respective departments (HR for LMS and procurement for IMS) and then refining the systems by carting/refining actually needs and issues. Responsibility:

• Lead the whole project as Technical Product Manager Role. o For Communication across all department for the implementation of LMS and IMS, o For grabbing the short comings, improvement and issue and then implementing those in LMS and IMS..

o For Team Creation, Task and Time Management.

Electronic Payment and Refund System (EPARS).

Organization: Pakistan Revenue Automation Pvt. (PRAL) Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

Tools &

Technologies:

ASP.NET 2 - 4.5, C#, HTML, Java Script, SQL Server 2000-2012, ADO.NET, Visual Studio 2008-12, AJAX, Oracle XE, 11g, WCF, Microsoft Enterprise Library. Windows, XML, SQL Server 2012, XSLT Microsoft SharePoint and Microsoft Office, SQL Server Integration Services, Replication. Environment: Windows 2008 Server, .NET Framework, IIS 7, ORACLE 11g on LINUX Design Pattern: Distributed Applications Architecture based on WCF. Template Design Pattern.

Start Date – End Date 1st Phase Feb 2010 – June 2011, 2nd Phase Oct 2012 – Mar 2013 EPARS is Tax clearing house which helps all the online Taxpayers to electronically pay taxes and receive refund from FBR. This secured payment system will complete its transaction electronically interacting with Federal Board of Revenue, State Bank of Pakistan, and Accountant General of Pakistan, Commercial Banks and Tax Payers. Different types of applications (Web Applications, Windows Services, WCF based Web Services and Sharepoint based Dashboard) comprise EPARS.

Responsibility:

• Lead the whole project as Product Manager for its design, development, deployment, and post implemation support and enhancement.

• Involved in Architecture Design, Project Management, Database design, and its Workflows.

• Communication with all stakeholder for requirements, legal issues, go live plans, hardware and procurement needs etc.

SHERPA Advertiser Management System.

Organization: NCI Network Communication Inc., Atlanta, GA http://www.nci.com Tools &

Technologies:

ASP.NET, C#, HTML, Java Script, SQL Server 2000, ADO.NET, Visual Studio 2008- 12, AJAX, Microsoft Enterprise Library.

Environment: Windows 2008 Server, .NET Framework, IIS 7, SQL Server 2000 Design Pattern: n-tier Architecture, Template Method design pattern. Start Date – End Date May 2009 – Sep 2009.

SHERPA (Advertiser Management System) for NCI’s “The Real Estate Book” http://www.realestatebook.com/ . SHERPA is N Tier Architecture based Web application, which is being physically divided in the multiply Server Layers. ASP.NET based web servers Communicate with Application server through MSMQ and then those communicate with Data Access servers. The Entity Object flows between the Layers. Front End is being constructed on web 2.0 standards with table less design based of Divs and AJAX.

Responsibility:

• Member of the Front End architecture team.

Muhammad Zaheer Ahmed

E-mail: *******.*****@*****.***

Cell: +92-321-***-****

• Worked extensively on the development of Front end layer with ASP.NET 3.5 and used

(Providers, HTTP Handler, ASP.NET server controls, AJAX and AJAX Tool kit, Extensive Use to Java Script with JQuery. etc)

• Worked on the middle tier and Database Layer using Template Method design pattern. Weblo community and casual gaming portal.

Organization: Allainet pvt.

Tools &

Technologies:

PHP, MYSQL,AJAX . LINUX

Environment: LINUX, APACHE

Design Pattern: MVC based Framework.

URL: http://www.weblo.com

Weblo is a virtual world based on the real world. Members earn real money by owning online replicas of real cities, states, famous properties and internet domain names. Members also claim celebrity gossip fan site. Members create sites and get paid for their popularity via internet advertising. Responsibility:

• Lead the whole project as Technical Project Manager role for its design, development, deployment and support.

• Involved in Architecture Design, Project Management, Database design, and its Workflows.

• Lead full project team Design, Software development, QA, deployment, E-Marketing and Support teams.

Contact this candidate