PLEASE REACH OUT ME BEFORE ORDERING !
Business Intelligence (BI)
- SSIS- Developing, implementing and maintaining ETL solutions to bring new data into the data warehouse
- SSAS- Designing, developing, processing and browsing multi-dimensional data models/cubes that enable analytic driven reporting
- SSRS- Designing, building and deploying BI reports and dashboards using various suitable reporting tools
Data Warehousing
- Designing & implementing effective DW architectures using Kimball approach with the right schemas, ERD, SCD, data modeling & data integrity that meet analytics/reporting objectives.
Data Mining
- Design and develop various Data Mining solutions
- Designing, developing data mining models and applying suitable algorithms for predictive analytics that meet end/client needs.
Data Analysis
- Extensively cleaning, transforming, data modelling & building analytic dashboards using MS Excel and Power BI
Database Programming & Development
- Manage and maintenance database through the design and development of T-SQL queries & solutions
- Database performance tuning and query optimization
- Writing stored procedures, user defined functions, views, T-SQL scripting for complex business logics