Sql Server Data
Resume:
Syed Mamun Ibne Moin
*******@*****.***
Professional Summary
10+ years of experience in SQL Server database development and administration including SQL Server 2005, 2008 R2, 2012 and 2014.
Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
Experience on developing tools using Visual Studio and SQL server.
Experience in deploying, administrating and troubleshooting of various SSIS features.
Knowledge on Oracle 9i database administration.
Knowledge on Data Modeling, System/Data Analysis, Design and Development.
Knowledge on SQL Server Always on, clustering, log shipping, mirroring and replication.
Good understanding of SQL Server Reporting Service (SSRS).
Experience in upgrade and database migration of SQL Server databases.
OLTP and Data warehousing environments knowledge.
Effective communication and management skills with the ability to work in a team environment. Perform all allocated tasks accurately and in a timely manner.
Basic knowledge on LAN/WAN
Analysis Services (SSAS – Multidimensional and Tabular cubes).
5+ years of experience in analyzing large and complex data using STATA.
Educational Qualifications
Bachelor’s Degree in Electrical and Electronic Engineering 2004
(Ahsanullah University of Science and Technology, Dhaka, Bangladesh)
Certificates
PRINCE2® Foundation Certificate (2017) in Project Management
ITIL Foundation Certificate in IT Service Management
ASP .NET 4 WEB DEVELOPMENT Certification
Android App Development Training
Certificate from Johns Hopkins University, Baltimore, USA for completion of Data Analysis courses
International Workshop
Data Analysis Workshop on Healthy Fertility Study organized by JHPIEGO, Baltimore, USA - March 2011
Data Analysis workshop on AMANHI (Objective-1 & 2). Organized by WHO in Geneva, Switzerland - February2016
Data Analysis Workshop on ANISA, by Bill & Melinda Gates foundation in Seattle, USA - October 2016
Publications
Safety and efficacy of alternative antibiotic regimens compared with 7-day injectable procaine benzyl penicillin and gentamicin for outpatient treatment of neonates and young infants with clinical signs of severe infection when referral is not possible:(http://www.thelancet.com/journals/langlo/article/PIIS2214-109X(14)70347-X/abstract);May 2015
Patterns and Determinants of Care-Seeking for Antepartum and Intrapartum Complications in Rural Bangladesh (http://journals.plos.org/plosone/article?id=10.1371/journal.pone.0167814); December 2016
Implementation of the ANISA Protocol in Sylhet, Bangladesh: Challenges and Solutions (https://jhu.pure.elsevier.com/en/publications/implementation-of-the-anisa-protocol-in-sylhet-bangladesh-challen); May 2016
Technical skills:
Languages: Transact SQL, PL/SQL, C, Visual Basic 6.0, VB.Net, ASP.NET, and HTML5
Databases: SQL Server 2014/ 2012/ 2008 R2/ 2005/ 2000/ MS Access/ Oracle 9i
Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), SPSS, STATA-13
ETL Tools: DTS, SSIS
Data Modeling Tools: Visio
Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL
Server 2008 R2 Query Editor, Solution Explorer, Analysis Manager,
Reporting Server
Professional Experience
Hi-Tech Bangla Information Systems, Inc. Irving, TX June 2018 to Current
Database Administrator/Developer
HTBIS is implementing loyal customer beneficiary program. As part of this project loyal customers of HTBIS will get bonus if they take Internet/Home Security/Phone/Electricity/Gas and other facility from HTBIS. To handle such a large number of customer and partner, HTBIS has developed a relational database for ISU project.
Work on SQL server 2008 R2/2014 for HTBIS.
Design and develop multiple tables for HTBIS’s Partners, Customers and Users using T-SQL.
Create clustered and non-clustered Indexes, Stored Procedure (SP) to produce complex query by joining multiple tables for ISU project.
Develop and implement Database Applications for HTBIS’s HR, And Customer Loyalty Program.
Manage and implement database models, dataflow diagrams, database schemas, DB scripts and data standards to support robust data and document management infrastructure.
Develop SSIS packages to pull data from various sources and load to Target tables using SSIS.
Analyze complex data in the source to look for data quality problems and wrote code to fix data quality issues or create code to log those errors for reporting needs.
Work on performance tuning of SQL queries.
Took full Database Backup quarterly and a bi-weekly incremental backup as a regular activity.
Troubleshot, address, and resolve database issues encountered by the end users.
Routine task for checking syslog, Database and Server health, disc storage, etc.
Test programs on SQL Server Database, correct errors and made necessary modifications as a part of performance tuning.
Plan, coordinate and implement security measures to safeguard information against accidental damage.
Develop reports using SSRS, automated and streamlined reports distribution using SSIS.
Schedule and perform preventive maintenance of server in accordance with company IT policy & guidelines.
Utilize an in-depth understanding of data environment and leverage knowledge to build robust, scalable solutions including Data Warehouse Architecture, Data Marts and SSAS cubes.
Johns Hopkins University-Bangladesh Dhaka, BD January 2011 to May 2018
Database Administrator/Developer
Designed, developed and implemented data capture systems using Visual Studio/.Net and SQL Server 2008 R2 for different Projects (conducted by Johns Hopkins University, funded by Bill & Melinda gates foundation through WHO) and maintained a very large database by setting and enforcing standard checks and controls.
Developed complex T-SQL code such as Stored Procedures, functions, triggers and views for the application while working for WHO projects.
Joined multiple tables using Stored Procedure (SP) to produce complex reports as necessary.
Designed and developed SSIS Packages to import and export data from MS Excel, Flat files and SQL Server.
Prepared reports using Crystal reports, SQL SP and SSRS.
Maintained MongoDB database architecture for different projects.
Secured database by following developed policies, procedures and controls.
Analyzed large datasets using STATA-13.
Built an ETL solution to have a new data warehouse from different data sources under one data schema.
Developed SSAS cubes.
Worked closely with Project Managers, Data Analysts, and Supervisors.
Designed and deployed data table structures, forms, reports, and queries for existing projects.
Diagnosed and resolved database access and performance issues as a regular basis.
Developed, implemented, and maintained change control and testing processes for modifications to databases.
Designed, created and maintained stored procedures for loading data and in reports
Knowledge on Object Oriented Programing, understanding on .Net language and HTML5/CSS3.
Performed Full Database Backup quarterly and a bi-weekly incremental backup as per JHU-B rule.
Migrated from SQL Server 2005 to SQL Server 2008 R2.
Troubleshoot, address, and resolve database issues encountered by the end users were a part of regular activity.
Performed routine tasks such as checking syslog, Database and Server health, disc storage, etc.
Tested programs on SQL Server Database (Ver. 2008 R2), corrected errors and made necessary modifications.
Planned, coordinated and implemented security measures to safeguard information against accidental damage.
Intrnt’l Center for Diarrheal Disease Research, BD (icddr,b) Dhaka, BD Apr 2007 to Dec 2010
Programmer/SQL Developer
Designed, developed and implemented different computerized applications for the project.
Updated the existing computerized systems to meet the project requirements.
Prepared detailed technical and non-technical documents for developed systems.
Migrated internal database from SQL Server 2000 to 2005 and then 2008 R2.
Performed and Upgraded, conversion work and functional enhancement of current application
Implemented and followed the best practices, design patterns, solution patterns and code quality.
Monitored the overall system from the data load perspective and take appropriate actions to improve the overall implementation.
System Engineering Ltd. Dhaka, BD January 2005 to March 2007
System Engineer
Installed and maintained Programmable Logic Controller (PLC) and Inverters in Industrial environment.
Contact this candidate