Sql Server .Net

GOWTHAMI DASIREDDY

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

Phone: 1-832-***-****

SUMMARY:

Microsoft Professional Having 7+ years of experience in analysis, design, testing and implementing Object Oriented Programming Concepts (OOPS), Service Oriented Architecture (SOA) based Applications, client-server applications, N-tier applications, and Windows Services based applications.

Experience in C# 4.0, VB.NET 10.0, ASP.NET, MVC, ASP.NET 3.5/4.0, WCF, WPF, Silverlight, SharePoint, ADO.NET, Ajax, VB6.0, SQL Server 2005/2008/2012,XML Web Services, Oracle9,10i, ADO, Angular JS and Angular JS 2.

Developed services using WCF (Windows Communication Foundation) technologies with Microsoft Enterprise library and Web service software factory.

Designed Applications using UML and Use Cases and Design Patterns, Agile Methodologies.

Managed software project life cycle (requirement analysis, Functional/Design Specifications, HLD, LLD & Test plans designing).

Experience in implementing error handling, exception management, tracing and logging features.

Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server, Oracle Database, Excel and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server 2005/2008/2012.

Built and wrote MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008/2012 Analysis Services Business Intelligence (SSAS, SSRS)

Strong abilities in Design Patterns, Database Design, Normalization, writing Stored Procedures, handling SQL CLR, Triggers, Views, Functions and SSIS/DTS Packages in MS SQL Server and involved in all the stages of System Development Life Cycle.

Experience in creating dynamic web pages using AJAX, JSON and XML.

System design and development, Rapid Application Development (RAD) using MVC and MVP patterns with design patterns, code review, release management.

Experience in Software Configuration Management (Daily Build, Release and Testing methodology) using tools like Team Foundation Server (TFS), Microsoft Visual Source Safe (VSS)

Experience in Load Testing, Code review and implemented automated unit testing with Nunit

Worked on ASP.NET MVC, singleton, Abstract Factory, Factory, Facade Design patterns.

Experience in working with divergent technologies including IIS 6.0/7.0, HTML5, CSS, Classic ASP, VB6, ADO, VBScript and Java Script.

Good Experience in developing Single Page Applications (SPA) using Angular JS.

Experience in requirements gathering, analysis & re-engineering and Ability to perform at a high level, meet deadlines, adaptable to ever changing priorities.

TECHNICAL SKILLS:

Operating System: Windows XP, Windows 7, Windows 8, Windows 2003, 2008 & 2008 R2, 2012

Programming Language: C#.Net 4.0, VB.Net, WPF, ADO.Net, PL/SQL, T-SQL Asp.Net.

Web Technologies: MVC, Silverlight, ASP.NET (3.0, 2.0, 1.1), VB.Net, C#, .Net, ADO.Net, Web Services, Reporting Services, HTML, DHTML, HTML5, XML, Ajax, CSS, AJAX Control Tool Kit, Telerik, JavaScript, Jquery, Angular JS, JSON, Angular Js 2.

Middleware: SOAP, COM/DCOM and, SharePoint, File Net

Languages: VB, ASP.NET, C#, JAVA, J2E

GUI: Visual Studio.Net, Silver light, AJAX Controls and Scripting

Databases: SQL Server 2005, 2008, 2012 Oracle 10g, Oracle 11g.

Business Objects: SSIS, SSRS, SSAS

Specialization: C#.NET, VB.NET, ASP.NET, MVC, WPF, Web API, SQL SERVER, SSIS, SSRS

Server Administration: HP Wintel, IBM Servers VM Ware Cloud Network

Tools: SAP Data Services (BAPI Calls etc NUnit, Enterprise Library, Telerik controls, Visual Source Safe(VFS), Team Foundation Server(TFS)

Other Skills: Requirements engineering, UML, Design patterns, code reviews, Testing

Project Management: Microsoft Project.

PROJECTS SUMMARY:

Plant Data Repository (PDR System), Decatur,AL Sept 2017 – Till Today

Sr. .NET Developer

Plant Data repository system is integrated with the Different systems in Decatur site which will have the complete data about the Plant data (Shipping System, Lims System,PI System, MMDC etc PDR interface fetch the data from different source systems and maintain the data in a standalone database for reporting and dashboards for the plant wide data. Consolidated data will be interfaced with outgoing data for different dept (Finance, Logistics, Procurement) related applications like Shipping report, MMDC system etc.

Responsibilities:

Worked with Business Analysts in understanding business requirements and analyzing use cases.

Developed windows application using C#.Net, WPF, Visual Studio 2015 and SQL Server 2012.

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

Programmed the Data Access Layer using C# .Net. .

Worked on Core SQL, Query Optimization, improving and optimizing database performance, connectivity, and speed through better SQL code.

Created WCF Services based API to import the data into data base.

Used Dependency Injection for data binding.

Performed unit level testing, wrote test plans, scripts and generated testable code.

Used Prism class library for Windows Forms.

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

Created deployment packages for Applications using Visual studio.Net Startup Project with specializing in design, and programming (OOA, OOD, and OOP).

Environment: .Net Frame Work, MS Visual Studio .Net 2015, VB.NET, C#.Net, ASP .NET, ADO.Net, SQL Server 2012, SSRS, SSIS, Web API, HTML5, CSS, XML, TFS, J Query, VSS, SOAP/WSDL/ WCF, WPF, HTML5,

Angular JS and Angular JS 2.

Lochbridge, Detroit, MI July 2015 – Aug 2017

Sr. .NET Developer

Lochbridge is an IT Service Organization with its Headquarters in Detroit, MI. It provides software solutions to various industries such as Healthcare, Automotive, Manufacturing, Finance and Insurance. The main aspect of the project is to develop a file-sharing platform system for healthcare industry. This includes the file sharing amount three users: Healthcare Companies (Medical & Pharmaceutical), Healthcare Providers (Doctors, Nurses, etc.) and the Patients. These three users have access to different functionalities based on their user types.

Responsibilities:

Worked with Business Analysts in understanding business requirements and analyzing use cases.

Performed actively in the Development and Testing phases of SDLC life cycle and monitored day to day project activities to ensure the deadlines were achieved as per client expectation.

Used N-tier architecture for the Business, Data Access Layer and UI Layer.

Designed and developed various screens using HTML, CSS, JavaScript/AngularJS and JQuery.

Developed reusable user interface component using Angular JS and JQuery.

Created Angular JS directives, services, controllers and filters.

Involved with the client team to design and implement the advanced technologies WCF, SOA, ASP.NET with the application logic in C# according to the user requirements.

Involved in front end Application development using in ASP.NET, AJAX using C#, and back end in SQL Server 2008.

Develop and deliver dynamic reporting solutions using SQL Server Reporting Services (SSRS).

Also involved in proof-of-concept usingASP.NET Model-View-Controller, MVC pattern.

Consumed some external Windows Communication Foundation (WCF) Services to write logs to the database.

Developed a business intelligence dashboard using Tableau software allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.

Worked on framework where involved in creating generic styles, themes for different generic WPF controls like Datagrid, WPF Textboxes and Comboboxes, WPF Radio Button List and Toggle Buttons

Used the Object Oriented Programming (OOP) techniques and created classes (C#.NET) for database access.

NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package

Designed and developed WCF Web Services and configured our WCF Services with appropriate endpoints for consuming them in the web application.

Developed User controls using ASP.Net and C# and used them dynamically in the web pages using Master pages and CSS.

Used ADO.NET objects such as Data Adapter, Command Builder, Data Reader, and Dataset for consistent access of data from SQL Server.

Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.

Used Web Services to enable effective communicate between different layers in the Application.

Developed Web Service to interact with remote business objects and different supplier’s systems using SOAP, HTTP/XML, WSDL

Tested application using Unit testing, tracking, debugging.

Actively involved in providing the technical support and production software operations through troubleshooting to resolve the issues.

Environment: .Net Frame Work, MS Visual Studio .Net 2015, VB.NET, C#.Net, ASP .NET, ADO.Net, SQL Server 2012, SSRS, SSIS, Couch base server, CSS, XML, TFS, J Query, VSS, SOAP/WSDL/ WCF, WPF, HTML5, Telerik, Angular JS.

Safelite, Columbus, OH Oct 2013–June 2015

.Net Developer

Worked on web application which handles insurance claims for Safelite and its Partners, Manage and update the script engine for the application

Responsibilities:

Developed solutions for diverse programming scenarios in C#, employing Object Oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction.

Utilized Nhibernate technology extensively for data retrieving, querying, storage and manipulation using Nhiberrnate mapping and queries.

Designed the web UI ASP.NET (4.0), HTML, DHTML, XSL/XSLT, JavaScript, CSS and AJAX controls.

Created User Controls, Custom controls, Data Access Layer, Business Logic Layer Classes using C# (4.5) for web pages.

Created WPF (Windows Presentation Foundation) for inputting and displaying data using C#.

Cold Fusion Component and Web Services design and integration with C#, LINQ, Generics, and WCF.

Used Windsor Castle as the DI container for Inversion of Control to make the code base reusable and easy to test.

Created SSIS packages to migrate data from Oracle 10g to MS SQL Server 2012.

Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.

Created SQL server Reports using SSRS for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.

Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.

Developed the C# code for implementing business logic in middle tier in 3-tier application interacting with SQL Server database.

Implemented WEB API Controller for non-SOAP-based HTTP Services.

Used the GET method of WEB API extensively to pass Jason/XML based response based on requirement.

Implemented ground transportation & Workflow Scheduler using Microsoft provider pattern, C# 3.5 & WPF.

Used ASP.NET MVC (4.0) Page Controller pattern to add functionality to individual pages such as to accept input from the page request, invoke the requested actions on the controller.

Used ADO.NET to connect the web forms to data sources such as SQL Server 2008 and XML files for manipulating data in database.

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

Written Stored Procedures in SQL Server 2012 and used ADO .NET with Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation.

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

Worked Extensively with Query Optimization Techniques to fetch data with better Performance Tuning.

Implemented Unit Testing, Integration Testing and System Testing using Nunit to ensure Code Stability and functionality.

Supported Operations team during the deployment and troubleshooting the production issues during deployment and on regular basis.

Environment: Visual Studio 2010, C#, ASP.NET MVC, WCF, JQuery, MVVM, IIS 7.0, AJAX, ADO.NET, TFS, XML, SSRS, SSIS, Microsoft Enterprise Library, NUnit, SQL Server 2012, UML, WPF.

Guardian Life Insurance Company, Princeton, NJ June 2011 – Sep 2013

.Net Developer

Guardian Life Insurance Company of America and its subsidiaries sell life, long term care insurance, disability income, group medical and dental insurance products, and offer 401(k), annuities and other financial products. ACT (Agency Compensation Transformation) Initiative project intends to replace the existing FAS mainframe system and Agency Accounting interfaces that will offer Guardian expanded IT capabilities.

Responsibilities:

Participated in requirements gathering, analysis and design of the client requirements.

Involved in the Design of the Application using ASP.Net, WCF, Entity Framework, SQL

Involved in UI designing, development and testing of web forms using ASP.NET,C#.NET, XML, and ADO.NET.

Programmed Data access layer using ADO.NET and VB.NET, which involved strong OOPS concepts to retrieve, display and manipulate data.

Developed tools using C# and SQL to ease the recording of the documentation that consists of theconfigurations in the database.

Designed and developed Ruleset Editor in C# 3.5 and WPF to execute various business policies in a workflow.

Optimized SSIS packages for the performance as the high volume data flows were taking more than the desired time to execute.

Developed ADO.NET based database access layer in C# and created stored procedures, triggers using T-SQL for data access from SQL server 2008.

Involved in writing database scripts, stored procedures, triggers, views, and functions.

Developed Test Classes for Unit testing the developed components using TFS automated Unit Testing Framework

Implemented the functionality for the plugin using C#, ASP.NET, MVC, WCF and Entity Framework.

Expertise in AngularJS controllers, directive, Components, Factory and service resources, routings and events. Expertise in DOM manipulation using JavaScript, jQuery and AngularJS.

Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel, OLEDB and Access to SQL Server.

Implemented the SOAP based WCF service to generate e-mails for the workflow solutions.

Used JQuery and JavaScript for scripting

Created Stored Procedures, Indexes, Views and Triggers using SQL Server 2008.

SQL Agent was used for automating creating packages and updating existing Tables in SQL server.

Implemented Forms-based Authentication and Role-based Authorization using ASP.NET Membership classes and methods.

Tested the product feature before and after integration using N-Unit.

Worked on production issues, debugging the application and fixing the issues

Used Tortoise-SVN to maintain version control by update and check out from SVN repository

Environment: Windows, Visual Studio 2010, SSRS, WPF, ADO.NET, C#, ASP.NET, Entity Framework, SSIS, JavaScript, JQuery, AJAX, JSON, HTML, SQL Server, IIS,

HPSM, South SF, CA June 2010 – Dec 2010

.Net Developer

Health Plan of San Mateo (HPSM) is a non-profit health care plan that offers health coverage and provider network to San Mateo County’s underserved population. HPSM currently serves more than 130,000 County residents, and have a vision, that Healthy is for everyone.

Member Portal is application where members taking health care from HPSM can login, and make changes to their demographics; see authorizations, request ID card, etc.

Responsibilities:

Involved in all the phases of the Project Life Cycle and also analysis of the system based on n-tier architecture.

Designed Graphical User Interface (GUI) using ASP.Net MVC 3, HTML JavaScript.

Used WCF for interoperability with other platforms, technologies and for building the customsolutions.

Implemented entire backend of the application in C#.NET, using various object oriented featureslike classes, interfaces, inheritance, and polymorphism.

Designed Business components and Data Access Layer using C#.Net

Implemented Caching, Client and Server side State Management techniques such as Viewstate, Cookies, application and session throughout the projects using ASP.NET.

Used the AJAX control kit and to provide the extender AJAX control properties to the existingASP.NET controls.

Used extensively JQuery, JavaScript and ASP.NET AJAX for front end and Ajax webmethods.

Involved in developing Web Service classes using SOAP to communicate with legacy systemsand also deployed web services as per business requirement.

Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access toSQL data sources.

Wrote SQL Queries, Stored procedures, Joins, Triggers to process large collection of productsand used Data Reader, Data Adapter, SQL Command and Dataset for retrieving data from database using SQL2008.

Environment: Visual Studio 2008, ASP.Net 3.0, ADO .NET, XML, HTML, JavaScript, IIS 6.0, NUnit, Visual Source Safe, SSRS, SOAP, WCF, .NET Framework 3.0, Web services, SQL Server 2005, T-SQL, DHTML.

SunRise Info Tech, India Jan 2010– May 2010

.Net Developer

Sunrise Info Technologies, Inc. (Sunrise) is a certified Small Disadvantaged Business (SDB) and Woman-/Minority-Owned Management Consulting and IT Professional Services Company based in Folsom, California. Since 1990, our staffing resources and networks have been well established to provide these specialized services to numerous clients in such diverse industries as information technology, aerospace engineering, and utility engineering services.

Responsibilities:

Developed the web forms using ASP.NET for the intranet application.

Designed and developed the 3 tier application using .NET framework 3.5/2.0.

Involved in the design, development and implementation of web user interfaces usingC#.NET, ASP.NET 3.5, HTML and CSS.

Utilized various ASP.NET server controls such as Validation controls for validating form entries such as email addresses, Radio Button List controls, etc.

Used JavaScript extensively for Client side validation.

Developed and integrated new user interface to existing application using C#.

Created the classes in Business logic layer using C#.

Built XML files to hold the listing for various drop downs in User Interface.

Used Ajax Controls like Calendar Extender, Filtered Text Box Extender, Hover Menu Extender and List Search Extender.

Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL server data sources.

Wrote SQL Stored procedures which enhanced the functionality of application.

Used Windows Communication Foundation (WCF) to communicate with other external application systems.

Used role based security for authenticating users.

Used Version control tool Team foundation server (TFS) for the entire development cycle.

Environment: ASP.NET, C#, Framework, ADO.NET, SQL Server 2005, CSS, XML, T-SQL, IIS, Team foundation server (TFS), JavaScript.

Qualifications

Bachelor of Technology in Computers (B. TECH)

Address: 2534 River Ridge

Houston, TX -77459

Work Permit: Have valid H4 EAD

Contact this candidate