Mr Khurram Rafiq

?Mr Khurram Rafiq Email: s.khurram@Mobile : 0044 – 747226322 (Primary)LinkedIn: Pakistani/NewZealand/UK CitizenPersonal StatementAPM - PMQ certified, over 18 years’ experience in Database Administration, Database design, Infrastructural design and implementation, Project management, Team leading, Change release management, Software development. Demonstrated success in leading and mentoring cross functional teams to maximize level of productivity. Excellent communicator with emphasis on building strong client relationship. Quick leaner that rapidly adapts to emerging technologies. Industries: Metering Service, Energy, Telecom, Police, Textile, Software industry, Recruitment, Motor Manufacturing, Publishing, Media, Public Sector. In my career I had been involved in multiple projects which were successfully executed and delivered on time and they are operational. I worked on various levels from project initiating until the closure of project as Project Manager, DBA Lead, System Engineer, Developer and DBA , Change Board Manger, Security AdvisorQualificationMSc, Master’s in computer sciences - (1999-2001) BSc, Bachelor’s in science - (1993-1995) Certifications2017 - APM Project Management Qualification (PMQ)2013 - ITIL V3 Certification - IT Service Management 2008 - MCTS - Microsoft certified Technical specialist – SQL Server 2001 - MCSE – Microsoft certified system engineer 2001 - MCDBA – Microsoft certified database administrator – SQL Server 2000 - MCP – Microsoft certified Professional Courses1995 - 1-year Computer Science Diploma 2001 - C++ and SQL 2000 Training Workshop 2001 - CCNA Training Course 2006 - Leadership Training Workshop, Toastmaster International 2006 - English communication skills Improvement course2007 – SQL Server 2005 Training Workshop, Wells Office 2011 – Oracle 11GR2 Admin Workshop I & 2 (10 DAYS instructor led training) 2012 - Updating Your Database Skills to Microsoft SQL Server 20122015 - Designing Business Intelligence Solutions with Microsoft SQL Server 20142016 - IEPTO1 & IETOP2: Immersion Event on Performance Tuning and Optimization2017 - Complete PMP(R) 2017 - Architecting MS Azure Solutions Self Learning (Plural site, Blog, CBT)2017 - Big Data and Machine learning2017 - NoSQL in cloud2018 - PostgreSQL2018 - Python programming2018AWS Vs Azure in Depth review Wagtail and Django Skills & Tools RDBMS AdministrationSQL Server 7.0 , 2000, 2005, 2008, 2012, 2014, 2016 , 2017MY SQL v5.0 and aboveOracle 11gr2 Limited Administration DTS & SSIS Development/Administration SSAS, Azure data warehousing Development and administrationSSRS Advance development an administration Cloud computingArchitecting Azure solutions and administration related to database and VM administrationAzure SQL database administrationAzure Query insight setup and monitoringScale Arc Traffic management using AZURE ILB – Full DB caching and traffic manger with 100% HA functionality for SQL server System AdministrationVM build and AD setup Network setup Windows clustering setup and administrationWindows Auditing setup and quarterly review for ISO 9001 -2000 Windows login security setup and administrationProgrammingVB6, – Expert LevelPL/SQL, SQL Developer for OracleT-SQL programmingVisual Studio 2010, Visual Studio 2012, VS2015, Team foundation ServerPowershell 2.0 and AbovePHP for web site developmentReportingSeagate crystal reports, SSRS 2008r2, SSRS 2012, SSRS2016, Report Builder 2, 3Power BI reportingExcel reporting, Service ManagementBMC Remedy, Service-Now, CherwellChange ControlCherwell change control process – BMC remedy change control, Service-nowMonitoringSQL Sentry for Azure SQL DB and SQL VM in depth analysis Red Gate SQL monitorSplunk dashboard and Event log analysis Ignite,PerfmonManagementSmall to large scale project management and successful deliveryManaging small to large scale teams across multiple domainsEngaged in all projects related to databases starting from initiating till close-up of project and continued operation support.MS project professional expertiseEngaged with procurement team on multiple product licensingProjects and Leadership.Leadership and ManagementI have managed small scale to large scale projects across the board in multiple countries and multi-culture environment and easily can handle minor to complex severity issues and able to successfully deliver the results under pressure.Based on my extensive learning and certifications in management and working in various teams at various level taught me something which I always try to imply on me is “Lead by example” so I always set standards and try to apply them to me first. Reason for me to learn all methodologies (Prince2, PMP, APM, Agile, Scrum, RAID, Waterwall) to apply them where appropriate based on nature of the project and get successful results. My team always seek challenges and look for more productivity – I build team moral by challenging them in different areas based on my knowledge and having extension group discussions to build their confidence and make sure they come at top – resolve any conflicts (multiple examples) for successful delivery and team bounding – keep my team motivated and engage them with extracurricular activities.KPI and Reporting – are the key tools for any manager to have to be successful and visionary – Most of the places I worked I found those reports or similar reports already exist but if they aren’t then I always push these types of reports to be developed (sometime developed on my own) – in my role at NHS digital I developed many such reports and contributed my input towards building them all.Procurement – successfully precured third party products – part of bids and vendor selection and setting examples for vendor selection criteria – I had been involved in end-to-end procurement process in multiple rolesBudgeting and capacity planning is one of my key and favour areas – in my role at NHS digital and previous roles I always involved in key decisions around budgeting and planning – as a project lead as stake holder I have to provide/set budget requirement and capacity requirement or fulfil them as and when needed – Every single project starts with planning first hence this is my favourite area. All my projects listed in this application reflect planning and budgeting examples. Projecting cash flow through project life cycle and making sure recruitment/procurement is in line based on available funding and project requirement.Managed globally diverse team across multiple roles and successfully delivered projects and on-going operations.Due to changing technology I must keep up-to-date with my management skills and find new methods of managing projects and improve on communication skills where needed, effective negotiation with stakeholders, maintaining and improve attitude/behaviour that maximize staff discipline and performance. The ways to acquire the necessary skills and competency I always engaged in continuous educational learning, management trainings, peer to peer learnings opportunity to meet with other manager which are faced with difficult situations. This is never ending learning cycle. Summary of some of my projects which I lead and delivered with some key information. Project 1: Migration to AZURE – Major move from Local data centre to Azure Cloud Lead database migration project with minimum/no time downtime and no data lossHeavily involved in platform architecture meetings and key decisions during migrationRecommended cost savings with multiple options with pros/cons.Performed extensive POC for 6 months with latest tools like SQLSim and SQLIO , SQL Distributed relayFollowed strict change control and release process and communicated with all stake holders time to timePerformed like to like migration to Azure cloud – so we don’t see any unforeseen technology related issuesWe faced with some disk IO challenges after migration but we placed mitigation plans in place and achieved this by spreading data load to multiple files later we choose to move to premium storage after extensive stress testing process.Migrated all applications depend on SQL to Azure cloudTechnologies used – SQL Server 2008R2, SQLServer 2012, MDS 200R2 – SSIS 2008R2/2012, SSRS 2012, windows 2012, Windows Clustering, Database mirroring, Replication, Azure Cloud, Azure SQL DB, SQL Sentry monitoring, Splunk monitoring, SQLSim, SQLIO, Powershell, Updated DR (Disaster Recovery) documentation and BCP (Business continuity plan) Resulted in 60% cost saving across the board by getting rid of physical data centre. Project 2: Technology upgrade – SQL 2008R2 and SQL 2012 Migration to SQL 2016Requirement to do technology refresh with more cost savings across the boardLead the project after getting business justification approved with acceptable risks.Explored multiple other open DB technologies like NOSQL and PostgreSQL, but based on current complicity and resources choose to stay with SQL server for now and keep the options open for future to adopt emerging technologiesEngaged in architecting optimized solutions which distributed the load across 4 DB servers only instead of 8 DB servers massive cost savings of over 100K Configure always-on with multiple AG groups to take advantage of Active licensingSuccessfully migrated to SQL 2016 with NO data loss and no downtimeTechnologies used – SQL Server 2008R2, SQLServer 2012, MDS 200R2 – SSIS 2008R2/2012, SSRS 2012, windows 2012, Windows Clustering, Azure Cloud, Azure SQL DB, SQL Sentry monitoring, Splunk monitoringUpdated DR (Disaster Recovery) documentation and BCP (Business continuity plan) Resulted in over 100 K cost saving across the board by reducing number of servers to half. Project 3: Scalearc adoption and migration to achieve data level caching (DB Traffic router, data caching, routing)Like Akamai we explored multiple options to cache data and query routing – after extensive discovery and analysis we decided to use Scalarc – so we can get some more saving and provide 99.99% high availability and uninterrupted patching and query routing.POC for 6 months with extensive engagement with all relevant stakeholder – show & tell – and finally after 1 year got approval to adopt this as technologySuccessfully configured in Azure using azure load balancer Configured high availability between ScaleArc serversTechnology used: SQL Server 2016, Azure Cloud, CentOS 6.7, Scalearc App, Slack, OpsGenieResulted in 20% Reduction on CPU and memory on DB servers because data results were being cached, Patching on DB servers without any downtime, Traffic routing to all nodes based without making a change to application Project 4:Database driven Maintenance automation (All PowerShell based scripting)We converted all maintenance jobs to PowerShell scriptsDeveloped Database based project for all automation processDeployed all scripts successfully in azureTechnology used: VS2015, Powershell, T-SQL SCRIPTING, Linked serversAutomated daily DB health check process notifications setup directly to slack for effective communication and action. Resulted in fully automated deployment of Database maintenance processes – less overhead management and deployment overhead. Project 5: Upgrade all Legacy SSIS package to SQL 2016 Project deployment model & SSRS Upgrade (Ready for Azure data Factory migration)We were running legacy DTS packages in different versions of SQL server from time to time and missing out latest functionalities in recent versions – so decided to upgrade them all to project deployment model and be ready for Azure data factory conversion in next phaseLead the project technically and successfully migrated all legacy packages to Project deployment municated with all developers and stake holders on timelines testing and release processRemoved config files disk-based dependency and moved them to DB drivenIntroduce verbose style logging and in-depth troubleshooting and analysis.Automate all powershell scripts on 1-click deploymentTechnology used: SSIS 2016, SSRS2016, Teamcity, Powershell Advance level scripting Resulted in standardised and central management of SSIS package with latest functionality and one-click deployment process – Trusted by developer and stakeholders and streamline standards for coding and development.Project 6: Oracle to SQL Server 2012 migration, code review and re-writing at GWC Wellington NZWe had requirement of migrating Oracle databases to SQL Server to cut down on licensing costs for oracle hence I lead the project to carry out migration.Architect new solution, SAN provisioning suggestions, Review of existing Oracle codes and suggested alternativesSuccessfully migrated few applications from Oracle to SQL with some of code – rewriting for performance gainsDeveloped front end applications to provide basic interfacing until contractors brought in to develop applications in .NETConducted trainings across multiple team on SQL Server administrationsTechnology used: Oracle 8, SQL Server 2008r2, SSIS, SSRS, PL/SQL, TSQL, SAP Resulted in decommissions on Oracle servers with massive cost savings on licensing Project 7: ISO 9000-2001 Certification achievement for Manpower groupAs per corporate sector requirements we must pass internal audit/external audit and achieve ISO certification – I lead project to make sure databases comply with Audit policyEstablished ITPM for databasesImplemented strict ITIL process and change control processImplemented review process for any privileged accounts use and approval processAutomated databases deployment process implementationTechnology used: SQL Server 2005/SQL 2008R2, SSIS, , DOS Scripting, Windows OS Administration, Clustering, DB Mirroring, Log shipping. Resulted in achieving iso Certification for the company. Project 8: Data Centre ConsolidationWe had requirements to move all database to one central region which were distributed across multiple data centres – to reduce cost and increase efficiency and manageability across multiple companies.Taking the lead in new build activities including liaising with application and architecture personnel, assessing, sizing and documenting the SQL platform requirements DR Solution planning and design and working though DR DRY runs in multiple companies and successfully demonstrated them.Technology used: SQL Server, Oracle, Financial System applications, Service-now, BMC remedy, Ignite, SolarWinds, SSIS, SSRS, SSAS. Resulted in savings across multiple DCC projects on servers and data centres and increased efficiency for database management.Project 9: Mobile App Development and Comms ServerWe had requirement of building a web-based application which serves hundreds of meter reader across country and ways to fully automated their and send/receive workload process. Currently they were doing on paper of manual devices which they dock into remote stations every day till midnight – We ned to replace this system with something more efficient and more real-time.Design and developed Mobile application on Sony P800 phones communication over GPRSDesigned Communication server over winsock communicationEnd to End system development and management and developments.Integration with fleet GPS tracking system and GIS system developmentTechnology Used: .NET communication servers, web-based enterprise application, b2b xml web services, GPS tracking system, Payroll system using , , Appforge, code warrior, Win CE technologies with SQL Server 7,2000, 2005 databases Resulted in 60% increase in efficiency, revenue by reducing overtime, offices and fleet by real time work allocation.Work ExperiencePrincipal Technical Specialist – NHS Digital - Leeds, United Kingdom(April-2014 TO Date)Role: I have been working as Database Lead operations , providing DBA operational and strategical support and working on migrating databases across to AZURE with Mix of SQL 2008R2 and 2016 using Always on HADR and Hybrid solution.Key ActivitiesDatabases Administration as per standard approved proceduresSQL Server database Migration to Azure 2012 and 2016PowerShell script writing for centralized deployment and DBA administrationOS patching and SQL server patching co-ordination and implementationReviewing standards and best practicesDaily Data Load processingReviewing new database architecture for databases for improved performance and simplicityAdministrating Mirroring, Log shipping across clustered environmentsPerformance monitoring and troubleshooting of cluster environmentsReviewing daily DBA administration tasks and suggestion to automate processDBA Team Lead Application services – GWRC (Greater Wellington Regional Council), Wellington New Zealand. (Jan-2014 TO Mar-2014)Role: I have been working as SQL DBA Team lead application service, providing DBA operational support along with design, infrastructure and high availability of applications with performance troubleshooting and tuning skills. Mix of SQL 2000 – 2012 on VMs and clusters. SSIS/SSRS/SSAS and GIS projects reviews and design and implementation.Team Leading: 1 Oracle/SQL DBA, 2 GIS Analyst, 1 Developer (.NET) and 2 SAP Analyst.Key ActivitiesDatabases Administration as per standard approved proceduresSQL Server consolidation projects migration to SQL 2012Oracle to SQL Server 2012 migration, code review and re-writingWorking on SSAS project along with multiple integration projectsCo-ordination with all departments, and designing migration path for applicationsStrict change control process for any changesReviewing standards and best practicesSCOM monitoring configuration and monitoringCustom DBA scripts for various SQL DB health checks and instant alerts monitoringAdministrating Mirroring, Log shipping and replication (Merge and transactional)Team leading and resource managementPerformance reviewsCost and budgeting for new and existing tools.Understanding of GIS data and feeds and SAP environment.SQL Database Administrator – DATACOM Systems Ltd, Wellington New Zealand. (Sep-2013 TO Dec-2013)Role: I have been working as SQL DBA operation within team of 20 SQL DBAs. I support all aspects of SQL Server (2000,2005,2008, 2008 R2 and 2012) for specific public sector clients and working on reviewing monitoring policies and implementation best practices where needed. Key ActivitiesDatabases Administration as per standard approved proceduresCustomer liaison, providing best solution where needed for specific allocated clientsManaging and providing 24x7 SQL Server on call support Strict change control process as per customers set standardsPerformance troubleshooting and providing permanent fixesReviewing standards and best practicesNagios Monitoring for all SQL ServersCustom DBA scripts for various SQL DB health checks and instant alerts monitoringAdministrating Mirroring, Log shipping and replicationLead Database Administrator – TOP-Right Group. United Kingdom. (April-2013 TO May-2013)Role: I had been working as a Lead SQL DBA since April-2013. As a hands-on technical team leader I support all aspects of SQL Server services and have designed monitoring policies and implementation best practice. The portfolio of over 30 SQL Server instances host critical enterprise wide operations. Supporting mixture of VMs, Clusters (3-node) Team leading: 1 Senior DBA and 1 DBA in recruiting process.Key ActivitiesManaging and providing 24x7 SQL Server on call support as per rotaDatabases Administration and security implementation as per standard approved procedures.Migration and planning of SQL 2008 to SQL 2012Oracle and MYSQL support assistantService-now request and change control process across all changes and requestsDeveloping and conducting performance tuning tests and investigations using tools such as Perfmon, Profiler and blocking scriptsSuccessfully implemented redgate monitoring tool to monitor performance tuning issues across all SQL Servers.T-SQL development and analysis and deployment in controlled environment.DR Solution planning and design and working though DR test scenarioBackup and recovery solution implementationMaintaining Central database repository for Inventory using SSIS in-house packageDaily summarized reports on Job failures, backup’s failures and capacity planning via SSIS package in-house developed.Senior SQL Server DBA Team Lead – Manpower Group ltd. United Kingdom. (Jan-2011 TO Mar-2013)Role: I have been working as a Senior SQL DBA since Jan-2011. As a hands-on technical team leader I support all aspects of SQL Server services throughout Manpower Group of Europe and have designed Global monitoring policies and migrations from old technologies to new ones. The portfolio of over 120 SQL Server instances host critical enterprise wide operations. Supporting mixture of VMs, Clusters, Geo Clusters. Max DB support is 500 GB with over 2200 databases across emea region.Team leading: 3 DBA’s on site direct reporting and 2 off-shore DBAs meeting 99.9% SLAKey ActivitiesManaging and providing 24x7 SQL Server on call supportMigration of sql 2000 & sql 2005 database servers to SQL Server 2008 and SQL 2012 to central DCC In UKOracle Cross training on 11GR2 to provide basic support for some Oracle applications.Supporting both stand-alone instances and configurations that provide high availability and scalability through Replication, Log shipping and clustered instances which span multiple data centers. ?Designing, implementing and operating all operational and strategic aspects of the SQL server platform such as Standardized build control, patching, sql monitoring.Developing and conducting performance tuning tests and investigations using tools such as Perfmon, Profiler and blocking scriptsUse of latest tools to monitor SQL performance and availability such as (Orion), backup tools such as SQL Lite speed.Carrying out all tasks associated with the operational support of SQL server, including allocation of tasks, project meetings, Database architecture, new technology POC and anizing application and infrastructure personnel during project work to ensure all required activities are carried out within the project timescales.Working with infrastructure & hosting teams to rapidly diagnose and resolve connectivity problems caused by network, firewall or middleware problems, liaising directly with customers under such circumstances to keep them informed of progress.Troubleshooting performance issues and providing optimized solutions for best performanceDeveloping code to implement automated monitoring systems.Developing scalable procedures, scripts and techniques to allow easy management of the SQL server using SSIS.Review of security requirements and creating an automated audit logging and reporting framework for databases associated with SOX-404 or sensitive dataMigrating SQL Server instances and databases between versions and for rehosting or SAN migration purposesTaking the lead in new build activities including liaising with application and architecture personnel, assessing, sizing and documenting the SQL platform requirementsCommunicating production support processes and techniques with other regions and departments to facilitate a follow-the-sun support model where possibleImplementing off shoring of some support whilst ensuring stability is maintainedWriting, reviewing and deploying of SQL server database objects and scriptsSQL Server DBA – Ford Motor Company Limited. United Kingdom. (Mar-2008 TO April-2009)SQL Server DBA AND Support Team Lead– Ford Motor Company Limited. United Kingdom. (Apr -2009 TO Dec-2010)Role: I have been working as a SQL DBA from Thales UK to Ford Motor Company since Mar-208. As a hands-on technical team leader I support all aspects of SQL Server services throughout Ford of Europe and have designed Global monitoring policies and migrations from old technologies to new ones. The portfolio of over 160 SQL Server instances host critical enterprise wide operations such as CRM, Finance & Credit, National Portal sites, in-dealer systems, vehicle diagnostics systems and manufacturing & plant floor systems.Team leading: 5 DBA’s on site direct reporting and 7 off-shore DBAs meeting 99.9% SLAKey ActivitiesManaging and providing 24x7 SQL Server on call supportCarrying out all tasks associated with the operational support of SQL server, including allocation of tasks, ensuring that over 1200 service requests per month are completed successfullySupporting the portfolio of both stand-alone instances and configurations that provide high availability and scalability through Database Mirroring, Replication, and Clustered instances which span multiple data centers. ?Designing, implementing and operating all operational and strategic aspects of the SQL server platform for Ford of Europe including the definition of COBIT compliant desk procedures for SQL server operations covering aspects such as monitoring, audit controls and testing.Writing and executing disaster recovery processes to meet required recovery time and point objectives within the enterprise ITIL framework.?Developing and conducting performance tuning tests and investigations using tools such as Perfmon, Profiler and blocking scripts and latest tools such as (Tivoli, SCOM Guardium etc)Organizing application and infrastructure personnel during project work to ensure all required activities are carried out within the project timescales.Working with infrastructure & hosting teams to rapidly diagnose and resolve connectivity problems caused by network, firewall or middleware problems, liaising directly with customers under such circumstances to keep them informed of progress.Analyzing and improving Table Index and DML / Stored Procedure performanceDeveloping scalable procedures, scripts and techniques to allow easy management of the SQL server portfolioResearching and documenting the enterprise wide SQL Server requirement to ensure the SQL server architecture meets the application availability, performance and security requirements now and in the future in addition to generating and reviewing architecture documentation and network diagrams. Performing comprehensive 2nd / 3rd line support resolving T-SQL, performance, connectivity, network and middleware related problemsReview of security requirements and creating an automated audit logging and reporting framework for databases associated with SOX-404 or sensitive dataMigrating SQL Server instances and databases between versions and for rehosting or SAN migration purposesTaking the lead in new build activities including liaising with application and architecture personnel, assessing, sizing and documenting the SQL platform requirementsCommunicating production support processes and techniques with other regions and departments to facilitate a follow-the-sun support model where possibleImplementing off shoring of some support whilst ensuring stability is maintainedWriting, reviewing and deploying of SQL server database objects and scriptsCompiling support cost estimates for internal budget managementMigration of sql 2000 & sql 2005 database servers to SQL Server 2008 to central DCC in USASystems Delivery Engineer/SQL Server DBA - Wells Group Ltd, New Plymouth New Zealand (Nov 2003 – Feb-2008)Role: Database administration/Systems analysis and design/Coding/Project management/Research Work and Team Leading. Project Management methodology (Agile, Scrum, Prince2, Waterfall and RAD)Team leading: 3 DBA’s/Developers on site direct reporting and 2 in-direct T-SQL developers meeting 99.9% SLAProjects: Database development, design and administration on Regularly BasisFine tune Queries and SP, views, triggersDTS and SSIS design and development and implementation.Replication design, setup and monitoringPerformance Monitoring and correlating data for optimized performanceAutomated Backup and restore process design, development and administrationAutomated Database maintenance plansComplex database design analysis, approval , capacity planningData modeling and re-modelingMigrated multiple databases from SQL Server 7, 2000 to SQL Server 2005Developed and migrating reports from Crystal reports to SSRSDeveloped assemblies for un-documented SP in SQL CLR Disaster recovery tests for all production databases on monthly basis Scripts coding comments with version controlKeeping Document Standard up to date to maintain ISO Standards Design, development, management, administration of multiple mobile phone software's, communication servers, web based enterprise application, b2b xml web services, GPS tracking system, Payroll system using , , Appforge, code warrior, Win CE technologies with SQL Server 7,2000, 2005 databases Project Manager - Citizen Police Liaison Committee, Faisalabad Pakistan (Nov 2002 - Nov 2003)Role: Project Management and Database design and administration (Oracle and SQL Server). On Time project delivery and Implementation, liaison with external Clients and Maintenance of running system. Project Management methodology (Agile, Scrum, and Waterfall).Team leading: 5 DBA’s/Developers/Network Admin on site direct reporting.Projects: FIR Management system for Police department for whole division, integrated Payroll, Vehicle tracking, Crime Investigation) (VB, VBA, SQL 7, Oracle, Crystal report) accessible through LAN,WAN, 30% Design and development 40% Management, 30% PL-SQL,T-SQL , triggers, viewsDesign/Developed/Implemented Call tracking system for Rescue 15 (vb6,C51,C++,Oracle 8, Crystal Reports) 40% design and management, 60% PL-SQL,T-SQL , triggers, viewsDay to day database administration, Tuning, Backups, restore, SQL Auditing, DTS, Replication 100% administrationData Processing Assistant (Billing) BPS 16-17 - Pakistan Telecommunication Corporation Limited , Multan Pakistan (Aug-1999 - Oct-2002) Role: Operation billing Task management and Database Administration (UNIX and SQL) Project Management methodology (Waterfall)Team leading: 32 Operation staff (Developers/Operators/DBAs) direct reporting.Projects:Develop and manage multiple utilities for Billing System (Visual Basic 5, SQL Server 7, RM COBOL)Updating pre-written Programs using (RM Cobol) 30% design and 70% PL-SQL,T-SQL , triggers, views development Utilities systems Report writing (Crystal Reports 4.5). 100% DevelopmentCISCO Routers Administration.Administrating Windows NT & SQL Server 7.O ,Replication 100% AdministrationT-SQL development, Performance monitoring, queries optimization 100% Development and administrationStaff Management around 40 personals. 70% administrationManaging and Resource allocation for Billing. 70% Administration.Software Developer (PART TIME) - Next Software Development Centre, Multan Pakistan (Aug 2000 - Oct 2002)Role: Development, Maintenance of accounting, payroll System for multiple external clients and also providing consultancy services Projects:Developed Complete Double Entry Account Accounting system (VB 5 and Access then SQL 7) 40% Front end development, 60% PL-SQL,T-SQL , triggers, views developmentPayroll System (VB 5,VBA, and MS Access 97) 50% Database design and front end development, 50% PL-SQL,T-SQL , triggers, views development.Software Developer / Networking Engineer - Amtex Textile Mills Pvt. Limited, Faisalabad Pakistan (Nov 1997 - July 1999)Role: Ssoftware development and network management, Management methodology followed (RAD, Agile and Scrum)Projects:Partly Developed completed double entry Accounting system using (VB 5 and SQL Server 7) Developed Payroll System (VB 5 ,VBA and MS Access 97)Developed Fabric Management System (VB 5 and SQL Server 7)Partly Developed complete decision support system (VB 5 and Oracle)Developed Automated Fax Send/Receive system (VB 5 and SQL Server 7 )On demand utilities Development (VB, FOX Pro, MS Access)Assisting Database Administration Team for SQL Server 7 and Oracle 8Assistant Programmer - Masood Textile Mills Pvt Limited, Faisalabad Pakistan (Jan 1997 - Nov 1997)Role: Pproviding assistance to experience programmers and Network Engineers.Projects: Assisting software development processes ( VB, Foxpro, Access) , Providing assistance with Report writing (Crystal report 4.6), Providing assistance to Network Engineers (Novell)Network Admin/Lecturer - Al-Khair University, Faisalabad Pakistan (Aug 1995 - Jan 1997)Role: Maintenance of University Novell Network and delivering lectures to BBA and BCS students on MS office, and other Network related subjects (short term courses)Projects: Delivering lecture on MS Office, Lotus 123, Foxpro, Dbase, Cobol, also managing Novell Network. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download