Below are the 6 Data Architects & 6 Database Administrators with Timberline/Sage 300 & other systems experience. The Thor Group® provides Timberline/Sage 300 SME's, business analysts, programmer analysts, developers, data analytics professionals, system engineers, systems administrators, cloud specialists and Timberline/Sage 300 implementers/trainers on a consulting, contracting or direct hire basis.

Would it be beneficial for your organization to employ a data architect with extensive background in applications architecture, project management, business intelligence and data analysis? Core competencies include data warehousing, data analysis, applications architecture, database development and system integrations. Technological knowledge consists of Sage 300/Timberline, SharePoint, SQL Server, PeopleSoft, Transact-SQL, MRI Property Management Software and Microsoft Office Suite. Educational background includes MBA, Finance. This individual is a Certified Public Accountant.

Serving in a real estate development and construction company, the job covered supporting critical business applications in an emerging international environment. The business applications group was led in the implementation and support of critical business applications. Managing IT steering committee meetings was done to prioritize the allocation of IT resources. An additional function consisted of managing a major accounting system version upgrade with limited resources and minimal disruption to end users. The yearly 1099 process was also managed, including significant data analysis and process re-engineering to dramatically improve efficiency and reporting. Managing the accounting system integration for third party outsourcing project, was one of the duties. The job cost forecasting report was developed, integrating data between Sage 300 CRE and Prolog systems.

While employed in a software consulting firm as a data architect, part of the job was to provide development and support of pharmaceutical decision support systems. Some of the tasks completed were leading software upgrades for Sage 300 CRE and Core Associates TimberScan systems, as well as providing solutions architecture for MRI property management systems re-implementation. Furthermore, this architect performed development and performance tuning for reporting solutions of pharmaceutical clients.

Does a data architect who performed all data modeling and physical database definitions with skills in Sage 300/Timberline, Oracle and Informatica as well as work background in telecommunications, food processing and professional services industries, fit in your organization? Technical skills encompass Sage 300/Timberline, Microsoft SQL Server, Oracle, Sybase System, IBM DB2, ERwin, ER/Studio, RDA, Informatica, Toad, ProClarity, MicroStrategy, Microsoft Office Suite and ETL. Educational attainment includes BS Computer Science with Minor in Economics. This specialist is a Certified Project Management Professional.

Duties in a telecommunications company covered managing SharePoint application and BI solutions, as well as handling the client’s technical team and deliverable schedule. Reporting solutions were developed for finance, sales and operations. Responsibilities covered business analysis, Scrum sessions and rollout of a sales proposal tracking system, capital and revenue forecasting solution, SharePoint workflow site, Operations project management solution and developing reports and analysis solutions using Microsoft BI stack with data sourced from Sage Timberline and SpatialNet systems. In addition, database structures were developed in MS SQL Server and Analysis Services, reports using MS SQL Reporting Services, ProClarity and Excel Services. Dashboards were built using PerformancePoint Server and deployed under MS SharePoint.

As a data architect for a professional services company, a task involved working with business SMEs to define data requirements. Some of the duties were performing all data modeling and physical database definitions as well as providing ongoing consultation and guidance to ETL, reporting and application development teams. Additional responsibilities involved developing MS SQL Server 2008/2012 and utilizing ERwin for data modeling and architecture documentation.

Could the future success of your organization be helped by this data architect who implemented process improvements and tools to enhance the usability and value of corporate data and who worked in the computer software and cloud computing industries? Technological background involves Sage 300/Timberline, Salesforce, Informatica, SAP R/3, SQL, PL/SQL, SOQL, Java, JavaScript, JDBC, Eclipse, HTML, ETL tools, Windows and UNIX scripting, VB, Visual Studio, Microsoft Office Suite, Salesforce.com, Oracle Siebel CRM and BMC Remedy. Educational background includes AS Degree in Computer Electronics.

In a cloud computing company, some of the responsibilities of this data architect were designing and deploying D&B Batch Data Integration to Salesforce.com. The use of Informatica PowerCenter with Agile/SCRUM team was employed. Additional duties were composed of working on the data governance team to define policies and priorities, as well as leading Informatica Cloud MDM, DemandTools and DupeBlocker product evaluations. EBS Modules worked on included AR (Customer), AP (Supplier), PA (Project), OE (Order), PER (Employee), PO (Purchasing), CSI (Service), SAP R3 and Timberline. MDM sources and targets cover Sage Timberline, SAP R3, Oracle EBS R12, Hyperion EPM and EDW.

While working for a computer software company, leading data quality, MDM and data governance consulting engagements, was a primary responsibility. The implementation of process improvements and tools to enhance the usability and value of corporate data was also carried out. Other tasks involved leading a project to build Salesforce.com AppExchange App as well as co-managing the corporate strategy, marketing, sales and operations.

How can your organization gain an advantage with the help of a data architect who designed and created solutions to resolve complex data issues with experience in real estate, IT and banking industries, and has knowledge of Sage 300/Timberline, SQL and GE Centricity? Technical skills include Sage 300/Timberline, SQL Server, Business Intelligence (SSIS), Reporting Services (SSRS), Microsoft Office Suite, GE Centricity, Gemini Project Management Software, Crystal Reports and Red Gate. Educational attainment includes BS Accounting and Computer Science and AS in Computerized Accounting.

Administering databases including backup, restores, tuning, resource contention, failover specification, database documentation, creation, management and version control, was one of the responsibilities. The job involved architecting automatic monitoring, index maintenance, SQL Agent Job monitoring and reporting, as well as automating the server alerting process. The Independent Shrink and Re-indexing Processing (ISRP) was efficiently managed. Other functions covered designing and creating solutions to complex data issues, along with mapping and removing data from one database to another. This included handling triggers, views, stored procedures, functions and security models.

One of the key tasks was validating data from source database to the target database. The examination of data and transformation (if used) to validate process results, was also carried out. Other tasks involved creating and maintaining the data dictionary, test scenarios, test data, version control for testing, business rules/requirements and process flow. Data validation, examination of data and comparing to process, for correctness and variation (process/data relationship), were other tasks. Data Cleansing using Dynamic SQL Generator was completed using a database solution.

Could the future success of your organization be helped by this data architect who set up a data warehouse with a module to automatically download the weekly payroll, with a work background in the construction services industries and is well-versed in Sage 300/Timberline, Oracle and SQL? Technological background is composed of Sage 300/Timberline, Microsoft SQL Server, MySQL, Oracle, MS Access, ER/Studio, Transact-SQL, SQLPlus, PL/SQL and Microsoft Office Suite. Educational background includes B.A. Psychology (Cum Laude) and A.A. General Studies. This specialist is a two-time recipient of the Employee of the Quarter Award.

Being a data architect for a construction services company, the job was to provide further development, backups and security for the MS Access database that was designed and developed previously. Setting up a data warehouse with a module to automatically download weekly payroll, was also one of the key tasks performed. The data was entered into the MS Access database and into the Sage 300/Timberline accounting system. Additional responsibilities involved reviewing and downloading the weekly payroll prior to automating the process.

Serving as a data architect for an informatics company, some of the duties were designing and building the physician honor roll production database architecture. The development of T-SQL procedures to load the data to production, was also performed. Another task was participating in building two applications (new database architecture, T-SQL procedures and SSIS packages) on agile teams in order to standardize the client data load processes. Skills consisted of relational database development, data architecture, ETL processes, data analysis and report writing.

Does a data architect who built a reporting platform consisting of hundreds of SSRS reports, with experience in web development and IT services industries and who is adept in Sage 300/Timberline, SQL and Crystal Reports, pique your interest? Technological knowledge includes Sage 300/Timberline, SQL, Transact SQL, ASP.NET, VB.NET, PHP, JavaScript, HTML, XML, XSL, SQL Server, Crystal Reports, Visual Studio .NET, Microsoft Active Directory, and Microsoft Office Suite. Core competencies include database modeling and development (normalization/optimization), database migration (DTS/SSIS), OLTP applications development, business intelligence as well as database reporting and representation. Professional certifications: Microsoft Certified IT Professional Database Developer, Microsoft Certified Technology Specialist-Microsoft SQL Server 2005 and Business Intelligence Development as well as Microsoft Certified Technology Specialist-SQL Server 2005. Educational background includes a Bachelor Degree in Computer Science.

One of the tasks as a data architect for an IT services company, was to build a reporting platform consisting of hundreds SSRS reports that were used daily/monthly throughout the entire business. Building a CLR library for SQL Server 2008 R2 (involving Active Directory calls and XML, custom aggregates), was also part of the job. In addition, supporting, maintaining and building BI cubes and reports, were some of the responsibilities involved.

Managing all phases of database modeling and optimization, handling Transact SQL-Stored procedures, Triggers, Views and Indexes, as well as working on data warehousing and migration from ERP software like Timberline, were assigned tasks. The job covered administering several databases for commercial websites, along with designing and constructing a friendly user interface via MS Visual Studio, VB.NET and ASP.NET.

Could the future success of your organization be helped by this database administrator who managed the successful transition of the IT Infrastructure to another IT company which saved the organization $30,000 per year, with skills in Sage 300/Timberline, SQL and Business Intelligence? Work experience includes IT and non-profit industries. Highlights of qualifications involve information technology, project management, operations management and technical analysis. Technological background includes Sage 300/Timberline, Sage CRM, VMware, Windows Server, Microsoft SQL Server, Acronis TrueImage, VNC, MS Office Suite and MS Visual Studio. Educational attainment includes Bachelor of Technology, Architectural Technology and Associate in New Media Technology. Certification covers SQL Server.

While employed as a database administrator for a non-profit organization, part of the job was to provide regular backup, updates and routine checks on the MS SQL database. Redesigning and developing the organization’s website as well as implementing a WordPress platform that allowed for better interaction between the organization and viewers of the site, were some of the tasks completed. The development of a SQL Server database was completed using Sage CRM as a front-end and MS SQL Server 2005 as the back-end. Business reports were provided using T-SQL code via SQL Views and Power Pivot tables.

Additional responsibilities involved managing the successful transition of the organization’s IT infrastructure to another IT company that saved the organization approximately $30,000 per year. This specialist also integrated analytical software to track web visitors to the site. Furthermore, taking ownership of all social networking and email marketing procedures was one of the notable achievements. This initiative increased the company’s followers by 50%.

Does hiring a database administrator who consistently develops and implements IT solutions to improve and optimize business processes as solution provider and systems integrator, pique your interest? Technical skills include Sage 300/Timberline, SharePoint, Crystal Reports, ColdFusion MX, Visual Basic, Visual FoxPro, Java, C++, JavaScript, VBScript, Visual Studio .NET, FrontPage, Dreamweaver, HTML, DHTML, XML, ActiveX, COM, DCOM and ASP. Educational attainment includes Doctor in Management in Organizational Leadership/Information Systems and Technology, MSCS in Computer and Systems as well as BSEE in Control Electronics Engineering. Certifications: Microsoft Certified Professional and Kaseya Certified Administrator.

Serving as a database administrator for an IT services company, the provision of high level customer technical support on databases and custom applications including the use of Dragon and Allscripts, was a primary responsibility. Some of the duties were analyzing user needs and developing IT solutions which included web, database and stand-alone applications. Furthermore, the analysis and the development of XML applications to send information from legacy applications like Sage 300/Timberline to internet- based systems, were also completed. In addition, the modification of codes in Sage 300/Timberline in order to meet company requirements and integration with new web applications, was accomplished.

Part of the job was to create solutions to improve and automate case management workflow. Some of the responsibilities accomplished were developing, creating and modifying customized computer applications. Functions consisted of consistently developing and implementing IT solutions to improve and optimize business processes. Technology-based solutions were also implemented for a broad diversity of business problems from concept to completion.

What contributions could a database administrator who designed and developed an interface to communicate with a client through XML Output and Schema capabilities, with knowledge of Sage 300/Timberline, Oracle and SQL as well as experience in the computer software industry, bring to your company? Technological knowledge consists of Sage 300/Timberline, RedGate, ER Studio, TOAD, Query Analyzer, MS Visio, MS Project, Visual Source Safe, C# .NET, Crystal Reports, SQL Server and Oracle. Educational attainment includes MS in Business and Information Technology (MBIT), MS in Computer Science (MCS) and BS in Computer Science (BSCS). Certifications: MCDBA, MCSD, MCSE, OCP-DBA, MCIT, MCTS, MCITP and MCTS.

For a market research company as database administrator, overseeing and managing the database team in order to design, develop, test and eventually deploy at client sites, were primary responsibilities. An additional task was performing database development and administration activities, which involved performance tuning and execution of scheduled jobs to load and process data from different sources using ETL, and SSIS Packages in SQL Server 2005 and 2008. Moreover, the implementation of database standards and naming conventions for database objects, was accomplished.

Contributing to a computer software company as a lead database administrator, part of the job was to design and develop an interface to communicate with an insurance client with the aid of XML output and schema capabilities through stored procedures and jobs. In addition, performing database development tasks and delivering every task according to CMMI Level 5, were some of the responsibilities completed.

Does a database administrator who designed, developed and implemented an application in Access to track customer returns, who worked in the construction and manufacturing industries, pique your interest? Technical knowledge includes Sage 300/Timberline, Report Designer, Access, Crystal Reports and more. Educational attainment includes a Diploma in Software Technology and Systems Management as well as an Industry Integrated Diploma in Electronics Engineering. Certifications earned are in the following: MS VB.Net, XML, Java, C++, Jacada interface and Web Development.

Important contributions included upgrading applications, handling conversion, process improvement, application tuning, Sage 300/Timberline administration and data architecture. Aside from capacity planning, other functions involved backup/recovery, normalization/de-normalization, Internet Directory (OID), disaster recovery and database performance tuning. This specialist designed and developed a management and user accounting report system using Great Plains internal Report Designer and Crystal Reports.

The job covered administering and supporting accounting systems Microsoft Dynamics Great Plains (SQL Server 2000) and Sage Timberline, EDI Application and the Warehouse Management System (WMS). This specialist worked closely with third-party vendors to support various applications. The installation, setup and implementation of the SQL Server database were carried out. Data migration from SQL 2000 to SQL 2005 was also completed. In addition, Great Plains 10 Server and Client was installed, setup and implemented. Duties consisted of designing, developing and implementing an application in Access to track customer returns. An additional function involved supporting both production and development databases on UNIX as well as on NT. Other responsibilities were installing and upgrading applications.

What can a database administrator who worked in the construction and retail industries bring to your organization? Technical skills cover Sage 300/Timberline, ADOT, digital blueprints and more. Educational attainment includes a College Degree with specializations in Advanced Algebra, Analytical Geometry and Beginning Calculus.

Relevant tasks encompassed maintaining the Sage 300/Timberline Estimating Software Database, as well as using and implementing digital blueprints for in-house and sub-contractor. The job involved assembling detailed proposals for commercial, ADOT, municipal and government projects that was worth $35,000,000, in addition to establishing information digital exchange. This individual handled networking and digital transmission of large bundled documents, blueprints and scope of work to all parties requiring such information. Assessing and detailing accurate materials and labor for such projects, were part of the job. Maintaining professional contacts with builders, designers, engineers, architects and outside vendors ensuring bid accuracy, was one of the key roles. Attention to detail was vital to project success. Extensive knowledge, as well as use and implementation of Timberline applications and its background environment, were applied.

Duties consisted of using Sage 300/Timberline in recording and maintaining detailed material, labor and project logistics which were vital for the success of one of the top 3 largest framing contractors in the state. Functions were working on estimates and purchase orders, managing materials and building vendor relationships. The work covered monitoring, installing and maintaining databases while checking backups.

The future success of your organization could be helped by this database administrator who recommended and provided solutions to the user community, and who worked in real estate and engineering industries. Technical competencies involve Sage 300/Timberline, budget variance reports, budget projections and more. Educational background includes MBA in Business Administration and a Bachelor of Science Degree.

Duties as a Timberline database administrator/support analyst consisted of managing and maintaining the accounting application and database for a real estate/construction company. The job covered troubleshooting daily issues, recommending and providing solutions to the user community and resolving system problems. Manual processes were reviewed and methods of automation were recommended utilizing system generated reports and/or modification of workflow. Contributions were developing and deploying custom financial reports to address the needs of external stakeholders. Participating in accounts payable activities during high volume months, was one of the key tasks. Developing and implementing the training curriculum to promote a self-serve environment where the users utilize available resources to find solutions, were notable accomplishments.

Relevant functions were reviewing manual processes and recommending methods of automation utilizing system generated reports. Modifying the workflow, along with designing, implementing and administering MS SQL 7.0 Enterprise OLTP database architecture of heterogeneous data sources, comprised other tasks. This individual worked on continuous transactional data replication. Draw requests were produced for construction lenders with proper supporting documents while communicating and answering questions pertaining to submitted documents.