Solution Architect( Dynamics CRM)

MITTALBEN P

802-***-****/ ********************@*****.***

https://www.linkedin.com/in/mittalpatel130/

SUMMARY

Strategic-minded and results-driven IT professional with more than thirteen (13) years of experience leading IT projects and teams, implementing technologies such as Dynamics 365 Customer Engagement, Power BI, Power Apps, Flow, Azure, SQL Server & SharePoint

Acted as a functional lead and was able to demonstrate a clean approach to methodology as well as Dynamics 365 CRM functional capabilities.

Led functional discovery sessions with customers to define technical, operational and user requirements

Led and partnered with stakeholders and cross-functional teams and created innovative software solutions that delivered operational efficiencies, improved product quality, enhanced productivity and reduced costs

Developed effective solutions to help clients track their customer engagement, sales, services and marketing

Experience guiding organizations to utilize a strategic approach to achieve organizational goals through the development of technical roadmaps and the use of Data Analytics to measure, track and achieve those goals

Defined, developed and delivered data and analyses that drove best practices in Data Governance, ownership, integration, management, modeling, storage and reporting

Worked with all levels of organizational hierarchy to translate business needs to data and information resources

Led data acquisition, design and analytics efforts to transform data into enhanced decision-making capabilities

EDUCATION

Bachelor of Computer Engineering, S. P. University, India

Diploma in Information Technology, M. S. University, India

SKILLS

Business Intelligence Tools Microsoft BI (SSIS, SSAS, SSRS), Microsoft Power BI, Advanced

BI Tools – Azure ML Studio, Azure Data Factory, Azure Data Lake Gen 2

Power Platform Microsoft PowerApps, Microsoft Flow, Microsoft Power BI

Enterprise Technologies Microsoft Dynamics 365 Online/On-premise, Microsoft SharePoint,

Microsoft Azure, Microsoft Office 365, ServiceNow

Programming Languages Microsoft .Net Framework, .Net Core, .Net C#, MVC Architecture, WCF,

Web API, VS 2012, VS 2013, VS 2015, VS 2017, DAX in Power BI

Web Technologies HTML, DHTML, XHTML, Ajax, XML, JavaScript, JQuery

Software Development Kit .Net SDK, SharePoint SDK, Dynamics 365 SDK

Database Tools Microsoft SQL Server 2017/2016/2014/2012, Oracle/MySQL, MS

Access

Source Safe Tool Microsoft TFS Online, Github

Business Modeling Tools Microsoft Visio, Enterprise Architect

CERTIFICATIONS

ServiceNow Certified System Administrator

ITIL v3 Foundation Certified

Microsoft Certified Professional – Designing Business Intelligence Solutions with Microsoft SQL Server

Microsoft Dynamics 365 for Sales - Badge

Microsoft Dynamics CRM Online (2016) Deployment

Microsoft Specialist – Microsoft Dynamics CRM 2015 Applications

SAS Certified Base Programmer for SAS 9 Microsoft-INSEAD Online Business Strategy and Financial Acumen

Microsoft Specialist – Managing Project and Portfolios with Project Server 2013 Microsoft Specialist – Managing Projects with Microsoft Project 2013

Microsoft Certified Professional

MCTS – Microsoft Dynamics CRM 2011 Applications

MCSD – Application Lifecycle Management

EXPERIENCE

Mar ‘18 – Present Senior Solutions Architect, State & Local Government, Fairfax, VA

Using Dynamics 365, implementing a unified approach to the HHS Front Door requires a common way to understand the population served. The client has a huge CRM Architecture with multiple environments, more than 30 Organizations and many third-party tools integrated like Click Dimensions, ESRI for maps, SharePoint, etc. We upgraded their departments from Dynamics 2016 to Dynamics 365 Online. After upgrades, we migrated all the data, reports, etc.

Provided leadership and direction in defining the role and boundaries of the overall IT Roadmap of Digital Transformation using Dynamics 365, Microsoft BI and drove the culture of data-driven decision making throughout the organization

Led end-to-end project management functions including requirements gathering, project planning and execution of key milestones and project delivery

Built and adopted a high-performance engineering culture, mentored team members and provided team with the tools and motivation to make things happen

Worked with the business stakeholders and programmer analysts to develop a solution or enhance existing ones

Provided guidance on pre-sales, technical architecture, integration, development, configuration/customization and Data Migration efforts for the team

Migrated 40+ On-premise CRM Organizations and Data to Dynamics 365 Cloud using Scribe and KingswaySoft tools

Built POCs, demonstrated solution to stakeholders, created efforts estimation and wrote SOWs

Partnered across teams to ensure the Dynamics 365 solution fit in with broader application architecture and aligned with Enterprise Architecture

Created documentation of entire CRM ecosystem, used for cross-training and on-boarding

Designed and implemented self-service business reporting capabilities within the organization, maximizing technical resources by enabling business users to define and execute individual reporting parameters

Automated external data processing functions and incorporated various data sources into integrated data warehouse infrastructure using SQL Server Integration Services

Designed Cubes, Dimensions, Measures, KPIs on Data Warehouse Infrastructure using SQL Server Analysis Services

Created a Data Dictionary and BI metadata repository providing users across the organization with expanded tools, data and reporting resources to warehouse and access internally and externally generated data

Developed and delivered a comprehensive BI training program to provide end-users the understanding and knowledge of BI infrastructure, database technologies and reporting tools

Provided consultation on Cloud Advanced Analytics Tools like Azure Data Lake Gen 2, Azure Data Warehouse, Azure Data Bricks, Azure Data Factory, Azure Analytics and Machine Learning Studio for Predictive Analysis

Environment: Power BI Premium, Power Apps, MS Dynamics 365 Customer Engagement, On-premise/Online, SQL Server & Azure

Mar ‘13 – Feb ‘18 Solutions Architect, Bitscape Infotech Pvt. Ltd, Gujarat, India

The goal of this project was to implement CRM and SharePoint integration for the Document Management System, including customizations to forms, plugins, workflow processes, custom workflow activity to create SharePoint site and document libraries dynamically. We implemented Dynamics CRM Online for New/Repeat Customer scenarios, managing store visits, reminders for follow-up, Monitor Sales & Stock, and Input Customer Feedback Surveys, and created workflows, plug-ins, personalized views and dashboards, and integrated Power BI for reporting purposes and SharePoint Online for document management.

Communicated with client/prospects to understand business requirements, prepare POC on Trial Environment and demonstrate MSCRM solution capabilities

Conducted Business Process Analysis, prepared proposals and estimations with presales team

Created solution design to address client requirements

Identified out of the box functionality to minimize custom development

Prepared business cases

Facilitated Dynamic CRM application development, customization, advanced customization using Dynamic CRM SDK, MS SQL Server development, administration, MS SharePoint integration, application development using asp.net, C#

Analyzed datasets and generated statistical reports using SAS

Designed Business Analytical Reports in Power BI and Datazen tools

Led and manged project resources, interacted with clients, coordinated and worked in achieving high levels of productivity and efficiency in complex, dynamic and challenging environment using CMMI method or an iterative method of SDLC (Agile Development)

Conducted analysis of provided requirements and experience with process/data modelling using Microsoft Visio for preparing data flow and cross functional diagrams

Designed and developed multi-tier and MVC Applications based on .NET framework (4.5/4.0/3.5) and MS SQL Server (2014/2012/2008 R2)

Implemented Web Service, WCF and REST service, which communicate data in a both XML & JSON

Designed UI and scripting using XHTML, HTML5, Advanced CSS, Java Script, JQuery library, prototype.js library, ASP.NET AJAX Control Toolkit

Implemented Azure PaaS features like SQL Data sync, Media Service, Service Bus, Azure Search, Mobile Service, Cloud Service, Website etc.

Designed relational database, data modelling, query optimization and implementation of database objects like tables, views, stored procedures, functions and triggers using MS SQL Server

Developed Integration Services Packages (SSIS) to import-export data between different data sources, multi-dimensional or tabular data models (SSAS) by defining measures and fact tables as per the required parameters

Deployed analytics reports (SSRS, Power Pivot, Power View, Power BI) on SharePoint Site

Customized CRM Entities (MS Dynamic CRM Online and On-Premise), custom workflow activities and plug-ins

Trained and mentored team members with product knowledge and business processes

Prepared presentations for clients and deployment guideline documents with user manual of the reports

Supervised maintenance, mirroring, backup, performance tuning and escalated issues

Environment: Power BI, Dynamics 365, SQL Server, SharePoint & Azure

Aug ‘10 – Feb ’13 Software Engineer, eClinicalWorks India Pvt. Ltd., Gujarat, India

In this project I worked as part of the development team for Patient Portal, EHR system Progress notes and Reporting, electronic health records and processing claims using the billing process.

Worked on developing applications and maintenance of products in Microsoft Technologies

Supported client team during production issues and system outages and resolved issues in pre-production and production

Conducted analysis of requirements, worked with clients and addressed the gaps in requirements, formulated design for the product/individual modules, and tracked tasks through closure

Developed various feature enhancements for the EMR Project ASP.NET (C#), MYSQL web application

Developed the claims handling website that tracks/reports claims, transactions and other claims-related data

Developed a processing engine and client-server application used to route, translate, and process submitted policy data-files

Analyzed needs and expectations, evaluated information, used experience in forming opinions, evaluated the benefits of alternative solutions and their impact to determine the most appropriate course of actions to achieve goals

Used a systematic approach for process improvement, for evaluating current business processes and developing and implementing

Integrated solutions, maximized customer satisfaction and delivered bottom line results

Environment: SaaS service, ASP .Net, C# .Net, Javascript, IBM Cognos Reporting

Jul ‘07 – May ’10 Associate Software Engineer, Allscripts India Pvt. Ltd., India

In this project I was a member of the research and development team, supporting Patient Financial Management Product and solving HL7 interface, and billing module tickets.

Environment: Cache Programming, UNIX, C++

Contact this candidate