Data Sql

Ramesh Lakshminarayana

Address: Stamford, CT ****2

Cell: 913-***-****

********@*******.***

SUMMARY

. Over 14 years of software industry experience with focus on database

architecture and business development using Oracle database servers on

various UNIX platforms.

. 10+ Years of experience Migrating data from Difference systems to

Oracle/Tuning large Databases (20 or 30 TB of data).

. 8 years of Experience as Oracle Data Architect/ETL Architect/Designer,

Relational Database applications design, development and Support on UNIX.

. 5 years of experience on Data warehouse/Data mart Design, Development,

Performance and tuning.

. Data loading experience with UNIX shell/Perl scripts, SQL*Loader, sound

experience using PRO*C, awk, sed, ksh commands and also writing shell

scripts which would build a code templates/Control files data loads and

Reverse the updates/Delete the inserts performed for in Sun Solaris/HP-

UX/Dec Alpha/Linux machines

. Team leadership skills - involvement in full software development life

cycle

. Experience in design, development and implementation of database and

application.

. Experience in client/server, Internet and Intranet applications.

. Proficient in Data Modeling (Logical & Physical Design of Databases)

using ERWIN

. Sound knowledge of Data Access Methods like PRO*C/ODBC/JDBC/JAVA

. Experience in Tuning the SQL statements using EXPLAIN PLAN to improve the

performance using appropriate HINTS.

. Extensive knowledge using Oracle Packages/ stored procedures/ functions/

Database Triggers

. Implemented Parallel Query, for enhanced performance.

. Expertise Knowledge in writing Dynamic SQL using EXECUTE IMMEDIATE.

. Implemented the concept of Materialized Views.

. More than 8 years of experience in Database Design, Normalization and

Implementation.

. Worked in a large team environment with many different user groups for

systems requirement study and system design sessions.

. Exceptional ability to quickly master new concepts, applications and a

team player.

. Expert level programming skills in Oracle 7.x/8.x/8i/9i/10g, PL/SQL,

PRO*C, SQL*PLUS, Developer 2000 Forms 4.5/5.0/6i Reports 2.5/3.0/6i,

CORBA, Erwin, TOAD, SQL Navigator, T-SQL

SKILLS

Operating Systems: WinNT, Win98, W2K, XP, DOS, Sun Solaris, UNIX, SCO

HP-UX

Languages: PRO*C/C, SQL, PL/SQL, SQL*PLUS, T-SQL, JAVA, HTML, KSH, SHELL,

AWK, SED, WEB PL/SQL

RDBMS: Sybase 10.0, Oracle 7.x/8.x/9i/10g/RAC, SQL Server6.5/7.0,

and MS Access.

Front End: Developer 2000 Forms 4.5/5.0/6i,Reports 6i, ERWIN, TOAD, SQL

NAVIGATOR.

Reporting Tools: Business Objects, Reports 2.5/3.0/6i,Crystal

Reports, ETL Ab-Initio.

Middleware: Vitria, CORBA, COM/DCOM

Version Control: PVCS, VSS

EXPERIENCE

July 2009 UBS IB, Stamford CT

To Present Sr. Oracle DEVELOPER

The purpose of the project is to enforce rules the Exchange regulators have

enforced on each trade that's performed, which includes Day Trading, After

Hours, and Pre-market. The database size could be close to 30 to 40 terra

bytes.

Role

. Develop the Commission Design Engine when the trades are not internally

fulfilled and routed to a different market, depending on the Exchange

the commission.

. Performance Tuning of the Queries to ensure optimal speed, especially

on the Java Front end when the results are required to be displayed in 1

to 5 seconds.

. Write DDL Scripts as and when needed when a tuning has to be performed

by the creation indexes.

. Develop/Migrate process from TOPCAT(Previous Commission Calculation

system) to the NEW ECA System

. Design/Develop a process that detects the trade activity of the previous

day for all the exchanges and calculate the cost and further produce a

Tactical feed to GGL team which will be fed in the GL System.

. Work with the DBA to provide a tactical solution in partition

compression, which was consistently failing in the batch process when

the data load process would occur every day.

. Develop a Data Warehouse/Data Mart termed called ZEUS; which basically

is a trading surveillance system. This is basically is a bunch of stored

procedures/packages that are coded to check for particular conditions

and see how many trades qualify under this condition, which is reported

back as an exception to the business in the form of controls or use

cases. The schema implemented is a semi star schema; was closely

involved in Data modeling aspect of the process.

Environment: Oracle 10g/11i, Window NT, Complex

Decodes/Partitions/Lead/lag stored procedures, AUTOSYS Windows NT,Erwin,

Informatica

March 2009 XL ReInsurance

To June 2009 SR. DEVELOPER

XL ReInsurance is firm which insurances the insurance company. The project

contains two sides, one side where they insure the company such as Geico,

Statefarm etc. and the other side where they have to insure themselves,

which is defined as Ceding. The Database used to maintain the data here is

SQL Server 2000.

Role

Destiny Data conversation/Maintainence

. Design and Develop the Data extraction process Spread sheets to SQL

Server Using DTS process.

. Write stored procedures and DML/DDL scripts to perform and implement

business solutions for recent conversation of Ceded Data of Bermuda which

was maintained in a different system to Destiny.

. Extract/Analyze the data for every contract on need basis, thoroughly

scrutinizing the reserve details, premiums incurred on these contracts.

. Co-ordinate with the data warehouse team, where the data from

transactional system (Destiny) is loaded in the FDM(Data warehouse).

. Reconciling the data between Destiny and FDM to ensure the numbers in

Destiny match to the numbers in FDM, which is later used to constructs

Cubes for senior management to review.

Environment: SQL Server 2000, Oracle 10g/11i, Window NT, Complex

Decodes/Partitions/Lead/lag Stored procedures, AUTOSYS Windows NT

November 2006 Freelife International

To February 2009 Data Architect /SR. DEVELOPER /Project Lead

. Freelife International is a company which manufactures and markets the

"Goji Juice". The existing Business in Freelife International happened on

an ACCPAC accounting package and the old Jenkon systems which a pretty

outdated system. The current systems is needed a replacement to a new

system which was Identified as iPS for Jenkon and Oracle11i for ACCPAC.

The Database used to maintain the data here is SQL Server 2000, Oracle

10g

Role

. Architecture/Performance Tuning of the whole 3PL Module which begins with

extraction of sales orders from iPS and transmit them to third party

companies such as ESTAFETA (Mexico) /Parcel port(US/Canada)/

Geodis(Germany)/ DHL (Australia) for shipment. On receipt of a these

orders and shipment conformation file is sent back for processing, which

involved code of SQL with Complex Decodes/Partitions/Lead/lag/DDL,

Basically the Pro*C module would read the respective tables write of

files for the designated 3PL country involved.

. Applied Oracle Analytical Functions like dense_rank, lead, lag while

developing complex reports.

. Generated Notification letters on occasions where the emails were not

available for the respective customers and the communication had to be

done by POSTAL MAIL which was developed using PL/SQL/SQL. This interface

was defined as EMAIL Campaigns, which was developed using WEB PL/SQL

feature.

. Designed/Modeled/Migrated data from Jenkon the old legacy to the new

legacy Oracle IPS, which involved writing ETL scripts using

SQL*Loader/External Tables and stored procedures which would

appropriately fill the other tables which are needed in the new legacy

system

. Developed and modified scripts in Korn shell, and awk which were

extensively reused for process initiation/Job Scheduling/Data

verification in files that were produced from Oracle.

. Developed Korn/awk/Sed scripts for file transmission to all third party

servers, which included existence of the file/integrity of file

format/ensuring perfect handshake between the two servers and the

complete transmission and notification.

. Developed Korn scripts which would notified the administrators about the

space limits in the file systems that exchange acknowledgement files from

3rd party servers, which contains order information with their

respective tracking numbers. The scripts developed are initiated by cron

job at desired times.

. Developed Korn scripts which would query the program log files for any

errors, which when encountered are reported back to respective

department/Users.

. Developed ad hoc Korn/awk scripts for trouble shooting purposes, owing to

sudden change in the requirement, in such situations the database has to

reverse the updates and delete the inserts that were performed by a the

execution of processes, so that the files can be reproduced after the

implementation the new change, in such occasions the shell scripts would

perform string operations to produce the necessary SQL statements.

. Reverse Engineer Jenkon, the existing Legacy system, gather requirements

to build a new system providing Scalability/User friendly functioning of

the businesses.

. Worked with a team of experienced database designers to put up the data

model for the new system

. Architecture/ Performance Tuning of a successful process to enhance the

marketing of Freelife Products called the RO process(Reoccurring Order

Process) which is executed monthly, which contains a series of steps such

as Identify the customer for autoship/Qualify him for the order, create

the order and then process it thru payment process and book the order.

This process generates over 50% of the company's' revenue.

. Architecture/ Performance Tuning of the In-house logistics process in all

the countries where there are no third party logistics involved. This

process produces controls and a packing slip to the importers, which

describes the items, purchased by the customers and then by the warehouse

personnel ships/delivers the product to the customers.

. Recruited/Trained I.T Consultants to understand the Architecture of the

whole module and Perform Quality Check; monitored the process to ensure

the right results were produced on every single occasion.

. Integrated iPS and Oracle 11i (Revenue and Inventory). Once the sale is

paid, shipped the inventory and revenue system was to be updated, which

was performed by Stored procedures inserted these in 11i Interface

tables.

. The existing Jenkon orders are stored in MSSQL Server 2005, as a stop gap

solution the integration between MSSQL and Oracle was taken up and

performed using the linked server and DBMS heterogeneous Services.

. Architecture the order hold process when the particular products that

orders is out of stock, subsequently release the order when the item is

back in stock. Involved in Gathering requirements, Designing the screen

and the modifying the file extract process.

Environment: Oracle 10g RAC/11i, UNIX, Pro*C/JAVA, TOAD/SQL Developer,

PL/SQL, SQL Server 2005, Ksh shell/ Perl/awk Scripting, Linux, Web

PL/SQL, Advanced Queues, Complex Decodes/Partitions/Lead/lag

dbms_Schedulers Windows NT, CVS, ERWIN

January 2006 Alliance Bernstein L.P - NY

To November 2006 SR. DEVELOPER

. The existing data of Sanford Bernstein in the system named as Heart of

Gold needed an upgrade for better maintenance, so the data has to migrate

to better system called Pacesetter, which was a modified version of EAGLE

system. It has a very large oracle database over 55 TB and multiple data

marts of sizes 5TB to 12TB of navigational data continuously mined,

analyzed, and used to form strategic partnerships with advertisers

worldwide. Data loads per day are over 1.8 billion lines using

parallelism, partitioning and direct loads via external tables.

Role

. Migration of Historical data from Apace system maintained in Main frame

migrated to Client Reporting, which involves writing complex Pro*c/shell

scripts which generate control files for initiating the ETL process, the

process follows anywhere from 25 to 30 specific instructions before the

control file is built and later the ETL process is initiated.

. Wrote shell scripts which would read between lines of the files looking

for very specific information validating the process. Built Shell scripts

which that would determine the error tolerance limit on files that were

used for batch processing.

. Developed and maintained SQL scripts, indexes, and complex queries for

data analysis and extraction.

. Created Adhoc Queries for data Anaysis and produced the reports by

using Excel- Pivot tables

. Developed batch process which are initiated either in Control M or Perl

Jobs which calls Pro*c/shell scripts (Wrapper scripts) to the underlining

oracle procedure/Packages.

. Wrote Complex PL/SQL Stored procedures connecting variety of

schemas/databases to extract data from Heart of Gold to Pacesetter,

included with Complex Decodes/Partitions/Lead/lag. A data migration

requirement from Bernstein systems which was to be maintained in

Pacesetter a Centralized Data Hub

. Worked with the client reporting group, when an outside investor calls

with query and they trouble shoots the problem, when occurred.

. Monitored the performance of the process to produce results in an optimal

time.

. Successful implementation of Partitioning and maintaining the Daily

Positions and transaction data which was unpartitioned and grew

substantially and further modifying the underlined procedures to use the

partitioning key for better performance.

. Work on fixing the Trial Balance (a process which takes the positions

from Previous month and add the transactions and validates the respective

position) issues when occurred.

. Perform user-managed backup and recovery using SQL scripts and shell

scripts and using RMAN

. Performed database performance tuning for all the procedures that run on

daily basis

. Effectively used the Oracle Parallel Server based on the need when

writing data migration scripts.

Environment: Windows NT, Oracle 9i/10g, TOAD, Pro*c, PL/SQL, SYBASE 7.0,

SQL Scripting, Sun SOLARIS,HP-UX, unix/linux Sun SOLARIS, Ksh/bash/Perl

Scripting, Oracle XDB Crystal Reports, Business Objects XI XML/XSLT

July 2004 GE Capital - Stamford, CT

To December 2005 PROJECT LEADER/Data Architech/Sr. Developer

Role

Hyperion Data Staging and Planning

. Designed Data warehouse staging area for Hyperion Essbase Hierarchy. The

staging area stored all the detailed transaction from GL.

. Design/Architecture of Logical and Physical Data Modeling, essentially

modeling the star schema.

. Developed critical reports for billing using Oracle Reports

. Wrote PL/SQL Packages, Performed tuning of Report Queries as part of

Production Support, Co-coordinated with the business team collecting the

requirement to build a Data warehouse to report Quarter end /Year End

results.

. Wrote PL/SQL stored procedures to extract/Transform/Load (ETL) the data

into the staging Area, which essentially used the Oracle Parallel Server,

the extraction is either by SQLLDR/External tables/db links,

Transformation involving complex string operations/decodes/lead/lag.

. The source for the Data could be from both MainFrame/SQL Server/Oracle

11i, so based on the source, the extraction process would require writing

Store procedures in SQL Server and later BCP the file, or a DB LINK

CREATION, or a FLAT file extract from the source.

. Developed and modified scripts in Korn shell, and awk which were

extensively reused for process initiation/Job Scheduling/Data

verification in files that were produced from Oracle.

. Developed shell scripts which were used by the Hyperion Admin to run

specific Calculations/ Implementation of load rules on completion send

out a notification.

. These scripts were the processes which basically builds the Closing cube

which is the primary source for producing reports that reconciled with

11i.

. Developed shell scripts in Development/Testing environment which would

take a nightly back up of all the stored procedures in a text file which

saves a significant amount of time to rebuild the procedures with changes

that were specific Development, but gets over written by the week clone

of production into development.

. Evaluated tasks and prepared a plan of action co-ordinating the work flow

with the GE Business controllers, submit the plan of action after

succeeding in getting a sign off proceed with on the development,

essentially providing the direction to developers

. Evaluated the requirements, Understanding the relation between the

entities.

. Used Oracle Designer to create logical models and oracle physical

databases using combination of star schema conforming dimensions, mini

dimensions and snowflake.

. Architecture the concept of write-back cube, for business reporting

requirements using Hyperion essbase in order to refine and fully

interrelate all combinations of dimensions, facts, attributes.

. Monitored the performance of the process meeting the Service Level

Agreement(SLA)

. Performed logical and physical database backups using EXP utility and

user managed backups.

. Restored database using IMP from an exported database dump file using EXP

to move the entire database schema(s) from the source database into the

target database.

. Architecture the initiation of the process using Ksh/Shell/Perl Scripts,

which are eventually scheduled in APPWORX.

Environment: Windows NT, Hyperion, Oracle 9i, TOAD, Pro*c, PL/SQL, SYBASE,

SQL Scripting, unix/linux Sun SOLARIS, Ksh/bash/Perl Scripting, Oracle XDB

Crystal Reports, SQL Server 2000, Business Objects XI XML/XSLT

June 2004 Administrative Office of Illinois Courts - Springfield, IL

To July 2004

Role

. Payroll System Conversion (Forms 3.0 to Forms 6i and

Oracle 6 to Oracle 9ias Rel 1)

. The Existing payroll system which had been running in

primitive version of Oracle(6.0) was outdated and

oracle support was slowly deprecating, this forced the

change in the whole environment,(Conversion) to the

latest and greatest version of Oracle(9i), retaining all

the functionality. Totally there were about 120

forms(Version 3.0) and 2 Cobol Programs, which were a

part of the payroll system, the Forms were converted to

Forms 6i and Cobol Programs were converted to Pro*C.

. Wrote the design specification of the project and came

up with a plan of action.

. Made key decisions in the project which had saved

significant amount of money and also time, if not done

would ended up doing the whole migration

process/Modification of existing programs to the newer

version (PRO*C/COBOL to PL/SQL). Responsible for making

the project happen in one month with two resources,

where other companies were quoting for astronomical

amount for the completion of the project in 1 month.

. Reverse Engineered the existing PRO*C from oracle 6

Version rewrote the whole process in PL/SQL.

. Presentation of plan to the client and explaining him

how the task will be performed.

. Coordinated with the client to check the satisfaction

level and get his approval.

. coordinated with the team in code review and checked if

all the forms retain the existing functionality.

. Worked with the DBA for the conversion of Oracle 6 to

Oracle 9ias Rel 1.

. Exported and imported tables from one database to

another.

. Evaluated existing process and Co-Ordinate with client

on improved performance.

. coordinated with the users for the User Acceptance Test,

implemented the feedback if necessary or educating them

with power of New Technology.

. Successfully managed and directed the projects in

partnership with peers, business community members,

payroll analysts, migration consultants and rule

changes. Developed critical company-wide Operational

Data Store.

. Preparing the Technical documentation of the project.

Environment: Windows NT, AIX 5L, Oracle6.0, Oracle 9ias

Rel1, PRO*C, FORMS 6iForms 3.0, PL/SQL, SQL Scripting,

UNIX KornShell Scripting, Oracle reports.

February 2004 Jefferson Pilot Financial

To June 2004

Role

Jet Issue and Producer commission

. The main goal of the project is to automate the approval after it's

quoted to the customers and customers have accepted the quote. The

approval can consist of one coverage or much coverage namely LIFE, Vision

and all the coverages which Jefferson Pilot issues to its customers, and

subsequently maintenance of the Agents Commissions.

. Writing Complex PL/SQL subprograms, packages, procedures and functions

and DB triggers to implement the business which calls for appropriate

writing and deleting records from respective tables.

. Reverse Engineered sold case approval process which was encapsulated in

the ORACLE FORMS which had series of SQL statements in various Form

triggers, by putting a flow diagram and later designed a package which

appropriate procedures which were used in the triggers.

. Designing the Screens thru which the end users can

Read/Update/Create/Delete the quote and soldCase details Using Oracle

FORMS 6i

. Writing Pro*C/C++ programs for commission Agreement and have that passed

to the printer, which can be to the data Center or the local printer.

. Troubleshooting the errors occurred when the production and testers hit

a roadblock.

Environment: Windows NT, Oracle 9i, FORMS 6i, PVCS, TOAD, PL/SQL Developer,

SQL*Net 8, PL/SQL, Pro*C/C++, Erwin, SQL Scripting, UNIX Korn Shell

Scripting

May 2003 Administrative Management Group ( Lincoln Financials)

To January 2004

External - Conversion and Data Management

Role

. A Module in which the Demographic, Employment, Financial, Participant,

Service, Vesting, Loan Data of a Company is converted to AMG Proprietary

format when that particular wants AMG to manage there 401k and payroll

data from the subsequent month.

. System Study & Business Requirements Analysis & Documentation

. Involved in designing the procedures for getting the data from all

systems to Data Warehousing system.

. Co-Ordination with the end-users and come up with proper architecture of

the module .

. Standardization of data, write them to the table for access of different

Business units

. Wrote Complex PL/SQL stored procedures and packages to convert the

external data to AMG authorized rules and later move the data to

production, these procedures would essentially perform the ETL process,

where the data is sourced from flat files, transformed to AMG format and

then loaded into the respective tables.

. Wrote PRO*C Interface programs to generate SQL loader scripts(ETL) for a

flat file which comes on a specific directories, and Using this SQL

loader script the Data is loaded in the stage data table.

. Wrote C Interface programs which would monitor the V$SQLAREA for the disk

reads in oracle.

. Applying the Standard and user-defined conversions, Validation, these

validation/conversation standards are part of the Data transformation.

. Moving Data to personal profile tables, Finance Related tables, this step

defines the Final stage of ETL Process, the data movement to the target

tables.

. Running the Balance Calculator, which would generate a report, which is

viewed by the business management?

. Moving data to production using a .NET service.

. Wrote shell script to generate a report which would show the used, unused

packages for a module.

. Performance Tuning of the queries written Using Explain Plan, TKPROF,

DBMS_PROFILER.

. Troubleshooting the errors occurred when the production group hits a

roadblock.

Environment: Windows NT,MQ Series, Oracle 9i, Informix, SQL Navigator

3.x,TOAD,PL/SQL Developer, SQL*Net 8, PL/SQL, Pro*C/C++, Erwin, SQL

Scripting, Unix Korn Shell Scripting, .NET

December 2002 Sprint United Management - Overland Park, KS

To March 2003

Role

Phase 1: Commissions Calculations and Appeals

. A project where Commissions are calculated on the PCS phones sold.

Ideally, the project is to deal with the commissions paid to the sales

representative when they sell sprint service to the existing or new

customers.

. Wrote PL/SQL subprograms, packages, procedures and functions and DB

triggers for Data retrieval, deletion, and creation.

. Fine-tuning the database by creating indexes, and running explain plan on

SQL scripts and using optimizer hints if necessary for faster retrieval.

. Wrote UNIX shell scripts (Awk, Sed) such as Utility shell scripts for

loading test data into the database.

Environment: HP-UX, SQL, SQL*PLUS, PL/SQL, Pro*C, Oracle 9i, PL/SQL

Developer. UNIX Korn Shell Scripting

July 2002 Verizon Wireless - Arlington, VA

To December 2002

Role

Source file management

. A project where all different system sent out the daily transactions in

flat files delimited with a valid characters in the respective servers

and the process monitoring them to archive and putting them to different

servers where other groups can access them.

. Develop/Designed Shell scripts that connect at least 15 different Unix

servers which are in variety of Time Zones Check the time on the remote

server without logging in and r capturing the files received from the

respective source providers and move them to NMP naming convention and

archive them in the archive directory

. Developed shell scripts that would add few consistent columns to the

files that were received from source providers, which involved a lot of

string operations and were either performed either by awk or sed

commands.

. Wrote shell script for reporting the missing files, received files,

duplicate files, and zero byte files automatically generate a letter with

the missing files list

. Developed a report program using Korn scripts, which would provide a

detailed list of files from different source providers, that were

received including the no. of bytes, receipt time and other useful

information; on missing the SLA, automatic alerts were triggered to

respective files source providers notifying about the non-receipt of

files. These reports are constantly view by directors at various levels.

. Write Shell Scripts for monitoring the space of the file system.

. Developed very large high scale client/server ERP solutions using Visual

Basic, Visual FoxPro and Access GUI's with Oracle, INFORMIX, Sybase and

Access databases.

. Experience in client/server development of 50 plus applications using

Sybase 10.0, Informix Dynamic Server 2000 7.x-9.x as the back end running

on an HP9000 L1000 server with in an UNIX operating system.

. Writing crontab utilities for doing the above tasks.

. Writing adhoc-scripts depending on the situation like searching for

records thru the files for a particular order.

. Monitoring the space in the files systems where these files come in and

have the pager beep me when the file system is full where the tolerance

level is above 87%

Environment: Sybase 10.0, VB, HP-UX, Awk, SQL, PL/SQL, Oracle8i/ 8.1.7,

TOAD,XML and Informix, UNIX Korn Shell Scripting.

July 2001 Sprint United/Management - Overland Park, Kansas

To March 2002

Role

E-Retail/LTD

. Tracking of Supply Chain Management for maintenance of their parts, which

are shipped to the customers. In this project the set of Java servers

using the PNS and Hitachi's TPBroker, providing persistent CRUD (Create,

read, update, delete) functionality to the Sprint SCOR Database.

. Worked on Specification, Business Analysis/requirements and

documentation.

. Prepared the detailed design document and test cases for the Business

requirements

. Worked along with Data modeling team in putting to gather these

requirements and come up with the Entity-Relationship Modeling. Using

this relation come with the database tables and conduct meetings along

with different groups.

. Responsible for maintaining an Oracle 8I database with size 25 gigs,

which contained very large history information tables. Responsible for

the creation of these history tables, data mapping and data extraction.

. Involved in the full development life cycle of the project like Problem

solving, testing, troubleshooting and maintenance of the application

. Designed, coded, tested, and implemented Architecture, Model and

Configuration of the system using SQL, PL/SQL, FORMS, PRO*C++, SUN OS,

and ORACLE.

. Wrote standard C++ classes and methods, which were extensively used in

other interfaces.

. Wrote various UNIX shell scripts (Awk, Sed) such as Utility shell

scripts, scheduling processes using crontab utility, SQL scripts to

monitor these interface programs.

. Wrote DB Triggers,PL/SQL subprograms, packages, procedures and functions,

Pro*C and Java Interfaces which implement the

CRUD(Create,Read,Update,Delete)

. Used different third party tools and Explain Plan utility to monitor the

performance of the various number of SQL statements

. Used SQL*Loader for loading business data into the production database.

. Responsible for performance analysis and tuning of SQL in the data

warehouse.

. Also responsible for Version Control and Security Maintenance of modules

developed for the application using the PVCS package.

Environment: Sun Solaris, Awk, Perl, CORBA, Oracle8i/ 8.1.6, PL/SQL,

Proc*C/C++, SQL*LOADER, TOAD, C/C ++, Java, PVCS, Designer 2000, Unix Korn

Shell Scripting

March 2000 Sprint United/Management - Overland Park, and Kansas

To October 2001

ION [5.0, 4.0, 3.5B]

. A project for maintaining the ION orders with the details of equipment,

equipment shipping, and type of customers. A set of Advanced CORBA/C++

UNIX servers using the PNS and Hitachi's TPBroker, providing persistent

CRUD (Create, read, update, and delete) functionality to the Sprint COR

Database.

. Assisted in estimating the specification requirements in the AIM

sessions, as well as in the estimation of database requirements and

design with functional specifications.

. Wrote DB Triggers/PL/SQL subprograms, packages, procedures and functions,

Pro*C and Java Interfaces which implement the CRUD

(Create,Read,Update,Delete) after connecting to the database using OTS.

. Problem Solve and Support Client Organizations and their applications

connectivity to Information Broker.

. Extensively worked on database objects design and defining business

rules.

. Create IDL [Interface Definition Language] presenting to client

organizations as their interface to Information Broker, On Approval

implementing the same.

. Written various level of UNIX shell programs/Perl (Awk, Sed) to automate

and schedule the processes using crontab utility.

. Maintenance of Version control of the programs using PVCS.

. Developed Interfaces between the Applications and Databases Using Java.

. Fine-tuning the database by creating indexes, and running explain plan on

SQL scripts

. Wrote standard C++ classes and methods, which were extensively used in

other interfaces.

. Used SQL*Loader for loading business data into the production database.

Environment: Sun Solaris, Awk, Perl, UNIX Korn Shell Scripting,

Oracle8i/8.1.6, Proc*C/C++, PL/SQL, SQL*LOADER, PVCS, C/C++, Java, CORBA,

Rational Rose, XML

Client : Nagarjuna Investors Services Ltd, India.

July 1993- February 2000

Role : Assistant/ Junior Oracle Developer

The following were the projects that were Successfully Accomplished.

Project name Description

Bank Reconciliation System This system was developed for reconciliation of

Dividend/Interest Warrants Thru the Group of Companies.

It Comprises of Capturing lot wise controls for

warrants en-cashed using a Barcode reader Tallying

Warrants for a particular lot. Generate Lot wise

details for Tallying and non-tallying lots. Generating

Ad hoc reports when necessary

Conversion of FORMS 3.0 to This project was for the conversion of the existing

5.0 and conversion of Rpt Forms 3.0 to 5.0, with the management opting to change

(1.1) to PRO*C the architecture In the Fixed Deposit Division.

Complaint Processing System This was project, which involved the process of various

complaints received from Investors. Basically, an after

process Viz. Transferring of stocks, Mailing of

Interest/Dividend Warrants, Transmission of stocks, and

various other reasons. The Complaints were entered by

users based on the complaint to a specific Complaint

Code and based on the entry made a Suitable reply was

generated to each Investor.

Stock Accounting System Project deals in controlling and managing the

activities of Stocks and Debentures. This project

contains the modules like In-mail Section, Scrutiny

Section, Signature Verification, Transfers, Issue of

Duplicate Certificates, Split Certificates,

Transmission, Transposition, Consolidation of Folios,

Renewal, Hold of Certificates, Out-mail Section and

Reconciliation.

EDUCATION

Pondicherry University - India

. Post Graduate Diploma in Computer Applications

Dr. B.R.Ambedkar Open University - India

. Bachelor in Science (Math, Physics, Chemistry)

Contact this candidate