Post Job Free

Resume

Sign in

.Net Developer Sql Server Project Oracle Experience

Location:
King Of Prussia, PA, 19406
Posted:
March 09, 2010

Contact this candidate

Resume:

Kiran

[pic] abnd5b@r.postjobfree.com [pic] 859-***-****

PROFILE

Over 7 years experience in Analysis, Design and Development of Client-

Server, Web and Wireless applications primarily using DOT NET framework

(ASP.NET), ASP, XML, Oracle database Server, C#, VB, MS-Access, HTML,

DHTML and JavaScript.

HIGHLIGHTS

. 7+ years of experience in Analysis, Design and Development of Client-

Server and Web-based n-tier Architecture for windows and web

applications.

. Expertise in Software Development Life Cycle (SDLC) processes, Object

Oriented Programming concepts, Design Methodologies and Practices.

. In-depth understanding of all versions of ASP.NET and .NET Framework

including 3.5 and Class Libraries.

. Expert knowledge of enterprise application development technologies

using .NET framework in the areas of performance, security, scalability

and extensibility.

. Extensive experience in Web and Application Development using

languages like C/C++, C# and Visual Basic.

. Good experience in .Net technologies like C#.NET, VB.NET, ASP.NET,

AJAX and Linq.

. Experience in writing Data Access Components using ADO.NET and ADO.

. Experience working on Windows Foundation Technologies like WCF, WPF

and tools like Silver light.

. Experience in using web technologies like HTML, DHTML, XML, ASP and

JSP to develop web applications.

. Experience in coding Cascading Style Sheets (CSS), Master Pages,

JavaScript, and VBScript.

. Experience with Moss 2007 with SharePoint designer, Navigation

controls, custom web parts, features, Custom document library, Custom

lists and workflows.

. Worked with Site Templates, Site Definitions and Master Pages as the

part of SharePoint site customization.

. Created and customized Custom Master Pages and Page layouts, Site

themes, Content Types using SharePoint Designer.

. Experience in Business Data Analysis, Design, Modeling and

Implementation on major RDBMS.

. Worked extensively with Stored Procedures, Triggers and Indexes.

. Developed web applications based on implementing Web Services and

Authentication.

. Experience in designing, developing, deploying and migrating reports

using Crystal Reports and SQL Server Reporting Services (SSRS).

. Excellent working and Conceptual knowledge of Oracle PL/SQL, Oracle

Forms and Reports.

. Experience in writing stored procedures, Functions, Packages and

Database triggers using PL/SQL.

. Data Conversion of Flat files to Oracle using Oracle SQL*Loader.

. Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle

utilities and creating relevant system and users documentation.

. Integrated and Deployed applications on IIS 5.0/6.0/7.0 web servers.

. Proven ability as a Self-starter, well-recognized Team Player, while

performing well in cross-functional teams with excellent

Interpersonal, Communication skills and strong technical capabilities.

. Strong analytical, mathematical and statistical problem-solving

skills.

KNOWLEDGE - BASE

.NET Technologies VB.NET, C#.NET, ASP.NET (All Versions), ADO.NET, AJAX,

Linq, Windows Forms, WCF, WPF, WWF, Web Services,

SilverLight 1.0/2.0.

SharePoint Technologies SharePoint Portal Server 2003, SharePoint Designer 2007,

MOSS 2007, Windows SharePoint Service 2.0/3.0.

Web Technologies HTML, DHTML, XML, CSS, ASP, JSP, XSLT.

Scripting Languages VBScript, JavaScript.

Web Servers IIS 5.0/6.0/7.0.

Databases MS SQL Server 2000/2005/2008, Oracle 10g/9i/8i.

Version Control Visual Source Safe 6.0.

IDE Microsoft Visual Studio 2003/2005/2008, Oracle Developer

Suite 9i/10g.

Reporting Tools Crystal Reports, Oracle Reports 9i/10g.

Operating System MS-DOS, MS Windows 95/98/2000/ME/NT/XP/Vista, Red Hat

Linux, Sun Solaris, Unix, Macintosh OS.

Programming Languages C/C++, C#, VB 6.0, Java (J2EE).

Modeling Tools UML, E-R Model, Relational Model.

Protocols and Standards TCP/IP, UDP, VoIP, HTTP, FTP, SOAP.

Hardware Pentium, PC AT-486, IBM, Dell and Apple Mac.

Certifications:

. Exam TS 70-536: MCTS in Microsoft .Net Framework - Application

Development Foundation.

. Exam TS 70-562: MCTS in Microsoft .Net Framework 3.5, ASP.Net

Application Development.

. Exam TS 70-542: MCTS in Microsoft SharePoint Server 2007, Application

Development.

HANDS-ON EXPERIENCE

Oklahoma State Department of Health, OKC, OK Aug 2008 - Dec

2009

1 Project: File-Share Application Sr. Net

Developer/SharePoint Developer

File-Share application is an intranet-based application that allows users

to share files and information on a web server, by making them accessible

through a common location. A pool of Authorized Users logged on to the

Direct-Online application can view, explore and download the available

files from the File Server to their systems, as well as upload new files to

their respective folders on the server. These authorized users could edit,

rename and delete files already present in the server. Administrator

creates and manages the users, while providing them with restricted access

to the folders on the File-Server. Notification mails are sent to the users

with access to a particular folder about any modifications in the folder

content.

Responsibilities:

. Analyzed and designed the project based on the given requirements.

. Created web user controls for the UI forms using ASP.Net 3.5 and

SilverLight 2.0.

. Developed User Authentication module by adding more secure

functionalities to LoginControl Toolkit.

. Implemented AJAX controls like UpdatePanel in the web forms, to

dynamically update the list of the contents of each file-folder on the

server.

. Implemented validations using Regular Expressions and JavaScript to

validate data entered in the user registration forms and generate-

email forms.

. Implemented File Upload Rich Control to upload files to the Server,

single file at a time.

. Worked on Cascading Style sheets (CSS), Master Pages and applied

themes, skins to the web controls.

. Involved in writing the Exception handling blocks and classes, to

catch exceptions based on the entered data and file-types uploaded.

. Developed Database Tables to store User ID/Password information in

Oracle 10g.

. Employed WCF End-Points and Contracts for enabling file-sharing across

various protocols, applications and platforms.

. Developed Complex Packages, function and stored procedures using

Oracle 10g.

. Developed modules for connecting the Project to the Database Objects.

. Involved in fixing QA and Production issues, by writing unit test

cases and testing the application.

. Worked with System Administrator to store user information, assign

security policies and deploy the project using Active Directory.

Environment: ASP.NET 3.5, C#, Oracle 10g, AJAX, WCF, Visual Studio

2008, Microsoft Active Directory, JavaScript, HTML, SilverLight 2.0.

Symbol Technologies, NYC

June 07- July 2008

Project: DFW for Windows

Programmer Analyst

Symbol Technologies is a leading provider of barcode readers, mobile

computing devices, RF devices, wireless LAN and Software used to

manage these devices. DFW (Short for Dispatch for windows) is a

service application that is used to service large scale customer

service requests for units they have purchased from Symbol. It takes

care of the service life cycle right from selling to shipping to

client, which includes repair, parts ordering, shipping to the

customer; it keeps track of Every Detail regarding the unit once the

unit arrives at the service depot for repair.

Responsibilities:

. Working on request for enhancements forwarded by the users of the

application.

. Creating all the related technical documents for the change technical,

design, rollout, rollback document.

. Was involved in doing changes to an existing application was involved

in creating rollback and rollout scripts.

. Making changes to the existing asp application and porting some of the

functionality to .Net.

. Ported the user authentication and authorization functionality to

.Net.

. Used AJAX technology for asynchronous lightweight communication

between controls and the server.

. Created and consumed Web Services in the communication.

. Used web controls and implemented the OO nature of C#.net.

. Worked on com components in C#. Familiar with references and

registering components and controls.

. Used ADO and ADO.NET extensively to communicate to the database.

. Used the three kinds of built in controls in Asp.net: web (for new

pages), html (porting existing pages) and validation (for validation).

. Unit testing the code that is developed and creating test cases

.Forwarding the test cases to the testing team.

. Interacting with the users to understand their requirements for the

changes .Doing feasibility study then analyzing, designing and coding.

. Created DDL modification scripts for SQL Server.

. Implemented referential integrity and domain integrity using triggers

as well as declarative statements.

Environment: C#, ASP.Net, Visual Studio 2005, MS SQL server 2005, .Net

Framework 2.0, ADO.Net.

Med Bill Corporation, Lansing, MI

Apr 2006 - May 2007

Project: Medical Invoice Processing System

.Net Developer

Med Bill Corp. is a medical invoice processing company located in MI.

Currently they are developing an invoice processing system with the help of

.NET technologies using ASP.Net2.0 and the back end is SQL server 2005. I

am responsible for the developing the business objects and data access

layer and the front end.

Responsibilities:

. Involved in Development and implementation of the 3-tier architecture.

. Application developed using Web Forms, .NET framework, .NET

Remoting, ASP.NET with C#.

. Designed site using Master Pages.

. Apply theme and skin declaratively.

. Configure the properties of Web server controls programmatically and

by using the Microsoft Visual Studio Property Editor.

. Used Validation Controls in ASP.NET for validating Front-end forms and

even created custom controls.

. Developed Custom User Controls to reduce the Complexity in Use

Interfaces.

. Developed client side validations using JavaScript.

. .NET Web service used to export the data.

. Involved in Designing and Creating the Database in SQL Server 2005.

. Implemented Data layer is using ADO.NET Component mode.

. Developed Business layer having business components using C# and .NET

Remoting.

. Developed User Controls as re-usable components.

. Implementation, Testing, Deployment and Documentations at all stages

of application.

Environment: C#, ASP.Net, Visual Studio 2003, SQL Server 2005, .NET

Framework 2.0, ADO.Net, Crystal Report.

InPhonic, Hyattsville, MD

Apr 2005 - Mar 2006

Project: Store Front Application SQL/.Net

Developer

InPhonic is a leading online provider of wireless services and

devices. InPhonic sell wireless services and devices through private

labeled websites like www.wirefly.com and www.intelenetwireless.com.

Storefront is an e-commerce platform that integrates merchandising,

provisioning, procurement, customer care and billing operations into a

single state-of-the-art system for activating wireless services and

devices.

Responsibilities:

. Developed Business and Data tier using C#, ADO.NET.

. Developed Web Forms using C#, ASP.NET with Visual Studio .NET 2003.

. Created different templates and skins using XML and XSLT and

implemented XSLT.

. Templates in .Net user control using ASP.Net.

. Used Share point portal to manage my task.

. Involved in writing the stored procedures, SQL Queries and also

involved in fine-tuning the queries using Query Optimizer.

. Involved in designing and documentation of flows and functional

diagrams using MS Visio.

. Implemented input validation using the ASP.NET Input Validation

Controls.

. Database Connection using ADO.NET.

. Developed reports using Sql Server Reporting Services and deployed

into the Share point Portal Server.

. Create DTS packages and stored procedures in SQL Server.

. Used Java Script for all client side validations.

. Reviewed other developer's code with the coding standard documents.

. Involved unit testing and functional testing in .Net components.

Environment: ASP.NET, C#, ADO.Net, Visual Source Safe, SQL Server

2000,,HTML, Java Script, XML, XSLT, CSS, IIS 5.0, UML, Microsoft.Net

Framework 1.1, Windows XP.

Board Of Education Retirement System, NYC, USA

Jan 2005 - Mar 2005

Project: Custodial Reporting Application

Programmer / Analyst

The Custody Reporting Application provides access to the Banks

financial and customer service data on both intra-day and an overnight

basis. The application allows users to generate financial, customer

service and reconciliation reports through ad-hoc queries.

Responsibilities:

. Developed Business and Data tier using VB.Net, ADO.Net.

. Developed web forms using VB.Net, Asp.net with Visual Studio .Net

2003.

. Configured web.config file for the configuration of the entire Web

Application.

. Security of the site was maintained using .Net authorization and

authentication services.

. Involved in writing the stored procedures, SQL queries and also

involved in fine-tuning the queries using Query Optimizer.

. Implemented input validation using the Asp.Net input validation

controls.

. Database Connection using disconnected architecture from ADO.Net.

. Coded components for generating XML data from the database using

ADO.Net.

. Programming and documentation of each module.

. Prepared project plan using Microsoft Project.

. Used JavaScript for all client side validations.

. Used Crystal Reports to create reports for the above projects.

Environment: Microsoft.Net Framework 1.1, ASP.Net, VB.Net, ADO.Net, HTML,

SQL Server 2000, Crystal Reports 9.0,Microsoft Project, Windows XP.

LearningMate Solutions Pvt. Ltd, Mumbai, India

June 2003 - Dec 2004

Project: Payroll System

Programmer

Designed and developed the Payroll System for a leading finance company.

Payroll System has features like daily presence of yearly employee ledger

with necessary leaves (CL, EL, SL etc.). A data entry is daily absent based

and automatically calculates monthly data. The system includes the 15

earnings and 16 deductions. System Contains reports for Monthly as well as

yearly for all departments.

Responsibilities:

. Designed, Coded, Tested and implemented forms and reports for Advance

loans, Pay-Slip, PF Statement and loan recovery modules.

. Involved in writing complex User Interface using ASP.Net and Win

Forms.

. Design, develop and implement all of the software using ASP.NET and

Win Forms.

. Database Connectivity using ADO.Net

. Involved in writing customized controls using C#

. Designed and developed classes to implement business logic and data

access using C#

. Programming and documentation of each module.

. Involved in Writing Packages, Functions, Store Procedures, Triggers

and Views in Oracle 9i.

Environment: ASP.Net, C#, ADO.Net, Win Forms, Oracle 9i, HTML, Windows XP,

Java Script.

K2 Systems Ltd, Hyderabad, India July

2002 - May 2003

Project: Financial Reporting Services.

Software Trainee

K2 Systems Ltd is a supply chain company that provides reports of expenses

and maintains logistics of its clients. The project was intended to develop

tools for reporting the financial information of the company in the

hierarchical structure and making adjustments for client count. My

involvement in the project is to develop Logic at backend using PL/SQL.

Responsibilities:

. Created database objects like Tables, Indexes, Sequences and Views

etc.

. Modified the existing database objects to meet the expanding business

requirements.

. Involved in design, development and Modification of PL/SQL stored

procedures, functions, packages and triggers to implement business

rules into the application.

. Written Procedures and Functions using Dynamic SQL and written complex

SQL queries using joins, sub queries and correlated sub queries.

. Developed user interfaces based on business requirements using Forms

9i and developed Procedures and functions at application level.

. Developed various Forms for the application involving modules to

segregate the data.

. Written UNIX shell scripts and scheduled kernel jobs.

. Involved in Database Tuning and Improved Application performance using

Explain Plan, TKPROF and SQL trace.

. Loading of the data from flat files into staging tables using SQL

Loader.

. Written Stored Procedures to perform Validations on data and to move

data from staging tables into the Base tables.

. Loading of data from flat files into the user interface forms using

Data Loader.

. Responsible for creating the technical design document.

. Involved in Development, Testing and Maintenance of the System.

Environment: Oracle 9i, Forms 9i, Reports 9i, TOAD, SQL *Loader, Data

Loader, SQL*Plus, PL/SQL, Windows XP, UNIX.

REFERENCES

. Available upon request.[pic][pic]



Contact this candidate