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