MAGSAD MEHDIKHANOV

BSS Domain Architect, Data Engineer

E-MAIL: adkgb1@r.postjobfree.com

TEL.: 571-***-****

Location: Fairfax, VA, United States

Work Authorization: Green Card holder

Linkedin: https://www.linkedin.com/in/mmegsed/

SUMMARY

-I am a professional in different IT segments over the last 20+ years with experience in Telecommunication (Azercell Telecom LLC).

-Implemented different Data Flows, Data Pipelines and ETLs using different ETL/ELT tools either open source or from vendors.

-Developed zero-maintenance data processing tool for massive data processing (in C, ProC, awk/shell scripting, SQL Loader).

-15+ years of experience and deep knowledge in Charging, Rating & Billing, Data Processing, Oracle PL/SQL, optimizing and tuning SQL statements, Unix Shell Scripting, AWK programming, Parallel processing.

-Automated batch processing in different OS environments (Alpha Tru-64, HP UX, Solaris).

-Experience with collaboration tools (JIRA, Confluence, Trello) in Daily Operation as well as in Project Management.

-Experience with Ericsson Charging System, BSCS, EMM and surrounding IT Systems such as Middleware, Order Management, CRM, VAS Platforms, Oracle Databases, Enterprise Data Warehouse, Data Lake and interaction with Telecom network elements such as MSC, SAPC, SASN, EPG, HLR/HSS, FNR.

-Involved actively in technical solutions for services and products, software architecture and development.

-Managed many business-critical projects such as BSS Transformation, 3G Phase II, Charging Modernization, Billing Modernization, 10+ Upgrade Projects with maximum availability requirements.

-5+ years of experience with issuing Tenders for Vendor and Solution selection.

-Prepared RFI and RFPs for BSS full Transformation including (but not limited to) CRM & Customer Channels, Order Capture and Order Management, Service Provisioning and Activation, Product Catalogue, Campaign Management, Mediation Platform, Billing, Off-line Rating, Online Charging, M2M, MNP.

-Managed tender phase of Multi-Tenant BSS transformation with consultancy support of PwC (PricewaterhouseCoopers).

-Implemented ITIL standards in operation and maintenance of IT Systems.

TECHNICAL KNOWLEDGE AND SKILLS

Data Ingestion and Mediation Tools

Apache NiFi, Ericsson Multi-Mediation (EMM)

Databases

Oracle, Cassandra, SQLite3

Operating Systems

HP-UX, HP Tru64, Solaris

Scripting

Shell Scripting (ksh, bash); awk programming

Programming Languages

Python, C, Pro *C, Java (basic)

Database and Query Languages

Oracle SQL and PL/SQL

Billing Systems

Ericsson BSCS (extensive experience)

Charging Systems

Ericsson Charging System (extensive experience)

Charging Interfaces

CS1+, Gy+, eSy, CAP2, CAP3, SCAPv2

IT Service Delivery

ITIL3

Project Management

PMBOK, PROPS-C

Methodologies

Scrum for Agile scope, Kanban for Tests, Smart planning and Waterfall by default

File formats

CSV, XML, JSON, ASN.1, TAP3

Repository System

Git/Bitbucket

Collaboration tools

JIRA, Confluence, Trello

Testing Tools

Selenium WebDriver, Postman

EDUCATION

Bachelor of Science in Mechanics and Mathematics (honors diploma, the highest GPA - 5 out of 5) – 5 years.

CERTIFICATES IN THE RELATED AREA:

ITIL Foundation (2016, Certificate #-311477, Candidate #-VR35175575, http://bcs.org/eCertCheck)

Python (2019, PCAP-31-02, Verification Code - C9Ao.6GB8.tqbx, https://verify.openedg.org)

PROFESSIONAL EXPERIENCE

Azercell Telecom

CIO Advisor- Business Support Systems

(remote from USA) Jun’2019 - present

Main Responsibilities:

-Provide consultancy on Technical Roadmap regarding BSS development and evolution.

-Provide consultancy for proactive problem management initiatives related to BSS and surrounding systems.

-Provide consultancy for optimization and improvement of existing products and services.

-Provide Technical consultancy to other IT teams regarding BSS related projects and end-to-end SLAs.

-Work closely with project managers, solution architects, operational teams, QA, and other IT teams to get high-quality BSS features through the project lifecycle.

-Provide consultancy in resolving incidents and problems related to product and services in a timely manner.

-Executing gap analysis, identifying focus areas, providing improvement recommendations.

Azercell Telecom

IT Support Systems Section

Expert IT Engineer/Senior BSS Architect/Team Head Oct’2014- May’2019

Main Responsibilities:

-Collecting Data from Telecom & IT nodes and transferring to different IT Systems like Data Lake, Billing System, Enterprise Data Warehouse, Active Data Storage, Backup Systems.

-Configuration of New Services and Tariffs, Rating, Charging, Billing, Automation of Batch Processing, Roaming data exchange (+ NRTRDE) in Ericsson Billing System (BSCS) and Charging System.

-Operation and maintenance of all Billing and Charging related systems such as BSCS, EMM, Charging System, roaming data exchange, interconnection, revenue assurance.

-Reduce cost and complexity in IT based on product portfolio rationalization and process simplification.

-Capacity and delivery planning and follow up Service Level Management (SLAs), OLAs and IT-roadmap development support and implementation, Coordination of Life Cycle Management (LCM), Quality & Release management.

-Organizing 2nd level support for BSS and OSS systems. Increasing incident resolution rate via creating instruction for 1st level support, defining and setting OLAs and SLAs.

-Onboarding of the systems to IT support.

-Vendor management, support and maintenance contract management.

-Asset management and TCO of applications and functions.

-Competence Development and IT Resource planning according to short-term and long-term plans.

-Creating RFPs/RFIs, evaluating bidders, selecting successful bidders, evaluating alternatives, creating Investment Decision Commitment Reports, creating a project charters, initiating projects, planning, executing, monitoring & controlling and closing projects, creating lessons learned report.

Key Achievements during that period:

Enterprise DWH modernization

oMigrated from HP Super Dome 2 to Exadata x5-2.

oSAP BO upgraded from 3.1 to 4.1

oCapacity expansion increased 10 times

oPerformance increase is 3-5 times

Centralized Data Reservoir - Data Lake on Cloudera distributive

Billing System port out

oBSCS & RTX DB ported out from Alpha Server to HP Superdome 2 (from HP Alpha True64 to HP UX)

oRemoved performance and capacity limitations

Charging Modernization:

o9 Oracle SDPs replaced with 4 HP SDPs

o4xCCN replaced with 2xCCN + 4xOCC cluster

oTroubleshooting guide for operation team (SME load off)

oCS17A upgrade

Data processing:

oEMM18 upgrade

oKafka Cluster support

Oracle Database Consolidation

oIntroduced PostgreSQL databases in Azercell

oConsolidated the similar databases into One DB

oMigrated from different OS and DB releases to 2 Exadata X7-2 machines.

Order and data processing flow optimization:

oSimplification of flows

oReduced dependency of nodes

oIncreased availability of the system

Azercell Telecom

Billing & Charging Unit, ICT department

Senior IT Engineer/BSS Architect/Team Head May’2009-Sep’2014

Main Responsibilities:

-Creating, executing and monitoring scripts in different shells such as korn, bash and remote shells using connection to Oracle Database.

-Collecting data from the different network elements in the different formats and forwarding towards the destination systems in the required formats.

-Automating Ericsson BSCS batch processes running in UNIX with the automated monitoring and notification capabilities.

-Administration, configuration and optimization of the batch processing engine.

-Troubleshooting the technical incidents & problems and finding the root cause of the issue or the problem.

-Creating and executing SQL statements or Stored Procedures.

-Administration, configuration and supervision of Ericsson Multi-Mediation (EMM) for creating the complex data processing flows.

-Analysis of the business requirements, providing a solution design, creating logical and physical models.

-Developing batches in Pro*C, SQL Loader, shell scripts and awk programming.

-Performance tuning and optimization of SQL statements introducing indexes, creating partitions and adding hints.

-Participating product and service development meetings, providing solutions for system configuration, order capture, order processing, resource management, network provisioning & activation and notification management.

-Changing business configuration of BSS/OSS systems.

-Using different online charging interfaces such as CS1+, Gy+, CAP2, CAP3, SCAPv2 and APIs such as XML-RPC (Ericsson UCIP, ACIP, VSIP), SOAP and REST.

-Integrating legacy OSS/BSS with new IT or Telecom systems and adapting BSS/OSS to changes in surrounding systems.

-Operation and maintenance of BSS/OSS nodes.

-Creating RFIs/RFPs, issuing tenders, managing projects/programs.

Key Achievements during that period:

-Charging Modernization

oEnabling CIP-IP

oEnabling call details for prepaid (in B&C and all surrounding systems)

oCS HW modernization, migration of real-time systems from T5220 to X4270 servers

oCentralized Backup Solution, implemented Netbackup solution from Symantec)

oFlexible USSD

oSubscriber distribution balancing

-Billing

oFolding modernization (2 PFE machines replaced with 2 Neopost machines)

oPrinting modernization (4 Xerox 4525 printers replaced with 4 Xerox Phaser 5550)

-Data Processing and rating

oInterconnect, Revenue assurance, Prepaid revenue calculation

oBonus on incoming call (installation, upgrade and remove)

oNRTRDE support

Azercell Telecom

Different positions in IT department:

IT Engineer, Group Supervisor, IT Coordinator Feb’1998 - Apr’2009

Main responsibilities:

-BSCS batch processing, business configuration, roaming configuration

-Interconnection billing and reconciliation, roaming data exchange

-All kinds of IT activities like installation of OS & business applications, development, IT systems operation and maintenance.

Key Achievements during that period:

-Active data storage – POLIS DB (from architecture to development), AIRDR

-SMS interactive channel for remote operation and monitoring (from architecture to development)

-Folding of invoices

oAutomation of folding process with introduction of new features (barcode on invoices, limits on # of pages, envelope requirements, automated booklet selection)

oOrganization of Local Support, SLAs, Spare stock, Competence development

-Print office relocation and printing reorganization – 4 mid-range printers instead of 1 big printer

-Azeri character support in presentation level (invoices, statements, CR GUIs)

Institute of Cybernetics,

Academy of Science of Azerbaijan Jan’1994 –Jan’2000

Scientific worker

Main responsibilities:

-Scientific research and investigation on academic dissertation

-Discovery of technological concepts in Oil Industry, Design, Software Development, Installation and Handover

LANGUAGES:

Azeri, Native

English, Advanced

Russian, Advanced

Turkish, Fluent

HOBBIES:

Playing soccer

Playing table tennis

MAIN PROJECTS AND ROLES:

Upgrade projects (BSCS, CS, EMM, OMM) – 10+ complex projects in O/BSS domain, different roles (Configuration manager and SW developer, Project Manager, Project Owner)

BSS Transformation– 3 tenders (Project Manager in 2 tenders, Key IT member in 1 tender)

3G phase 2 – Integration with BSS (Project Manager, Solution designer, Configuration manager, Data processing developer).

DWH (BSS SPOC, Data extraction and Data Ingestion developer)

Currency Denomination (System Owner, BSS Architect)

Unit to Currency (from counters to local currency) (System Owner, BSS Architect)

Integration of legacy BSS/OSS with Ericsson SACC

Centralized Backup Solution (Project Owner)

Active Data Storage (Solution Architect, Batch developer, Operation & Maintenance)

REFERENCES:

Anar Abbasov,

T-Mobile US, employee ID-12601729

adkgb1@r.postjobfree.com

Mobile: +1-206-***-****

Murad Bagirov, IT Department

Azercell BSS Platforms Unit Head

adkgb1@r.postjobfree.com

Mobile: +994*********

Rahim Ahmedov, Big Data Department

Azercell Data Engineering Section Manager

adkgb1@r.postjobfree.com

Mobile: +994*********

Sanan Yusifov, Network Technology Department

Azercell Core Network Section Manager

adkgb1@r.postjobfree.com

Mobile: +994*********

Contact this candidate