Mrs. Usha. S.

Workshops Attended

Sl no.

Title

1.

Attended  workshop organized  by Microsoft and bites on Microsoft.NET between 5th and 7th March 2009  at Srinivas Institute of Technology, Mangalore.


Projects Carried Out

Project Title:

www.sahyadri.edu.in

Tools

PHP,HTML,CSS,XML,MySQL, Asp.net, MS-SQL, VB.net, Ajax

Project Scope

This is a web site of Sahyadri College of Engineering and Management , Mangalore

It contains both the dynamic and static Pages .
Team Size 4
Responsibilities Design, Coding, handling the team and Unit testing.

Project Title:

www.bhandaryfoundation.org

Tools

PHP,HTML,CSS,XML,MySQL, Asp.net, MS-SQL, VB.net, Ajax

Project Scope

This is a web site of Bhandary Foundation  , Mangalore

It contains both the dynamic and static Pages .
Team Size 2
Responsibilities Design, Coding, handling the team and Unit testing.

Project Title:

www.esahyadri.net

Tools

Joomla (Content Management Software)

Project Scope

This Project is Sahyadri students dynamic portal. This is a website, where the news can be uploaded by the specified users,Students and faculty members can interact and can disscuss in the forum, browsers can comment on it, forums on related topics, Categories, posting of event on scheduled dates, polls and advertisements can be displayed. Sending of E-Newsletter to the subscribed users,
The product is under development.

Team Size 2
Responsibilities Design, Coding, handling the team and Unit testing.

Project Title:

 co-op Banksoft

Tools

Visual Basic 6.0, Crystal Report8.0, SQL Server2000, Oracle8i., Windows 2000 Server

Project Scope

co-op Banksoft developed is customized to meet the needs of the Finance Institutions in Karnataka. This software is available both in English and Kannada version. The major Functional requirement of the above software is in its

  • Accounting system
  • Loan processing, Recovery, deposits and Shares.
  • Customer Information
  • External bank transaction

Contribution:

    • Involved from its inception stage up to its implementation
    • Analysis of the requirements of the customer and customizing the software inline with the requirement of the customer.
    • Involved in implementing the complete  software at the client place along with the existing data porting
Team Size 6
Responsibilities Analysis, Coding, Implementation & Data Porting

Project Title:

Fri-Dec Banksoft

Tools

Visual Basic 6.0, Crystal Report8.0, SQL Server2000, Oracle8i., Windows 2000 Server

Project Scope

Project Description: Fri-Dec Banksoft developed by Fri-dec Software Technologies Inc, A Bangalore based banking software firm developing finance related products since its inception. Fri-Dec Banksoft software is designed and developed by Fri-dec Software Technologies Inc development team customized to meet the needs of the Finance Institutions in Karnataka.
This software is available both in English and Kannada version.

The major Functional requirement of the above software is in its

  • Accounting system
  • Loan processing, Recovery, deposits and Shares.
  • Customer Information
  • External bank transaction

Contribution:

    • Involved from its inception stage up to its implementation
    • Analysis of the requirements of the customer and customizing the software inline with the requirement of the customer.
    • Involved in implementing the complete  software at the client place along with the existing data porting
Team Size 6
Responsibilities Analysis, Coding, Implementation & Data Porting

Project Title:

Letter of Credit (LC).

Tools

Visual Basic 6.0, Crystal Report8.0, SQL Server2000, Oracle8i., Windows 2000 Server

Project Scope

Project Description:
          Letter of Credit (LC) is a very common and familiar instrument in settling trade between nations. Buyers and Sellers negotiate for purchase and sale of goods, sellers demanding cash or the buyers banker’s letter of credit as guarantee for payment before they undertake shipment.
         This software is developed to help the buyer to keep the track of his L.C.’s. Using this software the buyer can understand which L.C.’s term when ends along with his available free LC Amount. It also gives him the amount to be paid or to be got back from customs as custom duty.

Team Size 4
Responsibilities Analysis, Coding, Implementation & Data Porting

Project Title:

GAAP Analysis.

Tools

Visual Basic 6.0, Crystal Report8.0, SQL Server2000, Oracle8i., Windows 2000 Server

Project Scope

Project Description:

      Project involves payment and receipt handlings and tax calculations for managing the account. Also activating the project through the balance sheets describing it with statistical analysis and storing them as different transactional challans and reports
Team Size 4
Responsibilities Analysis, Coding, Implementation & Data Porting

Project Title:

7Eleven Sales Analysis.

Tools

Datastage 7.5x2(PX), Oracle 9i, Windows XP, UNIX

Project Scope

7Eleven is one of the largest Retail companies operating. It manufactures and distributes a wide variety of retail products. This is designed for the purpose of sales analysis that basically helps the decision makers to analyze the sales. This system helps to keep track the impact of advertising and other promotion on sales. It is also used to test the effects of pricing changes and varying media weights on local markets. It can compare today’s sales results those of previous year, as well as compare results among chains, geographic regions, and products down to the brand level.

The main objective of the project is to develop a Data mart of Sales System to help the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities.

Team Size 6
Responsibilities

Involved in Analyzing the Source System.

    • Extensively used Ascential Datastage designer to develop Jobs for extracting, transforming, loading data into data warehouse.
    • Involved in Developing ETL jobs using Data stage, supporting all facets of the ETL process such as implementing Source to target mapping
    • Created Parallel jobs using various Stages like Sequential file, Oracle Enterprise, Lookup, Join, Merge, Transformer, Modify, Funnel and Pivot etc.
    • Involved in preparing UTC’S for various jobs assigned.
    • Used Datastage Director to run and monitor the Datastage jobs.
    • Used Datastage Manager to import metadata, new job categories as well as to export and import jobs.
    • Tuned Datastage jobs to obtain better performance.

Project Title:

Sales Analyzing System (SAS).

Tools

Datastage 7.5x2(PX), Oracle 9i, Windows XP, UNIX

Project Scope

This system is mainly concerned with sales and distribution analysis of the products. Company has several branches spread all over Malaysia. Like every emerging company, this company is also searching for business enhancement and competitive edge using information technology to make better business decisions.

Client wanted to have a system that can give them intelligent reports regarding their existing business situation and how they can analyze specifically their business practices.

The main objective of the project is to help the senior and middle level management of the organization to improve the sales by having the knowledge of new business opportunities
Team Size 4
Responsibilities
  • Understanding the specifications provided and involved in OLTP system analysis.
  • Extracted information from flat files with related transaction details with line items such as the overall sale price, products purchased, product category, location of sale and mode of payment
  • Optimizing the job to load the data in Slowly Changing Dimensions.
  • Design the Jobs to load the data into the target based on constraint based load ordering.
  • Developed a job in getting the related values using lookups.
Worked with various stages like aggregator, Transformer. Merge Join and etc

 


Membership of Professional Bodies/Organizations/Associations/Societies.

Sl no.

Organization

1.

Life Member of Indian Society for Technical Education.