Clark Maxwell
208 Buli Lane
Bolingbrook, IL
630-759-9446
clark_maxwell@hotmail.com
BUSINESS ANALYST
Senior business analyst with over 15 years experience in requirements
gathering, analysis and elicitation; business process improvement, including
work process/work flow analysis, functional requirements analysis, object
oriented design, engineering/reengineering and documentation.
Experienced in Rational Unified Process (RUP) methodology, Universal
Modeling Language (UML), use cases and application of use case maps
for requirements definition, including its application as a use case-driven,
architecture-centric, iterative and incremental approach to software
development. Extensive experience in application design and development,
specializing in system development life cycle (SDLC) methodologies,
concepts, application and management, from conceptual design to system
testing and quality control; asset management, change management, release
and configuration management. Also experienced with object-oriented
application interface design, development and coding; RDBMS design and
programming, including data entity-relationships, data analysis and
tuning, data repository and data warehouse design, development, analysis
and population; mainframe/legacy systems, processes and applications
conversion. Extensive industry experience in developing accurate
business process requirements for financial services, pharmaceutical,
manufacturing and food service processes. Specific experience with and
applied knowledge in financial services and investment management, trading
systems, supply chain management, inventory management, AR/AP, general
ledger, customer relations management (CRM), electronic data interfaces
(EDI), bar-coding and serialization, product development, marketing,
and federal compliance (FDA, DEA, HL7, HIPAA regs.) business processes.
SOFTWARE DEVELOPMENT TOOLS
Programming Languages
PowerBuilder 8.0, Visual Basic 6.0, C/C++, Gupta SQL Windows,
Visual C++, Active X, COM/DCOM, VBA, HTML/DHTML, Oracle tool set --
PL/SQL, Oracle Developer 2000, Oracle Forms, Oracle Reports, Discoverer,
Borland and Microsoft C, Microsoft Quick Basic, UNIX Shell scripting
languages, VB and Java script, Active Server Pages, FoxPro, Clipper
ERP/CRM Systems
Oracle 11i, Siebel, FileNet ECM
RDBMS/Database
Oracle 8i/9i, DB2, Gupta SQLBase, Sybase ASE 12.5, SQL Server
6.5/7.0, Ingres, XDB, MS Access, xBase, Watcom, Informix 7
Operating Systems/Networking
Windows NT/2000/XP, TCP/IP, HP-UX, Red Hat Linux, Grid computing
Development Support/Testing Tools
Rational XDE, Requisite Pro, ClearQuest, ClearCase, PVCS, Visual
Source Safe, ER/Win, Visio, MS Test, MS Project, MS Excel, Crystal Reports
Enterprise, iLog JRules
Business Analysis
Rational Unified Process (RUP), Agile development methodologies,
Universal Modeling Language (UML), process engineering/reengineering,
RAD/JAD, requirements gathering, analysis and documentation, systems
analysis, architecture and design, use case development, quality assurance
and UAT test planning, system development life cycle
Industries
Financial, Insurance, Legal, Manufacturing, Engineering, Sales/Marketing,
Actuarial, Inventory Management, Supply Chain, Health Care, R&D,
Warehousing & Logistics
Quality Assurance/Testing
Automated testing: Key-Word Driven/Test
Plan Driven methods; manual testing: user acceptance, bash testing,
functional, integration and regression testing; test validation, bug
fix reporting and tracking, UAT design and management.
ACCOMPLISHMENTS
CONSULTING EXPERIENCE
Over ten years experience as an independent consultant for Fortune 500, 1000 and leading corporations, experienced in application and management of SDLC processes, requirements analysis, functional design, business process engineering/reengineering, mainframe/legacy systems conversion, project management, application design, development, coding and implementation.
US Foodservice
Skokie, IL
10/07 to
Present SENIOR BUSINESS ANALYST
Responsible for full SDLC activities
and deliverables, project and implementation planning for the pilot
implementation of warehouse slotting optimization software to improve
warehouse pick performance and increase labor management efficiency
at USF distribution centers in CA and SC. Duties include project
scope definition and management; requirements gathering, analysis and
documentation; workflow analysis, project coordination and management;
coordination and leading of business rule and technical design sessions
with business sponsors and technical teams; development of project plans
using MS Project; identification, documentation and diagramming of key/impacted
business processes using Visio and PowerPoint, working with business
sponsors to identify and document key performance indicators (KPIs)
to integrate with new business rules for warehouse management performance
measuring. Also responsible for working with development team in creation
of functional requirements and coding specifications, test planning
and documentation; working with deployment teams to develop and manage
implementation plans; management of work product and deliverables of
project team, providing regular status reports to executive staff and
business sponsors, management of project issues and risks log, escalation
processes and change control, maintenance of internal project web site
using Lotus QuickPlace.
Illinois Department of Human Services
Springfield, IL
04/07 to
10/07 BUSINESS PROCESS MANAGER
Responsible for business process improvement,
process flow analysis, and through interaction and collaboration with
the various DHS Divisions, identification and documentation of improvements
to processes as required or desired through the use of standard business
process redesign tools and practices, in accordance with standard SDLC
methodology, including asset, change and release management. Duties
include project conducting staff interviews for identification of opportunities
for process improvement and automation, development and documentation
of system requirements for the various functional groups within DHS,
working with application development teams in incorporating functional
and data management requirements into DHS systems, planning and management,
and serving as technology advisor to the various DHS program divisions.
As lead, developed and maintained business process modeling notation
(BPMN) standards for flow charting, developed and maintained flow diagrams,
using Visio, of all identified processes, created and maintained use
cases, requirements and design documentation. Also organized and
led JAD sessions for process improvement and optimization.
Northern Trust Bank
Chicago, IL
07/06 to 04/07 BUSINESS/SYSTEMS ANALYST
Responsible for requirements gathering,
analysis, design and documentation of business processes and software
requirements for upgrades for the bank’s investment and asset
management systems, including asset allocation and trading systems and
applications. Duties include conducting departmental staff interviews
for requirements gathering and process flow documentation, development
of full SDLC deliverables - scope, high-level business requirements,
process flow diagrams illustrating opportunities for process improvement,
use cases, low-level requirements and test plan documentation; management
of SDLC processes, including configuration, change, release and implementation
management processes; creation of UML diagrams, using Visio for development
of workflow, storyboards and process modeling; requirements management
– including scope and traceability, project planning and methodology
and implementation and enforcement of RUP best practices and quality
assurance. Also responsible for test plan development, management
of UAT phase. Responsible for team of 3 developers and junior
business analyst, perform data analysis, provide technical assistance
for architectural design and coding for PowerBuilder/Sybase developers,
performance tuning.
Chicago Department of Public Health
Chicago, IL
04/06 to 07/06 BUSINESS ANALYST
Responsible for the analysis, design,
development and documentation of business requirements, workflow processes
and business rules, and technical specifications for the integration
of the Chicago Health Event Surveillance System (CHESS) and the Illinois-National
Electronic Disease Surveillance System (I-NEDSS); development of HL7
messaging for bi-directional case and disease report exchange, in text
and XML formats, in accordance with HL7 specifications; ensured requirements
and process compliance with HIPAA requirements. Duties included
analysis of existing I-NEDSS use cases, requirements gathering, analysis
and documentation of existing business process for city and state health
department users and SMEs, development of statement of work, requirements
documentation and use cases, including UML use case, activity and sequence
diagrams, functional requirements, software requirements and business
rules, creation of workflow and high level architectural design documentation.
Duties included project planning and estimation, change and implementation
management, coordination of technical team and business units, conducting
staff interviews for requirements gathering, and JAD sessions.
Technologies used in solution design include Oracle 9i, PL/SQL, Business
Objects, DB2, BEA WebLogic, Jav, UNIX shell scripting. Also responsible
for business requirements gathering and technical requirements analysis
and documentation for FileNet-based document management system.
Information Resources Inc
Chicago, IL
03/05 to 04/06 BUSINESS ANALYSTS
Responsible for business process engineering
and mapping, business process modeling with UML, requirements gathering
and analysis, and creation of low and high-level functional design documentation,
use cases, technical specifications, and other artifacts in accordance
with agile development methodologies; development of use cases, storyboards
and object-oriented analysis and design using Rational XDE, project
resource planning and risk analysis and management, for legacy mainframe
systems conversion. Duties include organizing, managing and running
JAD sessions with developers and client representatives, conducting
client interviews with staff and SMEs, system architecture, UAT and
test plan development, defect management and development of user acceptance
test programs. Responsible for implementing and managing change
control processes and release management. Technologies used included
Red Hat Linux 7.3, Java, C++, Oracle, DB2, Data Stage, iLog JRules,
Perl and Shell scripting.
Culligan International
Northbrook, IL
10/04 to 03/05 BUSINESS ANALYSTS
Responsible for design, development and
implementation of serialization and bar-coding methods, processes and
systems for Culligan's product lines. Use of RUP and UML for business
process and application design, development of use cases for requirements
analysis; system software and hardware component evaluation and selection;
system architecture and database design and development, including development
of stored procedures and SQL queries for reporting. Developed
MS Access ad hoc query tool, and custom queries and reports, to extract
data from SQL Server. Developed functional and conceptual design,
specifications and work and process flow diagrams, through interviews
with business and technical staff. Also, responsible for project
plan, test plan development, budget planning, change control, configuration
and release management strategies; vendor contacts, specifications
and selection.
Seaton Corporation
Chicago, IL
05/03 - 10/04 QUALITY
ASSURANCE ANALYST
Responsible for maintenance and quality
control of recruiting processes and procedures, and process engineering
for users of Oracle 9i based custom client/server and web based recruiting
and reporting applications, including report development using Crystal
and Oracle Reports. Duties include QA through software testing
-- user, system and acceptance test plan development and management;
change and release management, monitoring of recruiter software usage,
conducting interviews with staff and external clients for requirements
gathering and process analysis, reporting and tracking of bugs and fixes;
data analysis and reporting using PL/SQL, Crystal Reports, Excel and
MS Access. Developed MS Access applications for users as
data analysis and query tools, with custom reports and queries.
Also responsible for enhancement and maintenance of FileNet-based document
management systems. Developed system and user documentation, and
training.
BrainBench
Chantilly, VA
9/02 - 10/04 TEST DEVELOPER/VALIDATOR
(part time/telecommuting)
Test developer and validator responsible
for developing BrainBench web-based skills evaluation products for Powerbuilder
8.0, and Sybase ASE 12.5 and SAS 8.2 skills certification tests, respectively,
for all skill levels, from beginner to advanced. Duties include
developing test curriculum, and questions, validating test questions
and answers for relevancy and accuracy, and overall quality assurance.
Coordinate test development and validation with test validation team.
Chicago Public Schools
Chicago, IL
10/02 - 12/02 SYSTEMS MANAGEMENT TRAINER
Trainer responsible for designing training
curriculum for Chicago Public Schools (CPS) Technical coordinators,
use of Microsoft’s Systems Management Server (SMS) 2.0 to develop
software packages for distribution over an enterprise, application management,
maintenance and technical support techniques and methodologies using
SMS. Duties included teaching basic networking concepts and systems
administration and software installation and support skills and methodologies
on Windows NT and Windows 2000 networks.
Sara Lee Bakery
Chicago, IL
12/00 - 5/02 PROJECT LEAD/BUSINESS
ANALYST
Developed and implemented business processes and successful integration and development of various applications to automate and simplify food formula development process in adherence with FDA regulatory certification process (CFR Part 21) requirements for food formula development. Responsibilities include requirements gathering through departmental staff interviews and JAD sessions, SDLC, application of RUP methodologies, UML diagramming, including use case, activity, sequence and class diagrams, and the development and realization of use cases in the reengineering of business processes and design, development and implementation of software applications; responsible for change control and release management processes and activities. Developed conceptual and functional design documents, requirements documents, work and process flow diagrams and storyboards; data modeling and database design/redesign to incorporate changes to Oracle 11i Supply Chain modules. Also responsible for development of coding specifications for interface design in VB 6.0, and Visual FoxPro, e-commerce interfaces; development of VB and FoxPro code, and Oracle 8i stored procedures using PL/SQL, report design and development using Oracle Reports.
Alliant Food Service
Northbrook, IL
7/00 - 12/00 BUSINESS ANALYST/PROGRAMMER
Responsible for requirements gathering
and analysis of business processes, development and analysis of use
cases, project management support and programming for the conversion
of mainframe legacy sales force management and planning applications,
and accounting applications to client/server. Duties conducting
interviews with staff and review of existing documentation for requirements
gathering; analysis and documentation of business rules for sales force
management, defining and documenting rules for alignment of territories
by clients and sales reps, commission and incentive calculation and
payment, and sales reporting. Developed new business processes
and process improvements based on analysis of business requirements,
development of interface design specifications for client server and
web interfaces and work flow using Visio, and creation of programming
specifications for four programmers. Also implemented Informix
7.0 database modifications and enhancements, modifications to Korn shell
scripts and stored procedures for new processes for data conversion
and cleansing, sales and commission data loading and archiving.
Implemented programming changes to application interfaces using PowerBuilder
6.5/7.0, MS Access, including development of custom reports and SQL
queries to provide user interface to Informix data, and Excel (VBA),
and modification of ODBC connection objects.
Pharmacia/Upjohn
Utilities International
Chicago, IL
1/99 - 4/99 IT CONSULTANT
Performed client/server application development
and business requirements analysis for management information and financial
analysis software tools developed for public utility clients of UI.
Duties included development of Profit & Loss statement reports,
and other financial reporting modules using VB 5.0/6.0 and Crystal Reports.
Also responsible for Oracle database design and development of stored
procedures, functions and triggers using PL/SQL. Identified and
documented application process and interface requirements and functionality
through development of use cases via information gathered from users.
Programming tasks included development of COM/DCOM objects, creation
and maintenance of ODBC connection objects, and RDO/ADO programming.
COMDISCO
Rosemont, IL
8/98 - 12/98 APPLICATION DEVELOPER
BP/Amoco
Chicago, IL
4/97 - 6/98 IT CONSULTANT
Developed and maintained new and existing
project planning, financial forecasting, sales and marketing applications
using Visual Basic 5.0/6.0, ODBC, MS Access and Excel. Duties
included integration of application interfaces with MS Office using
OLE and VBA, analysis of user requirements and business processes, and
design and documentation of application specifications using ER/Win
and Visio. Developed custom interfaces, reports and SQL queries
for users in MS Access, to provide ad hoc query and reporting capability
to users for Oracle data. Provided installation and configuration
support for custom and off the shelf enterprise-wide VB applications,
developed and maintained source code for new modules for business and
site development applications. Also developed, tested and implemented
Oracle stored procedures using PL/SQL, modified existing application
interfaces and reports using Developer 2000 and Crystal Reports.
Duties included maintenance of existing and development of new Unix
Korn and C shell scripts for sales/marketing EDI data extraction and
uploading to Excel spreadsheets and MS Project files, management of
client/territory alignments, sales reporting, and conversion; archiving,
and managing batch and K-shell scripts.
SBC/Ameritech
Chicago, IL
11/96 - 3/97 SOFTWARE DEVELOPER
Maintained and enhanced software applications
for sales force and contact management, client/territory alignment,
sales commissions and incentive calculation and payment, door-to-door
sales contact management and leads generation, and sales report development
for startup cable television service provider, using PowerBuilder 4.0/Oracle
7. Maintained and modified Oracle stored procedures for data management,
including upload and archiving of data using PL/SQL and SQL Loader.
Maintained and modified external processes for synchronizing sales systems
data loading and archiving between Oracle databases and legacy systems,
and documentation of business requirements and processes. Installed,
configured, maintained and supported off-the-shelf software for ad hoc
data mining and analysis for use by sales department users, and FileNet
based document management systems. Identified, developed and documented
requirements and technical documentation for existing sales applications
and enhancements using Visio and MS Word.
ERNST & YOUNG
Heller International
Bell & Howell
Tenneco Packaging
Bell & Howell
Freidman, Eisenstein, Raemer & Schwartz (FERS)
PROFESSIONAL EXPERIENCE
Computer Sciences Corporation (CSC)
EDUCATION
BS Chemistry, Minor Computer Science
Training
Network Administration
Telecommunications Systems Management
Business Management and Development
Series 7/66 Securities Training for Financial Management
Other