Jayayaprasad Chintamani

Over 8+ years of experience in developing BI applications utilizing SQL server, BI stack (T-SQL, SSIS, SSRS, Power BI, PowerApps, SSAS, Azure and Tableau) within a number of domains like Banking, Telecommunication, Airline, Automobile, Biotechnology, Retail, Energy sector, Marketing sector, Media and Construction. Involved in Business Analysis of the OLTP and OLAP data and in decision support. Extensive database programming.

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. Created different Power BI reports utilizing the desktop and the online service schedule refresh.

Created different visualization in the reports using custom visuals like Bar Charts, Pie charts, Line Charts, Cards, Slicers, etc Strong Knowledge of Data Warehousing methodologies and including star schemas, snowflake concepts. Worked with Agile methodology for application development. Developing and enhancing MI reports in order to support decision making.

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. 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.

Maintaining the Log and Audit information in SQL tables, experienced in providing Logging, Error Handling by using Event handler for SSIS Packages. Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).

Excellent

Knowledge in analysing Data warehouse by building cubes using 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.

Senior BI Developer - Warner Bros. Discovery

(2022-10 - 2026-09)

• Designed, developed and maintained SQL Server database solutions using T-SQL, stored procedures, views, functions, indexes and complex queries, supporting enterprise reporting and business-critical data requirements.
• Analysed and optimised SQL queries, stored procedures and database objects to improve query performance, data retrieval times and overall reporting efficiency.
• Designed and maintained relational and dimensional data models, including fact and dimension structures, to support scalable reporting and analytics solutions.
• Developed and maintained SSIS ETL pipelines to extract, transform, validate and load data from multiple sources including APTOS, Dynamics 365 F&O, ServiceNow, Excel and Snowflake.
• Implemented data validation and reconciliation checks, including record counts, duplicates, missing values and source-to-target validation, to improve data quality and integrity.
• Investigated and resolved database, ETL and reporting issues in production, performing root-cause analysis and implementing corrective solutions to minimise business impact.
• Developed and maintained SSRS and Power BI reporting solutions, including semantic models, DAX measures and reusable datasets supporting operational and management reporting.
• Applied data warehousing and Kimball dimensional modelling principles to create maintainable and scalable reporting structures.
• Supported database and reporting changes through development, testing and production deployment, using Azure DevOps/Git for version control, pull requests and controlled release processes.
• Worked with stakeholders, data engineering and development teams to analyse business requirements, translate them into database solutions and improve the performance and maintainability of the data platform.
• Supported the modernisation of the data platform by working with Snowflake and Databricks alongside the existing SQL Server and SSIS/SSRS environment.
• Developed reusable and maintainable data transformation logic, including dbt models and testing practices, to improve consistency and reliability of analytical data.

PowerBI/ BI Developer - SYSTRA

(2022-04 - 2022-06)

• Developed basic to complex SQL queries to research, analyze, troubleshoot data and to create business reports
• Experience running complex and high volume ETL processes
• Created, modified and tuned SQL stored procedures, functions and triggers
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Analyzing raw data, drawing conclusions & developing recommendations.
• Responsible for loading, extracting and validation of client data.
• Participated in Project Engagement meetings
• Developed canvas App.
• Developed complex stored procedures to create various reports.
• Prepared data models and setup data source.
• Developed Power Automate flow which will notify users about events.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in PowerBI.
• Developed Power BI visualizations and dashboards using Power BI Desktop.
• Developed reports using power BI and SSRS.
• Writing complex DAX functions in Power BI.

PowerBI/ BI Developer - LSEG (London Stock Exchange)

(2021-12 - 2022-04)

• Develop SQL scripts, indexes, and complex queries.
• Perform quality assurance and testing of SQL server environment.
• Perform normalization of database.
• Identify business requirements and provide solution options.
• Ensure data integrity is maintained through security and change management.
• Coordinate between project management and development teams.
• Solving the request raised by user support.
• Production support for the database and application issues.
• Supported production and development databases.
• Developed data standards, data exchange, XML data standard or data sharing model.
• Worked on XML Web Services Control Flow task to read from XML Source.
• Used XML and environmental variables in package configuration for deploying SSIS packages.
• Prepared data models and setup data source.
• Developed canvas App.
• Developed Power Automate flow which will notify users about events
• Developed MI metrics dashboards using Power BI.
• Developed Power BI visualizations and dashboards using Power BI Desktop.
• Developed reports using power BI and SSRS.
• Writing complex DAX functions in Power BI.

PowerBI/ BI Developer - HSBC UK

(2021-07 - 2021-11)

• Develop SQL scripts, indexes, and complex queries.
• Perform quality assurance and testing of SQL server environment.
• Perform normalization of database.
• Identify business requirements and provide solution options.
• Ensure data integrity is maintained through security and change management.
• Gathered and analyzed data from various sources like UCMDB, ServiceNow and Excel. Developed and optimized reports and dashboards using the Power BI platform.
• Solving the request raised by user support.
• Production support for the database and application issues.
• Sup