Name: Ramesh Kotha

Title/Role: Senior Consultant System ID:

Skills:

Technology
NUMBER OF YEARS USED
LAST USED
PROFICIENCY LEVEL
Reporting/OLAP Tools

Date technology last used
Basic/Proficient/Expert
TOAD 10.1
13
2010
Expert
PL/SQL Developer 8.0
3
2010
Expert
Brio SQR 6.2/8.3
3
2007
Proficient
BusinessObjects 6.5.1
2
2006
Proficient
Crystal Reports
2
2009
Proficient
Rapid-SQL 7.2.1
2
2005
Proficient
SQL Navigator v 4,
2
2010
Proficient
SQL Station 4,
2
2010
Proficient
S-Designer 5.0
3
2008
Expert
OBIEE
3
2008
Proficient
Hardware

IBM Compatibles and Pentium series, Sun Solaris 10

2010
Proficient
Operating Systems

Windows NT
5
2010
Proficient
98/95/2000/XP
14
2010
Proficient
HP-Unix,
2
2010
Proficient
Windows 2003,
2
2010
Proficient
AIX Unix 5.2
2
2010
Proficient
Linux 5 Release 2
2
2010
Proficient

Education & Certifications:
University of Osmania, India 07/1992 - 06/1995
Master of Computer Applications
Andhra University, India 06/1988 - 07/1991
Bachelor of Science in Computer Science

Employment History:
Electronic Transaction Consultants Corporation, Richardson, TX - Consultant
Mar 2007-Present

Electronic Transaction Consultants Corporation (ETC Corporation) is a leader in
toll collection solutions and hosting services provider. The company delivers
empowering electronic toll collection solutions through systems integration,
consulting, maintenance, and operations services.

Technologies: PL/SQL, SQL*Plus, Oracle 10g, Oracle 11 g, Oracle Designer 10g,
Linux, Windows XP, Windows 2003, PL/SQL Developer, TOAD 10.1, Oracle Reports 10g,
Oracle Developer

Electronic transaction Projects
Illinois State Toll Highway Authority - CSC Subcontractor
 * Configured all corporate data using JDBC connection.
 * Designed database triggers, procedures and functions in PL/SQL, and
incorporated business rules and constraints in the design.
 * Designed materialized views to interface the data between the databases.
 * Designed and Developed Reports using the Oracle Reports.
 * Developed procedures to send the data file to third party companies
periodically using UTL (an oracle utility to create text file).
 * Performed tuning SQL queries to obtain maximum efficiency and performance.

Technologies: PL/SQL (Oracle 10g), PL/SQL Developer, TOAD, Windows 2003

Harris County Toll Road Authority - Website Revamp 2.0
Involved in development and maintenance of the HCTRA tag-store website and
revamp the application developed in Oracle 10g, Reports 10g and PL/SQL.
HTP, HTF and OWA packages were used to dynamically build webpage from PL/SQL.
 * Developed new functions to allow patron to request to close his/her account
from the online CSC portal.
 * Created new packages/functions with such enhancements like
 * Authorized contacts.
 * View monthly statements Account comments.
 * Rebill threshold parameters.
 * Developed and modified Account notification preferences screen.
 * Developed and modified notifications history screens.
 * Developed Max Rebill and Pending to close Account reports.
 * Provided encryption technology in the tables to enforce credit card numbers
and Bank account numbers security.
 * Designed and modified the functions in the program to retrieve decrypted
values from the database and display the decrypted values in the reports.
 * Created new SQL report by using PL/SQL that will keep track of the toll
transactions incurred by Non Revenue toll tags used in other agencies lanes.
 * Designed tables, views and materialized views for OBIEE

Technologies: PL/SQL, Oracle 10g, PL/SQL Developer, TOAD, Oracle repots 9g/10g,
Linux, Solaris 10.
Crescent City Connection Division - CSC Subcontractor
 * Created and managed Queues using Advance Queuing feature. These Queues were
created for inbound messages (tolls) from the HOST. Separate queues were created
to validate the messages from the HOST and also use to process the incoming Toll
transactions. If the Validation or processing fails, the message will be send
back to the HOST by using the OUTBOUND queue.
 * Created and managed DBMS scheduler jobs to Enqueue and Dequeue messages
between systems.
 * Provided JOB chains and Chain rules to make use of DBMS scheduler
effectively.
 * Created and managed new reports used in CSC application.

Technologies: PL/SQL, Oracle 10g, PL/SQL Developer, TOAD, Oracle repots 9g/10g,
Linux, Solaris 10.
Delaware River Joint Toll Bridge Commission - CSC Subcontractor
 * Designed and Developed packages to send e-mail notifications to patrons using
UTL TCP and UTL SMTP
 * Designed database triggers, procedures and functions in PL/SQL, and
incorporated business rules and constraints in them.
 * Created materialized views/Snapshots to interface the data between the
databases.
 * Designed and Developed Reports using Oracle Reports.
 * Developed procedures to send data file to third party companies periodically
using the UTL file.
 * Performed SQL queries tuning for maximum efficiency and performance.
 * Designed tables, views and materialized views for OBIEE
 * Designed and developed package to create Monthly Statements in Txt file
format.
 * Created Test cases.
 * Created Technical documentation

Technologies: ORACLE 11g , SQL, PL/SQL, Oracle Reports 10g, Linux
Management Science Associates, Pittsburgh, PA - Software Engineer
Jan 2006-Mar 2007

Management Science Associates has its own software product 'Gabriel', a media
based software and it is using SQR as a reporting tool. It has modules like Sales
Management, Deal Maintenance, Research, Scheduler and Traffic. As a Database
developer responsible for developing stored procedure / functions / packages for
the team.

 * Provided enhancements to the existing stored procedures for the
implementation of the new data model.
 * Provided queries building support to the reports team.
 * Developed database packages/store procedures for extraction of the data to be
use in the reports.
 * Developed Technical Documentation.
 * Designed and created tables, views, stored procedures, triggers and sequences
with SQL and PL/SQL.
 * Trained in Oracle 10g.

Technologies: Oracle 8.x/9i, SQL Station, TOAD.

Hall mark Global Technologies Inc. - Software Engineer
TriZetto - Greenwood Village, CO
Aug 2005-Dec 2005

TriZetto developed and maintained databases for the health insurance companies
which are in US. TriZetto uses a product called 'Facets'. This product deals with
the maintenance of data base and provides reports to the clients.

 * Enhanced and maintained of existing stored procedures.
 * Modified shell scripts to run batch jobs to collect incremental data from
health insurance companies and copies to TriZetto serves.
 * Worked on reports using BusinessObjects 6.5.1

Technologies & Technologies: Sybase/Oracle, Business Objects 6.5.1,
T-Sql/Rapid-SQL 7.2.1 and AIX Unix 5.2

ExxonMobil - Houston, TX - Software Engineer
Apr 2005 - July 2005

The purpose of the project is to create the Incentive Compensation Employee Web
Site. The client is the Incentive Processing Office (IPO) that is a part of the
Corporate HR group located in Irving, TX. The IPO administers all incentive
awards (such as stock options, restricted stock shares, etc.) globally for
ExxonMobil.

The Incentives Web Site will aid the IPO in the distribution of new awards as
well as to give Incentive Program participants access to their outstanding and
historical award information, pay stubs, online help, online exercise requests
and simulations, and as well as legal documents associated with their awards.

 * Created new stored procedure for their new reports by using Brio SQR report
tool.
 * Provided query tuning and modified existing report generated by the Explain
Plan utility.
 * Provided database programming by using stored procedures and functions to
pull data for reports (moved code from reports and build stored procedures).
 * Provided queries building support for the team members.

Technologies & Technologies: Oracle 9i, PL/SQL, TOAD 7.1 and AIX UNIX 5.1

R Systems International Ltd., Noida, India - Sr. Software Engineer
Mar 2004 - Feb 2005
Open Solutions Inc - Glastonbury, CT

Open Solutions, product TCBS (The Complete Banking Solution) provides financial
institutions with enabling technologies to allow them to strengthen
relationships, improve productivity, reduce training and administrative costs,
and optimize delivery. They provide software and services that enable financial
institutions to establish new ways to create value and expand their financial
services relationships.

 * Created new reports according to International standards for multi currency
support using Brio.
 * Generated complex Extracts for Insurance companies / credit unions using
Brio.
 * Created Oracle stored procedures to pull data into Brio.
 * Provided extensive SQL queries execution validate data.
 * Involved in creating Tables, Views, Indexes, Functions, Procedures and
Packages using Oracle 9i.
 * Developed new and modified Centura Screens according to the user requirement
for Multicurrency support.

Technologies & Technologies: Brio Report Builder 6.1, Centura 2000, Oracle 9i,
PL/SQ, TOAD 7.6

Rollatainers Limited, India - Software Engineer
May 2002 - Feb 2004
Centralized Accounting Package

This project involves capturing all the vouching/sales data from different
offices of the company located all over the country online and generating all the
MIS online to serve the purpose of the Management. This Integrated package
provides automatic purchase voucher generation from the Goods received from
Inventory, automatic Journal voucher generation from Payroll and Freight
payments. Production of details is online and is integrated to generate Excise
related reports that will be submitted to the government.

 * Analyzed, designed, tuned and implemented the package tha