Sql Server Data
Resume:
Anu
MS Dynamics CRM Developer Mobile: 438-***-****
Email: ******@*******.***
Summary of Qualifications
8+ years of Experience in Microsoft Dynamics CRM, Digital Marketing and Business Development business solutions using Microsoft Technologies like .NET, MS Dynamics CRM and SQL Server.
5+ years of experience in Customizing and Configuring Microsoft Dynamics CRM 2015, 2013, 2011.
Hands on experience on Dynamics CRM forms customization using JavaScript and integration of CRM with other web/windows applications
Demonstrates excellent grasp on CRM application, domain, industry and related domains. Able to guide customers towards cost-effective solutions, a multi-phase roadmap to allow customers to take long-term advantage of their investments in CRM solutions
Experience in developing multi-tiered and distributed architectures using .NET related technologies such as C#, ASP.Net, ADO.Net, AJAX, JavaScript, WCF, SOAP and XML Web Services.
Expertise in Database Systems, T-SQL queries, Stored Procedures using SQL Server.
Experienced in implementing using Agile scrum methodologies.
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) and SSIS (SQL Server Integration
Services), Dashboard customization with complex charts built from SSRS.
Experience in developing complex applications on Microsoft Dynamics CRM platform with customization of entities, and JavaScript
Experience in developing of custom WCF web services, dialog based workflows, plug-ins and integrating custom web pages into CRM.
Experience in use of web services and interacting with MS CRM database through the use of web service methods.
Hands on knowledge of implementing and maintaining access controls and permission in CRM based on roles and access conditions.
Experience in converting client requirements and functional specifications to technical design with effort estimation.
Experienced in Angular JS, JQuery, and JQuery UI for client side programming.
Experience in building rich web experiences using JavaScript and Silverlight.
Hands-on experiences in developing Web/Windows applications using C#, ASP.net, ADO.net, SQL Server and .Net Framework 3.5/4.0 with strong knowledge of Object-Oriented concepts.
Good knowledge of Microsoft IIS 7.0/8.0.
Expertise in Database Systems, SQL, and Stored Procedure.
Good knowledge of Web Development skills like HTML, CSS, AJAX, XML, JQuery, JavaScript, and Visual Studio.
Strong ability to understand Business & System Requirement, Use Cases, Design, Architecture documents and well versed with RDBMS both SQL Server and Oracle concepts and hands on experience with writing complex T-SQL, PL/SQL queries with/without using the client tools TOAD, SQL Management Studio.
Extensive knowledge in entire Software Development Life Cycle, Business requirements analysis, Design, Development and testing
Good analytical, communication skills and ability to work independently and also perform as part of a team
Customer oriented, highly versatile, innovative, excellent interpersonal and communication skills. Creative and results driven with diversified experience in all aspects of testing
Bachelors in technology
Kakatiya University – India (2007)
TECHNICALSKILLS:
ERP Technologies: Microsoft Dynamics CRM 2015, 2011 and 2013.
Other Technologies: HTML, CSS, PHP, Java Script, JQuery, XML, XAML, Fetch
XML, JSON and ODATA.
.NET Technologies: MS Visual Studio 2010 & 2012, Eclipse, MS office,
Programming Language: C#.NET, ASP.NET, MVC, VB.NET,
SQL Server Technologies: WCF, WPF, SSRS, SSIS, SSAS and SQL Server Data Tools.
Data Base: MS SQL Server, MS-Access.
Work Experience
MS Dynamics CRM Developer
Laurentian Bank - Montreal, QC Jan 2014 to Present
Project: The project was mainly about upgrading from CRM 2011 to CRM2015 while adding new features in windows services and CRM system to meet the changing requirements from both the customers and the company. With the project being completed in the future, the CRM system would be more secure by data filtering and more powerful for marketing usage.
Involved in requirements gathering, analysis and project planning
Customized MS Dynamics CRM application based on the business requirement
Created Custom Entities, Custom attributes for individual business units in MS Dynamics CRM, according to their business process Customized Workflows and Plugin for automated processes, based on requirement from sales and marketing department to increase visibility and efficiency..
Used JQuery for consistent easy navigation, look and feel of the website.
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
Developed business objects using C# for various modules
Integrated Custom WCF Service with other applications
Used various report items like tables, sub report and charts to develop the reports in SSRS.
Created User defined Functions, Stored Procedures and Views using SQL Server 2012
Gathered client requirements and business process, development, testing and deployment of Microsoft CRM projects. Used JQuery, JavaScript framework to implement AJAX to restrict the screen flicker.
MS Dynamics CRM Upgrade & Functional Enhancement.
Implemented User Interface in Model-View-Controller architecture, which accomplishes a tight and neat coordination of JSP, Servlets, Java Script, XML, AJAX, HTML.
Implemented Gap analysis for finding out the required amount of customizations needed to meet the client requirements.
Created a detailed project plan, which includes tasks based on their priority.
Customized forms and views for new modules to be added to existing MS Dynamics CRM 2013 system.
Developed OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards
Created Workflow based on requirements from Sales and Marketing department.
Customized CRM Forms, Entities, Attributes, Views, Ribbons & Sitemaps.
Enhanced and developed Business Process Flows as per the client needs.
Designed a plugin to generate account number on create of new record.
Created custom workflows to calculate Probability weighted revenue.
Used WCF to interact with the data from MS Dynamics CRM 2013 system.
Generated Sales Reports for statistical analysis of data at user level using SSRS.
Used SSIS Import data into the system using multiple sources.
Used SSRS create reports in the system to provide accurate data for business decision making.
Customized Dashboards based on the custom reports and charts created.
Configuration of MS Dynamics CRM with Microsoft Outlook 2013.
Successfully upgraded from unsupported CRM 4.0 implementation to completely supported CRM2011 solution and then CRM2013 version.
Microsoft Dynamics CRM Developer
Toyota Canada April 2012 to December 2013
Project: The CRM Website Application Server upgrade and data migration
Responsible for gathering Business, Functional requirements and Use cases and requested for a walkthrough
Involved in requirements gathering, analysis and project planning
Customized MS Dynamics CRM application based on the business requirement
Created Custom Entities, Custom attributes for individual business units in MS Dynamics CRM, according to their business process.
Customized Account Entity fields and related the Account Entity with all other Custom Entities
Creating reports on Account Entity with graphical summary and calculated results.
Modified Sitemap file to display all the related entities in navigation bar of Account record
Created Fetch XML for new report and modified fetch XML using BIDS to customized the report and import back to CRM
Pre populating last created record data into new record form using JavaScript, CRM Web Services and XML object, thus saving time for the user to enter repeated data
Developed complex reports using SSRS and deployed into MS CRM.
Created .NET plug-in to send an alert e-mail to all users who have not reviewed their accounts in last 60 days
Developed UI workflow to add default price list when new products are created
Imported products from a CSV file using Data Maps and Imports.
Trained users on using the Microsoft CRM outlook client with Online and Offline mode features
Prepared Instructions manual for Installation, Un-installation, Re-installation and configuring Microsoft CRM Outlook client
Doing the initial setup of Production environment in order as creating Business Units, Roles, Territories, users and then importing accounts with assigning ownership
Importing and exporting customizations between DEV, QA and Production environments
Prepared requirement documents, training documents and security policy documents
Microsoft Dynamics CRM Developer
Banks-Hill Systems Ltd July 2010 to March 2012
Project: Currently, there are around 42 different departments within the company. Out of these, 2 departments have their own CRM 4.0 standalone systems in place. In the first phase of this project, company is looking forward for new CRM 2013 platform where these 2 departments will be integrated. In the later phases, company wants to bring in more departments on this new CRM 2013 integrated platform
Performed Dev planning, analysis, design and execution in Agile methodology by understanding the product backlog, sprint iterations, scrum session, stand up and defect triage
Installed and configured MS Dynamics CRM 2011 system for development and testing, configured server instance, created organizations.
Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM 2011 system.
Generated various reports with drilldowns, calculated members, drop downs 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.
Customized system entities and custom entities to meet the business requirements.
Created several plug-ins and workflows for enhancing the system and maintain data integrity.
Created custom asp.net pages and configured forms and views for new modules to be added to MS Dynamics CRM system.
Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
Used SSIS Import data into the system using multiple sources.
Used SSRS create reports in the system to provide accurate data for business decision making.
Created custom dashboard, create custom Ribbon button and configured sitemap using Pragma toolkit.
Extensively used User interface controls that use JQuery to validate client side validation.
Used Bing Maps API to design and develop dashboards to display incoming customer requests and update address coordinates in the Microsoft Dynamics CRM 4.0.
Designed and built DTS/SSIS packages and ran several scripts for implementing changes in the backend for applications.
Suggested several security policies on various entities in the system to manage and implement appropriate access controls
Developed UI using JQuery and JSP for interactive cross browser functionality and complex user interface.
Provided CRM end user training for case and service managements for department staff. Extensively worked on designing reports using SQL Server Reporting Services (SSRS)
Develop plug-ins to synchronize/update payment details to CRM system.
Provided technical guidance to the team and participated in several sessions of code review.
Assisted the team in basic testing and deployment of the solution.
.NET Developer
HP Jan 2009 to June 2010
Gathered Business and Functional requirements of the projects and performed Gap analysis to ensure that the documents are complete for the all the projects
Developed flexible, more user interactive and user-friendly GUI's and Dynamic Web Pages, reusable classes, functions using ASP.NET 3.5.
Created component design, prototyped the necessary business and data layer components using C# in .NET Framework 3.5.
UI layer web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.NET User Controls, Server Controls, ADO.NET and Microsoft SQL Server 2008.
Design the structure of the Web Services implemented by using the WCF methodology.
Created and maintained various T-SQL Queries, complex and heavy stored procedures, triggers, functions, views, indexes, cursors on Microsoft SQL Server 2008 to handle all kinds of transactions in the database.
Created and maintained several SSIS Packages for the system.
Create SQL jobs to process files, execute SSIS Packages and publish data on the web server.
Extensively used XML and dataset for accessing data form SQL Server 2008 database.
Followed Agile Methodology, using the project management software On Time.
Developed and tested the code for Enterprise Management Information System using ASP, Visual Studio 2005 with SQL Server database.
Developed custom page in App Code and Code- behind to support the presentation layer.
Created User Controls to be used in the web pages.
Implemented ASP.NET built-in validations in Web Forms. Used the Web Server validation controls for simple validations to be performed on client side and server side
Developed user interface screens using ASP, JavaScript and HTML/CSS.
Used ADO.NET to connect to SQL Server database.
Created custom reports and exported it in PDF format.
Used Cross Tabs, Sub Reports, Formulas and Parameters in the reports.
Integrated MS Dynamics CRM - 2011 to 2011with MS Outlook 2007 and offer a consistent, familiar user interface.
Troubleshooting and coordinated deployment between environments with other teams
Updating the UI in CRM meeting new business requirements.
Added new functions to existing windows services.
Implemented Plug-Ins defining business rules and validating data.
Debugged JavaScript used in CRM system
Configured CRM settings to adapt security policies within different environments using security roles.
Migration of data from Excel source to CRM using SSIS.
Used Advanced Find feature of MS Dynamics CRM and created multiple views of System entities
Built web pages that is more user-interactive using JQuery plugins, JavaScript.
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 including both automated and manual testing.
Created and customize reports in the system by using SQL Server Reporting Services (SSRS) to provide data for demand planning and opportunity management
Created organizations, business units, groups and their relationships.
Developed UI interface using HTML, Java Script, CSS, JQuery
Imported contacts from existing application into MS Dynamics CRM using the WCF service.
Integrated with SSRS to support reporting, data analysis, and business planning.
Worked on setting up relationship between System & Custom entities
Upgraded asp.net web pages and Plugins assemblies.
Customized the forms to extend the functionality and to meet the client requirements.
Maintained version control during solution import & export using SVN
ASP.NET/C# Developer
Wells Fargo June 2007 to Dec 2008
Responsible for gathering Business, Functional requirements and Use cases and requested for a walkthrough
Reviewed the Business and Functional requirements and identified and reported gaps to the Business Analyst
Performed test planning, analysis, design and execution in Agile methodology by understanding the product backlog, sprint iterations, scrum session, stand up and defect triage meetings
Created Standard Test Plan, Test Scenarios and Test Cases templates based on IEEE standards and created detailed Test Plan, Test Scenarios and Test cases according to the Business/Functional requirements and identified Involved in designing application architecture by using Microsoft Visio.
The integrated environment Visual Studio.NET 2005 was used for developing the complete application
The UI was developed using ASP.NET 3.0.
Incorporated user authorizations in Web.Config.
Implemented User Level Security so that every user can access only related forms and reports.
Used ADO.NET and its objects for Database Transactions.
Involved in the complete Software Development Life Cycle (SDLC) for development process and AGILE, SCRUM including Analysis, Design, Implementation, Testing and Maintenance
Written technical documentation with UML notations such as use cases, class diagrams, and sequence diagrams
Used WPF, Win forms for developing brokerage window
Involved in building a rich web experience using JavaScript
Migrated C++ code to C#.net
Implemented MVVM, single ton design patterns, Entity framework
Extensive development experience with .Net Technologies Microsoft .NET Framework 4.0, with C#, Classic
ASP, ASP.NET, ADO.NET, LINQ and Web applications using AJAX control toolkit
Implemented Scrum framework for agile software development
Developed the application using n-tier architecture, OO Design
Deigned tools using WPF which interact with web service, host teams
Designed tools required for testing using WPF
Established communications among applications using WCF
Implemented WCF for communication between Business-to-Business (B2B) and Business-to-Consumer (B2C)
Designed web pages using Silverlight, Expression Blend which has to interact with host servers
Implemented AJAX controls and functionality in the web forms
Used JQuery for a better interaction with the application
Used Rational Clear case to maintain version control, save UML, project related documents, maintain dynamic, static view while in the process of code updating i.e. role based access, code security
Experienced in developing windows services, web services and worked with Team Foundation Server
Experienced in functional decomposition and use case realization and applying design patterns
Written stored procedures, Triggers, Packages using SQL Server
Generated reports using the SQL Server Reporting services (SSRS)
References available upon request
Contact this candidate