Senior Business System Analyst Resume
Chicago, IL
SUMMARY:
- 25 years of business system analysis, project management, business architecture, and consultingin matrix organizations
- Experience in Business Process Modeling (BPM), Software Development Life Cycle (SDLC), Waterfall and Agile methodologies, re - engineering and improvements through automation and integration of systems
- Web and mobile applications, content management, capabilities/requirements elicitation, use cases, user stories, acceptance criteria, quality assurance testing, user acceptance testing (UAT), and mitigation of expectations
- Extensive understanding of data structures, databases, query tools, and source to target mapping
- Excellent organizational, leadership, analytical skills, problem-solving, and resolution-driven skills
TECHNICAL SKILLS:
- VSTS, VSO, Qlikview, Cognos, SQL Management Studio 2016 BI
- SQL, PL/SQL, Accent, Oracle, Office 365, MS Project
- Excel, Word, VISIO, Power Point, MS Project, Tableau
- MS Access, Documentum - Document Imaging
- Balsamiq, InfoPath, IBM Rational-Requisite Pro
- BluePrint, Appian, MEGA, SharePoint, ERP, SAP
PROFESSIONAL EXPERIENCE:
Senior Business System Analyst
Confidential, Chicago, IL
Responsibilities:
- Created an Agile/SCRUM guide for MPF
- Designed and created a tool in Visual Studio Team Services (VSTS) for system documentation, which provides ability to access production support analytics, data linage, provides impact analysis for estimation of projects, and detail documentation of each system
- Created SharePoint site for BSA department with multiple dashboards
- Projects included eliciting requirements from stakeholders, mitigating needs of the Business, documenting functional specifications, data specifications (including definitions), and screen layouts
- MPF Data Governance - worked with mapping of data mart data to the currently used application for data governance
- Data Mart - performed complete UAT for data mart files and the data integrity
- MPFM & MPFM Chicago 2.0/3.0/3.1 - pricing model refit (conversion of the application, historical data, and decommission of the application) and enhancement for national and Chicago pricing schedules including high and low loan balance pricing
- Application maintenance support team for six systems including requirement elicitation, root cause analysis, and enhance design with the SCRUM team in two-week sprints
- Default Detail - modifying the input data layout and database layout
- Early Check - mandatory modifications for FNMA validation changes
- ULDD - modifications to conform to FNMA and MISMO data standards mandate
- MPF Batch Enhancement - usability improvements for internal system (eMPF) for batch imports of validation layers, errors, CE Lite (credit enhancement), and MISMO fields
- Business Rule Engine configuration, creation, and rigorous testing
- Collaboration with vendor in teams, projects, and on innovative initiatives
Business System Analyst
Confidential, Westchester, IL
Responsibilities:
- Analyzed and documented existing system for re-development
- Led subject matter experts (SME) elicitation sessions
- Created user stories, wireframes (Balsamiq), prototypes (InfoPath), data analysis (SSIS), metadata definitions, and functional requirements documentation (FRD)
- Worked collaboratively with UI/UX designer on screen compositions to accommodate scalability and mobile adaptation
- Conducted presentations with executive management and contributed to buy-in presentation session for product budget approvals
Business System Analyst
Confidential, Schaumburg, IL
Responsibilities:
- Created the customer experience journey based on processes through data analysis and current documentation
- Documented repeatable process for deriving customer experience based on data analysis and documentation
- Google Analytics analysis for Zurich website
- Summarized customer experience journeys, surveys, and data analytics visualization in reports for management
- Reorganized content management (SharePoint) for the project
Business System Analyst
Confidential, west, Los Angeles, CA
Responsibilities:
- Conducted needs-based analysis for the international finance department based on meetings with CFO
- Created an ATHENA application user manual
- Documented the Foreign Levy team procedures
- Created analytical templates with VBA, data taxonomy displaying percentage matches, including macros slicing, dicing, and grouping data based on business rules for management review
Business System Analyst
Confidential, Burbank, CA
Responsibilities:
- Responsible for testing process, including creation of the test plan with 180 test scenarios
- Collaborated with technical and business resources to obtain approval including UAT
- Integrated preparation and analysis of data sets from source SAP and target Everbridge application
- Provided the metadata definitions and mapping documentation for SAP and Everbridge data
- Created three charter/scope documents and stakeholder analysis for simplification and usability, SAP Integrations, and D&D/control implementation projects
- Defined TRIRIGA usability requirements, data definitions, workflows, time study, clicks streams for four work streams and CAD integration requirements
- Maintained project resources, deliverables and budget within Clarity PPM Resource Management
Business System Analyst, Sr.
Confidential, North Chicago, IL
Responsibilities:
- Managed COGNOS ERP application enhancement upgrade, including documentation of requirements, testing (developed Excel automatic testing tool to validate finance reports), successful UAT, and deployment to production
- Created application manual and configured application security
- On-boarded two replacement sustainability resources
Business Architect
Confidential, Bloomington, IL
Responsibilities:
- Exclusively created use cases, wireframes, and generated Business Process Modeling (BPM) processes based on project needs
- Conducted stakeholder facilitations to elicited requirements, approvals, mitigated gap sessions, and UAT
- Mentor and lead a team of five business analysts and two data mapping resources
- Exclusively created business architecture standards and process for reporting
- Facilitated data mapping (business data element to physical source data) sessions between vendor and internal resources
- Participated in request for proposal submissions, vendor review and selection process, including work order reviews
- Exclusively created vendor acceptance criteria, testing strategy and risks/issue with mitigation strategies
- Created integration of content between MEGA and SharePoint
Business System Analyst
Confidential, Chicago, IL
Responsibilities:
- Conducted BPM, gap requirements, and UAT sessions
- Configured new software application to meet the needs of each business unit
- Conducted extensive testing of the application
- Detailed design for multi-currency process, requirements, and design for new module of the application
- Managed all issues and collaborated with the vendor for resolutions
- Conducted application sessions
- Analyzed extensive finance and accounting root cause analysis of issues (SQL, MS Access)
- Defined and implemented complex business rules
- Created SharePoint site for the project
Business System Analyst
Confidential, Lake Zurich, IL
Responsibilities:
- Conducted requirements elicitations resulting in extensive documentation, including data analysis, created data dictionaries, data modeling, GUI and design, defect sessions, SCRUM sessions, issue management, risk mitigation, testing sessions, and UAT
- Paperless solution for Medical Management and Claim divisions for 3,000 users with average of 10,000 imaged items daily using Documentum Content Management and SharePoint
- CM and ODM / E26 - Content Management Application
- E26 - Mobility module/application - created GUI, data integration with web services requirements
- Peer Review System - complex application with outsourced (off shore) development
- Global experience facilitating JAD development sessions
- Case Management Projects
- Account Management - re-engineering and modification/redesign of an existing system and extensive data mining to align data with the new data structure and mapping to two integrated systems
- Billing - complete automation of a billing process with rule engine and an approval workflow
- Intake - reutilization and modernization of an existing system
- Mentored four business analysts (2 consultants)
- Conducted proof of concept of a $1.4 million IBM product purchase; analyzed email taxonomy results appropriately categorized using Bayesian algorithm
- Created presentations for management, statements of work, requirements, policy, and design for Global Intranet for 12,000 users; analyzed usability research and researched mobile configuration for Oracle Portal
Business System Analyst, Sr
Confidential, IL
Responsibilities:
- Created requirements for bag on hand (BOH) module, including front end, middleware, and database high level design Baggage Service Transportation project
- Elicited requirements and contributed to design of a dashboard, web reporting front end user interface
- Conducted extensive testing including UAT and managed the improvement of existing Agent application functionality and identified numerous improvements for future implementation
- Facilitated JAD requirements sessions and JAD development sessions
- Developed statistical database for the business reporting needs
- Managed and researched defects for Kiosk and Agent applications through detail data analysis
- Collaborated with two departments and the outside resources on the requirements for integration with the WorldTracer data source, source to target mapping, data diagrams - data flows, and data modeling
Business System Analyst, Sr
Motorola, Libertyville, IL
Responsibilities:
- Designed process improvements for Customer Relationship Management Tracking system
- Contributed to project management process development
- Defined and elicited business requirements for three projects (global effort including: Brazil, Italy, France, China, Canada, and England teams)
- Facilitated JAD development sessions with the global team (China)
- Managed UAT
- Created an internal customer satisfaction survey of 7,000 customers
- Created extensive MS Access queries for testing of business rules, data mining, data cleansing, and data integration
- Designed a relational database for data warehouse as back end for reporting retention and retrieval, including metadata design and data dictionary for the users
Business System Analyst
Confidential, Chicago, IL
Responsibilities:
- Managed full lifecycle of two capital markets projects, including development and control of the project plan, mitigation planning, monitoring scope, risk assessment, weekly status reporting via SharePoint, and UAT
- Worked on multiple projects (up to 10) concurrently
- Facilitated SCRUM project sessions, defined project scope, data mapping and retention models, elicited business requirements, use cases, workflows including data flows, product evaluations, conducted product selections sessions, and UAT
- Introduced design re-engineering and recommended improvements for business processes
- Participated as an active team member within assigned phases of the software development lifecycle
- Provided direction and guidance to team members
- Provided operational and financial business-related analysis and research to support business goals
- Participated in rapid planning sessions for projects and assist with the development
- Analyzed defects within data marts and data warehouse based on the analysis of the source to target tracing
- Implemented business rules engine classification and configuration
