Ananda Sanyal

ANANDA SANYAL Mobile: - Home/ Office: - ~ E-Mail:- ~ Team:-~ Skype:- Senior Level Professional – SharePoint, O365 Application Design / Development / Project Management SUMMARY Over 18 years of experience in Application Development using Microsoft SharePoint and .Net Technologies. Over 4 years of experience in O365 Power Platform, PowerApps, Power Automate, Power BI Knowledge of Project Management and Transition and Transformations. Experience in end-to-end SharePoint, O365 implementation, migration. Experience of SharePoint migration from Lotus Notes and older versions. Domain expertise includes Banking, Mortgage Banking, Pharmaceutical, Travel and Transportation industry Knowledge of managing the entire software development operations involving requirement gathering, development of functional specifications, design & development, and co-ordination with customer Overseas exposure with global clients across Qatar (Dec’17 – Fan’18), Australia (Jul’12 – Mar’14), France (May’11 – Jun’11), Norway (Mar’10 – May’10), Canada (Nov’07 – Sep’08), UK (Apr’03 – Jun’03), Germany (Dec’00 – Jun’01). Adept in developing, creating and modifying applications software, analyzing the user needs and developing software solutions An effective leader with proven abilities in leading teams during the project phase, training & guiding team members and enabling knowledge sharing among the team Possess strong analytical skills & ability to lead new initiatives and take ownership of the work AREA OF EXPERTISE SharePoint 2016, Online, O365, 2013, 2010, 2007, Azure Design and Development of SharePoint App/ Add-in, Remote Event Receiver, Custom Web Parts using C#, JQuery, Angular, React, JavaScript, REST API. SharePoint O365 Modern Sites Design and Development. Power Apps, Power BI, Power Automate, Forms Design and Development of Hybrid Solution in SharePoint Design and Development of custom Workflows using Microsoft Flow, SharePoint Designer, K2. Design and Development of SSRS Reports Search configuration Custom Layouts, theme, Branding. Record Center Implementation SharePoint, O365 Migration Configuration of Google Analytics Configuration of O356, Azure, Skype for Business Installation and Configuration of SharePoint server 2016, 2013,2010 and MS SQL Configuration of Active Directory Integration, SMTP Service and Out-of-the-Box Features PowerShell Scripts ACADEMIC QUALIFICATIONS Bachelor of Science in Management Information System, - 2012, The City University of New York, Flushing, NY 11367. Post Graduate Diploma in Business Administration – 1998, Institute of Modern Management, Kolkata Bachelor of Commerce from Calcutta University, India in 1995 IT SKILLS Portal / Content Management:SharePoint Online, O365, 2016, 2013, 2010, 2007 and 2003 O365 Power Platforms:PowerApps, PowerBI, Power Automate, Forms Languages/ Technologies:.Net 4.5/4.0/3.5 / 2.0 / 1.1, ASP.Net, Azure, C#, JavaScript, JQuery, InfoPath, Angular, React Workflow:Microsoft Flow, K2, SharePoint Designer, Visual Studio RDBMS:MS-SQL Server, Oracle Reports:Microsoft SQL Server Reporting Service (SSRS) , Crystal Reports Project Management Tool:Microsoft Projects, JIRA, Rational Rose, RPM Awards and Achievements: IBM Manager’s Choice Award in 2014 for outstanding contribution in CAPS Project IBM GBS GD Eminence and Excellence Recognition Award in 2013 from Westpac WFI account IBM Bravo Award from IBM Canada for his dedication towards client success from CP Rail Account Team in 2008 IBM Bravo Award from IBM India for his dedication towards client success form Johnson and Johnson PRD in 2006 IBM Intellectual Capital Recognition in 2007 for converting off the self-product to custom application as per business need Work Experience SPO365.tech, Self Employed / Freelancer SharePoint Consultant, from Oct 2016 till date IBM India Ltd. Advisory System Consultant, SharePoint, August 2005 till July 2016 Debono India Ltd., Kolkata, India Senior Software Consultant from Mar’05 – Aug’05 Inuva, Kolkata, India Team Lead from Jan’04 – Feb’05 Illusion Online, Mumbai, India Team Lead from Feb’02 – Dec’03 Xenon Deutschland GMBH, Germany / Kolkata Technical Consultant from Dec’00 – Jan’02 Signotron India Pvt. Ltd. Web Master from May’00 – Nov’00 Earthbase India Pvt. Ltd. Web Developer from Apr’98 – Apr’Ͳ0 Recent Projects: Title:PowerApps Project Management Dashboard for Sentes-BIR. Turkey based manufacturing company. Role:PowerApps, SharePoint, O365 Consultant (Cont.) Skills Involved:PowerApps, SharePoint Online, Power Automate Description:It is a Project Management Dashboard build on PowerApps (canvas app), for managing Projects and corresponding activities, tasks. Projects information’s are captured and displayed with indicators. Galleries, Collections, Custom Tabs, SharePoint Forms are the core components SharePoint Lists are used as data repository, Flows are used for notifications. Title:Job Sheet App (PowerApps), Ceh Group Singapore Role:SharePoint, O365 Consultant (Cont.) Skills Involved:PowerApps, SharePoint Online, Power Automate Description:It’s a PowerApps (canvas), developed for service engineers to capture Job (Visit) information inside client site in Offline/ Online mode and generate Job Sheet PDFs. It stores data in local device (when Offline), On network availability, post data in SharePoint, A scheduled flow runs, Generates Job Sheet. PDF’s and mail those to the Customers as attachments. Title:O365 Modern Workspace, Serneholt Estate, Spain Role:SharePoint, O365 Consultant (Cont.) Skills Involved:SharePoint Online, Power Automate, PowerApps, Power BI Description:It’s O365 intranet portal, collaboration, operation platform for the teams like Sales, Marketing, IT Helpdesk, HR, Admin. There are few data integration with other systems, which are handled using Power Automate. Power BI reports are used for reporting sales data. All Lists Forms are replaced with PowerApps. Title:Psychometric test, Emami Agro Tech Ltd. Role:SharePoint Consultant (Cont.) Skills Involved:MS Forms, MS Flows, PowerApps, SharePoint Online Description:It’s part of Emami recruitment process, External users fill up the form, the answers for each candidate are stored in SharePoint. The solution is build using MS Forms, survey template, Flow is been used to capture data into SharePoint List. HR evaluates the data in PowerApps (Display form) is SharePoint. Title:Synbiotrix SharePoint Migration, UK Role:SharePoint Consultant (Cont.) Skills Involved:SharePoint 2010, SharePoint Online Description:It’s a SharePoint 2010 to Online (modern site) migration, which content 5 GB of data, nearly 100 users (external, internal), Wiki pages, Calendars, Lists, Libraries and Sub Sites. Used tools to migrate the data and adjusted the new modern site afterwards. Title:Gate Pass Application (PowerApps) for Maxop, Melbourne, Australia Role:SharePoint Consultant (Cont.) Skills Involved:PowerApps, MS Flow, SharePoint Online Description:This App is visitor management system, developed using Power-Apps, Mobile Layout, MS-Flows, to issue, manage gate passes. User key-in the details, capture his selfies and signature, The Information get stored in SharePoint Online List, Mail gets trigger to the visitor with Gate-pass ID. Using that he collects the visitor badge. The App.got 6 screens, MS-Flow is been used to store image, signature as list attachments which is hosted in Modern SharePoint Site. Title:SharePoint Online Site Provisioning for ESSPL Ltd. Plessey UK. Role:SharePoint Consultant (Cont.) Skills Involved:SharePoint Online, JSOM, CSOM Description:In absence of Save as Template feature in SharePoint Modern sites, Client is looking for an option of site template. I have developed a solution using Site Scripts using JSOM and publish that in template gallery. As further requirement developed a windows console program using CSOM, PnP to create site with data. Title:SharePoint 2013 Server maintenance for ESSPL Ltd. Plessey UK. This is an ongoing task to monitor and perform health check of SharePoint servers, Purge data from Nintex Workflow History List. Title:SharePoint Online Migration Tool Role:SharePoint Consultant (Cont.) Skills Involved:SharePoint Online, CSOM Description:Primary objective of this tool is to move Sites and Content from one environment to other. It’s a windows application, developed using CSOM, PnP. User has to logon in both the tenants (Source and Target) and then migrate the contents. Title:SAP Document Management Repository for Emami Agro Tech Ltd. Role:Independent SharePoint Consultant Skills Involved:SharePoint Online Description:This Document Management System is developed in SharePoint Online. It got 7 processes and few sub processes for each. The navigation is been developed using custom .CSS, Managed (Termset) Navigation, MS Flows, Custom Search are used in the system. It will also have a responsive website, which is under development. Modern Experience, Hub site will be used. Title:Migration of Oxford College of Arts, Business and Technology Intranet SharePoint Portal, Ontario, Canada Role:Independent SharePoint Consultant Skills Involved:SharePoint 2013, SharePoint Admin, Description:This is a migration project from SharePoint 2007 to 2013. It consists of Root Site and 10 Subsites [appox. 5 GB data], Finance, Student Finance, Marketing, Admission, IT, Career Services, HR, Academics, Instructor Portal. Identify SharePoint Components Lists, Libraries, Announcements, Contacts, Events, Master pages. Moved the data using custom C# program, Once the data migrated adjust the master pages, theme. Title:QAPCO Temporary Plant Shutdown Bulletin was developed in SharePoint 2013 for Qatar's largest Oil and Gas Company, Doha Skills Involved:SharePoint 2013, SharePoint Admin, C#, ADOBE.sdk, and Spire PDF component. Description:Primary objective is to capture the Temporary Plant Shutdown information, represent graphically in SharePoint and then share it in .PDF format thru email to all Qapco employees. Components used in this project are Custom Lists Chart View Webpart, JQuery. Windows Scheduler was developed to generate.PDF from SharePoint site and send email as attachment using C#, ADOBE .SDK, Spire PDF. Title:Migration - SharePoint 2003 to SharePoint Online for a manufacturing company from Sydney, Australia. Role:Independent SharePoint Consultant Skills Involved:SharePoint Online, 2003, SharePoint Admin, and Azure. Description:This was a migration of 6 Sub sites and the Root site for CathRx SharePoint Online, Identify SharePoint Components - Sub Sites, Lists, and Document Libraries. As the data volume was low [less than 5 GB], identified a free tool [Docukit], and started with the Sub Sites. .Net Framework 4.6, is required and as SharePoint 2003 doesn’t support this, we had to execute the same from a different box. Select the source [subsite], Create the destination [in SharePoint Online sub sites], Select the Lists, Libraries, and Views. [Exclude master pages].Validated the migration options, for example Full, Partial, Incremental, Save Migration job, and Run. Once done validate the results from the log. Perform the same steps for the root site, Once done organize the Home page, adding new web parts. Title:Issue Tracker in SharePoint Online, Microsoft Flow for a client based in UK Role:Independent SharePoint Consultant Skills Involved:SharePoint Online, Microsoft Flow, and JQuery. Description:Issue Tracker application has developed to capture and track issues. User adds an issue with priority, the mail triggers to help desk, then it get assigned to some users and SLA time starts based on the response times and change of issue status. The SLA calculation has been done with few calculated fields and flows. It got a dashboard, where the issues are displayed by SLA Met [Yes/No] with highlighted colors, by Priority [Urgency 1, 2, 3] with color demarcation. All these are done using JQuery. Title:Leave Management application in SharePoint 2016, Microsoft Flow, Power Apps [Hybrid model], for an US based client Role:Independent SharePoint Consultant Skills Involved:SharePoint 2016, Online, Microsoft Flow, Power Apps. Description:Leave Management application has developed to capture, track employee leaves and once it’s requested it goes through some approval process [Departments, Managers]. The application is hosted in SharePoint 2016 using Lists, Calendar, Chart.Js. Microsoft Flow, Power Apps. Install SharePoint 2016.Configure On-Premises Data gateway to connect Microsoft Flow, O365. Deploy the applications using Custom Lists, Workflow, Power Apps, Chart.js Title:Installation and configuration of SharePoint 2013 for an US based service provider. Role:Independent SharePoint Consultant Skills Involved:SharePoint 2013 Description:Installation and configuration of SharePoint 2013, which includes SAML-based authentication [ADFS], Search Configurations. To implement SAML I’ve done the followings - Create a realm for employee access, Add trusted certificates, Create the trusted providers, Associate them to a web application. Title:Provider Hosted App and Utility program to upload Emails + Attachments into SharePoint Online for an US client Role:Independent SharePoint Consultant Skills Involved:ASP.Net MVC 5, CSOM, C#, SharePoint Online, MS Azure. Description:The objective is to map SharePoint document library with Email Id [mail box feature], which is not available in the current SharePoint versions [SPO, 2016]. A custom utility program developed to achieve this. The program got 2 components, First - a SharePoint provider hosted app developed in ASP.Net MVC, deployed in MS Azure for mapping emails and document libraries. Second - A Windows service developed in CSOM to migrate the emails and attachments from network drive to SharePoint Online mapped document libraries. Title:Transformation of service of On-Premise SharePoint infrastructure towards Microsoft Cloud solutions, for a client from Belgium Role:Independent SharePoint Consultant Skills Involved:Consulting, SharePoint Online, Cloud, Service Delivery Management. DescriptionThe road map of transformation of service of On Premise SharePoint infrastructure towards Microsoft Cloud solutions SharePoint Online for a service provider managing the on premise infrastructure and will need to provide a new service in a hybrid infrastructure with a cloud partner and need to redesign the service. Deliverables: *Identify the steps that were executed during the process, risks. *Identify the impacts on the existing business. *Identify the service delivery management parameters. *Create a Plan to execute the steps in Service Delivery Management perspective. Title:POC on a project, where the goal is to determine to get emails from the exchange server and insert them into SharePoint online, for a client from Denmark Role:Independent SharePoint Consultant Platform:SharePoint Online, Azure App Service DescriptionThe steps contained - Azure Portal *Choose “Developer Services, *Add a Logic App *Add a SharePoint Online Connector *Add an Office365 Connector *Design the Logic App *Setup Triggers and Actions Title:SharePoint Online Project Management with Time Sheet application for a Norwegian Client Role:Independent SharePoint Consultant Platform:SharePoint Online, Microsoft Flow, JavaScript, CSOM, JQuery, Custom Master Page DescriptionIt contained Document library, few Custom lists with custom workflows developed in Microsoft Flow, Custom Projects list using Task List and Gantt chart view. There was a Remote Event Receiver developed to create Sub Site and Task List on Create Event of the Project List. The Time Sheet was developed using few custom content type and site columns. Engagement in IBM Key Result Areas: SharePoint 2013, 2010, 2007, .Net, C#, MS SQL SharePoint Solution Design, Migration, Application Maintenance and Support. Design, development, and implementation of workflow program, presentation and handling various phases of interface development based on technical specification Design, development, and implementation of SFTP in SharePoint Applications. Planning, scoping, estimating, tracking & ensuring implementation of project plans within pre-set budgets and deadlines (as per best practice guidelines) Preparing proposals, responding to RFP, handling business presentations, resource planning, architecture evaluation, technical direction, effort estimation, tracking, risk management, audit, status reporting and mentoring Responsible for analyzing requirements, determining technical approach & technical design, determining effort, and providing deliverable dates for projects and enhancement requests Owning the resources and the responsibility of product delivery with high quality Making technical decisions based on the architectural and software development experience Serving as single point of contact / interface for supporting the customer on various projects and technical issues Analyzing the user needs and requirements to determine feasibility of design within time and cost constraints Maintaining quality of work in accordance with the standards as specified in the design documents Managing team to ensure smooth progress of project work Monitoring and ensuring customer delivery during the transition period Conducting system study and coordinating with team members for product documentation, system design & integration, coding, application maintenance, etc. Implementing the project as per scheduled deadlines and extending maintenance support Accountable for handling the project related documentation requirements Key Accounts, Clients worked in IBM Cathy Pacific, IFCO, Westpac Bank, Australia, ONCOR Electric, USA. CMA, France. Seawell, Norway. GBS (IBM Internal), Canadian Pacific Railways, Canada. Johnson & Johnson, Belgium, USA TRAININGS ATTENDED Genesys Framework from Genesys University San Francisco, USA Genesys Framework and Routing Troubleshooting from Genesys University San Francisco, USA Advance .Net at IBM India Negotiation Skill at IBM India Creative Problem Solving at IBM India Effective Communication skills at IBM India Team Lead Training at IBM India PERSONAL DETAILS Date of Birth:6th July 1972 Address:112 G, Selimpur Road, Block A, Flat 4C, Kolkata- 700031 Languages Known:English, Hindi and Bengali