Vamsi Madasu Email & Phone Number

Milwaukee, Wi, Us

Pune, Maharashtra, In

Redmond, Washington, Us

• Providing insights to the business partners across the globe to deliver data driven decisions.• Configured Azure SQL Server and Implemented firewall rules and Auto-scaling capabilities using power shell.• Developed Power Automate(MS Flow) Applications to automate data set refreshes,file transformations and managing notifications.• Created SSIS Packages to support downstream applications.• Developed PowerBI dashboards and improved the dashboard performance of existing reports and reduced the data refreshing times.• Created Stored Procedures to implement back-end Logic for data processing.• Created Pipelines using Azure Data factory (ADF) for big data loads to Azure Data Lake (ADL).• Created Azure Databricks notebooks using PySpark to transform and process data.• Implemented Parallel process of databricks notebooks using Python multithreading, resulted in reduction of ETL and data processing by approximately 5 hours per day.• Migrated SQL Code to SparkSQL code for data processing.• Configured JDBC connections to write data from databricks to SQL Server.• Created Stored Procedures to implement backend Logic for the web applications.• Build SSAS Cubes for Analysis based on the business users requirements.• Build and Published PowerBI dashboards implementing role level security.• Implemented and configured monitoring of ADF pipelines.• Provided Production support to one of the modules in the web application and resolved approximately 100 plus incidents maintaining 100% SLA.

Cumming, Ga, Us

Bangalore, Karnataka, In

•Implementing Adobe Analytics using Adobe dynamic tag manager (DTM) and capturing the click stream data to improve the client digital experience and making capabilities.•Created C# Application to process Amazon SQS messages and convert the JSON data to relational model.•Developed ETL frameworks to automate the data loads from flat files, Excel files, AWS Redshift, S3 by integrating SSIS and C#.•Created C# Application to create Amazon S3 buckets and load files to S3 buckets.•Implemented life cycle management rules to archive S3 files to Amazon Glacier.•Built Tabular Model SSAS Cubes for data Analysis.•Deploying the SSRS reports on the SharePoint server and granting access to authorized users.•Developing interactive reports and dash boards using Microsoft Power BI and Tableau based on the clients requirements to deliver Data-Driven decisions.•Implemented Row level security in PowerBI.•Creating PowerBI workspaces based on the Organization Departments.•Configuring PowerBI gateways to refresh dashboards pointing to SSAS tabular model.•Connecting Data points across cross-platform applications and provide insights on client Journey•Developing Data Analytics pipeline using Python,AWS Redshift,Dynamo DB,S3,SQS•Implemented Row-level security to lock down user access based on role.

Arlington Heights, Illinois, Us

Shelton, Connecticut, Us

•Worked for One of the USA’s Leading Insurance company(Offshore)•Developed Web Applications using Asp.net,C#.Net•Created Indexes, Views, Jobs and Triggers using MSSQL-Server 2008•Preformed Unit Testing for all the Store Procedures to validate the results.•Microsoft Business Intelligence Stack•Data Analysis & Reporting on KPI's•Automation of Databases Backup's•Monitoring of Applications

•Designing webforms using asp.net and C#• Creating Stored procedures•Deploying web applications in IIS• Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports using SSRS.• Deploying the SSRS reports on the Reporting server.• Creating SSRS subscriptions for email delivery of SSRS reports•Troubleshooting production issues

Master'S Degree, Computer Science

B. Tech, Electrical, Electronics And Communications Engineering