Lokitha Mukka

Criteria for Importing Events from Outlook Initial Setup of Outlook Categories

Project Name: Timesheet Calendar Importer App

This app is a productivity tool that allows the user to quickly import their Outlook calendar events into their ServiceNow Timesheet for the current week.

• Only events that have a valid category assigned will be imported. All ServiceNow related categories must begin with a "#" prefix followed by text that matches a generic bucket (ex. "#Staff Meeting") or matches a ticket number such as a project or change request number (ex. "#PRJ123456").
• Events that are not categorized or have a category assigned that does not begin with a pound sign will be ignored/skipped.
• Only events where you are marked as "busy" or "out of office" will be included. If your status is marked as tentative or free then that event will not be included.

A one-time use script is available (windows computers only) that will automatically create for you categories that match all of the standard generic buckets in ServiceNow! It is strongly encouraged to take advantage of this to more easily utilize the app.

Normal Pattern of Usage

• User in Outlook reviews their calendar entries for the current week and insures all desired work-related events are tagged with an appropriate category matching a ServiceNow bucket.
• User loads the Timesheet Calendar Importer app
• User clicks button "Import Calendar". System will retrieve all matching events for the current week.
• User reviews/confirms list looks good.
• User clicks button "Submit to Time Sheet" to transfer the data into ServiceNow.
• User jumps to ServiceNow to review, finalize their timesheet for the week and submit.

Submitting to ServiceNow

Note the following rules will be adhered to when submitting data to ServiceNow.

• Time can only be transferred if your timesheet has not yet been submitted in ServiceNow.
• Only events that are categorized with a valid ServiceNow ticket number of generic bucket will be logged/added. When the system cannot match an error will be shown to the user to explain.
• If a user have multiple events with the same category for the same day, the system will total those hours automatically and be reflected in the timesheet for that day.
• When no timecard with that category/task exists for a given day it will be created.
• When a timecard matching that category/task exists on that day already, and hours match, no change will be made.
• When a timecard matching that category/task exists on that day already and the hours do not match, but was last updated by the API, the total hours will be overwritten to match the payload.
• When a timecard matching that category/task exists on that day already and the hours do not match, but was last updated directly by the user, the total hours will NOT be overwritten and an error will be shown to the user to explain.

Project Name: Cable Experiment Process Application

• Involved in all stages of Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, UAT, Production and Post-Production Support.
• Created prototype of application for demo before developing application.
• Created Canvas app and used data source is SharePoint.
• Created Scheduled flows for remainders and notification and created automated flows for different business process.

· PowerApps Developer would be responsible for designing and developing business applications and solutions

using Power Automate (Flow) and Power Apps

· Good Technical Knowledge on designing and developing the PowerApps and power automate

· Analyze the business requirements by collaborating with the stakeholders

· Experience in Demonstrate solutions by developing documentation, flowcharts, layouts, diagrams.

· PowerApps developer with Microsoft SharePoint /O365 knowledge.

· Experience in Canvas Apps development

· Experience in using CDS

· Understands and consider performance improvements techniques.

· Experience in designing, creating, Power Apps solutions in large-scale environments

· Experience in designing Canvas Apps User interfaces based in best practices

· Experience in producing technical documentation.

· Experience in Power Automate, CDS, other connectors

· Worked on Data verse, SQL, SharePoint as storage for PowerApps application

· Developing Apps using Power Platform and moving them to production

· Experience with integration of data from multiple data sources

· Worked on as support for many applications related to .net, SharePoint, PowerApps, Power Automate.

· Experience in Service desk tickets, Request, Incidents P3,P2,P1

· Experience in CAB process during the production movement.

· Worked on SharePoint online and SharePoint 2013, SPFX, react

· Experience in SharePoint migration using Sharegate License

· Build webparts, layouts,

· SharePoint permission level access

· Worked on estimations and technical design based on client requirements.

· Worked on the Azure Deployments

· Experience in Creating App Services, Azure SQL’s

· Deployment’s solutions in Azure app services

· Experience in Azure web jobs (Triggered, continuously)

· Hybrid Connections

· Developed controls such as user-controls,list views,validations and editing ,modal popups,dropdown lists,query strings,SQL Data source.

· Created SQL Serve database,tables,stored procedures,Views , and data base backup using SQL Server.

· Updating and saving of data to SQL database tables using C#/ASP.NET/

· Exprenice in Porvided hosted app/Remote reciver app