Worked as a Project Manager was responsible for design, development, deployment and maintenance of database (MS SQL Server 2008 R2) required for the HR web application on ASP.Net 4.5 and IHRMS application. The projects on web included display of Career details of individual on web, capturing of Aadhaar details in respect of Naval Personnel & families, provision of pre-filled Nomination Form & Retirement forms and regular updation of personal records. As Project Manager Developed several HR Management modules for selection of IN Officers for promotions / posting and tools for career planning of Officers. Executed several new projects and designed their workflow and excelled in execution of Turn-Key Projects for IHRMS (Integrated Human Resource Management System) and also has developed the SRS for eACR Project currently underway at IHQ MoD(Navy)/DOP, integrating other stake holders to Servers of IHRMS server for fast tracking of personnel updates with aim of Steering Navy to Digital Navy. With depth HR Domain knowledge Solved complex policy making problems using PowerBI and SQL. Steer the organization to think from OLTP application to OLAP and Analytical Application.

Database Administrator:

• Managed various MS SQL Server 2008R2 databases.

• Performance monitoring.

• Planning and executing High Availability Solutions.

• Performed SQL Server Backup and restoration.

• Did Replication, Mirroring, Performance tuning and optimization (Query Optimisation and Index tuning).

Worked as Team Leader of 6-8 developers. I was responsible for design, development, deployment and maintenance of enterprise level .Net (4.5) applications for management of HR information of all Indian Naval personnel of officer cadre. Shifted the SDLC model from Agile to Scrum and Extreme Programming (XP).

Responsibilities:

• Team management.

• Coordination with Hardware Team for setting up of hardware infrastructure.

• Troubleshooting TFS issues/ code collaboration.

• Project environment setup and issues.

• Developed training plans for the team to sharpen their skills.

• Effort estimation for project in hand.

While administering/managing the IHRMS, several value additions/module developments have been developed and successfully implemented. Various system enhancements have facilitated personnel management decisions by ensuring availability and integrity of information (ETL) suitably formatted for different levels of management using SSIS. Responsible for creating a Data Modeling (Extraction, Transformation & Loading). I put in continuous efforts to improve the programed logic by implementing the personnel policy changes for various HR related activities.

This phase was utilized for learning and gaining business logic of existing of HR application and website. I was assigned with application maintenance and improvement tasks consisting of Developing Stored Procedure based SSRS reported and integrated them with HR application. Participated in day to day SDLC development activities.