.Net Sql Server
Resume:
SHRAVAN
abg1bd@r.postjobfree.com
PROFESSIONAL SUMMARY:
7+ years of experience, as a software developer, in Functional Specifications, Analysis, Design,
Modeling, Development, Configuration, Management and implementation of various intranet,
client-server and web enabled applications.
Good experience in full life-cycle development using Object Oriented Programming concepts.
Expertise in developing applications using .NET 4.0/3.5/3.0/2.0/1.1, C#.Net, VB.Net, ASP.Net,
VB6,ADO.Net, XML, HTML, AJAX, JavaScript, XHTML, DHTML & CSS.
Experience working withdatabases such as SQL Server 2000/2005/2008/2012, Oracle 10g, and
11g and MS Access 97/2000/2003.
Experience in working with Java Script, JQuery and Bootstrap 2.0/3.0.
Extensive experience in ASP.Net, C#, VB.Net, ADO.Net, Web Services, LINQ, AJAX,
Windows Services, WCF Services, OOPS, Classic ASP, XML, XSLT, HTML, Text Editor,
MS IIS 5.0/6.0/7.0, DHTML,VBScript, VSS, JavaScript, SQL Server 2000/2005/2008/2012,
Visual Studio 2003/2005/2008/2010/2012.
Experience in writing stored procedures, user defined functions, views, query writing.
Expertise in working with Crystal Reports, SSRS and SSIS
Ability to work in all stages of System Development Life Cycle.
Experience in database tuning using SQL Server Profiler and SQL Server Tuning Advisor.
Expertize in working with source control TFS and VSS.
Experience in creating XML using Stored Procedure and User Defined Function.
Hands on experience with SQL Server and T-SQL in constructing triggers, tables, user functions,
views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
Expertise in implementing Object Oriented Programming (OOP) Concepts including Inheritance,
Abstraction and Polymorphism.
Strong programming and debugging skills in C and C++.
Proficient troubleshooting skills, committed to achievement, maintenance of quality, excellent
communication and interpersonal skills and a very good team player.
Good experience in end-to-end design, documenting high level specs, development and unit
testing.
Architected and implemented the SQL Server databases and SQL Agent jobs
Architected and coded the REST API. The first version of the API was XML via RESTful WCF.
The subsequent versions of the API were JSON via Web API REST.
TECHNICAL SKILLS:
Languages C, C++, VB6, C#. Net, VB.Net, ADO.NET, PL/SQL, Core Java, and SQL.
.NET Technologies .NET Framework 2.0, 3.0, 4.0& 4.5, ASP.NET1.1/2.0/3.0, C#.NET, VB.Net,
ADO.NET, Win Forms, Web Services, LINQ, WCF,Azure
Web Technologies ASP, HTML, Java Script, JQuery, XHTML, DHTML, CSS, XML, XSL, XSLT
and Bootstrap.
Database SQL Server 2012/2008/2005/2000, Oracle 10g/11g, My SQL
Protocols SOAP, FTP, TCP/IP, HTTP
Application/Web MS IIS 7.0/6.0/5.0
Servers
Development Tools MS Visual Studio.NET 2005/2008/2010/2012/2013.
Operating Systems Windows 8/7/Vista/XP
PROFESSIONAL EXPERIENCE
PennDOT, Harrisburg, PA Oct 2012 – Till
Date
Role: Sr. .Net Developer
Project Name: Cultural Resource Geographical Information System
The CRGIS web application provides analytical, mapping, and reporting tools for users to locate cultural
resources within a planned project area. Within the CRGIS web application, the AskReGIS tool provides
sophisticated querying functionality. The user can search on various criteria, including where the
resource is located and the resource’s time period. The user also is able to query on a number of other
criteria that vary by the resource type being queried.
Responsibilities:
Involved in requirement analysis, designing and development.
Major role in the development of the web application using .NET framework 4.0, ASP.NET,
C#, Java script, JQuery, Bootstrap, ADO.NET and AJAX.
Primarily assigned for developing Middle Tier.
Used Ajax, CSS, JavaScript and Bootstrap for the front end web development.
Used Agile methodology to implement the application.
Involved in developing Web Service and WCF using SOAP/HTTP to communicate with legacy
systems and also deployed web services as per business requirements.
Designed, developed Data contracts, Service contracts & Operation contracts for WCF Service.
Extensively used ASP.NET, C#.NET Validation Controls and JavaScript, JQuery for client
side validations in the Web Pages.
Involved in implementing the logic using C# and oops concept.
Extensively used Datagrids to display data and other information on the web pages.
The task included writing the C# classes, developing user controls, writing JavaScript
functions.
Developed application using N-Tier architecture.
Used Singleton Design Pattern in the application.
Documented the design and code documents.
Involved in testing and fixing the issues occurred in the testing process.
Developed reports using SSRS.
Created Tables, StoredProcedures, Triggers and Views in SQL Server.
Involved in Code reviews. Peer Reviews for developing quality code.
Performed functionaltesting on various developed modules.
Used TFS for the source & document version control.
Personally designed the UI and app features for the iPhone app and the Windows Phone app
Creating Web pages using advanced level of JavaScript, JQeuery and CSS.
The application was mainly developed in MVC5 pattern using Entity Framework for the Data
Access Layer and UI with JQuery/Bootstrap for the front end.
Worked on Code First approach for the MVC and Entity Framework for designing the models.
Used Generics extensively in C# and ASP.NET Menu Controls and Tab controls.
Created and Modified Stored Procedures in SQL Server 2012.
Experience in creating Stored Procedures, Triggers, and Views using T-SQL.
Identifying UI and data elements using Functional specification and creating technical
documents.
Fixed number of defects during implementation and debugged the application within the
deadlines.
Involved in SDLC of application developed using AGILE methodology
Environment: .Net Framework 4.0, Visual Studio 2012, SQL Server 2008, SQL Server Management
Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF) Studio,
Ajax.Net, C#.Net, VB.Net, VB6, Asp.Net, HTML, JavaScript, JQuery, Bootstrap, CSS, ADO.NET, Web
servies, TFS, SSRS, WCF, IIS 6.0.
American Internal Group, Jersy City, NJ July 2010 - Sep
2012
Role: Sr. .Net Developer
Project Name: AIQuic
AIQuic Application for comprehensive administration of individual life, health and annuity products. The
Web-enabled system features a frontend interface, which enables Intranet access to policy information,
forms and other online resources, and lets users request policy changes. The back-end administration
system maximizes user efficiency and provides all the functions and features needed to process insurance
products.
Responsibilities:
Worked with n-Tier Architecture involving Services Layer, Data Access Layer, and Business Layer
Creating the UI pages using ASP.NET, VB.NET, HTML, Java Script, and JQuery
Extensively worked on User Interface pages (aspx) using C#, CSS, HTML, AJAX, Java Script and to
implement complex Business Rules and Validation of front end forms
Developed Business Logic layer by implementing Object Oriented Programming Language (OOPs)
features like Inheritance, Polymorphism, Abstraction and Encapsulation in C#
Involved in working with Server side State Management Techniques like Session state to maintain state
between ASP.NET pages
Implementing business logic’s in server side, and integrating Data Access Layer (DAL) with Business
Logic Layer (BLL)
Responsible for code merging using Microsoft Team Foundation Server (TFS) and for other source
code maintenance needs
Designing the WCF Service based on the requirement and created separate WCF services project which
is integrated with BLL.
Consumed the WCF services using JQuery Ajax calls to enable effective communication
Extensively used Visual Studio 2010 development tool for building Web Application.
Analyzed business processes to identify challenges and created solutions through the use of database
and communication software across the entire company
Manage database security, Design, develop and implement automated data backup.
Assisted in developing database objects like Tables, Views, Stored procedures and updating the
databases
Analyzed test results, including user interface data presentation, output documents, and database field
values, for accuracy and consistency
Assisted in preparing presentations and scheduling meetings
Prepared unit test cases and performed N-UnitTesting prior to system implementation
Created reports using Crystal Reports.
Based on the support tickets, fixed bugs on priority basis
Environment:Net 3.5, ASP.Net, C#.Net, ADO.Net, AJAX, HTML, IIS 6.0, MS Visual Studio 2010/2008,
C#.Net, Windows Application, Oracle 11g and Crystal Reports.
Bank of America, Charlotte, NC Sep 2009 – June
2010
Role: Programmer Analyst
Bank of America is one of the largest banks in the United States providing Financial Services throughout
the world. The project I worked on at this company is called the Retail Fulfillment Incentive
Performance Dashboard.This application’s primary purpose is to provide a comprehensive look at
individuals incentives achieved. It also delivered a detailed description of the performance of each
individual per loan per Quality, Productivity and Customer Satisfaction. Managers are incented based on
the performance of the individuals working under them, so, the managers had a portal to monitor their
Team Members performance. Individuals also use this application to dispute any discrepancies found in
their loan level details, incentive payouts, metric calculations and tier levels achieved. The application
also provided detailed reports as to the information described above too. All in all, this application dealt
with a Loan’s origination to closing, these following aspects: Individuals work on the loan, their
performance in the work that was done, their incentive calculations depending on their performance;
Manager’s monitoring their Team Member’s performance, handling discrepancies in the incentive and
payout calculations and finally their payouts for every month.
Responsibilities:
Designed, developed and supported the first successful Retail Fulfillment Incentive
Performance Dashboard ever at Wells Fargo.
Being the only UI and .Net developer on the Team, the entire application was developed all by
me along with managing the database work during database developer transitions.
Key player in requirements gathering and analysis, data gathering and analysis and project
requirements for this application which is developed using agile methodology.
Created functional prototypes, design templates and mockups for the entire application.
Played a major role in coming up with the business requirements for the project, the project
plan and workflow.
Extensively used CSS and Java Script to create visually appealing User Interfaces.
Developed the procedural code using ASP.NET, VB.NET, HTML, Ajax and JavaScript using
Visual Studio.
Extensively worked on most of the data and validation controls in Visual Studio and also
creating a variety of Dynamic Controls in the application supported by dynamic style sheets
since there were quite some pages which were database driven.
Members/employees where they can assist monitor and support their individual children.
Developed and implemented custom Tracking and Error Logging mechanisms.
Developed and implemented a custom calendar control to add, update, delete and edit
recurring and non-recurring events.
Assisted in developing Tables, Triggers, Views, stored procedures and updating the SQL
Server database and Optimized SQL Server Stored Procedures using joins&indexes.
Supported the database for daily, weekly and scheduled jobs along with bug fixing and
production issues.
Created SQL Server Integrating Services (SSIS) Reusable packages to extract data from Multi
Formatted Flat files, XL, XML files into DB2 Systems.
Assisted in the design and development of reports in SQL Server using SQL Server Reporting
Services (SSRS).
Designed, processed and displayed reports in the website using the Report Viewer web server
control.
Developed the deploy cycle, responsible for weekly deploys to development, staging and
production environments, developed testing plans and also performed an active role as a tester
for the application.
Performed and resolved cross-browser issues, Unit Testing and Documentation along with N-
unit testing.
Environment: .Net 3.0, ASP.Net, C#.Net, VB.NET, ADO.Net, AJAX, HTML, JavaScript, CSS, MS
Visual Studio 2008, SQL Server 2008 R2, SQL Server Integrating Services (SSIS), SQL Server Reporting
Services (SSRS), T-SQL, PL/SQL.
Constellation Energy, Baltimore, MD Oct 08 – July
09
Role: .Net Developer
Description: Competitive energy markets help businesses, consumers and governments lower costs,
reduce usage and become more environmentally sustainable. Learn more about competitive markets, the
benefits of energy choice.
Responsibilities:
Understanding and analyzing the client’s requirement and involved in GUI designing of the
application
Created custom data component using ADO.NET to perform database operations
Created more than 15 normalized data tables, 150 stored procedures in oracle database.
Involved in the design and development of WinForms using C#
Created custom security component using C#.NET to encrypt and decrypt data
Implemented tracing using Trace listeners and Trace switches and configured the application for
debugging
Created login XML Web Service that handles the primary authentication, availability of licenses
and generation encrypted key, which would be used for many operations
Implemented Custom Error handlers, Custom Exceptions, Custom Error Pages
Written e-Mail scheduler application in ASP.NET to deliver messages to users on specified date
Built customized DataGridcontrol with ascending&descending sort features on each column
Extensively used Crystal Reports to generate billing, activity, historical reports
Used JavaScript for client side validations wherever necessary along with .NET validation
controls
Followed N-Tier Architecture development which involves Presentation Tier, Data Access Tier,
Business Tier, Database Tier
Closely interacted with QA team and updated Rational Clear Quest system after resolving the
bugs
Environment: Visual Studio .NET 2005,.NET Framework 2.0, Windows Server 2003, IIS 6, MSMQ,
UML, Oracle, WinForms, XML, XSL, ASP .NET, C#, VB.NET, Crystal Reports and JavaScript.
CMC Limited, Hyderabad Dec 2007 – Aug
2008
Role: Software Programmer
Description: The primary purpose of e-Computerized Operations for Police Services (eCOPS) is to
maintain information to monitor and enhance the performance of the department, to take a critical look at
the existing systems, processes and procedures of the department so as to identify and remove the
redundancy thus making the department function better.
Responsibilities
Extensively worked with Web Forms using ASP.NET and C#.NET
Involved in the database design and data collection using SQL Server 2005
Used VB.NET Technology for server side programming
Used Data list, Repeater, Data grid, Place Holder controls to show the data in the UI
Involved in Developing Components for Business Layer and Data Layer
Designed and developed Web Forms using ASP.NET, for the user interface
Using the Code behind Class technique and retrieving data using ADO.NET with ASP .NET
Involved in writing Complex queries, stored procedures in T-SQL
Utilized ADO.NET technology extensively for data retrieving, querying, storage and
manipulation
Developed reusable and optimized .NET components using C#
Validated user input on Web Forms using validation controls like Compare Validator, Range
Validator, Regular Expression Validator and Custom Validator. Also Performed Client side
validations for the same.
Writing java script to improve client experience
Performance tuning of stored procedures
Environment: C#, VB.NET, ASP.NET, ADO.NET, UML, SQL Server 2005, SSIS, SSRS, Visual Studio
2005
Contact this candidate