Pl Sql Project
Resume:
GEETHA SIVARAMAN
** *** ******* *** **** Irvine CA - 92612 USA
******.*.**@*****.*** . Ph: +1-949-***-**** (M) +1-949-***-****(H)
TECHNICAL SKILLS
Programming Languages/Framework: SQL, PL SQL, JAVA, C++, HTML, XML,
Servlets, Autosys, Struts, JDBC
Scripting: Perl, Shell
Platform: Windows, UNIX
Tools: SQL plus, Toad, Erwin, PL SQL Developer, WSAD, Eclipse
Web Servers: Tomcat, JBoss
CERTIFICATIONS
SCJP 5.4 - Sun Certified Java Programmer - 82%
OCP - Introduction to SQL - Oracle 9i - 94%
OCA - Oracle Certified Associate [PL/SQL Developer] - 97%
OCA - Oracle Certified Associate [DBA Fundamentals] - 95%
WORK EXPERIENCE
Senior Member Technical Staff @ Oracle India Private Limited (Nov 2009 -
till date)
Team: Database Porting - Server Technologies
Description: Server Technologies database porting team handles quality
assurance of database releases in various 64 bit porting platforms like for
e.g. Linux 64 bit, Solaris 64 bit, Solaris Sparc64, AIX.PPC64, HPUX.IA64,
ZLinux etc.
Responsibilities:
Handle quality assurance for Java/J2ee components in database releases -
Oracle 10G/11G patches and 12G.
Report, fix bugs for any test failures and coding in Oratst/Advanced
development environment (ADE).
Work closely with other teams like integration, build, ship home, label
announcement, test owners, product developers etc to resolve user issues
and bugs.
Perform tasks such as system enhancements, bug fixes, user support and
training, documentation and system upgrades.
Technologies/Tools used: Oracle 10g/11g PL SQL, Java, Servlets, Unix/Perl
Shell Scripting, JDBC and SQL Plus.
2) Assistant Systems Engineer @ Tata Consultancy Services (May 2005 - Oct
2009)
Client: Bank of America Project: Customer Relationship Management (10
months - Bangalore, India)
Description: Bank Of America is the largest bank holding company in the
United States, by assets. Customer Relationship Management (CRM Services)
is a data warehousing project to project the performance of the bank
against defined dimensions like region, period, employee, customer etc.
Responsibilities:
Collect user requirements, perform feasibility analysis, propose functional
and technical specifications and develop code per the specifications and
provide 24 X 7 production support on a rotation basis.
Develop PL SQL Objects, write adhoc scripts in Unix/Perl, create SQL Plus
reports and schedule jobs in Autosys.
Performance tuning of the application programs using explain plan, SQL
trace etc.
Technologies/Tools used: Oracle 10g, UNIX Scripting, Autosys, Perl, PL SQL
Developer.
Client: Citibank Project: SCOPE (11 months - Cincinnati, Ohio)
Description: Scope (Standard collections operations platform enterprise) is
a huge initiative by Citibank which aimed at having a common platform
(Chordiant - Oracle framework) to be used by all desktop agents across
different line of business in Citibank and handle credit collection system.
Responsibilities:
Use Case Analysis, Data dictionary preparation, Logical and Physical data
modeling using Erwin, Preparation of ERD, Database Design, Table Layout
design, Normalization, Coding PL/SQL objects.
Work in sync with Use case developers, Object Modelers and Chordiant
Developers.
Technologies/Tools used: Oracle 10g, Erwin, PL SQL Developer, SQL Plus
Client: MoneyGram Incorporation Project: Payment tracker (1 year -
Chennai, India)
Description: MoneyGram Inc. is a global leader in international money
transfers and one of the largest processor of money orders in the U.S.
'Payment tracker' is a system which was designed and developed to
track/report monetary transactions in form of money orders, money
transfers, utility payments, bill payments and gift certificates.
Responsibilities:
Preparation of guidelines for low level design LLD and high level design
HLD, unit testing, integration testing, study, analysis, design.
Programming in PL SQL, schedule batch programs, prepare customized
impromptu reports.
Handle production support issues after the project was commissioned.
Technologies/Tools used: Oracle 9i - PL SQL, SQL Plus, PL SQL Developer,
Proxy master.
Client: Deluxe Incorporation Project: Deluxe Financial System (DFS) (1
year, Chennai - India)
Description: Deluxe Incorporation is a large supplier of customized
products and services. In this project 'Deluxe Financial Services', dynamic
pattern/format changes in flyleaves of personalized bank cheques was
designed and developed.
Responsibilities:
Extensive requirement analysis so that the application is generic,
customizable and dynamic.
Document Tech Specs for the proposed data base design.
Coding in Java and testing the functionality using JUnit test cases.
Coding in PL SQL - Procedures, Functions, Triggers, Views, Sequences,
Indexes, using Built in Packages etc.
Technologies/Tools used: Oracle 9i, JAVA, JUnit, XML, HTML, WSAD, Toad.
E) Client: Wolters Kluwer Project: Compliance Management System (5 months -
Chennai, India)
Description: Bankers Systems Inc. (currently Wolters Kluwers) is a leading
provider of software, documentation, workflow tools and services to help
financial services organizations increase their efficiency and
productivity. The project 'Compliance Management System' aimed to track
suspicious financial transactions and report the necessary details to
concerned authorities in government.
Responsibilities:
Backend architecture design and PL SQL programming in Oracle 9i.
Java/JSP development using Struts framework.
Technologies/Servers/ tools used: Oracle 9i, Java, JSP, JBoss, Struts,
HTML, XML, JDBC, SQL Plus, Eclipse.
SOFT SKILLS
. Self motivated . Enthusiastic learner . Responsible . Good team player .
Desire to excel
EDUCATION
Bachelor of Engineering, Electrical and Electronics Engineering
GPA- 8.5/10
College of Engineering Guindy (CEG), Anna University, Chennai, India - May
2001 to May 2005
WORK AUTHORIZATION
I am currently on H4 visa. I was on H1B on my previous official visit to
USA and hence will be cap exempted for any new H1-B filing. Also, I can
work immediately once the paper work is done.
Contact this candidate