• Managed entire project lifecycle that includes requirements gathering, as-is process mapping, to-be process design, POC development, lead development, testing & go live for RMS implemented with SQL Server. Conducted road shows for launch to introduce Release Management System (RMS). • Architected, implemented and managed deployment of RMS using Microsoft SQL Server. Designed E-R models for OLTP staging and production tables of Release Management System.• Defined and launched Release business process for in-house software development including Change Request process. Defined and integrated Service Capacity Management process.• Identified entities, developed conceptual, logical and physical data models and created database objects. • Create complex stored procedures rolling up and aggregating transactional data to load tables.• Create Design Document including process maps, data flows, data mapping, relational models. • Conduct joint UAT sessions to ensure that the newly deployed system runs efficiently and accurately.• Improve performance by adding indexes and implementing appropriate structures including CTEs, Temp tables in the long running Stored Procedures. • Successfully created & delivered technical as well as project documentation throughout SDLC lifecycle.• Communicate projects status to cross-functional teams and program manager internally and to vendors externally. • Formulated and enforced Split of Responsibility matrix between Planning, Development and Operation teams to operationalize newly developed systems.

Project Management Office – Project and Portfolio Management • Formulated projects prioritization process based on the Portfolio Management guidelines.• Conducted organization wide workshops to establish a centralized Project Management Office.• Implemented and ensured compliance of the introduced Project & Portfolio Management process.• Designed and created database tables, views, indexes and triggers to store and retrieve projects data.• Designed ETL process, identified the source systems and defined data mapping rules to migrate data. • Created and scheduled complex Stored Procedures to automate data loads to Transactional Database.• Led the project to develop & deploy Demand Portal using MS SQL Server 2016, Project Server integrated with SharePoint Server. Demand Portal was used for portfolio analysis and to manage projects.