Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Corning, NY, 14830
Posted:
March 23, 2017

Contact this candidate

Resume:

ANNAPURNA GORINTA Phone# 607-***-****

Sr. Net Developer aczf4m@r.postjobfree.com

* + Years of experience in Systems Analysis, Design, Development and Implementation in developing Web and Windows using N-tier Architecture involving all stages of Software Development Life Cycle(SDLC).

Experience in Visual Studio.NET 2005/08/10/12, .NET 2.0/3.0/3.5/4.0/4.5, C# 4.0, ASP.NET MVC, ASP.NET 3.5/4.0/4.5, WCF, LINQ, EF, ADO.NET, Ajax, VB6.0, SQL Server 2000/2005/2008.

Extensive working experience with MVC for all the programming and technologies integrated into Asp.Net 4.0 C# framework with different types User Interaction and data binding which can operate on all popular web browsers

Experience in implementing several Design Patterns to standardize the application architecture.

Expertise knowledge on Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism.

Experience in using ORM (Object-relational mapping) tools like NHibernate 3.1 and Microsoft Entity Framework.

Hands on experience on implementing AJAX functionalities for partial page rendering through JSON.

Extensively used VB, C# coding in SSIS script task.

Proficiency in object oriented concepts and design patterns such as dependency injection, MVC.

Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with VB.NET in SSIS

Experience working with SSRS report snapshots and cached reports concepts.

Expertise in designing/creating several SSRS reports that have been formatted specifically for dashboard displays, i.e. with charts, KPIS, tables, etc.

Experience in using AutoSys for application batch Processing.

Experienced in design and development of web-based applications using technologies like ASP.NET, MVC, C#, ADO.NET, XML, ASP, CSS, HTML, JavaScript, JQuery, and Bootstrap.

Extensively worked with offshore and onsite tech leads and provided status report of team activities against the plan or schedule.

Experience to working with HP Quality Center for tracking the functional testing issues.

Experienced in relational database design and programming using MS SQL Server and Oracle databases

Experience in Extensive experience of Rational Unified Process (RUP). Development, Testing as per the RUP's Iterative Software Development Life Cycle process and Agile software development methodology

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

Experience in Microsoft ASP.NET Ajax Library, XMLHttpRequest, AJAX, JSON.

Experience in developing Web forms, User Controls, Custom controls and validating user inputs using validation techniques.

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL

Extensively used Partial Classes, Generics, Interfaces and Object-Oriented concepts for developing the application.

Experience on Build and release management like ANT, AnthillPro, Maven

Strong front-end development experiences with HTML, HTML5, CSS, JavaScript, JQuery, Angular JS and Bootstrap.

Expertise in developing web based applications using C#, ASP.NET, ADO.Net, .Net Web Services, HTML, JavaScript, JQuery, CSS, LINQ, AJAX, XML.

Experienced UI Development, designing Web applications using Master Pages, CSS and Themes.

Good working experience in making AJAX based web applications to improve the response time and extensively implemented update panels, script manager and triggers.

Experience in using Language-Integrated Query (LINQ to Objects, LINQ to XML, and LINQ to SQL), Entity Framework and retrieve data from different data sources.

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

Strong knowledge of Razor Engine, and Web API .

Worked on Agile, Waterfall and other SDLC processes.

TECHNICAL SKILLS

Web Technologies

ASP.NET, HTML, HTML5, XML, AJAX, CSS, MVC, Web Services, WCF, Bootstrap, Web API, REST API

Programming Languages

C#.NET, VB.NET, C, C++, T SQL, LINQ, Razor

Scripting Language

Java Script, JSON, XSLT, JQuery, UI, Knockout JS, Angular JS

Framework /Architecture

.NET Framework 4.0/3.5/3.0/2.0/1.1

IDE

Visual Studio.NET 2005/2008/2010/ 2012/ 2013/2015

Databases

SQL Server 2005/2008/2008R2/ 2012 and Oracle, Sybase, Toad for Data Analysts and Oracle, Sybase

Reporting/Scheduler Tools

Crystal Reports, SSIS, SQL Server Reporting Services (SSRS), AutoSys Edition) 4.5.1/R11.0

Web Server

IIS 7.0/6.0/5.0

Protocols

TCP/IP, HTTP, SOAP

Development Tools

MS-Office

Operating Systems

Windows Server 2003 Windows 9x/2000/2003/XP/7/8/10

Methodologies

Agile, Waterfall models

Source control tools

SVN & Team Foundation Server, GIT

EDUCATION

Masters in Computer Application, Andhra University - India

Bachelor of Science (BSc) from Andhra University, India

PROFESSIONAL EXPERIENCE

Wells Fargo; Reading, PA Feb 2016 to December 2016

Role: Apps Systems Engineer

Registration Management System

The Compliance Supervisory Control system (CSCS) provides a framework for monitoring and surveillance of WFS and WFA team members. The System records and enables authorized users to manage team members PIP manager, Supervisory principal, Compliance Officer, and Business Unit Compliance officer. Authorized users can set a variety of compliance attributes to use for surveillance and other down-stream applications.

Environment: Asp.net MVC, Web API, WCF, Angular JS, Bootstrap, C#, JQuery & SQL Server 2012, SSIS, SSRS, Ajax, Knockout.js, JSON, JQuery, Entity framework, Oracle 12, Sqlserver 2014, NHibernate, SVN,

TOAD

Responsibilities

Graphical User Interface (GUI) was designed using ASP.NET and the business logic was coded in C#.

Used Cascading Style Sheets for a unified look and feel of the ASP.NET Web forms.

Designing Administrator pages to handle overall application.

Designed the source and applications under agile process.

Involved in designing Database Architecture.

Implemented Optimized Stored Procedures.

Used NHibernate as the ORM tool for data access.

Maintained good security safeguards.

Implemented AngularJS Controllers to maintain each view data. Implemented Angular Service calls using Angular Factory

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

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database

Developing custom HTML elements using angular js directives.

Developed controllers, view/partials and directives for application.

Used JQuery, JQlite and JavaScript for DOM manipulations.

Played a key role in writing application logic using Eclipse IDE

Used Eclipse IDE to develop the screens for the application using MVC design pattern.

Widely resolved angular scope issues.

Developed Angular factories, and used angular promise api for making async calls.

Used angular Ui-bootstrap and CSS

Used Master Pages to provide a unified look and feel to the application.

Used AJAX to create better, faster and more user-friendly web applications.

Created ASP.NET validation controls and JavaScript, JQuery validations to enforce validations.

Used SSIS for data manipulation.

Designed and implemented the User Interface using JavaScript, HTML5, XHTML, XML, CSS3, JSP, AJAX and MySQL.

Used advanced level of HTML5, JavaScript, CSS3 and pure CSS layouts table less layout.

Produced content pages with CSS3 layout and style markup presentations and also used JavaScript methods and properties.

Developed the functionality for communicating between the modules mostly involved in VIEW and CONTOLLER section of MVC pattern for RMS project, it includes HTML5, CSS3, JavaScript, JQuery and AJAX which were used for UI development

Used Grid View, Data List, and Panels to display and manipulate data in ASP.NET Web Forms.

Used ADO.NET components like Data Adapter, Data Reader and Dataset.

Active participation in unit testing of the application to ensure quality

Used Windows Communication Foundation (WCF) for clients to consume multiple services using SOAP protocols.

Participated in various Client meetings with the team and the Project manager to discuss improvements/amendments in the development of the section.

Involved in ETL process using SQL server integration services (SSIS) with data from various sources like flat files, excel, xml and Sybase to Sql server etc.

Designed Batch Processing system for applications using AutoSys. Developed standardized scripts for job implementation

Created Stored Procedures, Views and User Defined Functions for fetching relevant data to UI for different reports.

Implemented the code for creating the pipe delimited file using C#.

Export the data from Oracle database to Sql server using SSIS.

Implemented the code for file is transferred automatically to RegEd Exchange.

Extensively used JQuery as code behind for all the webpages in MSDN and TechNet, and developed JQuery Model Popup’s and dynamically generating the HTML content based in the response JSON Format data from WCF service call and appending into a web pages.

Used Windows Communication Foundation (WCF) for clients to consume multiple services using SOAP protocols

Responsible for developing a script which effectively handles all the client side events (Button Click, Mouse Hover, Mouse Out etc.,) using JQuery. bind and. unbind methods.

Wells Fargo; Reading, PA Nov 2015 to Feb 2016

Role: Apps Systems Engineer

TMID (Team Member Identification)

The purpose of the Automate TM Identification for Email Retention project is to create a single system of records regarding a team member’s regulated status, visible to the business and to requisite compliance systems. This solution would simplify where ‘the rules’ are maintained, provide an audit trail of changes, provide greater transparency to current state and systematically identify situations for review and resolution on a more frequent basis.

Environment: VS .NET 2013, ASP.NET 4.5, Angular JS, Bootstrap, Ajax,C#.net, JQuery, Java Script, SQL Server 2012, SSIS, SSRS, Ajax, WebDataTree, Json, SSRS, SSIS, Entity framework, NHibernate, Oracle PL/SQL,SVN

Responsibilities

Created Web-based user interface with ASP. Net and using C#.Net.

Implemented .net utility for getting the members of groups from Active directory.

Implemented Team member admin can able to add or update business rules.

The system has an interface to view a specific TM and all of its’ attributes and characteristics

Developed the code for the UI layer, business layer, and the data access layer.

Business layer design to implement different business rules as set by rules system.

Extensively used SQL Server, SSRS reports for data retrieval and data manipulation.

Performed required field, comparison, range, custom validations of the input controls of the web forms.

Designed and Developed dynamic webpages using Bootstrap JavaScript, JQuery

Implemented ZL-attribute functionality and Client and server side validations.

Used Eclipse IDE to develop the screens for the application using MVC design pattern.

Used Web.Config to set up connection strings

Designed and developed .NET web components and user controls using ASP.NET and C#.NET, AJAX Toolkit

Used MS Visual Source Safe as source control for managing the code.

Used Ajax to effectively utilize client resources and improve performances.

Designed Batch Processing system for applications using AutoSys. Developed standardized scripts for job implementation

Implemented AngularJS Controllers to maintain each view data. Implemented Angular Service calls using Angular Factory

Tested all application controllers extensively with mocha/chai and angularJS's built-in testing facilities.

Created stored procedures, views and user defined functions for fetching relevant data to UI for different reports

Created batch process for loading the data into database.

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.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart

Implemented error handling, exception management, tracing and logging features.

Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Timer in some web pages.

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

Enhanced existing pages with different AJAX controls which provided responsive user interfaces to display the data on the web page

Wells Fargo; Reading, PA Jun 2015 to Oct 2015

Role: Apps System Engineer

WRL (Watch and Restricted List) Project

To migrate the Watch List, Restricted List, and Restricted List Viewer applications out of the existing database environment. The existing database environment has negatively impacted our stability several times during 2014, and the goal of this project is to sever the dependency on this environment, moving to one that is not online in-line with our enterprises standards, but also in-line with our emerging WFS Technology Standards.

Migrate our key applications (Watch & Restricted Lists) away from the Sybase ASE environment, to a new database Sql server 2012 environment in order to eliminate the existing risks of contention and implemented new enhancements.

Environment: Visual Studio .NET 2013, Asp.net 4.5, Bootstrap, C#.net, JQuery & SQL Server 2012, SSIS, SSRS, C#, VB.net, NHibernate, SSIS, SSRS, Oracle PL/SQL,SVN

Responsibilities

Migrated the Watch List and Restricted List application from framework 4.0 to 4.5 and pointed to sqlserver 2012.Involved in Converted all stored procedures from Sybase to Sql server 2012.

Involved in ETL process using SQL server integration services (SSIS) with data from various sources like flat files, excel, xml and Sybase to Sqlserver etc.

Used SSIS 2008 created various packages to bring data into the staging area from various sources like text files, Excel and SQL Server databases

Create reports subscriptions – to send data driven reports using SSRS.

Experience in developing various design patterns.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Created Store Procedures, Views and User Defined Functions for fetching relevant data to UI for different reports.

Implemented extreme programming by using fast paced Agile methodology, involving in task completion, user stories, and iterations

Developed and deployed web services using Visual Studio and IIS to handle unity orders.

Developed WCF Service for retrieving product data.

Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Timer in some web pages.

Enhanced existing pages with different AJAX controls which provided responsive user interfaces to display the data on the web page.

Extensively used concepts of Delegates, generics, boxing-unboxing and Inheritance in C#.NET, along with Abstract classes/Interfaces and Polymorphism.

Used JavaScript for triggering Pop-ups with a CSS-class, dynamic forms that include built-in error checking, dynamically changing background and text colors, or "buttons" and validations.

Application code was implemented using layered architecture.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

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

Expertise with Table Design, Index Design and Performance Tuning.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Extensively used JQuery as code behind for all the webpages in MSDN and TechNet, and developed JQuery Model Popup’s and dynamically generating the HTML content based in the response JSON Format data from WCF service call and appending into a web pages.

Unit testing on web application.

VarsuneTechnologies, Hyderabad, India Jun 2013 – Mar 2015

Role: Sr. Software Engineer

OCTL-ERP Project

OCTL ERP is an intranet ERP application used for automating the manufacturing process and Quality process data of various products like Casing, Tubing, Drill pipe, Pin, Box and Couplings. It has the modules Inventory, Production Planning & Control, QA & Reports.

Environment: Visual studio .NET 2012 sp1, ASP.Net, MVC4, Bootstrap,C#,Sql server 2012,Ajax, Java Script, JQuery, LINQ, Windows 7, .Net Framework 4.0,SVN

Responsibilities

Involved in the SDLC phase of requirement analysis, design, and development of the web based intranet application tool using ASP.NET and C#.

Graphical User Interface (GUI) was designed using ASP.NET MVC and the business logic was coded in C#.

Developed business use cases, sequential, collaborative, activity and class diagrams for the enterprise presentation, and business and data access components of the system using UML.

Designing Web forms and code associated methods using MVC (Razor).

Designed the source and applications under agile process.

We use Jqrid to generate reports.

Create views and controllers and bind the data from services.

Maintained good security safeguards.

Worked on the Model, View, and Controller for ERP.

Used Master Pages to provide a unified look and feel to the application.

Used AJAX and JSON to create better, faster and more user-friendly web applications.

Consumed a Web Service

Business Logic coding and Unit testing.

Implementing change-requests and new feature additions.

Created client side validations with JavaScript and JQuery.

Implemented Model Validations for validation purposes on the Server Side.

Active participation in unit testing of the application to ensure quality.

Supervised the development of functional documents for the application.

Implemented Optimized Stored Procedures.

Participated in various Client meetings with the team and the Project manager to discuss improvements/amendments in the development of the section.

VarsuneTechnologies, Hyderabad, India Oct 2012 – May 2013

Role: Sr. Software Engineer

SBC-AMS Project

Arihanth Management system (AMS) is used by the first nuclear submarine ARIHANT (Destroyer of enemies). This is a web based application, comprises of various set of modules to capture the administrative and ship management function for Ship Building Center staff.

Environment: .Net Framework 4, Asp.Net, MVC, Bootstrap, Visual Studio 2010, Windows Workflow, SQL Server 2008, C#.NET, WCF, Entity Framework, Code contracts, Ajax, Oracle PL/SQL,SVN

Responsibilities

Web Pages developing using MVC3, CSS.

Implemented business logics in MVC3 controllers.

Client side validations using JQuery, JavaScript.

Worked on Model, View, Controller for AMS

Familiar with standard concepts, practices, and procedures within the scope of database management.

Create functions, stored procedures and views using SQL Server 2008.Unit testing on entire project.

Worked on the Data layer of AMS using entity framework.

Developed the methods in the business layer to implement them in the activities.

Worked in consuming the shared activities such as File share that is already developed by the other team.

Designed and created tables in EHRIMS database which is a SQL server database.

Involved in Unit Testing of AMS for code.

Implemented Code contracts.

Experience in developing various design patterns.

Used firebug, IE development toolbar and Fiddler for debugging and browser compatibility

Worked in Agile environment and successfully completed 4 sprints.

Team consisted of 4 developers and 2 QA resources.

VarsuneTechnologies, Hyderabad, India Jan 2012 – Sep 2012

Role: Sr. Software Engineer

Hindustan Aeronautics Limited Project

OCTLDMS is a comprehensive Security document management system for capturing, archiving, indexing and retrieving any type of document - paper, email, fax etc. Its rich set of features include full text search, ability to store large amount of documents in repository, elaborate security permissions etc.

The project is built on a web-based modular architecture, which combines technical robustness with flexibility to adapt to business processes. Conforming to industrial standards, it is also an immensely scalable solution primarily because it can be customized to any level to suit any type of industry.

Environment: ASP.Net MVC,Ajax, Bootstrap, SQL Server 2008, Java Script, Windows 7, VS2010, .Net Framework 4.0, Visual Source Safe 8.0, SSRS, Entity Frame Work, MVC,SVN

Responsibilities

Involved in the SDLC phase of requirement analysis, design, and development of the web based intranet application tool using ASP.NET 4.0 and C#.

Graphical User Interface (GUI) was designed using ASP.NET MVC and the business logic was coded in C#.

3-Tier Application Architecture to ensure flexible and reusability of the application.

Developed various web services using WCF which can be consumed by web application and other systems.

Used Entity Framework to integrate small projects.

Created views and controllers and bind the data from services.

Designed Web forms and code associated methods using MVC (Razor).

Implemented Model Validations for validation purposes on the Server Side.

We use Jqrid to generate reports.

Business Logic coding and Unit testing.

Implemented change-requests and new feature additions

Used Session Objects, Cookies to store the application state.

Used ASP.NET, HTML and CSS to design the presentation layer of the website.

Prepared various test cases to fix the bugs and ensure the application error-free.

Used .Net Framework class library to build user interface that separated application logic from presentation code using code behind pages.

Designed and developed SSIS packages for processing and loading customer and business data.

Used Windows Communication Foundation (WCF) for multiple services to interact with the application for the clients.

Experience in developing various design patterns.

Used firebug, IE development toolbar and Fiddler for debugging and browser compatibility

Used XML to transport and store data.

Used Master Pages to provide a unified look and feel to the application.

Used AJAX to create better, faster and more user-friendly web applications.

Participated in various Client meetings with the team and the Project manager to discuss improvements/amendments in the development of the section.

Sify Technologies Limited, Hyderabad, India Apr 2011 – Dec 2011

Role: Software Engineer

Sify DMS Project

Sify DMS is a fully web-based application for archiving documents. Document Management System is a component of Enterprise Content Management System (ECM), used to track and store electronic documents and images of paper documents and enables clients with very distributed operations to centralize their document management into one efficient, secure and universally available environment, dramatically improving user access and document security.

Environment: .Net Framework (C#, ADO.Net, and ASP.NET), VB.NET, Active Directory Service, SQL Server 2005, IIS, XML, COM, Crystal Reports, SSRS, SVN

Responsibilities

Involved in several sprint meetings and planning the project development.

Involved in developing application using 3-Tier Architecture (Presentation Layer, Business Layer, Data Access Layer)

Responsible for designing and developing Presentation layer (User Interface) using HTML, DHTML, JQuery plugins, Java script.

Responsible for developing User Controls (.ascx), C#, JQuery which were commonly used for MSDN, TechNet web pages.

Responsible for developing master pages (. master), Nested Master pages to give a common look and feel to the application.

Responsible for developing validations scripts (Regular Expression validations, Authentication Validations, Custom Validations using JQuery.

Extensively used JQuery as code behind for all the webpages in MSDN and TechNet, and developed JQuery Model Popup’s and dynamically generating the HTML content based in the response JSON Format data from WCF service call and appending into a web pages.

Responsible for developing a script which effectively handles all the client side events (Button Click, Mouse Hover, Mouse Out etc.,) using JQuery. bind and. unbind methods.

Implemented changes in coding and designs using knowledge of VB .NET

Developed and tested user-friendly navigators by utilizing JavaScript and VB .NET

Responsible for writing the automated testing scripts using QUnit Testing to test the Application.

Proactively participated in working with testing team to test the application.

Responsible for developing server side scripting using C#.

Saman InfoTech private Limited Nov 2009 – May 2011

Role: Application/Winforms Developer

Issues and Change management

The Issue, Change management process is a Web based application which helps to keep a track of client issues, application change management for ongoing projects. Any issue with an application as reported by a Client/User is entered in the application. After a brief research into the issue, any Changes if required are associated with it. The issue, change is assigned to a project member by the manager who then completes it. Supporting documentation can be associated with each Issue, Change.

Environment: ASP.Net, Visual C#, VB.NET, SQL Server2000, Windows XP/2000, Visual Studio 2003, WinForms

Responsibilities

Assisted in development of new software solutions in C# domain within .Net development framework.

Implemented procedures for continuous development and support services of existing software systems.

Executed effective processes for preparation and maintenance of unit testing services.

Provided technical assistance for maintenance and development of existing database structures.

Supported technical team members in designing, development and support of desktop systems for order management systems.

Developed N-tier Architecture.

Creating applications using VB.NET and enhancing projects for .NET applications

Used ASP.NET validation controls and wrote java script for advance validation.

Extensively used .net features like ASP.Net, ADO.Net, web controls, assemblies etc.

Used Custom Controls like Tab control, Fixed Grid Control.

Developed MS Winforms utilizing MVP/Event Aggregator Patterns.

Executed processes for support and maintenance of applications utilizing C# and other languages.

Assisted in identification, escalation and documentation of production issues for delivery of client solutions.

Supported technical team members in preparation of research papers, white papers and decision documents.

Developed reports for viewing the issues based on user, change type, dates.

Created and integrated database Stored Procedures for data access, reports.

Functional testing using detail Test Scripts.

Preparing Detail Test Cases.

Uploading the files using XML.



Contact this candidate