Sql Server Software Engineer

Rama Kulkarni

** ********* ******

Shrewsbury, MA 01545

Home 508-***-**** Home E-Mail: ******@*******.***

Objective

To apply skills gained through education and experience toward a

Principal/Senior Developer position with a progressive organization that

offers opportunities for growth and advancement.

Education

Master of Software Engineering, Brandeis University 2005

B.S in Electronics and Communication Engineering, India

Certifications

Lean Six sigma Foundations Certification

ITIL Foundations Certification

Client/Server Certification Program

Programming Languages PHP, Visual Basic, VBA, VBScript,

HTML, ASP,

PowerBuilder,

JavaScript

Database Oracle10g, Oracle

9i,

SQL Server

2000, SQL Server 7.0,

Software Tools ERWIN, Cognos, Banner

ERP,

Dreamweaver

Report Net

tool, System Architect 2000, E-gain

Operating Systems Windows XP, Sun Solaris,

IBM AIX

Professional Experience

EMC, Hopkinton, MA

Senior Software Engineer

May 2007 - Present

. Worked with other team members

to support all of the Storage

Managed Service global clients

. Responsible for requirements

gathering, design,

implementation, and testing of

solutions on both critical

customer and internal

projects.

. Led database architecture

design for both billing and

charge-back packages for

European clients, eliminating

time-consuming and error prone

manual spreadsheets

. Designed and implemented an

Oracle database package for

backup reporting on the Portal

- this critical project

represents a continued

differentiator for the portal,

and proved to be a major

success.

. Implemented and led database

design for both the hardware

performance reporting as well

as the back office reporting

solutions. As a result of this

project, the back office team

was able to successfully track

the assets of all clients and

provided the site team with

real-time status updates of

the equipment.

Pfizer, Groton, CT

Sep 2006 - Apr 2007

Senior Consultant

. Worked with a team of over ten developers on a Clinical Supply

Distribution System. Created and updated ER diagrams using the

ERWIN model mart.

. Developed various reports and the data dictionary in ERWIN.

. Created the PL/SQL procedures to migrate data from various data

sources into CSDS Oracle 10g database.

. Created auditing tables and triggers. Worked on the design document

and data migration document.

Brown University, Providence, RI

Dec 2001 - Sep 2006

Senior Programmer/Analyst

. Worked on the implementation of the Banner (ERP) student Information

System.

. Responsibilities included customizing Oracle 10g Forms, writing stored

procedures and triggers, in addition to implementing application

security using FGAC.

. Developed reports using the Cognos Reportnet tool and re-designing

self-service applications. The Banner Student System is developed

using the Oracle 10g forms and reports and runs on an IBM AIX 5.2.

. Implemented fsaATLAS software package to comply with the SEVIS project

required by the government for foreign students. Responsibilities

included configuring the system, creating reports, writing stored

procedures, documentation and user training. Trained foreign students

and graduate and undergraduate office personnel in using the system

effectively.

. Designed and developed web applications using ASP, HTML and JavaScript

for the Provost's office in order to maintain faculty and research

personnel conflict of interest forms. Backend database was developed

using SQL Server 7.0.

. Developed Athletic Health Questionnaire System for the Athletic

department to maintain Athlete health information using ASP, HTML and

JavaScript. Backend database was designed using the SQL Server 7.0

. Developed Classlist

application for the

registrar's office to maintain

class scheduling and

enrollment information using

ASP and JavaScript. Backend

database was designed and

developed using SQL Server

7.0.

Trellix Corporation, Concord, MA

Aug, 2000 - Oct, 2001

Web Developer/Database Manager

. Designed and maintained multiple Oracle 8i databases on a Sun Solaris

system. Responsibilities included were database tuning, backup and

database monitoring reports development using SQL, PL/SQL and ASP.

. Proficient in administration of the NetGenesis tool which is used in

analyzing web server logs and corporate and partner reporting needs

. Worked with marketing team in designing the corporate website using

ASP, Photoshop, and JavaScript. Developed and implemented the partner

website using ASP and SQL Server 7.0. Responsibilities also included

designing backend databases using SQL Server 7.0, writing stored

procedures, triggers and performance tuning and backup.

. XML logs were processed using VB 6.0 and SQL Server

. Developed a service request application using ASP and SQL Server 7.0

City Year, Boston, MA

Jul, 99 - Jul, 2000

Database Analyst

. Designed and developed web-based Applicant Tracking database

application using Visual Basic web classes, ASP, SQL Server 7.0 and

HTML

. Responsibilities included were developing web entity relationships,

normalizing the database, building web classes, forms and reports.

Wrote stored procedures as well as SQL queries for retrieving data

from the SQL Server database. Deployed the application on the web

server. The database was accessed through ADO objects, and the user

interface allowed users to add, update, delete and retrieve

information. Developed customized reports using Crystal Reports 8.0.

. Developed an Employee Information database for the Human Resources

group using Access 2000. Wrote system user guide documentation and

provided training to users.

. Designed and developed a web-enabled online registration application

with a back end database for fundraising events using the VB IIS

application, Front Page and SQL Server 7.0. Performed technical

evaluation of web enabled commercial databases for fundraising events.

CMSI, MA

Dec, 98 - Jun, 99

Consultant

. Worked at CVS Corporation as a team member of the pharmacy 2000

project.

. Extensively used System Architecture data modeling tool. Developed an

application to retrieve meta-data from the System Architecture

repository and reports were developed using VB and VBA.

. Retrieved data and populated Access database for adhoc queries using

Access 8.0 and SQL.

Simsoft Corporation, MA

Oct, 97 - Nov, 98

Software Engineer

. Worked on the development of an inventory application for small

businesses to keep track of their inventories and shipping details

using Visual Basic 50 and the Access database.

. Developed passbook account application for savings back using Visual

Basic and Crystal Reports. Responsible for gathering user

requirements, functional specifications, and planning and analysis of

the system. Responsibilities included designing the database,

documentation, user interface and writing stored procedures and

queries.

Contact this candidate