Developer Project
Resume:
R AISHWARYA [pic]
Summary of Qualifications:
> Over 3.5 years of extensive experience in design, development,
maintenance and implementation of application software.
> Excellent command on Oracle 9i/10g, PROGRESS 4GL, Unix shell
scripting, SQL *PLUS, MYSQL including database design, development
with emphasis on back end stored procedures, functions, triggers.
> Hands on experience in all stages of system development efforts,
including requirement analysis, design, testing and implementation.
> Oracle PLSQL Developer Certified Associate.
> Proficient knowledge in building database applications using SQL and
PLSQL.
> Skillful in Data Modeling, Data Mapping, Table Normalization, Query
Optimization and Performance Tuning.
> Knowledge of PL SQL Programming using packages, procedures, functions,
Object Types, Collections, Cursors, Dynamic SQL, Bulk Collect,
Materialized Views and SQL *Loader. Sound knowledge in tuning SQL
statements. Oracle Import/Export Utilities and SQL*Loader
> Extensive experience in Shell scripting and scheduling the job using
CRONTAB.
> Keen focus on Performance Tuning using Hints, Indexes, Explain Plan,
SQL Trace, TKPROF.
> Worked on advanced PL/SQL constructs like Oracle supplied packages,
Nested tables, Varrays, Records and Types.
> Experience in ETL process using OBIEE and Oracle 10g.
> In-depth knowledge in various development tools such as TOAD and SQL
developer for Oracle, Query browser for MYSQL, Pro* editor for
PROGRESS 4GL and OBIEE for reporting and business intelligence.
> Designed and developed the Siebel Analytics Metadata Repository (.rpd)
using Siebel Analytics Server Admin tool by importing the required
objects (Dimensions, Facts & Aggregates) with Referential Integrity
constraints into Physical Layer using connection pool, developing
multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure
objects in Business Model Layer, and creating Presentation Catalog in
Presentation Layer.
> Developed many Reports and Dashboards with different Analytics Views
(Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart,
Column Sector, Tabular with local and global filters) using Siebel
Analytics Web.
> Result oriented innovative leader with proven ability to think
creatively. Have consistently surpassed project goals and demonstrated
success in solving complex technical problems while meeting tight
deadlines.
Technical Skills
RDBMS PROGRESS 4GL, MYSQL, Oracle 9i/10g,Performance
Tuning
Database Tools TOAD, MYSQL query Browser, Pro*editor, SQL
developer.
Programming C, C++, Core Java, JDBC, SQL, PL/SQL, Unix shell
Languages scripting, HTML, PERL
BI Tools OBIEE 10.1.3.4.1 .
Operating UNIX, RHEL 5.0, Windows Vista, XP, 2003 and NT.
system
Data modeling VISIO, Rational Rose.
Tools
Source safe PVCS, VSS.
Defect Tracking Quality center.
tools
Professional Experience
BETASOFT Systems Inc., Fremont, CA January 2009 - Till now
Project NGO networking
Role Oracle developer
Environment Oracle SQL developer, UNIX shell scripting, Microsoft
Visio 2007
Duration July 2009 -November 2009
Project Description
The aim of this project is to create a common platform for NGO, charitable
organizations, volunteers, donors and common man. This common platform will
allow different social organizations and people to interact with each
other, talk about their work, organization and future programs
Roles and responsibilities
. Involved in analysis and requirements gathering of the various work
streams by meeting with the business user and base lining the details.
. Involved in the detailed designing of database structure and created
data model using VISIO 2007.
. Involved in downloading the software and installing the SQL developer
. Develop database test plan and configure test environment.
. Created Tables, Views, Stored Procedures, Triggers, Functions,
Indexes, Oracle joins and performed fine performance tuning and query
optimization.
. Created stored procedures which are used update files and serve the
transaction processing.
. Involved in Unit testing of the stored procedures, functions and
triggers.
. Involved in Technical Documentation, Unit test, Integration Test and
writing Test plan
E-Mortgage System, I netsoftsolutions
Project E Mortgage
Role OBIEE developer
Environment Oracle BI EE 10.1.3.4.1, Oracle 10g
Duration February 2009 - June 2009
Project Description
E-Mortgage analytical processing uses OBIEE business intelligence tool on
their data mart to pull reports like total amount lent to customers by
Quarter/Monthly, identify loan amount by their property types and products,
number of new customers who applied for loan by weekly/monthly/quarterly.
The project compares and contrast reports using the data from various
sources and consolidates them at the report/dashboard level.
Roles and Responsibilities
. Involved in business analysis and requirements gathering by working
closely with the business user.
Designed and implemented custom business intelligence solutions
(Metadata and Dashboards/Reports) using the Siebel/Oracle BI Analytics
platform.
. Involved in the detailed design of the reports/dashboards and data
model.
. Created dimension tables, fact tables and implemented dashboards and
reports.
. Involved creating the Physical, BMM and the Presentation layer.
Created hierarchies, variables, and event poll strategies in the
repository.
. Enhance performance by creating Aggregate tables, Indexes and managing
Cache.
. Modified some of the existing reports and dashboards, and fixing some
of the issues related to performance, data quality etc., during
production support.
DNB, NJ
Project Entity Match System
Role PL/SQL, Oracle developer
Environment PL/SQL, UNIX shell scripting, Java
Duration August 2008 - January 2009
Project Description
The application is meant to update the business entity reference file and
search the inquiries against the business entity reference file. This
innovative new process ensures customers to receive more match candidates
of greater quality. GOLF application is the best-in-class search/match
engine used to retrieve and to update the information about businesses.
GOLF application enables customers to receive more match candidates as well
as greater quality candidates. This information assists customers in
various decision making and market analysis tasks. As a result, customers
will begin to see increased consistency in their match results across most
of our on line and batch products. The application algorithm is tuned and
developed to have different variety of data to enhance the match produced
on the customer inquiry.
Application layer is built using J2EE and the entity details are maintained
using Oracle 10g RDBMS.
Roles and Responsibilities
> Involved in understanding the business logic to modify existing SQL
Codes and Performance Tuning as per the requirements.
> Developed automated K-shell scripts to schedule the load of flat files
daily, weekly and monthly. .
> Read data from flat files and uploading that data into oracle tables
using SQL*loader..
> Perform complete backup copy and restore the instances.
> Created Tables, Views, Stored Procedures, Triggers, Functions,
Indexes, SQL joins and performed fine performance tuning and query
optimization.
> Created PL SQL stored procedures which are used to update the
reference file and serve the transaction processing.
> Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better
performance and also extensive usage of Indexes
> Involved in Unit testing of the stored procedures, functions and
triggers.
> Solved both Technical issues and Business issues in implementing the
features.
> Coordination between the on site and offshore team for task tracking,
planning and defect tracking enhancements and bug fixes.
Wipro Technologies, NJ
Project Segregated Funds
Role PROGRESS 4GL developer
Environment PROGRESS 4GL, UNIX
Duration April 2007 - August 2008
Project Description
Client is a leading provider in sophisticated record keeping, transaction
processing, computer software services and products, primarily to mutual
fund companies, insurance providers, banks and other financial
organizations around the world. IFDS plays a unique role since it is an
organization that acts as both a software developer of back office systems
and a service provider of a fully equipped back office complex including
customer call center division (Transfer agency)
The segregated funds consist of pool of investments in securities such as
bonds, debentures and stocks.
Roles and Responsibilities
> As a developer my responsibilities include enhancements of existing
applications built using PROGRESS 4GL.
> Gathered user requirements, analyzed business needs and derived
functional and technical specifications.
> Key developer for project Planning and tracking modules.
> Writing codes to generate monthly/yearly fund reports based on the
contract types for multiple clients to view deposit maturity amounts
and death benefit amounts.
> Creating transactional and batch processing for different clients with
different contract types and funds.
> Involved in the coding and testing of all the modules developed for
the project.
> Preparations of detailed unit test cases for the enhancements made and
also include various possible cases of testing.
> Worked on the implementation and support for the enhancements being
done.
> As a part of production support I have communicated directly with the
customer and resolved issues when tickets were opened. As a part of
this activity I need to analyze, document, code change, test and
deploy.
Wipro Technologies, NJ
Project Stock Information Management System
Role Oracle developer, UNIX shell scripting
Environment Oracle 10g, UNIX
Duration Jan 2007 - March 2007
Project Description
This provides interface which helps the user to manage the stock holdings.
This application also handles creation, modification and handling of user
accounts. It provides detailed management information for the customers.
The user can create accounts, add stocks, and manage different stocks. It
also enables the user to buy/sell stocks and maintain their transaction
processing efficiently and securely. This management system generate s a
monthly report including the stock name, stocks purchased during the month,
stocks sold and also various other transactions as selected by the user.
Roles and Responsibilities
> Was responsible for Analysis and gathering system requirements.
Redesigned and Customized the Reports using Developer Tools (Reports 6i,
Forms 6i).
> Created application schema as tables, views and indexes.
> Customized the stored procedures, functions, Pl/Sql package and
database triggers in Pl/Sql.
> Exception handling and cursor management in PL/SQL.
> Implemented and tuned the indexes. Handled pre-defined and user-
defined exceptions.
> Coded triggers at various levels for cascading functionality, cross
checking and for referential integrity.
> Designed the Procedures for getting the data from all systems to Data
Ware Housing system.
Tuned and Optimized the SQL statements using Explain Plan and SQL trace
utilities.
> Instituted Procedures to migrate development work from development
instance to production environment. Performed the data migration
using SQL*Loader
Wipro Technologies
Project On line Banking System
Role Oracle developer.
Environment Oracle 9i, JSP, Web service, JDBC and HTML
Duration October 2006 - Dec 2006
Project Description
This is a web based application built using Oracle, JSP, Web service, JDBC
and HTML; it is intended to provide on line banking functionalities for the
user. Users can do transactions such as to maintain and transfer funds from
one type of account to another. This also generates reports on monthly
basis depending on the user selection criteria.
Roles and Responsibilities:
> Involved in the System study and development of specifications as per
user requirements.
> Developed various PL/SQL and SQL scripts for populating database in
Oracle 9i.
> Created Indexes after analyzing reporting requirements. Developed
numerous Stored Procedures, Functions and Database Triggers to
implement application logic in Oracle 9i.
> Developed forms using Oracle Forms for storing materials, suppliers,
stock maintenance and others.
> Developed reports using Oracle Reports for users, suppliers and
others.
Education
B.TECH (Information Technology).
Oracle Certification
Oracle Certified Associate (OCA).
Contact this candidate