Sql Data

Kiran Yarlagadda

PH:732-***-****

E mail: ***********@*******.***

SUMMARY:

Around 8 years of experience in all the phases of software development

life cycle. Hands on experience include developing applications. Expertise

in Oracle 10G/9i/8i, C, SQL, PL/SQL, Oracle Forms 10g/9i/6i/4.5,

Reports10g/ 9i/6i/4.5 and UNIX shell scripting (PERL, KORN)

. Experience in application software analysis, design, development,

implementation, maintenance, and documentation of commercial

applications through out various phases of project life cycle.

. Interacting with Business users, gathering and analyzing requirements.

. Proficient in Oracle Database design with relational models and very

good experience in entity and attribute identification and developing

the Entity-Relationships.

. Writing complex SQL queries and PL/SQL procedures to extract data from

various source tables.

. Extensive experience in development of Stored Procedures, Functions,

Packages and Triggers.

. Loading data from flat files into database tables using SQL*Loader and

UTL_FILE.

. Automating data loading, extraction, reports generation using UNIX

Shell scripting.

. Involved in Forms Migration from 6i to 9i using Migration Assistant

Tool.

. Proficient with GUI development using Oracle Forms and Reports

Developer/2000

. Developed Form and Reports using Oracle Forms 10g/9i/6i/4.5, Reports

10g/9i/6i/4.5.

. For optimization process actively involved in capacity planning,

creating views, materialized views, partitioning tables and creating

indexes etc.

. Involved in query tuning using Parallel Hints, Explain plan and

TKPROF.

. Developed Data Mapping and Data Conversion scripts using SQL, PL/SQL.

. Developed custom models, packages and scenarios using Oracle Data

Integrator (ODI) for bulk data transfer between two databases.

. Involved in developing, testing, and deploying ETL solutions.

. Written complex SQL's using joins, sub queries and correlated sub

queries.

. Experience in design, analysis, coding, development, testing and

maintenance of Oracle applications (AP, AR, GL, PO, CM, FA, PA, OM,

BOM, INV, AOL and SYSADMIN).

. Experience in generating adhoc query reporting using Discoverer 4i.

. Experience on Oracle Financials 11i data structure,Jdeveloper and

sysadmin module

. Experience in requirement analysis, client interaction, system design,

development testing, security, documentation and implementation with

extensive coding standards.

. Knowledge on Agile Software Development and participated in SCRUM

meetings.

. Excellent analytical and Communication Skills, Ability to work

independently and good team player.

Technical Skills:

Database : Oracle 10g, 9i, 8i, 7x and Access 2000

Languages : PL/SQL, SQL, C, Pro*c, Perl, VisualBasic6.0, HTML,

JavaServlet and JavaScript.

Oracle Dev tools : Developer 2000 (Forms &Reports 4.5, 6i, 9i),

Jdeveloper, ADF

GUI Tools : TOAD, PL/SQL Developer SQL Navigator, Discoverer

4i, APEX

Other Tools : SQL * Loader, PUTTY, WS FTP, EDIT PLUS, Telnet.

Operating System: DOS, Microsoft Windows 9X, NT/2000/2003, UNIX, LINUX

Testing Tools : Win runner, QTP.

ERP : Oracle Financials (AP, AR, GL, PO, OM, INV,

SYSADMIN)

PROFESSIONAL EXPERIENCE:

EPSON

Apr 2011 -Till date

Responsibilities:

Involved in gathering requirements for the conversion of data from

oracle to SAP

Created packages for the calculating the projection for the inventory

planning based on the existing data.

Involved in creating the reports in a Global Data Warehouse environment

according to the user requirements.

Involved in creating Packages, Procedures, Functions and PL/SQL

programs for data conversion.

Involved in coordinating with the business users to develop the new

views for reporting.

Worked on call support to resolve the production issues on a rotation

basis

Created Procedures, SQL Loader scripts for loading data from various

sources CAMBAR, People Soft into GDW tables.

Involved in generating the flat files using UTL_FILE for sending the

data to parent company (SEC).

Created packages for the calculating the projection for the inventory

planning based on the existing data.

Involved in creating the invoices interfaces files from oracle

application to SAP.

Involved in creating work books and grant access to the user using

discoverer reports.

Environment: ORACLE 10g, SQL* Plus, UNIX, PL/SQL Developer,

VISIO,STONE Branch, Oracle Discoverer 10g Forms 10g and Reports

10g.Oracle applications 11.5.4

McKesson

Nov 2010 -Apr 2011

Responsibilities:

Involved in gathering requirements from the Customer Support

Representatives for the PAP

Coordinating with the owners of business to develop new business views

for reporting.

Involved in conducting the meetings for with the business partners for

the data hand shacking

Created procedures for loading data from various sources (BTA/CTA) into

PAP tables using UTL_FILE.

Involved in creating Packages, Procedures,Functions, Triggers and

PL/SQL programs

Performance enhancements were achieved using DMBS_STATS package and

also by using ANALYZE commands

Worked on production support to fix the error caused during the nightly

maintenance.

Involved in creating materialized views for replication and scheduled

the job to refresh the views.

Involved in customizing and creating the forms and reports using Forms

10g and Reports 10g

Used Cursors for processing the data and also used Collections for

handling the data while processing.

Involved in writing UNIX shell scripts for the sending output email to

various clients.

Extensively used appworx for scheduling the jobs to run daily.

Environment: ORACLE 10g, SQL* Plus, UNIX, TOAD, VISIO, HARVEST APPWORX

Forms 10g and Reports 10g.

DIRECTV, Inc. Sep 2008 - May

2009 and

Nov 2009 - Nov 2010

Responsibilities:

Involved in all phases of software development which includes gathering

requirements, designing, developing application and testing the

application.

Involved in fine tuning the sql queries for better performance using

parallel hints.

Involved in writing the PL/SQL programs using various Database links.

Involved in the creating Tables, Views, Stored Procedures, Functions,

Packages, and DB Triggers for outbound and inbound interfaces.

Loading data from various files into oracle tables using SQL*Loader

programming.

Performed Data validation and Data mapping for loading the data into

Callidus tables.

Involved in writing UNIX shell scripts for automating the Business

process.

Extensively used AUTOSYS for scheduling the jobs to run on the

weekends.

Involved in creating and generating reports for the business to view on

daily basis as well as monthly.

Involved in Table Design and implementation for data warehouse and

related ETL processes.

Worked in Production Support (24*7) for issue resolution to meet SLA's

Created Change Data Capture (CDC) scenario using ODI for real time

updates on target database.

Involved in controlling all production migrations of Oracle schema

objects.

Environment: ORACLE9i, SQL* Plus, UNIX, TOAD, VISIO, Windows XP, SQL *

Loader, AUTOSYS, Oracle Applications (AP,AR,GL 11.5.10)

Caterpillar Inc, Peoria, IL Jan 2008 - Sep 2008

Responsibilities:

Involved in all phases of software development including gathering

requirements, creating specifications, development of database objects,

developing code and validating programs.

Involved in development of User Interface Objects (Forms9i and

Reports9i) and Testing of entire module.

Extensively worked with Forms 9i using the advanced features like

beans, hierarchal trees for the Paperless Factory

Involved in the creation of database objects like tables, views, stored

procedures, functions, packages, DB triggers, Indexes and Collections.

Extensively used PL/SQL Developer for creating database objects,

running the command scripts for inserting the configuration data items.

Involved in migrating forms from 6i to 9i using migration assistant.

Involved in moving the code developed code to production using Change

Management DS

Written many database triggers for automatic updating the tables and

views.

Responsible for back end stored procedures development using PL/SQL

predefined procedures. Used Explain Plan and hints to tune the SQL

Used UNIX Shell scripts to deploy the Oracle forms and reports to

production servers.

Involved in loading the data from flat files to Oracle tables using

SQL*Loader and C.

Involved in creating user documentation and providing End user

training.

Environment: ORACLE10g, SQL* Plus, UNIX, Forms 9i, Reports 9i, PL/SQL

Developer, C, FORTRAN, Pro*c, Windows XP, SQL * Loader, Change Man DS.

AT&T, Atlanta, GA

Sep 2007 - Jan2008

Responsibilities:

Analysis of functional documents, creating Detail Design and Interface

Agreement documents.

Involved in creating Packages, Procedures, Functions, and Triggers for

outbound and inbound interfaces.

Involved in writing of k-shell scripts and setting up the crontab.

Generated daily and monthly reports and posted the PDF to the web using

Oracle Reports 10g.

Involved in creating SQL loader scripts to load the data from the flat

file into oracle tables.

Used Connect Direct to transfer the files from one server to the other

servers.

Involved in performance tuning using EXPLAIN PLAN and used hints to

tune the queries.

Involved in writing PL/SQL programs for Data Conversion and Data

integration.

Involved in Unit testing, System testing and UAT.

Worked as production support specialist and resolved production related

issues.

Environment: ORACLE 10g, SQL* Plus, Secure CRT (UNIX), Secure FX, Forms

& Reports 10g, SQL Navigator, Windows XP, SQL * Loader.

STARBUCKS, Seattle, WA Jun 2007 - Sep 2007

Responsibilities:

Involved in gathering the requirements by conducting meetings and

prepared the technical design documents.

Involved in creating Forms and Reports for the Site Manager and SLIM

applications using Forms 6i and Reports 6i.

Created Sql loader scripts for loading the data from a flat file to

Site Manager and SLIM.

Involved in creating Packages, Triggers, Functions, and Procedures for

publishing the data from Site manager to Slim.

Involved in writing data Conversion scripts for the ISO country

conversions.

Developed UNIX shell scripts for data loading and extraction.

Involved in writing complex SQL queries to extract data from various

source tables.

Developed Reports Using Discoverer 4i reporting tools for adhoc

queries.

Involved in Query tuning and used hints to improve performance.

Involved in writing Pro*C scripts based on the business requirements.

Involved in writing PL/SQL programs for data conversions using the

oracle built in packages like UTL_FILE, DBMS_SQL

Created materialized views and refreshed using the DBMS_MVIEW package.

Environment: ORACLE 10g, SQL* Plus, UNIX, Forms 6i, Reports 6i, Toad

9.0.1, Windows XP, SQL * Loader.

Donegal Mutual Insurance, PA Oct 2006 - Jun2007

Responsibilities:

Coordinated with Business users in business requirement analysis,

system analysis

Design and development of the application.

Created control files for loading the VSAM files into database tables

using SQL*Loader.

Involved in creating PL/SQL Packages, Procedures Triggers and Cursors.

Involved in creation of database objects like tables, views, stored

procedures, Indexes and Collections.

Created PL/SQL Procedures using Execute Immediate, Bulk Collect for

better performance.

Involved in creating PL/SQL procedures for writing the data into a flat

file using UTL_FILE.

Involved in GUI development using Forms 6i and Reports 6i.

Involved in query tuning using Explain plan and TKPROF.

Involved in creating complex queries Using joins, sub queries and

correlated sub queries.

Involved in creating the forms from the scratch using PLL's and object

groups.

Performed Unit testing for the Developed component.

Environment: ORACLE 10g, SQL* Plus, UNIX, Forms 6i, Reports 6i, Toad,

Windows 2000/XP, SQL * Loader, Pro*c.

GE Energy, NY Jan 2006 -Sep 2006

Responsibilities:

Developed conceptual design document with prototyping of User

Interface, involved in estimation and detailed scheduling of various

modules.

Involved in creating PL/SQL Packages, Procedures Triggers and Cursors.

Loading data from flat files into database tables using SQL*Loader.

Written complex SQL's using joins, sub queries and correlated sub

queries.

Involved in writing data conversion programs using PL/SQL.

Involved in creating PL/SQL procedures for writing the data into a flat

file.

Automated data loading, extraction, reports generation using UNIX Shell

scripting.

Involved in capacity planning, creating views, materialized views,

partitioning tables and creating indexes etc for optimization.

Developed Forms and Reports based on the Business requirement.

Attended Design meetings and technical meeting with Developers from

various other applications.

Involved in creating discoverer reports for the Banking management

application, which store the Investment data.

Involved in creation of reports to view their status on daily basis as

well as monthly depends on the input.

Creation of unit test cases, test case review and testing.

Environment: ORACLE 9i, SQL* Plus, UNIX, Forms 6i, Reports 6i, Toad,

Windows 2000/XP, SQL * Loader. Oracle Financials 11.5.10 (AP, AR, GL,

PO, SYSADMIN)

Educational Qualifications:

. Bachelor of Engineering, University of Madras.

References available upon request

Contact this candidate