Objective:I seek to apply my knowledge in a highly challenging and continuously growing organization that can provide me opportunities to grow intellectually, technically and professionally in concurrence with company’s goals and objectives.

Experience:

• 3+ years of relevant experience in IT industry. Possessing good analytical, communication and team building skills and has ability to think out of the box.
• Experience in SQL Server 2005/2008 BI tools, SSAS, SSIS and SSRS, DotNet, Microsoft Team Foundation Server.
• Experience on insurance domain,worked on business intelligence product(Insurance Analytics Framework) developed specifically for Insurance related Queries.
• Worked in an Onsite/Offshore setup. Have hands of experience on working and coordinating with client at Onsite in Texas USA.
• Experience in handling clients of different regions and also communicated effectively with USA.
• Experience in building enterprise level dashboards.
• Sound knowledge in performing root cause analysis and bug fixing.

Responsibilities:

• Responsible for interacting with client for gathering dashboard requirements.
• Analyzing and developing business critical dashboards based on client requirement.
• Module lead of Market dashboard and have guided the team effectively to exceed customer expectations.
• Responsible for creating cubes in SSAS, creating packages in SSIS and also creating corresponding reports in SSRS.
• Developing Web Applications in C#.net for Applied Materials Client.
• Responsible for Creating stored procedures, views, tables in SQL Server 2005.
• Creation of Crystal Reports which includes creation of charts, sub reports and cross tabs.
• Responsible for creating a performance tool, a web application which includes the above features.
• Working on Insurance Product which leverages business intelligence solution for all Insurance related Queries,
• Responsible for writing complex T-SQL queries for source logics of the product.
• Involved in Cube designing.
• Creating SSRS reports.

Achievements at Work:

Won the Team of the Quarter Award on the Client(Applied Materials) End for Quarter 2 2009
Team Member of Market Performance Dashboard (MPD), whichhas been recognized by MICROSOFT Corporation USA as an innovative dashboard and they performed a case study on the same. 
Got Star Performer (S) rating for two consecutive years 08-09 and 09-10
Won Pat-On-Back (PoB) on multiple occasions for excellent Performance and Delivery
Among the top 10 Associates in the batch of 83 Associates during training and also lead the team of 10 members in an internal project.
Appreciated on multiple occasions for excellent delivery by client and Managers.

Skill Set:

Primary Skill category:Microsoft Technologies - .NET, SSAS, SSRS, SSISSecondary Skill category 1:C, C++Project Acquired skills:C#.net, ASP.net, SQL Server 2005, SSAS, SSRSTrained Skills:C, Algorithms & Data Structures, OS, RDBMS, Internet Concepts, HTML & JavaScript, OOAD, SQL Server2000,ASP.Net, C#.Net ,ADO.Net, XML.

Certifications:MICROSOFT CERTIFIED APPLICATION DEVELOPER(MCAD)
(70-310) : Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
(70-320) : Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework
(70-229): Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

Project Summary:

Project Name:Casino Business Analytics(Austin, TX)Client :ConfidentialRole:Team LeadOrganization:ConfidentialDuration:Aug 2010 - Till DateEnvironment:

Technologies :SSAS,SSIS,SSRS, ASP.NET 2.0, MTFS 2008Software’s :Visual Studio 2005Database :SQL Server 2005Tools :BIDSO/s:Windows 7

Project Description: 
CasinoBusinessAnalytics is a Business intelligence product developed using Microsoft SQL Server Business Intelligence tools (SSAS, SSIS, and SSRS) which leverages BI solutions to all casino related analysis. This generic product is used across all higher management to answer their business requirements. The product includes business logic for creating data ware house (SSIS), Creation of cubes (SSAS) and creation of reports (SSRS).

Roles/Responsibilities:

• Coordinating with client to work with gathering requirements.
• Analyzing the mapping document and writing corresponding T-SQL used as the source logic for creation of datawarehouse.
• Creating SSIS packages and scheduling accordingly.
• Designing and developing SSAS cube.
• Responsible for identifying facts and dimensions, Coordinating in designing Dimensions, creating calculated members, designing agggregations, partitions and defining attribute relationships while designing cube.
• Discussing with offshore team to knowledge transfer client’s requirement and developing reports and drill-down reports using SSRS.
• Responsible for writing MDX, SSRS complex Expressions, and worked on drilldown, drill thru reports.
• Embedding SSRS reports into ASP.NET pages and deploying to IIS server
• Working closely with customers in testing and bug fixing data issues.

Project Name:Market Performance DashboardClient:ConfidentialRole:Team LeadOrganization:ConfidentialDuration:Oct 2009 – Jul 2010Environment:

Technologies :SSAS,SSIS,SSRS, ASP.NET 2.0Software’s:Visual Studio 2005, IIS 6.0Database:SQL Server 2005Tools:BIDSO/S:Windows Server 2003 x64

Project Description:
Market Analysis Performance Dashboard is a Web based tool to track revenue for top commodities Quartz, Silicon, Ceramics and Echucks. Also it is used to calculate run rate for all commodities and segments, Charts to include data tables.

Roles/Responsibilities:

• Documenting the requirements.
• Creating SSIS packages and scheduling accordingly.
• Discussing with offshore team to knowledge transfer client’s requirement and developing reports and drill-down reports using SSRS.
• Embedding SSRS reports into ASP.NET pages and deploying to IIS server.
• Working closely with customers in testing and bug fixing data issues.

Project Name:Close To The Customer DashboardClient:ConfidentialRole:DeveloperOrganization:ConfidentialDuration:Dec 2008 –Sep 2009Environment:

Technologies :SSAS,SSIS,SSRS, ASP.NET 2.0Softwares:Visual Studio 2005, IIS 6.0Database:SQL Server 2005Tools:BIDSO/S:Windows Server 2003 x64

Project Description: 
CttC Dashboard is a customer specific dashboard. It is intended for tracking performance of selected top customers of Applied Materials with flexibility for add/remove issues and comments. The performance of a customer is computed by multiple key performance indicators (KPI’s) which are set forth by Applied Materials.

Roles/Responsibilities:

• Documenting the requirements
• Creating SSIS packages and scheduling accordingly
• Discussing with offshore team to knowledge transfer client’s requirement and developing reports and drill-down reports using SSRS
• Embedding SSRS reports into ASP.NET pages and deploying to IIS server
• Working closely with customers in testing and bug fixing data issues.

Project Name:SEO ToolClient:ConfidentialRole:DeveloperOrganization:ConfidentialDuration:Oct 2007 – Nov 2008Environment(with skill versions):

Languages:C#.NetSoftwares:.NET 2005Database:SQL ServerTools:Visual Studio.NetO/S:Windows XP

Project Description: 
Search Engine Optimization (SEO) is the process of optimizing a web site by improving its internal and external aspects in order to increase the popularity of the website so that the website receives more traffic which in turn leads to increased revenue generation. Development projects within Satyam computer services Ltd for various clients requiring automation tool, which optimizes the websites in search engines.

Roles/Responsibilities:

• Developed SEO tool kit to provide "proof of concept" for application that allows user interface more flexible to submit links to directory submission websites, articles to article submission websites and stories to social bookmarking sites.
• Manage multiple simultaneous modules, successfully meeting all budgets and time frames, drove complex modules from conceptual stages to delivery in less than 9 months.
• Developed efficient automated SEO Tool reduces manual work drastically which has been formally praised by Satyam management.
• Contributed in design of the URD, SRS, OOD documents as well as in unit testing and integration testing.
• Provided configuration controlling for the project and knowledge transfer about the application to the new team members.
• Lead and co-ordinate a cross-functional development team, maintain a goal oriented environment while facilitating boundary questioning and creative thinking

Education: Bachelor of Engineering: Computer Science.