Xbox Game Data AnalysisAdhoc Analytics & Statistical insights involving Churn, Cohort, Trend

Owned and Managed Finance Data warehouse and reporting Solutions, which supported Finance ROB reports like Close P&L, Opex, ROF, Forecast and Budget. Collaborated with Engineering, PMs and Finance team to drive functional requirements and issue resolution Prepared business cases for IT enhancements, ensuring a fresh approach to improving existing systems and reporting processes.  Automated SAP reporting by consuming data from SAP Azure Data Lake and other Finance systems Designed and developed Power BI dashboard for Credit Analysis, Monthly Search Accountability Framework and Customer & Agency tracking. Managed Vendor team and monthly deliverable

• Drive implementation of (Bing Ads) Revenue reporting to internal tools - MSSales for new Partnerships.• Developed dashboard and alert system for tracking advertiser transition, which resulted in taking timely action of any impacted advertisers.• Subject matter expert (SME) for revenue recognition for online search advertisement and finance reporting.• Identified issues in revenue processing, provided finance team with exact monthly impact• Conducted statistical analysis and provided reports that enabled decision-making• Extensively used Excel, Power pivot, SQL, MDX & OLAP cubes for querying and analyzing data• Received accolades from the customers for the analysis & reports provided

• Designed and Architect Data warehouse & reporting system: FDM (Finance Data Mart). It serves to Microsoft ASG finance team for their financial reporting. Technology used were SQL, SSIS, SSAS (OLAP), Excel, Power Pivots, ASP.net, and C#.• Headed multiple projects, administered all aspects of project including project planning, staffing, production rollouts & Post Production support.• Created feature roadmap that aligned with Business ROB, anticipated and managed ad-hoc changes• Integrated data from wide-ranging upstream systems like MSSales, Mercury, Paid Search Billing, HeadTrax, and Operational systems.• Optimized the ETL process and reduced overall report publish time by 40%• Improved customer satisfaction by identifying areas of enhancement and driving the implementation.

• Led the team in delivering MS CRM 3.0 based application “Consumption Planning” for Microsoft GFS – ESBP division. Technologies used were MS CRM 3.0, C#, ASP.net, SQL, .net Web services, and smart documents. • Designed the overall architecture of the application and created generic components.• Automated build and unit testing process, resulting in saving 30hrs per month.• Reduced MS CRM workflow process failure by 70%• Honored with “Raise the Toast” award for the POC developed using MS CRM & VS Office automation; it also helped company win the Project contract.• Worked closely with Product Owner/Manager, Development Team and other IT groups for requirement gathering and UAT support.

Worked on several applications which were based on ASP.net, .net Compact Framework for mobile devices & SharePoint services.Lead the team in Billing and reporting module of ADEPT (Ads Designing Placing Technology) product development. Provided team with Functional Specs, Use case analysis and architectural diagram. Performed all the initial POC work for Generic Data Layer, Currency conversion & interactive reports.Worked on .net based mobile application to port search utility from windows based platform to mobile platform.Drive requirement, design and development for Share point based solution for SSKI (Financial Service Company). Solution involved contact management, email management and work flow management for all the financial reports generated. Involved in the initial requirement gathering and prototype building phase for "NFL" project. Project was to develop web site which would provide statistics of NFL team, players, live scores of ongoing matches and prediction module.