Maciej Zielinski - Senior Business Analyst

Senior Business Analyst

Nationality

Irish

Current location

Ireland

Work category

Accounting and Finance

Education

Masters/PostGrad

Sql, Hyperion IR Studion 9.3, Brio, SAP, Advanced Excel, Word, Lotus Notes - to name but the few;) Challenge is always welcomed;)

Maciej Zielinski's Professional Experience

2011 - Present

Senior Business Analyst

• Developing informative reports to support the decision making process in relation to pricing strategy of the company, across all business areas
• Producing and interpreting executive summary level reports using concise presentation methods (combining information from all business areas and presenting in agreed formats)
• Continually seeking opportunities to develop efficiencies and to enhance existing processes (learning reporting processes and finding possible ways of enhancing them so the data presented is clear and production of reports is more time-efficient)
• Reviewing existing reports and their relevance to current business requirements (reviewing reports and their relevance, limiting duplication of data, suggesting changes and possible amalgamations)
• Providing guidance and development to team members;
• Identifying and monitor emerging trends in reporting requests;
• Assisting in the generation of daily, weekly and monthly reports;
• Ensuring issues are identified, monitored, reported on and resolved in a timely manner;
• Performing ad hoc duties in accordance with business needs.

2010 - 2011

Allied Irish Banks - Business / Information Analyst

• Facilitating the creation and establishment of BI Analytics by taking responsibility for ensuring that inputs on the design and the outputs are fit for purpose (creating bespoke MI systems for 4 different departments – Invoice Discounting, Arrears Support Unit, Commercial and Customer Credit)
• Facilitating the creation and development of the new Automarkup Data Mart by taking responsibility for creation, development and ensuring that inputs on the design and the outputs are fit for purpose (being responsible for creating new, enhanced tables structure by reducing number of tables from 50 to 3 in data warehouse so any report can be easily processed);
• Linking with relevant departments to ensure deliverables are rolled out constantly;
• Adhering to all appropriate controls and standards in relation to the Enterprise Data Warehouse, including End User Computing policy and controls defined by the relevant User Group Owner;
• Being the first line support for the Business in relation to queries on rolled out BI analytic tools;
• Providing ongoing support to the Business (eg. ASU, Risk, ESRP, Retail) by providing ad-hoc analysis and interpretation to produced reports;
• Facilitating/Participating in workshops in relation to new CACS data load and data model design in EDW;
• Developing training sessions and create User Manuals for rolled out BI Analytics tools and templates;
• Proactively informing line management immediately of any issues which are likely to affect progress against planned deliverables;
• Providing ongoing support and technical assistance for all coins realignments throughout the year

Key Skills
automation data data analysis Line Manager MIS Project Management Reports
2009 - 2010

Allied Irish Banks - Business / Information Analyst

- facilitating the creation and establishment of the Credit & Risk Data Mart by taking responsibility for ensuring outputs are fit for purpose;
- linking with relevant departments to ensure deliverables are rolled out constantly
- being the second line support for the Business in relation to queries on (CRDM phase 1, FR reports etc as appropriate);
- providing ongoing support to the Business Architects for ad-hoc analysis and co-ordinate timely delivery of regular MIS as per schedule;
- facilitating/participating in workshops in relation to Data Mart
- identifying appropriate information/returns external to the CRDM for consideration as the basis for a reference set within the MI Programme to ensure accuracy and consistency of reporting from the CRDM and bringing them to the attention line manager;
- facilitating the automation of Financial Regulator returns from the CRDM by taking responsibility for the following specific tasks:
· (i) overseeing the prototyping of the report;
· (ii) producing a reconciliation report;
· (iii)engaging in the review of the reconciliation report with the business area which owns the report;
· (iv) agreeing with the relevant business area a timeline for parallel running of each report
- following AIB’s SDLC project management methodology and apply where appropriate. Helping maintaining the highest standards of documentation production and retention within the team, including ensuring that folder structures conform to standards (Archive, Code, Documentation, Results, Testing), that all previous versions of documents are saved to an archive folder and that all decisions, whether made at meetings or phone conferences or otherwise are appropriately documented;
- adhere to all appropriate controls and standards in relation to the EDW, including End User Computing policy and controls defined by the relevant User Group Owner
- draft the weekly status reports on behalf of the R&R Team

Key Skills
automation data Line Manager MIS Project Management Reports
2009 - 2009

Allied Irish Banks - Bank Official in EAS Regulatory Reporting (Fermat)

• support issue resolution for production for Regulatory/Economic Capital calculation purposes for ROI and Capital Markets,
• monthly/quarterly implementation of pre-calc manual adjustments for Regulatory Capital,
• responsibility for the load and validation of non Fermat files for each division for production ,liaise with divisional supports to ensure data quality issues are resolved,
• providing support to Regulatory Capital calculations,
• validation of non Fermat files and manual adjustments prior to upload to Fermat,
• ensuring ROI & Capital Markets operate within timeframes for production escalating issues as required,
• support the business configuration specification of Change Requests for Regulatory & Economic Capital, run tests and identify data and functional requirements for new changes if required,
• ensuring that Fermat to EDW is ready to go as per monthly/quarterly schedule and divisional information is distributed within agreed timeframes,
• review and verification of Fermat 8.2 upgrade testing,
• production of Group Risk quarterly report and results for Economic Capital,
• provide Regulatory/Economic Capital reconciliations to appropriate member of management in accordance with agreed timescales,
• undertaking detailed Analytical Review to explain any significant differences in calculation between different divisions,
• completing all monthly and quarterly tasks within agreed reporting deadlines ,
• implementing and supporting the new working monthly/quarterly process,
• ad hoc duties and analyses

Key Skills
data Validation
2008 - 2009

Allied Irish Banks, Financial Control, Credit Card Services, Issuing Team - Bank Official/ Assistant Accountant

Duties:
• taking full responsibility for the preparation of the quarterly accounts for First Trust Corporation,
• completing all monthly and quarterly accounting tasks within agreed reporting deadlines
• responding to Group/ KPMG information requests in a timely, efficient manner,
• providing accounting support to AIB FTB product and business initiatives,
• continually reviewing Group Accounting Policy Application and Financial Governance/ SOX Procedures to ensure any reporting issues are formally identified and resolve,
• carrying out detailed maintenance of all underlying records to support all financial information,
• preparing reconciliation of all Inter-company Balance Sheet and P&L positions for formal counterparty signoff,
• performing SOX control procedures to ensure effective control activities operate over all financial reporting inputs,
• undertaking detailed Analytical Review to explain all significant GL items in line with Group policy,
• preparing reconciliation of all GL and bank account reconciliations to confirm underlying GL Bank records,
• providing reconciliations to appropriate member of management in accordance with agreed timescales,
• following up and ensuring timely resolution of all outstanding items,
• escalating any reconciliation or control issues to management in a formal manner,
• identifying any areas where the current operational/reporting processes can be enhanced,
• providing EAS assistance to support Business Initiatives which impact on core syetem feeds to SAP GL,
• implementing and supporting the new working monthly/weekly process,
• monitor and control all accounting activities to ensure reporting requirements are met.

Key Skills
2006 - 2008

Allied Irish Banks, Financial Control, Credit Card Services, Financial Team - Bank Official/ Assistant Accountant

Achievements:
• creating a currency conversion analysis, bank charges and fees analysis which resulted in large savings for the company

Duties:
• completing daily/weekly/monthly reconciliations,
• solving queries in SAP regarding different postings,
• balance sheet analysis,
• reviewing accounts in trial balances,
• banking/general ledger responsibilities,
• supporting and assisting with the implementation of Finance Operating Model project for Financial Control R.O.I (Republic of Ireland),
• training other team members.

Key Skills
Banking finance Financial Control SAP
2006 - 2006

Allied Irish Banks, Financial Control, Credit Card Services, Operational Team - Bank Official

Achievements:
• personally introducing new control used in Card Acquiring Risk Department
• my suggestion to improve the international payments system resulted in implementation of the IT system change project with me being directly involved in the process.

Duties:
• completing daily banking/general ledger responsibilities within assigned deadlines,
• supporting and assisting with maintaining a controlled environment to meet SOX standards,
• working for three months on two projects simultaneously concerning SOX standards and introduction of IMP standard in daily reporting to MasterCard apart from normal duties

Key Skills
Banking
2005 - 2006

Allied Irish Banks, Home Mortgages, Special Project - Bank Official

Achievements:
• received an internal reward for being a key operator in terms of numbers and accuracy of cases completed.

Duties :
• manually recreating and balancing customers’ accounts,
• calculating daily interest / excesses
• training other team members

Maciej Zielinski's Education and Qualifications

2005

Masters/PostGrad - Banking and International Finance

Akademia Ekonomiczna im. Karola Adamieckiego w Katowicach

2005

Bachelor/Degree - Master's, Banking, Finance

Akademia Ekonomiczna im. Karola Adamieckiego w Katowicach

2005

Bachelor/Degree - Master's, Banking, Finance

Akademia Ekonomiczna im. Karola Adamieckiego w Katowicach

2003

Bachelor/Degree - ,

Instituto Superior de Línguas e Administração - Bragança

Bachelor/Degree - ,

ACCA - Association of Chartered Certified Accountants

Bachelor/Degree - ,

ACCA - Association of Chartered Certified Accountants

Bachelor/Degree - ,

ACCA - Association of Chartered Certified Accountants

Maciej Zielinski's Additional Information