Mahendra Ghedia
US Citizen ********.******@*****.*** 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.