Sign in

Analyst Manager

Indianapolis, IN, 46236
January 07, 2020

Contact this candidate


Harold Hill Morford


Business Analyst


BS/BA Equivalency based on training and experience

Highly motivated, goal driven, innovative, curious and open minded, fun to work with, team player

12+ years Business Support and Project experience with high attention to detail

5 years ERP Developer experience in pharmaceuticals

Collaborate at all levels regarding proposed and active projects

Document secure requirements, defects and process events

Make recommendations, create and publish periodic reports

Develop Ad Hoc reports that meet requirement needs

At ease presenting information to diverse audience in class or conference room

Support cross functional documentation covering development, testing, and deployment

Proficient use of SDLC procedures and processes and Agile methods

Routinely use Microsoft Office products such as Word, Excel, Access and Visio

Military career:

US Army - SP/6 E-6, Veteran, Honorable Discharge, Service: 6 years

Technical skills:

Platform: Microsoft (Windows, Office, SQL Server), SAP (Report Development tools)

Experienced: Consultant - Business Analyst - Reports Analyst – Instructor

Developed: 3D Database – Training Seminars – Management Apps

Skills: Collaborate with management – Collect user stories, needs and wants Convert needs and wants to requirements – Add detail to requirements with functional and technical specifications – Design Use Cases and Acceptance Testing – Distribute globally – Document process events

Languages: MS SQL, T-SQL, Access, VBA

Reporting: SAP (Crystal Reports, Business Objects, WEBI), Alteryx Analytics, Tableau

Business: MS Office (Word, Outlook, Excel, PowerPoint, Visio), JIRA

: Lilly Clinic Alphadas (Systems for early phase Clinical Trials), Computers Unlimited - TIMS6 ERP, GOLDMINE and Salesforce CRM, Microsoft (SQL Server, Design Studio, Access)

Professional Development:

Salesforce Super User 2016, Tableau Advanced Training 2015, HIPAA Certification 2008 – 2016 Roche Health Solutions – Lawrence Central High School, Diploma – BS/BA Equivalency at Eli Lilly and Company and Roche Health Solutions – Computer Technology Training 12 months, Communication Switch Manager 12 months, Communication Equipment Instructor 24 months, US Army – Mainframe Systems Instructor 24 months, Xerox

Professional Experience:

After Roche, Indianapolis IN

Time-off 4/2016 – Current

Shortly after leaving Roche we had what some call their family situation and we had ours. There was no fun about that but I was able to recharge, working around the house and doing odd jobs. Currently, I’m looking for a new challenge with integrity. I want a flexible environment and the opportunity to work with a variety of clients and technologies for an advanced corporate structure like yours.

Roche Diabetes Care, Indianapolis IN 3/2008 – 3/2016

Business Support Analyst

Experience measuring product performance

Develop reportable metrics and market penetration data from Sales and Marketing leads

Use agile methods to uncover detailed project information during collaboration

Develop requirements from needs and document

Add detail to requirements creating functional and technical specifications

Ensure functional specifications are sound, efficient and support company goals

Write use cases to capture exactly how user would interact with the process

Resolve problems and interact with technical resources

Assist others that track, project metrics and document

Eli Lilly Clinic, Indianapolis IN 12/2006 – 3/2008

Business Analyst

Support Lilly Clinic internal and regulatory report development

Collaborate with business and unit leaders developing requirements

Propose best solutions to business

Analyze business needs transforming needs to requirements

Create goals containing increased detail

Plan report testing; prepare for construction

Translate requirements and goals to document design

Build Crystal Reports from design; code in Pascal, Visual Basic and SQL

Perform unit and integration testing

Deploy reports for distribution

Elanco Animal Health, Greenfield IN 2/2005 – 2/2006

Business Analyst

Support FDA, EPA, and European Union reporting of adverse events for Elanco regulatory

Analyze business needs transforming needs to requirements

Propose best solutions to business unit leaders

Create goals containing increased detail

Translate requirements and goals to documented design

Plan report testing; prepare for construction

Build reports from design; code in Visual Basic and SQL

Performed unit, integration and system testing

Completed end user and business partner acceptance testing before deploying reports

Raytheon Engineering & Production Support - Indianapolis IN

Technical Lead/Programmer Analyst 10/2000 – 11/2004

Elicit project requirements and document results

Develop and implement Access and SQL Server databases for secure environments

Convert Quality Control system from Revelation database to Access SQL database

Convert Proposal System from Access SQL to SQL Server

Develop configuration management and data dictionary for Raytheon proposal system

Write test procedures for new releases and assist other developers

Led presentation regarding project success and direction

Contact this candidate