CAREER ABSTRACT

• Offering over 9 years of experience in Project Management and implementation of various object oriented applications in e-commerce, client/ server, web environment and enterprise solutions.
• Proficient in database design and Performance tuning and developing complex T-SQL Queries and Stored Procedures and SQL Functions
• Adept in maintaining the overall operations for executing projects involving scoping, resource mobilization, execution within cost & time parameters.
• Developing clear, elegant, highly functional code; creating attractive and functional user interface; providing advanced technology solutions that boost productivity & efficiency across the organization.
• Possesses invaluable experience of working in multiple technologies across various domains.
• Experience in tools like ColdFusion, PHP, ASP, Javascript, DHTML
• Creating test plans, test cases and test scripts/procedures for carrying out tests of the software at various stages in the SDLC
• Worked closely with customers and consistently won appreciation for work quality
• Experience using VSS, management studio, Visio

CERTIFICATIONS

• MCP (Microsoft Certified Professional) on SQL Server 2000
• Netcharts tool training through Confidential, Seattle, WA (USA)

CORE COMPETENCIES

Project Management

• Understanding business's requirements and mapping them to system requirements specifications.
• Conducting process and system studies and coordinating with team members for system design & integration, application maintenance, etc.
• Delivering and implementing project as scheduled and ensuring compliance to quality standards.
• Incorporating changes/modifications in the project as required.
• Involved in project status tracking, resource allocation and management, test case designing and preparation of check lists as well as conducting tests on software's/ applications.

Database Design

• Database design, performance tuning and troubleshooting SQL Queries and Procedures
• Scheduling database operations as well as writing complex T-SQL queries.
• Monitoring as well as debugging issues in production database for client team.
• Writing Stored Procedures/ Views/ Triggers/ Functions
• Worked extensively on Relational databases (Oracle, SQL Server, Sybase, PostGres SQL, MySQL)

Front End

• Coding Using languages Coldfusion/ PHP/ ASP etc
• Expert in Javascript/ DHTML/ HTML.
• Experience in CFC/ Custom tags/ Coldfusion Administration/ Structures/ Arrays/ Error handling.
• Expert in creating CFC to connect to Webservices.
• Experience using fusebox 2.0, fusebox 4.1, fusebox 5.1 technology and CFWheels

Clients

• Confidential, Bangalore, India
• Confidential, Seattle, WA.
• Confidential(Leadership Training Establishment)(Coimbatore), India
• Confidential, Coimbtaore, India
• Confidential, US

EMPLOYMENT RECITAL

Since Oct'09 to July 2010 with Confidential. for client Confidential as Sr Consultant

Key Deliverables:

• Created software specification template and the database specification template.
• Connecting to web services and get the internal details of employees as xml packets and load to Database
• Creating CFC/ Custom tags/ Error handling
• Implement Database design changes and Create complex T-SQL Queries, Stored Procedures
• Risk analysis

Since Jul'05 with Confidential for client Confidential, Everett, WA as Team Lead

Key Deliverables:

• Coordinated customer meetings and gathering the requirements of the project.
• Held team meetings and discussing the project.
• Generated scripts for the DTS Package to get data from Enovia database and upload the SQL tables.
• Created software specification template and the database specification template.
• Scheduled pages in cold-fusion admin to load data from pop3 mailbox to the database based on conditions specified in the SQL Scripts.
• Handled pages to priorities packages in SQL tables based on SQL scripts.

Nov 01 to May'04 with Confidential, Coimbatore, India as Project Lead

Key Deliverables:

• Met customers for understanding their requirements and working on their projects.
• Managed multiple website design and handling its maintenance.

May ‘00 to Oct'01 with Confidential, Cochin as Module Lead

Attainments:

• Received many customer Instant Recognition Awards from the organization.
• Achieved Pride @ Confidential Award in 2006, 2007 and 2008.

TECHNICAL SKILLS

Web/ Internet Technologies: HTML/ DHTML, JavaScript, CSS, Coldfusion& PHP
Web Servers: Apache, IIS &Coldfusion Server
S/w Dev. Process Tools: Mascromedia Dreamweaver, jRun, Visual Source Safe
Databases: Sybase, PostGres SQL, MySQL & MS SQL Server
Operating Systems: LINUX, Windows XP/2000/NT
Other Technologies: Fusebox Technology 2/4.1/5.1, Netcharts Tool, Microsoft Project, Microsoft Visio, Microsoft Office, Excel & PowerPoint

Expertise

• Utilizing Relational Databases (Oracle, SQL Server, Sybase, and PostGres, VSS, Management Studio, MS SQL & MySQL). Writing stored procedures and triggers and views.
• Drafting complex T-SQL queries, Cursors & creating complex charts using Netcharts Tool.
• Utilizing MS SQL Server Database Management, Database Design and Data Analysis.
• Handling the DTS, Performance Tuning, Backup, Recovery and indexing.
• Looking after the large volume of data (2TB or more) and data transfers.
• Designing Web based applications using ColdFusion 4.5, 5, MX 6.1, HTML and PHP.
• Using Custom Tag, CF Components and Error Handling Techniques.
• Coldfusion Studio, JRun 4.0, Macromedia Dreamweaver, CSS and IIS 6.0.
• Using Java-Script and Fusebox 2.0, Fusebox 4.1 &Fusebox 5.1 Technology.

ACADEMIA

• Master of Computer Applications.
• Bachelor of Mathematics.

Refer Annexure for Project Details

ANNEXURE I

Projects Executed at Confidential:
Duration: Oct'09 to Jul 2010
Role: SrConsultant(LMS)
Tools: MS SQL Server 2000, ColdFusion MX 6.1, Java Script, DHTML, HTML, Dreamweaver, CSS, VSS.
Role: 7 Members
Description:
The LMS Project includes improvements and enhancements to the current Channel Programs Partner LMS process and functionality. It also includes enhancements to Channel Program Operational Reporting & Channel Program General Administration functionality. Currently the LMS, Certification and the General Administration functionality are very labor intensive and error prone

Key Deliverables:

• Database design changes and impact analysis on changes.
• Handling the operations like: database design, table creation & indexing
• Generating SQL Procedures, triggers & views.
• Conducting performance tuning on the queries and procedures.
• Creating the ColdFusion templates and implementing JavaScript Validations
• Writing DHTML and CSS for interactive and visually sophisticated elements to website.
• Writing CFC's for connecting to web services and grab the information

Projects Executed at Confidential:
Duration: May'08 to Apr'08
Role: Team Lead (Mentorship)
Tools: MS SQL Server 2000, ColdFusion MX 6.1, FuseBox 4.1, Java Script, HTML, Dreamweaver, CSS.
Role: 3 Members
Description:
The Mentorship tool will allow people to register as mentors and chose the mentees. Also it has options for mentees to post Article, Conduct Seminars. People can view the seminar and register them selves based on slot availability.

Key Deliverables:

• Coordinating customer meetings and gathering requirements.
• Conducting team meetings and discussing the project reports.
• Handling the operations like: database design, table creation & indexing
• Scheduling the project into modules, and assigning the modules to all members.
• Generating SQL Procedures, triggers & views.
• Co0nducting performance tuning on the queries and procedures.
• Creating the basic fusebox templates for the project.

Confidential for client Confidential, Everett, WA
Role: Team Lead, CSMT
Duration: Jan'07 to Apr'08
Team: 3 Members
Job Skills: MS SQL Server 2000, ColdFusion, FuseBox 4.1, Java Script, HTML, CSS and Dreamweaver
Description:
The CMA statistical metrics tool will give visibility and status of Enovia action data that has been transferred to Confidential and or Partner CMA organizations via the Enovia system.

Key Deliverables:

• Coordinating the customer meetings and gathering the requirements of the project.
• Performing team meetings and discussing the project.
• Generating scripts for the DTS Package to get data from Enovia database and upload the SQL tables.
• Creating the software specification template and the database specification template.
• Scheduling the pages in coldfusion admin to load data from pop3 mailbox to the database based on conditions specified in the SQL Scripts.
• Scheduling the pages to priorities packages in SQL tables based on SQL scripts.

Organisation: Confidential for Client Confidential, Everett, WA
Duration: Nov'06 to Feb'07
Role: Database Administrator
Tools: MS SQL Server 2000, ColdFusion MX 6.1, FuseBox 4.1, Java Script, HTML, CSS, Netcharts and Dreamweaver.
Team: 3 Members
Description:
To reduce the manual labour involved in the IIMR Processing, reducne risk of IIMR data corruption, provide ability to accurately find IIMR data.

Key Deliverables:

• Evolving the stored procedures, DTS package and executing the scripts.
• Looking after the performance tuning of the database.
• Providing technical support to the application developers.

Organisation: Confidential for Client Confidential, Everett, WA
Duration: Jun'06 to Feb'07
Role: Sr. Developer
Tools: MS SQL Server 2000, ColdFusion MX 6.1, FuseBox 4.1, Java Script, HTML, CSS, Netcharts& Dreamweaver.
Team: 3 Members
Description:
The 787metrics tool was developed for engineers and managers to View the charts and data and make decisions on their statistics. It is a tool used in different groups of Confidential to get an idea where they are and what needs to be done.

Key Deliverables:

• Interfacing with the customers & gathering requirements from them.
• Evolving stored procedures, views, triggers, tuning queries & writing complex T-SQL queries.
• Analyzing and resolving the application problems.

Organisation: Confidential for Client Confidential, Everett, WA
Duration: Sep'05 to Aug'07
Role: Developer
Team: 2 Members
Tools: SQL Server 2000, ColdFusion MX 6.1, FuseBox 4.1, Java Script, HTML, CSS and Dreamweaver
Description:
The Interiors website was developed for engineers to upload their charts/ add user and give permissions, edit /delete etc and add the meeting info, upload the meeting files edit the file etc.

Organisation: Confidential for Client Confidential, Everett, WA
Duration: Jul'05 to Feb'06
Role: Developer
Team: 2 Members
Tools: MS SQL Server 2000, ColdFusion MX 6.1, FuseBox 4.1, Java Script, HTML, CSS and Dreamweaver
Description:
The Engineering Liaison website was developed for engineers to access the daily news/ upload their post cards, their activities, the team for a initiative, etc.

Organization: Confidential for Client Confidential, Everett, WA
Duration: Jul'05 to Sep'06
Role: Developer
Team: 2 Members
Tools: MS SQL Server 2000, ColdFusion MX 6.1, FuseBox 4.1, Java Script, HTML, CSS and Dreamweaver
Description:
Developed an automated system to assist in inspecting large production tools in the Confidential Everett factory. There are about 180 of these tools in the Everett factory. The Renton factory is also considering adopting this system. The system consists primarily of a Cold Fusion web application, a SQL Server database, and a set of inspection routine files in PDF format. The inspection routines serve as a checklist and are used for recording measurement data. Each tool has its own individual inspection routine. Users may log in to the system to obtain information about the production tools. Inspectors may log in to the system to check-out or check-in inspection routine PDF files, upload measurement data, or check the status of ongoing inspections.

Project Executed at Confidential, Coimbatore:
Client: Confidential
Tools: MS SQL Server 2000, ASP. Each team consisted of 4 Developers, 1 Team Lead and 1 Designer
Description:
Confidential is a Big Educational Group which has multiple institutes like Confidential Pharma, Confidential Management School), Confidential (Technology School), Confidential Arts and Science. Meetings with all the four group of customers every week to discuss on the multiple website design and later on maintenance. The websites gives an insight to the different activities in the institutions. The professors are able to post articles, message boards, discussion on topics, feedback on discussions, post the results of exam, etc. Students have option to view their marklist, seminar topic selection etc

Projects Executed at Confidential:
Client: Confidential
Duration: Jan'01 to Oct'01
Team: 11 Developers, 3 Module Leads, 1 Team Lead and 2 Designers
Tools: Sybase, Coldfusion 6.1 & JavaScript
Description:
The FulBright Senior Specialist Program website was designed for dissemination of applicant information for review in electronic format by the post and commissions, the Bureau of educational and cultural affairs (ECA/A) and Foreign standards Board.

Client: Confidential
Duration: May'00 to Dec'00
Role: Developer
Team: 6 Developers, 1 Team Lead and 1 Designer
Tools: Sybase, Coldfusion 5 & JavaScript
Description:
Confidential is a one-stop shopping site designed to fulfill entire specialty needs: It offers a huge market place stocked with common items like rice to the most exotic spices and quotes for international travel. The customer adds items to their shopping cart from the browser and can remove them if not needed. The cart is displayed during checkout where they can either checkout the item or delete it Other facilities included a full Search feature, Account Status and Session handling: The shopping cart also allowed the administrator to delete registered users, search for users, view their transactions on a daily basis and check status of shipment.