Power Engineer

SANDEEP JOHN addzg4@r.postjobfree.com

Plano, TX 248-***-****

PROFESSIONAL SUMMARY

●A Senior Microsoft Power Platform Developer with over 13 years of experience in designing, developing, and maintaining mobile, web and client/server applications using Microsoft Technologies.

●Expertise in Microsoft technologies(Cloud, Web, Mobile, Reporting, Repository) like Azure Cloud, Azure AD, Azure Cognitive services, Azure SQL, Microsoft Power BI, Microsoft Power Apps, Power Automate, SharePoint Online, Common Data Service (CDS), Angular 7, Typescript, Swagger, .Net core, Web API, SQL Server, GIT, ASP.NET MVC, ASP.NET Web Forms, C#, LINQ, ENTITY FRAMEWORK, XML Web Services, WCF SERVICES, AJAX, IIS, Bootstrap, SSRS, TFS, Unit testing.

●Industry exposure includes Automotive, HealthCare, Banking and Finance and Corporate Legal Services.

●Hands - on experience in Azure Cloud Services (PaaS), Storage, Web Apps, Active Directory (Azure AD).

●Designed and developed Cloud Service projects and deployed to Web Apps and PaaS.

●Make full use of Azure DevOps. – major features Repos, Board, CICD Pipelines & Artifacts.

●Develop quick small applications using Microsoft PowerApps, Power Automate, SharePoint online and Azure Cognitive services.

● Managing Citizen Development Center of Excellence on Enterprise level with MS tools PowerApps & Power Automate.

●Providing whole day Training's to large groups as part of COE.

●Implemented COE Guard Rails processes across enterprise.

●Closely worked with different application Teams to modernize their existing process using Power Platform.

●Developed Mobile Apps using PowerApps that runs on Android, IOS, Windows and Web platforms.

●Expertise in work with Office 365 connectors and created Custom connectors for accessing custom REST API’s.

●Expertise Administrating entire Toyota North America PowerApps & Power Automate Environment.

●Expertise in designing and developing PowerApps using Azure Cognitive services (Custom vision AI service)

●Experience in managing the Citizen Development Center of Excellence for Microsoft PowerApps & Power Automate (SaaS) on enterprise level.

●Expertise in providing one-day training on Microsoft Technologies for large groups as part of COE.

●Developed Canvas Apps as well as Model Driven Apps with the use of Common Data Service (CDS).

●Expertise in managing apps & security as part of Dynamics 365.

●Extensive experience with Scrum and Waterfall software development methodologies.

● Experience in using Language-Integrated Query (LINQ) query and retrieving data from different data sources.

●Report Development using Microsoft Power BI.

●Expertise in Client/Server (WinForms, WPF) and Web based (MVC, Web Forms, ASP.Net) application development.

●Solid experience with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, and Caching).

●Experience in database related work, primarily creating complex stored procedures, packages, Views, Triggers, and Functions, using SQL SERVER.

●Experienced in Configuration Management, setting up and maintaining company Version policies, build schedule using Bitbucket TFS-Git Repositories.

●Experience in preparing POC for common tasks including documentation for integration.

●Worked extensively on Swagger, Postman and SoapUI Open Source Functional testing tool for Web API and Web service testing.

●Participate in Code review and provide valuable suggestions.

●Proficient in using .NET Threading, Delegates, Events, Generics, Collections, Exception Handling, Transactions, Reflection, and Serialization.

●Good knowledge in Data Structures & Design Patterns.

●Exceptional skills in problem solving techniques, investigating, debugging & fixing the issues.

●Designed data flow diagrams using Visio and documented every phase of design & development of app.

●Experience in deploying, configuring and maintaining the web sites and services on IIS 7.0 with and without secure socket layer.

●Strong customer focus, excellent listening and communication skills, creative and cost-effective problem solver.

●Always seek out new technologies and ideas to add value and share technical knowledge with other members across the organization.

●Team player with good interpersonal, Collaboration skills and the ability to work in the team

TECHNICAL SKILLS

Azure Cloud: DevOps, Azure AD, Power Apps, Power Automate, Power BI, SharePoint online, CDS, Dynamics 365, Office 365

. Net Technologies: .Net core, EF Core, ASP.NET (Web Forms), ADO.NET, LINQ, Entity Framework, Swagger.

Languages: C#, SQL

Web Technologies: Web API, Angular 7, Bootstrap, Power Apps, Power Automate, HTML 5, CSS, JavaScript, TypeScript, jQuery, XML, Restful Services, WCF, Web Services, SOAP, WSDL, AJAX tool kit.

GUI and IDE: VS Code and Visual Studio.NET 2003/2005/2008/2010/2013/2015/2017.

RDBMS / DBMS: SQL Server 2017/2014/2012/2008 /2005.

Version Controller: Azure Repos, Bitbucket, Git, Team foundation server (TFS), Visual SourceSafe (VSS).

Reporting: SSRS and Power BI

Third party tools: Swagger, Postman, Telerik.

Web Servers: IIS 5.0/6.0/7.0/8.0

Unit Testing: xUnit

PROFESSIONAL EXPERIENCE

Working as Sr. Software with Computech Corporation, Plano, TX.

Worked with Softura Inc, Detroit.

Worked with IQ Software & Services Pvt.Ltd, Bangalore, INDIA.

Worked with M-SQUARED Software & Services, INDIA

EDUCATION & CERTIFICATION

Master’s in Information Technology from Manipal University (MAHE), Karnataka, India.

PROJECTS:

Toyota (Plano, TX)

Project Group : Business & Solution Architecture

Duration : June 2018 – June 2020 (Design, Development).

Business & Solution Architecture is a group within Advanced Technology & Data (ATD) of Toyota. This group is providing solution architecture & supporting Citizen development across TMNA along with providing services as a COE of PowerApps & Microsoft Power Automate. Develops & designs custom applications with advanced Microsoft technologies for various business requirements. Conducting training for large groups of citizen developers across the company.

Project Group : Minimum Viable Product

Duration : October 2015 – May 2018(Design, Development).

Minimum Viable Product (MVP) is a group within Prod Admin of Toyota. MVP group develops custom software from small to medium range requirements for Toyota plants. Within the last 4 years, MVP group developed close to 15 applications.

Floor Mat Survey Tool:

Floor mat Survey tool is a Mobile App, used by all Toyota dealers in North America to make sure the mats are properly fixed on the car when the time of service drop-off, pickup and new car delivery. Based on the picture of the mat, app will predict the mat type, stacked and hooked details using Azure cognitive service Custom Vision API (AI service). Custom vision AI models are developed through custom vision interface by uploading images & label them with appropriate properties. After doing enough training with labeled images, will evaluate the model by REST API calls. Based on prediction result, data will store to database and used to create national level Power BI reports.

Asset Management Workflow:

Asset Management workflow is an application to automate managing the various assets with different categories. Application will store the potential asset requirement proposal and it leads towards an approval workflow with different levels. Rejected approvals handled through email and it will automatically restart the workflow. All levels data including status will be recorded in the SharePoint list.

Daily Handover Database (DHD) :

Daily Handover Database (DHD) is a regional application developing to automate the shift-to-shift handover and documentation process for different plants. It will allow users from each plant (TMMWV, TMMAL, and TMMK) to manage production plans and actual data with comments per shift while automatically generating daily reports. It will Improve quality and speed of reporting to TMNA/TMC executives, ability to research historical downtime data for all shops and consistency in production reporting across all NAMCs.

Fundamental Skills Audit (FSA):

The FSA application developed to provide function support on auditing team members by Team leads from the plant floor. It will be used by Team Leaders in Body Weld & Assembly Departments at TMMI. This web-based application will be accessible on iPads and Desktops / Laptop for TLs/GLs to do the Audit. Admin users will have the ability to add / edit questions for Audits. This application will also allow the users to generate reports as required for the Audits completed using this system. The reports will be created and published using Power BI.

Roles & Responsibilities

●Design and develop the applications using advanced software technologies.

●Utilized OOPS concepts and Design Patterns to make flexible, reliable and extendable applications.

●Develop Web-based solutions using Microsoft technologies like, ASP.NET MVC, ASP.NET Core, C#, AJAX.

●Design and developed class library for Domain entities using Entity Framework 6.0.

●Design cloud solutions for various system components using Microsoft Azure.

●Used Azure DevOps. – major features Repos, Board, CICD Pipelines & Artifacts.

●Communicating with various department users to understand and provide specific solutions.

●Authentication techniques using Azure AD.

●Develop quick small applications using Microsoft PowerApps, Power Automate, SharePoint online and Azure Cognitive services.

● Managing Citizen Development Center of Excellence on Enterprise level with MS tools PowerApps & Power Automate.

●Providing whole day Training's to large groups as part of COE.

●Implemented COE Guard Rails processes across enterprise.

●Closely worked with different application Teams to modernize their existing process using Power Platform.

●Expertise Administrating entire Toyota North America PowerApps & Power Automate Environment.

●Expertise in designing and developing PowerApps using Azure Cognitive services (Custom vision AI service)

●Developed Mobile Apps using PowerApps that runs on Android, IOS, Windows and Web platforms.

●Developed Canvas Apps as well as Model Driven Apps with the use of Common Data Service (CDS).

●Expertise in managing apps & security as part of Dynamics 365.

●Expertise in work with Office 365 connectors and created Custom connectors for accessing custom REST API’s.

●Use LINQ to manage data flow from through domain entities.

●Extensively used Angular7.0, HTML5, CSS, jQuery for developing rich UI.

●Used Waterfall and Agile/Scrum methodologies to maintain the projects.

●Managed data using SQL server 2014.

●Analyze, suggest different solutions options, update / upgrade the application and deliver on time.

●Handle production exceptions with quick and quality solutions.

●Creating documentation such as System Requirement Specification, Unit Test Plan / Cases with proper screenshots etc for every change request or development.

●Develop reporting solutions using SSRS & Power BI.

●Deploying the application in different environments for System and Integration testing.

●Maintaining Project Build and Release management using Build Farm, CICD Pipelines.

Computech Corporation, Detroit, MI Apr 2015- Sep 2015

Sr. ASP.NET Developer

BMS (Internal Project)

Business Management System (BMS) developed to automate Employment life cycle process and other back office activities of clients. It has Timesheet, Mileage Sheet, Expense Sheet, Leave management, HR Docs, Project Task Scheduling Modules. Application was designed to keep all department employees on the same page and minimize manual and phone interaction with the HR, Account and Payroll department.

Roles & Responsibilities

●Involved developing the application using ASP.NET with C#.NET.

●Utilized OOPS concepts and Design Patterns to make flexible, reliable and extendable application.

●Designed and developed class library for Domain entities using Entity Framework.

●Used LINQ to manage data flow from through domain entities.

●Extensively used HTML5, CSS, jQuery for developing rich UI.

●Managed data using SQL server 2008.

●Creating documentation such as System Requirement Specification, Unit Test Plan / Cases with proper screenshots etc for every change request or development.

●Deploying the application in different environments for System and Integration testing.

●Maintaining Project Build and Release management using TFS 2013.

Environment: C#, ASP.NET MVC 5, EF 6, jQuery, Bootstrap, SQL-server 2008, IIS7

Softura Inc, Farmington Hills, MI Mar 2014 – Aug 2014

Sr. ASP.NET Developer

Clark Hill, Detroit, MI (Client)

ExpertEase

The project is to develop a smartphone application and a Website to manage all the Expert Witnesses for a law firm. Mobile applications will be supported in iOS and Android platforms. This application is for internal purpose and can be only used by the registered attorneys of the law firm. Users can search for an expert based on category, specialty, rating and location. Users can add new experts and can rate each one based on the matter number. Users can also upload multiple documents for each expert and manage documents done on the website.

Roles & Responsibilities

●Involved in requirement analysis, architecture design, leading the team and development.

●Involved developing the application using ASP.NET with C#.NET.

●Utilized OOPS concepts and Design Patterns to make flexible, reliable and extendable application.

●Designed and developed class library for Domain entities using Entity Framework.

●Used LINQ to manage data flow from through domain entities.

●Extensively used HTML5, CSS, jQuery for developing rich UI.

●Managed data using SQL server 2012.

●Creating documentation such as System Requirement Specification, Unit Test Plan / Cases with proper screenshots etc for every change request or development.

●Deploying the application in different environments for System and Integration testing.

●Reviewing the code based on the Microsoft standards.

●Maintaining Project Build and Release management using TFS 2012.

www.BillHighway.com

Bill Highway, Troy, MI (Client) Sep 2014 – Mar 2015

Sr. ASP.NET Developer

Bill Highway is the online and offline payment gateway for our nonprofit clients to automate donor data and dollars collected through their use of multi-channel engagement strategies. Fully integrated financial & donor management systems help to use the data more effectively and save time & resources. Product has features like Donation pages, Social Fundraising, Lockbox360 and Disaster Relief. Mostly involved in Donation pages which drive additional revenue with our online donation form and customizing pages that match the look and feel of the client's website. Either way, process all online gifts, integrating them to your donor management system.

Roles & Responsibilities

●Involved in developing the application using ASP.NET MVC4.0 with C#.NET, SharePoint, JavaScript, and CSS.

●Good understanding with the architecture and application logic.

●Good knowledge in creating jQuery Templates and utilized jQuery UI controls to create a responsive UI.

●Created business rules for validating the forms dynamically.

●Utilized Kendo UI framework for building the standard UI controls and components.

●Good usage of Directives, Services, Controllers and Factory from the AngularJs framework.

●Extensively used HTML5, CSS, jQuery for developing rich UI.

●Deploying the application in different environments for System and Integration testing.

●Maintaining Project Build and Release management using TFS 2012.

IQ Software & Services Pvt.Ltd, Bangalore, INDIA Dec 2007 – Jan 2014

Sr. ASP.NET Developer

BancTec, UK (Client)

eFirst.Origin

The project was based on Mortgages. The eFirst Origin loan origination project was divided into four phases. The first phase involved the documentation of the loan origination product 'eFirst origin' and the second phase of the project, was involved in the internationalization of the 'eFirst origin' product. The third phase, involved the development of a web based .Net application that helped in picking up several fields from the database, automating their document generation and creating documents that describes all dictionary items defined in the product. Fourth phase involved bug fixing and performance monitoring. The development was done in ASP.Net using the multi-tier architecture following all coding norms and standards.

Roles & Responsibilities

●Architecture the application using ASP.NET with C#.NET, AJAX, HTML, JavaScript, and CSS.

●Extensively used HTML5, CSS, jQuery for developing rich UI.

●Good knowledge in creating jQuery Templates and utilized jQuery UI controls to create a responsive UI.

●Designed and developed class library for Domain entities using Entity Framework 4.0.

●Having good knowledge in WEB API.

●Very good experience in creating Single Page Applications.

●Maintaining Project Build and Release management using TFS 2010.

ControlCentre

This web application is developed for NCHT to maintain the service details of Gas and Non-Gas appliances. This company maintains all the details about the customers and related information of appliances. The customer calls will be maintained by the company and each call can be assigned to the engineer. Once a call is assigned to the engineer, they can add appointments and cancel already existing appointments provided for servicing the appliances. This contains the service details like work status and problems identified and fixed. From this application they can reassign the calls to other engineers. In addition to this, applications can add new PDA device information of engineer, service details and user information. It has a window service to create the certificate and warning notices for the appliance service details that is provided to the client after service completion

Roles & Responsibilities

●Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

●Utilized OOPS concepts and Design Patterns to make flexible, reliable and extendable application.

●Utilized ASP.NET, WPF as a base technology for building huge web applications.

●Used HTML5, CSS, jQuery for developing rich UI.

●Used SQL Server 2008 R2 for database management.

●Used Entity Framework 4.0 as an ORM.

●Visual Studio 2010 Development with Source Control.

●Maintaining Project Build and Release management using TFS 2010.

●Creating documentation such as System Requirement Specification, Unit Test Plan / Cases with proper screenshots etc for every change request or development.

●Studying the entire application processing, identifying the areas of improvement and implementing the same.

●Deploying the application in different environments for System and Integration testing.

Hermes

Project Hermes is an Online Non-Prescription Ordering System, a means by which health service employees can order non-prescription items such as wound care products via an easy to use HTML based web browser. Because this is non-prescription ordering, routing via a GP for signature becomes redundant and the whole ordering process becomes less arduous and time consuming. The orders are routed directly from the HERMES system to a pharmacy or supplier of choice for fulfillment thus reducing the need for paperwork again cutting costs from the NHS system. The local pharmacist is provided with an online interface that allows the pickup and subsequent fulfillment of orders. Each system is configurable at PCT level to allow bespoke use. HERMES offering has a built-in clinical audit facility which would therefore not only allow monitoring of product use but also appropriate use and would highlight educational needs. In essence HERMES is an attractive, easy to use system that helps the NHS to control cost and clinical choice. SSIS package used for uploading the price list of non-prescribed products by NHS.

Roles & Responsibilities

●Architecture the application using ASP.NET with VB.NET, AJAX, HTML, JavaScript, and CSS.

●Extensively used HTML5, CSS, jQuery for developing rich UI.

●Good knowledge in creating jQuery Templates and utilized jQuery UI controls to create a responsive UI.

●Designed and developed class library for Domain entities using Entity Framework 4.0.

●Having good knowledge in WEB API.

●Very good experience in creating Single Page Applications.

●Maintaining Project Build and Release management using TFS.

M-SQUARED Software & Services, INDIA Oct 2006 – Sep 2007

.NET Developer

T-CAS (Total Clinical Automation Solution)

T-CAS is a web-based automated solution for clinical management. It coordinates and integrates all inherent activities involved in the management and running of a health care clinic consolidates Prescription Refills, Laboratory Order Processing. It supports LIS (Laboratory Information System) and communication between external LIS, Transcription Software, and Clinical Solution. This system provides modules for patient and employee registration and shows updated patient details. The Lab interface provides provision for doctors to post requisitions for conducting lab tests for patients. T-CAS provides analytic reports on Patient, Billing, and Lab available to the Clinical Staff. This project is developed for hospitals in the U.S.

Roles & Responsibilities

Utilized .Net 2.0 framework to build huge web-based applications.

Architecture the application using ASP.NET with C#.NET.

Utilized OOPS concepts and Design Patterns to make flexible, reliable and extendable application.

Created framework to dynamically create the UI controls based on the inputs from the web services.

Created configuration-based tab controls to support the business needs.

Used SQL Server 2005 for database management.

Used ADO.Net as an ORM.

Visual Studio 2005 Development with Source Control.

Created a framework to support the browser-based user controls.

Contact this candidate