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*********