Project Sql Server

Vijayalakshmi PRADEEP

Summary

• * years of experience in requirement analysis, design, development and implementation of client/server Web based and n-tier applications.

• Strong expertise in developing windows applications, web based applications.

• Worked on Microsoft Visual Studio .Net IDE using C#.Net 2.0, ASP.Net, ADO.Net and SQL Server 2005.

• Worked on ORACLE 8i and Crystal Reports for Visual Studio 2005.

Software Skills

Programming languages C#, C++ Intermediate

Microsoft Technologies ASP.NET, ADO.NET Intermediate

Scripting Languages HTML, SQL Intermediate

DATABASE SQL SERVER 2005,ORACLE 8i Intermediate

Development Tool Visual Studio.Net 2005 & 2008 Intermediate

SAP SAP BI Beginner

ERP SAP R/3 Beginner

Certifications

• Certified SAP BI in 2010 from SAP TAC, Bangalore.

• Certified DOT NET 3.5 in 2010 from CegonSoft Pvt Ltd, Bangalore.

SAP BI Expertise

• Expertise in creation of info source, info objects maintenance, transformations.

• Good understanding of Data Modeling using BW Extended Star Schema.

• Expertise in creation of Basic cube, Remote cube, Transaction cubes and DSO.

• Expertise in Business Explorer Analyzer for Reporting.

• Expertise in Generic Extraction of Table, Views and function Module

• Created DSO objects for data staging in BW.

• Good Knowledge in Business Content objects and creation of multi providers and info set.

• Experience in Building and enhancing BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set.

• Creation of Info Packages, info package groups.

• Knowledge in ABAP/4 Data Dictionary, Editor, BDC, Reports and Smart forms.

Academic Project in MBA (HR):

• Leadership-A comparison between the INDIAN way and Western way.

Professional Experience

• Worked as Software Developer with Sumearu Technologies, Bangalore.

• Following are some of the important projects executed during this tenure.

Project #1:

Project Title: Online Market Automation Software

Role: Design, Development and Implementation.

Environment: C#.NET 2.0, ADO.NET, Visual Studio.Net 2005, ORACLE 8i, SQL, .Net

Framework 2.0, ASP.NET, JavaScript, CSS

Project duration: April 2010-December 2010 Team size: 5

Description:

This project allows the three zonal offices of markets department to do rental, demand and collection online. In addition tendering for shops, pay and park, gate fee collection and ground rent can also be tracked. Concessionary and budget are also computerized. All the reports like DCB, Kirdhi book etc are generated automatically. This software will update the events data in the centralized server, which can be accessed from all the zonal offices, DC Market’s office and BBMP server administrator. The Tax Inspectors at the zonal offices should enter the details on line in the software after proper verification. This data should be updated in the centralized web server database automatically.

Responsibilities:

• Extensively used 3-Tier Architecture for Presentation Layer, Business Logic and Data Access Layers and developed using C#.

• Involved in creating SRS (Software Requirement Specification), requirement analysis, handling test cases and implementation.

• Created Stored Procedures, triggers and Sequence in Oracle 8i.

Project #2:

Project Title: Accounting Software.

Role: Design, Development and Implementation.

Environment: C#.NET 2.0, ADO.NET, Visual Studio.Net 2005, SQL SERVER 2005, SQL, Dot Net.Framework 2.0.

Project duration: Sept 2009-Mar 2010 Team size: 5

Description: This software is a three tier architecture based windows application including Data Access Layer, Business Logic Layer and Presentation layer using Class Libraries with C#.Typically composed of various modules such as Company Registration,Ledger,Ledger Adjustments,Sales,Sales Order for supply of Inventory,Purchases,Purchase Order to order inventory,Stocks.Audits reports on Receipts,Payments,Sales and Purchases exceeding user defined limits.Reports are generated on Trial Balance,Profit and Loss Account and Balance Sheet.Finally,implementing validations to check duplications.

Responsibilities:

• Extensively used 3-Tier Architecture for Presentation Layer, Business Logic and Data Access Layers and developed using C#.

• Implemented Stored Procedures and Triggers using SQL in SQL SERVER 2005.

• Exceptional handling, validation and unit testing.

Project #3

Project Title: Hospital Management System.

Role: Design, Development and Implementation.

Environment: C#.Net 2.0, ADO.Net, Visual Studio.Net 2005, SQL, SQL SERVER 2005, .Net Framework 2.0.

Project duration: Sept 2008-July 2009 Team size: 4

Description:

This software is used to maintain all hospital records on computers no matter whether it is prescription of doctor or treatment sheet of patient, medicine, all data of employees. This is designed to improve the quality and management of clinical process analysis and activity based costing. It consists of various modules such as Doctor Details, laboratory details, Patients details, Medicine details, treatment details.

Challenges / achievements

• Designed implemented and tested the application.

• Used Component dll for updating the records using ADO.NET.

• Developed Various reports with the facility to upload to Excel.

• Used SQL Stored Procedures for updating and retrieving.

Project #4

Project Title: Cold Storage.

Role: Design, Development and Implementation.

Environment: C#.Net 2.0, ADO.Net, Visual Studio.Net 2005, SQL, SQL SERVER 2005, .Net Framework 2.0.

Project duration: April 2008-Aug 2008 Team size: 4

Description:

This software is meant to preserve the perishable commodities cold storage offers the right data storage solution that can provide the highest performance, help lower infrastructure cost and cost of ownership, improve service reliability and simplify system management. Typical modules are Goods Inward Acknowledgment, Storage agreement, Floor-wise / Commodity-wise Billing Statements, Customer-wise Stock Position & Stock Ledger, Overall Stock Position & Stock Ledger, Balance Sheet, Trail Balance, Profit & Loss Statements.

Challenges / achievements

• Responsible for middle tier and database designing.

• Responsible for User Interface Design.

• Making the process in a configurable scenario, which we can change at regular intervals.

Education

PGDBA (Human Resource) Symbiosis Centre for Distance Learning (SCDL), INDIA

B.E (Electrical and Electronics) VTU, Belgaum, Karnataka, INDIA

PUC PU Board, Karnataka, INDIA

Languages English, French, Hindi, Kannada, Telugu

Hobbies

• Reading – Newspapers, Solving Puzzles, Crosswords, Photography, Interior decoration

• Interest to learn languages, has learnt beginner level French language in Alliance Francaise, Bangalore.

Date: April 20, 2012 Vijayalakshmi PRADEEP

Contact this candidate