• Design, Develop and implement Data Warehouse (DW) and reporting system solution using MSBI stack for the client to enable them to self-invoice their vendors.• Build SQL queries to pull source data from Microsoft project server. • Design, Build, Test and Deploy stored procedures, SSIS packages and SSRS reports.• Conduct client meetings and take part in sessions to propose technical solutions and help the client in User Acceptance testing.• Understand requirements and delegate tasks to offshore team and peer review their code.• Perform report field mappings with existing entries in MDS, add necessary new entries in MDS with pseudocodes and create report LLDs and HLDs. • Build MOLAP cube using SSAS and create PowerPivot reports on top of it.• Design & model new source systems.• Design ETL logic for moving data from source to destination.

Roles Performed• Lead, develop, manage, and support Data Warehouse (DW) reporting system for internal operational and financial reporting, and client invoicing purposes using SSIS, SSAS and SSRS.• Migrate SSIS ETL packages, SSAS cube and SSRS reports from SQL 2005 to 2012 version.• Map the current DW to new source system upon change of source system from Service Management Suite (SMS) to Microsoft Project Server (MSPS). Design, architect and implement SSIS, SSAS and SSRS changes owing to source system change.• Create InfoPath forms on SharePoint, handle permissions, integrate with SSRS and excel, document library, lists. Set up monitoring and scheduling jobs to track SharePoint reports usage. Create Performance Point Services KPIs, Scorecards, Reports, and Dashboards.Other Achievements•Star of the month for the month of november 2010.•ACE Award in FY2011 for Individual - Excellence in Value Creation - Contribution to Industrialization pillars - automation, asset reuse, harvesting - Genesis•ACE Award in FY2012(Alchemist award) for contribution through innovation in work process in the individual category.•Won the Continuous Improvement Program Award four times for sharing multiple innovative ideas to improve the processes.•Microsoft Certified Professional in Business Intelligence 2005/2008-MCTS and MCITP.

Roles Performed:•Creation of data models for various areas of Supply Chain like Procurement, Inventory Management using Erwin 7.3.•Creation of Cube (Dimensions, facts, relationships, perspectives) using Analysis Service 2008.•Creation of Calculated Members, KPIs using MDX queries in Analysis Service 2008.•Creation of Scorecards, Chart Reports and Dashboards using Performance Point Server 2007.•Creating Adhoc reports using MS Excel 2007 and Proclarity•Creating Adhoc using Power Pivot feature of excel 2010.•Implementation of Data Level Security for metrics and charts.•Creation of reports using SQL Server Reporting Services 2008.Other Achievements•Secured first place in Infosys Mysore for the competition “Structured Dive” (MS SQL Server 2005) held on 18th-21stApril 08.•Successful completion of Final Semester Project held at Infosys Mysore from 09thJan - 9thMay 08.•Got “Award of Excellence” for my contribution to product “Supply Chain Visibility” at Infosys in FY Q4 2010