Project Data
Resume:
Linda J. Barker
**** ******* **., **. *****, MO *3119
**********@*****.***
Business Analyst/Writer with Project Coordination and Leadership - strong
analyst experience during all levels of system development life-cycle
(SDLC) methodologies, requirements gathering and traceability, use cases,
functional specifications, technical design, root-cause analysis,
compliance, Quality Assurance/Control (QA/QC), testing, data modeling and
dictionaries, physical/logical process flows, batch and online data
warehousing reports for both financials and data, third-level customer
support, training, and technical writing (both commercial and military
experience)
TECHNICAL SKILLS
STRADIS, Workbench (Niku), MS-Project, Word, Oracle,
Rational, Visual Basic, Excel, XMLSpy, TOAD,
UML, MultiSpeak, Access, SQL Developer, SQL,
Visio, PowerPoint, SharePoint, SourceSafe, XML,
Iterative (Agile) and Waterfall, Photoshop, Erwin, Mercury QC,
DEFT CASE, Project Gateway, MS-Publisher, TeamTrack, CaliberRM,
MS-Paint, COBOL, C, Java, Netman,
IEEE, ISO, ANSI, CFR, FDA, HIPAA, Rainbow Series, MIL STD 498, Snagit
EDUCATION:
M.A., Quality Management (in progress) Webster University, St. Louis, MO
B.S., Information Technology Washington University, St. Louis, MO - Dean's
List
Certifications: MS-Office Specialist (Master level)
Secret Clearance (passed 2004 investigation)
Testing for Linux+ and studying for Oracle certifications
Consulting: Technisource, St. Louis, MO, Mar 2010-Jul 2010
. Analyzed requirements and designed a functional specification (FS)
solution which included the collection and transfer of web data to the
mainframe and to the Oracle data warehouse
. Planned agendas and conducted live meetings with CitiMortgage managers,
underwriters, auditors, and other Subject Matter Experts (SMEs) to gather
requirements and design new functionality
. Complied with government policies and regulations during design
. Used UAT loan numbers in project screens to learn the system and create
the field mappings
. Designed process flows for current and future states
. Created new format for an Excel field mapping document; included data-
dictionary type information, calculations, and 'what-if' scenarios for all
GUI screens
. Interpreted XML code and SQL queries; estimated work-effort hours for
waterfall phases
SharePoint, Word, Visio, Snagit, Excel, iRise Reader, Live Meeting,
NetMeeting, XML, SQL
Consulting: Adaptive Solutions, St. Louis, MO, Dec 2009-Jan 2010
(two month contract with Safety National, completed ahead of schedule and
within budget)
. Wrote Wi-Fi user guide for remote use of laptops with Wi-Fi connections
including air cards, VPN, Blackberry tethering, airport and hotel hotspots,
direct LAN connections, Internet access on land and In-flight; included
security precautions while traveling
. Wrote pocket guide, troubleshooting guides, and software installation
task list with form checkboxes
Word, Visio, Snagit, Excel
Linda J. Barker
**********@*****.***
Consulting: Comsys, St. Louis, MO, Aug 2008-Jun 2009
(second contract at Express Scripts; extended an extra six months)
. Responsible for management of small projects involving data modeling, SQL
queries, requirements and design for centralized data management, Express
Scripts personnel skill inventories, and reports on customer trends /
demographics (metrics)
. Created Access-Excel project-estimation worksheets - project costs,
resource needs, and risks are now automatically calculated on a standard
format by all managers thus eliminating manual calculation errors; the
project control office uses the worksheets to determine which projects will
be initiated and in what priority
. Interviewed various groups on their metric reporting needs vs. web
consumers' trends; attended JAD sessions then prepared PowerPoint trends-to-
needs summations
. Analyzed personnel skill inventories to determine ratio of SMEs to
training gaps; created and presented a PowerPoint summation suggesting the
inventories should continue as these were a great of gap analysis tool
. Synchronized updates to Physical Data Models (PDMs) including
relationships and keys; created chronology of updates; updated associated
data dictionaries adding attributes not previously included such as,
required vs. optional, sorting, referential integrity, and indexes sorting;
created additional data dictionaries for other applications
. Wrote a High-Level Design (HLD) document for a communications project to
synchronize and centralize patient data and preferences across several
systems ensuring data consistency via a single point of entry; participated
in JAR sessions
. Worked with a nationwide team to create and deploy enterprise-wide design
and programming templates; wrote FAQ documents in lieu of user guides
. Designed SP workspaces using built-in web parts; created and uploaded
training materials, then used the FAQs and templates during stand-up
training of document check-in / check-out, versioning and multiple-user
editing (MOSS); Full Control security
. Wrote standardized deployment, troubleshooting and other playbooks for an
IVR call center project
. Content Management using Microsoft Office SharePoint Server (MOSS) -
organized and created SP table-of-content links to documents, uploaded
documents to folders
. Completed refresher courses on HIPAA, long-term data storage procedures,
and data confidentiality
SharePoint, Excel, Access, Word, Visio, SQL Developer, PowerPoint, HIPAA,
MOSS
Consulting: SSE, Inc., St. Louis, MO, Apr 2008-May 2008
(six-week contract, completed in five weeks; second consulting position at
Monsanto with SSE)
. Used Excel expertise to write VLOOKUPs and other logic statements for
Seminis reports
. Also created pivot tables and wrote nested IF statements
. Combined nested IFs with VLOOKUPs and other built-in functions including
those for one-year
financial budgeting and long-range planning (LRP)
. Set cell, worksheet, and workbook protection as necessary; created data
validation lists
Excel, Word, TeamSpace, SAP
Consulting: TEKsystems, Inc., St. Louis, MO, Oct 2006-Feb 2008
(second TEKsystems position, contract extended from Sep 2007 to Feb 2008)
. Wrote numerous system use case documents containing state-specific
criteria for GMAC insurance
. Managed the writing and implementation of integration and smoke test
scripts for several projects
including compliance to Department of Insurance (DOI) mandates, updates
to state rules, cash, and book roll dealing with commercial credit and
debit cards
. Utilized root-cause analysis to assist with troubleshooting errors and
messages
Linda J. Barker
**********@*****.***
. Compared accounts receivable (AR), accounts payable (AP) and other data
displayed on new User Interface (UI) screens to green screen legacy data
ensuring data integrity to expected results
. Worked with Programmer Analyst to coordinate requirements for COGNOS
reports
. Responsible for verification of business requirements / rules; created
traceability for every test
. Conducted QA integration and smoke testing of above scripts
. Entered defects into Mercury Quality Center; worked closely with DBAs,
raters, BAs, and other SMEs to manage and retest defects until they were
corrected
Mercury Quality Center, CaliberRM, Excel, Word, XML, Paint, Visio
Consulting: SSE, Inc., St. Louis, MO, Dec 2005-Sep 2006
(contract extended)
. Conducted requirements gathering and design validation reviews (JARs and
JADs), interpreted Visual Basic (VB), XML, and Crystal Reports to determine
needed updates to a VB-to-Java GUI conversion; worked closely with field
rep, team members, developers, Data Base Administrator (DBA), and other
Monsanto teams
. Completed all screen designs and process flows by the strict start date
for delivery to nationwide seed dealers and warehouses
. Created templates used to write over 70 story and report requirement
documents; included requirements traceability, error messages, risks,
constraints, issues, data dictionary, field and button navigation, pre- and
post-conditions, triggers, updated screen views, process flows, and report
layouts
. Gathered requirements used to design layouts for the new Jasper reports
including Invoices, AP, AR, Seed Warehouse Inventories, Delivery Receipts,
and other reports
. Created SQL queries for Oracle and Access databases matching requirement
details to the Cloudscape data model; wrote SQL select statements in
Cloudscape and TOAD
. Wrote test scripts; conducted unit, UAT, and integration tests; used
TeamTrack to enter test defects and enhancement requests; followed up
through completion of entry
. Used root-cause analysis to correct test defects using TeamTrack software
not only on each report, but also across reports that displayed overlapping
order and accounting data
. Designed data dictionaries for QA / QC and used as a source to write
online help
. Interpreted XML code and XMLSpy content to write field mapping documents
. Interfaced with other teams to write new grain processor requirements
SQL, TOAD, Access, IBM Cloudscape Workbench, Word, Excel, XMLSpy, Visio,
Outlook, Visual Basic, TeamTrack, XML (requests/responses), TeamSpace,
agile methodology, SAP
Customer Sales, Primerica, St. Louis, MO, Dec 2004-Nov 2005
. Studied for Series 6 and Series 63 exams; passed MO life insurance exam
. Discussed plans for financial success and retirement planning with other
Primerica personnel
Word, Excel, investments, insurance, mortgages
Sys Eng Bus Analyst, DCSI, St. Louis, MO, Oct 2004-Sep 2005
(third PCI Staffing position)
. Wrote System Requirements Specifications (SRS) for Automatic Meter
Reading (AMR) for billing of electric, gas, and water usage; conducted
validation meetings and applied changes in real-time
. Wrote SQL queries used to create data dictionaries and requirements
traceability matrices
. Created metering voltage dictionary and data dictionary used by Customer
Support personnel; these increased trouble shooting accuracy thus
decreasing response time to customers
. Participated in formal design reviews (JADs) and FEMA assessments of
transponder product quality
Linda J. Barker
**********@*****.***
. Lead the writing of requirements traceability matrices and use cases for
each meter; these included voltages, transponder radio frequencies,
handheld AMRs (requests / responses), binary and hex equivalents and other
metering data
. Worked closely with electrical and hardware engineers, QA, managers,
developers, and marketing; worked with BA creating UML diagrams
. Conducted meetings with managers, developers, hardware and customer
support
MultiSpeak and SOAP, Word, Excel, XMLSpy, SQL, Access, Oracle, Outlook,
Visio, Teamcenter, IEEE standards, FEMA, ClearCase training, Rational, UML
Consulting: Rose International, St. Louis, MO, Nov 2003-Jun 2004
. Read and applied United States Department of Agriculture (USDA)
compliance standards and laws to create use cases for new and revised
accounting reports
. Facilitated JAR and JAD sessions used to gather requirements and design
accounting reports for both ad hoc interactive display and also for
scheduled batch runs against the data warehouse
. Created use case standards then trained team members
. Created wireframes, requirements traceability, constraints, risks /
mitigation, and error messages
. Lead report presentations and validation meetings where changes were
applied in real-time
. Worked closely with clients, developers, designers, SMEs, data modelers,
and BAs
. Passed Secret clearance background check (no badge required)
Word, Excel, SQL, Access, Outlook, Visio, SourceSafe
Consulting: PCI Staffing, St. Louis, MO, Oct 2003-Nov 2003
(second PCI Staffing position)
. Three-week contract - completed ahead of schedule
. Wrote customer service manuals for AOL call center representatives
Word, Windows XP
Consulting: TEKsystems, St. Louis, MO, Sep 2003-Oct 2003
(short-term contract, completed research and documentation on time)
. Wrote use cases and created the use case template; wrote Standard
Operating Procedures (SOPs) and a document creation template for Express
Scripts' patient acceptance program
. Interviewed SMEs and created System Description Documents (SDD)
Word, FDA standards, HIPAA
Consulting: PCI Staffing, St. Louis, MO, Apr 2003-Jul 2003
(first PCI Staffing position)
. Gathered requirements for Wyeth BioPharma's critical path Detailed Design
Specification (DDS)
. Wrote component and database recovery SOPs and process flows
. Lead document validation meetings; changes were applied in real-time
during meetings
. Interviewed SMEs and managers and applied FDA standards as necessary
Word, Excel, PowerPoint, Visio, Windows, FDA standards, SUN
Consulting: Analyst/Writer, Analytix of Greater St. Louis, St. Louis, MO,
Sep 2002-Jan 2003
. Created Implementation and related SDLC documents for Quick Study
Radiology (QSR); these were formally presented to the Board of Investors
guaranteeing future funding for this start-up firm
. Created network and process diagrams with Visio, used OLE to link / embed
Excel and Visio data into Word documents; created forms within Word and
Excel
. Provided Disaster / Recovery templates, troubleshot Excel, PowerPoint and
Word questions
Linda J. Barker
**********@*****.***
. Interviewed engineers to create accurate network flow and data
connectivity diagrams between the following: Picture Archiving and
Communications System (PACS), Radiology Information System (RIS), Digital
Imaging and COmmunications in Medicine (DICOM), and Health Level 7 (HL/7)
Word, Excel, PowerPoint, Visio, Windows NT, HIPAA, DICOM, HL/7
Consulting: Web Site Dvlpr, Boy Scouts, St. Louis, MO, Jan 2002-ongoing
through Apr 2003
. Analyzed troop needs and created web site for St. Louis-based troop;
troubleshot problems by directly editing the Hyper Text Markup Language
(HTML) code created by FrontPage (now DreamWeaver)
. Created various Scout, activity, and advancement reports based on
TroopMaster data
. Designed and distributed flyers, newsletters, and brochures for special
events
. Responsible for web site content management utilizing graphic design
techniques
FrontPage, HTML, Word, PC and iMac, Photoshop, TroopMaster
Project Lead/Analyst/QA Tester, UniGroup, St. Louis, MO, Jul 1997-Dec 2001
. Managed 20+ people and associated issues while upgrading 170 users to Y2K-
compliant hardware / software; created project plans for this project;
managed the needs of internal customers
. Designed and implemented an SDLC methodology which provided uniform
direction, expectations, and forms; created standardized project plan
templates and resource-to-project phase matrices, thus increasing
communication and productivity between departments
. Taught managers how to create project plans, utilize resources, follow
Gantt charts and critical paths, create baselines, create charts and
reports, work with dependencies, read the project dashboard, and interpret
reports
. Interim Lotus Notes Administrator; set up initial Notes system, defined
and set up Notes user IDs and passwords, taught new administrators how to
register users and install Notes client software; wrote agents and macros;
set up initialization (init) and configuration (config.sys) files
. Project Lead on: Lotus Notes server upgrade and personnel time entry;
project planning; PC fax; document imaging; and SDLC conversion projects
. Researched and documented the feasibility of implementing a RAID document
imaging system for external agents across the nation for invoices, BOLs,
delivery receipts, and other documents
. Wrote planning and requirements documents for Notes R5 server upgrade,
fax imaging, and PC fax software projects; also created new online Change
Management forms
. Project lead on analysis and installation of third-party faxing software
matching existing telephony rules; developed courseware and led stand-up
training for a broad range of audiences; wrote administration, user, and
operations manuals for this faxing software
. Utilized root-cause analysis to troubleshoot users' Notes questions /
problems (Netman help desk)
. Upgraded Lotus Notes 4 to R5 for 800+ PCs (manual); kept daily install
metrics
MS-Office, Lotus Notes, Windows, Fax Sr., Project Workbench, Project
Gateway, Netman,
Lotus Notes, Millennium (SmartSuite), OS/2, AS/400
Additional Consulting Contracts - Military and Commercial:
. Military work - DIDs, flight planning, multi-level security, avionics,
parts and wiring diagrams, selected photos and drawings included in final
manufacturing assembly documentation; SOWs
. Banking - cash and personnel management
. Insurance - auto, home, liability, claims processing, and life
Contact this candidate