Post Job Free
Sign in

Sql Server Project

Location:
Pasadena, CA
Posted:
January 28, 2013

Contact this candidate

Resume:

Lalitha

Phone: 571-***-****

Email: **********@*****.***

Objective:

Seeking a challenging position in programming or related areas that would

best utilize my expertise gained through experience and education.

Summary of Experience:

V Over 8 years of experience in the full life cycle of the software

design process including requirements definition, prototyping, design,

implementation (coding), testing, maintenance and documentation.

V Experienced in developing applications using HTML, DHTML, JavaScript,

CSS, ColdFusion 5/MX, Java, JSP and Servlets.

V Experience in using/developing ER diagrams, SQL, Stored procedures &

Triggers using RDBMS packages like SQL Server 2000/ 2005, MS Access

and Oracle.

V Experience in using editors like Dreamweaver, HomeSite, and Eclipse.

V Experience in Interacting with clients/users to gather the user

requirements.

V Dedicated hard working individual with ability to solve any type of

assigned problem.

V Excellent written and verbal communication skills.

V Ability to work well individually under pressure, Self-motivated fast

learner, who is consistently responsible and deadline oriented.

Skill Set:

Languages C, C++, ColdFusion 5/MX 8, 9, Java, SQL

Operating Systems Win NT/2000/XP, Linux & UNIX

Databases/RDBMS SQL Server 2000/05/08, MS Access, Oracle 8i, 10g,

DB2

Web Technologies HTML, DHTML, JavaScript, CSS, JSP, JDBC, Servlets

Other Tools VSS, FTP, MS-Office, Dreamweaver, HomeSite,

Eclipse, SVN

Web/App Servers Apache, Tomcat, IIS, ColdFusion and WebLogic

Education:

Bachelors in Computer Science Engineering,

Jawaharlal Nehru Tech University, India.

Project details:

Western Asset Management, CA July 2011- Till Date

ColdFusion/Oracle Developer

Technology: ColdFusion 9, Oracle 11g, Crystal Reports, HTML, JavaScript,

CSS, Eclipse, SVN, Mercury-QC,MVC, Windows XP,BO.

Western Asset is one of the world's leading fixed income managers. From

offices in Pasadena, Hong Kong, London, Melbourne, New York, S o Paulo,

Singapore and Tokyo, the company provides investment services for a wide

variety of global clients, across an equally wide variety of mandates. By

devoting all of its resources to fixed income, Western Asset can provide a

full commitment to clients of all types.

Responsibilities:

> Involved in development, maintenance and enhancements of the

application.

> Involved in software life cycle phases like Analysis, design, coding,

and implementation and testing.

> Wrote queries and Stored Procedures, Dynamic SQL to make the existing

page data-driven.

> Responsible for coding and unit testing.

> Involved in testing the application and bug fixing.

> Involved with user meetings for user requirements.

> Worked on production Issues.

> Worked with BO for scheduling and generating the reports.

> Worked on data CR's.

> Worked on onsite /offshore team as onsite co-ordination lead heading

the team.

> Worked on weekly basis releases.

> Worked on Individual projects like Insurance, Risk Dashboard and

Rating's/

> Worked on Pager Support and batch process jobs 24/7.

OED - SOAP, OR Jan 2011 - July 2011

ColdFusion/ColdBox Developer

Technology: ColdFusion 9, Oracle 11g, ColdBox, HTML, JavaScript, CSS,

Eclipse, SVN, Aptana Studio, MVC,jQuery, Windows XP, Ajax.

As member of the Streamlined Oregon Adjudication Project (SOAP) development

team, collaborates to complete a web application that automates the

adjudication of bi-weekly Unemployment Insurance (UI) claims that are at

variance with the standard requirements for payment.

Responsibilities:

> Designed database structure for the application.

> Developed Application using the ColdBox framework.

> Developed applications using jQuery features like Date Picker, I tabs

and Ajax post back.

> Developed Cascading Style Sheets (CSS) structure for the application.

> Worked on the Security module for the application converting from

cookie-based application to session-based application with security

interface on it.

> Worked on Reports using Report Builder.

> Worked on Stored Procedures, SQL Queries.

> Developed best practice solutions and performed code reviews.

Laser Ship, VA Oct 2009 - Jan 2011

ColdFusion Developer

Technology: ColdFusion MX, SQL Server 2005/2008, HTML, JavaScript, CSS,

Dreamweaver, VSS, Eclipse, MVC,Windows XP, Flash, Ajax, DB2.

Laser Ship is a shipping delivery partner offering the only fully

customized range of delivery solutions. Through innovative technology, in-

depth shipping expertise, and a strong customer focus.

Responsibilities:

> Involved in development, maintenance and enhancements of the

application in ColdFusion using agile methodology.

> Involved building up partner sites to access to the users for a

particular client.

> Involved in fixing production tickets.

> Involved in testing the application and bug fixing.

> Worked on generating reports for the client based on the shipping

/tracking of the packages.

> Worked on redesigning the website from job level to package level.

> Responsible for development and maintenance of the intranet website.

> Worked with SQL Server and DB2 databases.

> Responsible for a creating a new website where information about each

package, client can be tracked in ColdFusion.

NIH/NIDA, MD May 2009 - Sep 2009

Program Analyst

Technology: Oracle 10g, ColdFusion 8, ERwin, Eclipse, Toad, Canoo Web test.

The CMIS is used to manage The National Institute on Drug Abuse's (NIDA's)

extramural contract portfolio. CMIS is a new system that replaces two

previous systems: NIDA Contract Information System (NCIS) that was used to

manage pre-awarded contracts; and the Contracts Administration Tracking

System (CATS) that was used to manage awarded contracts. The functionality

from these systems has been incorporated and enhanced into CMIS.

Responsibilities:

> Analyzed the Database, prepared database documentation through ERwin

Data Modeler Tool.

> Used Toad to access and analyze the database.

> Clean up of the Database and built Relationship between tables.

> Design of ER diagrams to Database.

> Modifications for the ER diagram (creating relationship, normalizing

the database adding comments to the database tables)

> Implementing the ER model changes to the Development and Test

Environment.

> Creating Data Dictionary for the Database.

> Created test scripts for test the application using Canoo web test.

CMS-RACDW, MD May 2008 - Apr 2009

ColdFusion Developer

Technology: ColdFusion MX 8, SQL Server, Oracle 10g, HTML, JavaScript, CSS,

Dreamweaver, VSS, Windows XP, EXTJS, MS Access and Fuse Box.

RACDW is an application to identify improper payments for a claim and save

hundreds of million for CMS. For 2007 RAC identified overpayments of around

$ 357.2 million and underpayment of $14.3 million. Agile (TDD) based

project development methodology used in this project.

Responsibilities:

> Involved in development, maintenance and enhancements of the

application.

> Involved in analysis, development, and implementation of new RAC

module for CMS in ColdFusion.

> Involved in software life cycle phases like Analysis, design, coding,

and implementation and testing.

> Used VSS as version source control.

> Used Fuse box version 5 for MVC Architecture.

> Wrote queries and Stored Procedures to make the existing page data-

driven.

> Worked on DTS Packages to export data from the database.

> Responsible for coding and unit testing.

> Involved in testing the application and bug fixing.

> Responsible in modifying a tracking tool for the project.

> Responsible for documenting the database dictionary.

NYK Logistics, TN Jan 2008 - May 2008

LTL Rater

ColdFusion Developer

Technology: ColdFusion MX 7/8, SQL Server 2005, ColdBox, MVC,HTML, DHTML,

XML, JavaScript, Flash, Flex, CSS, VB, Dreamweaver, EXTJS, PHP, Oracle 10g,

DB2, Ajax, Flash, Web Sphere, Web Services and Windows XP.

LTL Rater is a function of the TMS system that allows the rating and

creation of LTL shipments. It offers an interface into the LTL Quote system

that allows both internal users and customers to view LTL rating

information, given specific shipment criteria.

Responsibilities:

> Involved in development, maintenance and enhancements to the

application.

> Played an active role in all stages - requirements gathering, analysis

and design, development, testing, debugging and fine-tuning.

> Developed/Modified front end UI using HTML, DHTML, EXTJS and CSS.

> Developed the client side validations using JavaScript and Ajax.

> Worked on DTS Packages to export data from the database.

> Developed and used ColdFusion components and Custom tags.

> Worked with CMS Common Spot.

> Developed/modified many complex reports.

> Used Flash for interactive and dynamic web pages.

> Involved in Integrated Testing and System Testing

> Used ColdBox framework for MVC Architecture.

> Concurrently worked on Tickets and Release in to production.

> Used VSS for source control.

> Used UML for designing and documentation.

Joe Pix, FL Aug 2007 - Dec 2007

Programmer

Technology: ColdFusion MX6.1, JavaScript, CSS, MVC,Oracle, jQuery, Perl,

PHP and MS Access.

Involved in design, development of small business websites, which

implemented business plan and E Marketing Solutions, for setting prices and

accounting. The web sites were mainly designed using ColdFusion and PHP.

The pages were mainly database driven pages and were basically managed by

SQL Server and MS Access.

Responsibilities:

> Developed and Maintained personal and small business websites using

Macromedia ColdFusion, PHP, HTML and JavaScript and Perl script.

> Modified existing PHP pages to ColdFusion WebPages.

> Handled the tasks of developing and creating PHP MYSQL applications as

per the specifications.

> Assigned the responsibilities of troubleshooting problems with PHP and

other web technologies.

> Coordinated with team members in developing database structure.

Real Tech Pvt Ltd Jan 2005 - Jan 2007

Technology: HTML, ColdFusion, DHTML, XML, JavaScript, Ajax, CSS, SQL Server

2005, Oracle, DB2, PHP, Fuse box, Perl, jQuery, Photoshop, CMS,

Dreamweaver, Eclipse.

As a Programmer in the development team, was responsible for developing a

hospital web page module which included updating the daily schedules of

doctors and the ability to change it online if they have to attend an

urgent case so that all the other hospital branches located at different

places can have access to information on a given doctor's schedule at any

instance.

Responsibilities:

> Developed the application based on HTML, ColdFusion and CSS,

technologies.

> Used Ajax for server side validations.

> Developed the application based HTML, PHP technologies.

> Used Content Management System for documentation.

> Encapsulated business logic using components at different scope

levels.

> Developed Client side validations, using JavaScript.

> Prepared documentation for future references and updates.

Stanford Solutions Hyderabad, May 2002 - Dec 2004

India

Citizen Card System

Programmer

Technology: HTML, Java, Servlets, PHP, SQL Server, Perl, Oracle, Tomcat and

JavaScript.

The Project 'Citizen Card System' gives us the information about the

citizen in any country. A Citizen has unique Id to find out the personal

information in each and every department or service wherever a citizen

goes. This information can be found out by the unique Id of the citizen. If

any citizen wants to utilize the services or utilities by the Government or

Private organizations, he has to go to each and every department with

different Id for that particular department. Instead, a citizen card helps

in having all the utilities and services under one unique Id.

Responsibilities:

> Involved in web pages designing using HTML, PHP, JavaScript, Perl,

Java, Servlets, coding and implementation.

> Analyzed the project, prepared status reports and documenting the

project.

> Communicated with clients to meet up with their requirements.

> Designed, developed, coded, tested and debugged system requirements

for the purpose of conversions and development projects.

> Analyzed the project, prepared status reports and documenting the

project.

> Actively interacted with the users in the design and implementation

phases of project.



Contact this candidate