Sql Server .Net

Swetha Bogaram

Senior .Net Developer

Cell: 732-***-****

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

Professional Summary:

.NET Developer with 8+ years of experience in various phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Deployment and Maintenance of web applications.

Hands-on experience in UI Design using Win Forms, Web Forms, and programming ASP.NET, C#.NET, VB.NET, ADO.NET, JavaScript, LINQ, AJAX, jQuery by using .Net Framework 2.0/3.0/3.5/4.0.

Designed and Implemented Data Access Layer (DAL) using C#.Net to communicate with SQL Server 2000.

Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Solid experience in Client side frameworks Angular JS, Knockout JS, JavaScript.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Utilized SQL Server Job Scheduling to schedule jobs to run at regular intervals.

Utilized various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

Extensively used Windows Communication Foundation (WCF) & Web services for Web applications using SOAP, WSDL, UDDI

Expertise in using Language Integrated Query (LINQ) providers for data manipulation.

Experience in using AJAX controls in ASP.NET Sites/applications and interacting asynchronously with ASMX Web Services.

Extensive experience in XML, XML Web Services, WCF, WPF, XSLT & Security in ASP .NET.

Experience in using third party controls like Telerik, Infragistics

Expertise in Web-Development technologies like, HTML, ASP, XML, XSD, JavaScript, JSON and jQuery.

Extensive database designing and programming skills using SQL Server 2000/2005/2008, Oracle 9i/10g, XML data source, RDBMS and MS Access.

Implemented Object Oriented Programming (OOP) concepts in most of the applications.

Experience in reporting and analysis using Crystal Reports, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) with the .net environment.

Designed and developed Use Cases, Class diagrams and Sequence diagrams using UML.

Experience in using AJAX controls in ASP.NET Sites/applications and interacting asynchronously with ASMX Web Services.

Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Worked on .NET framework to migrate existing ASP to ASPX as well as creating new ASPX pages. This includes component creation using VB.NET, ASMX Web services creating and consuming in ASPX pages, data access using ADO.NET to connect SQL Server and Oracle database.

Expertise in developing N-tier web applications using ASP.NET, C#, VB.NET, AJAX, XML, ASMX Web Services, ADO.NET, SharePoint Server, IIS 5.x/6.0, JavaScript, CSS, and HTML

Worked extensively with MS SQL Server, MS Access databases and knowledge in Oracle 10g/9i

Working extensively with JavaScript framework like Knockout JS.

Experience in Creation of Web User Controls and Web Custom Controls.

Good experience in deploying and testing web applications on IIS 5.0/6.0.

Experience in using Visual Source Safe (VSS), Team Foundation Server (TFS)

Experience in analytical and technical skills and developing systems using different software methodologies like Agile and Waterfall.

An innovative team player proven to work under tight deadlines, Adaptable to new software technologies, quick learner and can work efficiently as an individual.

Technical Skills:

Web Technologies

ASP.Net, ASP, CSS, HTML, jQuery, AJAX, JavaScript, Web Services, ASMX, Angular JS, Knockout JS

Net Technologies

VC#.Net, ASP.NET, ADO.NET, VB.NET, VC++.Net, .NET Framework

SharePoint Services

MS SharePoint Designer 2007, MS InfoPath 2003/2007

Languages

C#, C++, PL/SQL, XML, UML, HTML, Kendo UI, UNIX Shell Scripting

Operating Systems

Windows NT/2000/XP/vista, Win 32, Linux and UNIX

RDBMS

Oracle 7.x/8i/9i/10g, SQL Server, MS-Access

Version Control

Visual Source Safe 6.0, CVS, TFS and PVCS

Component Technologies

Crystal Reports, COM, DCOM, ActiveX

Professional Experience:

Client: Blue Cross Blue Shield - Detroit, MI Mar 2016 – Till Date

Project: NASCO

Role: Senior .NET\SharePoint Developer

Description: Finalised claims breakdown to show how much time/cost is being spent on processing claims for different Segments and groups. Combines DPA, various finance sources and finalized claims extracts. Claims that are pending for different departments over ages, workable claims. This project is designed using .Net Framework, Web Services, ASP.Net, ADO.Net and C#.Net with an intension to serve different clients. All the Code-Behind Classes have been implemented using C#.Net. SharePoint 2007 State machine workflows have been designed to address this complex process. The developed workflow applications to eliminate many manual steps and provide additional benefit in capturing metrics basically corresponding to each stage of the workflow. Reports are generated based on the workflow history and tasks the list for the management to monitor the status and to analyze the delays in the processes.

Responsibilities:

Developed the user interface in ASP.Net using C#.Net as code behind language.

Familiarity with development in JavaScript utilizing frameworks such as Angular JS.

Used JavaScript and CSS easily to handle each situation whether a browser supports feature or not.

Developed a new web application utilizing ASP.NET MVC, AngularJs, Kendo UI, and Bootstrap which provides performance data visualization to users.

Developed new user interface components for different modules using Kendo UI

Using DOM with java script to update, manipulate asp.net web server controls.

Designed developed Screens for Mortgage broker and loan officer hierarchy and admin ASP.Net Pages using Visual Studio.NET.

Responsible for building an internal, responsive Angular JS single page application.

Used Angular JS to execute expressions directly within HTML page.

Extensively worked with Angular JS, MVC 3 framework to organize our web application

Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS). Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Worked with my team member to add mobile support using jQuery Mobile and Knockout.js. This was used as a selling point for our software

Created knockout.js widget subsystem within a .NET dash dashboard using typescript and inheritance. Widgets needed to react to page controls changing to refresh data and browser resizing to change styling for responsiveness

Developed the administrative UI using Angular.js and Kendo UI

Used Bootstrap and AngularJS for developing modules in front end

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Generated several drill down and drill through reports using SSRS.

Expert in creating Star schema cubes using SSAS.

Designed and developed web forms with ASP.Net, JavaScript, jQuery and HTML5.

Designed and implemented many support tools using ASP.NET MVC, WEB API, JavaScript

Involved in developing requirements with C# 4.0, ASP.NET, WCF and Web services in .Net 4.0 Technologies, Ajax Controls and unit testing, system testing and release management.

Designed and developed web forms with ASP.Net, JavaScript, jQuery and HTML5.

Designed and implemented many support tools using ASP.NET MVC, WEB API, JavaScript

Involved in developing requirements with C# 4.0, ASP.NET, WCF and Web services in .Net 4.0 Technologies, Ajax Controls and unit testing, system testing and release management.

Developed search functionality by creating a custom search results page with Share Point Object Model (C#) based on the pre-existing SearchResults.aspx which uses the built-in SharePoint search functionality and manipulates the results to display metadata. Results are displayed in Data Grid.

Migrated SQL data to the SharePoint lists and synchronized them for the daily updates.

Worked with event handlers for handling various user events.

Created custom sequential workflows and associated them to the SharePoint list.

Used ADO.NET for data retrieving, querying, storage and manipulation interface screens developed using MVC.

Used ASP.NET 4.5 MVC framework to support the use of Dependency Injection to inject objects into a class.

Used Web Services (SOAP, WSDL) for communicating with other application and component

Designed and developed custom SharePoint Workflows for the document routings, Approvals, Corrections to handle the Material Management modules like, New Raw Material Request and Raw Material Change Request using InfoPath 2007, SharePoint designer.

Environment: ASP .Net 4.0, Web Forms using C#.Net, Knockout JS, AJAX, Bootstrap, AngularJS, Kendo UI, JavaScript, XML, SQL Server 2008, MS Visual Source, Oracle 9i/10g/11g SQL, PL/SQL, MS SharePoint Designer 2007

Client: John Deere Landscapes- Troy, MI Oct 2015 – Mar 2016

Project: Nursery Purchasing System

Role: Senior .NET\SharePoint Developer

Description: It is a web based application to maintain stock information, sales/purchase, shipping and invoicing information. This project is designed using .Net Framework, Web Services, ASP.Net, ADO.Net and C#.Net with an intension to serve different clients. All the Code-Behind Classes have been implemented using C#.Net

Responsibilities:

Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).

Involved in Analysis, Design and Development of the application and database.

Handled the SQL Server data tables to the WSS custom list. Synchronized SQL data with the respective List items on the SharePoint server for daily updates.

Developed the user interface in ASP.Net using C#.Net as code behind language.

Used Editable Data Grid Controls to generate responses based on client requests.

Developed third party components used in ASP.NET that are UI based using the latest .NET Framework.

Generated Crystal Reports to display the statistics based on user request selecting options

Worked with my team member to build a layered Knockout.js binding system to support partial views. This allowed the partial views to contain the JavaScript functionality that was associated with them, making them both reusable and much more maintainable compared to a pure jQuery system.

Developed the data grids using ng-table and Kendo-grid.

Built Web pages that are more user-interactive using AJAX, JavaScript, Kendo UI and AngularJS.

Created custom SharePoint sites, sub sites, Document Libraries, Lists and List views to collaborate the Affiliates using visual studio 2005.

Created custom SharePoint Web Parts using Visual Studio 2005, asp.net, C# with Microsoft. SharePoint and Microsoft. SharePoint. Webpartpages object model.

Supported third party controls used in ASP.NET platform

Involved in implementing Referential Integrity and Cascade deletion in database by creating primary key constraints, foreign key constraints and triggers etc.

Used ADO.Net for data querying, storage and manipulation.

Designed and Implemented Data Access Layer (DAL) using C#.Net to communicate with SQL Server 2000.

Develop user interface by using Telerik Kendo UI, jQuery, JavaScript, Json, AJAX, and HTML5.

Used Custom Validators, Validation Controls and performed validations both on client side and server side

Used Datasets for temporary storing and manipulation of data.

Responsible for the integration of software modules (version control and packaging releases).

Loaded Data into Oracle Tables using SQL Loader.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Developed SQL Stored procedures, Triggers, Functions, Views and cursors to interact with the database.

Documented developed components and module.

Enhancements to the existing system to add additional functionality to meet users’ requirements

Actively involved in writing test cases, testing scripts for developed modules and forms

Environment: ASP .Net 4.0, Web Forms using C#.Net, AJAX, JavaScript, Kendo UI, AngularJS, XML, SQL Server 2008, MS Visual Source, Oracle 9i/10g/11g SQL, PL/SQL

Client: Mercedes Benz Financial Services - Farmington Hills, MI

Project: Remarketing Applications Sep 2013 – Sep 2015

Role: .NET Developer

Description: Remarketing applications, manages Mercedes Benz financed Car accounts that are primarily leased; it also contains few retail, MBUS, Balloon and Gold Key accounts. It is an intranet application handling consumer accounts for US and Canada and helping MB (Mercedes Benz) US and Canada to remarket units in numerous ways by providing quotes for Lease Extension or Lease to Retail Conversion, Disposal of units at Dealer location or Internet Auctions or Physical Auctions etc. The primary business objective of this Remarketing application is to leverage the inherent powers of the Internet, bringing buyers and sellers together virtually, eliminating the time and overhead associated. So, the systems can conduct business, 24 hours, 7 days a week.

Responsibilities:

Worked on Technical documentation for the project and involved in requirement analysis and application designing sessions with business analysts and team members for the development

Supported third party controls used in ASP.NET platform

Involved in customizing the third-party Data grid controls(Infragistics)

Developed custom controls using third party controls(Infragistics)

Developed rich front-end UI using ASP.Net and AJAX controls, Silverlight and enhanced the User interface as per the requirements

Used front end web development tools like CSS3, JavaScript, DHTML, and jQuery.

Used HTML5 controls and server controls and developed user controls.

Developed and tested user friendly navigator by utilizing JavaScript and VB.NET.

Created applications by using vb.net and enhancement of the projects for .net applications.

Worked on .NET framework to migrate existing ASP to ASPX as well as creating new ASPX pages. This includes component creation using VB.NET, ASMX Web services creating and consuming in ASPX pages, data access using ADO.NET to connect SQL Server and Oracle database.

Worked with my team member to add mobile support using jQuery Mobile and Knockout.js. This was used as a selling point for our software.

Provide coding, maintenance and enhancements to mobile application.

Ensure that new feature is added and old features are enhanced in the mobile.

Implemented N-Tier Architecture and integrated the UI with Data base for data retrieval and manipulation using ADO.NET data objects and ADO.NET Entity Framework.

Loaded Data into Oracle Tables using SQL Loader.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Implemented over 100 unit tests to improve software quality using Nunit.

Designed and developed web forms with ASP.Net, JavaScript, jQuery and HTML5.

Designed and implemented many support tools using ASP.NET MVC, WEB API, JavaScript

Involved in developing requirements with C# 4.0, ASP.NET, WCF and Web services in .Net 4.0 Technologies, Ajax Controls and unit testing, system testing and release management.

Used ADO.NET for data retrieving, querying, storage and manipulation interface screens developed using MVC.

Responsible for building an internal, responsive AngularJS single page application

Defined new validations through AngularJS for the form field validation implemented through HTML5.

Developed a new web application utilizing ASP.NET MVC, AngularJs, Kendo UI, and Bootstrap which provides performance data visualization to users.

Used ASP.NET 4.5 MVC framework to support the use of Dependency Injection to inject objects into a class.

Used Web Services (SOAP, WSDL) for communicating with other application and component

Expertise in Win forms applications, ASP.NET, XML, ADO.NET and TFS

Involved in creating database design along with complex stored procedures, Triggers and user defined functions using SQL Server.

Environment: .NET Framework 4.0, Entity Framework 4.0, Nunit, Crystal Reports 10/2008, ASP.NET, VB.Net, SQL Server 2008, Oracle 9i/10g/11g SQL, AngularJS, PL/SQL, Visual Studio 2010, TFS, XSLT, MVC 4.0, Web API, jQuery, CSS3, HTML5, WCF, Kendo UI, JavaScript, Ajax Controls, N-Tier Architecture.

Client: Citrix, Fort Lauderdale FL Sep 2012 - Aug 2013

Project: Marketing/ Receipting System

Role: Sr. Net Developer

Description: This project involved various modules including Marketing/ Receipting System. The marketing web site developed using .NET using, this application followed N-Tier architecture, Receipting System module is a .Net 3.5 E Commerce application used to accurately receive and log invoice payments, the project removed the existing cash receipting system, which was out dated. The use of .Net technologies enables less support and maintenance issues for the Clerk's office and is cheaper and less difficult to maintain and support.

.

Responsibilities:

Involved in requirement analysis and application designing sessions with business analysts and team members to outline the proposed IT solution.

The BAT project is implemented based on MVVM

Designed, coded and modified applications by implementing knowledge of VB .Net.

Used JSON Serialize in data contract of WCF to generate the data in JSON format

Improved the performance of web pages by implementing AJAX controls

Designed the screens using CSS3, JavaScript, DHTML, and jQuery.

Designed the web UI using MVC Razor Engine, HTML5, XSL/XSLT, JavaScript, CSS3.

Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports

Designed and developed Oracle forms & reports generating up to 60 reports.

Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Created functional automation scripts using open source tool selenium.

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

Developed third party components used in ASP.NET that are UI based using the latest .NET Framework.

Used Selenium IDE for Open source web testing

Supported third party controls used in ASP.NET platform

Developed Angular / .NET web application using Angular.JS, JavaScript, ASP.NET MVC 4, C#, Visual Studio 2013.

Expertise in Win forms applications, ASP.NET, XML, ADO.NET and TFS

Experienced with .Net WinForms and reporting tools, such as Crystal Reports

Initiated the unit tests development process and created tests using Nunit.

Used ASP.NET membership concept for authentication/authorization framework

Used .Net framework 4.0, n-tier architecture and Object-Oriented Methodologies for application development.

Developed and tested user friendly navigator by utilizing JavaScript and VB.NET.

Developed an AngularJS workflow manager leveraging Angular-UI's state router for flexible configuration and management of multi-step user input flows.

Used PL/SQL to create Packages, Functions, and Procedure.

Developed Web Services and invoking them by using XML SOAP and WSDL for creating proxy classes.

Experience in writing Data Access Layers using ADO.net entity Frame Work and LINQ to SQL.

Involved in designing and developing the GUI for the user interface with various controls (Component Art Grid View, Data List, Textbox, Calendar, List Controls, Dropdown, Validation Controls etc.).

Develop Business logic layer by implementing Object Oriented Programming languages (OOPS) CONCEPTS abstraction, encapsulation, inheritance, polymorphism in C#.

Implemented session management concept

Used ADO.NET for the database access using SQL Server Data Adapters.

Created the database and have written stored procedures using SQL Server 2008

Used ASP.NET web form controls such as Grandview, List View, etc. for displaying data

Designed and implemented many support tools using ASP.NET MVC, WEB API, JavaScript

Developed WCF services and wrote clients to consume these services.

Experience in MVC architecture to create web applications using AJAX Extensions.

Performed unit testing on some modules.

Developed web pages using HTML5, JavaScript, CSS3, XML and ASP.NET.

Handled many production issues and enhanced the User interface as per the requirements

Environment: .NET Framework 4.0, Entity Framework 4.0, ASP.NET, Nunit, ADO.NET, Crystal Reports 10/2008, TFS, MVC 4.0, Web API C#, SQL Server 2008 and 6.5, WCF, Oracle 9i/10g/11g SQL, PL/SQL, JavaScript, XSLT, jQuery, HTML5, CSS3, AJAX, Visual studio 2010.

Client: RG Info Systems, Hyderabad, India Sep 2011 - Aug 2012

Project: First Data Commercial Services

Role: .NET Developer

Description: The Client line product is a web-based service designed to provide merchants with access to their payment processing information on Internet. Users pick-and-choose the information they need from a comprehensive database including payment processing details of gift card, check and all credit, debit and EBT card types

Responsibilities:

Involved in understanding and analyzing the client’s business, requirements for the system.

Involved in Design and Developing components of this application using ASP.NET, C# .NET, VB. NET, JavaScript.

Transformed XML files into specified business format (PDF, MS-Word) using XSLT.

Architect and implement high volume, high traffic transactional application using conventional design practices (SOA, design by contract, MVC)

Implemented business, database access layer classes in C# using UML class diagrams and sequence diagrams.

Experience in Win forms applications, ASP.NET, XML, ADO.NET and TFS

Developed and tested user friendly navigator by utilizing JavaScript and VB.NET.

Created applications by using vb.net and enhancement of the projects for .net applications.

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

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Written SQL Queries, Stored Procedures, Triggers, Backup and Restore Database, defining roles, creating database users, Assigning Roles to user’s using SQL Server 2005.

Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Involved in preparation of cascade style sheet (CSS) files.

Extensively involved in developing components for Business and Data tier using C#, ADO.Net, LINQ.

Environment: .NET Framework 2.0, ASP, C#, VB.NET, XML, Java, Web services, HTML, JavaScript, IIS, Windows 2000 Server, HTML, DHTML, UML, CSS, UML, TFS, XSLT, Ajax Toolkit, VSS, Visual Studio 2005, SSIS, SQL Server 2005, SVN

Client: LIC (Life Insurance Corporation), Bangalore, India July 2008 – Aug 2011

Role: Jr .NET Developer

LIC Life Insurance is the leading provider of liability insurance to physicians, hospitals, and medical entities in India. The Project involved the development of a Data warehouse to consolidate policy and claims information from different states for operational and strategic reporting needs.

Responsibilities:

oDeveloped stored procedures using SQL Server 2000

oInvolved in Coding web forms using ASP.NET, C#, Java Script

oInvolved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

oCreated Business Layer/Data Access Layer using C#, SQL Server 2000, ADO.NET

oParticipated in several UAT (testing), migration and production releases for software upgrades and version upgrades

Environment: Visual Studio 2000, ASP.NET, C#, SQL Server 2000, Java Script, ADO.NET, HTML, CSS

Contact this candidate