M Prashanth

Software Developer

IT
View resume
2roles
25skills
2education

About

Software developer with 1.3 years of professional experience in SQL Server database development, SQL queries, database design, SSIS data transformations, and SSRS reporting.

Experience

Software Engineer

Crevavi Engineering Solutions Pvt Ltd

Software Developer

Xpheno Pvt Ltd

Education

SVS Group of Institutions

B.Tech, EEE

VMR Polytechnic College

Diploma, EEE

Skills

SQLMicrosoft SQL ServerSQL Server 2008R2SQL Server 2016SQL Server 2019T-SQLDatabase designStored proceduresViewsFunctionsComplex queriesTriggersIndexesSSISSSRSData transformationsData warehousingDatabase backup and recoveryDatabase optimizationError loggingError handlingDrill-down reportsParameterized reportsSubreportsLinked reports

Projects

Pfizer

Healthcare data project involving extraction of client data through DTS packages into a SQL Server staging area and then into a data mart. Responsibilities included SQL Server database management, backup and recovery procedures, complex queries, stored procedures, triggers, database optimization, and collaboration with application developers.

Corporate Data Warehousing System

Cigna Health project using SSRS and SQL Server 2008R2 to maintain insurance-related database systems, analyze customer revenue, load modeled data from flat files and Excel sheets, and create drill-down, parameterized, sub, linked, and complex reports.