Marina Potuzhnaya's Email Addresses & Phone Numbers

📖 Summary

Business Analyst/Data Analyst @ From June 2015 to Present (6 months) London, United KingdomBusiness Analyst/Data Analyst @ From August 2013 to May 2015 (1 year 10 months) London, United KingdomSenior MI Analyst @ From April 2013 to July 2013 (4 months) London, United KingdomSenior Database & MI Analyst (contract role) @ • Maintained and refreshed weekly data in 4 Customer Journey Tracker databases in MS Access • Identified errors and missing data in the previous refresh processes and put fixes in place that ensure the data is correctly mapped, updated and reflected in the database. Set up reconciliation queries to ensure data accuracy and completeness • Provided daily and weekly data extracts and MI reports to the Steering Committee, project teams and business stakeholders to drive decisions in the migration process • Created new Excel pivot reports with ODBC link to the Tracker databases that improved manager experience in navigating through large sets of data, with an instant view on the live data • Executed change requires to the front end Access Forms according to the changing business requirements, fully testing the changes and ensuring that VBA code and Access back end databases where fully updated From August 2012 to November 2012 (4 months) London, United KingdomSenior Advisor through FIDA Advisors Ltd @ • For the third year running involved in the Revenue Planning project, the aim of which was to enhance the planning tool that is used by EY partners in the EMEIA region. • Re-designed and built Revenue Planning SQL server database with tables, views, stored procedures, functions, triggers that delivered client’s new requirements using SQL Server 2008 R2 • Worked closely with senior stakeholders to identify their enhancement requirements, provide advice on the data layout and data integrity • Handled client data from various sources to import and map to the database structures using T-SQL, MS Access, MS Excel • Supported the client’s Data Analyst with advice on the data reconciliation and accuracy for the uploading into the SQL database • During the life cycle of the project, ran the weekly/monthly Planning Data refresh process by updating the database using stored procedures and performing reconciliation checks to ensure an accurate and complete update has taken place From June 2011 to July 2012 (1 year 2 months) London, United KingdomSenior Business Analyst @ • Created Priority Accounts database and monthly reporting using o MS Access development skills like advanced queries, table joins, etc. o Advanced Excel such as pivots, formulas, ODBC data connections, VBA o Business Objects query building and scheduling • Analysed business needs, designing and independently implementing solutions. Providing support to the Area Priority Manager and other leadership with ad hoc queries and advanced excel pivot analysis. • Producing Client and Account related reporting and analysis for the Finance Directors and other internal customers across the UK and EMEIA region, ensuring that information provided is complete, accurate and reliable • Developing and maintaining new reports as required, using a diligent approach to report building, including logical approach to design. • Involved in the full life cycle of the Revenue Planning project. The task was to build Revenue planning system that would be used by 7000 partners throughout EMEIA region. o Suggested and introduced a new way of calculating revenue estimates which was used throughout this system o Performing complex data mining business analysis to understand the necessary data mappings, feed logic and system testing o Provided all the base data, using my Priority Accounts database, for each planning cycle to the developer o Designed and produced all of the reporting using MS SQL database for measuring partner performance and planning stats o Designed and executed test scenarios o Day to day management of change requests in relation to the project plans to ensure agreed deadlines were met • Ensuring all development is built in an efficient way such that the reporting process runs smoothly, accurately and in a timely fashion. From September 2009 to May 2011 (1 year 9 months) London, United KingdomFinance Analyst, Global Valuations Group @ • Analysed and tracked the performance of the trades that breached the predetermined tolerances for Global Markets products (Fixed Income, Commodities, Equity, FX, Credit Derivatives, GMF) covering all locations • Worked extensively on Business Hierarchy project: o Replaced the outdated hierarchy to reflect correct business ownership of the aged exceptional trades for all trading books in the Global Markets division o Involved in discussions with various groups within Finance and IT on the new business hierarchy to be adapted by the MCC processes o Made positive suggestions for change and provided informed analysis of what is required to deliver it o Performed UAT on the new system interface to ensure the business requirements have been met by IT • Reported on exception trades that remain in the Market Conformity Control Tracking System using Cognos queries and Excel spreadsheets • Develop meaningful weekly MIS reports & responded to all queries from internal customers & senior management • Designed & produced Biweekly exception stats report to senior management • Created Cognos queries that extracted historic data for use in process improvement analysis • Prepared various MIS reports as required by the audit reviews From October 2007 to April 2009 (1 year 7 months) London, United KingdomFinance Manger, Business Intelligence @ • Developed a thorough understanding of the business processes and integrated data from a variety of diverse systems/structures. Performed data analysis, reporting and financial dashboard analysis • Provided KRA scorecard feeds and monthly management reporting packs to Financial Managers and Provincial Directors in the Branch Network • Created and manipulated financial data queries in Business Objects • Worked on continuous improvement of the quality, accuracy, integrity and speed of MIS reporting whilst adapting to the constantly changing business rules • Developed & maintained a robust Notional Income Statement model using Hyperion Essbase. This model: o measured the profitability & productivity of all the Standard Bank branches in South Africa o collated data from SAP, Business Objects & Cognos queries o allowed for slice & dice functions in Excel via the Essbase add-in o provided for the lowest level of analysis i.e. product/segment views o provided Year on Year as well as Actual vs Budget reporting • Provided analytical/technical support to business stakeholders • Managed and trained a junior analyst reporting to me From January 2005 to June 2007 (2 years 6 months) Johannesburg Area, South AfricaBachelor of Commerce Honours, Financial Management @ University of South Africa/Universiteit van Suid-Afrika From 2004 to 2005 Bachelor of Commerce, Finance and Insurance & Risk Management @ University of the Witwatersrand From 2001 to 2003 Marina Potuzhnaya is skilled in: Access, VBA, Data Analysis, SDLC, Analysis, Cognos, Databases, SQL, Financial Analysis, Project Delivery, Business Objects, Analysis Services, Microsoft SQL Server, Success Factors LMS, Plateau report designer