Design Sql Server

Location:

Philadelphia, PA

Posted:

April 15, 2019

Contact this candidate

Resume:

TAPAN KUMAR MOHAPATRA

704-***-****

********@*****.***

Linkedin : https://www.linkedin.com/in/tapan-mohapatra-7a4b6311/

Skype : RTAPANKM123

Professional Summary:

•I have experience in Analysis, Design, Architecture, Development, Testing and Implementation of various projects in Microsoft Dynamics CRM Technologies.

•Proficient experience in Designing, Architecture, Developing Cloud Based, On Premises, and Web based and windows based applications using Microsoft Dynamics CRM and .Net 1Framework.

•Proficient in Microsoft Dynamics 365, CRM 2016, 2015, 2013, 2011 and 4.0 Coding, implementation, Deployment and Installation, Publishing, Plugins, Customizations, Custom Work Flows, Security Roles, Privileges.

•Proficient in Coding, Development, Testing and Deploying of CRM Dynamics Customizations, CRM SDK Plugins, Custom Workflows, Business Process, Actions, Sub grids, Dialogs, Web Resources, Client Extensions, Ribbons, Reports, Mobile Apps development.

•Proficient in Microsoft Dynamics CRM/XRM 365 (both on-line cloud and on premise), creating Web Services using SOAP and ODATA REST API, Web API, .Net Framework, java script and XRM Page model, MS Dynamics CRM SDK application development and creating custom plug-ins.

•Proficient in Office 365, Active Directory, SharePoint, creating reports using SSRS, Fetch XML, SQL

•Proficient in Kendo UI Teleriks, JQuery, SOAP, REST ODATA web service, XRM, Java script, Business Rules by Process Flows, Rollup and Windows Server, Exchange Server, SharePoint Server 2010.

•Proficient in Microsoft Power BI Reporting Tool on Cloud and Desktop.

•Proficient in Dynamics CRM 365 cloud server Configuration, Copy, Backup and Restore and Global Admin on Microsoft Office365 and managing users.

•Proficient in ASP.NET Web API 2.0 with MVC4, MVC5

•Proficient in C#.Net, Web API, JQUERY, HTML5, SOA, SDLC, MS Build, Team foundation Server TFS

•Proficient in Microsoft Windows Communication Foundation (WCF) and Proficient in web application development using Entity Framework 4.5, MVC4, MVC5, JQuery, CHTML, HTML5, ODATA, JSON, Knockout.js and Web API controllers.

•ADX Studio Portal CRM Web Application Development

•ADX Portal Development, creating webpage, entity form, web form, entity list, subgrid, web form steps, metadata configuration, web role, entity permission, webfiles, webcopy tool, alm tool.Experience in Veeva CRM and Salesforce.com CRM.

•Experience in Tableau Report in Desktop and Cloud implementation.

•Well verse with latest Dynamics 365 features like Text Wrapping, Multi-select fields, Security enhancements, Microsoft Flow, Virtual Entities, Customer Engagement Portal, LinkedIn integration, Editable Grids, Outlook App, Relationship Insights (Preview Feature), Relevance Search, Web Portals, Customer Field on Custom Entities, Social Engagement, Organization Insights Dashboards, One Click Document Generation, Excel Templates, OneNote integration, Improved Search, Hierarchy Visualizations, Product Family Enhancements, Calculated Fields, Rollup Fields, Improvements to Business Rules, Branching Logic for Guided Processes, Hierarchy Security Profiles, Field level security.

•Proficient in SQL Server 2012, 2015 writing Stored Procedures, efficient query designing using SQL Server 20012/ 2015.

•Proficient in SQL Server 2015 Reporting Services (SSRS)

•Proficient in SQL Server 2015 Integration Services (SSIS)

•Proficient in SQL Server 2015 Analysis Services (SSAS)

•Proficient knowledge in Kingsway soft (SSIS), SCRIBE Data Integration.

•Proficient knowledge in SharePoint Server 2010

•Reporting Tools: SSRS reporting tools, Crystal Report

•Design Patterns: UML, Infragistics Net Advantage 2012v1, Microsoft Enterprise Library 3.0

•Source Safe: TFS, SVN Version Control, VSTS Framework, MS Visual Source Safe, Serena-PVCS

•Designing Tools : Visio-2010, ER Win, Rational Rose

•Database Tool: SQL Query Analyzer(Sql Server),Toad (for Oracle), QMF (for DB2)

•Project Management : MS Project 2010, Version One -- Agile project development tracking Tool

•Code Review Tool : FXCOP, Beyond Compare, Anthill Build 2004, Fiddler2 Debugger.

•IDE Tools : Visual Studio 2012, C++ Builder, Developer Express, Kendo UI Teleriks

•Testing Toll: NUnit, SQUID, TDD.

•FTP/SFTP Tool : SecureFx Meeting Conferencing: Skype for Business, Microsoft eMeeting Tool

Educational Qualification:

Bachelor of Engineering, Electronics and Communication, Karnataka, India

Additional Skills Summary :

•Fully conversant with Software Development Life Cycle methodologies, Estimation, Architecture Design, Application Development, Database Design and Testing using Agile, Waterfall, XP, Scrum methodologies.

•Excellent aptitude to understand and meet client needs, a special ability to develop and foster relationships, a wide management experience in all phases of application systems development and excellent analytical and technical skills.

•Fully conversant with Creational Patterns (Singleton Pattern) and implemented Structural and Behavioral design patterns.

•Commendable Estimation, Planning, Execution and Monitoring skills.

•Well versed in Configuration Management and Quality Assurance activities.

•Excellent Analytical, Development, Written, Communication skills, Quick learner and Excellent Team Leader

•Certificate in Health Insurance Domain Knowledge (E1 Certified)

Clients & Industry Focus:

•United Biosource Corporation

•Valeant Pharmaceuticals

•SPS Communication

•DOITT

•DFC Global

•ESPN

•Thomson Reuters

•Knowles Corporation

•GAF Materials

•Wells Fargo Bank

•HUMANA Health Insurance

•CUNA MUTUAL GROUP

•HANOVER Auto Insurance

•ONEBEACON Auto Insurance

•Gateway.com ecommerce

•Descartes System Group

•Banking Finance Industry, HealthCare Insurance, Auto Insurance, Financial Services Management

•ecommerce B2B and B2C Application Management

•Mobile Technologies, Wireless and Telephony and Embedding Technology

•LED Display board and LED TV manufacturing

United BioSource Corporation, Bluebell,PA May 2018 – Till date

Sr Software Consultant in Architect,Design,Develop Ms Dynamics CRM,.Net Framework, Kendo UI, Web API

Project Name: - ARCS Migration Process

United BioSource Corporation(UBC) is a leading provider of pharmaceutical support services, partnering with life science companies to make medicine and medical products safer and more accessible.Dedicated to Global Product Safety, Brand Loyalty, and Patient Access Strategies that Support the Full Product Lifecycle.

Responsibilities:

•Providing latest Technical Architect, Design and best feasible solutions in MS Dynamics CRM 2016 on premises business oriented solution using latest CRM tools and techniques.

•Developing Custom Plugins, Custom Work flows, .Net Framework, CRM SDK, and Web API.

•Developing CRM application using SOAP and REST ODATA API web services, Windows Application, Console Application.

•using Dynamics CRM Creating Teams, User Roles, managing Teams, managing Users and User Roles and Privileges.

•Developing CRM Dynamics Customizations, Plugins, Custom Work Flows, and Defining, developing the business processes and creating new actions, Synchronous, Asynchronous Custom Workflows, Dialogs, Security Roles and Privileges.

•Developing, publishing and deploying POWER BI, SSRS Reports and CRM Plugins using Plugin Registration tool, Designing and defining Entities customization, their Relationships and defining Entity Data Model, Coding, Testing and Deploying CRM Dynamics Customizations to QA, UAT,PROD.

•Developing robust architecture design and extensible functionality, developing and deploying Web Resources, Client Extensions, Command Bars and Ribbons, Implementing changes in CRM workflows, processes and User Interface based on business requirements.

•Data Architecture and Relational Data model and Data Integrity, Designing and developing integration solutions for backend services

•Identifying creative solutions to meet system/business requirements.

•Deployment of Managed and Unmanaged Solutions in MS Dynamics CRM 365 using MS Build and TFS.

•Restructuring relationship of Entity Data model to improve performance.

•Implementing Duplicate Detection rules and improving Data Quality in CRM.

•Implementing the required classes and implementing OOAD coding technique

•Implementing well define reusable methods and properties for classes

•Implementing coding standards to be followed to code in .net language and stored procedures

•Implementing Business Logic and required stored procedures using SQL and Fetch XML

•Writing efficient stored Procedures, functions

•Creating reusable Web Services and deployment of components

•Understanding the business requirement,participate in business discussion and meeting

•Developing application using Microsoft Dynamics 2016 on Premises .Net Framework, MVC 4,5,6, Kendo UI Telerik, Web API, JQuery, Javascript, CHTML, HTML5, CSS3, ODATA, JSON, Custom CRM SDK Plugins, Custom Workflow Activities, developing .Net Web services and windows services, Console Applications using Web API 2.0, EntityFramework4.5, C#.Net, SOA, SDLC, MS Build, TFS, SQL Server 2012/2015, Visual Studio 2013/15,XML, XSD, XAML, XSL, WCF, Web Service, Ajax, JavaScript, LINQ, Design Patterns, MVC, MVP, MVVM, Enterprise Library, GUI design, OOD, OOP, .NET Remoting, IIS, Power BI, SSRS, SSIS.

BAUSCH+LOMB Pharmaceuticals, Bridgewater, NJ Jan 2017 – April 2018

Sr Software Consultant in Microsoft Dynamics Dynamics 365, .NET Framework, SQLServer, Power BI, SSIS

Project Name: - Call Plan Processing for Prescribers

Valeant Pharmaceuticals International, Inc. is a multinational, specialty pharmaceutical and medical device company anchored by a collection of world-class franchises. Valeant develops, manufactures and markets a broad range of branded, generic and branded generic pharmaceuticals, over-the-counter (OTC) products and medical devices, which are marketed directly or indirectly in more than 100 countries.

Responsibilities:

•Providing latest technical Architect, Design and best feasible solutions in MS Dynamics CRM 365 business oriented solution using latest CRM tools and techniques.

•Understanding the business requirement of Prescriber Maintenance, Call Plan Processing, and Sales Operations. Providing Architect, Design, Develop and Deploy Microsoft Dynamics CRM 365 custom Solutions.

•Deployment of Managed and Unmanaged Solutions in MS Dynamics CRM 365 using MS Build and TFS.

•Developed Call Plan Process between Prescribers and Sales Reps using Custom Plugins, Custom Work flows, .Net Framework, CRM SDK, and Web API.

•Created Demographic File generation for Prescribers using Custom Work flows, .Net Framework, CRM SDK, Web API.

•Created Sales Rep Roster import Process using CRM SDK, CRM custom Plugins and Custom Workflows

•Created Call Plan, Targeting, Zip Territory, Deciles import process using .Net Framework, Custom windows applications, CRM SDK and Web API.

•Created Call Plan Integration process using SOAP and REST ODATA API web services, Windows Application, Console Application, using Dynamics 365 Creating Teams, User Roles, managing Teams, managing Users and User Roles and Privileges.

•As a Global Dynamics CRM Administrator managed the server instance configuration, copy, Backup, Restore, install Service Pack and Rollup updates and created, managed new users.

•Created Call Plan Analysis Quarterly reports and Dash Board reports, KPI using POWER BI, SSRS reporting Tool.

•Developing CRM Dynamics 365 Customizations, Plugins, Custom Work Flows, and Defining, developing the business processes and creating new actions, Synchronous, Asynchronous Custom Workflows, Dialogs, Security Roles and Privileges.

•As subject matter expert on architecture techniques and designed detail Technical work flow process. Data Architecture and Relational Data model and Data Integrity, Designing and developing integration solutions for backend services, Identifying creative solutions to meet system/business requirements.

•Creating a robust plan for implementing enhancements to the CRM system that will streamline processes

•Developing application using .Net Framework, MVC 4,5,6, Web API, JQuery, CHTML, HTML5, CSS3, ODATA, developing .Net Web services and windows services using Web API 2.0, EntityFramework4.5, MVC 4, MVC 5, JQuery, CHTML, HTML5, CSS3 and C#.Net, HTML5, SOA, SDLC, MS Build, TFS, SQL Server 2012, Visual Studio 2013,XML, XSD, XAML, XSL, WCF, Web Service, Ajax, JavaScript, LINQ, Design Patterns, MVC, MVP, MVVM, Enterprise Library, GUI design, OOD, OOP, .NET Remoting, IIS.

SPS - Strategic Products and Services, Parsippany, NJ July 2016 --- Jan 2017

Sr Software Consultant in Architect,Design,Develop Ms Dynamics CRM,.Net Framework, SQL,Web API

Project Name: - Connect

The focus of company is customer success achieving outcomes with communication, collaboration and connections across all environments. Decades of investment in our people, process and leading technologies have resulted in offerings for our customers to realize their objectives. ConvergeOne’s expansive portfolio and world class expertise have received numerous awards by our technology partners.

Responsibilities:

•Providing latest technical Architect, Design and best feasible solutions in MS Dynamics CRM 2013, 2015 business oriented solution using latest CRM tools and techniques.

•Understanding the business requirement and architect, design, develop and deploy Microsoft Dynamics CRM 2015 Solutions to different environment like QA, UAT and Production.

•Deployment of Managed and Unmanaged Solutions in MS Dynamics CRM 2015 using MS Build and TFS.

•Developing CRM Dynamics 2015 Customizations and Plugins, Custom Work Flows.

•Defining, developing the business processes and creating new actions.

•Developing Synchronous, Asynchronous Custom Workflows, Dialogs, Security Roles and Privileges.

•Developing deploying Web Resources, Client Extensions, Command Bars, Ribbons and Site Maps.

•Developing, publishing and deploying SSRS Reports and Plugin Registration tool.

•Designing and defining Entities customization, their Relationships and defining Entity Data Model.

•Coding and deploying CRM Dynamics Customizations and Plugins.

•Coding and deploying Workflows, Dialogs, Security Roles and Privileges.

•Restructuring relationship of Entity Data model to improve performance.

•Implementing Duplicate Detection rules and improving Data Quality in CRM.

•Developing .Net Windows service and web services using Web API, EntityFramework4.5, MVC 4, JQuery, CHTML, HTML5, CSS3 and ODATA, C#.Net, Kendo UI, HTML5, SOA, SDLC, MS Build, TFS, SQL Server 2012, Visual Studio 2013XML, XSD, XAML, XSL, WCF, WWF, WPF, Web Service, JQuery, WSDL, Ajax, JavaScript, LINQ, Design Patterns, MVC, MVP, MVVM, Enterprise Library, GUI design, OOD, OOP, .NET Remoting, IIS.

•Developing, Publishing and Deploying SSRS Reports

•Developing application using EntityFramework4.5, MVC 4, JQuery, CHTML, HTML5, CSS3, ODATA

•Used Serena Agile Planner Tool

DOITT, New York City, NY Nov 2015 --- June 2016

Sr Software Consultant in Microsoft Dynamics CRM, NET Framework, SQL Server, ADX Portal, SSIS, SSRS

Project Name: - New York City Housing Recovery

The New York City Housing Authority (NYCHA) provides housing for low- and moderate-income residents throughout the five boroughs of New York City. NYCHA also administers a citywide Section 8 Leased Housing Program in rental apartments. Many of its facilities are known popularly as "projects," or "developments."

Responsibilities:

•Providing latest technical Architect, Design and best feasible solutions in MS Dynamics CRM 2013, 2015 business oriented solution using latest CRM tools and techniques.

•Understanding the business requirement and architect, design, develop and deploy Microsoft Dynamics CRM 2015 Solutions to different environment like QA, UAT and Production.

•Deployment of Managed and Unmanaged Solutions in MS Dynamics CRM 2015 using MS Build and TFS.

•Developing CRM Dynamics 2015 Customizations and Plugins, Custom Work Flows.

•Developing ADX Portal components. Creating, Configuring Master Pages, Custom Views, Grids in ADX Portal

•ADX Portal Development, creating webpage, entity form, web form, entity list, subgrid, web form steps, metadata configuration, web role, entity permission, webfiles, webcopy tool, alm tool.

•Writing Custom Plugins to do CRUD operation on linked entity in ADX Portal.

•Integrating ADX Portal and Dynamics CRM using CRM Web Services and Custom Plugins