Over 10+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like Investment Banking, Financial, Insurance and manufacturing. Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2. Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Conditional , Table, Chart and Sub Reports. Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert. Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge and union all. Excellent knowledge in creating Databases, Tables, Stored Procedures, Views, User defined data types, functions and Indexes using T-SQL. Worked Extensively on ETL process using SSIS package. Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

SQL Developer @ Take the lead on the technical design of databases, SSIS packages, Replication, Reporting Services and supporting technical documentation for the Information Department. Develop automated solutions for the collection and presentation of standard reports to internal bodies as well as ad hoc requests. Develop sustainable automated solutions for existing standard reports (created within the Trust’s Information Management Team) using an appropriate technology Develop solutions alongside the Technical Support Team for configuration issues relating to SQL servers and database security. Make rapid personal decisions regarding the most appropriate action to take to ensure continued availability of core systems when SQL Server or database problems occur. Translate user requirements into a technical implementation plan, new design work and substantial redesign of existing database and where appropriate modifying existing code. Work at a highly complex level of technology, using the SQL Server suite to undertake detailed analysis, design, programming and testing work on all SQL systems developed within the Information Department. Undertake detailed analysis (ad-hoc, weekly, monthly, etc.) of complex, sensitive clinical/non clinical information derived from Trust IT systems, working at a wide variety of levels, such as Trust-wide, specialty specific, clinical audits/research or individual patient/user and Information audits. From October 2015 to Present (3 months) London, United KingdomMI/BI/SQL Developer @ • Agreeing the scope of any business analysis work with key stakeholders ensuring vision and strategy are considered in the scope • Contributing to the continuous improvement of the Business Analysis practice • Write complex scripts and SQL queries. • Assist in the management and maintenance of the BI/Reporting systems • Identify opportunities for data analysis relevant to business drivers and initiatives • Support members of the management team and client management with information retrieval and data analysis on an on-going basis • Evaluate business processes from a data integrity perspective and come up with recommendations for improvement and automation. • Proactively embed validation processes to ensure high quality data • Provide assistance with special projects that require data mining, analysis or reporting • Contributing to the continuous improvement of the Business Analysis practice • Conduct Risk: • Actively contribute to our culture of ‘doing the right thing’ • Remain compliant with FCA regulations and industry best practice • Demonstrate that the customer is at the heart of the business through their behaviours and mind-set From August 2015 to September 2015 (2 months) System Developer/Software Developer @ • Designing and managing the new in-house Data warehouse, development of new information databases, information processing systems, and web-based information deployment. Leading other information staff. • Lead and manage the data and information flows from operational / departmental systems into the Information Departments databases. • Designing the SSIS/BIDS/Distributed packages in SQL Server 2008 that is consisting of VB / SQL script and data transfer services to automate the job by clicking a button. Before I designed this SSIS package these task/s took one week to complete but now it takes only few minutes. • Lead discussions and specifications of new information processing and reporting requirements. Using knowledge and expertise to recommend and implement agreed solutions. Ensuring that the process is robust, efficient and well documented. • To improve and streamline existing processes and systems to promote greater efficiency and effectiveness within the information department. • To develop the use of web based reporting tools and develops the publication of information reports. • To design the database for various specialties on various Microsoft platforms. • Assisting information staff with database analysis and interpretation, including problem solving using Microsoft Access/SQL Server 2008/SQL Server Business Intelligence Development Studio, use of advanced functions and complex methodology. • Develop and improve information reporting systems to meet the requirements of managers within the trust. • To support the Trust in the development and implementation of new information systems. • Ensure that all developed systems are documented to the appropriate level, and that documentation is maintained and up to date. • To ensure that the Data Protection Act recommendations relating to the provision of information are followed at all times. • Assist other team members within Information Department as required. From July 2009 to July 2015 (6 years 1 month) Software Developer/IT infrastructure Engineer @ • Designing and Developing database and enhancements to Real-time applications based on three different databases, to ensure enhancements meet business needs and development best practice. • Delivering high quality, elegant and robust code and monitoring and tuning of database performance. • Develop and apply appropriate validity and reliability checks to incoming and outgoing highly complex data before release to users, to ensure the reliability and integrity of the data • Designing and creating reports, DTS and stored procedures in heterogeneous database environment. • Creating ad-hoc queries, forms, reports and dissemination of data in response to user requests. • Analysing, Designing, and implementing the database in Ms Access and SQL server 2000. • Analyzing information and converting data from spreadsheet to fully functional database system. Built comprehensive systems for, inventory/sales control, HR, and payroll functions. • To produce and fully document test plans following local and internationally recognised Software Development guidelines and protocols. • To adopt a problem solving approach to problems in the live system to ensure that systems unavailability due to software faults is reduced to the minimum. • To schedule work according to the priorities set by the IT Manger and Practice Manager, and to work accurately when under pressure. • Analysing network traffic and any security issues for entire Firm. • Administrating all E-mail and Network traffic issue by using Mail Marshall and Mime Sweeper. • Administrating the active Directory in Window server 2003 and creating new rules, policies, users and groups. • Creating Window XP and all related application’s images by using Microsoft Ghost image. From April 2007 to July 2009 (2 years 4 months) IT Assistant @ •Providing secondary server/desktop support, Network support, repairs and maintenance in both a Novell and Microsoft environment. •Do advanced daily network health checks, carrying out repaired as required. •Providing remote support by using VNC, RDP and Citrix Terminal. •Diagnose and resolve complex real time credit cards transactions, chip & pin devices configurations and software troubleshooting in effective manner. •Analyzing and troubleshooting DHCP/DNS/WINS, and TCP/IP Networking services. •Administrating the Active Directory in Windows 2000/2003 Server, and Novel Netware Server for entire company. •Doing back up by using Veritas Backup Exec. •Writing and Designing Group Policies and Security Polices in Active Directory. •Carry out maintenance and installation of network equipment as required to maintain a stable environment in consultation with the Network Manager. Following and completing change request documentation. •To take a lead for the functioning of SQL Server 2000 solutions, producing required enhancements to meet management needs, and ensure safe and effective corporate functioning. •To act as a software trouble-shooter (primarily SQL 2000) for the service users, identifying and finding solutions for their problems. •Developing database solutions to enable sound management decision-making and promote effective use of staff time. •Providing initial support to users on Access databases and make enhancements to these databases •To take a lead in the development of MS Access based applications and systems to enable the service users to meet developing management needs From July 2006 to April 2007 (10 months) Desktop Support @ •Providing Desktop, Network and Application Support to Traders, Marketing, Risk Analyst, and HR in EIIB Bank. •Supporting desktop systems and Window 2003 Server systems, and managing network operating system components. •Analysing and troubleshooting DHCP/DNS/WINS, and TCP/IP Networking services. •Installing, Configuration and adding users in Microsoft Exchange Server 2003. •Adding users, user Profile and workstations to the domain •Administrating the Active Directory in Windows 2003 Server for entire EIIB Bank. •Designing VBScripts in Window Server 2003 Active Directory for Users, Domain and OU. •Writing and Designing Group Policies and Security Polices in Active Directory. •Connect, set up and check PCs and peripherals for normal operation. •Perform routine maintenance tasks for user accounts; run network monitoring reports and utilities. •Maintain Microsoft IIS Server for the EIIB Bank's intranet and web site. •Provide a fault determination & fixing service on the full range of Microsoft Window server 2003, Microsoft Exchange Server 2003 and SQL Server. •Responsible for providing 2nd line/3rd Line software and hardware support on Local Network Systems. •Providing Application support from beginner to advance level in Bloomberg, MS Excel, Word and Outlook 2003 From January 2006 to March 2006 (3 months) London, United KingdomIT Technician/Software Specialist @ • Providing Technical Support to entire company (300 Staff) by using MS Server 2003, Domino Lotus Server and Window NT Server. • Designing, creating and running queries on AS/400 Server for Marketing and Sales department. • Supporting desktop systems and Window 2003 Server systems, and managing network operating system components. • Writing and Designing Group Policies and Security Polices in Active Directory. • Installing, Supporting and Maintains of the Applications, Desktop Pc’s, Laptops and Printers. • Providing advance User Support in MS Word, Excel, Access, SQL Server 2000, PowerPoint and Lotus Notes. • Creating and designing Database System for Trelleborg by using MS Access and VB 6.0. • Doing Backups on AS/400 and on MS Server 2003. • Provide general technical support and advice to desktop users in the following areas as directed by the IT Desktop Support Manager: • Specification, hardware and software installation, Version control and software tuning • Network connection, system performance, file management, trouble-shooting From May 2005 to August 2005 (4 months) London, United KingdomIT / Technical Support @ • Working as IT Helpdesk Support for FUJITSU, the worlds third largest IT Company. • Providing all kinds of Technical support for Window 95/98/NT/ME/2000/XP and Mac OS. • Providing Dial-UP connection and Broadband support to clients. • Working as a Trouble Shooter and IT Technical expert on behalf of NTL and TESCO. • Configuration, Advices and Installation of Outlook, Outlook Express, Norton Anti Virus, McAfee Firewall and ZoneLABS • Excellent interpersonal skills and the ability to communicate courteously and effectively with a wide range of people. From November 2004 to May 2005 (7 months) London, United Kingdom

Bachelor of Science (BSc), Computer Software Engineering @ University of East London From 2000 to 2004 Bachelor of Technology (BTech), Computer Software Engineering @ Lambeth College From 1999 to 2000 Nafees Farooqi is skilled in: Visual Basic, Software Development, Databases, Operating Systems, TCP/IP, Windows Server, Troubleshooting, Microsoft SQL Server, SQL, Software Documentation, Software Installation, IT Specialist ,Software/Database Developer,VBA/SSIS/BIDS Developer, Relational Databases, Software Design, OO Software Development