PeddiReddy

PeddiReddy

Data Scientist
India

About Me

 Over 3.5 yrs. of Experience in Software Development Life Cycle Covering Analysis,

Design, Development.

 Plan, design, and implement application database code objects, such as stored

proce…

Experience

SQL Developer

optum
Apr 2022 - Present · 4 years 2 months

Over 3.7yrs. of Experience in Software Development Life Cycle Covering Analysis, Design, Development. ? Plan, design, and implement application database code objects, such as stored procedures and views. ? Experience in writing Complex T-SQL Queries, Stored Procedures, Views and Indexes on SQL Server 2008 r2. ? Experience in MSBI Tools, SSIS. Designed and worked on SSIS packages for data importing into SQL Database. ? In-depth knowledge in various RDBMS concepts like Database, Tables User Defined Data Types, Views, Indexes, Stored Procedures, User Defined Functions, Triggers, CTE (Common Table Expression) etc. ? Created indexes, stored procedures and functions if necessary. ? Dedicated team player, a self-motivated individual, and a fast learner with excellent interpersonal, analytical, problem-solving communication and client interaction skills. ? Work with business stakeholders, application developers, product teams and across functional units to identify business needs and discuss solution options. ? Plans and accomplishes goals by required deadlines.

SQL and SSIS Developer

Metlife
Apr 2022 - Present · 4 years 3 months

Developing SSIS packages for any kind of enhancements.
Worked on developing ETL for loading data into SQL Server.
Fixing issues in various SQL objects like Stored procedure, Functions, Triggers.
Working on performance tuning of long running stored procedures and queries by creating appropriate Indexes and re-writing queries.
Working on Production issue tickets by Identifying root cause and fixing the issues in SQL objects like Stored procedures or correcting data related issue.
Fix any issues related to database performance and provide corrective measures.
Attending Working sessions, defect calls with Client.

Data Scientist

Optum Global Solutions (India) Pvt Ltd
Apr 2022 - Jul 2023 · 1 year 3 months

SSIS Developer

Wipro, Pune
May 2021 - Mar 2022 · 10 months

SQL Developer

Medidata
May 2021 - Mar 2022 · 10 months

working on Change requests, UAT issues, PROD issues and providing resolutions in stipulated time.
Creating SQL objects like tables, triggers, stored procedures based on requirement.
Writing stored procedure to get required columns for a report as per specification.
Using BCP command to generate output files for a report and deliver to FTP path.
Updating my tickets with daily status and collaborating with other teams to get resolution.

MSBI Developer

Value Added Solutions
Nov 2019 - Apr 2021 · 1 year 5 months

BI Developer

Capital One, USA
Nov 2019 - Apr 2021 · 1 year 5 months

working on issues reported by internal team and client.
Creating SQL objects like tables, triggers, stored procedures based on requirement.
Writing stored procedure to get required columns for a report as per specification.

Skills

Structured Query Language (SQL) T SQL .NET Data Repository Microsoft SQL Server SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) Database Design Performance Tuning SQL Server Management Studio TFS Databases SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 T-SQL Stored Procedures Views Indexes RDBMS User Defined Data Types User Defined Functions Triggers CTE ETL BCP Problem Solving Communication Client Interaction Analytical Skills Interpersonal Skills Requirement Gathering Change Management Production Support Software Development
Report this Profile?