Sql Server Project
Resume:
Sumit Khemka
Bangalore, India, ******
E-mail : ***********@*****.***
Curriculum Vitae
Professional Summary
* ***** ** ********** ** IT industry, currently working as Technology Analyst.Around 4.7 years of experience in Data warehousing and Business Intelligence.Domain Knowledge of Energy Trading & Risk Management.Worked at client locations in London (UK) & Houston (US).Strong experience on T-SQL and query optimization, developing ETL strategies.Strong experience with SQL Server 2000/2005, SSIS, SSRS and SSASBasic understanding of writing and debugging MDX queries.Project Experience on Informatica and Business Objects tools.Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.Experience on Service & quality management tools such as Remedy, JIRA, Mercury QC, and ClearQuest.Experience on configuration management tools such as ClearCase and VSS.Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS PackagesGood understanding on .NET framework especially in ASP.NET client/Server technology.Flexible with work location, travelled globally mostly in UK, US, Europe & India.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.Exposure to Proposal/Estimation Discussions and SMC model.Certified as MCP and MCTS in SQL Server 2000/2005/2008 and Business Intelligence and .NET 2.0.
Awards/ Certifications/ Achievements
Microsoft Certified IT Professional for Microsoft Business Intelligence Developer 2005Microsoft Certified Technology Specialist for Microsoft Business Intelligence – Implementation and Maintenance 2005/2008Microsoft Certified Technology Specialist for Microsoft SQL Server 2005 ( Dec 2007 )Microsoft Certified Technology Specialist for Microsoft .NET Framework 2.0 - Application Development Foundation (April 2007)MSBI-COE (Center Of Excellence) anchor for Systems Integration - Business Intelligence Unit at Infosys.Best Project Team award 2010 for EUS unit at Infosys.Best Freshman Award (Jan-June 07) for Systems Integration - Business Intelligence Unit at Infosys. Nominated as a Microsoft Student Champ, by Microsoft, at Manipal Institute of Technology (2006)Topper at Infosys Foundation Training Program with a CGPA of 5.0/5.0 (Jun – Aug 2006) among 1000 professionals.Microsoft Certified Professional for Microsoft SQL Server 2000 (June 2005)
Professional Experience
Infosys Technologies Limited, Bangalore ( Jun 06 - Till Date)
Client : British Petroleum ( BP)
Project : Risk Reporting
Houston, TX (2010-2011)
Bangalore, India(2010)
London, UK (2008-2009)
Technology Analyst(TA) (Dec 2008 – till date)
Team Size : 30
BP : 10 (Manager, BAs, Architect, DBA)
Infosys: 20 Onshore/Offshore
Project Overview
BP is one of the largest traders of oil and gas in the world. Integrated Supply and Trading (IST) team combines all Oil, Gas, Power, Chemical and Financial trading activities. Objective is the provide support and development for IST Risk Reporting, NAGP, GTEL MVAR & Oil MVaR applications and also address key weaknesses within the existing system.
Responsibilities Support existing data warehouse reporting platform and applications to ensure operational availability and scalability Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements. Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture. Research, define and deploy BI improvement opportunities and streamline the business intelligence processesCreate detail design, work on development and perform code reviews.Analysis & implementation of better performance strategies.
Technologies: Server : IIS, Analysis Services, Reporting Services, Integration Services,Informatica,BOProgramming – SQL,C#, ASP.NETOperating System – Windows Server 2003Configuration Management – IBM Clear CaseDBMS: SQL Server, Oracle, MS Access, Excel.
Client : Canada Pacific Railways ( CPR )
Project : Automated Inventory Reporting (AIR)
Bangalore, India
Business Intelligence – Technical Specialist(TS) ( Oct 2008 – Dec 2008)
Team Size : 8
CPR : 3 (Manager, CSE, Bas)
Infosys : 5 ( Manager, TS, Developer)
Project Overview
At CPR, Car Management metrics are used across various departments and are published to the Operations Dashboard and 0700 for senior Canadian Pacific management up to and including the President & CEO. The BI Initiative will provide a significant upgrade to the current Car Metrics process. Metrics will be centralized into a Car Management Portal in a supported BI environment. Data will have consistent business rules, hierarchies and standardized metrics and calculations.
Responsibilities Develop technical architecture based on detailed requirementsValidate the technical feasibility of business requirements Infrastructure, architecture and environment evaluationInterfaces with Business users and Technical SMEs to clarify requirements, review design, test cases, UAT and deploymentDevising the Report delivery mechanismsEnsures deliverables meet Quality standardsTraining people in new technologies
Technologies: Server : IIS, Analysis Services, Reporting Services, SharePoint ServerProgramming – C#, ASP.NETOperating System – Windows Server 2003Configuration Management –MS Visual Source SafeDBMS: SQL Server, MS Access, Excel.
Client : Underwriter Laboratories (UL)
Project : Datamart Reporting
Bangalore, India
Systems Engineer – Datamart Developer (Aug 06 – Sept 08)
Team Size : 13
Client: 7 (Manager, Bas, Architect, DBA, Dev)
Infosys: 5 offshore, 1 onsite Coordinator/BA
Project Overview
The primary objective of this project to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of data from heterogeneous sources like LotusNotes Databases, Oracle, SQL Server 2000/2005. Provide maintenance support for ETL systems. Creation of Datamarts. Incremental processes, LotusNotes Agents, Report Modeling, Creation of business reports, Dashboard reports, and also the maintenance of web reports using MS Reporting services 2005.
Responsibilities Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.Writing LotusNotes agents, ActiveX script for pulling data from LotusNotes db.Designing and Implementing the ETL processesCreation of Canned reports, Cube-Based Reports, Report Models for Ad-Hoc Using Reporting Services Capabilities and 3rd party tools accordingly to build Dashboards.Troubleshooting reports issues, ETL job failures, optimizing query performances.Coordinating with onsite folks and leading and mentoring the offshore team.Travel to various locations to train people in new project specific technologies
Technologies:
Server : IIS, Analysis Services, Reporting Services
Programming – C#, ASP.NET
Operating System – Windows Server 2003
Configuration Management – IBM Visual Source Safe
DBMS: SQL Server, MS Access, Excel, Lotus Notes Database
i2 Technologies Limited, Bangalore (Project Trainee) (Jan – May 06)
Project : Production Scheduler (PS)
Bangalore, India
Java Developer (Project Trainee)
Team Size : 16
Project Overview
Production Scheduler is designed to provide optimization-based scheduling, shop-floor synchronization, reactive re-scheduling, and complete reporting and analytics. Production Scheduler is a configurable scheduling application that produces detailed schedules for multi-stage manufacturing processes.
Responsibilities Enhancements to the PS client and Server components, and also Customer issue fixes.
Technologies: Server : OS(Optimal Scheduler)Programming – Java, 3rd Party Widgets, Optimal Scheduler Language( i2 Proprietary Language)Operating System – Windows Server 2003Configuration Management – IBM ClearCaseDBMS: MS Access
Angel Movies Enterprises, Mumbai ( As a freelance ) ( May – June 2004)
Development of www.angelmoviesenterprise.org
Manipal, India
Web Developer
Team Size : 1
Project Overview
Angel Movies Enterprises is a professional & experienced production house (Domestic & International Market) in the following areas. 1. Feature-Films (Dhoop, U Bomsi N Me) 2. TV Software, Animations, Telefilms (Saturday Suspense etc
Responsibilities
Technologies: HTML, JavaScript, Flash, Dreamweaver.
Technical Skills
Languages : C#, C, C++, JAVA, T-SQL
Business Intelligence : SSIS, BIDS, SSAS, SSRS
Operating Systems : Windows 2003, XP, MS-DOS
Framework Experience : Microsoft .NET, J2EE
Web Technology : HTML, XML, Jscript, VBScript, ASP, ASP.NET, JSP, WebServices, Basic PHP
DBMS : SQL Server 2000/2005, ORACLE, MS Access, MySQL, LotusNotes databases
Configuration Management : Rational ClearCase, Visual SourceSafe
Service & Quality Management : JIRA, Remedy, ClearQuest, Mercury QC
Applications & IDE : Visual Studio.NET, Business Intelligence Development Studio, Visual Studio6.0,
intelliJ IDEA, Eclipse, MS Office, Dreamweaver, LotusNotes Designer
Web Server : IIS, Tomcat
Training at Organization
Microsoft SQL Server 2005 by Synergetics-India at Infosys.Microsoft ASP.NET 2.0 and its new features by Synergetics-India at Infosys.Microsoft Certified Course on Programming and designing Database using MS SQL Server 2000 at NIIT, Bangalore (May 2005).Advanced Migration from Business Objects 5.x\6.x to XI R2 at Infosys, By Business Objects.Completed Infosys J2EE Foundation Training Program at Mysore, India.
Academic Details
Manipal Institute of Technology (MIT)
http://www.manipal.edu/manipalsite/Users/manipalhome.aspx
Bachelor of Engineering in Computer Science & Engineering
September 2002 – May 2006
Cumulative GPA: 3.6/4.0
Manipal, India
Graduated with High Distinction; among top 10 students of the batch.Selected as a Microsoft Student Champ, by Microsoft, for the Microsoft Student Community at MIT.Organized workshops, seminars and gave presentation on Microsoft Technologies.Active participant in College sport’s events, Member of the college Hockey and Athletics Team, cross country runner, participated in football, cricket and indoor games.Alumni of CSI (Computer Society of India), MAFIA (Music and Fine arts) clubs
Apeejay School
http://www.apeejay.edu/saket/home.htm
All India Senior Secondary Certificate Examination (Standard XII)
April 2002
Percentage: 75.8
New Delhi, India
First class with distinction; Top scorer in Computer Science subjectActive participant in Inter-school sports meets.Member of School Volleyball, Football, Badminton & Athletics team.
Vidya Niketan – Birla Public School
http://www.bpspilani.com/
All India Secondary School Examination (Standard X)
April 2000
Percentage: 83
Pilani, Rajasthan India
First class with high distinction.Member of School Hockey, Football, Cricket teams.Member of Official School Band group, performed during Annual Events.High Scorer at Indian Public School Conference General Knowledge Exams
Extracurricular activities
Participated in the Companies Cultural, Music Events and Workshops.Organized trainings in Business Intelligence Domain for SI unit at Infosys Technologies ltd.Active Member of Nascent Education and Society (Independent NGO), where I managed and organized local events in Bangalore, India. Latest event being Clean Bangalore Drive, where we installed Trash Cans (Dust bins) at various important & troubled crossings in the city.
Hobbies & Interests
Watching DVDs from classics to the latest, ive games, learning new technologies ( recently bumped into JQuery) or searching for the latest bestsellers in the bookstores.Traveling is one of the things I really enjoy. Traveled extensively in India, UK, Europe, and US exploring places from aspects of rural/urban divide.
Last updated: 25 - Apr - 2011
Contact this candidate