Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Mumbai, MH, India
Posted:
November 17, 2016

Contact this candidate

Resume:

Anusha

Email: acxjjg@r.postjobfree.com

Contact # 956-***-****

Professional Summary:

Around 7 years of experience in Information Technology, Module Design, Development and Maintenance, Testing, Documentation, System analysis, full life-cycle project development experience.

Experience in .Net development, encompassing analysis, design, development and execution of business applications in N-Tier and SOA architectures.

Experience in detection of bugs, Rectifying the bugs, Supporting the application and Application maintenance.

Experience in using Net framework 3.0/3.5/4.0 technologies such as WCF and WPF.

Strong experience in Object Oriented Programming (OOP) and methodologies.

Experience in creating and consuming Web Services using C#. Experience in Object Oriented programming.

Experience working in Agile development methodology and Test Driven Development.

Programming concepts and Design Patterns (MVC, MVP).

Good exposure to the Software Development Life Cycle (SDLC), Service Oriented Architecture (SOA) and Agile Software Development.

Expertize in developing web based applications using ASP.NET, C# .NET, ADO.NET, Entity Framework, VB.Net, VB6 Silverlight, JavaScript, JQuery, WCF, LINQ, Angular JS, HTML5, CSS, CSS3, XML, XSL, XSLT.

Worked on LINQ to SQL, LINQ to ADO.Net Datasets, LINQ to Objects, and LINQ to XML.

Proficient in Client Side scripting using JSON, AJAX.

Proficient in Test Driven Development (TDD), Object Oriented Development (OOD) and Model View Control (MVC) design pattern.

Strong understanding and Implementations knowledge of Design Patterns.

Experience in using DB2 utilities for maintenance, data movement.

Hands on experience in web-application including Front-End & Database

Ability to handle Complex Queries, Sub Queries, Joins, Stored Procedures, Triggers

Ability to run Vera code scans for application security.

Experience in writing SQL Statements, Stored Procedures, Triggers, Views, and Functions in SQL Server.

Extensive experience in developing reports using Crystal Reports, MS Access reports and SQL Server Reporting Services (SSRS)

Experience with ETL/DTS packages using SSIS.

Fast learner with excellent problem solving capabilities.

Proven skills in relationship management with clients and effectively guiding teams during the project development life cycle and delivering the product within time line, cost and quality.

Ability to work closely with users, lead cross-functional teams and handle multiple concurrent assignments effectively.

Excellent communication and inter personal skills

Educational Qualification:

Bachelors of Technology in Computer science -Jawaharlal Nehru Technological University, India.

Technical Skills:

Programming Languages

C#,C++, PL/SQL, T-SQL, Perl Scripting

Microsoft .Net Technologies

.NET Framework 4.0/3.5/2.0, ASP.NET 4.0/3.5/3.0/2.0, ADO.NET, VB.NET,VB6, WCF,MVC

Scripting languages

JQuery, JSON, JavaScript, VB Script, Angular JS, Bootstrap, Kendo

RDBMS

MS SQL Server 2012/2008/2005/2000

Operating Systems

Windows Server 2008/2003/2000,Windows XP, Vista/ Windows 7, Unix, Linux

Web Services

Restful Web Service, SOAP

IDE

MS Visual Studio.NET 2013/2012/2010/2008/2005, RTC

Web Development

ASP, XML, HTML, XHTML, DHTML, CSS, XSLT, AJAX

Networking Protocols

TCP/IP, HTTP, FTP, SOAP

Web server

IIS 6.0 / IIS 7.0, Microsoft SQL Server

Report Writer

Crystal Reports, Business Object, SSIS, SSRS

ORM Tools

Entity Framework 3.0/4.0, NHibernate

Version Control System

GIT

Tools

LINQ to SQL, Team Foundation Server (TFS), SharePoint, NUnit, Azure, PowerShell, AWS

Development Methodologies

Agile development, Scrum, Test Driven Development (TDD), Object Oriented Development (OOD)

Professional Experience

Ohio Department of Transportation (ODOT), Columbus, OH August 2015 – Till Date

Role: Full Stack .NET Developer

Description:

The Ohio Department of Transportation is the administrative department of the Ohio state government responsible for developing and maintaining all state and federal roadways in the state of Ohio with exception of the Ohio Turnpike.

Responsibilities:

Understanding system requirements and execution of tasks allocated to maintain and develop Web pages.

Involved in the everyday scrum meeting which included the management.

Involved in supporting and maintaining the application after production.

Creating the routing logic by using Controller in ASP.NET MVC and Entity Framework.

Updating the entire application to be cross browser compatible

Ensuring quality of deliverables with Testing and Supply chain teams.

Used N-tier architecture for presentation, business and data access Layers.

Involved in coding member validation business functionality using WCF Rest services.

Implemented web user interface design using HTML5, Master Pages, Themes, CSS, AJAX.

Developed dynamic and responsive web pages using the HTML5, CSS 3 & 5, JavaScript frameworks (JQuery, Angular JS).

Performing Transition activities for Non-Mainframe DB2 Database Servers and basic administration activities of Oracle database.

Used LINQ in data and business layers.

Developed GUI using ASP.NET and C# as code behind language to implement the business logic.

Maintained and improved upon existing codebase and systems, including a RESTful web service using .NET Web API service-oriented architecture for data processing with RabbitMQ, SQL Server and Apache Solr for persistence layers

Responsible for troubleshoot and bug fix of the defects

Used agile methodologies for development through TDD, continuous integration, stand-up meetings.

Experience in developing Stored Procedures, triggers, views, Indexes using SQL Server 2008 and SQL Azure.

Analyze defects and find strategic and logic solution.

Developed web applications using ASP.NET and AJAX Extensions under MVC architecture.

Involved in consuming Restful web services to validate the data entered by the user.

Involved in generating Enterprise level reports using SSRS and used SSIS for data transformation.

Resolved issues in applications that are using C#.NET, VB.NET.

Worked on DB2 on different platforms in UNIX, Windows. Using SQL, obtained data from DB2 and other databases.

Experience with SQL Azure Dynamic Management Views.

Used LINQ to query the objects to get the orders and availability.

Used LINQ to SQL to get data from database.

Created multiple Perl scripts that retrieved data from the database using Oracle PL/SQL for displaying in reports.

Worked on AZURE, created the instances, Installed the Windows server, adapted web applications to run in Windows Azure against SQL AZURE using Azure Queues for background processing.

Retrieving the configurable data from XML files and displaying in front end GUI.

Proposing branching strategies for using Version Control Systems like Subversion and Git.

Used CAST to capture and quantify the reliability, security, complexity and size of business applications.

Used Server Controls like Data Grid, Datasets to display, manipulate data along with SQL Stored procedures to interact with the database

Unit and Integration Testing for the modules.

Environment: MS Visual Studio 2012, .NET Framework 4.5, C#, ASP.NET, DB2, AJAX, WCF, LINQ, MVC 4.0, Agile development, TDD, Azure, SQL Server 2008, T-SQL, Web Services, IIS7.0, HTML5, CSS3, XML, XSLT, JQuery, Angular JS, Bootstrap, SSRS Reports, GIT, Perl, Team Foundation Server, Windows 7

Jonas Fitness Inc., Columbus, Ohio August 2014 - July 2015

Role: .NET Developer

Description:

Our gym software solutions handle your complex daily operations with flying colors. Whether you're a mid-size or a high-end multi-location health club chain we have the industry knowledge and security to be your software partner for life.

Responsibilities:

Understanding system requirements and execution of tasks allocated to maintain and develop Web pages.

Involved in maintaining the application after production and detecting and rectifying bugs.

Documenting functional specifications and implementing UI elements in the Model and View layers.

Creating the routing logic by using Controller in ASP.NET MVC and Entity Framework.

Updating the entire application to be cross browser compatible.

Ensuring quality of deliverables with Testing and Supply chain teams.

Perform enhancements for Web using C# ASP.Net using Visual studio 2010 and SQL Server 2008.

Used N-tier architecture for presentation, business and data access Layers.

Involved in coding member validation business functionality using WCF Rest services.

Implemented web user interface design using HTML5, Master Pages, Themes, CSS, Web Parts, AJAX, JQuery and JavaScript.

Used LINQ in data and business layers.

Programmed the Intermec bar code scanner with VB.Net/SQL Server Compact and converted many VB6 RAPI routines to VB.net.

Responsible for troubleshoot and bug fix of the defects.

Involved on migrating SQL Server databases to SQL Azure Database using SQL Azure MigrationWizard.

Implemented a set of C++ adapter class to parse different XML requests and build internal data structure (DTO design pattern) to be used by service class.

Ensured the delivery of the desired deliverables using AGILE Methodology.

Analyze defects and find strategic and logic solution.

Performed DOM manipulations, create Templates, Directives, Factories, Controllers, and established two way Data binding using Angular JS.

Created User Interface presentation layer using ASP.NET, CSS, JavaScript, the data access layer (DAL) using ADO.NET.

Helped migrate from SOA to RESTful services using ASP.NET Web API.

Involved in migration and consolidation of Unix Servers in Production data center activities.

Version Control is managed by using GIT to protect from accidental file loss and track version.Performed TDD using NUNIT to find bugs at development phase itself and documented the results.

Responsible for developing and consuming WCF Services.

Written the Stored Procedures, user-defined functions, SQL queries, triggers, creating database users in SQL server.

Responsible for deploying the files to the development and test servers, configuration management

Environment: .NET Framework 3.5, Visual Studio 2008, ASP.NET, VB.NET, VB6, C#, C++, HTML, XML, XSLT, SQL Server 2005, Azure, Ajax, MVC, TDD, WCF, WPF, SSRS, IIS, PL /SQL

New Jersey Motor Vehicle Commission, Jersey City, NJ Jan 2013 – July 2014

Role: .NET Developer

Description:

The New Jersey Motor Vehicle Commission deals with many features like how to get a vehicle title, Pre-Owned vehicle titles, NJ Dealer out of business etc.

Responsibilities:

Interacted with Business Users for gathering business requirements and involved in analyzing, documenting business requirements, functional requirements for developing Forms, Documents and Reports.

Created dynamic web portal for authorized information requestors MATRX sub module using ASP.Net Web Forms application in Visual studio and developed reports using Reporting services.

Developed the sub modules using ASP.NET with business logic written in C# with Visual Studio

Used Data Set, Data Reader, Data Adapter, Grid view, Data Repeater for retrieving and displaying information.

Created ASP.NET web services using WSDL and SOAP for interacting with other sub systems and to access Reports, Forms and Notices.

Implemented WCF security features.

Defined request-response message system, typically expressed in JSON or XML, which is exposed via the web - most commonly by means of an HTTP-based web server using server-side web .

Developed online Billing Systems for users to view invoices

Developed online public information center and Web-based Query center applications

Developed the front end application using HTML5, CSS3, JavaScript, JSON, and Angular JS.

Used JQuery, JavaScript for advanced user controls and client side scripting for rendering dynamic content.

Extensively used LINQ to retrieve and manipulated data as strongly typed objects.

Experienced in creating Master pages, User Controls and used Cascading Style Sheet, HTML5 for ASP.NET web applications.

Implemented Ajax for creating interactive web application and for avoiding reloading of page for each request.

Session management of the application was well handled.

Used ADO.NET for connecting to SQL Server database

Complex Stored Procedures were created in SQL Server

Worked on development using Java, J2EE, JDBC, Servlets, JSP, Web Services, WSDL, and SOAP.

Generated Enterprise level reports using SSRS and used SSIS for data transformation solutions and extraction solutions.

Communicated with Agencies for Business Requirements, Analysis and Reports phase.

Involved in maintaining and supporting the application after production.

Involved in unit and functional testing.

Built xml templates and validated the generated files on a large scale for the business layer.

Implemented Authentication and Authorization security mechanisms

Environment: NET Framework 3.5/4.0, VisualStudio.Net 2008/2010, ASP.NET, MVC, C#, ADO.NET, Java, Entity Framework, CSS, XML, XSLT, AJAX, Angular Js, JavaScript, WCF, LINQ, SQL Server

ICICI Bank, Hyderabad, India Sept 2011 – Dec 2012

Role: .Net Developer

Description:

ICICI Bank is an Indian multinational banking and financial services company headquartered in Mumbai, Maharashtra, India, with its registered office in Vadodara.

Responsibilities:

Developed ASP.NET website using C#, HTML, JavaScript, ASP.Net and ADO.Net

Involved in developing the Business Layer and Web User Custom Controls in C#.NET

Created Web and HTML Controls to develop web pages and user controls

Designed all necessary database connection classes

Extensively worked on ADO.NET to talk to the SQL database

Designed and develop all necessary Web Forms with .NET

Developed user documentation and program maintenance documentation

Developed screens for user registration and authentication. Used ASP.NET validation controls for validating user data input

Designed and developed screens for User Interface & Interaction, also developed various Search Screens for different strategies

Developed triggers & stored procedures for automatic insertion & retrieval of Data

Used ADO.Net to access the data from back-end SQL Server database

Performed Unit and Tiered testing of the application

Environment : ASP.NET 3.5 in C#, XML, HTML, CSS, SQL Server 2005

Creative Global Solutions, Hyderabad, India July 2009 – Aug 2011

Role: .Net Developer

Description:

Creative Global Systems is a leading provider of end-to-end IT services and BPO solutions. The company has a client-centric delivery model that combines local, senior, on-site resources with the cost, scale, and quality advantages of off-shore operations.

Responsibilities:

Effectively involved in various stages of the development.

Designed, configured and developed the web application using ASP.NET, C# and CSS.

Created User Controls for the pages.

Implemented validation using ASP.Net Validation Controls.

Implemented session management for the application.

As a security measure implemented Form Based Authentication and Role Based Authorization.

Data is stored in Microsoft SQL Server database and retrieved using ADO.NET.

Consumed Web Service using VB.Net.

Wrote SQL queries, Stored Procedures, Triggers, and Indexes using SQL Server.

Data grid and Data list were used to display account summary, history and other information on the web pages.

Environment: .ASP.NET 1.1, ADO.NET, VB.Net, SQL Server 2000, Web Services, Windows XP, CSS, JavaScript and UML.



Contact this candidate