Post Job Free

Resume

Sign in

Sql Server Project Manager

Location:
Shreveport, LA
Posted:
June 25, 2014

Contact this candidate

Resume:

Bhavani Yellamelli

Cell #: 337-***-**** E-mail:

acep7l@r.postjobfree.com

Summary:

• Experience in designing and developing software applications in several different

engagements, focused on .Net based Applications.

• Expertise in Microsoft Visual Studio 2010/2012, .net 4.0/3.5/3.0, ASP.NET, C#, .NET

Framework 3.5, Windows Presentation Foundation (WPF), MVC, SQL Server, Entity

Framework and LINQ.

• Good knowledge and experience on Windows Communication Foundation (WCF).

• Extensive experience in SQL Server Database design, Database maintenance,

developing T- SQL queries, stored procedures and triggers in SQL Server

2008/2005.

• Experience in usage of third party tools Telerik RAD controls for Silver light.

• Experience in developing web services (REST and SOAP).

• Highly proficient in using Microsoft word, Microsoft Front Page, Microsoft Visio,

Power point, Access, Excel, SharePoint 2010, Adobe Photoshop, Adobe

Dreamweaver, U4ia Design Software.

• Strong skills in Debugging Techniques, Object Oriented programming concepts and

Design patterns.

• Strong Knowledge of cross-browser Compatibility Issues and Support.

• Experience in usage of Source Control and Version Control tools Team Foundation

Server (TFS), Tortoise Subversion.

• Exposure in full Software Development Life Cycle (SDLC) which includes Software

Requirements gathering including the business requirements and system requirements,

System analysis and Design, Code Generation, Testing, Implementation and maintenance

of various business applications.

• Developed complex stored procedures, views, triggers and SSRS on MS SQL Server

• Self -motivated and able to work both individually and as part of team.

• Task-oriented and committed to deliver work products within the established

timelines.

• Ability to work under minimal supervision, adhere to deadlines, excellent verbal and

communication skills.

Technical Skills:

Web Technologies: ASP.NET, ADO .NET, AJAX, Windows Services, Forms, MVC,

Windows Communication Foundation, Windows Presentation

Foundation IIS Server, Visual Studio, XML, XSL, XSLT,

Entity Framework, LINQ

Other Tools: Telerik, ItextSharp, Jira, Pivotal Tracker.

Programming Languages: C#, VB, C++, C

Scripting Languages: Java Script, JQuery

Version Control: MS Team Foundation Server, SVN, Tortoise Hg, Bit Bucket,

Team City, Git, Nuget

Reporting Tools: Crystal Reports, Telerik Reports

Database: MS SQL Server 2005/2008/2012 SQL Azure, SQL Server 2008

R2,

MS Access 2007

System Designs: Unified Modeling Language (UML), Object-oriented Analysis

and Design (OOAD) and RDBMS

Work Experience:

Synapse Development Group, Software Developer Jun 2011 – Current

Southern University, Web Designer Jan 2010 – May 2011

Projects:

Lilah (Living Independent Life at Home) June 2011 – Current

Lilah is a Telehealth system that allows Family Members and Caregivers to remotely

monitor the health of a loved one/patient. Lilah is a Web based as well a Windows based

Application, custom designed to fit the individual needs of patients. It is based around a

touchscreen device that is configured to each patient’s need .It reminds patients when to

check their vitals and when to take medication. It also allows patients to video chat with a

medical professional when the need arises. It provides SMS/Phone /Email Health

Notifications when a patients reading is outside of their preferred health range. And is built

with custom created patient reminders that notify patients when they have an appointment

or remind patients to do household tasks. Every LILAH patient will have a package based

on their assessment of medical needs. It also includes social features in addition to the

medical features such as Games, Local weather, Personal Photo Gallery and Social Media.

Responsibilities:

• Implemented the project according to the Software Development Life Cycle (SDLC).

• Worked with JQuery to make client side AJAX calls to WCF and Web Services.

• Worked with Entity Framework 4.0 to develop both code first and database first

approaches and to create Object Relational Mapping.

• Designed Reports using Crystal Reports 2008.

• ItextSharp for generating pdf templates and for dynamically populating content.

• Worked with Telerik tools to create data grids and panels.

• Designed and developed various abstract classes, interfaces, classes to construct the

business logic using C# .NET and SQL.

• Created Stored Procedures to manipulate the database and to apply business logic

according to the user’s specifications.

• Developed the Generic Classes, which includes the frequently used functionality, so

that it can be reusable.

• Developed Web Services to communicate with the active directory and Database, to

generate emails etc.

• Developing and Consuming WCF Web Services (Rest and Soap) using C#, ASP .Net.

• Worked with Log4net for writing output log statements.

• Designed and developed dynamic ASPX web pages using C#, ASP .Net, HTML, Java

Script.

• Worked with SSL Certificates for creating secure web sites in IIS.

• Used Sessions to store the user-specific information throughout the Web Application.

• Extensively made use of Grid view, List view, Repeater Control, and Drop down List

for displaying the data in a clear and pleasant format.

• Created Web.Config files for setting up of the application by writing database

connections.

• Used Cascading Style Sheets (CSS) to attain uniformity of all web pages and to

control the layout and look of the page easily.

• Extensively used Master Pages, Web User and Custom Controls in developing the front

end application.

• Worked with .NET Login Controls (Create User Wizard, Password Recovery, Login

View, Login and Login Status) and Custom Controls.

• Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Modal

Popup Extender within some web pages.

• Exception Management mechanism using Exception Handling Application Blocks to

handle the exceptions.

• Created Test Cases and performed Unit Testing of components to ASP.NET

Analyzed requirements, Contributed to architecture design and developed UML

Diagrams

• Involved in Debugging and fixing the bugs in maintenance phase.

• Worked on Integrating Third Party Services like Call- Em -All for Automated

Messaging Service, Microsoft Health Vault with our application.

• Worked with SQL Site Map Provider to generate custom menus.

• Responsible for migrating the Application source code across Environments from

Development to Beta and Production.

Environments/Tools/Skills Used: Visual Studio 2010, ADO.NET, SQL Server 2008,

ASP.NET, CSS, HTML5, Java Script, JQuery, C#, IIS, Rest and Soap Web Services,

WCF, AJAX, ItextSharp, Telerik Rad Controls for ASP.NET and Ajax, Telerik Reporting,

Log4net1.2, .Net Migrations.

Project Status Tracking and Reporting Tool

Project status tracking and reporting program is an Ajax-enabled ASP.NET web

application to track the status of all the projects that need to be administered by the

Project Manager. The application contains two modules. The project status tracking

module allows the users to track the status of a project and get the update to date view

while the Reporting module allows the users to generate the reports of timesheets, and also

several other reports to estimate and check every aspect of each project to see if it is on

track. The Application allows the administrator to create new projects, task lists, delete the

projects, assigning resources, tasks, issues etc. The team members can fill in the timesheets,

expenses, discuss issues on each project which is automatically updated and gives the status

of the project real-time.

Responsibilities:

• Worked with Telerik tools to create data grids and panels.

• Implemented Windows Forms for numerous modules using C#.

• Created various re-usable User Controls.

• Involved in designing screens Graphical User Interface (GUI).

• Worked with .NET Login Controls (Create User Wizard, Password Recovery, Login

View, Login and Login Status) and Custom Controls.

• Developed Technologies used include ASP.NET (using C# programming language),

MS SQL Server 2005, HTML, CSS, XML, and Java Script.

Environments/Tools/Skills Used: Microsoft Visual Studio 2010, SQL SERVER 2010, Telerik

Rad Controls for ASP.NET and Ajax, Telerik Reporting, Free Textbox, ASP.NET 4.0, Ajax,

C#, JavaScript, CSS, HTML, T-SQL.

Doctor’s Office

Doctor’s office is an ASP.NET Web application which included some functionality and

responsibilities include requesting an appointment, notifying the doctors/doctors assistant

of the new appointment, scheduling the appointments, few html pages, designing the

database etc.

Responsibilities:

• Implemented windows form for numerous modules using C#.

• Involved in designing screens Graphical User Interface (GUI)

• Worked with HTML and CSS Scripts.

• Involved in gathering, documenting the requirements from the product stake

holders.

Environments/Tools/Skills Used: Microsoft Visual Studio 2008SQL SERVER 2008, IIS,

ASP.NET 3.5, ADO .NET, C#, CSS, Java Script, HTML, T-SQL.

Agent Portal

Agent Portal is a web based tool that provides functionality for real estate agents/realtors who are

within the In-House Realty network to update their personal information, client (people buying

/selling homes) status information, real estate agency information etc.

Responsibilities:

• Worked closely with marketing team and other IT teams to gather all the business

requirements.

• Implemented business, data access, UI layers using C#, ADO .NET, ASP

.NET, MVC respectively.

• Involved in merging two databases.

• Worked closely with the front-end engineers to design web services for integration.

Environments/Tools/Skills Used: C#,ASP .NET 3.5, MVC 3.0, LINQ, JQuery, AJAX, Java

Script, SQL Server 2008, Visual Studio 2008 .

Library Management System

This is an ASP.NET Web application which enables the Administrator and users to access

the library system online and check the status of a book online, search for a particular book

etc.

Responsibilities:

• Designed and developed dynamic ASPX web pages using C#, ASP.Net, HTML, Java

Script.

• Used Sessions to store the user-specific information throughout the Web Application.

• Used Cascading Style Sheets (CSS) to attain uniformity of all web pages and to

control the layout and look of the page easily.

• Used JavaScript to perform validations and catch the events on client’s browser.

• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter.

Environments/Tools/Skills Used: Microsoft Visual Studio 2005, SQL SERVER 2008,

ASP.NET 3.5, ADO .NET, C#, JavaScript, CSS, HTML, T-SQL.

Online Course portal for a campus

This project aims at creating a Courses portal for a campus/organization. This allows

registered users of the system to add a course and access the materials related to the course.

People can register themselves as students of a course or Faculty for a course. Sending

automatic emails to the Administration when a registration happens. There will be a

discussion board for each course where students can interact. An announcement section,

which contains the latest announcements. And a course content section which gives the

links for the material available for the course. For faculty members there will be an extra

link for uploading the course content in a zip file format. A mechanism for the faculty

members to create a test for the course specifying the test title and a set of multiple-choice

questions and duration of time of the test.

Responsibilities:

• Designed and developed various abstract classes, interfaces, classes to construct the

business logic using C#.NET, VB.NET, ADO.NET and PL/SQL.

• Worked with ASP.NET Web Forms, Web Services, and State Management, Caching

features, configuring optimizations and securing the web application.

• Developed client call back mechanism (AJAX) together with JavaScript to provide

better user interactivity.

• Extensively used ASP.NET Grid view control for displaying the data in a clear

format.

• Also utilized Microsoft Visio to create custom forms that would serve as the starting

page for custom workflows developed using Visual Studio 2008.

Environments/Tools/Skills Used: Microsoft Visual Studio Team System 2008, SQL SERVER

2008, ASP.NET 3.5, C#, JavaScript, CSS, HTML, T-SQL.

Education:

Master of Science in Computer Science,

Southern University and A&M College May

2011

Bachelors of Engineering in Information Technology,

Osmania University May 2009

REFERENCES: Furnished upon request Relocation: Willing to

Relocate



Contact this candidate