EXPERIENCE

DBA/Sr. Web Applications Developer

Confidential

Led product development team for the Association eCommerce module for various core services including membership dues, meeting registrations, accreditation and certifications. Primarily responsible for managing and maintaining the Accounts Receivable AR database and interfacing with remaining accounting information in the Solomon database. The AR database accounted for all manner of journal entries including invoices, debt memos, credit memos, and payments. Also supported various other Association IT initiatives including a video learning system DigiCast , a content management solution CMS for 20-30 yearly meetings and conferences, and an examination and testing interface for accreditation and certifications. Database Administrator DBA managing the underlying Relational Database Management System RDBMS for all Association data.

• 500,000 membership records
• Over 5,000,000 financial transactions
• Over 30 meetings, conferences, and webinars per year and all related information
• Sponsorships and exhibitors
• Advertising data

Project Leader

Confidential

Everything from Budget and Bid Coordinator to Software Engineer, from Database Administrator to Server Administrator and Project Manager for C S coordinated, designed, developed and managed the entire spectrum of the consulting business with a strong focus on software development. My experience provides you the unique combination of someone with concrete technical expertise along with project and staff management. Experience with AGILE and iterative software engineering life cycles: requirement analysis and specifications, design and prototyping, implementation, functional testing and re-design. Furthermore, administers and upgrades server software, imports and parses relevant data at the beginning of a project, creates and optimizes MS SQL Server databases, programs the application, and programs integrated GIS functionality as well. Strong interpersonal skills, communicates effectively, prepares graphs and charts in Excel, and develops mockups and prototypes using online tools MockingBird and workflow diagrams and server infrastructure designs in Visio. Also proficient with MS Project in tracking human and technical resources and meeting major milestones as anticipated.

Projects

• Bid Proposal Coordinator, responsible for delivering a well-written, thorough bid proposal and presenting to selection committee on short-lists for various projects:
• San Diego County Airports Lease Management Software ALMS RFP, interview and proposal. This is a 500,000 bid proposal for developing a comprehensive software engineering solution for the County's 8 general aviation GA airports, over 100 lease contracts, and in excess of 1,000 leasing areas in the form of T-hangars and concessions. Drafted, scoped and priced comprehensive RFP, responsible for technical interview strategy, presented day-long proposal at County offices, answered all technical questions related to hardware and software >Win
• Los Angeles World Airports LAWA , organization for the City of Los Angeles, residential sound insulation program, for 8 airports, consisting of approximately 2.3 million parcels, and 12 different modules including Mass Mail Merge, Statistics reporting to Excel/PDF, and GIS Mapping. Scoped 200,000 in fees for two different programming options HTML5 ColdFusion , and optional choice of selective modules. >Pending
• City of Novi GIS Application Request for Proposal RFP , approximately 70,000 bid
• New York State Environmental Facilities Corporation ARRA Compliance Assistance and Monitoring Services RFP, approximately 120,000 bid cost, tracking for 300 projects, 400 visitation surveys, 15 GB / 13,000 project files >Win
• Erie County NY Health Dept. Database Request For Proposal RFP , approximately 200,000 cost proposal for managing Health Dept records in comprehensive web-based RDBMS. Drafted proposal and presented our approach in person. >Loss
• Oakland County Airport MI Lease Management Software RFP, approximately 50,000 cost proposal 2,500 customers, 4,300 aircrafts, 50 land leases, 650 T-Hangars >Win
• San Diego County CA Airport Land Use Compatibility Plan ALUCP Application RFP, approximately 80,000 cost proposal, 1 million parcel records, 16 airports, 64 compatibility factors >Win
• Wayne County MI GIS Services RFP, consisting of four different companies with C S acting as primary consultant, fees totaling 2 million dollars. >Loss
• Confidential
• Staff 4 : GIS Analyst, Programmer, Senior Applications Developer, Graphics Artist or Senior Marketing Communications Specialist contact info available upon request
• Formulated Requirements Analysis based on client interviews
• Devised Product Specifications, allocated staff tasks, and set staff expectations and roles based on their experience
• Estimated product delivery schedule in MS Project based on client expectations, defined major milestones
• Set agenda for weekly progress meetings with staff based on schedule, assessed staff progress and readjusted individual priorities as needed to meet client expectations
• Researched technical resources which best meets client needs and plays to staff strengths programming platform, Integrated Development Environment, etc.
• Dispatched purchase orders for required technical resources software and additional hardware
• Organized biweekly progress meetings with client
• Served as chief liaison with client
• Managed project budget in BST accounting software and reallocated human and computer resources as necessary every other day
• Approved invoices to client
• Final product demonstration and training
• Devised response procedures for product bugs and errors
• Assigned bugs/errors to specific staff
• Confidential Staff 3 : GIS Analyst, Programmer, Graphics Artist
• Organized weekly meetings with staff and client together
• Managed Programmer's workload based on client priorities
• Confidential Staff 2 : GIS Analyst, Programmer
• Organized weekly progress meetings with staff and client together
• Set meeting agenda and tracked individual as well as project progress
• Readjusted GIS Analyst's workload from other tasks to meet deadline
• Tracked individual staff and project effort in terms of cost to meet budget requirements
• Confidential Staff 3 : GIS Analyst, Senior Applications Developer, Database Administrator
• Formulated data transformation mapping guidelines for DBA from county GIS datasets to QuietTrack database schema
• Designed and implemented 3 phases of product development: 1 data collection/migration, 2 requirements analysis, specs and prototyping, and 3 software development, and 4 testing, delivery and training
• Designed project schedule in MS Excel
• Led kick-off meeting: defined staff roles, set staff expectations and assigned staff tasks
• Coordinated collaboration between GIS Analyst, Senior Applications Developer and DBA by agreeing on critical paths and a mode of communication
• Organized and led biweekly staff progress meetings
• Managed and tracked budget
• Led testing efforts and trained users in live demonstrations
• Devised response procedures for product bugs and errors
• Coordinated team response times to bugs/errors based on their workload and communicated expectations back to client.
• Confidential Staff 3 : GIS Analyst, Programmer, Senior Applications Developer
• Drafted product requirements, finalized specifications and designed prototype for Programmer
• Designed calendar, ticklers and environmental forms for tracking airside/airport/landside/pavement deicing, spill incidents, work orders, storage tanks, and sampling data for the web-based application
• Led kick-off meeting with client, gathered requirements, held weekly meetings with team to track progress, and trained client at their site
• Managed budget and approved invoices
• Tracked human and technical resources in MS Project
• Researched and integrated commercial off-the-shelf COTS document management tool
• Maintained client relationship: client pays monthly licensing fee for the past 5 years

Confidential

• Staff 4 : Programmer, Senior Applications Developer, Graphics Artist, and GIS Analyst
• Formulated Requirements Analysis based on client expectations
• Devised Product Specifications, allocated staff tasks, and set staff expectations and roles based on their experience
• Estimated product delivery schedule in MS Project based on client expectations, defined major milestones
• Organized and led biweekly staff progress meetings
• Managed and tracked budget
• Confidential Developed mobile-based Utility Condition Assessment Tool UCAT for C S Facilities team as a tool to help field engineers collect data on 13 different utility systems including: Storm water, Sanitary sewer, Electric, and Telecommunications among others. Each system consists on average of 40 fields in a grid panel, each with about 16 drop-downs, various checkboxes, dates, currency such as rehab cost , and text controls. Note that this HTML5 application consistently looks and operates across all mobile devices including iPhones, iPads, Android phones and Android tablets including desktops/laptops.
• Confidential Designed, developed and implemented the Inventory module in C ASP.NET 3.5 using Visual Studio 2010 updated and customized the reporting interface using custom controls and the Telerik ASP.NET object library. Also used Model-View-Controller design separating out components of the Inventory module into different files interacting with each other. The repository interacts with the SQL Server database in a standard CRUD design interface.
• Confidential Simple web-based VB .NET application tracking over 100 projects assessing the condition of homes within Western New York. Funded by HUD U.S. Dept of Housing and Urban Development , this application utilizes Telerik -based custom reporting to Excel, PDF, etc., and allows users to attach large pictures to their projects for display in advanced reporting.
• Confidential Upgraded and migrated the facilities management tracking application QueCentre written in C from Version 1.9 to 2.0. Developed 7 scripts for migrating 7 modules in QueCentre including Work Orders, PMs, Events, Inventory, Location management, Fixed Assets, and ad hoc reports, using T-SQL and C . These complex scripts were run against 180 Version 1.9 clients to upgrade them to QueCentre Version 2.0 , where although the basic database schema were consistent, each client used the application and stored the data uniquely for their purposes.