Mohammad Rafiqul Islam

Senior Software Engineer

Bdjobs.com Ltd•  August 2015 - Present

 Designed dynamic SSIS packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.  Designing and developing the automated routines (scripts etc.) to facilitate the application development and deployment process.  Creating complex stored procedures using a linked server, CTE, temp table, SQL joins, ranking functions and dynamic SQL and responsible for performing T­SQL tuning, multi­tasking and optimizing queries which takes longer time in execution with SQL server 2012/2014/2016.  Maintaining the product application data which is critical in product lifecycle and efficiently implementing the data migration in each release.  Implementing the heartbeat product role-based security which defines access to each individual functionality based on their role-based permissions.  Involving in database design, application development of health benefits functionality and developed mission-critical benefits eligibility exception report.  Developing SQL routines for complex, enterprise-level application development tasks involving hierarchical tree structures.

Software Engineer

Bdjobs.com Ltd.•  August 2012 - July 2015

 Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, tables, and views to other databases or files with proper mapping.  Developed complex stored procs which consumes and exports data in XL to support payroll/benefits data exchange.  Designed and implemented data marts using dimensional modeling for clients KPI reporting requirements.  Generated ad hoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts.  Creating the database objects ­ schemas, tables, indexes, views, user defined functions, cursors, triggers, stored procedure, constraints, and roles.  Writing the stored procedures and user defined scalar functions (UDFS) to be used in the SSIS packages and SQL scripts.  Extensively utilizing the joins and sub-­queries to streamline complex questions including different table.

DEPUTY SYSTEM ANALYST

University of Science & Technology Chittagong (USTC)•  July 2009 - September 2011

 Networking devices and other infrastructure components  Networking devices and other infrastructure components (to include Wireless technologies)  Desktop PCs, Workstations and Laptops  Desktop PC, Engineering Workstation, Laptop imaging and support  Classified Operations and Desktop PC, Engineering Workstation, and Laptop Support  Audio/visual systems, such as projectors and teleconferencing equipment  Stationary communications devices, such as desktop and conferencing phones

ASSISTANT SYSTEM ANALYST

University of Science & Technology Chittagong (USTC)•  June 2004 - June 2009

 Install and troubleshoot software and hardware for windows.  Monitoring and perform tests and maintenance on servers and workstations.  Resolve issues ranging from resolving registry conflicts to troubleshooting system crashes and performance issues.  Set up computer equipment for pop up requests such as a mobile check in desk or laptops/printers for in-house groups.  Upgrades - prepare for and perform various upgrades to current applications. Perform weekend upgrades to involve testing on various databases and servers to ensure the company will not have down time.  Computers and printers - troubleshoot and repair equipment as needed, connecting remotely to devices in various locations. Use proxy to connect to various computers on the network. Provide 7x24x365 days of support on a rotating schedule with other team members.