Sql Developer

Email s.sriharipriya@gmail.

com

Phone 717-***-****

Work Authorization EAD

Sri HariPriya Sekar

Dedicated IT professional with exceptional database development experience

with excellent analytical, communication, interpersonal and leadership

skills

EXPERIENCE SUMMARY

Total: 7 yrs.

. Over 7 years of experience in Application Development using Oracle

9i/10g/11g, PL/SQL and Reports 6i/11g.

. Experienced in interacting with Business Users, Business Analyst, IT

Leads, Developers and System Analysts to gather and analyze business

requirements and translating requirements to functional and

technical design specifications.

. Strong Knowledge on Oracle Architecture and Database Design.

. Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.

. Experience in Database design using Normalization and E/R Diagrams.

. Rich experience in writing SQL Queries, Views, Materialized Views,

PL/SQL Procedures, Functions, Packages, Triggers, Cursors,

Collections, Ref Cursor, Cursor variables, System Reference Cursor,

Dynamic SQL, Exceptions.

. Experience in designing business requirements and modelling using

oracle designer.

. Experience in developing External Tables, Joins, Indexes and

sequences.

. Experience in query optimization, performance and tuning (PL/SQL)

using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds,

Bulk Collect, Creation of global temporary tables and table

partitioning.

. Extreme Use of Exception Handling methods along with

Pragma_Exception_init in order to associate our own created exception

names.

. Experience in using several built-in database packages such as

DBMS_JOB, DBMS_OUTPUT, UTL_MAIL, UTL_FILE, and DBMS_SQL to name a few.

. Experience in using DBMS_SCHEDULER to run jobs in parallel to improve

time-constrained performance.

. Have experience on archive platform that provides high performance and

highly scalable archiving support.

. Extensive experience in Performance Tuning (both SQL Tuning and PL/SQL

Tuning) using TKPROF, SQL_TRACE, TIMED_STATISTICS & Explain Plans,

DBMS_PROFILER.

. Expertise in loading data from legacy systems using SQL*Loader.

. Good knowledge in front end development using Oracle

Forms/Reports6i/9i/10g.

. Experience in Deploying Forms and Reports on the web.

. Experience in Developing Forms based on Views, Tables and Procedures

in tabular and form layouts.

. Experience in developing both Web Layout and Paper Lay out Reports in

various styles based on the user requirements.

. Extensively worked with third party database tools like TOAD & PL/SQL

Developer.

. Strong knowledge of Extraction Transformation and Loading (ETL)

processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.

. Good in creating users and maintaining their roles and

responsibilities.

. Experience in writing Technical Design Documents and Developing Unit

Test Documents.

. Experience working on different applications using UNIX shell-

scripting.

. Had working experience with .net and java developers.

. Had experience working and good understanding on jdbc and LINQ for

front end to back end connectivity.

. Had experience in front-end back-end web site development, website

conversion to java j2ee

. Good knowledge and experience working in Java using JDBC, HTML, XML.

. A Self-starter with a positive attitude, willingness to learn new

concepts and accept challenges.

. Involved in projects implemented using Waterfall and Agile process.

. Excellent Communication and strong Interpersonal skills.

CERTIFICATION

Certified in Oracle Certified Associate (OCA)

TECHNICAL SKILLS

Databases : Oracle 8i/9i/10g/11g.

Scripting : SQL, UNIX

Languages : SQL, Oracle PLSQL, SQL Loader, HTML, CORE JAVA, UNIX.

Tools : SQL Developer, TOAD, SQL plus, Win SCP, Putty

Applications : MS Office

OS : Windows 7, Windows Vista, XP, UNIX, Linux.

PROFESSION EXPERIENCE DETAILS

Client : The Nielsen Company

Project : NRSP Back End - New RMS Scanning Platform

Role : Oracle PL/SQL Application Developer Dec '12-Jul '14

Description:

To develop the right marketing and sales programs, and to help retailers to

understand their competitive positions and also integrates information from

a variety of sources to provide accurate, decision-ready reporting and

coverage of a broad array of retail channels.

Responsibilities:

. Creating complete end-to-end software solutions by developing,

testing, rolling out and supporting systems, reports and services

. Worked on design/ development of Customer Integration system.

. Developing program specs based on Functional specifications.

. Wrote procedures to import raw data into oracle database instead of

using SQL*Loader.

. Wrote procedures to extract data into excel/csv/dat/txt format for

interfacing.

. Wrote procedures to identify possible duplicate to staging table.

. Wrote procedures to load data from different tables for mapping table.

. Created the role level security for database and tables.

. Modified existing forms and reports, designed new forms and reports as

per business requirement.

. Extensively used of PL/SQL Stored Procedures, Functions, Triggers,

Cursors and Packages

. Creating SQL, PL/SQL database objects.

. Wrote Views, PL/SQL packages, procedures and function for processing

business logic in the database.

. Developed and modified a number of SQL, PL/SQL, stored procedures,

functions, packages and reports.

. Responsible for following up bugs reported by various users and

suggesting possible patches to be applied.

. Enhanced the performance of legacy PL/SQL packages by using Oracle 10g

new features like FORALL and BULK COLLECT.

. Written the Interface Stored Procedures for Data Transformation

. Used PL/SQL developer tools for faster application design and

developments

. Developed procedures using Dynamic SQL, UTL_FILE.

. Involved in Testing (Both Unit and Integration Level) and

Implementation.

. Tested the entire application in testing environment and exported to

Production.

. Wrote PL/SQL packages, procedures, triggers and function for

processing business logic in the database.

. Developed and modified a number of SQL, PL/SQL, stored procedures,

functions, packages and reports.

. Involved in Designing of Data Modelling the, Design Specifications and

to analyze Dependencies.

. Responsible for creating and maintaining the packages, stored

procedures, triggers functions and cursors.

. Involved in Unit level testing, Module level testing and System

testing.

. Involved in preparing functional specifications, release notes, &

documentation using MS-Office.

Environment:

Oracle 9i/10g/11g, SQL, PL/SQL, SQL*Loader,Pro*C, UNIX Shell script, MS

Access, TOAD, Oracle Forms 10g, Reports10g,Dollar Universe, Quality

Center,JAVA, Windows XP/2000, Clear Case,WinSCP,Putty, UNIX, Visio

Client : The Nielsen Company

Project : SIRVAL

Role : Oracle PL/SQL Developer Oct '10 to Dec '12

Description:

This project involves the validation of raw data using country channels and

implemented the performance tasks after analyzing the source data using

validation method with procedures, packages and functions

Responsibilities:

. Worked with the Business analysts and the DBA for requirements

gathering, business analysis, testing, metrics and project

coordination.

. Involved in designing ER diagram using oracle designer, to set the

logical and physical relationships of database.

. Developed Stored Procedures, Functions, Packages and SQL Scripts using

PL/SQL.

. Loaded the data into database tables using SQL*loader from text and

excel files.

. Developed data model, SQL Coding, SQL Query tuning process and

Schemas.

. Created SQL*plus reports as per client's various needs, and developed

business objects.

. Developed SQL Scripts, Packages and Procedures for Business rules

check to implement business rules.

. Used Bulk Collections, Indexes, and Materialized Views to improve the

query executions.

. Used Ref cursors and Collections for accessing complex data resulted

from joining of large number of tables in pl/sql blocks and even have

experience with exception handling.

. Automized routine jobs using DBMS_JOB. On completion of these jobs an

email will be sent out automatically with the help of UTL_MAIL.

. Developed SQL and PL/SQL scripts to transfer tables across the schemas

and databases.

. Data loaded from legacy systems (ETL Operations) using PL/SQL and

SQL*Loader.

. Developed custom Forms and Reports as per client requirements and

making them web enabled using Oracle Reports builder 6i and Oracle

Forms builder 6i respectively.

. Developed Procedures for efficient Error Handling process by capturing

errors into user managed tables.

. Using Swing Concepts in Java Front End Forms are designed.

. Using Oracle developer Database tools to write triggers and

procedures, Function.

. Archived many applications in the existing system and retrieval of

necessary data from them.

. Worked with java developers to repair and enhance current base of

PL/SQL packages to fix production issues and build new functionality

and improve processing time through code optimizations and indexes.

. Performed SQL and PL/SQL Performance tuning and Application Tuning

using various tools like TKPROF,

. AUTOTRACE and DBMS_SQLTUNE.

. Using perl script for database connectivity using DBI which connects

to backend database drivers.

. Developed UNIX Shell scripts to automate table creation, execute

procedures.

. Used ORACLE sql DEVELOPER for creating PL/SQL (trigger, sequence,

stored procedure).

Environment:

Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java.

PL/SQL Developer

Client : Citi Group

Project : AML CAMBRS 5 & CAMBRS 6 Optimization

Role : Oracle PL/SQL Developer Sep '09 to Sep '10

Description:

This project involves the optimization of already existing CAMBRS 5 &

CAMBRS 6 rules of AML and implemented the performance tuning techniques

after analyzing the source data using statistics methods.

Responsibilities:

. Involved in designing ER diagram using oracle designer, to set the

logical and physical relationships of database.

. Developed Stored Procedures, Functions, Packages and SQL Scripts using

PL/SQL.

. Loaded the data into database tables using SQL*loader from text and

excel files.

. Developed data model, SQL Coding, SQL Query tuning process and

Schemas.

. Worked with the Business analysts and the DBA for requirements

gathering, business analysis, testing, metrics and project

coordination.

. Migration of dbms jobs to control_M.

. Scheduling jobs in control_M and handling them.

. Used VSS and rational rose version control for changing the codes.

. Making changes to the existing apex applications in the production.

. Created SQL*plus reports as per client's various needs, and developed

business objects.

. Developed SQL Scripts, Packages and Procedures for Business rules

check to implement business rules.

. Used Bulk Collections, Indexes, and Materialized Views to improve the

query executions.

. Used Ref cursors and Collections for accessing complex data resulted

from joining of large number of tables in pl/sql blocks and even have

experience with exception handling.

. Automized routine jobs using DBMS_JOB. On completion of these jobs an

email will be sent out automatically with the help of UTL_MAIL.

. Developed SQL and PL/SQL scripts to transfer tables across the schemas

and databases.

. Data loaded from legacy systems (ETL Operations) using PL/SQL and

SQL*Loader.

. Developed Procedures for efficient Error Handling process by capturing

errors into user managed tables.

. Archived many applications in the existing system and retrieval of

necessary data from them.

. Worked with java developers to repair and enhance current base of

PL/SQL packages to fix production issues and build new functionality

and improve processing time through code optimizations and indexes.

. Performed SQL and PL/SQL Performance tuning and Application Tuning

using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.

. Developed UNIX Shell scripts to automate table creation, execute

procedures.

. Used ORACLE sql DEVELOPER for creating PL/SQL (trigger, sequence,

stored procedure).

Environment:

Oracle 9i/10g/11g, SQL, PL/SQL, SQL*Loader, Pro*C, UNIX, TOAD, WinSCP,

Putty, SQL Plus, Visual Source Safe, Pl/Sql developer, Windows 2000

Client : Citi Group

Project : EMEA & UK AML Rollout

Role : PL/SQL Developer Jan '09 to Sep '09

Description:

Implementation of AML product for EMEA & UK countries with new exception

rules. This system maintains information about transaction details,

customer's personal and professional details other important feature of

this application is that it keeps track of the details of customer

complaints and the concerned action taken. Check statements/alert

statements were designed using triggers, procedures and functions.

Responsibilities:

. Involved in analysis, Design, Development phases of the project.

. Designed ER diagram using Erwin, to set the logical and physical

relationships of database.

. Involved in walkthrough sessions with business users during Analysis

and Designing phase. Writing PL/SQL Stored Procedures, Functions, and

Packages to meet the business requirements.

. Involved in implementing the data integrity validation checks through

constraints and triggers.

. Extensive use of XML.

. Writing SQL reports and scheduling these reports from UNIX scripts.

. Created SQL*Loader control files for moving the data from flat files

to staging area tables.

. Worked on performance issues and used EXPLAIN PLAN for tuning the

queries

. Worked with Bulk Collections for bulk load processing. Involved in

code walk through and review sessions with the development team.

. Involved in the migration project to load data from mainframe systems

into oracle database.

. Involved in Troubleshooting Performance issues and bugs within

packages and stored procedures using dbms_output and Explain Plan.

. Performance of the queries is enhanced by executing optimization

techniques such as Index Creation, Table Partition and Coding Stored

Procedures.

. Involved in developing data conversion programs using SQL *Loader,

PL/SQL and UNIX Shell Scripts.

. Development of client side program units and sharing them among

multiple applications for processing business logic in the database.

Environment:

Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, PL/SQL Dev, UNIX Shell script,

Pro*C, TOAD, Java.

Client : Citi Group

Project : AML - Anti Money Laundering

Role : PL/SQL Developer Sep '07-Dec '08

Description:

AML Managed services deals with projects related to anti-money laundering

for different countries and regions. And AML services helps identifying the

money laundering activities via transactions performed and personal,

professional details of the customer.

Responsibilities:

. Creating SQL, PL/SQL database objects.

. Involved in data maintenance for static tables.

. Involved in preparing test datas for testing.

. Worked on checking log files on UNIX while working on support for

production environment.

. Worked in SQL Loader for loading data from various sources like flat

file, excel etc. into tables.

. Involved in developing PRO*C batch programs.

. Involved in Database Design and Analysis.

. Analyzed and Created Partitions on the tables to improve the

performance and enhance parallel processing.

. Design and Developed data validation, load processes using PL/SQL,

Stored Procedures, Functions, and Triggers using Oracle 9i.

. Created Control Files and used SQL* Loader to upload bulk data into

database from external files.

. Actively involved in Production Support by Performing Tests, Trouble

Shooting and Bug Fixing.

. Involved in formulating general methodologies, naming conventions and

coding standards for various procedures and packages

. Involved in Code Standardization and Documentation.

. Involved in Logical and Physical Database design and identified the

tables and relationship between tables.

. Used for all and bulk collect to fetch large volumes of data in PL/SQL

objects.

. Involved in database Performance Tuning and monitoring.

. Designed Report output formats, complex filtering and formula

calculations, as well as the rendering of multi-band and multi-grouped

reports.

. Developed complex triggers in reports before/after for validation of

user input.

. Coordinated between management, users and technical teams for

Requirement Gathering

. Involved in various activities like preparation of Technical

Documentation, Client discussions for purposed solution and User

Acceptance Testing.

Environment:

Oracle 9i/10g, PL /SQL Dev, SQL Loader, Pro*C, SQL.

Education:

Bachelor's in Computer Science Engineering

Contact this candidate