Search for a freelancer Post a project
Malt welcom

Welcome to Rishav's freelance profile!

Malt gives you access to the best freelancers for your projects. Contact Rishav to discuss your project or search for other freelancer profiles on Malt.

Rishav Tripathi

Consultant Microsoft BI

Can work in or around Paris

  • 48.858705
  • 2.342865
Propose a project The project will begin once you accept Rishav's quote.
Propose a project The project will begin once you accept Rishav's quote.

Location and workplace preferences

Location
Paris, France
Can work onsite in your office in
  • around Paris and 50km

Preferences

Project length
≥ 6 months
Business sector
  • Automobile
  • Banking & Insurance
  • Retail (Small Business)
  • Defense & Military
  • E-commerce
+15 autres

Verifications

Freelancer code of conduct signed
Read the Malt code of conduct

Verified email

Languages

Categories

Skills (9)

Rishav in a few words

Consultant Microsoft BI ayant 11 ans d'expérience dans le domaine de Microsoft Azure, SSIS, Data Factory, Power BI et SQL Server 2008/2014/2019

Expertise dans le développement de packages SSIS pour extraire, transformer et charger (ETL) des données dans l'entrepôt de données à partir de bases de données hétérogènes telles qu'Oracle, Teradata, Sybase et MS Access.

Expertise dans la conception de rapports complexes à l'aide de paramètres en cascade, de rapports d'exploration, de rapports paramétrés, de sous-rapports et de rapports ad hoc à l'aide de SQL Server Reporting Services (SSRS) et de Power BI.

Expertise dans l'utilisation d'outils tels que MS SQL Profiler, le plan d'exécution de requêtes, les performances Windows pour la surveillance et le réglage des performances de SQL Server.

Expérience approfondie du cycle de vie du développement, dès l'analyse des exigences, la conception du système, le codage, les tests, le débogage, les correctifs de performances et la mise en œuvre dans un environnement Agile.

Le rôle dans les projets impliquait essentiellement la prestation de services, la gestion et l'optimisation de projets, l'analyse de données, l'assurance qualité, la gestion de la relation client, l'analyse des causes profondes et le développement des personnes.

Experience

Edenred - Edenred

Retail (Large Retailers)

Microsoft Azure BI Analyst

Paris, France

July 2019 - June 2022 (2 years and 11 months)

Translating business requirements to technical solutions using Microsoft Azure cloud data technologies. Exposing data to end-users using Azure API Apps and other modern visualization platform (Power BI). Delivery of architectures for transformation and modernization of enterprise data solutions . Involved in the planning and implementation of data design services, providing sizing and configuration assistance and performing optimization assessments. Developing and maintaining data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics. Implementing data warehouse architectures using Microsoft SSIS and deploying it in Azure Catalogue and then scheduling the Catalogues in different environments using Azure Data Factory. Conducting data profiling, cataloging, and mapping for technical design and construction of technical data flows. Experience with Git/TFS/Azure DevOps/VSTS. Working and collaborating with remote teams.

AXA Global Direct

Banking & Insurance

MSBI Project Lead

Paris, France

October 2016 - July 2019 (2 years and 9 months)

Responsible for business process analysis and creation of software-designs for a functional domain within the client own platform. Communicate effectively on KPIs evolution within the company (with the help of Dashboard) Responsible for the development, maintenance and support of the database (Development, Integration, Pre-Production and Production) for France and Spain. Monitoring Activities: Monitoring system checks and jobs failures. Administration and Supervision. Package (JOBS) scheduling using TWS (IBM Tivoli Workload Scheduler). Resolution of potential incidents. Support Activities: Manage tickets and services requests (disk space problem, table analysis, file groups, file size, file space usage and file free space in different disks, synchronization of databases and packages in all four environments). Deploy datafix. Work with the team of Change management (France) and the development team (Spain). Actively involved in creating and monitoring Issue Tracker. Business Intelligence Activities : Creation of reports using Power BI. Support BI activity and automation of incidents by writing SQL scripts. Implementation of Data Warehousing for a huge database of 4TB using Microsoft Best Practices. Development of SSIS Packages. Deployment of the Project using Catalogs and validation of packages in all four environments: Design, Integration, Pre-Production and Production. Validating and Running SVN scripts in all four environments. Optimization of SQL codes and SSIS packages for improving the performance. Manage and analyze SQL Server traces during performance tests (CPU and Memory usage).

Enedis (ex ERDF) - Enedis

Energy & Utilities

MSBI Project Lead

Paris, France

April 2016 - September 2016 (5 months)

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytics, reports and scorecards / dashboards on SQL Server 2016 using SSIS, SSAS, SSRS. Actively involved in creating OLAP cubes and using MDX queries to retrieve data from the cubes. Created cubes having multiple fact tables and dimension tables and created calculated columns using named query and named calculation property of SSAS. Generating custom and parameterized reports / dashboards using SSRS. Created different kind of reports like cascading prompts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports, Matrix/Tabular Reports, Charts and Graphs in SSRS. Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts. Perform Query optimization & Performance Tuning using SQL Profiler and Database engine tuning advisor. Assistance in the design of star schema and snowflake schema. Create Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views and Stored Procedures. Taking part in the normalization and de-normalization of database. Creating packages in SSIS. Scheduling the packages to keep extracting the data from OLTP at specific time intervals. Using various transformation tasks to create ETL packages for data conversion. Implementing the AGILE Method of Development.

Actimage

MS BI Developer

August 2015 - February 2016 (6 months)

External recommendations

Check out Rishav's recommendations

Education

Certifications