Md Humayun Kabir

Phone: +1-475-***-****

Email: adzg2i@r.postjobfree.com

Linkedin: ClickHere

Summary

Proficient in Data Analysis, Database Design and Data Modeling, writing SQL Queries, Query tunning, TKPROF, Database Trace, SSIS, SSRS, Cursor, Trigger, Stored Procedures, User Defined Functions, Views, datatypes CLOB and BLOB, OLAP and OLTP. Good experience in Oracle, SQL Server 2005/2008/2012/2016, MySQL, Sybase, DB2 etc.

Worked with RDBMS and Normalization technologies.

Provide innovative solutions to problems and drive the design/development of components, ETL, Unix, Oracle, MySQL, SQL Server, PostgreSQLs, SQL etc.

Experienced in data migration for numerous databases. Wrote numerous PL/SQL scripts for data migration. Worked with Pentaho Data Integration (ETL) tool, SSIS, SQLLDR, BCP etc.

Hands-on experience working with large and complex datasets.

Expertise in Shell and Python Scripting.

Ability to work on Agile Scrum Methodology to meet timelines with quality deliverables.

Worked with Jira for project maintenance and daily worklog entry with the in Sprint.

Resourceful in Telecom BSS operation e.g., Postpaid Billing System, Interconnect System, International Roaming System, Mediation, Provisioning etc. Have hands on work experienced with postpaid billing system TABS (Telecom Advanced Billing Solution) 6.0, TABS 7.0, BSCS 6.0, VNU etc. and have adequate postpaid billing migration experience for multiple billing systems.

Have expertise in Revenue Assurance and Fraud Management System for Telecom Operator.

Expertise in Microsoft .NET Framework (3.0,3.5, 4.0, 4.5), ASP.NET, C#, VB 6.0, SQL Server and development, consuming and manipulating data using ADO.NET.

Developed numerous applications from scratch, worked with multiple projects and developed core functionalities involved in complete Life Cycle including Analysis, Design, Development and Testing.

Ability to plan and implement all the different stages of Software Development Life Cycle including System Analysis, User Requirements Determination, Data modeling, Coding, Implementation and Testing.

Experience in using GIT, GitHub for Version Control.

Have experience in vendor communication for new change request, testing and implementation and feedback. Have project management and team management skill.

Work in a fast-paced environment, under minimal supervision providing technical guidance to the team members.

Have strong analytical skills, able to handle complex situation and have can do attitude and can work under huge pressure to meet the deadline and always like to work in diversified area and with new technology.

Experienced working in a collaborative, team-oriented setting

Experienced in Microsoft Office applications

Technical Skills

Databases Oracle 8i/9i/10G/11G/19C (PL/SQL), MS SQL Server 2016/2014/2012/2008 R2/2005, MySQL 4/5, SYBASE, SQL Server, PostgreSQLs, DB2 etc.

Languages & Scripting VB 6.0, Power Builder, C#, Python, Shell Scripting, Perl Scripting, Cake PHP, Bootstrap, HTML, CSS, XML, JSON etc.

Editors/Tools MS Visual Studio.NET 2022/2015/2013/2012/2010/2005, SQL Management 2012/14/16, Transact-SQL (T-SQL), SSIS, SSRS, Power BI, SQL Developer, Toad, workbench, SQLLDR, BCP, Putty, FileZilla, SSH Client, TextPad, Notepad++ etc.

.NET Technology VB 6.0, C#, ASP.NET

Web/App Server Web Server: IIS 7.0, IIS 6.0, APACHE.

Operating Systems Microsoft Windows, Linux etc.

Report Tools Crystal Reports 9.0/10, iReport 5.6.0, Jasper report studio 6.4.3.

DevOps Culture Agile methodology, Scrum, Sprint, Jira, Git, GitHub, CI/CD Pipeline, Jenkins, Docker etc.

Professional Experience

03/2023 - Present TATA Consultancy Services, Client: NextEra Engergy

Senior PL/SQL Developer

Technology Company providing enterprise solutions

Providing day to day operational support for energy charging and billing system (GEMS).

Reviewing Power Builder code, JSP scripts, Java code to articulate GEMS business understanding for dispute resolution and also for GEMS migration purpose.

Working as a key migration team player from old legacy system GEMS to new system Orion for Energy Management System.

Developing PL/SQL store procedures, functions, views triggers etc. in Oracle/MSSQL, reviewing existing PL/SQL procedures, functions, triggers, views for any modification for migration support and drive continuous improvement.

Developing DTS tasks in SSIS package for data extraction into migration DB, generating interface file for Orion system using migrated data and SSRS reporting for GEMS migrated customer.

Preparing UAT document, writing test case scenario and performing UAT for trial migration activities in test environment.

Facilitate discussions among other developers to exchange new ideas and improvements.

Coordinate with Agility teams and project managers to execute a complex migration.

Interface with cross-functional teams to develop and implement database solutions, GEMS app. Change management using Agile development methodologies.

07/2021 - 03/2023 Red.Digital IT Limited

Lead Database Developer/Analyst

Technology Company providing enterprise solutions

Worked as a Data Migration Team lead from PostgreSQL to MSSQL, MSSQL or ORACLE and MSSQL TO MSSQL for a Telecom operator for their new system RDMS (ROBI Distribution Management System) from the old legacy system STS (Sales Tracking System).

Coordinate with DevOps teams and project managers to execute a complex migration from Oracle to Microsoft SQL Server, create stored procedures, functions, triggers, cursors, views, perform database development, and drive continuous improvement.

Interface with cross-functional teams to develop and implement database solutions using Agile development methodologies.

Provide day to day operational support and resolved disputes for Electronic Telecommunication Subscriber Affiliation Form (ETSAF)

Re-vamped 05 same type of large tables of ETSAF database into single partitioned table and migrated there 250M records.

Provide operational support and resolved disputes for multiple RPA e.g., Advance/Claim RPA, Campaign broadcasting RPA, Un-willing GPRS data pack purchase adjustment RPA etc.

Re-vamped Advance/Claim RPA using python scripting into one simple RPA and for featuring error handling in VB script while committing transaction into SAP and email notification to the stakeholders with Oracle and Python interfacing with SAP.

Developed Email alert application for Oracle Jobs for ETSAF, ECRM systems with Python.

09/2018 - 06/2021 Segmatek Software and Solutions Ltd.

BSS Senior Engineer / Data Analyst

Technology Company providing support for Software and Telecom based Services

Providing support as L1/L2 to multiple telecom operators (BANGLALINK, Epic Cyprus, MTN Sudan and Syriatel) for TABS (Telecom Advanced Billing Solution) rating, billing, interconnect and roaming system and call center applications for TABS issue resolution.

Resolving day to day error or disputes or any issue occurrence in real time 24/7 for TABS application.

Communicating upper layer with offshore team for any resolution if required. After receiving solution from head quarter Cairo, performed UAT in test env and then deliver to customer and played active role for deployment in production environment.

Communicate with customer for issue detail that has been raised and follow up customer for issue to close.

Developing trigger, procedure in ORACLE and shell scripting as per business or customer requirement.

10/2017 - 09/2018 Aerobill IT

Senior System Analyst

Technology Company providing Software Solutions

Played leading role to manage small size 4 to 5 members

Working for System Design and Development

Performing System tuning, UAT and Validations

Checking system security and vulnerability

Developing PL/SQL procedures for various accounts, inventory, and sales reports

08/2013 - 10/2017 IBM Bangladesh Private Limited

Lead IT Representative

Technology Company providing support to airtel Bangladesh

Played leading role to manage small size 4 to 5 members for rating, billing, interconnect and international roaming system operation and maintenance.

Resolving billing disputes and charging issue, IOT disputes and roaming revenue disputes etc.

Developing small applications using shell script, PL/SQL, C# as per business requirement.

Developed application in shell script for Airtel roaming subscriber's data bundle offer which TABS roaming did not support

Enhanced and Developed PL/SQL procedures for Billing Time Discount for customer which system did not support

Developed PL/SQL procedures to subtract Supplementary Duty and Surcharge from TAX amount to show in customer bill copy.

Enhanced and Developed shell script for performance tuning of existing e-bill execution process.

Developed PL/SQL Script for Content's Providers revenue generation report and for mediation end to rating end CDR performance report

Developed Oracle Cursor to update customer credit limit for package change done and Trigger for CDR segmentation.

Responsible to migrate IT Billing systems of Airtel Bangladesh for Rating, aggregation, incentives, and Interconnect from TABS6 to TABS7 Implementation.

09/2008 - 07/2013 Airtel (BD)

Telecom Operator, Senior Executive Revenue Assurance

Developed VOIP Auto barring application for postpaid and prepaid subscribers with c# and Oracle.

Developed CP revenue data aggregation process through Oracle PL/SQL procedures to validate IT generated CP revenue data

Developed application with c# for CP revenue generation report in PDF to share among all the CPs for their invoicing to Airtel

Performing verification and establishing control between two points from collection of CDR to invoicing to ensure almost 0% revenue leakage.

Establishing effective controls and quality checks on billing data, records and detection of billing frauds.

Identify leakage and its root cause and take initiatives to fix that with the help of operational stakeholders.

Ensuring and establishing effective documentation and quality control records.

Developed generic file up loader application with c# to upload data into Oracle database.

Performance tuned of existing HLR parser to get faster output of HLR dump to reconcile with TABS dump.

Developed Interconnect Billing System only through PL/SQL procedures to encounter IT generated receivable and payable amount

Developed Postpaid Rating System only through PL/SQL procedures to validate daily rated CDR of TABS charging system.

Developed complex report through PL/SQL procedures to validate any discrepancy in Easy Load Transfer from Airtel bucket to distributor and from distributor to Retailers

Validate and perform UAT whenever new system needed to be implemented in network or IT dept.

for e.g., MAGIC, PreTUPS, AIR CS4 and GGSN etc.

Validating daily basis distributor and retailers opening and closing balance and transfer amount from distribution management system from RA.

Developed Prepaid Customer life cycle validity checking control and prepaid activity dashboard

04/2004 - 08/2008 TM International (BD) Limited

Telecom Operator, System Analyst

Managed provisioning request to HLR, AUC data upload and reconcile Billing & HLR subscriber's dump

Resolved billing problem submitted by CSR

Worked in database development. Provided operational support for Interconnect System, prepared monthly necessary memo for invoice and bill verification.

Credit Control System Monitoring and maintenance and Operational Support to International Roaming Services

Exchange rated file to Roaming Partner

Determining scope, strategy, data mapping, business process mapping e.g., Interconnect System, Credit Control system, Customized Cell Restriction utility (CRU) and Friends & Family Number (F&F) for billing system migration.

Major Projects:

VOIP barring application for Telecom operator, Platform- c#, Oracle.

Prepaid CDR filtration from MSC postpaid CDR, Platform- Shell Script, Oracle.

Roaming Subscriber's Data Bundle Offer in TABS roaming system, Platform- Shell Script, Oracle.

AKTEL International Roaming Services (AIRS) Platform- Power Builder, Sybase.

Enhanced Auto blocking Utility (EABU) for AKTEL Platform- Power Builder, Sybase.

Huawei MSC CDRs Translator developed for AKTEL Platform- Power Builder, Sybase.

Education

Bachelor of Science in Agriculture 1993

Contact this candidate