Andrei Chernykh

ACHIEVEMENTS:

1. Integration with an additional monetization service - monthly 300 thousand rubles (3 300$);

2. Reduction of payment acceptance costs in 2020: 500 million rubles (5 570 000$), 2021: 120 million rubles (1 336 800$).

3. Reduction of printing and delivery costs of electricity bills by providing paperless bills, saving over 10 million rubles (111 400$) in 2022;

4. Development of metrics for analytics and comparison of conversion rates of paper and paperless bills;

TASKS:

Support of regional structural units (15 Regions; overseeing more than 50 workers) in business processes:

1. Printing payment documents; promotion of paperless bills (+30% in 6 months of 2022);

2. Control of the Delivery paperless bills.

3. Billing of own clients within partner companies;

4. Maintenance of the queue management system in offices;

5. Acceptance of payments from customers by agents, banks (reduction of over 500 million rubles (5 570 000$) in agent commission expenses in 2021 compared to 2020). Support for Bank Card Acquiring;

6. Establishment of a system of proprietary payment acceptance points (over 300 cash registers). Completion of the unified cash system project for all regional structural units in the 3rd quarter of 2022;

Unification and centralization of business processes. Transformation of the existing organizational structure, consisting of local units, into centralized units. Design, coordination, and calculation of labor costs for newly introduced structural units.

Supervision of cost articles to ensure the execution of functional directions.

Centralized procurement organization through tenders.

Completed projects:

1) Printing bills for 9 Regional brunches (procurement format - tender),

2) Development of technical documentation for equipment maintenance contract with queue management system in offices, followed by documentation tendering.

Investment project: supply of equipment for the queue management system in offices, 15 company branches.

Building charts and tables in Excel, data visualization in charts using clickable Excel tools.

Reporting on system performance.

Projects in progress:

1. “Skrepka” - additional monetization from a partner company;

2. Development of online payment service with a new companies;

3. Standardization of individual payment documents for all branches;

4. Development of activities aimed at promoting paperless bills through centralized services.

5. Implementation of payment method using instant payment system for bank card acquiring.

KEY PROFESSIONAL COMPETENCIES AND SKILLS:

- Proficient in the theory and fundamentals of data analysis: probability theory and mathematical statistics, continuous and discrete distributions, hypothesis testing, construction of confidence intervals. Total educational program volume: 400+ hours.

- Proficient in Excel: complex formulas, construction/analysis of pivot tables and basic types of charts, as well as manual adjustment and enhancement, construction of unit economics calculators and scenarios, Power Pivot, and Power Query.

- Good skills in working with SQL: working with MySQL, PostgreSQL, Metabase database management systems, WHERE clauses, JOINs, including conditional, UNION, CASE WHEN, GROUP BY, ORDER BY, HAVING, understanding and using window functions, working with subqueries, ability to use CTE temporary tables.

- Proficient in libraries: Pandas, NumPy, Matplotlib, Seaborn, Scipy.

- Basic knowledge of statistics, A/B testing, analytics process, and metric analysis.

- Experience in conducting vintage and cohort analysis, calculating LT, LTV.

CASES COMPLETED:

- Anomaly detection in the data warehouse.

- Calculation of Retention and LTV of online cinema users.

- Analysis of the dependence of bookmaker's office profit on changes in betting odds.

- Profitability analysis of bonds (with Excel calculator construction).

- Marketing A/B test regarding sending discount offers to users of a music service.

ACHIEVEMENTS:

- Ranked in the top 3 students in the course.

- Completed 6 large-scale educational cases and 20+ homework assignments with an "excellent" grade.

- Provided additional support to the course instructor and assistance in mastering the study material to 5+ classmates.

TASKS:

- Conducted data analysis in various areas, allowing for the identification of key insights.

- Extracted and processed large volumes of data using various tools, ensuring the accuracy and reliability of the information obtained.

- Calculated indicators and metrics, conducted tests and hypothesis checks.

- Participated in workshops and final assessment events, as well as worked in groups, contributing to the development of communication skills and the ability to work in a team.

TASKS:

Organization of the printing process and delivery of electricity bills, with a monthly circulation of approximately 1,000,000 copies. Organization of the delivery process bills to email, development of activities to increase the number of subscribers signed up for paperless bills.

Organization of a branched network of points for receiving payments from customers. Conducting negotiations on the modernization of information exchange, expansion of additional services, and commission rates with Banks. Control over the loading of payment information into the Billing and Payment System.

Organization of payment acceptance in own cash desks. Development of methodology, instructions, cashier training, control of compliance with cashier discipline. Procurement of equipment for cash desks, repair of cash handling equipment.

Signing contracts with contractors for billing and customer service purposes.

Budgeting control, initiation of payment requests for expenditure contracts.

Maintenance of customer service equipment: informational kiosks, electronic queues, informational-payment terminals.

Department staff: 9 specialists.

Organizing the acceptance of the heat supply function from PJSC "T Plus" to JSC "ESb+" in terms of agency contractual arrangements, integrating them into the contractual arrangements of JSC "ESb+" without compromising the heat supply function. Supporting and budgeting agency contracts. Coordination with the Regional Contracting and Procurement Offices (RCPO) on the forms of contractual arrangements. Coordination with adjacent structural units on the forms of reports required for accounting for useful deliveries by agents.

Identification of reasons and factors leading to accumulation of unpaid bills for supplied communal resources. Development of a plan of actions aimed at eliminating or reducing the growth of accounts receivable of legal entities depending on the form of contractual relations with them. Analysis of the proposed plan of actions for compliance with the Federal Law. Development and coordination with related structural units of a package of documents necessary for formalizing relations with customers. Preparation of negotiation scripts for meetings with debtor customers.

Supervising 3 project managers. Structuring the department's work and interactions with related structural units as a result of the company's organizational restructuring. Monitoring and overseeing concluded projects, technical elaboration, and formulation of commercial proposals for tenders in the following directions: Commercial accounting, telemetry, data collection system for meter readings.

Equipment supply process. Supplier search, contract negotiation, shipment monitoring. Consolidation and processing of accompanying technical documentation from suppliers according to the international standard of Total requirements.

Overall project management, interaction with clients, official correspondence, organization of meetings with clients. Compilation and control of project budget execution, adherence to payment schedule, contract management, organization of work at the site, establishment of interactions between employees in various structural units.

Organization of work with subcontractors.

Technical elaboration of incoming tender documentation, determination of labor costs, preparation of cost estimates, preparation of technical specifications.

Types of work: construction, repair and restoration, installation and commissioning, equipment supply.

Examples of projects: creation/reconstruction/modernization of metering and management systems, commercial accounting, telemetry, data collection system for meter readings.

Recovery of accounts receivable for services rendered from counterparties. Conclusion of income/expenditure contracts with subcontractors: preliminary discussions, internal coordination. Analytical work on the implementation of automotive services.

Project work: project administration for the implementation of additional services. Understanding the stages of the process for implementing organizational activities, interaction between employees in structural units. Establishing retail sales from scratch at the sites of JSC "Sverdlovenergosbyt", interaction with subcontractors, preparation of reports, adherence to the payment schedule. Conducting marketing research.

Supervising other accounts receivable. Automating reporting on other accounts receivable. Conducting activities to reduce other accounts receivable. Preparation of documents to confirm provisions for doubtful debts.

Preparation of reporting to the Federal Service for Financial Markets, preparation and development of the Company's Annual Report.

Project work: Registration of land plots in ownership, territory of Sverdlovsk region. Understanding all required stages of the process. Starting from the beginning, ending with obtaining the certificate (land plot surveying, interaction with the Territorial Departments of the Real Estate Management, Administration of the Municipal District, State Real Estate Cadastre).

Effective property management: leasing of premises (search for tenants, conclusion of contractual relations).

Project work: registration of renovations/reconstructions of premises, conducting technical expertise. Organizing the stages of the process for legalizing changes in room layout.

Working with clients in the store. Direct sales. Merchandising and stockkeeping.