SUMMARY:

• Over 10 years of experience in business process modeling and engineering leading change management projects.
• Deep experience developing functional requirements and software requirements using the Software Development Life Cycle.
• Experienced working with business unit executives to identify strategic business opportunities and leveraging technology to achieve them and track achievement using data warehouse Key Performance Indicators (KPI).
• Significant experience architecting system interfaces, bulk data loads, data cleansing and data deduping for data warehousing and master data management.
• Excellent leadership skills with experience managing change in challenging environments.
• Excellent communications, analytical and presentation skills.

SKILL:

Databases: Oracle, MS SQL, MS Access, Websphere, Cognos PowerPlay

Enterprise Systems: Siebel, SAP, Oracle, Salesforce.com (multiple versions, modules in each)

Other Tools: Visio, MS Project, Altova XML Tools, Minitab, SAS, Doors, WinRunner

Methodologies: Agile, OOAD, RUP, Waterfall, Lean, Six Sigma

Industry Standards: CFR 21 Part 11, HIPAA, HL7, ISO

PROFESSIONAL EXPERIENCE:

Confidential, Addison, TX

Business Analyst

• Worked closely with business executives to determine overall technology strategies for Confidential .
• Advised on integration of systems technologies between Confidential and Tesco’s CRM and inventory and planning systems ahead of the planned merger.
• Mapped processes and developed requirements for implementation of Oracle’s Planning and Retail Management solution.
• Developed functional requirements for implementation consultants.
• Oversaw development of the ETL approach in seeding and managing master data.
• Developed functional requirements for a mobile ordering app for customers placing orders.
• Developed metrics and KPIs to measure successful implementation and use of the systems in achieving business objectives.

Confidential

Business Analyst / Project Manager

• Provided database creation and application development for clients using Microsoft Access and Visual Studio. In addition to database modelling, this also included query design and report development.
• Wrote functional requirements and system specifications for each project.
• Modelled business processes using flow charts and Use Case diagrams.
• Developed customized spreadsheets using Microsoft VBA for automation.
• Wrote user acceptance testing modules and conducted user acceptance testing.

Confidential, Abbott Park, IL

Project Manager Business Excellence

• Successfully negotiated and launched Abbott’s first partnership with a 3rd party service provider for servicing customer analyzers. Negotiated with purchasing and legal resulting in a master services agreement, a statement of work, and a set of performance metrics to be used in quarterly business reviews of the partnership. The resulting partnership enabled field service to improve service level focus on the newest automated flagship instrument platforms while holding headcount. Project nominated for President’s award.
• Led a nationwide project to review problems with installation of Abbott’s flagship automated diagnostic analyzers nationwide . Mapped processes identifying systematic variation and process deviation across the country. Proposed solutions to stakeholders using Lean and Six Sigma methodologies implementing new core common processes for analyzer installations. This resulted in bringing analyzers online quicker by several weeks, on average, which enabled quicker billing for reagents (consumables) estimated at an additional $1.5 million the first six months after project completion.
• Worked with the data warehousing team to develop reports reflecting business KPI’s.
• Reviewed problems with
• Documented business processes and re - engineered common processes (using Viso) to reduce variation and streamline future implementations.

Confidential, Abbott Park, IL

Business Analyst / Project Manager, Sales Commercial Applications

• Worked with sales and service executives to develop KPI’s to measure and track business performance with the data warehouse implemented in my previous role.
• Implemented several sales realignments using Oracle and Microsoft MapPoint to improve coverage of key business resulting in 20% increase in sales for flagship analyzers.
• Implemented inventory consolidation for service parts used in the field resulting in a $750M inventory reduction, lower trunk stock, and improved reliability of parts held. The process was executed using Lean Six Sigma analysis.
• Worked with data warehousing team to develop reports reflecting business KPI’s.
• Traveled with the Sales and Service General Managers in the field to conduct business reviews with district managers in each district using the reports and KPI’s I developed.
• Lead analyst for an implementation of Salesforce.com for U.S. Diagnostics sales, responsible for requirements, project traceability, system testing and end-user training.

Confidential, Abbott Park, IL

Business Analyst / Team Lead, Commercial Operations IT

• Team lead for the application integration team of consultants for a Siebel CRM rollout to the U.S. Customer Support Center and Field Service technicians. This rollout required interfaces to 34 legacy applications including many to SAP.
• Team lead, implementing a Data Warehouse using Siebel Analytics and Cognos PowerPlay.
• Projects were implemented with small development teams using the Agile methodology with frequent iterative and incremental development cycles shared with stakeholders.
• Performed GAP analysis of existing system interfaces.
• Created extensive application and data interface models and maps using Visio.
• Initiated a successful pilot implementation of a corporate-wide Application Integration Center of Excellence leveraging existing relationships with IBM (Websphere), Siebel, SAP and Abbott’s corporate IT division to deliver application integration.
• Led several committees on Abbott’s Intra-Divisional IT Council delivering corporate standards for implementation of business applications and application integration practices.
• Implemented incident tracking for post-rollout and support to manage any implementation issues and to leverage the body of knowledge for future implementations.

Confidential, Abbott Park, IL

Business Analyst, IT Marketing

• Team lead for the first implementation of Siebel CRM within the Diagnostics division for U.S. Marketing and Contracting and Pricing.
• Worked with marketing to prepare Use Case diagrams and Business Process Requirements using Visio and Rational Rose.
• Led a second Siebel CRM and Sales implementation to the sales force in Canada.
• Worked with business unit to develop KPI’s to track improvement efforts in managing customer relationships and contracts.
• Worked with IT and marketing to develop System Software Requirements.
• Wrote test protocols for system testing and user acceptance testing.
• Authored system training materials and conducted end-user training.

Confidential, Abbott Park, IL

Business Analyst, Diagnostic Assay Manufacturing

• Developed user requirements and led system testing for an MRP system implementation in Assay manufacturing including interfaces between the PLC systems on the manufacturing lines and the Laboratory Information System (LIMS).
• Implemented a custom software application that bolted onto manufacturing PLCs to capture system downtime and causality.
• Used Rational Rose for managing requirements and traceability.
• RUP and OOAD methodologies were used on all projects.
• Developed system and user test protocols and oversaw system testing for multiple projects.
• Created training materials and conducted end-user training for multiple projects.
• Worked with engineering to develop ongoing upgrades to the AS400 mainframe.

Confidential, Chicago, IL

Process Engineering Designer

• Designed equipment layout and supervised installation of food process equipment production lines at Hills Pet Foods (Science Diet), Quaker Oats and Nasbisco Foods.
• Upgraded control systems and PLCs on the implementation at Hills Pet Foods.