Ajay S•••

About

On the record

A results driven software professional with 9+ years of experience in Data Architecture role for Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modelling using SQL Server, SSIS, SSRS and SSAS. • 9 years of experience as a Data Architect for various Reporting projects using various technologies. • Expertise in end to end implementation of reporting solutions including data modelling and data visualization using power BI. • Experience in Reporting services, POWER BI (Dashboard reports), SSRS using MS SQL server. • Experience in creating architecture for reporting solution implementation including conceptual, logical and physical models. • Experience in building cubes and dimension with different architecture and data sources for business intelligence in Reporting. • Expert in creating and developing Power BI Solutions to create various Dashboards for reporting that depicts critical elements such as trend analysis, plausibility metrics. • Experience in implementing POWER BI gateway different sources to match analysis criteria and further modelling for Power Pivot and Power view • Experience in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies. • Proficient knowledge of Data Warehousing methodologies and concepts, including Data Vault Modelling, star schemas, snowflakes schemas, ETL processes, dimensional modelling and reporting tools. • Expertise in the designing, coding, testing, supporting, and debugging of the solutions/applications following the SDLC. • Proficient in writing complex T-SQL (DDL, DML), SQL, Physical, logical database design and Performance tuning. • Experience in Unit, Functional, regression and integration testing using Jenkins, github technologies. • Experience in unix and linux.