SUMMARY:

• 10 years of testing experience includes estimating, functional, system integration, UAT, regression, unit, smoke, performance, test plans, scripts, scenarios and strategy
• 10 + years of experience as a Business Systems Analyst with a focus in BI, finance, sales performance management (SPM) and software and database implementations, configurations and migrations
• Data analysis experience with table specs, metadata, data models, source to target mapping, data mart, data dictionaries, data cleansing, fact and dimension tables and views

TECHNICAL SKILLS:

Confidential Test Manager, SQL Server 2008R2, SSMS, Visual Studio, TFS and Office

Teradata 13, SQL Assistant, BTEQ

Callidus True Comp Cloud, Xactly

Varicent

SAP R2/3, BW, ECC, HANA - 85.3FI/CO and Business Objects-4.1

Oracle HFM and Essbase

HP ALM. RALLY, SeleniumMicroStrategy, Erwin, ARIS

ActiveBatch V9, .XML, TOAD, UNIX

PROFESSIONAL EXPERIENCE:

Lead QA Engineer Consultant

Confidential

• System Integration, functional, unit, smoke and regression testing on MS SSMS, .XML data feeds and CLTCAS proprietary end-to-end platform, designed for Long Term Care Insurance administrative functions
• Researched, created and executed SQL test scripts
• Responsible for Sales Compensation plan analysis and CLTCAS commissions module testing
• Trained and supervised onshore and offshore QA resources
• E2E system integration scenarios with all steps across the enterprise to include MS SSMS, CLTCAS (UI), FMS (billing), ABAT batch jobs, C360 (imaging) EPS (printing), .XML feeds and email / mobile alerts
• Enterprise wide integration environment setup and management
• All phases of policy lifecycle tested includes enrollment, product, pricing, claims and sales commissions
• Managed triage and defect tracking with Confidential Test Manager and Team Foundation Server
• Test Plan and Test Strategy creation with signoff
• Test cases, traceability matrix
• Weekly management status reporting package with root cause analysis
• Project estimation and submission of assessment for overall project, budgeting and resourcing

Business Intelligence Designer

Confidential

• BI Design Lead for 6 Tartan SAP and non-SAP BI Report initiatives
• Led JAD sessions and worked with cross functional team members to understand business and architecture of the system.
• Researched and produced metrics and KPIs for performance benchmarking BI
• Designed and performed integration testing on BI reports in Business Objects
• Sourced and created data mapping and transformation rules from SAP R2, R3 & HANA to BO universes
• BEX queries, t-codes
• Produced functional design (FD) documentation

Senior QA / BI Analyst Consultant

Confidential

• Created 300 + UAT test cases with scripts for commissions implementation using plans, rules, formula and rates
• Managed triage and defect tracking with RALLY and distributed status through all phases of testing
• Trained and supervised QA and BI resources
• Traced and validated inputs through each Callidus pipeline stage result with manual calculations
• UAT, Regression, integration white /gray/ black box testing of compensation plans, reports, and workflows
• Produced functional design (FD) and Business Requirements Document (BRD)
• Test Plan and Test Strategy creation with signoff
• Test cases, traceability matrix and weekly management status reporting package
• Project estimation and submission of assessment for overall project, budgeting and resourcing.
• Designed and configured BI reports with Access and MicroStrategy
• Researched and produced metrics and KPIs for performance benchmarking BI reports

Senior QA / BI Consultant

Confidential

• UAT Lead for Releases 1 - 4 Alpha & Delta Sprint Teams - GL Revenue BI implementation
• Researched, created and executed SQL test scripts for Teradata BIDW DB integration of 65 DB source systems
• Test Plan and Test Strategy creation with signoff referencing BRD, FRD, System Design and Application Interface Design artifacts
• Oracle Financials (CFAS), DB2 & SAP Business Objects (FDW) GL reconciliations
• Teradata, Essbase (cubes) & Business Objects (universe) unit and integration testing
• User Stories, requirements, triage and defect logging with HP ALM and RALLY
• Test Plan and Test Strategy creation with signoff
• Test cases, traceability matrixes and daily status report for each sprint
• Researched and produced metrics and KPIs for performance benchmarking BI validation
• Erwin, Table specs, data cleansing, metadata, master data, semantic layer, source to target mapping

Senior QA / BSA Consultant

Confidential

• HAWK SAP Business Objects Planning and Consolidation implementation for OEM allocation initiative
• Source to target mapping, semantic layer and transformation rules
• Use cases, test cases, UAT, unit and integration scripts
• Produced functional design (FD) and Business Requirements Document (BRD)
• Test Plan, traceability matrix and test strategy creation with signoff
• Triage and bug tacking with Visual Studio
• Data sourcing documentation, data cleansing, data dictionaries, source to target mapping

Senior Business Systems Analyst Consultant

Confidential

• Organized and led workshops with Retail and B2B stakeholders, SMEs, developers, architects and source system owners to document data, business and transformation rules for Varicent SPM implementation
• Sourced and created data and process mappings for use in design sessions
• Data analysis includes LDM and source to target
• Interface Agreements, SLA’s and data dictionary

Senior QA / BSA Consultant

Confidential

• Performed month end global administrative SAP R3 GL close and created flat file for HFM load
• Researched and documented SAP FICO scripts, tables, t-codes and fields for implementation of Chapter 11 reorg profit center / cost center restructure
• Analyzed FX, reposting’s, chargebacks, deposits and purchase orders for global reconciliations
• Extract transfer load and reconcile data from Essbase (cubes) and SAP to Oracle HFM
• UAT, integration, regression testing and triage for HFM implementation
• Test Plan, test matrix and test strategy creation with signoff
• Load input of SAP R2 to HFM Excel templates for IFRS/USGAAP Balance Sheet and Income Statements
• Performed HFM training and knowledge transfer initiatives within finance and the global SAP community
• Maintained documentation on key systems and process changes for use by ABAP and Oracle HFM project

Consultant

Confidential

• As is and to be data mapping and analysis for Cognos vendor management upgrade initiative
• Researched and produced metrics and KPIs for performance benchmarking
• Sourced and created data and process mappings for use in design sessions, creation of metrics and KPIs for dashboard and reporting
• Test Plan, test cases, test matrix and test strategy creation for Cognos upgrade implementation
• Performed UAT and integration testing
• Distributed weekly status report

Confidential

BA / Financial Analyst

• Analyzed and documented SAP FI/CO data and process mappings for the SAP ECC migration
• Tracked routers, switches, LAN, WAN, servers and hubs
• Managed wireless billing cycle, AR/AP and vendor contracts
• Created monthly financial reporting package for 35+ int'l business units
• Performed UAT and reconciliation testing of Quickcomm vendor Accounts Receivable implementation
• Test Plan, test matrix, and test strategy creation with signoff for Quickcomm initiative

Software Developer Engineer

Confidential

• Implementations of Xactly SaaS and Callidus software
• Four full lifecycle engagements included design, configuration, test and implementation
• Informatica data staging
• Execution of overall configuration and testing strategy including unit, integration and UAT
• Reports and Dashboards

Consultant

Confidential

• Hyperion Essbase and Clarity reports configuration for compliance budget and forecast
• Designed Business Objects reports for vendor billing analysis, reporting, metrics and forecasts
• Monthly close of the GL and subsidiary financial systems, reconciliations, allocations and reporting package
• As is / to be process analysis and data mapping for the Credit Suisse Bank One integration

Confidential

Trading Support - BA / Financial Analyst

• Business analysis of trading statistics includes benchmarks, volume, order flow, liquidity, cps and revenue
• Month end reporting package included activity reporting, metrics, variance, budgets, forecasts, and G/L
• Web publishing of daily trading statistics and revenue