SUMMARY

• Twenty years of experience performing business systems analyst functions for multiple client and internal projects in a matrix environment, including projects for process improvement, to streamline, and simplify business processes, and projects for the development of new application systems, including web - based, client/server applications; and twelve plus years of experience performing project management functions for multiple projects, using cross-functional teams in a matrix environment (two yrs in a PMO environment).
• Many years of experience developing and managing enterprise project plans and status reports, and tracking project costs.
• Twenty plus years of experience implementing enterprise IT applications and performing all phases of the system development lifecycle (SDLC), including all phases of quality assurance testing - unit, integration, system, and user acceptance testing.
• Experienced in requirements gathering; the development of System Requirements Specifications (SRS), use case documents, Field Mapping Matrices, traceability matrices, and other project documents and technical specification documents; and the coordination of project implementation activities across all corporate organizations and with all stakeholders, managers, vendors, and end-users.
• Experienced with facilitating meetings, both functional and technical, using video, audio, and web conferencing; and interfacing with and making presentations to executive sponsors, senior level managers, division coordinators, SME leads, and SMEs.
• Excellent interpersonal, presentation, and negotiation skills; great oral and written communication skills.
• Experienced in managing development teams and holding team members accountable for their deliverables.
• Experienced managing and motivating resources in offshore and matrix environments.
• Adept at identifying, suggesting, and documenting new process improvements.

• Business Systems Analysis
• As-Is Business Process Modeling
• Functional Data Analysis
• To-Be Business Process Modeling
• Requirements Gathering
• Oral & Written Communications
• Quality Assurance Testing
• Mission-Critical Project Management
• Application Software Development
• Waterfall & Agile Methodologies

TECHNICAL SKILLS

Platforms: Windows NT/2000/XP/2007/2010, IBM OS 390 Mainframe, Sun UNIX (Solaris)

Databases: Oracle, Microsoft SQL Server, IBM IMS, ADABAS

Languages: Oracle SQL & SQL *Plus, Data Definition Language (DDL), Data Control Language (DCL), HTML, MS Visual Basic, MS Access, FTP Scripts, VB Scripts, COBOL II, OS 390 JCL, OS 390 Assembly Language, MS C#.NET (training), IBM High Level Assembly Language, SAS, TSO CLISTs, ISPF Dialog Manager

Software: MS Project, Project Office, Primavera TeamPlay Project Manager, Primavera TeamPlayer, Cognos, WebFOCUS MRE, WebFOCUS Developer Studio, WebFOCUS ReportCaster, WebFOCUS Migration Utilities, UC4 Enterprise Job Scheduler, Hummingbird Connectivity/FTP, Visio for Enterprise Architects, MS FrontPage 2003, UML Activity Diagrams, UltraEdit, SPFPC, MS Windows 2000/XP, MS SourceSafe, IDEF0 Business Process Modeling, MS SharePoint Services, MS Word, MS PowerPoint, MS Outlook, MS Excel, MS Internet Explorer, Windows Explorer, Adobe Acrobat, Lotus 1-2-3, PageMaker, Beyond Compare 4, MS SQL Server 2008 R2, TXTcollector, Team Foundation Services (TFS), Wordpress and Wordpress Plugins, Yoast SEO Plugins, Qlickview

Applications: State and Local Government Applications, I-9 Workforce Compliance, Delinquent Account Collection, Aerospace Manufacturing, Programmer Productivity Tool Development, Oil and Gas, Banking, Savings and Loan, Medical, Recruiting, Government Reporting, Payroll, Accounts Payable, Accounts Receivable, Invoicing, Inventory, Management Reporting, General Ledger, Marketing, Website Development, Managed Cloud Computing & Hosting

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Business Systems Analyst

Responsibilities:

• Responsible for the maintenance of a corporate website using Wordpress technology.
• Using Windows 2007, Windows 8, Windows 10, and MS Office 2007 suite of products.
• Responsible for the accounting and payroll functions for the company using QuickBooks Pro 2016.

Confidential, San Antonio, TX

Business Systems Analyst/Quality Assurance Analyst

Responsibilities:

• Performed business analysis and quality assurance testing functions for Qlickview business intelligence reporting.
• Developed Business Requirements Documents (BRDs) that defined the requirements and specifications needed by a BI development team to create reporting applications used for IT infrastructure cloud computing software license management in an MS SQL Server data warehouse environment.
• Developed and used test plans and test cases for BA validation and QA testing.
• Performed parallel testing of report output using MS Excel 2016 formulas and functions.
• Used MS SharePoint Services as a project document repository and document management tool.
• Used MS Office 2016 software extensively, in an MS Windows 10 environment.
• Used Rackspace’s in-house-developed, proprietary, configuration management database (CMDB) extensively.

Confidential, Houston, TX

Sr. Business Systems Analyst

Responsibilities:

• Responsible for the development and maintenance of a corporate website using Wordpress technology.
• Researched the use of various website themes and plugins.
• Responsible for the implementation of search engine optimization for the website.
• Responsible for the implementation of corporate webpages on Facebook, Twitter, Google+, and LinkedIn.
• Used MS Office 2007 Suite of products.
• Responsible for the accounting functions for the company using QuickBooks 2013.

Confidential, Houston, TX

Sr. Business Systems Analyst/Project Coordinator

Responsibilities:

• Performed business analysis and project coordination functions for projects involving the conversion of IBM mainframe legacy applications to a Windows, web-based processing environment using XML and MS SQL Server technologies.
• Reverse-engineered mainframe legacy applications using IBM COBOL and OS 390 JCL. Documented business rules in System Requirements Specification (SRS) and Field Mapping Matrices documents.
• For each conversion project, held a project kickoff meeting to communicate project specifications to an offshore or in-house Agile development team, management, and other stakeholders within the company.
• Developed and used test plans and test cases for BA validation testing.
• Interfaced with QA testers during the QA testing phase of each project.
• Used Team Foundation Services for bug tracking.
• Performed parallel production testing using Beyond Compare 3, MS SQL Server 2008 R2, TXTcollector, UltraEdit, and Team Foundation Services (TFS).
• Coordinated the migration of all assigned projects to production, and the implementation of those projects in production.
• Managed and coordinated all client conversion projects that were assigned.
• Used Project Insight for project management tasks, and MS SharePoint Services as a project document repository and document management tool.
• Used MS Office software extensively.

Confidential, Houston, TX

Sr. Business Systems Analyst/Project Coordinator

Responsibilities:

• Performed business analysis and project coordination functions for projects involving the conversion of IBM mainframe legacy applications to a Windows, web-based processing environment using MS C# and MS SQL Server technologies.
• Reverse-engineered mainframe legacy applications using Visual Basic 6, IBM COBOL, and OS 390 JCL. Documented business rules in System Requirements Specification (SRS) and Field Mapping Matrices documents.
• For each conversion project, held a project kickoff meeting to communicate project specifications to an offshore Agile development team, management, and other stakeholders within the company.
• Developed and used test plans and test cases for BA validation testing.
• Interfaced with QA testers during the QA testing phase of each project.
• Used Team Foundation Services for bug tracking.
• Coordinated the migration of all assigned projects to production, and the implementation of those projects in production.
• Managed and coordinated all client conversion projects that were assigned.
• Used Project Office and Project Insight for project management tasks, and MS SharePoint Services as a project document repository and document management tool.
• Used MS Office software extensively.

Confidential, Houston, TX

Sr. Business Systems Analyst

Responsibilities:

• Performed business systems analysis, design, and development functions on a project to re-develop an antiquated engineering material management system using the Microsoft Visual Studio 2008 Professional web development technologies, the MS Silverlight 3 SDK and Toolkit, MS Expression Studio 3 (MS Expression Blend 3, MS Expression Design 3, MS Expression Encoder 3, and MS Expression Web 3), and MS SQL Server 2005 for the database, in an MS Windows 7 Ultimate 64-bit operating system environment.
• Used MS Office 2007 Suite of products.
• Responsible for the accounting functions of the company using QuickBooks Pro 2009.

Confidential, Houston, TX

Sr. Business Systems Analyst

Responsibilities:

• Facilitated meetings and did research to develop an RFP for Confidential to outsource a portion of its outbound contact center, working out of Idea Integration’s PMO. Met the deadline for getting the RFP to Purchasing.
• Developed an RFP Evaluation Matrix to be used by reviewers/evaluators of the RFP responses, along with instructions for its use.
• Developed an Excel workbook to be used for determining the winning vendor using information supplied by the reviewers in the RFP Evaluation Matrix documents.

Confidential, Houston, TX

Sr. Business Systems Analyst

Responsibilities:

• Responsible for the accounting functions of the company using QuickBooks Pro 2009.
• Installed and used MS Office 2007 Suite of products.
• Installed and used MS SQL Server 2005, MS Visual Studio 2008 Professional, the MS Silverlight 3 SDK and Toolkit, and MS Expression Studio 3 in an MS Windows 7 Ultimate 64-bit operating system environment.
• Performed business systems analysis, design, and development functions on a project to re-develop an antiquated engineering material management system using the Microsoft Visual Studio.NET web development technologies and MS SQL Server for the database.

Confidential, Houston & Fort Worth, TX

Sr. Business Systems Analyst

Responsibilities:

• Worked as a cross-agency Business Systems Analyst, out of Idea Integration’s PMO, on Phase I of the Confidential Project, a joint venture involving four partners - Mental Health Mental Retardation Authority (MHMRA) of Harris County, Texas; Mental Health and Mental Retardation (MHMR) of Tarrant County, Texas; Uni/Care; and Idea Integration. The project involved the implementation of Pro-Filer, an enterprise clinical software application, developed and marketed by Uni/Care, for the Harris and Tarrant County MHMR agencies. Idea Integration was the IT consulting company responsible for managing the Confidential Project.
• As one of Idea Integration’s two Business Systems Analysts assigned to Phase I of Project Confidential, was a member of the Project Confidential Core Team, consisting of Project Confidential PMs and BAs; worked with BAs at both agencies; facilitated meetings in Harris and Tarrant County using video, audio, and web conferencing; and interfaced with division coordinators, SME leads, and SMEs at both agencies. Hundreds of SMEs were involved in the project at both agencies.
• Coordinated analysis work and facilitated meetings for as-is and to-be business process modeling for several functional areas, including Client Life Cycle, Client Care, and Client Records, gathering and documenting information obtained from five divisions across the agencies - Mental Health (MH), Mental Retardation / Intellectual and Developmental Disabilities (MR/IDD), Early Childhood Intervention (ECI), Addiction Services (ADS), and Crisis Psychiatric Emergency Programs (CPEP).

Confidential, Houston, TX

Sr. Business Systems Analyst

Responsibilities:

• Managed the daily operations of this family-owned I.T. consulting company.
• Responsible for the accounting functions of the company using QuickBooks Pro 2008.
• Used MS Office Suite of products.

Confidential, Austin, TX

Sr. Business Systems Analyst

Responsibilities:

• Developed a Mainframe Migration Test Strategy document that defined the strategy that would be used by the DADS IT Test Team for legacy mainframe migrations.
• Performed planning and management support functions during the Reverse Engineering phase of a project to migrate legacy COBOL applications off of a Unisys mainframe to a UNIX/Oracle/Java open systems environment.
• For DADS IT, made improvements to the Texas Department of Information Resources’ (DIR’s) system development lifecycle (SDLC) project documents related to application software testing.
• Developed new SDLC document templates that were being used by the DADS Migration Test Team. Their usage was spreading among other teams within the agency.
• Used MS Visio to develop process workflow diagrams that mapped the usage of DIR project-related documents.
• Developed and used FTP scripts, VB scripts, and MS Visual Basic/MS Access 2003 to obtain files from remote sites for parallel testing during legacy migrations to the open systems environment. Used MS Visual Basic, MS Access 2003, and Compare It to develop utilities for automating the comparison of output files between the mainframe environment and the open systems environment during parallel testing.
• As a member of the DADS IT Migration Test Team, participated in developing a recommendation to upper management of an approach to legacy migrations that effectively eliminates the risk of failure (studies show that legacy application migrations have a 76% failure rate). The recommendation was accepted.

Confidential, Houston, TX

Management Consultant

Responsibilities:

• As President, managed this software company, which developed, markets, and supports a hosted, web-based software application that is used for insuring workforce compliance with Department of Homeland Security regulations and U.S. immigration laws.
• Management responsibilities included sales and marketing, operations, and information technology.
• Developed a five-year business plan for the company, which included a plan for obtaining equity funding from a venture capital firm. It also included an analysis of market segmentation, market needs, trends, and growth; an analysis of the competition and of buying patterns; SWOT (strengths, weaknesses, opportunities, and threats) analysis; strategy for maintaining a competitive edge; marketing strategy (positioning, pricing, promotion, distribution); e-commerce website marketing strategy; sales strategy; strategy for developing strategic alliances; plan for developing corporate infrastructure and for the recruitment and hiring of personnel; a financial plan; and an investment offering.
• Worked with attorneys for Confidential and for prospective clients and strategic partners to negotiate agreements with them. Wrote some of the agreements.
• Performed the duties of a Software Sales and Marketing Manager in the absence of another qualified person to fill the position. Sales and marketing efforts targeted HR managers, compliance officers, and legal departments within large companies.
• Collaborated with Senior Sales Executives to develop proposals and responses to RFPs.
• Attended HR conferences to obtain sales leads, to develop partnering relationships, and to promote Lookout’s products and services.
• Participated in onsite sales presentations to Fortune 100 companies. Participated in conference calls with clients, prospective clients, and strategic partners to resolve various problems and issues.
• Researched background check companies and how they operate in order to select and establish a strategic partnering relationship with one of them. Traveled with and made joint presentations with the owner of a background check company to jointly sell the services of both companies to prospective clients. While doing so, learned a lot about the entire background check process. Worked with Lookout’s IT Department to get background checks set up as an additional offering on the company’s website.
• Developed numerous policies, standards, and procedures for the company pertaining to employees, information technology, and security.

Confidential, Houston, TX

Project Manager/Sr. Business Systems Analyst

Responsibilities:

• Performed project management and business systems analysis functions for multiple client and internal projects.
• Primary project manager and business systems analyst for the company’s longest running, most profitable client.
• Performed requirements gathering, developed project documents and programming specifications, conducted meetings and JAD sessions, and coordinated project implementation activities across all corporate organizations.
• Used MS SharePoint Services extensively as a document repository and document management system.
• Performed business analysis and requirements gathering functions for the development of a new collection system using Agile methodologies.
• Project manager/business analyst for Outbound Processing portion of the system.
• Developed ETL applications for moving data from an IBM mainframe to Windows folders, and developed API needed for the application program interface (API) between the mainframe and the MS Windows environment.
• Managed project to evaluate business intelligence tools to be purchased and used for enterprise internal and client reporting. Managed “proof-of-concept” projects to evaluate Cognos and Information Builders’ WebFOCUS business intelligence solutions.
• Managed project and worked with system architects to set up infrastructure and standards and procedures for the use of Information Builders’ WebFOCUS Business Intelligence Tools for outbound reporting.
• Used IDEF0 to model “as-is” and “to-be” business processes for Outbound Processing.
• Developed standards and procedures for the migration of WebFOCUS components from one environment to another (dev, stage, prod).

Confidential, Hurst, TX

Project Manager/Business Systems Analyst/ETL Test Team Lead

Responsibilities:

• Used Primavera TeamPlay Project Manager software to manage a project for developing the standards and procedures for Confidential ’s Enterprise Data Architecture (EDA) Group.
• Working in Confidential ’s Project Management Office (PMO), designed and recommended procedures for the full ETL system development lifecycle. Designed forms, diagrams, and spreadsheets. Led reviews and walk-thrus of newly developed procedures.
• Managed Bell’s ETL Test Team. Developed procedures for the unit and systems testing of DecisionBase applications. Used Oracle SQL and Oracle SQL *Plus. Wrote numerous Oracle SQL scripts to aid in the testing procedures. Used Oracle’s Data Definition Language (DDL) and Data Control Language (DCL).
• Designed two methods for verifying and reporting on the integrity of data in Oracle tables of the Enterprise Database (EDB). Developed and presented MS PowerPoint presentations for convincing management of the need for implementing one of the designs. Used one of the designs to develop a prototype ETL Audit Mechanism for the most complicated ETL application at Bell - Shop Floor Traveler.