Power Bi User Experience

Vyshnavi Sravanya M

********.********@*****.*** +1-919-***-****

linkedin.com/in/vyshnavi-madabushi

Professional Summary

●Proficient in Database Design, Programming, Development and Implementation of Client-Server applications and Database systems using MSSQL 2018/2016/2005/2000.

●Experience in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.

●Extensive knowledge of Normalization and Relational Database Management Systems.

●Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and handling dynamic queries and Transact SQL.

●Experienced in creating/maintaining SSIS Packages to extract, transform and loading data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks, and transformations.

●Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.

●Developed and optimized interactive Power BI reports and dashboards, integrating data from multiple sources (SQL, Excel) and utilizing DAX for advanced calculations and KPIs.

●Published and shared reports via Power BI Service, managing user access, scheduling data refreshes, and ensuring performance optimization through query folding and efficient data models.

●Designed and optimized complex SQL queries to extract, manipulate, and aggregate data for real-time reporting within web applications, ensuring accuracy and performance.

●Collaborated with development teams to integrate query results into dynamic dashboards and web interfaces, improving data accessibility and user experience.

●Wrote and optimized SQL scripts for test automation, enabling efficient data validation and verification during the software testing process

●Developed and maintained dynamic web applications using C#, ASP.NET, and JavaScript 2.0, ensuring seamless functionality, performance, and user experience across platforms.

●Performed database restore and backup operations, ensuring data integrity and security, while managing user permissions to control access and maintain compliance.

●Collaborated with cross-functional teams (development, QA, business analysts) to gather requirements, troubleshoot issues, and deliver cohesive solutions, ensuring alignment with business goals and project timelines.

●Proficient in source code management with version control systems like VSS, SVN, ClearCase, and GIT, ensuring seamless collaboration and code integrity across development teams.

●Created detailed functional and technical documentation, including system specifications, user guides, and process workflows, to ensure clear communication and smooth knowledge transfer across teams.

●Strong problem-solving abilities and attention to detail, with a track record of delivering high-quality, scalable, and cost-effective solutions within strict timelines.

●Utilized Splunk and Dynatrace to monitor, analyze, and debug application performance issues, identifying root causes and implementing solutions to improve system reliability and performance.

Technical Skills

Microsoft SQL : Microsoft SQL Server 2018 with Azure, Sql Server 2016, SQL server 2012, SQL server 2005.

Reporting : Power BI

Integration Services : SSIS

UI : C#, Asp.net, Ado.net, JavaScript 2.0.

Tools : GIT, VSS, SSIS, VSTS, JIRA, Splunk, Dynatrace

Professional Experience

Digital Management, LLC DMI Nov 2022 to Present

SQL Developer

Responsibilities:

●Creating and modifying stored procedures, views, triggers, functions, as well as various DML

and DDL statements using Microsoft Server management Studio 2018 with Always On feature.

●Using SQL Profiler, Dynatrace, and Splunk to examine log files to resolve various issues.

●Working with Integration services to import various type of data into the server.

●Performance tuning the procedures, functions by looking at the SQL Server execution plan.

●Creating/Monitoring the Automating processes by creating jobs for data refresh, integrity

●checks in different environments.

●Creating reports for Ad hoc requests from end users for the data analysis.

●Debug issues using SQL Profiler, Splunk Errors or using Dynatrace logs.

Technologies Used:

●Azure databases, SQL Server 2018, SSIS 2017, JIRA, GitHub, Dynatrace, Splunk, SQL Agent Jobs, Linked servers, Transactions, Tableau reporting

Alchemus JUN 2020 – OCT 2022

Senior SQL Developer

Responsibilities:

●Collaborate with business stakeholders to gather, analyze, and document functional and technical

●requirements for projects and enhancements .

●Conduct gap analysis to identify areas of improvement in existing processes and systems.

●Translate business needs into detailed functional specifications for technical teams

●Design the database flow/process for the new modules, Enhancements in the product.

●Create the procedures, Functions, triggers, Views to the Front-end team. Generate various

●reports to analyze the data for the project dash boards.

●Performance Tune the queries for the faster page loads, create indexes.

●Analyze the large datasets using SQL, identifying key trends and patterns to improve the

Dashboard pages.

●Developed and presented Data visualization using Power BI

●Creating technical documentation, functional documentation, SOP for the future reference.

●Create supporting SQL agent jobs to support the features that run monthly and yearly.

●Experience taking Backup, restore, transaction log backups for setting up the environment for

new clients.

Technologies Used: SQL Server 2012, SSIS 2017, JIRA, GitHub, Power BI, SQL Agent Jobs, Linked

servers, Transactions, C#, Agile Model

Infosys - Microsoft Jun 2015 – Mar 2018

Senior SQL Developer

●Responsible and involved in implementation of Always on Feature in the project.

●Writing the SQL Agent Jobs to support the Always on Feature.

●Analyzing the requirement specification, communicating with project managers regarding

scheduled deliverables, progress, and open issues.

●Created SQL Jobs, stored procedures and functions, tables, and views to include complex

business logic.

●SQL Jobs to import data from external systems and send it to downstream systems.

●Participated in Daily stand-up call in a Scrum Environment and discussing about things

completed so far in the present sprint.

●Maintained the projects status and details on JIRA with hard dates and worked on

troubleshooting the issues

Technologies Used: SQL Server 2016 With Always ON (IAAS), Microsoft Teams foundation

server, GitHub, Splunk SQL Agent Jobs, Transactions, MSRA Excel Reporting tool, Excel VSTO

using C#,, Agile Model

Infosys - Microsoft Jul 2012 - May 2013

Technology Analyst

●Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server

and Flat files.

●Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and

Fuzzy Lookups etc.

●Created SSIS packages for Data Conversion using data conversion transformation.

●Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors,

Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and

also created clustered and non-clustered indexes.

●Experience working in developing parameterized, drill down, drill through, chart, matrix, ad hoc report

●Designed packages to extract data from SQL DB, flat files and loaded into SQL database

●Involved in all the stages of SDLC and working solely in the project and directly reporting to the client for all the deliverables.

●Responsible for DB design and data upload from spread sheet to the new system. Working

extensively on SQL queries.

Technologies Used: SQL Server2012, Microsoft Teams foundation server, VSTS, SSIS

Infosys - Microsoft Jun 2011 - Feb 2012

Senior SQL Developer

●Review and Understand the Business Requirements Document [BRD] to help with base lining

●the scope.

●Participate in resource planning and allocation.

●Performing Business analysis and documentation, project planning and its execution time lines,

●Status reporting, tracking and reviewing deliverables, risk management their communication

●to Client.

●Maintenance and Production Support work from Onsite

●Doing Requirement Analysis and functional specification document and communicating with

●the offshore.

●Review of the technical specification document, code, and System Test cases

●Developments of UI Automation tool for excel projects using Coded UI framework.

●Learned excel VSTO and fixed related bugs.

Technologies Used: SQL Server2008, Microsoft Teams foundation server, VSTS, Excel VSTO

using C#, Visio, Coded UI Framework.

Infosys - Microsoft Jun 2009 - May 2011

Senior Software Engineer

●Responsible for creating .bat and .cmd files and SQL jobs that pull data from remote servers

with some very complex internal logics associated to it.

●Quickly Learnt VBA and developed new Excel templates for different feed partners to Budget

their revenues and the data flowing to reporting server using complex SQL Server jobs.

●Technical and Functional Specification documentation.

●Production and Maintenance Support

●Single resource for development of Excel based reporting tool and delivering it on time.

●Worked on creating replications using SQL Server.

Technologies Used: SQL Server2008, Microsoft Teams foundation server, VSTS, Excel VBA

Visio, Coded UI Framework.

Infosys - Microsoft Nov 2007 - Jun 2009

Software Engineer

●Involved in development of a New Web screens and their features using JavaScript, Asp.net

●2.0, HMTL

●Written complex Automation SQL jobs for Data validation between two different sources.

●Responsible for Writing Functional and Technical Specifications Documentation.

●Have later extended help to the Testing team balancing both Test and Development activities without any hiccups

Technologies Used: SQL Server2005, Visual Source Safe, Asp.net 2.0, Java Script, CSS, HTML

2.0, C#

Education

●2003 - 2007 Bachelor of Technology (Electronics and Instrumentation) JNT University, India.

Contact this candidate