Deborah Esezobor

adtuhe@r.postjobfree.com

+1-404-***-****

Professional Summary

BI Developer with over 3+ years of extensive experience in database design and development, with MS SQL Server versions 2020 using SSIS, SSRS and Power BI.

Excellent backend skills in creating SQL objects such as Tables, Stored Procedures and Views to facilitate efficient data manipulation and consistency.

Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2014/2016, SSIS and SSRS.

Experience in client interaction and understanding business applications.

Good understanding of SQL Server Reporting Services (SSRS) with Report management and Report delivery.

Good understanding of Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), Send Mail Task, Bulk Insert and Error Handling in SSIS

Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing, and teamwork spirits.

Experience

AMERICA UNITED MORTGAGE

SSIS/Report Developer 02/20 – Present

Responsibilities Include:

Generates reports of KPI scorecards & effective dashboards after gathering and translating end user requirements.

Experience creating stored procedures and views.

Involved in designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.

Data entry into SharePoint and bulk data entry into SharePoint from excel using Microsoft flow.

Create report templates and enhance reporting templates used in creating reports.

Experience with creating reports using Power BI.

Created Power BI reports using sources like Excel, SQL server, Datawarehouse, SAP, Azure SQL, Synapse, CSV, SharePoint.

Experience in creating data visualization solution and report dashboard using Tableau.

Created and developed Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts, Graphs, Drill Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.

Created Power BI visualization of Dashboards & Scorecards (KPI) for Finance Department

Designed, developed, and implemented Power BI Dashboards, Custom reports, Scorecards & KPI Reports using data from different sources like SQL Server, SAP, Azure, Excel, CSV, Share point.

Created DAX functions in Power BI to manipulate data.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.

Contribute to the development of automated reporting solutions.

Create and deliver Mortgage reports, dashboard, and analyses for senior and executive level audiences.

Create and maintain detailed documentation on all projects/requests.

Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.

Rendered Power BI reports to be executed automatically on weekly or monthly basis, created and managed subscriptions.

Scheduled the reports to run on daily and weekly basis in report manager and email them to managers and analysts to review in excel spread sheet.

STARBUCKS

Data Analyst 01/19 – 01/20

Responsibilities Include:

Served as a team member in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.

Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading).

Performed the extraction, presentation, and analysis of health care information to develop new solution that support business needs.

Worked on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS.

Configured packages with checkpoints, error logging and event handling to redirect error rows and fix the errors in SSIS.

Created Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.

Designed, developed, and deployed SSRS reports that include parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports, Gauges, Pie Chart, Bar Chart.

Support the customer by developing solutions that support the collection of data from various sources such as SAP, CSV and Excel files that needs to be transferred to Power BI Visualization reports.

Assist in generating various management and administrative reports based on the gathered data.

Demonstrate various visualization capabilities to measure the effectiveness of business operations.

Present analyzed data via tools such as heat-maps, charts, trendline, and location-based maps visualizations.

Enhance reporting mechanism for better data analytics.

Contact this candidate