Rishav Tripathi

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.

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

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.