Capable in both Agile & SDLC project execution models. Can wear as many hats as needed if working as a Agile Developer (PM, Business Analyst, Report Writer, etc..) or can simply play a Team Role as needed in the SDLC traditional style project model methodologies.
UPDATE - Resume & LinkedIn profile update coming within the next week to more closely match industry technology trends & requirements. Reference for this update is the most recent technology guide provided by Robert Half Technology (link here).
Contract PaaS Cloud CRM Application Developer @ * Responsible for providing several clients with custom application development including initial consulting, prototyping and implementation.
* Recent project utilizing both cloud computing leaders AWS and Azure which required creating a automated file storage transfer using both AWS S3 and Azure Blob Storage tools.
* Visual Studio.NET 2015 & SQL Server 2014 custom solution created which ties together a custom PaaS Cloud Application, SharePoint 2013 & Excel Web Services. This custom solution was created to give the client a custom front-end to more easily review & apply "what-if" scenario's to the data being analyzed and served up from Azure SQL Server 2014. This was chosen as a easier and more cost effective route instead of using SSRS & Business Intelligence tools since the client is a small company having minimal human resources to perform typical BI analysis of SQL data. From June 2004 to Present (11 years 5 months) Houston, Texas AreaCustom Reporting Analyst & Trainer for Client Cognos Self-Service Reporting @ • Assist Fiserv banking clients with software support in areas of technical assistance, report writing and problem resolutions such as missing banking reports. Regularly performed assistance via phone and Web Ex remote training to multiple bank employees several times a day requiring exceptional customer support skills.
• Manage all reporting for the Facets helpdesk support database application used for the entire Southwest Region (approx. 3,000 tickets per month).
• Responsible for all KPI reports used to track helpdesk support tickets and phone calls via Avaya & Taske phone call center technologies. This data was extracted to Access via SQL pass through queries and then reported in Excel dashboards and drill down Access reports. These were provided to senior management and account execs on a monthly basis.
• Created custom dashboards & reports using Cognos
• Trained Bank Clients on how to use Cognos and write their own reports using one-on-one in-house training or via Bomgar communication software From June 2010 to March 2011 (10 months) Houston, Texas AreaBusiness Process Analyst @ • Performed one on one interviews as well as led group discussions to gather analysis on existing operational processes at Houston headquarters and at main branch locations in Oklahoma City, OK, Lafayette, LA and Tyler, TX.
• Created interactive cross functional flowcharts of current operating processes. The processes documented were Customer Inquiries, Sales Quotations, Credit Reviews, Sales Orders, Engineering, Field Service Orders, Purchasing, Vendor Management, Shipping & Receiving, Assembly & Manufacturing and Accounting.
• All existing operational maps were presented to a committee and interactive web based workflow features were demonstrated such as applying custom properties to process maps to gain more of an understanding of “what-if" scenarios.
• Analyzed existing Infor Syteline 8 ERP implementation to incorporate into the operational maps. Made suggestions to utilize features such as Event Notifications that would improve operations.
• Managed process mapping project via Sharepoint
• Created training manuals for the interactive web version of the process maps
Reported to VP - Support Services From March 2009 to June 2009 (4 months) Houston, Texas AreaBusiness Analyst, .NET VB/SQL Developer & PM @ Major welding company hired me to assist with scheduling and the development of a project cost software system. Duties included:
• Created MS Project scheduling templates to manage engineering/construction activities and site personnel rotation schedules.
• Implemented cost control policies incl. Purchasing, Job Costing, Shipping/Receiving within the Supply Chain Department and trained users how to follow these policies with the QuickBooks Enterprise accounting package for a business unit with $135 million in annual revenue.
• Assessed company’s readiness for an Enterprise Resource Planning (ERP) implementation with the IFS software suite. Analyzed current operating procedures, technology infrastructure and suggested/implemented improvements for the implementation.
• Performed requirements gathering sessions which were converted into a .NET/SQL Server software development system. This software was the main cost system used for the subsea welding fabrication for the BP Thunderhorse project ($50 million annual revenue).
• Designed all the cost & management reports using Crystal Reports
• Trained all users, installed and supported the software users as well as wrote all documentation for the software.
• Created Excel dashboards that displayed project portfolio metrics. VBA was utilized to customize the thresholds required for the metric status indicators. From January 2008 to November 2008 (11 months) Houston, Texas AreaBusiness System Analyst @ Was hired as a Contract IS Business Analyst by this Energy Company. That was a 6 week assignment but the company extended my contract for another 6 months to assit with other key areas. Duties included:
• Analyzed business processes in all levels of the company to find areas where Enterprise Content Management (ECM) could increase efficiencies.
• Planned and aggressively discovered/collected ECM functional and system requirements in the following functional areas: document management, web content management incl. portals, business process management, forms processing and records management.
• Created vendor bid packages which ranked possible new vendors based on total requirements provided and composite function needs sorted by heat mapping techniques. Vendors worked with included Oracle, IBM - FileNet, EMC - Documentum, BEA, Microsoft and Vignette.
• Helped Project Manager with ECM project using MS Project.
• Designed and managed ECM project teams Sharepoint site.
• Presented ECM project metrics via digital dashboards using Excel conditional formula charts and graphs.
• Designed custom digital dashboards utilizing BMC Remedy software and Excel VBA conditional formulas which displayed over 50 key performance indicators (KPI’s) including IT Service Level Agreement (SLA) trends with customized alert indicators and drill down capabilities.
• These dashboards were presented on desktops via Sharepoint portals as well as plasma TVs for “hands-free” viewing/analyzing. From June 2007 to December 2007 (7 months) Houston, Texas AreaInformation Systems Manager @ • Planned, directed, and maintained the overall policies and goals for the companies Information Systems requirements.
• Managed and coordinated work teams that included outside consultants, application systems analysts and technical writers.
• Worked with executives to make sure the IS developments were in parallel with the companies long-term objectives. Managed budgets up to $1 million.
• Managed the design and implementation teams for the PRISM (Project Real-Time Information Sharing & Management) ERP system that managed multiple $150 million Oil & Gas Deepwater projects. The GUI was designed in Visual Basic 6.0 and the business rules were enforced using Transact SQL.
• Captured PRISM ERP business requirements from the Project Department (Engineering, Procurement, Document Control, Cost Controls, Sales & Marketing and Accounting) groups and created functional design specs including prototype software screens for the programmers.
• Utilized business process modeling technologies, MS Visio, to confer with SDLC methodologies through the PRISM system development.
• Created internal quality assurance testing (QAT) using “User Test” groups.
• Worked with Timberline Accounting consultants to maintain and add cost modules to PRISM to support existing company financial systems
• Created and conducted training programs for the IS Department.
• Created software user manuals utilizing RoboHelp and VB 6.0 help context id’s.
• Created reports using Crystal Reports and published via Crystal Enterprise Server.
• Created and presented Flash/Power Point presentations about PRISM features to educate and promote the system’s capabilities to upper management in order to solicit additional funding.
• Foreign company purchased Atlantia in 2003 and wanted to incorporate their systems so Electronic Data Interface (EDI) solutions were created to merge both companies’ technologies. From January 2000 to June 2004 (4 years 6 months) Cost Estimator @ • Created Order Magnitude Estimates (OME) for the fixed platform and deepwater business units in the range of $1 million to $150 million.
• Created proposals that included CAD drawings, vendor bids and cost, time & resource information including projected project s-curves.
• Created Excel estimating and proposal templates to manage the different bids. These eventually were converted to Access and then to the Estimating & CTR (Cost, Time & Resources) modules within PRISM. From July 1998 to January 2000 (1 year 7 months) Houston, Texas Area
BBA, Finance @ Texas A&M University From 1991 to 1996 Derek Caldwell is skilled in: SEO, ERP, Business Analysis, Business Intelligence, CRM, Project Management, SQL, Access, Management, SharePoint, Mobile Applications, Business Process..., MS Excel Pivot Tables, VBA Development, Cognos, Caspio Developer, Cloud Applications, PaaS, Custom Websites -..., Leadership
Websites:
http://derekcaldwell.com