SUMMARY:

Software engineer with 29+ years of experience in various computer languages and flexible to fulfill other roles like data and information architect even BIM API support for CAD software. Proven ability to identify business process improvements creating a competitive advantage. Excellent analytical, problem solving, and interpersonal skills. Known for providing outstanding customer service.

COMPUTER SKILLS:

Proficient in: VBA for both Excel/Access, VB.NET, HTML, C#, T - SQL

Familiar with: Java, XAML, PHP, HTML5, Revit API, Agile Methodology

Database: Microsoft SQL Server, Microsoft Access, MySQL and AS400, PostgreSQL, Oracle, Primavera

Applications: Autodesk Revit, Autodesk Architecture, Microsoft Visual Studio, Adobe Acrobat Pro, FileMaker, Bluebeam, Microsoft Sharepoint

EXPERIENCE:

Confidential

Systems Developer / Data Analyst

Responsibilities:

• Improved Microsoft Access databases connected to Excel files and SQL Server that kept accounting information to potential sales and collection departments. VBA functions provided automation of connecting separate Excel files and ensure data consistency along with data scrubbing.

Confidential

Systems Developer

Responsibilities:

• Modified Microsoft Access database to include time assigned to projects in order to produce dynamic monthly financial reports to PowerPoint. These reports were responsible for reducing risk, improving decision making and driving efficiencies across all BUs and functions through maximizing return on data and information assets. Security was implemented using VBA.
• Coordinated with several departments and their dispersed data systems (Microsoft Access, Primavera P6 and Microsoft Sharepoint using SQL Server) to eliminate data discrepancies and conduct quality-control checks based on unique identifiers.
• Reversed engineered AutoCAD plugin without source code that manipulated and created hundreds of well pads based on location.

Confidential

Systems Developer

Responsibilities:

• Converted Revit API plugins with original source code from previous versions to current.
• Gave speeches and on Revit API software development.
• Worked on Autodesk Forge along with Node.Js to provide automation to a BIM 360 website application that manipulated hundreds of Revit drawings.

Confidential

Systems Developer

Responsibilities:

• Provided accounting with dynamic method of sending Excel PM reports on a monthly basis. Reduced the time from 4-6 hours to 2 minutes using Excel VBA.
• Moved several Microsoft Access databases to SQL Server 2012 and converted front-end to talk to SQL Server using SSIS for the conversion, SSMS to allow for remote connections and created reports with SSRS.
• Combined data from two separate database sources: Cosential which uses Oracle (Marketing dept) with Deltek (SQL Server - Accounting dept.) to produce various financial statements like a pro-forma forecast.
• Created a Visual Studio solution that could read an entire PDF of medical equipment cut sheets and parse out into individual PDFs as separate files labeled as their unique identifier. Also, inserted text label in that PDF with their item ID to each data sheet perspective of the cover sheet.
• Produced Revit API tools using WinForms with VB.NET that copied in architecture rooms from background drawing and used Excel to load in parameter values. Later such tools were converted over to C#.

Confidential

Systems Developer

Responsibilities:

• Created iPhone / iPad app that connected employees to client contact information using FileMaker Server based on services type
• Supported MacBook Pro machines and networking.

Confidential

Systems Developer

Responsibilities:

• Constructed dynamic reports that connected Revit BIM drawings to both either an Access database or SQL Server that dealt with client budget costs and storage of furniture and medical equipment standards.
• Built a dynamic code generation tool to speed up development of programming code based on options stored in a database.
• Created a tool that could sort and rename thousands of drawing sheet PDF files per ADA standards.
• Established a database change report between two separate archived Microsoft Access databases. It displayed both before and after values and created itself dynamically after having the user browse out to the location of each file using Access VBA.
• Provided a collation process of data sheet and cut sheet reports that took the process of building an equipment planning medical book from 2 ½ days to under an hour. The company was able to hire three full time managers with the time savings and made $4,000,000 in profit that year.
• Set up template of combination of reports per building phase so print out equipment planning books did not have to be selected each time.
• Had AI dashboard system in place to identify either user as necessary, or a new feature needed to be implemented before the user could report an error occurred.

Confidential

Warehouse Database Administrator

Responsibilities:

• Developed Visual Basic programs that sent Microsoft Access database results to Excel spreadsheets and graphs thus reducing paperwork workload from three people to one person.