Prasuna Madda

Plano, TX *****

469-***-****

ad0sr7@r.postjobfree.com

SUMMARY:

* ***** ** ********** ** Analysis, Design and develop database objects, stored

procedures, views, functions, tables, and triggers; ensure their stability, reliability, and performance.

Knowledge of relational DBMS management and structure, including primary and foreign key constraints, indexes and database constraints, data encryption, database triggers, stored procedures, SQL Alerts, SQL Trace, Database Links, other features of SQL Server as needed.

Knowledge of reading Execution Plans, understanding implications of alerts and events, and develop and test optimization plan, Performance Tuning.

Knowledge of DB admin activities such Backups and restore of databases,

Data patching, Configuring SQL Jobs, Email Alerts, Knowledge of defining Users and enable data distribution to the right user.

Develop procedures and scripts for data migration across databases and ensure migrated data is accurate and intact.

Knowledge of understanding the types of data collected in various databases helping maintain their integrity and security.

Experience in the design of ETL processes, database design, development,

Implementation, information storage and retrieval, dataflow, and analysis activities.

Experience in developing reports and dashboards using Power BI tool.

Experience in Server setup (production and Test) activities and all feature installations, Elastic Search, Smart search, IPO, reports.

Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Experience in creating SSIS packages with different data sources and

load the data into one or more destinations.

Familiarity with the Software Development Lifecycle (SDLC) process

Ability to analyze, troubleshoot and solve technical issues; will own issues and tasks until full resolution.

Ability to organize time to complete prioritized tasks in a timely manner

Ability to prioritize competing needs related to technology and data systems in a highly dynamic environment.

Ability to manage and prioritize multiple projects.

Working knowledge of data software development processes and programming languages

Understanding of recognized IT best practices and how to apply them.

Delivered all the projects and assignments within the specified timelines with accuracy.

VISA STATUS: U.S Citizen

EDUCATION:

Masters in VLSI System Design, Electronics and Communications Department

JNTU University, India.

Bachelors in Electronics and Communications Engineering Nagarjuna University, India .

TECHNICAL SKILLS:

Analytical Tools: Qlik Sense.

Reporting Tools: Tableau, Power BI, SSRS, SSIS, Azure Data Factory

Operating Systems: Windows 10, Linux.

Databases: MS SQL, AWS SQL, MySQL, Oracle, MS Access.

Programming Languages: T-SQL,Oracle SQL, PL/SQL, PostgreSQL, Kafka,

MongoDB, java, C++, C#, VHDL, Verilog, FPGA

Cloud Technologies: AWS, Microsoft Azure, Snowflake.

Ticketing Applications: JIRA, Service now.

Microsoft Office: MS Word, MS Excel, MS Access, PowerPoint.

Project Methodologies: SCRUM Agile Methodologies, ITIL.

Frame works: Agile-Scrum, java web services, .NET Framework.

TRAININGS / CERTIFICATIONS

CERTIFICATION:

Microsoft Certification 2017

T-SQL- Microsoft certification 2019

(SQL 2016 Database Development)

Platform by Per Scholas, Cognizant, Dallas, TX 2018

(Application Support Management (ASM) Training)

Trained how to evaluate, improve, and manage internal ITIL framework without disrupting the organization’s current operations. Support applications smooth functioning via troubleshooting, conducting analysis and research, and providing resolutions by using advanced query and programming skills.

PROFFESSIONAL EXPERIENCE:

Collins Aerospace Iowa (2022- 2023)

Database Developer

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Work closely with the development team to provide support for Database Objects and perform code review.

Work closely with .NET Developers, Scrum Masters, and Project Owners to determine proper system and database designs.

Actively participate and contribute to the continual improvement of best practices by developing and implementing system recovery and database management.

Involved in creating database objects, tables, stored procedures, functions Views, triggers, Indexes and SQL optimization and performance tuning Activities.

Troubleshoot various problems that arise in the day-to-day operations and fix the issues.

Develop procedures and scripts for data migration across databases.

Develop procedures to process business artifacts and reports.

Involved in DB admin activities such Backups and restore of databases, Data patching, Configuring SQL Jobs.

Maintain Users, Roles, Permissions and Security.

Enhance existing stored procedures, views, functions, and database objects to meet additional requirements of latest releases.

Participate in various software releases by deploying database scripts and performing post-deployment monitoring.

Write and optimize SQL statements for data access and retention.

Act as a SQL subject matter expert to establish policies, best practices, and share knowledge at all levels within the organization.

Ramco Systems New Jersey (2020 – 2022)

SQL Developer (Supported Tactical Air Support, Erickson, Top Aces Corp, Pano Stat LLC)

Work as a SQL Developer and Establish strong relationships with end

users and technical resources throughout established Projects.

Participated in the planning, installation, configuring, monitoring, and

deployment of database systems in an SQL Server environment.

Work closely with the development team to provide support for Database

Objects and performing code review.

Work with IT and data owners to understand the types of data collected in

various databases, helping maintain their integrity and security.

Involved in creating database objects, tables, stored procedures,functions

Views, triggers, Indexes and SQL optimization and performance tuning

Activities.

Involved in DB admin activities, such Backups and restore of databases,

Data patching, Configuring Jobs, Email Alerts.

Involved in ETL processes creating SSIS packages with different data

sources and load the data into one or more destinations.

Created and debugged complex ETL processes using T-SQL queries,

functions, stored procedures and SQL Server Agent jobs.

Involved in Server setup (production and Test) activities and all feature

Installations like Elastic search, smart search, Reports.

Conduct testing and perform troubleshooting on databases to ensure

accuracy, security, and efficiency.

Configure and Maintain Database Servers.

Define Users and enable data distribution to the right user.

Develop procedures and scripts for data migration across databases and

ensure migrated data is accurate and intact.

Involved Integration Testing activities using Postman and Rest API, Wso2

Data Upload activities using IDUCT.

Development activities

Integration activities using IRIS.

Report developments activities using Dcube, DW ARI, DW ER, SSRS

Chirala Engineering College, Chirala, India

Assistant Professor

Instructed various undergraduate courses in electronics engineering.

Created team projects and helped students plan incremental delivery of their projects.

Graded exams, labs and team projects including project plans.

Contact this candidate