.Net Developer Sql Server Web Services Power Plant

PranayKumar

.Net Developer

SUMMARY

• Over Eight years of experience in IT industry in developing Client/Server, Web based and Windows based

applications using ASP.Net, VB.Net and C#.Net.

• Excellent experience in designing and developing n tier Web applications using ASP.Net in 1.1/2.0/3.5/4.0/4.5

frameworks and worked with XML, HTML4.0/5.0, CSS, JavaScript, JQuery, Web Services.

• Expertise in Client/Server development architecture and Distributed Computing Architecture and experience in

Visual Studio 2005/2008, and hands-on Visual Studio 2010.

• Expertise in ASP.Net controls like HTML Controls, Server Controls and User Controls using in C #.

• Good experience in publishing and consuming Web services using C# along with XML.

• Experience in working with AJAX, LINQ.

• Understanding Software Development Life Cycle.

• Expertise on ADO.Net components such as Datasets, Data Adapter, Data Reader, Data View, Data Table and

expertise in Web Forms.

• Excellent experience in developing user interfaces using Web forms and Window forms.

• Expertise in HTML4.0/5.0, DHTML, CSS, Jquery, JavaScript and also and validation controls for performing

Form validations.

• Implemented Ajax controls extensively in Web forms.

• Experience working on Crystal Reports.

• Well versed with complete Software Development Life Cycle process.

• Strong experience in back-end programming using SQL, T-SQL, PL/SQL.

• Worked extensively with Views, Stored Procedures, Triggers, User Defined Functions using Microsoft SQL

Server 2000/2005/2008 and Oracle 9i/10g.

• Having extensive knowledge in implementing various design patters like MVC and Waterfall.

• Aptitude for learning new technical skills quickly and highly organized with the ability to manage and meet

deadlines.

• Self- starter and comfortable in fast paced and challenging work environment.

TECHNICAL SKILLS

Languages: C, C#.Net, VB.Net, Java, SQL, And TSQL.

Concepts: Object Oriented Programming, SCRUM, Agile.

Operating Systems: Windows XP, Vista, 7 Windows Server 2003, 2008.

Applications/Platform: ASP.Net 1.1/2.0/3.0/3.5, ADO.Net, LINQ, HTML4.0/5.0, SSIS XHTML, CSS,

JavaScript, Web Services, Win Forms, AJAX.

Webservers: IIS 6.0/5.0/4.0, Tomcat Server.

Desktop Tools: MS Office 2007/2010, Adobe Photoshop.

Databases: SQL Server 2005/2008, Oracle 9i/10g, MS Access 2007, TOAD

Web: HTML, XHTML, XAML, CSS, XML, SQL, SQL*Plus, Java Script, Jquery, JSON, AJAX

Handlers

Centralized Servers: TFS, Ankh SVN, Tortoise SVN.

EDUCATION:

Jawaharlal Nehru Technological University, India (2001-2005)

Bachelor of Technology in Computer Science

PROFESSIONAL EXPERIENCE

Stanley Security Solutions as Microsoft .Net Developer Indianapolis, IN (Nov 13 to Till Date)

Role: .Net Developer

Astea Summary:

This application is used to create service orders by the customers and also to create the work orders to the

Technicians for installation and the repairs requested by the customers and it also used for maintaining the

updates sent by the Technician from the site place.

Responsibilities:

• Involved in interacting with business analysts, other developers and management to develop the

application.

• Involved in full lifecycle of the project from design, development & Testing.

• Extensively Worked on Agile and Scrum methodology.

• Followed and developed the N-Tier architecture for the business, presentation and data access layers.

• Developed web-based applications using ASP.NET MVC

• Extensively worked on ADO.NET Entity Framework for developing core data layers for the distributed

applications.

• Used C#.NET to develop code behind logic, business layers and data layers.

• Designed database and system flow, programmed in ASP.NET.

• Developed the Order Generation and Billing/Invoicing System

• Performed Unit Tests on the libraries developed.

• Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Indexes

using SQL Server 2008.

• Extensively Used TFS (Team Foundation Server) for the source control.

• Created classes and core modules in C# for implementing business layer

• Used LINQ to SQL in the data layer for rapid development of few standalone projects

• Created Web Services (SOAP, WSDL) for communicating with other application and components.

• Involved in code review meetings, peer to peer code reviews and team meetings.

Environment: .NET Framework 4.5, XML,ADO.NET, C#, Web Services, SQL Server 2012, Visual Studio 2012,

Re-sharper, TFS.

GCA, Las Vegas (Global Cash Access (May2013-Nov2013)) as Microsoft .Net Developer.

Cage Cash Application: Cage cash Application is used to provide the services to the users in the Casinos

through the ATM’s, Cheques and the cage that present in the Gaming Industry. This application mainly used to

authenticate the Users or Patrons and the checking the Daily Limits, and charging the Patrons according to the

amount requested and this particular project involved Device Programming and there are mainly used to

authenticate the patrons by swiping their Identification Cards and the Financial Cards and securing the card

information by using different encryption techniques and Hashing. It uses the XView Application for managing the

activities in the business and this particular application is used at all the Casinos in Las Vegas and the most

Casinos in California and the Los Angeles.

Responsibilities:

• Designed and Modified Database tables and used SQL Queries, Views, Stored Procedures and Triggers.

• Responsible for performing the backend database development of stored procedures, triggers, packages,

and functions within an SQL Server 2008 database environment using SQL.

• Developed the independent Windows Communication Foundation (WCF) services and defined Service

Contracts for specific functionality in project search module.

• Extensively Used the Java script functions and the JQuery for the Client Side validations and capturing

the Events on the Client Side.

• Implementations of client side validations using JQuery and ASP.NET MVC Validation implemented at

Controller level.

• Implemented Client Side functionality using JQuery.

• Created DAL(Data Access Layer) to establish database connectivity and data manipulation.

• Performed unit testing on every new version before sending it for User Acceptance Test.

• Responsible for deployment of the Application in production and resolving any post-deployment issues.

• Worked Extensively in Designing the Web Pages using the HTML5.0, CSS and the Style Sheets.

• Worked Extensively with the Device Programming.

• Worked extensively in programming the drivers for the Devices like Eseek and the Ingenico which are

mainly used to authenticate the users by their identification cards and the financial cards.

• Used AJAX for Partial Page Updating, Invisible Data Retrieval, Constant Updating, Smooth Interfaces,

Simplicity and Rich Functionality.

• Developed Application Logic using C#.

• Led development and Site core for GCA global Department extranet.

• Provided custom ez publish and Site core Development.

• Used Enterprise Library in Business Logic layer for extracting the data efficiently from the database.

• Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.

• Responsible for performing the backend database development of stored procedures, triggers, packages,

and functions within an SQL Server 2008 database environment using SQL.

• Used AJAX for Partial Page Updating, Invisible Data Retrieval, Constant Updating, Smooth Interfaces,

Simplicity and Rich Functionality.

• Extensively used Data Grid control in the application for displaying the tabular format

results from the backend.

• Used the Encryption techniques like SHA, SSL, Public and Private Keys and Used the Hashing

Techniques for securing the Password from the attackers.

• Provided security (Authentication and Authorization) for the site, including Role and User Management.

Configured entire site as a secured Web site using SSL and installed digital certificates. Worked on

custom attributes.

• Extensively used WCF Web Services, SOAP, and XSL to expose the reports to facilitate the information

sharing across teams.

• Worked with Off-Shore and On-Shore team by following the Agile and Scrum Methodology.

• Worked with Team Foundation Server as a Centralized Repository.

• Extensively worked on the SOA Architecture.

• Extensively used C# Programming language for creating drivers to the devices that are used for

identification and authenticating the users.

• Worked extensively with the Microsoft Enterprise Library and used the libraries in the Encryption

techniques we used in the application.

• Worked with Agile and Scrum methodology and had good knowledge working with different Design

Patterns.

• Had Hands On Experience in Cassandra and HBase.

• Provided estimates, daily and weekly status reports to the client on progress of the tasks.

• Used MVC 3.0 and MVC 3 RAZOR for coding.

• Environment: : C#, ASP.NET4.0, ADO.NET, SQL Server 2008, Web Services, WSDL, Windows XP,

Visual Studio 2010,HTML5.0, SQL Reporting Services(SSRS), SQL Integration Services(SSIS), CSS,

Security, JavaScript, AJAX, XML, UML, IIS 6.0.

US Bank Minneapolis (Jan2013-May2013) as Microsoft .Net Developer.

Connex: Connex is an internal application used to approve corporate cards to the clients by reviewing the

request and do some negotiations with them and process the request according to the information provided by

them and the application will follow some set Network Security Standards such as Authentication and

Authorization. The flow of the application mainly uses the Windows Presentation Foundation for the navigation

between the pages. This particular application solely creates platform for the US Bank Clients for requesting the

Corporate Credit Cards to their employees working in the organization.

Responsibilities:

• Designed and Modified Database tables and used SQL Queries, Views, Stored Procedures and Triggers.

• Design and Development of Business Layer using .NET Web Services, ADO.NET .

• Developed Application Logic using C#.

• Written Stored Procedures, triggers using SQL in SQL SERVER 2008.

• Worked Intensely on the User Interface.

• Used Xpath, XMLNode to access files and XMLDataDocument to synchronize with DataSets.

• Extensively used GridViews sorting and paging.

• Responsible for performing the backend database development of stored procedures, triggers, packages,

and functions within an SQL Server 2008 database environment using SQL.

• Used MVC design patterns for development.

• Extensively used WCF Web Services, SOAP, and XSL to expose the reports to facilitate the information

sharing across teams.

• Developed the independent Windows Communication Foundation (WCF) services and defined Service

Contracts for specific functionality in project search module.

• Designed and developed WCF services layer where WPF client communicates for server side calls.

• Used AJAX for Partial Page Updating, Invisible Data Retrieval, Constant Updating, Smooth Interfaces,

Simplicity and Rich Functionality.

• Created ADO.Net entity models, custom entity models, mapping the stored procedures, manipulating and

handling events of HTML controls using Jquery.

• Used AJAX pattern to improve page performance.

• Used disconnected Datasets, Type Datasets, Data Reader, and Data Adapter for accessing the data .

• Designed and Used AJAX pattern to improve page performance .

• Extensively used various ADO.Net objects, stored procedures and other database techniques to achieve

database connectivity to the Web portal.

• Uses Windows Presentation Foundation for Navigating between the pages.

• Provided security (Authentication and Authorization) for the site, including Role and User Management.

Configured entire site as a secured Web site using SSL and installed digital certificates. Worked on

custom attributes.

• Worked extensively with the Microsoft Enterprise Library and used the libraries in the Encryption

techniques we used in the application.

• Worked with Agile and Scrum methodology and had good knowledge working with different Design

Patterns.

• Worked with Team Foundation Server as a Centralized Repository.

• Worked with Agile and Scrum methodology and had good knowledge working with different Design

Patterns.

• Used N-tier architecture for Presentation layer, the Business and Data Access Layers using c#.

Environment: : C#, ASP.NET4.0, ADO.NET, SQL Server 2008, Web Services,HTML4.0/5.0, WSDL, Windows

XP, Visual Studio 2010, SQL Reporting Services(SSRS), SQL Integration Services(SSIS), CSS, Security,

JavaScript, AJAX, XML, UML, IIS 6.0.

Wolf Creek Nuclear Power Co-Operation, Burlington, Kansas Jul2012 – Dec12

Microsoft .Net Developer

SKED Scheduling Application: Sked is an internal application used to maintain the working schedules in the

power plant. It is a replacement of current application called EPS which is using to do this functionality. The

security of the access in the application is used to develop according to the roles in the organization (i.e. Admin,

Scheduler, and User Admin).This application is also used to insert and also update the status of the activities in

the Plant.

Responsibilities:

• Gathered the Information from the client and developed the use cases for building the new

application.

• Working with Oracle11g as the backend

• Extensively used Data Grid control in the application for displaying the tabular format results

f rom the backend.

• Writing the packages and the stored procedures for the oracle backend.

• I t is Windows based application.

• Extensively used Oracle Primavera Web Services.

• Performing Web Service calls from Oracle PL/SQL packages.

• Created several views in the Oracle 11g Database.

• Worked with Infragistics controls extensively.

• Worked extensively with the Table relationships and worked with the Table keys.

• Worked with Oracle Stored Procedures and packages in the Oracle Database.

• Extensively worked with Creating Web Services and calling them from the Database.

• Extensively used XML for creating the Web Services.

• Worked on the Front End Design

• Worked with VB.NET programming language for the Application development.

• Worked with UTML_DBMS package for calling the Web services.

• Thoroughly tested various modules of the system and fixed the bugs.

• Worked on Windows forms to develop applications for administrative people.

• Worked on Grid Views to Edit/Display/Modify the cases information.

• Worked extensively with the Third-Party controls called Infragistics Controls.

• Deployment of Application on Test and Production Server.

Environment: Visual Studio.Net 2008, VB.NET3.5, Oracle11g, Oracle Primavera Web Services, XML, HTML

4.0/5.0,Professional Visual Studio .Net2008, Infragistics Controls, Source Safe, SQL Navigator6.5.

Quintiles, Boston, MA Feb 2011 – Jun 2012

Microsoft .NET Developer

Prescription Monitoring Program: Prescription Monitoring Program is a Web-based application developed to

maintain a database of Doctors, Patients and Prescription. It is used to efficiently collect, cleanse and manage

prescription data. Proactively analyze data to spot suspected illegal activity. Manage e-mail, fax or paper

notification user by user. Educate prescribers on the nature and extent of prescription drug diversion and the

agency’s efforts to prevent it. Securely share data with other PMP programs.

Responsibilities:

• Developed information architecture for building the application. Developed ASP.Net pages and used IIS as the

Web server.

• Working with Oracle9i/10g, SQL-Server2005, 2008 Databases.

• Extensively used Data Grid, Data List and Repeater Controls to create various reports.

• Created client side and server side validations using JavaScript and ASP.Net input validations controls.

Maintained the state of session objects, created dynamic menu, used session management. Involved in

preparing the Detailed Design document.

• Used MVC 3.0 and MVC 3 RAZOR for coding.

• Used OOPS concepts.

• Used Entity Framework.

• Used Jquery, JqueryUI.

• Used SharePoint in the project.

• Used Enterprise Library in Business Logic layer for extracting the data efficiently from the database.

• Implemented Mvc3Architecture

• Extensively used data controls in .Net to display the data.

• Implemented LINQ to SQL for database related operations using C#.

• Designed Web pages using HTML, CSS, JavaScript, and Jquery.

• Designed the CSS to enhance the interface of the Web pages. Coded using Java Script and AJAX to design

Web pages.

• Developing User interface design using WPF.

• Working with Service Oriented Architecture, and Model View Controller Architecture.

• Coded stored procedures, functions in the SQL-Server 2008.

• Using WCF for building, configuring, and deploying network distributed services.

• Created master page template. Developed data access layer using VS.Net 2008. Involved in weekly project

status meeting.

• Extensively Worked with JavaScript, and JQuery, JSON.

• Thoroughly tested various modules of the system and fixed the bugs.

• Worked on Windows forms to develop applications for administrative people.

• Programmed Crystal Reports to generate periodic reports with custom options.

Environment: Visual Studio.Net 2010, C# 4.0, ASP.Net 4.0, HTML4.0/5.0, CSS, AJAX, CSS, SVN,SQL Server

2008,Oracle9i/10g,Javascript,JQuery,JSON,AjaxHandlers,WCF,WPF, XML, MVC 3.5,MVC RAZOR,SharePoint,

SOA.

Citi Group, Irving, Texas Apr 2010 - Jan 2011

Microsoft .NET Developer

Home Loan Defaulters Application: This project provides extensive information to the attorneys about the

bankrupted cases assigned to them. If a person takes loan from CITI Bank and is not able to repay the loan

amount then, such a kind of case is known as bankrupted case. Bankrupted cases are normally getting assigned

to the attorneys for checking whether CITI Bank can take any legal action on those customers. If so, they will

update the case information and send the cases back to CITI Bank stating that it can take further legal action on

that case. With this Website attorneys can easily log into the site and check which cases are assigned to them

and can download case information in text format.

Responsibilities:

• Participated in the Business Requirements gathering, and writing Program Specifications.

• Involved in GUI design for the project using Master and Content Pages along with User Controls.

• Used asp.Net Cache Invalidation features in order to provide latest data to the users while navigating through

the site. Provided security (Authentication and Authorization) for the site, including Role and User Management.

• Using WCF for building, configuring, and deploying network distributed services.

• Using WPF for building UI applications.

• Used MVC 3.0 and MVC 3 RAZOR for coding.

• Used OOPS concepts.

• Used Entity Framework.

• Used Jquery, JqueryUI.

• Used Enterprise Library in Business Logic layer for extracting the data efficiently from the database.

• Implemented Mvc3Architecture.

• Configured entire site as a secured Web site using SSL and installed digital certificates. Worked on custom

attributes. Involved in creating UML Diagrams using Microsoft Visio.

• Working with Service Oriented Architecture, and Model View Controller Architecture.

• Extensively Worked with JavaScript, and JQuery.

• Worked on Grid Views to Edit/Display/Modify the cases information.

• Involved in creating and troubleshooting the stored procedures using SQL Server 2000.

• Used most of the ADO.Net classes like Data Sets, Data Tables, Data Views, Relations, Primary Keys, Auto

Increment Columns and Expressions etc.

• Wrote Stored Procedures, Triggers and Transactions using T-SQL in SQL Server for quick processing and easy

maintenance of the database.

• Working with Oracle9i/10g, SQL-Server2005, 2008 Databases.

• Prepared test cases and responsible for delivering the product in specified time.

• Maintained a consistent look-and-feel for the Home Loan Defaulters Application.

Environment: ASP.Net 3.5, VB, SQL SERVER 2005, Oracle9i/10g, ADO.Net, SOAP, Windows XP Professional,

Visual Studio 2008,WCF,WPF, MVC 3.5,MVC RAZOR, Ajax Handlers, JavaScript, JQuery,JSON.

TIAA-CREF, Financial Institution, NC May2009-Mar2010

Microsoft .NET Developer

Insurance Management System: Insurance management system (IMS) is a robust internet and intranet Web

application. This system deals with insurance policy, proposal, premium, endorsement, renewal and receipt. This

system also deals with the insurance claim information according to health damage, accident. System generates

different reports for their operations such as New Policy, Premium, Accident claim and various summary reports.

Claim Management is primarily used by the insurance sector intercompany personnel like Inspectors, Claims

specialist, supervisor, and managers. This Intranet application also features a powerful search engine and also

helps keep track of claims and various corporate activities like report generation, status maintenance etc.

Effective Role Based Authorization is enforced on the application.

Responsibilities:

• Involved in the SDLC phase of requirement analysis, design, and development of the web based intranet

application tool using ASP.NET and C#.

• Graphical User Interface (GUI) was designed using ASP.NET and the business logic was coded in C#.

• Created Stored Procedures and User Defined functions using Transaction SQL and PL/SQL.

• Followed 3-Tier Application Architecture to ensure flexible and reusability of the application.

• Design, customization, and implementation of Microsoft CRM 4.0.

• Coordination in Wireless Devices and Outlook CRM Laptop Client.

• Working with Oracle9i/10g, SQL-Server2005, 2008 Databases.

• Used C#, ASP.Net, Win Forms, SQL Server, Web Services, and a custom single sign-on.

• Wrote the T-SQL Database Triggers, Views, and Indexes.

• Used WPF and WCF to communicate between DAL and other business components.

• Developed & maintained Web Forms with ASP.Net, Silverlight and C#.Net.

• Developed applications leveraging ADO.NET, LINQ to SQL, Entity Framework 4, and the Microsoft Enterprise

Library Data Access Application Block.

• Developed LINQ to Objects and LINQ to XML for collections and XML generation.

• Used AJAX to create better, faster and more user-friendly web applications.

• Followed the Model view controller (MVC) architecture to ensure the flexibility of the application.

• Created ASP.NET validation controls and JavaScript validations to enforce validations.

• Used SQL Server Integration Services (SSIS) for data Integration.

• Used SQL Server Reporting Services (SSRS) to generate reports.

• Designed and developed rich complex user interface (UI) in Silverlight, used XAML heavily for the user

interface.

• For building workflows within the .NET applications Windows Workflow Foundation (WWF) is used

• Developed HL7 interfaces (message parser, message generator) for Eclipsys products. All incoming and

outgoing patient data goes through these interfaces.

• Used LINQ and WCF to communicate between DAL and other business components.

• Developed WCF Web Services that implement the Service-Oriented Architecture (SOA).

• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

Environment: C#, ASP.NET3.5, ADO.NET, SQL Server 2008, Oracle9i/10g, Web Services, WSDL, Windows XP,

Visual Studio 2008, SQL Reporting Services(SSRS), SQL Integration Services(SSIS), CSS, Security, JavaScript,

AJAX, XML, UML, IIS 6.0.

Intranz Info Solutions, India Sep 2006 – May2009

Microsoft .NET Developer

Physician information and Management System: Modules include Doctor Appointments & Patient Scheduling &

Hospital Registration and Patient Management Electronic Medical Records and Referral Management. The sub

modules include Vitals, Allergies, Medical History, Social Profile, Visits, Physical Examination, Diagnosis, Lab

Order and Result. This completes the one touch access place to patient medical information. Referral

Management module includes patient referrals from one consultant to another, lab referrals, expert opinions and

depending upon the schedules and availability a physician can fix appointment for his patient to meet another

consultant or a lab.

Responsibilities:

• Involved in customizing, testing, debugging, application evaluation and implementation. Developed Generic

Data adaptors for Health care application. Browser Compatibility has been handled for business solutions.

Worked on presentation, business and data access layer.

• Responsible for Design and Development of Webforms in ASP.Net using C#. Designed and developed C#

classes, Used extensively data grids in ASP.Net, Web forms. Developed stored procedures. Developed

JavaScript to support AJAX.

• Used extensively user controls and custom controls in ASP.Net, Webforms. Involved in database design and

system design, Used ADO.Net for data access, used Data Adapter, Reader, Dataset Classes. Developed stored

procedures, triggers and functions. Developed a Web service using C#.

• Working with Oracle9i/10g, SQL-Server2005, 2008 Databases.

• User management, maintaining users of different roles and workflow. Created the test cases and performed unit

testing using for these modules. Designed and Developed Web forms for the patient demographic system.

Environment: .Net2.0/3.0, ASP.Net(C#), ADO.Net, SQL Server 2005, Oracle9i/10g, Crystal Report, Visual

Source Safe.

Amee International, India Jan 2005 – Aug 2006

Microsoft .NET Developer

Employee Management System: Automation of Small Scale Industries mainly automates the processes like

attendance sheet, leave transactions, overtime, benefits and salary calculations.

Responsibilities:

• Involved in requirements gathering, design and development of the system. Created the table structures and

integrity constraints in Access database.

• Designed and developed the user interfaces using VB 6.0. Wrote queries to extract and store the data into

these tables.

• Created daily reports using Crystal Reports.

• Wrote the test cases and executed the same. Supported the production system.

Environment: Windows 2000, VB 6.0, ASP, Visual Interdev, HTML, MS-Access, Crystal Reports.

Contact this candidate