Over 10 years of IT experience with strong consulting background including Project Management and Development skills. Experience include Project Planning and Management, Systems Analysis and Design, Development, and Testing experience of web based and Client/Server applications using Microsoft Technologies. Strong experience in managing global teams with very solid background at onsite-offshore model with various global teams and coordination experience across various geographies.

Rich Experience of Requirements Gathering analysis, database design, performance tuning and application integration.

Over 4 Years of strong experience in Process Engineering Quality Management including CMMI and ITSM based systems.

EXPERTISE:

Experience in Development and Implementation:

• Excellent experience with Microsoft Office SharePoint Server MOSS 2010/2007/2003, SharePoint Designer 2007/2010.
• Expertise in developing environment of n-tier web and client server applications using C . Net Framework 1.0/1.1/2.0/3.0, ASP.NET, ADO.NET, XML, Web Services, ASP 2.0/3.0, ADO, VB Script, HTML, Java Script, SQL Server 7.0, SQL Server 2000/2005, MS Access, Oracle.
• Customized SharePoint solutions using Features, Solutions, Content Types, Event Receivers, Site and List definitions, Web services, Web parts, Windows Workflow Foundation, Office 2003 and 2007.
• Implemented solutions using Master pages, Themes, CSS, Workflows, Data Views, Data Forms using SharePoint Designer 2007/2010.
• Experience with tools like Nintex,Metalogix.
• Excellent experience in Database Design and creating ER Diagrams for database depending upon the Specifications and requirements and database optimization.Experience in creating Stored Procedures, Views, Triggers and development of database objects using PL/SQL, SQL, and T-SQL in SQL Server.
• Knowledge of data modeling using tools like Erwin, TOAD and Microsoft Visio.
• Excellent Domain knowledge in Manufacturing, Management Information System, Portal Development, Supply Chain Management

Experience as Project Manager/Analyst:

• Executed and maintained program/project management processes and disciplines in the areas of: Project Planning and schedule quality management communications management human resource management cost management risk / issue management change management.
• Strong experience of working in Global Delivery Model with Onsite/Offshore teams which included Teams from India, EMEA and Americas Geo.
• Gather Business Requirements, analyze data/workflows. Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented Designs.
• Expertise in CMMI/ITSM Implementation, Project Management Reviews, ITSM Audits.
• Experience in Software Process Definition and Metrics collection, Analysis and establishing the Process Performance Baselines PPB .
• Proficient in creating UML diagrams like Use Case Diagrams, Class Diagrams, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, State Diagrams, Deployment Diagrams
• Excellent background in full life cycle development of systems: Analysis, Specifications, Design, Documentation, Programming, Testing and Maintenance of N-Tier and Client - Server applications. Excellent understanding of Client/Server, web based and object oriented architectures.
• Ability to create Requirement Traceability Matrix RTM for managing changes in requirements. in Root Cause Analysis, Defect Prevention Activities.
• Experience of Conducting interviews with key business users to collect requirement and business process information.
• Extensive experience in Project Management tools such as Microsoft Project Plan, Visio.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

• Project 1: Leading SharePoint Center of Excellence Team
• Leading the team with SP CoE associated with the EWS Web SDG SharePoint Services. We are responsible for the strategy, solutions and services for SharePoint in Novartis Pharma. To operate a global SharePoint Services in Pharma IT
• Use existing best practices, Novartis IT processes and overall standards
• Identify areas where SharePoint can reduce cost and time of application delivery
• Manage demand though strategic delivery partners
• Actively participate in driving the SharePoint strategy in Novartis
• Governance, Training, Center of Excellence
• Align with other Novartis divisions for long-term SharePoint strategy
• Site Provisioning : There is a automated process for requesting the sites, the SP CoE support team provisions the sites by creating the site following the Novartis Governance rules, and applying standard branding to the sites.
• Training and Evaluation the Users: The SP CoE team was resposible to conduct weekly training for the users for various features of SharePoint.We setup an automated Training and Evaluation system, for the users which they need to qualify in order to get the sites.
• Custom Solutions: The Custom solutions mostly involved the completed SDLC Process. We provided custom solutions for code based Application functionalities, Designer based Custom Pages, custom workflows.
• Sites Migration: We migrated the sites from one environment to another based on requests like increase in
• space, security or features. The advanced environment had features like Ninetex workflow, Bamboo webparts. The
• migration was performed using Metalogix tool. The Migration Types involved:
• Lotus Notes to SharePoint
• SharePoint to SharePoint
• 'other' to SharePoint
• SharePoint 2007 to SharePoint 2010

Responsibilities:

• Assess the needs of the Business Divisions through direct interaction and assist in the development of Business cases, Use Cases, Business Solution docs and training manuals.
• Responsible for the collecting, analyzing, interpreting, reviewing, documenting, and communication of business needs and requirements.
• Focus on developing improving business processes within the technology and business organizations.
• Involved in Requirements Gathering and discussing the requirements with users. Creating Functional Specification Documents
• Worked as Sr. Project Lead with responsibilities of creating Project Plan, Estimation, Co-ordinate with the team onsite and offshore and monitor progress. Prioritizing work , work distribution and Monitoring. Weekly Status meeting with Management Team to track the progress using Daashboards.
• Leading the team in developing web parts, Event Handlers, Custom Wokflows, Features, Solutions in SharePoint site which will interact external data sources like Oracle database
• Involved in analysis of MOSS 2010 and Migration from MOSS 2007 to MOSS 2010.
• Created Sites and Sub-sites within the site collections for Various Departments and accordingly created new Site Permission levels and Groups for MOSS 2010 site.
• Design and Developed Custom Page Layouts for Branding and Chroming of portal by SharePoint Designer 2010/2007 also look and feel of portal by modifying Master Pages.
• Providing custom workflows using Nintex Workflow.
• Involved in created presentations/training to business users/owners for the workflow processes.
• Responsible for conducting and preparing training for the users to use the new applications.
• Managed application transition for a team of resources onsite offshore.
• Perfromed Migration tasks for Sharepoint Sites using Metalogix tool.

Environment: Microsoft Office SharePoint Server MOSS 2010/2007, Windows SharePoint Services WSS 3.0, SharePoint Designer 2010/2007,Visual Studio.NET 2008/2010, MS Visio, Nintex.

Confidential

SharePoint Consultant

Project 1: DMCP Portal

The DMCP Portal will be a central web resource to find, update and track information important to the Discovery Medicine and Clinical Pharmacology DMCP department.

Long term goals of the system included:

• Providing users with a faster, simpler and more integrated ways to do work
• Unified interface with overall departmental and role-based perspectives
• Links to key tools and reports
• The following functions are in scope for DMCP Portal
• Shared Document Repository to store, route and query for DMCP documents in a centralized location
• Team sites to facilitate content development and knowledge sharing
• Teams site to guide and track the Plan approval process
• Shared messages and calendar functionality
• Implement Security

Responsibilities:

• Assess the needs of the Business Divisions through direct interaction and assist in the development of Business cases, Use Cases, Business Solution docs and training manuals.
• Responsible for the collecting, analyzing, interpreting, reviewing, documenting, and communication of business needs and requirements.
• Focus on developing improving business processes within the technology and business organizations.
• Interacting with the developers at offshore on resolving the reported bugs and various technical issues, so as to implement change management
• Involved in creating the User Acceptance Test UAT plan and test cases with the testing team, and also verifying and validating the test results.
• Involved in Requirements Gathering and discussing the requirements with users. Creating Functional Specification Documents
• Worked as Sr. Project Lead with responsibilities of creating Project Plan, Estimation and resource plan.
• Leading the team in developing web parts, Event Handlers, Custom Wokflows, Features, Solutions in SharePoint site which will interact external data sources like Oracle database
• Involved in analysis of MOSS 2010 and Migration from MOSS 2007 to MOSS 2010.
• Created Sites and Sub-sites within the site collections for Various Departments and accordingly created new Site Permission levels and Groups for MOSS 2010 site.
• Design and Developed Custom Page Layouts for Branding and Chroming of portal by SharePoint Designer 2010/2007 also look and feel of portal by modifying Master Pages.
• Involved in created presentations/training to business users/owners for the workflow processes.
• Responsible for conducting and preparing training for the users to use the new applications.
• Managed application transition for a team of resources onsite offshore.

Environment: Microsoft Office SharePoint Server MOSS 2010/2007, Windows SharePoint Services WSS 3.0, SharePoint Designer 2010/2007,Visual Studio.NET 2008/2010, C , Oracle 10, XML, WIN 2003 server, Sprint.Net, nHibernate.,

MS Project, MS VISIO

Confidential

Project Lead

Project 1: Six Sigma Process Establishment

The Project included data analysis for the current projects, collected from the different sources.

Responsibilities:

• Involved in Requirements Gathering and discussing the requirements with users. Creating Business Requirement Documents BRD's and Functional Specification Documents
• Involved in creating the User Acceptance Test UAT plan and test cases with the testing team, and also verifying and validating the test results.
• Used MS Project for managing schedules and resource management
• Project Planning and Tracking: Periodic project reviews, Project Estimation, Issue management, Metrics baselines, and involved Root Cause Analysis
• Working with business lead, QA lead, to make sure all the functionalities are being properly documented and developed and tested before released to the client.
• Assigning tasks to the team members and tracking as per the project management processes, guidelines and templates as per Industry standards like CMMI
• Planning, Managing and Tracking of the application transition and development/maintenance projects with onsite and offshore teams.

Environment: Visual Studio 2005, MOSS 2007, ASP.NET 2.0, C , ADO.NET, Oracle, SQL Server, XML, WIN 2003 server. MS Excel, MS Visio,MS Project

Confidential

Sr. Software Developer/Project Lead

Project 1: ITIL Certification Exam Registration Site

The Site developed provided the users to register in the site for taking up the ITIL Certification Exam. The Site was used for the trainer to list out and schedule the training for the registered candidate, and track their trainings. Based on the trainings completed by the candidate, they were allotted the time/date slot for taking up the exam. The site also tracked the pass/fail status for the candidate and the candidate receiving the certificate within the appropriate time. The candidates are alerted every time regarding the trainings/ exams. There was a provision for the admin to access the users' data, while a restriction for the users from accessing the other user's data. There was an Approval Form where in the users entered the details and the message were sent to their managers for their approval for taking up the certification. Also the site allowed the users for requesting for the re-imbursement for the fees from the organization.

Responsibilities:

• Involved in Requirements Gathering and discussing the requirements with users. Creating Business Requirement Documents BRD's and Functional Specification Documents
• Involved in creating the User Acceptance Test UAT plan and test cases with the testing team, and also verifying and validating the test results.
• Used MS Project for managing schedules and resource management
• Project Planning and Tracking: Periodic project reviews, Project Estimation, Issue management, Metrics baselines, and involved Root Cause Analysis
• Working with business lead, QA lead, to make sure all the functionalities are being properly documented and developed and tested before released to the client.
• Assigning tasks to the team members and tracking as per the project management processes, guidelines and templates as per Industry standards like CMMI
• Planning, Managing and Tracking of the application transition and development/maintenance projects with onsite and offshore teams.
• Devising strategies for effectively implementing change management policies as directed by the management

Environment: Visual Studio 2005, MOSS 2007, ASP.NET 2.0, C , ADO.NET, Oracle, SQL Server, XML, WIN 2003 server. MS Excel, MS Visio,MS Project

Project 2: Metrics Data Collection and Analysis Portal

• The portal was developed to provide the users Project managers/Senior management facility to enter the data for the various projects within the program. The data for the existing projects was imported from the SQL Server and Oracle.
• The actual dates for WIP for the Projects were entered by the PMs. The calculations were performed and the calculated data was displayed using the WebParts in the Site. This tool was mainly used for tracking Schedule variance and Effort variance for the Projects.

Responsibilities:

• Gathering of requirements from various teams, consolidation of requirements, designing of application flow determine the business needs and define the functional requirements
• Conducted user interviews, brainstorming sessions, and Joint Application Development JAD sessions to create Activity and Sequence diagrams using MS Visio.
• Responsible for reports displaying calculated data for the various required Metrics based on the Project types and KPIs.
• Used the Excel Web Services for the Senior Management for further discussion making.
• Responsible for providing the Understand the Business Process , identified enhancements and gather Business needs and converted it to the Functional Requirements Specification Document to integrate into the new system
• Created System Architecture and Process Flow diagrams using MS Visio to define the system functionalities and manual processes
• Planning, Managing and Tracking of the application transition and development/maintenance projects with onsite and offshore teams.
• Supported the Program Manager in balancing project goals and business needs

Environment: VISUAL STUDIO 2005, MOSS 2007, ASP.NET 2.0, C , ADO.NET, Oracle, SQL Server, XML, WIN 2003 server ,InfoPath Forms 2007, MS Visio, MS Excel

Confidential

Responsibilities:

• Interacted with Users, Developers, Project Manager and Subject Matter Experts to understand the business process, identified enhancements and gather Business Requirements to be converted to the Functional Requirements Specification Document for integration into the new system
• Develop Requirement Traceability Matrix RTM for managing changes in requirements
• Collaborated on creating Work Breakdown Structure using MS Project
• This project involved a tool called Executive Viewer which is a reporting tool, used for analyzing the Performance of the team. This used SAP Database. The reports/charts extracted from the Tool were put across in the PPT and was uploaded for the PMR meeting with the Client.
• Implemented Issue Management for the project using MS excel in which the Team entered the Issues and that was updated and reviewed during the team meetings.
• The participants were sent alerts for the meetings or If any data was required for analysis.
• This project was basically to implement the ITSM for Incident management,Problem Management and Services like Availablity and Continuity Mangement

Environment: VISUAL STUDIO 2005, Sharepoint 2003, WSS 2.0, ASP.NET, C , ADO.NET, SQL Server, XML, WIN 2003 server, MS Visio, MS Excel, MS Project

Project 4: Project Assistant

• Project Assistant is a tool for the Project Analysis for the Project managers and Program Managers. It was helpful for the tracking of the Projects from the start, their WIP and the Closure. It comprises of reports like Schedule Variance, Effort Utilization, etc.
• Project Assistant has two parts web application which needs data and questionnaire completed by the client and second report generation application.

Responsibilities:

• Used MS Visual Source Safe for Version Control Management
• Coded for remote data accessing using XML Web Services for fetching data for various modules.
• Used InfoPath Forms 2003 for data collections.
• Responsible for creating Work Breakdown Structure using MS Project
• Responsible to gather the Business Requirement Involved in Requirements Gathering and discussing the requirements with users.
• Developed Business Data Objects, Business Services, Web Objects and data layers.
• Designed and developed various Data Transformation Services DTS Packages for the data transformation for uploading data.
• Written various stored procedures, Triggers, Views in T-SQL using MS SQL Server.
• Involved in Unit Testing and Integration Testing of various modules of the project.
• Project Planning and Tracking: Periodic project reviews, Project Estimation, Issue management, Metrics baselines, and involved Root Cause Analysis
• Project management process/ methodology: Reuse standardized software engineering and project management processes, guidelines and templates as per Industry standards like CMMI, ITIL.

Environment: ASP.NET, C .NET, Web Services, IIS , MS Visual Source Safe, MS SQL Server 2005, ADO.NET, MS DTS, HTML, JavaScript, XML, XSL,SharePoint 2003, WSS 2.0. MS VSS,MS Office, MS VISIO.

Confidential

Responsibilities:

• Responsibilities:
• Tool used in executing supply chain transactions, managing supplier relationships and controlling associated business processes. It encompasses the planning and management of all activities involved in sourcing, procurement, conversion, and logistics management activities.
• Project 1: Supply Chain Management System:
• Confidential
• Environment:ASP.NET, C .NET, Web Services, IIS , MS Visual Source Safe, MS SQL Server 2000, .NET Framework, ADO.NET, MS DTS, HTML, JavaScript, XML, XSL.MS Visio.
• Coordinated the work flow between onsite and offshore EMEA .
• Escalate non compliances to Q Rep.
• Auditing the process compliance of the project and submitting the audit report to QREP every month.
• Timely submission of project metrics report to the QREP.
• Reviewing and ensuring the execution of the Project Plan Defect Prevention Plan
• Adhere to the processes and plans defined for the project
• Involved in writing SQL queries on SQL Server for stored procedures for optimization and performance.
• Written complex stored procedures .functions and trigger using SQL Server 2000.
• Coded various components to access the WebService functions using VB.NET.
• Designed Business Logic Components and Data Access Classes using C .
• Analyzing User Requirements. Outlining Business Flow. User Interface Design preparing User Requirement Document URD .Preparing Implementation Plan. Testing System Software Replication .
• Analyzing User Requirements preparing Request for Proposal RFP .Outlining Business Flow. User Interface Design preparing User Requirement Document URD .Preparing Implementation Plan. Testing System Software Replication .
• Developed a Web based Intranet application using ASP.NET, VB.NET, C
• ASP.NET web forms, web controls, html controls are used to develop rich user interface.
• Involved in Component Design, Business and Data layer Components in C , ADO.Net.
• Developed a Web Service which accepts XML string as the input parameter and returns customer data in XML format to the client application.
• Created XSLT to present the raw XML data as reports in HTML format for top management review.
• Used ADO.NET to provide connectivity to MS SQL Server 2000 back end database.
• Involved in designing database and creating indexes, triggers, stored procedures and Query Optimization.
• Involved in Unit-testing of individual modules during the development stage.
• Developed Stored Procedures which could accept a XML string as a parameter from the Front-
• End and parse it to insert multiple data records.
• Coordinated the work flow between onsite and offshore.

Environment: ASP.NET, C .NET, VB.NET, Microsoft Visual Studio 2003, IIS , MS Visual Source Safe, MS SQL Server 2003, .NET Framework 2.0, ADO.NET, MS DTS, MS ASP.NET 2.0, MS SQL Server Reporting Services, HTML, JavaScript., ASP,VB

Confidential

Responsibilities:

• Gathering of requirements from various teams, consolidation of requirements, designing of application flow and design database schema in MS SQL Server.
• Developed a Web based Intranet application using ASP.NET, VB.NET
• ASP. Net, C , Web forms, user controls, web controls, html controls, XML, XSL were used to develop rich user interface.
• ASP.NET web forms, web controls, html controls are used to develop rich user interface. Application used server-side validations.
• Developed a Web Service which accepts XML string as the input parameter and returns customer data in XML format to the client application.
• Created XSLT to present the raw XML data as reports in HTML format for top management review.
• Used ADO.NET to provide connectivity to MS SQL Server 2000 back end database.
• Involved in designing database and creating indexes, triggers, stored procedures and Query Optimization.
• Involved in Unit-testing of individual modules during the development stage.
• Environment:Microsoft Visual Studio 2003, IIS 6.0, MS Visual Source Safe, MS SQL Server 2000,C ,VB.NET, ASP.NET, ADO.NET, VB.NET, DTS, Oracle ,TOAD