Uploaded File
Sravani
sravanireddy753@gmail.com
361-228-6967
Edison, NJ 08817
PL/SQL Developer
12 years experience W2
2
Recommendations
Average rating
127
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
PL/SQL Developer
Information Technology
May 2016 - present
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Worked on SQL Loader to load data from flat files obtained from various facilities every day.
  • Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
  • Involved in the continuous enhancements and fixing of production problems.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Partitioned the fact tables and materialized views to enhance the performance.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX.

SQL TOAD Stored Procedure Oracle Triggers SQL Developer Unix scripts UNIX Shell Scripts PL/SQL SQL Loader Oracle SQL*Plus PL/SQL Developer Oracle 11i Data Marts Database Design
Remove Skill
References
Average Rating

1 recommendation
PL/SQL Developer
Information Technology
Mar 2015 - Apr 2016
Saint Louis, MO
  • Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
  • Created management analysis reporting using ParallelQueries, Javastoredprocedure. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
  • Involved in creating UNIXshellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
  • Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.
  • Used SQL Server SSIStool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing.
  • Extracted data from the XML file and loaded it into the database.
  • Designed and developed Oracle forms & reports generating up to 60 reports.
  • Performed modifications on existing form as per change request and maintained it.
  • Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
  • Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.
  • Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shells cripts to automate repetitive database processes.

Environment: JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.

HTML Java SQL XML Crystal Reports TOAD SQL Server Oracle ETL SSIS Triggers SQL Developer UNIX Scripting PL/SQL Performance Tuning Oracle Forms Data Replication Data Integration HP-UX SQL Loader Oracle SQL*Plus DBA PL/SQL Developer Shell Scripts Database Design
Remove Skill
References
Average Rating

0 recommendations
SQL Server BI Developer
Information Technology
Oct 2013 - Feb 2015
Middletown, CT
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Extract, Transform and Load source data into respective target tables to build the required data marts.
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Designed SSAS cube with Star Schema to hold summary data for Target dashboards.
  • Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Responsible for gathering business requirements to create business user reports.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
  • Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
  • Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS

Environment: Microsoft SQL Server 2008 Enterprise Edition, MS Access, ETL Packages (SSRS, SSIS), PL/SQL, VB.Net, ASP.NET, HTML, Visual Studio 2008 & 2005, SSIS, T-SQL, Oracle, TFS.

HTML SQL Data Integrity Visual Studio Stored Procedure SQL Server Oracle ASP.NET PL/SQL ETL SSIS SSRS SSAS SSAS CUbe T-SQL Triggers BI Developer Star Schema Performance Tuning VB.NET OLAP MS Access CUBE Data Marts Database Backups Database Design
Remove Skill
SQL Server BI Developer
Information Technology
Jul 2012 - Sep 2013
  • Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
  • Involved in database Schema design and development.
  • Designed tables, constraints, necessary stored procedures, functions, triggers and packages using T-SQL.
  • Audited the Front-end application calls to SQL Server.
  • Created efficient Queries, Indexes, Views and Functions.
  • Enforced Security requirements using triggers to prevent unauthorized access to the database.
  • Optimized the Database for best performance, with DBCC, partition table.
  • Design and develop the payroll module using MS SQL Server 2008.
  • Migrated data from MS Access to SQL Server.
  • Performance Tuning of the client databases for better performance on a regular basis.
  • Responsibilities include writing of scripts for Database tasks, releasing Database objects into production.
  • Running DBCC consistency checks, fixing data corruption on application Databases.
  • Worked in establishing connectivity between VB applications and MS SQL Server by using ADO.

Environment: SQL Server 2008, Oracle, MS VB Access, Windows 2003 Standard Edition, Windows

SQL Visual Basic Stored Procedure SQL Server Oracle T-SQL Triggers BI Developer Windows Performance Tuning MS Access Data Modeling Auditing Windows 2000 Windows 2003 Database Design
Remove Skill
BI Developer
Information Technology
Sep 2009 - Jun 2012

Responsibilities:

  • Involved in installation and configuration of SQL server 2008 on Servers.
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Implement and maintain database security.
  • Implemented trigger and stored procedures and enforced business rules via checks and constraints.
  • Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
  • Going through the clients' requirements and coming up with database design and application architecture.
  • Troubleshoot and minimize production down issues.
  • Designed new job process, new database maintenance plans, SSIS programs and did performance tuning of the existing processes.
  • Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
  • Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
  • Data conversions and data loads from various databases and file structures.
  • Monitor failed and long running MS SQL Server jobs.
  • Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
  • Maintained User account administration for Different domains.

Environment: MS SQL Server 2008, SSIS, Visual Studio 2005, C#

SQL Visual Studio Stored Procedure SQL Server Data Conversion SSIS T-SQL Triggers Disaster Recovery BI Developer Performance Tuning Database Maintenance Applications Architecture C#
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science
not provided
Skills
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
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