Georgeta Piscati
Data Analyst Data Scientist and Data Warehousing
Hire their services
Request a quote with no obligation
About
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.
Experience
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
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
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.
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.
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.
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.
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
Education
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
