Hi Friends,
This position is located in New York, NY. • Design and Develop highly performing OLAP Data marts for Securities Reporting and support and maintain the same • Design and Develop data access layers and interfaces using *SQL and MDX for providing data to Dashboard, custom reports etc.,*** • Design, Develop and Support* Formatted and Adhoc reports* • The ability to scale to large volumes of data and large numbers of concurrent users • Consistent, fast query response times that allow for iterative speed-of-thought analysis • Integrated metadata that seamlessly links the *OLAP server and the data warehouse** *• relational database • The ability to automatically drill from summary and calculated data, which is managed by the • OLAP server, to detail data stored in the data warehouse relational database • Ability to come up with a calculation engine that includes robust mathematical functions for computing derived data • (aggregations, matrix calculations, cross-dimensional calculations, OLAP-aware formulas and • procedural calculations) • Seamless integration of historical, projected and derived data • A multi-user read/write environment to support users what-if analysis, modeling and • planning requirements • The ability to be deployed quickly, adopted easily and maintained cost-effectively • Robust data-access security and user management • Availability of a wide variety of viewing and analysis tools to support different user communities • Microsoft Analysis Services • * **MDX Reporting/Integration/DOS Sampling* • Expert in Data-Warehousing Solutions with *Analysis Services 2000, SSAS 2005 and SSAS 2008 & SQL Server 2000 - Data ETL with DTS and SSIS 2005 (migration to SSIS); SSRS 2005 and SSRS 2008 ; AB Initio ; Informatica 7.1; ErWin 7*** *•* Large Database design both *OLAP and OLTP *(data-marts and subject areas) • Extensive experience in programming* T-SQL,PL/SQL and writing complex stored procedures; complex relational and dimensional data modeling; DB2 SQL; Teradata SQL ; Oracle PL/SQL Expert complex Business Case Solutions with MDX and multi-dimensional math modeling with MDX*** *Resumes with the following information will be given preference.* *Full Name:* *Current Location:* *Relocation:* *Availability:* *Work Authorization in US:* *Contact Number:* *Email:* *Rate on C2C:* * * *Please ensure all candidates have all skills listed under "Required Skills" in their resume.* * * *Reply - [email protected]* -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" 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/oracle-projects?hl=en.
