BUSINESS/DATA ANALYST

Professional Summary

Business/Data Analyst with over 13 years of experience. Expertise in working with executives, managers, and business stakeholders to determine their business requirements and processes. Senior Business/Data Analyst for the QC Data Requirements Team at Bank Of America. Subject Matter Expert SME for several of the largest lines of business. The QC Data Requirements Team was high profile, mandated by Risk And Compliance. Senior/Lead Business Analyst for the Basel II Retail Auto Team at Ally Bank. Created and maintained all Business/System Requirements documentation for Basel II Retail Auto projects. Elicited business requirements from business partners and system requirements from technical partners. Worked with Ally Bank's Requirements Center Of Excellence RCoE to establish new standards in BRD/SRS documentation. Designed, developed, produced, and maintained Data Dictionaries for Bank Of America's enterprise-wide Global Corporate Banking GCB Navigator project. Business Analyst and Assistant Project Manager for MWD's Software Management/Licensing Project designed to manage and track all software licenses, purchases, and installations . Business Analyst and Project Manager for MWD's Business Objects/Crystal Reports Enterprise Upgrade Project . Experienced with JAD sessions and ran the JAD sessions for the SMLP BO/CRE Upgrade Projects. Have worked closely with QA/QC and been directly involved in major roll -out upgrades of both hardware and software. Worked as an integral part of MWD's Maximo 5.2 to 6x Upgrade Project Team. Expertise in creating highly complex executive level reports. Expertise in data mapping, database design, data analysis, data mining, resolving data quality/cleansing issues, and process improvement. Experienced in training new existing staff for job duties and procedures.

Technical Skills Experience

• Crystal Reports/Business Objects Enterprise All Versions >17 years
• Business Objects Crystal Enterprise All Versions 8 years
• Maximo 2.1, 5.2, 6.2, 7x 8 years
• Remedy Action Reporting System >12 years
• Microsoft Office All Versions >17 years
• Oracle 8i, 9i 11 years
• SQL 7 years
• Microsoft Project 6 years
• FileNet 9 years
• SharePoint 2007, 2010 2 years
• Microsoft Windows All Versions >20 years
• SQL Server Management Studio 5 years
• SAS < 1 year
• Data Warehousing 6 years
• BRD/SRS/JAD 10 years
• User Acceptance/BA Acceptance Testing 10 years
• TOAD For Oracle 7 years
• Toad For SQL 2 years
• TOAD For Data Analysts 2 years
• Teradata 2 years
• HP Quality Center 9.2 2 years
• Borland CaliberRM 1 year

Experience

Confidential

Senior Business Consultant/Data Analyst, Performance Analytics Contract

• Temporary replacement for perm staff on Maternity Leave Created End2End Data Dictionary
• Performed Source To Target testing Performed Data Quality Analysis
• Created and managed Project Test Plan
• Ran Test Plan in HP Quality Center
• Entered defects in HP Quality Center
• Worked with DBAs and Data Owners on data sourcing and access requirements Logged test issues
• Created ad hoc Crystal Reports for data analysis Worked with Oracle databases
• Worked under minimal supervision in a matrixed environment with employees and consultants

Confidential

Senior Lead Business Consultant, QC Data Requirements Team SOW Contract

• Team Lead for Production Support
• Senior Business/Data Analyst responsible for pulling data from source locations and generating random statistical samples based on population and other factors
• Subject Matter Expert SME for several of the largest lines of business Workstreams
• Was the only Analyst in the group to work all three groups - Production Support, Development, and Business Requirements equally
• Re-wrote numerous procedures to conform to documentation standards as well as for clarity Created numerous procedures from scratch screenshots included
• Re-wrote SQL code for efficiency and changes Created SQL queries for tests from scratch
• Elicited Business Requirements from Business Partners
• Worked with DBAs and Data Owners on data sourcing and access requirements Worked with MS SQL Server, Teradata, AS400 databases
• Participated in Workstream forums
• Worked closely with sample data recipients to identify issues with population requirements, gaps, and other areas of concern
• Maintained the SharePoint site where all sample transmissions are logged and updated Transmission Log Responsible for monthly workload assignments for Production Support Team
• Advised on process improvement and best practices
• Worked on several special projects among them an overall Quality Improvement project for the group manager
• Maintained System Inventory and developed new system of tracking data sources and server access procedures Considered the go to person in Production Support for any issues
• Reviewed, tested, and approved new tests before they were placed in production
• Performed metics on performance, replacement sample requests, productivity, and other aspects Logged test issues
• Logged requests for replacement samples when one or more samples fell outside of testing criteria Completed all annual/semi-annual required BAC training courses
• Consistently had the 2nd highest quantity of tests and the most complex tests tests were generally along Workstream lines
• Worked under minimal supervision in a matrixed international environment with employees and consultants, both domestic and overseas
• 100 of work done remotely

Confidential

Senior Lead Business Analyst, Basel Retail Credit Team Contract

• Designed, developed, produced, and maintained Business Requirements Documentation BRDs and System Requirements Specifications SRSs for all NAO, LAO, and IO Retail Auto projects and NAO Mortgage projects
• Considered a Subject Matter Expert SME for Basel II Retail Auto projects Participated in numerous JAD sessions
• Worked closely with Business Partners for requirements gathering
• Worked closely with the Oracle Reveleus Technical/Configuration Team to translate requirements into programming and Oracle Reveleus configuration
• Worked closely with the QA/QC Team on defect analysis and remediation Worked closely with the Data Governance Team
• Worked closely with the Oracle Business Intelligence Enterprise Edition OBIEE Team to develop necessary reports based on business requirements
• Advised on process improvement and data quality issues Created and documented Change Requests
• Entered, updated, and closed defects/change requests in HP Quality Center Documented all BRDs and SRSs in Borland CaliberRM
• Worked under minimal supervision in a matrixed international environment with employees and consultants
• 100 of work done remotely

Confidential

Business/Data Analyst III,

Business Analyst/Data Analyst

• Designed, developed, produced, and maintained Data Dictionaries for enterprise-wide Global Corporate Banking GCB Navigator project
• Worked closely with other BAs to develop and maintain Project Functional Specification PFS documents Developed new reports in Business Objects/Crystal Reports to replace existing spreadsheets
• Participated in numerous BRD and JAD sessions
• Worked across Lines Of Business to alleviate duplication of efforts, standardize, and consolidate reports and reporting procedures
• Developed and tested complex SQL queries using TOAD For Oracle/TOAD For Data Analysts and Crystal Reports
• Performed extensive data mining
• Performed extensive data quality analysis on Source and Data Warehouse/DataMart data
• Performed extensive QA/QC testing UI functionality, design, data accuracy from Dev through Prod environments Developed and approved test scripts
• Worked closely with Data Warehouse and DataMart personnel Advised on process improvement and data quality issues
• Advised on Data Warehousing prospects, strategies, designs, and expectations Advised on DataMart prospects, strategies, designs, and expectations
• Wrote Change Requests/Enhancements
• Entered, updated, and closed defects and change requests in HP Quality Center Updated support requests in Maximo
• Completed all annual/semi-annual required BAC training courses
• Worked under minimal supervision in a matrixed international environment with employees and consultants, both domestic and overseas
• Majority of work done remotely

Confidential

Business/Data Analyst III, Wholesale International Systems Delivery WISD Contract

Data Analyst/Reports producer

• Developed new reports in Business Objects/Crystal Reports to replace existing spreadsheets
• Worked with Design Engineering Team personnel to develop new reporting databases SQL Server Oracle Worked across Lines Of Business to alleviate duplication of efforts, standardize, and consolidate reports and
• reporting procedures
• Complex SQL queries were developed and tested using SQL Server Management Studio and Crystal Reports Worked with legacy Wachovia personnel on merger data and reports
• Advised on process improvement and data quality issues
• Advised on Data Warehousing prospects, strategies, designs, and expectations Advised on DataMart prospects, strategies, designs, and expectations
• Worked under minimal supervision in a matrixed environment with employees and consultants

Confidential

Data Analyst III, Default Information Management Analytics Contract

Data Analyst/Reports producer

• Utilized SQL Server Management Studio 2005 to draw data from various sources including flat files, Teradata, Business Objects, and SQL Server for copy/paste into Excel spreadsheets
• Utilized SAS v9.1 to draw data from various sources including flat files, Terradata, Business Objects, and SQL Server for copy/paste into Excel spreadsheets
• Complex SQL queries were developed and tested using SQL Server Management Studio and Crystal Reports Learned mortgage default procedures and information
• Developed new reports in Business Objects/Crystal Reports
• Advised on process improvement and data quality issues
• Advised on Data Warehousing prospects, strategies, designs, and expectations with Automation Team Advised on DataMart prospects, strategies, designs, and expectations with Automaton Team

Confidential

Business Analyst III, Business Applications Support Team

• Project Manager for the Business Objects/Crystal Reports Enterprise CRE Upgrade Project 8.5 to XIr2
• Conducted JAD sessions for CRE Upgrade Project
• Met with subject matter experts and customers in a variety of locations to identify customer business needs and requirements, providing solutions regarding development process improvements and customer education
• Developed Business Requirement Documents based on meetings with subject matter experts Experienced working directly with work management business processes
• Worked directly and on-site with business stakeholders to validate business process requirements and reporting/application logic
• Attended JAD sessions for numerous projects and upgrades
• Developed SDLC documents and developed User Acceptance Testing Documented testing defects identified during testing and re-testing
• Complex SQL queries were developed and tested using TOAD For Oracle and Crystal Reports Communicated with QA/QC and other technical teams to assist with defect resolution
• Completed deliverables to support testing efforts, such as test scripts and defect tracking Performed extensive data mining
• Acted as an integral part of the Maximo 5.2 to 6x Upgrade Team
• Developed project scope, requirements, deliverables, and received customer approvals
• Worked with Data Warehousing Team to advise on optimum reporting requirements, business unit requirements, and overall design schemas
• Worked with Data Warehousing Team to advise on DataMart schemas Familiar with .NET programming though not a programmer
• Worked under minimal supervision in a matrixed environment with employees and consultants

Reports Developer/Data Analyst III, Business Applications Support Team

• Responsible for management and execution of the design, development, and implementation of highly complex District-Wide Enterprise Reporting software Business Objects/Crystal Reports Enterprise 8.5/XIr2 for the District-wide Maintenance Management System Maximo and various other organizational groups
• Assisted with data management, cleansing, and analysis of Maximo Maintenance Management System
• Part of the reports requirements were generating Work Orders, Preventative Maintenance Orders, Corrective Action Orders, and Asset Management Orders
• Reports developed and deployed were used on a daily basis by employees and managers Developed District-wide reporting standards
• Extracted existing data and reports from Microsoft Access databases and Microsoft Excel spreadsheets and standardized them in Business Objects/Crystal Reports
• Complex SQL queries were developed and tested using TOAD For Oracle and Crystal Reports Processed and tracked trouble calls/issues with Remedy Action Reporting System
• Completed business and data analysis advanced interpretation of the mined data in the form of highly complex reports in formats, including information in the form of graphs, charts, and tables, that are understandable by peers and all levels of management
• Responsible for Level 3 software support
• Handled hard to solve hardware and software issues that could not be resolved by the Customer Support Center
• this included extensive QA/QC testing with hardware and software installations Conducted reporting, data mining and data analysis which included:
• Processed large amounts of data for statistical modeling and graphic analysis
• Identified relationships and trends in data, as well as any factors that could affect the results of research
• Analyzed and interpreting statistical data in order to identify significant differences in relationships among sources of information
• Prepared data for processing by organizing information, checked for any inaccuracies, and adjusted and weighed the raw data
• Evaluated the statistical methods and procedures used to obtain data in order to ensure validity, applicability, efficiency, and accuracy
• Evaluated the sources of information in order to determine any limitations in terms of reliability or usability
• Planned data collection methods for specific projects, and determine the types and sizes of sample groups to be used
• Responsible for web page creation/modification and support for district-wide enterprise reporting software, which included:
• Identified customer needs and requirements, and provided potential solutions regarding client/server applications, development processes, and internet technology
• Arranged for the creation of the web pages
• Modified the pages as necessary
• Linked the reports
• Ensured that reports are run properly from the web pages
• Maintained pages and updated as necessary with new reports
• Provided support to application teams in change migrations and back-out

Confidential

Acted as the assistant project manager/business analyst/senior technician

• Responsible for developing and implementing the Software Management Project , including business and data analysis
• Responsible for the design, creation, execution, and maintenance of the Software Management/Licensing Project database Microsoft Access/Microsoft Excel/Oracle
• Developed highly complex statistical reports for the Software Management/Licensing Project utilizing Business Objects/Crystal Reports
• Complex SQL queries were developed and tested using TOAD For Oracle and Crystal Reports
• Conducted JAD sessions for the Software Management/Licensing Project
• Attended JAD sessions on other projects
• Documented testing defects identified during testing and re-testing
• Communicated with QA/QC and other technical teams to assist with defect resolution
• Completed deliverables to support testing efforts, such as test scripts and defect tracking Met with business stakeholders to identify business needs and gather requirements
• Responsible for internal HelpDesk Support Level 3
• Assisted in the training of new Customer Support Center personnel
• Participated in JAD sessions for the XP Professional Upgrade Project
• Developed all system analysis and software reports for the XP Professional Upgrade Project
• Specifically assigned to upgrade all systems at the District's five most remote locations for XP Service Pack 1
• Participated in JAD sessions for the XP Professional to Vista Upgrade Project
• Worked under minimal supervision in a matrixed environment with employees and consultants
• Responsible for management and execution of the design, development, and implementation of highly complex reports for Customer Support Center statistics
• Responsible for data analysis and cleansing for Customer Support Center data Remedy Action Reporting System
• Co-developed Customer Support Center metrics
• Developed highly complex statistical reports for the Customer Support Center utilizing Business Objects/Crystal Reports
• Customer Support Center statistical analysis reports were utilized as part of individual team member performance evaluations
• Designed and distributed numerous roll-out/upgrade-related statistical reports using Business Objects/Crystal Reports

Confidential

Received HelpDesk 2000

Responsible for internal HelpDesk Support Level 2

• Had the highest call resolution rate as well as the highest customer satisfaction rating
• The Customer Support Center handled calls, emails, and walk-ins from employees across the District Coordinated upgrade, break-fix, and installation efforts with managers and staff at multiple locations Only CSC Analyst to perform on-site support and software upgrades at multiple sites
• Was the CSC central point of contact for Office Of The CEO and executives
• Was the CSC central point of contact for all of the District's Desert Offices and their liaison Evaluated all support issues/tickets before they were passed on to other support groups
• Processed and tracked all trouble calls/emails/issues with Remedy Action Reporting System Designed, created, and distributed reports using Business Objects/Crystal Reports
• Complex SQL queries were developed and tested using Crystal Reports Supported and used FileNet as the EDM system
• Supported a wide range of applications and user problems, dealing with all levels of staff, including upper and senior management
• Worked under minimal supervision in a matrixed environment with employees and consultants

Confidential

Responsible for internal HelpDesk Support Level 2

• Processed and tracked trouble calls/emails/issues with Remedy Action Reporting System Designed, created, and distributed reports using Seagate Software Crystal Reports
• Assisted in roll-out upgrade of software hardware Windows 3.11/NT to 95/2000 Provided support to application teams