Post Job Free
Sign in

.Net Developer Sql Server Project Experience Management

Location:
Bolingbrook, IL
Posted:
February 11, 2014

Contact this candidate

Resume:

SRI CHARANI LINGAMANENI

***.***********@*******.***

260-***-****

SUMMARY:

Over Seven years of Information Technology experience in developing Internet, intranet & client server applications

using Microsoft.NET technologies, C#, ASP.NET, ADO.NET, AJAX, XML, XSL, Win Forms, ASP.NET

2.0/3.0/3.5/4.0, WCF, LINQ,WPF, SQL Server 2005/2008, IIS, HTML, DHTML, HTML5, CSS, JavaScript, T-

SQL, Web Forms, Windows Services, SOAP, WSDL and Web Services .NET Enterprise Serviced Components,

Multithreading with domain knowledge of Education, E-learning, Government, Healthcare and Media.

Two plus years as a Tech lead involving in guiding development team, resolving technical issues, coordinating

development team and testing team.

Experience in Requirement Analysis, Application Development, Application Maintenance, Functional Studies,

Quality Reviews and Testing by being a part of all phases of Systems Development Life Cycle (SDLC).

• Experience in developing Web Services and N-Tier Web applications using C#, ASP.NET, ADO.NET, WCF, LINQ.

• Experience in web application development on MVC 3.0 framework.

• Experience in developing projects in .NET framework 2.0/3.5/4.0 and good knowledge of .NET Remoting, Caching and

Security.

• Experience in migrating Windows and Web based applications to .NET platform.

• Experience in Web Application Design and Development using n-Tier, SOA and MVC Architectures

• Excellent Experience in Object Oriented Analysis and Design (OOA & D), development, implementation and testing of

software application.

• Experience in developing client side validations and business implementations using JQuery, Ajax and JavaScript.

• Good Experience in Adobe Flex Framework 4.0, Action Script 2.0 & 3.0. Flash Media Server 3.5, Flash CS5.

• Proficient in developing Use Case Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams

(sequence diagrams), and Class Diagrams based on UML methodology

• Expertise in Code reviews, Defined coding standards, and performance optimization using .NET Technologies

• Experience in developing projects in Visual Source Safe 6.0, SVN and Team Foundation Server 2010

• Experience in XML related technologies: XML, XSD, DOM, XSL, WSDL, UDDI, SOAP and XPath.

• Database Design, Development, and Administration using MS SQL Server 2005/ 2008.

• Experience in writing complex Database Queries, Stored procedures, Triggers, Cursors, Database programming,

Normalization, Indexing, performance tuning, SQL Server Integration services (SSIS), and data model analysis & data

migration using MS SQL Server 2005/2008.

• Experience in Agile and Waterfall software development methodologies.

• Ability to manage the quality of project as per the CMMI Level 5 requirements.

• Exceptional ability to adapt to latest technologies, perseverant, innovative, organized and self-starter.

• Possess strong team building skills and competencies needed to analyze problems, respond to changing need, and forge strong

working relationships with peers and clientele

TECHNICAL SKILLS:

Technology/

Framework

.NET 2.0 & 3.5, 4.0, ASP.Net, ADO.Net, MVC, WCF, LINQ, WPF, XML, XSLT

Programming Languages

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

Databases

SQL Server 2005/2008, Oracle 10g, MS Access.

IDE Tools

Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Sitecore 6.5.

Web Servers

IIS 6.0, IIS 7.0

Internet/Scripting Languages

JavaScript, JQuery, HTML, HTML5, DHTML, CSS, VBScript, XML, XSLT, XPath, XSL, AJAX.

Version Control Systems

MS Visual Source Safe (VSS) 6.0 & Team Foundation Server.

Hardware / Platforms

Windows Vista, Windows XP, & Windows 2003 server

Reporting Tools

Crystal Reports, SQL Reporting Services

Network Protocols

TCP/IP, HTTP/HTTPS, FTP.

CERTIFICATIONS OF EXCELLENCE:

MCSD 70-486: Developing ASP.NET MVC 4 Web Applications

MCTS 70-515 : Web application development using .Net framework 4

Brain Bench certification in .Net Framework 2.0, ASP.NET Fundamentals, Master ASP.NET 2.0, Master

ADO.NET, Programming Concepts, OO Concepts

EDUCATION

Bachelor of Engineering, Osmania University, Hyderabad

PROFESSIONAL EXPERIENCE:

Ulta Beauty, Bolingbrook, IL Oct 2013 to Present

Senior .Net/SQL Developer

Project Objective and Description: ULTA Beauty is the largest beauty retailer that provides one-stop shopping for

prestige, mass and salon products and services in the United States. ULTA Beauty provides affordable indulgence to its

customers by combining the product breadth, value and convenience of a beauty superstore with the distinctive

environment and experience of a specialty retailer. Loyalty Point System is a program for rewarding customers based on

the their Ulta membership. It has three web applications to manage memberships, Rewards, bonus points and create

Daily reports . Objective of this project is to develop Point Reward System for different memberships, different

programs depending on the customer eligibility criteria then apply campaign offers and bonus points to the customers

depends on the offers provided to eligible customers and generating daily activity report for all active customers and

stores.

Responsibilities:

Implemented ASP.NET provider models like Role, Session, Sitemap, Membership providers.

Implemented Master pages, Themes, CSS and Telerik controls for rich user interface.

Implemented complex business functionalities like file uploading.

Implemented ATLAS-AJAX, XML, and XSL in the application to provide user friendly interface to the user.

Implemented Windows Workflow Foundation (WWF) to create state based workflows that pass through Benefit

Administrators, Call service representatives, and Managers.

Developed Service Oriented Architecture (SOA) based system with Windows Communication Foundation

(WCF).

Implemented Exception Handling, Data Access Layer and Event logging using Microsoft Application Blocks.

Designed and developed Data base schema for staging tables, production tables and normalizing the tables and

indexing to tune the performance.

Developed SSIS package that validates the Excel sheets with specific requirements and do SQL validations and

imports to the data base.

Reporting to client based on requirements using SQL Server Reporting Services (SSRS).

Developed tools, created scripts, and setup systems for a one-step scripted build including unit testing, functional

testing and automated the test cases.

Created and scheduled Jobs in Tidal for SSIS Packages.

Extremely used TFS for version control, Work Items for tasks, Bug tracker, Documents, Reports, and Stable

nightly builds.

Environment and Tools: Net Framework 4.0, WCF Framework,LINQ to SQL, SQL Server 2008, Visual studio 2010,

SQL Server Management Studio, Team Foundation Server 2010,WWF, Enterprise Library, MS Unit Testing, Telerik,

Tidal, JQuery

Department of Human Services, State of Tennessee, Nashville, TN Sep, 2012 to Sep 2013

Senior .Net Developer

Project Objective and Description: ARTS application is a web application used by the Appeals and Hearings Staff

of Department Human Services (DHS) in Tennessee. The application is mainly used for creating, tracking and

processing the different types of appeals received by DHS.

Responsibilities:

Actively involved in gathering and documenting the requirements from the business

Developed the special services application using windows communication Foundation ( WCF)

Developed the application on MVC 3.0

Implemented Model, controller and views for the application

Implemented the validation using MVC data annotations between SOA

Worked with Ajax enabled WCF services using C# and ASP.Net

Implemented the different functionalities at the client side using JQuery and Ajax

Implemented the some business functionalities using Entity Frame work

Developed the Stored Procedures as a part of Data Base maintenance on SQL 2005 and SQL 2008

Developed the SSIS packages for loading the tables from text files and Excel sheets

Actively involved in Agile approach SCRUM meetings, Sprint planning, sprint Retrospective, Sprint

review meetings

Used the TFS for source control, Work Item tracking and Project management functions.

Developed the unit test cases for testing the individual blocks in the developed application

Environment and Tools: C#.NET, Visual Studio 2008, Visual Studio 2010, SQL Server 2008, ADO.Net, ASP.NET 3.0.,

ASP.NET 4.0.,MVC 3.0, Windows XP/ Windows 7

Kaplan University, Fort Lauderdale, FL Jul, 2010 to Aug 2012

Associate of Project (Tech Lead) / Senior .Net Developer

Project Objective and Description: Kaplan University is predominantly a distance learning institution of higher

education that is regionally accredited by the Higher Learning Commission. Seminar 2 is the Virtual

Class Room implementation where the teacher will be able to take classes to the students online through

the Seminar Tool, where the Tools has predominantly 2 modes, a teacher mode and a student Mode. This

project is extremely huge having nearly 650 code base files.

Responsibilities:

Involved in analysis of client requirements, development and testing.

Lead offshore .Net and testing teams by coordinating with Flex/Flash Development Team.

Developed Web services using WCF Framework with knowledge of JSON.

Worked on LINQ to SQL for backend design and development.

Developed client side validations using JQuery.

Involved in Integrating .NET services with Flex Application using WebOrb 3.0

Supporting flex team with good knowledge in .Net framework for better development of application with

flex and .Net integration.

Used TFS for source control, Work Item tracking and Project management functions.

Involved in analysis and document preparation of seminar2 .Net application

Developed the unit test cases for testing the individual blocks in the developed application

Responsible for Build release the application and deployment of Build-release.

Participated in thorough testing of application before releasing the build in to QA.

Actively involved in Agile SCRUM meetings, Sprint planning, sprint Retrospective, Sprint review meetings

Worked in Onsite/Offshore model.

Involved in R&D to propose better solutions for addressing challenges in the project.

Environment and Tools : .Net Framework 4.0 with WCF Framework and LINQ to SQL, SQL Server 2008, Adobe Flex

Framework 4.0, Action Script 2.0 & 3.0. Flash Media Server 3.5, Flash CS5, JQuery, Visual studio 2008, SQL Server

Management Studio Express, WebOrb 3.0, Flash Builder 4.0, Flash Media Server 3.5, and Flash CS5, Team Foundation

Server 2010.

Rodale, New York Apr, 2010 to Jul 2010

Senior .Net Developer

Project Objective and Description: Kraft Engagement program is a website development for Kraft foods, the site is

expected to provide diet and exercise related suggestions and recommendations to the end users who wish to maintain

good health and control their diabetes. The recommendations to the users are dynamic in nature based on their current &

target weight, number of days of the program, gender etc. Also, community networking features like maintaining message

boards, centers and blogs are provided to the user. KEP Phase 2 is a project for development of 365MYHEALTH and

365LIVING sites with all the enhancements to the Kraft Engagement (THR!VE365) site.

This project objective is to deliver all modules on time as per client requirement.

Responsibilities:

Extensive involvement in all stages of application development life cycle ( SDLC) including requirements,

design, development, implementation, and support.

Designed Strategic N-Tier Application Architecture model for consistency and best utilization of Object

Oriented Concepts, extensible and scalable model.

Created extended custom server controls for different systems.

Created nested Master Pages and CSS for presentation layer.

Involved in development process of total 365LIVING site.

Developed few modules in 365MYHEALTH site.

Extensively worked on PL/SQL to create packages, functions, cursors, and procedures.

Developed stored procedures and scripts for the reference data set up in QC and DEV Environments.

Visual Source safe administration and customized the project template according to the requirements and

maintained the repository for branching and merging etc.

Responsible for addressing production issues

Environment and Tools: .NET 3.5 (ASP.NET using C#), Oracle 10g, Visual studio 2008, Visual Source safe 6.0,

Oracle SQL Developer

Rodale, New York Dec, 2009 to Apr 2010

Senior .Net Developer

Project Objective and Description: Rodale is maintaining few web sites that are designed to help the users to maintain a

balanced health and lead a best life. These websites offer suggestions for good diet, decent life styles and tips on

workouts, what to eat and why care about health.

This project object is to deliver these websites time to time enhancements and fixing of production issues.

Responsibilities:

Validated the client-side data using ASP.NET Validation controls and JavaScript.

Used Caching Services for better application performance.

User Interface screens were designed and developed in Grid view depending on the nature of requirements to

generate reports.

Used ISAPI filters and Http Handlers and Http Modules.

Implemented event driven programming by creating different user controls for code reusability.

Translating the existing applications in to different cultures by creating the Global Resource files.

Used Sitecore 6.5 for content management of website.

Used Visual source safe Source control for versioning of multiple applications and database stored

procedures.

Responsible for creating and managing schema objects such as Stored Procedures, tables, views, indexes

and referential integrity depending on user requirements and converting them into technical specifications.

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

Production issues were treated as highest priority and are addressed accordingly.

Environment and Tools: .NET 3.5 (ASP.NET using C#), Oracle 10g, Visual studio 2008, Visual Source safe 6.0, Oracle

SQL Developer, Sitecore 6.5

PR Newswire, New York Dec, 2007 to Dec, 2009

Module Lead/ .Net Developer

Project Objective and Description: PR Newswire is the global leader in news and information distribution services for

professional communicators. PR Newswire Association provides electronic distribution, targeting, measurement and

broadcast services on behalf of tens of thousands of corporate, government, association, labor, nonprofit, and other

customers worldwide.

This project is a web based application used by the customers of PR Newswire to upload news releases, photos and

multimedia for distribution via the wire. It also lets the customers manage their broadcast fax and e-mail lists, manage

image archive, and view news release Activity Reports and Search Engine Visibility results. It also has interface for the

PRN internal users to manage the users of the portal, manage the customer requests, view reports and access different

maintenance tools.

Responsibilities:

Lead the module

Identify the requirements through interactions.

Involved in designing and developing web pages by using Asp.Net.

Involved in coding the functionality by using C#.Net.

Perform Code Reviews.

Implemented N Unit testing and SIT testing

Used VSS 6.0 for version controlling of .Net application and Database stored procedures.

Written stored procedures and queries in Oracle 10g, which are used to manipulate the backend database

Environment and Tools: .NET Framework 3.5, C#.Net, ADO.NET, Visual Studio.NET 2008, Oracle 10g, Visual Source

Safe 6.0,HTML, JavaScript, WCF, XML, Ajax, JQuery

Satyam computers, Hyderabad. Jul, 2006 to Nov, 2007

.Net Developer

Project Objective and Description: The purpose of the project is to provide a platform for car pooling activity where

the employees of an organization can help each other by sharing the same vehicle for traveling.

Responsibilities:

Identify the requirements through interactions.

Requirement Analysis, Designing, Coding, Unit Testing.

Involved in full Application Development starting from creating UI Screens to writing Stored Procedures.

Written stored procedures and queries in SQL server, which are used to manipulate the backend database

Environment and Tools: .NET Framework 2.0, C#.Net, Winforms, Visual Studio.NET 2005, My SQL, HTML, XML.



Contact this candidate