Lorena Lancho

Experience

• 

  Scotiabank

  Jun 2008 - Jul 2012

  Software Developer

  • Developed a C#-based integration tool between Microsoft Project Services (web services) and Financial System Application Management, which reduced 10% of operational hours per month.• Participated as a developer and operational support of Java-based application for the Caribbean and Latin America Call Centers, which reduced the Average Speed of Answer (ASA) by 30%.

• 

  Verizon Business

  Aug 2012 - Sept 2017

  Business Intelligence Data Analyst

  • Used agile methodologies to build and deliver automated dashboard and self-service reporting capabilities to IT Service Delivery teams, saving 100k dollars per year and reducing 40 man-hours a week.• Developed dashboards, and ad-hoc data extracts using complex SQL queries, stored procedures, SSRS and SSIS services, reducing 20% man-hours per month.• Responsible for automating manual processes by building ETLs that integrates multiple data-points, from different company divisions, reducing 80 man-hours a week. Show less

• 

  IBM

  Oct 2017 - Sept 2018

  Business Intelligence Specialist

  • Led projects to implement data solutions to business problems, provided estimates for user stories and tasks, managed team workload, and acted as a liaison between the team and the internal clients by understanding business needs.• Performed ETL processes, data warehouses, data marts, dashboards, Reporting & Analysis using relational MS SQL database, SQL queries, and MS BI Stack. • Lead the creation of knowledge database repository and post-implementation support to systems, built ad-hoc reports for the operational tools using SSRS, and SQL complex syntax. Show less

• 

  Centennial College

  Aug 2019 - Nov 2019

  Business Analyst Aerospace Program

  • Accountable for analyzing, understanding and documenting business objectives and requirements.• Responsible for gap analysis, to identify solutions that are cost-effective and meet industry partners' requirements (Marsh Brothers, Bombardier, and Lynch Fluids Controls).• Develop an Excel application for Cost-Benefit assessment, automated excel workbook(s) for use as data entry templates, and cleansing process for large data sets.

• 

  Scotiabank

  Feb 2020 - now

  - Managed and contributed to data initiatives, ensuring timely and budget-aligned project delivery.- Conducted data profiling, quality assessments, root cause analysis, and data mapping activities.- Identified and registered critical data elements (CDEs) and data sources, documented data lineage and flow diagrams, and defined data requirements.- Developed BAU data exception reporting, visualizations, dashboards, and data reconciliation.- Performed various data testing (QAT, BAT, PIV) and supported the mobilization of Compliance and AML Data domains. Show less - Lead the Transaction Monitoring requirements analysis for Mexico.- Lead the Data Development Team to define data specifications and transformation rules for customer, product, and transaction data ingestion into Oracle Case Management solution for Transaction Monitoring.- Collaborate with Enterprise Data Lake team to investigate different data scenarios and to define ETL logics as part of the data preparation step to Application Team.- Responsible to ensure a high level of steady state Production support.- Guide the QA Team on data conditioning and functional specifications for test design and planning. Show less

  • Manager, Compliance and AML Data

    Sept 2021 - now

  • Technical Business Analyst Advisory

    Feb 2020 - Sept 2021