Prasanth Rayapati

About Prasanth Rayapati

Involving in Designing phase and Development Phase for every Project within billing and financial department.• Translated business needs into data analysis, business intelligence data sources and reporting solutions for several types of information consumers.• Gather and understand business requirements to set functional specifications for reporting applications.• Created various kinds of reports using Power BI and Tableau, SSRS, Excel, and PowerPivot based on the client\'s needs. Experienced on creating multiple kinds of Reports in Power BI, Ad-hoc and present it using Story Points.• Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.• Created joins and sub-queries for complex queries involving multiple tables.• Scheduled SQL Server Agent Jobs to monitor data transformation and database updates.• Identified Fact tables and Dimension tables and created data marts for various subject areas as required.• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Experience

1. Sr Sql Bi Developer

   Verra Mobility

   Jan 2021 — Present · Mesa, AZ, US

   Verra Mobility is a global leader in smart mobility. The company develops technology-enabled solutions that help the world move safely and easily. Verra Mobility fosters the development of safe cities, working with police departments and municipalities by operation more than red-light, speed, and school bus stop arm safety cameras in more than 200 jurisdictions across North America.Responsibilities: • Defined and designed the data sourcing and data flows, data quality analysis.• Proactively create framework to analyze system performance to ensure high availability and of processing using a variety of tools. Identified the data source and defined them to build the data source views.• Creating Stored Procedures in MS SQL Server.• Written complex SQL queries involving multiple tables inner and outer joins, temporary tables, table variables.• Strong SQL programming skills and some stored procedure development.• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects. String technical knowledge in Troubleshooting and performance tuning.• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.• Designing flow of data from daily tables to weekly tables and monthly aggregates in the billing Data marts.• Identified and modified the KPI\'s, measures in co-ordinance with the requirement and created calculate members in cube using MDX queries in Business Intelligence Studio using SSAS.• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing various kinds of transformations using SQL Server Integration Services (SSIS). Tested and managed the SSIS and SSIS packages and was responsible for its security.• Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters

Education

• Arkansas State University

  Master's degree, Engineering/Industrial Management

• Christian Brothers University

  Master's degree, Engineering/Industrial Management