Sql Server .Net

Professional Summary:

*+ years of experience in Requirements Analysis, Design, Development and Testing of various applications with involvement in all stages of software development life cycle.

Expert in implementing the applications using MVC, MVVM, Factory patterns and N-Tier architecture.

Hands on experience in design using N-tier architecture and Object Oriented Programming (OOPS) Principles like Encapsulation, Inheritance, Polymorphism, reusability and Design patterns like Abstract factory, Singleton, Object pool a standard solution to common problems in software design.

Extensive experience in .NET Technologies .NET Framework 4.5, 4.0, 3.5, 2.0, C#, VB.NET, ASP.NET, ADO.NET, LINQ.

Wrote test plans, tests suites, and test framework primarily using C# and VB script, Ajax, Silverlight, XML, PowerShell, etc.

Expertise in developing front-end layouts, navigations with JavaScript, Bootstrap, MV frameworks such as Angular 2.0, Angular JS, Backbone JS and Node JS as a platform for Web applications.

Experience on developing latest version of Object Oriented JavaScript Libraries like AngularJs 1.4/1.5/1.6/2.0, Cordova Node Js, REACTJS, Backbone Js.

Expertise in Programming, development and design applications using Microsoft Technologies like C#.NET, VB.NET, Typescript, Telerik controls, ASP.NET, ADO.NET, Web API, WCF, PRISM, Web Services, WPF.

Experienced in developing web-based applications using Python, XML, CSS, HTML, Java Script and JQuery.

Experience in Content Management System with Adobe CQ5.5, AEM 5.6 and AEM 6.0.AEM 6.1 Better understanding of Classic/Touch Modes. Worked on Adobe CQ/AEM product suite, including CQ/AEM, CRX, CQ WCM and DAM. Experience implementing, enhancing, and troubleshooting.

Solid understanding of Object Oriented Analysis and Design (OOD& OOPS) Dependency Injection, UML and RDBMS principles.

Developed procedures to unify, streamline and automate application development and deployment procedures using Linux container technology with Dockers.

Expertise in Docker containers and its configuration based on requirement, maintaining the Dockerhub for container.

Good in creating stored procedures, Triggers, Functions and Optimizing Queries for performance by looking at execution plan using MS-SQL Server 2008/2012.

Good report creation skills using Microsoft Reporting Services (SSRS), SSIS with proficiency in using Report Designer as well as Report Builder.

Extensive experience in Agile SCRUM, Waterfall, Iterative and TDD methodologies.

Good Experience in front end design and script programming using HTML5, JavaScript, CSS3, jQuery, AJAX and XAML, Phone gap, Sencha Touch, node.js with iOS and Android.

Develop the Design and workflow of the fetching data in real time on big data databases like MongoDB and postgreSQL.

Experience in creating Services and Endpoints using WCF and working with Windows Communication Foundation (WCF).

Worked on ASP.NET MVC 5 application using C#, Web API, HTML, CSS, JavaScript, JQuery, Entity Framework, AngularJS, TypeScript, C# 6 and SQL Server

Experience in developing Language-Integrated Query (LINQ) queries to retrieve data from different data sources (LINQ to Entities, LINQ to XML, and LINQ to SQL).

Experience in developing applications using Web Services, WCF, REST, WPF and SOAP.

Experience of data modelling concepts for designing databases/data warehouses and good knowledge on Source Control Management concepts.

Experienced in XML Web Services (SOAP, WSDL), Service Oriented Architecture [SOA] concepts using .NET Framework.

Experience in performing Unit and Integration testing in the Development. And experience in VSS, Bug Reporting and Fixing.

Experience in making Responsive Web Pages using Media Queries, MVC .net framework and Bootstrap. Expertise in using Twitter Bootstrap Framework responsive design.

Experienced with Configuration Management Tools like Visual Source Safe (VSS), Team Foundation Server (TFS) and Sub Version (SVN).

Experience in working with Cloud platforms - Service Now Amazon AWS. Worked with various AWS EC2 and S3 CLI tools.

Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions such as Amazon Web Services (AWS)

Experience in designing and branding Master Pages utilizing Server Controls, User Controls, Data Grid control, Forms Validation controls, Custom controls and CSS.

Experience in securing web applications using ASP.NET authentication (Forms-based Authentication) and authorization mechanisms like authorizing Users, Roles and User Account Impersonation.

TECHNICAL SKILLS:

Programming Languages

C, C#.Net 4.0/3.5/3.0/2.0, VB.Net 10.0/9.0/8.0, T-SQL, PL/SQL

Web Technologies

ASP.Net 4.5/4.0/3.5/3.0, ASP.Net Ajax 3.0/2.0, Java Script, JQuery, VB Script

XML Technologies

XAML, XML, XDOCUMENT, XSLT, XPATH, XSL

UI Technologies

Win Forms, WPF, Web Forms, HTML, CSS

Databases

MS SQL SERVER 2012/2008/2005/2000, MS Access 2010/2007, Oracle 10g/9i

IDE Tools

Visual Studio 2013/2010/2008, SQL Server Management Studio

.Net Technologies

Net Framework 4.5/4.0/3.5/3.0/2.0, ASP.NET MVC 4/3/2, C#.Net, ASP.Net, ADO.Net, WCF, Web API, Web Services, Entity Framework 5.0, LINQ

Reporting Tools

SQL Server Reporting Services SSRS 2012/2008/2005, Crystal Reports 2010/9/8.5/8

Version Control Tools

Visual SourceSafe 2005, Subversion, Team Foundation Server 2013/2012/2008

Modeling Tools

UML, MS Visio 2010/2007

Servers

WCF, ADO.Net 4.0/3.5/3.0/2.0, MSMQ, Web Services, Enterprise Library 5.0/4.0/3.1

Professional Experience:

Client: Genomic Health Inc.

Redwood City, CA

Senior .Net Developer June2017– Present

Description: Genomic Health, Inc. is the world's leading provider of genomic-based diagnostic tests that help optimize cancer care by addressing the overtreatment of the disease, one of the greatest issues in healthcare today. With its Oncotype IQ Genomic Intelligence Platform, the company is applying its world-class scientific and commercial expertise and infrastructure to lead the translation of clinical and genomic big data into actionable results for treatment planning throughout the cancer patient journey, from diagnosis to treatment selection and monitoring.

Responsibilities:

Involved in gathering information from clients, analyzed the information and provided with thebest solutions, which meet client's requirements Involved in all phases of project lifecycle i.e. Requirement gathering, analysis, design, application development and testing for the project.

Programmed application using C# 4.5 and implemented architectural UI design using ASP.NETMVC 4.0, CSS, HTML, XML.

Developed ASP.Net modules using MVC 4(Model-View-Controller) pattern.

Worked on the existing ASP.NET Web Forms and involved in designing and developing the GUIfor the user interface with various controls (Component Art Grid View, Data List, Textbox,Calendar, List Controls, Dropdown, and Validation Controls etc.)

Created the database and developed SQL Queries, Stored Procedures, Views, Functions, Triggersusing SQL Server.

Handled Client-side validations using AngularJS, JavaScript, jQuery along with ASP.NET built-incontrols like Range Validator, Compare Validator and Regular expression validators inASP.NET

Used .Net framework 4.5, n-tier architecture and Object-Oriented Methodologies forapplication development.

Thoroughly worked on AJAX for Client-side and Http Handlers files for Ajax implementation inthe user controls/Web pages.

Used Ajax, JQuery, AngularJS and JavaScript to minimize number of Page Refresh and build richinteractive UI across the web pages in the application.

Built Interactively Web forms using Web Controls.

Implemented HTML Helper MVC Web Grid with JQuery, Win Forms for boosting the paginationperformance, and loaded the graphical data with JSON. Also supporting custom searching alongwith sorting the data with partial view.

Used React JS in components like creating React components, Virtual DOM, React Props,Lifecycle methods, working with React States and Events.

Used REST architectural model in web service development part, and also RESTful web serviceswhich implements both principles of REST and HTTP.

Create Database(s) on SQL AZURE.setting up SQL Azure Firewall.Create, manage SQL Server AZURE Databases.

Setting up Connection Strings and connecting SQL Server AZURE Databases from locallyInstalled SQL Server Management Studio(SSMS) for Developers.

Used Web API to build RESTful web services to interact with ASP.NET MVC modules as well

Implemented Knockout.js functionalities for a stand-alone web portal.

Extensive use of Web Services, SOAP, XML, XSLT to expose the reports to facilitate information sharing.

Designed, developed SOA Web Services using WCF Services with C#.NET and Hosted on Internet Information Server (IIS).

Used React JS for templating for faster compilation and developing reusable components and also stable React components and stand-alone functions to be added to any future pages.

Implemented Angular JS to bind the data with Angular validation to HTML controls from the entity model.

Implemented access to Web Services by consuming WSDL, which are created and accessible in SharePoint.

Implemented LDAP authentication to identify users against active directory.

Used Dataset, Data Table, Data Adapter, Data Reader and other ADO.NET connectivity controls and worked with Entity frame work.

Created Entity classes and used LINQ (Language Integrated Query) to SQL to manage relational data as objects.

Developed SSIS packages for data transformation to SQL Server for various billing and reporting needs.

Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS and SSIS.

Implemented Unit Testing through MS Test and created tests for all functions used in the application.

Used the Debugging and Tracing features of Visual Studio.Net Extensively.

Fixing bugs reported by QA and performed unit testing using NUnit.

Utilized the TFS source control software to keep track of new and past versions of code written in my application.

Environment: ASP .Net MVC 4.5, C#, .Net 4.0, WCF service, ADO .Net, SQL Server 2012. Net

Framework 4.5.2, Visual Studio 2012, WPF, XSD, XAML, AWS, Dynamo DB, PRISM 5.0, MS Visual Studio, ADO.NET, T-SQL, Win Forms, NHibernate 4, Modernizer, VB.NET, WSDL, Entity Framework 6, Oracle,SQL Developer 4, Oracle Client 12C, Fiddler Web Debugger, Tortoise SVN, Agile Scrum

Client: Tiffany &Co,Parsippany, NJApril 2016 to Mar 2017

Role: Sr. .NET Developer/Web Developer/Angular Developer

Description: Tiffany & Co. operates jewelry and specialty retail stores and manufactures products

through its subsidiary corporations. Its principal subsidiary is Tiffany and Company. The Company

Operates TIFFANY & CO. retail stores and boutiques in the Americas, Asia-Pacific and Europe and

Engages in direct selling through Internet, catalog and business gift operations. Other operations include

consolidated results from ventures operated under trademarks or trade names other than TIFFANY &

CO.

Responsibilities:

Requirements gathering, Analysis and Design of all the client requirements.

Software development using Agile Software Development methodologies.

Development of most of the User and Custom Controls and XAML views in WPF.

Studied the use case diagrams to gather functional requirements. During the design phase participated in discussions with the client regarding system requirements and contributed for the preparation of flow document.

Developed the front-end screens in ASP.NET and C# .NET using Visual Studio 2008.

Used front-end web development tools like AngularJS, JavaScript, Typescript, HTML, CSS, and JQuery.

Utilized Entity Framework code first for backend with Bootstrap and jQuery for the front-end styling and actions

Used ADO.NET and Enterprise Library Ado.net Application Blocks to access data from database.

Used AngularJS as the development framework to build a single-page application.

Utilized AngularJS as the framework and done CRUD operations.

Created Python/MySQL back-end for data entry from Flash.

Worked on Presentation, Business, Entity and Data Access Layers.

Writing business and data access components (as separate assemblies) in C# utilizing ADO.NET transaction management.

Designed and developed of UI web pages using JavaScript, CSS3, JQuery and HTML5.

Designed responsive and intuitive user interfaces for the web using CSS and custom AJAX scripts and JQuery.

Created Web APIs using ASP.NET Web API allow new web/client projects to leverage reusable data.

Created job chains with Jenkins Job Builder, Parameterized Triggers, and target host deployments. Utilized many Jenkins plugins and Jenkins API.

Used BizTalk Server to understand the plain text data (in the form of xml), and with different systems which has several inbuilt adaptors like SQL Adapter, MSMQ Adapter, SMTP Adapter, File Adapter, SOAP Adapter etc.

Developed SQL Procedures and Queries for data retrieval and storage in SQL Server and implemented in portal using ADO.Net.

Developed solutions for diverse programming scenarios in C#, employing Object Oriented Programming (OOPS) concepts such as Encapsulation, Inheritance, Polymorphism, and Abstraction.

Implemented Continuous Delivery Pipeline with Dockers and Github.

Worked with Web API Routing prefixes on the controllers.

Developed independent ASP.NET Web API Carrier and Subscriber RESTful Services over.NET Framework with XML responses to integrate with Exchange Enrollment applications.

Highly proficient in Transact SQL (T-SQL) and PL/SQL Queries including writing queries, complex stored procedures, functions and triggers in SQL Server and Oracle.

Implemented HTTP protocol and SSL to secure the information between WCF Service and Client.

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

Validating all the User’s Inputs through Java Scripts.

Created and deployed XML Web Services (WCF) using ASP.Net and C#, used them to generate the proxy class files based on the web services and consumed in web application.

Generated Reports using Telerik report for Action Track Project and used Telerik RAD control Data Grid.

Implementing automation testing and done unit tests.

Created Service Layer using C# and WCF.

Develop the Documents for Logging/Error Handling for SSIS Packages.

Integrate the SSIS package, converting all existing DTS packages of MS SQL 2005 to 2008 by adding extra SSIS task.

Used ADO.NET extensively to interact with SQL Server(T-SQL) and Oracle Writing Stored procedures for SQL Server and Oracle.

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

Created views in MVC using Razor Syntax.

Worked on TFS for version control, Code Review and for automatic builds and continuous integration.

Developed Reports using MS SQL Server Reporting Services (SSRS).

Automate code Deployment using configuration Management tool like puppet.

Environment:C#.Net, ASP.NET 3.5, Visual basics studio 4.0/4.5, AWS, Microsoft Data access application blocks, Exception and logging frameworks, Containers, Dockers, Jenkins, Windows Services, Saas, Xamarin, Bootstrap, JavaScript, Typescript, SQL 2014/2012, Angular JS, XML, XSD, HTML 5, CSS3, MVC, Silver light, TFS, Telerik Reports, Oracle 11g, SSIS, IIS 6.0, Visual Source Safe 6.0, Windows Server 2003, Visual Studio 2008, WCF.

Client: South Carolina State Government, Columbia SC Jan 2015– Mar2016

Position: Sr.NET Developer

Project Description: South Carolina State Government, headquarter at Columbia, SC, encompasses the administrative structure of the U.S. state of South Carolina, as established by the South Carolina State Constitution. It provides business, education, employment, environment, government, health, housing, military, safety and justice, taxes and transportation services SC state healthcare has built a new end to end Medicaid Management Information System (MMIS) platform called Health Enterprise. This project is to customize the Health enterprise product as per South Carolina state requirements. It also provides care coordination and management, health information analysis, and fraud and abuse protection services.

Responsibilities:

Worked with Business Analyst's and Project managers to drive out requirements and implemented an elegant solution to the task at hand.

Implemented Model View Controller (MVC) Pattern in the application development.

Designed and developed web based UI in C# using different controls like HTML Controls, Data Controls and Web Controls.

Extensively worked in developing Stored Procedures and Functions in Oracle.

Extensively used Angular JS for DOM traversing and manipulation.

Involved in Database modeling, creating tables and in writing stored procedures using Oracle PL/SQL.

Used XML to create Web-based tools for transactions on SQL and Oracle databases.

Provide guideline and code samples to improve system performance, using Visual Studio 2008, Silverlight, SQL Server, Crystal Report 2008, Telerik Report.

Developed SQL Queries and Procedures for storage and retrieval of data using ADO.Net and LINQ to SQL.

Worked on Web Service calling using JQuery and AngularJS for Synchronous and Asynchronous Ajax calls in HTML5 web pages.

Used ASP.Net Web API for HTTP based RESTful Services using JSON message format achieving usage of less bandwidth for server communication.

Implemented features of ASP.Net such as Calendar Controls, Repeater Control and Security using form authentication and used ASP.Net Validation controls to do server-side validations and client-side validations based on the user’s browser.

Installing Oracle on various Operating Systems and migrating Oracle databases from Oracle 9i to 10g.

Used ASP.Net AJAX extensively for calling Web Services without writing a lot of custom JavaScript code to handle the request and response messages.

Used JavaScript extensively to enhance the UI and to make application looks more dynamic and to perform client side validations.

Implemented XML Web Services in C# based on SOAP protocols using XML and XSLT extensively for data transfers.

Involved in developing Web Services and invoking them by using XML SOAP tool for creating proxy classes.

Created WCF Services and Client Proxy for communication between Application Server and Web Server.

Developed Restful service using WCF framework and used Angular Js for getting data.

Designed WCF the front end using XAML Browser WPF for Rich UI.

Used JQuery and JavaScript to reduce the turnaround time of retrieving data from the data base.

Created data access layer to communicate with the SQL Server Database with ADO.Net objects.

Worked on ADO.Net components SQL Connection Object, SQL Command Object, Data Reader, Data Adapter, Data Set and Data View to provide communication to the database.

Created Stored Procedures, Functions, and Triggers using T-SQL in SQL Server 2008 to insert, update, and delete data inside tables.

Development of enterprise reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).

Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.

Worked with Bootstrap framework and AngularJS to Design single page application.

Implemented Unit, Integration and System Testing using NUNIT.

Responsible for maintaining versions of source code using Team Foundation Server.

Environment: .NET Framework 4.0/3.5(Visual Basics), Visual Studio 2010, ASP.Net 4.0, C#, ADO.Net, MVC AJAX, IIS, Share Point 2010, Web Services, SOAP, Telerik, Saas, AWS, WCF, HTML5, CSS3, XML, SSRS, JavaScript, Angular JS, SQL Server 2008, Oracle 9i, Bootstrap, SSIS, Team Foundation Server(TFS), Windows Server 2003.

Astoria Financial Corp, Lake Success, NY Aug 2013– Nov 2014

Role: .Net Developer

Astoria Financial Corporation is the unitary savings and loan holding company of Astoria Bank and its subsidiaries. The Company’s principal business includes the operation of its wholly owned subsidiary, Astoria Bank. Astoria Bank’s business is attracting retail deposits from the general public and businesses and investing those deposits, together with funds generated from operations, principal repayments on loans and securities and borrowings, in multi-family and commercial real securities.

Responsibilities:

Involved in SDLC followed by agile methodologies to produce high quality software model using N-Tier Architecture.

Based on the requirement collected from the Business analyst, created use case and design documents.

Designed web application using three–tier architecture.

Designed the application based on MVC design pattern.

Developed and designed web forms using ASP.NET, C# and XAML.

Designed front end UI with help of ASP.NET, Ajax Controls, and CSS.

Implemented web based front end using ASP.NET, JQuery, CSS, HTML controls and business logic using C#.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports usingSSRS.

Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

Promoted RDLs to Reporting Service Server (SSRS).

Generated parameterized reports, sub reports, tabular reports usingSSRS2012.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.

Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports usingSSRS2012.

Efficiently implemented Data and control templates to dynamically change the behavior and appearance of the UI Control using XAML for WPF application.

Used Ajax Update Panel for faster post back of the data.

Designed Presentation Tier (web pages) using the Master Pages, Themes, Skins by utilizing HTML.

Implemented a separate query processing using LINQ and created data entry web applications, with LINQ to SQL CRUD operations.

Created and consumed WCF Web Services.

Used Windows Authentication Mechanism for successful Authorization and Authentication of the Credentials related to the application.

Environment: ASP .NET3.0, ASP.NET MVC, Microsoft Visual Studio 2008, C, HTML4, XML, CSS, JavaScript, LINQ, WPF, Entity Framework, IIS, TFS, Win Forms, SQL Server 2008, ADO .NET.

JSV Software Ventures, India, Hyderabad, India. June 2010 – Sep 2012

Position: .Net Developer

Project: LVIS Life Time Vehicle Information System (LVIS)is an information supplier for Hero Honda True Value, Hyderabad. LVIS publishes valuations for used cars, new car pricing reports and valuations of other vehicles. LVIS is used by the car manufacturers, car dealers, financial institutions, and insurance companies.

Responsibilities:

Used C#.NET and ASP.NET to design the user interface.

Analyzing the data from various sources like car manufacturers, car dealers, financial institutions, insurance companies, and auction systems.

Communication with domain experts.

Worked with SQL Server at the back-end.

Used ADO.NET to connect to the database.

Used SQL statements to create the tables and views.

Data Coding for two modules, namely, New Car, and Used Car.

Coded classes to connect to the centralized database.

Reporting the deliverables status to the client.

Implementation at the client side and maintenance.

Environment: C#.NET, JavaScript, ASP.Net 2.0, Visual Studio.NET 2005, ADO.NET, XML, SQL Server 2005, IIS 5.0, VB. Net6.0, Web Forms, CSS.

Education:

Bachelors in Computer Science Engineering, India

Contact this candidate