Home » Other » Marketplace » Urgent Requirement in Dataware Housing
Urgent Requirement in Dataware Housing [message #92864] Sat, 24 November 2001 16:26 Go to next message
RRad Soft Services
Messages: 2
Registered: November 2001
Junior Member
Hi all

A IT major in chennai, India is looking for Project leaders and Architects in DATAWARE HOUSING.

The right candidate should have around 5+ years IT exp with around 3 years DWH exp. He should have working exp in DWH/ETL/OLAP/Oracle warehouse builde..

People who are in H-1B and are willing to relocate to chennai can also. Interviews will be conducted over phone.

People with above skill sets please forward your resume to rradsoftservices@yahoo.com

----------------------------------------------------------------------
Re: Urgent Requirement in Dataware Housing [message #92894 is a reply to message #92864] Sun, 27 January 2002 20:04 Go to previous messageGo to next message
mozzam sondai
Messages: 1
Registered: January 2002
Junior Member
I am Student OF ISRA University Hyderabad..
Writing Desertation on DATAWARE HOUSE......
IF u ve any information or best topics for reasarch then mail me.
Re: Urgent Requirement in Dataware Housing [message #92935 is a reply to message #92894] Sat, 20 April 2002 09:06 Go to previous messageGo to next message
Asif Ali
Messages: 4
Registered: March 2002
Junior Member
please send me any infomation on dataware housing . please mail me on above id
Re: Urgent Requirement in Dataware Housing [message #92938 is a reply to message #92894] Tue, 30 April 2002 11:30 Go to previous messageGo to next message
nitya vishnumolakala
Messages: 2
Registered: April 2002
Junior Member
NITYA VISHNUMOLAKALA
434-964-1297/434-825-7663
rao_nitya@hotmail.com

GENERAL Nitya has years of overall experience with 4 years in the US. Good experience as a UDB DB2 DBA and DB2 DBA on IBM mainframe systems and Extended Enterprise Edition. Worked with large databases, both in production and development environments in the area of application software development. Has been involved in analysis, development, conversion and maintenance of application software. Has very good knowledge in SQL. Main skills are on IBM mainframe software (IBM-3090, ES 9000,OS 390) and in the functional areas of Insurance, Automotive and Banking industries. Excellent communication, team playing, organizing and trouble-shooting skills. Has excellent knowledge in AIX 4.3, UBD db2 dba. Preparing for IBM certification of Database Administrator for DB2 UDB Version 6.

EDUCATION Bachelor of Engineering, Regional Institute of Technology, Jamshedpur.

SKILLS Hardware:
IBM ES-9000, 3090, RS6000, SAP/R3.
O / S:
MVS/ESA, MVS/XA, OS/ 390, SunOS2.6HP AIX 4.3, UNIX, WINDOWS NT.

Languages:
OS/VS COBOL, COBOL-II, JAVA, JAVA SCRIPT, JDBC,VB, C, C++, CICS, JCL, VSAM, TSO/ISF, CICS, ABAP/4.

RDBMS:
DB2, Oracle8.0, IMS, IDMS (network database), SQL SERVER7.0.,ODBC

Tools:
SPUFI, EXPEDITER, QMF, PLATINUM, EXPLAIN, BMC,
INFORMATICA 4,7,ETL,MICROSTRATEGY7.0.



EXPERIENCE
Oct 00-Present Wausau Insurance Companies, WI
DB2 DBA


Responsibilities included:

· Used CHANGEMAN , PANVALET to download
Programmes into and work as our local database.
· Installed and configured Db2 database on OS 390.
· Installed websphere 4.0 and configured with DB2.
· Creation of DB2 UDB database from scratch to deployment to production and maintenance level.
· For UDB Logical Design, identified data elements, grouping them together and mapping them into the structure of the database.
While creating the logical design I have concentrated on all data elements, data relationships, transactions and output requirements.
· For UDB Physical Design, selected the storage formats and organizations, space considerations, physical blocksizes for the data. Created Containers, Table spaces and Extents.
· Performed all database management and administration tasks from the simplest create to the most complex alter in either batch or online mode.
· Created Data Joiner Instance for AIX Environment for UDB DB2 environment.
· Performance improved on udb db2 bu using Extended Enterprise Edition to make it conveninet for Symmetric multiprocessors(SMS), clustered SMP and Massively Parellel Processors(MPP) on different operating systems and platforms.

· Using Extended Enterprise Edition, handled to run killer queries.
· Queriees run faster by using Extended Enterprise Edition udb db2.
· Maintain performance linear to hundreds of processor nodes and terabytes of data by using Extended Enterprise Edition.
· Journal file system (JFS)is used for AIX .
· Supported 24x7 production environment and associated with a team of 25 developers.
· Responsible for Tape Backup, Capacity Planning, System Tuning and Disaster/Recovery planning of database.
· Skilled in problem detection, network skills like TCP/IP. Also involved in planning configuration for communication protocols.
· Responsible for Installation, Maintenance and Management across multiple client sites.
· Managed DB2 databases across multiple platforms like Unix and Windows NT In distributed environments using PLATINUM.
· Used PLATINUM to support database schema and object migrations and full object alteration, creation, and deletion.
· For DB2 UDB Database, Spanned the data for a single table across multiple tables spaces using AIX , Data Base Managed Storage. Stored Large Objects and Indexes separately from the data base objects.
· Dynamically Increased number of Containers in Tables Spaces using DMS in order to rebalancing of data.
· Created many logical volumes as containers, and separated them from physical drives to realize true I/O Parellisam.
· Separated db2 hard drives from the drives of AIX logical volumes to avoid sharing of drives.
· Job scheduling for batch jobs on the UNIX platform
· Performed performance monitoring and tuning on UDB DB2 V5.0.
· Created DB2 database objects.
· Estimated table spaces and index spaces.
· Altered the table spaces.
· Improved the access performance of SQL queries using DB2 EXPLAIN.
· Extracted and loaded data from/into tables using DB2 utilities.
· Made full IMAGE COPIES for Backup.
· Ran DB2 Utilities REORG, CHECK DATA on table spaces whenever needed.
Environment: EEE UDB DB2 V7.0. IBM OS/390, Linux 7.0,SAP R/3, ABAP/4,DB2 UTILITIES, BMC UTILITIES, CICS, DB2, VS COBOL II, JCL, TSO/ISPF, XPEDITOR, FILEAID, MVS, PLATINUM, BMC,SPUFI, QMF, ER Diagrams, INFORMATICA 4.7,ETL, MICROSTRATEGY7.0,ORACLE 8.0, MQ-SERIES,MS-Office.


Dec 99-Sept 00 Wausau Insurance Companies, WI
Bdr Conversion Project
UDB DB2 DBA
This is a batch system which consists of a set of batch programs run weekly. This project is intended to convert data from IDMS old flat file system into UDB DB2 database.

Responsibilities included:
· Planned the Logical design of the UDB db2 database.
· Mapped the database design to the layout of table spaces.
· Created the UDB DB2 database.
· Sizes of the tables, any indexes and table spaces noted down.
· Determined the characteristics of the containers in the table spaces.
· For creating physical environment created devices.
· Used PLATINUM products RC/QUERY, RC/MIGRATOR and DB2 command processors at interface level to query, migrate and executing purposes.
· Used PLATIUNM in DB2 UDB environment for Application Development, Data access and Analysis, Data Warehousing and Database Administration.
· Designed the UDB DB2 database at unit and acceptance level.
· Used AIX device Container as a logical volume based on the type of table space and plat form.
· Backup and Recovery Process at the Table space level.
· Used Extents for storing the user data and for the space management with the table space.
· Job scheduling for batch jobs on the UNIX platform
· Run the DB2 utilities LOAD, FULL IMAGE COPIES, DATA CHECK and REORG on the table spaces and index spaces whenever needed.
· For accessing the remote database, used alternate Index as UBD db2dba.
Environment : UDB DB2 V5.0.IBM OS/390, AIX 4.3, DB2, IDMS, VS COBOL II, DB2 UTILITIES, PLATINUM, XPEDITOR, FILEAID, BMC,CHANGEMAN,SPUFI, QMF, ER Diagrams, Explain, MS-Office, TSO/ISPF.


Sep 97-Nov 99 AARP Pharmacy Services, Roanoke, VA
Comprehensive Automotive Processing Systems(CAPS)
DB2 DBA
AARP Pharmacy Services is a leading pharmacy industry. The AARP's major business activities are computerized by using the project Comprehensive Automated Processing System (CAPS), which consists of many applications like Order Processing, Accounts Receivable, and Credit Card Processing, Employee
Payroll and Inventory system.

Responsibilities included:
· Designed, developed and supported the mainframe IMS/DB2 application.
· Developed and coded Java applets using Visual Age.
· Client scripts were written using JavaScript.
· Implemented JDBC in the Server program to update and retrieve Price information database.
· Performed feasibility study on Mainframe to server solution and produced. functional and detailed specifications to implement solution.
· Produced functional specifications and detail specifications.
· Produced database support and training manuals.
· Disaster recovery and planning.
· Support the systems groups on system related issues.
· Backup and recovery procedures.
· Creating database objects (tables, views), altering tables and adding check constraints, triggers and referential integrity using EXPORT and IMPORT utility.
· Moving data between tables and output files.
· Monitoring and problem determination.
· Optimizing the database.
· Inserting the data to DB2 table using LOAD utility.
Environment IBM-3090, MVS, DB2, DB2 UTILITIES, CICS, IMS/ dB, VS COBOL II, JCL, TSO/ISPF, XPEDITOR, FILEAID, SPUFI, QMF, JAVA, VISUAL AGE, HTML,WEBSPHERE 4.0, JAVA SCRIPT, JDBC.

Aug 96- Aug 97 South Western Bell, St. Louis, Missouri
DB2 Database Administration of the ETQIS application
DB2 DBA
Currently working in the capacity of a DB2 Database Administrator / developer on the ETQIS team which is part of this team for developing the 271 performance measurements. This will help South Western Bell compete with other companies as a long distance telephone service provider.

Responsibilities included:
· Translating customer business requirements into database specific requirements.
· Providing normalized design of database based on business requirements.
· Design involves details including tablespace size, lock sizes, table structures,
· View definitions, constraints like Unique Index, Check constraints and Referential integrity constraints if applicable, Triggers and Stored Procedures if necessary.
· Creation and maintenance of database and all physical objects like tablespaces, tables, views, triggers, and stored procedures.
· Extensively worked on writing DB2 stored procedures.
· Granting privileges on the database.
· Creation of jobs and/or programs for loading the database.
· Application monitoring and SQL tuning using tools like T-MON, EXPLAIN and DB2 commands. Provide solutions for minimizing lock contention.
· Decide IMAGE COPY (and type of image copy), RUNSTATS and REORG frequency.
· Running Explain for Performance tuning of SQL within applications.
· Provide production support.
Re: Urgent Requirement in Dataware Housing [message #93034 is a reply to message #92894] Sat, 05 October 2002 18:21 Go to previous messageGo to next message
sagar
Messages: 11
Registered: December 2000
Junior Member
Hi,
I am new to Dataware housing, I would like to know what are the requirements to install and what are the demand tools in the market.
please let me know wher can i find documentaion

thanks,
sagar
Re: Urgent Requirement in Dataware Housing [message #93044 is a reply to message #93034] Wed, 16 October 2002 11:30 Go to previous messageGo to next message
shekhar chandra
Messages: 1
Registered: October 2002
Junior Member
imwant to know about this term.
please help me.
Urgent Requirement in Dataware Housing [message #93097 is a reply to message #93034] Fri, 17 January 2003 20:49 Go to previous messageGo to next message
Atul Rambhad
Messages: 2
Registered: January 2003
Junior Member
hi,
Pl. send me the details of Data warehousing.
I don't know anything about this .
How can start and from which books.
Tell me the tools. And from where i can get the tools

Bye
Re: Urgent Requirement in Dataware Housing [message #93239 is a reply to message #93034] Fri, 30 January 2004 04:53 Go to previous messageGo to next message
saimaithri
Messages: 1
Registered: January 2004
Junior Member
Hi,
I am new to Dataware housing, I would like to know what are the requirements to install and what are the demand tools in the market..
please let me know wher can i find documentaion
thanks,
saimaithri
Re: Urgent Requirement in Dataware Housing [message #93249 is a reply to message #92894] Tue, 17 February 2004 23:07 Go to previous messageGo to next message
D.Arvinkumar
Messages: 1
Registered: February 2004
Junior Member
Hi,
I am ArvinKumar,
Presently Working as SoftwareEngineer.

Areas :
C++,JAVA,JSP,J2EE(under training).
ORACLE9i,ORACLE9I DBA,DatawareHousing.
Present Postion : Team Leader
Current Salary : 20K
Experience
Java: 12 Months,
JSP : 8 Months
Swing : 4 Months
DataWareHousing : 12 Months
Oracle(SQL,PL/SQL,DBA) : 30 months(2&1/2 years)

Contact Info:
Mobile:37806427
Res:27806427.
Mail id:arvinkumar@rediffmail.com,arvinkumar@myway.com,arvinkumar@lycos.com

Thanks
Regards
Arvin Kumar.
Re: Urgent Requirement in Dataware Housing [message #93269 is a reply to message #92894] Thu, 01 April 2004 02:56 Go to previous messageGo to next message
pranali j. chaudhari
Messages: 1
Registered: April 2004
Junior Member
please send info immediately
Re: Urgent Requirement in Dataware Housing [message #93274 is a reply to message #93269] Sat, 10 April 2004 13:53 Go to previous messageGo to next message
gerardo
Messages: 2
Registered: January 2002
Junior Member
quiero saber todo sobre Dataware Housing
Re: Urgent Requirement in Dataware Housing [message #93343 is a reply to message #92894] Fri, 06 August 2004 02:22 Go to previous messageGo to next message
Habeeb
Messages: 61
Registered: August 2000
Member
hii,
i want to learn dataware housing course.how is the job oppertunities on this?is my decision is good or not?
please suggest me....
regards,
habeeb
Re: Urgent Requirement in Dataware Housing [message #93412 is a reply to message #93343] Sat, 11 December 2004 03:25 Go to previous messageGo to next message
iena
Messages: 1
Registered: December 2004
Junior Member
i need your help about critic of data ware housing.
please??
Re: Urgent Requirement in Dataware Housing [message #93422 is a reply to message #93269] Wed, 22 December 2004 19:40 Go to previous messageGo to next message
Sreenivasulu
Messages: 2
Registered: July 2002
Junior Member
HI,
I am sreenivas.

I have a doubt,

What is the difference between report generated in cognos and cognos reportnet.
If any one knows the exact answer u can pls mail me .

Mailto: sgangeneni@rediffmail.com
Re: Urgent Requirement in Dataware Housing [message #93453 is a reply to message #93343] Sun, 30 January 2005 21:24 Go to previous messageGo to next message
Murali Krishna
Messages: 9
Registered: April 2002
Junior Member
Hello Habeeb,
There r good number oppertunities for DWH
But every where companies are asking for experienced people with minimum of 2 years.U can concentrate on ETL tools like informatica.
Re: Urgent Requirement in Dataware Housing [message #93472 is a reply to message #93274] Tue, 15 February 2005 22:40 Go to previous message
rajesh
Messages: 173
Registered: November 1998
Senior Member
hello
im rajesh now i want the requirement in dw.i completed engg.im the fresh batch in dw.so give me the details.
thanking u
rajesh
Previous Topic: Urgent Openings with CMM Level 5 Companies in Chennai
Next Topic: Oracle Financials System Administrator / Seattle / 2085
Goto Forum:
  


Current Time: Fri Mar 29 06:12:00 CDT 2024