Experience

IT_One

• Russian Federation
• Information Technology & Services
• 300 - 400 Employee

• Data & System Analyst / PgSQL Developer / BI Engineer

  • Dec 2020 - Present

  Description: No project and team change (see prev. pos.). Continued with Tare accounting project (2.5-4 people involved). Gained responsibility from management for the whole project and Tare system development. Also gone a level lower, to SQL development: refactored and fully migrated Tare accounting database (~40+ tables); cleaned wrong technical implementations; optimized data processing/queries for better performance. Also switched to requirements verification by direct code (sql, java) review as more efficient way to check for errors. In 2022 adopted Metabase BI reporting system as BI for project. Developed most dashboards (> 20) and statistics collection jobs (~10). Til May 23 continued to evolve Tare accounting system combining roles: Product manager/Owner, System Analyst/Designer, SQL Developer/DB Designer, Tester / Code reviewer, BI Engineer and User education activities. On IM from May 23. Customer: Internal, within RussianPost Responsibilities & Activities: • Primary responsible for project development (small team: 2-3 developers incl. me for SQL part; 1-2 testers; 1-2 people in support); • Data & System Analyst activities; • PostgreSQL overall data processing flow design, incl. parallelization issues; DDL Design and SQL programming; Query optimizations; Data Migrations; Procedural Data processing; statistics collection and so on (vols: 50GB-200GB); • Metabase BI reports development (https://www.metabase.com/); • Story/Business-logic impl. acceptance through Java code review with Developer; - • Simple Python scripting for data transfer between DBs, load testing and other small tasks. Show less



Luxoft

• Switzerland
• IT Services and IT Consulting
• 700 & Above Employee

• Analyst

  • Jun 2018 - Dec 2020

  Summary: Worked in "SortMaster" dev. team delivering solutions for RussianPost internal and international logistics. Made logical design of reference data management subsystem ("NSI" in Ru domain), helped with ETL tasks on adopting UPU code lists and NSI integration tasks with substituted system. Then was switched to Tare accounting domain, where designed data processing algorithms (~1.2 million messages per day), business processes and UI forms, controlled implementation. Customer: Internal, within RussianPost Responsibilities: Analytical ones with tendency to control technical side more than standard IT BA within Sortmaster team does. Black-box testing of NSI and Tare accounting systems. Achievements: Proved ability to design logically/conceptually systems/subsystems of small/medium complexity (system analysis). Normally, due to design/model tendency, got lower scores as IT Business Analyst. But regain value by application of data analysis/transformation skills. Show less



ANT-Inform

• IT Services and IT Consulting
• 1 - 100 Employee

• Lead System Analyst

  • Sep 2011 - Mar 2018

  Domain: 1. Gas supply in Russia (mrg.gazprom.ru segment); 2. Automated dispatching control systems (ADCS). Projects: 1. Single Technological and Information Area (~ 100 organizations involved), 2. ADCS for MRG, vertical integration of MRG and 47 Regional gas supply companies based on cross-functional automated business processes. Responsibilities: 1. While producing a solution: • Understand initial business case and problems to be solved; • Study how work is currently done (“AS IS” business processes); • Elicit and document stakeholder requirements; • Develop “TO BE” solution/business processes (BPMN); • Develop functional/process architecture; • Engineer system requirements, perform formal sign-off; • Engineer detailed requirements/solution logic specs (UML); • Control technical decisions; • Maintain requirements & sync fully with software dev. team; • Work closely with QA team to test implementation results. • Participate tightly in UAT; • Work out and close issues. 2. Fixing a solution: • Make necessary changes to the specs according to hidden or new requirements revealed; 3. Supporting a solution: • Analytical participation to clarify project decisions and to perform problem analysis. 4. Evolving a solution: • Follow p.1 – 3 above to change functionality according to ongoing business demands. Depending on a scale some responsibilities were applied in a team, some individually. Environment: 1. Challenge to substitute ADCS MRG system and cross-functional processes which were in production for 12 years; 2. Added complexity due to ongoing horizontal & vertical integrations with related systems; 3. Highly regulated area (a lot of normative documentation and laws). Main achievements: 1. Successfully accomplished projects; 2. In 2016 was promoted to Lead System Analyst position. More detailed description to be provided upon request. Show less



IE Meledin Aleksei Vladimirovich

• Individual entrepreneur

  • Sep 2010 - Jul 2011

  Attempt to work independently on an official basis. Freelance projects, Mobile/Cloud Technology Area, SaaS. Attempt to work independently on an official basis. Freelance projects, Mobile/Cloud Technology Area, SaaS.



IBCon, Ltd

• Business Analyst

  • Jul 2009 - Aug 2010

  Management supporting analytical and research activities; IT Analysis; Capital construction, Oil&Gas area; Was involved in several marketing and implementation projects, such as application concept development for “LenVO” and planning improvement projects at Lengiproneftehim Institute. Management supporting analytical and research activities; IT Analysis; Capital construction, Oil&Gas area; Was involved in several marketing and implementation projects, such as application concept development for “LenVO” and planning improvement projects at Lengiproneftehim Institute.



GET Information Technology GmbH

• Germany
• IT Services and IT Consulting
• 1 - 100 Employee

• System Analyst

  • May 2008 - May 2009

  Analysis & Specification, Oil&Gas, Energy field; joined development of project management web application: analyzed requirements and wrote UML based specifications. Analysis & Specification, Oil&Gas, Energy field; joined development of project management web application: analyzed requirements and wrote UML based specifications.



KI Club

• Coach / Manager

  • Sep 2005 - Jan 2007

  Education, Non-commercial; Health-care and personal development area; changed profession and moved to the area concerned with ZYQ education: organized and conducted training sessions; applied IT knowledge and skills for web-site development and maintenance. Education, Non-commercial; Health-care and personal development area; changed profession and moved to the area concerned with ZYQ education: organized and conducted training sessions; applied IT knowledge and skills for web-site development and maintenance.



Luxoft

• Switzerland
• IT Services and IT Consulting
• 700 & Above Employee

• System Analyst

  • Oct 2004 - Jul 2005

  Was employed to work on Dell's project related to Logistics & Manufacturing processes automation: mostly participated in defects resolution; specification development and solution logic definition were at customer site. Was employed to work on Dell's project related to Logistics & Manufacturing processes automation: mostly participated in defects resolution; specification development and solution logic definition were at customer site.



Advanced Technologies Group

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Business / System Analyst

  • Nov 2001 - Jul 2004

  Was involved in a FOREX software development (~ 25 empl.), primary responsible for communication with a business analyst on site, requirements systematization, analysis and modeling, development of RUP’ style “Vision” and SRS documents, design of functional modules logic, functional testing and benchmarking. As some Developers participated in analysis efforts, lectured on OOA and Requirements. Was involved in a FOREX software development (~ 25 empl.), primary responsible for communication with a business analyst on site, requirements systematization, analysis and modeling, development of RUP’ style “Vision” and SRS documents, design of functional modules logic, functional testing and benchmarking. As some Developers participated in analysis efforts, lectured on OOA and Requirements.



DMY Software, InterForge, Prom-Invest-Audit

• Developer / Manager

  • Jul 1997 - Aug 2001

  07.2000-08.2001: DMY Software (ENG) [~25 empl.], Web Department Manager: worked on a project concerned with web components development for US customer: managed and controlled efforts of a team of web developers (3-8 empl.); was primary responsible for requirements, analysis & design, architecture efforts; organized and performed code inspection; participated in code development (Java, SQL) and framework components evolution. 05.1999-07.2000: InterForge (RUS) [~3-4 members], Manager/Owner: created and organized a small team of web developers; combined management, administrative, marketing functions with system and DB administration (FreeBSD, PostgreSQL), and web development (Java, PHP); designed some proprietary framework components for rapid application development using JSP technology. 06.1997-05.1999: Prom-Invest-Audit (RUS) [~30-40 empl.], Engineer-Programmer: performed functions of system administrator (LAN, WinNT, FreeBSD) and Web-Developer (HTML,C++, CGI, SQL, ErWin). Developed and maintained company web-site. Show less