Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
Celina, TX
Posted:
March 28, 2024

Contact this candidate

Resume:

SUMMARY

Around ** years of experience on Microsoft Dynamic CRM 4.0,2011, 2013, 2015, 2016, Dynamics 365, .NET and SQL Server, SSIS, SSRS, Azure, CI/CD.

Good Hands-on experience in Customizing Dynamics 365 application like Dataverse Tables, Views, Web resources, Ribbon, Chart, configuration and customizations.

Good Experience in Dataverse Security Model.

Hands on experience working on Power Platform technology stack including Canvas Apps, Model-Driven Apps, Power Automate, Omnichannel for customer service, Customer Voice, and Virtual Agents.

Implemented good no.of plugins, custom workflows & Actions.

Experience working with PCF Components and enhancing the UI on the CRM form.

Good Hands-on experience in Power automates, Azure Logic Apps, Web jobs & Azure Functions.

Proficient in Microsoft Power Apps, Power Automate (Flow), with hands-on experience in designing and developing solutions using these tools.

Developed custom Power Apps canvas apps and model-driven apps to address specific business needs, improving data management and user productivity.

Designed and automated complex workflows using Power Automate, reducing manual tasks and streamlining business processes.

Experience in working ADF pipelines for Data Migration.

Experience in working Yaml pipelines for CRM deployment.

Experience working in CI/CD pipelines.

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.

Good Knowledge in MS CRM Functional Side.

Working knowledge of MS Windows Server, Active Directory, ADFS.

Experience in working with Azure related technologies.

Experience in working in Telecom, Mortgage, Health, and Insurance and Retail domains.

Experience working State projects.

Experience in translating requirements into solutions with proper dependencies and preparing strategic development plan in MS CRM.

Experience in Team Foundation Server (TFS) code repository.

Proficient in designing and deploying Plug-in and Workflows in CRM to meet business process flow requirements, including Sales, marketing, customer services support, using CRM SDK and C#.NET.

Expertise in developing windows applications, web applications, windows services and web services in Microsoft Visual Studio.

Expertise in client side development using HTML, JavaScript, CSS, ADO.NET and

ASP.NET

Experience in importing/exporting data between different sources like Oracle/Access/Excel using

SSIS/DTS utility.

Experience in ETL processes involving migrations and in sync processes between two databases

Experience in Microsoft Dynamics CRM Data integration towards import/export of data using SSIS and custom application development.

Have good experience of SSRS (SQL server reporting services) reports.

Hands on Experience on building Daily Packages using SSIS.

Proficient in JSON, ODATA, IIS 6.0/7.0.

Hands on experience in agile and scrum methodologies along with project management systems.

Experience in fostering and developing client relations, providing end user training and innovative technical solutions, conducting software demonstrations.

Expertise in writing SSIS (SQL Server Integration Services) packages for migrating data to MS CRM from SQL and generating reports using SSRS and also experience in configuring MS CRM with MS Outlook and SharePoint Integration.

Experience in several custom dashboards with various degrees of complex visualizations using charts and reports.

Experienced with SQL server 2008, SQL, TSQL, stored procedures, Functions, Triggers, Backup and Restore.

Experience in Full cycle implementations and up-gradations in Dynamics CRM 2011, 2015, 2013.

Experience with integration and functional testing, SCRUM methodologies and Sprints.

Excellent communication, analytical and interpersonal skills.

Quick learner and adaptive to new and challenging technological environments.

Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

Worked with report manager for deploying the reports across all the environments.

Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.

Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.

Ability to establish priorities and work independently.

TECHNICAL SKILLS:

CRM Tools

Dynamics 365 Online & On-premise, MS Dynamics CRM 2016,2015, 2013, 2011,4.0`,Power Apps, Power Automates, Azure ADF, Data Lake.

Reporting Tool

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Azure Data Factory Pipelines

.NET Technologies

MS Visual Studio 2010 & 2012, MS office.

Programming Language

C#.NET, ASP.NET.

Other Technologies & Tools

HTML, CSS, Java Script, XML, Fetch XML, JSON and ODATA, Web Services, WCF, Power shell 2.0, Share Point 2010, TFS (Team Foundation Server), TFS CI/CD, SCRUM Process, GIT

Databases

MS-SQL Server 2008R2/12, Microsoft Dynamics Data Migration Tool(Kingsway soft)

EDUCATION:

Bachelor of Technology - Computer Science and Engineering, Bapatla Engineering College, Bapatla, Andhra Pradesh, India.

Master of Technology - Computer Science and Engineering, Bapatla Engineering College, Bapatla, Andhra Pradesh, India.

AWARDS and RECOGNITIONS:

Received star performer award and received applauds from Ericsson Customers in TCS.

Received On the spot award in team for solving the typical scenarios in the Police Mutual project.

Got performer of the batch award in the ILP training conducted for new joiners in TCS.

CERTIFICATIONS:

·Microsoft Dynamics CRM 2011 Customization and Configuration (MB2-866) on June-27, 2013

·Microsoft Dynamics CRM 2013 Customization and Configuration (MB2-703) on Dec-08, 2014

PROFESSIONAL EXPERIENCE

Client: Mr. Cooper

Dallas, TX

SEP 2023- Till Date

MSCRM Lead Developer

Responsibilities:

Involved in requirement gathering sessions, design walkthrough meetings with customer to understand new business requirements and discuss the concerns, issues raised during review phase.

Customized Dynamics 365 application based on the business requirement.

Worked on Model-Driven Apps & Power Automate, Customer Voice, and Virtual Agents.

Configured Chat Widgets, Bots in Power Virtual Agent.

Developing plug-ins and workflows as per requirement for enhancing the system and maintaining data integrity.

Customizations using java script with respect to CRM. Advanced validations of form data using script. Mapping functional system requirements to Dynamics CRM capabilities and design appropriate solutions.

Created multiple Dataverse Tables, Columns, Business Rule, Views & Relationships.

Configuring security roles, business units, teams, field security profiles in Dataverse Security Model.

Worked on REST API and CRM plugins.

Implemented good number of power automate flows based on requirements.

Worked on data integration towards import/export of data using custom application development. Experience in use of web services and interacting with MS CRM database using web service methods.

Created Model driven apps, Azure Functions to integrate with other systems

Worked on SLA’s and end to end Case Management flow.

Experience in analysis, design, development, and deployment of software solutions.

Created Model driven apps & good hands-on Case Management.

packages to ADF pipelines.

Worked on azure pipelines to move solutions from power platform to different environments.

Working experience with Microsoft support for any issues related to CRM environment.

Implemented different PCF control to enhance UI on CRM forms.

Client: Baylor Scott & White

Dallas, TX

JUN 2020– AUG 2023

MSCRM Lead Developer

Responsibilities:

Involved in requirement gathering sessions, design walkthrough meetings with customer to understand new business requirements and discuss the concerns and issues raised during review phase.

Experience in analysis, design, development, and deployment of software solutions.

Customized Dynamics 365 application based on the business requirement.

Created Model driven apps, Azure Functions, Case Management.

Created multiple Dataverse Tables, Columns, Business Rule, Views & Relationships.

Configuring security roles, business units, teams, field security profiles in Dataverse Security Model.

Worked on REST API and CRM plugins.

Worked on Power automates, Azure Logic Apps, Web jobs & Azure Functions.

Worked on Microsoft Power Apps, Power Automate (Flow).

Developed custom Power Apps canvas apps and model-driven apps to address specific business needs, improving data management and user productivity.

Designed and automated complex workflows using Power Automate, reducing manual tasks and streamlining business processes.

Developing plug-ins and workflows as per requirement for enhancing the system and maintain data integrity.

Implemented ADF Pipelines, SSIS packages to bring the data from other system into CRM.

Customizations using java script with respect to CRM. Advanced validations of form data using script. Mapping functional system requirements to Dynamics CRM capabilities and design appropriate solutions.

Configuring security roles, business units, teams, field security profiles, call outs to CRM API, and CRM plugins.

Implemented good number of power automate flows based on requirements.

Integrating CRM with Call Rail & Marketo.

Providing out of box CRM Api’s to other system to interact with CRM.

Moving SSIS packages to ADF pipelines.

Worked on Plugins, Workflows, MS Flows.

Worked on Azure Devops, CI/CD pipelines.

Implemented SSIS data import to get legacy data into the current system.

Leading Offshore team with debugging issues and delegating tasks.

Worked on Azure technologies such as WebApps, Functions, LogicApps, Data Gateways and Service Bus.

Client: Mr. Cooper

Dallas, TX

MAR 2020 - JUN 2020

MSCRM Lead Developer

Responsibilities:

Involved in requirement gathering sessions, design walkthrough meetings with customer to understand new business requirements and discuss the concerns, issues raised during review phase.

Customized Dynamics 365 application based on the business requirement.

Developing plug-ins and workflows as per requirement for enhancing the system and maintain data integrity.

Created multiple Dataverse Tables, Columns, Business Rule, Views & Relationships.

Configuring security roles, business units, teams, field security profiles in Dataverse Security Model.

Worked on REST API and CRM plugins.

Customizations using java script with respect to CRM. Advanced validations of form data using script. Mapping functional system requirements to Dynamics CRM capabilities and design appropriate solutions.

Configuring security roles, business units, teams, field security profiles, call outs to CRM API, and CRM plugins.

Implemented good number of power automate flows based on requirements.

Worked on data integration towards import/export of data using custom application development. Experience in use of web services and interacting with MS CRM database using web service methods.

Created Model driven apps, Azure Functions to integrate with other systems

Worked on SLA’s and end to end Case Management flow.

Experience in analysis, design, development, and deployment of software solutions.

Created Model driven apps & good hands-on Case Management.

Designing Solution, Customization & Configuration, etc.

Involved in story discussion with Business System Consultant and Client to create stories for each Sprint.

Building the CRM forms, dashboards, JavaScript, and views, as well as workflows and reports.

Customizing CRM Sitemap area and applied button functionality through Ribbon workbench tool.

Creating custom workflows, Business Rules, Business Process Flows in CRM

Experience in integrating third party API using Power Automate.

Responsible for creating views, forms, attributes, Dataverse Tables, etc.

Worked on Kingsway Soft for migrating data to MS CRM and worked on Shift and lifting SSIS packages to ADF pipelines.

Worked on Data export service to sync data between CRM and Azure SQL DB.

Working experience with Microsoft support for any issues related to CRM environment.

Client: AgFirst Farm Credit Bank

West Columbia, SC

Nov 2019 – MAR 2020

MSCRM Lead Developer

Description:

The Farm Credit System is a federally chartered network of borrower-owned lending institutions and related service organizations, exclusively dedicated to supporting agriculture. It provides Lending and IT Services to 21 Associations.

Responsibilities:

Involved in requirement gathering sessions, design walkthrough meetings with customer to understand new business requirements and discuss the concerns, issues raised during review phase.

Experience in analysis, design, development and deployment of software solutions.

Customized MS Dynamics CRM 365 application based on the business requirement.

Created multiple Dataverse Tables, Columns, Business Rule, Views & Relationships.

Configuring security roles, business units, teams, field security profiles in Dataverse Security Model.

Worked on REST API and CRM plugins.

Working knowledge of MS Windows Server, Active Directory, ADFS.

Requirement gathering and preparation of requirement document for sign off.

Leading Offshore team with debugging issues and delegating tasks.

Construct/Modify ASP.Net pages and WCF services

Construct/Modify SQL procedures, jobs.

Construct SSIS packages to integrate with external systems using Kingswaysoft/ CozyRoc.

Created SSRS reports.

CI/CD Pipeline to automate deployments.

Worked on Azure technologies such as WebApps, Functions, LogicApps, Data Gateways and Service Bus.

Implemented PowerBI Reports for business.

Work across functional (development/testing, deployment, systems/infrastructure) and project teams to ensure continuous operation of build and test systems

Development of automation systems to increase the team’s performance and quality

Perform database backups and restores

Provide timely communications on significant issues

Perform maintenance and troubleshooting of continuous build/deployment systems

Contribute to an atmosphere of cross-functional teamwork within the organization’s emerging Agile delivery lifecycle. Customized Sale module and entities of leads, account, contact and opportunities according to the business process.

Import and export data within MS Excel and MS Dynamics CRM.

Fix customizations, scripts

Ensure the business functionalities are carried forward

Implemented Plugins, Workflows in CRM.

Client: Department of Buildings

Broadway, New York

Jan 2016 – Nov 2019

MSCRM Lead Developer

Description:

Department of Buildings, NYC: DOB NOW provides robust onIine accounts making easier to submit applications, make appointments, schedule appointments, check the status of an application or inspection, puII permits and make renewals.

Responsibilities:

Involved in requirement gathering sessions, design walkthrough meetings with customer to understand new business requirements and discuss the concerns, issues raised during review phase.

Experience in analysis, design, development and deployment of software solutions.

Requirement gathering and preparation of requirement document for sign off.

Preparation of use cases and process flow diagrams.

Installation of Microsoft Dynamics® CRM 2016 On-Premise.

Developed FetchXML & SQL based SSRS reports.

Designed and developed complex business flows in MSCRM using plugins and asynchronous workflows.

Worked on upgrading CRM 2016 to CRM 365.

Custom JavaScript on form events, and add web resources, navigation links to achieve the business requirements.

Developed good number of plugins on appropriate entity events, workflows.

Hands on experience in MS CRM deployments.

Lead technical efforts to configure, develop and customize CRM as appropriate to support foundational CRM components. Works closely with developers to build out custom CRM functionality as necessary.

Analyze technical requirements and develop effective technical solutions.

Designed and developed custom solutions such as plugins, workflows, and custom entities.

Implemented Microsoft CRM form development using JavaScript and reports with Microsoft SQL Server Reporting Services.

Customized Dashboards based on the custom reports and charts created.

Worked with Rest, Soap calls to CRM service in 2016.

Migrated data from Excel source to CRM using SSIS.

Created several client-side extensions using JavaScript, CSS and HTML.

Implemented stored procedures/ complex queries using SQL Server and on SSIS packages.

Worked on CRM entities, workflows, configurations, customization development, and integrations development.

Worked on setting up relationship between System & Custom entities

Used extensively JavaScript for client side validations and access data within the HTML controls.

Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM 2016 system.

Installed and configured MS Dynamics CRM 2016 system for development and testing, configured server instance, created organizations.

Hands-on background in Visual Studio, XRMToolBox, and CRM SDK

Plugin development for Microsoft Dynamics CRM applications.

Working on upgrade of CRM from CRM 2016 to Dynamic 365.

Hands on experience on integration using SSIS with external systems.

Good knowledge on Model driven apps and Microsoft Flows.

Client: Accenture/Police Mutual

Liverpool, United Kingdom

July 2014 - AUG 2015

MSCRM Developer

Description: Police Mutual is a mutual society, dedicated to help and Serve Retired Police Officers, Police Staff and their families with their financial wellbeing. Application works on MS CRM 2011, Unified Service Desk, MS SQL Server 2008, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS Visual Studio, and MS Office.

Responsibilities:

Involved in requirement gathering sessions, design walkthrough meetings with customer to understand new business requirements and discuss the concerns, issues raised during review phase.

Experience in analysis, design, development and deployment of software solutions.

Customized MS Dynamics CRM 2013 application based on the business requirement

Created organizations, business units, groups and their relationships

Developed good number of plugins and familiar with plugin pipeline.

Created Custom Entities, Custom attributes for individual business units in MS Dynamics CRM 2013, according to their business process

Created several client-side extensions using JavaScript, CSS and HTML.

Migrated data from Excel source to CRM using SSIS.

Created and customize reports in the system by using SQL Server Reporting Services (SSRS) to provide data for demand planning and opportunity management

Integrated with SSRS to support reporting, data analysis, and business planning.

Customized Workflows and Plug-in for automated processes, based on requirement from sales and marketing department to increase visibility and efficiency.

Created SSIS packages for different data loading operations for many applications.

Used CRM web service and developed a custom service using WCF to provide extended functionalities to the common methods of CRM

Configuration of MS Dynamics CRM with Microsoft Outlook 2013.

Integrated Custom WCF Service with other applications

Used Advanced Find feature of MS Dynamics CRM 2013 and created multiple views of System entities

Generated Sales Reports for statistical analysis of data at user level using SSRS.

Customized Dashboards based on the custom reports and charts created Used Visual studio test project and performed unit testing.

Document management with SharePoint integration.

Good knowledge in writing stored procedures/ complex queries using SQL Server and on SSIS packages.

Use of Rest, Soap calls to CRM service in 2013.

Enhanced and developed Business Process Flows as per the client needs.

Client: Ericsson, TCS, India

OCT 2011 – Jul 2014

.Net & MSCRM Developer

Description:

Ericsson is using CRM360 application to manage the global Sales Process by providing a process workflow throughout all sales stages from Opportunity Identification to Contract Management, including Sales Methodology. CMR360 Application works on MS CRM 4.0/2011, MS SQL Server 2008, MS SQL Server Reporting Services, MS SharePoint 2010, MS SQL Server Integration Services, MS Visual Studio, and MS Office.

Responsibilities:

Installed and configured MS Dynamics 2011system for development and testing created organizations.

Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM 2011 system.

Gathered client requirements and business process, development, testing and deployment of Microsoft CRM projects.

Implemented good number of plugins using C#.Net Framework.

Customized CRM Forms, Entities, Attributes, Security Roles, Views, Ribbons & Sitemaps to extend the functionality and to meet the client requirements

Created Security Roles based on requirements from business.

Used various report items like tables, sub report and charts to develop the reports in SSRS.

Created Workflow based on requirements from Sales and Marketing department.

Designed and built DTS/SSIS packages and ran several scripts for implementing changes in the backend for applications.

Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.

Experience in writing stored procedures/ complex queries using SQL Server and on SSIS packages.

Use of Rest, Soap calls to CRM service.

Designed a plug-in to generate account number on create of new record.

Developed UI interface using HTML, Java Script, and CSS.

Generated Sales Reports for statistical analysis of data at user level using SSRS.

Designed and developed windows Applications using C#.

Designed the Front-end screens using C#, CSS and JavaScript.

Used ADO.NET to connect to SQL Server database.

Created Custom Web resources (Editable Sub grid) using Java Script.

Created Multiple Custom HTML Web Resources

Extensively Used SDK.REST package in JavaScript to retrieve data from CRM

Use of Rest, Soap calls to CRM service in 2011.

Created Business Rules to Validate forms and Business Requirements

Designed the structure of the Web Services implemented by using the WCF methodology.

Company: Triculin Technologies Pvt Ltd., India

JUL 2009 – Jul 2011

.Net & MSCRM Developer

Responsibilities:

Installed and configured MS Dynamics 4.0 system for development and testing created organizations.

Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM 4.0 system.

Gathered client requirements and business process, development, testing and deployment of Microsoft CRM projects.

Implemented good number of plugins using C#.Net Framework.

Customized CRM Forms, Entities, Attributes, Security Roles, Views, Ribbons & Sitemaps to extend the functionality and to meet the client requirements

Created Security Roles based on requirements from business.

Created Workflow based on requirements from Sales and Marketing department.

Generated various reports with drilldowns, calculated members



Contact this candidate