Tomasz Białek

Tomasz Białek

Everyone can find fault, few can do better.
Kraków, małopolskie

Umiejętności

Cold Calling Microsoft Excel Microsoft Word Microsoft PowerPoint Microsoft Outlook Microsoft One Note Microsoft Excel (w stopniu zaawansowanym) MS Excel Tabele przestawne - MS Excel Pivot Tables a little bit of VBA

Języki

angielski
biegły
włoski
podstawowy

Doświadczenie zawodowe

Capita (Polska) Sp. z o.o.
TEST ANALYST
I am a 35 year old serious, responsible man - currently liable for:

• Carrying out "Rate Checking" process and using the set of macros created by me, i.e. conducting tests checking if the particular benefit options have the proper rates before UAT commence
• Payroll reports testing, i.e. checking their layout against specs, creating test scenarios file (by using macro created by me) and submitting the appropriate choices, comparing payroll files against the particular other reports (tiny macros, general knowledge of Excel), creating Change Report for Payroll Change reports testing purposes
• Maintaining test environments, i.e. managing test environments log, assigning particular companies to particular environments, keeping in the loop managers and consultants regarding passwords to particular test environments, their expiry date, general information which one of them is busy and which one is free to use
• Cooperating with Service Desk consultants by raising SD Requests in Jira environment
• Assisting my workmates whenever they need any help with Excel (providing them with little tips and tricks to save time)


In addition:
• I work with SharePoint platform
• I take care of a good atmosphere in the team and I never refuse to help anyone from my crew
• I play along with our company's values which are expressed in "VOICE" sententia, i.e.:
- I share information with my colleagues,
- I thank others,
- I keep looking for improvements and I create new solutions,
- I ask for help if I need it - as well as - I provide it whenever it is needed by someone else,
- I take responsibility of my actions and I communicate clearly with my workmates on-site and overseas


Moreover: I am experienced with HP ALM/Quality Center.

And I can promise you - you won't find more engaged employee than me.
Zensar Technologies Ltd.
DATA QUALITY ANALYST
• Taking care of data cleanness and its integrity in Sales Account View Manager tool by executing such procedures as Naming Variation, Aged Automation and CR De-Dupe (investigation based on One Cisco Adjustment tool, Customer Registry, PUMA tool, Sales Hierarchy Advanced Repository Environment, Sales Territory Reports – system view, Bookings Report, Bloomberg platform etc.)
• Running Account and Opportunity reports from Salesforce.com tool
• Reallocating transactions on demand of the requester adhering closely to established business rules, including receiving losing Account Manager approval, holding on to the appropriate value of transactions and so forth
• Opening IT cases in My Cisco Workspace and allocating tasks to executing support teams, mainly to BPO team located in India
• Reallocating transactions incorrectly allocated due to Deal ID Automation failure
• Proceeding Managed Services claims, by carrying out analyses of the reports generated from One Cisco Adjustment Tool, and from SAP BusinessObjects, and then after receiving evidences, assigning a task to the executing team, based on the prepared report – cooperating mainly with Account Managers from Italy
• Creating new accounts in SAVM
• Reassigning Opportunities in SFDC by using Manual Upload Tool
• Keeping track of claims pending 5 or more days on a weekly basis
• Keeping track of Orphaned accounts in SAVM and cooperating with RSEs once any of them has been found
• Participating in pre cutover SFDC Normalization (New Fiscal Year Readiness)
• Opening CR cases via My Cisco Workspace
• Participating in team meetings twice a week, with colleagues from the USA and from India
• Cooperating with Account Managers from all over the world
• Carrying out the Root Cause Analyses on manual claims on a weekly basis
• Creating an Excel tool / VBA tool for RSE team (to compare different reports)
• Looking for any excuse to streamline any process (simple macros, organizing appropriately the mailbox etc.)
Capita (Polska) Sp. z o.o.
TEST ANALYST
• Evaluating the documentation of the project to check for its completeness
• Analyzing the documentation, describing the layout of HR platforms and the set of benefits provided to customers' employees
• Adhering closely to the requirements described in the documentation and looking after the correctness of both – dedicated HR platforms provided to customers and their project documents, and making reconciliation between them
• Creating test scenarios in HP ALM/Quality Center test management tool
• Carrying out manual tests and the compliance analysis
• Executing tests verifying the correctness of calculations made on HR platforms, by balancing the outcomes of calculations generated from them against the calculations made in the Excel spreadsheets based on the specifications provided by consultants (performing the procedure known as “The Rate Checking”)
• Generating the Defect Log and sending it to the Implementation team based on-site as well as overseas
• Re-testing resolved defects
• Presenting myself as a self-starter, by doing overtime many times and creating Excel tools for improving and streamlining processes (my biggest achievement is creating the set of 9 macros speeding up and automating The Rate Checking procedure as well as making a macro which forms the Defect Log in a standardized layout)
Logo
INVESTMENT COMPLIANCE ANALYST
State Street Bank GmbH, Branch Office in Poland
• Reviewing stock exchange transactions flagged in the automated fund-compliance platform (MIG21) as possible breaches
• Investigating the reasons of possible violations and classifying them as a “Non Breach”, an “Alert”, a “Passive Breach” or an “Active Breach”, according to the international regulations (incl. UCITS V)
• Collecting the latest data of particular securities (from money market, capital market or derivatives market) from the “Bloomberg” platform or internal accounting system “Multi-Currency Horizon” (MCH) and downloading them as a form of a required backup for the overseas second tier of review, during the process of a possible breach investigation
• Verifying and confirming the accuracy of fund data as it appears in the system
• Making calculations in Excel spreadsheets while numerical data is incorrect in the MIG21 system and providing them as a backup
• Verifying transactions on cash accounts in the “Integrated Banking System” (IBS), also known as the “Payment Systems Account Repository” (PSAR), and as well in the “Multi-Currency Horizon” system and making reconciliation between these systems and the outcomes displayed in the MIG21 system
• Preparing specific reports regarding fund transactions required by customers
• Adhering closely to the daily deadlines, when the investigation must be done and the summary report must be provided to the second tier of review
• Sending completion emails to the second tier of review as a proof that the particular deadline has been reached
• Taking part in internal training and development meetings
• Supporting teammates in completing tasks to ensure that agreed deadlines will be reached
• Communicating with overseas workmates via an email and the Office Communicator
• Participating in tech calls with foreign co-workers
• Processing and analyzing sensitive data in a professional and discreet manner
• Preparing a brief training about useful Excel shortcuts to streamline daily data processing and increase efficiency
Aon Hewitt
FLEX BENEFITS ADMINISTRATOR
• Administering flexible benefits scheme for clients from EMEA countries
• Looking after correctness of benefit reports, payroll reports and other essential accounts required by customers
• Preparing final versions of benefit reports and payroll reports (which requires being very accurate and having strong attention to details)
• Preparing additional reports including required for processing with online finance and human resources software solutions such as:
- "My Money Platform" (finance software dedicated, i.a., to budget planning and expenses managing),
- "e-Days Platform" (absence management software)
• Participating in conference calls with foreign co-workers and client representatives
• Processing and analyzing sensitive data in a professional and discreet manner
• Keeping team’s SLAs and adhering very closely to the client processing calendars
• Communicating with client representatives via email on a daily basis
• Resolving cases assigned (workflow tickets)
• Monitoring helpdesk shared mailboxes and supporting colleagues from the first tier by resolving cases such as password resets and so forth
• Evincing proactive approach by:
- being an Excel Community member,
- creating Excel tools for improving and streamlining processes connected with creating reports,
- finding ways how to improve MS Outlook mailboxes managing,
- introducing myself to Visual Basic for Applications programming language to take advantage of it and implement it to the Excel tools and MS Outlook,
- attending private English classes regardless of being a student in English lessons provided by the company
Capgemini Polska Sp. z o.o.
CUSTOMER SERVICE ADVISOR - TIER 1
• Processing incoming technical issues according to the internal guidelines
• Processing incoming requests for new mobile phones, software applications and other devices
necessary to fulfill particular job obligations
• Responding to queries from Rolls-Royce employees having specific issues with the technical devices
or having ongoing requests in the Procurement Department
• Resolving cases assigned
• Cooperating with clients from the Rolls-Royce company and from other companies participating
in the entire IT Ecosystem – from all over the world
• Keeping Team’s SLAs
• Appropriately assigning incoming issues or requests
• Resolving issues over the phone as the first-time-fix issues
• Keeping clients in the loop about pending major incidents
• Chasing or escalating issues being behind the schedule or in some other way breaching SLAs
Logo
SALES DEPARTMENT ASSISTANT
BioSys - Biometric Systems
• The telemarketing of "Punktualny Przedszkolak" system ("Punctual Kindergartener")
• Making business appointments
• Making sales presentations
• Providing telephone and e-mail customer service
• Delegating tasks to IT Consultants, in internal CRM system
• Carrying out the customer needs analysis over the phone
• Preparing trade offers and product pricings
• Making phone calls and informing about running out software support agreements
• Issuing pro forma invoices, final invoices, invoice extensions, invoice specifications
• Issuing GIN documents (Goods Issue Notes) of "Kontrola Strażnika" system ("Guard Control")
• Dispatch preparation of products purchased by the customer
• Filling in the company Excel sheets used for the presentations of sales department statistical results
• Designing leaflets and mailing illustrations in Adobe Photoshop
• Translating marketing materials from Polish to English
Logo
PRESALES SPECIALIST
ALPOL - IT Solutions (presently known as FUTURITI)
• Providing back office support for the sales department
• Making calls and setting business appointments for sales representatives
• Providing telephone customer service
• Checking customer satisfaction
• Carrying out the competitor analysis
• Writing industry articles on the company blog
• Maintaining the company website
• Administering the company facebook fan page
• Managing correspondence flow
• Taking care of the order in the company documentation
• Keeping track of software warranty deadlines, purchased by customers
• Issuing pro forma and final invoices
• Issuing requests for payment
• Sending Welcome Letters to new customers
• Conducting preliminary interviews with the candidates over the phone and sending the respective candidates profiles to the management
Logo
ARCHIVIST (INTERNSHIP)
Municipal Labor Office in Krakow
• Sorting out the documentation
Logo
NEW PRODUCTS AND MARKETING SPECIALIST (POST-GRADUATE INTERNSHIP)
Notatek.pl Ltd.
• Notatek.pl website positioning – especially providing a collection of links
• Promotion of website, events and company competitions on the Internet – especially on Facebook, on internet forums and on industry websites
• Creating promotional materials for the company and its customers
• Creating the database of potential customers and making contact with them
• Doing market research and preparing reports
• Verification website materials
Viamot SA
MARKETING AND PROMOTION DEPARTMENT (INTERNSHIP)
• Designing posters in Adobe Photoshop:
- “Viamot Best Team” (the poster for the internal company purposes)
- “Burza Brav” (the poster for the Fiat Bravo September sales offer)
• Designing layouts in Adobe Photoshop:
- for Viamot North Krakow Branch service offer
- for Iveco Service (Lublin Branch of Viamot) mailing purposes
- for the purposes of official company profile on Facebook
• Designing advertising banner in Adobe Photoshop for Iveco Service (Lublin Branch of Viamot)
• Editing in Adobe Photoshop photos made in North Krakow Branch of Viamot
• A small correction of Hyundai ad, which was published in press
• Working with the CRM system – preparing reports
• Cooperation in creating company official Facebook profile, preparing posts to upload on it
• Preparing notes for the company newsletter
• Creating preliminary requests for proposal – sending queries with a request for the pricing of advertising materials
• Telephone and e-mail contact with Viamot contractors
• Business travel:
- contact with the contractor in Myslenice
- contact with the contractor in Krakow
• Substantive assessment of Viamot website and cooperation in modifying it
• Being responsible for efficient correspondence flow between secretariat and marketing department
• Participation in an organized for the internal company purposes photo session
• Taking care of standards of brands – information and promotional materials distribution within the car showroom
• Operating the office equipment (printer, photocopier, scanner)
Logo
CITY TOURIST MARKETING OFFICE (INTERNSHIP)
The Municipality of Krakow
• “Tourist traffic in Krakow in 2009 – final report” – analyzing and making adjustments
• Creating communication plan for tourists – an extensive plan (including particularly transport hubs) makes it easier for tourists to reach the sights included in the sightseeing program
• Creating the presentation in Microsoft Power Point “Krakow – together we create the future”, presented at the Expo 2012 in Shanghai (text edition and creating the part about tourism in Krakow)
• Creating the presentation in Microsoft Power Point promoting Krakow in the context of tourism, presented in the People’s Republic of China, in Nanjing
• Creating databases in Microsoft Excel:
- travel organizers / tour operators / travel agents – (from Lower Silesia Province and Kujawy-Pomerania Province) with an offer for exploring Krakow
- tour operators contact details
- journalist contact details
- contact details of: selected Polish Embassies and Consulates and Polish National Tourist Offices
• Organizing documentation about:
- Polish Presidency of the Council of the European Union
- the organization of the 10th anniversary of the Community of Democracies in Krakow
• Modifying the portal Magic Krakow, the tab Tourism/Accommodation
• Cooperation in the organization of the funeral of President Lech Kaczynski and the First Lady at Wawel (a little help when receiving promotional materials of Krakow)
• Distribution of correspondence between the Municipality of Krakow and:
- Municipal Centre of Tourism
- Marshal Office of the Lesser Poland Province
- Wawel Royal Castle
- Private clients
• Telephone contact with clients of the Municipality of Krakow
• Analyzing texts in Italian describing tourist attractions in Krakow
• Warehouse work – delivering promotional materials (leaflets, brochures) and maintenance of sizeable promotional items
• Operating the office equipment (photocopier, printer)

During my internship I received the Letter of Thanks from The President of Krakow – prof. Jacek Majchrowski for my cooperation in the organization of the Presidential Couple funeral on Wawel Hill.
Logo
WAREHOUSE WORKER
Armadeo.pl Ltd.
• Receipting of goods
• Securing goods onto a pallet before shipment
PKO Bank Polski
INTERN - BRANCH OFFICE NO. 2 IN KRAKOW
• Acquainting myself with the tasks and organization of the bank and its hierarchical structure
• Learning about the basic servicing procedures of individual client
• Making acceptance reports
• Entering images of signatures of individual clients into the computer system (checking accounts) and supporting IntraGraf computer program (system of visual verification of signature)
• Acquainting myself with circulation of the bank internal correspondence
• Operating the office equipment (scanner, photocopier)
Logo
SECURITY GUARD
“Justus” Ltd. Security Agency
• Protection of the photography exhibition in Planty gardens in Krakow entitled “Save Krakow” – organized by Społeczny Komitet Odnowy Zabytków Krakowa (Social Committee for the Restoration of Historic Monuments in Krakow)
• Every hour wireless reporting
Logo
SALES CLERK
BP Express Ltd. – Gas Station and Wild Bean Café
• Filling a propane fuel vehicles
• Retail selling of goods
• Issuing invoices
• Adding points in the loyalty program BP Partner Club
• Preparing meals and coffee brewing
• Arranging and composing of delivered goods on a designated store area
• Maintaining the cleanliness and appearance of the store shelves
• Maintaining the overall appearance and cleanliness in the store and toilet
• Settling the propane deliveries
• Making daily cash settlement
Logo
HODCARRIER
Work on construction site
• Help with renovations performed inside a building such as: driver operating, grinder operating, filling, hand grinding, painting etc.
Logo
BARMAN
VIBO Krzysztof Nowosad Ltd. – “Liza Café”
• Brewing and preparation of different types of coffee
• Preparation of chocolate
• Preparation of Campari Orange drinks
• Wine serving
• Selling ice cream
• Taking care of cleanness and a counter exposition
• Guest service
Logo
WAITER
WM Hotel System Ltd.
• Preparation of meals for hotel guests
• Buffet service
• Hotel guests service in the restaurant and in hotel rooms
• Taking care of hotel garden cleanness
• Cleaning dining rooms and the restaurant
• Preparation of conference rooms
Logo
MERCHANDISER
Tesco and Carrefour in Krakow
• Arranging and composing of delivered goods on a designated store area
• Taking care of goods exposition
Makro Cash and Carry Polska S.A.
LOGISTIC ASSISTANT
• Quality and quantity acceptance of goods

Szkolenia i kursy

FOREIGN LANGUAGE COURSES:

English:

And additionaly since March 2015: Brushing up on English and improving it by:
Revising notes, setting up English conversation meetings three times per week, attending English meetings in cafes
March - July 2015: Three Lions School of English - Business English Course (B2 level)
February 2015: Poliglota - Foreign Languages School - Three-week Intensive English Conversation Course (B2 level)
October 2014 – February 2015: Three Lions School of English - English Conversation Course (B2 level)
October 2013 – March 2014: Three Lions School of English - English Course (FCE 3 level - pre-advanced)
July 2013: Three Lions School of English - Summer Intensive English Conversation Course (B2 level)
March – July 2013: Three Lions School of English - English Course (FCE 2 level)
October 2012 – March 2013: Three Lions School of English - English Course (FCE 1 level)

Courses at the upper-intermediate level (B2):
July - August 2012: Three Lions School of English - Summer Intensive English Course
February - July 2012: Success School of English - English Course
June - July 2010: K&K School of English - Summer Intensive English Course

Italian:

March - July 2015: Sensapolis - The Center of the Mediterranean Languages - Italian Course (A2 level)


OTHER COURSES:

July 15th and 16th 2016:[img]http://postmodernnews.com/images/new.gif[/img]
Excel VBA (basic level) course
- Conducted by the representative of "ForEDU - Computer Training Courses" company
( http://www.foredu.pl/ )
TRAINING COURSE PROGRAM:
- INDUCTION:
-- the ways how to swap numbers in text format into numerical format
-- print settings options
-- how to figure out the MAX IF and MIN IF options
-- how to interrupt frozen sheet while calculating
-- array formulas
-- columns and rows grouping,
- VBA FUNDAMENTALS:
-- recording, editing, deleting and hiding macros
-- assigning a digital signature
-- ways to run macros,
- CONTROLS:
-- form control
-- ActiveX control,
- VISUAL BASIC EDITOR:
-- code displaying options
-- working with modules,
- PROCEDURES,
- FUNCTIONS,
- VARIABLES AND DATA TYPES,
- REFERENCES TO CELLS AND RANGES OF CELLS,
- WORKING WITH NUMBERS AND TEXT,
- CONTROL STATEMENTS:
-- comparison and logical operators
-- Do While / Do Until loop
-- For Next/For Each In loop
-- If Then Else - a conditional statement
-- Select Case - a leading to choices statement
-- a jump instruction GoTo,
- SHEET FUNCTIONS:
-- Excel functions
-- MsgBox and InputBox functions
-- data and text managing

September 16th 2015:
Brief course of pivot tables in Microsoft Excel 2010
- Conducted by "AXON SYSTEM" Education Center ( http://axonsystem.edu.pl/ )

April 14th 2013 – May 12th 2013:
Stockbroker course (part. 1)
- Conducted by Mr. Damian Jasik and Mr. Grzegorz Piekarski ( http://www.kurs-maklerski.pl )

September 2012:
Microsoft Excel 2010 - self-study based on:
- Excel for beginners - video course published by Agora 2010 and Videoszkolenia.pl Ltd
- Excel for advanced - video course published by Agora 2010 and Videoszkolenia.pl Ltd
- J. Morajda et. al., "Arkusz kalkulacyjny" in B. Nowarska, ed., Podstawy informatyki. Laboratoria i ćwiczenia, Krakow: published by Cracow University of Economics, 2003
- K. Masłowski, Excel. Funkcje w przykładach, Gliwice: published by HELION SA, 2007
- materials from the Internet

November 7th 2011:
Training course "Sales Communication"
- Conducted by the representative of KAM Ltd., carried out by Cracow University of Economics, a project co-funded by the European Social Fund as a part of the Human Capital Operational Program

March 16th 2010 – April 13th 2010:
Computer graphics course "STANDARD" (CorelDRAW + PHOTOSHOP)
- Conducted by “GRAFFO” company ( http://www.graffo.com.pl )
- The certificate confirming completion of the course (Scope of course: design and graphics editing in CorelDraw X4 and PhotoshopCS4)

“OPT!MALNY START” Certificate
- The certificate confirming knowledge of Comarch OPT!MA software in: Payroll and HR, Sales, Tax Book

July 2007:
Training course on how to properly handle and fuel propane vehicles (work at BP gas station )

July 2007:
First Aid Training Course (work at BP gas station )

July 19th 2003 – July 25th 2003:
Forklift operator training course
- Forklift license

Edukacja

Logo
MANAGEMENT: one year extension of the study due to an ambitious MA thesis - connected with personal interests, magisterskie
Cracow University of Economics
Logo
MANAGEMENT AND PRODUCTION ENGINEERING, magisterskie
Tadeusz Kosciuszko Cracow University of Technology

Specjalizacje

Bankowość
Bankowość korporacyjna/SME
Call Center
Konsultanci
Finanse/Ekonomia
Inne
Obsługa klienta
Finanse/Bankowość/Ubezpieczenia
Obsługa klienta
IT/Telekomunikacja

Zainteresowania

• Nowa Huta – architecture and history
• World cities similar to Nowa Huta
• Soccer and other sports as a form of relaxation and rest
• City marketing, sport marketing

Inne

• Driving license cat. B (active)

• In January 17th 2012 the local newspaper "Dziennik Polski" published an article about my MA thesis, entitled "Jaka Nowa Huta?" ("What Nowa Huta?") - an electronic version available at the following links:

- [url=http://www.dziennikpolski24.pl/artykul/3108368,jaka-nowa-huta,id,t.html]Dziennik Polski: "Jaka Nowa Huta?" - free access[/url]

- [url=http://www.dziennikpolski24.pl/pl/region/miasto-krakow/1203523-jaka-nowa-huta.html]Dziennik Polski: "Jaka Nowa Huta?" - paid access[/url]

- and there is something from my MA thesis:
[url=http://www.wizeruneknh.cba.pl]Diagnosis of the image of Nowa Huta Anno Domini 2011[/url]

• Personal qualities: full availability, responsibility, kindness, diligence, consistency, accuracy