Shikha Singh

Experience

• 

  Seasia Consulting

  May 2005 - Feb 2006

  Software Developer

  1. Analyzing the requirements of Modules2. Forms and Reports Designing.3. Creating Triggers, Functions, Constraints, Cursors, Views, Indexes and Stored Procedure Development for the modules.4. Server Maintenance (Backup and Restoration).5. Performance monitoring of various Procedures.6. Uploading of Data through Bulk Copy Program and Bulk Insert Utility.7. Uploading Data through Data Transformation Services (Import/Export Wizard in SQL Server 2000)8. Testing (Unit, Integration) of various Modules Show less

• 

  NIIT

  Aug 2006 - Mar 2007

  Systems Associate

  1. Conduct of Education Delivery Sessions as per the product methodology.2. Maintenance of the Hardware & Software of Practice Lab.3. Academic and Administrative Duties.4. Active participation in the affairs of learned and professional societies, and keeping abreast of research and development in area of teaching.5. Keeping track of Milestones delivered

• 

  Seasia Infotech

  Apr 2007 - Apr 2011

  SQL Dev

  1. Creating Triggers, Functions, Constraints, Cursors, Views, Indexes and Stored Procedure Development for the Batches delivered.2. Server Maintenance (Backup and Restoration).3. Uploading of Data through SSIS Packages of SQL Server 2005.4. Performance monitoring of various Procedures.5. Uploading of Data through Bulk Copy Program and Bulk Insert Utility.6. Updating Statistics.7. Database Maintenance.8. Optimization of database through SQL Profiler.

• 

  National Rural Health Mission

  Jan 2012 - Dec 2012

  RTM

  1. Monitoring of RT activities through software EPI Info.2. Testing of the Surveillance System named “Mother and Infant Death Reporting System”.3. Ensure comprehensive process documentation.4. Carry out other tasks/activities related to Referral Transport Scheme as and when required by Medical Officer (Referral Transport).5. Generating reports of Referral Transport Activities.6. Feedback Collection from districts Control Room.

• 

  National Health Mission, Haryana

  Dec 2012 - now

  Programmer (SQL Server Administrator)

  ➢ Performed the Database Development of queries, views, triggers and stored procedures for development teams in MS SQL SERVER 2014.➢ Design, Management and Maintenance of 11 databases for all the in house applications under Government of Haryana in MS SQL SERVER 2014.➢ Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, hardware/software installations, configuration, upgrades, security, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.➢ Developed SQL scripts (functions or stored procedures) for automating complex or repetitive database related tasks.➢ Created documentation for MS SQL Server Coding Guidelines which includes models for Standard Operating Procedures, Database Design documents, definitions for the meta data and Implementation Plans for Change Management purposes. Implementation of same by all the team members.➢ Worked on Data transformation services through SSIS.➢ Optimization and Troubleshooting of issues through SQL SERVER Profiler.➢ Refining of logical design of database to meet the Meta Data standards.➢ Migrated the databases from MS SQL SERVER 2008R2 to MS SQL SERVER 2014.➢ Created Jobs in SQL SERVER Agent for automation of tasks which include Weekly Backups and Shrinking of Transaction log files.➢ Code review of the database scripts (stored procedures, cursors, triggers, views) created by developers.➢ Guided the team members to resolve the complex or expensive queries through performance tuning, index management.➢ Implement and maintain database security which includes creation of users, roles and assigning privileges).➢ Master Trainer in WHO project of Data Usage Workshop in the Haryana state which includes providing training to Medical Officers / Deputy Civil Surgeons / Senior Medical Officers regarding the portals operational in the state of Haryana along with hands on orientation of participants. Show less