* ******** *******

***** **** *** *****, #*

Seatac, WA 98198 Email: abl596@r.postjobfree.com

* *******

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; airline material management and

maintenance, manufacturing, financial planning and operations, sales and marketing (CRM), HR, Sarbanes Oxley (SOX) auditing and

computer forensics in public utility and retail companies. My roles have included Senior Functional/Business Analyst, Senior Data and

Systems Analyst, Senior Quality Assurance Analyst, Database and Support Analyst, SQL Database Administrator and a Systems

Engineer. I excel at interfacing with clients, customers, cross functional business and IT teams, gathering, documenting and translating

business requirements to functional and technical requirements; authoring User Acceptance tests, functional tests, and database

design and development.

3 Technical Skills

Software: Microsoft SQL Server 4.21 through 2008, Oracle 10g, Access, FOCUS (Mainframe and PC), Microsoft IIS, SMS, Visio, MS

Office Suite, Visual Source Safe, MS Product Studio, Visual Studio Team System, ERWIN, Sharepoint, Crystal Reports, Mercury

Quality Center, IBM ClearQuest, IBM Clear Case, Longview Khalix, Primavera, TOAD, SAP/R3, SAP Convergent Invoicing, SAP

Convergent Charging.

Platforms: MS Windows 95, 98, XP, NT, Windows 2003, Vista, Windows 7, VM/CMS, MVS/TSO

4 Professional Experience

Microsoft, Redmond, WA

January 2010 – June 2010

Sr. Business and QA Analyst (Consultant)

Proactive involvement in test strategies, planning, and execution across the OEM Channel Software plus Services Global

•

Readiness Program following the MSFT SDLC/ITLC discipline.

Authored and executed Business Use Cases and User Acceptance test cases for MS Advantage Program (Software+Services),

•

which included SAP/R3, SAP Convergent Invoicing and SAP Convergent Charging.

• Collaborated with Cross functional teams for testing, triage, reporting and resolution of defects.

• Assisted business users during multiple test passes.

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) for two major

releases, one minor release for maintenance data delivery to Boeing Toolbox web application for airline customers.

• Created Oracle 10g SQL queries (pl/sql) for data validation.

• Revised and created new IBM Rational ClearCase projects. Provided ClearCase end user training and support, performed audit and

analysis of DMS (Document Management System); implemented configuration management process improvements.

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. Performed data mapping from COBOL to Oracle.

• 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 – Sept 2007

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, Operational Data Store, OLTP, Data Store, and OLAP processes.

• Authored knowledge base articles

Boeing, Renton, WA

March 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

• 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 (30 servers)

• Installed security patches, created stored procedures, NT CMD batch jobs, DTS packages, performance tuning

Microsoft, Redmond, WA

January 2001 – December 2001

SQL DB Engineer (Consultant)

• Developed and maintained new and existing financial reporting scripts and stored procedures

• Provided 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 (Management Analys) / Texas A&M University (Education)

Contact this candidate