PROFESSIONAL SUMMARY:
• 8 years of experience in PL/SQL and Data warehousing technologies • Strong experience in Data Warehousing, Data Analysis, ETL, Reporting tools, Testing methodologies, Development, Maintenance and Documentation • Extensively worked with Informatica Tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager • Extensively used Erwin for Data modeling and Dimensional Data Modeling • Experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema, which are used in relational, dimensional and multidimensional modeling • Experience in Performance tuning of targets, sources, mappings and sessions • Experienced in loading data into Data Warehouse/Data Marts using Informatica, Oracle Scripts and SQL*Loader • Knowledge in Informatica Power Exchange with R/3 • Three years of experience in IT industry with experience in sustenance of Teradata RDBMS and expertise in Teradata Data-warehousing, Database internals and Teradata SQL and ETL Concepts • Knowledge in open source ETL tool KETL • Extracted data from and to relational,flat file sources and XML data sources through jdbc interface • Knowledge in Aster ncluster jdbc and odbc interfaces which are supported by majority of BI tools • Expert in normalizing the data using BCNF and 3 NF • Four years of experience in working with Cognos ReportNet 1.1/1.02 and IBM Cognos8 • Extensive experience in modeling using Framework Manager including applying table level, and data level security. • Experience in creating Universes, various types of Reports and Charts for Decision Support Systems (DSS) using Business Objects XI • Proficient in use of Business Objects 5.x/6.x Designer, Reporter, Supervisor, Web-Intelligence 2.x, 6.x, and Broadcast Agent Server. • Experience in optimizing query performance, session performance and fine tuning of mappings for optimum performance • Strong troubleshooting skills, strong experience of working with complex ETL in a data warehouse environment • Experience with pre-session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes • Excellent problem solving skills with a strong technical background and good interpersonal skills • Experience in Unix Shell scripting , scheduling cron jobs and also Job Scheduling on multiple platforms like Windows NT/2000/2003,Unix • Strong technical skills in Oracle, SQL, PL/SQL and Teradata • Excellent Team player and can work on both development and maintenance phases of the project • Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels • Quick learner and excellent team player, ability to meet tight deadlines and work under pressure TECHNICAL SKILLS: ETL Tools Informatica (Power Center 8.x/7.1.2/6.2/5.1), Data stage Operating Systems Windows 2000/NT/98/95, Sun Solaris 2.x, HP-Unix, Red Hat Linux 7.2/7.3 RDBMS Oracle 9i/10g/11g(SQL, PL/SQL, Stored Procedures, Functions), MS-Access 2002/2003, Teradata V2R4.1/V2R5, SQL Server 2005/7, DB2 Data Base Tools Toad, SQL Navigator 4.0, SQL Loader Data Modeling Erwin Reporting tools Business objects XI/5.x/6.x, IBM Cognos 8, Cognos Report net Scripting Unix Shell Scripting. Web Technology HTML, Java Script Languages C, C++, Java, HTML, SQL,PL/SQL *Thanks & Regards* * * *Chris *** *VOLGA Systems & Services, Inc.* *(*408) 216. 7673 (Voice) (413) 235.7695 (Fax)* *ch...@volgasystems.com* *www.volgasystems.com http://groups.google.co.in/group/recruiting-simplifies Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at ch...@volgasystems.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "oraapps" group. To post to this group, send email to oraapps@googlegroups.com To unsubscribe from this group, send email to oraapps+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/oraapps?hl=en -~----------~----~----~----~------~----~------~--~---
