Cracow Metropolitan Area
What am I like? A friend of mine recently told me I'm 'RELIABLE'. In my recent life: - I've sorted out the affairs of my commonhold association, - Despite adversity, I've completed the renovation of my apartment, - I've saved myself from surgery by finding appropriate rehabilitation, which no doctor had told me about, - I've organized vacations for myself and my friends, booking tickets, finding accommodations, and planning mountain routes, - Despite many expenses, I've managed to accumulate some savings, - I've met a Krakow stand-up comedian (a great guy :)), - I've started helping a family member and, all by myself, step by step, I'm overcoming bureaucratic obstacles and constantly moving forward. And I've learned that I can multitask.
• Knowledge of the "ownership of premises" act • Fragmented knowledge of the Polish Construction Law • Ongoing cooperation with the property administrator • Cooperation with the technical emergency service • Preparation of annual reports on the board's activities ACHIEVEMENTS: - I led a change in the commonhold association board; - I led a change in the building administrator; - I led a change in the technical emergency service servicing the building; - I led a change in the chimney sweep servicing the building; - I led a change in the building's cleaner; - I initiated the process of repairing the neglected building by: a. repairing the exhaust pipes on the roof, b. repairing the gutters, c. assisting in diagnosing a neighbour's non-heating radiator and determining, according to regulations, whether the radiator repair could be financed from the commonhold association renovation fund (in accordance with the law), or whether it was a "private part" and the neighbour had to finance it from his own funds, d. partial replacement of the sewer risers, e. sealing the rusticated corners of the building (the facade is rusticated, and the building is listed in the municipal register of historic monuments), f. helping an elderly neighbour lady replace windows, g. finding a specialist to repair damaged sheet metal on the building's baseboard, h. successfully repairing the intercom system, i. finding the cause of cracks in the staircase walls on the top floor of a block of flats (professional report) and obtaining recommendations on how they should be repaired, j. Obtaining permission from the Department of Architecture and Urban Planning of the Krakow City Hall and also from Municipal Conservator of Monuments to connect the domestic hot water system; - Constant contact with the property administrator, - Thanks to the process I initiated, the commonhold association passed a resolution regarding the connection of domestic hot water and the removal of gas heaters in the bathrooms
• Reviewing internal decision forms and budget allocation forms, as the Review and B&P Coordinator in Salesforce • Daily contact with the sector team • Attending team meetings • Creating Accounts and Opportunities in Salesforce • Setting up the stages in the sales process for Opportunity • Setting up Account Leads and Sales Leads • Generating reports as per requests of sales team members from the UK • Accounts verification as per internal guidelines, as well as, working with Dun and Bradstreet Hoovers registry • Creating Cases (service desk tickets for reporting defects and technical issues in Salesforce) • Preparing training materials (training videos, MS Power Point presentations, PDF files) • Keeping track of active Opportunities that are expected to become closed-won before the close of the fiscal quarter • Also in the past: sorting and digitizing invoices from countries such as: Malaysia, Philippines, Indonesia ACHIEVEMENTS: - I joined a team of people tasked with manually calculating data from invoices exported to MS Excel spreadsheet. The matter was urgent. I noticed a pattern in the data and constructed a complex formula that summed the data. This allowed me to complete a task, that was supposed to take several days by a group of people, in about two hours on my own. - I systematically took notes on processes that weren't yet fully defined, and then compiled everything into one file. This systematized procedures and created a file that was helpful for me, my local team, and my colleagues from abroad. - I recorded a training video on one of the more complex processes, which involves many variables and dependencies. I admit, it was difficult, but I completed it.
• 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: 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: 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 • I am experienced with HP ALM/Quality Center ACHIEVEMENTS: - creating the set of 9 macros speeding up and automating The Rate Checking procedure (Before: this procedure took about a week. After: the procedure was completed within 1 or 2 days.) - creating a macro which formed the Defect Log in a standardized layout - establishing rate checking process from the very beginning to the end - establishing payroll reports testing process in various test cases (different kinds of payrolls, different testing methods) - taken over the process of managing test environments and improving it (changing test environment log, setting up a few templates with short descriptions what the requester should have done before asking for a test environment) - improving coordination of shared mail box to keep track of the current workload - optimizing the layout of a defect log generated from HP ALM Quality Center tool - for the last 2 weeks coordinating the work of my workmates - sending reports to overseas supervisors
• 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.)
• 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)