SUMMARY:

• Experienced IT Analyst with in depth knowledge of development process, analysis, design, implementation, testing, and release.
• 20+ Years Experience in:
• Project Management, Business Analysis, Quality Assurance
• Data Analysis, Data Architecture/ Modeling, ETL Design
• Business Intelligence/Data Warehouse
• Data Governance, Stewardship and Master Data Management
• Custom Application Design
• Process Improvement and Standardization
• Agile/Scrum

PROJECT EXPERIENCE:

Sr. Business Analyst

Confidential

Responsibilities:

• Member of Center of Excellence Team responsible for:
• Development of “Assembly Line” process to decompose Business Requirements Documents into artifacts required to produce quality software in Kanban/Agile/Scrum development environment
• Configuration of Blueprint (requirements management tool) to support required artifacts:
• BRD’s
• Capabilities
• Features
• Data Definitions
• Business Rules
• User Stories and Acceptance Criteria
• Business Process Model
• Wireframes/Story Boards
• Responsible for the creation of process documentation, including Business Model, and presentation to cross functional teams
• Provided end user training for Blueprint
• Mapped artifact data from Blueprint to Rally (Agile Tool) to perform real - time integration
• Decomposed approximately 10 Business Requirements Documents:
• Produced Data Definitions and performed gap analysis against Logical Data Model
• Produced Business Rules Catalog to identify patterns used in build vs buy decision for Business Rules Engine
• Produced User Stories and Acceptance Criteria in collaboration with cross functional Product Owner Team

Confidential

Quality Assurance Analyst

Responsibilities:

• Responsible for testing ETL development that utilized Talend Integration Suite (ETL tool)
• Led JAD sessions with end users to identify data sources for ETL development
• Created test plans for new ETL development, ETL enhancements and ETL defects, based on User Stories and Acceptance Criteria
• Reviewed ETL code to gain additional technical understanding of code being tested and determine if it met business requirements
• Documented defects using JIRA ticketing system
• Audited data model to identify inconsistencies and best practices
• Developed reusable SQL scripts to automate and improve time-to-market for data warehouse
• Produced QA Process as standard for testing data warehouse to insure data quality
• Identified and initiated resolution for data quality issues not related to ETL development
• Responsible for final approval to move development to production
• Responsible for development of overall data quality strategy
• Developed requirements for data profiling using Talend Data Quality module to identify trends and anomalies in data warehouse
• Developed requirements and complex SQL scripts used to compare source to data warehouse. Scripts were automated and used to identify potential bugs and other issues that would make the data warehouse out of synch with the various sources
• Created requirements for system monitoring and reporting
• Produced daily reporting requirements to notify appropriate parties of system outages, ETL failures and statistics on record counts
• Created requirements for dashboard reporting to access the overall data quality of the data warehouse
• Produced roadmap to data quality including Data Governance and MDM
• Defined Data Governance roles including Leadership, Strategic and Tactical teams
• Delivered Best Practice for Data Governance Policies and Procedures
• Identified System of Record for Customers in Master Data Management planning
• Delivered workflow for creation, approval and activation of new Customers
• Designed Translation Engine to support historical records

Sr Consultant - Solution Architect

Confidential

Responsibilities:

• Delivered overall architecture to implement the Informatica Platform
• Data Architect responsible for designing and modeling SQL Server database to support ETL process.
• Solution Architect responsible for designing the implementation strategy for deploying Informatica to support 120 disparate sources, including data standardization and data quality efforts
• Lead JAD sessions with Subject Matter Experts to elicit Business Rules for data transformation
• Managed, trained and mentored team of 5 data analysts who were responsible for mapping and testing
• Performed data analysis to document standard rules to transform data to source system values.
• Documented data requirements for mapping and transformation
• Developed complex transformations using Informatica mapping tool
• Created Training Guide for Informatica Data Analysts
• Documented steps required to setup a new data feed
• Documented tips for mapping over 120 fields
• Documented sample transformations for reuse
• Developed Role Based Production Support Strategy
• Identified 6 points of failure
• Defined skills required for each support role
• Developed process flow, utilizing JIRA (in-house Issue Tracking System)

Sr Consultant - Sr Business/ Data Analyst

Confidential, Alpharetta, GA

Responsibilities:

• Delivered Technical Requirements, including Use Cases, based on Business Requirements for Custom Applications including:
• Lead JAD sessions to elicit functional requirements and create Business Process Model using BPN notation.
• Developed Wire Frame Design providing an intuitive interface to support data access and analysis
• Created Logical Data Design using Erwin to assist Developers in Technical Design Phase
• Performed Data Analysis of Oracle Financial and TeraData Warehouse data to identify data sources
• Produced Custom ETL Design documenting data sources, targets, transformations, translations for Informatica Developers
• Developed and maintained Traceability Matrix to insure that all Business Requirements were met.
• Documented Security, Disaster Recovery and Audit Design
• Produced all BA role documentation as required by the Corporate SLDC methodology
• Lead implementation by coordinating all activities associated with roll out on a 24/7 schedule
• Delivered weekly status reports to CFO and other project stakeholders
• Lead change management process by identifying changes versus defects and producing documentation as required by the Corporate SLDC methodology
• Delivered Data Quality Strategy, including roadmap for Data Governance and Master Data Management
• Participated in developing process improvement strategies to improve time-to-market delivery.
• Developed Application Test Strategy including:
• Test data requirements, Test cases and scripts for System Test
• Test cases and scripts for Integrated Testing with Data Warehouse and Reporting Data Marts
• Technical Support Liaison for System, Integrated and User Acceptance Testing Cycles

Consultant - Data Architect

Confidential, Raleigh, NC

Responsibilities:

• Delivered Data Mart Logical and Physical Models based Business Requirements
• Performed Data Analysis of PeopleSoft data to identify data sources.
• Delivered ETL design for Informatica Developers
• Participated in Data Quality and Performance Testing

Consultant - Sr. Data Architect

Confidential, Charlotte, NC

Responsibilities:

• Delivered Data Governance and Stewardship strategy and best practices
• Assisted with Executive Sponsorship
• Assisted in defining roles and responsibilities including Leadership, Strategic and Tactical Teams
• Provided framework for Policies and procedures
• Delivered Data Quality Strategy with focus on profiling:
• Column Analysis
• Table Analysis
• Cross Table Analysis
• Delivered Enterprise Conceptual Data Model based on pattern approach
• Delivered Risk Assessment based on data model analysis
• Developed Roadmap for implementation of Master Data Management Best Practices
• Identified multiple sources for Customer data
• Developed Customer Master Data Logical Model
• Designed Customer Data translation engine to map customer identifiers to an enterprise identifier

Senior Consultant - Lead Systems Analyst

Confidential

Responsibilities:

• Reverse engineered requirements from system design documentation
• Worked with Subject Matter Experts to identify business and technical requirements for system improvements
• Created data sets for each positive and negative test scripts
• Improved QA process by delivering reusable scripts to validate data
• Established timelines for testing and established weekly check points to insure their changes would coincide with Harcourt’s Implementation Plan
• Redefined data pumps (Lotus LEI ETL Tool) to insure 13 character identifier had been added
• Defined test data scenarios based on established Business Rules
• Worked with QA to develop test scripts for data testing
• Developed SQL statements for QA to validate data
• Created data sets for each positive and negative test scripts
• Requirements Analyst and Data thread lead for Phase II of the Depository Automation Project
• Reverse engineered the database for Depository Automation
• Gathered requirements to optimize the existing application
• Defined new tables, columns, data types for optimization
• Worked with QA to develop test scripts for data testing
• Developed SQL statements for QA to validate data
• Created data sets for each positive and negative test scripts

Senior Consultant - Lead Data Conversion Analyst

Confidential

Responsibilities:

• Performed Data Profiling at the Column, Table and Cross Table
• Performed mapping of legacy data to target system with rules for transformation and translation for Informatica developers
• Performed Legacy to Target Data Gap Analysis
• Identified external data sources to augment the legacy data to improve data quality
• Produced reports of source data that must be manually converted
• Implemented Enterprise Data Governance Program
• Provided Best Practices framework for Data Governance Policies and Procedures
• Defined Data Governance roles including Leadership, Strategic and Tactical Teams
• Participated Data Governance Council consisting of Business Users to standardize domain values for the composite application, including the target system improve data sourcing process
• Developed a Test Data Strategy and built a test environment for the tightly integrated composite application consisting of 15 core applications by refreshing all components from production data
• Worked with QA to create test data that would give them expected results for positive and negative testing
• Worked with QA Data Analysts to give them test scenarios so they could write data related testing scripts
• Participated in Implementation and stabilization period of 6 weeks
• Participated in JAD sessions to elicit Business requirements for the high availability inventory/pricing engine
• Documented technical and data requirements
• Developed and managed test data strategy to build a composite QA environment consisting of 15 core applications and 7 external applications.
• Devised project plan and schedule to achieve product delivery milestones
• Identified data sources and distribution methods
• Developed process for implementing data structure changes in the QA environments
• Provided technical support for data related defects during all phases of testing and training
• Developed and managed data staging and deployment strategy for implementation
• Devised project plan and schedule to achieve product delivery milestones
• Built secure end-to-end environment to stage “sensitive” data
• Insured all product was built and staged in accordance with established timelines.
• Performed data quality assessment of staged data to insure accuracy and completeness
• Developed hour by hour timeline with dependencies for go-live implementation
• Performed full data quality assessment of the legacy reservation system (IMS, COBOL, Unisys)
• Designed data conversion specification detailing file layout, translations, transformations, validations and testing requirements.
• Provided data analysis support for Data Governance to define domain values for enterprise attributes.
• Established data model reviews to insure data structures support legacy data for conversion.
• Managed and mentored the data analysis team consisting of 3 analysts.
• Represented data architecture team in Status, Issues and Change Control Meetings