Think-Lab

Responsibilities:

Maintain current ColdFusion applications and design and develop future applications. Manage three other developers.

• Converting old procedural code to OOP.
• Rebuilding an Event management system using ColdBox, Transfer, SQL Server and jQuery.

Responsibilities:

Maintained ColdFusion applications and the company intranet. Built a new web applications and reports as needed.

Task Consolidation :
• Built an application that consolidates data from multiple databases into one centralized database.
• To accomplish this, I used an open source project (located at @ http://code.google.com/p/cfcdatamapper/.)

Responsibilities:

Maintained current website, intranet and ticket system using ColdFusion 7. Created new web applications and reports as needed. Processed HIPAA 834?s using Informatica and VB 6.

FLEX:
• Built an interface to my ticket system, which had a backend using MS SQL Server and ColdFusion.
• Designed simple entry forms and a data grids with filters.

Intranet:
• Created an intranet, including HTML, PDF, and Excel reports, using ColdFusion 7 and Oracle.
• Designed a company news/blog for senior staff to broadcast messages to the company via intranet.
• Developed other company tools including a company directory, which allows the administrator to update our active directory via the intranet.
• Constructed a polling tool for senior staff to poll the whole company.

Ticket System:
I created a help desk ticket system for IT using ColdFusion 7 and SQL Server integrated with Active Directory. For the ColdFusion framework, I used Model-Glue Unity. This ticket system replaced the old method (employees would send IT an email). The ticket system now tracks the ticket from start to finish.

Operational Data Store:
Using Informatica, I created an operational data store from our transaction system (FACETS). It allowed for much quicker and simpler access to member information.

Bank of America File Processing:
I created an application using ColdFusion 7 that runs daily. It takes a CSV file from Bank of America and converts it into a proprietary format. It then FTPs securely using ColdFusion to the transaction system (FACETS).

Responsible for monitoring, backing up and managing logins for all of the SQL Server Databases. Also responsible for maintaining current ColdFusion/ASP/PHP web sites and web applications.

Worked on the Development of a custom built web-based statewide case management and fiscal accounting system. The system provided services and support to children and adults with developmental disabilities. Core functions that the system provides are: consumer case management, trust management, vendor management, quality assurance management, service authorizations and invoicing, accounts payable, general ledger, state reporting and claiming, and other general accounting functions.

Responsible for monitoring, backing up and managing logins for all of the SQL Server Databases. Re-designed and developed modules within the existing application. Migrated parts of their application from Fusebox 1 to Fusebox 3. Developed custom HTML reports introduced CSS to the new parts of the application. Created stored procedures and analyzed/re-wrote SQL queries to improve efficiency of data processing.

Developed intranet applications using Fusebox methodology. Built a search engine using ColdFusion, Verity and SQL searching data from databases and intranet documents, such as Excel, PDF and Word. Using new technology within ColdFusion MX6.1 (CFC's) and old technologies (custom tags, arrays, structs, sessions and cookies), I built a company resume database enabling employees to build their own resume and then esport to PDF or MS Word format. Built a company timecard program using CFC's to help re-use code, including SQL queries that are used throughout the timecard program. Used JavaScript for validating the timecard, which was based on individual schedules; used scheduled task to send emails to supervisors for approval; also used CSS for screen display.

Built a ColdFusion application (www.conditionassessment.net) for assessing the condition of a building and making recommendations for needed repairs.

Built a ColdFusion application www.Constructabilityonline.com, which allows architects to view project comments by the entire project team in real time. Consistency in the comments and issues that are addressed and typical for most projects allows the plans examiner more time to spend on understanding the program and searching for more substantive comments.
Environment
SQL Server 2000 for the database CSS for content layout CFCs to re-use code and input/output data from SQL Server Crystal Reports for all reports Managed three instances of ColdFusion MX6.1 and SQL Server 2000 (Dev, Testing and Live) Database Migration: MS Access Database to a SQL Server 2000.

MS Access Development/Planning: Analysis and documentation of user functions and steps required to develop new resources. Web Application: Development and maintenance of a training application utilizing ColdFusion and ASP. Online Training Converted an MS Access training database to a MS SQL Server database. Integrated the training database with the employee database to create an online training program, for ordering and tracking training requests. On the training website, used SQL to Select, Insert, Update and Delete records from the MS SQL Server database, which then output into HTML format. Used JavaScript to validate user input and selections.