Post Job Free

Resume

Sign in

Sql Server Project .Net Software Engineer Application

Location:
Berlin, CT, 06037
Posted:
March 11, 2014

Contact this candidate

Resume:

Sindhu Jampala

acc2ve@r.postjobfree.com

512-***-****

PROFESSIONAL SUMMARY

. 8 years of IT industry experience that includes all phases of the SDLC

(requirement analysis, design, coding, testing, implementation, and

production support of client/server & web systems).

. Experienced in both Waterfall and Agile development methodologies.

. Strong background developing intra/internet applications using ASP.

Net, C#, VB.Net, JavaScript, JQuery, WCF, WF 3.5, ADO.NET, LINQ, SQL

Server 2000/2005/2008.

. Worked on .NET Security features such as Authentication &

Authorization, Forms-based Authentication, Authorizing Users, Roles

and User Account.

. Substantial knowledge in XML based web services using .NET Framework.

. Experienced with ASP.NET MVC framework.

. Experienced in designing and implementing workflows with Windows

Workflow Foundation.

. Efficient in using Database Connectivity API's in Client Server and

Web Applications.

. Experience in Developing and Consuming XML Web Services using C# and

VB.NET.

. Experience in dealing with Private, Shared assemblies configuring them

with strong names, deploying them in GAC.

. Strong knowledge of Modern software development models and theories,

such as the object oriented programming (OOP) model, Event-Driven

Programming.

. Excellent Database design, analysis, development skills using SQL

Server 2000 and SQL Server 2005/2008.

. Hands-on experience with database including T-SQL, PL/SQL and SQL

Server involving Stored Procedures, triggers, cursors and indexes.

. Knowledge of custom error pages and exception handling

. Good experience in database design and development in writing

SQL Queries, Stored Procedures, Cursors and Triggers

. Hands-on experience on SQL Server Integration Services (SSIS)

. Solid experiences in complete Software analysis, design development

cycle that include requirement analysis with Use Cases, Sequence

Diagrams, applying UML design Patterns.

. Proficient in problem solving, self-motivated, driven professional,

able to work with minimal supervision, and able to exercise good

judgment to keep critical systems operational.

. Involved in Unit testing, System testing and Integration testing of

system interfaces

. Exceptional ability to learn new concepts, technologies, and skills.

TECHNICAL SKILLS (Trained / Project Acquired Skills)

Languages VB.NET, C#.NET, C, C++

Frameworks .NET Framework 3.0/3.5/4.0, MVC

.NET Technologies ASP.NET 2.0/3.0/3.5, ADO.NET, WCF, WF, LINQ,

WinForms

Web Servers: IIS 4.0/5.0/5.1/6.0

Development Visual Studio 2005/2008/2010, Telerik UI controls,

Technologies JavaScript, JQuery, CSS, HTML, DHTML, web

services, XML, AJAX, MS FrontPage,

Version Control Tools Microsoft Visual SourceSafe 2005/6.0, Team

Foundation Server, CA SCM

Operating Systems Windows 98/NT/2000/2003/XP/Vista/7, UNIX, DOS

Databases SQL Server 2000/2005/2008, Oracle (TOAD), MS

Access

ETL Tools SQL Server Integration Services, IBM data stage

8.5

Other Tools MS Power Point, MS Visio, Excel, MSBuild, NUnit

Experience:

Client: Hewlett-Packard (HP)

Location: Houston, TX

Role: Sr. Software Engineer

Duration: October 2013 - Present

Project: Sudden Impact/GR8 Webster

This application allows user to track and manage customer problems. And as

a means of supplying the information, to determine if there is an issue to

be worked.is used to identify the product issues and log the issues before

and after shipping. Allows user to create and describe a known issue, as

well as collect and communicate information relating to the root cause and

solution for the issue.

There are five main modules in this application. They are Observation,

Elevation, Product Issues, KM, and Admin. Observation is used in pre-

production and all other modules will be used in post-production.

Responsibilities:

. Involved in the Analysis, design and architecture of the overall

application. Involved in creating user controls in c# 4.0

. Involved in coordinating with off shore team with development,

deployment and code Review.

. Application has been architecture on Model-View-Controller (MVC) model

with complete

Service Oriented Architecture (SOA).

. Involved in creating and consuming WCF services.

. Implemented Model first Entity Framework.

. Involved in developing the requirement with C#, ASP.NET in .Net

Technologies, unit testing.

. Responsible for identifying the repetitive problems in application and

come up with the solution to fix them.

. Following Iterative Agile Methodology for software development.

. Developed web services to read from various Data Sources Oracle and

Sybase.

. Worked with configuration application block, Data Access application

block and Exception handling application block.

. Involved in design and development of user and custom controls for

application using C# and ASP.NET

. Developed XSLT for data transformation for reports and data grid and

XML Schemas.

. Developed Object Model and Data Access Model based on Prototype design

pattern using C# and ADO .NET.

. Designed and implemented the Core components for the application,

which included a data access layer and an error logging component.

. Involved in preparing requirement specifications, design specification

and writing the test case documents for the QA team.

. Effectively used JQuery a concise JavaScript Library for traversing

HTML document, event handling.

. Actively participated in testing of the application. Write test cases,

testing scripts. Executed operational qualifications and Installation

qualifications.

. Written Stored Procedures, Views, Triggers and Database connectivity

using SQL Server 2008.

. Implemented NUnit Testing, Integration Testing and Regression Testing.

. Involved in configuring web.config file for ASP.Net web forms and the

entire Web

Application.

Environment: .NET Framework 4.0, C#, MVC 4.0, Visual studio 2012, ASP.NET,

WCF, Entity Framework, Team Foundation Server, IIS (8.0),SQL Server 2008,

LINQ, jQuery, java Script

Client: WELLS FARGO

Location: San Antonio, TX

Role: Sr. Application Developer

Duration: Feb 2011 - September 2013

Project: IAM Workflow Applications

The objective of this project is to provide enhancements and support for

IAM (Integrated Application Menu). IAM is a large, enterprise web

application that provides a framework to create customized workflows &

applications that handle loan modification functionality including Loss

Mitigation Workflow, NPV, Short Sale Decision Tool (SSDT), Score, Mail

Workflow, etc.

It also provides integration with external systems such as CPI/MSP,

Genesys, Rightfax, Data Marts and IVR to perform various functions of loan

modification.

Developed NPV 512 tool to include automation for client 512 for new or

prior NPV evaluations and provide historical data for reporting.

Responsibilities:

. Interacted directly with the product team to understand the business

of the project.

. Involved in Analysis, Design, Coding, Testing and maintenance phase

of the project life cycle which includes Rollout and Support of

application migration for every distribution centre.

. Understanding the functionality, Identifying & troubleshooting the

code defects and to fix them

. Part of a large, globally distributed team utilizing the Agile

development methodology.

. Primary role was enhancing and supporting multiple, existing

applications with VB.NET 3.0/3.5, web services, ADO.NET, SQL Server.

. Developed two new applications with C#, ASP.NET, WCF, JQuery, CSS,

HTML, MVC, ADO.NET, LINQ, and SQL Server. This included

functionality for pulling information from MSP and IAM workflows.

. Designed and implemented new features based on the client

requirements

. To create SSIS packages for data movement and database maintenance.

. To update existing data model for the enhancements.

. Used ADO.NET extensively for data retrieving, querying, storage and

manipulation.

. Extensively involved in integration of developed modules.

. Monitored and managed production support issues ensuring efficient

and timely resolution.

. Worked closely with testing team for issue resolution.

Environment: VB.NET, C#.Net, .NET Framework 4.0/3.5/3.0, ADO.NET, SQL

Server 2008, SSIS, JavaScript, Ajax, CA SCM

Client: Pfizer.

Location: Kalamazoo, Michigan

Role: Sr. Developer

Duration: OCT 2009- JUN 2011

Project: GeneSys

GeneSys is an enterprise application in the animal science domain used for

maintaining the genetic and non-genetic data for animal sample testing. It

provides scalable Order Management for the customers (who often have

competing feature requests) located in 3 different countries.

The project involves design of GeneSys database, data migration and

development of SQL stored procedures, ETL packages and SSRS Reports for all

the existing interfaces/reports. This is an end-to-end application

development project involving requirement gathering, designing, development

and unit testing, integration testing, user acceptance testing and warranty

support for the software applications.

Responsibilities:

. Analyzed and designed the flow of the application.

. Involved in requirements gathering and functional specification

phases.

. Built the user interface that separated application logic from

presentation code.

. Performed UI design and coding. Created web pages and developed

user interface using ASP.NET with VB.NET as code behind. Used JQuery

and also JavaScript for client side validations.

. Designed and implemented workflows (WF) for the business process.

. Implemented AJAX extension controls.

. Developed web services for various interaction modules.

. Used ADO.NET to communicate with the SQL Server database.

. Used Data Sets, Data Readers and Data Adapters to extract data from

the backend.

. Created new tables, wrote stored procedures in T-SQL for application

developers and some user defined functions. Created T-SQL scripts

for tuning and scheduling.

. Wrote and integrated stored procedures to generate the reports, and

created triggers to enforce data and referential integrity using T-

SQL.

. Used VSS for source control system.

. Involved in logical and physical database design including data

modeling.

. Performed system testing.

Environment: NET Framework 3.5, VB.NET, Windows Workflow Foundation 3.5

(WF), ASP.NET, Ajax, CSS, JavaScript, LINQ, JQuery, IIS, Telerik UI, SSRS,

Data Stage 8.0, VSS, Waterfall, SQL Server 2005.

Client: RaboBank (Australia client)

Location: India

Role: Developer

Duration: June 2008 - OCT 2009

Project: Customer Management Application

This was a large development project for a new enterprise application to

manage and track customer information.

Responsibilities:

. Responsible for requirements analysis, design, development, testing,

and warranty production support.

. Analyzed the requirements and to provided technical solutions.

. One of the senior members contributing to the Proof of Concepts for

the technical solutions provided.

. Designed the data model based on the client business requirements.

. Designed and implemented new features based on the client

requirements.

. Designed and developed Workflow (WWF) system used to track and control

the activities within the business processes.

. Built the user interface that separated application logic from

presentation code.

. Created web pages and developed user interface using ASP.NET and

C#.NET. Implemented front end validations using JavaScript.

. Developed Web services for various interaction modules and used

ADO.NET to communicate with the SQL Server database.

. Created new tables, wrote stored procedures in T-SQL for application

developers and some user defined functions.

. Used VSS for version control

Environment: C#.NET, .NET Framework 3.5, WCF, ASP.NET, MVC, JavaScript,

CSS, Windows Workflow Foundation 3.5 (WF), Visual SourceSafe, Waterfall,

Agile, SQL Server 2008.

Client : Pfizer

Role: Developer

Duration: Jan' 06 to June 2008

Project: KARMA (Key Account Relation Management Application )

Enhanced the Key Account Relation Management Application (KARMA)

according to the realignment of existing business structures

Roles and Responsibilities:

. Analyzed application enhancement requirements.

. Enhanced the existing application to refit the realigned business

structure.

. Enhanced the UI design and coding.

. Involved in writing procedures, functions, triggers, and packages for

new requirements.

. Created Application Flow diagrams for the modules and UML data models.

. Updated the existing data model based on the client business

requirements.

. Integration of all these developed DB components with .NET components.

. Performed system testing of the application for database performance

analysis.

. Created new tables and modified/tested existing stored procedures in T-

SQL.

. Performed support of the developed database and application in client

machine.

. Performed impact analysis for the changes made.

Environment: C#.Net, .Net Framework 3.0, Visual Studio.NET 2005, Winforms,

Windows Services, SQL Server 2005.

Education

. Bachelor of Technology in Computer Science, INDIA.



Contact this candidate