Sql Server Data
Resume:
ABDUL ISMAIL
********@*****.***
Skills Summary
Over 15 years of experience in Application Software Development, Database Administration (DBA) and Database Developer
Solid understanding of SDLC and software best practices, Agile and Scrum.
12 years of IT experience in Database Design and Administration, Data Modeling, System Analysis, Design, Development & Support of MS SQL Servers 2012/2014 and Oracle 11g R2 in Production & Remote environments.
Experience on SQL Server 2014 Installation/Configuration on AWS C2 Environment.
Good Experience in SQL Server Integration with SharePoint Administration.
Extensive Experience on SSIS 2014 Package Development and Deployment. Implemented Knowledge of SQL Server CDC Functionality.
Hands on experiences on all DBA activities in Oracle 9i/11g R2
Responsible for developing automation of maintenance jobs, Performance tuning configurations, administering SQL Server security, SQL Server automatic e-mail notification, SQL Server backup strategy and automation, creating logins, groups, users, roles, checking for database consistency Running DBCC consistency checks, if generated, fixing data corruption in application databases.
Experience of database development and data modeling with Visio, Erwin 2010 and ER-Studio in Embarcadero 9.0 data modeling tools.
Hands on Experience for SQL Replication. Experienced to setup Transactional and Snapshot Replications.
Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
Experience in MS SQL Server installation, configuration, performance tuning, and client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC
Good Experience in XML With BI Integration for SQL SERVER 2012/2014
Hands-on experience in Data Migration using DTS, SSIS (BI), BCP and Oracle Data Pump (Data Migration) Utility
Configure SQL Server failover Cluster Service on windows 2008 and setup the Databases in Always ON High availability Group mode in SQL Server 2012
Experienced in Business Analysis, Systems Study, Data Modeling and Process Modeling
Good Knowledge in Data Warehousing concept using OLAP, ETL and Data Mining
Good experience in Windows 2008/2012 Server Operation System installation of Client OS with Multi Server Management and Hyper-V hypervisor-based virtualization.
Strong experience in developing and implementing experience in SSRS/ SAS 9.1 Developed Data and graph oriented reports for all the projects.
Over 3 years of Application development experience with JAVA and .NET Programming and Develop the Unit testing code.
Excellent interpersonal, analytical, Documentation and communication skills. Strong commitment to high quality of work and timely deliverables
Technical Skills Summary
Databases : MS SQL Server 2012/2014, ORACLE 11G and MYSQL 5.6
GUI : JAVA Eclipse Juno, Visual Studio 2010, Informatica 9.0
Languages : JAVA, COBOL and VB .NET
Web Programming : ASP.NET, HTML5, XML, IIS 5.0, JBOSS
Tools : Microsoft TFS, IBM Rational Rose, Visual Interdev 6.0, VBSQL, ERWIN 6.0, MS Visio, Crystal Report 9.0, SAS 9.1, SVN, Red mine, SQL Adminer, JIRRA and
Embarcadero DB tool, Red Gate 10.0
Networking Knowledge : ftp, LAN - TCP/IP and SPX/IPX
Operating Systems : Windows 2008/2012 Server and Workstations-
Windows 8/Windows 10
Education:
BSc in Physics, Monomania Sundaranar University, INDIA
PGDCA in Computer Application, INDIA
Master of Computer Science, University of West Georgia, GA, USA
Certification:
Microsoft Certified Professional in Visual Basic
DBMS Certified by Computer Society of India
Personal Detail:
US Work Status : Green Card Holder
Current Address 940 Cranbrook Glen Ln
Snellville, GA 30078
Contact: ********@*****.***
Professional Experience:
Project : ESSENCE (BIOSENSE)
Client : OSELS, CDC - Atlanta
Role : Sr. Database Administrator & Data Analyst
Duration : Sep’ 2014 – July ‘2016
ESSENCE is an acronym for Electronic Surveillance System for the Early Notification of Community-based Epidemics. This System was developed by JOHN HOPKINS University. ESSENCE is Ongoing and systematic collection, analysis, and interpretation of health data – Used to determine need for public health action and to assess the effectiveness of programs. It is rapid, automated systems based on syndromes Non-traditional data sources. ICD9/ICD10 codes, pharmaceutical sales, ER chief complaints May provide earlier indication of outbreaks
Essence will quickly provide necessary demographic information.
Project Role: Sr.Database Developer/ Database Administrator
Responsibilities:
●DB Lead Developer on large complex database design projects.
●Provide support for data analysis, database analysis and design for relational databases.
●Advised on database management strategies and best practices.
●47 States customer support to their production data
●Design the Database setup and Data architecture for new functionalities.
●Support to set up databases on Production AWS EC2 environment
●Storage capacity planning for production servers.
●Analyzed & Fine-tuned the SQL Server performance at regular intervals
●Involved day-today SQL Development and DBA Support to Application Development team.
●Creating Several Stored Procedures and database Objects to support the Application
●Migrated Legacy data to New database using SSIS Package
●Setup the SQL Replication .Setup the Transactional subscription between Server’s Databases.
●Working with Deployment Team to support the States Production Site’s Data.
●Prepare the Deployment Scripts and assisting the new release to Production environments.
●Complete DBA Support for MySQL Databases Including Development and DB Administration Support to Project
●Worked on Mongo DB with JSON Scripts for Data reporting analysis
●Estimated the space and did the Capacity Planning on Tables. Managed the Databases Size more than 2 TB
Project : NEDSS (National Electronic Disease Surveillance System)
Client : CSELS, CDC - Atlanta
Role : Sr. Database Administrator & Database Analyst
Duration : Sep’ 2011 – Sep’ 2014
Description:
NEDSS is an acronym for the National Electronic Disease Surveillance System. It is an initiative to promote data and information system standards for disease surveillance. Surveillance systems collect and monitor data for disease trends and/or outbreaks. Public health personnel use this data to protect the nation's health. This System currently installed on 19 US States and it is running under JAVA, SQL Server 2008/2012 and ORACLE 9i/11g R2 Software.
Project Role: Sr.Database Developer/ Database Administrator
Responsibilities:
●DB Lead Developer on large complex database design projects.
●Provide support for data analysis, database analysis and design for relational databases.
●Advised on database management strategies and best practices.
●19 States customer support to their production databases.
●Provide SQL training and support including SQL query creation and tuning.
●Tutoring and Mentoring junior database developers and new features in application and database sides in SQL Server 2008/2012 and ORACLE 9i/11g.
●Migration Production Databases From Beta environments
●Performance tuning.
●Set up Federated database on Production WINDOWS Server environment.
●Storage capacity planning for production servers.
●Make plan for multi-terabyte database maintenance.
●Make backup-recovery strategy on Multi Cluster Server environment.
●Data Modeling using Embarcadero Studio 8.9
●Working with Development Team and support the Development Efforts in terms of Database side.
●Creating Several Stored Procedures and database Objects to support the Application.
●Working with Deployment Team to support the States Production Sites.
●Prepare the Deployment Scripts and assisting the new release to Production environments.
Project : CDS Data Warehouse
Client : NCPHI, CDC - Atlanta
Role : Database Administrator/Database Analyst
Duration : Mar’2008 – Aug’ 2011
Description:
The Centers for Disease Control Common Data Store (CDS) will store disease surveillance data sent from disparate systems across the CDC and its partners (e.g., States, National Sentinel Surveillance partners etc) to disseminate and collect information through coordinated data collection, compilation of historical and transactional data, and provisioning of data for analysis. CDS will be able to collect and store data from any CDC partner application which is compatible with PHIN (Public Health Information Network) or the NEDSS (National Electronic Disease Surveillance System) Base system (NBS). Currently, there are numerous databases containing information for a particular program and each of these databases has different access mechanisms, security protocols, visualization tools, case reporting tools, etc. CDS will bring all this data to a common data warehouse and create Data Marts with specific data sets as requested by the end users. This will allow different programs to monitor and analyze their data in a more comprehensive manner
Responsibilities: Sr.Database Developer & Database Analyst
Project : PHINDIR (Public Health Directory)
Client : NCPHI, CDC - Atlanta
Role : Data Architect/Database Administrator
Duration : Jul ’2005 – Feb ‘2008
Description:
Public health directory Project seeks to enhance public health partner communication and collaboration capabilities by ensuring and standards-based exchange of contact information about public health and clinical care personnel among relevant agencies. The PHINDIR architecture supports the security of contact information as well as the technical needs of increasingly stringent emergency preparedness and responses communication. At the CDC, the PHINDIR Project will also provide a high capacity enterprise-level directory service for use by a wide array of public health systems and programs. PHINDIR is referencing and providing all CDC Contacts personnel to Director of Emergency Operation Center.
Responsibilities:
Created Login accounts and database user accounts. Managed database security using groups and roles.
Created database Objects and managed the permission access on the objects with necessary security.
Created Stored Procedures, Query optimization and triggers. Schedule the Job and monitoring the Jobs.
Created the Packages and Scheduled the Packages using SQL Server BI
Estimated the space and did the Capacity Planning on Tables.
Extensively used SQL SERVER BCP Utility to load the database from text files received from different applications
Automated consistency check of the database (DBCC) for SQL Server
Analyzed & Fine tuned the SQL Server performance at regular intervals
Created the necessary indexes to improve the query performance
Extensively used stored procedures to perform complex operation. Debugged and tested stored procedure from developers and improved the performance.
Installed the Silver Stream and Setup the Database for Web Server
Created the Data Model Using ER-Studio in Embarcadero DB tool
Design flexible, feature-rich reports from SQL SERVER data source. Use extensive formatting and interactivity options to empower end users with business information.
Technical Environment: MS SQL SERVER 2005 with Java Technologies
Project : StarLIMS
Client : Center for Disease Control and Prevention (CDC)
Role : SQL Server\Oracle DBA & Data Analyst
Duration : Mar 2005 –Jun 2005
Description:
The Laboratory Information Tracking System (StarLIMS) is an easy-to-use, laboratory data management system that runs on a local area network (LAN). It offers modularity, flexibility, and expandability and facilitates consistent laboratory practices. StarLIMS provides a mechanism to enter, edit, analyze and report laboratory test results. The system is implemented in the National Center for Infectious Diseases (NCID), Centers for Disease Control and Prevention (CDC).
Responsibilities:
Installed and administered SQL Server 2000/ORACLE 8.1.7 and created databases
Created Login accounts and database user accounts. Managed database security using groups and roles.
Created database Objects and managed the permission access on the objects with necessary security.
Created Stored Procedures, Query optimization and triggers. Schedule the Job and monitoring the Jobs.
Created the Packages and Scheduled the Packages using DTS
Estimated the space and did the Capacity Planning on Tables. Managed the Database size for more than 100GB
Automated SQL Server /ORACLE database/Transaction backup
Extensively used SQL SERVER BCP Utility and Oracle Import/ Export to load the database from text files received from different applications
Automated consistency check of the database (DBCC) for SQL Server
Analyzed & Fine tuned the SQL Server/ORACLE performance at regular intervals
Created the necessary indexes to improve the query performance
Extensively used stored procedures to perform complex operation. Debugged and tested stored procedure from developers and improved the performance.
Installed the Silver Stream and Setup the Database for Web Server
Created the Data Model Using ERWIN 4.0
Design flexible, feature-rich reports from SQL SERVER and ORACLE data source. Use extensive formatting and interactivity options to empower end users with business information.
Technical Environment: MS SQL SERVER 2000, ORACLE 8.1.7/9.0,Crystal Report 8.5/9.0
Project : Reynolds Generations Series (Sales & Vehicle Management)
Client : Reynolds & Reynolds
Role : SQL Server Developer
Duration : July 2004 –Feb 2005
Description:
Retail applications to track the prospect and customer information, maintain information about dealer’s inventory vehicles and clients' vehicles, and complete the sale of vehicles and related products to meet clients’ needs. The Retail applications include Vehicle Management, Sales Management, and F&I (Finance and Insurance). Applications form the foundation for organizing dealership data. These include Accounting (Accounts Payable, Accounts Receivable, Advanced Consolidations, Cash Management, Common Information, Financial Statements, General Ledger, Purchasing, and System Manager), Client Management, HR/Payroll (Commissions Management, Employee Management, and Integrated Timekeeping), Parts, Retail (Finance & Insurance, Vehicle Management, and Sales Management), Service, and System Administration. Data Integrity Service is Customer address cleaning service which is included in Client management.
Responsibilities:
Installed and administered SQL Server 2000 and created databases
Created the Data Model Using ERWIN 4.0
Converted the Data Model from Logical to Physical design.
Developed the PFD,ERD and DFD for Database lifecycle using ERWIN Data Model tool
Created Login accounts and database user accounts. Managed database security using groups and roles.
Created database Objects and managed the permission access on the objects with necessary security.
Created Stored Procedures, Query optimization and triggers. Schedule the Job and monitoring the Jobs.
Created the Packages and Scheduled the Packages using DTS
Estimated the space and did the Capacity Planning on Tables. Managed the Database size for more than 100GB
Automated SQL Server database/Transaction backup
Extensively used SQL SERVER BCP Utility to load the database from text files received from different applications
Automated consistency check of the database (DBCC) for SQL Server
Analyzed & Fine tuned the SQL Server performance at regular intervals
Created the necessary indexes to improve the query performance
Extensively used stored procedures to perform complex operation. Debugged and tested stored procedure from developers and improved the performance.
Technical Environment: MS SQL SERVER 2000, IIS 5.0, SOAP, VB 6.0, ASP, Crystal Report 9.0 and ERWIN 4.0 and Rational Clear Case & Rational Clear quest.
Project : LITS Plus
Client : Center for Disease Control and Prevention (CDC), Atlanta, GA
Role : SQL Server/Oracle Developer
Duration : Jan 2001 –June 2004
Description:
The Laboratory Information Tracking System (LITS) is an easy-to-use, laboratory data management system that runs on a local area network (LAN). It offers modularity, flexibility, and expandability and facilitates consistent laboratory practices. LITS provides a mechanism to enter, edit, analyze and report laboratory test results. The system is implemented by the Division of Bacterial and Mycotic Diseases (DBMD) in the National Center for Infectious Diseases (NCID), Centers for Disease Control and Prevention (CDC).
LITSPlus has been implemented in CDC, Atlanta and 14 US States and GAP sites (Uganda, Kenya and Zimbabwe)
Responsibilities:
Installed and administered SQL Server 7.0/ORACLE 8.1.7 and created databases
Created Login accounts and database user accounts. Managed database security using groups and roles.
Created database Objects and managed the permission access on the objects with necessary security.
Created Stored Procedures, Query optimization and triggers. Schedule the Job and monitoring the Jobs.
Created the Packages and Scheduled the Packages using DTS
Estimated the space and did the Capacity Planning on Tables. Managed the Database size for more than 100GB
Automated SQL Server /ORACLE database/Transaction backup
Extensively used SQL SERVER BCP Utility and Oracle Import/ Export to load the database from text files received from different applications
Automated consistency check of the database (DBCC) for SQL Server
Analyzed & Fine-tuned the SQL Server/ORACLE performance at regular intervals
Created the necessary indexes to improve the query performance
Extensively used stored procedures to perform complex operation. Debugged and tested stored procedure from developers and improved the performance.
Installed the Silver Stream and Setup the Database for Web Server
Created the Data Model Using ERWIN 4.0
Design flexible, feature-rich reports from SQL SERVER and ORACLE data source. Use extensive formatting and interactivity options to empower end users with business information.
Developed the Lab Reports and various customized reports for major outbreak (SARS) and several CDC LITSPlus Labs.
Technical Environment: MS SQL SERVER 7.0/2000, ORACLE 8.1.7/9.0,
Power Builder 6.0/9.0, Crystal Report 8.5/9.0,and SILVER STREAM 3.4.7
Project : Collection management System (CMS)
Client : National Commercial Bank, Jeddah, Saudi Arabia
Role : SQL Server Developer
Duration : Sep ’99- Sep ‘00
Description:
Client Server System to maintain the Credit Cards Due Amount of the Customers. The Objective of the Project is
keep tracking of Customer’s Credit Cards Payment
making the agreement between the Customers and Credit Cards Department
automated the process of Customer’s Statement Printing
System functionality covers Customer history, Account history, Customer Involved the transactions, maintaining the Customer Payments etc...
Responsibilities:
Data Modeling and Database Design (Logical and Physical)
Server Installation and Configuration. Production and Development Support
Creation of Databases, Tables, Views, Indexes, Triggers and Stored Procedures
Enforced referential integrity and other Constraints
Created and maintained Roles and Database Users
Optimization of queries and Performance tuning
Implementation of Backup and Recovery strategies
Created Active-X Component using Visual Basic
Have used SQL Mail Management to notify the users
Deployed the Component Into MTS and monitoring the Transactions
Technical Environment: MSSQL Server 7.0 SQL Mail, MTS 2.0, and WINDOWS NT
Project : Investment Management System (IMS)
Client : AL AZIZIA Commercial Investment Co. Riyadh, Saudi Arabia
Role : SQL Server Developer
Duration : Mar ’99 – Aug ‘99
Description:
IMS is a Client Server System to maintain the local shares and International Shares. It is handling share brokerage and provides complete functions covering Order placement, execution and order Settlement. IMS will have automated process for share transaction and financial transactions. Keep monitoring the company share stock position at the current Point. It is maintained the Corporate Action like Consolidation/Split, Transfer/Conversion of the Shares and Merger of the stocks.
Responsibilities:
Upgraded SQL Server from 6.5 to 7.0
Handled very large database up to 75GB Database in MS-SQL Server 7.0
Maintained standby Server for Production Environment
Migrated Data from various data sources using BCP Utility
Created Database, Stored Procedures and triggers
Authorizing and managing the Security Privileges
Created Automated Jobs for Backup and maintain standby Server
Optimization and fine-tuning of database
Providing a clean and running database back end to the development team
Maintenance of Security and data integrity
Have used SQL Mail management to notify the users
Data Migration from Various databases.
Developed Standard Brokerage reports and customized the various reports for user requirement.
Technical Environment: MS SQL Server 7.0, WINDOWS NT 4.0 Visual basic 6.0
Crystal Reports 7.0 and COM
Project : Brokerage Management System
Client : Al Aziza Commercial Investment Co. Riyadh, Saudi Arabia
Role : SQL Server Developer
Duration : Aug ’98 –Feb ‘99
Description:
Brokerage Management System is Share purchasing system to deal the local and International shares commission and Investment Maturity values. It is Bilingual Compatibility (English & Arabic).BMS will have automated the Process for share Price display and maturity value calculations. It will Audit the Company Internal Accounting Functions. It has the Graphical Oriented reports and charts
Responsibilities:
Created Database, Stored Procedure and Triggers
Maintained the Database up to 80GB in MS SQL Server 6.5
Authorizing and managing the Privileges
Created Automated Jobs for Backup and maintain standby Server
Optimization and fine-tuning of database
Providing a clean and running database back end to the development team
Back-up and disaster recovery plan
Maintenance of Security and data integrity
Created the Component using Visual Basic
Developed the Reports both online and offline based on the user requirements using Crystal Reports.
Technical Environment: MS-SQL Server 6.5, WINDOWS NT, and Visual Basic 6.0
And Crystal Report 6.0
Project : Customer Information System (CIS)
Client : RIYAD BANK, Riyadh, Saudi Arabia
Role : SQL Server Developer
Duration : Feb ’98 –Jul ‘98
Description:
Customer Information System was developed to Riyadh Bank Private Banking Department. Its deals the Private banking Customers entire Parts of the Kingdom of Saudi Arabia. It is maintaining the Customer’s Current Account, Saving Account, Time Deposits, Share Details, Credit Cards transactions and ATM Card Transactions. Replicate the Database to the all Branches in the Kingdom. It has the Chile System called Gift Management System (GMS) is maintaining the Customer’s Gift details distributed by the Head office to the Branches.
Responsibilities:
Screen design, Programming and testing
Creating Stored Procedure, triggers and database administration.
Writing regular reports, statistical reports and graphical charts and reports
Implementation of system and customer support
Created the Component using Visual Basic
Developed the Reports both online and offline based on the user requirements using Crystal Reports.
Optimization and fine-tuning of database
Technical Environment: MS SQL Server 6.5, Replication Server (Subscription Server),
Windows 4.0, Visual Basic 5.0 and Crystal Reports, COM
Contact this candidate