Mahendra Ghedia

732-***-****

US Citizen ac85gq@r.postjobfree.com https://www.linkedin.com/in/mahendraghedia

SUMMARY

Information Technology lead with more than 15+ years of experience in Business/Technology Architecture and Management in all aspects of Information technology.

A hands-on solution architect experienced in building enterprise class SharePoint solutions in large intranet, extranet & Internet scenarios.

Experienced in planning, designing, customizing & implementing SharePoint Solutions (SPS 2003, MOSS 2007, 2010 & 2013, 2016, SP Online, PowerApps, MSFlow, SPFx) and enabling infrastructure & server technologies (Windows '03/08/12 IIS, SQL '00/05/08/12).

Championed Cloud-First migration strategy and migrated vast number of on-perm applications to Cloud PaaS and implemented enterprise grade solution using O365 SaaS

Extensive knowledge in core networking, virtualization & cloud computing, solution in on-site/off-site hosted and service delivery model implementations. This includes web server farms and Business Continuity.

Innovative in fresh ideas & approaches with a desire to deliver & exceed customer expectations, and to address business problems with sound technical solutions. Highly respected among peers as a quick learner, with exceptional problem solving & analytical aptitude. Innovative thinker who leverages pragmatic, out-of-the-box thinking to improve the effectiveness of technical teams in ever-changing environments and someone who doesn’t hesitate to challenge himself

Offering cost effective solutions since 14 plus years of technical experiences in large corporations.

Senior SharePoint Architect with multi-industry experience across complex, large-scale IT and business programs/projects. Oriented towards successfully leveraging clients’ technical specifications to maximize operational efficiencies and exceed expectations. Led domestic and international full life-cycle development projects with expertise in onshore - offshore delivery model.

Providing best practices on creating Records management and Information Archival solutions that meet corporate compliances (HIPPA, SOX, and FERPA). Large scale content migration from various environments such as Network Shares, existing intranets, creating Document Management solutions to host migrated data.

Providing direction and leadership with strong interpersonal and team building skills

Successfully worked with people within and across organizational boundaries to build agreements, guidelines, and standards in order to resolve issues and create consistent practices. Strong practitioner of clearly written purposeful communication and direction

Developing solutions to deliver quality products to clients through people and processes

Enterprise Solutions Architect and Software Engineer in various areas of IT/Business in Financial Reporting, Risk Management, Regulatory/Fed Reporting, Tax & Treasury Operations, Asset Management, Legal Matter Management and Ops, Investments Portfolio Data Governance, Legal Entity Management, Product implementation, Business Process Management, Change and Release Management, e-commerce product development etc. in multiple technology and financial platforms.

QUALIFICATION HIGHLIGHTS

Information Technology

Project Management

Client Relationships

Team Building

Process Improvements

SharePoint Governance Workshop

Strong Finance domain knowledge

IT Strategy Development

Business Productivity Infrastructure Optimization

Migrations/Upgrades

Operations Management

Change Management

Technical Analysis

Document Management Solutions

System Integration

Best Practice Implementation

Contingency Planning

Records Management Solutions

Microsoft Solution Framework

EDUCATION

Master of Computer Application/Science (MCA)

TECHNICAL PROFICIENCY

Agile and/or Waterfall methodology of managing/tracking project

O365, SP Online, PowerApps, MSFlow, Power BI, One Drive, Graph, SharePoint Framework Webparts - Extensions and Windows Azure

SharePoint Online, SP 2016, 2013, 2010, Server 2007, 2003, Configuration, Migration, Upgrade, Architecture, Taxonomy, Content Management, Collaboration, Windows Workflow Foundation, Reports, BDC - Business Data Catalog/ BCS 2010, Configuring custom Search, InfoPath 2007/2010, Forms Server, Content Types, Features, Excel Services.

Microsoft Office 2007/2010/2013, SharePoint Designer 2007/2010, InfoPath 2007/2010, Project Server, Active Directory and Quest Software SharePoint Tools.

jQuery, React Framework, SPFx and jQuery Plugins

Companies and Work Areas-Domain

AIG -NY, Proskauer -NY, Citi Group - NY, BBDO – NY, Wachovia Bank – NY, Matlen silver NJ, Merrill Lynch - NJ, EZ solutions Inc - NJ, VMF Softech Ltd – India

Work Areas: Finance, Insurance, Legal, Risk, HR, Regulatory/Fed Reporting, Asset Management, Business Process Management, Change and Release Management

ACHIEVEMENTS & SPEAKING ENGAGEMENTS

Recognized consecutive two years by award of best performer employee

Awarded two times Best employee of the Month at Citi Group for Extra ordinary performance

Received appreciation award by Matlen Silver by completing project ahead of deadline

SharePoint Best Practice Conference in Citi Group team, AIG team

Multiple local speaking engagements User Groups, SharePoint Saturdays

EXPERIENCE

AIG, NY May 2015 - Current

Role: Senior Tech Architect, Process Automation Lead

Projects:

Alternative Asset Tracking System (AATS): Supports Chartist CIOs to manage subscriptions to investments. Research information is posted for review and investment selection. Once an investment is selected, the allocation of % of investment is made and tracked by entity. It manages investment allocation process. This application helps AIG Investment group (Chief Investment Officers, Compliance managers and Champions) to effectively track alternate assets

Investment Restriction Database (IRDB): This initiative is to facilitate and streamline the process of capturing and creating a database of investment restrictions applicable to AIG Investments’ (“AIGI”) clients. Investment restrictions for the most part is sourced from investment management agreement (“IMA”), regulatory requirements, and AIGI defined requirements. The AIGI Compliance team is responsible for documenting and monitoring investment restrictions applicable to AIGI clients. The database would help facilitate and streamline this process by creating one central source to view and track updates to all investment restrictions and methods of how each restriction is monitored

New Product New Transaction (NPNT) [Invest]: Establish a centralized systemic workflow / document repository & collaboration solution to manage information requests / responses, collect data / artifacts, track and notify global users across PFIG (Public Fixed Income Group) impacted by this process facilitating preparation of responses on time sensitive basis. These enhancements will redesign approval form which will benefit customer such that he can add/Remove/delete conditions from same approve form itself

Management Responsibilities

Build and maintain a sustainable, profitable and growing practice

Serve as the main Point of Contact for clients

Lead the development of best practices and process maturity for technical and business processes

Provide oversight and governance for all SharePoint and Cloud projects

Identify opportunities for Practice growth

Provide internal thought leadership for Practice operations, governance and team members

Manage technical architecture, quality and deployment of all engagements

Lead and support the personal and professional development of Practice team members through coaching, mentoring junior employees and consoling them on their carrier path

Drive business development through collaboration with the different internal organizations

Problem solve under pressure of deadlines

Establish technical procedures, guidelines, protocols and templates

Create SharePoint solutions roadmaps and architecture diagrams

Provide technical guidance, support and best practice leadership/mentorship to members of an existing team

Make strategic decisions to improve efficiency of managing enterprise environments

Meet practice specific yearly revenue targets

Technical Responsibilities

Involved in identifying, documenting, and refining business and system requirements based on dialogue and interaction with end users.

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire SharePoint portal by implementing it on BRD.

After finalization of these requirements, designs appropriate architecture and developed the SharePoint Online-based solutions, in the Modern UI and Communications sites, that meet the specified business needs as per project plan to ensure solutions are implemented on schedule

Implemented SharePoint Online solutions leveraging React JS, JavaScript, jQuery, HTML, CSS, XSL and XML, HTML, CSS in the creation of custom solutions, including complex workflows or Web parts.

Developed prototypes, POCs, collateral, etc. Analyzes existing technical and business processes as well as current technology solutions, implemented security by creating User Groups and Roles to identify features of current user Created SPFx webpart using React framework to display beautiful analysis, listing and status view.

Used Rest APIs to retrieve information directly from list without writing custom code

Created Approval Workflow to setup approve reject process for investments. also, setup notification system to notify related users using MSFlow.

Implemented business process workflows (SharePoint Online, Nintex, Microsoft Flow) are designed and developed in a manner that provides for further expansion of SharePoint Online-based solutions.

Used PowerApps to implement core functionality and user management.

Implemented HTML display webpart for O365 which can replace content editor webpart in cloud

Developed Security SPFx extension to restrict backdoor access of List/Library or items

Implemented investment allocation display using list Column Formatting

Created Site Pages for analysis display.

Successfully implemented the Security model to the SharePoint sites to meet the business need.

Extensively worked on the configuration Search, Search Schema, Result Source and Search scopes.

Developed configurable Webparts to display all requests for current users and Approve/Reject All in one shot.

Implemented page to search particular request matching with criteria

Developed using Knockout JS, jQuery and jQuery plugins in previous version of this application

Used jQuery Data Tables and other plugin in Webparts for sleek client-side operation

Developed project/action plans and monitors implementation action items to ensure on-time delivery

Environment: SP Online, Visual Studio Code, SPFx, React, MS PowerApps, MSFlow, MS OneDrive, jQuery.

Projects:

Model Administration and Reporting System (MARS): The “Model Administration and Reporting System” (MARS), is AIG’s primary model risk workflow management system and the central repository for the inventory of models. MARS provides support to AIG’s senior management, 1st Line and 2nd Line constituents, and Internal Audit for conducting model risk management in a consistent manner firm wide. With a 1000+ user base, MARS workflow has been matured over the years to suit AIG’s requirements. This project is targeted to update MARS to conform to the significant changes introduced in the Model Risk Management Policy Version 6.0. Specifically, this MARS update takes advantage of the matured workflow embedded within the system and has been designed to minimize the fundamental software changes.

Comprehensive Capital Analysis and Review (CCAR): Comprehensive Capital Analysis and Review [Global Finance] - The CCAR Comprehensive Capital Analysis and Review is a hub for the tasks tracking and governance reporting, Tasks in each business units are tracked using the CCAR application for global finance operations. Application also tracks the status of the task like At risk, deferred, In progress, closed etc. Different reports based on BU and Levels of the tasks are generated for management. Goal - Automation of task approvals, single place to generated the reports and Seamless end user experience

Federal Reserve Regulatory Group (FRRG): FRRG partnered with the Legal Operations Center Process Excellence Team, for a 3-month period in Year to document FRRG’s current state processes and assess the existing FRRG technology toolset. As a result of the assessment, we identified opportunities to streamline and strengthen FRRG’s processes and tools used for administering Meetings and electronic document delivery to Federal Reserve Bank of New York (FRBNY). Implemented meeting and document routing workflow through SharePoint

Consumer FP&A: The Consumer FP&A team require a SharePoint site to manage task lists, collect supporting documentation and responses. Workflow and Reporting features are also required as part of the SharePoint site. The team currently manages a request list of approximately 190 Tasks. The team has to collect data for each of the request items in order to complete several work streams, such as the Quarterly Business Review, Financial Supplement and Earnings Binder on a monthly/quarterly basis. Convert current method of data collection through a centralized email box to SharePoint.

FedExam: The Corporate Federal Regulatory Reporting (FRR) Team requires a SharePoint site to collect information and share responses with the Fed during their examination of AIG which is planned for year 2014/2015/2016. Workflow and Reporting features are also required as part of the SharePoint site. The site will need to be operational prior to commencement of the Fed Exam and before the collection of the first day letter (FDL) request documentation begins.

Responsibilities

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire SharePoint portal by implementing it on BRD and SRS.

Installed-Configured Windows Server 2012, VS2013, SP2013.

created Content Types, Sites, Document Libraries, Lists and List Views to collaborate users and Created List definition, Site definition, Site Columns where required.

Used Visual Studio for branding and customizing SharePoint Server 2013 by modifying Master Pages.

Implemented security by creating User Groups and Roles to identify features of current user

Developed Event handlers on document library and lists to store items Metadata and implemented automated actions required for each stage of multiple workflows.

Used Rest APIs and CSOM (Client-Side Object Model) to retrieve information directly from list without writing custom code

Used Client Object Model, minimized server-side code and maintenance by utilizing SharePoint Rest APIs operations, AJAX, JavaScript, jQuery, Knockout JS in Content editor webparts

Created Approval Workflow to setup approve reject process and other workflows for various operations. Also, setup notification system to notify related users using Visual Studio 2013 and without SharePoint Designer.

Created generalized Email notification mechanism which can be configured as needed from SharePoint list

Created Site Pages for various data display and Application Pages for analysis display.

Created Webpart to display beautiful Promotion analysis in Pie chart and Graphs.

Successfully implemented the Security model to the SharePoint sites to meet the business need.

Mastered on the configuration Search and Search scopes which can retrieve customized search in micro seconds.

Utilized InfoPath in MARS project to implement various risk rules.

Injected client-side code in SharePoint Items to control user actions and satisfy validations.

Created deployment mechanism using PowerShell script

Used Agile methodology using MS TFS and deployment mechanism to track project progress and deployments

Used jQuery Data Tables and other plugin in Webparts for sleek client-side operation

Worked on Business Connectivity Services (BCS) to integrate business data from SQL Server back-end server to SharePoint Server 2013 to display required information

Created One-shot Deployment to deploy portal

Proskauer, NY Mar 2015 – May 2015

Role: Senior SharePoint Specialist

eRoom: EMC eRoom migration to SharePoint involves migration of eRoom databases and documents to SP2013. A custom migration tool developed to migrate documents and files to SharePoint. Another existing eRoom related existing SharePoint site used to store cases and case related documents and processes. Was initially developed in SP2007 and responsible to migrate 200+ sites into SP2013. Also enhanced functionalities and added features after migration to provide best user experience and its ease of work.

Responsibilities

Review and understood eRoom database and architecture and document folder structures

Involved in analysis of existing eRoom sites and its processes.

Installed-Configured VS2013, SP2013.

Calculated site strength and suggested target server farm capacities.

Decided and acted hopping strategy to migrate existing SP sites first from 2007 to 2010 and then to 2013.

Took care of user conversion and CreatedBy, ModifyBy and its dates to keep its history as it is.

Created Sites, Document Libraries, Lists and List Views where needed.

Implemented custom tool using CSOM (Client-Side Object Model) to retrieve information directly from existing eRoom structure to SharePoint Site.

Implemented security by creating proper User Groups and Roles to identify features of current user

Developed Event handlers on document library and lists to store items Metadata.

Used Client Object Model SharePoint to retrieve information client side webpart from List.

Created Site Pages for user friendly home page and other functionalities.

Used PowerShell scripts for SharePoint custom components deployment

Successfully implemented the Security model to the SharePoint sites to meet the business need.

Extensively worked on the configuration Search and Search scopes.

Involved in writing Unit Test cases, Test Plans and Production deployment and its documents

Citi Group, NJ/NY Aug 2008 – Feb 2015

Role: Admin/Designer/Developer

Code Promotion Tool (CPT): is a SharePoint based tool to promote code. It’s a workflow-based tool which tracks each and every code promotion done in DEV, UAT and Production environment through Developers. Collaborates work between Developer, PM/PL, Engineers and DBAs. Developer can create request, Manager approves, DBA and/or Engineers promotes and everything documented in same request with comments. This project used SharePoint 2013 technology

Responsibilities

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire SharePoint portal by implementing it on BRS and SRS.

Installed-Configured Windows Server 2012, VS2013, SP2013 and SharePoint Designer 2013.

Created List definition and Site definition to customize SP2013.

Created Site Columns and Content Types, Sites, Document Libraries, Lists and List Views to collaborate users.

Implemented custom List definition to add comments for each promotion request.

Used Visual Studio for branding and customizing SharePoint Server 2013 by modifying Master Pages.

Implemented security by creating User Groups and Roles to identify features of current user like Developer, PM/PL, Engineers or DBA

Developed Event handlers on document library and lists to store items Metadata.

Used CSOM (Client-Side Object Model) to retrieve information directly from list without writing custom code

Created Approval Workflow to setup approve reject process for code promotion. Also, setup notification system to notify related users using Visual Studio 2013 and without SharePoint Designer.

Used Client Object Model SharePoint AJAX to retrieve information client side webpart from List.

Created Application Pages for analysis display.

Created Webpart to display beautiful Promotion analysis in Pie chart and Graphs for Developer, PM/PL, Engineers and DBAs.

Successfully implemented the Security model to the SharePoint sites to meet the business need.

Extensively worked on the configuration Search and Search scopes.

Developed configurable Webparts to display all requests for current users and Approve/Reject All in one shot.

Created Webpart to monitor special promotions.

Created Webpart to analyze and monitor overall Developer, Engineers and DBA’s performance

Implemented webpart to search particular request matching with criteria

Used jQuery Data Tables and other plugin in Webparts for sleek client-side operation

Worked on Business Connectivity Services (BCS) to integrate business data from SQL Server back-end server to SharePoint Server 2013 to display required information

Created One-shot Deployment to deploy portal

ICG Operation and Technology: is portal of Citi Group, collaborating all financial departments together at one place. It gives flexibility to create/maintain Department sites dynamically for each department to store its shared information. It also gives flexibility to maintain secured and open for all site-subsite structure to fulfill its need. This portal gives flexibility to extend Site-collection and maintain its separate databases. It’s a Hub and Central point of collaboration so its setup as Home page for all Global Banking Group.

Involved in Start to End life of project by Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire SharePoint portal. Installed SP2010, Created Site Collection, Sites, Site Columns, Content types, List, Libraries, Views, Master Pages, Application Pages, Site Navigation to collaborate Cross-Site Collection and Dynamic site creation structure. Developed Event handlers, SharePoint Timer Service, Used Client Object Model SharePoint AJAX, jQuery and JavaScript. Created Generalized XML-XSLT Webpart which can be configured to display any list and Document library to display its items intelligently using Caching mechanism. Implemented the Security model and Configured Search. Developed configurable Webparts to display Document/list item information as per business need. Developed various reports using SharePoint List Connection Type (SSRS). Worked on Business Connectivity Services (BCS) to integrate business data from SQL Server back-end server to SharePoint Server 2010.

Lineage Tool: is tool to visualize information flow between two CSI applications inside Citi. Lineage tool gathers information about Lineage for information between two application and using this tool, user can Search, update and visualize information flow in Visio Chart. This Tool generates Visio diagram using XML such a way that no other Graphical programming generate this much faster diagram.

This position is responsible for implementation and administration of the product and managing to complete requirement without team help. Created Web application using C# and ASP.NET using visual studio 2012. Extensively used JavaScript and jQuery to implement Search interface and client-side validation. Implemented Role and Security structure for better user management. Instead of using VISTO, I have used totally Unique technique to generate Visio diagram using XML. Used Macro to render Visio diagram at client side in Right to Left and other flow. Built templates to get variety of diagram output. Used Data Tables and Dyna Tree jQuery plugins. Used Microsoft SQL Server 2008 to store data by creating Stored procedures for each transaction. Implemented Bootstrap Style sheet to make rich look and feel for the tool. Tested and made bug free by using standard and complex test cases and one-shot deployment.

Who Knows Whom (WKW): is smart client tool to provide Relationship information between Citi Bankers and other outside Individuals or Companies It is graphical representation of relationship network which is used by Citi Group bankers in Windows presentation foundation platform. This application also displays network information using third party (BoardEX) data and Citi Group internal relationship information database. This application is the milestone for the Bankers to contact any Bankers of any other organization/

Involved from start to end of life cycle of this application by designing its architecture to deciding what technology should be used Created Windows application using WPF-WCF technology and MVC model. Extensively used Webservice to get data in XML format. Used WebClient method for asynchronous function call. Implemented rich GUI by creating 2D, List and 3D Views. Rendered Data in 5 category, Direct Relationship, Target, Association, Indirect Relationship and Indirect Contact using interconnected Graphical Thumbs using zone classes. Created information dialog box and message popup using Animations and Storyboarding. Implemented Search, Print, Print Preview, Copy and Screenshot email using exclusive Image processing method.

AutoBuilder: is automated tool to generate/compile Assemblies automatically which builds developer code by getting from Source safe and compiles using .net framework. This tool fulfills internal/external Audit requirement to build assembly from the code which is stored at Source Safe place and not to build manually by Developer to confirm its reliability. This Tool gets latest Developer’s code from TFS at one location and compiles using MSBuild and stores at secure location.

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire application by implementing it on BRS and SRS. Created Web application using C# and ASP.NET using visual studio 2008 to create AutoBuilder request. Used JavaScript and jQuery to implement Drag-Drop and client-side validation. Used TFS classis and objects to retrieve TFS project path. Created Console application using TFS and .NET classis with using MSBuild to get latest code from TFS and compile Developers code at secure place. Used System classes to create Security model so Developer can View only his/her output generated by AutoBuilder and Engineers can view all AutoBuilder output. Created Windows Service to Kick-off Console AutoBuild application. Utilized Visual Studio 2008, C#, ASP.NET, IIS 6.0, XML, XSLT, HTML, SQL Server 2008.

Market & Banking Technology Passport: is portal of Citi Group, collaborating all financial departments together at one place. It gives flexibility to create/maintain Department sites dynamically for each department to store its shared information. It also gives flexibility to maintain secured and open for all site-subsite structure to fulfill its need. This portal gives flexibility to extend Site-collection and maintain its separate databases.

This position was responsible for implementation and ongoing administration of input and organization of evaluation for the product and managing all aspects of its value with Team management as Team advisor. Involved from scratch by Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire SharePoint portal by implementing it on BRS and SRS. Installation of SharePoint 2007 and its components, decided site and portal structure including List definition and Site definition to customize SharePoint Portal 2007 for Dynamic site creation structure. Created User controls for Top-Navigation and Left-Navigation to collaborate Cross-Site Collection navigation management. Developed Event handlers on document library and lists to store items Metadata. Successfully implemented the Security model to the SharePoint sites to meet the business need. Created the hierarchy of site structure to secure the sites. Mastered by configuring MOSS Shared service Provider (SSP) for managing the search scopes and making the managed properties. Developed XSLT Webpart which displays Sitemap gathering all sites and subsite’s active links. Developed configurable Webparts to display Document/list item information as per business need. Developed highly configurable Custom Report viewer webpart with controlling report parameters that Sends Report result as Attachment through Email. Implemented reports using SQL Server Reporting Service which displays report sourcing SharePoint list data also used third party Dundas Chart control for better chart presentation for reports. Implemented SharePoint List Connection extension DLL which is used to pull data from SharePoint list to Reporting service Data Connection. Also worked on BDC.

BBDO, NY Jun 08 – July 08

Role: Senior SharePoint Developer/Admin

Café BAC: is portal of BAC Agency Partners and BAC Marketing Associates collaborating in the sharing of content for marketing programs and projects effective for Bank of America. This is a collaborative tool which gathers all Marketing programs and projects information and shares in such a manner that its associates can use all information anytime anywhere to take decision. Also participated defining and designing Omni Access portal and its development.

Involved in Start to End application implementation by Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire portal by implementing it on BRS and SRS. Installed SharePoint Server 2007, Windows SharePoint Services 3.0 and SP Designer 2007. Worked on List definition and Site definition to customize SharePoint Portal 2007. Created Site Columns and Content Types to resume schema of columns in different lists of web application. Extended BAC Portal to use Café BAC application through Internet. Used Form authentication for external and internal users to login Application. Created Sites, Document Libraries, Lists and List Views, custom configurable, Master pages, Application Pages, SharePoint Custom Workflow, Event handlers.

Contact this candidate