Curriculum Vitae

I. Personal Details

• Name: Paweł Włodzimierz Krawczyk

• E-mail: pawel.w.krawczyk@gmail.com

II. Summary

• Over six years of extensive experience in the field of Information Technology with Business

Intelligence, Data Warehousing, Data Architecture and ETL Applications.

• Certified MicroStrategy specialist with 6+ years of experience as Developer, Architect &

Administrator.

• 5+ years of experience in managing BI Quality Assurance team.

• Strong hands-on experience on advanced Report Development.

• Extensively worked on schema objects such as Facts, Attributes and Hierarchies and other.

• Strong knowledge in creating application objects and complex reports.

• Expertise with different databases and environments (Oracle, Netezza, Redshift).

• Expertise in creating and managing MicroStrategy users at different levels with required

privileges.

• Good knowledge in implementing and maintaining Dashboards and Documents.

• Having strong experience in SQL and performance tuning.

• Experience in building Data Model and BI optimisation.

• Design and architect multi-language and global time zones on BI solutions

• Hands on SQL for troubleshooting, analyzing production issues and providing root cause

analysis.

• Ability to work in tight schedules with high quality and efficient in meeting deadlines.

• Wide experience in working in international team both onsite and remotely (Poland, USA,

India, Ireland)

• Ability to learn new abilities, skills and technologies extremely fast.

• Excellent communication, presentation and interpersonal skills.

• Open for work in other countries business trips or relocation

III. Work experience

Since 2012/08 Angel.com, Senior MicroStrategy Developer and QE lead, Poland and USA

• Business Intelligence - MicroStrategy Development and Administration

o Creation of schema and public objects, reports, documents and dashboards

o Working on customer ad-hock requirements and product strategy

o Administrating BI environment- projects, users, schedules, events

o Report tuning with VLDB properties

o Everyday support for BI users

o Analyze Customer reported issues, troubleshoot and provide resolution

o MicroStrategy optimisation for different DB environments

o Object migration with Object Manager

o Automated projects analysis with Integrity Manager

o Creating complex objects with Apply Simple functions

o Project experience with SCRUM methodology

• Quality Engineering Leadership

o Managing Quality Assurance team

o Creating automated tests and manual test cases

o Leading multiple regression projects

• ETL (Informatica) and Data Modelling analysis

o Working on optimal data model for BI reporting

o Close cooperation with ETL developers

• Database technologies (Oracle, Netezza, Redshift)

o Both from MicroStrategy and DB side

• Work on Multiple project such as:

o DWH and Analytics for Virtual Contact Center and IVR systems

o Multi-Channel Analytics including email, chat, social media, web and mobile interactions

o DB Migration Oracle, Netezza, Redshift and performance tuning

o Design DWH and Analytics for Global OEM Customers including multiple data source,

security, multi-language, time zone, date formats

o Self-serve Analytics with MicroStrategy Visual Insight.

o Data aggregation projects – creation of new and modification of existing objects.

• Environment:

o Microstrategy 9.4.1, Informatica Power Center, Netezza, Redshift, Aginity

2011/09 – 2012/08 MicroStrategy Poland (Angel.com), Senior Consultant, Poland and USA

• MicroStrategy BI Development

o MicroStrategy optimisation for supporting multiple time zones

o Creation of schema and public objects, reports, documents, dashboards

o Working on customer ad-hock requirements and product strategy

o Administrating BI environment- projects, users, schedules, events

o Working on web, desktop and mobile environments

o Everyday support for BI users

o Object migration with Object Manager

o Projects test with Integrity Manager

o Project experience with SCRUM methodology

o Creating complex objects with Apply Simple functions

o Work on Visual Insight to create Visualization

o Gathering requirements from users

• ETL analysis

o Testing ETL processes – Pentaho to Informatica migration, aggregation

• Quality Assurance for Business Intelligence

o Managing Quality Assurance team

o Creating automated and manual test cases and complex SQL code

• Technologies:

o Microstrategy 9.2.1m, Informatica Power Center, Netezza, Oracle 10g, Linux, Oracle SQL

Developer, Shell scripting, HP Quick Test Professional

2010/05 – 2011/08 MicroStrategy Poland (Angel.com), Consultant, Poland and USA

• Business Intelligence consulting and development

o MicroStrategy objects and reports, dashboards creation

o Participate in meeting with business users to understand the requirements.

• Creation of reports, documents and dashboards - MicroStrategy

• Identification of KPI (Key Performance Indicators)

• IVRs’ creation

o Working on IVR creation for multiple customers

• Quality Assurance for BI

o Data and UI verification

• Technologies:

o Microstrategy (8.x -9.2.1m), Pentaho, Oracle 10g, Oracle SQL Developer, Shell scripting

2010/01 – 2010/03 Surana Ventures Ltd., Business Development Manager for Europe, India

• Preparation of the company for entering European market

• Preparation of marketing materials for European market

• Help in preparation for certification process

• Marketing for Solar and other Electrical Products

• Liaison with global partners establishing contacts and building relationships

• Identifying markets opportunities and potential clients

• Market research and study

2009/10 – 2010/01 Doctor Reddy’s Foundation, Project Manager, India

• Analysis of education system in India

• Preparation and management of project for group of schools in India

• Creating report after the project

2006/10 - 2008/6 PZU and PZU Życie S.A. (the biggest insurance company in Poland), Poland

• Marketing and sales of financial products

• Market research and study

• Customer relations

2006/2 – 2006/10 European Academy of Financial Planning, board representative, Poland

• Preparation of application for European Union

• Organization of conferences

• Analysis of the financial market in Poland

IV. Additional experience:

• Business Intelligence (MicroStrategy) projects in Poland, US and Ireland

o Genesys, Sound Bite – Poland and USA , telecommunication industry

o VHI – Ireland; insurance company

• European Federation of Financial Professionals Poland – cofounder

o Creation of the federation – all aspects like organizing people, structures, law issues

o Market research and marketing

• AEGEE European Students’ Forum – board member

o Project management

o Found rising and liaison with corporate partners

• Scouts’ team – lieutenant, patrol leader

• Psychology of Management Students’ Club - webmaster, conference organization

• CEMS - conference organization (Investment Banking Marathon, Inspiring SoluTions)

• Polish Red Cross – premedical rescuer

• WOSP (charity) – member

• University newspaper (“Magiel”) – journalist

V. Technical Skills:

MicroStrategy (9.x, 8.x), Informatica Power Center, Redshift, Netezza, Oracle, SQL, Linux, Shell

Scripting, Aginity, Oracle SQL Developer, AWS, Pentaho, Tableau, Click, IT Security, Android,

Python, Microsoft Office, JIRA

VI. Honours and Awards

• Employee of the quarter (twice) - Angel.com

• Innovations in banking – Citi Group

• Supply Chain Management Case Study AT Kearney (I place)

• Millennium Bank Negotiation Contest (final)

• National economics competition

VII. Education:

2010 – 2012: Warsaw School of Economics (master in management, thesis: cloud computing); top 10%

2008 – 2009: Warsaw University of Technology (robotics)

2006 – 2009: Warsaw School of Economics (finance, thesis: electronic banking);final result- top 10%

VIII. Trainings:

• MicroStrategy Certified Engineer – MicroStrategy

o MicroStrategy Certified Project Designer

o Microstrategy Architect: Advanced Project Design

o MicroStrategy Architect: Advanced Data Warehousing

o MicroStrategy Mobile for iPhone and iPad

o MicroStrategy : Advanced Reporting

o MicroStrategy : Documents and Dashboards

• Android Apps – basic development - University of Illinois at Urbana-Champaign

• Certified IT Security Specialist - IT Security Academy

• Programming for Everybody (Python) - University of Michigan

• JavaScript (basics) – Code Academy

• Financial Markets – Yale University

• Consulting Academy – Deloitte

• Training for trainer on human rights education in Azerbaijan organized by European Union

• YNY training for trainers in Turkey organized by European Union

• Investment – Warsaw Stocks Exchange and Warsaw School of Economics

• Financial planning - European Academy of Financial Planning

• Interpersonal skills - multiple companies - for example Berdson/ CEMS/AIESEC

• Insurance (KNF)– PZU SA and PZU Życie SA

• Other: first aid, rock climbing, massage

IX. Languages:

• Polish – native

• English – fluent

• Russian – good

• Spanish – intermediate

• Chinese – basic