*Summary* * *
Ø *7 years* of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) /Enterprise Data warehouse (EDW) analysis, design, development, Testing and implementation. Ø *6 years* of experience in populating and maintaining Data warehouses and Datamarts using *IBM Information Server v8.0.1*,*Ascential* *DataStage v** 7.5.x/7.x* (*Administrator, Director, Manager, Designer*) – Server Edition, Enterprise Edition (*Parallel Extender)*,* *and *Quality Stage*. Ø Expertise in Relational Database Modeling and Dimensional Modeling-*Star schema*,* Snow-Flake schema*, and hands on experience in data modeling tools *Erwin / Microsoft visio.* Ø Experienced in troubleshooting DataStage jobs, enhancement of jobs and addressing production issues like performance tuning and enhancement. Ø Optimized DataStage jobs utilizing parallelism, partitioning and pipelining features of Parallel Extender. Ø Experience in designing *Job Batches* and *Job Sequences* for scheduling server and parallel jobs using DataStage Director,* UNIX* scripts. Ø Experience in migrating ETL code to upgraded version. Ø Experience in programming using *SQL, PL/SQL, *and* UNIX Shell Scripting. * Ø Extensive experience in Microsoft *SQL Server* 2005/2000, *IBM DB2* UDB 8.0/7.0, *Informix*,*TeraData*, *Oracle 10g/9i/8i*., *XML files* and *Message Queues*. Ø Strong Experience in Unit testing and System testing of the DataStage jobs. Ø Experience in Scheduling the DataStage jobs using *Control-M, Autosys*. Ø Knowledge on designing and developing reports using BI/OLAP tools like Business Objects and Cognos. Ø Involved in *Documentation of ETL process* following the standard naming conventions used in DataStage. Ø Excellent communication and interpersonal skills, teamwork, problem solving skills, flexible, self-direct and energetic person. Ø Experience in *DataStage* *Administrator* to create/modify/delete projects, add DSN entries and cleanup projects and Implemented security among *DataStage* users and projects. Ø *IBM Certified Solution Developer* -- Websphere IIS *DataStage*Enterprise Edition V7.5 Parallel Extender. OUR CONSULTANTS ARE AVAILABLE ONLY FOR DIRECT CLIENT REQUIREMENTS. *Rita Kanna* *Business Development Manager* *EGEN SOLUTIONS INC*** *Innovation, High performance, Results * *PH: (630)-270-2642* *E-mail id: **[email protected]* *GTALK or Yahoo : ritakanna* *Linkedin:*www.linkedin.com/in/ritakanna ** -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/business_intelligence?hl=en.
