b'Sumit Khemka\n\nBangalore, India\nkhemkasumit@gmail.com\n+91 9886632360\n\nPROFESSIONAL SUMMARY\n\n\xef\x82\xb7\n\n8.5+ years of experience in Information Technology, with 2 years at London (UK) and Houston (US).\n\n\xef\x82\xb7\n\nDomain knowledge in Data Quality, Market Risk and Pricing (MVAR), Health Quality Measures (MU Quality\nReporting), Mortgage Servicing.\n\n\xef\x82\xb7\n\nExperience in Shared Services, Matrix organization and Agile model of project execution.\n\n\xef\x82\xb7\n\nCertified MCP and MCTS in SQL Server and Business Intelligence and .NET 2.0.\n\n\xef\x82\xb7\n\n7 years of experience in Data warehousing and Business Intelligence tools.\n\n\xef\x82\xb7\n\n6 years strong experience with SQL Server 2005/2008/2012 databases.\n\n\xef\x82\xb7\n\n6 years strong experience with Microsoft Business Intelligence Suite .ie SSIS,SSRS & SSAS.\n\n\xef\x82\xb7\n\n2 years working experience on Oracle Databases.\n\n\xef\x82\xb7\n\n1 year technical hands-on experience on Informatica 8.6/9.0 and Business Objects XI R3 tools.\n\n\xef\x82\xb7\n\n1.5 years\xe2\x80\x99 experience working on LogiXML & SpagoBI reporting tool.\n\n\xef\x82\xb7\n\nStrong experience on T-SQL, Query Optimization and Performance Tuning.\n\n\xef\x82\xb7\n\nVery good experience and understanding of database design/modeling, OLAP, OLTP systems.\n\n\xef\x82\xb7\n\nGood experience on .NET framework especially in ASP.NET client/server technology.\n\n\xef\x82\xb7\n\nStrong knowledge of SDLC such as developing, testing, migrating and production support (L3 support).\n\n\xef\x82\xb7\n\nExperience on Service & Quality management tools such as Remedy, JIRA, Mercury QC, and ClearQuest.\n\n\xef\x82\xb7\n\nExperience on configuration management tools such as SVN, Perforce, ClearCase and VSS.\n\n\xef\x82\xb7\n\nExperience on scheduling tools such as TIDAL, SQL Server Agents, Windows scheduler.\n\n\xef\x82\xb7\n\nExcellent communication skills bridging Client Interaction and Team Management.\n\n\xef\x82\xb7\n\nStrong analytical, problem troubleshooting/solving skills, self-starter.\n\n\xef\x82\xb7\n\nExperience at providing organizational trainings especially in BI tools.\n\n\xef\x82\xb7\n\nExperience of working with business users, traders and IT.\n\n\xef\x82\xb7\n\nExposure to Proposal/Estimation Discussions and SMC model.\n\nTECHNICAL COMPETENCIES\n\nBusiness Intelligence\n\n: SSIS, SSAS, SSRS, Informatica, Business Objects, LogiXML,SpagoBI\n\nRDBMS\n\n: MS SQL 2005/2008/2012, ORACLE 10g, MS Access, MySQL,\n\nLotusNotes Operating Systems : Windows 2003, XP, Win 7-64bit, Win 8, MS-DOS\nConfiguration Management\n\n: Rational ClearCase, Visual SourceSafe, Perforce\n\nService & Quality Management\n\n: JIRA, Remedy, ClearQuest, Mercury QC\n\nWeb Technology\n\n: HTML, XML, Jscript, VBScript, ASP, ASP.NET, JSP, WebServices, Basic PHP\n\nApplications & IDE\n\n: VS.NET, BIDS, Visual Studio 6.0, intelliJ IDEA, Eclipse, MS Office,\nFlash, Dreamweaver, LotusNotes Designer\n\nLanguages\n\n: C#, C, C++, JAVA, T-SQL\n\nWeb Server\n\n: IIS, Tomcat\n\nAwards/ Certifications/ Achievements\n\xef\x83\xa0\n\nCertificate of Excellence at Altisource for successfully taking care of the Data Quality Program(2014).\n\n\xef\x83\xa0\n\nCertificate of Excellence at QSIH for successfully implementing Meaningful Use Stage 2 program for certifying\nEHR systems (April 2013).\n\n\xef\x83\xa0\n\nMicrosoft Certified Technology Specialist for Microsoft BI \xe2\x80\x93 Implementation and Maintenance 2005/2008, MS\nSQL Server 2005, and NET 2.0 - Application Development Foundation (April 2007)\n\n\xef\x83\xa0\n\nMicrosoft Certified IT Professional for Microsoft Business Intelligence Developer 2005\n\n\xef\x83\xa0\n\nMSBI-COE (Center Of Excellence) anchor for Systems Integration - Business Intelligence Unit at Infosys.\n\n\xef\x83\xa0\n\nBest Project Team award 2010 for EUS unit at Infosys.\n\n\xef\x83\xa0\n\nBest Freshman Award (Jan-June 07) for Systems Integration - Business Intelligence Unit at Infosys.\n\n\x0c\xef\x83\xa0\n\nNominated as a Microsoft Student Champ, by Microsoft, at Manipal Institute of Technology (2006)\n\n\xef\x83\xa0\n\nTopper at Infosys Foundation Training Program with a CGPA of 5.0/5.0 (Jun \xe2\x80\x93 Aug 2006).\n\n\xef\x83\xa0\n\nMicrosoft Certified Professional for Microsoft SQL Server 2000 (June 2005)\n\nPROFESSIONAL EXPERIENCE\n\xef\x83\xa0\n\nAltisource Business Solutions Pvt Ltd, Bangalore ( Sept 13 \xe2\x80\x93 Till Date)\n\nProduct\n\n: Data Governance & Data Quality\n\nRole\n\n: Lead Data Analyst\n\nBangalore\n\nTeam Size : 11\nProject Overview\n\nResponsibilities\n\nData Quality Program checks the quality of data across various data assets at Altisource and Ocwen.\n\n\xef\x82\xa7\n\nDevelopment of Data Quality Program for various Business Units & Data Systems.\n\n\xef\x82\xa7\n\nDevelopment & Maintenance of Enterprise Data Dictionary through Mediawiki.\n\n\xef\x82\xa7\n\nDevelopment of Metadata & Data Profiler using Kettle\n\n\xef\x82\xa7\n\nDashboard Reporting using SpagoBI\n\n\xef\x82\xa7\n\nWorking on Agile development model.\n\n\xef\x82\xa7\n\nDWH & BI Platform : SpagoBI & Kettle\n\n\xef\x82\xa7\n\nProgramming \xe2\x80\x93 Oracle, Java\n\n\xef\x82\xa7\n\nOperating System \xe2\x80\x93 Windows Server 2003, Win 7\n\n\xef\x82\xa7\n\nConfiguration Management \xe2\x80\x93 Subversion\n\n\xef\x82\xa7\n\nDBMS: Oracle 11g\n\nTechnologies:\n\n\xef\x83\xa0\n\nQuality Systems India Healthcare Pvt Ltd, Bangalore ( Jul 11 \xe2\x80\x93 Sept 13)\n\nProduct\n\n: Health Quality Measures\n\nRole\n\n: Associate Technical Specialist\n\nBangalore\n\nTeam Size : 15\nProject Overview\n\nQSI Healthcare is a new subsidiary of Quality Systems, Inc. (QSI),US which develops and market computer-based practice\nmanagement and electronic health records (EHR) solutions, ambulatory, inpatient and dental providers to empower patientcentered care and deliver results for medical and dental group practices and hospitals throughout the U.S.\n\nResponsibilities\n\n\xef\x82\xa7\n\nWorking on Agile development model.\n\n\xef\x82\xa7\n\nDevelopment of HQM Portal & Quality Reporting\n\n\xef\x82\xa7\n\nDevelopment of new NextGen Dashboard 3.0 \xe2\x80\x93 Using LogiXML\n\n\xef\x82\xa7\n\nReporting quality & clinical measures under Meaningful Use, PQRI, BTE programs.\n\n\xef\x82\xa7\n\nDeveloping Quality dashboards using LogiXML & SSRS\n\n\xef\x82\xa7\n\nBI Platform : SQL Server Reporting Services, LogiXML 10\n\n\xef\x82\xa7\n\nProgramming \xe2\x80\x93 SQL,C#, ASP.NET,\n\n\xef\x82\xa7\n\nOperating System \xe2\x80\x93 Windows Server 2003, Win 7\n\n\xef\x82\xa7\n\nConfiguration Management \xe2\x80\x93 Perforce \xe2\x80\x93 Open Source\n\n\xef\x82\xa7\n\nDBMS: SQL Server 2008 R2/SQL SERVER 2012\n\nTechnologies:\n\n\xef\x83\xa0\n\nInfosys Technologies Limited, Bangalore ( Jun 06 - Jul 11)\n\nClient\n\n: British Petroleum ( BP)\n\nHouston, TX (2010-2011)\n\nProject\n\n: Risk Reporting\n\nBangalore, India(2010- 2011)\n\nTechnology Analyst(TA) (Dec 2008 \xe2\x80\x93 July 2011)\nTeam Size : 30\nBP\n\n: 10 (Manager, BAs, Architect, DBA)\n\nInfosys: 20 Onshore/Offshore\n\nLondon, UK (2008-2009)\n\n\x0cProject Overview\n\nBP is one of the largest traders of oil and gas in the world. Integrated Supply and Trading (IST) team combines all Oil, Gas,\nPower, Chemical and Financial trading activities. Objective is the provide support and development for IST Risk Reporting,\nNAGP, GTEL MVAR & Oil MVaR applications and also address key weaknesses within the existing system.\n\nResponsibilities\n\n\xef\x82\xa7\n\nSupport existing data warehouse reporting platform and applications to ensure operational availability and scalability\n\n\xef\x82\xa7\n\nWork directly with functional analysts and business users in understanding the information needs of the business and\ndeveloping new data warehouse/BI functionalities or tools to meet these requirements.\n\n\xef\x82\xa7\n\nAssess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture\nmeets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on\nevolution of the architecture.\n\nTechnologies:\n\n\xef\x82\xa7\n\nResearch, define and deploy BI improvement opportunities and streamline the business intelligence processes\n\n\xef\x82\xa7\n\nCreate detail design, work on development and perform code reviews.\n\n\xef\x82\xa7\n\nAnalysis & implementation of better performance strategies.\n\n\xef\x82\xa7\n\nServer : IIS, SQL Server, Oracle, Analysis Services, Reporting Services, Integration Services, Informatica, BO\n\n\xef\x82\xa7\n\nProgramming \xe2\x80\x93 SQL,C#, ASP.NET\n\n\xef\x82\xa7\n\nOperating System \xe2\x80\x93 Windows Server 2003\n\n\xef\x82\xa7\n\nConfiguration Management \xe2\x80\x93 IBM Clear Case\n\nClient\n\n: Canada Pacific Railways ( CPR )\n\nProject\n\n: Automated Inventory Reporting (AIR)\n\nBangalore, India\n\nBusiness Intelligence \xe2\x80\x93 Technical Specialist(TS) ( Oct 2008 \xe2\x80\x93 Dec 2008)\nTeam Size : 8\nCPR\n\n: 3 (Manager, CSE, Bas)\n\nInfosys : 5 ( Manager, TS, Developer)\nProject Overview\n\nAt CPR, Car Management metrics are used across various departments and are published to the Operations Dashboard and\n0700 for senior Canadian Pacific management up to and including the President & CEO. The BI Initiative will provide a\nsignificant upgrade to the current Car Metrics process. Metrics will be centralized into a Car Management Portal in a supported\nBI environment. Data will have consistent business rules, hierarchies and standardized metrics and calculations.\n\nResponsibilities\n\n\xef\x82\xa7\n\nDevelop technical architecture based on detailed requirements\n\n\xef\x82\xa7\n\nValidate the technical feasibility of business requirements\n\n\xef\x82\xa7\n\nInfrastructure, architecture and environment evaluation\n\n\xef\x82\xa7\n\nInterfaces with Business users and Technical SMEs to clarify requirements, review design, test cases, UAT and\ndeployment\n\nTechnologies:\n\nClient\n\n\xef\x82\xa7\n\nServer : IIS, Analysis Services, Reporting Services, SharePoint Server\n\n\xef\x82\xa7\n\nProgramming \xe2\x80\x93 C#, ASP.NET\n\n\xef\x82\xa7\n\nOperating System \xe2\x80\x93 Windows Server 2003\n\n\xef\x82\xa7\n\nConfiguration Management \xe2\x80\x93MS Visual Source Safe\n\n\xef\x82\xa7\n\nDBMS: SQL Server, MS Access, Excel.\n\n: Underwriter Laboratories (UL)\n\nBangalore, India\n\nProject : Datamart Reporting\nSystems Engineer \xe2\x80\x93 Datamart Developer (Aug 06 \xe2\x80\x93 Sept 08)\nTeam Size : 13\nClient: 7 (Manager, Bas, Architect, DBA, Dev)\nInfosys: 5 offshore, 1 onsite Coordinator/BA\nProject Overview\n\nThe primary objective of this project to build a robust and intelligent system that will help Business people to strategize based\non analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of\ndata from heterogeneous sources like LotusNotes Databases, Oracle, SQL Server 2000/2005. Provide maintenance support for\nETL systems. Creation of Datamarts. Incremental processes, LotusNotes Agents, Report Modeling, Creation of business\nreports, Dashboard reports, and also the maintenance of web reports using MS Reporting services 2005.\n\nResponsibilities\n\nTechnologies:\n\n\xef\x82\xa7\n\nWork closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.\n\n\xef\x82\xa7\n\nWriting LotusNotes agents, ActiveX script for pulling data from LotusNotes db.\n\n\xef\x82\xa7\n\nDesigning and Implementing the ETL processes\n\n\xef\x82\xa7\n\nCreation of Canned reports, Cube-Based Reports, Report Models for Ad-Hoc\n\n\xef\x82\xa7\n\nCoordinating with onsite folks and leading and mentoring the offshore team.\n\n\xef\x82\xa7\n\nTravel to various locations to train people in new project specific technologies\n\nServer : IIS, Analysis Services, Reporting Services\nProgramming \xe2\x80\x93 C#, ASP.NET\nOperating System \xe2\x80\x93 Windows Server 2003\nConfiguration Management \xe2\x80\x93 IBM Visual Source Safe\n\n\x0cDBMS: SQL Server, MS Access, Excel, Lotus Notes Database\n\n\x0c\xef\x83\xa0\n\ni2 Technologies Limited, Bangalore (Project Trainee) (Jan \xe2\x80\x93 May 06)\n\nProject\n\n: Production Scheduler (PS)\n\nBangalore, India\n\nJava Developer (Project Trainee)\nTeam Size : 16\nProject Overview\n\nProduction Scheduler is designed to provide optimization-based scheduling, shop-floor synchronization, reactive re-scheduling,\nand complete reporting and analytics. Production Scheduler is a configurable scheduling application that produces detailed\nschedules for multi-stage manufacturing processes.\n\n\xef\x83\xa0\n\nResponsibilities\n\n\xef\x82\xa7\n\nEnhancements to the PS client and Server components, and also Customer issue fixes.\n\nTechnologies:\n\n\xef\x82\xa7\n\nServer : OS(Optimal Scheduler)\n\n\xef\x82\xa7\n\nProgramming \xe2\x80\x93 Java, 3rd Party Widgets, Optimal Scheduler Language( i2 Proprietary Language)\n\n\xef\x82\xa7\n\nOperating System \xe2\x80\x93 Windows Server 2003\n\n\xef\x82\xa7\n\nConfiguration Management \xe2\x80\x93 IBM ClearCase\n\n\xef\x82\xa7\n\nDBMS: MS Access\n\nAngel Movies Enterprises, Mumbai ( As a freelance ) ( May \xe2\x80\x93 June 2004)\n\nDevelopment of www.angelmoviesenterprise.org\n\nManipal, India\n\nWeb Developer\nTeam Size : 1\nProject Overview\n\nAngel Movies Enterprises is a professional & experienced production house (Domestic & International Market) in the following\nareas.\n\xef\x82\xa7\n\n1. Feature-Films (Dhoop, U Bomsi N Me)\n\n\xef\x82\xa7\n\n2. TV Software, Animations, Telefilms (Saturday Suspense etc...).\n\nResponsibilities\n\n\xef\x82\xa7\n\nDesigning of complete website.\n\nTechnologies:\n\n\xef\x82\xa7\n\nHTML, JavaScript, Flash, Dreamweaver.\n\n\x0cTRAINING AT ORGANIZATION\n\xef\x82\xb7\n\nCompleted 4 Days/35 PDUs PMP certification Program (Sept 2012).\n\n\xef\x82\xb7\n\nAdvanced Migration from Business Objects 5.x\\6.x to XI R2 at Infosys, By Business Objects.\n\n\xef\x82\xb7\n\nMicrosoft SQL Server 2005 by Synergetics-India at Infosys.\n\n\xef\x82\xb7\n\nMicrosoft ASP.NET 2.0 and its new features by Synergetics-India at Infosys.\n\n\xef\x82\xb7\n\nMicrosoft Certified Course on Programming and designing Database using MS SQL Server 2000 at NIIT,\nBangalore (May 2005).\n\n\xef\x82\xb7\n\nCompleted Infosys J2EE Foundation Training Program at Mysore, India.\n\nACADEMIC DETAILS\n\n\xef\x82\xb7\n\n\xef\x82\xb7\n\nBachelor of Engineering in Computer Science & Engineering\n\xef\x82\xb7\n\nSept 2002 - May 2006\n\n\xef\x82\xb7\n\nManipal University, Manipal, India.\n\n\xef\x82\xb7\n\nManipal Institute of Technology (MIT), Manipal, India.\n\nHSC - Science\n\xef\x82\xb7\n\nJune 2002\n\n\xef\x82\xb7\n\nApeejay School, Saket, New Delhi\n\nINTEREST / ACTIVITIES\n\xef\x82\xb7\n\nTraveled extensively in India, UK, US, Europe.\n\n\xef\x82\xb7\n\nPart of Energizers team at QSIH.\n\n\xef\x82\xb7\n\nParticipates in the Company\xe2\x80\x99s Cultural and Music Events and Workshops.\n\n\xef\x82\xb7\n\nNovels, DVDs, Movies, Concerts\n\n\xef\x82\xb7\n\nLive Sports \xe2\x80\x93 Cricket, F1'