Sql Server .Net

Prashanth

MS CRM Dynamics /.NET Developer

Email: **********.***@*****.***

Phone: 414-***-****

SUMMARY

* + years of experience in Microsoft Technologies in Designing, Developing and Implementing Intranet, Internet, Client/Server Applications, Web Development, Object Oriented Programming in Software Development Life Cycle (SDLC) using Microsoft Dot NET Framework 4.0/3.5,MVC5 Razor, ASP.NET, C#.NET, VB.NET, ADO.NET.

Experience working on NET 4.0/3.5/2.0,C#,VB.NET, ASP.NET,XML,XSLT,DHTML, ADO.NET, Web Services, WCF, WPF, LINQ, Generics, Java Script, AJAX, OOPS, HTML, CSS, IIS, Win Forms, Web Application, Visual Studio 2010/2008/2005/2003,SqlServer 2008R2/2008/2005/2000,Oracle CRM-On Demand, MS Dynamics CRM 4.0, 2011, 2013 and 2015.

Hands on experience on Dynamics CRM forms customization using JavaScript and integration of CRM with other web/windows applications.

Expertise in developing and deploying plug-ins, custom workflow activities and java script extensions for MS CRM.

Hands on experience on Dynamics CRM forms customization using JavaScript and integration of CRM with other web/windows applications.

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

Creating SSIS packages to export reports from MS Dynamics CRM.

Expertise in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Data Adapter Object and Dataset Object.

Adapted Model-View-Controller (MVC) frameworks for developing web applications using Angular Js.

Have good experience of SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services), Dashboard customization with complex charts built from SSRS. Proficient in building Web User Interface (UI) using HTML5, DHTML, XHTML, CSS3JavaScriptand Angular JS that follows W3C Web Standards and are browser compatible.

Responsible for designing Presentation Tier (web pages) using the concepts such as Master Pages, Themes, Skins, HTML, XML, CSS, Java Script, JQuery, Angular JS and also Worked With ASP.NET Custom Controls.

Experience in working with Web Services, WCF Services, WCF RIA services and ADO.NET Entity Framework.

Hands on experience using Source Code Control Systems like MS Visual Source Safe, Subversion and TFS.

Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2008/2005/2000 & Oracle 11g/10g/9i.

Strong relational database background in SQL Server,Oracle 10g with extensive knowledge in writing the T-SQL scripts, Stored procedure, Triggers, Views, Database designing and Maintenance.

Hands-on experience with Reporting Tools SQL Server Reporting Services (SSRS), creating ETL packages using SQL Server 2005/2008 Integration Services (SSIS), SQL Server Tuning Advisor.

Experience in writing Unit test cases & developing System Test cases

Excellent communication, analytical and interpersonal skills.

Experience with full life cycle implementation of business solution, including requirement gathering, prototype designing, coding, database/data mart setup, report development, testing, UAT deployment, production and ongoing product support.

Strong communication, organizational and interpersonal competencies along with detail oriented and problem solving skills in the technology arena.

Technical Skills

Languages

.NET 4.0/3.5/2.0, ASP.NET 4.0/3.5/2.0, VB.NET,C#,XML, Web Services, WCF, WPF,, Win Forms, Web Forms, T-SQL, PL/SQL

Server Scripting

ASP.NET 2.0/3.0/3.5/4.0/4.5, ASP

Client Scripting

JavaScript, JQuery, VB Script, JSON, Angular JS.

Web Technologies

AJAX, XML, XSLT, CSS, Web Services, Web Parts, WCF, WPF, LINQ, WSS.

Database

SQL, PL/SQL, T-SQL, Oracle 8i/9i/10g/11g, MS Access 2000, SQL Server 2000/2005/2008

Reporting and Testing

MS SQL Reporting Services, Crystal Reports

Development Tools

Visual Studio 2003/2005/2008/2010/2012 Team Edition and MS Dynamics CRM 2011, 2013, 2015.

Versioning

Team Foundation Server (TFS), Visual Source Safe(VFS),

SubVersion, Tortoise SVN.

Operating Systems

Windows, Mac, and UNIX.

Web Servers

IIS 6.0/7.0,8 Windows Server 2008/2003/NT

Methodology

UML, Agile, Object-Oriented Analysis/Design

PROFESSIONAL EXPERIENCE

Client: AT&T, Middletown, NJ Aug’ 15 – Till Date Role: .Net/MS CRM Dynamics Developer.

Responsibilities:

Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation and Testing using AGILE-SCRUM Methodology.

Enhance MS Dynamics CRM 2013 usability by designing and optimizing navigation, forms, and layouts.

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

Created and validated Views, User Controls, Models, View Models and Controllers using MVC5 Framework with Razor Syntax and Used JQuery for Client Side Scripting.

Customization of Microsoft Dynamics CRM system, based on functional requirements of the client and use of out-of-the-box features, required configuration and customization for various functionalities and requirements.

Documentation of functional requirements and design of CRM, based on business processes of the client organization.

Provide input and advice regarding Microsoft Dynamics CRM capabilities and functions to client organizations, in relation to current business processes and effort estimation for configuration, customization and documentation

Designed different components using C# language and used Exception handling, Error providers to handle exceptions.

Developed the necessary Stored Procedures and created Complex Views using Joins for robust and fast retrieval of data in SQL Server using T-SQL.

Involved in testing of application by Unit Testing, Integration Testing, User Acceptance Testing (UAT) and End User Support.

Extensively Designed and implemented Data Integration and ETL processes with SQL Server Integration Service (SSIS) packages to make data available for reporting purpose within a data warehouse.

Worked with Team Foundation Server (TFS) control which stores all code, as well as a record of all changes and current check-outs in Project.

Environment: C#.Net (VS 2013), Asp.Net MVC, .Net 4.0,VB.Net, WWF, SSRS, SSIS, Fetch XML, JSON, HTML, JavaScript, MS CRM 2013,HTML5,CSS3,JQuery,Visual Studio 2012/2013.

Client: Fremont Bank, Hayward, CA May’ 13 – Juy’14 Roles: .Net/MS CRM Developer.

Responsibilities:

Involved in functional analysis, design documentation, requirement gathering and development.

Experience the CRM team to regular monthly release cycle process.

Developed out-of-box workflows and custom workflows for CRM 2013 based on user needs.

Worked on supporting the CRM 2011/2013 production environment and resolving the issues for CRM production environment.

Involved in various meeting held based on upgrade of the current CRM 2011 version to the CRM 2013 version.

Extensively used Advanced Find functionality in CRM.

Developed custom SSRS reports for CRM

Used excel templates for data imports to and from CRM.

Functional and Technical understanding of the issues.

Querying SQL 2008 and oracle 11g database for customer production issue resolutions.

Developed dynamic reports using CRM reporting interface and SSRS (SQL 2008 R2 engine) deployed it on the CRM that were used in the application depending on roles.

Worked on dashboards in CRM 2014. Surveyed variety of users to develop customized dashboards according to their security roles.

Developed Duplicate detection rules to prevent Duplication in Cross entities.

Bound the Sitemap to the Tree View control for navigating between several Web Forms.

Developed reusable custom data access layer using ASP.NET.

Wrote stored procedures and database functions for data extraction.

Used ASP.NET as data access middleware for retrieving data and updating records in database.

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 2008, SSIS and SSRS.

Client: JP Morgan Chase, Dublin, OH Dec’ 12 – Apr’13 Roles: MS Dynamics CRM Developer.

Responsibilities:

Involved in Full Software Development Life Cycle (SDLC) and identifying the requirements and defining the business rules to user requirements.

Understanding and analyzing the client’s requirement and involved in GUI designing of the application

Created Entity Attributes, Lookup fields and customized forms/views for all System &Custom Entities.

Pre-populating data into the CRM page during the page load using JavaScript, CRM Web Services and XML object.

Initially Migrated Microsoft Dynamics CRM 4.0 customization to CRM 2011.

Designed different components using C#.NET language with extensive use of Object Oriented Programming Techniques (OOPS) like Abstract Classes, polymorphism, Interfaces etc.

By using SOAP request I tested the web methods in the application.

Created Stored Procedures for generating reports by using Server Reporting Services (SSRS), Triggers, and Views for performance tuning and retrieval of data.

Implemented various test cases for Unit testing using NUNIT.

Used Team Foundation Server (TFS) for Version Control, creating and managing projects and accessing the items that are stored and managed for a project.

Environment: Net 4.0, MS Dynamic CRM 2011, C#.Net, Entity Framework, AJAX, JSON, Agile, HTML, IIS 6.0, MS Visual Studio 2010, TDD, N-Unit, Windows Application, SQL Server 2008.

Client: MindTree Limited, Hyderabad, India NOV’ 08 – Jun’12 Roles: Junior Software Developer

Responsibilities:

Developed web based application for using ASP.NET, VB.NET, ASP, VBScript, JavaScript, Visual Basic 6.0, COM, XML, and XSLT.

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:

.Net framework 3.0, Visual Studio 2005, C# 3.0, ADO.NET, ASP.NET 2.0, XML,MQSeries, Sql server 2005, IIS 6.0

Contact this candidate