Post Job Free
Sign in

Power Bi Data Management

Location:
Melissa, TX
Posted:
January 24, 2025

Contact this candidate

Resume:

Delinta Baylor

SUMMARY:

•Excellent professional communication skills through clearly written, concise and comprehensive documentation; strong technical writing skills and ability to develop and/or present training to operations trainers and/or business users.

•Experienced in Data mining of disparate Data sources and with NPR Report Writing and Crystal Reports.

•Prepare reports and coordinate on various system process improvement initiatives and exciting ad hoc analytic projects as assigned by the Director, Process & System Performance.

•Experience with multiple Customer Assignment System proprietary systems and with SQL Database and knowledge of different ETL tools (PL/SQL, SSIS, T-SQL, Data Migrator.

•Experience with SSRS Report Builder, TeraData SQL Reporting, Toad Data Point and worked with ALM or Quality Centre for defect tracking and testing.

•Used advanced Tableau features including calculated fields, parameters, table calculations, joins, Data blending, and dashboard actions.

•Responsible for Analyzing report requirements and developing the reports by writing TeraData SQL Queries and using MS Excel and used complex computer programs to mine Data sources and look for trends.

•Support Data manipulation and developed performance metrics with BI reporting tools MicroStrategy, Tableau, Power BI, Qlik and Cognos.

•regulatory requirements and Data model governance

•10 years’ experience in Data management

•10 years’ experience in Data governance

•10 years’ experience in Data analysis

•Strong experience defining and documenting process flows and design in both verbals to transfer into system requirements and specifications

TECHNICAL SKILLS:

•Proficient in numerous MS Office Applications, PowerPoint

•Experienced working with Cognos

•Experienced working with Qlik

•Experienced working with Power BI Reporting

•Advanced MS Excel

•Experience with all phases of Software Development Life Cycle, Agile/Scrum methodologies

•Experience with Visual Basic, VB Script or similar language (PowerShell, JavaScript, Auto Hotkey, Autofit)

•Advanced knowledge in Visio Studio, SharePoint

•Ability to build or create Tableau Dashboards

•Active Directory

•Demonstrated ability to be work under pressure and to meet tight deadlines with proactive, decisiveness and flexibility

EXPERIENCE:

Wells Fargo - Lead Data Management Analyst Dallas, Texas 09/2022 to Present

•Perform initial analysis of Application Data to determine potential owners of Application Groups.

• Work with both business and technology partners identified as potential owners to obtain ownership agreement.

•Work with IT development team to get ownership of Application Group(s) properly assigned to the owner.

•Maintain detailed tracking logs that identify the status of each Application Group. Provide visual diagrams such as bar charts based off of the Data in the tracking logs. Analyzing business requirements with complex logics.

•Identify Data gaps and research missing transmissions by using reporting and partner systems; Create Data where transmissions are unavailable

•Developed perp Flow Diagrams for Tableau dashboard.

•Develop Power BI reports and Dashboard for internal team needs

•Partner with other team members as well as cross-functional partners to support business processes, system solutions and strategic projects

•Challenge conventional thought, offer unique perspectives and conceive innovative solutions

•Write & execute Test Plans and Test Scripts (both Functional and Data Integrity)

•Identify opportunities to streamline or improve processes through operational or technical solutions

•Write and execute basic SQL queries (knowledge of Database structure necessary)

•Perform Excel VLOOKUP’s, various count formulas and build out charts based on those formulas

•Provide technology solutions and support for Risk, Audit, Finance, Marketing, Human Resources, Corporate Properties, and Stakeholder Relations business lines.

•Establish and formalize relationships in and between departments where business critical dependencies have been identified.

•Provide input during development and implementation phases, including formulation and definition of systems scope, objectives, and necessary system enhancements.

Northern Trust - Business/Data Analyst Remote 09/2021 to 09/2022

•Perform initial analysis of Active Directory Group Data to determine potential owners of Active Directory Group(s).

•Work with both business and technology partners identified as potential owners to obtain ownership agreement.

•Linked Tableau server to publish dashboard to a central location for portal integration.

•Work with IT development team to get ownership of Active Directory Group(s) properly assigned to the owner.

•Utilize all Tableau tools including Tableau Desktop, Tableau Public/Online/Server, and Tableau Reader.

•Maintain detailed tracking logs that identify the status of each Active Directory Group. Provide visual diagrams such as bar charts based off of the Data in the tracking logs. Analyzing business requirements with complex logics

•Design, configure, and document Tableau Data Source and Extract.

•Identify Data gaps and research missing transmissions by using reporting and partner systems; Create Data where transmissions are unavailable

•Write & execute Test Plans and Test Scripts (both Functional and Data Integrity)

•Identify opportunities to streamline or improve processes through operational or technical solutions

•Write and execute basic SQL queries (knowledge of Database structure necessary)

•Perform Excel VLOOKUP’s, various count formulas and build out charts based on those formulas

American Eagle - Data Analyst Remote 03/2021 to 09/2021

•Work daily with Oracle Financial as part of Implementation Team

•Serve as direct consultant for Finance & Accounting team, assisting with Oracle integration and Data validation

•Analyzing business requirements with complex logics

•Manage the domestic and international supply chain Data stream identifying exceptions and resolving discrepancies

•Identify Data gaps and research missing transmissions by using reporting and partner systems; Create Data where transmissions are unavailable

•Create and utilize reporting to analyze trends and ensure compliance from our Data trading partners

•Experience in configuration and administration of Tableau Server in a multi-server and multi-tier environment.

•Implement supply chain-related integrations (flat files, EDI transactions, XML) with Trading Partners

•Actively manage and contribute to Data compliance programs and scorecards

•Partner with other team members as well as cross-functional partners to support business processes, system solutions and strategic projects

•Challenge conventional thought, offer unique perspectives and conceive innovative solutions

•Write & execute Test Plans and Test Scripts (both Functional and Data Integrity)

•Identify opportunities to streamline or improve processes through operational or technical solutions

•Write and execute basic SQL queries (knowledge of Database structure necessary)

•Utilize business intelligence reports/dashboards using QlikView, Tableau or Cognos

•Participate in appropriate training and development activities

Bank of America - Data Analyst/Database Tester Dallas, Texas 06/2020 to 11/2020

•Analyzing business requirements with complex logics, translation of business logic into test cases/scripts

•Created report schedules on Tableau server. Created drill down and drill up in worksheets in tableau.

•Responsible for SQL Database testing using SQL server or Oracle.

•Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.

•Deploy QA builds, applying OTSs & running batch processes on QA environments.

•Troubleshoot issues occurred during the testing.

•Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.

•Perform modification of the code/SPs in test and creation of the test Data

•Functional Testing and Data Integration Testing & executing Automated Test Scripts

•Test Management tools like HP-ALM QC, JIRA

Wells Fargo - Data Analyst Dallas, Texas 07/2019 to 04/2020

•Makes recommendations based on Data analysis that may have performance and financial impacts to the company

•Responsible for SQL Database design, architecture, administration, and report customization.

•Prepare reports on excel and coordinate on various system process improvement initiatives and exciting ad hoc analytic projects as assigned by the Director, Process & System Performance.

•Prepare Dashboards using calculations, parameters in Tableau.

•Develop performance metrics and develop Database QA tools and KPI metrics.

•Conduct and contribute to project meetings and responsible Database and reporting functionality

•Design interactive dashboards in Tableau Desktop and published them to Tableau Server.

•Design and maintain Data Dictionary for Technical and Business stakeholders

•Design and maintain MetaData templates for Technical and Business stakeholders

•Provide Data analysis to support business requirements definition and interact with both the business and technical partners.

•Collecting, organizing, and analyzing Data from various resources and prepare complex Data reports on excel.

•Experience in retrieving Data with TeraData, Oracle, and SQL

•Created own customized visualizations in tableau.

•Managing the activities required to maintain a Data & process governance structure

•Demonstrated experience in one or more of the following disciplines: Data Quality

•Manage the daily, weekly, and monthly reports on excel and contribute to continuous improvement projects and Data maintenance projects.

Steward Health Care System - Supply Chain Data Analyst II Richardson, Texas 08/2018 to 07/2019

•Makes recommendations based on Data analysis that may have performance and financial impacts to the company

•Responsible for SQL Database design, architecture, administration, and report customization.

•Responsible for Database and reporting functionality

•Utilize MS Excel and interpret Data, extract trends, and identify insights

•Coordinate on various system process improvement initiatives and exciting ad hoc analytic projects as assigned by the Director, Process & System Performance.

•Develop performance metrics with BI reporting tools MicroStrategy, Tableau, Power BI, Qlik and Cognos.

•Develop Database QA tools and KPI metrics and utilize excel and interpret Data.

•Assist supply chain team with DBA support when needed.

•Present reporting to supply chain team members and hospital users as required on excel

•Collecting, organizing, and analyzing Data from various resources and generate reports on excel.

•Experience in retrieving Data with TeraData and SQL

•Contribute to continuous improvement projects and Data maintenance projects in the Supply Chain Department.

•Responsible for a range of activities including statistical analysis, designing, and deploying dashboards, identifying key trends based on Data, and forecasting or predicting business outcomes.

•Design and maintain Data Dictionary for Technical and Business stakeholders

•Assist with the ETL and Data modelling using Alteryx

•Assist with building and maintenance of Data warehouse

Bank of America - Business Intelligence Consultant Richardson, Texas 08/2017 to 03/2018

•Makes recommendations based on Data analysis that may have performance and financial impacts to the company

•Use complex computer programs to mine Data sources and look for trends.

•Effectively works with cross-functional teams and establishes strong relationships with key members of the Compliance Operations team

•Created own customized visualizations in tableau.

•Manually combine Data elements to create compliance to track performance

•Generate Performance Reports daily, weekly, and monthly and promptly distribute to all business owners and the executive management team in a timely manner.

•Interpret Data, extract trends, and identify insights

•Proactively provide timely feedback to the management team whenever key metrics and measurements exceed the acceptable parameters.

•Used advanced Tableau features including calculated fields, parameters, table calculations, joins, Data blending, and dashboard actions.

•Designing and plan BI solutions

•Design interactive dashboards in Tableau Desktop and published them to Tableau Server.

•Writing relational and multidimensional Database queries

•Configuring, deploying, and maintaining Database servers

•Experience with Data Extraction, Transformation and Loading (ETL) with Microsoft SQL Server SSIS from different Data sources like DB2, Oracle, MS SQL Server etc.

•Experienced with different Relational Databases like TeraData, Oracle, and SQL Server.

•Experienced working on large volume of Data using TeraData SQL

•Responsible for Analyzing report requirements and developing the reports by writing TeraData SQL Queries and using MS Excel

•Wrote several TeraData SQL Queries using TeraData SQL Assistant for Ad Hoc Data Pull request and used Joins like Inner Joins, Outer joins while creating tables from multiple tables.

•Utilized ODBC for connectivity to TeraData via MS Excel to retrieve automatically from TeraData Database.

•Designed & developed various Ad hoc reports for different teams in Business (TeraData and Oracle SQL, MS ACCESS, MS EXCEL)

•Created pivot tables in Excel by getting Data from Toad, TeraData, and Oracle.

•Design, configure, and document Tableau Data Source and Extract

•Experienced structured Databases, information architecture, metaData management, and documentation

•Experienced Visual Studio, Team Foundation Server, Agile, SharePoint, and Microsoft teams.

•Develops, implements, and maintains policies and procedures regarding regulatory requirements and Data model governance

•Design and maintain Data asset-related artifacts

•Develop and deliver presentations, summarizing key business needs and articulating model options to facilitate model optimization decisions and to drive decision-making with key stakeholders

•Design and maintain Data Dictionary for Technical and Business stakeholders

•Support Data manipulation

•Writing reports/reporting services using SSRS

•Supported Compliance reports with Microsoft SQL Server SSRS

Bank Of America - Business Intelligence Developer Dallas, Texas 08/2016 to 07/2017

•Effectively works with cross-functional teams and establishes strong relationships with key members of the Compliance Operations team

•Makes recommendations based on Data analysis that may have performance and financial impacts to the company

•Use complex computer programs to mine Data sources and look for trends.

•Manually combine Data elements to create compliance to track performance

•Generate Performance Reports daily, weekly, and monthly and promptly distribute to all business owners and the executive management team in a timely manner.

•Interpret Data, extract trends, and identify insights

•Extensive experience in working with Tableau Desktop, Tableau Server, Tableau Online in various versions of Tableau

•Create user support documents for Tableau use to be shared on SharePoint

•Writing relational and multidimensional Database queries

•Configuring, deploying, and maintaining Database servers

•Experience with Data Extraction, Transformation and Loading (ETL) from different Data sources like Toad, DB2, Oracle, MS SQL Server etc.

•Provide ongoing support and user training for Tableau use

•Experienced with different Relational Databases like TeraData, Oracle, and SQL Server.

•Experienced working on large volume of Data using TeraData SQL

•Responsible for Analyzing report requirements and developing the reports by writing TeraData SQL Queries and using MS Excel

•Wrote several TeraData SQL Queries using TeraData SQL Assistant for Ad Hoc Data Pull request.

•Used Joins like Inner Joins, Outer joins while creating tables from multiple tables.

•Utilized ODBC for connectivity to TeraData via MS Excel to retrieve automatically from TeraData Database.

•End to end experience in designing and deploying Data visualizations using Tableau.

•Designed & developed various Ad hoc reports for different teams in Business (TeraData and Oracle SQL, MS ACCESS, MS EXCEL)

•Created pivot tables in Excel by getting Data from TeraData and Oracle.

AT&T - Business/Data Analyst Plano, Texas 02/2016 to 08/2016

City Of Arlington - Data Inventory Analyst Arlington, Texas 11/2015 to 02/2016

Ernst & Young - Data Research Analyst Dallas, Texas 03/2014 to 11/2015

Dr. Pepper - Data Research Analyst Plano, Texas 11/2013 to 03/2014

Interface People - Data Support Specialist Lewisville, Texas 06/2011 to 10/2013

Education:

Tarrant County College

Associate Degree in Communication

Cola berry School of Data Analytics

Developing BI/EDW Applications with MS SQL Server

Business Intelligence applications with Microsoft SQL Server 2016 using SSIS, SSRS and SSAS services.

70-467 Designing Business Intelligence Solutions with Microsoft SQL Server Certification



Contact this candidate