Georgeta Piscati

As a Data Analyst and Business Analyst with over 16 years of experience in business intelligence and operational systems, I have delivered data-driven solutions for various domains, including banking, academic, and manufacturing. I have a certificate in Data Science from MIT and a bachelor's degree in Mathematics and Computer Science from Craiova University.

My core competencies include designing and architecting business solutions, analyzing data, coordinating teams, managing workflows, project management, problem-solving, and operations. I have extensive experience in conducting workshops, challenging requirements, identifying unstated needs, and proposing strategies to support project delivery and process improvement. I have also built and automated cross-validation systems, reduced analysis time, and presented data issues to stakeholders. I am proficient in IT Business Analysis, Data Warehousing, Google Cloud Platform, Python, G Suite, and ITIL4. I am fluent in French, English, and Romanian. 

My mission is to leverage my data science and business analysis expertise to help organizations optimize their performance, enhance their customer experience, and achieve their strategic goals. I am passionate about discovering the meaning, value, and relationships of data, and connecting disparate data sources to gain insights. I am also motivated by collaborating with diverse teams, facilitating communication, and empowering innovation. I am currently looking for new opportunities as a Business Analyst, Data Scientist or Business Intelligence Consultant in the banking industry.

Business Analyst Consultant, Financial Market                                                November 2021 – May 2023

BNC, Montréal

• Organize collaborative activities with business units and stakeholders to define data quality metrics, increase data literacy, and improve data management, aligned with organizational goals.
• Understand and identify data, discover the meaning of the data, define relationships between data, and connect disparate data to gain insights and deliver operational changes to drive better results for the organization.
• Present and explain important insights from data overview, summary statistics, exploratory data analysis (EDA) and visualization - continuous and categorical variables, univariate, bivariate and multivariate analysis; treating missing values and outliers – Zscore and DBSCAN
• Analyze complex relationships, large data sets, trends in the data, and patterns, and conclude what data provides the most value.
• Driving the data cleansing activities
• Develop and refine new data standards, policies, and procedures by working closely with the data management team, business, PO and technical team to develop and implement policies and guidance across the organization and data sources.
• Manage requirements gathering and capture sessions to capture and prioritize business and end user needs related to data and analytics.
• Act as a resource person for development teams

Projects: risk factors, compliance reports (CAIS, CAT, BlueSheets), trading on US market. 

Technologies: Python, Power BI, Tableau, Broadridge, SQL, AWS, ActiViam, Swagger, Jira, DataStage, Sharepoint

Business Analyst Consultant, Treasury (QRM)                                         February 2020 – November 2021

DESJARDINS, Montréal

• Define the cross-validation strategy using the most important features of the business model.
• Build the architecture of the cross-validation system, so that it is automated. (Data modeling, transformations, and data loading). Reduced analysis time by 70%. 
• Organize collaborative activities with business units and stakeholders to define data quality metrics, increase data literacy, and improve data management, aligned with organizational goals.
• Understand and identify data, discover the meaning of the data, define relationships between data, and connect disparate data to gain insights and deliver operational changes to drive better results for the organization.
• Driving the data cleansing activities
• Develop and refine new data standards, policies, and procedures by working closely with the data management team, business, PO and technical team to develop and implement policies and guidance across the organization and data sources.
• Manage requirements gathering and capture sessions to capture and prioritize business and end user needs related to data and analytics.
• Act as a resource person for development teams

Project: change QRM data base engine. 

Technologies: Python, Power BI, Tableau, Oracle, SQL Server, HP ALM 12.53, Jira, Sharepoint

Business Analyst (PO)  Consultant, BI Department                                      January 2019 – February 2020

GILDAN, Montréal

• Analyze, model, and schematize targeted processes for the business needs of each branch (South America, Central America, Canada, China)
• Organize collaborative activities with business units and stakeholders to define data quality metrics, increase data literacy, and improve data management, aligned with organizational goals.
• Understand and identify data, discover the meaning of the data, define relationships between data, and connect disparate data to gain insights and deliver operational changes to drive better results for the organization.
• Manage requirements gathering and capture sessions to capture and prioritize business and end user needs related to data and analytics.

Projects: Netezza Replacement – POC, BRD, database architecture; System source JDEduards

Technologies: Snowflake et Netezza(queries), Talend et DataStage 7.5 (ETLs), QlikView(ETLs, dashboard and reports), OBIEE 10G(Dashboard and reports), Denodo (data virtualization layer), Data Vault

Business Analyst Consultant, BI Department                                                   March 2018 to January 2019

Business Development Bank of Canada, Montreal

• Data modeling and architecture for two data warehouses
• Write the requirements document (BRD) and present it to senior management.
• Organize and facilitate working sessions.
• Develop functional analysis documents (mapping) and test plans for production deployment.

Projects: Hospitality Industry and Loan Guarantee to BDC – two stars, 8 tables - Kanban; Clics Modernization – Change of source systems for 3 stars, 17 tables - DAD (Disciplined Agile Delivery)

Technologies: SSMS 2012(queries), SSIS 2012 and Informatica (ETLs), SSRS 2012(Reports, SQL & MDX), Enterprise Architect (data modeling), Confluence

Business Analyst (SME), Corporate data                                                                 June 2013 to March 2018

National Banque of Canada, Montréal

• Understand the business needs of stakeholders.
• Participate in the design, modeling, and architecture of data.
• Act as a resource person for development teams
• Ensure the profitability of delivered improvements/solutions.

Projects: Mortgage loan and line of credit, check imaging, monetary transactions, near real-time

Technologies: Toad(queries), DataStage PX 11.5(ETLs), Unix (scripts, commands), Oracle (BD), TWS (scheduler), MFT (secure file transfers), Excel(documentation), Quality Center (functional testing)

Lead Operations Analyst, FBN / PBN Wealth Management                                    April 2012 to June 2013

National Banque of Canada, Montréal

• Managed a 5-person operations team and mixed teams (developers, analysts, DBAs)
• Reported production status, incidents, and their resolutions to senior management.
• Coordinated production releases, environment updates, and data corrections with BNC, IBM, CGI teams.

Technologies: Toad (queries), DataDtage 8.1(ETLs), Unix, Oracle, UC4 et TWS (scheduler)

Business Analysis and Developer                                                                                       2007 – March 2012

PCG Canada, Montréal

Coordinated projects: for Upper Canada School Boards, Lambton Kent, French School Boards in Ontario, Prairie Spirit Saskatchewan, British Columbia, Atlanta, etc.

Technologies: SQL 2008 – SSIS, SSRS, SSAS, SSMS, MDX, SSMS, Sharepoint, Canvas (tableaux de bord), KPI, data mining

Data entry clerk, DICOM EXPRESS Montréal (Québec)                                                                 2004 – 2005

Software Engineer I, Daewoo Automobile, Romania                                                                     2000 – 2003

Computer science teacher, T. Arghezi Computer Science High School                                    1997 – 2000

Bachelor of Mathematics - Computer Engineering                                                                                  1997

Certificate, 2-year university degree, in psychology and pedagogy for teaching                                1997

Windows, Linux, and Novell Network Administration Diploma                                                             2006 

• Scrum Master – Université McGill 2019
• Data Science at Massachusetts Institute Technology, July 2023.
• ITIL 4 Foundation in IT Service Management, 2019
• Pythonic Programming, 2019
• Google Platform for developers, 2019
• Courses: Power BI, Tableau, AWS Certified Solutions Architect Associate SAA-C03, Data Vault
• Apache Kafka, and Kafka Streams for Data Processing, 2022