SUMMARY

• Around 7 years of experience in system design, development and implementation of EAI solutions, Client/Server applications and Windows applications, and solid experience with Service Oriented Architecture (SOA) using BizTalk, .NET, SOAP, REST, etc.
• Experienced in all aspects of Software Development Life - Cycle (SDLC), QA Life Cycle, and on SCRUM (Agile) methodology.
• Strong working experience and understanding of Microsoft Power Apps and Flows, connecters and other Office365 services.
• Developed MS Power App applications in Web, Mobile, Tab and demonstrated on how to use, maintain the apps
• Experience in working with MS SharePoint list, forms, MS Power BI with the MS PowerApps
• Strong experience in using Gallery, Forms, Controls, Icons, Formulas, Errors Notifying, Charts, etc. in Microsoft Power Apps
• Solid experience in publishing Canvas Apps, Model Driven Apps (Dynamics 365), SharePoint Integration Power Apps, etc.
• Used SQL Server, SharePoint, Approvals, Outlook, One Drive for Business, CDS, File System, FTP, SMTP, Power BI, etc. connectors.
• Created SharePoint Sites, Subsites, List, Pages, Apps, etc. in SharePoint Online
• Strong knowledge of various licensing options for Power Apps Plan 1, Plan 2, Office 365 Enterprise & MS Flows Plan1, Plan2
• Designed generic interfaces to push and pull data or Objects into Microsoft Dynamics CRM using API Integrations.
• Strong working experience and understanding of Microsoft BizTalk Servers 2013R 2/2013/2010/2009/ 2006 (R2) & Windows Communication Foundation (WCF).
• Strong working knowledge understanding and experience in C#, .Net Framework, WCF, JavaScript, HTML, CSS, XML, SQL Server.
• Experience in developing Stored Procedures, Functions and Triggers for the implementation of data integrity using SQL, T-SQL and PL/SQL.
• Experience in developing Azure Functions & deploying in Azure Portal
• Strong relationship with business stakeholders gathering requirements, providing different solutions and keeping them updated with priorities, roadblocks, deployment dates, run books, error handling etc.
• Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems.
• Effective leadership skills with good written, verbal communication and presentation skills. Self-motivated with result-oriented approach.
• Experience in developing BTS Solution Objects such as Orchestrations, Maps, Schemas, Adapters, Ports, Pipelines and using Custom Functoids, Custom Pipelines.
• Strong knowledge in publishing Schemas and Orchestrations as WCF service and consuming WCF and Web Services hosted by different layers.
• Used Custom Adapters and out of the box BizTalk Adapters & accelerators such as Oracle, SQL, File, HTTP, SOAP, SAP, SharePoint, MSMQ, MQ Series, HIPAA EDI.
• Used ESB Toolkit to create itinerary projects and management portal reports and exceptions.

TECHNICAL SKILLS

Programming: C#, T-SQL, XML, JSON, .Net Framework 3.5/4.0/4.5/4.6 , ADO.Net, ASP.Net

Database: Common Data Services(CDS) 1.0/ 2.0, SQL Server 2005/2008/2012/2014/2016

Cloud Technologies: Azure, AWS, Google Cloud Platform

Adapters: HTTP, WCF, WCF-LOB, FTP, SFTP, FILE, Oracle, SOAP, SAP, SQL, EDI, DB2, MSMQ, MQ Series, POP3, nsoftware. Email v3, etc.

XML Technologies: XML, XSL, XSLT, XPath, Web Services, SOAP, WSDL

Servers: BizTalk 2006 R 2/2009/2010/2013 , 2013R2, SharePoint, SSIS, IIS 6.0/7.0/8.0

PROFESSIONAL EXPERIENCE

Confidential, Heyward City,CA

Sr Integration, Power Apps Consultant

Responsibilities:

• Participate in all aspects of Software Development Life-Cycle (SDLC) and QA Life Cycle including requirements gathering, functional specification, design, implementation, testing, and documentation, Power Platform and Canvas.
• Provide architectural and design guidance for Integration Solutions using Globalscape EFT Server, Microsoft Power Apps, Web Methods;
• Develop Sites, Events Rules, AWE Scripts, Connection Profiles, Workspaces, DMZ Gateway configurations, etc. in Globalscape EFT.
• Architecting & Developing Canvas Apps in PowerApps along with Custom API development
• Solution development in Microsoft Power BI, Microsoft Flow (now Automate) tools
• Designed & Developed automated integrations like Franchise Order Tracking and Delivery Tools for Field Employees for in Power Apps for easy handling of online created/newly created orders during the middle of the day.
• Work with product managers, user experience designers, test engineers, QA analysts, consultants, and program managers to ensure that we build tools that our internal and external clients.
• Developed screens for different types of Graphical Chats, Analytical views from underlying data in SQL, SharePoint, etc. in Power Apps for tracking, comparing, taking decisions on the same screen with MS Flows
• Developed Pages, Gallery’s (Horizontal. Vertical, Blank etc.), Forms (New, Edit, View), Graphs (Pie, Line, Column Chart), Error Notifications, Data Table etc. in Microsoft Power Apps for both web, mobile and tab Apps.
• Developed using all kinds of controls like Buttons, drop down, Combo, List, Check Boxes, Radio, Slider, Rating, Attachments, etc
• Translate complex functional and technical requirements into detailed software development sprint plans and release schedules
• Practicing ITSM Process for Change, Release and Incident Management, Agile Methodology in SDLC
• Reverse engineering application code and prepare functional specification documents
• Document technical, deployment and process documentation for projects and process teams
• Work with business users or project teams to identify and address issues, work in a team environment, and execute under tight timeframes
• Report all the issues, blockers, development work in daily standups & work accordingly as per weekly Sprint plan following Agile Methodology
• Working with business users (end-users) in User Acceptance Testing, Deployment & In Production issues & in Enhancing the existing solution

Confidential, PA

Power Apps Consultant, Data & Integration

Responsibilities:

• Architecting & Developing Canvas and Model apps in PowerApps along with Custom API development
• Solution development in Microsoft Power BI, Microsoft Flow (now Automate) tools
• Work with product managers, user experience designers, test engineers, QA analysts, consultants, and program managers to ensure that we build tools that our internal and external clients.
• Translate complex functional and technical requirements into detailed software development sprint plans and release schedules
• Practicing ITSM Process for Change, Release and Incident Management, Agile Methodology in SDLC
• Reverse engineering application code and prepare functional specification documents
• Document technical, deployment and process documentation for projects and process teams
• Design and developed BPAT (Business Process Alignment Tool) to be used by High Power Committee to evaluate various Opportunities/Projects in Upstream businesses using Azure SQL, Power Apps, Power BI, Flows, etc.
• Developed screens for different types of Graphical Chats, Analytical views from underlying data in SQL, SharePoint, etc. in Power Apps for tracking, comparing, taking decisions on the same screen with MS Flows
• Developed Pages, Gallery’s (Horizontal. Vertical, Blank, etc.), Forms (New, Edit, View), Graphs (Pie, Line, Column Chart), Error Notifications, Data Table, etc. in Microsoft Power Apps for both web, mobile and tab Apps.
• Developed using all kinds of controls like Buttons, drop down, Combo, List, Check Boxes, Radio, Slider, Rating, Attachments, etc.
• Used SQL Server, SharePoint, Approvals, Outlook, OneDrive for Business, CDS, File System, FTP, SMTP, Power BI, etc. connectors.
• Created SharePoint Sites, Subsites, List, Pages, Apps, etc. in SharePoint Online
• Strong knowledge of various licensing options for Power Apps Plan 1, Plan 2, Office 365 Enterprise & MS Flows Plan1, Plan2
• Hosted MS Power Apps on Power BI and vice versa for taking full advantages of each feature and Configured Power Apps in Microsoft Teams for easily accessible to the end-user

Environment: Microsoft (MS) Power Apps, MS Power BI, MS Flow, Azure SQL, JIRA, SharePoint, .NET

Confidential

Power BI Developer

Responsibilities:

• Participated in all phases of analysis and implementation of .NET and BizTalk Server applications
• Integrated MDM (Master Data Management) with multi-vendor systems like Google XSM, Digital Order Tracking (ServiceNow), NCS (News Cycle Solutions) and WO (Wide Orbit) with BizTalk Server
• Designed & Developed automated integrations like Print to Digital & Digital to Print for subscribers/customers to migrate from Newspaper to Online or vice versa in Power Apps
• Created Vendor Management System, Digital Advertise Tracker, Intra Company Training Sites, Approval Flows, Various Analytical and automation task in Microsoft Power Apps, Flows, Common Data Services, SharePoint, Power BI, etc.
• Held meeting with different teams to demo the Power App applications in Web, Mobile, Tab and demonstrated on how to use.
• Developed screens for different types of Graphical Chats, Analytical views from underlying data in SQL, SharePoint, etc. in Power Apps for tracking, comparing, taking decisions on the same screen with MS Flows
• Developed Printing Form to PDF, Approval from Manager on a new item in SharePoint, SQL in email, data transfer between systems, Camera Input, File Inputs, etc.
• Created different environments for Development, Production and non- CDS environment using PowerApps Plan 2 license
• Used Custom connections to call our internal webservice & other vendor services via HTTP calls
• Documented the Power App Requests, Changes and made sure it passes the full Software Development Life Cycle (SDLC) of development, QA, UAT, Production.
• Developed Pages, Gallery’s (Horizontal. Vertical, Blank etc.), Forms (New, Edit, View), Graphs (Pie, Line, Column Chart), Error Notifications, Data Table etc. in Microsoft Power Apps for both web, mobile and tab Apps.
• Developed using all kinds of controls like Buttons, drop down, Combo, List, Check Boxes, Radio, Slider, Rating, Attachments, etc.
• Hosted MS Power Apps on Power BI and vice versa for taking full advantages of each feature
• Configured Power Apps in Microsoft Teams for easily accessible to the end-user
• Developed an Azure Function a CAP Service (Customer Assistant Portal Service) an API used to Fetch data from Ijento (Analytics) Database on API Call Request from CAP Portal & deployed in Microsoft Azure.
• Designed & Developed Google xSM to DOT (Digital Order Tracking) integration, which is responsible for taking Contract information from Google xSM and delivering this information to DOT (built on Service Now).
• Developed an integration between Atlassian JIRA & Service Now systems for auto-updates & tracking between them as per given workflows by the business
• Design and Development of SOAP and RESTful services using ASP.Net, C#, and BizTalk Server.
• Preparing and promoting applications from Test to UAT and planning for Production.
• Provided technical support and advice to systems administrators, database administrators, and BizTalk administrators as necessary to resolve problems.
• Coordinated planned and unplanned applications administration activities with business units to minimize or eliminate impact on business processes
• Achieved the SLAs and got the appreciation from client

Environment: Office365, Microsoft PowerApps, Microsoft Flows, MS Power BI, Common Data Service (CDS), SharePoint BizTalk Server 2013R2, C#, ASP.NET, JIRA, ServiceNow, SOAPUI, Visual Studio 2013,2016 MS SQL Server 2012, 2014,2016, XML, Windows Server 2012R2, IIS, SFMC, Azure, NuGet, Google xSM