Post Job Free

Resume

Sign in

Sql Server Project

Location:
Latham, NY, 12110
Posted:
August 22, 2011

Contact this candidate

Resume:

VENKAT

732-***-****

Certification

Brain Bench Certified in ColdFusion 4.0/4.5

Summary

. Around 14 years of experience in the analysis, design and development

of client/server, E-Commerce, B2B and B2C applications using

ColdFusion 4.0/4.5/5.0/MX, ASP, and Java.

. Extensive User Interface (UI) development experience with ASP,

ColdFusion, Java, JSP, VB Script, Java Script, XML, XSL, XSLT, Visual

Basic, Visual Interdev, HTML and Developer 2000.

. Expertise in developing and deploying the applications on I-planet web

server, Apache Tomcat Web Server,Jboss,Internet Information Server

(IIS), and ColdFusion Application Server.

. Expertise in creating the data sources, configuring the mail server,

setting the ColdFusion development environment using ColdFusion

Administrator.

. Experience in setting up the Session, Application Variables and

Cookies.

. Expertise in ColdFusion Verity Search Engine, CFCOLLECTION, CFSEARCH.

. Implemented Search Feature using both ColdFusion Administrator and

also using tags.

. Extensively worked with ColdFusion custom tags, CFQUERIES, CFLOOPs,

CFTRANSACTION, CFLock and CFHTTP.

. Extensive Knowledge of advanced ColdFusion, Allaire Spectra and

ColdFusion Fuse Box Methodology.

. Solid working knowledge of RDBMS including SQL Server, MS Access,

Sybase and Oracle10g/9i/8i/7.x.

. Hands on experience with ActiveX, DAO, RDO, ADO, DTS Package, Crystal

Reports, COM and DCOM.

. Knowledge of Techniques such as Object Linking and Embedding (OLE),

Open Database Connectivity (ODBC), Application Programming Interface

(API) and Dynamic Link Libraries (DLL's).

. Well versed with Full Project Development Life Cycle (SDLC)

. Worked with developers and users to research and document existing

business and system processes.

. A self-starter, team player, worked on fast-faced development

environments committed to the deliverables.

Education: BS in Computer Science from Gulbarga University, India

Technical Skills

Languages: SQL, Transact-SQL, C, FORTRAN, COBOL, Java 1.2/1.4,J2EE

Web Technologies: HTML, XML, XSLT, DHTML, JSP, ASP, and ColdFusion

4.0/4,5/5.0/MX,VBScript,JavaScript,Ajax,Ext JS,Jquery and

Visual Interdev

6.0, IIS 4.0, PWS, Apache, IPlanet,Jboss

Tools: Crystal Reports and Macromedia

Dream weaver

GUI: Visual Basic 5.0/6.0, Developer 2000

RDBMS: Oracle 7.x/8.x/9i/10g, SQL Server 6.5/7.0/2000, MS Access

Operating Systems: Windows 95/98/NT/2000, MS DOS, HP-Unix

Hardware: Pentium, IBM PC Compatibles

Advanced Technologies:AJAX,ExtJS,Jquery,CFXTAGS,WDDX,ActiveX, COM/DCOM

Professional Experience

Client: GE Corporate Tax Albany, NY

Jan'09-Tilldate

Description:

Virtual File Room(VFR) is the part of GE Corporate Tax systems. The Virtual

File Room combines the four GE tax collections which store entity and

business related documents created for the preparation and filing of

the various jurisdictional returns.

Responsibilities

. Involved designing Application, Database design, Architecture and

drafting technical specifications for new applications.

. Converting the business requirements into technical specifications.

. Seamlessly integrated different environment applications to VFR.

. Code Components (CFCs) for reusable code and interaction with business

logic / database.

. Working with Security Program (LDAP) and Implementing within Cold Fusion

applications.

. EXT JS is used for Bulid the reports using JSon Grid.

. AJAX is used for auto select using search the data.

. Jquery is used for Bulid the tool up on Data Grid

. PL/SQL Developer used for writing stored procedures, optimizing and

tuning the queries for better performance

. Extensive use of Java Script, DHTML and Style sheet to improve the

presentation layer as well as front-end validation etc

. Involved in integration testing, user-acceptance testing, Application

profiling, System Maintenance

Environment: Macromedia Cold Fusion Application Server 8/9, Macromedia

Dream weaver 8, CFEsclipse,CFML, CSS, FrameWork1,JavaScript, Ajax, Ext JS

3.0,Jquery,LDAP, Oracle 10G,Excelwriter, PL/SQL Developer

Client: GE Corporate Tax Albany, NY

Aug'06-Dec'08

Description:

VAT Reporting Toll is the part of GE Corporate Tax systems. VAT is a tax

charged any supply of goods or services made in the country. Where it is

taxable supply made by taxable person in the course or furtherance of

business carried on by him on the acquisition of goods into the EU from

other member states of the EU and on the importation of goods into the same

country.

Responsibilities

. Application support team in analysis of production level issues

. Involved designing Application Architecture/Frame work and drafting

technical specifications for new and existing applications.

. Custom tags are used to allow reference to reusable code.

. Code Components (CFCs) for reusable code and interaction with business

logic / database.

. Working with Security Program (LDAP) and Implementing within Cold Fusion

applications.

. Excel writer used for generate customized excel reports.

. CFAJAX used for combination JavaScript and http request.

. PL/SQL Developer used for writing stored procedures, optimizing and

tuning the queries for better performance

. CVS (Tortoises 1.104) version control is used for keep track of version

control for change mana ment system.

Environment: Macromedia Cold Fusion Application Server 7/8, Macromedia

Dream weaver 8,CFEclipse, CFML, CSS, JavaScript, Ajax, Jquery, EXT JS,

LDAP, Oracle 10G, PL/SQL Developer,CVS version control

Client: Internationalsos, Philadelphia, PA Feb'06-

Aug '06

Project: www.Internationalsos.com

Description: International SOS is the world's leading provider of medical

assistance, international healthcare, security services and outsourced

customer.

Responsibilities

. Involved designing system architecture and drafting technical

specifications for new and existing applications

. Code Components (CFCs) for reusable code and interaction with business

logic / database.

. Used XSL for converting XML to HTML pages for presentation.

. Assist Application Support Team in analysis of production level issues.

. Error Handling and performance the applications.

. LDAP Server is implemented to login authorization and authentication

using CFLADAP for Company employee Directory.

. Stored procedures used for the inserting or updating data the in database

through CF stored procedures

. Crystal reports are used for report generation using front end CFML

Environment: Macromedia Cold Fusion Application Server 6.12, Macromedia

Dream weaver 2004, CFML, CSS, JavaScript, XML, XSL, LDAP, .net, IIS

5.0,Windows XP, SQLSERVER-2000/2005,

Client: UBS Financial Service, Weehawken, NJ Mar '05-Dec'05

Project: UNIFORM/UNITRACK/EMPLOYEE RISK SYSTEMS

Description: All These systems are secured intranet applications on UBS

Financial Services and these systems were well designed and built to fast

track the efficiency, control and management of the Legal and Compliance

policy forms. These Systems deliver a self-service rendering of the forms

and allow the client to complete the information in a timely fashion. These

Systems replace the need for paper-base forms. Based on regulatory changes

in the Securities industry, this system was introduced to allow rapid form

generations for the collection of data about an employee.

Responsibilities

. Involved All Applications Migrated from Windows NT to Unix System.

. Working with new enhancements, code fixing and maintenance work on

CFML Pages.

. CFX tags and Custom tags are used for Authentication and Securities

for the System login.

. Involved in conversation the code from ASP pages into CFML pages using

Macromedia Dream weaver.

. PVCS Version control is used for keep track of version control for

change management system.

. WS_FTP is used for FTP to upload and down load the data from Secured

application.

. Creating Views for Oracle Discoverer to generate reports and publish

information to End User.

. SQL Navigator used for Creating Views, Packages, and writing Stored

Procedures.

. Used XSL for converting XML to HTML pages for presentation.

. Error Handling and performance the applications.

. LDAP Server is implemented to login authorization and authentication

using CFLADAP for Company employee Directory.

. RoboHelp used for create on help system and generation of on line

manuals.

Environment: Macromedia Cold Fusion Application Server 5.0/MX, Macromedia

Dream weaver 2004, Macromedia RoboHelp X5, CFML, CSS, JavaScript, XML, XSL,

SQL Navigator 4, LDAP, ASP, Oracle 9i, IIS 5.0, I-Planet web server 4.1,

Windows XP, Sun Solaris 2.8, PVCS, Oracle Discoverer and WS_FTP Pro

Client: NY State Government, New York, NY Nov '04-Jan '05

Project: HRDW/ MTA-MNR

Description: This site is secured intranet data warehousing application on

Metro North Railroad Company. HRDW contains payroll information and HR

information and these information access only internal users for the

company and authorized employee's for the company. This application is

divided in to three categories and it contains each employee personal

information, wages, salary and vacation allocated

Responsibilities

. Designing the frame structure and coding using micro media dream waver

. Client side validation using JavaScript and server side validation

using CFML

. Stored procedures used for the inserting or updating data the in

database through CFStroedproc

. Generating the reports in Acrobat reader and Excel sheets using front

end CFML

. Crystal reports are used for report generation using front end CFML

. TOAD editor used for creating views, tables, stored procedure for

oracle 9i

. Used XSL for converting XML to HTML pages for presentation.

. Error Handling and performance the applications

. LDAP is implemented for login authorization and authentication for

secure web site.

Environment: Macromedia Cold Fusion Application Server 5.0/MX, Macromedia

Dream weaver, CFML, CSS, JavaScript, XML, Toad, LDAP, Crystal reports

8.0/9.0, Acrobat reader, Excel, Oracle 9i, SQL Server2000, Windows 2000,

IIS 5.0

Client: SBC, St. Louis, MO May '03-Oct '04

Project: WFA Billing

Description: This site is secured intranet-billing application on

Southwestern Bell Company. A WFA billing program gathers billing and rebate

information from mainframe applications. This information is then processed

by Issuing additional charges and the rebates into the appropriate

mainframe applications. These charges and rebates are performed after a

service is provided to a customer and can be delayed several days before

running without causing loss of revenue or customer dissatisfaction. This

WFA Billing suite of Applications has been slated for 13 state deployments

with all four regions Southwest, Midwest, West, and East.

Responsibilities

. Designing and Coding CFM Pages using Cold Fusion Studio 5.0/MX

. Tuning and performing the large volume quires using oracle8i

. Designing the frame structure using micro media dream waver

. Monitoring and deploying the coldfusion application using site mover

. Client side validation using JavaScript and server side validation

using CFML

. DTS (Data Transformation service) package used for load the feeds form

FTP to SQL Server database

. Stored procedure used for to load the daily feeds and monthly feeds

form ftp to SQL server database

. Converting the data from SQL server database to Oracle database

. Creating Security policies for secure development using ColdFusion

Server

. Configuring ODBC data source, maintain the schedules running

applications in ColdFusion Application Server 5.0/MX

. Maintenance of the Database including Backup/Restore, and Database

Maintenance Plan

. Generate reports using third party tool as crystal reports with CFML

tags

. Used XSL for converting XML to HTML pages for presentation.

. LDAP is implemented for login authorization and authentication for

secure web site.

. Used Eclipse IDE to develop JSP and java classes.

. Developed Java Application to insert data into Mainframes and oracle

databases.

. Worked with CVS for version controlling.

. Developed the Java Utility Classes.

. Involved in Migrating coldfusion to JSP pages.

. Worked on Tiles in developing the JSPs. Used a layout in combining the

JSPs according to their wire frame appearance

. Implemented Log4j for all classes to set debug levels on production.

. Involved in unit, integration and User Acceptance testing phases

Environment: Macromedia Cold Fusion Application Server 5.0/MX, Macromedia

Dream weaver, CFML, CSS, JavaScript, Oracle 8.x, SQL Server 2000, SQL

server enterprise manager, Crystal reports 8.0/9.0, Windows 2000, HPUnix,

IPlanet web server 6.0, XML, XSL, Apache Tomcat 4.1, Java, JSP, JDK1.3.3,

Eclipse 3.0, Log4J

Client: ReisReports/Reis.com, NY Apr '00-Mar '03

Description: This site is a comprehensive resource for commercial real

estate trends, analytics, market research and news. It supports

transactions by real estate professionals involved in the buying and

selling of office, industrial, retail and multifamily properties throughout

the U.S.

Responsibilities

. Designing CFML pages, coding and testing

. Writing queries by joining multiple tables

. Using dynamic queries to populate required data (search screens)

. Coding CFM pages using ColdFusion Studio 4.0/4.5

. Performing validations using server side scripts (CFML)

. Performing Integration testing, System testing, Functionality testing,

data validation testing and carried out User Interface Testing

. Determine gaps between current processes client/Server and new

requirements web applications

ReisReports/Reis.com (Continued)

. Handling the transactions and maintaining the integrity of Oracle

tables from CFM pages using CFTRANSACTION tag

. Populating dynamic list boxes using CFLOOP tag

. Declaring variables through out the application using CFAPPLICATION

tag

. Implementation of user tracking module for Reistranet System

. Generating reports in HTML and exporting the same to Excel and PDF

file formats

. Client side validation using JavaScript

. Development of online help using JavaScript

. Creating third party components using Visual Basic

Environment: ColdFusion 4.0/4.5, CFML, CSS, JavaScript, Oracle 8i, SQL

Server 2000, Visual Basic, Microsoft jet 5.0, Windows NT, Unix, Apache

1.3.6 and IIS.

Client: Skill Bay Inc

Troy, MI Aug '99-Mar

'00

Description: This is a web-based, data-driven E-Commerce application for

placement services. Its unique e-services include e-requirements posting,

e bidding, e-interviews, e billing and e-payments - to name a few. Users

and Providers of IT staffing meet engage and manage the entire process,

start-to-finish, via the web. Features of the language such as database

integration, custom tags, mailing, error handling, scripting, encryption,

regular expressions; user authentication, stored procedures and session

management were used in this project.

Responsibilities

. Development, testing and implementation of Candidate, Requirements,

Alert, Interview and E-mail modules

. Table design, analysis, development and implementation of a

customizable interface for sending and receiving emails, mass mailing

and generating detailed reports

. Writing program specifications, unit testing and system testing

. Internal quality assessment audits

. Content Management for alerting the users regarding changes in the

system's content

. Production Support

. Development of a ticketing system for monitoring the status of raised

tickets

. Client-side validation using JavaScript and Server-side validation

using CFScript

Environment: ColdFusion 4.5, HTML 4.0, JavaScript 1.2, Windows NT/98,

Sybase

Client: MIC Electronics, India Aug '98-Jun '99

Project: Payroll Management System

Description: Yashoda Hospitals is one of the biggest corporate Hospitals in

India located at Hyderabad of Andhra Pradesh. This is aimed at

computerizing Human Resource Development needs for easy transactions of

their accounts. This prototype is primarily designed for maintaining the

department wise details of employees and their dependants. This module

keeps track of the employee and his/her dependants for maintaining the

perquisites enjoyed by the employee as per the company's policy such as

children's educational allowance, medical allowance and Leave Travel

Concession.

Responsibilities

. Development of monthly pay stubs for temporary and permanent employees

. Creating employees tables for each department

. Design and development of the front-end screens for maintaining

transactions

. Writing code to bridge data between the loan statements and payment

modes

. Retrieving data from the database using Remote Data Access method(RDO)

. Developing reports like attendance, leave availability etc

Environment: Visual Basic, Oracle 7.3, Crystal Reports and Windows NT

Invoicing System (11/97 - 7/98)

Description: MIC Electronics is one of the display board manufacturing

companies in India located at Hyderabad of Andhra Pradesh. Main goal of

this project is computerization of billing system. This system is

integrated with the Accounts Receivables module. The System maintains the

details of Customers, Products and Orders etc. The System has an

additional module; the Pricing Module, where the data related to prices and

discounts are stored in tables instead of hard coded values.

Responsibilities

. Development of the Invoicing module and Pricing module

. Developing the GUI screens for maintaining the transactions

. Maintaining the User-Level validations in order to reduce the load on

the Server

. Creating Templates for frequently used Forms

. Writing Code to bridge data between the Invoicing and AR modules

. Using data access methods like the DAO for retrieving data from the

database

. Creating tables, setting up relationships between them and also

maintaining the data integrity

. Connecting different forms using the multiple document interface

concept and menus. The Screens involved various windows Intrinsic

controls like the Label, Textbox, Command buttons etc. and also custom

controls like the DB Grid, DB Combo box and DB List box

. Development of Invoice reports and Item Preference reports

Environment: Visual Basic 5.0, MS Access 7.0, Crystal Reports, Win 'NT

Material Management System (12/96 - 10/97)

Description: MIC Electronics is one of the display board manufacturing

company. Main goal of this project is computerization of material

management. This software deals with materials required, ordered,

available on hand and items produced apart from maintaining purchase orders

and sales orders. This system has three Main modules viz. Masters,

Transactions and Reports. Master module maintains details of items,

customers and suppliers. Transactions module takes care of purchase orders

and sales orders whereas reports module generates various reports for

daily, monthly and yearly transactions.

Responsibilities

. Development of Master and Transactions module

. Developing the GUI screens for maintaining the transactions

. Writing programs to exchange data between the master and transactions

module

. Creation of GUI screens for maintaining transactions

. Developing daily, monthly and yearly transaction reports

Environment: Oracle 7.x, Developer 2000(Forms 4.5, Reports 2.5), Windows 95



Contact this candidate