Yerra K Rao

Senior Analyst Programmer

Summary

  • Client-focused Senior Oracle developer with 7+ years of Oracle  10g/11g Pl/Sql development with UNIX shell scripting.
  • Good Experience in performance tuning using explain plan, TkProof and DBMS_PROFILER and Oracle supplied HINTS and partions like range, list, hash, parallel, index.
  • Advanced and complex query writing with best optimizer methods.
  • Good exposure on various joining methods like HASH_JOIN, MERGE_JOIN and NESTED_LOOP JOIN.
  • Extensive exposure on designing the procedures, functions, packages and triggers (compound triggers with follows clause).
  • Extensive exposure on Cursors, bulk collections and bulk binding with SAVE Exceptions.
  • Sound exposure on exception handling with user defined, predefined and PRAGMA exceptions.
  • Good exposure on pragma directives like PRGMA AUTONOMOUS, PRAGMA RESTRICT_REFERENCES, SERIALLY RE-USABLE etc.
  • Sound exposure on Oracle Analytical functions like RANK, DENSE_RANK, LISTAGG, REGEXP_LIKE().
  • Good exposure on materialized views with different refresh options and refresh modes.
  • Good exposure on Oracle Architecture with different back ground processes and files
  • Good updatable knowledge on Oracle 12C developer track.
  • Mentored a team of 4 members in the design and development phases.
  • Accomplished as "An Outstanding Contributor" from the customer Bank of America in 2013.


TECHNICAL SKILLS

Skills
10
Programming Languages
Oracle 11g Pl/Sql, Oracle 11g Sql, C++ Unix Scripting Java/J2EE
10
Utilities/Third Party tools
SQL * Loader, External Tables, TkProof, Auto Trace, Toad, SQL * Developer
8
Reporting Tools/Scheduling Tools
Crystal Reports, Autosys, Ctrl-M.
10
Commercial Databases
Oracle 10g, 11g and 12C, MS- SQL Server 2012.

Education

Education

Work History

Work History
Jul 2014 - Jan 2015

Senior Analyst Programmer ::: Oracle 11g Pl/Sql, Sql, ERWIN, Toad, Autosys, SVN, Unix Scripting, Crystal Reports.

Citi Bank, UK
  • Done the database performance Tuning using Explain plan, TkProof and DBMS_PROFILER and SQL_TUNE_Advisor.
  • Monitored the database activities and grant privileges to different users.
  • Good Experience on DBMS_JOB, DBMS_UTILITY, UTL_FILE, DBMS_PIPE, and DBMS_STATS.
  • Developed database triggers, Compound Triggers, Packages, Functions and Procedures.
  • Designed on Inner Joins, Outer Joins, Self Joins, Cross Joins and Analytical functions like RANK, DENSE_RANK and LISTAGG().
  • Loaded the data using SQL Loader conventional path and direct path.
  • Developed Oracle Cursors - Implicit and Explicit cursors with ref cursor. Developed Indexes like B-Tree Index, Bit-Map Index, and Function-Based Index.
  • Designed views and materialized view with different refresh options and refresh modes to ease the network loads.
  • Used PRAGMA autonomous transaction to differentiate the child transaction and parent transaction.
  • Mentored the junior programmers in the DB development and participated in their code reviews.
  • Involved in Data Model designing using ER Win.  
  • Handled the different types of exception in the Pl/Sql code and prepared the unit testing plans.
  • Schedule and monitored the back ground jobs at various time intervals using autosys scheduler.
  • Processed the bulk records with bulk collection and bulk binding with SAVE exceptions.
    Designed complex and best performance queries.
  • Prepared the Unit Testing Plans according to the customer requirements.
  • Mentored the team of a 4 members in the design/development phase and code review has done.
  • Gathered the table level statistics using DBMS_Stats and handled e-mail activities using UTL_MAIL package.
  • Involved in the functional design documents like LLD and HLD.

     
Feb 2013 - May 2014

Senior Oracle Developer ::: Oracle 11g Pl/Sql, Sql, ERWIN, Toad, Autosys, SVN, Unix Scripting, Crystal Reports.

Amazon, UK
  • Involved in the design phase of the main architecture the project EAAA.
  • Designed Pl/Sql entities like compound triggers and instead of trigger.
  • Designed Pl/Sql tables, Bulk Collections and Bulk Binding mechanisms with SAVE Exceptions.
  • Handled many exceptions and Pragma directives.
  • Identifying and tuning costly queries, and tuning with minimal response time.
  • Done the reports using Actuate tool.
  • Designed the Oracle entities like stored procedures, functions and Triggers to meet new features.
  • Code Review and creating the packages for standalone procedures and functions and for ref cursors.
  • Coordination wide variety of people including, business users and implementation teams.
  • Scheduled the jobs using Autosys scheduler to run once-a-day a complex package.
  • Designed and customized the reports using crystal reposts with various styles like mailing label, form style.
  • Extensively designed the packages with minimal response time of the oracle engine with best and efficient execution plans.
  • Handled critical failures in the production in efficient manner.
  • Published the designed reports online according to the customer requirements.
  • Developed the control files to load various sales data into the system via SQL*Loader.
  • Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time.
  • Designed the UNIX shell scripts according to the customer requirements.
  • Object over loading has been done with the help of the user defined packages to re usability of the database objects.
  • Granted different types of roles and privileges to other users and done the cold back up and hot back up.
Aug 2010 - Jan 2013

Senior Analyst ::: Oracle 11g, Oracle Pl/Sql, SQL, Toad, Unix, Autosys, SVN, ERWIN and TkProof and Oracle DBA.

Bank of America, UK
  • Acted as the POC for the ECS application offshore development/design Oracle team.
  • The Responsibilities included in understanding the Issue by having conversation with Business users and owners.
  • Coordinates/ facilitates transition (planning, sign-off, team meetings, and escalations).
  • Coordination wide variety of people including, business users and implementation teams.
  • Designed Compound Triggers and packages with procedures and functions
  • Designed Pl/Sql tables, Bulk Collections and Bulk Binding mechanisms
  • Handled many exceptions and Pragma directives
  • Involvement in Production Change Management & Release Coordination.
  • Identifying and tuning costly queries, and tuning.
  • Involved in the functional design documents like LLDs and HLDs.
  • Mentored the junior programmers in Oracle database design and development
  • Troubleshooting for the end users requirement and Optimizing Queries
  • Developed UNIX shell scripts to invoke the SQL * Loader to load the data from flat file to tables using direct path loading.
  • Scheduled the background jobs using Autosys job scheduler.
  • Extensive performance tuning for the Individual queries and user defined packages.
  • Created complex and efficient queries with minimal response time.
  • RMAN data backup techniques used in an application.
Mar 2009 - Apr 2010

Senior Oracle Developer ::: Oracle 11g, Oracle Pl/Sql, SQL, Toad, Unix, Ctrl-M, TkProof, Remedy and Oracle DBA.

British Telecom, UK
  • Loading the data using SQL * Loader.
  • Prepared the Unit Testing plans according to the customer standards.
  • Prepared the Oracle components like functions, procedures and packages
  • Created the complex queries to retrieve the data .
  • Handled the exceptions and bugs in the plsql coding.
  • Involved in the client meetings and review schedules.
  • Prepared the invoices according the customer requirements using the Crystal Reports.
  • Done the performance tuning using DBMS_PROFILER package with proftab and profload tables.

Oct 2006 - Feb 2009

Senior Software Engineer ::: Oracle 11g, Oracle Pl/Sql, SQL, Toad, Unix,Remedy,SVN, Toad.

Astra Zeneca, UK
  • Created advanced and complex queries.
  • Involved in the project reviews and client meetings to update the status.
  • Extensively designed Oracle Pl/Sql packages.
  • Prepared the Unit Testing plans according to the customer standards and requirements.
  • Job scheduling done by DBMS_JOB and Crontab in UNIX.
  • Source Control System SVN to repository the designed documents and code.
  • Developed standalone procedures and functions, triggers as well.
  • Loading the data using SQL * Loader in direct path method.
  • Production database performance monitoring and acting accordingly.
  • Troubleshooting for the end users requirement and optimizing queries.