Sridhar Reddy

Senior PLSQL Developer

513-***-****

adkeom@r.postjobfree.com

PROFESSIONAL SUMMARY

11+ years of Strong experience in Client/Server application development using Data Modeling & Oracle PL/SQL (9i/10g/11g,12c and 19c) Programming in Analysis, Design, Development and Application Support and Implementation using Oracle RDBMS

Well conversant in translating business requirements into creation of database objects: tables, Indexes, packages, stored procedures, functions, and triggers using Oracle PL/SQL.

Experience of product development lifecycle and product support, implementation and maintenance activities.

Experience on Banking, Health Care and Pharmacy.

TECHNICAL EXPERIENCE:

Extensive experience in Client/Server application development using Oracle PL/SQL.

Involved in all phases of the SDLC from analysis, design, development, testing, implementation, Support and maintenance with timely delivery against aggressive deadlines.

Experience building ETL Process from scratch, without any tools.

Experience on Import, Export and SQL Loader.

Experience on DBA Activities.

Worked extensively In UNIX Scripting.

Involved in extracting, transforming, integrating, and loading data into different Datamart’s.

Excellent in understand in data models and relationship and convert into business scenarios to write complex SQL queries using Joins, Sub queries with good performance.

Experience in developing large scale enterprise database applications and performance tuning with high transactional data.

Perform SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Substantial development experience in creating PL/SQL Cursors, Stored procedures, Functions, Packages and Triggers.

Proficient in PL/SQL and creation and modification of database objects like Tables, Packages, Procedures, Functions, Triggers, views, Synonyms using Oracle tools like SQL*Plus, PL/SQL Developer and Toad.

End to end testing of the applications and root cause analysis

Experience with data flow diagrams, data dictionary, database normalization theory techniques, Entity relation modeling and design techniques.

Extensively used the advanced features of PL/SQL like Collections including Records, Tables, Object types and Dynamic SQL.

Experience on process flows/models, test cases and scripts.

Excellent at troubleshooting.

Experience in advance features of PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.

Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.

Extensively used Oracle pre-defined package like DBMS_SCHEDULER, DBMS_APPLICATION_INFO, DBMS_LOCK, DBMS_OUTPUT and UTL_FILE.

Extensively used Cubes & Rollups for making cross tabular reports.

Great experience in resolving most critical issues.

Good experience in handle runtime errors by providing Suitable Exception Handlers.

Experience in developing the business validation-oriented trigger logic.

Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin and ER Studio Data modeling tools.

Strong knowledge of data warehouse architecture and Star Database schemas, Fact and dimensional tables.

Enforced data integrity using integrity constraint and database triggers.

Making structural changes to the database objects.

Experience in Creating and Modifying Objects like Tables, Views, Synonyms and Sequences, Functions, Procedures and Packages and Triggers.

Strong knowledge in Oracle Cursor management and exception handling.

Can take challenges arising in the process of development function Critical logic in developing joins, sub queries and hierarchical queries and OLAP In SQL * Plus.

Extensive experience with all phases of the Software Development Life Cycle including analysis, code development, testing, implementing and maintenance.

Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.

Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.

Experience in Database Index, Data Model and SQL Tuning.

Experience in Export and Import the database objects.

Experience in creating materialized views and refresh the same.

Experience in generating .csv files in server and transfer to FTP servers.

Experience in shell scripting and used to schedule oracle jobs.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Experience in writing technical system design documents for both the defect tracking and change request.

Strong interpersonal and communication skills in dealing with customers.

EDUCATIONAL BACKGROUND:

Master’s – Master of computer Applications

TECHNICAL SKILLS:

Operating Systems

Windows, Linux and AIX

Languages

SQL, PL/SQL, C, C++

Database

Oracle 9i/10g/11g/12c/19c

Tools

SQL*PLUS, SQL Developer, PLSQL Developer and Toad.

Source Control

TFS, PVCS (Product Version Control System)

DCMS (Defect Change Management System)

PROFESSIONAL EXERIENCE:

Client: Sutter Health, Sacramento, CA

Duration: Jun-2017 to Till Date

Environment: Senior Oracle PLSQL Developer

Environment: Oracle, Unix, .net

PROJECT: EDM and Kronos

Responsibilities:

Creation and Enhancements in SQL, PL/SQL code for Procedure, Functions, Packages.

Worked on Database split into 3 regional databases, Data purged to improve the Performance.

Warehouse EOD Batch processing time reduced dramatically by tuning the multiple Queries, major query execution time reduced from 8 hours to 1 hour.

Performed database tuning by using various tools like Oracle Enterprise Manager and AWR Reports.

Worked with .net team on trouble shooting and Development phase.

Automated various tasks by using shell scripts.

Worked on Data Analysis and Data Fix.

Fixed long running queries.

Worked on Data Migration.

Worked with Oracle SQL Data modeling tools to designing the Conceptual, Logical and Physical data modeling.

Experienced in using external table to load data into the Oracle tables.

Experience on SQL Server.

Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.

Writing technical documents using the functional specifications.

Writing PL/SQL code using the technical and functional specifications.

Optimized the queries to improve the performance of the application.

Handled Performance tuning and improve the performance by using hints and Writing PL/SQL procedures, Functions and packages for various reports

Transfer the data file between the servers.

Client: NEC Corporation of America, Rancho Cordova, CA

Duration: Oct-2014 to Jun-2017

Role: Oracle PLSQL Developer and Junior DBA

Environment: Oracle, Unix, .net

PROJECT: Image Vault, Biometrics

Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Triggers, and Synonyms.

Used TOAD, PL/ SQL developer tools for faster application development.

Worked with the Business Analysts and Users in understanding the business requirements for the project.

Worked on Data migration and Validation.

Export and Import Data using Data Pump.

Performed database tuning by using various tools like Oracle Enterprise Manager and AWR Reports.

Worked as Junior DBA activities like Create Database, Patching, Add Tablespace, Deployments, Environment Refresh, create users and grant privileges.

Constructed standard and materialized views for viewing and extracting usable data from various sources to get a clear real-time view of business-critical information

Used Dynamic SQL programming technique to build and process SQL statements

Extensively involved in developing PL/ SQL packages that includes advanced PLSQL concepts like REF_CURSOR, BULK COLLECTS, for all, etc.

Used SQL*Loader to load data from external system and developed PL/ SQL programs to dump the data form staging tables into base tables.

Production support for data fixes and debugging aborted processes.

Explain Plan, AWR reports, SQL Trace, TKROF, Stats Pack and SQL*PLUS Auto trace.

Performed functional testing for the procedures and packages.

Client: Kroger, Cincinnati, OH

Duration: Jan-2012 to Sep-2014

Role: Oracle PLSQL Developer

Environment: Oracle, Unix, Java.

PROJECT: Pharmacy

Responsibilities:

Written SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.

Performed SQL and PLSQL tuning and Application tuning using various tools like EXPLAINPLAN, SQL*Trace and TKPROF.

Conducted major stakeholder meetings involving SME's, Business Analysts, ETL developers and other stakeholders to determine the requirements.

Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.

Effectively used the advanced features of PL/SQL like Collections including Records, Tables, Object types and Dynamic SQL.

Used forward engineering to generate DDL's that best suits the requirements from the Physical Data Model (ER Model).

Widely used PL/SQL tables and Bulk Collect for processing the load on tables and retrieving into oracle.

Participated in code review meetings with the development team.

Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.

Developed complex SQL queries to perform the back end testing of the Oracle database using UNIX shell commands.

Performed SQL and PLSQL tuning and Application tuning using various tools like EXPLAINPLAN, SQL*Trace and TKPROF.

Client: State Bank of India, Mumbai

Duration: May-2009 to Jan-2012

Role: Junior Developer

Environment: Oracle, MF Cobol and Unix.

PROJECT: Deposits

Responsibilities:

Developed new Packages and Procedures.

Written UNIX Shell scripts for supporting Multithreading of programs, which improves the response time drastically.

Involved in Data Migration from Legacy System to Bancs@24.

Direct interaction with clients and giving them real-time solutions.

Analyzing the MF COBOL code and data based on the problem, fixing the error and rising IR if necessary.

Written PL/SQL programs for Defect analysis and data fixes.

Requirement analysis, Design and development of various “General Functionalities”. This involved writing Technical Specifications.

Contact this candidate