Data Stage Consultant Availalable

HI, 

 

This is Shareef from Virgo Systems Inc. I have a Data Stage Consultant Rajesh available for your requirement. I am sending the consultant resume along with

 

This mail. If the skillset matches with your requirement, do let me know.

 

The consultant is available immediately.

           ;           ;           ;           ;           ;           ;     

 

• Over 6 years of experience in System Analysis, Design and Development and implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) using Data Stage.
• Extensively used ETL methodology for supporting Data Extraction, Transformations and Loading processing, in a corporate-wide-ETL solutions using Ascential Datastage 7.5/7.1/5.2/4.0 Parallel Extender, Ascential Datastage, Version Control.
• Proficient in Data analysis, Data modeling, Database design and Data migration.
• Expert in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin 4.0.
• Experience in all phases of DataWarehousing Life Cycle and has good experience in ETL Design Methodology.
• Experience in writing complex AIX and Unix Shell Scripts (Korn Shell, C Shell, Bourne Shell).
• Exposure to other Ascential suite package tools such as MetaStage, Profile Stage and Quality Stage.
• Experience with DataStage packaged application connectivity kit (PACK) for ERP applications such as SAP, Siebel, XML
• Experience in Dimensional Analysis / Multidimensional Analysis and involved in designing Star Schema and Snowflake dimensional data marts using Erwin tool, Microsoft Visio.
• Experienced in ETL Documentation using the standard naming conventions
• Expertise level knowledge in PL/SQL – creating Triggers, Views, Constraints, Stored Procedures and Indexes
• Involved in design, maintenance, performance and query optimization of databases
• Excellent problem solving and interpersonal skills, strong team leadership skills, self-motivated and energetic

 

TECHNICAL SKILLS

 

ETL Tools           ;          IBM Ascential Datastage 4.x/5.x/6.0/7.0/7.5.2, Parallel Extender.

Operating Systems      Windows NT/98/2000, SUN Solaris2.8, HP-UX, Linux and IBM AIX 4.0

Databases           ;         TeraData, Oracle 7.x/8i/9i, DB2, Sybase, DB2UDB, AS400 and MS-Access.

Languages           ;        PL/SQL, Visual Basic, SQL, Pro* C, UNIX shell programming, C, HTML. 

Database Tools           ; SQL Plus, SQL Loader, TOAD, Import, Export, Query Man.

Other Tools           ;       Business Objects 5.x, Designer2000, ER Studio, Erwin, Sync sort, SQL server, Crystal Reports, Actuate Reports 6.0, Quality Manager 6.0, MicroStrategy.

Operating Systems:     Microsoft Windows XP/2000/98/95, AIX, LINUX, UNIX

Languages:     ;           ;  C/C++, Java, SQL, PL/SQL, TSQL, VB6.0, Shell scripting

Hardware           ;          Sun Systems, HP 20, IBM PC, IBM Mainframes.

 

Thanks and regards

SHAREEF