Title:Vice President

abpw6z@r.postjobfree.com

Document

Source below

NAME: sairam, sairam

ADDRESS: **** ********* *****

ADDRESS2:

CITY: walnutcreek

STATE: CA

ZIP: 94596

CANDIDATE ID: 2243903

US CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: Open -

JOB WANTED: Any

RATE NEEDED:

TELEPHONE:

EMAIL: abpw6z@r.postjobfree.com

HOMEPAGE:

HOTTEST SKILLS: 2167, 3270, 80.86, a+ certification, abap, active server, activex,

animation, apache, applet, as 400, as/400, as400, assembly language, athlon, autocad,

automatic test equipment, aviation, baan, banyan

REVISION: 24-SEP-01

YOE: 5

RESUME:

SAIRAM

Tel: 925-***-**** or 925-***-****,51,52,53

Experience Summary

Over 5 and half years of software development experience. During the tenure in IT

field, I involved in developing & designing of several client server applications and

middle wares. 2years implementation of OLTP / OLAP (Data Warehousing & Web Housing).

UsingBusinessObjects(4.x,5.x),WEBIntelligence2.6,andETL tools Data

Junction,Informatica.

Involved in BO supervisor module and BO system administration.

Client server middleware and techinical witing of system manuals, user manuals and

applications specificaton and system flows. Involved in object oriented analysis.

Using PL/SQL, SQL Plus, Developer 2000 Microsoft Visual Basic 5.0/6.0,VBA with MS SQL

Server 6.5,Oracle 7x/8x,Msaccess, DB2, DB2,-400,COM,DCOM, Crystal Reports 5.0/6.0, DAO,

RDO,ADO, developing the Custom Commands, Custom applications using the Active-X components

.

Experienced in working with ASP Technology, Web Methods, VB Script, and Java Script

HTML applications Visual Interdev 6.0 and IIS 4.0.

Experienced in web-site designing, coding and testing phases of application development

With emphasis on the servers MTS, SNA, IIS, DCOM Engines

TECHNICAL SKILLS

LANGUAGES : COBOL, SQL, JCL, C++, PL/SQL, SQL Plus,

OLAP TOOLS : Business Objects (4.x, 5.x), WEBI 2.6,Erwin

ETL TOOLS : DATA JUNCTION,INFORMATICA

GUI : VB5.0/6.0,MS VISUAL INTERDEV 6.0.

OPERATING SYSTEM : MVS/ESA, UNIX, MSWIN-95, Win NT.

RDBMS : MS-access,ORACLE7x & 8.x, SQL-SERVER-6.5,&7.0.

UTILITIES : TSO, ISPF/PDF, VSAM.

SCRIPTING LANGUAGES : VBSCRIPT, JAVASCRIPT.

REPORTING : Crystal reports 7.0/8.0,seagate info 7.0

INTERNET : WEB METHODS, HTML, DHTML, XML,

IIS, ASP, TCP/IP, FRONT PAGE

COMPONENTS : DAO, RDO, ADO, ACTIVE-X, and ODBC

MONITORING TOOLS : MSMQ series, Document and Broadcast agents

SERVER TECHNOLOGIES : MTS, SNA, IIS, DCOM Engines

MICROSOFT CERTIFICATION IN VISUALBASIC 5.0

Brain bench certification for Crystal Reports 7.0

Project #1

Mar 2001 Till Date,

PIMS(Procurement information management service)

InterPro, Pleasanton, USA.

This project deals with procurement of data from data ware housing system. I developed

Universes from the existing data ware house system. Mapping the universe from its complex

cities in to user understandable .The data that involved in this project is coming from

three different data sources. Created three different universes and linked them to get

reports.

Created groups and Users and implemented row level Security through Supervisor. Developed

Canned Reports like daily, weekly, bi- weekly, monthly, quarterly, yearly and distributed

through repository scheduled through Broadcast Agent.

Developed three Universes. Universes are Expense Express, Credit card,supplier.

Connected multiple Aggregate tables using Aggregate Aware Function.

Created Hierarchies on Region and Time classes and created customize LOVs.

Resolved the Loops by using Aliases and Contexts.

Technical writing of system specifications and manuals.

Building universes and universe modification using Business Objects 5.1.1

on oracle and sybaseasdatabase.

Used Data junction to create complex mappings using different transformations to move

data

to multiple databases .

Worked extensively with complex mappings using expressions, aggregators, filters and

procedures to develop and feed Data Marts.

Created various stored procedures. Used the repository manager to give permissions to

users, create new users, repositories.

Tuned the mappings to perform better using different logics to provide maximum

efficiency and performance Complete knowledge of Repository Manager to create user groups

and user profiles with privileges of AdministratorInvolved in full life cycle of Business

Objects reporting application.

Environment

Windows NT,Oracle 8i,Business Objects 5.1, Web Intelligence2.6, Data Junction 7.0.,Toad

And BO system administration.

Project #2

Nov 2000

Feb2001,

Helpdesk Reporting,

Genoa, Fremont, USA.

This project Developed to review the semiconductor and computer information on systems.

Developed Data Mart (Star schema) and built a BO Universe for help desk to review the

latest computer information (like disc space, software & hardware installed and etc).

Reports distributed to users through repository. Created groups and Users and implemented

row level Security through Supervisor. Developed Canned Reports like daily, weekly, bi-

weekly, monthly, quarterly, yearly open/close tickets, assigned ticket list to help desk

technical support and scheduled through Broadcast Agent. Data Mart refreshed daily through

Data Junction scripts.

Developed Universes. Universes are software, hardware,devices

Connected multiple Aggregate tables using Aggregate Aware Function.

Created Hierarchies on Region and Time classes and created customize LOVs.

Resolved the Loops by using Aliases and Contexts.

Technical writing of system specifications and manuals.

Used Data junction to create complex mappings using different transformations to move

data

to multiple databases .

Worked extensively with complex mappings using expressions, aggregators, filters and

procedures to develop and feed Data Marts.

Created various stored procedures. Used the repository manager to give permissions to

users, create new users, repositories.

Tuned the mappings to perform better using different logics to provide maximum

efficiency and performance Complete knowledge of Repository Manager to create user groups

and user profiles with privileges of AdministratorInvolved in full life cycle of Business

Objects reporting application.

Environment

Windows NT,Oracle 8i,Business Objects 5.1, Web Intelligence2.6, Data Junction 7.0

And BO system administration.

Project #3

Jan '2000

Oct2000KEPPEL Engineering, Singapore.

(Preventive Management System).

Project Profile; Keppel Engineering deals with Equipments, which manages and supplies to

the to the big corporate clients like Airport, General Hospitals, Shipyard, Road

Transportation and etc. This system is developed for the different services provided to

them. Kipper Engineering deals with equipments like electrical, mechanical, air

conditioning, buildings and car parking.

Actually this project deals with time scheduling for technical support provided to

corporate clients and also keeps track of different modules like Inventory, preventive

Maintenance, Building Fault Report, PM work Records and Work order.

My Role:

I involved in developing

1 module: Preventive maintenance system for Kipper Engineering (Airport and Shipyard).

Developed two Universes. One for Airport and another for Shipyard .

Connected multiple Aggregate tables using Aggregate Aware Function.

Created Hierarchies on Region and Time classes and created customize LOVs.

Resolved the Loops by using Aliases and Contexts.

Developed Canned Reports like daily, weekly, bi- weekly, monthly, quarterly, yearly and

distributed through repository.

Created various groups and Users through Supervisor.

Created and Used Document Agent Server to schedule the reports.

Environment

Tools: Oracle 8,Business Objects 4.1.7, Windows NT .

Project #4

Apr '1999

Dec1999POS-BANK, Singapore.

(Customer Management System).

Project Profile; POS-Bank deals is one of the leading banking industry in the Singapore.

this project is developed to maintain customer details and their transaction in online. It

provides the and few of their transaction entered in the database. Developed Star schema

and built a BO information about customers checking and saving amount details Universe for

Reports distributed to users through repository.

Created groups and Users and implemented row level Security through Supervisor. Developed

Canned Reports like daily, weekly, bi- weekly, monthly, quarterly, yearly open/close

accounts, scheduled through Broadcast Agent. Data Mart refreshed daily through Data

Junction scripts. Created universes for checking,saving,time management systems.

My Role:

I involved in developing

Developed two Universes. One for checking and another for Savings .

Connected multiple Aggregate tables using Aggregate Aware Function.

Created Hierarchies on Region and Time classes and created customize LOVs.

Resolved the Loops by using Aliases and Contexts.

Developed Canned Reports like daily, weekly, bi- weekly, monthly, quarterly, yearly and

distributed through repository.

Created various groups and Users through Supervisor.

Created and Used Document Agent Server to schedule the reports.

Environment

Tools: Oracle 8,Business Objects 4.1.7, Windows NT .

Project #5

Nov' 1998

Mar1999

(Attendance Monitoring System

)

Description : Supervised the analysis and design of the system. The system uses SQL*LOAD

to convert the non-text file from the Daily Time Recorder (DTR) machine to a database

table. It also maintains attendance of non-swiping employees and reconciles these with the

DTR entries along with the other DTR exemptions. The system automatically records to each

employee leave card all leaves of absences (i.e. sick leaves, vacation leaves, special

leaves, forced leaves, etc.) and any unauthorized absences. The system also computes for

the number of hours of leave without pay. Leads the quality assurance and control team in

testing the completed programs and modifying the programs, if necessary.

Project 6 :

Jan1998

- Oct1998

(Provident Fund Information System)

Description : Led the team that conducted system investigation and system design. The

Provident Fund is a retirement benefit plan which is an incentive to all permanent

employees. Its funding comes from a shared contribution between the employee and the

corporation. Its principal function is to provide trust and/or loans at interest that each

member can avail of in accordance to existing policies. Performs testing and quality

assurance of completed programs.

Environment : Oracle 7.3, PL/SQL, SQL Plus, UNIX SVR4

Project : 7

Apr 1997

Dec 1997

(Payroll Information System)

Description : Specifically analyzed the business rules and procedures given by the users.

Designed the system as part of the Integrated Financial Management System (IFMS). The

Payroll Information System (PIS) is a comprehensive system that captures all transactions

concerning the payroll of employees and produces the complete set of external reports to

other government agencies. Fully involved in the development phase of the system in terms

of code generation, PL/SQL debugging and program modification. Conducted testing and

quality assurance of completed programs. Provided technical support and end-user training.

Environment : Oracle 7.3, PL/SQL, SQL Plus 3.3, UNSVR4

Project : 8

Nov 1996

Mar1997

(Cash Management System)

Description : Performed gap analysis between the old CMS and the users new requirements.

Designed the system as part of the Integrated Financial Management System (IFMS). The Cash

Management System (CMS) is a system that records and monitors the disbursements of checks

and collections of payments of HIGC. These transactions are subsequently posted to the

subsidiary and general ledgers maintained by the Treasury and Controllership Departments

of the company. Developed 25 forms and 23 reports and was also responsible for the

integration testing of the system and end-user training.

Environment : Oracle 7.1, PL/SQL, SQL Plus 3.3, UNIX SVR4

Project 9 :

Mar1996

Oct1996

Retail Guaranty Information System

Description : Solely responsible for the analysis and design of the new system. It

records the initial enrollment of housing loans for guaranty, the subsequent renewals and

consolidation of the guaranty by funds/banks and the payment of claims to the funds of

called accounts. The Retail Guaranty is a guaranty facility that accredits funds for

insurance coverage of housing loans granted to individuals for the purpose of home

acquisition. Part of team which develop the programs, provided technical support and

conducted end-user training. In total, developed 45 programs consisting of 28 forms and 17

reports.

Environment : Oracle 7.1, PL/SQL, SQL Plus, UNIX SVR4

Project 10:

oct1995 Feb 1996

Cash Flow Guaranty Information System

Description : Performed gap analysis between the old CMS and the users new requirements.

Solely responsible for the design of the system. It is a system that captures and monitors

all activities involved in the administration of the Cash Flow Guaranty Fund by HIGC, such

as: enrollment of loan accounts for guaranty, post-auditing of accounts, renewal of

guaranty, calling of accounts, consolidation, redemption and disposition of called

accounts. The Cash Flow Guaranty Fund specifically covers the housing loans directly

funded by the Social Security System (SSS), Government Service Insurance System (GSIS) and

Home Development Mutual Fund (HDMF).In total, developed 60 programs consisting of 33 forms

and 27 reports.

Environment : Oracle 7.1, PL/SQL, SQL Plus 3.3, UNIX SVR4

Project 11:

Jan1995

Dec1995

Asset/Mortgage Backed Securities Information System

Description : Responsible for the analysis and design system. The system records the

enrollment of loan accounts for securities and the claims of the sellers/services for

guaranty payments in the event of borrowers default. The system also monitors the

payments of such claims and the refunds HIGC gets when defaulting borrowers pay their

outstanding amortization dues to the sellers/services. The Asset Mortgage Backed

Securities are participation certificates, representing undivided ownership interest in a

pool of balances on receivables covering loans backed up by residential properties, issued

for the purpose of providing liquidity to the funds of home mortgage. In total, developed

62 programs consisting of 38 forms and 24 reports.

Environment : Oracle 7.3, PL/SQL, SQL Plus 3.3, UNIX SVR4

Contact this candidate