Sql Server Project Manager
Resume:
Bhavani Yellamelli
Cell #: 337-***-**** E-mail:
*******.***********@*****.***
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