Post Job Free

Resume

Sign in

Manager Sql Server

Location:
Sacramento, CA, 95825
Posted:
January 04, 2011

Contact this candidate

Resume:

Sharone Gorla

Email: abhyqk@r.postjobfree.com

Phone Number: 601-***-****

Summary: 4 years of professional IT experience in designing, developing,

integrating and implementing enterprise products and applications using

various technologies.

Education:

Master of Science in Computer Science, California State University,

Sacramento, CA; (Jan 2007-Dec 2008)

Bachelor of Engineering in Computer Science, Jawaharlal Nehru Technological

University, India (May 2002-May 2006)

Knowledge and Skills:

Programming Languages: C, OOP through JAVA, PL/SQL, C#, VB.NET, CSS,

Assembly, Verilog, J2EE

Scripting: Java Script, HTML

System & Architecture: UNIX/Linux, Windows, MAC, Intel x85, Intel x86

Software Tools: Net Beans, SQL Server, MS office, ORACLE, Adobe, UML

(Rational Rose)

Tools/Utilities: Eclipse, Visual Studio, HP Open view Asset Center, Dream

Weaver (ColdFusion, Flex etc)

Certifications: HP Professional Certification for Asset Center v5.x

.NET Framework 3.5, ASP.NET Application Development

ITIL v3 Foundation

Professional Experience:

Client: Minerva Enterprises, Sacramento CA

Jan 2010-Dec 2010

Role: Consultant

Description: - Minerva Enterprises gives a perfect strategy for managing

your IT assets and/or services. It basically focuses on addressing

organizational alignment challenges, to develop IT service management

system architecture, helps in creating process frameworks, definitions and

integration also to select and implement IT service management software and

to establish meaningful metrics

Responsibilities: HP Virtualization and Cloud Management: HP Asset Manager

5.x currently allows for basic management of virtual machines, however it

is limited to the single Host multiple VM model that was common several

years ago. Current and future virtualization methods rely increasingly on

clusters of physical servers pooled together and collectively supporting a

set of virtual machines. Minerva Enterprises proposed to extend the

functionality of HP Asset Manager so that customers can more accurately

model these more complex and dynamic environments.

. To use ITIL best practices throughout the project and assist through

all the phases of the project.

. Assist with encoding, testing, debugging and documenting web based

applications Develop and provide content for the organization's web

site using Dreamweaver; SQL; Cold Fusion; HTML; etc.

. Visual Programming in BASIC using HP Open View Asset Manager 5.x (an

Enterprise Asset Management tool produced by HP).

. Designing the necessary GUI (Pages, controls, event generation and

handling etc) for the application using HP Asset Center.

. Involves Writing test cases for the wizards and debugging the wizards.

. Involves creating UML models for the proposed functionality using

Enterprise Architecture.

. Dealing with the two-tier (direct connect from the client to the

backend RDBMS (Oracle & SQL server)) WPP application written in C++.

. Also involves testing and resolving issues with the wizards on both

Windows and Web Client.

. Involved in analyzing designing implementing and testing

Environment:

HP Open View Asset Center 5x, Visual Programming in Basic, RDBMS, C++, SQL,

Web Interfaces, SDLC, ITIL V3

Client: California Primary Care Association

July 2009-Jan 2010

Role: IT Coordinator (Admin)

Description: - California Primary Care Association (CPCA) is the

statewide leader and recognized voice representing the interests of

California community clinics and health centers and their patients.

Responsibilities:

. Provide technical support to staff, working with IT consultants as

needed to troubleshoot and resolve hardware and software related

issues

. Assist with encoding, testing, debugging and documenting web based

applications Develop and provide content for the organization's web

site using Dreamweaver; ASP.NET; SQL; Cold Fusion; HTML; Flex, etc.

. Oversee company database, ensuring data is current. Modify or create

tables, queries, Stored Procedures and reports as needed

. Work with Association staff in the development of web based and data

based projects Ensure content on company website is current and

provide assistance to members and other website users with issues such

as access to restricted areas and downloading materials

. Provide training and technical support to staff on Association's

software; web site; databases and other applications

. Maintain an inventory list of company software and hardware

. Work with staff and IT consultants on new features or revisions to the

Association's databases and website. Ensure projects are developed to

specifications and tested.

. Develop and maintain vendor relationships and manage the purchases of

software to secure best pricing options.

Environment:

SQL server 2005, ASP.NET, Dreamweaver, Contribute, ColdFusion, Flex, HTML,

MS Office Suite software, troubleshooting

Client: Honda, Sacramento CA

December 2008-April 2009

Role: Computer Programmer (VB & SQL)

Description: - Minerva Enterprises gives a perfect strategy for managing

your IT assets and/or services. It basically focuses on addressing

organizational alignment challenges, to develop IT service management

system architecture, helps in creating process frameworks, definitions and

integration also to select and implement IT service management software and

to establish meaningful metrics

Responsibilities:

. Visual Programming in BASIC using HP Open View Asset Center (an

Enterprise Asset Management tool produced by HP).

. Designing the necessary GUI (Pages, controls, event generation and

handling etc) for the application using HP Asset Center.

. Creating many physical objects (table, constraints, index, function)

to facilitate the smooth data retrieval

. Dealing with the two-tier (direct connect from the client to the

backend RDBMS (Oracle & SQL server)) WPP application written in C++.

. Also involves testing and resolving issues with the wizards on both

Windows and Web Client.

. Involved in analyzing designing implementing and testing

. We used ITIL best practices

Environment:

HP Open View Asset Center 5x, Visual Programming in Basic, RDBMS, C++, SQL,

Web Interfaces, SDLC

Client: Ericsson (TCS)

December 2005 - May 2006

Role: Java/J2EE Programmer

Description:- Tata Consultancy Services serves large and fast growing

organizations.TCS provides clients with the right set of capabilities for

the right problems at the right time. They apply deep industry experience

to provide a wide range of IT Solutions, Consulting, Business Process

Outsourcing, Engineering Services and IT Infrastructure Services.

Responsibilities:

Speech simulation in SEA (Simulated Environment for Network Switch) is an

attempt to provide a communication between two SEA environments. At a basic

level SEA is scalable software architecture for simulator based test

environments and other simulator based products where complex computer

environments should be simulated. SEA is mostly suited for system level

simulation using one or several Instruction Set Simulators (ISS) and

interface simulations, where a computer system needs to be simulated on

other computer platforms.

. Involved in analyzing designing implementing and testing

. Developed code for all the activities using Java Media Framework API

which enables audio, video and other time-based media to be added to

applications and applets built in Java technology

. Developed code for the necessary GUI used for the application from the

Java/J2EE API.

. Used JMF managers like Package manager, Capture Device manager Plug-in

manager etc to program the audio tracks.

. Used Real Time Protocol to transfer the speech packets between two SEA

environments.

. To capture speech at runtime using microphone, applying Codec's to the

captured speech, generate packets and transfer it on a network using

RTP.

. Retrieve packets from the network, de-packetize them by applying

codec's and listen to the speech.

. Integrate this application with the environment TCS used for

Switch Simulation.

. Involved in preparing the UML diagrams like use case diagrams,

sequence diagrams and class diagrams using

Rational Rose

Environment:

JAVA (JMF, javax.media API, Forms), Packetizing and de-Packetizing Codec's,

Real Time Transfer protocol, UML (Rational Rose), SDLC

Client: Enterprise Resource Management System (AKALPA)

Jan 2005 - Dec 2005

Role: Java/J2EE Developer

Description: Bharat Dynamics Limited (BDL) is a high-technology fast

growing Mini Ratna PSU under the Ministry of Defense with two production

units. Bharat Dynamics is the prime production agency for missile weaponry

systems under the Integrated Guided Missile Program, including the Prithvi,

Trishul, Akash and Nag missiles. Production Planning Control is used to

design the software for managing the operations in a work shop and to

determine the machine and operation efficiency which are subsequently used

to award incentives to employees involved in the production process

Responsibilities:

. Developing a 3-tier web based application.

. The application contains a front end web tier.

. EJB tier using both Session Beans and Entity Beans.

. Designing, Developing & Fine Tuning data-retrieval & data-migration

scripts.

. Database tier using Oracle Server, database-pooling techniques to

connect to the Oracle database.

. Used PL/SQL for queries and stored procedures

. Performed Unit and Integration testing

. Involved in preparing the UML diagrams like use case diagrams,

sequence diagrams and class diagrams using

Rational Rose

Environment:

J2EE, JAVA, Servlets, JSP, UML, Oracle EJB, SQL/PL SQL

Academic Projects:

. Steganography: (Language: Visual Studio 2005 & C#)

The goal of this project is to hide messages inside other harmless messages

(i.e. Image and Audio file) in a way that does not allow any third party

(other than sender and intended receiver) and to retrieve the hidden

information from the image received. In addition, to extend with detection

tool for the Image files, this can identify whether the Image was modified.

RDBMS & PL/SQL:

Oracle implementation of RDBMS, basic functionality of PL/SQL for creating,

viewing, maintaining, and altering data in Oracle which includes Sorting

and grouping data,using functions, using queries/sub-queries for data

selection, using joins for advanced data selection and also Creating and

maintain indexes for tables.

.

Software Requirement Analysis for AMDOCS Company Project

When requirements are presented to various stakeholders, they understand

them according to their views i.e. the understanding of the requirement is

subjective. The developers implement the product according to their

understanding. Our task is to define a process to identify unexpected

errors/behaviors, implied requirements and remove ambiguity from the

provided requirement set as early as possible in the product life cycle.

3-Tier Web Based System: (Language: J2EE)

Developed a 3-tier web based application. The application contains a front

end web tier using JSP, an EJB tier using both Session Beans and Entity

Beans, and a database tier using Oracle Server

Research Projects: MPAB (Mobile Portal Address Book); Class Imbalances and

Overlapping (Data Mining); Cyber Defense Competition



Contact this candidate