Sql Server Web Services

Summary:

Over * years of experience in designing, developing, and testing n - Tier Client/Server Web-based Applications using Microsoft .NET Framework and SQL Server with Agile and Waterfall Development Methodology.

Hands-on experience in domains like Finance and Healthcare.

Outstanding .NET Full-Stack Developer with proven expertise in all phases of SDLC.

Expert in Microsoft Technologies like C#, ASP.NET 5.0/4.5/4.0, MVC 5.0/4.0, Entity Framework 6.0/5.0/4.0, ADO.NET, SQL Server 2014/2012/2008 R2, WCF 4.5/4.0, Web API RESTful Services, IIS 7.0/6.0.

Knowledge of Object Oriented Programming Concepts, in applying Object Oriented Analysis and Design (OOAD), UML and design patterns like Singleton and MVC framework

Good Knowledge of various capital markets products such as equity, options, mutual funds, fixed income, annuities, new issue management, currency, next shares for retail as well as managed clients

Strong knowledge of XML Schema, GJXML, XML, XSLT, and NIEM.

Good experience providing and consuming REST and SOAP based services and JMS/AMQP/MQTT applications.

Experience working on developing DB2 Stored Procedures, online CICS tools, SOLA (Service Oriented Legacy Architecture) templates.

Experience with Unit test/Mocking frameworks (Rhino Mocks, Moq, etc.), Test Driven development.

Experience in AWS services such as EC2, ELB, Auto-Scaling, EC2 Container Service, S3, IAM, VPC, RDS, DynamoDB, Certificate Manager, Cloud Trail, Cloud Watch, Lambda, Elastic Cache, Glacier, SNS, SQS, Cloud Formation, Cloud Front, EMR, AWS Workspaces, Elastic File System, Storage Gateway.

Experience with WebMethods Administration, Installation, Patching, Troubleshooting, Deployments & Migration

Worked on new Ajax Framework Mode property of ASP.NET 4.0, which controls components of the ASP.NET Ajax Library.

Extensive knowledge in Mobile Development using the frameworks Angular UI, Ionic Framework

Has knowledge and understanding of ODM Architecture standards for implementation of Rule Applications and its integration of them with BPM applications.

Sound knowledge of SQL Server Analysis Services (SSAS), SharePoint 2010 development and Performance Point Services (PPS), SQL Server Reporting Services (SSRS), Power Pivot (Excel 2010).

Experience in web development with JavaScript, JQuery, AJAX, JSON, CSS, Knockout.JS, Angular.JS, HTML, HTML5 and DHTML (CSS).

Wrote source code in PowerShell and C# relating to network administration and in-house employee software.

Worked on large numbers of WPF Forms, Custom Controls and User Controls using XAML language for UI and Dynamic Web Parts for personalized content which allows Change, Edit, Move the content on pages as per users' own choice.

Developed Web & Windows Applications Using ASP.NET, C#. NET, VB.NET, MVC 1.0/3/4 (ASPX/RAZOR View Engine)

Significant experience and deep understanding of JavaScript framework internals (React, JQuery, Angular, Knockout, Backbone)

Developed and consumed Web services (Http, Soap, XML) and WCF services (Http, Nettcp, SOAP, XML)

Experience with Knockout.js, Bootstrap, Grunt, and Less CSS preprocessor in ASP.Net

Experience in SQL, PL/SQL, Database Triggers, SQL Stored Procedures, database-interfacing elements like ADO.NET like SQL command, Data reader, Data set and Data Adapter.

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

Good experience on Versioning tools like VSS (Visual Source Safe), TFS (Team Foundation Server) and GIT.

Good experience in using.Net Assemblies, XML Web Services (SOAP, WSDL).

Worked with Serialization concepts in .NET and Security related issues for Web services i.e. providing the Certification to the Client, Windows Based Authentication, Form Based Authentication and SOAP Envelope.

TECHNICAL SKILLS:

Technologies

. NET Framework 2.0/3.0/3.5,4.0, ASP.NET, ASP Classic, ADO.NET, Win Forms, and Web forms, XML Web Services, LINQ, WCF and MVC 4.0/6.0, LINQ, Silverlight, ASPX View Engine for MVC 3.0/4.0, Entity Framework 4.0, Knockout JS,CSS, HTML/XHTML and DHTML.

Languages

C, C++, C#, VB.Net,SQL, PL/SQL, T-SQL.

Scripting Languages

VBScript, Java Script, J-Query, HTML5, Shell Script, ML, XSL, XSLT, XPath.

Web Technologies

HTML, HTML5, DHTML, CSS, XML, DOM, IIS, AJAX, XSLT, SOAP, Web API, WSDL, Web Services, OData

Operating Systems

Windows 8/VISTA/XP/2000/NT/98/95, Windows Server 2003,2008

Databases

MS SQL Server 2000/2005/2008/2008 R2, MY SQL

Protocols

TCP/IP, HTTP, FTP

Tools

NUnit, Visual Studio Testing, QTP, Selenium

Tools

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Rapid SQL

Reporting Tools

Crystal Reports, SQL Server Reporting Services (SSRS).

IDE

Visual Studio 2012/2010/2008.

Version Control Tools

Visual Source Safe (VSS), Team Foundation Server(TFS), Team Forge

PROFESSIONAL EXPERIENCE

Client: Ultimate Software, FL January 2018 – Till Date

Role: Full Stack .Net Developer

Working out the new system's requirements and specifications and test strategies, assisting in functional testing of the new system, ensuring that it meets the user specifications.

Developed the system front end using C#, ASP.NET and HTML and backend using SQL server as the backend database, Win forms.

Designed and developed GUI components, implementing event handling using C# DHTML and AJAX.

Created WCF based web service for communication between applications which are published for the various business units.

Involved in Enhancing the Business Layer to provide more interfaces and functions needed for the system

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Developed web application using ASP.NET MVC architecture and used entity framework‘s db based approach for mapping between application and database.

Worked on Angular2 Templates, directives, Routing and navigation, Components, Services, Pipes and Data Binding

Implemented various Validation Controls and also created Custom Validation Controls using JavaScript to perform Client Side Validation.

Developed web pages using data binding controls like dropdown list, grid control and various other UI controls.

Used angular validation such as $touched, $invalid and $dirty for client-side validation

Implemented asynchronous programming to complete Web API call when using API to call services from other projects.

Coded using XSLT in generating patients list taking the data from XML document and formatting with XSL.

Extensively worked with Forms Authentication and successfully implemented login mechanism for different levels and roles of users.

Used Visual Source Safe (VSS) for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Implemented Angular Router to enable navigation from one view to the next as user performs application tasks.

Worked on query optimization, index tuning, caching and buffer tuning to improve performance of databases.

Developed RESTful Web API services that allow sophisticated, effective and low-cost application integration and multi-tier.

Designed dynamic client-side JavaScript codes to build web forms and simulate process for a web application, page navigation using Angular 2.

Implemented Unit, Integration and System Testing using NUNIT.

Used Git extensively to rebase and merge branches to the Master. Used Jenkins to do Continuous Integration.

Environment: .NET Framework 4.5, Visual Studio 2015, C# 5.0, ASP.NET 4.5, MVC 5.0, Entity Framework 6.0, Web API 2, SQL Server 2014, HTML5, CSS3, JavaScript, AngularJS 1.5, AJAX, IIS 7, LINQ, SSIS, SSRS, Git, Agile, Jenkins, NUnit

Client: Thomson Reuters, TX January 2017 – Dec 2017

Role: Full Stack Developer/ Web Developer

Responsibilities:

Involved in the SDLC of requirement analysis, design and development of the web-based application in the fast-paced agile methodology.

Tested the backend database using SQL queries and make/edit changes to SQL queries and table entries.

Leveraged technologies including NHibernate and JQuery to accelerate development, which enabled the team to complete both projects ahead of schedule and to exceed the expectation of the business managers.

Branching, Tagging, Release Activities on Version Control Tools: SVN, GIT.

Developed a WCF Service using WSDL to get the all Details of customers using Search Engine.

Created Typescript reusable components and services to consume REST API's using modular based architecture provided by Angular 2.

Experience in configuring email notifications in ServiceNow. Has been part of end user self-service portal management.

Worked and involved different data structures algorithms like sorting searching and string manipulations with best optimized time and space complexities.

Performed troubleshooting, fixed and deployed many Python bug fixes of the main applications that were sources of data for both customers and internal customer service team.

Extensively used Fiddler, SoapUI and Postman for WCF service, Rest service testing.

Performed Unit testing on ReactJS applications using tools like Karma, Jasmine and worked with Gulp tool for build automation.

Used VB.Net and ADO.NET to define and implement Business Logic Layer and Data Access Layer.

Utilized AngularJS Services, Factory and Dependency Injection techniques to ensure an Inversion of Control (IOC) by focusing on minimizing the number of watchers in order to increase the performance.

Implemented AngularJS provider injection to handle the request to WebAPI (Build a factory to return each of the RESTful services)

Build Jenkins jobs to create AWS Infrastructure from GitHub repositories containing Terraform code.

Data conversion from any data source to MySQL database - custom code development configuration and implementation

Used Nuget package manager for consuming and managing the packages in the project.

Worked with the team to design, develop, test & implement system. Creation of database objects like tables, procedures using Oracle tools like PL/SQL, TOAD. Written Stored Procedures using PL/SQL.

Tested SOAP and REST web services using the different assertions like HTTP assertion, security assertions, and XPATH assertions in SOAPUI.

Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).

Created a dynamic reporting application which used reflection to see a list of available reports

Involved in designing and coding the various core components and UI Screens for the Outbound Interface in the Application using ASP.NET, AngularJS and Kendo UI.

Wrote and executed various RDBMS, MYSQL database queries from Python using Python-MySQL connector and MySQL db package.

Implemented AngularJS client-side form validation, format view results using various controls and filters

Used AngularJS and other front-end libraries and frameworks for developing robust front-end web applications.

Environment: .NET Framework 4.0, Visual Studio 2015, C# 5, ASP.NET 4.0, MVC 4, SignalR 2, ADO.NET, Entity Framework 6.0, SQL Server 2014, Oracle 11g, LINQ, RESTful API, WCF 4.0, HTML5, CSS3, AngularJS 1.3/1.4, AJAX, JQuery, Bootstrap, IIS 7.0, JSON, MSTest, Azure, Agile, Jenkins, TFS and Git

Client: NBC Universal Technology Center, NJ Nov 2015–Dec2016

Role: Full Stack Developer/Web Developer

Responsibilities:

Gathered Client requirements and converting them into the Technical Specifications and developed Web forms using C#.NET.

Introduced google-style code standards/code reviews to the UI team, lead others to write clean reusable UI code and angular JS

Applications logic was developed using C# and used HTML helper in a view to render the HTML content.

Implemented MVC framework to reduce the complexity and to get full control over the behavior of the application.

Worked on E-Commerce application development using ASP.Net (1.1, 2.0, 3.5, 4.0), AJAX Pro, Payment Gateways

Monitored the Cassandra and Mongo DB using the admin tools, ensuring proper management of the NoSQL databases.

Implemented of WCF services and better logging exception management support to help in the premature detection of new problems.

Work behind the scenes of the virtual meeting to ensure everything runs smoothly in Adobe Connect

Designed and Developed Backend Components such as Business Objects and Collections (Generics) using C# .NET for all WPF Controls.

Developed Microsoft SQL Server stored procedures and staging tables for pushing and pulling data to/from BizTalk.

Used Data Structures for storing the raw data received using Circular Queue.

Updated and re-designed several internal tools from VB.NET 2008 to VB.NET 2015 bringing current software standards which facilitated automation of mundane tasks for accounting department.

Implemented ADO.NET concepts to connect to the database. SQL. NET Data provider, Data Adapter and Data Set were used to retrieve and access data.

Built front-end SPA using HTML5, AngularJS, Bootstrap and backend server using ASP.NET Web API.

Worked on Integrating applications like (Web, Services, Mainframe, MS Office, GUI, Outlook etc.) using workflow, automation tools (Blue Prism).

Involved in coding with SQL, PL/SQL function, stored procedure, packages, triggers, and Materialized view for Oracle database.

Involved in integrating the change in the workflow to both test and allow error handling using Informatica IDQ

Defined AWS Security Groups which acted as virtual firewalls that controlled the traffic allowed to reach one or more AWS EC2 instances.

Designed WPF Forms, Custom Controls and User Controls using XAML language for interactive UI

Build servers using AWS, Importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.

Consulted on improvements to digital rights management system and Content management systems.

Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.

Created AngularJS Controller which Isolate scopes perform operations in UI.

Created Kendo UI Grid and Tab Panel based views with Responsive Design

Creating a responsive web application integrating Twitter Bootstrap with AngularJS and media queries.

Environment: .NET Framework 4.0, Visual Studio 2010, C#, ASP.NET MVC4, SQL Server 2012, Entity Framework 4.0, XHTML, CSS2, JavaScript, JQuery, AJAX, JSON, SSIS, SSRS, TFS, IIS7

Client: CompuCom Systems, Dallas, TX Oct 2014 – Nov 2015

Role: Sr.Net Developer

Responsibilities

Involved in Daily Scrums and Weekly Meetings with the project Sponsors to meet deadline and expectations following Agile Methodology.

Involved in migration of current VB application to MVC application using MVC5.

Designed and developed the core functionality of the application with the ASP.NET MVC Framework razor (C#.NET, Entity Framework)

Used ASP.Net MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Worked closely with the QA team to review and develop XML data standards and data sharing models Tested and researched integrations to meet functionality requirements

Updated the prototype using InfoPath and SharePoint designer as well as OOB tools to create a sample for the business users

Performed migration activities in preparation for a migration from SharePoint 2010 to SharePoint 2013.

Used ASP.Net MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions on the mode.

Experience in working with Splunk authentication and permissions and having significant experience in supporting large scale Splunk deployments.

Designed, developed, Implementation of C++ code on 32 bits to support enhancements, fixed bugs in the existing software.

Managed database operations such as partitioning, indexes, scheduled jobs, DML, DDL e.t.c

Custom programming in VB.NET within SQL queries solution to Databases.

Developed organizational units in Active Directory (AD) and managed user security with group policies.

Worked with SharePoint Designer workflows, Experience on InfoPath form templates, creating rules, section, actions, calculated formulas, promotional parameters

Used Backbone.js and React JS to create Controllers to handle events triggered by clients and send request to server.

Developed couple of Windows and Console applications as per business requirement using C# .Net and VB.Net.

Provided internet related services including web site design, front-end web development, domain name registration, web hosting, search engine optimization / submission.

Used AJAX on frontend web based GUI for an enhanced user experience.

Created and Consumed WCF Services responsible for Communicating and providing Real Time Data from integrated server to Client Application.

Extensively used User interface controls, which use JQuery to validate client side validation.

Implemented Database First EDMX and used LINQ to Entities to massage the Data and optimized the Query Expressions.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in Oracle 11g for inserting/Updating/Deleting the data into the relational tables

Refactored and enhanced an existing AngularJS application to follow strict MVC patterns.

Environment: .NET Framework 4.0, Visual Studio 2010, C#, ASP.NET, ADO.NET, SQL Server 2012, Entity Framework 4.0, XHTML, CSS2, JavaScript, JQuery, AJAX, JSON, XML, TFS, IIS 7

Client: CNA Insurance, Chicago, IL Feb 2013– Aug 2014

Role: .Net Developer

Responsibilities:

Mostly worked in ASP.NET with creation of new web pages and modification of existing pages.

Used data modeling and developed Use Cases, Class Diagrams and Sequence Diagrams using Enterprise Architect (EA/UML)

Developed new Web Pages, Custom User Controls for reusability in web portal. Extensive use of master pages.

Effectively used Model-View-Controller (ASP.NET MVC) Architectural pattern to decouple Data Access Logic and Business Logic from data presentation and user interaction.

Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud Infrastructure Azure

Resolved numerous ECM database, application and network stability and performance issues

Wrote complex Oracle, SQL queries, views, stored procedures and functions.

Developed reusable and optimized .NET components using Visual C#.NET.

Created Silverlight applications for interactive, Web-based data visualization using XAML in Visual Studio 2008

Used JavaScript and jQuery for client side validation of controls, wrote custom JavaScript functions where necessary.

Involved in developing the UI pages using HTML5, CSS, JavaScript, JSON, JQuery, Angular JS and Ajax.

Used Cascading Style Sheets (CSS) for consistent look and feel across Web pages.

Used AJAX for partial rendering of pages and preventing full post back.

Developed and consumed ASP.NET web services and WCF Services (ASP.NET 4.0) to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.

Used (Windows Presentation Foundation) WPF to build application for privileged users.

Involved in database design, normalization, indexing in SQL Server 2012 (T-SQL)

Involved in writing SQL queries and query optimization for improving performance.

Environment:.NET Framework 3.5, Visual Studio 2008, C#, ASP.NET, ADO.NET, JavaScript, HTML, JQuery, SQL Server 2008R2, Web Services.

Client: One Shield Inc. Marlborough, MA July 2012-Jan 2013

Role: C# .NET Developer

Responsibilities:

Developed application using Visual Studio 2010 with .Net Framework.

Actively involved in writing business logic in C# extensively used Object Oriented Programming fundamentals during all phase of web application development.

Developed client side validation using JavaScript.

Extensively worked on communication protocols such as RS232-TCP/IP, IGT protocol.

Created and consumed Web Services using SOAP.

Responsible for writing SQL queries, Store procedures, triggers using SQL Server 2008 R2.

Unit tested Business Layer and Data Access Layer using N-Unit.

Team Foundation Server is used for version control and collaboration of team effort.

Used JIRA for tracking the time of task and fixed issues in each sprint system testing.

Involved in Development of the n-tired application.

Microsoft.net Framework 3.5, ASP.net, LINQ, WCF, AJAX, JavaScript, jQuery, XMLWEBSERVICES.

Application is designed using MVC (Model View Controller) Façade Pattern Concept.

Proficient in JavaScript, jQuery, HTML5, CSS3 and AJAX

Migrating old Data into new Database using SSIS

Table and Stored Procedures designed using SQL.

Involved in Database Designing in SQL Server 2008 and T-SQL coding.

Implemented SQL Server Reporting Services (SSRS) and Crystal reports to deliver variety of interactive reports.

Environment: Visual Studio.NET 2010, VB.NET, C#, ASP, ASP.Net 4.0/3.5, .Net XML, XHTML, SQL Server, SQL Server Integration Services (SSIS), SSRS, Server Controls, IIS5.0, DMZ Configuration, Win2007/NT, Web Services, SOAP, ODBC, Web Forms, caching, CSS, UDDI, SOA, Android, Adobe Photoshop, JavaScript.

Client: Amura Infotech, India June 2011– MAY 2012

Role: Jr. Net Developer

Responsibilities:

•Interacting with Client to gather requirements and document all the requirements

•Involved in the Analysis, Design and Development of the enhancement system

•Designed User Interface with HTML and Cascading Style Sheets (CSS)

•Involved in creation of application setup and reports using ASP, HTML, DHTML, and Validations were performed using VBScript and JavaScript and J-query.

•Involved in Object Oriented Analysis and Graphic User Interface (GUI)

•Designing new software applications in C++ to meet business needs.

•Used AJAX techniques for Asynchronous Data Transfer.

•Used Web Services for communication with in different LOBs in the organization.

•Implemented Object oriented concepts effectively like inheritance, overloading, abstract class, etc.,

•Developed JavaScript and JQuery files for client-side validations.

•Created (BLL) Business Logic Layer and Presentation layer in VB.NET.

•Contributed significantly to design of the object model in the middle tier.

•Created Common DATA Access Layer (DAL) Using Visual Basic and ADO.NET.

•Involved in Database Design using SQL Server 2008 R2.

•Creating Packages and Stored Procedures.

•Environment: .Net Frame Work 3.5,Visual Studio 2005,ASP .Net 3.0, JavaScript, VB Script, VB .Net, HTML, Microsoft SQL Server 2005, Win Forms,Visual Source Safe( VSS), Java Script, CSS, Internet Information Services 5.0 (IIS)

Contact this candidate