Michael Spence Email & Phone Number

Raleigh, North Carolina, United States

Raleigh, North Carolina

Cary, Nc

Works with data Producers, data Consumers, data Architects and Modelers to understand data and functional requirements and to write functional specifications. Documents data transformation rules and source to target mappings for data movement between Producers and the Target Data store. Maintains the Data dictionary with a business glossary and data lineage information, and also works on data quality rules. Responsibilities * Analyzes business requirements documentation to formulate and create Functional Specifications. * Draw conclusions and effectively communicate findings with both technical and non-technical team members. * Analyses government regulatory documentation to understand the functional impacts of newly released Dodd Frank final rule amendments. * Work closely with a subject atter experts to identify gaps in existing the regulatory reporting process.* Produces and maintains data models and data dictionary as required. * Create and maintain data lineage between producer, datastore and consumer data layers. * Provides support and bug fix resolution during the SIT and UAT testing processes. * Mentor staff on relevant procedures and best practices Deliverables * Functional Specifications. * Data quality reports. * Mapping and transformation requirements and rules. * Data migration requirements. * Data dictionary. * Data profiling of source system. * High-level CRUD matrix for entities, and diagrams showing data flows.

Raleigh-Durham, North Carolina Area

First Citizens Bank, Raleigh, NC Analyzes existing complex systems to understand and document data elements, relationships, data flow, dependencies and related interfaces. Performs GAP Analysis of current state reporting to determine business need of custom report development. Gathers, interprets, and translates customer needs into functional and nonfunctional requirements translate business problems functional and technical requirements. Designs business intelligence and data warehouse solutions to meet business needs. Completes data mapping and metadata documentation. Acts as the primary liaison between the Business and Technology.

Hoffman Estates, Il

Works with the business owners and product managers to determine and document the requirements for technical solutions that meet the strategic needs of the business. Manages the scope of business requirements while keeping a focus on project benefits and delivery. Seeks various alternatives to business problems to achieve desired results. Partners with the project delivery team to ensure a strong architecture design and understanding of the business requirements. Drives innovation, identify areas for process improvement, and promote new ideas. Negotiates agreement when gaps in business and technical functionality are identified. Conducts analysis of business processes to determine requirements and opportunities for improvement. Assists in the creation of high level test plans and review test cases for completenessCreate well written documentation that is clearly understood by the business, development, and quality assurance Provide project leadership for small to medium projects.

Greater Chicago Area

SEARS HOLDING CORP, Hoffman Estates, IL DEC 2009 – JUL 2010Analyzed the business need through a series of group and individual interviews with stake holders and subject matter experts. Developed detailed business requirement documentation for the purpose of system solution builds. Assists in the development of System Requirement and Design Diagram documentation. Designed process models and diagrams. Acted the liaison between Technology and the Business.BANK OF AMERICA, Chicago, IL FEB 2009 – AUG 2009Analyzed source systems’ (ACBS) core functionality and interfaces, performed gap analysis of the target system (AFS), and documented results. Facilitated mapping sessions and prepared reverse mapping documents as required. Worked closely with business partners to resolve outstanding mapping questions. Participated in technical team meetings.

Greater Chicago Area

Business Analyst (2008–2009)Reviewed and analyzed processes, procedures, and systems to identify areas for improved workflow or automation. Determined business requirements, designed and developed documentation to support changes. Presented solutions to executive management for budgetary consideration. Interacted with IT staff and operational staff to formulate and implement solutions to improve processes. Identified impact of changes and facilitated acceptance of change through training and communication. Developed reporting to monitor effectiveness of implemented processes.Client Services Operations Manager (2005–2007)Managed a staff of 9 commercial loan analysts responsible for providing support and service through various processing, due diligence, client services, and collateral monitoring activities. Coached and mentored staff to achieve department volume and efficiency goals. Drafted and amended procedures to address operational needs of multiple business lines. Coordinated and managed special projects.

Greater Chicago Area

Supervised a staff of 10 covering the following Commercial Lending departments: Operational Risk, Compliance, and the Credit Department file room. Planed, scheduled, and conducted training for commercial and retail staff on commercial loan data systems. Provided oversight, training, and support to the commercial lines of business in all areas of commercial compliance to include, but not limited to HMDA, CRA, Flood Disaster Act, BSA, and CIP. Monitored the reconciliation and reporting of aged items for a variety of commercial lending G/L accounts. Performed operational risk assessments and implements process improvements. Coordinated and managed special projects.

Bachelor Of Science (Bs), Computer Information Systems

Bachelor'S Degree, Economics

Ba, Economics