PROFESSIONAL SUMMARY:

Accomplished Project Manager/Sr. Business Analyst/Project Coordinator/Test Lead/MS Access (VBA) Developer/Federal Lead; Consultant with 22 years of experience; Strong work experience in business analysis, project management and VBA development. Proven ability to supply critical leadership on organizational, team, and project levels. Proactive and results - oriented professional with 22+ year track record of successfully delivering clearly measurable bottom line results. Outstanding analytical and problem solving skills. Adept at leading and mentor personnel to share vision to maximize s. Excellent communicator capable of interfacing with internal/external stakeholders as well as end users and developers.

TECHNICAL EXPERIENCE:

Software: MS Office Suite 95/97/XP/ 2003/2007/2010/2013/2016 (Access, Excel, PowerPoint, Word) DBA, MS Project, Visio, Lotus Notes, MS Exchange, IIS Server, Visual InterDev, Enterprise Manager, Rational Tool Suite (Requisite Pro, Clear Case, Clear Quest), Primavera, Crystal Reports, Active Directory, Dreamweaver, SharePoint, Cognos, BIQuery, Informatica Metadata Manager, Teradata, Ultra Edit

Databases: MS Access, SQL 2000 server, DB2, Oracle, PeopleSoft, SAP, EDW, Teradata

Programming Languages: VBA, HTML, SQL

Testing Applications: HP Quality Center, Clear Case, Clear Quest

Operating Systems: Windows NT/98/2000/XP/ME/Vista/7.0/;

Methodologies: Software Development Life Cycle (SDLC), Agile, Waterfall, Iterative, Software Development Methodology (SDM), ITIL

PROFESSIONAL EXPERIENCE:

Confidential

Technical Team Lead

Responsibilities:

• Document compliance utilizing MITA and MECT 2.2
• Create standardized templates for evidence packets.
• Work with vendors and IV&V team to determine out of scope checklists and checklist items for each application.
• Work with software vendor and stakeholders to identify ownership of in-scope checklist items
• Build evidence packets for each MECT 2.2 checklist item.
• Gather additional required artifacts from CMS Appendix B.
• Work with internal and external entities to capture technical specifications.
• Identify and capture documentation for the federal process.
• Work closely with IV&V to ensure data captured meets federal guidelines and expectations.
• Lead evidence review sessions with SME’s to discuss evidence captured and revise as necessary.
• Data validation of batch data transactions using BIQuery, Teradata, and SQL queries in data warehouses.
• Work with external developers to ensure defect fixes addressed in a timely manner.
• Long Term Care (LTC) defect and issue documentation
• Create dashboards and metrics with Excel

Confidential

Test Lead

Responsibilities:

• Oversee testing necessary to ensure encounter data is accurate and all functions of the new pharmacy system are working correctly
• Writing Hex files to submit test scenarios using Ultra Edit
• Validate and document defects
• Working with business users to ensure all requirements are implemented and functioning properly
• Work with vendor to ensure timely implementation of defect fixes
• Create DSDD quick materials.
• Create and import data definitions to Informatica Metadata Manager for use with new IMPACT system.
• Perform data analysis SQL queries using Teradata and BIQuery within the EDW
• Identify Mobius reports and determine which are obsolete
• Business Process & Data Flow Diagrams.

Confidential

Sr. Business Solutions Analyst / Project Manager

Responsibilities:

• Project Management/Business Analysis utilizing full Software Development Life Cycle methodologies
• Business Process Mapping utilizing Visio in creating a roadmap for design structure and documenting project guidelines
• Work with various programmers in development of lead projects in n-tier environment
• Establish project plan with Object Oriented Methodologies
• Design database structure (tables, fields, data types, default values, etc.).
• Provide technical advice/support
• Prepare/review project and status reports for management

Confidential

Sr. Business Systems Test Analyst

Responsibilities:

• Business Analysis
• Prepare BRD
• Data Modeling
• Prepare process and data flow diagrams and flow charts
• Used SharePoint filing system and calendars.
• Test
• Prepare Test Strategy/Plans
• Write Test Cases/Scripts
• Perform system, integration and regression testing
• Validate data thoroughly for accuracy

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Work with BI team on transitioning from AS/400 to SAP/BW and EDW systems.
• Data Analysis Mining and Mapping using SQL and Toad
• Write Cognos queries and .reports for use in testing
• Write Test Scripts to insure the accuracy of reports and data
• Requirements gathering with VP's and Directors in establishing report layouts and details.

Confidential

Sr. Business Analyst

Responsibilities:

• Prepare process and data flow diagrams, swim lane diagrams and flow charts
• Create Procedures for Test, and Change Management compliance
• Prepare reports validating compliance with federal regulations
• Built custom Excel Spreadsheets utilizing VBA
• Provided dashboards to upper management, which monitor status of the projects.
• Research PII data standards throughout the U.S.A. and Europe and provide definitions
• Used SharePoint filing system and calendars. Working with BI team on transitioning from AS/400 to SAP/BW and EDW systems.
• Data Analysis Mining and Mapping using SQL and Toad
• Write Cognos queries and .reports for use in testing
• Write Test Scripts to insure the accuracy of reports and data
• Requirements gathering with VP's and Directors in establishing report layouts and details.

Confidential

Sr. Systems Analyst

Responsibilities:

• Perform test analysis on defects using SQL queries.
• Work with developers to ensure defect fixes are addressed in a timely manner.
• Used SharePoint filing system and calendars.

Confidential

Senior Consultant: Business Analyst Test Lead

Responsibilities:

• Data Analysis
• Identify, review and evaluating data sources
• Identify entities, attributes and relationships on a relational database
• Work with Data Management to develop implementation plans for the data elements
• Business Analysis
• Prepare BRD
• Data Modeling
• Prepare Use Case Diagrams
• Prepare process and data flow diagrams and flow charts
• Used SharePoint filing system and calendars.
• Test
• Prepare Test Strategy/Plans
• Write Test Cases/Scripts
• Track testing in HP Quality Center 11.0
• Perform system, integration and regression testing
• Validate data thoroughly for accuracy
• Planning
• Work on Project Schedule (MS Project 2007) to ensure timeliness of completion.

Confidential

Independent Consultant

Responsibilities:

• Built custom Excel Spreadsheets utilizing VBA
• Built custom MS Access Database using VBA and SQL.
• Built custom Reporting capabilities using SQL statements and Crystal Reports.
• Perform Business Analysis
• Meet with Business Partners in JAG sessions to identify necessary requirements for implementation of data platforms, web interface projects, hardware implementation, software upgrades (including third party vendor software)
• Creation of Requirements Inventories by identifying the following Requirements types:
• Business Requirements
• Functional Requirements
• Technical Requirements
• Non Functional Requirements
• Business Rules
• Data Elements
• Requirements Modeling using Visio in the following areas:
• Use Cases
• Data Flow Diagrams
• Various other diagrams
• Data Design and normalization of tables.
• Write Test Cases & Identifying potential defects.
• Risk and Defect Management

Confidential - Bloomington, IL

Sr. Business Analyst

Responsibilities:

• Oversee the overall health of multiple projects throughout the entire project lifecycle.
• Web Technologies
• Mainframe
• Client Server
• Software implementation
• SharePoint
• Payment Card Industry (PCI) Data Security Standards (DSS)
• Federal of the new PCI system changes
• Work with Planner on Primavera schedules
• ITIL methodologies used in PCI transition (Strategy, Design, Transition, & Operation)
• Built SharePoint site for Confidential Sponsorship Committee
• Oversee the overall health of the project throughout the entire project lifecycle.
• Built custom Excel Spreadsheets utilizing VBA
• Built custom MS Access Database using VBA for future use with the top 10 State Farm Corporate efforts related to the specifications required by the Payment Card Industry
• Perform Business Analysis
• Meet with Business Partners in JAG sessions to identify necessary requirements for implementation of data platforms, web interface projects, hardware implementation, software upgrades (including third party vendor software)
• Creation of Requirements Inventories by identifying the following Requirements types:
• Business Requirements
• Functional Requirements
• Technical Requirements
• Non Functional Requirements
• Business Rules
• Data Elements
• Requirements Modeling using Visio in the following areas:
• Use Cases
• Data Flow Diagrams
• Various other diagrams
• Data Design required for normalization of tables.
• Writing Test Cases & Identifying potential defects.
• Also took the following IBM Rational Tool Suite classes: Clear Case, Clear Quest, Requisite Pro Essentials of Rational Software Architect

Technologies: SDM, Clear Case, Clear Quest, Requisite Pro, Microsoft Office Suite 2003 & 2007, VBA, Microsoft Project, Visio, Lotus Notes

Confidential - Springfield, IL

IT Director/Project Manager

Responsibilities:

• Budgeting, planning, software implementations, maintenance, hiring, and project management utilizing MS Project.
• Ensuring regulatory compliance with state contracts
• Evaluation and implementation of software and hardware packages
• New client business development and marketing programs
• Lead Beta Testing of database applications
• Maintain 3 Windows 2000, 1 NT & 1 SQL 2000 server network & hardware at two locations.
• Built and implemented SQL 2000 server for use on the network.
• Design and program custom databases using VBA, for Archer Daniels Midland and Pepsi Cola bottlers in MS Access XP & 2003, and develop SQL Databases for use with web development projects.
• Design reporting capabilities with Crystal Reports versions 9 & 10.
• Teach high level classes for local area businesses (MS Project 2003, Access Level 1, 2, & 3, Access Power User, Application Development, Access VBA, Conquering Queries, HTML, ASP, Dreamweaver, VB 6.0, Crystal Reports (expert), Excel Levels 1, 2 & 3, Excel functions & Charts including VBA, Microsoft Word Levels 1,2, & 3 included VBA, Network+, etc.
• Teach & develop specialized classes for clients (Archer Daniels Midland, Ameren, etc)

Technologies: SQL 2000 server, MS Access XP & 2003, SQL, HTML, ASP, Dreamweaver, VB 6.0, MS Excel, VBA, Microsoft Project, Visio, Microsoft Office Suite, Lotus Notes

Confidential - Springfield, IL

Sr. Business Analyst VBA- Database Developer

Responsibilities:

• Perform Business Analysis utilizing full Software Development Life Cycle methodologies establishing new business processes for each city in the Confidential to perform their annual filing of the Police and Firemen’s Pension Funds with the Illinois Department of Insurance.
• Meet with Management and Fiscal Officers to identify all aspects required for project plan and development of the application sent out to each city enabling all law enforcement and Fire Protection Agencies to file Annual Pension Fund compliance with the Confidential .
• Perform business process modeling of the following Requirements types for filing Police and Firemen’s Pension Funds Annual Statement as required by the Confidential:
• Business Requirements
• Functional Requirements
• Technical Requirements
• Non Functional Requirements
• Business Rules
• Data Elements
• Requirements Modeling using Visio in the following areas:
• Use Cases
• Data Flow Diagrams
• Various other diagrams (Roadmaps, etc)
• Data Design required for normalization of tables.
• Writing Test Cases & Identifying potential defects.
• Review of new government standards’ impact on the organizations
• Evaluation of current state compliance with new regulations
• Provide ongoing analysis of compliance with government standards
• Design and program a database in MS Access 97 & 2000 utilizing VBA
• Document State Requirements for filing Police and Firemen's Pension Funds Annual Statement
• Compile screens to be used in the final application (i.e. Primary Details, Financials, Schedules, Interrogatories, etc.)
• Presentations to State Officials
• Design/Develop Help Files using HTML format
• Create reporting capabilities using MS Access 2000 Developer
• Lead Beta Testing teams

Technologies: Software Development Life Cycle, MS Access 97, VBA, Lotus Notes, HTML