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…
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 database systems, with successful designing and implementing database solutions that improve business functionality. Excellent at rooting out data errors and assessing its quality with in-depth knowledge of data analysis, cleaning and migration. A good communicator, fast learner and a results-oriented person with the aim of providing useful information that fulfil business needs. Committed to Continuing Professional Development (CPD), willingness to acquire more knowledge and experience by undertaking relevant training to keep up to date with the latest developments in technology. Now seeking the right opportunity where I can use my skills, experiences and develop.
Experience
Data Engineer/ Power BI Developer
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.