.Net Sql Server Design Experience Customer Service
Resume:
Pradnya
abnj5b@r.postjobfree.com
SUMMARY
• 6+ years of experience in Web Development in Financial, Banking, SEO, Retail segment.
• Developed UI in a multi-platform cross browser /OS combinations environment.
• Experience with web application development/client-side development with ASP/JSP,
ASP.Net, WCF, WPF, WWF, VB6/VB.NET,ADO.NET, Silver Light,PHP,
HTML,DHTML,XML,VB Script, JavaScript, and CSS/AJAX).
• Ability to write SQL queries and design tables in relational databases such as SQL
Server/My-SQL/Oracle using ADO.NET.
• Experience with the use of object-oriented design in real-world problems.
• Experience on both Windows and Linux
• Good Knowledge of .Net fundamentals, .Net framework, CLR, CTS
• Good Understanding of Design Patterns & UML Diagrams with Microsoft Visio.
• Experience with XML, C#, VB.NET, IIS, Visual Studio 2005 and Dreamweaver..
• Experience with version control systems such as Subversion or CVS
• Solid experience developing web applications utilizing Web 2.0 technologies such as AJAX
• Good Knowledge of Ruby, Ruby on Rails, Flex/Flash+ Action Script 2.0, .NET
Framework or C#,and Microsoft Expression suite
• Experience with Social Media Networking, Search Engine Optimization (SEO), Search
Engine Marketing (SEM).
• Familiar with Web Analytics, PPC, Word of Mouth Marketing, Comparison Shopping
Engines, Blogs, Online Reputation & Brand Management
• Having good problem solving and analytical skills, highly motivated, quick learner.
Language Asp.Net, VB.Net, Visual Studio 2005, C, C++, Java, XML, PL/SQL,
T-SQL, C#, LINQ
Microsoft Technologies C#, ASP.NET 3.5, Silver Light, WCF, VB.Net, ADO.NET, Win Forms,
WPF, WWF, Microsoft Visio (UML Diagrams), .Net Framework 2.0/3.5,
IIS 5.0/6.0,Visual Studio 2008,
Script Languages PHP 5.0, ASP, JSP, Perl, VB Script, Java Script, AJAX
Database SQL Server 2000/2005, My-SQL, Oracle 10i, MS-Access
Web Development HTML, DHTML, CSS, XML, XSL,XML Schema, XSLT, Flash, Adobe
Flex, FrontPage and Dreamweaver.
Reporting Tools Crystal Reports 9.0
Version Control Subversion, Concurrent Version System (CVS).
Web Servers IIS, Apache, Tomcat
Operating Systems Windows NT 4.0/2000/XP, Red Hat Linux 7.x, and UNIX
PROFESSIONAL EXPERIENCE
Silicon Valley Bank, CA
Web Developer Nov 08 –Till Date
Description:
SVB Financial Group helps entrepreneurs and enterprising companies succeed, offering
diversified and complementary financial services to technology and life science companies,
venture capital/private equity firms and premium wineries.
SVB Internet Banking application enables the customers to access their Bank Accounts online.
The application provides the “Account Summary” (balances, last deposits), “Activity Detail”
(Transaction Details) to transfer funds between various accounts using ‘Fund Transfers’. The
user has the option to change his ‘PIN’ number, enable or disable the ability to transfer funds
between accounts etc.
Roles & Responsibilities:
• Designed and developed web application using Web-Forms and User-controls on the .NET
Framework using VB.Net and C# .Net.
• Used UML Diagrams and Design Patterns for Classes, Use Case Diagrams & Sequence
diagrams
• Created reusable custom controls and used the AJAX control toolkit for a rich UI experience
in the web application.
• Did database design review and performance tuning for the RecoverEase database.
• Implemented application security by using Authentication and Encryption, enabled
persistence of user session data by using Serialization
• Used JavaScript, HTML, and CSS for making application user-friendly.
Involved in design and architecture of the ASP .Net application, WCF Services and Flex
•
Designed GUI for web pages using WPF, Silver Light & Flex.
•
Used Enterprise library packages for Exception Management and Data Access Layers
•
Developed and Consumed Web Services created by WCF using Flex and ASP .Net.
•
Developed Custom Controls, User Controls etc. using ASP.NET, Silver Light and Flex.
•
Executed the project using Agile and Scrum Model
•
Written T-SQL and Stored procedures to retrieve and save the data back to the Sql Server
•
2005 database.
Created complex Reports using Sql Server Reporting Services for information distributing
•
Integrated the data from client side using Sql Server Integration Services (SSIS)
•
Used XML for processing data returned through Web Services
•
Used Com/DCOM to access the office libraries for the services
•
Environment: .Net Framework 2.0/3.5, ASP.NET, Visual Studio 2005,UML,IIS, Dreamweaver,
Web-Forms, VB.Net, HTML, CSS, JavaScript, C# .Net,, Flex, Silver Light, JavaScript,WCF,WPF,
Sql Server Reporting Services, AJAX control toolkit, XML,X, SQL Server 2005.
JP Morgan Chase, Chicago
Web Developer Aug 07 –Sept 08
JP Morgan Chase is a leading global financial services firm with assets of $2.1 trillion and operations
in more than 60 countries. The firm is a leader in investment banking, financial services for
consumers, small business and commercial banking, financial transaction processing, asset
management, and private equity.
As part of this My Account Activity Restructure project, there are specific pain points identified by
management that are being addressed. To provide a better customer experience by displaying relevant
transaction information up front, thus reducing calls to Phone Bank, Customer Service etc. Some of
the features included as showing the pending transactions, available balance etc.
Responsibilities:
• Responsible for analyzing, Designing, and Development of the Project
• Client interaction for the enhancements of current system and gathering requirements.
• Involved in writing stored procedures and triggers in SQL Server 2000 for querying, batch
updates, insertion and deletion.
• Used UML Diagrams for Classes, Modules.
• Presentation layer was being developed in ASP.NET with XML and Business Layer (Code
Behind concept) programming in VB.NET.
• Designed of web forms using ASP.Net, HTML, CSS and JavaScript
• Involved in financial and activity report production by line of business, industry segments,
and product and by user.
• Extensive use of the ADO.NET objects such as Data grids, Data Tables, Data Readers and
Datasets for data retrieval and manipulation.
• Proven ability to develop applications across multiple complex environments with varying
configurations (DEV, QA, STAGE, and PROD).
• Supported the QA team through the testing and validation of applications.
• Used various validation controls and exception handling
• Database design and maintenance
Environment: ASP.Net, HTML, CSS, C#.Net, SQL Server 2000, Windows 2000, IIS, DHTML,
DHTML, JavaScript, XML/SOAP, UML, OLE-DB
Macy’s, San Francisco, CA July 06 – July 07
Software Engineer
Search Engine Marketing Application (SEMA) is a Macy's internal application that manages paid
advertisement content for search engines. Macy's Search Marketing personnel utilize SEMA as a tool
to set up internet ads and publish those ads to search engines. Currently, SEMA publishes ads to most
popular search engine Google but in the future SEMA will also publish ads to other search engines
like Yahoo, MSN, and AOL, etc. SEMA helps Macy's Search Marketing personnel to manage their
ad Campaigns.
Responsibilities
• Involved in System Software Life Cycle design, development, testing and documentation.
• Developed Web Forms using ASP.Net
• Involved in writing CSS files and include files to maintain the consistency and reusability of
the code in the web pages
• Features Applied using Cookies, Sessions, SSL, Control Panel and Revise Panel
• Worked with CURL Library functions for setting up advanced integration method with
Authorize.net gateway for secure credit card transaction.
• Worked on open source modules such as OsCommerce.
• Responsible for maintenance of database on server. Backup and Restore of database.
• Maintenance of server such as creating domains, Virtual hosting, uploading files, Password
Authentication etc.
• Developed prototypes for proposals and presentations to prospective clients
Tested applications for cross-browser issues.
• Improved SEO (Search Engine Optimization) resulting in a higher hit-rates
• Involved in preparation of technical documentation and Search engine optimization.
• Understanding business processes & identify value adding processes
VeriSign Payflow Pro functions to process credit cards and other financial transactions
• Responsible in preparation of system specs, development of various backend SQL stored
procedures needed to develop business logic, application logic and highly involved in the
database design of SQL Server 2000
• Created and used User Controls
• Used validation controls to validate the input data using the validation controls
• Designed and created reports using Crystal Reports
• Used ADO.NET to connect to the SQL Server database.
• Extensively used Dataset and Data Reader to transfer Data between the Client and Server.
Environment: ASP.Net,CSS, MySQL, JavaScript, ASP, Vbscript, HTML, Dreamweaver,
XHTML, XML, XSL, CURL, C#.NET, ADO.NET, HTML, SQL Server 2000, Crystal Report
Prudential Financial, New Jersey
Programmer Analyst May 05 – June 06
Prudential Financial is a provider of financial services such as banking, mortgage, insurance and
investment planning and investment banking.
Automated Underwriting System is a web-based application, which provides a financial analysis
of the customer’s ability to apply for a loan or an insurance policy. It provides a recommendation to
approve the loan or asks to refer to an underwriter based on the rules set in the system. AUS takes the
data directly from the online applications and Forms case files, which are checked and validated. A
decision is arrived at based on the score, the input parameters and the underwriting rules set in the
system.
Responsibilities
• Involved in design, development and maintenance of the modules.
• Developed Web Forms and validated these pages using C#.NET.
• Used ADO.NET extensively for data retrieving, querying, storage and manipulation.
• Developed SQL stored procedures for data manipulation and querying data from SQL
Server 2000.
• Developed complex reports using Crystal Reports.
• Performed unit testing on every new version before sending it for User Acceptance Test
(UAT).
• Interpreted business and functional requirements into a strong design
• Documented design solutions and implement according to the design
• Worked closely with other developers, project managers, database administrators and QA
• Identified opportunities for process improvements/efficiencies and drive adoption of high
priority/high value improvements within the team
• Managed time effectively with minimal supervision to accurately scope projects and ensure
that projects release on-time
Environment: C#.NET, ADO.NET, HTML, SQL Server 2000, Crystal Report, Visual Source
Safe
APLAB Ltd., India May 03 - Mar 05
R & D Software Engineer
Project 1: Automated Teller Machine (ATM)
Developed Kalignite software platform for completely hardware -independent self-service
applications and is also capable to communicate with TBA Server. It performs applications like
Keypad Entry, Balance Enquiry, Pin Change, and Cash Withdrawal
Responsibilities
• Design and implementation of database using ADO.Net
• Analysis and design of the project, created UML diagrams, explore objects using
CRC cards
• Used 3-tier Architecture, class analysis, interface programming and overall
subsystem design
• Developed Win Form using Visual Studio
• TCP/IP protocol for communication with Switch.
• Installation, training and maintenance of software at client-side.
• Testing of the code modules developed for accuracy of functionality.
• Design of libraries using VC++.
• Created the various documentation for software development like glossary, vision docs, use
case model/specs, architectural analysis/design etc
Environment: VB.net 2003, MS SQL Server 2000, VC++, C#, ADO.Net, XML, Visual Studio
2000, MS Visio, Design Pattern
Project 2: Gas Station Automation System
It helps oil companies to get real-time data on retail sales and manage inventory levels better. All
Pumps and tanks are connected to Central Server using TCP/IP protocol.
Responsibilities
• Design and implementation of Central Server.
• Design of reports using Crystal Reports 8.0 retrieving data for the reports through database.
• Design of ActiveX Controls and class libraries to make software configurable.
• Testing of the code modules developed for accuracy of functionality.
• Implementation of Interfacing between Server and Hardware component which are
• Communicating through RS-232.
• Communication with other devices is accomplished using TCP/IP protocol
Environment: VB.net 2003, MS SQL Server 2000, ASP.NET 2.0
Project 3: Customer Relationship Management (CRM)
Software developed to help for both the customer and the management and it enhances the
relationship among them.
Responsibilities
• Designed Complaint module, Order processing module using JDBC-ODBC connectivity.
• Worked on Java Web Server 2.0. Java Script which is used to enhance functionality and
developed user friendly interface.
Environment: JSP, Microsoft Access 2000, HTML, Java Script
EDUCATION
B. S. in Computer Science, India
Contact this candidate