Katarzyna Fitzgerald

PROJECT: CTS - CPU (Divestiture)

BUSINESS ANALYSIS

• Business analyst with TMAD (Technology Mergers, Acquisitions and Divestitures) Wells Fargo Corporate Trust Services.
• Worked on migration of CTS applications and data that includes production migration.
• Collaborate with business, Technical and buyer teams to migrate applications and databases.
• Support delivery of data and technical solutions for work around WIM(Wells Investment Management) operations processes such as GNMA transactions, Asset Movement transactions, SEI account de-conversion, SEI Account closure.
• Create & maintain project/system documentation, functional specs, test plans, user guide, and release documents.
• Support Product Owner with BA tasks including; requirements gathering, business process flow mapping, documentation, gap analysis and solutioning sessions.
• Creating test plan, test scripts, working closely with QA/Dev team to ensure user/tech story releases are aligned with business requirements.
• Create dynamic reports with Pivot Tables and manage large datasets with VLOOKUP and XLookup.
• Communication: Led & managed Command center for migration events & staffing schedule.
• Documented RAID logs that includes issues logs, commutation, and risk plan, action items and follow ups, key decisions.

• Analyzing complex business operations and recommending solutions to align individual business functions with organizational goals
• Ensures the business teams responsible for managing the Trade procurement, Inventory and Integrated Planning functions
• Involved in scope meetings with Managers to understand the type of requests and issues handled by the teams and documented the high level business requirements to the product backlog using Jira
• Worked with SMEs to gather functional requirements and documented the specifications in Confluence and process tickets through Cherwell Service Management
• Design and deliver system solutions to support both new initiatives and continuous improvement efforts within teams while ensuring that they support the overall company goals and IT strategies
• Create reports, charts, graphs and presentations to aid in proposing new strategies for successful business changes
• Provide guidance and management advice that has a large impact on cost, efficiency, compliance, service and quality.
• Maintain timely communication with Engineering Team and business to assure timely and efficient completion of tasks
• Prepare and document meetings presentations
• Actively follow agile principles and contribute in the various agile ceremonies like Daily Scrum, Sprint Planning, Story refinement, Sprint retrospective etc
• Provide comprehensive reporting solutions to Executives and work with them closely to provide data analytics to highlight useful information and support decision making.

• Analyzed and reviewed financial documentation, loss mitigation data, loss mitigation waterfalls and contractual documents; ensuring the accuracy of all data and the appropriate decision rendered throughout the loss mitigation review process to compliance with Federal laws, State laws, and Investor specific guidelines
• Continuously challenge and improve loss mitigation policies and scorecards through analysis of customer behavior data and sophisticated statistical and financial modeling
• Evaluating, developing, and implementing operational risk management initiatives to strengthen company policy
• Managed Hyperion BI Essbase, planning, strategic finance, SmartView and Reporting
• Interpret large data sets, prepare recommendations, and present to members of the team to influence the strategic direction of the company
• Worked on VB to export data, SQL/ Query Analyzer, Tableau, UNIX, and MS Office along with Excel (Pivot tables, charts / graphs and formulas) to export reports and analyze business requirements
• Developed, implemented, and coordinated project plans, including tracking progress, preparing reports, facilitating communication and collaboration with management on identifying, strategizing, prioritizing, and initiating special projects
• Deep knowledge and understanding of loss mitigation programs and government regulations including CFPB requirements, legislative updates and frequent investor specific updates
• Unearthed the root cause(s) of pain points and validated business opportunities and problems
• Designing database structures for business process automation
• Evaluated, analyzed, and communicated systems requirements on a continuing basis, and maintained systems processes, including the delivery of monthly status reports to all appropriate parties.

• Acted as Primary Liaison with Business Units and Technical Units to gather, analyze and prioritize Business Requirements translated into Project Scope, Business Specifications (BRD) and Functional Specifications
• Coordinated and conducted meetings to coordinate user review and approval at all stages of system development and delivery
• Prepared Requirements Document, Requirements Traceability Matrix, Scope and Impact Assessment, Risk Assessment and Management, Managed project scope throughout the lifecycle of projects
• Developed functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specifications
• Work cross-functionally with Legacy and Hybrid team to create product processes and provide continuous improvement to ensure key performance targets are met
• Led extensive interaction with business process, development, implementation teams, and end users in all aspects of report requirements for content management, identifying defects, and proposed recommendations
• Managed team meetings with onshore and offshore resources for functional and application interface delivery; Maintained project schedules, metrics, status reports, issues log
• Actively followed agile principles and contributed in the various agile ceremonies like Daily Scrum, Sprint Planning, Story refinement, Sprint retrospective etc
• Also stepped in as a Scrum Master when needed for a different team
• Collaborated and provided business analysis support to the product owner, business sponsors, SMEs and testers during development.

• Filtered and 'clean' data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems
• Worked with respective Database Administrators in Performance Tuning for in-efficient queries, CPU consumed Queries and Long-running Queries
• Designed and developed tools for business requirements using stored procedures
• Identified problems, suggested solutions, and implemented fixes for various issues encountered
• Modified and enhanced the existing systems to incorporate new functionality and to optimize their performance
• Involved in creating constraints, rules, defaults, and triggers to maintain the data and referential integrity
• Involved in the full development cycle of Planning, analysis, design, development, testing, and implementation
• Used Store procedures, User defined functions, Views, T-sql scripting for complex business logic
• Optimized the database by creating various clustered, non-clustered indexes and index views
• Using aggregate strategies to aggregate data, sorting and joining tables.

• Assessed individual's vocational abilities and work readiness
• Provided professional guidance and mentorship to at-risk individuals with employment barriers
• Analyzed job responsibilities for job training
• Monitored work culture and mentored resources
• Evaluated the progress of individuals through documentation/reporting
• Maintained effective communication between worksites and staff
• Maintained positive community relationships on behalf of Spectrum
• Reviewed candidate documentations and created weekly report
• Provided ongoing case management to children and families with intense/complex needs.