Roxana Ibanez, Developer in Winnipeg, MB, Canada
Roxana is available for hire
Hire Roxana

Roxana Ibanez

Verified Expert  in Engineering

Bio

Roxana has more than 10 years of experience advising and assisting companies and clients in data warehousing, business intelligence, data governance, and digital transformation. She understands the benefits of good communication and clean code and how a well-projected architecture helps productivity and maintainability in the long term. Roxana's extensive experience in the data domain has been proven to help leverage applied analytics to manage complex problems.

Portfolio

Eileen Fisher, Inc.
Data Analytics, Microsoft Excel, Business Intelligence (BI), Data Analysis...
FGI Ltd
Data Governance, Data Management, Change Management, Python, PostgreSQL...
Banco Supervielle
MicroStrategy, Microsoft Power BI, Microsoft SQL Server, Python, SQL...

Experience

  • SQL - 10 years
  • ETL - 10 years
  • Data Modeling - 9 years
  • Business Intelligence (BI) - 9 years
  • Python - 5 years
  • Data Architecture - 3 years
  • Data Governance - 2 years
  • Scrum Master - 2 years

Availability

Part-time

Preferred Environment

Scrum, Databases, Python, Data Governance, Data Management, Master Data Management (MDM), Business Intelligence (BI), Analytics

The most amazing...

...thing I've developed was for a bank's data warehouse which handled warnings and errors on the input data which resulted in a 30% reduction of incidents.

Work Experience

Business Intelligence Analyst

2024 - 2024
Eileen Fisher, Inc.
  • Designed and developed an employee survey using SurveyMonkey.
  • Compared current survey results with past editions through Tableau visualizations.
  • Performed sentiment analysis on text comments and word clouds, filtering by community and role to dive deep into feedback.
Technologies: Data Analytics, Microsoft Excel, Business Intelligence (BI), Data Analysis, Surveys, Data Visualization, SurveyMonkey, Tableau

Data Management Specialist

2020 - 2024
FGI Ltd
  • Surveyed the organization to understand their processes and pain points and determine the maturity level. Executed lunch-and-learns to promote continuous learning and provide a friendly environment to showcase new tools and expand their usability.
  • Developed a transport-and-logistics rates tool and invoice auditing tool to analyze different carriers that obtained credit notes. The business estimates a $100,000 recovery in a year. The tools used are PostgreSQL, Python, and Power BI.
  • Designed several initiatives to take steps towards data governance with agile teams to gather definitions, cleanse data, and improve quality while defining policies that will keep information trustworthy.
  • Developed a data model (clients, sales, and orders) for an enterprise data warehouse; it ingested two years of information to start creating corporate KPIs.
  • Created a Tableau dashboard that overlays information from Salesforce, Statistics Canada, and LinkedIn talent insights to understand where talent recruitment missions could occur.
  • Designed and coordinated the development of a social media dashboard combining Google Analytics, Sprout Social, Pardot Tags, and partnership sales to understand audiences and improve the organization's content.
Technologies: Data Governance, Data Management, Change Management, Python, PostgreSQL, Microsoft Power BI, Microsoft Excel, SQL, Requirements Analysis, Dashboards, Data Visualization, Data, Key Performance Indicators (KPIs), Data Analysis, Business Intelligence (BI), ETL, ETL Development, Python 3, Dashboard Development, Data Analytics, Business Requirements, Reporting, Relational Databases, Salesforce

Data Manager

2019 - 2020
Banco Supervielle
  • Led the design and deployment of the data governance plan which included hosting the steward council and forming an agile team to address changes along the organization to live by the business definition.
  • Implemented scrum as a work methodology in the data warehouse.
  • Generated training spaces on Python programming and Power BI and participated as a trainer of Python for beginners.
  • Oversaw the expansion and usage of the API design to be the MDM (master data management) solution of customer data.
Technologies: MicroStrategy, Microsoft Power BI, Microsoft SQL Server, Python, SQL, Requirements Analysis, Dashboards, Data Visualization, Data, Key Performance Indicators (KPIs), Data Management, Data Analysis, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), ETL, Agile, Dashboard Development, Data Analytics, Business Requirements, Reporting, Relational Databases, ELT

Data Architect

2018 - 2019
Banco Supervielle
  • Managed the data assessment process within the company which included coordinating the RFP for the process and establishing the strategy for the data ecosystem within the company.
  • Coordinated a data warehouse/database migration team and published updates to users; also kicked off the data warehouse data reengineering process.
  • Participated in RFP for a campaign manager tool implementation by designing a data model for campaigns on the data warehouse.
Technologies: SAS, Microsoft Power BI, MicroStrategy, Microsoft SQL Server, Python, SQL, Requirements Analysis, Dashboards, Data Visualization, Data, Key Performance Indicators (KPIs), Data Management, Data Analysis, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), ETL, Teradata Databases, Agile, ETL Development, Scrum Master, Data Architecture, Relational Databases, ELT

Data Analytics and Reporting

2017 - 2018
Elementum SCM
  • Designed and developed a transport data mart with Python by extracting data from Elasticsearch, MongoDB, and SQL Server, which provided insight for Carrier Managements and data quality improvement points.
  • Refactored the application usage dashboard in Tableau, making it more user-friendly and efficient; also documented the information linage, gaining data transparency and trust.
  • Gathered requirements from business areas and developed the processes in Python, Elasticsearch, MongoDB, SQL Server, and Tableau.
  • Interacted with different areas within the organization to implement required data solutions.
  • Mentored and trained new talents and business team members in the areas of data analytics and reporting in Python, SQL, and Tableau.
Technologies: Python, Tableau, Microsoft SQL Server, Elasticsearch, MongoDB, Microsoft Excel, SQL, Requirements Analysis, Dashboards, Data Visualization, Data, Key Performance Indicators (KPIs), Cloud, Data Analysis, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), ETL, Git, Agile, Python 3, Dashboard Development, Data Analytics, Amazon Web Services (AWS), Reporting, Relational Databases, ELT

Associate

2015 - 2017
AlixPartners
  • Worked on an analytics solution POC for an Asian retail company with Tableau, Netezza, and SQL Server.
  • Enhanced analytical capabilities of a US healthcare company to detect fraud. This also involved a massive data migration from SQL Server using Abinitio to Hadoop with an agile team.
  • Participated in the REOI and RFP process of a power company in the US and implemented a POC for fraud.
  • Developed a lead management dashboard for private equity using Python and Tableau.
  • Worked as scrum master in an implementation—removing blockers and helping teams achieve their goals.
Technologies: Hadoop, Ab Initio, Netezza, Tableau, Microsoft SQL Server, Python, Microsoft Excel, SQL, Requirements Analysis, Dashboards, Data Visualization, Data, Key Performance Indicators (KPIs), Data Engineering, Data Management, Data Analysis, Business Intelligence (BI), ETL, Git, Change Management, Data Build Tool (dbt), Dashboard Development, Business Requirements, Reporting, Relational Databases, Looker Studio

Professional Services Consultant

2012 - 2014
Teradata
  • Led the design and development of a process to control data quality on the input data to the data warehouse that decreased 30% incidents.
  • Developed ETL process and design data models in the corporative data warehouse.
  • Coordinated the team and software factory tasks.
  • Gathered and documented business requirements, interact with outside data providers to incorporate new information into the enterprise data warehouse.
Technologies: Informatica PowerCenter, Teradata, SQL, Requirements Analysis, Dashboards, Data Visualization, Data, Key Performance Indicators (KPIs), Data Engineering, Data Analysis, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), ETL, Teradata Databases, ETL Development, Dashboard Development, Data Analytics, Business Requirements, Reporting, Relational Databases, ELT

Data Warehouse and Business Intelligence Analyst

2010 - 2012
Claro (Telecommunications Company)
  • Contributed to the implementation of an Informatica PowerCenter ETL tool.
  • Automated the monthly accounting closing processes.
  • Generated several data marts and optimized their ETL process.
Technologies: SAP BusinessObjects (BO), Informatica PowerCenter, Data Integration, Oracle, SQL, Requirements Analysis, Dashboards, Data Visualization, Data, Data Engineering, Data Analysis, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), ETL, ETL Development, Dashboard Development, Data Analytics, Reporting, Relational Databases, ELT

Supervielle Bank

Supervielle is among the top ten banks in Argentina and has a history of 130 years on the country being the leader in some segments.

Tasks Accomplished:
• Implemented data governance.
• Established the road map for the data governance initiative.
• Kicked off the steward council and client definition.
• Implemented Campaign Manager.
• Performed the scrum master tasks.
• Implemented Jira for data projects.
• Migrated a data warehouse database from SQL Server 2008 to 2017.
• Coordinated and hosted Python training for beginners.
• Implemented Power BI for beginners' training coordination.
• Used RFP for a strategic data assessment project.
• Assessed data and composed scripts over business databases and data warehouse database to profile data.
• Established the baseline for the data governance and data strategy plan.

Data Governance Plan

A data governance plan for a distribution company.

I was the data management specialist, and based on their mission and goals, I assess their maturity and propose a detailed plan on how to implement data governance while working towards those goals.

I design the party data model, incorporated data from their systems for the data warehouse POC, and automated the invoice auditing for suppliers. This resulted in up to 54% of them obtaining credit notes that improved supplier management.

Transport and Logistics Auditing Tool

I developed an auditing tool for rates and invoices for different carriers in transport and logistics. It was developed using Python and PostgreSQL on the back end and Power BI for the customer-facing part, which enabled the business to recover an estimated $100,000 a year and improve the relationship with the carriers. The tool gathers invoices and rates agreements and detects anomalies and overcharges while showing trends.

Data Architect - Data Governance

I performed a company assessment and documented usage across multiple areas and sites of the system to conduct a clinical trial. I also audited the associated data and created standard operating procedures (SOPs) and data governance policies.
2018 - 2019

Specialization in Data Science (Computer Science)

ITBA | Instituto Tecnológico de Buenos Aires - Buenos Aires, Argentina

2016 - 2016

Certificate of Completion in Machine Learning for Big Data and Text Processing (Computer Science)

MIT | Massachusetts Institute of Technology - Online

2014 - 2015

Master's Degree in Strategic Management and Technology (Computer Science)

ITBA | Instituto Tecnológico de Buenos Aires (EOI) - Buenos Aires, Argentina

2014 - 2014

Postgraduate Degree in Business Intelligence (Information Technology)

UTN | Universidad Tecnológica Nacional - Buenos Aires, Argentina

2002 - 2011

Bachelor's Degree in Business Administration and Management

UBA | Universidad de Buenos Aires - Buenos Aires, Argentina

NOVEMBER 2019 - PRESENT

IELTS General Training

IELTS

DECEMBER 2012 - PRESENT

Teradata 12 Certified Professional

Teradata

Tools

Tableau, Informatica PowerCenter, Microsoft Power BI, Microsoft Excel, Abinitio, Git, Talend ETL, Ab Initio, AWS CLI, Salesforce Sales Cloud, SurveyMonkey

Paradigms

ETL, Business Intelligence (BI), Requirements Analysis, Agile, Scrum, Change Management

Storage

Relational Databases, Teradata Databases, Data Integration, Elasticsearch, MongoDB, Databases, Microsoft SQL Server, Netezza, Teradata, Master Data Management (MDM), PostgreSQL, MySQL

Languages

Python, SQL, Python 3, SAS

Frameworks

Hadoop

Platforms

Oracle, Amazon Web Services (AWS), Salesforce

Industry Expertise

Healthcare

Other

Data Analysis, Data Management, Data Visualization, Data, Key Performance Indicators (KPIs), Data Warehousing, Dashboard Development, Data Analytics, Business Requirements, Reporting, Data Modeling, Data Governance, Data Architecture, Analytics, ETL Development, Dashboards, Data Engineering, Data Warehouse Design, Data Build Tool (dbt), Looker Studio, ELT, Scrum Master, MicroStrategy, SAP BusinessObjects (BO), Data Science, Cloud, Surveys, SOP Development, Relational Database Services (RDS)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring