SrilekhaRishi

This blog provides MSBI stuff and Interview Questions

SunGard is a Fortune-500 company and global leader in integrated software and processing solutions for financial services, higher education and public sector. SunGard also helps information-dependent enterprises of all types to ensure the continuity of their business. With annual revenues of $5 billion, SunGard serves more than 25,000 customers in more than 50 countries, including the world's 50 largest financial services companies.

SunGard has over 70 subsidiaries around the world developing software in domain areas including:

a. Institutional Asset Management & Securities
b. Trading, Treasury & Risk Management
c. Wealth Management & Brokerage Operations
d. Benefit Administration & Insurance
e. Higher Education
f. Public Sector

SunGard's Leadership position in financial systems

1. Customers include the world 50 largest financial services companies
2. $25 trillion in investment assets are accounted for and managed daily on our systems
3. More than 5 million trades are processed daily by broker-dealers and other financial intermediaries on our systems
4. 70% of Nasdaq trades flow through our systems

SunGard's Leadership position in higher education and public sector
1. More than 1,600 universities and colleges rely on our administrative, advancement, and academic solutions
2. 10 million learners rely on our technology solutions to help improve teaching, learning, and research
3. Data on more than 16 million alumni is entrusted to our advancement and fundraising solutions
4. Over 800 cities and counties, 600 public safety agencies, and 600 schools and school districts also rely on our solutions.

SunGard Technology Services is a fully owned subsidiary of SunGard Data Systems Inc, USA with global product development centers in Bangalore and Pune. With 0ver 2400+ employees, we are located in the Central Business District and the centres boasts of world-class infrastructure and work systems.
Designation MS BI ( SSAS / SSRS / SSIS )
Job Description

• We are looking for candidate with 4+years IT experience.

• 2+ years of Experience with Microsoft BI Technology (SSAS, SSRS, SSIS, MDX, T-SQL).

• Develop and support a data warehouse, business intelligence solutions and a reporting environment surrounding the Sun System.

• Develop and support complex reports in an OLTP environment.

• Design, develop, deploy and maintain cubes and BI solutions using SSAS

• Develop and maintain reports and queries for end users using SSRS against both, OLTP and OLAP, environments.

• Develop and maintain ETL processes using SSIS

• Work with DBA’s to transition to SQL Server 2008.

• Construct KPI’s to be used in reports.

• Advance T-SQL skills (2005/2008).

• Extensive knowledge of MDX.

• Support the production environment and resolve production issues.
Desired Profile

Mandatory Skills

• SSAS

• SSRS

• SSIS

• Excellent T-SQL skills

• Extensive MDX

Desired Skills

• C# experience a plus

• Executive Vie