Jeannine Fortier
21230 40TH Way South, #G
Seatac, WA 98198
Email: J9Fortier@gmail.com
Summary
I have 20+ years of hands on IT experience that encompasses a solid knowledge
base of all aspects of the Software Development Life Cycle (SDLC). I have
experience in a variety of roles within an extremely diversified industry base;
Sarbanes-Oxley (SOX), airline material management, airline software data
delivery, manufacturing, lean processes, financial planning and operations,
including AP/AR, budgeting, sales and marketing (CRM), HR, auditing and computer
forensics in public utility and retail companies as a Senior Functional,
Business, Database and Support, Quality Assurance Analyst, a Database
Administrator in a SQL environment and a Systems Engineer. I excel at interfacing
with clients, customers, cross-functional and IT teams and business units
gathering, documenting and translating requirements; authoring and defining
functional tests, and database design and development.
Technical Skill Summary
Software: Microsoft IIS, Microsoft SMS, Visio, MS Office XP Suite, Visual Source
Safe, MS Product Studio, Visual Team System, ERWIN, Crystal Reports, Mercury
Quality Center -Test Director, ClearQuest, ClearCase, Longview Khalix, Primavera,
SharePoint, TOAD.
Methodologies Macroscope, SDLC, Sarbanes-Oxley (SOX), Lean
Platforms: MS Windows 95, 98, XP, NT, Windows 2003, Vista, VM/CMS, MVS/TSO
Database Software: Microsoft SQL Server 4.21 through 2008, Access, FOCUS
(Mainframe and PC), Oracle 10g
Professional Experience
Boeing, Tukwila, WA
November 2008 – December 2009
Sr. Functional Analyst (Consultant)
* Authored and executed test cases for 787 SDD (Support Data Delivery) PIMS
(Parts Information Management System) two major block point release, one minor
release for maintenance data delivery to Boeing Toolbox web application for
airline customers.
* Created Oracle 10g SQL queries (pl/slq) for data validation.
* Revised and implemented IBM Rational ClearCase projects. Provided ClearCase
end user training and support, performed audit of documentation stored in DMS.
Boeing, SeaTac, WA
February 2008 – August 2008
Sr. Systems and Data Analyst (Consultant)
* Analyzed complex production change requirements and translated into functional
requirements in BCA (Boeing Commercial Airplanes) and MMIT /MMODS (Material
Management IT/Material Management Operational Data Store) using Macroscope
methodology
* Analyzed complex requirements and translated into functional requirements in
BCA MMAS (Material Management Aviall Synergy) project.
* Interfaced with business units to gather requirements for MMAS Aviall Synergy
project.
* Defined and created functional and system tests for MMIT/MMODS production
change requests and Oracle RAC (high availability)
* Developed and executed tests to validate system functionality against
specifications using Mercury Quality Center
Microsoft, Redmond, WA
May 2007 – Feb 2008
Sr. Operations Engineer (Consultant)
* Supported Visual studio team foundation for internal groups: SQL server 2005;
SharePoint services; reporting services; analysis services
* Upgraded VSTS application releases (SQL server, SharePoint services, analysis
services)
* Provided troubleshooting analysis of Web services (IIS), Operational Data
Store, OLTP, and OLAP processes.
* Authored knowledge base articles
* Provided application incident management support
Boeing, Renton, WA
Mach 2006 – March 2007
Functional Analyst (Consultant)
* Worked with customers to define requirements and functions in data and process
models; analyzed change requests; documented functions and unit processes
* Evaluated business requirements and participated in specification reviews
* Defined functional tests and participated in testing the Khalix application
* Utilized Mercury Quality Test Center; ClearQuest; Lean processes, Primavera,
P+, CMMI process improvement knowledge and Macroscope SDLC
Microsoft, Redmond, WA
November 2005 – February 2006
Database Analyst/Engineer (Consultant)
* Designed and developed SQL databases for MS Vista Beta users in the MSX
Usability Group
* Documented and wrote technical specifications and detailed design
specifications
* Developed store procedures for external MS IIS website
Boeing, Renton, WA
July 2005 – October 2005
Business Analyst (Consultant)
* Evaluated Boeing SQL server and Oracle IT databases and applications in
Windows and UNIX environments for Sarbanes-Oxley (SOX) compliance
* Analyzed and assessed IT process controls, identified risks and linked risks
to relevant IT audit procedures
* Documented IT control process requirements and evaluations
Microsoft, Redmond, WA
December 2004 – July 2005
Sr. Support Analyst (Consultant)
* Provided administration and support of SQL 2000 databases (30 servers) for the
Corporate Security Group
* Supported operations for the Microsoft symbols system which included clustered
file servers (SAN) with multi terabyte storage capacity
* Administration and performance tuning of 6+ TB SQL database attached to SAN
* Installed security patches and deployed IIS/.net applications into UAT and
Production environments
* Installed SQL server on new hardware and developed SQL reporting stored
procedures, batch jobs, DTS packages
* Provided application incident management support for multiple applications and
analyzed hardware requirements for EMC Storage
* Created Data Flow Diagrams, Process Models, ER diagrams
August 2004 – December 2004
Database Engineer/Analyst (Consultant)
* Provided SQL server 2000 database administration and IS application support
* Administered a 6+ TB SQL databases on a SAN and other smaller databases
* Installed security patches, created NT CMD batch jobs, DTS packages,
performance tuning
* Educated end users on applications and data
* Responsible for administration of 30 servers
* Designed and developed reporting stored procedures for MSN finance analysts
July 2002 – February 2004
SQL DBA (Consultant)
* Provided SQL Server 2000 database administration and IIS application support
* Administered a 6+ TB SQL databases on a SAN and other smaller databases
* Installed security patches, created stored procedures, NT CMD batch jobs, DTS
packages, performance tuning
* Educated end users on applications and data
* Responsible for administration of 30 servers
Microsoft, Redmond, WA
January 2001 – December 2001
SQL DB Engineer (Consultant)
* Developed and maintained new and existing financial reporting scripts and
stored procedures
* Provided all round support for SQL reporting databases (OLAP) for MSN Software
Subscription Business Operations
* Designed DTS packages and batch files for data retrieval from multiple
internal and external sources
* Planned, tested, and migrated SQL 7.0 databases to SQL 2000
* Determined business requirements for reporting solutions
* Designed and developed Data Warehouse for MSN subscription billing system
* Documented technical specifications
*
Military/Education
U.S. Air Force 1972-1975 Statistical Analyst / Texas A&M University B.A.
Education, 1979
|