Ranjana Goel
#**, ** **** ***** *** Beaverton, Oregon 97006, US.
Email: ****.*******@*****.***, Mobile: +1-408-***-****
Summary
• A Microsoft-certified SharePoint professional with 7.5 years of experience in designing and programming,
leading offshore development teams and gathering business requirements from client stakeholders.
• Having strong understanding of Software development life cycle and Agile methodology.
• Developed technical and business requirements documentation. Created prototype of the application for demo
before developing the application.
• Created custom web parts, SharePoint 2013 designer workflows for SharePoint Online tenant.
• Working experience as SharePoint admin for supporting SharePoint 2010 portal.
• Experience in installation and configuration of SharePoint 2007 and SharePoint 2013.
• Provided the SharePoint governance for unmanaged SharePoint 2007 internal sites. Provided technical
consultation to client for any SharePoint issue.
• Having working experience in Design, Development and implementation of SharePoint technologies include
MOSS 2007, SharePoint 2010, SharePoint 2013.
• Having hands on experience with SharePoint Designer 2007 and 2010 and implementation of various
SharePoint Web Parts, forms development using InfoPath 2007, 2010 and 2013, SharePoint designer
workflow, event handlers, Excel services setup and configuration, Master Pages, Page Layouts, Features,
Workflows, site columns and lists, taxonomy fields, Timer jobs, User Profile, Enterprise Search Configuration,
and Business Connectivity Services (BCS). Used XSLT, CSS, and JavaScript for SharePoint application web
parts.
• Experience in developing SharePoint applications using C# as programming language in Visual Studio 2005,
2010 and 2012.
• Participated in peer code review and conducted knowledge transfer sessions for new engineers in the project.
• Participated in UAT, user training, defected fixing and change requests implementations.
Technical Skills
Operating Systems: Windows Server 2003/2008/2012
Programming & Scripting Languages: C#, HTML, XML, XSLT and JavaScript
Database: SQL Server 2005/2008/2012
Applications: Microsoft SharePoint 2007/2010/2013,SharePoint Online, Office 365,
Visual Studio 2005/2010/2012, InfoPath 2007/2010/2013, SharePoint
Designer 2007/2010/2013.
Certifications
Microsoft Certified Professional: Enterprise Application Developer - SharePoint 2007
Microsoft Certified Technology Specialist: Office SharePoint Server 2007-Application Development
Work Experience
CSG pro (Onsite at Portland through Horizon Consulting) Feb’14 to current
Project #1: SharePoint Administration Support
Client: TriQuint
Role: SharePoint Specialist
Description: The intranet portal was built on Microsoft SharePoint 2010. It contained many sub sites and site
collections under main portal. The portal was used by employees to maintain documents, process flow,
approval process, publishing company news and events, conducting surveys, HR related activities
Tasks and Actions:
1
• Outlined project requirements.
• Handling client’s customer requirements.
• Supporting SharePoint Help desk queue related to SharePoint 2010 site collections. Managed
and resolved SharePoint application issues.
• Solution builds for application like SharePoint designer workflow, InfoPath form, and CQWP
web parts, Page layouts.
• Managing user permission and security on library and list which are confidential.
• Created content types and site columns.
• Created Search keywords and queries.
Environment: SharePoint 2010, Office 2010, InfoPath 2010, SQL Server 2008, Visual Studio 2010, C#,
Windows 2008 server, SharePoint designer 2010, .NET Framework 3.5.
Project #2: SSII HR Employee Action Form
Client: Schnitzer Steel
Role: SharePoint Specialist/ senior developer
Description: The HR portal was built on SharePoint Online. This project was to create dynamic forms for HR
Employee Action with fields outlined in the wireframes provided by Schnitzer. The form has been embedded
with the rules and logic to fill out data and information dynamically based on the chosen action and other
relevant requirements. The SharePoint designer 2013 workflow has been created for various levels of approval
process and sending emails. The Security and permission setup has been done as this was highly confidential
system. The form XML data is then stored in SharePoint. Schnitzer will have the ability to delete older forms
manually if desired.
Tasks and Actions:
• Gathering project requirements.
• Worked with teammates to analyze requirements and transform requirements to programming
solutions.
• Applied proven practices in the design and implementation of SharePoint solution that fulfill
client needs and expectations.
• Handling client calls and project status calls.
• Build and design of InfoPath 2013 form.
• Rules and logics implemented in the InfoPath form.
• Creation of multi-level sequential approval SharePoint designer workflow.
• Setup security and permission on portal.
• Creation of SharePoint groups on site collection.
• Creation of custom permission level for user groups
.
Environment: SharePoint Online, Office 2013, InfoPath 2013, SharePoint designer 2013.
Project #3: ESCO Service Catalog
Client: ESCO
Role: SharePoint Specialist
Description: The ESCO Service Catalog has been built on SharePoint 2010 portal. This project was to
redesign the publishing component and web parts creations for pages. The portal has multilevel publishing
pages and menus that needed to be redesigned and recreated.
Tasks and Actions:
• Outlined project requirements and creating business requirement document.
• Handling project status calls.
• Re-design of existing publishing component.
• Build and design of custom Content Query web parts.
• XSLT creation for content query web part.
• Lists creation and creation of InfoPath form.
• Testing and bug fixing.
• UAT support for any issues
• Workflow creation in SharePoint designer 2010
• Setup security and permission on portal by custom level permissions.
Environment: SharePoint 2010, Office 2010, InfoPath 2010, SharePoint designer 2010, .Net 3.5
Sapient Consulting Pvt. Ltd India (June’09 - October’13)
Project #1: Migrated Hiring System from SharePoint 2007 to 2013
Client: Sapient, India
Role: Senior SharePoint Developer
Description: The Recruiting Coordination SharePoint application managed Sapient’s entire interview
scheduling and hiring process. The application was migrated from SharePoint 2007 to SharePoint 2013 to
overcome process flow and data management issues.
Tasks and Actions:
• Outlined project requirements
• Developed technical design and business requirements documentation
• Created prototype of the application for demo before developing the application
• Installed and configured SharePoint 2013 on Windows 2012 server
• Setup production and UAT environments for deployment.
• Created the page layouts
• Configured Excel services and Excel web access web part for creating dashboards.
• Setup and configured User profile.
• Created content types
• Created Content Search Query web part.
• Created timer jobs for updating the various SharePoint lists by fetching data from SQL
database.
• Created tables and stored procedures in SQL database.
• Used CAML Queries for data retrieval from SharePoint Lists
• Created InfoPath 2013 forms.
• Created deployment/cut over document.
• Used SharePoint Object Model for developing the Web Parts.
• Prepared Unit Test Cases and review of various Test Cases (Unit, Integrated & System)
• Tested the application and fixed software bugs
• Mentored junior developers
Environment: SharePoint 2013, Office 2013, InfoPath 2013, SQL Server 2012, Visual Studio 2012, C#,
Windows 2012 server, SharePoint designer 2013, .NET Framework 4.0, CAML Queries builder, Web Parts,
Object Model.
Project #2: Enterprise Collaboration System
Client: NHS Business Services Authority, UK
Role: Senior SharePoint Developer
Description: The client intranet portal was rebuilt using SharePoint 2010 to enable easier collaboration among
employees regardless of their geographical location. The collaboration and content management feature of
SharePoint were used extensively. The portal will functional as a central repository for all business documents
for the client.
Tasks and Actions:
• Developed low-level technical design documentation
• Developed application using SharePoint 2010 object model
• Created Content types.
• Created site columns and lists for the application.
• Created taxonomy fields and managed metadata.
• Created the Master Pages for the Branding the website using SharePoint Designer 2010
• Created master pages and page layouts
• Created Event receivers for lists.
• Created custom list.
• Caching implementation on site collection and on server.
• Build PowerShell script for deployment of features.
• Configuration of out of box search.
• Created features to use out of box approval workflow.
• Worked at client location for bug fixing and UAT
.
Environment: SharePoint 2010, Office 2010, SQL Server 2008, Visual Studio 2010, C#, Windows 2008
server, SharePoint designer 2010, .NET Framework 3.5, CAML Queries builder, Web Parts, Object Model.
Project #3: SharePoint support
Client: Dundee Wealth Management, Canada
Role: Architect MSFT (Microsoft)
Description: Technical support was provided to the client for their SharePoint 2007 and 2010 applications.
Provided the SharePoint governance for their unmanaged SharePoint internal sites.
Tasks and Actions:
• Providing technical consultation to client for any SharePoint issue
• Helped creating SharePoint Governance.
• SharePoint farms troubleshooting.
• Worked as a team lead and managed Retail Audit Project
• Outlined the project requirements
• Analyzed and resolved SharePoint critical issues
• Developed approach and design of assigned tasks/projects.
• Created workflow using SharePoint designer 2007
• Created InfoPath 2007 and 2010 forms for business requirements.
• Used SharePoint Web Services for developing console apps.
• Created SSP configuring Audience targeting, Search and User Profile.
• Provided documentations.
• Created Deployment packages.
• Transitioned the project to new team lead upon completion
Environment: SharePoint 2010,SharePoint 2007,Office 2007, InfoPath 2007/2010, Office 2010, SQL Server
2005/2008, Visual Studio 2005/2010, C#, Windows 2003/2008 server, SharePoint designer 2007/2010, .NET
Framework 2.0 and 3.5, CAML Queries builder.
Project #4 Automated Data Upload using SharePoint and .Net
Client: Citibank (US)
Role: Senior SharePoint Developer
Description: Financial data upload to Oracle database was automated through SharePoint and .net
application. The data was also made available to web parts of SharePoint 2010 through custom development.
Hierarchical permission system to SharePoint sites was set up.
Tasks and Actions:
• Coordinated with client stakeholders to outline the project requirements
• Proposed technical design to system application architect (client)
• Managed application development team
• Created custom list
• Created content types
• Created timer jobs
• Unit testing and bug fixing
Environment: SharePoint 2010, SQL Server 2008, Visual Studio 2010, C#, Windows 2008 server, Oracle,
SharePoint designer 2010, .NET Framework 3.5, CAML Queries builder.
.
Accenture Services Pvt Ltd. India, December 2006 to June2009
Project #1: Idea Box Collaboration Portal
Client: Ericsson
Role: SharePoint Developer
Description: Idea box was a corporate collaboration portal used by the employees and business owners to
share innovative ideas and documents sharing. The portal was developed using MOSS2007.
Tasks and Actions:
• Participated in gathering technical requirements
• Development environment setup which includes SharePoint 2007 installation and configuration
• Involved in giving knowledge transfer to the team
• Given technical approach for Idea Box application
• Developed components which includes web parts, user control, used out off box feature of
MOSS2007
• Involved in unit testing of developed application and fixing issues in UAT
Environment: SharePoint 2007, Office 2007, SQL Server 2005, Visual Studio 2008, C#, Windows 2003
server, SharePoint designer 2007, .NET Framework 2.0.
Project #2: Attrition Reporting System
Client: Accenture
Role: SharePoint Developer
Description: Attrition Reporting System was a web based Application used by human resource of the
company.
Tasks and Actions:
• UI development using VS2005
• Worked on Excel generation using VSTO (Visual Studio for Office)
• Using ADO.Net for Data transactions to talk to SQL Server
• Worked on stored procedure in SQL Server 2005
• Database and tables creation
Environment: SharePoint 2007, Excel 2007, SQL Server 2005, Visual Studio 2005, C#, Windows 2003
server, .NET Framework 2.0.
Project #3: Interactive Portal
Client: Accenture
Role: SharePoint Developer
Description: Interactive portal was an intranet site developed on MOSS2007 which was used by used
employees to upload different types of assets, to update profile, displaying announcements and news.
Tasks and Actions:
• Rich form development using InfoPath
• Workflow development using SharePoint designer
• Custom web parts
• Custom site definitions
• Feature creation
• Unit testing and bug fixing
Environment: SharePoint 2007, InfoPath 2007, SQL Server 2005, Visual Studio 2005, C#, Windows 2003
server, SharePoint designer 2007, .NET Framework 2.0, CAML Queries builder.
Project #3: Web Content Management System
Client: Avanade
Role: SharePoint Developer
Description: The Microsoft Office SharePoint Server 2007 was implemented and customized to manage all
documents & simple workflows. The functionality allowed users to share the documents, schedule a meeting,
participate in the forum and log issues on their day to day application for the support team. The users may also
review and approve the documents.
Tasks and Actions:
• Branding and customization of SharePoint site using SharePoint Designer2007.
• Custom Web parts and custom list, workflow implementation
• Master Pages
• Custom Site definition
Environment: SharePoint 2007, Office 2003, SQL Server 2005, Visual Studio 2005, C#, Windows 2003
server, SharePoint designer 2007, .NET Framework 2.0.
Project #4: Command Center
Client: Avanade
Role: Junior SharePoint Developer
Description: This project was a SharePoint based Information Portal / Reporting Dashboard used for
business process outsourcing users. This project was based on business intelligence and uses KPI, SSRS,
SharePoint.
Tasks and Actions:
• Enhancement of application which includes working knowledge of MOSS2007, custom Web
parts
• Interaction with client to resolve issues related to the application in a timely manner
• Participated in peer code review and conducted knowledge transfer sessions for new
engineers in the project
• Defect fixing and change requests implementations
• Involved into the new asset testing
Environment: SharePoint 2007, SSRS, SSIS, SQL Server 2005, Visual Studio 2005 C#, Windows 2003
server, .NET Framework 2.0.
Education
• M.C.A (Master of Computer Applications), 2006 from Uttar Pradesh Technical University, Lucknow, India.
• BSc. Computer Science (Bachelors), 2002 from Nagpur University, Maharashtra, India
Awards
• Nominated for Rookie of the Year Award 2010 at Sapient
Distinctions:
Commitment and Leadership quality
Due diligence
Active team player
• Contribution Award for organizing various fun events at work at Sapient.
• Associate Software Engineer Super Achiever Award at Accenture.
Distinction: Best Performer of the year and Great team player.
• Celebrating Performance Award at Accenture:
Distinction: Great team player who consistently drives the project.
Distinction: Demonstrates professionalism and confidence in project.
• Yellow Topper Team Award at Accenture
Distinction: Excellence in work.