Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Timeline
Technology Skills
Personal Information
Generic

Rashi Dwivedi

Calgary

Summary

20+ years of strong IT experience with Software Development, Product Development, End-to-End application development and leading production support engagements. I have been working with Canada’s Prairie School Division’s IT department for last 12+ years and enriched with very strong application and product development experience which are being widely used in educational domains in Canada. Some of these IT applications were developed for Ministry of Education, Government of Canada, and Saskatchewan Government Provincial School board. I have extensively worked on following Technologies (PowerApps, PowerAutomate, PowerBI, SharePoint, SharePoint Online, InfoPath Form, Dataverse Integrations, Dataverse Custom Actions/APIs, Dataverse plugins, custom connectors, SQL Server, PowerShell, Dynamic 365,Azure function, App Service, Webhook, Service Bus, Logic Apps). One of most accomplished work was Alloy Portal setup for ITSM governance including monitoring, incident management, inventory management, knowledge base management with dashboard reporting capabilities. Additionally, I have 7+ years of work experience with prestigious Tata Consultancy Services (TCS) in Manufacturing, Telecom, Life Sciences and Healthcare domains with various technology sets. I have played role of developer, analyst, and project manager and worked in TCS’ projects both in India and USA. As a Project Manager, I was very successful in managerial roles that demanded rigor, a high level of drive and dedication and a focus on delivering business outcomes through the use of methodologies. I am an enthusiastic and versatile professional with experience in Software Project Development, Implementation and Support, Project Planning and Management, SDLC Planning and Rollout. I am an enthusiastic and versatile professional with experience in Software Project Development, Implementation and Support, Data warehouse processes, Systems Design, Maintenance, Quantitative Analysis, Quality Assurance, Testing Automation, Application Performance and Load Testing, User Training and IT Acceptance Testing. Characterized by excellent analytical and programming skills, good knowledge of Configuring Microsoft Team Foundation Server, Visual Studio, Microsoft SharePoint and .Net, Application Lifecycle Management, Oracle PL/SQL and UNIX Shell scripting, Oracle Developer Reports, ASP Reports, Oracle RDBMS and SQL server Database.

Overview

22
22
years of professional experience

Work History

Sr. Power Platform Developer/architect

Prairie Valley School Division
02.2013 - Current
  • Company Overview: IT department for educational domains in Canada, developed applications for Ministry of Education, Government of Canada, and Saskatchewan Government Provincial School board.
  • Developed a Grant Inventory Management Tool for Prairie Valley School Division using Microsoft SharePoint, integrated with a custom digital application compatible across desktop and mobile platforms.
  • Leveraged PowerApps, Power Automate, Dynamic 365 CE and mobile app integration to ensure seamless user experience, workflow automation, and real-time data access across the organization.
  • Skilled in building Power Apps (Canvas & Model-driven), Power Automate workflows, Power BI dashboards, and Dataverse integrations and Azure integration to drive business transformation, Dynamics 365 CE.
  • Dataverse Custom Actions/APIs, Dataverse plugins, custom connectors for integrations with other APIs.
  • Azure function, App Service, Webhook, Service Bus, Logic Apps and worked with Azure services such as Azure Functions, Logic Apps, Service Bus, App services
  • IT department for educational domains in Canada, developed applications for Ministry of Education, Government of Canada, and Saskatchewan Government Provincial School board.


Project Manager

Elli Lilly and Company
01.2009 - 02.2011
  • Company Overview: Pharmaceutical company known for its innovative medicines.
  • Responsible for the preparation of Project Plan, Strategizing UAT (User Acceptance Testing).
  • Involved in the preparation of Functional Specifications, SOWs, ROI, RFPs.
  • Led a team of technical and functional developers to complete enhancement projects with Microsoft TFS configurations.
  • Pharmaceutical company known for its innovative medicines.

Developer Analyst

Xerox Corporation
01.2008 - 12.2009

I was given an opportunity to work in the prestigious project of Xerox Corporation. I have worked extensively as part of a team supporting one or more projects in Developer capacity. Primarily, I was involved in Business Process Modeling (AS-IS and TO-BE study), End user discussions and documentationof existing business process flow, Overview update on proposed application model, Requirement Analysis of functional and non-functional processes for software application and business process development. Create, document, and TEST Strategy and Execution Plan, Creation of new roles and responsibilities of business roles based on future state models Document and provide training materialsfor technical operations areas Compile and synthesize information related to both organizational and technical Change Management. Support and execute implementation strategies and plans. Extended support to complete activities associated with Project Management, Project Audit and Internal/External Reviews.

On Technology front, actively worked on promoting Microsoft Team Foundation Server (TFS) and Microsoft SharePointfor hosting web applications, portal-based solutions, change management projects including component-based access and version controls. As an Analyst in Business SME role also supported application performance and load testing activities for Oracle Data Warehouse project with advanced and complex framework and technologies such as SQL, PL/SQL, and UNIX shell scripting, and ASP web report development. I was working as a Onsite/ Offshore coordinator in Oracle DWH, ETL Tool Data Stage, PL/SQL developer, MS SQL developer, ASP reporting, Defect Analysis, Defect Ticket creation.

Web Applications:

In this project, I was working as an Analyst and was bridging between IT and Business teams. Here, I was involved to develop an online system to support Product Order Life Cycle Management Application using Microsoft technologies (ASP.Net)and SQL server. Extensively used Microsoft TFS (Team Foundation Server) for web portal deployment and linked with Microsoft SharePoint services for document repository and version control and access control features.

  • Initial Study to propose Application Technology
  • Business Case Studies
  • Requirement Analysis and Documentation
  • Documentation – To prepare Technical Design and System Design documents
  • Planning and Testing Strategy and test cases buildup
  • Working with Quality Assurance team for testing automation and support
  • Team Coordination between Onsite / offshore teams
  • Developer support for Performance testing, Load testing simulations and analysis
  • Business Analyst support for Performance Monitoring, Analysis and Tuning
  • Onsite / offshore communication and coordination
  • SLA mitigation – Production Support
  • Audit tracking, documentation for internal and external reviews
  • Weekly Status Call

DataWarehouse Project: This is an Oracle DataWarehouse Project.

  • Parts, supplies, and equipment inventory data comes from a variety of data sources and technical platforms. Data is generally inaccessible at the source and little history is available.
  • Business requires timely, accurate, quality information and the need to share the same data and information, which should be easily accessible.
  • Reporting requests are labor intensive, often difficult to produce resulting in negative customer satisfaction.

– Expensive storage, processing, support on the mainframe.

– Redundant custom extracts from legacy sources for current desktop tools using programming.

– Multiple naming conventions exist, making extraction difficult.

I have extensively worked on following to support Warehouse projects.

· Conducting and Facilitating Workshop to provide new application demo and end User Training

· Enable user training and demonstration for End -USER Information Access for business needs

· Onsite / offshore coordination to provide 24x7 support

· Automation Planning , Test cases buildupand UAT Testing

· Supporting Quality Assurance team

· SLA mitigation to provide support to meet project SLA (production support)

· Audit tracking and reviews

· Resource Management, Cost Budget Preparation, Project Planning and Review

· Project Status Reporting, Weekly Status Call

· Patch Analysis and Documentation- Integration testing of latest patches and code fixes for all associated COTS applications

Business Analyst

Tata Consultancy Services
12.2005 - 12.2008
  • Company Overview: Prestigious IT services, consulting, and business solutions organization.
  • Worked as a Project Manager, Business Analyst and IT Consultant for Tata Consultancy Services (TCS) since 2003.
  • Responsible for preparation of Project Plan, Strategizing UAT (User Acceptance Testing).
  • Involved in the preparation of Functional Specifications, SOWs, ROI, RFPs.
  • Led a team of technical and functional developers to complete enhancement projects with Microsoft TFS configurations.
  • Prestigious IT services, consulting, and business solutions organization.

Project Manager

Nortel Networks
04.2005 - 12.2005
  • Company Overview: Telecommunications and data networking equipment manufacturer.
  • Responsible for the preparation of Project Plan, Strategizing UAT (User Acceptance Testing).
  • Involved in requirement analysis and gathered business requirements from business group owners and SMEs.
  • Telecommunications and data networking equipment manufacturer.

Analyst

Tata Consultancy Services
11.2003 - 04.2005

I had completed my in-house Initial Learning Program successfully and joined TCS development project as Business Analyst. During my project tenure in TCS, I have developed an understanding in TCS' business processes, client's business processes, software correlations and management.I have also participated in core project activities like IPMS effort tracking, Defect & Causal Analysis, SIX Sigma concepts, Knowledge Transition, Documentation, Training, Mentoring and Team building.

  • Analyzed data trends to identify opportunities for process improvement and cost reduction.
  • Developed reports to communicate insights and support decision-making for management teams.
  • Collaborated with cross-functional teams to align strategies and optimize operational efficiency.

Education

Bachelor of Engineering Degree with Honors - Electronics and Communication

Lakshmi Narain College of Technology
Bhopal, India
06-2003

Skills

  • ASP
  • ASPNet
  • ASP Web Reports
  • Expertise in Power Platform solutions development
  • PowerApps development
  • Experience with Dynamics 365 solutions
  • PowerShell
  • SmartWEB
  • PowerAutomate
  • Power BI
  • Dataverse integration
  • Webhook integration
  • LogicApps
  • Dataverse Custom Actions/APIs
  • Dataverse plugins
  • custom integration connectors
  • JSON
  • CSS
  • HTML
  • HTTP
  • REST APIs
  • SQL
  • Net and Visual Basic
  • PowerShell Scripting
  • PL/SQL
  • Databases
  • SQL Server
  • Oracle RDBMS
  • MS Access
  • Microsoft SharePoint 2010
  • Microsoft SharePoint 2013
  • Microsoft SharePoint Online
  • BMC Remedy
  • ITT Ticket Tracker
  • Microsoft Alloy
  • Assential DataStage
  • SQL Loader
  • TOAD
  • PL/SQL Developer
  • SQL Plus
  • Microsoft Team Foundation Server TFS
  • AI Builder
  • Virtual Agents
  • SharePoint
  • Teams
  • Dynamics 365 CE
  • Azure AD
  • JavaScript
  • C#
  • Power Fx
  • REST APIs
  • DAX
  • Power Query
  • Dataflows
  • Agile/Scrum
  • DevOps
  • CI/CD for Power Platform
  • Azure
  • GitHub
  • ALM Accelerator
  • Solution Packaging & Deployment
  • Solace
  • Active Directory/Entra
  • Solution management, segmentation and deployment processes

Accomplishments

Projects for Ministry of Education, Saskatchewan, Government of Canada:

Ø Electronic Educator Profile:Developed SQL Queries using SQL Server database tables from Navision and Student Information Systems to get the output in desired XML Format to upload to Ministry of Education sites to submit the profile of 600 teachers electronically and thus reducing manual entries.

· Develop Complex SQL Queries on Finance and Student Information tables

· Using SQL XML to get the output in XML Format

· Uploading the XML files to Ministry’s website to populate the information on their Web Application

Ø WordPress Website for Ministry of Education: Requirement gathering and creating the website in WordPress, customizations done to WordPress Template using HTML and CSS, Java Templates.

· Concepts of Web Hosting

· Customizing the WordPress Template using HTML, CSS and JavaScript.

Ø Microsoft Power Apps Developer: Developed PowerApps Applications using forms and PowerAutomate Flows: Designed and deployed end-to-end Power Apps solutions (Canvas & Model-driven) integrated with Dataverse and SharePoint.

1. Central Cataloguing App: Developed a Central Cataloguing Form in PowerApps

which was used by the Cataloguing department to scan barcodes and catalogue items.

The functionality included scanning of the barcodes, converting the string into barcodes.

The form had role-based access. Administrators had access to the form at their

schools, while the Central Cataloguing department had access to all the forms submitted.

PowerAutomate: Used PowerAutomate to create two flows

a) Email flow: The user received an email after the successful completion of the form

b) Purge Flow: the completed forms were purged automatically two weeks after

their completion.

2. Mileage Expense App: Designed and deployed end-to-end Power Apps solutions (Canvas & Model-driven) integrated with Dataverse and SharePoint. Developed an end-to-end application to automatically create

mileage based on the origin and destination and then created a jpeg file with all the details to

scan this directly to kwiktag for further processing.

PowerAutomate: Used PowerAutomate to create two flows:

a) Email flow: The user received an email after the successful completion of the form

b) Create file: Created a jpeg and pdf files in the Sharepoint Library

3. Charter Bus request App: Designed and deployed end-to-end Power Apps solutions (Canvas & Model-driven) integrated with Dataverse and SharePoint. Developed an end-to -end application,where the Charter

Bus request forms were submitted by the users. The mileage was automatically

calculated. The forms would go through a multilayer approval process, Administrators,

Transportation Department and finally by payroll for the Bus Request to be approved and

processed.

4. Performance Management Document App: Implemented role-based security, ALM practices, and governance policies. This app was used to automatically create

performance management word documents in the SharePoint library based on the user

information. PowerAutomate was then used to tweak the permissions on the created

documents to ensure document confidentiality.

Languages

English

Timeline

Sr. Power Platform Developer/architect

Prairie Valley School Division
02.2013 - Current

Project Manager

Elli Lilly and Company
01.2009 - 02.2011

Developer Analyst

Xerox Corporation
01.2008 - 12.2009

Business Analyst

Tata Consultancy Services
12.2005 - 12.2008

Project Manager

Nortel Networks
04.2005 - 12.2005

Analyst

Tata Consultancy Services
11.2003 - 04.2005

Bachelor of Engineering Degree with Honors - Electronics and Communication

Lakshmi Narain College of Technology

Technology Skills

ASP, ASP.Net, PowerApps, PowerAutomate, SQL, PL/SQL, Microsoft SharePoint, BMC Remedy, Microsoft Team Foundation Server, Power Platform, Agile, Scrum, DevOps

Personal Information

Title: Sr. Power Platform Developer/ Architect

Rashi Dwivedi