Andrew Troukhan available

Andrew Troukhan

Senior Consultant SAP BI/BW

available
Profileimage by Andrew Troukhan Senior Consultant SAP BI/BW from Minsk
  • 22000 Minsk Freelancer in
  • Graduation: Software and Administration Information Systems
  • Hourly-/Daily rates: 35 €/hour 280 €/day
    Remote work rates
  • Languages: English (Full Professional) | Russian (Native or Bilingual)
  • Last update: 10.12.2018
KEYWORDS
PROFILE PICTURE
Profileimage by Andrew Troukhan Senior Consultant SAP BI/BW from Minsk
ATTACHMENTS
CV SAP BI consultant
The download of this file requires a paid membership.
SAP Portfolio
The download of this file requires a paid membership.
SKILLS
KEY SKILLS
Business warehouse:
? SAP BW NW 7.0-7.4
? SAP BW on HANA
Analytical reports:
? Analyzer (BEx Query, Workbooks with VBA extensions)
? BEx Web applications (with java extensions) and formatted reports via Report Designer
? SAP BO Web Intelligence & Analysis
? SAP BO Live Office
Visualization Interfaces:
? SAP BO Dashboards
? SAP Lumira
? MS Power BI
Integration with SAP & non-SAP products:
? ERP, CRM, Cognos, Fiori, SAP-portal

Dynamic, team-oriented and self-motivated BW developer. More than 6 years of experience in the IT sector. Deep knowledge of architecture SAP BI / BW solutions and related technologies. Project experience: 4 successfully completed full cycle projects implementation, design and architecture of the business warehouse systems, analytical and regulatory reporting, skills of development team management and coordination of 2-3 people.
REFERENCES
Large pulp and paper company
08.2014 – 06.2016
Lead BI/BW Consultant
• Contributing to the SAP Business Intelligence platform through the development of reports, dashboards, scorecards, and analytical tools to support corporate BI initiatives
• Design and implement the ETL Architecture to build custom Data Warehouse based on data from SAP ECC applications (leveraging standard/custom extractors). Design processes to minimize data quality risks and proactively identify potential data issues
• Development BW reports (BEx queries, Workbooks, BO)
• Creating BW web reports through SAP frontend design tools such as Web Application Designer and Query Designer, query development, JavaScript and HTML structures
• Troubleshooting of reports using Query Designer and Business Warehouse
• Providing optimization and technical support for existing reports, dashboards, or other tools
• Investigating and resolving any identified data anomalies
• Developing processes and procedures for managing test cases
• Updating the business glossary with terms and definitions related to master data • Developing processes to monitor and alert when master data issues exist
• Maintenance of the SAP Business Warehouse environment through proactive incident root cause analysis and problem resolution
• Contributing to and documenting new departmental procedures and user guides, training and education materials for business application users
• Assist business power users in ad-hoc report creation and training using BI tools

Railway transportation company
08.2014 – 05.2015
Senior SAP BI/BW Consultant
• Ongoing support of the existing SAP BW system according to the business service level agreements
• Troubleshoot and resolve technical issues. Debug, tune and optimize report performance
• Responsible for the development, unit testing (including documenting the results) • Data modeling, Multi-Cubes, ODS, Info Cubes, ETL, Info Set Queries, Info Objects, and User Exits
• Development of BEx queries using SAP BW, BOBJ reports
• Prepares comprehensive technical design documentation required according to the methodology for all technical solutions Validates the data warehouse feeds, ensuring all data is current and complete
• Monitors queries and reports behavior to ensure performance expectations are met
• Troubleshoot and support systems and applications
• Collaborate with SAP BASIS, BI Architecture and consulting teams to activate extractors, set up the connectivity between different non-SAP systems (Custom Data Warehouses) and also troubleshoot performance issues

Consulting company
07.2013 – 07.2014
SAP BI/BW Consultant
• Activate and enhance business content objects, enhance standard SAP data extractors and create generic data extractors
• Design and implement the ETL Architecture to build custom Data Warehouse based on data from SAP ECC applications (leveraging standard/custom extractors)
• Design processes to minimize data quality risks and proactively identify potential data issues.
• Collaborate with business stakeholders, technical and cross-functional project teams to implement data integration solutions
• Work closely with Business Analysts and Technical Leads in defining technical specifications. Create mapping and technical design documents for Data Integration Programs • Identify and resolve data, technical issues and mediate business implications with efficiency, effectiveness and with consistently high quality
• Providing optimization and technical support for existing reports, dashboards, or other tools
• Development of BEx queries using SAP BW, BOBJ reports

Large retailer company
11.2013 – 02.2014
SAP BI/BW Support Consultant
• Preparation specification
• Development of BEx queries using SAP BW, BOBJ reports
• Development financial reports
• Design and implement the ETL Architecture to build custom Data Warehouse based on data from SAP ECC applications (leveraging standard/custom extractors)
• Working with FI-CO data sources
• Designing and implementing ETL, data governance and information management process

Large retailer company
07.2013 – 04.2014
SAP BI/BW Consultant
• Preparation specification • Development of BEx queries using SAP BW, BOBJ reports
• Data modeling, creating generic-extractors, Info Cubes, Transfer Rules, Routines, Info Objects, designing and implementing ETL
• Working with LO data sources
• Integration with SAP-portal
• Working with web-service data sources
• Document specification, user manuals, procedures, and other relevant information.
• Troubleshoot and support systems and applications

Large retailer company
07.2012 – 01.2013
SAP BI/BW Consultant
• Activation and implementation BW business content
• Preparation specification
• Design SAP Business Intelligence and Business Objects solutions, including design and deployment of reports, analytics and solution architecture
• Setting broadcaster for sending reports
• Document specification, user manuals, procedures, and other relevant information

Large retailer company
05.2012 – 04.2013
SAP BI/BW Consultant
• Integration BW and CRM
• Activation and implementation BW business content
• Prepare specification
• Development of BEx queries using SAP BW
• Data modeling, Business Warehouse Remote Cubes, Multi-Cubes, ODS Objects, Info Cubes, Transfer Rules, Routines, Info Objects, and User Exits, designing and implementing ETL
• Working with FI-CO, LO data sources

Large retailer company
05.2012 – 04.2013
SAP BI/BW Consultant
• Data modeling, Business Warehouse Remote Cubes, Multi-Cubes, ODS Objects, Info Cubes, Transfer Rules, Routines, Info Objects, and User Exits, designing and implementing ETL
• Development of BEx queries using SAP BW
• Creating BW objects such as custom generic-extractors to support projects and ensure data flow through each

Global pharmaceutical corporation
10.2010 – 03.2012
Junior SAP BW/BI analyst
• Data load monitoring using BW process chains.
• Investigating and resolving any identified data anomalies
• Development of BEx queries using SAP BW
• Web development
TIME AND SPATIAL FLEXIBILITY
Available for a business travel
GET IN TOUCH

I accept the Conditions

I accept the terms of the privacy policy

Note: sending your contact request is free of charge

WEB PRESENCE