Sravani
sravanireddy753@gmail.com
361-228-6967
Edison, NJ 08817
PL/SQL Developer
15 years experience W2
2
Recommendations
Average rating
189
Profile views
Summary

  • Over 7 Years of IT experience which includes Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology
  • Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, CTE’s, Table Variables, User Defined Data Types, Indexed Views, Relational Database Models,
  • Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
  • Good knowledge on logical and physical Data Modeling using normalizing Techniques.
  • Created Tables, Views, Constraints, Index
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Developed materialized views for data replication in distributed environments.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Partitioned large Tables using range partition technique.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Experience in SQL performance tuning using Cost-Based Optimization (CBO).
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
  • Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Tableau, SSRS.
  • Created Shell Scripts for invoking SQL scripts and scheduled them.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Technical Skills:

Tools &Packages:

  • SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0,

BI Tools:

  • SSIS, SSAS, SSRS, Informatica, Power BI, Cognos.

Databases:

  • MS SQL Server 2000/2005/2008, MS Access 2003/2005/2008, Oracle, DB2.

Language:

  • T-SQL, PL/SQL, MDX,C, C# (.NET), Java, C++, COBOL, JCL, Mainframes.

Application Packages:

  • MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools:

  • Erwin, MS Visio, EDI

Operating Systems

  • Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.

Experience
Education
Computer Science
not provided
Skills
OPTIM
2022
10
Database Design
2021
7
SQL
2021
7
Triggers
2021
7
Performance Tuning
2016
6
SQL Server
2016
6
Stored Procedure
2021
6
BI Developer
2015
5
Data Marts
2021
5
SSIS
2016
5
T-SQL
2015
5
Oracle
2021
4
Visual Studio
2015
4
Applications Architecture
2012
3
C#
2012
3
PL/SQL
2021
3
Data Conversion
2012
2
Database Backups
2015
2
Database Maintenance
2012
2
Disaster Recovery
2012
2
ETL
2016
2
HTML
2016
2
MS Access
2015
2
Oracle SQL*Plus
2021
2
PL/SQL Developer
2021
2
Shell Scripts
2021
2
SQL Developer
2021
2
SQL Loader
2021
2
TOAD
2021
2
UNIX
2021
2
ASP.NET
2015
1
Auditing
2013
1
Crystal Reports
2016
1
CUBE
2015
1
Data Integration
2016
1
Data Integrity
2015
1
Data Modeling
2013
1
Data Replication
2016
1
DBA
2016
1
HP-UX
2016
1
Java
2016
1
OLAP
2015
1
Oracle 11i
2021
1
Oracle Forms
2016
1
Scripting
2016
1
SSAS
2015
1
SSAS CUbe
2015
1
SSRS
2015
1
Star Schema
2015
1
Unix scripts
2021
1
VB.NET
2015
1
Visual Basic
2013
1
Windows
2013
1
Windows 2000
2013
1
Windows 2003
2013
1
XML
2016
1
Agile Methodology
0
1
C
0
1
C++
0
1
Cognos
0
1
Data Dictionary
0
1
EDI
0
1
Erwin Data Modler
0
1
Informatica
0
1
Microsoft Excel
0
1
MS SharePoint
0
1
OLTP
0
1
Project Management
0
1
Scrum
0
1
Tableau
0
1
Waterfall
0
1
Windows Server
0
1