Oracle Project

AVINASH KAZA

CAREER DIRECTION

I am seeking to secure a challenging position in IT/Software related industries with an emphasis on new business

development. I am seeking a firm to join that values technical expertise, seeks employees who are innovative and

have a strong desire to use all their skills to make a value added contribution in a short time frame.

PERSONAL PROFILE

• More than 8 years of IT experience in various areas (Project Management, Application Development,

Database Administration, Marketing, Customer Support and Training).

• Coordinated with a variety of campus representatives, from the university presidents to the building

maintenance staff for 25 different institutions as part of Higher Education Facilities Information System (HEFIS)

project.

• Extensively used Flex, AJAX, ColdFusionMX and J2EE to develop Object Oriented data driven secure

websites providing multiple levels of access, visibility, monitoring, and control on Oracle 8i/9i/10G and other

backend databases.

• Using eXtreme Programming for the past 2 years and mentored a team in the popular agile software

development technique.

• Worked with a team of 24 using Scrum Methodology

EDUCATION

Master of Business Administration (part time) December 2007

West Virginia University, Morgantown, WV

Master of Science in Engineering December 2004

West Virginia University, Morgantown, WV

BS in Mechanical Engineering June 2002

MVSR Engineering College, India

Diploma in Advanced Software Technology June 2002

CMC, A government of India Organization

OCCUPATIONAL EXPOSURE

Flex Team Lead, Contracting for Infospherix (Part of ActiveNetwork), in a team of 6, with Agile Scrum

and eXtreme Programming Methodologies October 2008 to Present

Duties/Responsibilities:

Working on a Flex application which will be used by state and county employees to schedule reservations at their

parks and other recreational facilities.

Using Pure MVC frame work in Service Oriented Architecture with ColdFusion and .Net providing the web services

Flex Developer, Contracting for Davita Inc. in a team of 24, with Agile Scrum Methodology

March 2008 to October 2008

Duties/Responsibilities:

Lead development of Document Management for the entire platform which comprises of couple of web based Flex

Applications. Develop bridging applications between client based, already existing applications and the web platform.

• Developed an AIR app which connects to the server periodically, retrieves and print PDF reports on client side

without any user interaction

• Used adobe JavaScript to fill Adobe LiveCycle forms from Flex applications

• Implemented a message interface between Adobe PDF and Flex using JavaScript and Flash external

interface class

***********@*****.*** 19544 Crystal Rock Dr

Cell: 304-***-**** Apt # 14

http://flexpdfair.blogspot.com/ Germantown, MD 20874

• Designed a flex app which can activate a scanner (or any twain device), get the image file and upload

to the server as a PDF document

• Integrated into the custom designed architecture which was created on top of the Adobe Cairngorm

Framework

Team Lead, WV Higher Education Policy Commission (HEPC) for Higher Education Facilities Information

System (HEFIS) project April 2005 to March 2008

Duties/Responsibilities:

Expand the usability of the HEFIS system by understanding and developing what the customers need in order to do

their job more efficiently and to make modules which will take care of reporting functions the HEPC performs for the

legislature and the governor’s office

• Designed and lead the development of MVC architectured enterprise applications using ColdFusion and Flex

for the state higher education institutions

• Followed best practices and design patterns by developing object oriented code through the use of

ColdFusion Components (CFCs), components, and custom events

• Used eXtreme Progamming methodology for Rapid Application Development along with UML in a team of 4

developers

• Adopted an Event driven loosely coupled component architecture for Flex development design

• Maintained the code base on Subversion (SVN) and used Eclipse IDE with SVN for team development

• Followed the philosophy of write the tests before the code by developing tests using CFUnit and other

automated testing software like Selenium

• Developed ColdFusion application to convert Google’s Geo Lat Long coordinate system to WV GIS’s UTM

coordinate system and shared the code with other state and federal agencies like WV Conservation Agency

(http://hefis.wvnet.edu:8080/gis_28.cfm)

• Used advanced ANSI SQL code in order to keep the application code free from being database dependent

• Developed Perl scripts to convert the raw data coming from institutions and load it into oracle database

• Designed and developed equipment module and work order system using Flex 2.0 and plugged it into the

core application as optional modules for campuses to use

• Designed and lead the development of brand new UI using Flex 2.0 for the core modules of the application

with ColdFusion being the data providing business tire with Oracle being the backend database

• Developed a building safety reporting module with Flex UI and ColdFusion as business tire, generated

dynamic PDFs as part of the reporting system

• Developed a state wide financial appropriations module for the institutions to request for budgets for projects

from the state budget office, effectively used the automatic PDF generation through ColdFusion business tire

Accomplishments:

• Automated all the procedures for state budget requests and saved significant work for campus

representatives and gave them a place to save and track their projects

• Reduced the man power requirements of campuses by giving managers the ability to see their facilities on

their computers, floor plans and aerial views (http://hefis.wvnet.edu:8080/gis_28.cfm) in addition to data

• Provided tools and interfaces for registrars and academic decision makers to analyze their short comings in

scheduling and using their facilities efficiently

• Enhanced the ability to make financial decisions with a variety of reports created to see academic utilization,

vehicles and housing reports for years 2005, 2006 and 2007

URL for Public Reports Website: http://hefis.wvnet.edu:8080/

Technologies used: Flex 1.5/2.01 on Event Driven Architecture, ColdFusionMX 7/8, CFUnit, Selenium,

J2EE on OC4J, AJAX, XML, SVN, Acrobat JS, Adobe Action Script, Perl, Oracle 8i/9i/10G, Oracle SQL

Loader, IMP, EXP, AutoCAD, eXtreme Programming, UML, RAD, CSS, HTML

Team Lead for Higher Education Facilities Information System (HEFIS) project, which in its initial stages was

run at West Virginia University funded by the Chancellor’s office April 2003 to April 2005

Duties/Responsibilities and Accomplishments:

Design of an efficient database, which can hold the facilities information (Buildings & Rooms & Vehicles & Housing)

and course schedule information of all higher education institutions in the state of West Virginia. Development of a

website with the ability to search, make real time alterations and output reports at institutional and HEPC levels.

• Designed an MS Access database with user-friendly forms (developed in VBA) for data population, to be used

by the data acquisition team

• Developed the application to interlink the course information with facilities information to get a wide variety of

useful utilization reports and graphs at different levels

• Migrated multiple Access database files and merged into a single Oracle database

Technologies used: ColdFusionMX 6/7, J2EE on OC4J, AJAX, XML, SVN, AWK, Oracle 8i/9i, Oracle

SQL Loader, IMP, EXP, Oracle Migration work bench, MS Access VBA, AutoCAD, RAD, UML, CSS, HTML

Database and Web Administrator, Facilities Information System’s TMA and ISD

Duties/Responsibilities and Accomplishments:

This project used TMA Systems, to track and maintain work orders for WVU online

• Worked on setting up TMA clients and TMA databases on windows machines

• Installed TMA Internet Service Desk and administered it for WVU

• Added code to Internet Service Desk pages to let ISD users go into the HEFIS site and see the

schedules, drawings and/or reports

• Enabled ISD users to add, edit or delete buildings and rooms in the HEFIS database

• Migrated two TMA databases from an SQL Server to Oracle9i using TMA’s e-tools and Oracle Migration

Workbench

• Saved $125,000 annually to physical plant budget by reducing TMA user’s time by connecting them to

a wealth of HEFIS information on a single interface

Technologies used: ColdFusionMX 6/7, XML, ASP, SVN, MS SQL Server, Oracle 9i, Oracle SQL Loader,

IMP, EXP, Oracle migrations work bench

Key Control Management System (KCMS) Developer, Facilities Information System

Duties/Responsibilities and Accomplishments:

This project aimed at facilitating the building supervisors in WVU to access the on-line keys database. Developed a

web based application to assign, un-assign keys to students and faculty, based on room and key number.

Technologies used: ColdFusionMX, MS Access

Note: Experience listed above shows only the most applicable projects

Thesis Related Works

• Used Crystal Reports 9 to plot graphs to depict the failure of a composite material on application of tensile

load. The source data for the graph was an excel file made by a data acquisition system named LOCAN AT

• Wrote four independent AWK scripts for converting experimentally collected raw data into an input matrix to a

neural network program. To relieve future users from possessing the knowledge of syntax to call AWK scripts,

developed a C program that takes experimental inputs from user, calls relevant AWK scripts, passes variables to

them and saves the output neural network matrix by a name specified by the user

• Worked with Wireless Sensor Networks using MICA MOTES hardware and TINYOS operating system and

applications like TINYDB and TASK

Patents and Copyrights

• Applied for a Patent for the method created to show layers on pdf floor plans based on the room types,

utilization hrs and mapping equipment on to floor plans

• Obtained copyrights for the code developed for HEFIS project, REG: Txu1-150-050, Txu1-182-953

Awards and Commendations

• Won the 2007 West Virginia State Technology award for “Innovative use of Technology”

• Was awarded Certificate of Appreciation for Professional Excellence in Educational Presentation as WV APPA

conference in 2006

• Received recognition for presentation at South East Regional Association of Physical Plant Association

(SRAPPA) 2004 conference

• Received commendation from the then WV HEPC Chancellor Dr. J. Michael Mullen for my work as a graduate

assistant at WVU

TECHNICAL SKILLS

Web Designing : HTML, DreamWeaver MX, Flash MX, Eclipse, Flex Developer

Web Application : ColdFusion MX 6.0/6.1/7.0, J2EE, .NET Framework, Flex 1.5/2.0

Servers

Databases : Oracle 8i/9i/10g, MS Access, SQL Server,DB2

Packages : Oracle Apps, Visual Basic 6.0, Visual C++ 6.0, Crystal Reports 9,

SmartDraw, Adobe Photoshop 6.0, Adobe ImageReady 3.0, Adobe

Illustrator 10, Dia, The Gimp, Google Sketchup, Oracle SQL Loader, IMP,

EXP, Oracle Migration Workbench, CVS, Subversion, Selenium

Languages : CFML, MXML, JSP, C, C++, VB, JAVA, UNIX shell programming, SQL,

PLSQL, SED and AWK (UNIX power utility tools), Perl, AJAX, CF AJAX,

XML, Acrobat JS, Flash Action Script, Flex, CSS, HTML

Operating Systems : Windows 9x/NT/2000, MAC, Redhat Linux 6.0, Ubuntu, Knoppix and UNIX

Contact this candidate