Technical Proficiencies
Platforms: UNIX, IBM-****, Windows, Mainframe, Oracle 10g,
Tools: Excel, Access, Word, Power Point, Visio, UNIX Editor, SQL, Toad,
Outlook, Sharepoint, Mercury Quality Center
Experience equals faster employee Return On Investment
Veteran manager with a long history providing process improvements and
efficiencies through automation. Demonstrated success in leading teams
through Joint Application Design sessions producing clear concise
artifacts. Strong personal core values of Honesty, Integrity and Service
Excellence. Always strive for win-win solutions in all efforts. Unmatched
problem solving and personal initiative. Strong internal drive to succeed
while helping others maximize their potential.
Examples of Value Add
. Contributed key requirement documentation that kept a legacy
conversion project delivery on time.
. Authored and served as liaison for business case development,
requirements gathering and coordinating with developers to implement
an Engineering Inventory Control and Workflow Management System in
support of capital equipment investment > $54M.
. Authored requirements and liaised with developers and stakeholders to
integrate ordering, and inventory Support Systems for trending
historical equipment data for over 900 Central Offices.
. Authored Use Cases and Visio Screen Prototypes to convert a legacy
3270 Work Management System to Oracle Client-Server with a Visual
Basic front end GUI.
. Defined requirements and managed the implementation of an Access
database for order tracking and provisioning of a new product.
. Authored requirements and developed code to create an automated
quality control application that verifies technician quality and
productivity.
. Implemented an automated employee measurement tool.
. Teamed with stakeholders to develop in excess of 1000 requirements for
an upgrade of a Customer Relationship Management System.
Areas of Expertise
. Project Management
. Team leadership
. Capital budget and inventory control
. Process Improvement/Business Process Reengineering
. Process Mapping and Work Flow for 'As is' and 'To Be' business models
. Systems Development Life Cycle (SDLC)
. Business Analysis/Application development and support
. Relational Database concepts
. Joint Application Development (JAD)
. Writing SQL queries to analyze database functionality and testing
. Total Quality Management
. System and Integration Testing
. Technical Documentation
. User Acceptance Testing
. Communication
Professional Education
Montgomery College, Rockville, MD 20850
Associates of Applied Science, Systems Management, December 1997
Verizon Communication/Philip Crosby Associates, Inc
Total Quality Management, 1994
University of MD Baltimore
Oracle for Software Developers, 2002
Professional Experience
Arbitron
Senior Project Analyst December 2007 to Present
Scope: Portable People Meter - Oracle 10G Enterprise Application Software
used for collecting and analyzing National and International media
audience and marketing information data
Scale: Supports Business Intelligence reporting as well as 100+ direct
system users
Duties and Responsibilities:
. Analyze requests for system enhancements and write Business Narrative,
Test Strategy and Test Cases for an Operations Support System.
. Critically evaluate the information gathered from multiple sources,
reconcile conflicts, decompose high-level information into details,
abstract up from low-level information to a more general
understanding, and distinguish between user requests and underlying
true needs, as well as solution ideas from requirements.
. Write requirements specifications according to standard templates,
using natural language simply, clearly, unambiguously, and concisely.
. Lead requirements analysis and verification, ensuring that requirement
statements are complete, consistent, concise, comprehensible,
traceable, feasible, unambiguous, and verifiable, and that they
conform to standards.
. Manage changes to baseline requirements through effective application
of change control processes and tools.
. Use SQL to analyze back-end data in Oracle DB.
. Perform System Integration Testing to validate requirements with
impact to other systems.
. Support User Acceptance Testing
Verizon Business March 2007 to December 2007
Consultant - Business Analyst
Scope: Siebel Customer Relationship Management System for IP Application
Hosting/Management Services
Scale: Supported Sales to Cash processing for 200+ system users
Duties and Responsibilities:
. Gather Business Requirements from all stakeholder groups for a COTS
Siebel replacement project.
. Investigate background processing and web methods used for data
exchange to ensure there are no missed requirements.
. Analyze existing manual processes for possible inclusion in the
project.
. Analyze requirements for a billing system replacement and integrate
known requirements into the billing project. Ensure requirements are
clear, concise and unambiguous.
. Build 'to be' workflows and data dictionary.
TeleBright August 2006 to March 2007
Business Analyst
Scale: Small Business Web Application support of Telecom Expense
Management for commercial and government customers
Scope: Small Office client base of 12 employees
Duties and Responsibilities:
. Facilitate JAD sessions to gather requirement enhancements.
. Write detailed requirements for enhancements and modifications to a
Telecom Expense Management application.
. Research and investigate Telecom products and services.
. Prototype an Access database to map Customer Service Request (CSR)
billing to customer accounts for tracking and cost allocations.
. Participate in Quality Assurance testing to ensure all requirements
meet objectives.
. Design activity diagrams, data flow diagrams, context diagrams using
Visio.
. Prepare Test Plan and conduct testing with sample data.
Tek Systems/Time Warner Cable Sept. 2005 to April 2006
Data Integrity Manager
Scale: Multiple Enterprise level business Sales to Engineering Inventory
Systems merging in Oracle database.
Scope: Supported executive level managers to produce Sales/Inventory
analysis and reporting among various Time Warner Entities.
Duties and Responsibilities:
. Work with stakeholders to collect requirements and translate
requirements into design specifications.
. Coordinate application documentation, planning, and rollout.
. Compare data between source and target systems using Unix-VI to
manipulate data as well as PL/SQL and Toad to create database and run
reports for data compares.
. Use Excel to analyze results and provide management reports to user
groups.
. Data manipulation includes search/replace in VI to standardize data
and eliminate control characters.
> Data cleaning
> Removing redundant data
> Pattern search/replace
> SQL code to compare table data
. Use Oracle SQL-Loader control files to add columns, load dates or null
column data. Source data provided in comma delimited format.
> DML in Oracle PL/SQL for Table builds and updates
> Analyze results and make process improvement recommendations to
upper management.
Corporate Professional Services, Inc. /Lockheed Martin May to
August 2005
Business Analyst
Scale: Web Application supporting Social Security conformance to record
retention requirements
Scope: Clients included 25+ onsite and offsite contract and government
employees
Duties and Responsibilities:
. Develop requirements documentation using a release management tool to
track versions and create documents in MS-Word.
. Create Project Plan, Scope, Business Process, and General User
documentation.
. Design activity diagrams, data flow diagrams, context diagrams and use
case diagrams using Visio.
. Meet with end users to discuss requirements and then translate them
into developer ready documentation.
. Research and analyze National Archive Records Administration
directives to clarify requirement objectives.
Advance Technology Solutions/Verizon August to December 2004
Systems Analyst
Scale: Enterprise level 3270 IBM Main Frame system upgrade to Oracle 9
database with GUI app supporting Verizon's Work Management
functions.
Scope: Supported contract team to produce requirements based on existing
application documentation. No direct end user interaction.
Duties and Responsibilities:
. Analyze legacy system and resource documents to detail 'As Is'
workflow.
. Design new web based GUI screens using Visio.
. Develop test cases based on system-documented requirements.
. Develop data dictionary and integrated relational data fields with
other sub-system requirements.
. Research and document legacy batch processing by reverse engineering
code.
Verizon Communications March 1984 to November 2003
Telecommunications Manager
Scale: Enterprise level 3270 IBM Legacy Network Equipment Inventory System
Scope: Supported Mid-Atlantic Engineering Department for Provisioning of
Network Services
Duties and Responsibilities:
Years of business management experience with increasing levels of
responsibility in Operations and Engineering process areas.
. Project Managed complex engineered products and services, i.e., LAN
implementations, Network rings, etc.
. Staff Specialist responsible for enhancements to a large equipment
inventory assignment system.
. Supervised a group of 10 union Operations employees responsible for
engineering and testing complex services.
. Ten years developing automated scripts to process repetitive work
steps including all requirements, coding, system integration, testing,
release management, user training and support.
. Managed 20 union employees in an Operations call center environment.
. Implemented process improvements, employee measurement tools and
reduced ordering backlog from 15,000 customer orders down to zero.
. Provided Key performance reports to executive management for Sales
versus In-Service Product activity.
. Provided Human Resource coordination including annual performance
payouts and policy coverage for four Engineering and Operation
departments with over 500 employees.
. Provided Administrative support to an Engineering-Switched Services
work group with 15 technical managers.
References
Jean Rothwell - Arbitron Project Manager - *********@***********.*** 301-
509-6087
Kristi Sturm - Verizon Project Manager - ******.*****@*******.*** 410-487-
0740
Maryann McDonald Senior Systems Analyst
**********@*******.***