VINOD MAHAJAN

• 16+ Experience in Pre-Sale/Development /Migration of Azure/SharePoint/Power Platform applications.
• 3+ Experience solutioning mid to large scale modernation deal for M365/Azure as Pre-Sales Solution architect.
• Good Understanding of Project Estimations Technique, Staffing Planning, Costing and Budgeting.
• Strong Pre-Sales, Project Management, Team Building, Project Implementation, Analytical, Interpersonal & Communication Skills with proven ability to produce the highest quality results working under extremely tight deadlines.
• Having good experience delivering projects in agile methodologies.
• Strong experience in Analysis, Development, and Maintenance of web-based solutions, extensive experience in ASP.NET 2.0/3.5, C#, MVC, SharePoint 2010/2013/Online, Power Platform, React, Azure.
• Good Experience in various Power Platform components like power apps, power automate, power virtual agent, power pages. Hand-on experience in Azure services like Azure Functions, Logic Apps, DevOps, Azure AD(Intra), API Management etc.
• Got good knowledge of Azure & M365 security features through certifications.
• Expert in SharePoint custom development of Web Parts, Event Receivers, Event Handlers, Master Pages, templates, and features. C# Client object model, JavaScript Client Object model, Rest Services, Search Services. Configuration of search center. Development of designer workflows. Performed SharePoint migration using tool base and lift and shift approach. Hands-on experience in .Net MVC, Angular JS, REACT, JQuery, Bootstrap, JavaScript AJAX, WCF Web Services. Developed WEB API TOKEN BASE Authentication (using OWIN) project. Very good understanding of OOP (Object Oriented Programming).
• Having good knowledge of third-party tools like Nintex Form, Nintex Workflow, Jira, Share gate, SVN, Git, Quest Web Parts Good Experience in Capital Market, Life Science domain Good knowledge of Azure AI services like Cognative service & Azure Applied AI service. Generative AI , Azure AI Studio, & Copilot.

• Power Platform fundamental, PL 900
• Microsoft M365 Fundamentals, MS 900
• Microsoft Security, Compliance, and Identity Fundamentals, SC 900
• Microsoft Azure fundamental, AZ 900
• Core solution of Microsoft SharePoint 2013, 070-331
• Scrum Fundamentals Certified, SFC

# Project   Name: Solution   Architect 

Start   Date: Sep 2022  End   Date: Till date

Description

As   a Solution Architect, I have been responsible for providing technical and   business solutions to clients to meet their specific needs. Some of my key   work experiences are:

● Worked with Client/ Sales teams to understand   requirements for Sole Source / RFP deals. Participate in client workshops to   understand problem statements and client approach toward the project.

● Create Solution for mid to large M365/Azure transformational   deals and get it review with leadership to submit response to ask.

● Collaborated with internal teams in order to develop the   best solutions for clients, work closely with internal teams such as   development, product management, and support to ensure that we could deliver   on our proposals. This involved coordinating with these teams to provide   technical guidance and support, as well as collaborating on product   development and implementation.

Overall,   my experience as a Solution Architect has given me a deep understanding of   customer needs and the ability to develop and present technical solutions   that meet those needs. I have also developed strong collaboration skills,   working closely with sales teams and internal teams to ensure successful   client engagements.

Role   & Contribution

● Creation   of solution plan/Proposal.

● Creating   staffing plan, and budgeting.

● Stakeholder   Management & Negotiation

● Research   new technology, contribute to creating assets, and use the same in solution   as solution differentiator.

Tools   / Technologies

Power   Platform, SharePoint, Azure, Azure AI Services

# Project   Name: Work as SME for COE

Start   Date: Jan 2020  End   Date: Sep 2022

Description

As part of   COE, factory was set up for big pharmaceutical company base in Europe.

As a   Subject Matter Expert, I have been responsible for providing deep expertise   in a Power Platform, SPFX, Azure to support various projects and initiatives.   Some of my key work experiences as an SME are:

Perform   migration of 136 services from SP 2010 to the power platform.

Provided technical guidance and   support

Conduct training and knowledge   sharing sessions

Create architecture and technical   documents

Role   & Contribution

● Design   document.

● Manage   client calls to clarify requirement and create architecture.

● Develop   POC and help team to resolve technical issues, perform code review etc.

Tools   / Technologies

Power   Platform, Spfx, Azure

#17 Project   Name: CQC Country Operation

Fair Market Value (clinical users)

CQC Country Operation (phase 2)

Noogle/NTO

Start   Date: Jan 2019  End   Date: Dec 2019

Description

FMV  application developed for finance department to set caps for expense reports   file by associates, application allow admin to set caps at country and   department level, also admin can define caps for travel and preparation time.   User can use calculator to enter expense of service time, preparation time   and travel time base on country, division calculator show allowed figures and   generates PDF. Workflows are set to intimate any rate change by admin or   country moderator.

NTO –  React SpFx application for pharma organization’s entity to perform quality   risk assessment (QRA) on purchased excipients and packaging material as per   regulations.

Noogle – MVC application to query on different   heterogeneous data source like oracle, sql, SharePoint etc. Tools are developed to facilitate clinical   trial process of different geographical data, and facility approval process   from different geography.

CQC - Application   is developed using React and 0365 SharePoint as backend to review and process   clinical cases. This system required data from oracle system and keep track   of processed and non process cases.

Remote Event receiver is developed and   hosted on azure to connect to oracle and fetch data from hourly and weekly   batch. This will also check SharePoint system for final cases for archival   and send reminders for assign cases.

Phase 2 of   CQC is to get another set of data map with existing function and store in   SharePoint.

Role   & Contribution

● Create   Functional requirement, Design document.

● Help   to create test cases.

● Lead   team, track deliverables and provide WSR to stockholders.

● Manage   client calls.

● Develop   Remote event receiver.

● Create   POC, help team to resolve issues and code review.

Tools   / Technologies

C#, React, SpFx, Entity framework, SharePoint   Online, Client Object Module, Azure, VSTS , Angular, PowerApps

# 16 Project   Name: Vendor portal

KPMG Portal

FMV (Accounts)

Start   Date: Oct 2017  End   Date: Dec 2018

Description

MVC base application uses entity framework   and angular for UI. Aim of application was to capture bid from vendor and   route it internally for approval. Vendor can see various opportunities and   bid to supply items. Vendor has to register on portal and login to bid, once   process start, he can see all status and communications on portal.

KPMG portal was developed to upload KPMG   data from KPMG environment to SharePoint system. Token base (using OWIN) MVC   website developed and hosted on DMZ environment. KPMG has to upload excel   file in system and fill in some information along with to upload data, system   them perform some checks and massage data before pushing to SQL, SharePoint   to sql connection was build using external content type inside SharePoint.

FMV tool is design to replace manual   process of finding fair market value of projects.

This tool   helps users to find fair value by minimum data entry, there are multiple   lookup screens for minimizing data entry. Approval process is automated by   nintex workflow and flow.

Role   & Contribution

● Create   Functional requirement, Design document.

● Help   to create test cases.

● Lead   team, track deliverables and provide WSR to stackholders.

● Manage   client calls.

● Develop   and perform POC for critical modules.

Technologies

C#, MVC, Angular Js, Entity framework, SharePoint   2013 online, PowerApps, Nintex Workflow, Azure, VSTS

# 15 Project   Name: WB campaigns management

Bulk File   transfer module

Start   Date: June 2016 End   Date: Oct 2017

Description

1.  SharePoint hosted app is developed to manage   WB’s campaigns, influencers and agencies. Nintex workflow and nintex forms   are used for custom development.

2. Bulk file transfer module was developed   to transfer big excel file from one server to other, before transfer file has   to go through number of checks and few fields need to be derived and save   back in file as extra excel columns.

Role   & Contribution

● Development   of UI in Nintex form.

● Development   of functionalities using JSOM.

● Development of workflow using nintex   workflows.

● C# module file transfer

Technologies

SharePoint 2013 online, Hosted app , C# .Net,   Angular Js

# 14 Project   Name: Solaire   mobile app / BSS Mobile App

Start   Date: Jan 2016  End   Date: June 2016

Description

Solaire   mobile app is native android and iOS app for Solaire’s online reservation   system, as a part of solution there are events management system build on   SharePoint and Web APIs are exposed to mediator service for mobile, custom DB   is created to specific purpose and used in WebApi using entity framework for   CRUD operation.

BSS Mobile app is mobile solution for share service   of client, as part of solution we have developed intranet site for content   management in SharePoint 2013 on prem and exposed SharePoint web api to   mediator service.

Role   & Contribution

● Documenting   requirement (creation SRS, TDD).

● DB   creation and Web API development.

● Development   of event receivers for DB updated though Web Api and SFTP image upload.

● Development   of reports using JQuery DataTable.

Technologies

WebApi (MVC), SharePoint 2013 onPrem

# 12 Project   Name

JCI – SSNA, UDAT, High-Risk, Hitachi, EI- Support

Start   Date: June 2014 End   Date: Dec 2015

Description

As a part of Jonson controls India’s internal   systems there are number of modules which are developed by IEC (India team)   on office 365 environment.

UDAT & SSNA – Knowledgebase, high risk modules   are comprising of complex data entry screens and some statistical reports. As   environment for project is SharePoint   online, there is extensive use of JavaScript CSOM and rest services,   bootstrap & various third party components like jQuery data tables.

Role   & Contribution

● Documenting   requirement (creation SRS, TDD).

● Coordinate   with client for getting requirement.

● Development   and unite testing of complex modules.

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

SharePoint 2013 online

# 10 Project   Name: World Vision – WV Central

Start   Date: Jan 2014  End   Date:June 2014

Description

Intranet   application for world vision NGO, WVCentral is main publishing site where   content from all other sites/sub sites are published. Social collaboration   and publishing features are used extensively, Java script CSOM is used for   faster response.

Custom components are created to fetch   data from across site collections. Cross site publishing feature is use for   publishing content on WVCentral.

Role   & Contribution

● Coordinate   with client for getting requirement.

● Development   and unite testing

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

SharePoint 2013

# 9 Project   Name: KLA-Tencor – HR Online

Start   Date: Sep 2013  End   Date: Dec 2013

Description

HR online is   collaboration portal for HR team of KLA-Tencor for publishing content and   documents, KLA wanted to use SharePoint 2013 collaboration and search   features extensively.

Leverage   many SharePoint 2013 OOTB features, used JavaScript CSOM and rest apis for   faster response. Customized page layouts to meet branding requirement.   Publishing features are used content authoring.

Role   & Contribution

● Coordinate   with client for getting requirement.

● Development   and unite testing

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

SharePoint 2013, API

# 8 Project   Name: 2007 to 2013 Migration

Start   Date: June 2013  End   Date: Sep 2013

Description

Ask was to migrate CRS, mutual fund applications   from 2007 to 2013. In existing application Store procedures and views were   created to build SSRS reports.

This   migration activity involves optimization of views and store procedure along   with SharePoint up gradation.

Performed lift and shift approach for migration.

Role   & Contribution

● Coordinate   with client for getting requirement.

● Estimate   efforts and provide timelines.

● Creating   queries, Store procedures, views, SSRS reports.

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

SQL 2008, SharePoint 2013

# 7 Project   Name: Payment   Advice & Balance confirmation

Start   Date:   April 2013  End   Date: June 2013

Description

This SharePoint application was design to automate   generation, approval / Rejection, printing and Emailing Payment advices and   Balance confirmation of client. Schedule (C# .NET Application) is developed   to generate advice documents.

Data for generating reports were stored in oracle   DB, data is fetched from oracle to SQL using link server.

Role   & Contribution

● Coordinate   with client for getting requirement.

● Estimate   efforts and provide timelines.

● Creating   queries, Store procedures, views , SSRS reports.

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

SQL 2008, SharePoint 2010, C#

# 6 Project   Name: Portfolio   management system

Start   Date:   Sep 2012  End   Date: April 2013

Description

This SharePoint portal was developed for L&T   Infra Finance (NBFI) to track their entire loan sanctioning and reporting   process. This application captures all client info, sanction info,   non-sanctions / cancellations, disbarments, repayments, loan assignments etc.   Reporting module built on SSRS shows data with different dimensions which   help them tracking business and decision making.

Data was hosted outside the SharePoint content DB,   Data modeling was done considering SharePoint features.

Role   & Contribution

● Coordinate   with client for getting requirement.

● Estimate   efforts and provide timelines.

● Creating   queries, Store procedures, views , SSRS reports

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

SQL 2008, SharePoint 2010, C#, WCF, External List,   BCS

# 5 Project   Name: Motilaloswal.com

Start   Date: Jun 2012  End   Date: Sep 2012

Description

MotilalOswal.com is corporate website of Motilal   Oswal stock broker. This website was created in ASP .NET with option to   change content dynamically using rights based CMS module. One can create   complete dynamic webpage with pre define template through admin login.

Role   & Contribution

● Coordinate   with client for getting requirement.

● Estimate   efforts and provide timelines.

● Creating   queries, Store procedures, and views.

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

ASP .NET 3.5, JQuery, SQL 2005, WCF API

Key   Achievements

Complete dynamic webpage creation with pre define   template is provided through custom admin login. One can create columns using   9 data types provided to generate tabular reports. DB structure is created to   hold dynamic data.

# 4 Project   Name: Aditya   Birla Money Universe

Start   Date: Jan 2011  End   Date: May 2012

Description

Aditya Birla Money Universe is a personal finance   management portal that helps peoples to take control of their finances. One   can link his/her accounts to see consolidated reports, analyse, compare   his/her actual portfolio with recommended by portal. Various tools available   on portal to help user to set goals and to make best investment decisions.   Alerts and recommendation make them aware of activities/goals/budgets.

Role   & Contribution

● Coordinate   with client for getting requirement.

● Estimate   efforts and provide timelines.

● Creating   queries, Store procedures, views, SSRS reports.

● Leading   team of developers, assign work and track all deliverables up to closure.

Technologies

SharePoint 2010, JQuery, WCF Api, SQL 2005.

# 3 Project   Name: C-MOTS   Tracker

Start   Date: Jun   2010  End Date: Dec   2010

Description

✔ CMOTS   Tracker is basically work flow system. It covers four main areas, Project   Management System (PTS), Defect Tracking System, Leave management system,   Time Tracking system.

✔ PTS   is project work flow and documentation system (useful for ISO). It take cares   of project registration, planning, assignment, Progress tracking, work   progress analysis etc.

✔ Defect   Tracking is QA Work Flow System, Team member assigned in PTS for particular   project directly gets project listed in Defect Tracking section of portal   when project is mark as ‘Testing phase’ through admin section.

✔ Leave   management has two phases leave application and leave sanction. System   generates alert wherever rules needs to apply. Pictorial representation helps   users to understand status of sanction/pending/granted leaves.

✔ In   time tracking system each employee has to fill his daily assign work with   start and end time, expected time is filled by leader and based on that   various performance reports are generate by system.

Role   & Contribution

● Coordinate   with various departments for getting requirement.

● Estimate   efforts.

● Assign   work to team.

● Writing   code in ASP .Net

● Creating   Queries in SQL

Technologies

ASP .NET   3.5, SQL 2000, AJAX

Key   Achievements

Portal is   conceptualize and developed by me with full SDLC and security standards.

# 2 Project   Name: Quadratic

Start   Date: Nov   2009  End   Date: Jun   2010

Description 

This   is intranet/internet portal, this tool keeps track of daily activity of the   firm i.e. transaction tracking, bills generation, Brokerage summary, Ledger   balances, IPS Capturing, Financial Plan for investor, Liquidity analysis.

This   is end to end solutions to client’s requirement that helps them to perform   day to day activity and also their clients can access information intended to   feed for them. Clients can login through separate interface provided to check   their transactions and holding of various asset classes (Equity, Mutual Fund,   Derivatives, and Insurance) and other portfolio reports.

Role   & Contribution

● Coordinate with client for   getting requirement.

● Estimate efforts.

● Assign work to team.

● Writing code in ASP .Net.

● Writing Queries/Store   procedures in SQL.

Technologies

ASP .NET 3.5, SQL 2000.

# 1 Project   Name

Website/Portfolio Development

Start   Date: Sep   2006  End   Date: Nov   2009

 Description

✔ PrimeGold (http://primegold.cmlinks.com/portfolio/login.asp)

✔ PincMoney (https://www.pincmoney.com/login.aspx)

✔ Sushil Finance   (http://www.sushilfinance.com/Client/ClientLogin.aspx)

✔ PincMoney (http://www.pincmoney.com -   ASP.NET 2.0 )

✔ Sushil Finance (http://www.sushilfinance.com - ASP.NET 2.0 )

✔ Idbipaisabuilder (http://idbipaisabuilder.in -   ASP.NET 2.0 )

✔ Premiumglobal (http://premiumglobal.in - ASP.NET   2.0)

✔ Commodityinsights (http://www.commodityinsights.com  - ASP.NET 2.0)

✔ Somayajulu (http://somayajulu.cmlinks.co.in  - ASP.NET 2.0)

Note:   Some link may not work due to revamp/change in domain name

⮚ Prime Gold is mutual fund   portfolio, here family wise hierarchy is maintain so that any one from family   can see their family’s portfolio.

⮚ Facility is provided to upload   trade file from cams, karvy, Franklin which is then processed to create   hierarchy and map the schemes from various vendors to assign unique scheme   id.

⮚ Reports like folio wise   holding, consolidated holding, transaction summary, absolute and annualize   returns,CAGR are then available to Admin(Prime gold) as well as investors.

⮚ Sushil and Pincmoney both are   multi asset portfolio, one can maintain his all transactions detail for   equity, mutual fund, commodity, insurance, borrowing, derivatives, property,   fixed assets etc.

⮚ various reports like Portfolio summary, unrealized / realized   gain and loss, annualized return, stock industry Classification, fund   industry classification, fundamentals of stocks, profit booked are provided   to investors.

⮚ Also one can create his watch   list, compare stock with index, and track the funds, Performance high and low   value of fund for various periods.

⮚ Capital market online trading   solutions (CMOTS) is known name among financial data providers, company   provides Live and historical data of Equity, Mutual Fund, Derivatives,   Commodity, Insurance and IPO.

⮚ List of above website shows   predefine analytical repots of various segments (Equity, Mutual Fund,   Derivatives etc. ) and also dynamic content uploaded through admin interface   provide by cmots.

Role   & Contribution

● Coordinate with client for   getting requirement.

● Writing code in ASP .Net.

● Writing Queries in SQL.

Technologies

ASP .NET 2.0, SQL 2000, WCF.

• Date of Birth: 04/09/84