Summary
Overview
Work History
Education
Skills
PROJECTS
Timeline
BusinessAnalyst
Yatindra Vinayak Raijada

Yatindra Vinayak Raijada

Summary

Technical Architect with 13 years of experience in the field of Visualization, Database Design, Development and Team Handling. Exposure of Health Care, Finance, Food industry and Manufacturing domain projects. Core competencies include SQL, MSBI stack (Power BI, SSRS and SSIS), Azure Tools (Azure SQL Server, Data Factory, Logic Apps) SQL Server Performance Tuning & Query Optimization

Overview

13
13
years of professional experience

Work History

Technical Architect

Tavant Technologies Inc
04.2024 - Current
  • Collaborated with clients to determine project specifications and scope.
  • Designed an ETL Architecure to transform Tableau Prep Flows into highly optimized Power BI Dataflows and Semantic models.
  • Led a project to migrate paginated reports from Tableau and Cognos to Power BI Report Builder.
  • Independently designed and delivered a comprehensive Sales Dashboard on the Tableau platform.
  • Performed quality code review and removed technical debt and security vulnerabilities.

Technical Lead

CAI Info India Pvt. Ltd
05.2023 - 03.2024
  • Leading migration project of analytics from Oracle analytics to Power BI reports
  • Write complex business logics using T-SQL
  • Data Modelling by joining different tables and creating calculated columns
  • Setup new working process as per business needs
  • Alignment between teams & stakeholders
  • Responsible for successful delivery of sprint

Technical Lead – Power BI

Ensemble Health Partners
03.2022 - 04.2023
  • Team handling of 16 developers
  • Design complex Health Care Analytic Reports using Power BI
  • Automated refresh schedule of PBI reports by Logic Apps and script
  • Prepared next line leaders
  • Promote PBI reports on Production through Deployment Pipelines
  • Job planning and execution using Azure DevOps

BI Consultant

INECTA Pvt. Ltd
10.2020 - 02.2022
  • Design solutions that align firm's data management principles, policies, standards, and bestpractices
  • Design complex Financial Analytic Reports using Power BI
  • Consume Web APIs of Business Central Dynamics and perform ETL using Azure Data Factory
  • Creation of Azure SQL Server Machines and Databases
  • Job planning and execution using Azure DevOps

Sr. Software Engineer

InTimeTec Visionsoft Pvt. Ltd
04.2018 - 10.2020
  • Key player of the team and have worked as an offshore coordinator
  • Power BI Report generation using SQL Data source, excel, ODATA, web URL etc
  • Writing Complex DAX functions in Power BI
  • SSRS report development, migration from BRIO/DB2/Cognos environment
  • Data warehouse and ETL using SSIS packages for data migration
  • Generate reports for AG group and server metadata using SSIS andprocedures
  • Job planning and execution using JIRA.

Database Developer

National Informatics Center
01.2012 - 04.2018

- Database Developer | Velocis Systems Pvt. Ltd | April 2017 - April 2018

- Software Developer | CMS IT Services Pvt. Ltd | December 2014 - March 2017

- Programmer | IAP InfoTech | June 2012 - December 2014

- Assistant Programmer | CyberQ Consulting Pvt. Ltd | January 2012 June 2012

  • Development on Govt Project for a single client (NIC) with various vendors
  • Database design, development in MS SQL Server
  • SSIS packages development for data migration
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance
  • Write business logic though stored procedure, triggers, functions, views, and other database objects
  • Extensively used T-SQL in constructing User Defined Functions, Indexes, Cursors, Joins
  • Create Parameterized, Cross, Drill Down and Summary SSRS reports
  • Work on Three-Tier architecture based on C#/ASP.Net application
  • Crystal report development

Education

Master of Computer -

Maharishi Arvind Institute of Science andTechnology
2011

Skills

  • Data Modelling, Analytics and Reporting - Power BI, SSRS, Tableau
  • RDBMS - MS SQL Server, Oracle
  • ETL - Azure Data Factory, SSIS
  • Team Handling,Troubleshooting & Debugging
  • Job planning and Execution using Azure DevOps and Jira
  • Version Controlling through GIT and TFS

PROJECTS

  • Oracle Analytics migration to Power BI - Manufacturing
  • Acute & PRC Reports generation - PharmaTech
  • Multi-Client Power BI Reports - Food Industry
  • DMM – Data Migration Management (SSIS) - Manufaturing
  • PayManager – Payroll System - Finance
  • HMS – Health Management System - HealthCare

Timeline

Technical Architect

Tavant Technologies Inc
04.2024 - Current

Technical Lead

CAI Info India Pvt. Ltd
05.2023 - 03.2024

Technical Lead – Power BI

Ensemble Health Partners
03.2022 - 04.2023

BI Consultant

INECTA Pvt. Ltd
10.2020 - 02.2022

Sr. Software Engineer

InTimeTec Visionsoft Pvt. Ltd
04.2018 - 10.2020

Database Developer

National Informatics Center
01.2012 - 04.2018

Master of Computer -

Maharishi Arvind Institute of Science andTechnology
Yatindra Vinayak Raijada