Sql Server Technical Support

Irfan Nasir

**** **** *** **** **** Appt# **** Contact: 832-***-****

Webster, Texas 77598 email: **********@*****.***

Career Highlights

More than Six years of experience in Database Development and Maintenance in SQL Server 2000/2005/2008/2012.

Experience in SQL, TSQL, performance tuning, Query Optimizations, designing database tables, SQL Triggers, Views, Functions and stored procedures in SQL Server 2000/2005/2008/2012.

Experience in Create Databases, Define Schemas, Database Security, create and manage clustered and non-clustered indexes, Backup and restore Databases.

Setting up and maintain Linked Server.

Experience in Create and maintain Tabular, Drill down, Drill throw SSRS based reports.

Experience in Data Transformation Services (DTS) for Data migration/Integration projects.

Experience in Design, develop, and deploy ETL (extract, transform, and load) using DTS and SSIS Packages.

Familiar with design and implementation of the Data Warehouse life cycle and excellent knowledge on entity-relationship/multidimensional Modelling (star schema, snowflake schema).

Deployment and maintenance of DTS, SSIS and SSAS packages.

SQL Server profiler.

Hands on experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS and DTS Packages.

Experience in deployment and technical support of various client/server, Web Applications and Windows Applications.

Experience Windows 10/8/7/Vista/XP/2000/NT/98 environment.

Having good knowledge of Health Care domain.

Professional Experience

1. emedapps, Houston Tx. From Jul 2015 to till Date

E-Medapps has been providing consulting services to Health Care providers, clinics and hospitals since 1999, serving over 5,000 providers across the U.S. They worked with the most popular EHR systems on the market including NextGen Healthcare, GE, McKesson, e-Clinical Works, all scripts, Athena and more. Also have a suite of products focused on increasing efficiency for clinics and facilitating communication between systems and entities in the health care industry.

Role: Solution Specialist

Job Responsibilities:

SQL Server RDBMS database development using T-SQL/Dynamic SQL.

Implementation of SevaXChange suite.

Fine-tuned SQL Queries for maximum efficiency and performance.

Writing SQL code to fetch and map data from SQL Server to HL7 interfaces and HL7 interfaces to SQL Server.

Data Conversion and validation.

Documents conversion from doc and tif to pdf.

Server migration.

Backup and restoring of SQL Server Databases.

Creating or modifying of SQL Server objects like Tables, stored procedures, indexes, views, and triggers.

HL7 interfacing between Hospital, clinics and labs.

Tools and Technologies:

SQL Server 2005/2008/2012, SSIS, VBScripts, C#.

2. Aryharsh Corporation, Houston Tx. From Nov 2014 to Mar 2015

Aryharsh Corporation is a retail company in Houston Texas, which operates various grocery stores and gas stations includes fresh food, cosmetic, bakery and check cashing departments.

Role: Freelance SQL Developer

Job Responsibilities:

Upgraded the server from MS SQL Server 2005 to MS SQL Server 2012.

Restored databases and configured database security.

Optimized the existing SQL code.

performance tuning of database objects using indexes and server to ensure efficient data retrieval.

Developed Stored Procedures and Triggers for automating tasks.

Migrated SSRS reports from 2005 to SSRS 2012.

Configured the report viewing security for various users at various levels using Report Manager.

Developed Stored Procedures to generate parameterized reports and linked reports using SSRS.

Designed SSIS Packages to transfer data from csv and text files to SQL Server 2012.

3. Shams Software Services, Karachi. From Dec 2008 to Aug 2014

Shams Software Services is a sub office of The Shams Group (TSG) located at Dallas Texas, a Healthcare Software & Service Provider, having serviced over 400 hospitals and healthcare systems worldwide. TSG offers both services and enterprise-wide solutions in areas of EHR Portals, Business Intelligence, Dictation and Transcription Portal, and various Smart Phone/Tablet based mobile solutions.

Role: Software Programming Engineer

Job Responsibilities:

Development of Healthcare softwares.

Perform client support, maintenance and enhancement of products by creating or modifying SQL stored procedures, indexes, views, and triggers.

Create, modify, and tune SQL Server Databases stored procedures, triggers, functions, indexes, views, and schemas.

Extract and import data in and out of the SQL Server using DTS Packages.

Maintain databases by checking automated backups, monitoring queries, and adjusting indexes accordingly.

Development of SQL based Validation of data for MEDITECH.

Development of Tabular, Drill down, Drill throw SSRS based reports.

Develop and schedule Data Mart upload process for SSRS based reports.

Created DTS packages to extract data from OLTP to Data warehouse systems, development and maintenance of SSAS pacakges.

Deployment and implementation of applications.

Development & Enhancement of below Products:

a)Galactica OCR (Optical Character Recognition)

b)Medical Record Batch Scanning Software

c)Galactica Document Imaging

d)Galactica RX (Pharmacy)

e)Galactica Electronic Chart Management System

f)Document Release Management (DRM)

Tools and Technologies:

SQL Server 2000/2005/2008, SSRS, SSIS, SSAS, C#, ActiveX Script, VBA, Microsoft DNN.

4. Information Technology Dept, Sindh Secretariat Karachi Pakistan: from July 2007 to July 2008.

Role: NIP Intern

Job Responsibilities:

Development of Web based applications.

Human Resource Management (MIS) for Government of Sindh.

Education

B.S. in Software Engineering, 2006

University of Sindh Jamshoro, Pakistan

Contact this candidate