SUMMARY

• 9 years of experience in various roles as Technical Consultant, Business Systems Analyst, Operations Service Engineer, and Software Design Engineer
• Strong experience in Data Center, Cost Management & Billing, IT Infrastructure Operations, and Supply Chain domains, having worked 9 years wif Microsoft’s Cloud Infrastructure division.
• Experience designing, developing, and maintaining high performance, scalable enterprise systems using Microsoft technology stack (Dynamics AX, Dynamics CRM, MS SQL Server, ASP .NET) and third party cloud solutions (Apptio and SAP S&OP).
• Enthusiastic and quick learner (learnt Dynamics CRM, Dynamics AX, SharePoint, Apptio, SAP S&OP), result driven, and self - motivated team player.
• Excellent communication, cross-group collaboration, and interpersonal skills interfacing wif business and technical groups.
• Excellent analytical, problem solving, team management skills wif creative & strategic thinking,
• Track record of delivering high quality work under tight timelines.
• Experience writing in-depth comprehensible technical and functional documentation.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2012, 2008, 2005, 2000 Power BI, Power Query, Power Pivot

Data Warehousing: SSIS and SSAS

Reporting: Microsoft SQL Server Reporting Services 2012, 2008, 2005, 2000; Apptio

ERP: Microsoft Dynamics AX 2009, 2004; Microsoft Dynamics CRM 2011, 4.0, 3.0

UML tools: Microsoft Visio

Source Control: Microsoft Team Foundation Server (TFS); Microsoft Visual Source Safe (VSS)

IDE tool: Microsoft VSTS 2012, 2008, 2005, 2003

Other: SharePoint 2010; 2007; Apptio; System Center Operations Manager (SCOM) Microsoft Project

OS: Windows Server 2012, 2008, 2003

PROFESSIONAL EXPERIENCE

Senior Technical Consultant

Confidential, Redmond, WA

Responsibilities:

• Working on designing and implementing Cost Model for Cloud Infrastructure. Goal of the project is to provide cost transparency, account, help users in cost planning by providing complete, accurate, and granular cost data for operating online services in Microsoft’s cloud infrastructure which will help identify cost optimization opportunities.
• Managing operations for Apptio solution which provide cost model units to Finance for monthly chargeback and allocation.
• Implemented Integrated Supply Chain Initiative (ISCI) for the Microsoft’s Services business, utilizing SAP’s S&OP cloud based solution. Goal of the project was to do aggregate demand and supply planning for Microsoft’s Data Center business and improve forecast accuracy.
• Extended business and technology consulting experience for day-to-day operations and environment management of Apptio product at Microsoft to help manage cost model operations for Confidential , Corporate Finance, Business Group Finance team and Business Groups to help produce monthly bills outlining all the charges associated wif services provided by Confidential to Business Groups wif full transparency and drills to individual assets dispersed across the globe.
• Worked closely wif customers to design and configure custom solutions to address their business needs and solution requirements.
• Represented the voice of the customer at each step in the development lifecycle and managed customer feedback to identify areas for services and systems improvement.
• Executed communication plans to drive awareness and adoption of the services and systems across Confidential and Microsoft.
• Conducted Monthly Business Review to track performance and identify improvements in Apptio and their service offerings.
• Performed project management including coordinating scope, scheduling, identifying and tracking project milestones for FY13 and FY14 Confidential Cost Model including project planning and providing overall project organization and tracking.
• Gatheird and authored functional and business requirements from Service Owners for new features and functionalities and worked wif IT for development on Ignition portal.
• Performed analysis and prepared inventory of current tools, SharePoint sites, and reporting tools across Confidential to drive consolidation to a single self-serve portal.
• Designed Business Information Management framework which included standardized taxonomy, information management workflows, policies, and governance model.
• Designed and managed SharePoint site for the key initiative - ‘Business Group Interaction Model’.

Business Systems Analyst

Confidential, Redmond, WA

Responsibilities:

• Managed operations and production support for Confidential ’ mission critical applications - Confidential AX Supply Chain Management (SCM), MSAsset (Microsoft’s Asset Management System), Apptio Billing Services (Microsoft Confidential ’ Billing system); and various other applications including Ignition, Operations Workbench, Consumption Planning, iPartner, Data Center Access Tool (DCAT), and Ticketing.
• Designed and implemented high availability, disaster recovery (DR), and business continuity planning (BCP) solutions for Confidential AX SCM - Asset Management system and Apptio Billing Services using Network Load Balancing, SQL Clustering, SCOM, and Active-Passive solutions.
• End-to-end ownership to upgrade product technology from Microsoft Dynamics AX 2004 to AX 2009/5.0 and Microsoft Dynamics CRM 3.0 to CRM 4.0 for mission-critical applications.
• Designed and developed Support dashboard showing health of all applications for all levels, from individual operations engineers to operations managers to track key performance indicators of systems.
• Represented Operations team as part of the IT Quad (PM, Dev, Test, and Operations) to perform operational assessment and provide inputs for all new releases and features.
• Performed release and program management for all releases to UAT and Production.
• Managed and trained Incident Management Offshore Team (5 members) for new features and functionalities for new releases.
• Performed problem management, performance tuning, defined SOPs, identified areas of improvement, and implemented system improvement plans reducing incident volume by ~ 40%.
• Managed business stakeholders’ expectations to ensure business goals and SLAs are met.
• Proactively engaged wif customers to prevent escalations.
• Authored in-depth technical and functional documents including technical specifications, functional specifications operations support guides, and knowledge base articles.
• Setup virtualization for applications saving infrastructure and maintenance costs.
• Performed system maintenance tasks including security patching to ensure security compliance, password management for system accounts, etc.

Software Engineer

Confidential

Responsibilities:

• Designed and developed billing solution for Microsoft Confidential using Microsoft technology stack including ASP.NET, C#, MS SQL, SSIS, SSRS, and SSAS.
• Designed and developed SQL package to pull and consolidate data from various source systems into a single data store.
• Designed and developed Confidential Client Onboarding workflow using Microsoft Dynamic CRM, plug-ins, and Windows Workflow Foundation (WF).
• Performed performance tuning to optimize existing MS SQL database design to optimize execution time for monthly billing processes resulting in the reduction of process time by ~60%.
• Developed reporting solution for billing and client onboarding using SSRS.
• Implemented data warehousing solution for billing using SSIS and SSAS.
• Authored and reviewed technical and functional specification documents.
• Authored induction documents and mentored trainees and new employees to the project.