Post Job Free

Resume

Sign in

Sql Server Sales

Location:
Conyers, GA
Posted:
August 18, 2017

Contact this candidate

Resume:

SUMMARY:

*+ years of experience in entire Microsoft Dynamics CRM Software Development Life Cycle as well as Microsoft .Net Framework Technologies. Having sound knowledge of developing web based B2B B2C applications in the client/server environment.

6 years of extensive implementation experience in installation, configuration, customization and extension of Microsoft Dynamics CRM 4.0 2011 as well as doing the deployment, trouble shooting and production support for the applications developed.

Experience in developing complex applications on Microsoft Dynamics CRM platform with customization of entities, sitemap writing client side JavaScript

Experience in developing of custom WCF web services, dialog based workflows, plug-ins and integrating custom web pages into CRM

Experience in interacting with MS CRM database through the use of web service methods

Experience in operations like data migrations and updating using LINQ and XRM that help in facilitating data migration within CRM across various entities

Hands on knowledge of implementing and maintaining access controls in CRM based on roles and access conditions

Exposure in configuring and working with Windows OS, IIS, Outlook with CRM plug-in, SharePoint Server

Hands-on experiences in developing Web/Windows applications using C, ASP.net, ADO.net, SQL Server 2005/2008R2, and .Net Framework 3.5/4.0 with strong knowledge of Object-Oriented concepts

Good knowledge of Windows Communication Foundation WCF, Windows Workflow Foundation WF, and Microsoft Web Server like IIS 6.0/7.0

Expertise in Database Systems, SQL, and Stored Procedure

Good knowledge of Web Development skills like HTML, XML, XSLT, JavaScript, and Visual Studio 2005/2008/2010

Experience in converting client requirements and functional specifications to technical design with effort estimation and doing development for the same

Experience in client management and system development, design, and implementation

Experienced in creating, updating, and reviewing project plans

Excellent analytical, logical and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems

Windows XP/ 2000/7/8/10/Vista, Red Hat, SUSE Linux, Solaris, Linux

Enterprise Technologies

Microsoft Dynamics CRM 4.0 2011, SharePoint 2010

Web Technologies

HTML/DHTML/XHTML, AJAX, XML, JavaScript

Database

SQL 2005/08/12/14. Oracle, MySQL, No SQL

Management Tools & Version Control Tools

JIRA, Service Now, Confluence, GitHub/Git

Scripting

Python, shell, Perl, Ruby

Application/Web Servers

WebLogic, WebSphere, Apache Tomcat, IIS, JBoss, HTTP server

Professional Experience:

Microsoft Dynamics CRM Developer/Administrator

Avanade, Hartford, CT Jan 2016 to Present

Responsibilities:

Analyze the requirement and do High level and Low level architectural design.

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

Design and customize CRM 2015/2016 forms, ribbons, site map, workflows, Dialogue.

Worked on tablets and mobile platforms with CRM 2015/2016.

Designed the web UI using ASP.NET MVC5, HTML5, JQuery, CSS, Infragistics grid controls.

Code review of plug-in, custom workflows and custom Asp.net MVC Application (ISV).

Design and develop custom Plug-in and workflows.

Worked on Fetch XML for query expression.

Worked on Site Map changes with the help of Sitemap editor in CRM system 2016.

Worked on plug-in and workflows depends on business requirement.

Worked on Managed and Unmanaged solutions.

Worked on Ribbon workbenches.

Used SSRS create reports in the system to provide accurate data for business decision making.

Worked on SSIS and Scribe packages for importing and exporting data.

Design and develop custom web application using Asp.net MVC 5, Razor engine.

Actively participated in daily scrum and defect triage meetings.

Used Application Lifecycle Management (ALM) for Defect tracking.

Worked on TFS for source control.

Worked as per Sprint using Agile Methodology.

Environment: Microsoft CRM 2015, Microsoft .NET 4.5, C#, Visual studio 2015, JavaScript, JQuery, AJAX, LINQ, Entity Framework, Razor engine, SQL Server 2014, IIS 7.5 and TFS.

Microsoft Dynamics CRM Developer/Administrator

Vince, Atlanta, GA Oct 2014 to Dec 2016

Responsibilities:

Analyzed the business requirements and advised feasible solutions to achieve business goals.

Worked on Development Strategy with other developers.

Used Scribe to Integrate the Customer details and Sales Information from Sound Bank to the MSCRM.

Customized various system entities and created custom forms, custom fields, custom views etc.

Created all the security roles and users accordingly in the system based on roles.

Perform one to one requirements gathering session with Business users and prepared the Enhancements lists in-service Module.

Design and Develop Complex ERM to describe the relation between Different custom and system entities.

Worked with CRM SDK for customize the entities, fields forms etc.

Developed workflows to automate various business processes.

Developed Plug-ins in CRM to facilitate complex business rules and validate data, create events.

Responsible for Providing redundancy and backup support for other team members.

Responsible for preparing Functional Specification Documentation.

Gathered a variety of data points for reporting services.

Developed complex reports using SSRS and deployed into MS CRM.

Developed ODATA endpoint on required entities in CRM.

Developed Jscript libraries for various data validations and customizations.

Designed the Security Model for the production environment.

Created Dashboards, Views, Reports and Charts.

Demonstrated proficiency with Microsoft .NET 3.5+ development using C#.

Worked on the initial setup for the Production environment created Business Units, Roles and users, imported accounts and assigned ownership.

Designed and created training material for the end-client.

Environment: Microsoft Dynamics CRM 2011, CRM SDK, C#, Asp.net, Visual Studio 2012,.NET Framework 4.0, MS Outlook, IIS 7.0, JavaScript, Message queues(MQ), XML,HTML/CSS, SQL Server 2008, SSRS and SSIS, TFS2012,MVC,XRM Toolbox, XML, Ribbon Workbench.

Microsoft Dynamics CRM Developer

Grant Thornton LLP, Chicago, IL May 2013 to Sep 2014

Responsibilities:

Attending daily Scrum and Stand-up meeting to follow up the technical use cases.

Created Custom Entities, Custom attributes for individual business units in MS Dynamics CRM, according to their business process Customized Workflows and Plug-in for automated processes, based on requirement from sales and marketing department to increase visibility and efficiency.

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

Collaborate with other development staff to problem solve, implement solutions, perform code reviews and troubleshoot

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

Worked with a team of stakeholders following the Agile Scrum software development process.

Developed and deployed the Custom workflow and plug-in assembly to the organization.

Customized the CRM form programming and form validations through Java script.

Building the CRM forms, screens, and views, as well as workflows and reports around the customer, needs for an interface.

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

Discussed the requirements with end user and propose solutions to achieve business goals. Generated Sales Reports for statistical analysis of data at user level using SSRS.

We have applied the client side and server side scripting in the CRM.

Develop plug-ins to synchronize/update payment details to CRM system.

Created several plug-ins and workflows for enhancing the system and maintain data integrity.

Customized the Sitemap area and applied button functionality through Ribbon workbench tool.

Environment: Net 4.0, MS Dynamic CRM 2011/2013, Asp.Net MVC 3, C#.Net, AJAX, JSON, Agile, HTML, IIS 6.0, MS Visual Studio 2010, jQuery, Windows Application, SQL Server 2012, SSIS and SSRS.

Microsoft Dynamics CRM Developer

Axiometrics Inc., Dallas, TX Feb 2012 – Dec 2012

Responsibilities:

Gathering and analyzing business requirements, designing and implementing the best CRM technical solutions based on long term needs and scenarios of insurance providers.

Creating a custom MS Dynamics Sales CRM solution, this also includes configuration, forms, workflow and plug-in.

Involved in Agile Sprint planning meeting Performed CRM system administrating including Configure system wide settings, setting entity and global auditing, setting duplicate record detection roles and schedule detection jobs.

Customized, Microsoft Dynamics CRM 2011 interfaces using JavaScript (Sitemap.xml and ISV.Config) and also for client side data validation and changing UI.

Cleaning data using bulk deletion, exporting data, setup data import asynchronous job.

Using performance monitor to epitomize performance and fine tuning CRM SQL database and CRM application server.

Responsible for designing and developing the Application using ASP.Net MVC, Razor Syntaxes, Razor view engine.

Involved in Requirement Analysis, gathering, Low Level Design, Coding and Integration.

Perform CRM Performance Optimization, Error and Trace Diagnostic, DB Backup, Configuration, Bulk delete, and installation of CRM upgrade and patches.

Responsible for developing the reusable Components on UI(Views) by developing the Partial Views, View starts, and reusable components for implementing the business rules with C# and OOPS Concepts.

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

Upgraded ASP.Net web pages and Plugins assemblies.

Customized CRM Forms, Entities, Attributes, Views, Ribbons & Sitemaps.

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using JQuery and getting the Data back as JSON and parsing it onto the UI.

Developed external SQL reports in SSRS and deployed into MS CRM.

Responsible for implementing the Client Side Validations using JQuery and Java Script. \Responsible for writing the Actions in the Controllers which implement the Business Rules and which act as a mediator between UI (View) and Database (Model).

Design and developed Views, Store Procedures, Joins and Temp Tables, User Defined Functions

Worked in SQL database Optimization and implementing Performance tuning on the Data Retrieval Queries.

System test planning and Unit testing using the Microsoft Unit testing.

Involved in daily and weekly scrum meetings to discuss various aspects of the code related to individual modules.

Involved in modifications of various projects related to Service Desk like Configurations Application, Service Desk Web Application and Service Desk Reports, and successfully deployed to Production.

Tested the code developed to ensure it accurately captured the existing business processes.

Provided ongoing troubleshooting, defect and enhancements.

Environment: Visual Studio .NET 2008, .NET Framework 3.5 & 4.0, WCF, ASP.Net MVC, JQuery, ADO.Net Entity Framework, SSRS, HTML, DHTML, JavaScript, C#, SQL Server 2008

.Net Developer

Liberty Mutual, NH June 2010 to Jan 2012

Responsibilities:

Involved in design, development of application using .NET Framework as an application Framework.

Implemented input validation using the ASP.NET Input Validation Controls.

Implemented Forms-based Authentication in ASP.NET to authenticate the users.

Designed and Implemented the Data Access Assembly using ADO.NET, VB.NET, and SQL Server.

Worked with the database using ADO.NET library.

Configured Web.Config file for the configuration of the entire Web Application.

Developed ASP and VB pages to meet the business requirements and also involved in replace VB pages with redesigned VB.NET pages.

Created stored procedures in SQL Server 2005, wrote the SQL statements using T-SQL, executed and tested stored procedures on SQL Server 2005.

Developed Interfaces for data exchange using SQL Server, Visual Basic and XML.

Developed Web UI Development using AJAX approaches in the product.

Designed, Developed Business Logic, Data Access COM Components in Visual Basic and deploying in COM+ application.

Used Unit Testing frame work for .NET Technologies.

Designed and generated reports using Crystal Reports.

Wrote stored procedures and SQL statements to access data from SQL Server 2005 Database.

Involved in the design of the Database and Developed Stored Procedures using SQL for all the interaction with the database.

Environment: C#.NET, ASP.Net, ADO.Net, XML,Web Services, XAML,SSRS, IIS 6.0 and SQL SERVER 2005.

Education:

Bachelor of Technology, Chirala Engineerging College, May 2009, India.

Master of Science in Computer Science, Trine University, May 2010, Indiana.



Contact this candidate