Sonali Bellapravalu
					      [Send email using form at bottom]
						201 214 2662
						862 209 1097
				
			
 
	9+ years of experience in development, project lead / management role,
business / system analysis of client/server and web applications.
	Extensive experience in .NET Framework (VB.NET, ASP.NET, ADO.NET). 
	Has excellent communication and interpersonal skills.
	Chief liaison between the business groups and the technical teams.
	Led offshore development center efforts based on the business
requirements.
	Demonstrated ability in leading projects and delivering solutions.
	Experienced in defining project scope, developing project plans,
managing project communications and assigning resources.
	Intensive experience in Credit Risk Management / Assessment process.
	Highly organized with demonstrated ability using analytical and project
management expertise to successfully achieve goals.  Recognized for combining
interpersonal, negotiation and leadership skills managing teams and multi-tasking
throughout project life cycles.
	Well-developed analytical and problem-solving skills.  
	Ability to learn new concepts/technologies swiftly.  
	Recognized for using excellent verbal and written communication
skills.
	Enjoys new challenges with the opportunity to expand knowledge and
become an asset to the organization. 
	Self-motivated & diligent with an ability to adapt to new environments
and situations easily.


											
Computer Skills

Operating Systems	Windows 95/98/NT/2000/2003,XP
Languages	Visual Basic 6.0, VB.NET (1.0,1.1, 2.0),, VBA Excel
Databases	MS SQL Server (6.5, 7.0, 2000,2005), Oracle (7.x, 8i,10g) MS Access
Web Technologies	ASP.NET(1.0,1.1, 2.0), ASP, CSS 1.0, CSS 2.0 XML, XSL, XSLT,
DHTML and HTML, VBScript, AJAX, JavaScript, .Net Remoting
Web server	IIS 5.0, PWS
Data Connectivity	ADO.NET(1.0,1.1, 2.0),, ADO, RDO, ODBC, OLE-DB, ODP.Net
Web Design Tools	Macromedia Dream Weaver, Macromedia Flash MX, Adobe Photoshop,
Adobe Illustrator, Adobe Image Ready, Quark Express
Third Party Tools	Infragistics components
Middleware	COM, DCOM, MTS, COM+
IDE’s	Visual Studio.NET, Visual Interdev 6.0, Visual Source Safe, XML Spy
Report Tools	Crystal Reports, Business Objects
Other	MS SharePoint, Citrix Server, Salesforce, TeamTrack, TimeTrack



Education: 
Masters in Management of Information Systems – NJ
Bachelors in Commerce - India











Professional Experience

CIT Group, NJ								June 2006 – July2009
Project Lead / Manager / Senior .NET Analyst/ Senior Web Developer

Group: CRM (Credit Risk Management)

Projects:
1.	GES (Global Exposure System) – Web / Database Production Support
2.	Declination/Fraud Index – Project Lead / Manager
3.	AQR Reporting (Asset Quality Review) – Project Lead / Manager
4.	CSR Reporting (Credit Surveillance Review) – Project Lead / Manager
5.	MAF (Management Action Form-HR) – Web / Database Production Support
6.	CSR (Credit Surveillance System) – Project Lead / Manager 
7.	Forecasting – Project Lead / Manager
8.	Web server upgrade migration project


	Led the team through all phases of the System Development Life Cycle
(SDLC).  
	Coordinated with offshore development centers for most of the SDLC.
	Supervised consultants / offshore team to successfully implement the
interfaces. 
	Gathered business requirements by group and one to one meetings.
	Converted requirements into Business Requirement Document (BRD) for
design and development implementation.
	Gathered system requirements, analysis and design in .NET.
	Acted as a liaison between business groups and the corresponding
technical teams.
	Used Microsoft Project extensively to organize and manage project
tasks, tracking Gantt chart, & resource usage.
	Involved in making on-site design changes to meet the needs of the
business user.
	Developed and managed an issues list to prioritize report and resolve
problems.  Used Microsoft Excel to manage and report these issues.
	Conducted code review meetings to ensure source code development
standards were being met.
	Created PowerPoint presentations to demonstrate initial application
workflow to the business users.
	Designed and developed various graphical user interfaces (UI) of the
application using VB.NET & ASP.NET.
	Involved in designing the data model, analysis of source data,
transformation of logical model into physical model and generation of DDL.
	Managed “AS-IS” and “TO-BE” processes.
	Involved in IIS administration & troubleshooting application server
errors.
	Worked with change management group to set up elevation requests using
change & process management tool - Team Track.
	Involved in day to day production support.
	Implementing design compositions using cross-browser CSS, SEO-friendly
HTML and JavaScript, in a standard, maintainable and compliant way.
	Planned the schema, designed database objects tables, indexes, views,
sequences, integrity constraints, procedures, functions packages and database
triggers.
	Involved in designing & developing business logic layer (BLL) which is
a process of transitioning business rules into highly scalable, flexible and
manageable programming components. 
	Data Access Layer (DAL) was created for accessing SQL/Oracle database
in the most optimized way by minimizing concurrent database connections by
writing efficient SQL queries and stored procedures.
	Used SQL Developer to create packages, functions, procedures & triggers
for data access.
	Involved in creating macros for ad-hoc financial excel reporting.
	Used Fiddler to check web server load and the amount of data
transmitted to and exchanged from the web server.
	Reduced web page post back(s) by using third party component called
“component art” which enables AJAX within ASP.NET.
	Involved in User Acceptance (UAT) & system integration testing (SIT).
	Built an XML structure base (configuration file) for multiple database
connection string and for dynamic stored procedure parameters.
	Worked extensively with the major functionalities of Business Objects
like sections, breaks, alerter, filters, sorts, and ranks.
	Extensive unit testing and user acceptance testing (UAT) for developed
applications.
	Used XML to create Web-based tools for transactions on SQL and Oracle
databases.
	Modified the existing Data Transformation Services(DTS) packages as per
user requirements
	Created new DTS packages for transforming data gathered from various
global data sources.
	Created stored procedures with T-SQL cursors to clean up redundant
data.
	Involved in documentation, design, development and preparation of user
manuals of the complete project.
	Developing coding conventions and standards to enhance source code
management and increase software maintainability.
	Created excel based reports using VBA macros and ADO objects for data
access.
	Developed and published agendas and minutes of our project status
meetings.
	Conducted post-implementation reviews.
	Led the activities for unit, integration and user acceptance testing
for testing phases of the project.

Environment: VS.NET, VB.NET, ASP.NET, ADO.NET,ODP.NET, JavaScript, IIS,
VBScript, SQL Server 2005, Oracle 10i, SQL Developer, Visual Basic, VBA for
Excel, ASP, HTML, DHTML, Business Objects, Sales force, SharePoint, Citrix
Server,  Windows 2000/2003/XP



Coach, NYC									April 2006 – June 2006
Senior .NET Developer/Analyst

	Developed project plans and was responsible for verbal and written
project team communications.   
	Gathered, analyzed and documented complex business, functional and
system requirements.  
	Led the development effort of highly-intuitive, user friendly and
professionally designed Graphical User Interfaces (GUI) leveraging VB.NET.
	Migrated existing ASP and VB pages to ASP.NET and VB.NET in Visual
Studio.NET.
	Accessing data from SQL server in the most optimized way whereby
minimizing concurrent database connections, writing SQL Queries as efficient as
possible by creating stored procedures.
	Developed various intranet based web pages using HTML, DHTML, XML and
ASP.
	Designed and developed various graphical user interfaces (GUI) of the
application using VB.NET & ASP.NET.
	Developed and managed an issues list in Microsoft Excel.
	Involved in generating reports for the application using Crystal
Reports.
	Extensive end user training and hand-holding of users.
Environment: VS.NET, VB.NET, ASP.NET, JavaScript, IIS, VSS, VBScript, SQL
Server, Visual Basic, ASP, HTML, DHTML, Windows 2000/2003/XP




Bowne, NJ									July 2005 – April 2006
Senior .NET Developer/Analyst

	Gathered user/client requirements and drafting functional/technical
specifications from client/business users.
	Developed and managed project plans, resources, project issues and
communications.  
	Involved in designing, developing modules in an N-Tier Web Application
and UI in .NET environment.
	Led in migration existing ASP and VB pages to ASP.NET and VB.NET in
Visual Studio.NET.
	Used ASP .NET objects and ASP.NET components in creating dynamic web
pages.
	Designed and developed aspx pages using web forms, ascx controls,
validation controls, CSS style sheets to incorporate user interface in ASP.NET. 
	Extensively used VB.NET for creating code-behind and business logic.
	Conducted code review meetings to ensure source code development
standards were being met.
	Developed the web Forms, using server controls, validation controls
using VB.NET with IDE as Visual Studio.NET.
	Handled Run Time Errors & Design Time Errors by implementing
appropriate Error Handlers in VB.NET.
	Used ADO.NET to connect, retrieve, update, insert and delete the data
in SQL Server.
	Programmed ADO.NET in the Data Access Layer for communication between
application and the SQL Server database.
	Developed Windows Services to establish connection between UI layer,
Business layer and Data layer.
	Extensively used Datagrid to display data. Implemented data adapters,
datasets and data readers to execute stored procedures as well as SQL queries for
data manipulation and retrieval.
	Involved in trouble shooting the connection between the application
(Remoting client) and the remoting server.
	Deployed applications to QA / UAT and Production servers and also
changed the Config files accordingly.
	Assisted in resolving networking issues between the servers.
	Developed applications to Citrix server for end user accessibility.
	Wrote SQL stored procedures, functions, cursors, triggers, views and
packages to insert, update or delete information from the SQL Server database.
	Efficient team work using VSS and MS Sharepoint.
	Designed User controls for navigation, search functionalities and for
information display. 
	Fine tuned application performance using Caching, View State, and
Application objects in the .NET framework.
	Used XSL for displaying the XML document.
	User interaction with MS SharePoint and Citrix Server.
	Developed and published agendas and minutes of our project status
meetings.
	Generated reports using the Crystal Reports software.
	Documented the test cases and worked extensively with the QA team to
validate the final product with the functional requirements.
Environment: VS.NET, VB.NET, ASP.NET, JavaScript, IIS, VSS, VBScript, SQL
Server, Visual Basic, ASP, HTML, DHTML, XSL/XML, .Net Remoting, Crystal Reports,
MS Sharepoint, Citrix Server, .Net Windows Services, Windows 2000/2003/XP









Ajinomoto, NJ								Jan 2004 – July 2005
Senior Web Developer 

	Analyzed requirements and defined solution architecture. Work involved
interaction with the customers, collecting and analyzing requirements, designing
application architecture and preparing specification documents.
	Used VB.NET for code-behind in ASP.NET and HTML for user interface.
	Designed & developed ASP.NET User Controls.
	All UI layer web pages were created and integrated to maintain the
performance of data flow and data integrity using ASP.NET User Controls, Web
Server Controls and ADO.NET.
	Used ASP.NET / Data Bound Web Server controls like Data Grid and Data
List to display the records multicolumn grid on web pages. Customized the data
grid column by implementing Hyperlink Column to pass multiple queries to new
page.
	Developed UI for Budgeting which contains - Account & Products,
Payments, Maintenance, Processing, Contacts Administration.
	Designing and implementing business logic in VB.NET.
	Used Infragistics Controls (3rd party tool) along with ASP.NET web
controls and HTML controls to design and develop the UI.
	Designed and developed custom controls, .NET components and user
controls using ASP.NET.
	Used .NET security for securing the access by the users.
	Used XSL for displaying the XML document.
	Client side scripting using JavaScript.
	Created and generated different reports using SQL Reporting.
	Used ASP.NET Validation controls for validating user inputs.
	Development of Cascading Style Sheets, JavaScript and DHTML.
	Wrote COM components to access document server and deployed using
COM+.
	Provided production support for the existing applications.
	Used ADO.NET for SQL Server database interaction.
	Wrote stored procedures in SQL Server.
	Involved in unit and integration testing of the application
	Prepared the Detail Design Documents, Business requirement documents
and user training
Environment: Visual Studio. NET, VB.NET, Visual Basic, ASP.NET, ASP, JavaScript,
VBScript, HTML, DHTML, SQL Server, XSL/XML, Infragistics, Front Page, Adobe
Photoshop, SQL Reporting, Windows 2000

Oxford Healthplan, CT							Aug 2002 – Nov 2003
Web Developer
Environment: Visual Studio. NET, VB.NET, Visual Basic 6.0, ASP, ASP.NET,
ADO.NET, XML / XSL, HTML, DHTML, Java Script, VB Script, COM / DCOM, FrontPage,
Dream Weaver, Photoshop, Visual InterDev, SQL Server, Crystal reports, Windows
2000


Orbitz, India									Sept 1998 – June 2000	
Web Developer/Designer
Environment: Visual Basic 6.0, ASP, JavaScript, VBScript, HTML, DHTML, Front
Page, Dream Weaver, Photoshop, Flash, SQL Server, Windows NT


UTI Bank, India								Oct 1997 – July 1998
Web Developer/Designer					
Environment: Visual Basic 5.0, ASP, JavaScript, HTML, Visual Interdev, Front
Page, Dream Weaver, Photoshop, SQL Server, Windows NT.