Developer .Net Sql Server Data Service Manager
Resume:
Gullapalli
* *****.****@*****.***
Summary:
. Over 8 Years of overall Software Development life cycle experience as
Team Lead/Sr. Application Developer in WPF, Silverlight, WCF,
client/server,web based applications, windows applications and
service oriented applications.
. Master of Science in Information Technology from IT University of
Copenhagen, Copenhagen, Denmark
. Microsoft Certified technology specialist (MCTS)
. Extensive experience with Silverlight 2.0/3.0/4.0 beta, WPF, .NET
Framework 3.5, ASP.NET, C#, VB.NET, ADO.NET, Lin q, Silverlight
toolkit, Visual Studio.Net, Ninject, NHibernate .
. Worked in AGILE methodology (SCRUM) of software development to produce
optimal productivity.
. Expertise in Web Services using WCF, SOAP, XML, XSLD, WSDL, UDDI and
Service Oriented Architecture.
. Proficient in writing Stored Procedures, Functions, Triggers, and Jobs
with SQL, PL/SQL and MS SQL Server, Oracle, MYSQL database.
. Strong skills in accessing the data using ADO.NET over OLEDB provider
with C#.NET and VB.NET.
. Expert in building Client/Server Applications using Web Services,
SOAP,WSDL,UDDI,WCF and Configuration files
. Worked with Inversion of control with NInject.
. Experience in working with LDAP using C#.NET.
. Good knowledge of relational databases T-SQL and PL/SQL.
. Experience in working with Oracle 8i (using TOAD for generating
queries)
. Good experience in providing guidance and training to the junior
developers in silverlight.
. Extensively used Threading, BackgroundWorker controls in various
applications.
. Experience in writing design specifications, technical specifications,
timelines, schedules, test plans and implementation plans and other
technical documents using Office and MS Project.
SKILLSET
Web Technologies : Silverlight2.0/3.0/4.0 beta,WCF,WPF,ASP.Net,C#.NET,
ADO.Net, AJAX, XML Web Services
Languages: Visual Basic 6/5, C#.NET, VB.Net, .Net Framework
3.5/3.0/2.0, MS SQL, T-SQL, PL/SQL, C, C++
Database: SQL Server 7/2000/2005/2008, Oracle, MS Access, MySQL
Development Tools: Visual Studio.Net 2002/2003/2005/2008, SQL
Management studio
Web Serve: IIS 5.0/6.0/7.0
Directory Services: Active Directory, LDAP
Design Tool: Microsoft Visio, Rational Rose, UML, Expression Blend,
Expression Design
Operating System: Windows Server 2000/2003/2008
Source Control : Visual Source Safe 6.0,MS Team Foundation Server, CVS,
SVN
Reporting Tools: Crystal Reports, SSRS
Other Tools & Technologies :Telerik Controls, infragistics NET
advantage, Ajax Toolkit, COM/DCOM, IIS 4.0/5.0/6.0,win cvs, tortoise
svn, visual svn, BugZilla, ERWIN, MS Project, Mingle, Hudson
Education:
. Master of Science in Information Technology from IT University of
Copenhagen, Denmark.
. Bachelor of Technology in Computer Science and Engineering from
Amaravathi university, India.
. Diploma in Computer Science and Engineering from State Board of
Technical Education and Training,India.
PROJECTS EXECUTED:
Health tracker, IEP (Intelligence Exchange Portal)
Feb 2009 - till date
Client: Mckinsey & Company, Newyork
Senior Developer / Lead Developer
Link: https://solutions.mckinsey.com/catalog/healthTracker.html
Health tracker is a silverlight based web application provide various
services for healthcare industry. Some of the modules include performance
assement, clinical health economics, implementation insights and
Leadership network.
Environment :.Net 3.5, Silverlight 3.0/4.0 beta, MVVM, C#, WCF,
Silverlight toolkit, SVN, Visual SVN, Hudson, Windows server 2008, Visual
studio 2008, WCF default client, N Inject, N Unit, SQL Server 2008, Re
sharper, Style Cop, Expression Blend, Expression Design, PRISM, XAML, VSM,
telrik silverlight controls.
Responsibilities:
. Followed Agile scrum methodology. Participated in sprint backlog
preparation, story preparation, task preparation and sprint
planning. Used mingle as project management tool.
. Used hudson for automated build process. Created hudson scripts for
continuous integration.
. Used visual t4 editor for creating template files for automated
configuration generation.
. Created silverlight custom controls, styles, animations and thems
based on requirements.
. Implemented MVVM (Model View ViewModel) pattern to create
silverlight user controls. Designed and implemented more than 100
silverlight user controls though out the application.
. Designed, implemented and configured WCF service layer.
. Used NInject for dependency injection.
. Designed and implemented Sql 2008 database and stored procedures.
. Used Linq to sql and linq to xml extensively.
. Used threading extensively for various time consuming background
works.
. Designed and implemented various silverlight animations with the
help of expression blend.
. Extensively used VSM (Visual state manager) in creating animations.
. Used log4 net and wcf logging for service side logging.
. Used nunit for unit testing service libraries.
. Configured WCF services for accessing them in silverlight.
. Used office 2007 interops to convert any office document or pdf to
xps to display in a xpf document viewer.
. Guided rest of the team (3) as they are new to silverlight and WCF.
Granularity of Growth
Sept 2008 - Feb 2009
Client: Mckinsey & Company, Newyork
Sr Developer
Link: https://solutions.mckinsey.com/catalog/granularGrowth.html
Granularity of growth is a business intelligence platform generates various
analytics based on granular data from various companies and analyzes the
data and produces various analytics. These analytics can be used by
companies to concentrate on future growth related plans. Granular data can
be collected based on companies external financial data or internal data
collected by business analyists.
Environment :.Net 3.5, Silver light 2.0/3.0, C#, SOAP, WCF, Silverlight
toolkit, Silverlight Spy, SVN, Visual SVN, Tortoise SVN, Visual Guard,
Hudson, Windows server 2008, Visual studio 2008, Silver light SDK for
visual studio, WCF default client, N Inject, N Unit, SQL Server 2008, Re
sharper, Style Cop, Expression Blend, Expression Design, PRISM, XAML, VSM .
Responsibilities:
. Gathering requirements following SDLC, Analysis, Design, functional &
technical specification, Coding, testing and Document preparation.
. Designed and implemented various Silver light 2.0 user controls.
. Interacting with Business analysts and service line to collect data in
required format.
. Used Microsoft patterns and practices PRISM frame work for application
architecture.
. Followed MVVM (Model, view, View-Model ) pattern through out the
application.
. Used Lin q queries for data management
. Participated in installation and setup of Hudson server for automated
build process.
. Involved in documenting the application using visual studio in line
comments and preparing user guides.
. Involved in Unit testing using NUNIT and N inject and System testing.
. Used N Inject for dependency injection.
. Extensively used data binding to bind models in various modes.
. Created silver light custom controls using template binding.
. Extensively used Event aggregator to publish and subscribe events between
various modules.
. Used WCF services to access data from data store.
. Implemented forms based authentication with the help of Visual guard to
secure application.
. Set up Https Communication layer between silver light client and server
to secure the communication channel
. Designed and implemented data management layer using linq, extension
methods and sql 2008.
. Created application wide silver light animations using VSM (Visual State
Manager).
ICS (Integrated Cash Settlement System) integration Manager
Jan2008 - Aug 2008
PPL (Pennsylvania power and light), Allentown, PA
Senior .Net Developer
Description: Data movement between front office systems and ICS must
incorporate a consistent, accurate, timely, cost efficient and controlled
process. Integration is based on defined business objects, transported
between integration points via messages, files or a combination of two.
Data originating from or delivered to the front office systems are
typically transformed into or from the business objects rather than
requiring changes to the front office systems to use business objects.
ICS integration is based on front office systems receiving / sending
files, primarily using flat files, and ICS receiving / sending messages
consisting of business objects.
Roles & Responsibilities:
. Participated in design and implementation of business logic layer,
data access layer and service layer
. Used abstract factory, singleton and facade patterns in design and
implementation.
. Implemented complicated stored procedures based on data access layer
requirements
. Worked with 15000 user Active Directory extensively to implement
role based authentication and authorization for the application.
. Extensively designed and implemented web services for various tasks.
. Worked with Oracle 9i database to access millions of utility
customer records.
. Optimized oracle stored procedures to improve performance.
. Designed and implemented class libraries with multi threaded
environment
. Implemented a .Net webservices to upload millions of customer
records to sql 2005 database from oracle 9i database.
. Designed and implemented Data access layer through web services
. Handled web service exceptions with the help of soapexception
object.
. Designed and implemented UI for integration layer
. Implemented custom wizard for the application
. Participated in unit testing the code with NUNIT
. Prepared design and implementation documents for each task.
Environment: .Net2.0, C#.NET, VB.NET, Win Forms, ADO.NET,WSDL, UDDI,
SOAP, Web services, Visual Studio 2005, SQL Server 2005, XML, VSS, Oracle
9i, Web Methods, LDAP, Active directory .
Licensing system Nov 2006-Dec
2007
iMotions, Copenhagen, Denmark
Senior software developer
Description:
Licensing system is a server application which facilitates on line credit
based licensing system for Emotion tool application. This application will
accept request from emotion tool, updates the database with respective
information and sends email notification to client and marketing
department. Licensing system web application is a client for the licensing
server and will be used by marketing people to issue credits and
application licenses. After receiving email notification from licensing
server respective marketing representative will either issue the credits
through web application or communicate with the client for further details.
This application contains web services in license server implementation and
used active directory for role based authentication and authorization for
web application.
This project contains following modules:
iMLSLicenseIssuanceLayer: This is a web service receives request
from web application and process the request and generates license. This
layer sends mail to all the related parties regarding success or failure.
IMLSUtilityLayer: This layer contains all the commonly used
classes, constants and enumerations used throughout the application.
IMLSDataAccessLayer:This layer contains all the database related
classes and methods.
IMLSApplicationLayer: This is implemented as a web service receives
requests from Emotion tool, updates the database and sends a mail to client
and marketing people.
iMLSApplicationBusinessLogicLayer: This layer contains logic to
verify license and credit xml files.
iMLSWebApplication: This web application is used by marketing
people to issue licenses and credits to the clients.
Role & Responsibilities:
. Involved in Information gathering from marketing department and
business analyst
. Designed and implemented UI controls and forms
. Used Active directory for web application's role based authentication
and authorization.
. Designed & Implemented iMLSLicenseIssuanceLayer webservice
. Developed & Maintained various components for UI, Server side &
database using ASP.NET, SQL Server
. The application code behind was developed in C#.NET.
. Wrote SQL queries, Stored Procedures and Triggers for data
Manipulation and made extensive use of Dataset and Data Reader
classes for the same.
. Extensively used GridView control to generate various reports.
. Different validation controls provided in asp.net are used for input
validations.
. Used TFS for version control.
. Generated .chm files with sand castle from in line documentation
Environment: C#, .NET 2.0, ADO.NET, ASP.net, SQL server 2005, Windows 2003
server, IIS6.0, Java script, Ajax toolkit, TFS, sand castle, Web services,
web forms
Client: iMotions
2004 - 2007
Project Title: Emotion Tool and iMerge (Worked on various versions of the
product)
Role: Senior .NET developer
Description: Emotion tool is a software tool for measuring human emotions
with the help of Eye Tracker hardware. This software responds for various
events thrown by eye tracker hardware and records 26 different values for
each 20th of a second from human eye. By using this data Emotion tool will
measure human emotions. Emotion tool contains various modules named setup,
run analysis, backup and restore, imerge, and database updater.
iMerge was initially delivered as separate tool and later merged in to
emotion tool which is used for mergeing various instances of emotion tool
database data. iMerge takes database backups from emotion tool and merges
studies from various database instances and makes it one large database.
Emotion tool Contains following modules:
Setup: This module is used to setup a study which will be used to collect
respondent data in "run" module. This module contains various win forms and
custom controls.
Run: Main task of this module is to collect data from respondents and store
it in to MS SQL server database. This module uses custom controls and COM
to communicate with the eye tracker hardware. This module deals with huge
amount of data as eye tracker collects 20 different channels of data 60
samples per second.
Analyze: Main task of this module is to analyze data which is collected in
"run" phase of application. This module will pass the data to Engine and
collects the results, place them into Database and generates various
reports based on user input. This module uses CR.NET (crystal reports XI)
to export reports into various formats.
Backup and restore: Data collected from emotion tool is highly expensive so
data need to be maintained very carefully. This module will backs up data
in regular intervals and maintains backup files in the application folder.
If emotion tool data got corrupted due to any reason this backup will be
used to restore data.
Imerge: This module is used to merge various instances of Emotion tool
database data. If study conducted at various geographic locations and
finally merged at a specific location to generate results as a single
study.
DataBaseUpdater: The aim of this module is to update database schema
between various versions and convert data from one database version to
another.
Roles & Responsibilities:
. Designed and implemented GUI components for Setup and analysis modules
with the help of WPF,XAML, and expression blend
. Used WPF and Expression blend in creating UI controls, styles and
resource dictionaries
. Extensively used Win form controls and validations
. Developed Context Menus in C#
. Involved in the design and implementation of
database for various modules in SQL2005
. Data retrieval using ADO.NET dataset, datatable and
data adapter and DataReader.
. Designed, implemented and integrated various dynamically generated
reports using CR.NET
. Used TFS for version control
. Wrote Stored Procedures and SQL queries.
. Used SQL DTS to transport data between various transactional databases
to data ware house
. Worked with multi threading environment to process huge image data
. Extensively used VS2005 in line documentation to generate Compiled
HTML files (.chm)
. Extensively used SMO.NET objects and transactions
. Created windows installer for iMerge application and participated in
generating installer for Emotiontool using install shield.
. Unit tested with VS Team test and achieved 65% of code coverage
Environment: C#, .NET 2.0/3.0, Win forms, NetAdvantage, Expression Blend,
WPF, ADO.NET, SQL server 2005, SQL2005 DTS, Reporting services, Crystal
Reports 11, XML, T-SQL, TFS, CR.NET, SMO.NET, sand castle, custom controls
Project: Auto Spare parts System
Description: Worked on Inventory management and sales of Auto Spare parts
System
Responsibilities:
. Gathering requirements, Analysis, Design, functional & technical
specification, Coding, testing and Document preparation.
. Design and Development of user - Interface screens using ASP and VB.
. Designed and wrote stored procedures, functions and packages using T-SQL
for SQL Server 2000.
. Managed and backup the database using SQL Server 2000 back-end tools and
DTS.
. Design, develop and administer the E-Marketing and E-commerce platform
website.
. Used ASP and VBScript for the front-end presentation and server site
processing.
. Created web pages using ASP, Used VB as code behind.
. Designed and developed different modules using ASP, VB.
. Designed tables, constraints, necessary stored procedures, functions,
triggers and packages using T-SQL for SQL Server 2000
. Used ASP.Net and C# for the front-end presentation and Server Side
Processing.
. Configured Web.Config for application as well as IIS settings.
. Responsible for debugging and maintaining the managed C# libraries.
. Responsible for developing the user management components (using COM) Web
interfaces using ASP.NET.
Environment: ASP.NET, ASP, ADO, ADO.NET, VS.NET CF, CSS, XML, HTML, C#,C++,
Webservices, VBScript, JavaScript, T-SQL, Visual Studio.NET, IIS 6.0, IIS,
SQL Server, 2000, Windows XP/NT
Project Title: Company Profiles
Description:
The project involved in development of software which facilitates the end
users with company profiles like, company background details, volatility
report, annual report, equity share data and balance sheet data reports.
Also a friendly user interface to administrate the data required for
generating the above reports. The reports will be generated dynamically on
the request of the user based on the most recent data. The reports are
useful for the shareholders and purchasers to have an idea of the
fluctuations in the price of shares and company's past growth and financial
status. The administrator will be given database and front end to maintain
the data.
Role:
. Involved in Design and Implementation of ASP pages.
. Server side components design, development, Integration and deployment.
. Designed the database as per the functional and technical
specifications
Work Experience
. Currently working as lead developer Perigonsoft .
. Worked as lead developer at Tekforcecorp Inc, San Ramon, California
from 2007 till 2009
. Worked as a Senior Software Developer/ Team lead in iMotions-Emotion
Technology, Copenhagen, Denmark from December 2003 till December 2007
. Worked as a Software Engineer in Cybertel Software Limited, India for
a period from August 2000 to December 2002 with Experience in
Designing, development, testing and deploying projects in various
domains.
4
Contact this candidate