Design Engineer .Net Sql Server Experience Service
Resume:
SHASHIDHAR K
abmlv4@r.postjobfree.com
Summary
. Extensive experience in both development and testing areas using
Microsoft.Net technology (C#, VB.NET, ASP.NET, WCF, WPF, LINQ, Entity
Framework, Web Forms, ADO.NET, Web Services ).
. Knowledge in database development for Oracle and SQL Server.
. Knowledge in multi-threaded programming.
. Experience using latest .net technologies like WPF, WCF, LINQ-SQL, Entity
framework.
. Involved in end to end software development lifecycle, from gathering
requirements to deployment and support.
. Extensive experience in Test Driven Development (TDD).
. Experience in developing both internet and windows applications.
. Hands on experience writing stored procedures, triggers, views and
designing tables and databases.
. Working experience with Object Oriented Programming (OOPS) technologies.
. Extensive Experience in Database Programming and Development using MS SQL
Server 2005/2000, and Oracle 9i/10g/11i. Good experience in SQL, T-SQL,
PL-SQL, Job Scheduling, Back-up & Restore, Triggers, Views and Stored
Procedures.
. Experience supporting and rewriting legacy applications.
. Worked both as an Individual contributor and as a team player.
. Experience in application of analytical, problem solving, communication
and interpersonal skills.
Technical
.NET Technologies .NET Framework 3.5/2.0/1.1/1.0, ADO.NET, ASP.NET,
.Net Web Services, Mapi.net, VSTO, LINQ, Entity
Framework, Astoria, Microsoft Enterprise Library,
Silverlight
Web Technologies ASP.NET3.5/2.0/1.1, AJAX, Web Services, HTML, Java Script,
CSS, Front Page 98/2000
Languages and API C#, VB.NET, C, C++, VB 6.0/5.0, T-SQL, PL/SQL, XML
Databases MS SQL Server 2005/2000, Oracle 9i/10g/11i
Servers IIS 6.0/5.0, Windows 2008/2003/2000 server, Apache,
Exchange
Server 2010.
IDE & Version Control Source depot, Team Foundation Server, Clear Case,
Visual Source Safe 6.0.
Protocols SOAP, HTTP, SMTP, TCP/IP, FTP
Others Perseus.net, SSIS, SSRS, Crystal Reports, Logidex, Core-
ID, UML,
Rational Rose, Visio, Info Path, SOAP toolkit 3.0, Infragistics
8.x
Education
MS in Electrical and Computer engineering 2003-2006
Temple University, Philadelphia GPA 3.78/4.00
Professional Experience
Microsoft, Redmond
July 2009 - Current
Exchange Server
SDET
Microsoft Exchange Server is a messaging and collaborative software product
developed by Microsoft. It is part of the Microsoft Servers line of server
products and is widely used by enterprises using Microsoft infrastructure
solutions. Exchange's major features consist of electronic mail,
calendaring, contacts and tasks; support for mobile and web-based access to
information; and support for data storage.
Responsibilities
. Analyze designs and develops overall test plans.
. Develop and execute test cases to perform unit, integration and
system tests.
. Develop repeatable testing procedures and processes.
. Develop Management packs and automate test cases that test them.
. Analyze test runs to create and triage bugs.
. Develop and execute test cases to perform unit, integration and
system tests.
Environment
C#, Power shell, SCOM, .net 3.5, Visual Studio 2010/2008, Perseus.net,
Source Depot, Exchange Server 2010, Mapi.net, ADO.NET, Windows Server 2010.
AEGON Cedar rapids, IA
Apr 2009 - July 2009
Application Engineer
AEGON is one of the world's leading insurance companies ranked by market
capitalization and assets. AEGON's businesses focus on life insurance and
pensions, savings and investment products. The group is also active in
accident and supplemental health insurance and general insurance, and has
limited banking activities. Cash Match Project involves development of an
interface to help business user's gain in depth knowledge of Projected and
actual cash flows for a given portfolio.
Responsibilities
. Design, develop and test the Interface that enables data editing.
. Design, develop and test the Interface used to view reports
. Design, develop and test report using SSRS.
. Design, develop and test web services developed using WCF.
. Involved in design, development and normalization of database
using DB Pro.
. Develop and execute test cases to perform unit, integration and
system tests.
. Maintain different version's of Source code using Team Foundation
Server.
. Involved in creation of technical design and Requirements
documentation.
Environment
WCF(C#), WPF(C#), SSRS, DB Pro, LINQ-SQL, .NET 3.5, Team Foundation
Server, VSTS, IIS 6.0, Visio, MS-SQL 2005, T-SQL, Logidex, Core ID.
AEGON Cedar rapids, IA
Jan 2009 - Apr 2009
Application Engineer
The intention of JDE Translator Project is to transform Trans America US
ledger data to TA Canada's JD Edwards format.
Responsibilities
. Involved in development of Requirements and Technical design
documentation.
. Design, develop and test the User interface that is used to edit
transformation tables.
. Design, develop and test the Interface that is used to launch
transformation process.
. Design, develop and test SQL server Jobs that are used to launch
transformation process.
. Design, develop and test SSIS packages that are used to extract
and transform data.
. Design, develop and test SQL database using DB Pro to store
Transformation and configuration
tables.
. Design, develop and test that Reports that gives a summary of ETL
processes.
. Design, develop and test FTP process that FTP's the resultant
file to destination.
. Develop and execute test cases to perform unit, integration and
system tests.
Environment
C#, SSIS, ADO.NET(2.0), Team Foundation Server, VSTS, DB Pro, Visio, MS-
SQL 2005, Oracle 11i, T-SQL, Logidex.
AEGON Cedar rapids, IA
Sept 2008-Feb 2009
Application Engineer
Windows job scheduler is used to schedule server jobs to be launched at
scheduled intervals. Data format transformation Project involved conversion
of Flat files to XML and vice- versa.
Responsibilities
. Involved in development of Requirements and Technical design
documentation.
. Design, develop and test User interface to Provide ability to
schedule new jobs.
. Design, develop and test User Interface to edit existing scheduled
Jobs.
. Design, develop and test Web services using WCF technology.
. Design, develop and test User interface to view Job launch
failures.
. Design, develop and test SQL database to store Job schedule and
audit tables.
. Design, develop and test Logic to transform flat files to XML
format and vice - versa.
. Develop and execute test cases to perform unit, integration and
system tests.
Environment
C#, WCF(C#), ADO.NET(3.5), Entity framework, Team Foundation Server, VSTS,
Visio, MS-SQL 2005, T-SQL, Logidex.
AEGON Cedar rapids, IA
Aug2007-Sept 2008
Application Engineer
External data service project aims at developing a data service to retrieve
and cache the data from all the external data sources used by AEGON.
Security framework project involves design and development of a framework
that helps authenticate and authorize users for all the application under
investment department.
Responsibilities
. Involved in three simultaneous projects.
. Design and develop database to cache data from external data
sources.
. Design and develop data service for users to help cache and
retrieve external data.
. Develop and test Web service and windows service.
. Design, develop and normalize database using DB Pro.
. Develop stored procedures.
. Effective Version Control using Team Foundation Server.
. Create technical design documentation.
. Develop user based authentication model to enable changing the
database using front end.
. Design solution to help applications to retrieve user identity.
. Document requirements, use cases and technical design.
. Develop a web service to be consumed by windows application to furnish
user information.
. Develop and execute test cases to perform unit, integration and
system tests.
Environment
Web services(C#), Windows services(C#), DB Pro, ADO.NET, VSTO, XML, XSD,
SOAP, Team Foundation Server, VSTS, IIS 6.0, Visio, MS-SQL 2005, T-SQL,
Logidex, Core ID.
AG Edwards St Louis, MO
Jan2007-Aug2007
Application Engineer
AG Edwards is a as a full-service securities broker-dealer in the United
States and Europe. Fee Base Billing application provides a billing system
for Pathways and PFA Mutual Fund lines of business. This project involves
design and development of a billing module which helps automate billing of
fee based accounts.
Responsibilities
. Design and develop solution to decrease load on the current
database.
. Design, develop and normalize database in oracle.
. Design, develop and test the SOA web services.
. Modify existing windows applications to call the web service.
. Implement Version Control using Clear Case
. Create batch jobs for data upload.
. Create technical design documentation.
. Develop user based authentication model to implement role based
authorization.
. Responsible for different Software Development Life Cycle (SDLC)
processes included Analysis, Preparing Business proposal and
presentation, Design, Resource allocation, Technology Evaluation,
System Architecture, Data Modeling, Programming, and Documentation.
. Develop and execute test cases to perform unit, integration and
system tests.
Environment
C#(Win forms), Web services, ADO.NET, XML, SOAP, Clear Case, IIS 6.0,
Visio, Oracle10g, PL-SQL.
GE Capital (CEF), Danbury, CT
Sept2006 - Dec2006
Systems Analyst
GE Capital CEF is a Commercial Equipment Financing company. Transweb is an
application that helps the department of transportation finance to help
selection of documentation that needs to be filed with a deal. This also
involves design, testing and support of an auditing tool that helps auditor
audit a deal to track if a credit analyst followed all the specified
guidelines in approving a Loan request.
Responsibilities
. Design and develop Finance applications using .Net framework.
. Use MS Visio to draw UML diagrams
. Develop web applications using ASP.NET.
. Develop a back end using SQL Server 2000.
. Develop the Business layer using VB.NET and hosted it using COM.
. Use Query Express to construct and test complex query based
objects.
. Create Tables, Triggers and stored procedures.
. Effective Version Control using Microsoft Visual Source Safe
. Involve in database backups and batch job scheduling.
. Develop user based authentication model for to enable changing the
database using front end.
. Perform automated testing as well as manual testing on .net
projects.
. Responsible for different Software Development Life Cycle (SDLC)
processes.
. Maintain existing applications built in earlier technologies like VB6
and ASP.
. Develop and execute test cases to perform unit, integration and
system tests.
Environment
VB.NET, ASP.NET 1.1, COM, Web services, ASP, VB Script, ADO, ADO.NET, Java
Script, XML, HTML, VSS, IIS 6.0, Visio, MS SQL Server 2000, Oracle 9i, T-
SQL.
Temple University Philadelphia, PA May2005
- Sep2006
Software Developer
Overview:
A website was designed and developed as a part of ongoing research to help
people quit smoking; the website has a SQL back end which stores the tests,
smoking log and conversation between the counselor and the user. The user
enters the website to enter the personal details and takes a test. Based on
the test counselor decides his counseling strategy. The Counselor is
furnished with data about the number of cigarettes smoked by the user on
given day, personal details and test results. This website can be
customized by the user and has a C# front end. Java Script was used to do
Client Side Programming.
Responsibilities
. Attend project meetings.
. Gather requirements from one on one meeting with psychiatrist.
. Translate the Gather requirements to develop Technical Specifications.
. Develop evaluation strategies to evaluate the developed project.
. Research techniques used in securing the patients data.
. Design and develop SQL database to store users' data.
. Design and develop a strategy for interviewing the user.
. Design and develop User interface in C# based on requirements of a
Psychiatrist.
. Design and develop an application to facilitate communication between
user and Psychiatrist.
. Design and develop interface which facilitates the psychiatrist to
develop a comprehensive insight of the patient case.
. Test and debug the developed system.
. Develop a Role base security to secure patients data.
. Document the data collected by interviewing the psychiatrist.
. Develop a detail documentation of proceedings, decisions and planning.
. Create weekly reports and presentations of the work done.
Environment: VB.Net, Java Script, ASP.NET, ADO.NET, Visual Studio. NET,
Web Forms, MS SQL Server 2005, T- SQL, XML, XSLT, IIS 5.0, Windows 2003
server, VSS.
Contact this candidate