MD MONIRUL ISLAM KHAN
DHAKA
Summary
I am an experienced and highly skilled professional with 15 years of expertise in Data Management, Specializing in roles such as Database Administrator, Data Engineer, and Data Analyst. My career highlights include efficient data consolidation, procedure development, and advanced SQL/TSQL. I am proficient in managing master data, data storage structures, data mining, and data cleansing.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Data Specialist
BRAC
DHAKA
03.2022 - Current
- Developed data dictionaries and documentation to improve understanding of data sources.
- Gathered data from multiple sources to assimilate meaningful inputs for databases.
- Identified areas of improvement in existing database systems and implemented solutions accordingly.
- Identified clients responsible for violations of data transmission guidelines, referring incidents to supervisor for remediation.
- Conducted data analysis of key problem areas to assist in root cause analysis.
- Extracted, imported and exported RDBMS or NoSQL data into various database applications.
- Resolved conflicts among various stakeholders during the design phase of projects that involve working with multiple datasets.
- Audited data regularly to guarantee data integrity and quality.
- Provided technical support for users with issues related to accessing or manipulating data.
- Developed new functions and applications to conduct analyses.
- Assisted in developing training materials related to working with databases for non-technical personnel in the organization.
- Assessed database performance by developing protocols for identification of problem areas and measurement of results.
- Utilized business intelligence tools such as Tableau and Power BI to create interactive dashboards for management reporting purposes.
- Conducted regular maintenance activities such as backups, archiving old records, ensuring availability of data at all times.
- Analyzed complex datasets using SQL, SAS and Excel to uncover patterns and trends.
- Developed data models to support decision-making processes within the organization.
- Created reports and audited charts to maintain concise records.
- Conducted quality assurance testing on newly created databases to ensure accuracy and integrity of data.
- Cleaned and manipulated raw data.
- Created graphs and charts detailing data analysis results.
- Built custom applications using scripting languages like Python, R, JavaScript for automating tasks within the organization's infrastructure.
- Secured database by preparing control and access procedures and policies and implementing disaster recovery protocols.
- Optimized existing queries used in daily operations by providing recommendations based on best practices.
- Monitored system performance metrics and identified potential issues before they became problems.
- Corrected data errors and entered missing information into new data parcels being processed for clients, maintaining compliance with guidelines.
- Maintained database security by setting up user accounts and granting access privileges as needed.
- Implemented new database technologies such as NoSQL, Hadoop, MongoDB to optimize performance.
- Tested, validated and reformulated models to foster accurate prediction of outcomes.
- Performed ETL operations to move data between databases.
- Recommended data analysis tools to address business issues.
- Achieved cost-savings by developing functional solutions to problems.
- Planned and completed group projects, working smoothly with others.
- Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
- Maintained open communication with team members and stakeholders, resulting in successful project outcomes.
- Prioritized and organized tasks to efficiently accomplish service goals.
- Approached customers and engaged in conversation through use of effective interpersonal and people skills.
- Displayed strong telephone etiquette, effectively handling difficult calls.
Lead Database Consultant
BJIT LIMITED
DHAKA
02.2013 - 02.2022
- Created and implemented complex business intelligence solutions.
- Developed and implemented database solutions for clients to improve data accuracy, security, and performance.
- Planned and installed database management system software upgrades to enhance systemic performance.
- Ensured compliance with industry standards when designing databases for clients' projects or applications.
- Built reports using reporting services such as SSRS, Crystal Reports, Cognos based on customer requirements.
- Developed stored procedures, triggers, functions, views, indexes, and other database objects as needed to support application development efforts.
- Collaborated with developers to optimize queries for better performance and maintainability.
- Applied various skills to evaluate, design, implement and optimize databases and database applications.
- Researched new technologies that could be used to improve current processes or develop new solutions for clients' needs.
- Provided ongoing support for all aspects of database management including capacity planning, installation and configuration.
- Established and determined optimum values for database parameters using manuals and calculators.
- Developed and managed enterprise-wide data analytics environments.
- Identified user requirements by conducting interviews with stakeholders and analyzing existing databases.
- Implemented strategies for high availability systems such as replication, log shipping, clustering to meet business continuity requirements.
- Wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.
- Monitored the health of the systems using various tools like SQL Profiler and Database Tuning Advisor.
- Evaluated existing databases for potential risks or vulnerabilities and recommended corrective actions accordingly.
- Collected, outlined and refined requirements, led design processes and oversaw project progress.
- Configured access controls on tables, views, stored procedures so users have only necessary privileges over sensitive information.
- Migrated data from legacy systems into modern databases while ensuring data integrity throughout the process.
- Identified, protected and leveraged existing data.
- Worked as part of project teams to coordinate database development and determine project scopes and limitations.
- Designed efficient database structures to store large amounts of data while optimizing performance, scalability, and reliability.
- Assisted in troubleshooting complex problems associated with the database environment during system testing or production issues.
- Performed regular maintenance activities such as backups, integrity checks, index rebuilds and reorganizations to ensure optimal performance of the databases.
- Provided technical guidance on best practices related to database architecture and design.
- Completed, audited and updated administrative requirements related to application and onboarding process of candidates by maintaining database systems and spreadsheets.
- Analyzed and developed technical and functional specifications for databases.
- Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
- Prioritized and organized tasks to efficiently accomplish service goals.
- Planned and completed group projects, working smoothly with others.
- Achieved cost-savings by developing functional solutions to problems.
- Approached customers and engaged in conversation through use of effective interpersonal and people skills.
- Maintained open communication with team members and stakeholders, resulting in successful project outcomes.
- Assisted with customer requests and answered questions to improve satisfaction.
- Maintained updated knowledge through continuing education and advanced training.
- Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
- Modified existing software systems to enhance performance and add new features.
- Delivered products to customer locations on time.
- Leveraged PLM,ERP skills to input and compile data gathered from various sources.
- Worked with cross-functional teams to achieve goals.
- Created conceptual, logical and physical data models for use in different business areas.
Database Administrator
DATASOFT SYSTEMS BD LIMITED
DHAKA
08.2007 - 01.2013
- Solved complex analytical problems using statistical models from data.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
- Developed strategies to assess applications designed to client standards while eliminating security risks.
- Managed multiple databases running on different platforms including Windows, Linux and UNIX systems.
- Implemented data replication between two different databases using DataGuard feature of Oracle Database Server.
- Supported planning for software development and purchases and coordinated implementation.
- Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
- Participated in evaluation, design and implementation of new and major enhancements of business applications.
- Participated in capacity planning initiatives to forecast future resource needs based on current trends.
- Coordinated security compliance and audit preparation with cyber security team.
- Defined database design specifications based upon project requirements.
- Worked with software vendors to analyze and resolve software installation and ongoing support issues.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Partnered with project management teams on development of scope and timelines.
- Tested application code changes before deploying them into production environment.
- Established security controls to help protect client systems.
- Aligned systems with business needs to enhance scalability of database structures and recommend improvements.
- Developed and implemented database security measures to ensure data protection.
- Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
- Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
- Created and monitored performance metrics to keep databases functioning at optimal capacity.
- Provided support for complex issues related to software tools, applications and databases.
- Communicated with data architects, programmers and engineers to keep projects on track.
- Devised reports and visualizations to present requested data in sleek format.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Monitored performance of queries and tuned them as needed using Explain Plan tool.
- Wrote scripts and processes for data integration and bug fixes.
- Analyzed workflows and established priorities for daily operations.
- Developed data models and database designs to plan projects.
- Coordinated with other teams such as network administrators and system admins for resolving complex issues.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Resolved customer queries related to database issues promptly and accurately.
- Migrated existing databases from one platform to another with minimal downtime.
- Developed and implemented security initiatives to protect important company data.
- Conducted training sessions for junior DBAs regarding best practices related to database administration.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
- Defined synchronization plan for patch management.
- Installed, configured, and maintained Oracle 11g and 12c databases on Linux servers.
- Ensured that all the stored procedures are optimized for better performance of the system.
- Analyzed and developed technical and functional specifications for databases.
- Performed quality assurance processes to support data warehouse improvements.
- Performed daily backups of the databases using RMAN utility.
- Provided technical support for developers by creating views and indexes as per their requirements.
- Created new tablespaces for applications to store their data in the database.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Displayed strong telephone etiquette, effectively handling difficult calls.
- Identified needs of customers promptly and efficiently.
- Leverage Banking,Microfinance skills to input and compile data gathered from various sources.
- Maintained open communication with team members and stakeholders, resulting in successful project outcomes.
- Completed day-to-day duties accurately and efficiently.
- Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
- Modified existing software systems to enhance performance and add new features.
- Approached customers and engaged in conversation through use of effective interpersonal and people skills.
- Achieved cost-savings by developing functional solutions to problems.
Education
PGD - Database Design & Development
Isdb-bisew
DHAKA,BANGLADESH07-2007
Master of Science - Physics
NATIONAL UNIVERSITY
BARISHAL, BANGLADESH01-2006
Skills
- Data Acquisition
- Data Verification
- Compiling Data
- Database Structures
- Advanced Data Mining
- Statistical Analysis
- Data Acquisitions
- Quantitative Analysis Expertise
- Data Aggregation Processes
- Data Analysis
- SQL and Databases
- NoSQL Databases
- Database Development
- Load Balancing
- Warehouse Models
- Data Migration
- Data Mining
- Data Security
- Data Analytics
- Microsoft SQL
- Database Management
- Information Systems Management
- Writing Queries
- Python
- Database Analysis
- Data Conversion and Migration
- Linux Operating System
- Disaster Recovery
- Microsoft PowerShell
- Database Administration
- Root Cause Analysis
- Coding Data
- Agile Methodology
- Business and Technical Analysis
- Troubleshooting and Diagnosis
- Back-End and Database Skills
- Scripting Languages: PHP, Python, Javascript
- Software Development Tools: JIRA, Confluence
- Scripting
- Databases: Oracle, SQL Server, MongoDB
- Version Control Systems: Git, Github
Languages
Bengali
First Language
English
Upper Intermediate (B2)
B2
Certification
- OCP on SQL Oracle University / Jun 2006 - Aug 2006
- Oracle PL/SQL Oracle University / Sep 2006 - Dec 2006
- OCP on Oracle DBA Oracle University / Jan 2010 - July 2010
- Red Hat Certified Engineer (RHCE) RedHat / Jun 2014 - Dec 2014
- MCSA: SQL Database Administration Microsoft / Jan 2018 - Dec 2018
- Microsoft Certified: Azure Administrator Microsoft / Jan 2019 - May 2019
- Applied Data Science with Python - Level 2 IBM / Jan 2020 - Dec 2020
- Exasol Certified Associate Exasol / Jan 2022 - Apr 2022
- GCP Cloud Data Engineer Google Cloud / Jan 2023 - Apr 2023
- GCP Data Warehousing with BigQuery & Administration Google Cloud / May 2023 - July 2023
- GCP Cloud Data Models with LookML
References
References available upon request.
Timeline
Data Specialist
BRAC
03.2022 - Current
Lead Database Consultant
BJIT LIMITED
02.2013 - 02.2022
Database Administrator
DATASOFT SYSTEMS BD LIMITED
08.2007 - 01.2013
PGD - Database Design & Development
Isdb-bisew
Master of Science - Physics
NATIONAL UNIVERSITY
Similar Profiles
Sadia TasnimSadia Tasnim
MANAGER, DIGITAL TRANSFORMATION UNIT, MICROFINANCE PROGRAMME at BRACMANAGER, DIGITAL TRANSFORMATION UNIT, MICROFINANCE PROGRAMME at BRAC
Juthee Halder LabonnoJuthee Halder Labonno
Deputy Manager, Accounts and Audit at BRACDeputy Manager, Accounts and Audit at BRAC
Maurice Momoh KallonMaurice Momoh Kallon
Technical Sector Specialist - Agriculture at BRACTechnical Sector Specialist - Agriculture at BRAC