Khurram Imtiaz
Rawalpindi,PK
Summary
11+ years of professional experience in MS SQL Servers, MySQL, and MS Access with expertise in RDBMS, data analysis, optimization , Azure data factory Pipelines , ETL process, and data maintenance. Skilled in problem-analysis, reports generation, and writing SQL scripts. Extensive knowledge of US healthcare Tool and technologies. Seeking to enhance existing technical and management skills by joining a talented team in a competitive and challenging environment.
Overview
12
12
years of professional experience
Work History
Associate Manager
Wiseman Innovations/DataQ Health(Dallas, US)
Islamabad, Pakistan
12.2019 - Current
- Create and maintain optimal data pipeline architecture
- Assemble large, complex data sets that meet functional / non-functional business requirements
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
- Experience supporting and working with cross-functional teams in a dynamic environment
- Completed a project in MS access also integrate this with SQL server
- Strong analytic skills related to working with unstructured datasets
- Worked with LabCorp of America to integrate the healthcare data in HL7 Format
- Work with data and analytics experts to strive for greater functionality in our data systems
- Setup High availability Cluster environment
- Costing of a Instances on Azure
Sr. Database Administrator
Zigron Pakistan(Virginia, US)
Islamabad, Pakistan
12.2018 - 12.2019
- Data forecasting for next 6 month in an IOT project
- Code optimization in and MYSQL project and reduce the execution time
- Partitioning one of the largest tables in MYSQL project
- Implement Hadoop 2 nodes with 4.7 million data
- Configure 2 node SQL Server polybase with Hadoop
- Optimization on different algorithms which takes more then week to execute
- Optimization in SQL Server for main source table
- Data Transformation to Hadoop from SQL Server polybase using ETL
Sr. Database Administrator
F3 Technologies
Islamabad, Pakistan
08.2016 - 12.2018
- Expertise in Always-On Availability Groups (AAG) and HA Troubleshooting/ resource governor/ Sql Server distributed replay/ SSIS and SSRS
- Expertise in CDC, Service Broker, CLR and Database Partitioning (function & view)
- 24 X 7 Production Database on Call Support
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
- Expertise in Database Encryption and Description using TDE
- Worked on SQL Server 2012 migration and above from SQL Server 2008 / 2005
- Writing complex scripts and procedures in TSql also optimize the scripts written by other teams
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
Database Developer/Administrator
DPL-IT(Florida, US)
Islamabad, Pakistan
07.2014 - 06.2016
- Installation of SQL Server, Oracle and Related Products and patches
- Performance tuning through Execution plan and SQL Server profiler
- Strong Development knowledge on SQL Server Integration services (SSIS) write many packages for data transformation and data extraction and load also strong knowledge of package configuration setting and troubleshooting
- Optimization of SQL Server, Stored Procedures and SQL Scripts
- Creating and Monitor Application Related Jobs and Data Replication Activities
- In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL, and Stored Procedures
- Strong knowledge of Google, Bing, Yahoo and Facebook AdSense data APIs
- Monitor daily system health check and backups
Database Programmer/Administrator
Protégé Global
Islamabad, Pakistan
11.2013 - 04.2014
- Installation of SQL Server Software and Related Products
- Establish and Maintain Backups on Local and Remote Media
- Performance Monitoring Using Performance Monitor, DBCC Commands, Maintenance Plans
- Analyse Applications Performance Using Query-Execution Plans, Index Utilization and Procedure Cache Utilization
- In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL and Stored Procedures
- Data Migration from Other Databases (Oracle, Excel, CSV, FoxPro, Access, Med soft) to SQL Server (Import/Export)
- Write Database Procedures, Functions and Triggers
- Tune Database Queries
- Optimization of SQL Server, Stored Procedures and SQL Scripts
- Creating and designing reports on reporting server
- Monitor Application Related Jobs and Data Replication Activities
Database Developer/Administrator
MTBC (New Jersey, US)
Rawalpindi, Pakistan
12.2012 - 12.2013
- Installation of SQL Server Software and Related Products
- Establish and Maintain Backups on Local and Remote Media
- Performance Monitoring Using Performance Monitor, DBCC Commands, Maintenance Plans
- Analyse Applications Performance Using Query-Execution Plans, Index Utilization and Procedure Cache Utilization
- In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL, and Stored Procedures
- Plan Growth and Changes (Capacity Planning) with Team
- Data Migration from Other Databases (Oracle, Excel, CSV, FoxPro, Access, Med soft) to SQL Server (Import/Export)
- Write Database Procedures, Functions and Triggers
- Tune Database Queries
- Optimization of SQL Server, Stored Procedures and SQL Scripts
- Creating and designing reports on reporting server
- Managing reporting server issues
- Monitor Application Related Jobs and Data Replication Activities
Education
Master’s - computer sciences
PMAS Arid Agriculture University
08.2012
Bachelor of Commerce/IT - B. Com
University of Punjab
06.2007
Skills
- US Healthcare Medical Billing
- US Healthcare ACO Model Analyst
- Team Management
- SSMS 17/18/19
- Redgate SQL
- SSIS 2008/2012/2014/2016/2019/2022
- SSRS
- Azure Data Factory
- Azure SQL Databases
- Azure AI Services
- MS Access
- T-SQL/PLSQL/PGSQL
- SQL Server administration
- HL7 integration
- Build jobs on power automate
- HA Environment Setup
- Hadoop
- SQL Server Polybase
- MySQL
- Query Optimization
- S3 Bucket
- Azure Data Lake
- High Availability/Always On
- Backup/restoration
- Database Encryption (TDE)
- Automate Tool
- Azure Data factory
- Mirth Connect
Accomplishments
- Employee of the month in MTBC (August 2013)
- Team of the month in MTBC (April 2012)
Timeline
Associate Manager
Wiseman Innovations/DataQ Health(Dallas, US)
12.2019 - Current
Sr. Database Administrator
Zigron Pakistan(Virginia, US)
12.2018 - 12.2019
Sr. Database Administrator
F3 Technologies
08.2016 - 12.2018
Database Developer/Administrator
DPL-IT(Florida, US)
07.2014 - 06.2016
Database Programmer/Administrator
Protégé Global
11.2013 - 04.2014
Database Developer/Administrator
MTBC (New Jersey, US)
12.2012 - 12.2013
Master’s - computer sciences
PMAS Arid Agriculture University
Bachelor of Commerce/IT - B. Com
University of Punjab
Similar Profiles
Adnan KhaliqAdnan Khaliq
Principal Support Engineer at Wiseman InnovationsPrincipal Support Engineer at Wiseman Innovations
Muhammad AzimMuhammad Azim
Sr. Enterprise Database Architect at Wiseman Innovations SMC LimitedSr. Enterprise Database Architect at Wiseman Innovations SMC Limited
Asli SacuAsli Sacu
REGIONAL MANAGER at Wiseman ResidentialREGIONAL MANAGER at Wiseman Residential