Maia B

 Developed and executed complex SQL queries to extract, transform, and load (ETL) data from multiple sources into MySQL databases, ensuring data accuracy and integrity. Utilized Visio to create and maintain database schema diagrams, ensuring accurate representation of data structures. Developed robust data models in Power BI, including defining relationships, hierarchies, and calculated columns, to support complex reporting requirement
 s. Apache Hadoop ecosystem by working with technologies like HDFS, YARN, Hive, Pig, and HBase to manage and analyze data efficiently
 Experience with the following Erwin Data Modelling, Oracle, SQL Server, DB2, and Big Data Technologies. Developed dashboards and ad-hoc reports using Tableau for senior management team for analysis
 Performed Transformation like Lookup, filter, Aggregate, Join, Sort, etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file and MS Access to data warehouse such as snowflake

Conducted statistical analysis using Python to identify trends, patterns, and correlations within datasets, aiding data-driven decision-making.
Demonstrated responsibility by designing and implementing data ingestion pipelines using Apache Hadoop ecosystem components like Apache Flume or Apache Nifi.
Leveraged Jupyter Notebooks to explore and understand complex datasets thoroughly.
Performed data cleaning and preprocessing tasks within Jupyter Notebooks, ensuring data quality and integrity.
Created different visualizations in Tableau according to the requirements.
Designed data models and performed regression analysis in Excel to identify patterns and make predictions.
Conducted scenario analysis using Excel to assess the impact of different variables on business outcomes.
Designed and implemented data visualization solutions in QlikView to answer business questions and drive data-driven decision-making.
Extraction of test data from tables and loading of data into SQL tables.
Utilized SAS Enterprise Miner to identify patterns and trends within large datasets, improving predictive modeling accuracy.
Produced regular and ad-hoc reports using SAS to communicate analysis results to non-technical stakeholders effectively.
Proficient in utilizing Microsoft Azure's robust suite of data services, including Azure SQL Database, Azure Data Factory, Azure Databricks, and Azure Synapse Analytics, to efficiently manage, process, and analyze large volumes of data.
Developed and executed complex SQL queries to extract, transform, and load data from multiple sources into MySQL databases, ensuring data accuracy and integrity.
Utilized Visio to create and maintain database schema diagrams, ensuring accurate representation of data structures.
Developed robust data models in Power BI, including defining relationships, hierarchies, and calculated columns, to support complex reporting requirements.
Worked with technologies like HDFS, YARN, Hive, Pig, and HBase to manage and analyze data efficiently.
Experience with Erwin Data Modelling, Oracle, SQL Server, DB2, and Big Data Technologies.
Developed dashboards and ad-hoc reports using Tableau for senior management team for analysis.
Performed transformations like Lookup, filter, Aggregate, Join, Sort, etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file and MS Access to data warehouse such as snowflake.
Implemented and managed user access controls, roles, and permissions within MySQL databases to ensure data security and compliance with privacy regulations.
Conducted thorough data analysis using QlikView to identify trends, patterns, and anomalies within the data.
Provided continued maintenance and development of bug fixes for the existing and new Tableau reports.

Developed cost and other performance targets that were measurable and achievable, and acted decisively in enhancing client experience as well as internal team support.
Created reports based on business requests and ad hoc requirements using Tableau desktop.
Prepared financial deliverables including quarterly, accrual and budgetary reports for stakeholders to illustrate KPI metrics.
Developed interactive Tableau reports after gathering and analyzing the data from the warehouse to illustrate KPI of the sales.
Developed and delivered QlikView training sessions to end-users, empowering them to self-serve their data analysis needs.
Written complex SQL queries for validating the data against different kinds of reports.
Provided training sessions and support to team members and stakeholders on using Visio for data visualization and diagramming.
Developed error handling processes in Excel to identify and rectify data anomalies.
Documented Excel workflows, formulas, and processes for knowledge sharing and continuity of data analysis tasks.
Implemented data integration solutions, including ETL pipelines, to efficiently transfer and synchronize data between MySQL databases and other data sources, enhancing data consistency.
Optimized AWS infrastructure costs by using services like AWS Cost Explorer and EC2 Spot Instances while maintaining performance and availability.
Integrated PostgreSQL with data visualization tools like Python's Matplotlib or Seaborn to create visually appealing charts and graphs for data storytelling and presentations.
Optimized SAS code for efficiency, reducing processing times and resource utilization.
Developed custom SAS scripts and macros to automate routine tasks.
Implemented robust security measures, such as Kerberos authentication and encryption, to protect sensitive data stored in Apache Hadoop clusters.
Documented analysis processes and results in RMarkdown or Jupyter Notebooks and communicated findings to non-technical stakeholders.
Implemented robust data backup and disaster recovery strategies on AWS S3 and AWS Glacier, ensuring data integrity and business continuity.
Evaluated data models and reports in the ETL process for quality and accuracy and made recommendations backed up by data visualizations to support the business team.
Implemented data security measures and access controls in QlikView to protect sensitive information.
Utilized PostgreSQL's advanced concurrency control mechanisms, including MVCC, to handle high-transaction-rate environments and ensure data consistency.
Created interactive and informative dashboards and reports using Tableau or Power BI, connecting to MySQL databases to provide stakeholders with real-time business insights into key metrics.
Established monitoring and alerting systems using AWS CloudWatch to dynamically identify and address performance issues in data pipelines, ensuring high availability.
Used Tableau to tell compelling data stories, combining visualizations, text, and interactivity to convey the narrative behind the data and drive action.
Set up and managed automated data refresh schedules in Power BI Service to keep reports and dashboards up-to-date with the latest data.
Connected to relational databases using R, extracting data, and performing SQL queries for data retrieval and analysis.
Created and scheduled QlikView reload tasks to ensure data availability for real-time reporting.

Responsible for building and maintaining effective working relationships with business teams, as well as other external vendor and Customer Data Management Team.
Created data visualizations using libraries like Matplotlib, Seaborn, and Plotly to communicate insights effectively.
Developed interactive Tableau reports for sales KPIs after data analysis.
Created automated Excel reporting templates, reducing manual work.
Proficient in Python for data analysis and R for statistics.
Managed MySQL replication for real-time data synchronization.
Designed custom Visio templates for data diagrams.
Orchestrated data transfers between PostgreSQL databases.
Optimized Power BI reports and dashboards for performance.
Conducted data validation for accurate QlikView reports.
Connected Tableau to various data sources for seamless integration.
Implemented auditing and logging features in PostgreSQL to track database activity and monitor data changes for security and compliance purposes.
Used Python to connect to relational databases and execute SQL queries for data extraction and analysis.
Created data visualizations using R packages such as ggplot2 and lattice.
Managed data migration projects involving Oracle/DB2 data warehouses, successfully transferring data to Teradata using Informatica Power Centre.
Utilized Microsoft Visio to enhance data communication, integrating visualizations into presentations and reports for informed decision-making.
Performed ad hoc analysis in Tableau to address specific business inquiries, delivering timely insights to support strategic goals.
Proficient in statistical analysis using Python, including hypothesis testing, regression analysis, and correlation studies with libraries such as SciPy and Statsmodels.
Stayed current with the latest SAS features and best practices through continuous training and certifications.
Shared Power BI reports and dashboards through Power BI Service, enabling collaboration and data access among team members.
Stayed updated on QlikView best practices and industry trends to improve data analysis processes.
Employed Excel for data transformation tasks like merging, splitting, and reshaping data to meet analytical requirements.

Conducted in-depth financial analysis on multiple industries, resulting in increased company sales by 5%.
Collaborated with cross-functional teams to understand business requirements and prepare as well as present monthly and quarterly reports to senior management.
Assisted in the preparation of presentations and proposals for clients, contributing to the acquisition of 3 new clients.

Provided hands-on support to research team in reviewing necessary materials for accuracy of ongoing research projects.
Supported portfolio managers by working on 2 papers for ad-hoc analysis to use in investment models and undertook company and industry-specific research.
Researched 15+ companies.
Involved in analyzing lead-lag relationship between multiple companies and industries to determine returns.

Utilized economics knowledge and understanding in analyzing Georgia’s agricultural sector and export potential.
Presented the findings to a group of 15 people.
Recognized by management for remarkable contribution within the areas of project funding.
Provided highlights and personal valuable insights.