Post Job Free

Resume

Sign in

Sql Server Project

Location:
Himayathsagar, Telangana, 501504, India
Posted:
July 06, 2015

Contact this candidate

Resume:

Suresh

973-***-****

Professional Summary:

*+ Years of Experience in building both n-tier static and interactive web applications & eBusiness projects using Cold Fusion 7.0/8.0, CFMX, Java, Servelets, HTML, JavaScript, CSS, Oracle 9i/10g, SQL Server 7.0 and ColdFusion Application Server, JDBC, Servlets, JSP, STRUTS.

Good experience in Web Application Development using Cold Fusion Adobe ColdFusion 8, MX 7/MX 6/5.0/4.5 environments .Expert in Web Technologies like HTML, Flash, Flex, Action script, Dream weaver, Microsoft Silver Light, Fireworks, CSS, Photoshop.

Experience in Fuse box Web Application Standards, CFCs and CF Objects.

Possesses strong analytical and technical acumen backed by vast programming and research experience in the areas of application and web development

Experience with user interface development using Flex 1.5/2.0/3.0, Action script 2.0/3.0, Flex API, Flex Data services, MXML.

Extensive experience in programming with Java, Struts, Servlets, Java Server Pages, Java Beans, JDBC, HTML, JavaScript and AJAX.

Experience with Flex data services (Adobe Life cycle Data Services)

Good knowledge and hands on experience with various "Open Source" technologies and programming languages. Specific languages include: COLDFUSION, XML, HTML, CSS, SQL,AJAX and JavaScript

Good Understanding of OOAD and J2EE Design Patterns like MVC, Singleton, Session Façade, Factory, DTO, DAO and Service Locator.

Proficiency in PL/SQL, procedures, packages, functions and triggers.

Involved in good web application security preventing SQL Injection attack.

Extensive experience in Database programming and development using TSQL.

Work experince in building mobile application using Direct show, VC++ environment.

Have complete Software development life cycle (SDLC) Knowledge and experience.

Strong understanding of Multi-Tier Environment and Design Patterns.

Expert at database-driven Web sites using Adobe Flex and configuring with application server ColdFusion, for Intranet/Extranet and e-Commerce applications. Also good in converting existing applications into ColdFusion environment.

Expert in integrating flash files, with files derived from Photoshop and fireworks, to flux environment for achieving exceptional webpage experience and for developing AIR applications.

Experienced in all steps of System Development Life Cycle of web projects, focusing on requirement specification to product release in E-Commerce, Web Applications and Application development.

A results-oriented, focused, skilled professional who understands Information Systems as a means, not as an end. Completes projects with maximum speed, efficiency, and maintainability. Measures personal success by the success of the organization, and seeking and monitoring roles.

Technical Skills:

Operating Systems

Window 98/NT/2000/XP/Vista, Linux, UNIX.

Languages

C, C++, Java, HTML, CFML, CSS,XML.

Frameworks

Fuse Box, MACH II, MVC, AngularJS, Jquery, Struts, Hibernate.

Databases

Oracle 10g/9i/8i, MySQL, MS SQL Server 2008/2012, MS-Access

Web technologies

ColdFusion 3.0/4.0/4.5/5.0, MX 6.0/7.0/8.0,CFC,CFML, FLEX 2.0,3.0,3.0.1, Homesite5, Fireworks, Adobe Dreamweaver CS3,Adobe Photoshop 7.0, FLASH, JavaScript,, Crystal reports, Microsoft Expression Studio, ColdFusion Reports.

XML technologies

XML, XSL, XSLT, SAX, DOM, .

IDE

Eclipse 3.2, Net beans, Jbuilder.

Application Servers

WebSphere 7.1/5.1, WebLogic 7.1/6.1, JBoss.

Web Servers

Apache Tomcat 6.0/5.5, Java Web Server 2.0, IIS.

Version Control

Subversion, CVS, perforce.

Testing

JUnit, JUnit-Perf.

Tools

Developer 2000, crystal reports, SQL Developer, Lite Speed, XML SPY, Rational Rose, XMLBeans.

Educational Profile:

Bachelor’s degree from JNTU University, India.

Professional Experience:

Client: First Data Corp, Omaha, NE Aug 14 – Till Date

ColdFusion Developer

Roles and Responsibilities:

.

Worked with clients to determine project needs and requirements.

Wrote detailed technical requirements documents outlining project requirements.

Created timelines and budgets to successfully complete projects.

Programmed Cold fusion MX modules to handle transactional database queries and builds using interactive data entry forms.

Set up Client environments and created connections in Cold Fusion Admin Server.

Developed and used CFC for handling database activities.

Configured DNS, Web, and email servers.

Involved in design and development.

Developed an application for a client using Cold Fusion, HTML, CSS and JavaScript,

and Angularjs to view the form pages attractive.

Used JavaScript for field validation, form submission, field value updating, and error checking

Designed and developed Cold Fusion web pages according to requirements. The tasks include mainly day to day changes to the above web site.

Implementing Cold fusion projects with Fuse box.

Migrated a part of application, written in Flex as a front end and Access as the back end, to Cold Fusion and SQL

Creating animations on Adobe FLASH, with appropriate script and incorporating with FLEX for exceptional Web Pages and Integrating FLEX applications with COLDFUSION.

Configured Cold fusion for SSL Communication

Developed applications using Macromedia Dream weaver MX.

Developed administration website with built in web securities, activity logs and file administrations, capable of running dynamic content on multiple web sites.

Involved in the developing various Hibernate mapping files; XML configuration, EJB for abstracting business logic and provide dependency-injection in Spring.

Rewrote the stored procedures for increased stability and performance, redesigned tables and views for the same performance gains.

Worked with SQL Server 2012, creating, updating tables.

Maintain backend servers MS SQL 2012, Oracle 9i, and IIS.

Involved in Data mapping and migration process from SQL Server to Oracle Database.

Environment: Cold Fusion MX 6.1, Java, HTML, CSS, XML, Adobe Flash CS6, C++, JavaScript,

Angularjs, Dreamweaver CS6, FLEX, SQL Server 2012, Oracle9i.

Client: Chase Bank, Houston, TX Apr 13 – Jul 14

ColdFusion Developer/Admin

Description: This project was to Develop new applications for standard web browsers and mobile browsers in ColdFusion, which are designed to support various business functions, including distribution center business functions and merchandising activities to support item flow to the store- The Enhancements were to develop replace and rename operations to be done on planograms (which are basically a name given to a group of item in a store) .Replace operation is to change one planogram to another in the store mapping layout for a particular day in future, so that on that day all the item in that particular store location will be substituted with another group of items (by taking care of lot of constrains like store location,space compatibility, transportation facilities etc) . Rename operation is basically an operation designed to change the name of an existing planogram to a more flexible one, mainly intended to help store manager to easily identify the store items. The new application development was accomplished in ColdFusion 8; the project also involved the migration of existing product inventory from ColdFusion 9 to ColdFusion 11, with backend oracle 10g database.

Roles and responsibilities:

Analyzed the project environment and sub systems of the project, and prepared a high level documentation for application designing.

ColdFusion Administrator: set up the environment, data sources and server mappings.

Developed the stored procedures and triggers as per the business logics to present the data to the end user.

Gathered the functional requirements for application.

Responsible for conceptualization, design, layouts and logic flow of the project.

Developed Cold Fusion Components for complex business functionalities.

Developed the required XML Schema documents and implemented the framework for parsing XML documents.

Involved in Unit testing and Integration testing.

Developed ColdFusion Components and custom tags.

Upgrade/migrated current application from CF 8 to CF9.0 version.

Designed the application using OOPs concepts (MVC model)

Installing ColdFusion on different systems (including clustering) and configuring those with appropriate database.

Enabling more security features like RDS and sandboxes.

Creating users for accessing ColdFusion admin server with appropriate rights.

Enhanced existing user interfaces.

Developed the new Custom Tags and CFCs.

Set up Client environments and created connections in ColdFusion Admin Server.

Involved in Data migration from Portal Servers to Excellence Award Applications.

Developed the User Defined Functions (UDF).

Database Maintenance and support for backup Databases.

Involved in Data mapping and migration process from SQL Server to Oracle Database.

Used ColdFusion reports for integrating with websites, also for analyzing data.

Creating animations on Adobe FLASH, with appropriate Asionscript and incorporating with FLEX for exceptional WebPages.

Creating Flex AIR desktop applications, with the use of XML, Photoshop, flash etc.

Integrating FLEX applications with COLDFUSION.

Environment: ColdFusion MX 6.1/8.0, Adobe Dreamweaver CS3, Adobe Flex 3, Adobe Flash CS3 with Action Script 3.0,XML, Crystal Reports, HTML, ColdFusion Reports, Adobe Fireworks CS3, Adobe Photoshop cs3, Java Script, Java, BEA Weblogic, JDK1.4.1, JSP, LDAP, JavaBeans, Servlets, J2ee, Struts, SQL Server 2008.

Tavant Technologies,Santa Clara, CA Aug 12 – Mar 13

ColdFusion Developer

Description: While engaged on internal job Placement Profile(IJPP),IJPP is a web based application developed in ColdFusion and SQL, for the HR department of the company. The application contains records for each and every employee and consultant working with HP. The main aim of the application is to allocate resources from within the organization, i.e. if there is a requirement of a professional in one project and a resource, with almost same skill set as desired, is sitting idle in some other project, then to allocate resource internally instead of hiring a new professional from outside.

Roles and Responsibilities:

Interacting with business users, testing teams, analysts and clients to produce web-based applications using ColdFusion, HTML, DHTML, CSS, JavaScript and SQL Server.

Generating reports on sales and marketing data for business users to facilitate decision making. The reports contain graphical tools like pie charts, histograms, bar charts etc. to facilitate maximum understanding.

Upgrading existing ColdFusion MX code to ColdFusion 9, including the creation and addition of custom CFCs and user-defined functions.

Creating graphics, banners, forms, surveys, and editing photographs for the Web.

Managing ColdFusion Administrator, FTP, and other related Web server functions.

Interacting with clients for gathering requirement.

Used SQL Server 2008 as database for maintaining all the information of employees.

Maintain backend servers SQL Server 2008.

Creating UML diagrams, if required, for better understanding of user requirements.

Coding to transform XML files to Query Objects to meet the backend requirements and transformation of XML documents into WDDX using XSL scripts.

Performing unit, system and user acceptance testing for each of the applications.

Developing the server side scripts using CFML and CFC.

Writing CFML user defined function for all of the applications.

Responsible for client meetings and evaluation.

Responsible for the creation of user documentation for each of the application, and making sure that each documentation is timely updated.

Environment: Cold Fusion 9, Java, HTML, CSS, XML, Adobe Flash CS4, C++, JavaScript, UML

Dreamweaver CS4, SQL Server.

Sparks Network Limited, Atlanta, GA Jun 11 – Aug 12

Cold fusion developer

Description: While Engaged on the AmericanSingles.com Project,American Singles is a singles’ online community dedicated to materialize singles’ needs in a online environment, providing chat rooms, message boards, photo personals, a photo gallery, anonymous private mailboxes, and much more.

Used Rational Rose for developing use cases, sequence diagrams and for the system in UML.

Used FuseBox Methodology.

Interact with the clients and gather the requirements and analyzed.

Managing ColdFusion Administrator, FTP, and other related Web server functions.

Enhanced existing user interfaces.

Used HTML, JavaScript, Ajax, Flash and CSS to create attractive, user-friendly interface to keep track of ATP hardware and software inventory.

Developed administration website with built in web securities, activity logs and file administrations, capable of running dynamic content on multiple web sites.

Set up Client environments and created connections in ColdFusion Admin Server.

Used the features of cold fusion such as cfcs, custom tags, scoped variable, client & session Management, database interaction.

Created programs in Cold Fusion MX and JavaScript to run various tasks such as user validation, parsing, functioning of site and conversion of XML getting user data for mining purposes.

Coding to transform XML files to Query Objects to meet the backend requirements and transformation of XML documents into WDDX using XSL scripts.

Involved in Design and development of POP email and browser based email client.

Develop a Chat Module Forms Using Flex

Developed few custom tags and components.

Involved in database programming. Writing stored procedures.

Configured Cold fusion for SSL Communication

Environment: CFMX, SQL Server 2008, Eclipse 3.0, HTML, CSS, javaScript, VSS, XML, HTML, Ajax, Flex.

ICICI Bank Online India Feb 10 - April 11

Programmer/Analyst

Description: It’s a comprehensive e-commerce application aimed at providing secure twenty-four hour online Banking support. This application primarily consists of modules that provide a consolidated statement of all your ICICI accounts and loan activity, and also used to see which checks have cleared, or review the complete transaction history of any of your accounts, provide functionality for fund transfer between accounts with ICICI Online banking and provide support for all the other ICICI products & services like checking accounts, saving accounts, installment loans, overdraft protection.

Roles and Responsibilities:

Developed interfaces using HTML, JSP pages and Struts Presentation View.

Implemented CMP entity beans for persistence of business logic implementation

Developed and implemented servlets running under WebLogic

Development of database interaction code to JDBC API making extensive use of SQL Query Statements and advanced prepared statement

Was involved in architecture and development of most middle ware components using Struts Framework.

Inspection/Review of quality deliverables such as Design Documents.

Wrote SQL Scripts, Stored procedures and SQL Loader to load reference data.

Interact with end-users to establish requirements.

Implemented business logic using EJBs in the middle tier, developed java beans and helper classes to communicate with the presentation tier, which consists of JSPs, Servlets and Java Applets

Created the security and access level to EJBs and server side scripts

Designed, Implemented, Tested and Deployed Enterprise JavaBeans both Session and Entity using Websphere as Application Server

Query Statements and advanced Prepared Statements

Used EJB session beans to implement business logic and session handling and transactions. Developed user-interface using JSP, Servlet and java script.

Involved in good web application security when the applications are hacking preventing from SQL Injection attack.

Environment: HTML, J2EE, Java Servlets, JDBC, JavaBeans, JSP, Struts, JavaScript, MVC Framework, WebLogic, SQL, Oracle8i, UNIX, SQL 2005.

KELTRON, Trivandrum, India June 08 - Jan 10

Web Developer

Description: KELTRON (Kerala State Electronics development Corporation Limited) is a major manufacturer of wide range of electronic products in India. It is noted as the first government owned companies in India to shift to open source software. The Project involved creation of web pages using basic HTML and CSS.

Roles and responsibilities:

Involved in developing the UI pages using HTML, CSS, JAVASCRIPT, JSON, JQUERY, and AJAX.

Used JQUERY and AJAX for service calls on pages to interact with the server for information.

Involved in Requirement collection.

Fixed all the issues raised by the team. Involved in fixing cross browser issues.

Used SAX and DOM parsers to parse the raw XML documents.

Created Custom UI screens by using XSL and XML data from Quickbase reports.

Involved in constructing HTML pages and forms with appropriate styling.

Created customized user controls and accessibility.

Involved in planning the modules for each area.

Responsible for ensuring the pattern consistency across all pages.

Responsible for overall design, layout, content, interactivity and coordination of the project.

Created client side validations using JavaScript.

Like implemented various design patterns like Module Patterns, Observer Pattern and Name Spacing Patterns.

Involved in design and development of interactions between Model, View and Controller components of the application using the Struts Framework and Design Patterns

Created the ER diagram, designed the Database and related objects connected.

Created SQL queries to perform insert, update or delete operation on MySQL database.

Environment: HTML, CSS, JavaScript, Jquery, AJAX, JSON, QuickBase, XML, MySQL.



Contact this candidate