Sql Server Data

THARAKA KUNDLA Email: acxjgy@r.postjobfree.com

Senior .NET Developer Phone: 302-***-****

Professional Summary:

More than 8 years of experience as Programmer Analyst and Application Developer in all phases of SDLC in developing .NET Enterprise applications and object oriented application framework

Technical expertise in Microsoft Technologies like .Net Framework 4.5/4.0/3.5/3.0, C#, ADO.NET, IIS, Win Forms, Web Services, ADO, Web API, WCF, XML, Microsoft SQL Server and MS Team Foundation Server.

Very well acquainted with the concepts like inheritance, polymorphism, abstraction and encapsulation, have used them wherever Object Oriented Programming System (OOPS) is needed and also comfortable with the SOLID principles.

Experienced in creating rich User Interface on the web using HTML 5.0, XAML, DHTML, Master Pages, CSS, Ajax, JavaScript and JQuery.

Worked on N-Tier Architectures, Design Patterns like MVC (Model View Controller) on the applications.

Developed Data Access Layer (DAL), Business Logic layer (BLL) also implemented in Business Processes.

Expertise in implementing SOA using WCF technology developed and consumed WCF services with features versioning, security, optimization and reliability.

Experience in Data accessing including using Data Adapter, Data Reader and Data Set in ADO.NET.

Created Entity classes, relationships between entity classes using LINQ (Language Integrated Query) to SQL to manage relational data as objects with Entity Framework.

Good knowledge over .Net framework concepts like Lambda expressions, LINQ, Extension methods etc.

Hands on experience in working with development of Stored Procedures, User Defined Functions, Queries, Indexes, Triggers and Views using SQL Server 2012/2008/2005 and T-SQL

Prepared Technical design document, Use cases, Test cases and User manuals for various projects and good at Bug fixing, Code reviews, and Unit & System testing.

Experience with Test-Driven Development (TDD) like N-Unit testing frameworks.

Excellent communication and interpersonal skills and has ability to handle multiple tasks can take initiative to handle responsibilities independently as well as a proactive member of a team.

Great desire to learn latest technologies and ready to take up challenge

Technical Skills:

Web Technologies:

ASP.NET, ADO.NET, HTML5, JavaScript, CSS3, AJAX, Web Services, XML, JQuery, MVC, WCF.

Languages:

C#, VB, C++, SQL Server, T-SQL, Java Script

Databases:

Access, MS SQL 2014/2012/2008/2005, Oracle 8i/9i/10g/11g.

Development Tools:

Visual Studio 2015/2013/2010/2008, SQL Management Studio.

Reporting Tools:

Crystal Reports, SSRS, SSIS.

Design Tools:

MS Visio, MS Office, MS Project.

Source Control :

VSS, CVS, TFS, Tortoise SVN, GIT.

Operating Systems:

Windows NT/2000/XP/2K3, Linux.

Software Testing:

MS Test Suite, N-unit framework, unit testing, UI, T-SQL Testing.

Education:

Bachelor of Technology in Computer Science,

Koneru Lakshmaiah College of Engineering, Andhra Pradesh, India.

Professional Experience:

Microsoft Corporation - Redmond, WA

Mar 2016 – Till Date

Sr. .NET Developer

Description: This is the Microsoft internal project about the Azure Revenue Services. Here we are working on two portals called Customer Portal and Product Portal. In Customer Portal we are developing the services for Azure customers who are using the Azure from Microsoft and in Product Portal we are developing the details and revenue of products of Azure and Microsoft technologies.

Responsibilities:

Attended the code reviews and status meetings.

Worked on front end, business logic layer and database access layer using C#.

Created/Modified Stored Procedures using T-SQL and SQL.

Created and Modified existing SSIS packages for extract, transform and load the data into SQL Server.

Created and Modified Stored Procedures depends on the requirements.

Used C# for coding the application.

Developed Web Services to retrieve information.

Used .NET controls for designing the page and displaying the data in the user interface.

Developed Web API MVC5 application using C# .Net.

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

Used Restful Web Services like Get, Put, Post and Delete for the existing services in the project.

Used Model View Controller (MVC 4.0/5.0) architectural Design Patterns for the development of the product using Razor view engine and Web API.

Developed Web Services to retrieve information.

Used AJAX Toolkit provide the pleasant client side experience with JQuery, Java script, and JSON.

Used LINQ to query the database and used LINQ as a middle ware component for encapsulating the business logic.

Performed Unit Testing of the developed component and windows forms and worked closely with manual testers and automation testers, User Acceptance testers for ensuring the desired functionality is achieved.

Followed agile methodology in the project.

Environment: MVC 4.0, MVVM, C#, IIS, WCF, Web API, .Net Framework 4.0/4.5, Visual Studio 2015, VB6, Classic ASP, AJAX, XML, COM, XAML, HTML, SQL Server 2014, SSIS, SSRS, ADO.NET, CSS, SOAP, WSDL, Restful services, N-hibernate, JavaScript, JQuery, Code flow 2010, Source Tree, GIT.

Wells Fargo - West Des Moines, IA

June 2015 - Feb 2016

Sr. .NET Developer

Description: Wells Fargo is a diversified financial services company providing banking, insurance, investments, mortgage, and commercial finance through more than 9, 000 stores and more than 12, 000 ATMs and the Internet across North America and internationally.

Responsibilities:

Analyze and understand business and functional requirements, applications and processes at onsite.

Worked on daily production support incidents, troubleshoot/resolve problem tickets assigned.

Worked on database design, research needed, development of back-end objects and front end screens, testing and deployment required for various projects in ASAP team.

Developed Web API MVC5 application using C# .Net.

Successfully developed views Using Visual studio 2013 ASP.NET MVC Razor, HTML, JavaScript, CSS.

Used Model View Controller (MVC 4.0/5.0) architectural Design Patterns for the development of the product using Razor view engine and web API.

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

Implemented Page Level Caching to store copies of entire pages/page fragments for more static pages.

Developed Web Services to retrieve information.

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

Used Restful web Services like Get, Put, Post and Delete for the existing services in the project.

Developed web pages and User Controls using Java Script, ASP.NET, HTML,C#.NET and also CSS based Style sheets to maintain consistency among all the web pages

Performed Unit testing and System testing and prepared required documents for testing.

Used WCF Services for communications.

Used WCF for developing and deploying services on Windows in line with the Service Oriented Architecture (SOA).

Designed and coded user interface using web forms and custom controls.

Used AJAX Toolkit provide the pleasant client side experience with JQuery, Java script, and JSON.

Managed Team Foundation Server for the project and managed builds for release.

Used LINQ to query the database and used LINQ as a middle ware component for encapsulating the business logic.

Created new web services to be consumed by other modules.

Wrote SQL procedures, Views and triggers.

Created SSIS Packages with BIDS for developing ETL process.

Involved in creating large SSIS packages for generating monthly summary report spreadsheets.

Involved in fixing post production support issues.

Used Bootstrap for Creating Design Templates for interface components and JavaScript extensions.

Environment: ASP.NET, VB.NET, MVC 4.0, Prism, MVVM,C#, IIS, WCF, Web API, .Net Framework 4.0/4.5, Visual Studio 2010, VB6, Classic ASP, AJAX, XML,COM, XAML,HTML,SQL Server 2008/2012, SSIS, SSRS, ADO.NET, CSS, SOAP, WSDL, Restful services, N-hibernate, Java, JavaScript, JQuery, Visual Team Foundation Server.

Liberty Tax Services - Chicago, IL

May 2014 – June 2015

Sr. .NET Developer

Description: The project is developed for documenting and sharing information on Technical Assistance (TA) delivery. By providing Fund-wide access to information on the content of TA activities and progress achieved, the system helps facilitate prioritization of scarce TA resources, improve awareness of current and outstanding issues in TA provision, improve the integration of TA with surveillance and Used Fund Resource (UFR), and enhance reporting on the effectiveness of TA.

Responsibilities:

Gathering the requirements from the functional designs, meetings, from business analysts and department heads.

Implemented Master Pages for the uniformity of the site and Cascading styling sheets.

Followed agile development methodology during the project life cycle.

Used MS Visual Studio 2010 for development.

Interacting with the business team and drafting down the requirements.

Prepared technical design document that involve documenting the changes to be made to the user interface, business services, web services, data services, data classes and any database changes to the tables and stored procedures.

Designed and developed web applications using C# language.

Designed and developed the required stored procedures, triggers and database functions.

Developed Employee objects, and created functions to get data from data access layer using C#.

Worked on Client Side Validation using Java Script.

Used media types in API to let consumers choose the format of the data they wish to receive.

Used Bootstrap for Creating Design Templates for interface components.

Using Restful web services provided JSON interface for HTML5/ JavaScript applications.

Reusable UI widgets, such as the navigation menus, are implemented using ASP.NET User/Custom Controls.

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

Used LINQ to build set of operations, parameters and expressions (Binary, Unary, Lambda) during execution (aimed at “Querying”) a set of data from SQL Server.

Implemented Page Level Caching (i.e. called Output Caching) to store copies of entire pages/page fragments for more static pages.

Developed MVC Razor views and partial views and developed business logic in terms of Models.

Developed Web Services to retrieve information.

Used Entity framework for data access.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Extensively used SSIS to create packages to move data from a single data source to a destination.

Environment: Visual studio 2013, C#.Net, Classic ASP, VB6, ASP.Net, MVC, Prism, MVVM, IIS, HTML 5, COM, JQuery, Ajax, Razor, WCF, Web API, Active directory, WWF, WIF SharePoint, SQL 2008/2012, Entity Framework, CSS 3 and TFS, SSIS, SSRS, ADO.NET, CSS, SOAP, WSDL, Restful services, JavaScript, Typescript, Bootstrap, Oracle, Visual Team Foundation Server

Anthem - Indianapolis, IN

Aug 2013 – May 2014

Sr. .NET Developer

Description: Is to publish inspection findings online for the public. The portal allows searching for a Facility person by Facility Name, street address, city etc.

Responsibilities:

Involved in collecting analyzing and understanding the business requirements from the customers and Child Care Licensing Portal application business analysts.

Involved in full Software Development Life Cycle (SDLC) for analysis, design, development, documentation, and testing and deliver on projects and deliverables.

Implemented N-tier architecture for the application development with Presentation Layer (UI), Data Access Layer (DAL) and Business logic layer (BLL).

Have designed and developed web application for the users to login and view the data, ASP.Net is used for the page design and coding was done using C#.

Used CSS and developed Master Pages for consistent look and feel of the ASP.Net pages.

Used Java Script for validations at the client-side and ASP.Net Validation Controls on Server side.

Involved in implementing Microsoft Application Blocks for data access, security and logging.

Used MVC design pattern in checking Log In credentials and displaying the necessary components and data to the particular user.

Used Microsoft Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC 3 application.

Extensively used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database.

Created data access layer to communicate with the PL-SQL Created few database tables in PL-SQL depending on the requirement.

Wrote queries for retrieving data from the database tables and displaying data in the ASP.Net pages.

Used Session State, Query string for saving data on the page and transferring data from one page to another page.

Used Response. Redirect to navigate from one page to another page.

Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel within some web pages for partial rendering of the page.

Created and Consumed Web Service (SOAP, WSDL and UDDI).

All database calls were made from Web Service.

Created User Controls that can be reused in all pages of the application.

Used Agile Methodologies for regular adaption to changing requirements.

Created test cases and performed N-Unit testing to rectify errors.

Environment: Visual Studio 2008/2012, .Net Framework4.0, Visual Basic 6.0, MVC, MVVM, XAML, WCF, LINQ, ASP.NET, ADO.NET, JavaScript, C#, Web services, ASP.NET, AJAX, CSS, Entity frame work. Agile Methodologies, Facets, PL-SQL, SOAP, REST, XML, HTML, DHTML.

First Premier - Watertown, SD

Oct 2012 – Aug 2013

Sr. .NET Developer

Description: The project is Automated Payment System. The fees is exempted for certain categories like Soldiers and Sailors, Senior Citizens also if the payments are made through First Premier bank etc.

Responsibilities:

Attended the code reviews and status meetings.

Worked on front end, business logic layer and database access layer using C#.

Created/Modified Stored Procedures using T-SQL.

Created and Modified existing SSIS packages for extract, transform and load the data into SQL Server.

Migrated SSIS packages from SSIS 2005 to SSIS 2008, also involved in DB migration from Sqlserver2005 to Sqlserver2008.

Worked and involved in migrating the jobs from Autosys 4.5.1 to Autosys R11 Created Jil files and scheduled jobs in Autosys.

Created and Modified Stored Procedures depends on the requirements.

Used C# for coding the application.

Used .NET controls for designing the page and displaying the data in the user interface.

Performed Unit Testing of the developed component and windows forms and worked closely with manual testers and automation testers, User Acceptance testers for ensuring the desired functionality is achieved.

Used pac2000 for tracking the problem tickets and TFS for version controlling.

Followed waterfall methodology in the project.

Environment: VS.NET 2008, .NET 3.5, C#, SSIS, ADO.Net, SQL Server 2008, T-SQL, TFS, Windows XP, AUTOSYS 4.5.1/R11, pac2000.

Elico Health Care Services - Hyderabad, India.

Mar 2011 – Sep 2012

Role: .NET Developer

Description: This project was designed for the new super specialty hospital Harrison Community Hospital, Cadiz. This was developed as a generic product, which could be further, marketed by the sale Points. The solution offers better and more efficient operations, achieve cost efficiency in operation and maintenance, and ensure their confidentiality and integrity of patient medical information

Responsibilities:

Attend requirements meetings with officials in various fields and work on the specifications mentioned. Responsible for writing all business logic part of the application.

Responsible for the development using ASP.NET and C# as the server side coding language and some designing issues and implementation.

Test Driven development pattern followed for the application development.

Used ADO.Net connectivity to an SQL Server database

Developed various user controls for different requirements.

Involved in the gathering requirement for developing ASP.net application using Asynchronous JavaScript and XML (AJAX) using Visual Studio.

Implementing interactive functionality in user/custom controls using AJAX controls.

Designed and implemented event handling using C#, JavaScript, AJAX and also used CSS to get consistent look and feel of the web site.

Used Grid View Control for data editing and display purposes.

Developed of the core business logic to be consumed from diverse applications.

Cookie development for validation, and other site requirements.

Actively participated in the complete life cycle of development, from the design phase to implementation phase.

CSS used to change the look and feel of the website.

Used Data Adapters, Data Sets and Command & Connection Objects of ADO.NET to manipulate data in the SQL Server Database.

Maintained the state of session objects, used session management.

Involved in developing various modules such as customers (Patients) module and employers modules etc. Presentation layer was developed in ASP.NET.

Involved in the logical and physical relational database design using SQL Server.

Wrote Complex SQL statements, Stored Procedures, Indexes and Views. Used Normalization for fine-tuning the Database tables.

Worked with Access database and front end.

Data Migration done with SSIS (Export/Import of data).

Followed agile methodology throughout the project.

Managing security policy such as security configuration file applying permission sets provide security on IIS level.

Followed agile methodology throughout the project.

Unit testing done. Associated with Test Team for functional testing.

Used MSSRS for generating reports.

Developed Web services using WSDL and SOAP.

Environment: ASP.NET, C#, Visual Studio, ADO.NET, JavaScript, CSS, AJAX, MSSRS, SSIS, Web Services, SOAP, WSDL, REST, XML, XSLT, XHTML, IIS v5.1, T-SQL, SQL Server 2005,UML, Windows XP

Saahi Systems - Hyderabad, India.

June 2008 – Feb 2011

Role: .NET Developer

Project description: Account Transfer for Cash Online Systems online banking service provided for corporate accounts and provided an Actuate reports to facilitate to the valid user. The Actuate Reporting Service is responsible to manage and enables the valid user to check the transactions using different search criteria. A separate window is displayed with a printer friendly report. And the user can export the report to excel or PDF file format.

Responsibilities:

Involved in developing application completely under .NET framework with OOP’s concepts.

Developed applications with strict compliance to UML Use Cases and Class Diagrams.

Developed the UI using Windows forms and Windows controls.

Used Visual inheritance in developing the forms.

Created the database objects like Tables, Indexes, Views, stored procedures etc.

Developed custom Data Grid Column Style.

Designed and developed custom user controls.

Worked on ActiveX controls such as Tree View control, List View while developing Win Forms.

Used ADO.NET to interact with SQL Server database.

Wrote queries, stored procedures, views and triggers for supporting the functionality of the application.

Used Data Adapter and other ADO.NET objects for importing and exporting the data from the database.

Environment: Microsoft .NET, C#.Net, Win Forms, SQL Server, Oracle, ADO.NET, UML.

Contact this candidate