PeddiReddy

PeddiReddy

Data Scientist
India

نبذة عني

 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…

الخبرة

SQL Developer

optum
Apr 2022 - حتى الآن · 4 سنوات 2 أشهر

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 - حتى الآن · 4 سنوات 3 أشهر

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 سنة 3 أشهر

SSIS Developer

Wipro, Pune
May 2021 - Mar 2022 · 10 أشهر

SQL Developer

Medidata
May 2021 - Mar 2022 · 10 أشهر

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 سنة 5 أشهر

BI Developer

Capital One, USA
Nov 2019 - Apr 2021 · 1 سنة 5 أشهر

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.

المهارات

لغة الاستعلامات الهيكلية (SQL) لغة الاستعلامات الهيكلية الدوت نت (مجموعة أدوات تطوير البرمجيات) مستودع البيانات مزود بيانات SQL Server من مايكروسوفت خدمات تكامل SQL Server خدمات تقارير SQL Server تصميم قواعد البيانات ضبط الأداء استوديو إدارة خادم SQL تي إف إس (خدمة الإطار الزمني للعمل) قواعد البيانات 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
الإبلاغ عن هذا الملف الشخصي؟