Projects

Your Gateway to Success...ETC Consulting

Bring projects in on time and within budget
Free your resources to concentrate on KPI's and building your business
Take advantage of resources well versed in changing trends and skills
Improve the performance of your team
Grow your business revenue
Improve quality of the work product
Increase employee satisfaction
Reduce risk to your clients
Make a great return on investment

Just a few examples of our consulting and training projects by industry

Biotechnology

Using our knowledge and expertise with MS Project and Project Management, our consultants helped to design the work breakdown structure that became the basis of a department's project schedules for the drug submission process.

After meeting with the Director of Regulatory Submissions, it was clear that deadlines were of the upmost importance in the submission process. We met with the subject matter experts and agreed on the milestones and objectives that were necessary to the process. We then developed a MS Project template that would be the building block for all future submissions.

Our job was not complete. ETC designed a training program for the regulatory group based around that template and additional business objectives. Each member ot the regulatory team received comprehensive training and support as requested with their individual submission projects.

Construction

When a large construction company out of Framingham, MA won the bid to build a new energy complex for a prestigious teaching hospital, they soon realized they needed a few additional tools not in the standard construction toolbox. Reporting time, scope and resource needs to their stakeholders as the five year project progressed needed to be sophisticated and above all dynamic.

ETC designed a MS Project training program for all lead engineers. We took on a consulting role, assisting the Project Scheduler in creating the WBS, the schedule and the resource pool. The consulting role lasted an additional six or more months. By that time, the scheduler was proficient in tracking, predicting and preventing changes that would keep them from meeting deadlines. The report templates were perfect for stakeholder meetings and the dynamic schedule was a trusted resource for all project team members.

Information Tech

A smaller but very crucial medical information company needed an effective but cost efficient solution for capturing performance reviews. We offered three solutions; one using MS Access, another taking advantage of Microsoft Excel’s formula capability to calculate scores and an option that used MS Word’s form and table features. The client ultimately decided on MS Excel.

Working with a civil engineer, ETC helped to lay out the framework for collecting the data from the individual respondees. Once the database structure was in place, we imported the data and created summary tables, graphs and an analysis of the comments. We took advantage of MS Excel's powerful function capability to create meningful statistics that could lead them to make changes in the governing policies of the organization.

This model became the standard for assessing the employees outlook on the company. The ROI on this project was outstanding as the cost of outsourcing this project yearly was not financially sustainable.

Pharmaceutical

When the government, by means of the Sunshine Act, set new laws in place for medical experts’ compensation compliance, ETC designed and implemented a relational database application in a multi-user environment using MS Access.

Working with the legal department and the admnistrative team, we defined the rules based on the Federal Govenrment as well as the additional rules required by State Govenments.

Much of the data needed to be entered into forms meeting compliance rules which were built into the database and form fields.

The database was multi-user friendly and provided access to uploading the data to several state and federal databases.

Manufacturing

When a large international manufactuirng company wanted to encourage high level management to review data and drill down to potential problem areas in the supply and demand chain, they called on ETC to create a MSExcel scorecard system.

After analyzing the business case for this project, ETC came up with a project plan that defined the milestones and objectives. Once all project documentation was approved we entered the concept phase of the project. The storyboard displayed the type of information each sheet would display and a brief explanation of how the end user would interact with the data on each sheet.

The development phase included design, calculation and programming.

The testing phase allowed the project leads to follow the logic of the drill down and make recommendations for changes. The final testing phase resulted in approval by all team members and stake holders. Success!

Asset Retrieval

A small company but a giant in its industry revolutionized how organizations with asset retrieval problems that heavily cut into their profit margins could contract with them to reverse the losses. The company is committed to and continues to deliver new innovations driving continuous improvement for their clients. Through this digital transformation, the company has brought real-time single platform visibility, predictive analytics, and decision tree automation- delivering highly targeted, and significantly improved business outcomes for their clients. They recognize that it all starts with their employees and the skills they need to deliver those business outcomes.

ETC contracted with this company to provide in-depth training on MS Excel and MS Access. The volume of data sent by their clients needed to be optimized for call center use and reporting back to the client. We designed three levels of training for each software package. Each level of training was broken down into two three-hour classes held over several days. Once a student felt competent working with the skills obtained in one level, they were invited back to continue their learning.

Most employees were required to take the training. This was an on-going training project for several years as the workforce grew and the needs became more and more sophisticated.