Md. Shohel Rana

Assistant Database Administrator at Sysnova Information Systems Limited
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Dhaka, Bangladesh, BD
Languages
  • Bangla Native or bilingual proficiency
  • English Full professional proficiency
  • Urdu Full professional proficiency
  • Hindi Professional working proficiency
  • Arabic Elementary proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Bangladesh
    • Software Development
    • 1 - 100 Employee
    • Assistant Database Administrator
      • Jul 2016 - Present

      ERP Functional: - Working on web based open source ERP (Adempiere & iDempiere) developed by Java and PostgreSQL - Working with different modules like procurement, production, accounts, sales & distribution, payroll, asset maintenance, and billing etc. - Implement new business requirements and processes of different industries like poultry and food in ERP - Upload all kinds of master data including production recipes, fixed asset, and journals using import loader - Support ERP end users to troubleshoot operational issues and fix data anomalies Technical: - Perform database administration, maintain, update, ensure data security, backup and recovery in PostgreSQL - Checking database log and perform tuning on different tables, queries proactively - Collaborate development team with proper guidelines of database design and planning - Write DDL, DML statements in backend - Design, develope, update and tune all kinds of MIS reports Show less

    • Senior Management Executive (Database)
      • Apr 2016 - Jul 2016

      - Responsible for working on different modules of Oracle EBS including Accounts Receivable, Accounts Payable, Purchasing, Order Management, Advance Pricing for Order Management, Landed Cost Management.- Worked on successful implementation of Fusion Accounting Hub Reporting Cloud Service (FAHRCS) under Oracle EBS implementation project.- Checked RMAN backup schedule done by crontab and data and archive log backup files- Created new service request (SR) in Oracle website to get solved EBS malfunctioning and followed up running SR- Maintained, verified, created all kinds of master data in Oracle EBS- Designed new RTF report template using Oracle BI Publisher Add-ons- Maintained IBM Servers (Production, Test and DR) and worked with server vendors- Maintained and managed Datacenter and worked with datacenter vendors Show less

    • Senior Executive (Database)
      • Apr 2014 - Mar 2016

      • Team Lead in Oracle Financials, Purchasing and Landed Cost Management modules under Oracle EBS Implementation Project • Vendor Management of IBM Servers and Co-Location (Data Center) Services • Database administration, planning, design, performance tuning in SQL Server 2008 R2 database • Perform Database backup and recovery activities in SQL Server 2008 R2 database • Configure and maintain high availability options (Replication and Mirroring) of database • Trace user actions in ERP using client side (SQL Server Profiler) & server side tracing mechanism • Write complex queries, views, stored procedures, triggers, indexes in SQL Server 2008 R2 • Working with the different ERP modules (Accounts, Sales, Distribution, Inventory & HR) • Provide training of the ERP software to the users• Configure and monitoring SMS notification system in ERP • Design MIS reports as per management requirements using iReport 4.5• Website design & development using HTML, CSS Show less

    • Executive, MIS
      • Aug 2012 - Mar 2014

      Oversee all of the database administrative tasks including backup planning, disaster recovery, high availability, query optimization, profile tracing etc. Worked on building npoly's own data center for managing servers. Need to write complex triggers, stored procedures, views and functions. Also maintain ERP software and support users. Perform ERP new version unit testing and implementation. Design & Development of corporate website. Provide office software support, computer troubleshooting and basic IT support. Show less

  • H.K.Chemicals
    • Tantibazar, Dhaka
    • Assistant Manager
      • Dec 2010 - Jun 2012

      I have involved in purchasing, selling, all the banking transactions, import through L/C, stock management, and dealing with parties. I have involved in purchasing, selling, all the banking transactions, import through L/C, stock management, and dealing with parties.

Education

  • American International University-Bangladesh (AIUB)
    Bachelor of Business Administration (BBA), Management Information System (MIS)
    2005 - 2009
  • Dhaka Commerce College
    Higher Secondary Certificate (HSC), Business Studies
    2002 - 2003
  • St. Gregory's High School
    School Secondary Certificate (SSC), Business Studies
    1999 - 2001

Community

You need to have a working account to view this content. Click here to join now