Rishi Kaul Email & Phone Number

Gurugram, Hr, In

• Extensively involved in Development, Implementation and Reporting in MS SQL Server 2016/ 2014/2012/2008 R2/2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). • Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor. • Involved in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL. • Responsible for creating reports such as Cascading, Drill down/Drill through Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.• Worked extensively on Data visualization and Data analyzation using Power BI.• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.• Responsible for identifying, designing and implementing processes related to predictive / analytical modeling, data mining and complex data sets using statistical and text mining using python scripts.

Toronto, Ontario, Canada

•Responsible for gathering/refining requirements from the customer for developing reports in Power BI.•Built Data Analytics or visualization using Power BI (Power View integrated with Share Point.•Created Grouping, sorting columns and writing expressions according to the business requirements.•Created Grouping, sorting columns and writing expressions according to the business requirements.•Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.•Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.•Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS

Kerala, India

•Design and developing the POC’ S according to business users•Developing the best practices and drive the code to across development, test and Pre-Prod and Production environments.•Developing the best practices and drive the code to across development, test and Pre-Prod and Production environments.•Designed and developed the migration of Data Analytics to Power BI.•Experience in developing the Calculated columns and Measure in the Data Analysis Expressions (DAX).•Design and develop the RLS (Row -Level-Security).•Extensively involved in deploying SSIS Packages, SSRS Reports and SSAS Cubes using command line utilities

Pune, India

•Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).•Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.•Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Used Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all in transformation of SSIS Packages.•Created and modified various Stored Procedures used in the application using T-SQL.•Designed Cubes with star schema and snowflake schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.•Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.•Worked in Creating Calculations using MDX and Supported DAX expressions which were using Pivot table reports

Pg Diploma

Bachelor Of Engineering - Be