We provide IT Staff Augmentation Services!

Ms Crm Developer/team Lead, Sql Server Bi (ssis, Ssrs) Resume

3.00/5 (Submit Your Rating)

Coconut Creek, FL

PROFESSIONAL SUMMARY:

  • Over 8 years of professional experience in field of Information Technology with responsibilities including Analysis, Design, development, Implementation and Testing in Client - Server and web based n tier architecture across multiple business domains.
  • Hands on experience in MS CRM. (Customizations, Workflows, Plug-in, CRM Web Services, Duplicate Detection job, Import utility etc.)
  • Implementation of MSCRM 4.0, 2011 and 2013
  • 4+ years’ experience doing development and configuration work in Microsoft Dynamics environment ( )
  • Experience in developing web based applications using ASP.Net, C#, Java Script and SQL Server.
  • Having 3+ years’ experience in Customizations: Java Scripting, Plugin in .NET to communicate to CRM
  • Having 3+ years of experience on developing SSIS Packages.
  • 2+years’ experience in Microsoft Visual Studio 2013/2015
  • Experience in SOAP & WCF based Web Services using .NET Framework.
  • Possess sound knowledge on ADO.Net and its architecture.
  • Experience in creating Stored Procedures and Triggers in SQL Server Databases.
  • Efficient in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers
  • Having experience in BizTalk Server 2006/R2 technologies
  • Having good knowledge in Orchestrations, Transactions and Correlations in BizTalk Server.
  • Having knowledge on Big Data Ecosystems Hadoop, Hive and Sqoop
  • Knowledge in performing various types of testing like Functional Testing, Regression Testing and System Testing and Acceptance Testing.
  • Involved in all phases of Software Development Life Cycle (SDLC).
  • Having 2+years of AGILE software development methodology
  • Proficient in learning new technologies and quickly adapting to new environment.

TECHNICAL SKILLS:

  • Dynamics CRM 2015/2013/2011/4.0
  • Visual Studio 2008/2005/2013/2015
  • Windows 2008/2003/2000
  • C
  • MS SQL Server 2005/2008/2008 R2/2012
  • T-SQL
  • ASP.NET
  • C#.Net
  • WCF
  • SSIS
  • SQL Server Business Intelligence Development Studio (SSBIDS)
  • SSRS
  • CVS
  • MS Office
  • Adobe Photoshop
  • MS Excel
  • Excel
  • ETL.

PROFESSIONAL EXPERIENCE:

Confidential, Coconut Creek, FL

MS CRM Developer/Team Lead, SQL Server BI (SSIS, SSRS)

Responsibilities:

  • Handling team of 7 members
  • Responsible for requirements gathering from Business users and communicated with team to convert business requirements to technical approach, delivery and maintenance of custom solutions
  • Implementing custom solutions in Dynamics CRM 2013
  • Using Microsoft visual Studio 2013 team edition to develop and maintain code bases
  • Worked on entity customizations, plugin development, workflow development and JavaScript
  • Worked on security role configurations
  • Designed and developed Custom .Net web Application
  • Designed and Implemented Dynamics CRM look - alike user interface and controls using HTML, JavaScript, CSS, WCF and Web Forms, jQuery.
  • Used REST/SOAP end points with JavaScript, worked on Ribbon customization etc., for CRM applications
  • Created complex Stored Procedures, Functions, SSIS packages, triggers, cursors, tables, and views and other SQL joins.
  • Developed and executed SSIS packages to populate data from the various data sources, created packages for different data loading operations for many applications.
  • Discovered performance issue with plugins that run on every entity create and recommended registration for only entities that need it
  • Prepared project related documents like application portfolio, User Manuals, update application’s requirement document for change requests etc.
  • Throughout the project followed the AGILE software development methodology

Software: MS CRM 2013, Visual Studio 2013, MS SQL Server 2008 R2, SSIS,ASP.NET, C#.Net, WCF, LINQ, Windows 8, Windows Server 2008, HTML, XML

Confidential, Coconut Creek, FL

MS CRM Developer/Team Lead, C# Developer, SQL Developer

Responsibilities:

  • Worked as a CRM developer/Tech lead for the project
  • Implementing custom solutions in Dynamics CRM 2013
  • Worked on Migration of code from CRM 4.0 to CRM 2013
  • Used Microsoft Visual Studio 2013 for code development and maintain code bases
  • Communicate with client for gathering business requirements and communicated with team to convert business requirements to technical approach.
  • Worked as a developer for MS CRM to develop the custom tool to migrate the data from the existing system to MS CRM and setting up the business unit hierarchy structure for all the users in CRM
  • Using T-SQL in development activities such as writing stored procedures, triggers, functions and views
  • Developed complex T SQL code for Customer data import using SQL Server bulk import.
  • Providing support to client on daily activities
  • Helping the team members on resolving the issues
  • Assisted in branching and merging code in Visual Studio team foundation server

Software: MS CRM 2013, Visual Studio 2013, MS SQL Server 2008 R2, C#.Net, LINQ, Windows XP, Windows Server 2000, HTML, XML

Confidential

CRM Developer, SQL Developer, C# and Application Developer

Responsibilities:

  • Worked on code migration from dynamics CRM 4.0 to dynamics CRM 2011
  • Configured CRM Security Roles
  • Using ASP.Net validation controls for validating user input in the web forms
  • Used VB.Net for supporting the Dynamics solution
  • Worked as MS CRM developer and worked on customizing the application
  • Implemented and conducted training for Confidential users on using the CRM application software
  • Worked closely with business analysts to understand CRM application enhancement needs
  • Using T-SQL in development activities such as writing stored procedures, triggers, functions and views
  • Involved in creating SQL Job to update database table for business need.
  • Documented the schedule process and presented it accordingly.

Software: MS CRM 2011, MS SQL Server 2008 R2, ASP.Net, C#.Net, ADO.NET, LINQ, Windows XP, Windows Server 2008, HTML, XML

Confidential

CRM Developer, SQL Developer, C# Developer

Responsibilities:

  • Worked as a developer for MS CRM to migrate the data from the existing system to MS CRM
  • Using T-SQL in development activities such as writing stored procedures, triggers, functions and views
  • Providing support to client on daily activities
  • Helping the team members on resolving the issues
  • Developed complex T SQL code for Customer data import using SQL Server bulk import.
  • Modified the existing database by adding the tables and maintained relationships between the tables.
  • Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables.
  • Created Database Objects like Tables, Linked Servers, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints, in SQL Server 2005/2008

Software: MS CRM 4.0, MS SQL Server 2008 R2, Asp.Net, C#.Net, Windows XP, Windows Server 2000, HTML, XML

Confidential

MS CRM Developer, SQL Developer

Responsibilities:

  • Worked as a developer for MS CRM to migrate the data from the existing system to MS CRM
  • Worked on the customizations, developing Plugins and Workflows.
  • Wrote T-SQL code for creating stored procedures, cursor and handling the data validations
  • Providing support to client on daily activities
  • Responsible for ongoing maintenance and resolving the issues
  • Helping team members on resolving issues
  • Fine tune complex SQL queries and Stored Procedures to increase performance.

Software: MS CRM 4.0, MS SQL Server 2008 R2, C#.Net, Windows XP, Windows Server 2000, HTML, XML

Confidential

BizTalk Developer, C# Developer and SQL Server Developer

Responsibilities:

  • Worked on the enhancements made to the application
  • Created schemas for the data files to be exchanged by the clients
  • Created maps for conversion of business data to a format acceptable by business application
  • Created orchestrations for business implementation
  • Code review and testing of components
  • Helping team members on resolving issues
  • Triggers, Stored Procedure, Constraints in SQL Server 2005/2008
  • Created deployment documents for all dev work to deploy in all environments.
  • Successfully tested all tasks in staging and stored all versions of SQL scripts using VSS.
  • Responsible for creating Databases, Tables, Clustered, Non-Clustered Indexes, Unique/Check
  • Constraints Views, Stored Procedures, Triggers, Rules and Defaults

Software: BizTalk Server 2006, MS SQL Server 2008 R2, C#.Net, Windows XP, Windows Server 2000, HTML, XML

Confidential

MS SQL Server/ CSLA/ Application Developer

Responsibilities:

  • Worked on developing the classes for CSLA enhancements required for the application
  • Worked on coding the windows forms using VB.NET
  • Created the data objects like stored procedures, views and functions required for application
  • Collaborated with team members for review and analysis of system requirements
  • Worked on creation and maintained the required documentation
  • Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables.
  • Triggers, Stored Procedure, Constraints, in SQL Server 2005/2008
  • Successfully tested all tasks in staging and stored all versions of SQL scripts using VSS.
  • Responsible for creating Databases, Tables, Clustered, Non-Clustered Indexes, Unique/Check
  • Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Software: MS SQL Server 2008 R2, C#.Net, VB.NET, Windows XP, Windows Server 2000, HTML, XML

We'd love your feedback!