Rishi Kaul Email and Phone Number
•Having 6 years of experience working in Microsoft BI tools and designed and developed Power BI reports and dashboards from multiple data sources using data blending.•Proficient in Microsoft BI Tools (SSIS/SSRS/SSAS) and T-SQL using SQL Server 2005/2008R2/2012/2014/2016.•Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.•Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.•Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.•Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.•Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.•Strong written and communication skills.
-
Service Manager | Operations SpecialistAllied UniversalGurugram, Hr, In -
Sr Power Bi / Sql DeveloperBioware Oct 2023 - Present• 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. -
Power Bi DeveloperProcor Limited Aug 2022 - Oct 2023Toronto, 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 -
Sql/ Power Bi DeveloperBlue Horizon Infotech Jul 2019 - Jun 2021Kerala, 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 -
Sql DeveloperRbl Bank Apr 2017 - Jul 2019Pune, 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
Rishi Kaul Education Details
-
Pg Diploma -
Bachelor Of Engineering - Be
Frequently Asked Questions about Rishi Kaul
What company does Rishi Kaul work for?
Rishi Kaul works for Allied Universal
What is Rishi Kaul's role at the current company?
Rishi Kaul's current role is Service Manager | Operations Specialist.
What schools did Rishi Kaul attend?
Rishi Kaul attended Lambton College, Graphic Era Deemed To Be University.
Who are Rishi Kaul's colleagues?
Rishi Kaul's colleagues are Amanda Young, Thomas Lyons, Deyvid Canuto, Hanaa Gual, Edgar Figueroa, Reginald Norris, Samantha Cobb.
Not the Rishi Kaul you were looking for?
-
Rishi Kaul
Dubai, United Arab Emirates1ericsson.com3 +911244XXXXXX
-
Rishi Kaul
Engineering Graduate | Exploring Full Stack Development & Data-Driven Decision-MakingJammu -
Rishi Kaul
Danville, Ca2me.com, norcaloffice.com -
Rishi Kaul
Associate Engineer @ Deutsche Bank | Full Stack Engineer | Cs Spit’22 | Sih ‘22 WinnerMumbai1db.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial