Samuel Adeleke Email & Phone Number

Lawrenceville, Ga, Us

United States

 Collaborating closely with business stakeholders to deeply understand their analytical needs, ensuring data-driven solutions align with objectives. Proficient in writing T-SQL queries to extract essential data, demonstrating expertise in data retrieval. Creating robust SSIS packages to consolidate, validate, and transform data from diverse sources like XML, Excel, and SQL servers, facilitating its seamless integration into a Data Warehouse. Crafting and modifying SSRS/Power BI reports for efficient operational reporting, utilizing SQL Server Reporting Services (SSRS) for various report types.

United States

 Importing the data from data sources and preparing the data in Power Query as per user requirements. Building the relationships between the various Tables in Power Pivot. Created New Columns and new Measures using DAX functions. Created different filters like visual level filters page level filters and report level filters as per reporting needs. Expertise in various visualizations like donut charts, Pie charts and Bar graphs, Tree maps and waterfall charts, and Card Visualizations. Designed diverse types of reports like drill down, drill through, and Sync Slicer. Developed custom report tooltips for different reports to showcase the multiple data points in one report. Created various Customized and interactive Reports and Dashboards in Power BI. Publishing reports to Power BI service and providing access to required users.

Dedicated professional with a proven track record in sales analytics and project management, specializing in the utilization of Power BI. Adept at creating dynamic reports and dashboards to visualize sales data, driving informed decision-making. Excels in collaborating with cross-functional teams, implementing data-driven strategies, and delivering impactful insights for optimizing sales performance. Passionate about continuous improvement and staying at the forefront of Power BI advancements.Responsibilities: Constructed SQL queries, including Common Table Expressions (CTEs), views, and stored procedures, facilitating seamless integration with various applications. Designed and executed SSIS packages, importing data from Excel, XML, OLE DB, and Flat Files. Utilized SQL for data extracts, supporting SSRS, Power BI, and visualizations. Demonstrated proficiency in the end-to-end process of analyzing, designing, developing, deploying, and supporting Power BI dashboards and reports, ensuring alignment with both business and technical requirements. Played a pivotal role in translating complex business requirements into efficient DAX formulas. Managed report publication within workspaces, effectively scheduling refreshes and subscriptions while meticulously controlling user access for optimal data security and dissemination.

 Gathered and documented business requirements, creating user reference guides for clarity. Effective project manager aligning client needs with internal teams, ensuring timely goal achievement. SQL expert: crafted CTEs, views, and stored procedures for seamless application  Skillfully developed SSIS packages to import data from diverse sources, including Excel, XML, and OLE DB Source. Designed and executed data extracts using SQL to support various reporting applications such as SSRS and Power BI. Crafted dynamic Power BI dashboards, reports, charts, and graphs effectively. Analyzed, designed, developed, deployed, and maintained Power BI dashboards effectively. Played a pivotal role in translating business needs into effective DAX formulas.