Sign in

.Net Developer Sql Server

Hyderabad, Telangana, India
March 14, 2018

Contact this candidate

BALA Email:

Senior .Net Developer Phone: 972-***-****


Over 9+ years of experience in Software Analysis, Design, Development, Migration, Testing and Deployment

Of secure, multi-tier web and client-server applications.

Well versed in designing, coding, implementation of Internet/Intranet Applications like Web forms and Web Services using ASP.NET MVC,ASP.NET, VB.NET, Classic ASP and C #.NET, ADO.NET, Microsoft SQL Server and

IIS (Internet Information Services).

Strong Foundation in Design Patterns, SOLID Principles and Object oriented concepts.

Strong Knowledge in End-to-End Software Development Life Cycle, Application Development Methodology

(ADM) and Agile Methodologies, ER Diagram.

Experience on migration on old technology to new technology.

Used Agile practices and Test Driven Development techniques to provide reliable, working software.

Worked on N-Tier Architectures like MVC (Model View Controller), MVVM (Model View View Model)

design patterns on the applications.

Experience in developing Graphical User Interfaces using XAML, Silver Light, JQuery, AJAX, Kendo UI and


Extensively used RESHARPER in many projects for refactoring of C# code and make the code more efficient.

Strong experience in the Analysis, Design, Development and Implementation of multi-tier web based

applications and distributed applications for web services, .NET Remoting Services and Web 2.0 Standards

based on Service Oriented Architecture (SOA), REST.

Expertise in Database Design and Database Programming using SQL Server 2000/2005/2008/2012 and


Experienced in SQL for writing, Indexes, and Views, Stored Procedures, Cursors, Triggers under define function DTS, Transaction management, T-SQL, code optimization and performance Tuning creating table

and Index.

Hands on experience in creating and modifying reports with reporting tools like Crystal Reports, SSRS using

MS BI Tool.

Experience in gathering customer requirements and functional requirements and converting them to

technical specifications/requirements and replacing current system with Web-based application.

Extensive usage of Delegates and Events to establish communication between the WinForms.

Knowledge in XML transformation languages like XSL, XSLT and X Path.

Experience in creating Unified Modeling Language (UML) diagrams like Class, Sequence and Use Case

diagram using Rational Rose and MS Visio.

Deployed a variety of .NET Framework Applications including Windows and Web Forms.

Experience in building and consuming .NET Web Services using SOAP, REST and WSDL.

Skilled in continuous integration and deployment.

Well versed with test driven development, used NUnit, MbUnit and Visual Studio Test Tools for Unit testing. Post-release maintenance bug fixing and adding enhancements based on requests by offshore feedback

during the project migration/testing.

Involved in debugging, bug fixing, testing phase of the application and error handling routines.

Responsible for programming and testing customizations in support of customer-specific business requirements. Also responsible review over application designs, code and provide support for existing applications.


Programming Languages C#, Java, C

Web Technologies ASP.NET, MVC, Web API, WCF, REST, XML, NodeJs, Angular JS, HTML,

CSS, JavaScript, JQuery, Ajax. Dependency Injection, IIS

DATA BASE SYSTEMS SQL Server 2000/2005/2008/2012, Oracle 9i/10g/11g/12c, MS-Access,


IDE / DEVELOPMENT TOOLS Visual Studio, Eclipse, chrome developer tool


Continuous Integration Cruise Control

Version Control Systems Team Foundation Server, GIT, SVN

Operating Systems Windows NT/2000/2003/XP/Vista, Windows Server 2012/2008/2003,


XML Related Technologies XML, XSL, XSLT, XPath, SOAP, WSDL

Reporting Tools SSRS, Crystal Reports


PROJECT#1 Limits of Authority

Client ( Andeavor) - San Antonio TX

April 2017-PRESENT

ROLE: Senior .Net Developer

DESCRIPTION: LOA application is to enable people to delegate accountabilities and decision-making power accurately and within their legal powers.


Worked closely with business analysts, business architects, and solution architects to understand business processes and document requirements to design technical solutions

Developed rest full services using web API

Implemented dependency injection using Windsor container

Implemented Unit tests in NUnit to test server side logic

Implemented fronted using Angular JS

Implemented styles sheets in Sass

Implemented unit tests in mocha to test frontend functionality

Implemented stored procedures to perform complex SQL operations

Implemented an Interface using Webmethods middleware to automate Data Import from SAP HR to LOA database

Implemented Business Logic to automate Assignment of LOA templates to employees based on management Level they belongs

Implemented Interface using Webmethods middleware to export LOA values using database view

Worked with Middle ware team (web Methods) to automate importing employee data from SAP HR to LOA SQL database

Worked with HTR and mini master teams to do integration testing of LOA


NOV 2015-MARCH 2017

ROLE: Senior .Net Developer

DESCRIPTION: TADA is an Executive Operating Solution (EOS) that provides visibility to business leaders by mapping their organizational landscape with speed, flexibility, and scalability.


Developed Data Contracts a Windows based application used to transform raw data from multiple sources

using set of operations like Aggregate Rows, join etc. and publishes data to Network.

Used Lucene as search index for storing intermediate data of transformations.

Used XML to store transformation related metadata.

Implemented REDIS cache for storing metadata of the network.

Implemented services using WCF and Web API.

Developed Web application portal to sync the data using Angular JS.

Developed Web application to create widgets and factsheets.

Automated build process using NANT and CruiseControl.NET.

Used Windsor container for dependency injection.

Used LINQ for querying objects.

Used LINQ to XML to handle xml file data.

Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, validate form inputs, special effects and customize selections.

Extensively used Master Pages in designing the webpages and used Cascading Style sheets for a unified look of the application.

Environment: 4.0 with C#, SQL Server, LINQ, JQuery, WEB API, MVC, HTML 5, Angular JS

PROJECT#2 Product Cost Management – Surya Technologies NC MAY 2013 - OCT 2015

ROLE: .Net Developer

DESCRIPTION: Product Cost Management Application is a secure tool to help NPI teams efficiently collect, and perform cost roll ups prior to Gateway 3 to streamline processes to ensure cost effective high quality time management, clarify changing Bill of Material (BOM), collaborating supplier information, and ensuring safe sources for all estimates. Created logical and physical data models.


Responsible for the PCM Application Data model and Architecture using design patterns and proven


Developed high level and low level application design. Designed and developed interfaces for business layer.

Developed huge database queries and packages to roll up and export data to excel in tree view structure

With a 2 sec response time.

Developed complex SQL queries using CONNECT BY clause to deal with Parent-child Functionality to display

the BOM views

Created logical and physical data models.

Design, develop, databases, including writing stored procedures and user defined functions.

Design the application architecture in .NET using well defined object oriented design principles. Design and integrate reports with the system and provide customization for advanced search.

Created a complex security framework to match all the cost security limitations set by business team. Created advance filters so that users can customize their own reports.

Implemented Open XML reports to create multi sheet excel reports.

Environment: 4.0 with C#, SQL Server, LINQ, JQuery, WEB API, MVC, HTML 5

PROJECT#3 Soft Sol, Hyderabad, India

SEPT 2011 - APR 2013

Role: .Net Developer

DESCRIPTION: Soft Sol Communications, Inc. provides small and medium sized businesses with a fully integrated, hosted communications solution. Utilizing best of breed technology, Soft Sol serves as your outsourcing partner to efficiently supply and manage the communications needs.


Involved in gathering all requirements from the client and provided expertise advice for better enhancement of the application.

Creating and maintaining UI prototypes and specifications.

Responsible for gathering requirements and preparing Business Requirements. Document (BRD), Software Requirement Specification (SRS).

Worked on Quotes and Order Generation in ecommerce platform.

Collaborating with Product Managers and Software Engineers to provide guidelines on solid UI design. Keeping up to date with the latest industry trends in UI design and usability.

Translating market and product requirements into UI designs in the form of Conceptual models, Wireframes and prototypes

Followed MVC3 architecture.

Followed Razor View Engine approach in the MVC Pattern. Used Schema First approach in the Entity Framework.

Used LINQ-SQL extensively for extracting the data from database using Entity Framework. Used WPF for rendering user interfaces in Windows based applications.

Gathering requirements from client and creating Functional specification document.

Implemented Server and Client side validations using ASP.NET validation controls, JQuery and JavaScript. Developed WCF web services for calling API methods.

Involved in fixing the bugs based on the client requirements and involved in the enhancements for the web forms, class files and stored procedures.

Experienced in using Silver light for providing a more compelling engaging and rich media experience for viewers which is a cross-browser, cross-platform implementation of the .NET Framework. Used HTML, XML, AJAX, JavaScript, CSS and pure CSS layouts.

Designed the user interfaces using Web Server Controls which are built on ASP.NET Server Controls.

Developed Business Logic Component using Web Services, WSDL.

Implemented SOAP (Simple Object Access Protocol) for communication of application.

Used LINQ to Objects for WCF service call.

Used SSRS for SQL reporting services.

Used AJAX for rich user experience in designing the screens. GUI was developed using C#.NET and ASP.NET.

Used .NET Framework 3.0 throughout the project and converted existing code from 1.1 to 3.0. Modifications were made to the existing GUI using WPF for better look and feel.

Consumed Web services using WCF and WPF for online transactions using C# and exposed them through HTTP

Environment:-.NET Framework 2.0/3.0, VB.NET, C#, ASP.Net, ADO.NET, NHibernate, Visual Studio

2003/2005/2008, Web services, XML, AJAX, HTML, CSS, CSS 3, IIS, SQL Server 2000 and Windows XP.

PROJECT#4 Countrywide Corp Hyderabad, India

Role: .Net Developer

JUL 2009 – Aug 2011

DESCRIPTION :NSS is National Sales support system, which helps the sales force of Countrywide in performing their activities accurately and efficiently. NSS prime responsibility is to help the top management to get an overview of the sales per territory or region etc


Involved in entire SDLC for the application.

Handled individual modules like Home page, Pay Online, Get Paid, Manage Account.

Define the Diagrams using Visio according to customer requirements.

Designed Web Pages using C# Asp.Net, Java Scrip for better UI.

Worked on Visual Studio Office for C#.

Made use of Data Grid, Data List and Repeater Controls to display data in a customized format in the ASP.NET web pages.

Created web pages according to client's guidelines and standards throughout the development and maintenance of the website using DHTML, HTML, XML CSS, Share Point and JavaScript.

Created User Controls and Custom Controls to encapsulate the UI.

Developed web pages/user controls as per requirement documents use-cases, wireframes, etc. while interacting with Business Analyst for their implementation.

Implementation of Business Logic of at entity manager layer.

Worked on integration of FAST ESP Search API at service layer with the application.

Worked on capturing Activity Capture on selected function/pages/download actions/emails in entire application.

Utilized HTML and JavaScript extensively, with the Cascading Style Sheets specification used to control the appearance of the site.

Developed Test classes and did Unit Testing using NUNIT and Integration Testing of the system.

Environment: Windows 7, Visual Studio 2008/2010, ASP.NET, C#, Entity Framework 5.0, Java script, JQuery, AJAX, HTML5, SQL Server 2008, IIS, NUnit.

PROJECT#5 Broadgate PVT Ltd, India

May 2008– JUN 2009

Role: .NET Developer

DESCRIPTION: Developing Add-Ins for Microsoft Office applications like PowerPoint, Word and Excel which will be used by bankers and management to create standardized pitches, presentations, charts and documents.


Involved in development of web based application to develop new modules and enhance existing

functionality in the application.

The application was developed in .Net framework 3.5 and 4.0 Created user controls to provide reusability feature.

Worked on C# and VB applications as multiple projects were gathered to make full fledge application. WCF services were getting used to get the distributed functionality feature.

Created stored procedure in SQL server 2008 database

Created reports using COGNOSE tools based on the data provided by the user.

Used XML serialization and de-serialization to provide data transportation functionality. Created various MIS reports using Data Grid Control and displayed the data.

Implemented custom forms authentication to secure the application.

Used OOPS (object oriented programming language) concepts in developing classes. Used ADO.NET Controls like Connection, Command, Dataset and Data reader.

Transformed XML document with XSLT in ASP.NET application.

Designed and created ER Diagram and a new database in SQL Server 2005. Worked on Visual Studio Office for C#.

Created database objects like tables, views, and stored procedures that are used throughout the application.

Responsible in Error Handling using Try, Catch, finally exceptional handling technique to avoid circumstances leading to abnormal program termination.

Environment: Windows XP Professional, Visual Studio 2008, ASP.NET, WinForms, C#, LINQ, IIS, SQL Server 2008, HTML.


Bachelor of Technology in Computer Engineering JNTU, Hyderabad, India.

Contact this candidate