HAROLD HILL MORFORD

Indianapolis, IN 317-***-****

adcuky@r.postjobfree.com

Senior Business Analyst

SUMMARY:

BS/BA Equivalency, 7+ years of business support and project experience with high attention to detail

Extensive daily experience collecting business requirements for development of eagerly awaited Business Information

At ease in the classroom or conference room presenting technical information to a diverse audience

Advanced understanding of SDLC procedures (ELANCO)

Support report development, requirements analysis, design and test strategies (Lilly Clinic)

Hi Level experience with Microsoft Office products such as Word, Excel, and PowerPoint

Provided services for pharmaceutical Sales and Marketing, clinical trials and healthcare IT

Created Excel Spreadsheets from SQL database queries using SAP Reporting Tools - distributed globally - Used Agile Methods to meet needs of business (Roche)

Program and Project Lead experience - Lead Programmer (Raytheon)

TECHNICAL SKILLS:

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

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 – Document use cases and acceptance testing – Distribute globally

Languages: Visual Basic for Applications (VBA), SQL, T-SQL. Visual Basic (VB)

Reports Development: Crystal Reports and Business Objects, SAP WEBI, Tableau, SSRS, SSIS

Business Development: MS Office (Word, Outlook, Excel, PowerPoint, Visio) Adobe Acrobat

Alphadas: EDC system for early phase clinical trials (Lilly Clinic) – TIMS6ERP GOLDMINECRM SalesforceCRM Web-Based Applications

Databases Development: Microsoft SQL Server, Design Studio, Microsoft Access

PROFESSIONAL DEVELOPMENT:

Salesforce Fundamentals 2016, Tableau, Advanced Training 2016, HIPAA Certification 2008-2016 Roche Health Solutions, Indianapolis IN – Lawrence Central High School, Diploma – BS/BA Equivalency - Computer Technology Training 12 months, Communication Switch Manager 12 months, Communication Equipment Instructor 24 months US Army - Sigma Mainframe Systems Instructor 24 months Xerox Data Systems

PROFESSIONAL EXPERIENCE:

Remote Information Technology, Indianapolis, IN 4/2016 – Current

Independent Consultant

Sold Needs Analysis, Requirements and Process review services for small to medium companies

Used Agile methods while collecting BI needs during secure collaboration

Added detail to requirements while creating functional and technical specifications

Currently I am looking for a challenge with a variety of clients and technologies

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

Business Support Consultant

Used Agile methods while collecting BI needs during collaboration

Developed requirements from needs and documented

Added detail to requirements while creating functional and technical specifications

Ensured functional specifications were sound, efficient and supported company goals

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

Acted as liaison to resolve problems and to interact with technical resources

Assist with tracking and Project metrics

ADDITIONAL RELATED EXPERIENCE:

Eli Lilly & Co., Indianapolis, IN 12/2006 – 3/2008

Clinical Business Analyst

Support Lilly Clinic internal and regulatory report development

Interview business and unit leaders for requirements

Propose best solutions to business

Analyze business needs transforming needs to requirements documentation

Create goals containing increased detail

Plan report testing; prepare for construction

Translate requirements and goals to design documentation

Build Crystal Reports from design; code in VBA and SQL

Perform unit and integration testing

Deploy Crystal Reports for distribution

ELANCO Animal Health, Indianapolis, IN 2/2005 – 2/2006

Regulatory Reports Analyst

Provided adverse events reporting to ELANCO regulatory per FDA, EPA, and European Union

Analyze business needs transforming needs to documented 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 for Applications and SQL

Performed unit, integration and system testing, end user and business partner acceptance testing and deploy reports

Raytheon Engineering & Production Support 10/2000 – 11/2004

Indianapolis, IN

Technical Lead/Project Analyst

Elicit project requirements and document

Develop and implement Access and SQL Server databases

Convert Quality Control system from Revelation DB to Access SQL

Convert Proposal System from Access SQL to SQL Server

Improved configuration management and data dictionary for in-house proposal system

Write test procedures for new releases and Assist other developers

MILITARY CAREER:

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

Contact this candidate