Mike Shmuylovich

Skype: mishashm**

acat3s@r.postjobfree.com

LinkedIn profile: www.linkedin.com/pub/michael shmuylovich/33/714/895

+7-903-***-**** (mobile in Russia)

GREEN CARD HOLDER (will be in the beginning of 2014)

PL/SQL Developer, Analyst

Summary

Many years’ experience in Application Development and Systems Analysis: Databases

•

(Oracle, MS SQL), PL/SQL, Stored Procedures, Triggers, Table Indexing, Complex Queries,

Dynamic SQL, Analytical functions, Query Optimization, Debugging, and Tuning,

CrystalRepors, FastReports, VB, C++, PoweBuilder, WEB, XML, Java. Knowledge of the full

system development life cycle.

Strong background in Requirements gathering and Business processes modeling: Use

•

Cases, UML, eEPC, ErWin, MS Visio, MS Office, data analysis and GAP analysis. Technical

and QA specifications.

Strong experience in communication with stakeholders both written and verbal. Making

•

presentations.

Extensive experience in Telecom domain: Billing, Rating and Charging, Customer Care,

•

Revenue and Debt management, CRM, NGN, TMF’s eTOM/TAM.

Experience in working with major telecom operators, including Production environment.

•

Experience in management of workgroups of up to 10 people.

•

Proven ability to solve problems in tight deadline environments.

•

Professional experience

11/2004 Current, PL/SQL Developer, Analyst, Peter-Service, Moscow, Russia

Develop Functional and Systems Requirements Specifications documents. Write PL/SQL modules

and scripts, develop reports. Design of database structure. Interact with all sides of the process of

development of the current OSS/BSS system including clients, developers and support specialists.

Participate to most of the steps in implementation of the comprehensive solutions to cover our client’s

needs and requests. Manage 5 7 people workgroups of developers and support specialists.

The list of projects includes but not limited by the following:

Building the new OSS/BSS solution based on Amdocs products in the largest Russian

•

telecommunication holding company “Svyazinvest”.

The “Svyazinvest” consists of many of the wired and wireless telecom operators across all

over the country. Totally they have had millions of clients being served by more than 180

different software systems. The goal of the project was to replace all of these different

incompatible systems to the one integrated solution from Amdocs Company. Worked side by

side with the colleagues from Amdocs and from other subcontractors during the process of

refining the requirements to the Interconnect and Partner Management systems. Played an

expert role during sessions with the client's representatives, made the presentations, wrote

the Requirements Specifications documents and participated to discussions with development

team.

Switching the billing system of the Russia’s second largest mobile operator “MegaFon” to the

•

local currency instead of previously used USD.

Historically the “MegaFon” used the USD as the internal currency for rating and billing

purposes although the local currency in Russia was "Ruble". It was very inconvenient so they

decided to switch to the usage of the local currency. It wasn't so simple task because the

transition had to be done on the running system without any interruptions in the service and

included many hardware and software components working together. I played one of the key

roles in the process of the requirements collection, identifying involved subsystems, writing

the technical documents, creating the transition plan, developing the auxiliary software and

consulting the clients. It was very tight project, all had to be done in one night and had to be

as sutureless as possible.

Implementation of the Billing system in the oldest mobile operator in Moscow “SkyLink”

•

“SkyLink” decided to switch from previously used "homemade" billing system to the solution

from Peter Service. One of the key tasks was integration of the existing corporate warehouse

software with our billing system. In a short period of time the "gap analysis" was performed

and the requirements to the missing functionality were identified. Then the integration layer

was quickly developed and provided to the client. The job was to identify the borders of this

“gap” between two systems and to propose how to “fill” it in the given time frame.

Transition to the new accounting policy in the Russia’s second largest mobile operator

•

“MegaFon”

During the subscribers migration process from the previous billing system to the new one,

made by Peter Service, it was discovered that the bookkeeping policy for these subscribers

have to be changed. In a short period of time the workaround solution was implemented and

delivered. This software solution was consisted of a bunch of auxiliary software modules and

recommendations how to use them in the current business processes. Providing this solution

allowed us to keep the schedule that was critical for the total migration process.

Implementation the Billing solution in the Moscow branch of Russia's leading long distance

•

provider “Rostelecom”

The Moscow branch was going to switch from their current billing system to the Peter

Service's system. I communicated with the client’s representatives to study functionality of

their current system and to identify the requirements for customizations and settings which

had to be implemented in the new billing system. According to those requirements the System

Requirements Specification document was written. Also led a group of implementation and

deployment.

Tools: MS Word, MS Visio, MS PowerPoint, PL/SQL Developer, FastReport, ErWin, Eclipse

01/2004 10/2004, Business / Systems Analyst, Home Credit and Finance Bank, Moscow, Russia

Collected and refined change requests from different bank’s departments. Wrote Requirements

Specification documents. Consulted the implementation team to make they did correct work. The

main business of the bank was consumer lending, so there were a lot of local offices across all over

the country. Additionally, the bank’s headquarter was situated abroad (Czech Republic) where the

Scoring system was situated. Launching almost every new bank’s product or marketing action usually

demanded adjustments in software or business processes.

Tools: MS Word, MS Visio, MS SQL, MS VisualBasic, Rational Rose, Rational Requisite Pro

05/2002 12/2003, Application Developer / Systems Analyst, Mango Telecom, Moscow, Russia

Collected change requests to the billing software from business units. Managed the team of

developers and testers during implementation of the new functionality and fixing of bugs. Consulted

and supported the business users.

Tools: Informix, Borland Delphy, ANSI C, MS Word, MS Visio, MS Project

12/1999 01/2002, Lead Software Developer / Analyst, Protek, Moscow, Russia

New version of Revenue Management and Debt Collection system was developed. Held discussions

with clients’ representatives to refine the business requirements and ways of their implementations.

Wrote Technical Specification documents. Implemented the core PL/SQL procedures and packages.

Led the workgroup (tasks distribution, consulting and participation in scheduling the work with Project

Manager).

Tools: Oracle SQL, PL/SQL, PowerBuilder, Rational Rose, Rational Requisite Pro, Rational Clear

Case, MS Word, MS Visio, MS Project, MS SourceSafe

11/1998 12/1999, Software Developer, Standard & Western Software, Moscow, Russia

Made customization in the ERP Solomon (currently called Microsoft Dynamics). Programmed both

front end and back end sides, created and customized several reports.

Tools: MS VisualBasic, MS SQL, Pervasive SQL, Crystal Reports

11/1995 10/1998, Software Developer, Lanx, Moscow, Russia

Participated in development of Warehouse Management System. Programmed both front end and

back end and reports.

Tools: PowerBuilder, MS VisualBasic, Power Designer, MS SQL

04/1994 11/1995, Software Developer, InvestSber Bank, Moscow, Russia

Participated in development of Securities Management System. Programmed both front end and

back end, reports.

Tools: C++, PowerBuilder, ERWin, Oracle SQL

Education and training

Moscow State University of Railway Engineering, Diploma, 1994

•

Object Oriented Analysis and Design of Information Systems with UML and Rational Rose, IT

•

Academy, Certificate of completion, 2001

Technology of CORBA, Interface Ltd, Certificate of completion, 2001

•

Training in Java, internal courses, 2013

•

Training in JavaScript, internal courses, 2013

•

Contact this candidate