Kanchanadevi Raju

513-***-****

acemzs@r.postjobfree.com

Professional Summary

. Around 7 years of experience in development, analysis, implementation,

upgradation of different telecom, retail applications.

. Experience in full life cycle project development, including design,

coding, testing and implementation and on-going application support.

. Extensive experience in writing Oracle PL/SQL Packages, Procedures,

Functions, Database Triggers and SQL queries.

. Experience in writing complex SQL queries, Tuning SQL queries.

. Experience in using Cursor, Ref Cursor, and dynamic SQL Queries.

. Experience in writing synchronized complex SQL queries.

. Worked on developing various data extracts and loading routine using SQL

loader

. Have experience in using Toad.

. Performance tuning of the application, reduction in the number of loops

and code optimization.

. Experience in SQL tuning, PL/SQL tuning and Application tuning using

various tools like TKPROF, EXPLAIN PLAN, DBMS_PROFILER etc.

. Interacted with Customers for requirement gathering and effective

analysis.

. Scheduled jobs in project based mainframe system

. Worked on project documentation, handholding for each module of the

application.

. Worked on Agile methodology

. Acted as New Operating Model champion in Telecom Domain.

. Created Stats tool in C#.Net for preparing monthly reports in Excel

application.

. Good knowledge/understanding of new features of ORACLE 11g.

. Worked on UNIX shell scripting.

. Used Exception handling for validation of input and the ease of debugging

and displaying the error messages in the application.

. Possessing strong hands-on background in supporting production

environments and meeting customer needs

. Performed unit testing and integration testing.

. Involved in Production Support, Problem resolutions and Bug fixing.

. Proven ability to work efficiently in both independent and team work

environments.

. Highly organized and efficient to prioritize and manage multiple tasks.

Technical Skills

Operating Windows 7 / 2000 / NT / XP, LINUX

Systems

Scripting Oracle SQL, PL/SQL, T-SQL and UNIX - Shell

Scripting

Databases Oracle 11g/10g/9i, MS-SQL Server 2000/2005,

MS Access

Query Tools TOAD, PLSQL Developer, SQL*Loader

Languages Visual Basic 6, ASP, C#.Net, C, C++, JAVA,

HTML

Tools Attachmate Extra! Client, Clarify Clear

Support Client

Certifications

MCTS: .NET Framework 2.0 Web Applications Certification

Lean Six Sigma - Green Belt

Oracle Warehouse Builder 10g

IBM Certified Database Associate - DB2 Universal Database (DB2 UDB) V8.1

Family - Test 700

Oracle Certified Associate (OCA-Level -2)

Oracle Certified Associate (OCA-Level -1)

PROFESSIONAL EXPERIENCE

1 Wellsfargo, Minnesota MN,

Jul-2013 to till date

. Sr Oracle PL/SQL Developer

Role and Responsibilities

. Developed Triggers, Procedures, Functions and Packages.

. Involved in writing Unix Shell Scripts

. Worked on Performance tuning and optimization of Database Queries and

Procedures.

. Deploying the Code in Production server.

. Delivering anonymous PL/SQL block to support team.

. Performed audits and System testing.

. Involved in writing complex queries to generate reports as per client

request as a part of production Support

. Modified the existing code to use Automatic Subprogram Inlining to

improve the performance.

. Loading and moving the data between different database tables using SQL

Loader

. Wrote Unit test plans and test cases.

. Developed ER Diagrams, Data flow diagrams based on the requirement.

. Used FOR ALL and BULK COLLECT to fetch large volumes of data from table.

. Performed unit testing and supported integration testing and end user

testing.

. Extensively worked on production issues with effective defect management.

. Involved in logical and physical database design, Identified Fact Tables,

Transaction Tables.

. Involved in SQL tuning, PL/SQL tuning and Application tuning using

various tools like TKPROF, EXPLAIN PLAN, DBMS_PROFILER etc.

Solution Environment : Visual Basic 6, Oracle 11g, TOAD,SQL Loader,

PL/SQL developer, UNIX, Windows 7

2 The Nielsen Company, USA,

Jan-2012 to Apr-2013

. Sr Oracle Developer

Description

. Enhancement of DCES application.

Role and Responsibilities

. Worked with team in full project life cycle implementation (requirement

gathering to production).

. Having discussion with team on the requirements on daily basis and

coordinating other developers.

. Worked in writing Oracle PL/SQL Packages, Procedures, Functions, Database

Triggers and SQL queries.

. Developed PL/SQL blocks using Cursor, Ref Cursor, dynamic SQL Queries.

. Developed synchronized complex SQL queries.

. Preparing necessary documents like LLD, HLD and getting approval from

client before development.

. Developed various data extracts and loading routine using SQL loader

. Having review call with client during development phase.

. Conducting testing and installing the program into production and

reacting to problems and correcting the program as necessary;

. Optimizing the stored procedure to improve the performance of the

application.

. Coordinate with other developers and software professionals.

Solution Environment : Visual Basic 6, Oracle 11g,TOAD, Windows 7

British Telecom, UK,

Apr-2010 to Dec-2011

Sr Oracle Developer

Description

. Fast-Track is aiming to support for the majority of the applications with

an offshore strategic partner abiding to the Service Level agreements.

. Most systems are designated as 'Tactical Interfaces' (TIs) or 'Robotics'

and were designed to fill gaps in BTs system infrastructure in the

absence of or whilst waiting for, a strategic solution.

. These systems reside on local PC hardware and interact with legacy 'host'

BT systems such as CSS via a screen scraping method.

Role and Responsibilities

. Provide 2nd line support (Accept the problem, Liaise with customers and

necessary groups to resolve the problem and close the BRIDGE case once

the problem is solved)

. Provide 3rd line support (problems that needs code fix are first analysed

for the impact and then the required code changes are carried out for

applications or forwarded to development team)

. Developed Oracle PL/SQL Packages, Procedures, Functions, Database

Triggers and SQL queries.

. Worked in performance tuning of the application, reduction in the number

of loops and code optimization.

. Used Exception handling for validation of input and the ease of debugging

and displaying the error messages in the application.

. Experience in interpreting Trace file Reports (TKPROF reports) and

performance tuning.

. Interacted with Customers for requirement gathering and effective

analysis.

. Involved in development of applications in VB.

. Enhancements are made based on Agile methodology

. Developed automation tools which are used in management work & reduce lot

of manual efforts involved.

. Worked on project documentation, handholding for each module of the

application.

. Responsibility of Logging errors, messages on errors etc.

. Involved in Production Support, Problem resolutions and Bug fixing.

. Responsibility that the code is placed in the VSS or server and labelled

as necessary

. Update the management about the tasks, status and problems if any that

arises

. Acted as New Operating Model champion.

. Responsibility to protect the privacy of the client's data if any.

Solution Environment : Visual Basic 6, SQL Server, Oracle 10g,SQL LOADER,

TOAD, MS Access, ASP, Java Script, Windows 2003

Tools : Clarify Client (Ticket/Fault Management tool), Extra! Client (GUI

browser for mainframes)

British Telecom, UK,

Jan-2007 to Apr-2010

Oracle Developer

Description

Revenue Assurance involves cutting revenue leakages for BT and its

Customers by customer data alignment. Customer data alignment is the

process of assuring the correctness and completeness of the customer

records between CSS and exchanges. The process involves getting data from

switches like System X and Axe-10; cleanse the data, converting the data in

to required format by using a formatting application. The discrepancies

between switches and CSS (Customer Subsystem) have to be located and

updated in the both.

Role and Responsibilities

. Scheduled Jobs in project related mainframe system, for getting data from

system, finding discrepancies...

. Found RCA and done code fixes for long standing errors occurred in

project cycles;

. Developed new Oracle PL/SQL blocks and modified existing blocks.

. Used Exception handling for validation of input and the ease of debugging

and displaying the error messages in the application.

. Gathered requirement data from client for development, analysed entire

system for impact and enhanced the system;

. Combining all elements of the program design and testing it, testing

sample data-sets to check that output from the program works as intended

. Conducting testing and installing the program into production and

reacting to problems and correcting the program as necessary;

. Adapting the program to new requirements, as necessary

. Conducting user acceptance testing to ensure the program can be used

easily, quickly and accurately;

. Writing detailed documentation for the operation of the program by users

and computer operators;

. Worked on UNIX shell scripting.

. Consulting manuals and technical reports to learn new ways to develop

programs and maintain existing skills and knowledge;

. Involved in Production Support, Problem resolutions and Bug fixing.

. Worked on Agile methodology

. Created Stats tool in C#.Net for preparing monthly reports that minimized

manual effort.

Solution Environment : Visual Basic 6, Oracle 9i, TOAD, MS Access,

Windows 2003

Tools : Extra! Client (GUI browser for mainframes), Project Related tools

like Crusader, Exchconv

Contact this candidate