Dinesh Reddy Vakiti

Summary:

Result-driven professional with 8+ years of experience as MSBI developer in various stages of Software Development Life Cycle (SDLC) like Planning, Design, Production, Development, Implementation and Unit Testing

Experienced in medium to large scale environments in various domains like Finance and Healthcare

Worked on packages to load HEDIS measures, ICD codes, Claims data into the servers.

Proficient in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures and Triggers using Microsoft SQL Server Management Studio

Experienced in optimizing Stored Procedures, query performance tuning.

Proficient in Extract, Transform and Load process using SQL Server Integration Services

Developed complex SSIS packages for processing incremental data load with multiple transformations like Slowly Changing Dimension, Merge, Lookup, Derived Column, conditional split.

Strong experience in automation of SSIS packages by scheduling jobs, creating, monitoring alerts and using breakpoints, checkpoints, error handlers and event handlers to debug and troubleshoot SSIS packages.

Expertise in creating multivalued parameterized reports, multi-level cascading reports, drill down, drill through, sub reports, charts and ad-hoc reports using SQL Server Reporting Services (SSRS) and publishing them to server.

Created Power Bi reports using Power BI desktop and online service and schedule refresh.

Generated Power BI reports using interactive visualizations and DAX features from multiple data sources.

Worked on Power Bi Paginated report builder on Desktop and published them.

Configured row-level security for customers in Power BI

Good team player, strong analytical, written, communicational and interpersonal skills.

Have proven track record working in various environments and a valuable ability to quickly pick up new technologies and become an asset to the company in a minimal amount of time.

Technical skills:

DBMS & RDBMS

SQL Server 2005/2008/2012/2017, MySQL, Snowflake

Languages

TSQL, VB Script, C, C#

SQL Server Tools

SQL Server Data Tools, SQL Server Profiler, Database Tuning Wizard,

ETL Tools

SQL Server Integration Services (SSIS), Informatica

Reporting Tools

SQL Server Reporting Services (SSRS), MS Excel, Tableau, Power BI

Other Tools

MS Visual Studio, Unix, Linux, MS Office, Advanced MS Excel, Jira, FreshService, Snowflake, Matallion

Education:

BSc In MPC from Osmania University 2012

MS In Technology Management from University Of Bridgeport 2018

Professional experience:

Community Behavioral Health, Philadelphia PA July 2019 to Till Date

Sr BI Developer

The focus of the project is to migrate data from legacy systems to the new 2017 Data Warehouse. To achieve the goal, packages and reports are converted to SSIS and SSRS 2017 version and new packages and reports are created to accommodate new requests.

Responsibilities:

Write new SQL queries and Stored procedures to extract data from the tables.

Worked on existing stored procedures to make necessary changes according to new needs.

Worked on BIDS 2005 to make changes to the existing ETL packages.

Developed new ETL packages to transfer data from databases to flat files in shared folders.

Used various kinds of transformations like Lookup, Sort, Merge, Conditional Split, Data Conversion, Derived column to match the data in ETL packages.

Created incrementally loading ETL packages instead of performing full load that was previously used.

Worked on creating replication packages for existing procedures in new Data warehouse.

Collaborated with various departments to create ETL packages based on their needs.

Test run packages in different environments before deploying them to production.

Responsible for deploying packages and scheduling them for the team.

Scheduled daily, weekly, monthly jobs that took care of the SSIS packages.

Generated various kinds of reports in SSRS, published them to the report server and scheduled them to their needs.

Worked on data extraction for SSRS reports that are exported to flat files and excel files.

Worked on BIDS 2008 to generate new reports and make changes to the existing reports.

Develop and modify SQL scripts that are used in Power BI dashboard by the analyst.

Develop different visualizations in reports using Power BI desktop and publish them.

Created DAX queries in Power BI to generate computed data fields.

Developed various kinds of visualizations like donut, pie, word count, stacked bar/ column charts, scatter plots and tree maps according to the needs using Power BI.

Designed and developed reports, paginated reports, dashboards and data models to support organization’s operations using Power BI.

Involved in integration of SSRS reports to embedded Power BI reports and deploy them on to power BI service.

Provided row-level security to users by creating user roles and groups.

Migrating data warehouse to Snowflake environment and testing the data integrity.

Environment: SQL Server 2017/2008/2005, T-SQL, Visual Studio 2005/2008/2017, Snowflake, Power BI

Bank of New York Mellon, New York City, NY Sep 2017 to June 2019

Sr BI Developer/ Power BI Developer

The aim of the project is to create stored procedures that help to build dashboards in Power BI and SSRS for clients. Load data using SSIS.

Responsibilities:

Loaded data into the data warehouse using SSIS packages.

Extracted data from multiple sources, performed various kinds of transformations and loaded the data using SSIS.

Used multiple transformations in SSIS to make changes to the data to match the metadata in the tables.

Tested the ETL packages in different environments for data integrity before sending it to the production team.

Developed SSRS reports by creating stored procedures.

Worked on existing SSRS reports and was a support postproduction of the reports.

Worked on existing stored procedures and fine-tuned them for better results.

Created new stored procedures for new reports in SSRS and Power BI.

Created validation & test case mapping documents to match data from source to destination.

Collect requirements from clients and work on Power BI projects and visualize the reports.

Created various complex reports in Power BI (Private equity and real estate) which pulls in data from different databases.

Worked on OLTP data from various sources like Trade files, TRN Trade, Equity data.

Gave demos to fund accountants and business users in Power BI and DAX studio to understand the reports.

Setup data gateways in Power BI for on-premises data servers.

Implemented row-level security to keep reports access to specific users.

Implemented Power BI gateway to keep dashboards and reports updated with on-premises data sources.

Experience in understanding and designing the data model in Power BI modelling according to structure and relationships of data.

Good understanding and knowledge of DAX queries in Power BI to satisfy business needs.

Developed SSIS ETL process using various transformations to load data into tables and output Trade, Position, Profit and Loss data consumption.

Environment: SQL Server 2012/2016, T-SQL, SSIS, SSRS, Visual Studio 2017, MS Excel, Power Pivot, Power BI

United BioSource Corporation Jan 2017 to Aug 2017

MSBI Developer

Project’s focus is to load the data from different sources into tables. ETL packages were created to load the data which was further used to generate reports that are used by the internal team to analyze the patient records.

Responsibilities:

Created data mapping document by analyzing the data which is used in ETL process in SSIS.

Developed ETL packages using SSIS to load data into specific tables.

Worked on existing packages that needed to be updated with new requirements and monitored those packages.

Involved in creating triggers to automate the process of ETL in different stages.

Created dynamic reports in SSRS for data driven subscriptions to be delivered to various clients in excel.

Created drill-down and drill-through reports for internal clients and deployed them to the server.

Created interactive reports in SSRS for internal clients which are used in further analysis of patient records.

Created standard template for reports which can be used across all the clients.

Extensively tested the automation of the ETL process in SSIS and reports in SSRS.

Environment: SQL Server 2012, Microsoft SQL(T-SQL), SSIS 2012, SSRS 2012/2015, MS Excel, VB Script

Cardinal Health, Dublin OH June 2015 to Nov 2016

MSBI Developer

The scope of the project is to perform ETL process and generate Customized Reports. Gathering data and centralizing to hold adequate information for analysis using ETL process and determining trends, identifying product success and failure, and provide a more holistic view of company activity were part of this project.

Responsibilities:

Used ServiceNow tool to create UI for customers and worked as administrator for the same.

Designed and implemented data models and data marts for database and data warehouse.

Expertise in using all types of database objects such as constraints, tables, views to facilitate data consistency and efficient data manipulation.

Experience in using joins, CTE’s, stored procedures and sub-queries for complex queries which involved multiple tables from different databases.

Responsible for analyzing data and re-mapping fields based on business requirements.

Created SSIS Packages to load data from multiple sources like Flat files, Excel, OLEDB to SQL Server and other client destinations.

Developed SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc., before loading data

Implemented event handlers, breakpoints and checkpoints to troubleshoot and debug. Also incorporated error redirection during ETL process in SSIS packages.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports.

Responsible for deploying and scheduling reports to generate periodic depiction of the customer’s standing, repayments, payments and collections using SSRS.

Developed tabular, sub report, drill down, cascaded, multi-valued parameterized reports using SSRS.

Studied the existing OLTP system and created facts, dimensions and star schema representation for the data mart.

Environment: Unix, Linux, C, SQL Server 2008/2012, Microsoft SQL(T-SQL), SSIS, SSRS, MS Excel

Contact this candidate