Learn Data Skills
Beta
Laura Motta

Laura Motta

Data Analyst

HSE - National Ambulance Service

Technologies

My Portfolio Highlights

My New Course

Data Manipulation in SQL

My New Track

SQL Fundamentals

Insights whisperer, uncovering hidden gems in the vast realm of information.

My Work

Take a look at my latest work.

course

Exploratory Data Analysis in SQL

course

Data Manipulation in SQL

course

Understanding Data Visualization

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Health Service Executive | Jul 2022 - Jan 2022

Data Analyst

Contract with CPL working for National Ambulance Services. • Building the data warehouse to organise the data according to the organisation's needs. • Design and implement ETL procedures for intake of data ensuring data is verified and quality is checked. • Developing clinical dashboards for National, Corporate and Regional reporting. • Using Tableau to automate reports and data ingestion.
Show More

Edward Dillon & Co. Ltd | Jan 2022 - Present

Data Analyst

• Liaising with all departments, including management, in providing solutions in relation to data collection, manipulation and visualisation. • Manipulating of datasets and structures across multiple platforms. • Responsible for training staff in the use of the BI resources. • Creation of presentations for the business and assisting in the preparation of information to be shared in both internal and external meetings.

Health Service Executive | Jan 2019 - Jul 2022

Student & General Employee

• Studied General English and completed a Higher Diploma in Science in Computing. • Worked in general employment dealing with people as Customer Service Assistant at Milano Restaurant and Home Care Assistant at Home Instead Company.

L'Oréal | Jun 2018 - Jan 2019

Senior Business Intelligence Analyst

⦿ Achivement: Contributed to build business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity. Duties: ‣ Analysed sales force productivity indicators to check for opportunities for improvement. ‣ Prepared follow-up reports for medical visitation managers to help in decision making. ‣ Developed sell-out goals by medical visitation sector. ‣ Performed the results of the sales force team. ‣ Kept the tools for monitoring the goal and field visits up-to-date in order not to generate unforeseen events in the activities of the propagandists. ‣ Implemented the new trade marketing solution (Involves Stage) for the sell- out team. ‣ Used BI Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis. ‣ Led and conducted a change management initiative to improve a workflow system. ‣ AR payment and trend analysis presentation to management committee to recommend strategic plans to increase revenue. ‣ Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.

Metrô Rio | Apr 2017 - Jun 2018

Senior Business Intelligence Analyst

⦿ Achivements: Got a promotion as a Senior BI Analyst by recognizing the importance of accurate work. Provided leadership and initiative to ensure services, delivery, research and project expectations were met or exceeded. Have Conducted research and analysis on ongoing operational activities and also investigated key business problems through quantitative analyses of utilization and costs data. Reported directly to CEO and Shareholders proving statistical findings and conclusions in analyzing interpreting trends and root cause analysis. Duties: ‣ Assisted Controller and Accounting Team with research and data analysis. ‣ Directly supported the executive leadership teams and CEO. ‣ Evaluated and presented information to the CEO and the executive leadership teams in a manner that will facilitate management's understanding of the results and impact. Developed, analyzed, and monitored new, routine and ad hoc reports. ‣ Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to the company. ‣ Provided technical financial reporting expertise to assigned business units/ leaders to ensure all financial and operational data (including budgets and forecasts) are available to support business decisions. ‣ Prepared strategic trend reports to measure KPI, Increased leadership focus on key Performance Indicators. ‣ Communicated with the Executive Management Team to anticipate their specific requirements and provided sound recommendation on necessary changes based on detailed analysis. ‣ Created Dashboards, KPIs and other Operational Reporting through Reporting Services. Met with requestors to gain insight on reporting needs and translating those needs into business specific metrics and other reports. ‣ Participated and provided technical leadership in all phases of BI projects: from discovery and planning through implementation and delivery.

Metrô Rio | Jan 2014 - Apr 2017

Business Intelligence Analyst

Duties: ‣ Prepared meetings and made presentations to the board. ‣ Monitored and analysis of passenger demand. ‣ Monitored and analysis of macroeconomic indicators in Rio de Janeiro to understand the behavior of the metro demand. ‣ Coordinated engagement Short and long term demand forecast (basis of the company's financial budget and business plan). ‣ Prepared of comparisons with the demand of other modes of transport. ‣ Visited the stations to understand the flow and check for possible improvements. ‣ Verified the impact of external events on the Metro demand (demonstrations, concerts, carnival, New Year's Eve, among others). ‣ Participated in the planning and operation of MetrôRio in major events that took place in Rio de Janeiro (Confederations Cup, WYD, World Cup, Olympic and Paralympic Games). ‣ Monitored of political, economic and demographic news in the State of Rio de Janeiro, in order to subsidize all analyses related to demand. ‣ Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, in order to eliminate implementation issues. ‣ Coordinated with business unit teams developing further enhancements of the performance management processes and tools. ‣ Analysed business processes ensuring best practices were captured and implemented consistently.

Metrô Rio | Mar 2013 - Jan 2014

Business Intelligence Intern

Duties: ‣ Performed requirements analysis, analysed and documented the system specifications, business requirements and detail design of the business using requirements inventory for the requirement tracking and analysis. ‣ Analysed, documenting, prioritizing and scoped the requirement for the various iterations of the project development. ‣ Prepared analysis spreadsheets for the sales force. ‣ Analysed the client's requirements in depth to understand key business needs and participated in documenting current business process and workflows. ‣ Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc. ‣ Followed a structured approach to organize requirement into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed. ‣ Created visually impact dashboards in excel for data reporting by using pivot tables and vlookup. Extracted, interpreted and analysed data to identify key metrics and transform raw data into meaningful data. ‣ Engaged with EViews system to understand business requirements and developed solution design of business model.

GVT | Jan 2012 - Jan 2013

Sales Analyst

⦿ Achievement: Analysed and assessed prior and current financial data in order to assist in the future planning of the targeted sales division aligning to the Global Village Telecom. Duties: ‣ Analysed of regional sales results focused on reaching the budget. ‣ Interacted with the manager and sales force to understand the gaps in results. ‣ Prepared of management presentations to demonstrate the main sales results. ‣ Prepared analysis spreadsheets for the sales force. ‣ Created and support of marketing actions carried out in Rio de Janeiro. ‣ Created and implemented new and efficient strategies for data collection within the (GVT). ‣ Provided fundamental economic analysis on and insights into developed and merging market economies. ‣ Generated reports: Sales, Pricing, Business Planning and Product Management. ‣ Ensured that all requirements met for sales programs and policies, including advertising and promotional allowances. ‣ Revisited sales&⦿39; threshold and rebates achieved for that time span and corrected errors.

Claro Brasil | Jan 2010 - Jan 2012

Trainee

Duties: ‣ Analysed Market research to check competitor offers and create comparisons. ‣ Created of differentiated and competitive offers for the Small and Medium Enterprises Channel (SME). ‣ Prepared of argumentation materials to assist the sales force. ‣ Checked the margin and profitability of corporate clients in order to assess the potential for contract renewal. ‣ Prepared of management reports in order to facilitate the visualization of sales data. ‣ Conducted economic research and improvement projects to aid in analysis of price movement and improvements in data collection.

Siemens Healthineers | Jan 2010 - Jan 2010

Trainee

Duties: ‣ Analysed Market research to check competitor offers and create comparisons. ‣ Created of differentiated and competitive offers for the Small and Medium Enterprises Channel (SME). ‣ Prepared of argumentation materials to assist the sales force. ‣ Checked the margin and profitability of corporate clients in order to assess the potential for contract renewal. ‣ Prepared of management reports in order to facilitate the visualization of sales data. ‣ Ensured annual renewal and retention of existing clients.

F3V Confecções Ltda. | May 2008 - Jan 2009

Administrative Assistant

‣ Responsible for the company's logistics. ‣ Data entry of invoices and processed backup reports after data entry invoices. ‣ Ensured timely processing of transportation service provider invoices in accordance with service provider agreements and corporate payment procedures. ‣ Assisted in payroll preparation by providing relevant data (absences, bonus, leaves, etc). ‣ Researched potential vendors and obtained quotes, attended meetings and taking minutes to confirm purchase order details. ‣ Placed and tracked orders and ensuring timely delivery. ‣ Crossed-reference product deliveries with purchase orders. ‣ Responsible for the Stock organization. ‣ Scanned and filed all paper documents into the office network.

Caixa Econômica Federal | Jan 2006 - Jan 2006

Trainee

‣Assisted to individuals and companies. ‣ Improved transactions processing to manage related costs (e.g. credit cards, collections, payments). ‣ Assisted customers in writing checks and opening bank accounts. ‣ Consulted with customers about their product or service needs or their wants. ‣ Determined cash requirements. ‣ Entered members and transactions data into computer and issued computer- generated receipts to member.

My Education

Take a look at my formal education

Higher National Diploma, Science in Computing  · (janeiro de 2021 - janeiro deNational College of Ireland | 2022
Bachelor's degree, EconomicsUniversidade Federal Rural do Rio de Janeiro | 2015

About Me

Laura Motta

Laura hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free