Sql Developer Editor
Resume:
PROFESSIONAL PROFILE
Hardworking professional with a proven record of accomplishments in the development of business Software with Database. Designed and managed highly effective applications framework. Spear headed comprehensive update of corporate legacy system. Strong development background in combination with comprehensive understanding of business needs and goals, that result in consistent and excellent production of relevant solution-oriented applications.
HANDS-ON TECHNICAL SKILLS
Excellent in Databases, Data-Warehouse solution lifecycle & Unit Testing, Metadata, ETL - Extraction Transformation and Loading, Data loads, and Data Integration & Migration processes.
Worked on Database Development / Production / Staging Environment implementation for SQL Server.
Knowledge in T-SQL, MS SQL Server 2016, 2019 (SSMS) and Business Intelligence (SSAS, SSRS, SSIS), Power BI, Tableau.
Microsoft Office (Word, Access, Excel, PowerPoint, Publisher, Outlook, Visio, Projects)
WORK EXPERIENCE
NextGen Healthcare, Atlanta, GA
Analyst I [January 2022 till date]
Roles & Responsibilities:
Developed insightful and interactive business intelligence reports (KPIs, operating metrics, business metrics, ad-hoc queries), dashboards, and scorecards in regular cadence using Power BI tool.
Leveraged large amounts of data to solve business issues, support various function team with business intelligence.
Designed, built, and automate reports that provide actionable insight on key metrics.
Collaborated with stakeholders to ensure the creation and delivery of the new/enhanced reports/dashboards.
Performed detailed analysis of source systems data and model data with Power BI.
Produce management information reports, identify, and correct data anomalies, and manage all data integrations, working closely with stakeholders in senior management, functional leaders, and colleagues across multiple functions.
Used Power Query Editor to import data from source files, shape, combine and consolidate the data into one useful query to create a visual report and a data model to use in reports.
Used the DAX-Language to create calculated columns or measures to perform in-depth data analysis.
Cornerstone Building Brand, Marietta GA
Power BI Developer [November 2018 December 2021]
Roles & Responsibilities:
Design and develop of reporting data module for Marketing Analytics.
Creating Row level security with power bi and integration with power bi service portal.
Developed profit analysis reports and dashboards by products and customers
Worked on all types of transformations that are available in Power bi query editor.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
Created reports using time intelligence calculations and functions.
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Executed dashboard setups and data manipulation using DAX.
Apterve Inc, United Kingdom [November 2016 July 2018]
MS SQL Developer (Remote)
Roles & Responsibilities:
Involved in writing T-SQL Queries.
Worked on Query Optimization through query Analysis and Index Optimization.
Involved in writing SQL Scripts using T SQL to create the datasets for the reports.
Used Joins and sub queries concept for extracting data from multiple tables.
Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written function, stored procedures, and triggers.
CERTIFICATION & TRAINNIG
SQL Training & Certification for MS SQL Server from Ennplugg Consult.
EDUCATION
B. Sc Lagos State University November 2009
RESUME
OLUWASEUN
TUGBIYELE
435 Vinings Vintage Cir, Mableton GA, 30126
****.*********@*****.***
Contact this candidate