Руслан Mамедов

Business scope: Data Migration (DM), Integration, BSS\OSS, CRM, billing, Product Inventory/Order Management (PIM/POM), Customer/Service Order Management (COM/SOM),  Resource Inventory (RI), DWH, Address Book, DMP(digital marketplace)

Current responsibilities:

Organization and holding meetings with the customer;

Analyzing source data and customer's requirements;

Writing Migration and Cutover strategies (Big bang, Delta, Phased);

Working with other streams, analyzing target solutions;

Writing outer (for customer) and inner (for developers) designs;

Project planning;

Planning works for developers and BA by using Task Management system (JIRA/TMS);

ETL design\implementation;

Development of validation scripts of source data;

Development data migration code from source data into intermediate DB and then to the target system;

Checking designs, Optimization of weak points and Checking/refactoring developer's code;

Coordination of work between developers, BA and QA;

Holding the inner meetings to check current works of developers, BA and QA;

Training newcomers and mentoring;

Certificates:
Oracle Advanced PL/SQL Developer Certified Professional (OCP)
Oracle Certified Associate PL/SQL Developer (OCA)
Oracle Database SQL Certified Expert
Java Programming course (36h 17m)

Technical Skills:
● Oracle 19c,12c,11g,10g,9i,8i – about 20 years:
○ SQL and PL/SQL development and design, DataWarehouse.
○ Performance tuning, reading and understanding execution plans, choosing data access strategy, joins, data dictionary views, dynamic performance views.
○ Good understanding of Oracle server architecture (context switching, locking strategy, latches, rollback segments, explain plan, SGA, PGA, wait events and etc.).
○ Physical and logical design, redesign. Partitioning, choosing of indexing approach, large volume (> Tb) schemas design.
○ Optimization, PL/SQL code refactoring, SQL queries tuning, Tracing, Profiling.
○ Data migration, ETL processes design, SQL*Loader, external tables, analytic functions, materialized views, direct path inserts, parallel execution.
○ Working with LOBs, dynamic SQL, Jobs, Schedulers, Oracle Object Types, XML type, own aggregate function implementation. “White-box” approach in development and design.
○ Administration, Datapump, Imp/Exp, tablespace management, archive logging.
● PostgreSQL – about 2 years
○ SQL development, working with JSON types.
○ Data migration from Oracle to Postgress and vise verse.

PL/SQL Developer, SQL Developer, SQL*Plus, JIRA, Confluence, SVN, TOAD, ClearCase, PVCS Tracker, Mashup Bug tracker, MS Project, WinSCP, PuTTY, DBeaver, GIT, MS Office.

Soft skills:

Responsibility, creative approach, analytic thinking, good communication skills, 10 years of experience as Team Lead of developers, BA and QA, working as Lead BA and together with BA, good experience as Data Migration/Integration Solutions Architect, excellent experience in optimizing SQL queries, good experience of training of newcomers and mentoring, excellent task planning, good team player, efficiency, ability to learn quickly, persistence, no bad habits.

Projects history:

• Jan.2024 – Present Project - OSS project for APAC Tier 1 Telco Company (DM, COM\SOM, RI, B2C customers)

Position Name – DM Lead \ Solution Architect, Job Role – Technical Manager (Solution Architect)

• Aug. 2023 – Jan.2024 Project - BSS\OSS project for EMEA Tier 1 Telco Company (DM, PIM, CRM, Billing, RI, B2C\B2B customers)

Position Name – R3 Technical Manager, Job Role – Technical Manager

• Mar. 2023 – Aug. 2023 Project - Cloud project for EMEA Tier 1 Telco Company (Cloud Migration Platform (CMP) (NiFi))

Position Name – Integration TM, Job Role – Technical Manager

• Aug. 2022 – Mar. 2023 Project - BSS project for EMEA Internet Provider (DM, PIM, CRM, Billing, RI, DWH, Address Book, DMP, B2C/B2B customers)

Position Name – Migration TM, Job Role – Technical Manager (Solution Architect)

• Feb. 2021 – Aug. 2022 Project - BSS project for EMEA third largest mobile operator (DM, CRM, Billing, PIM, RI, DWH B2C/B2B customers)

Position Name – DM Solution Architect, Job Role – Technical Manager (Solution Architect)

• Aug. 2019 – Feb. 2021 Project - BSS project for EMEA Internet Provider (DM, PIM, CRM, Billing, RI, DWH, Address Book, DMP, B2C/B2B customers)

Position Name – DM Solution Architect, Job Role – Technical Manager (Solution Architect)

• May 2019 – Jul 2019 Project - BSS\OSS project for LATAM Tier 1 Telco Company (DM, PIM, CRM, Billing, RI, B2C\B2B customers)

Position Name – DM Technical Manager, Job Role – Team Lead (Solution Architect)

• Mar. 2019 – May 2019 Project - BSS project for EMEA Telco Company (DM, PIM, CRM, Billing, RI, B2C customers)

Position Name – DM Manager, Job Role – Team Lead (Solution Architect)

• May 2015 – Mar. 2019 Project - BSS project for LATAM Big Multinational Telecom company (DM, PIM, CRM, Billing, RI, Address Book, B2C customers)

Position Name – Data Migration Lead (TOMS), Job Role – Team Lead (Solution Architect)

• Mar. 2015 – May 2015 Project – BSS project for AMEA International Telecom company (DM, RI, DWH)

Position Name –Migration Developer Lead, Job Role – Sr. Developer (Dev Lead)

• Dec. 2014 – Feb. 2015 Project – BSS project for APAC Tier 1 Telco Company (RDB, CRM, Billing, B2C customers)

Position Name –RDB Developer, Job Role – Sr. Developer (Dev Lead)

• Oct. 2014 – Dec. 2014 Project - BSS project for APAC Tier 1 Telco Company (RDB, CRM, Billing, B2C customers)

Position Name –RDB Developer, Job Role – Sr. Developer

• Feb. 2014 – Oct. 2014 Project - BSS project for APAC Main Telco Company (DM, PIM, CRM, Billing, RI, B2C customers)

Position Name – DM Senior Engineer, Job Role – Sr. Developer

• May 2012 - Dec. 2013: Group of financial statements and custom development
• May 2008- May 2012: Development team
Development of a new functionality, refinement and correction of errors (stored procedures, triggers, collections, security policy, etc.), development of reports (Fast Report) for customers, writing of technical specifications;
Administering Oracle databases, batch processing (export-import, cloning test environments, installation/update subsystems business/logic configuration, granting rights to users, etc.);
Create/update stands for development and testing, installation and configuration of Apache and HAS servers (thin/thick client), installing and configure additional server software systems, installation/upgrade, setting subsystems business/logic, supporting of application servers;
Support/Setup Clear Case;

Maintenance of FORIS OSS system for the customers (Comstar Direct, Skylink);
The introduction of FORIS OSS system to the customers;
Migration of data of CRM and Billing from FORIS OSS system into "East Wind" system;
Development of functional for synchronization of CRM data between subscribers of "Amethyst Absolute" system and subscribers of FORIS OSS (Comstar Direct) system;
Development of functional for payment acceptance from external payment systems into FORIS OSS (Comstar Direct) system;

Setting up a business/logic Oracle database for the customer;
Making statements using report generator Fast Report;
Technical support;
Software installation and configuration at the customer;