Shahul H.

Data Analyst - SQL Expertise with 10 plus years of experience

I'm a Data Engineer with more that 15 years of hands on experience in Data Warehousing, Business Intelligence , Data Analysis & Visualization, and Process Automation in various business domains. I have clarity and excellent communication skills required to execute / deliver projects on time and within budget. I’m here to support startups, small and large companies, and organizations to grow by getting the most of their data. I’ll help you grow and improve your decision-making by creating tools, dashboards, and environments that guarantee to obtain valuable information and trends from data with a user-friendly and adaptive interface. I can help your organization in the following areas: + Data Modelling, Data Warehouse (ETL, Data Visualization) + Power BI, SSRS + SQL + Microsoft Excel + Data Vault modelling + VB.NET support Projects : a. End point Security Compliance In this project, extracted data from various sources such as Active Directory, Linked Servers, csv files and excel files from shared location. Ran SQL jobs to import data into an SQL database. Created procedures to cleanse data and give them meaning to understand. Views for users to generate reports as per business requirements. SSRS parameterized reports on portal and automated tabular reports for stakeholders. Weekly/Fortnight/Monthly reports to calculate compliance based on security software such as Antivirus, Backup and Encryption. Before leaving Capgemini, converted few SSRS reports to Power BI dashboards to enrich data visualization. b. Hardware/Software Asset Management. Here, I had an experience using Eracent Discovery tool which discovers data from devices using collectors placed at various Data centers. There are several jobs running behind the scenes to import data into Eracent Data warehouse. My role is to connect with various stakeholders and understand their business ideas and help them take decisions based on SSRS / Power BI dashboards. Reporting devices connecting to company's network on a weekly/monthly basis. Improvement with figures of new devices and devices not connecting to network due to issue in jobs collecting data from collector. Monitoring SQL jobs on a regular basis to ensure data extraction from various Eracent collectors. You may google about Eracent Tool which is similar to SNOW tool for asset discovery of large MNCs. Currently working as a Data Architect to convert 3NF Data models to Data Vault models as per business requirements Have done Prince 2 Foundation and Agile Certification for Project Management. I have gained knowledge of handling a project from scratch to end. Would be happy to serve as a freelancer for any BI related projects. Shahul