Revathi S Rajashekara aduk6r@r.postjobfree.com

+1-848-***-****

Professional Summary

** ***** ** ********** **** expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment.

Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing.

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.

Feasibility study, planning, implementation, testing and deployment.

Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL*Loader.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Firsthand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication.

Good Knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, SQL profiling and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan.

Strong database skills, Object Oriented Programming and development knowledge.

I am self-motivated, quick learner and a team player.

I have completed SAFe 4 certification.

Recognized in the IBMer Appreciation program for the practice Listen for Need, Envision the Future.

Recognized in the Manager’s Choice Award - program for the practice Put the Client First.

Recognized in the Manager’s Choice Award - program for the practice Share Expertise.

Skill Set

Oracle 12c/11g/10g, SQL, PL/SQL, Oracle GoldenGate 11gR2/12c data replication. *Loader, SQL*Plus, XML, TOAD, Explain Plan, Execution Plan, SQL Developer, Git, SVN, SCME (AT&T version control tool) MS Visio, Windows, Red Hat Linux.

Education

B.E in Electronics and communication from Visvesvaraya Technological University, Belgaum, India.

Professional Experience

Client: AT&T

Oracle PL/SQL Developer January 2013-Till date

(Worked in India from January 2013 – January 2016 and Worked in US from February 2016 – till date)

Project 1: ADOPT - AT&T Design Automation and Pricing Tool.

ADOPT (AT&T Design Automation and Pricing Tool) is a Design Pricing and Proposal tool used in AT&T for complex services like Managed Information System (MIS), AVPN (AT&T AVPN) and Unified Communications (UC).

Project 2: Pricer-D

Pricer-D is a Design Pricing and Proposal tool used in AT&T for complex services.

I have worked as Subject Matter Expert in for below mentioned offers in telecom domain for ATT Client:

Gamma/ASEoD/SDN Ethernet, ASENOD, NFOD, ADI Express, FBB Express, VVB Express, ADIVB, AVPN Express.

Roles and Responsibilities:

As an Application Developer - analyze the scope of the new feature being requested by the client from a system & technical perspective; provide architectural level changes / impacts for the new feature. Come up with the feasibility of the of the feature, a potential architecture for the system from the customer about the integration with new Sales and Ordering System that will provide End to End Sales, Ordering & Billing capabilities that works across the product and services provided by the critical application. This task needs more specialized knowledge in creation of process models, services, automation of business models and end to end architecture creation which in terms requires deep specialized knowledge in IBM proprietary tools.

Responsible to write Oracle PLSQL code to UI application which is built using Java and Oracle ADF.

Responsible to deliver complex PLSQL procedures, functions, Triggers to UI application.

Worked on SQL*Loader to load data from flat files.

Involved in the continuous enhancements and fixing of production problems. Generated PL/SQL code for business logic.

Created scripts to create new tables, views, queries, Materialized views, procedures and packages using Oracle tools like TOAD, PL/SQL Developer and SQL*plus for new enhancement in the application using TOAD.

Developed and Optimized Contractor Management package making use of Bulk Collect and Bulk Insert features in PL/SQL.

Involved in one-way, two-way/bi-directional data replication using Oracle Golden Gate.

Manage all aspects of the OCG design, Implement and support in development, AT and production environments.

Identify and resolve OCG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).

Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.

Created Indexes on the tables for faster retrieval of the data to enhance query performance.

Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.

Performed SQL and PL/SQL tuning and application tuning using EXPLAIN PLAN and SQL*Trace.

Responsible in ensuring all the issues, risks are resolved in time, escalate to appropriate higher management in case of very propagating risks. Also ensure to have mitigation plan for any issues/risks, track the plan and close.

Identify the Technical Dependencies and Risks involved in the implementation of a Feature Project and provide a mitigation plan.

Communicate risks and dependencies to Project Management.

Work with developers and testers in converting the High-Level Design to working code.

Own overall solution for the features being developed.

Perform a feasibility study as well as impact analysis for new features as well as change requests.

Guiding and mentoring team members in project related technical implementations and acquainting them with the new processes and tools implemented in IBM.

Tracking and reviewing project deliverables within the team and communicate the risks and issues to higher management.

Help team members in resolving schedules, project related issues.

Performing Root Cause Analysis for system defects.

Environment: Oracle 11g, Oracle 12c, PL/SQL, TOAD, SQL*Loader, Unix Shell scripts, Web Logic, Oracle ADF, JDeveloper.

Contact this candidate