← Back to list
senior
Registration: 13.04.2022

Stanislav Polunin

Specialization: BI Architect, Tech Lead, BI Developer

Portfolio

UniCredit

• Successfully entered into in Core Banking Transformation project. • Responsible for reporting infrastructure: development, maintenance, lifecycle management. • Expert role in Data Warehouse development (DB - Oracle, sources: Oracle Siebel, Flex Cube and others). • Responsible for BI Competence Center technical management. • Played a key role in local project of architectural change of current BI landscape. • Development of database structure (entity relationship, tables, views etc.) for data marts and custom reports. Life cycle management of Business Objects environment: server deployment, administration, migration. • Participation in project of data warehouse implementation (role - expert & architect). • Logical and physical architecture development. • Design and implementation of data marts. • Universes, dashboards and reports design. • BI Competence Center technical management. • Capacity planning, schedule and workload control. Achievements: • As technical lead of BI Competence Centre managed to implement Agile methodology that reduced development time by 30%. • Increased knowledge exchange and circulation among team members with help of knowledge base usage. • As an expert in SAP Business Objects, lead internal IT project of BI landscape architecture change to its successful finish. • The project implementation allowed dramatically reduce license gap (for approx.0.5m EUR/yr) and optimize technical infrastructure.

RBtechnologies

• Participation in Core Banking Transformation project in an international bank. • Responsible for reporting infrastructure (SAP Business Objects 4.1):development, maintenance, lifecycle management of reports and metadata. • Expert/architect role in Data Warehouse development (DB – Oracle, sources:Oracle Siebel, Flex Cube, IBM Midas and others). Responsible for BI Competence Center management. • Played a key role in local project of architectural change of current BI landscape. • Development of database structure (entity relationship, tables, views etc.) for data marts and custom reports. • Life cycle management of Business Objects environment: server deployment,administration, migration. • Participation in project of data warehouse implementation (role - expert &architect; team size – about 70 members). • Logical and physical architecture development. • Design and implementation of data marts. • Universes,dashboards and reports design. • BI Competence Center management. • Capacity planning, schedule and workload control. Achievements: • As head of BICC managed to implement Agile methodology that reduced development time by 30%. Increased knowledge exchange and circulation among team members with help of knowledge base usage. • As an expert in SAP Business Objects, lead internal IT project of BI landscape architecture change to its successful finish. • The project implementation allowed to annihilate license gap (approx. 0.5m EUR/yr) and optimized technical infrastructure.

Protek, LLC

• Implementation of ERP-class system (Oracle E-Business Suite). • Development and re-engineering of business-procedures (using ARIS methodology), description of customizations designs (AIM). • Business analysis - warehousing, pharmaceutical certification: Development, testing of new, and optimization of existing technologies. • Work as analyst with Oracle DB (SQL, PL/SQL). • Report creation, modification and optimization in Business Objects environment. • Support of existing and development of new reports covering department specific tasks. • Interviewing stakeholders and elaborating of business and technical requirements for RnD (including logical and physical database structure design). • Analytical and technical development of pharmaceuticals purchase process (shipment, customs processing, certification, warehousing). Achievements: • As a member of a team developed the architecture of extension module (for internal software complex) covering customs processing and corresponding tasks. • Participated in development and implementation of licensing quotas (uses in combination with customs processing subsystem) control system (ARIS - as business-process description tool, ERWin - as logical and physical structure description tool). • As an implementation and development team member developed business-processes and logical structure of internet project for internal business-users and suppliers (supply chain management software - to allow managers to gain detailed information about their shipments). • Developed a set of reports fully covering all certification department demands (it was mandatory to provide a certification process for each import medicaments shipment; it was necessary to control sample movement and certification documents handling).

Skills

Business Intelligence
Confluence
Java
Jira
Oracle
PL/SQL
SAP Business Objects
SAP Business Objects BI
SAP Data Services
SQL
Sybase
Tableau
T-SQL

Work experience

BI Team Lead/BI architect
11.2015 - 11.2019 |RBtechnologies
SAP Business Objects, Oracle, Flex Cube, IBM Midas, Atlassian Jira. Confluence
• Participation in Core Banking Transformation project in an international bank. • Responsible for reporting infrastructure (SAP Business Objects 4.1):development, maintenance, lifecycle management of reports and metadata. • Expert/architect role in Data Warehouse development (DB – Oracle, sources:Oracle Siebel, Flex Cube, IBM Midas and others). Responsible for BI Competence Center management. • Played a key role in local project of architectural change of current BI landscape. • Development of database structure (entity relationship, tables, views etc.) for data marts and custom reports. • Life cycle management of Business Objects environment: server deployment,administration, migration. • Participation in project of data warehouse implementation (role - expert &architect; team size – about 70 members). • Logical and physical architecture development. • Design and implementation of data marts. • Universes,dashboards and reports design. • BI Competence Center management. • Capacity planning, schedule and workload control. Achievements: • As head of BICC managed to implement Agile methodology that reduced development time by 30%. Increased knowledge exchange and circulation among team members with help of knowledge base usage. • As an expert in SAP Business Objects, lead internal IT project of BI landscape architecture change to its successful finish. • The project implementation allowed to annihilate license gap (approx. 0.5m EUR/yr) and optimized technical infrastructure.
BI Architect
since 10.2015 - Till the present day |UniCredit
SAP Business Objects 4.1, 4.2, Oracle Siebel, Flex Cube, Jira, Confluence, Oracle DB, MS SQL Server, Sybase ASE
• Successfully entered into in Core Banking Transformation project. • Responsible for reporting infrastructure: development, maintenance, lifecycle management. • Expert role in Data Warehouse development (DB - Oracle, sources: Oracle Siebel, Flex Cube and others). • Responsible for BI Competence Center technical management. • Played a key role in local project of architectural change of current BI landscape. • Development of database structure (entity relationship, tables, views etc.) for data marts and custom reports. Life cycle management of Business Objects environment: server deployment, administration, migration. • Participation in project of data warehouse implementation (role - expert & architect). • Logical and physical architecture development. • Design and implementation of data marts. • Universes, dashboards and reports design. • BI Competence Center technical management. • Capacity planning, schedule and workload control. Achievements: • As technical lead of BI Competence Centre managed to implement Agile methodology that reduced development time by 30%. • Increased knowledge exchange and circulation among team members with help of knowledge base usage. • As an expert in SAP Business Objects, lead internal IT project of BI landscape architecture change to its successful finish. • The project implementation allowed dramatically reduce license gap (for approx.0.5m EUR/yr) and optimize technical infrastructure.
Expert, Team Lead, Project manager, BI developer
02.2010 - 10.2015 |ISG Consulting, LLC
Mincom Ellipse 6.3.2, MS SQL Server 2005, 2008, SAP Business Objects, SAP Data Services, Oracle
• Development of database structure (entity relationship, tables, views etc.) for custom implementation of Mincom Ellipse product. • New custom modules design: transport logistics module, asset-management extension module. • Complete cycle of Business Objects environment management: server deployment, administration. • Complete cycle of reports development: end-users interview, technical requirement compilation, universes development, reportsdevelopment. • Participation in data warehouse implementation project (role - expert &architect, later – PM; team size – up to 30 members). • Logical and physical architecture development. • ETL process development. • Universes, dashboards,information spaces and reports design. • Management of developers and administrators group on the Mincom Ellipse implementation project: system administration, integration, customization. Achievements: • Developed enhancement to standard Mincom Ellipse asset management module in order to fit specific law requirements: additional accounting of assets mounting/movements and daily depreciation calculations. • Developed and successfully implemented approximately 200 reports in Business Objects Environment that greatly improved performance of standard and enhanced Mincom Ellipse functionality. • As an architect in DWH project developed structure of Data Warehouse(including staging areas, storage areas and data marts for reports, dashboards and analytical cubes).
Team Lead/Database administrator/BI developer
06.2004 - 01.2010 |Golden Palace Group
Atronic System. Oracle 8i-9i-10g, PL/SQL. Business Objects 5, Cisco
• Implementation and technical support of slot machine floor control system Atronic System (2 casinos), development and support of audit reporting system (environment - Business Objects). • System administration (setup and administration of system, setup and administration of server sets and users workstations). • Administration and support of External Data storage (Hitachi DS 9520V). • Network infrastructure administration (Cisco Systems and D-Link hardware: multi-VLAN environment support, VPN-channels support and configuration). • Database administration (Oracle 8i, 9i, 10g: maintenance, backup, cloning, performance optimization, test environment deployment and support). • Domain support (MS Windows Active Directory support: maintenance, deployment from "scratch", creation of administrative templates). • System Technical support of 1-st and 2-nd level. Contact with Competence Centre in Monaco. Direct contact with developers in Monaco and Austria. • Provide slot machine gaming floor back office operation 24*7 in two casinos (role - administrator & developer; project team size - 3 members). • Databases administration: backup/recovery operations (using rman and 'old-fashioned' file copy for online backup operations, physical standby deployment), capacity planning, workload planning, migration between environments planning. • Report development: interview end-users on their specific requirements, convert business requirements into technical requirements, universes/reports design. • Infrastructure support: passive and active network planning.
System Analyst
2001 - 2004 |Protek, LLC
Oracle. SQL, PL/SQL
• Implementation of ERP-class system (Oracle E-Business Suite). • Development and re-engineering of business-procedures (using ARIS methodology), description of customizations designs (AIM). • Business analysis - warehousing, pharmaceutical certification: Development, testing of new, and optimization of existing technologies. • Work as analyst with Oracle DB (SQL, PL/SQL). • Report creation, modification and optimization in Business Objects environment. • Support of existing and development of new reports covering department specific tasks. • Interviewing stakeholders and elaborating of business and technical requirements for RnD (including logical and physical database structure design). • Analytical and technical development of pharmaceuticals purchase process (shipment, customs processing, certification, warehousing). Achievements: • As a member of a team developed the architecture of extension module (for internal software complex) covering customs processing and corresponding tasks. • Participated in development and implementation of licensing quotas (uses in combination with customs processing subsystem) control system (ARIS - as business-process description tool, ERWin - as logical and physical structure description tool). • As an implementation and development team member developed business-processes and logical structure of internet project for internal business-users and suppliers (supply chain management software - to allow managers to gain detailed information about their shipments). • Developed a set of reports fully covering all certification department demands (it was mandatory to provide a certification process for each import medicaments shipment; it was necessary to control sample movement and certification documents handling).

Educational background

Master in Applied Informatics (Masters Degree)
2013 - 2015
Moscow State University of Economics, Statistics and Informatics (MESI)
Mechanical Engineering (Masters Degree)
1995 - 2001
Bauman's MSTU - Moscow

Languages

JapaneseIntermediateEnglishProficientGermanIntermediateRussianAdvanced