Summary
Overview
Work History
Education
Skills
Timeline
Generic

Yagna Sree Inturi

BI Developer

Summary

Welcome to my Portfolio! This is Yagna Sree Inturi. I am a dedicated BI Developer with a strong proficiency in SQL Server, SSIS, SSRS, SSAS, and data visualization tools such as Power BI and Tableau. I specialize in designing and developing comprehensive business intelligence solutions that drive informed decision-making and enhance operational efficiency.

I am committed to staying at the forefront of business intelligence, continually enhancing my skills in data warehousing, ETL processes, and advanced analytics. My expertise in managing large datasets and creating dynamic reports and dashboards ensures high data quality and insightful visualizations. With experience in cloud platforms like AWS and Azure, I deliver scalable and robust BI solutions.

As a proactive team player, I excel in collaborative environments and am adept at translating complex data insights into actionable business strategies. I am driven by a passion for using data to uncover trends, optimize processes, and contribute to business innovation and success.

Overview

5
5
years of professional experience
2
2
years of post-secondary education

Work History

BI Developer

Tungsten Automation
04.2023 - Current
  • Participated in the entire SDLC, focusing on requirements gathering, analysis, design, development, and testing
  • Expertly crafted complex queries, stored procedures, temporary tables, functions, CTEs, joins, and sub-queries
  • Utilized Python libraries such as Pandas, NumPy, Seaborn, SciPy, Matplotlib, and Scikit-learn for data analysis
  • Managed parameters, variables, error handling, and expressions within SQL Server and SSIS
  • Developed essential database objects including tables, views, functions, and indexes
  • Engineered T-SQL queries, stored procedures, and views to efficiently store and manage data using SQL
  • Server Management Studio
  • Implemented user-defined functions and triggers to enhance data handling and query performance
  • Developed OLAP cubes, facts, and dimensions for comprehensive data summarization
  • Implemented cube partitioning and incremental synchronization for tabular, OLAP, and SSAS cubes
  • Maintained detailed documentation for SSRS reports and corresponding data models
  • Utilized SQL Server 2016 and Visual Studio 2013 to build dynamic SSIS packages for importing data from multiple sources
  • Employed SSIS packages for ETL operations, ensuring effective data transformation and loading into data warehouses
  • Created ETL workflows in Azure Data Factory to facilitate data integration into Azure SQL Database and
  • Azure Data Lake Storage
  • Optimized Azure Analysis Services models through partitioning and aggregation techniques
  • Delivered interactive Power BI dashboards and reports to convey data insights to stakeholders
  • Applied data transformations and measures in Power BI to provide actionable information
  • Ensured HIPAA compliance and data security for sensitive healthcare data.

SQL Server Developer

High Radius Technology
01.2021 - 07.2022
  • Collaborated with stakeholders to gather and analyze business requirements, implementing effective solutions
  • Developed SSIS packages to integrate data from diverse sources into SQL Server databases
  • Connected Tableau to SQL on Azure for generating real-time operational reports
  • Managed package configurations, logging, scheduling, error handling, and variables in SSIS
  • Developed and maintained SSIS packages for comprehensive ETL processes
  • Created complex queries, stored procedures, triggers, functions, views, and indexes for various applications
  • Generated reports using SSRS based on user requirements and specifications
  • Designed and implemented ETL pipelines using Azure Data Factory and SSIS
  • Developed OLAP cubes and conducted data analysis using Azure Analysis Services
  • Executed and managed stored procedures, resolving issues with SQL Server Management Studio
  • Created parameterized and ad-hoc reports using SSRS
  • Enhanced database performance through regular index rebuilding and query tuning.

SQL Server Developer

Magna Infotech
05.2019 - 12.2020
  • Developed T-SQL programs for stored procedures and functions
  • Conducted daily backup and restore operations using SQL Server tools
  • Engaged in database normalization and de-normalization processes
  • Created complex stored procedures and triggers using SQL Server 2005
  • Implemented ETL processes using SSIS for data transformation and transfer
  • Automated workflows with Python scripts and Unix shell scripting
  • Generated diverse reports using SSRS
  • Implemented data storage optimization using Azure SQL Database
  • Performed ETL from transactional databases to data warehouses
  • Developed cubes and implemented calculations using SSAS
  • Created complex SQL queries involving multiple tables from different databases.

Education

Master of Applied Science - Computer Science

University of Cincinnati
Cincinnati, OH
08.2022 - 04.2024

Skills

  • TECHNICAL SKILLS
  • Programming Languages:
  • T-SQL, PL/SQL, VB, C, C#, Java, Python
  • Operating Systems: MS Windows, MS-DOS, Unix, Linux
  • Databases: SQL Server, NoSQL, Oracle, MS Access, PostgreSQL, Teradata Database, MS SQL Server 2000
  • Data Processing Tools: OLAP, OLTP
  • Business Intelligence: SSMS, SSIS, SSRS, SSAS, SQL Server BI Development Studio (BIDS), MS Visual
  • Studio, PowerBI, Tableau
  • Methodology: Agile, Scrum, Waterfall

Timeline

BI Developer

Tungsten Automation
04.2023 - Current

Master of Applied Science - Computer Science

University of Cincinnati
08.2022 - 04.2024

SQL Server Developer

High Radius Technology
01.2021 - 07.2022

SQL Server Developer

Magna Infotech
05.2019 - 12.2020

Similar Profiles

CREATE PROFILE
Yagna Sree InturiBI Developer