BusinessIntelligence-SumitKhemka.docVIP

Sumit Khemka Bangalore, India khemkasumit@ +91 9886632360 Professional Summary 8.5+ years of experience in Information Technology, with 2 years at London (UK) and Houston (US). Domain knowledge in Data Quality, Market Risk and Pricing (MVAR), Health Quality Measures (MU Quality Reporting), Mortgage Servicing. Experience in Shared Services, Matrix organization and Agile model of project execution. Certified MCP and MCTS in SQL Server and Business Intelligence and .NET 2.0. 7 years of experience in Data warehousing and Business Intelligence tools. 6 years strong experience with SQL Server 2005/2008/2012 databases. 6 years strong experience with Microsoft Business Intelligence Suite .ie SSIS,SSRS SSAS. 2 years working experience on Oracle Databases. 1 year technical hands-on experience on Informatica 8.6/9.0 and Business Objects XI R3 tools. 1.5 years’ experience working on LogiXML SpagoBI reporting tool. Strong experience on T-SQL, Query Optimization and Performance Tuning. Very good experience and understanding of database design/modeling, OLAP, OLTP systems. Good experience on .NET framework especially in ASP.NET client/server technology. Strong knowledge of SDLC such as developing, testing, migrating and production support (L3 support). Experience on Service Quality management tools such as Remedy, JIRA, Mercury QC, and ClearQuest. Experience on configuration management tools such as SVN, Perforce, ClearCase and VSS. Experience on scheduling tools such as TIDAL, SQL Server Agents, Windows scheduler. Excellent communication skills bridging Client Interaction and Team Management. Strong analytical, problem troubleshooting/solving skills, self-starter. Experience at providing organizational trainings especially in BI tools. Experience of working with business users, traders and IT. Exposure to Proposal/Estimation Discussions and SMC model. Technical Competencies Business Intelligence : SSIS, SSAS, SSRS, Informatica, Business Objects,