Uploaded File
Sravani
PL/SQL Developer
10 years experience W2 Edison, NJ
Available immediately
Actively seeking
Sravani
92
views
PL/SQL Developer
2 recommendations
2
Recommendations
Average rating
92
Profile views
Database Design SQL Triggers Performance Tuning SQL Server Stored Procedure BI Developer Data Marts SSIS T-SQL
Remove Note
View Note
Recent Experience
PL/SQL Developer 05/16 - present
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
PL/SQL Developer 03/15 - 04/16
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
SQL Server BI Developer 10/13 - 02/15
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
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.

Top 5 Skills
SkillsProficiencyLast Used
Database Design
2020
SQL
2020
Triggers
2020
Performance Tuning
2016
SQL Server
2016
Education and Certifications
not provided
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:Employment Authorization Document