Prerna Valecha Email
accvi6@r.postjobfree.com
Mob 609-***-****
Professional Summary
Prerna Valecha is a Microsoft Certified Professional with a multi industry
experience working in Microsoft Share Point Portal solutions & business
analyst capacity. An efficient team leader with a record of successfully
delivered projects in diverse industries. Responsible for solution
development, technical/business support, team & building. Expertise in
supporting custom solutions for various SharePoint applications. She has
rich experience with Share Point 2007/2010 in Pharmaceuticals, financial
services, and oil & gas domain.
. Rich Experience in supporting SharePoint 2007 & 2010 portal
applications & solutions.
. Expert in designing & creating workflows using Nintex /SharePoint
designer to automate the business processes.
. Provide out of the box solutions/workarounds to the users.
. Supporting the production SharePoint sites & fixing the low, medium &
high propriety issues.
. Develop governance standards & best practices for existing SharePoint
portals.
. Manage content by creating Content Types, Meta data & taxonomy.
. Trained the information workers on creating sites, document libraries,
lists, assigning permission to sites, sub-sites, folders, lists and
documents (item level security), configuring business workflows &
content management capabilities.
. Experience on multiple projects for gathering/managing requirements
and getting sign-off on requirement documentations.
. Excellent analytical skills in understanding the business
requirements, business rules/processes and design of the application.
. Translating business needs and objectives into business and technical
requirements. Creating Business Requirements Specification and
Functional Specification Documents.
. Proficient with HPQC Quality Centre tool.
. Define Test strategy, approach and execution plan for medium to large
scale system solutions.
. Monitor defect resolution process & assist in coordination/integration
between teams for defect resolution.
. Document test execution results and maintain defect logs.
. Develop processes and best practices to streamline test activities.
. Experience in all stages of Software Development Life Cycle.
. Ability to prioritize responsibilities, manage multiple projects and
keep close attention to details.
. Excellent written and communication skills.
. Participated in resource management activities & have participated in
performance moderation.
. Flexible to work on multiple time zones while working on
offshore/onshore model
Technical Skills
Microsoft Specific Skills Other Skills
MOSS 2007/2010 HPQC
MS InfoPath 2007/2010 HTML
MS Visio Hypertext Markup Language
MS Share Point Designer C++
NET Framework Microsoft office applications
C#
Microsoft Visual Safe Source Jquery
ASP. NET JavaScript
Microsoft IIS Web server Remedy Support Tool
Team Foundation Server Nintex
Current Company: SBP Consulting (USA)
Project:
Global Pharmaceutical client - Novartis ( Cambridge, MA)
Duration : May 2013 to present
Title : SharePoint Lead
Client : Global Pharmaceutical Client
Role & Responsibilities
As SharePoint Lead my role involves
. Analyse and document the System specifications, Business requirements
and detail design of the software for full understanding of the
business.
. Map the business requirements into the process flow diagrams.
. Create & design workflows using Nintex to automate the Day one
Transformation business processes to address the fragmented and
uncoordinated set-up process for new personnel into the centralize and
link related business functions and activities to improve the set-up
of new employees and contractors.
. Develop governance standards & best practices for existing Share Point
portals.
. Manage & organize content by creating & using search scopes, content
types, meta data,publishing features, record management
capabilities.
. Create surveys & conduct meetings with the business to understand the
requirements on the existing portal
. Create and configure workflows using Nintex and SharePoint designer.
. Created browser compatible forms using InfoPath 2010 and deployed to
Form Library in share point sites.
. Maintain, configure SharePoint sites using Metalogix Migration third
party tool
. Integrate applications using client side scripting languages like
Silverlight, JavaScript, and Jquery.
. Design, develop & support Share Point deployment, configuration and
customization of projects.
. Create functional specification documents and guide technical team.
. Review the Share point related tickets in the remedy tool to
understand the on-going issues & provide trainings to the business
users and create useful repository for the users documenting the
common issues & there resolutio
SBP Consulting
Project:
Global Pharmaceutical client- AstraZeneca ( Wilmington, DE)
Duration : November 2012 to April 2013
Title : SharePoint Lead
Client : Global Pharmaceutical Client
Role & Responsibilities
As a SharePoint Lead my role involves
. Developed and implemented web parts and customization of Share Point
sites using Visual Studio and .NET technologies to supplement out-of-
the-box functionality.
. Developed applications using Visual Studio .NET, Share Point Designer,
and XML including the design and implementation of custom web parts
and other programs utilizing the Share Point object model using C#.
. Participate in the migration of the documents from eRoom to Share
point discussing the retention policies of the documents & the
archiving process.
. Assist the developers on enhancing the existing share point sites in
the USIS Test environment that can be migrated to production.
. High level client exposure and interaction with manufacturing
leadership from both the business and IT areas
. Designed and conducted testing of the developed functionality using
tools like HPQC, WatiN
Past Professional Experience: Accenture
Project
Global Pharmaceutical client- Bristol Myers Squibb (Princeton,NJ)
Duration : April 2010 to October 2012
Title : Sharepoint Lead
Client : Global Pharmaceutical client
Role & Responsibilities
As an onsite Sharepoint Lead my role involves
. Develop governance standards & best practices for existing SharePoint
portals.
. Trained the information workers on creating sites, document libraries,
lists, assigning permission to sites, sub-sites, folders, lists and
documents (item level security) & content management capabilities.
. Support the existing applications through tickets & provide the users
creative solutions & workarounds to resolve the issues.
. As a Share Point administrator was responsible for provisioning the
share point sites, configuring workflows, web parts, workspaces,
permissions etc.
. Use discussion forums to support users with there Share Point problems
using out of box feature & provide solutions using client side scripts
like jquery or JavaScript for quick resolutions.
. Create permission matrix for the user access & Used Audience Targeting
for Web parts.
. Participated in various business workshops to understand customization
requirements for SharePoint Portals.
. Conduct JAD (Joint Application Development) sessions with SMEs to
discuss requirements and Identified Use Cases from the requirements.
. Translate business wants, needs, requirements, and objectives into
Functional and technical requirements.
. Creating Business Requirements Specification and Functional
Specification Documents.
. Responsible for new process development, fit gap analysis, training
business users for new process implementation.
. Develop communication plan and materials Develop Test Scripts for
integrating FAST enterprise Search & Yammer the enterprise social
network with Share Point environments.
. Managed test reporting, defect resolution, results analysis and
metrics.
. Test and support Change Controls during production Implementation and
troubleshoot any issues that come up during the production
Implementation.
. Analyze and ensure non-functional test results and changes/defect are
reflected in the test case and test cases are updated appropriately
based on
. supporting both pilot launch and global launch.
. Create computer-based training modules supporting global roll-out of
SharePoint.
. Interact with the off shore delivery team for smooth delivery.
. Manage SharePoint Support Team, consisting of onshore and offshore
resources.
Project
Global Pharmaceutical client (Bristol Myers Squibb,India)
Duration : April 2009 to April 2010
Title : Senior Analyst
Client : Global Pharmaceutical client
Role & Responsibilities
As an Off Shore Senior SharePoint Analyst my roles & responsibilities
included:
. Support, maintain & monitor the SharePoint 2007/2010 portal
applications & ensure the solution is leveraged effectively to meet
the needs of the client.
. Constant interaction with business end users to understand and
resolve issues.
. Proposed creative solutions to resolve the issues related to
SharePoint.
. Ability to test and evaluate third party web parts for Share Point.
. Involved in enhancements for existing applications.
. Lead multi vendor team (HP, Accenture) for various production
releases.
. Created & Designed Test Plans, Test strategy, Test Closure Memo &
traceability Matrix.
. Monitor defect resolution process & assist in
coordination/integration between teams for defect resolution.
. Responsible for validating the automated regression test results for
new enhancements, and deployments.
. Proactively lead analysis to identify, evaluate and resolve complex
problems during testing.
. Used the Quality Centre tool to accomplish basic yet critical tasks
such as monitoring test progress.
. Enhanced and extended use of SharePoint by creating widgets using
client side tools like jquery, Java Script and silver light.
. Contributed to development of knowledge base for SharePoint
Operations Support team.
Project
Global Financial Services Client- RSA (Royal and Sun Alliance, Sweden)
Duration : Nov 2008 to March 2009
Title : Senior Programmer
Client : Global Financial Services Client
Roles and Responsibilities:
As a Onshore Senior Software Developer
. Gathered all the relevant information regarding data and analyzed it
to identify the pain-points of the prospective clients.
. Clarified client requirements, business needs and project objectives,
via feedback sessions and client meetings, in collaboration with all
stakeholders.
. Analyzed and documented the System specifications, Business
requirements and detail design of the software for full understanding
of the business.
. Created UI Mock-ups according to end user requirements.
. Designed the technical solutions to use SharePoint 2007.
. The customization involved like development of user controls, Site
Definitions, Content Types, Lists, and Event Handlers, Web parts in
Visual Studio 2008 using C Sharp.
. Developed a Shared Services portal using Microsoft Office Share Point
Server 2007. The development of Web parts and page layouts involved
use of SharePoint designer, C#, JavaScript.
. Enhanced and extended use of Share Point by creating widgets using
client side tools like jquery, java script.
. Deployed custom features using STSADM commands tool at different
levels including site collections, web applications and site level
. Participated in End-to-End testing of the portal.
. Involved in defect fixing and UAT.
Project 5
Global Oil and Gas Client - Shell
Duration : March 2008 to Oct 2008
Title : Senior Programmer
Client : Global Oil and Gas
Roles & Responsibilities:
. Participated in the meetings with stakeholders and managers and
understood various process plans, business process, and functionality
in detail.
. Developed a Requirement Traceability Matrix (RTM) and ensured its
timely update.
. Took part in the preparation of Project plan.
. As a Senior Programmer was involved in the customization for many
modules in Visual Studio.NET 2005 using C sharp and XML to create
different lists, Document library, Sites, Sub sites, blogs and wiki
Sites.
. Deploy custom share point solutions in development environment using
STSADM utility & coordinate with infrastructure team for solution
deployment in UAT & Production environments.
. Involved in end to end testing of portal (Manual testing).
. Actively involved in walkthroughs and meetings with development team
to discuss defect fixes and retesting.
Project 6
IDCFS Portal: Accenture
(Intranet Web Application)
Duration : Dec 2006 to Feb 2008
Title : Associate Software Engineer
Client : Accenture Internal Project
Role
. Gathered business requirements for custom SharePoint features,
including dashboard and KPI development.
. Developed Share point collaboration Portal & Customised master page
and style sheets, content types, features, solutions, Excel Services
& UI Branding.
. Involved in the creation of different lists, Document library, Sites,
Sub sites, blogs and wiki Sites, Used all out of the box features for
workflow and security issues, Created dashboards using excel services
2007.Customised master pages, style sheets, themes, workflows using
Share Point designer.
. Involved in acquiring complete knowledge about the application, from
the SMEs and transition it to offshore team.
. Derived Use Cases and Use Case Models from Business Rules and
Business requirement documentation.
. Developed & maintained the knowledge management portal for
organizational capabilities.
. Created the user manual for the end users to understand the overall
functionality of the portal.
. Involved in Unit Testing and User Acceptance Testing.
Professional Certifications
Microsoft Certified Professional MCPD - Enterprise Application Developer
3.5
Microsoft Windows SharePoint Services 3.0 - Application Development
Professional Membership
Member of Women's Active participation in discussion forum on issues
Networking forum like work/life balance.
Member of CSR As member of Corporate Social Responsibility we
donate our time & help to people in old age homes
& educate children in orphanages
Organized blood donation camps in our company
Highest degree of Education Uttar Pradesh Technical
University
Bachelors of Year of completion 2006
Technology in with 85%
Computer Science
Engineering.