Mohammad I.

MOHAMMAD ISLAM SUMMARY MSc on Data Warehousing and Data Mining. Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers and Oracle Servers. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. I have extensive technical knowledge in Java and C.. Much of my work has been around the Oracle (10G & 11G) and SQL Server- interfacing with it, building MIS and OLAP reporting solutions around it, including Oracle Discoverer and Oracle Financial Analyzer. Have experience in developing Data warehouse in Telecommunication Domain. Good Knowledge in SAP BW 3.5 and BI 7.0 specially to design and development of custom InfoCubes . The InfoCube development included Basic and Transactional InfoCubes. Backend development included custom Start Routines, Transformation Rules, Transactional, Master Data, and Variable User Exits. Activated BW Business Content including InfoCubes, Update Rules, InfoSources, and DataSources to provide a baseline for the custom InfoProvider and design and development of custom Bex Queries, BI backend design based upon SAP Best Business Practices for an Enterprise Data Warehouse including the following layers; Data Acquisition, Business Propagation, Flexible Reporting, Dimensional Reporting, and Virtual Reporting and also Crystal Reporting Have experience and extensive knowledge in PHP programming including PHP (5) Object Oriented programming , Good knowledge and experience in MySQL (5) . Have experience in ,C++, java scripts, HTML,XML, Pentaho BI, SPSS,SDLC, RUP,UML and SSADM SPECIALTIES PHP, XML,JSON, Google API, Yahoo API, Expedia API, Facebook API, Twitter API, ORACLE, MS SQL, MYSQL, Data Warehousing and Data Mining (Business Intelligence), Distributed Database, Database Integration, ETL, SAP BW PERSONAL PROFILE - Dynamic, creative person, willing to learn and develop myself - Able to perform both individual and team work - Good decision–making abilities and open-minded, willing to meet new people - Fully prepared to work in flexible hours - Self-motivated and able to work with minimal supervision - result driven project leader and coordinator - Industrious, works effectively with all levels. - Ethical and loyal, maintains a high degree of confidentiality. KEY SKILLS - Self Starter: Self starter and highly motivated, duty bound, a highly committed with strong conceptual knowledge of analytical and the ever-changing technology. - Organiser: Tremendous energy and is eager to actively participate in, as well as plan and organize various events for the company. - Sharing Knowledge: A flair for creatively implementing ideas and an enthusiast, a doctrinaire always eager to learn new things and has an unflagging enthusiasm for sharing. EDUCATION & TRAINING The University of Greenwich, London MSc on Data Warehousing and Data Mining -(Metrit & Distinction on Research Project) London Metropolitan University, London BSc (Hons) in Computing and Information Systems (BCIS) -Upper Second Class (104 out of 128) National Computing Council (NCC), London International Advanced Diploma in Computer Studies (IADCS) -Merit National Computing Council (NCC), London International Diploma in Computer Studies (IDCS) -Distinction Govt. Titumir College, Dhaka, Bangladesh Higher Secondary Certificate (H.S.C) -Distinction Khilgaon Govt. High School, Dhaka Bangladesh Secondary School Certificate (S.S.C) -Distinction INTERNATIONAL RECOGNISED PUBLICATION 12th International Conference on Computer and Information Technology (ICCIT 2009) -Paper's Title: A Practical Approach of Designing Synchronous Replicated Heterogeneous Distributed Database System, Page 646-649 8th International Conference on Computer and Information Technology (ICCIT 2005) -Paper's Title: An Auto Exam Question Maker (Artificial Intelligence), Page 1234-1239 8th International Conference on Computer and Information Technology (ICCIT 2005) -Paper's Title: An Approach to Managing Information Systems Obstacles, Page 898-903 RESEARCH AREA Developing replicated (Hybrid Replication- Multi-master replication and Snapshot both combine) heterogeneous distributed database system and developing Data Warehousing (for warehousing to prepare data using ETL tools for data cleaning and preparing for the warehouse) and execute Mining using association rule mining in very large database (fuse the intelligent algorithm e.g. Apriori on the dataset using SPSS Clementine) for data manipulation, preparation, modelling and validation. Provide analytical Service where need to improve segment performance and enhance customer experience within the company Conduct extensive mining of large databases to analyze marketing programs performance, productivity by segment and generate detailed reports that drive insight and highlight opportunities for achieving company revenue. Develop statistical and predictive models for different marketing initiatives (i.e. Customer segmentation, churn, cross sell, fraud, customer profitability) by using different data mining tools such as (SPSS Clementine and WEKA) . Apply statistical and data mining techniques such as Decision Trees, Logistic Regression, clustering and Neural Network and make market recommendations. EMPLOYMENT HISTORY SEP 2010 - PRESENT Resale Weekly ([login to view URL]) Position: Database Analyst Responsibilities - Responsible for the database administration in the organization - Advanced PHP Programming for the web site and also developed the XML parser to capture data to the MySQL database and generating RSS Feeds XML from MySQL database using PHP. - Installing new versions of the DBMS applications, MySQL and other related software - Responsible for analyzing database related applications and software - Responsible for solving database related problems and developing new database programs - Responsible for maintaining and updating new database applications and software - Responsible for providing support and help to the project managers - Maintained a good rapport with the team members - Analyse the OLTP system - Analyse multichannel marketing data - Analyse the DATA for different clients e.g. analyse data for Caterpillar. - Designing and Developing Data Warehouse - Implementing Data Mining Technology OCT 09 - AUG 10 Glocalings Technologies, UK Position: System Analyst and BI consultant Responsibilities - As a system analyst my task is to analysis and design the system from the scratch. - Design and develop data models (Star Schema for DW)and database architecture ( MySQL, ORACLE) - I am responsible for development of new PL/SQL procedures (MySQL and ORACLE) functions (MySQL, ORACLE), create cursor (MySQL, ORACLE) inside of procedures and packages (ORACLE) for implementing the new requirements of database data entries. - Good experience in handling MyODBC as a MySQL connector with other database ( MS Access, Oracle, MS SQL etc,) - Define system requirements by consulting data administrators and system users about the types of information needed - Modifying existing databases, as user needs change - Find faults in programs and resolve the problem - BI solution in ORACLE and SAP BW 7.0 FEB 2005 - JUN 2007 Daffodil Software Limited, Bangladesh Position: Database Developer Responsibilities - As Database developer I was responsible for database design, database development and development of web-based database applications. - As Oracle developer I was responsible for development of new PL/SQL procedures and packages for implementing the new requirements of database data entries. - I was responsible for performance tuning, preparing and installing of patches for new releases of Bangladesh Railway application, database security procedures, backup and recovery procedures, solving emergency database issues in every of supported branches, including remote database administration for emergency fixes. Programming Languages: - SQL, Oracle PL/SQL Operating Systems: - Windows 2000 - Windows 2000 Advanced Server Databases: Oracle9i DEC 2003 - JAN 2005 IBCS-primax, software Bangladesh Ltd. Dhaka, Bangladesh Position: Senior Database Developer and Analyst Responsibilities - As Oracle Developer I am responsible for database maintenance of the Enterprise Resource Planning (ERP) System for the Sheba Telecommunications Ltd, (an Orascom Company). - As Oracle Developer and part of the Development team I am responsible for designing and development of Enterprise Data Warehouse for Grameen Phone Bangladesh on behalf of IBCS-Primax Ltd. - As Database Consultant I am responsible for consulting of company’s clients in case of incidents and database-related problems. - Preparing, Development and Implementing of a procedure for replication between main database and other branch databases. - Maintenance and administration of a production 10g RAC database of the Enterprise Resource Planning (ERP)System for the Sheba Telecommunications Ltd, (an Orascom Company) Bangladesh. Programming Languages: - SQL, Oracle PL/SQL Operating Systems: - Windows 2003 Server Databases: - Oracle10g, Oracle 10g RAC TECHNICAL SKILLS Database Related Technical Skills: Name Last Used Experience Oracle Real Application Clusters Currently Used 2 years Oracle Administration Currently Used 5 years Oracle Development Currently Used 5 years Database Design Currently Used 7 years Oracle Replication Currently Used 4 years Data Warehousing Development Currently Used 4 years Data Mining Currently Used 4 years Distributed Database Design Currently Used 4 years Database integration/Merging Currently Used 4 years Databases Name Last Used Experience Oracle 11g Currently Used 4 years Oracle 10g Currently Used 5 years Oracle 9i 2 years ago 2 years Oracle 8i 3 years ago 2 years Microsoft SQL Server 2008 Currently Used 1 years Microsoft SQL Server 2005 Currently Used 3 years Microsoft SQL Server 2000 2 years ago 3 years MySQL Server Currently Used 4 years Database Administration & Development Tools Name Last Used Experience Oracle Enterprise Manager Currently Used 5 years Oracle SQL*Plus Currently Used 7 years PL/SQL Developer Currently Used 7 years SQL Server Integration Services (SSIS) Currently Used 3 years SQL Server Analysis Services (SSAS) Currently Used 3 years SQL Server Reporting Services (SSRS) Currently Used 3 years Operating Systems Name Last Used Experience MS Windows 2000,2003 Currently Used 5 years Linux Server 3 years ago 1 year Application Servers Name Last Used Experience Apache Currently Used 5 years IIS Currently Used 5 years Languages Name Last Used Experience SQL & PL/SQL Currently Used 5 years PHP Currently Used 4 years XML Currently Used 3 years C++ 2 years ago 4 years Java 2 years ago 3 years Java script Currently Used 4 years HTML Currently Used 4 years Tools Name Last Used Experience Developer Currently Used 5 years Crystal Report Currently Used 5 years ERWin Currently Used 5 years MS Visio Currently Used 5 years Microsoft Office Project Currently Used 4 years SPSS Clementine Currently Used 2 years Methodologies Name Last Used Experience Waterfall Currently Used 5 years Agile, Extreme Currently Used 2 years OOA/OOD Currently Used 4 years RAD 2 years ago 3 years Rational Unified Process (RUP) 2 years ago 3 years Multimedia & Graphic Tools Name Last Used Experience Adobe Photoshop Currently Used 4 years Image Styler Currently Used 4 years Adobe Illustrator Currently Used 4 years Macromedia Flash 2 years ago 3 years Gif Animator 2 years ago 3 years OTHERS - Developing Data Warehousing(very sound knowledge and practical experience) - Data Mining(very sound knowledge and practical experience) - Developing Distributed Database System(very sound knowledge and practical experience) - Database Integration (very sound knowledge and practical experience) - ETL (very sound knowledge and practical experience) HOBBIES & INTERESTS - Computer technology - Internet security - Sport: Cricket, Football - Music - Reading novels PERSONAL STRENGTHS - Designed and implemented several large software projects in various languages - Skilled in a broad range of technical and managerial competencies - Hard-working, dedicated to the business and committed to meeting the business objectives - Excellent communicator, and quick to pick up on technically difficult topics - Responsible and quality-conscious - Do not mind traveling, domestically as well as abroad - Good-humored and non-smoking