SUMMARY

• Total 13+ years of professional IT experience in all phases of Software Development Life Cycle which includes Requirement Analysis, Design, Effort Estimation, Core Development, Integration, Implementation and End - user Training.
• Experienced in diverse domains such as Banking & Finance, Human Resource and Education.
• Experienced in Waterfall & Agile(using SCRUM) Project Management Methodologies.
• Sound knowledge of IT Service Management (ITSM) processes and standards.
• Experienced with technologies like Microsoft SQL Server, Sybase and Oracle.
• Highly experienced in MS SQL Server Database including development & designing logical/physical databases.
• Expertise in writing complex Stored Procedures, Triggers, User Defined Functions, Views, SSIS, and SQL DTS packages, etc.
• Strong abilities in Database Design, Normalization, and De-Normalization.
• Hands-on Database programming experience in RDBMS technologies like Sybase and Oracle.
• Well versed with ticketing system like Service-Now(SNOW), BMC Remedy (OPAS)and MKS Integrity.
• Good experience in source safe tools like MKS Source Integrity and Microsoft Visual Source Safe.
• Experienced in preparing Quality Process documents as per the standards.
• Experienced of Test Case Creation, Test case execution, Defect solving and Tracking.
• Executed projects at CMM level 5.
• Excellent communication, interpersonal and presentation skills.
• Excellent work ethics, self-motivated and quick learner. Willing to learn, adapt to new technologies and third party products.
• Strong analytical, organizational and coordination skills.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long-term business and system requirements.

TECHNICAL SKILLS

RDBMS: MS-SQL SERVER 2008/2005/2000 /7.0 , Sybase, Oracle

OPERATING SYSTEMS: Windows 9x / XP / VISTA / / 2007 / NT, UNIX, LINUX

Source Control Tools: MKS Source Integrity, Visual Source Safe

Ticketing Systems: Service-Now (SNOW), BMC Remedy (OPAS) & MKS Integrity

PROFESSIONAL EXPERIENCE

Confidential, NEW YORK CITY, NY

Lead/Sr. SQL Server Developer

Responsibilities:

• Lead Development team of Research & Analytics Systems suite of applications. Total there are 20+ applications.
• Responsible for Requirement Gathering, Design Analysis, Effort Estimation, Task Allocation, Development & Implementation, Defect Resolution and Release.
• Involved in all stages of Software Development Life Cycle (SDLC).
• Involved inDesign Analysis, Core Development, Implementation and Defect Resolution and complete it within agreed time-frame using Agile or Waterfall Project Methodologies framework.
• Involved in Requirement Gathering, Design Analysis and Release Planning meetings with client stakeholders.
• Responsible to Design, Develop, Implement, Maintenance of Database Objects like Tables, Stored Procedures, Views, User Defined Functions, Triggers, and SSIS/DTS packages etc. using RDBMS MS SQL 2008/2005/2000 .
• Support applications built in Legacy technologies like MSSQL 2000/2005 and migrate/upgrade to MSSQL 2008.
• Involved in Daily Scrum calls for the releases governed under AgileProject Methodologies framework.
• Take active participation in Incident Management, Problem Management and Change Management meetings.
• Involved in creating Data Flow, Data Model, and Architecture Diagrams. Also Involved in Database Design.
• Responsible to provide Knowledge Transition toOperation teams for all the scheduled Production Releases.
• Responsible to provide Level-3 Support for resolving Production Issues escalated by PS team.
• Responsible to attend High Severity Production Issues Bridge Calls as and when required and provide inputs for its resolution.
• Currently Single Point-Of Contact (SPOC)&Subject Matter Expert (SME) for all Research suite of applications.
• Responsible to handle client escalations and address it.
• Responsible to manage offshore team and authorize to Hire and Fire them.
• Take active participation Disaster Recovery activities that are planned twice in a year

Environment: MS SQL Server 2008/2005/2000 , Sybase, MKS, Service-Now (SNOW), and BMC Remedy (OPAS).

Confidential

Responsibilities:

• Developed Database projects for various Web applicationof Legacy Moodys.com website using MS SQL Server 2008/2005/2000 , Sybase, and MKS.
• Supported application using Legacytechnology like MSSQL 2005/200and migrate them to MSSQL 2008.
• Responsible to Design, Develop, Implement, Maintenance of Database Objects like Tables, Stored Procedures, Views, User Defined Functions, Triggers, SSIS/DTS Packages, etc. using RDBMS MS SQL 2008/2005/2000 .
• Involved in making various documentations like Impact / Design Analysis, Unit Test Plan, Code Review document, etc.
• Involved in creating Data Flow, Data Model, and Architecture Diagrams. Also involved in Database Design
• Worked with Source Code control like MKS Source Integrity.
• Worked with static content repositories like SharePoint.
• Taking Knowledge Transitions for various applications and preparing detailed documentations of the same.
• Successfully moved from Transient to Steady state for various applications and have taken full ownership of the same from client.
• Responsible for multiple applications of Legacy moodys.com (v2.moodys.com ) website and have experience of handling multiple Projects of different applications simultaneously.

Environment: MS SQL Server 2008/2005/2000 , Sybase, MKS.

Confidential

Sr. Database Programmer / Development Manager

Responsibilities:

• Interacting with client to finalize the requirements, design and delivery.
• Responsible of overall Development of EAS project and was in charge ofentiredevelopment team’s delivery.
• Responsible of Monitoring, Reviewing and Resolving Issues raised by client and internal QA team.
• Involved in Planning and Designing as per client’s requirements.
• Assign tasks to Development team and track their progress.
• Responsible for each and every Database activity of MS-SQL 2000 such as design, develop, maintenance & implementation.
• Responsible for Designing various Database objects such as Tables, Stored-Procedures, Views, Triggers, User Defined Functions, etc.
• Also involved in creating the same as and when required by team.
• Involved in implementing and maintaining the application at client location.
• Preparation of Quality Process documents as per the standards.
• Worked on all modules of EAS application like Payroll, Leave Management systems, etc.

Environment: MS-SQL Server 7.0/2000, Oracle 8i/9i, ASP, and Visual FoxPro 7.0.

Confidential

Database Programmer

Responsibilities:

• Worked as Database Programmer & System Implementer.
• Design, Develop and ImplementDatabase projects using Relational DatabaseManagement Systems like MS-SQL 7.0/2000 and Oracle 8i/9i.
• Creating and Changing Database objects like Stored Procedures, Triggers, Tables, Views, etc. as per requirements.
• Developed Database Project for Central Reservation System product.
• Preparation of Quality Process documents as per the standards.
• Responsible of Monitoring, Reviewing and Resolving Issues.
• Worked with Source Code control like VSS.
• Implemented the project at one of the client location in Chennai, INDIA

Environment: MS-SQL Server 7.0/2000, Oracle 8i/9i, ASP, and Visual FoxPro 7.0.

Confidential

Responsibilities:

• Worked as a Database Programmer & System Implementer.
• Design, Develop and ImplementDatabase projects using Relational Database Management Systems like MS-SQL 7.0/2000 and Oracle 8i/9i.
• Creating and Changing Database objects like Stored Procedures, Triggers, Tables, Views, etc. as per requirements.
• Developed various Database Projects for Web based applicationslike 360-Degree Appraisal, Recruitment, Shift Management System, and Leave Management System of Human Resource Information System (HRIS) product.
• Preparation of Quality Process documents as per the standards.
• Responsible of Monitoring, Reviewing and Resolving Issues.
• Worked with Source Code control like VSS

Environment: MS-SQL Server 7.0/2000, Oracle 8i/9i, ASP, and Visual FoxPro 7.0.