Sam Ayefele

Sam Ayefele

Data Analyst /Power BI Developer
United Kingdom
English

About Me

A competent and experienced IT professional with Database administration skills across MS SQL server 2008 R2, 2012, 2014, Azure Cloud, Power BI and Oracle Database 18c. Experienced at development and upgrading of databas…

Experience

Data Engineer/ Power BI Developer

SETTLE GLOBAL INTERNATIONAL LIMITED
Oct 2019 - Present · 6 years 8 months

Data Engineer/Power BI Developer; Designing, administering, installing and upgrading
the SQL Server, database software and creating insight report on Power BI.

• Maintaining existing SQL Server database, creating tables, store procedures, views, functions and indexes to enable quick access to data for reporting and other business needs.
• Scheduling Job on ERP/CRM system (Infor Lawson M3) to update price of products, creating new customers whilst managing requests from different department.
• Working on over 2,000 tables on SQL Server Database and creating more tables that suit business needs and requirements.
• Extracting and cleaning data from different data sources for report design in POWER BI and Infor BIRST.
• Performing Real-Time analytics and reporting in INFOR M3 integrated with BIRST to generate visualized report used in quick and informed business decision to monitor changes in operations.
• Responsible for implementing SQL Server Reporting Services (SSRS) through data warehouse and against SQL Server Analysis Services (SSAS).
• Auditing SSRS solution and making decision on reports selection whilst documenting SQL reports and SSIS tasks.
• Developing and upgrading of in-house database using ER/Studio Architect.
• Creating and executing SSIS packages to extract, transform and load data on to data warehouse.
• Working as part of a development team reviewing codes especially in C#, ASP.NET and JavaScript.

Skills

Azure JavaScript Microsoft Azure MSSQL PL/SQL Power BI Scrum and Waterfall RAD JAD • DSDM • Agile/Iterative software development JIRA Ms Project Ms Visio Web Email server TCP/IP Cognos Infor Lawson M3 Power BI T-SQL Python PowerShell XHTML PHP Java CSS ASP.NET Client Server Ms Access (Ms Office). Ms Excel Ms Word ER/Studio Data Architect 17.1 Microsoft SharePoint C# database data
Report this Profile?