jayaprasad chintamani , Milton Keynes, United Kingdom

• Over 7+ years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau. • Involved in Business Analysis of the OLTP and OLAP data and in decision support. Extensive database programming. • Experienced in Building SSAS Cubes and Dimensions with different Architectures and Data Sources for Business intelligence and writing MDX scripts. • Experience in writing T-SQL Stored procedures, Triggers, Constraints and Indexes using various DDL and DML commands. • Developed T-SQL scripts for performing automation tasks, Performed and fine-tuned stored Procedures and SQL Queries and user Defined Functions. • Strong Knowledge of Data Warehousing methodologies and including star schemas, snowflake concepts. • Worked with Agile methodology for application development. • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. • Proficient in Creating, Configuring workflows designed in MS SQL server Integration Services (SSIS). • Experience in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services. • Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources and integrates data based on business logic and to load it in data warehouse. • Designed ETL using SSIS Packages to reprocess any date data at any time using Reprocess Logic. • Developing C# scripts in SSIS and automating tasks using C#. • Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error Handling by using Event handler for SSIS Packages. • Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL server Analysis Services (SSAS) • Utilized Power BI to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicer and dicers enabling end-user to make filters. • Experienced in designing and developing SSRS reports using data from ETL loads, SSAS Cubes and various heterogeneous data sources. • Have knowledge of AWS, Big Data Technologies like Hadoop. • Excellent analytical, communication and interpersonal skills. • Proficient in technical writing and presentations and good team player. • Strong investigative and troubleshooting skills.