SUDHIR GUDIVADA

adzbjj@r.postjobfree.com

708-***-****

PROFESSIONAL SUMMARY

IT Professional with 9+ years of experience as Oracle PL/SQL developer in Analysis, Design, Data Modeling (Logical and Physical), Data Migration, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

System Analysis, Design, Development and Support of Oracle Database 9i, 10g and 11g in Production, staging and Development environments.

Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology.

Designed database schema's using Entity relationship modeling with ER diagrams& database normalization principles.

Experience in requirement gathering, data analysis, database engineering and configuration management.

Experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.

Expert in creating Views, Stored Procedures, effective functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.

Very good experience in Oracle tools like SQL*PLUS, SQL*Loader, SQL Developer and TOAD.

Experience in retrieving data from external data Files and loading them into oracle tables using tools like UTL_FILE, SQL*Loader and External Tables.

Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, SQL*Trace and Table partitioning.

Working Knowledge on UNIX, Windows and Shell Scripting

Good experience in version control of documents and database objects using tools like VSS and SVN

Expertise in Database Design, Database programming and SQL

Experience in Autosys job scheduling.

Expertise in Unit, Integration, Functionality, GUI, System, Regression and UAT Testing

Knowledge of Extraction Transformation and Loading (ETL) processes using SQL, PL/SQL and SQL Loader.

Worked on User-defined and also the System defined exceptions to handle different types of errors like NO_DATA_FOUND, ROWTYPE_MISMATCH, and PRAGMAEXCEPTION_INIT.

Self-motivated and enjoy working in a technically challenging environment

Ability to work under stringent deadlines within a team as well as independently

TECHNICAL EXPERTISE

Programming Languages : Python, SQL, PL/SQL, UNIX shell scripts, C

Developer /Design Tools : SQL* Plus, Toad, SQL* Loader, SQL Developer, Oracle Developer,

Oracle Enterprise Manager, Oracle Warehouse Builder, MS Visio, Putty, Winscp

Operating Systems : UNIX, Solaris, Windows XP/7

Databases : Oracle 11g/10g, MS SQL Server 2000

DataWarehousing : Snowflake, Redshift

Reporting Systems : Splunk

PROFESSIONAL EXPERIENCE:

Wells Fargo, Winston Salem, NC

Oracle PL/SQL/Snowflake – Apr ’20 to Feb’22

This project is Wholesale Customer Onboarding Project user’s access this application.

Analyze the business requirements of the project by studying the Business Requirement Specification document.

Created tables and views on snowflake as per the business needs.

Design and implement efficient data pipelines in order to integrate data from a variety of source into Data Warehouse.

Develop Etl pipelines in and out of Data Warehouse using snowflake SnowSQL queries against snowflake.

Create PLSQL Stored Procedures, Functions, and Packages per the business requirements.

Work on Query Optimization Techniques for complex SQL Statements that are running longer and provided solutions to make the process run faster.

Work with front end application developers with the queries/stored procedures and Views.

Created database objects tables, views, triggers, according to the requirement.

Wrote complex SQL queries using Joins, Sub queries and Group functions.

Use Performance Monitor and Explain Plan for performance tuning to enhance the Performance of databases.

Analyzed data performance and implemented changes necessary to improve execution time.

Developed various reports for management using T-SQL.

Developed systems that met user requirements by performing system analysis and database design. Translated business requirements into technical requirements. Developed technical documentation. Performed code and report development to meet the user requirements.

Resolved issues effectively by providing supports in System Integration Testing, Business Integration Testing and Production.

Executed SQL queries to test back-end data validation of DB2 database tables based on business requirement.

Prepared and wrote complex, high-performance SQL statements.

Automated real-time system monitoring, designing, and developing scripting tools.

Debugged SQL and provided alternate ways to write SQL for DB performance improvements.

Use SQL Tools, Oracle SQL Developer tools to develop programs and execute the queries.

Verify expected system behavior after deployments to QA Environment.

Perform design and code fixes necessary to address defects observed in QA Environment.

Resolving the JIRA & ALM tickets on priority basis

Used Version Control tool GitHub.

Communicate with peers and supervisors routinely, document work, meetings, and decisions.

Work with multiple data sources.

Environment: Oracle 11g, SQL Tools, Snowflake, Jenkins, TOAD, SQL Developer, GITHUB, UNIX, JIRA, ALM, Windows, Snowflake, Redshift, SQL server, AWS, TALEND, GitLab and SQL

Well Care, Tampa, FL

PLSQL Developer – Dec’19 to Apr’20

Participated in detailed sessions with technical and business stakeholders to determine data and interoperability requirements.

Performed initial data migration, subsequent delta migrations and validated the data been converted.

Developed conceptual and logical representations of data and physical data models.

Wrote PL/SQL Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules

Tuned SQL queries to enhance performance, using Explain Plan both at backend and in Toad.

Performed the BAU and interact with client through email.

Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes – troubleshooting.

Scheduling the Batch jobs on Autosys PRODUCTION and TEST Servers according to the request of

the clients.

Environment: Oracle 11g, SQL Tools, PLSQL Developer, TFS, UNIX, Putty, Windows

Presbyterian Health Sciences, NM

PLSQL Developer – Jul’19 to Dec19

Analyze the business requirements of the project by studying the Business Requirement Specification document.

Create PLSQL Stored Procedures, Functions, Packages and Triggers to transfer the data from the Intermediary database to the main database.

Work on Query Optimization Techniques for complex SQL Statements that are running longer and provided solutions to make the process run faster.

Use Performance Monitor and Explain Plan for performance tuning to enhance the Performance of databases.

Use SQL Tools, Oracle SQL Developer tools to develop programs and executing the queries.

Worked on UNIX scripting ETL process on Oracle database.

Creating Reports of Batch Jobs using UNIX commands.

Resolving the JIRA tickets on priority basis

Used Version Control tools like Tortoise SVN

Environment: Oracle 11g, SQL Tools, SQL Developer, UNIX, Putty, Windows

Johnson&Johnson Skillman, NJ

PLSQL Developer – May’18 to Jul’19

Analyze the business requirements of the project by studying the Business Requirement Specification document.

Create PLSQL Stored Procedures, Functions, Packages and Triggers to transfer the data from the Intermediary database to the main database.

Create new object Schemas/metadata, indexes as part of new database creation.

Define ETL pipelines to migrate data from one database to other.

Perform exception handling for data that did not conform to the required format.

Work with front end application developers with their queries/stored procedures while building User-Interface for the project.

Work on Query Optimization Techniques for complex SQL Statements that are running longer and provided solutions to make the process run faster.

Use Performance Monitor and Explain Plan for performance tuning to enhance the Performance of databases.

Use TOAD, SQL Developer tools to develop programs and executing the queries.

Worked on UNIX scripting ETL process on Oracle database.

Responsible for primary development of testing strategies, Performs more complex analysis of business requirements and system specifications.

Verify expected system behavior after deployments to QA Environment.

Perform design and code fixes necessary to address defects observed in QA Environment.

Deploy software to development, staging/QA, and production environment as necessary.

Environment: Oracle 11g, SQL Developer, UNIX, Toad, Putty, Windows

PriceWaterHouse Coopers, Albany, NY

PLSQL Developer – Dec’17 to Apr’18

This project is the bridge for PWC tax applications where we import the trial balance, entity related data from GE. It classifies the entities and process the trail balance data which is consumed by the downstream applications.

Analyzed the business requirements of the project by studying the Business Requirement Specification document.

Created PLSQL Stored Procedures for analyzing the trial balance data.

Created new objects, indexes and DB links as part of process design for trial balance.

Wrote complex SQL queries using Joins, Sub queries and Group functions.

Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.

Tuned SQL queries to enhance performance, using Explain Plan both at backend and in Toad.

Performed the BAU and interact with client through email.

Environment: Oracle 12c, PLSQL Developer, SQL Developer, Toad, Windows

Goldman Sachs, SLC, UT

PLSQL Developer – Oct’16 to Dec’17

This project involved in active database development to support banking services for private wealth management division to support existing business requirements and creation of new databases and database development for client web uplift.

Analyzed the business requirements of the project by studying the Business Requirement Specification document.

Created PLSQL Stored Procedures, Functions, and Triggers to transfer the data from the intermediary database to the main database.

Created new object schemas/metadata, indexes as part of new database creation.

Defined ETL pipelines to migrate data from one database to other.

Created database objects tables, views, triggers, according to the requirement.

Wrote complex SQL queries using Joins, Sub queries and Group functions.

Performed exception handling for data that did not conform to the required format

Coded SQL Procedures, Functions and Packages for batch processing of the applications.

Worked on Query Optimization Techniques for complex SQL Statements that are running longer and provided solutions to make the process run faster.

Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.

Tuned SQL queries to enhance performance, using Explain Plan both at backend and in Toad.

Creating Reports of Batch Jobs using Unix commands.

Resolving the JIRA tickets on priority basis

Used Version Control tools like Tortoise SVN, CVS

Environment: Oracle 11g, SQL Developer, Toad, Edit Plus, T-SQL, UNIX, Windows XP, Putty

Wells Fargo, Winston Salem, NC

Oracle PL/SQL Developer – Apr’15 to Oct’16

This is a data warehousing project which involved with the data integration and Migration .The purpose of the project is to provide accurate, timely and reliable data to support different Line of Business.

Interacted with BA’s and the DBA’s to analyze the issues those were encountered while testing the applications.

Performed data validation between various systems and drive changes that ensure the integrity of data based on business rules and transformations.

Involved in reading and analyzing the data mapping documents.

Wrote SQL queries for generating various kinds of reports as per the usual requirement.

Debugged SQL and provided alternate ways to write SQL for DB performance improvements.

TOAD, SQL Developer tools were used to develop programs and executing the queries.

Extensively worked with Excel advanced commands for preparing and comparing the data.

Developed ETL’s for data extraction, Data mapping and Data Conversion using SQL, PL/SQL.

Written Test cases for compare source and target database systems.

Responsible for primary development of testing strategies. Performs more complex analysis of business requirements and system specifications.

Used the ALM tool to write the test cases and to track the defects.

Performed system testing, functional testing and Integration testing and the regression testing.

Environment: Oracle 10/11g, Toad, Edit Plus, SQL Plus, SQL, PL/SQL, UNIX,Windows XP, Putty, ALM 11.0

Loch Bridge, Detroit, MI

Oracle PL/SQL Developer – Oct’12 to Mar’15

Participated in detailed sessions with technical and business stakeholders to determine data and interoperability requirements.

Performed initial data migration, subsequent delta migrations and validated the data been converted.

Developed conceptual and logical representations of data and physical data models.

Wrote PL/SQL Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules

Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions

Created database objects tables, views, triggers, according to the requirement.

Created constraints on the tables for data validations and for maintaining the clear data without any issues.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files and vice versa using UTL_FILE package.

Loaded extensive data files into ORACLE using SQL LOADER, Created ORACLE EXTERNAL tables for search and processing.

Created database objects like tables, views, procedures, packages using Oracle tools like SQL developer, and TOAD.

Extensively used HTP and HTF package used to dynamically build webpage from PL/SQL

Developed stored packages with Oracle\'s Web Toolkit.

Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.

Wrote complex SQL queries using Joins, Sub queries and Group functions

Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.

Performed exception handling for data that did not conform to the required format.

Coded PL/SQL Procedures, Functions and Packages for batch processing of the applications.

Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes – troubleshooting.

Scheduling the Batch jobs on Autosys PRODUCTION and TEST Servers according to the request of

the clients using Unix Perl scripting and JIL .

Resolving the REDMINE and JIRA tickets on priority basis

Used Version Control tools like Tortoise SVN, Microsoft-TFS

Involved in unit, performance and integration testing of data stage jobs and prepared documentation.

Environment: UNIX, Oracle 11g, SQL Developer, Tortoise SVN, WINSCP, PUTTY, TOAD

Contact this candidate