Семен Горелов - Резюме Analyst

I am a results-driven Business and Systems Analyst with over 4 years of experience in logistics, warehousing, and e-commerce. My core strength is acting as a bridge between business operations and IT. I have managed end-to-end requirements for major projects, from AS IS/TO BE process analysis using BPMN, to writing technical specifications for 1C and API integrations. On the data side, I build end-to-end BI solutions in Power BI. I write complex SQL queries to pull data from Teradata and MySQL, clean it in Power Query, and build dashboards that drive decisions—for example, creating an OEE dashboard that saved 11 hours of manual work per week for shift supervisors. I’ve successfully replaced legacy Excel processes with automated systems, such as launching an electronic code issuance service and a claims management module in 1C, which eliminated human error in penalty calculations. My focus is always on business outcomes: reducing costs, speeding up time-to-market, and enabling self-service analytics.

Associate degree

1. Business Analysis & Requirements Management: - End-to-end requirements management - Business process analysis (AS IS / TO BE) - Business process modeling (BPMN, UML Activity & Sequence diagrams) - User Stories & Use Cases development - Functional & non-functional requirements development - Business requirements elicitation - Gap analysis 2. Data & BI (Business Intelligence): - SQL (MS SQL Server, MySQL, Teradata, JOINs, window functions) - Power BI (end-to-end dashboard development) - Power Query (data cleaning & transformation) - Deep-dive data analysis & root cause analysis - KPI monitoring & anomaly detection - Ad-hoc hypothess testing - Data visualization 3. Integration & Technical Specifications: - API contract development (REST/SOAP) - Integration algorithm design - Database structure description - Technical specifications (TS) writing for development teams (including 1C) 4. Testing & Quality Assurance: - User Acceptance Testing (UAT) - Manual functional API testing (Postman, SoapUI) - UI testing - Test case creation 5. Warehouse & Logistics Operations: - Warehouse process analysis (inbound/outbound control) - Warehouse topology & rotation optimization - Inventory management (weekly, quarterly, annual) - Product card management - Storage characteristics configuration - Logistics process analysis 6. Documentation & Training: - User documentation / user manuals development - Knowledge base creation - User training & demo conduction - Change management (legacy to automated systems) 7. Methodological & Analytical: - Customer journey mapping - Voice of Customer (VoC) formalization - A/B testing design & evaluation (sample size calculation, significance testing) - Time-to-Market support - Post-implementation metrics collection & reporting

Английский

Additional Information:

1. Tools & Tech - Power BI, Power Query, DAX, Postman, SoapUI, DBeaver, MS SQL Server, MySQL, Teradata, draw.io, Visio
2. Languages - Russian (Native), English (B1 – Intermediate)
3. Certifications - SQL for Data Analysis – Stepik, Power BI – Microsoft Learn
4. Methodologies - Agile (Scrum, Kanban), Waterfall, UAT, Change Management
5. Soft Skills - Cross‑functional communication, facilitation, root cause analysis, user training
6. Other - Driving license (Cat. B), ready to relocate / remote, portfolio available upon request