Sql Server .Net Service Developer Development
Resume:
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
•
Summary MCTS: Microsoft Certified Technology
Specialist - .NET 2.0 Web Applications -
Highly proficient IT professional with over Seven years of experience in
Microsoft .NET Framework 2.0 -
designing and developing Enterprise .NET applications in Windows
Application Development Foundation
environments for Manufacturing, Retail, Utilities, Health,
Imaging/Storage and Financial Service Industries.
• MCP: Microsoft Certified Professional -
Experience in Application Development Foundation -
Design and Development of User Interfaces using C#, HTML,
Microsoft .NET 2.0 Web Based Client
DHTML, VBScript, JavaScript, JQuery.
Development
XML technologies such as web services, XML, XSL and
XSLT.
• Brainbench - ASP.NET, SQL Server 2005
Version control tools like Visual Source Safe, SubVersion,
Team Foundation Server, and Telelogic Synergy 6.5.
• Attended Microsoft Visual Studio Launch
Developing SSIS packages to migrate the data from legacy
database to SQL Server. Conference – Powered by Microsoft and
Creating Reports including sub-reports, drill-downs, DevConnections
graphs/charts and summary reports using SQL Server Reporting
Services (SSRS) 2008/2005.
End-to-End testing including validation, unit testing, integration
testing, troubleshooting, and bug fixing.
Performance Analysis and Tuning, Production Support &
Maintenance Solutions.
• Waterfall, Agile and SCRUM development methodologies.
Good interpersonal written/verbal communication skills, ability to
work under pressure, prioritize and multi-task efficiently in a team
setting or independently.
Education and Certifications
• M.S in Computer Science, Columbus, OH
• B.E. in Electronics & Communications, Bangalore
University, INDIA
• MCPD: Microsoft Certified Professional Developer - Web
Developer - Designing and Developing Web Applications by
Using the Microsoft .NET Framework
1 of 8
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
Areas of Expertise
• Extensive experience in applications architecture design, adapt in
use of design patterns(ex: GOF) and architectures(ex: SOA, N
Tier, Web Services, Security)
• C#, ASP.NET, IIS, HTML, DHTML, SOAP, ADO.NET, XML Web
Services, Windows Comm Foundation (WCF) Web Service, Web
and Windows Custom Controls, User Controls, Class Libraries, Win
Forms and Web Forms.
• AJAX controls, Delegates, XML, Security, Globalization, Error
Handling Techniques and good knowledge in WPF, Silverlight,
.NET Remoting, Tools provided by .NET Framework
• Database design, entity relationship, and database programming
including writing SQL Queries, Tables, Views, Stored Procedures,
Functions, and Triggers using MS SQL Server.
• Software Development Life Cycle including
requirements,architecture,design, development, implementation and
maintenance of various Web & Windows based Software Projects.
Experience and Skills
• OS - Windows 2003 Server (Windows.NET Server), Windows 2000
Advanced
• OS Client - Windows 95/98/2000 Professional / XP / Vista Business
• Programming Languages – C, C++, .NET 1.1, 2.0, 3.0, 3.5, 4.0
C#, T-SQL, HQL (Hibernate Query Language), JavaScript,
Visual Basic 6.0.
• Internet Applications - HTML, DHTML, HTTP, SOAP, XML Web
Services, ASP.NET, JavaScript, VBScript, XML, XSL.
• IDE & Front-end tools - Visual Studio. NET 2008/2005, Visual
Basic 6.0/5.0, Visual Studio, Visual Interdev, Front page 2000,
NUnit 2.5.1
• Web Server - Microsoft IIS 6.0, 5.1
• Database - SQL Server 2008/2005/2000/7.0, Oracle 8/9.x and MS-
Access.
• Data Integration & Reporting - SSIS 2008, SQL Server 2005
Reporting Services and Crystal Reports.
Version Control - Visual Source Safe, Team Foundation Server,
Telelogic Synergy, Change ManagementSuite6.5,TortoiseSVN
2 of 8
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
WORK EXPERIENCE
Client: Jacobus Energy, Milwaukee, WI 5/10 - Present
(Executed remotely from Rockville, MD)
Role: Senior Software Consultant
Jacobus Energy is one of the nation's premier petroleum marketers; Jacobus Energy provides fuel and related services
to businesses nationwide. Its major divisions include Quick Fuel and Quickflash Heating & Cooling Services
Quick Fuel Fleet Services is a comprehensive fuel management program for commercial fleets anchored by a network
of automated fueling sites in major cities throughout the Midwest and South. Quick Fuel offers a variety of fueling
programs including on-site mobile refueling, terminal fuel management, and automated fueling stations - giving fleets
a competitive advantage by lowering bottom line fuel costs and improving fleet efficiency.
Key Accomplishments –
Involved in design and development of redesigning Quick Fuel Admin Website for manager users, viewing
and ordering cards system for admin users.
Responsibilities –
Suggested Best Technologies to execute the project.
Created UML Use Case diagrams, Class diagrams, and object diagram using Microsoft Visio.
Designed and developed data access layer using LINQ to SQL.
Developed WCF Service to communicate with BIZ Talk server.
Developed Admin UI and Daily Transaction Reports.
Developed Kentico CMS for ASP.NET project.
Environment: Windows 7, Visual Studio.NET 4.0, AJAX, LINQ, ASP.NET, C#, SQL Server 2008, JavaScript, Team
Foundation Server, IIS 6.0 Web Server, SandCastle, Microsoft Visio 2010.
Client: GMR Marketing, Milwaukee, WI 10/09 –
05/10
Role: Senior Software Consultant
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
GMR Marketing is a forerunner in experiential marketing and pioneering the concepts of branded marquee events and
touring attractions that enable a consumer to engage with a brand through a tangible and personally relevant encounter.
To manage these processes, GMR has a number of software products which engage the customer, manage interactions
and deliver relevant data to the proper users.
Key Accomplishments –
Involved in design and development of web based inventory management system for management of large
event logistics, asset management and fulfillment. While managing a challenging delivery timeframe,
successfully delivered a scalable, quality software product from development to staging to production using
automated tools and best practices.
Responsibilities –
Created UML Use Case diagrams, Class diagrams, and object diagram using Microsoft Visio.
Developed project using SOA Architecture and design patterns like, Domain Driven Design, Unit of Work
Pattern, DTO and DTO Assembler Patterns, Validation and Notification Pattern, Supervising
Controller (MVP) Pattern, Parent and Child Presenter, UI Command, UI Microcontrollers.
Designed and Developed Data Access using Fluent NHibernate Object Relation Mapping (ORM).
Improved UI Performance using JQuery and JSON Services.
Logged messages to variety of output targets using Log4net.
Developed WCF Service in accordance with SOA principles to support distributed computing.
Implemented NMock Unit testing for Object Models.
Developed Rich UI with third party Telerik Controls.
Created SSIS (2008) package to exporting/Importing formatted data files from client server to production
server.
Mentor team for UI Best Practices.
Environment: Windows XP, Visual Studio.NET 3.5, AJAX, LINQ, ASP.NET, C#, SQL Server 2008, JQuery, JSON,
Server, IIS 6.0 Web Server, SandCastle, Microsoft Visio 2008, Telerik Controls, TortoiseSVN an Interface to (Sub)
Version tool.
Client: Miller Coors, Milwaukee, WI 07/09 –
10/09
Role: Senior Software Consultant
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
Miller Coors is company with a unique foundation of great beer brands and 288 years of brewing experience &
heritage.
Key Accomplishments –
Involved in design and development of redesigning Miller ADNet website. AdNet is advertising, viewing and
ordering system for field marketing, sales personnel and distributors.
Responsibilities –
Created UML Use Case diagrams, Class diagrams, and object diagram using Microsoft Visio.
Developed project using design patterns like Abstract Factory, Factory Method
Designed and developed data access using NHibernate Object Relation Mapping (ORM).
Created SSIS (2008) package to migrate data from legacy database to SQL Server.
Developed UI by creating Web Forms using AJAX Controls, Web Server Controls and User controls and
used Master Page and Nested Master Page for common designs.
Improved UI performance by using JQuery.
Involved in hiring .NET Consultants for the team.
Research and presented best third party tools to build the application.
Mentor team for UI Best Practices.
Environment: Windows 7, Visual Studio.NET 3.5, AJAX, LINQ, ASP.NET, C#, SQL Server 2008, JavaScript, Team
Foundation Server, IIS 6.0 Web Server, SandCastle, Microsoft Visio 2008.
Client: Johnson Controls, Milwaukee, WI 08/08 –
07/09
Role: Senior Software Consultant
Johnson Controls is a global leader in automotive experience, building efficiency and power solutions. For buildings, it
offers products and services that optimize energy use and improve comfort and security.
Key Accomplishments –
Designed and developed EUPM (Energy and Utility Performance Monitoring) module to the MARS
(Metasys Advanced Reporting System) application.
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
MARS is an application which provides the ability to select, save, run built-in Metasys reports and/or configure
energy items on site data. Metasys is a building management system gives more control and easier access to
information that can effortlessly link your building systems with your IT systems locally and remotely.
EUPM configuration module provides the means for the user to create, update and delete the new EUPM objects
created in the MSEA (Metasys System Extended Architecture) user view and configure them and view these
parameters in the Report.
EUPM configuration benefits the users to:
• Create new Billing Period and Rate objects.
• Delete Energy Object Items (Meter/Equipment/Billing Period/Rate).
• Modify the attributes (one to many) of Energy objects.
Responsibilities –
Created UML Use Case diagrams, Class diagrams, and object diagram using Microsoft Visio.
Developed project using Model View Presenter (MVP) for user interface design pattern to facilitate
automated unit testing and improve the separation of concerns in presentation logic.
Developed project using design patterns like Abstract Factory, Factory Method, Singleton, Bridge
Implemented Business Process as a Service using .NET Windows Communication Foundation (WCF)
service
Developed application for Globalization.
Developed UI using third party Infragistices Controls, used Master Page and Nested Master Page for
common designs and LINQ to query the data.
Designed and developed Data Access using LINQ to XML.
Environment: Windows XP, Visual Studio.NET 3.5, AJAX, LINQ, ASP.NET, XML Spy, C#, SQL Server 2008, NUnit
2.5.1, JavaScript, Telelogic Synergy 6.5, Adobe Acrobat, Beyond Compare 2, IIS 6.0/5.1 Web Server, SandCastle,
Enterprise Architecture 2.0, PSP/TSP
Obj100
Client: State Of Wisconsin – Dept of Financial Institution, Madison, WI 02/05 – 07/08
Role: Senior Application Consultant
Department of Financial Institutions, DFI is an agency with several divisions (Banking, Credit Unions, Securities and
Corporate and Consumer Services) regulates and licenses financial service providers who do business in Wisconsin.
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
As a part of the team, I was involved in number of .NET projects in development to automate the various business
process of Department of Financial Institution, WI like Banking and Saving Institutions, Mortgage Banking,
Corporate Services and Licensed Financial Services.
Significant Projects executed –
• Case Management: Develop and implement a departmental framework, encompassing all program areas, to
record and track the receipt, assignment, progress, and disposition of consumer cases.
• Payment-CVV2: Add CVV2 feature to DFI Online Payment system. CVV2 Credit Card verification helped
DFI settle chargeback disputes for online credit card transactions.
• Provider reconciliation: Developed a reconcile system which includes a reconcile process between provider
transactions with local transactions, thereby ensuring synchronization between the payment provider and local
systems.
• SQL Server 2005 Reporting Services: Migrated MS-Access reports to SQL Server 2005 Reporting Services
reports. This involved both enhancing existing reports and creating new reports. SQL Server reports had enhanced
user interface, moving the report selection functionality from a static menu list to a data-driven form.
• RegAgent Changes: Created ‘Online RegAgent Changes’ web application. This application allows the
submission of registered agent changes. Existing payment processing system is also integrated with this system
• Online Order System: It is a secure online entry which replaces paper forms and stack of fax.
• UCC Notification: Created ‘UCC Notification’, an online mechanism for the customers to create and
maintain notification for a particular UCC filing. Created XML Web Service to communicate existing ASP
component with the new .NET server components. This application integrates with the payment processing
system.
Responsibilities -
Created UML Use Case diagrams, Class diagrams, and object diagram using Microsoft Visio.
Implemented Business process as a service using .NET Web Services.
Worked on Presentation Layer, Business logic layer, Service Layer and Data Access Layer.
Implemented Business Process as a Service using .NET Web Services.
Developed UI by creating Web Forms using AJAX Controls, Web Server Controls and User controls and
used Master Page for common designs.
Designed and developed Data Model.
Developed ADO.NET entity framework for data access.
Implemented Role Based Forms Authentication for security.
Created Reports using SQL (2005) Reporting Service.
Sapna Sharma
http://www.linkedin.com/in/SapnaSharma
abmepa@r.postjobfree.com
(262) 408 – 8431 (Cell) (301) 238 – 5183 (Home)
Implemented NUnit testing for object models and Created Python test scripts to ensure quality of the
product.
Environment: Windows XP, Visual Studio.NET/2.0, ASP.NET, XML Spy, C#, SQL Server 2000/2005, SQL Server
(2005) Reporting Services, NUnit 2.4.7, Visual Basic 6.0, VBScript, Microsoft Visual Source Safe 6.0, JavaScript,
Adobe Acrobat, Axis Merge, Visual Source Safe, Team Foundation Server, IIS 6.0/5.1 Web Server.
OTHER PROJECTS EXECUTED
• 08/04 – 02/05 American Academy of Cosmetic Dentistry, Madison, WI
Application Consultant – .NET Framework - Visual Studio.NET 1.0, ASP.NET,
C#, ADO.Net, SQL Server 2000, mySQL, Visual Basic 6.0, VB Script,
JavaScript, Classic ASP, Microsoft Visual Source Safe 6.0.
• 05/03 – 08/04 Nationwide Mutual Insurance,, Columbus, OH
.NET Developer – .NET Framework - Visual Studio.NET 1.0,ASP.NET, C#,
ADO.Net, SQL Server 2000, T-SQL, Microsoft Visual Source Safe 6.0.
Microsoft Visio.
Contact this candidate