.Net Sql Server Experience Project Oracle Manager
Resume:
[pic]
Naga
***.*********@*****.***
Summary
. More than 3 years of experience in developing Windows and Web
applications using ASP.NET, ASP, C# and ADO.NET
. Experience in Complete Software Development Lifecycle (SDLC) -
Requirement Analysis, Design Analysis, Project management using web and
Client-Server Technologies.
. Good knowledge of Object-Oriented Analysis and Design and have working
knowledge in designing Use Cases, Sequence Diagrams, Class
Diagrams using UML and have experience in Agile Methodologies.
. Extensive knowledge in C# within the .Net framework 2.0/3.0/3.5.
. Experience in using Web User Controls, Master Pages and Custom User
Controls.
. Abilities to map functional requirement of clients into technical
specifications and a sound experience of requirement gathering and client
interactions.
. Worked and implemented business logic using Entity and Manager Classes
. Working knowledge in Internet languages like HTML, CSS, XML, VBScript,
JavaScript and AJAX.
. Extensively worked on Oracle SQL, PL/SQL, SQL Server, MS Access and
MySQL.
. Experience in writing web scripting languages like PHP and Perl using
CGI.
. Managing Data Table space, Undo Table space, Temporary Table space for
oracle databases.
. Managing Users, Roles, Privileges, Checking alert log and trace files for
errors in oracle databases.
. Creation of roles, granting privileges and profiles etc.
. Participated in the integration of different modules of the application.
. Good team player with excellent communicative and analytical skills
Certification:
Oracle certified associate (OCA) in 10g database administration.
70-536: Microsoft .NET Framework 2.0- Application Development
Foundation
Education:
B.Tech. Computer Science and Engineering, JNT University, India (GPA
- 3.5)
Masters in Bradley University, Peoria USA (GPA 3.75).
Technical Skills:
Web Technologies : ASP, ASP.Net 2.0/3.0, ADO.Net, Web Services, Win Forms,
Web Forms
Operating Systems Windows 98/XP, Windows NT/2000/2003, Vista, Unix, Linux,
: Solaris
Programming C#, VB.NET, SQL, PL/SQL, T-SQL
Languages :
IDE : MS Visual Studio 2003/2005/2008
Web Programming : HTML, DHTML, XML, XAML, CSS, Java Script, XSLT,WSDL,AJAX
Databases : SQL Server 2005, MS Access, Oracle 8i,9i, Oracle 10g
Express Edition, My Sql
Version Control Microsoft Visual source Safe
Tools:
Reporting Tools: SQL Server Reporting Services, Crystal Reports
UML tools: Rational Rose, smart Draw
Professional Experience:
Social Networking, Wilmington, Delaware
Jan'09- Till date
.Net Developer
This project is powered by Aambit Inc. allows users to connect with various
people who have similar interest to interact. It allows users from
different parts of the world to create custom profiles to express their own
interests where in they can add friends, Post events, Upload Photos, Videos
for maintaining interaction and communication.
Responsibilities:
. Involved in different phases of SDLC including requirements, analysis and
architectural design phases of the project using agile methodologies.
. Involved in Designing the Use Cases using UML Tools.
. Involved in iterative, test driven and SCRUM method of Agile Methodology.
. Implemented various Classes and Modules in C#, ASP.Net for efficient
reuse of code in Visual Studio environment.
. Involved in creating CSS for a unified look of the front end User
Interface.
. Designed and developed the master page and the login functionality for
the application.
. Used Datasets and Data Grids to retrieve, display and manipulate the data
as desired from the User Interface
. Worked on implementing business logic using Entity and Manager Classes
. Worked on configuring Web Apps using IIS
. Responsible for providing Authentication and Authorization for the
system.
. Involved in creation of tables, indexes according to the uses cases and
requirements.
. Involved in writing Complex SQL statements, stored procedures, Triggers
using SQL Server2005
. Taking backups of test database at the end of module integration.
. Actively participated in application development using C#.Net, ASP.Net,
Java Script, XML, XAML, XSLT, XPATH and SQL Server2005
. Experience in integration of modules.
. Developed the data access layer using MS Application Blocks.
. Developed Test Cases using NUNIT.
Environment: .Net Framework 3.5, SQL Server 2005, ASP.Net 3.5, C#.Net,
ADO.Net, WCF, JavaScript, IIS, Ajax, Crystal Reports, OOPS, Visual Studio
2008,, HTML, Java Script, XML
Help Desk Administration System, Mahwah, NJ (Aug 08 - Dec 08)
Programmer, .NET Intern
Sharp Electronics Corporation (SEC) is the U.S. sales and marketing
subsidiary of Japan's Sharp Corporation. Project involved development of
application to report hardware problems online. It supports over 150
machines. Project is suited for any service or support environment where a
large number of problems are managed by one or more intermediate stage with
optimum time usage and quick & efficient response.
Responsibilities:
. Designed and Developed components using C# & .NET Framework Classes.
. Developed Front End UI screens using Web Forms in C#.
. Used Web Forms and Server controls in ASP.NET.
. Created the User controls for the presentation layer.
. Used Ajax on server controls to avoid page post back and page
flickering.
. Used Iterative Agile Methodology Scrum Framework and performed
functional and unit testing for the modules developed.
. Developed a communication layer for consuming WCF and web services for
fetching the products.
. Developed connectivity to RDBMS using ADO.NET datasets.
. Developed stored Procedures and Triggers to do business calculations and
event generations.
. Used SQL Server 2005 to design and develop tables.
. Involved in automating SSIS packages where data goes to SQL and Oracle
Databases.
. Generated monthly reports by using SSRS.
. Involved in Integration Testing of various modules of the project.
. Used Visual source safe to maintain version control and history during
development.
Environment: C#, ASP.NET 3.0/3.5, Visual Studio 2005/2008, ADO.NET, SQL
Server 2005/2008, Oracle 9i/10g,WPF, WCF, Web service, Visual SourceSafe,
HTML, DHTML, CSS, ASP.NET, AJAX, XML, MVC, Windows 2003 server.
Master's projects:
Graduate Assistant: Department of computer science Bradley University
May'08 - Aug' 08
The project is to develop a search engine for finding files using keywords
Responsibilities:
. Involved in all phases of system development life cycle and deployment
. Experience in using Rational Rose modeling tool for system design and
documentation
. Worked on Use cases, Documentation, and UML diagrams.
. Gathered and analyzed all necessary requirements by involving in
discussion sessions.
. Involved in generating the user interface screens using .net frame work
. Developed the UI and Business Logic in ASP. NET using C#.Net.
. Implemented UI validation using Validation Controls and JavaScript.
. Extensively used Data Adapter and Dataset to access database.
. Involved in designing and developing the GUI using
various ASP.NET controls like DataGrid, DataList, Repeater, Textbox,
Calendar, Panel, DropDownList and Validation controls.
. Developed and optimized stored procedures, functions, triggers and
cursors in Oracle 10g.
. Involved in Unit testing.
. Used Microsoft's Visual Source Safe for Version Control.
Environment: ASP.Net, C#.Net, ADO.Net, Visual Studio.Net 2005, JavaScript,
HTML, DHTML, XML, IIS, CSS, SQL Server 2005, Visual SourceSafe, N-Unit,
Rational Rose.
Project: Data mining for RA Database using SQL SERVER 2000
Dec'07 - Apr'08
The project is to research the various factors and analyze the RA disease
factors by breaking the tables into clusters through k-means algorithm
implemented through data mining technique.
Responsibilities:
. Involved in Generating ER diagrams through ER studio
. Involved in creating databases, tables in MySQL.
. Wrote DML, DDL statements
. Involved in creating indexes, tuning indexes
. Generated Clusters using Business Intelligence.
. Compared SQL CLUSTERS with Clementine tool clusters through C++
programming
Environment: SQL Server 2000, Solaris, SQL, T-SQL
Client : Votive software solutions.ltd.
Jan' 06-Dec' 06
Location : Hyd, India
Role : Programmer / jr. DBA
Responsibilities:
. Designing and monitoring the database
. Involved in Creating the table spaces, indexes, and database objects
. Assigning various permissions on various database objects
. Checking the alert logs and trace files for errors
. Involved in user management activities like creating, maintaining the
users roles, privileges and profiles
. Involved in performance tuning of the SQL queries using EXPLAIN PLAN,
SQL Trace.
. Involved in generating the backup and recovery strategies
. Involved in taking cold and hot backups
. Experience in using the SQL*LOADER and TOAD
. Experience in writing SQL, PL/SQL procedures, triggers
. Knowledge of Unix shell scripts
. Timely completion of activities for database backup and
monitoring jobs
Environment: Oracle 9i, UNIX, Linux, SQL, PL/SQL, SQL*LOADER, Toad.
Contact this candidate