Ebun Eluyera Email & Phone Number

Dallas Tx- Remote

•Experience working across cross-functional teams to gather requirements, propose a technical solution, and execute against defined timelines.•Developed executive and operational dashboards to monitor the business’s velocity and create ad-hoc reports.•Collaborating with the ETL team on the best approach for data integration and ETL tasks by extracting, transforming, and loading data to and from different RDBMS and Utilizing ERWIN Modeler for ETL data modeling, migration, and analysis.•Developing an overall approach for designing a solution and evaluating risk analysis with teams by using BI tools as both investigative and predictive tools to develop insights for business decisions.•Successfully applied R and Python integration in Tableau for advanced statistical and predictive analysis.•Developing KPIs and KRIs metrics that are crucial for analyzing business performance and making informed decisions against risks and control requirements.•Creating and managing complex dashboards, using insights from data exploration to build comprehensive findings into advanced and intuitive visualizations (using Tableau) and insights.•Developing tableau reports for year over year, month over month, YTD, QTD and MTD analysis using Charts such as Line/Bar/Donut/Bubble/Funnel charts etc.•Providing end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.•Working closely with database leads and DBAs to troubleshoot SQL performance issues.•Assisted senior SQL developers in writing SQL queries and stored procedures.•Conducted data analysis and assisted in data cleansing and transformation.•Performed quality assurance testing on SQL scripts and database functionality.•Collaborated with the development team to integrate SQL code into applications.•Assisted in database performance tuning exercises.•Developed complex SQL queries and stored procedures to extract and manipulate data.

Dallas, Texas, United States

•Led requirements-gathering sessions with internal stakeholders on concept dashboards or analytic projects.•Ensured correct translation of business questions and needs into precise queries and reports. Developed reports with accurate, easy-to-read, useful information. Effectively interpret technical and business objectives and challenges and articulate solutions.•Worked with the development team to plan, develop, and implemented a BI system for KPIs for evaluating the health of the organization•Worked with team to develop ETL packages to move data from disparate source systems such as flat files, excel, and Oracle database into centralized SQL server enterprise database using Erwin Data Modeler•Developed solution-based dashboards by creating various types of charts including Crosstabs, Heat/Geo/Tree maps, Pie/Bar Charts, Scatter plots, and Histogram using Tableau Desktop•Utilized advanced table features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and filters•Applied knowledge of APIs in data source connections in Tableau•Built and published customized interactive Tableau reports and dashboards as well as managed extracts and refresh schedules using Tableau Desktop and Tableau Server•Executed data queries across multiple data sources in support of business intelligence reporting needs•Utilized Tableau to design, develop, enhance, and support Tableau visualizations including highly interactive dashboards, scorecards, and reports with drill down to detail and analysis pathways to other supporting reports•Involved in creating database objects such as tables, views, Stored procedures, triggers, and functions using T-SQL to effectively provide data description and structure•Worked with the Business Analyst team to support UAT testing and obtain sign-off•Performed backend testing by executing SQL Queries•Worked successfully in an Agile Project across multiple features and component teams