Igor Pylypenko Email & Phone Number

Astana, Kazakhstan

Analysis of business requirements Project Cost estimation of reporting partExtraction data from SAP modules (PM, PP, PS, FI-GL, CO, SD, MM) Activating SAP BW Content for SAP FI, CO, FM, PS, and MM, ETL extending and reworkingData Model extent and rework Report development in BExReport Testing Audit of current state in EDW and Performance tuning

Moscow, Russian Federation

- Consulting in all areas of SAP BI deployment and usage, including pre-sale consulting and auditing - Advanced technical expertise in SAP BW/SAP BI configuration- Ensure that solutions adhere to SAP BI development methodology, standards and naming conventions and best practices - Develop of BI applications using SAP BW-BI- Lead BW Projects through all project phases starting from analysis through to the productive implementation- Work directly with analysts, developers and project members to develop new data warehouse functionality from business specifications by modeling, designing, developing, testing, and implementing the appropriate back-end structures- Develop the appropriate data models, cubes and documentation for the defined business requirement- Create, modify, and maintain development objects related to the SAP BI platform- Maintain and develop knowledge of current and emerging technologies. Identify new and emerging solutions, assesses their relevance and potential value to the organization, and contributes to briefings of staff and business management

Moscow, Russian Federation

- Development of BI applications using SAP BW and BO- Providing advice in the deployment and use of the BI within the business- Advance technical expertise in SAP BW/SAP BI - SAP BW/SAP BI configuration- Adhere to development methodology, standards and naming conventions and best practices - Lead BW Projects through all project phases starting from analysis through to the productive implementation- Works directly with analysts, developers and project members to develop new data warehouse functionality from business specifications by modeling, designing, developing, testing, and implementing the appropriate back-end structures- Develop the appropriate data models, cubes and documentation for the defined business requirement- Create, modify, and maintain development objects related to the SAP BI platform- Maintain and develop knowledge of current and emerging technologies. Identify new and emerging solutions, assesses their relevance and potential value to the organization, and contributes to briefings of staff and business management

Duties: Participation in SAP projects as free-lance SAP BI ConsultantResponsibilities: Reviewing of present business processes (“As Is”), conceptual design development (“As to Be”), prototyping, final design development, testing, transport to Production; BI part project leading. Details: - Participation in Full-scale SAP implementation for a distribution company as lead SAP BI Consultant. The project is going on. Details... - Participation in support and tuning of SAP CRM implementation for a distribution company as SAP BI Consultant. The project is going on. Details... - Participation in BI Performance evaluation project for a Ukrainian Telecom company as SAP BI Consultant. The project was successfully completed. Details... SAP Modules: BW, BOBJ, CO, SD, MM, FI, CRM

Duties: Participation in EPAM projects as SAP BI Lead Consultant; Team leading Responsibilities: Reviewing of present business processes (“As Is”), conceptual design development (“As to Be”), prototyping, final design development, transport to Production. Coaching for junior consultants. Managing of project issues. Development of education, training, and examination programs for juniors. Project coordination. Coaching. Final evaluating Details: - Participation in Capital development planning project for National Bank of Ukraine as SAP BI Lead Consultant and as a Coacher for EPAM junior consultants. The project was successfully completed. Details... - Training of SAP BI junior newcomers. 10+ juniors were successfully hired, trained, examined and are now involved in EPAM customer SAP BI projects. Details... SAP Modules: BW, BW/BPS

Duties: providing BW technical support for Europe, Africa and Australia working in international globally-distributed team (EurAfNE team); Responsibilities: uploading historical data from SC Johnson legacy systems; development of BEx queries/process chains/ BW data export; managing/scheduling background jobs; managing data availability/quality issues in SC Johnson BI environment; improving system performance. Details: - 30+ BW issues were resolved by me during the period May – September 2007(after an external consultant left EurAfNE team); 20+ issues were resolved faster than in one week - EurAfNE team started to do part of previously Global team’s work: managing data availability for America region. A special Thanks! from Global SCJ BI leader. - All EurAfNE Open Hub process chains exporting SAP BW data from InfoProviders to flat files were successfully adapted during upgrade to NW2004s in 2 days - Several old BEx queries were adjusted for EurAfNE team during upgrade to NW2004s - Several new BEx queries were developed for EurAfNE team - Technical consulting for Europe, Africa and Australia SCJ business users about proper using BEx/WEB queries/workbooks, data consistency and data availability was done for about 10 users - Gathered and analyzed 5+ queries developed by advanced users (so-called user data marts) and escalated gathered business requirements to Global team - Participated in system performance improving by implementation BW accelerator for Sales reports - Involved in the postproduction support: compressing and indexing InfoCubes IT Platforms and tools: SAP BW (3.x and 2004s), Tivoli, Microsoft Office 2003, Microsoft Access 2003, Microsoft Exchange, Magic Service Desk, SharePoint, and PlanView.

Duties and Responsibilities: to lead requirements gathering (To Be), to lead business processes/data/environments analysis (As Is), gap analysis, design architecture, project development, project management, conceptual/logical/physical database modelling, development, and implementation, change management, support. Development relationship with business teams (Purchasing and Sales departments). - Software tool package used by SC Johnson Application Development Centre was enhanced by including BI tools. After including BI technology in our projects business users got in a new vision of their data (drill-down from totals to lowest detail level - each day/SKU (hundreds)/distributor (tens of thousand)). - Security of business data become higher due to implementing more granulated data access permissions - Microsoft SQL Server 2000 BI tools were upgraded to Microsoft SQL Server 2005 version. New business-valuable feature – quantity of different SKU/by different distributor sold (distinct count) performed on-the-fly, - was implemented in DDC project. - Network delays, which were previously a big issue, were shortened even in worse network environment (ADC server were moved from England to USA) - SC Johnson Application Development Centre migrated to SQL Server 2005 (first in all EurAfNE region) - As a Business Analyst I managed to find an opportunity to help procurement department in their challenging goal for year 2006 – to reduce plant inventories from 70 work days down to 45 work days. 2 projects - Purchasing Analysis system & Sales Analysis system, - together enabled platform for fast and reliable analysis of material requirements and supplies Platforms and tools: MS SQL Server 2000, 2005 including SSAS and SSIS, Web Methods, Microsoft Office 2003, Microsoft Access 2003, Microsoft Exchange, Magic Service Desk, SharePoint, PlanView.

Duties and Responsibilities: to develop and maintain quality standards, quality standards enforcement processes, and change control processes; to conduct Information Systems (IS) testing and output quality control for every solution coming out from application development projects, build IS stress testing scripts, make ultimate decisions about solutions compliance to the quality standards, manage transfer of application objects from QA to Production environment, communicates to team. - Ensured that all ADC projects met current software quality standards - QA became to be proactive, quality control process starts now from the stage of business requirements gathering - Developed new quality standards, in data security area (more granulated data access permissions) - Increased communication standards between developers and testers Platforms and tools: Scala, Crystal Report, Crystal.NET, Microsoft .NET 2003, MS SQL Server 2000, Microsoft Exchange, Magic Service Desk, SharePoint, PlanView.

Duties and Responsibilities: Pre-sale consulting in several IFS Applications area: IFS Applications technical platforms, IFS Applications administration, Integration, IFS/Distribution (Logistics), Business Performance. Support of IFS Implementation. - Providing technical and presale support for all PMCG marketing events - Providing functionality consulting for IFS/Distribution and IFS/Manufacturing on marketing events - Collecting business requirements on pre-sale stages and providing functionality consulting for IFS/Distribution for PMCG clients Technologies: IFS Applications, Oracle (9i, 8i), MS SQL 2000.

Master, Physics

Physics

Education record