Sql Server Project .Net Software Engineer Application
Resume:
Sindhu Jampala
*********@*****.***
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