Md. Monirul Islam Khan

Sr. PM & Lead Data Consultant

BJIT Limited•  October 2020 - Present

• As a Data Analyst: Managing master data, including creation, updates, and deletion. Managing users and user roles. Provide quality assurance of imported data, working with quality assurance analyst if necessary. Commissioning and decommissioning of data sets. Processing confidential data and information according to guidelines. Helping develop reports and analysis. Managing and designing the reporting environment, including data sources, security, and metadata. Supporting the data warehouse in identifying and revising reporting requirements. Supporting initiatives for data integrity and normalization. Generating reports from single or multiple systems. Troubleshooting the reporting database environment and reports. Evaluating changes and updates to source production systems. Training end users on new reports and dashboards. • As a Database Consultant: Providing technical expertise on data storage structures, data mining, and data cleansing. Consulting on ASM, Real Application Clusters,Avilability implementation & administration. Consulting on Database Warehouse implementation and administration. Consulting on Linux, Unix, SHELL scripting,Python,Data extraction, Data Transformation, Loading (ETL), conversion and integration, replication. • As a Database Administrator: Working on Oracle 10g, 12c,19c database installation, configuration, upgrade /migration and Administration. Working on SQLSERVER 2014,2016,2017,2019 database installation, configuration, upgrade /migration and Administration. Working on PostgreSQL 9.5,9.6,10,11,12 database installation, configuration, upgrade /migration and Administration. Working on MariaDB 10.3,10.4,10.5 database installation, configuration, upgrade /migration and Administration. Working on MySQL 5.5,5.7,8 database installation, configuration, upgrade /migration and Administration.

Sr. Database Administrator & Project Manager

BJIT Limited•  March 2017 - September 2020

• As a Data Analyst: Managing master data, including creation, updates, and deletion. Managing users and user roles. Provide quality assurance of imported data, working with quality assurance analyst if necessary. Commissioning and decommissioning of data sets. Processing confidential data and information according to guidelines. Helping develop reports and analysis. Managing and designing the reporting environment, including data sources, security, and metadata. Supporting the data warehouse in identifying and revising reporting requirements. Supporting initiatives for data integrity and normalization. Generating reports from single or multiple systems. Troubleshooting the reporting database environment and reports. Evaluating changes and updates to source production systems. Training end users on new reports and dashboards. • As a Database Consultant: Providing technical expertise on data storage structures, data mining, and data cleansing. Consulting on ASM, Real Application Clusters,Avilability implementation & administration. Consulting on Database Warehouse implementation and administration. Consulting on Linux, Unix, SHELL scripting,Python,Data extraction, Data Transformation, Loading (ETL), conversion and integration, replication. • As a Database Administrator: Working on Oracle 10g, 12c,19c database installation, configuration, upgrade /migration and Administration. Md. Monirul Islam Khan - page 1Working on SQLSERVER 2014,2016,2017,2019 database installation, configuration, upgrade / migration and Administration. Working on PostgreSQL 9.5,9.6,10,11,12 database installation, configuration, upgrade /migration and Administration. Working on MariaDB 10.3,10.4,10.5 database installation, configuration, upgrade /migration and Administration. Working on MySQL 5.5,5.7,8 database installation, configuration, upgrade /migration and Administration.

Database Administrator & Sr. Software Engineer

BJIT Limited•  July 2014 - February 2017

Database Administration & Development on : Oracle 10g/11g/12c,MySQL,PostgreSQL,InfluxDB,DataGuard,Clustering, Experienced on Data WareHouse (DWH) implementation and administration. Scripting: Shell,PHP,Python,Powershell,Batch. Web Development: PHP,CodeIgniter,Laravel,HTML,CSS,Java script,Ajax EAI/BI: Telend,SSIS Operating System: Red Hat Linux,Ubuntu Linux, Centos Linux,Windows Server 2012 Tools: Toad,SQLDeveloper,Zabbix,Ansible,GitHub,GitLab etc. Business Line: PLM,PDM,Engineering Application(Catia v6,Aveva ERM) etc.

Database Administrator

BJIT Limited•  February 2013 - June 2014

• Administration of the database including performance monitoring and tuning. • Taking part in the preparation and execution of technical tests. • Populating a database with new information or transfer existing data into it. • Creating backup copies of data. • Daily maintenance of firewall protection and file security. • Development of web based interfaces for Oracle & MySQL databases and web applications. • Responsible for database security and also preventing data loss. • Identifying and escalating immediately any risks to the database service. • Involved in the design of physical database schema, data modeling, and performance tuning. • Manipulating, cleansing & processing data using Excel, Access and SQL. • Responsible for loading, extracting and validation of client data. • Liaising with end-users and 3rd party suppliers. • Analyzing raw data, drawing conclusions & developing recommendations • Writing T-SQL scripts to manipulate data for data loads and extracts. • Developing data analytical databases from complex financial source data. • Performing daily system checks. • Data entry, data auditing, creating data reports & monitoring all data for accuracy. • Designing, developing and implementing new functionality. • Monitoring the automated loading processes. • Advising on the suitability of methodologies and suggesting improvements. • Carrying out specified data processing and statistical techniques. • Supplying qualitative and quantitative data to colleagues & clients. • Experience of Oracle Servers, SAN, XMLDB. • Able to plan the structure of a database. • Exposure to MIS/data warehouse applications. • Checking of supplied data for sense, consistency and accuracy.

Database Administrator

DataSoft Systems Bangladesh Limited•  July 2009 - January 2013

Installing and maintaining databases. Administration of the database including performance monitoring and tuning. Taking part in the preparation and execution of technical tests. Populating a database with new information or transfer existing data into it. Creating back up copies of data. Daily maintenance of firewall protection and file security. Development of web based interfaces for Oracle & MySQL databases and web applications. Responsible for database security and also preventing data loss. Identifying and escalating immediately any risks to the database service. Involved in the design of physical database schema, data modeling, and performance tuning. Manipulating, cleansing & processing data using Excel, Access and SQL. Responsible for loading, extracting and validation of client data. Liaising with end-users and 3rd party suppliers. Analyzing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts. Developing data analytical databases from complex financial source data. Performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality. Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements. Carrying out specified data processing and statistical techniques. Supplying qualitative and quantitative data to colleagues & clients. Experience of working on MySQL5 server infrastructures. Experience of Oracle Application Servers, SAN, XMLDB. Able to plan the structure of a database. Experience with RAC, ASM, instance tuning and SQL tuning. Ability to multi task & priorities under ever changing & challenging workloads. Ability to quickly understand complex problems and devise effective solutions. Experience of working on Oracle 9i/10/g/11g server infrastructures.

Software Engineer

DataSoft Systems Bangladesh Limited•  August 2007 - June 2009

Involved in the support, maintenance and development of critical systems. Carrying out design, construction, review and defect analysis activities. Responsible for database design and development and Application Tuning. Defining and generating screen formats and report designs. Providing suitably tested fixes to defects within the sanctioned delivery process. Producing and updating relevant documentation. Developing in accordance with policies regarding secure coding & standards. Meeting clients face to face and on site to ascertain requirements. Md. Monirul Islam Khan - page 4Develop software in accordance with agreed design with consideration for usability, software quality and future maintenance. Have an excellent knowledge of PHP, SQL, XHTML, CSS and JavaScript. Extensive experience of Oracle 9i, Oracle 10g and Oracle PL/SQL. Ability to produce clear documented and commented code. Experience in Oracle database design and development. Proficiency in Java, SQL, PL/SQL, OAF and JSP. Shell scripting languages, preferably shell, bash and python. Development experience in Configuration models, rules, and extensions. Oracle 10g, SQL, AQ, ESQL, PL/SQL, database design and tuning. Knowledge of object orientated analysis and design techniques. Experience of Oracle application interfaces including OCCI, OCI, ESQL, PRO C, SQL Loader. Experience of PHP, MySQL, HTML, XHTML, CSS, Java Scripts, Ajax.

IDB-BISEW

Database Design & Development (DDD), Postgraduate Diploma•  May 2006 - August 2007

Postgraduate Diploma in Database Design & Development (DDD):

National University

Physics, M.Sc•  May 2004 - March 2006

Master of Science (M.Sc.), Physics

National University

Physics, Bachelor of Science (B.Sc.)•  July 1999 - April 2004

Bachelor of Science (B.Sc.)

The Board of Intermediate and Secondary Education (BISE)

Science, Higher Secondary Certificate•  February 1997 - June 1999

Higher Secondary Certificate, Science

The Board of Intermediate and Secondary Education (BISE), Jashore,Bangladesh

Science, Secondary School Certificate (SSC)•  January 1987 - January 1997

Secondary School Certificate (SSC)