PRASHANTH SAMBANA

732-***-****

acr9h9@r.postjobfree.com

PROFESSIONAL SUMMARY

9+ years of IT experience in design, development, coding of business/commercial Web and Windows applications using Microsoft Technologies such as ASP.NET, C#, ADO.NET, Web Services, WCF Services, Java Script, XML, HTML.

Experience in all phases of software development life cycle SDLC in the areas of Business Requirements, System Analysis & Design, Development, and Implementation of Mission Critical applications and

Worked in Financial, commercial, telecom and healthcare related domains.

Exposure of working in Agile/Scrum environments.

Experience in developing web applications using ASP.NET and AJAX.

Experience in developing distributed applications using Web Services, and WCF.

Experience in designing Database and Database programming like writing Queries, Stored Procedures, Functions, and Triggers using SQL Server 2005/2008.

Exposure on developing UML, DFD and Data Model diagrams in MS Visio.

Creating VSTO add-ins and creating installers for 32 bit and 64 bit machines.

Strong Knowledge of Developing Web applications using XML, XAML, XSLT, HTML, DHTML, JavaScript and CSS.

Extensively used Grid Views with sorting, paging and Template Columns for Custom Nested Grid Views.

Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.Net.

Extensive work experience and knowledge of LINQ.

Experienced in .NET security features such as Authentication (Windows-based Authentication, Forms-based Authentication) and Authorization (Authorizing Users and Roles).

Skilled in transforming complex business requirements into software applications.

Good work ethics with excellent communication and interpersonal skills.Capable to delve into the new leading Technologies.

Ability to work well in team as well as individual environment.

TECHNICAL SKILLS

Programming Languages : C#.NET, T-SQL

Web Development : ASP.NET, AJAX, ASP.NET MVC

Web Languages : HTML, CSS, JavaScript

Distributed Technology : .NET Remoting, Web Services, WCF

Development Software : Microsoft .NET Framework 2.0/3.0/3.5/4.0, Visual Studio 2005/2008/2010

Modeling Software : MS Visio

Configuration Tools : Visual Source Safe, Team Foundation Server (TFS), Perforce, SVN.

Database Engine : SQL Server 2005/2008

Web Servers : IIS 5.1, 6.0, 7.0

Operating System : Windows Server 2003/2008, Windows 2000/XP/Vista/7

EDUCATION

Master of Computer Applications (MCA)

Bachelor of Computer Applications (BCA)

PROFESSIONAL EXPERIENCE:

SumTotal Systems, Gainesville, FL, USA Feb 2015 to till-date

Module Lead

Project: UDM (Unified Data Modelling),

The SumTotal Enterprise Suite is an integrated suite of business performance management and learning applications that develop talent, knowledge, learning and competencies from a single point. Sumtotal Enterprise Suite consists of TotalLMS, TotalPerformance, TotalCompensation, TotalLCMS, TotalVersioning, TotalVCS, Total Information, TotalAccess, TotalCollaboratin and Toolbook.

The scope of the project is to merge the TotalLMS(SumTotal Learning Management Systems) and TotalTM(Sumtotal Talent Management) databases into single database and re-designing the business and application layers.

RESPONSIBILITIES

Involved in unifying the database of LMS and TM Tools.

Involved in modifying the stored procedures based on the new table structure.

Resolved the issues that will be raised due to new table structure.

Interacted with Business Users to gather the requirements.

Involved in development of User Interface of application using ASP.NET, AJAX and JavaScript with C# language.

Responsible for design and development of Services that are consumed in various application processes.

Involved in tuning the queries which are taking long time to execute.

Responsible for modifying the business and data access layer based on new table structure.

Used WCF and Web services layer to communicate with several modules.

Used TFS for version controlling.

Played active role in Implementation, Pre and Post production supports.

Responsible for resolving the bugs.

Involved in unit testing and resolving the issues that occur due to database changes.

ENVIRONMENT

ASP.NET, C#.NET, SQL Server 2008, VS.NET 2012, WCF, Web Services, TFS, ADO.NET, XML, IIS 7.5, JavaScript, Windows Server 2008.

Megapath, San Jose, CA, USA March 2014 to Jan 2015

ModuleLead

Project: Megapath Apps,

Megapath is the leading voice, data, networking, cloud, and security managed services provider for small, medium, and enterprise in the United States.

Scope of the project is to develop the business work flows, web pages and automate the processing stages that are used to process the different order processing flows in Megapath enterprise. Developed business work flows, web pages, services to automate number portability for few of the carriers.

RESPONSIBILITIES

Interacted with Business Users to gather the requirements.

Followed Agile Scrum standards to go over the New Requirements/ Production Support Tickets/ Any Bugs.

Involved in designing the Database Model using MS Visio.

Involved in development of User Interface of application using ASP.NET, AJAX and JavaScript with C# language.

Responsible for design and development of Services that are consumed in various application processes.

Played active role in writing SQL Queries & Stored Procedures.

Involved in tuning the queries which are taking long time to execute.

Responsible for development of business and data access layer.

Used WCF and Web services layer to communicate with several modules.

Used perforce for version controlling.

Played active role in Implementation, Pre and Post production supports.

Responsible for creating workflows using Total Agility(Kofax) tool.

Developed login modules implementing Windows authentication and form authentication methods. Role management was done to give selective access to users.

ENVIRONMENT

ASP.NET, C#.NET, SQL Server 2008, VS.NET 2012, WCF, Web Services, Agile Methodology, SVN, ADO.NET, XML, IIS 7.5, JavaScript, Windows Server 2008.

Wells Fargo, San Francisco, CA, USA Sep 2012 to March 2014

Module Lead

Project: Automation of Wells Fargo Business Applications,

Automating Wells Fargo business applications such as

Wells Fargo Multifamily Capital – WFMC provides permanent multifamily and healthcare facility financing for experienced multifamily, senior housing and healthcare developers, investors and developers. With more than 30 years’ experience WFMC has developed strong relationship with its lending partners Fannie Mae and Freddie Mac and Federal Housing Administration (FHA). Loan originations can range in size from $5 million to $500 million with terms of 5 to 40 years.

Real Estate Capital Management – RECM is a source for long term, fixed-rate, commercial real estate loans. RECM loans are typically sold in the Commercial Mortgage Band Securities (CMBS).

Community Lending and Investment – CLI specializes in offering debt and equity capital to organizations that provide economic development, job creation and affordable development in communities of need nationwide.

The above banking applications are used by bank underwriters, these applications were built in MS-Excel. As there are thousands of business rules and formulas associated to different cells in the application it becomes very tough to manage them.

Automation of the business applications includes

Automating the testing of applications

Creating a repository to store and refer the business rules.

Storing important data in Salesforce.

Providing VSTO add-ins in excel for smooth usage of applications

RESPONSIBILITIES

Responsible for creating VSTO add-in.

Responsible for creating installers for 32 bit and 64 bit machines.

Involved in Requirementgathering, Analysis, Development and Implementation.

Developed the web application using ASP.Net, C#, HTML/CSS, XML, JavaScript.

Played active role in writing SQL Queries & Stored Procedures for reports using SQL server 2008.

Responsible for development of business and data access layer.

Played active role in Implementation, Pre and Post production supports.

Actively involved in SCRUM meetings discussing the implementation, integration of backlog modules considering the released version of software and best practices for solutions

Worked with n-Tier Architecture involving Services Layer, Data Access Layer, and Business Layer

Involved in unit testing and fixing the issues occurred in the testing process.

Prepared unit test cases and performed N-Unit Testing prior to system implementation.

ENVIRONMENT

ASP.NET, C#.NET, VSTO, Spec Flow, SQL Server 2008, VS.NET 2012, WCF, Web Services, SVN, ADO.NET, XML.

Norwest Venture Partners (NVP), USA Feb 2011 to Sep 2012

Module Lead

Project: Contact Management System,

Contact Management System is a web based application that allows users to synchronize different contacts from Salesforce and Cluen systems to Outlook public folders. The main aim of CMS is to create a central repository of all contacts used within NVP and further allow all the other systems to derive their data from this common repository. If there are any new or updated or deleted contacts then those contacts will be synchronized into their respective systems.

RESPONSIBILITIES

Involved in Requirementgathering, Analysis, Development and Implementation.

Played active role in writing SQL Queries & Stored Procedures for reports.

Involved in development of User Interface of application using ASP.NET, AJAX and JavaScript with C# language.

Responsible for development of business and data access layer.

Prepared unit test cases and performed N-Unit Testing prior to system implementation.

Actively participated in discussion with clients to freeze the requirements.

Reviewed and modified the code to eliminate design inconsistencies introduced during development cycles.

Involved in creating the TIP(technical Implementation Plan) document.

ENVIRONMENT

ASP.NET, C#.NET, VSTO, Spec Flow, SQL Server 2008, VS.NET 2012, WCF, Web Services,TFS, ADO.NET, XML, IIS 6.0, JavaScript.

CFC, USA Jan2009 to Feb 2011

Sr. Developer

Project: Bank In A Box,

With BIAB small businesses will be able to purchase RDC (Remote Deposit Capture) Solutions through retail outlets, office channels or online throughout the country. BIAB is more than just selling software or scanners but providing a complete solution offering comparable to bank RDC offerings. BIAB is a web-based application which has 3 modules.

Customer Module

Bank Module

CFC Module

RESPONSIBILITIES

Involved in Requirementgathering, Analysis, Development and Implementation.

Extensively worked on User Interface (views) using CSS, HTML, AJAX, Java Script

Involved in development of User Interface of application using ASP.NET, AJAX and JavaScript with C# language.

Played active role in writing SQL Queries & Stored Procedures.

Played active role in Implementation, Pre and Post production supports.

Prepared unit test cases and performed N-Unit Testing prior to system implementation.

Worked with Team Foundation Server 2010 for Source Code management and Bug Tracking.

Involved in writing HLD and LLD documents.

ENVIRONMENT

ASP.NET, C#.NET, SQL Server 2008, VS.NET 2012, WCF, Web Services, VSS, ADO.NET, JavaScript.

Logos Technologies, UK March 2008 to Jan 2009

Developer

Project: SMART-Dairy Card,

SMART-Dairy Card is a Pocket PC application, which continuously tracks the health of different patients by asking questions. The device automatically switches off ones the questionnaire finishes and switches on automatically after regular intervals of time with a beep sound. The device will be generally used for researching different habits of patient, it is also used to find out the result of a drug on a group of patients.

RESPONSIBILITIES

Designing E-Dairy pocket UI component.

Research, Structuring and Implementation of new things in Pocket PC.

ENVIRONMENT

.NET Compact Framework 2005, Windows CE 5.0, Windows mobile 6.0, C#, XML.

Sunburst Shutters, CA, USA June 2006 to Feb 2008

Developer

Project: I-Shutter –Tablet PC Application &i-Admin Website,

I-Shutter is a Tablet PC application, which considerably eases the daily workload for a sales person at Sunburst Shutters, a leading shutter manufacturing company in the US. By automating various stages in shutter manufacturing process, i-Shutter increases efficiency by excellent margins.

i-Admin is a Web application, which helps in keeping record of Sunburst Shutter’s sales activities. It is a centralized database for the company that maintains all the customer details, company data, employee roles and procedures to follow.

RESPONSIBILITIES

Design & Development of Windows application pages for i-Shutter.

Designing I-Admin web pages.

Writing stored procedures in SQL server 2005.

Played active role in writing SQL Queries & Stored Procedures.

Played active role in Implementation, Pre and Post production supports.

Prepared unit test cases and performed N-Unit Testing prior to system implementation.

ENVIRONMENT

Net Framework 2.0, ASP.NET 2.0, C#.Net, SQL server 2005, AJAX, Java Script.

Contact this candidate