Gayathri Perni – 571-***-**** mailto:ad2chv@r.postjobfree.com

PROFESSIONAL SUMMARY

Having 10+ years of analysis, design and development experience in the IT industry.

Strong Experience in Interface programs to import data from legacy systems and excellent skills in writing pl/sql stored procedures, functions and Packages.

Excellent skills in Application Development using Oracle 8i/9i, 10g, 11g, 12c and Developer Suite 10g.

Design and Generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages, Database Triggers and External Tables.

Strong knowledge in Oracle Cursor management, Exception Handling and also Experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints and Optimizing the oralcle reports

Expertise skills in using the tools TOAD 12.8, Sql * Loader, Oracle Sql Developer and Oracle utilities like DBMS_PIPE,UTL_FILE,Exp,Imp and Data pump and also Experience in Perl and UNIX Shell Scripting.

Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Handled Production issues with high pace and efficiency. Optimized existing queries for better performance and less impact on database.

Used Materialized views in places where the data does not change very frequently and Good understanding of the star schema.

Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.

Involved in the design of the front end applications forms 6i/9i, Reports 6i/10g and Database objects.

Used Ref cursors and Collections, Bulk Collect and Bulk Binding for accessing huge volume of data.

Experience in core java Technologies like multithreading, collections and exception handling mechanisms.

Worked with the users to identify the business requirements and integrated them into the front end Applications and CO-Coordinating the Off shore team.

A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

ACADEMIC QUALIFICATION

Masters Degree in Computers

Bachelors in Computer Science

TECHNICAL SKILLS

Data Base : Oracle 12c,11g,10g, 9i, 8i, 7.x, MS Access and SQL Server 2000,2005.

Operating Systems : UNIX, Solaris 10, Windows 95/98/2000/XP/Vista.

Data Base Tools : iSQL *Plus, Toad 9.5, OWB (Oracle Warehouse Builder), Erwin 7.2,

Sql *loader, Sql Navigator,Proc*c.

Utilities : UTL_FILE, DBMS_PIPE, Exp, Imp and Data pump.

GUI Tools : Oracle Developer Suites 10g, Forms 9i, 6i, 4.5 and Reports 6i, 2.5,Apex,Tabaleu

Languages : SQL, PL/SQL, C, C++, JAVA and Perl, Shell Scripting

Internet Technologies: Java Script, HTML and XML.

PROFESSIONAL EXPERIENCE

Client : JPMChase, COLUMBUS, OH.

Environment : Oracle 11g (SQL, PL/SQL), TOAD 12.8,DB2, SQL Developer, APEX, UNIX,JAVA, shell scripting.

Duration : Aug 2013 to Till date.

Role : Senior PL/SQL Developer.

Responsibilities:

I contributed to the build and delivery in 6 months of a new Escrow paperless communication for home lending clients that receive their statements digitally. I wrote code for the send email capability that required taking the existing Email send repository and making code additions and changes enable consumption of our HTML email template and creation of events for Email send, email failed and bounce back, email storage and archiving capability.

As part of the home lending team, I adapted to a shift in technologies, learned the In-house letter building software Infosource, and statement generation software (GMC and Open text) and have become a contributing member of the team on multiple projects.

Involved in Gathering end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.

Composed user requirement documents, created technical specs and design documents for various projects.

Generated complex SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.

Involved in TECH refresh projects and worked with DBA team, Web Admins in order to migrate database and application connections.

Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.

Written packages, triggers, stored procedure and functions for the following modules products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.

Utilized object-oriented programming and Java for creating business logic.

PL/SQL coding for Exception Handling and duplicate data maintenance.

Used Triggers in Customizing Error conditions.

Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.

Programming using PL/SQL stored procedures, triggers, views, user-defined functions

Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.

Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in PL/SQL packages.

Used event handlers for event handling which includes on preexecute, post execute and error.

Involved in package logging in both standard and custom logging using customer stored procedure and tables.

Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views.

Created adhoc reports more often based on end user requirements export them in Excel.

Performed daily DBA activities, security assignment, user setup, backup, restore.

Generated and formatted reports using global variables, expressions and functions.

Involved in developing parameterized reports using single values, multi values and cascading parameters.

Worked with various charting JavaScript libraries to display visual data on the dashboard

Expertise in Client Side designing and validations using HTML, DHTML and JavaScript.

Client : AEP, COLUMBUS, OH.

Environment : Oracle 11g (SQL, PL/SQL), TOAD 9.5, SQL Developer, SQL Server Management Studio, UNIX shell scripting.

Duration : Aug 2012 to Aug 2013.

Role : Senior PL/SQL Developer.

Responsibilities:

The objective this project is used to bring up the CashLynk Authorization Engine.

Validated all the stored procedures which is migrated from sql server 2005 to oracle 10g around 1400 procedures,convert them into pl/sql packages and Troubleshooted performance issues and bugs within procedures and functions using Exception Handling. Optimized the performance by using the performance enhancing tools like bulk binds, optimizer hints and SQL Trace.

Developed procedure to updates the cardholder paid Trxs and Auth fees field in the MirrorAccount table.

Developed stored procedure returns summary deposit information for the given Date Range and ClientID or ProgramID and return pending pre auths for a cardpan throw REF cursor variable.

Implemented PL/SQL packages to perform Application Security and batch job scheduling.

Developed and maintained the ETL process for the CashLynk Authorization Engine involving 6million+ transactions.

Developed SQL *Loader control scripts to load data from multiple data files into Cashlynk staging database tables.

Developed Database Triggers to audit the sensitive data of the table along with account information and to enforce complex business rules.

Wrote Procedures and database triggers for the validation of input data and to implement business rules.

Worked closely with the business intelligence team on existing project modules to identify where improvements needed to be made in order to support new requirements and/or more efficiently support existing functionality.

Client : ADESA, Carmel, Indianapolis.

Environment : ORACLE 10g (SQL, PL/SQL), SQL*Loader, PL/SQL Developer, UNIX shell scripts.

Duration : Jan 2012 to Aug 2012.

Role : Senior Oracle Developer.

Description: ADESA is a leading provider of vehicle remarketing services and has a full range of auction, reconditioning, logistical and related services. Data is periodically received from various methods of transmission and it is from these raw data feeds that the Oracle structures are populated. The process of taking the raw data in whatever format it is transmitted and Extracting, Transforming and Loading it into the Oracle structures accessed by the application is referred to generally as Publishing i.e., moving the raw data into a form visible by the application and to its users.

Responsibilities:

Requirements gathering from the existing applications and end users and work with the Architects and Tech Leads for architecting the product as per the business requirements

Creating data mapping documents and business rule documents from source to target. Creating technical design documents based on requirements from user cases and mapping documents for data migration.

Coding (Oracle, PL/SQL, Advanced SQL), Unit testing the application on Oracle 11g database.

Suggest and implement various technical and performance improvements in the system.

Rewrite the existing old PL/SQL packages into new oracle 11g database and utilize new features to improve the current application performance.

Extensively used TKPROF, EXPLAIN PLAN get the statistical data for the performance tuning of the SQL queries and stored procedures.

Created Tables, Views and Materialized Views. Indexing wherever required for enhancing the performance of the current application.

Created several external tables for the regular feed for application.

Created/Modified UNIX scripts as needed for the current production system.

Production support for the current application and fix/rewrite the PL/SQL code if any ticket assign from users.

Client : JPMChase, Columbus, OH.

Environment : Oracle 10g, 11g (SQL, PL/SQL), TOAD 10.6, UNIX scripting.

Duration : Jun 2011 to Jan 2012.

Role : Senior Oracle Developer

Description: An integrated suite of functionality to support Pricing Events will be created by inventorying the current toolset and data components, automated or manual. Data will be modeled into a single repository to support integral data relationships and remove redundancy with standard normalization practices. Current toolset functionality and data will be reused wherever possible and architected into the target business process for Pricing Events. New functionality will be created to fill gaps. The new suite will allow users to see the impact of pricing changes in real time. Price Event Integration project consolidates four applications currently used for Pricing Events into one application. This application will allow for a more efficient and streamline Price Event to reduce the timeline significantly.

Responsibilities:

Developed several PL/SQL Packages, procedures, functions to facilitate business logic and calculations.

Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using TOAD 10.6.

Developed Custom Triggers, Stored Procedures, Packages and SQL Scripts and Prepared explain plan for the long running queries and created Indexes to improve overall system performance.

Utilized tools such as SQL*Loader to load data from CIS (Customer Information System) flat files in to the pricing database tables.

Involved in logical, physical database design utilized pl/sql advanced features to improve overall application performance.

I have tuned several long running pl/sql stored procedures, functions and package and sql queries by using EXPLAIN PLAN, tkproof and DBMS_PROFILLER.

I have developed export package to generate flat files in the oracle specified export directory to feed outbound pricing mainframe systems by using UTL_FILE package.

Extensively used cursors, user-defined object types, records, pl/sql tables and dynamic sql to generate runtime queries for the REF CURSORS.

Extensively used database triggers for adding various default functionality, like database and non-database methods of running totals, sequence generation in the custom axapplication.

Developed several table functions to generate user defined look up data.

Created indexes to large tables for tuning and modified SQL queries utilizing indexes for better performance.

Worked closely with the users and developed the user-interface applications and database reports according to UC (User Cases).

Analyzing the bugs reported by users, fixing and migrating code to UAT and documenting the changes made to original code.

Involved in preparing the test cases and testing of applications to achieve end user satisfaction.

Designed several User documents and Developed Mapping application by using oracle developer suite 10g .The Forms are like administrator, approver, Business requirements, mapping and Reporting screens. Developer several reports for the Business analysts.

Interacted with Business Analysts and client representatives in doing research and solving client specific data issues.

Performed Unit testing on queries. Run on the UNIX by writing UNIX shell scripting.

Involved in preparing the test cases and testing of applications to achieve end user satisfaction.

References

References available upon request for last two/three companies

Contact this candidate