Business Systems Analyst Resume
Milwaukee, WI
SUMMARY:
- Over 9 years of experience as a Business/Systems Analyst with successful delivery of multiple projects possessing detailed and thorough expertise Finance, Insurance, Banking, and Healthcare domains.
- Proficient in gathering and defining the business requirements and functional requirements.
- Experience in conducting JAD sessions, interviews, and meetings with business users and development teams in an Agile environment.
- Good knowledge of the Payment Card Industry (PCI) and also of its regulations and compliance rules to adhere to industry standards
- Strong knowledge of the Bank Secrecy Act and the USA PATRIOT Act as well as a thorough understanding of FinCEN guidance pertaining to SAR filing requirements
- Skilled at developing use case diagrams, user stories, XML, class diagrams, sequence diagrams, collaboration diagrams, state diagrams, and activity diagrams using UML.
- 5 years’ experience with configuration of SAP HR Mini Master, HR Organization Management, and HR Personnel Administration.
- Strength in working with project management tools like MS Project for status reporting and planning.
- Expertise in analyzing business specifications, designing and developing strategic test plans, test cases, test scenarios, and test reports using JIRA for both manual and automated tests.
- Excellent problem solving, analytical, judgment, organizational, and leadership skills.
- Strong project management skills including strategic planning, problem solving and decision - making abilities.
TECHNICAL SKILLS:
Business Analysis Tools: DOORS, ProVision, Rational Rose MS Visio, IBM Kenexa, ULDD, HR Personnel Administration, and GIS.
Testing Tools: Rational Clear Quest, Rational Clear Case, Quality Center, Load Runner, QTP, JIRA, and ALM.
Databases: Oracle 10g/9i/8i, MS Access2000/2007, MS SQL Server 2008/2005/2000, and Big Data.
Methodologies: SDLC, Agile/Scrum, UML, and SWOT, .NET, Agent UI, CSS/PFS.
Office Tools: Microsoft Office XP Professional-MS Excel, MS Word, MS Power Point, MS Project, and MS Outlook, MS Silverlight
PROFESSIONAL EXPERIENCE:
Confidential, Milwaukee, WI
Business Systems Analyst
Responsibilities:
- Responsible for providing end-to-end support to the client for all the applications under Information Risk Management (IRM), Enterprise Project and Support (EPS), and Enterprise Vendor Access Management (EVAM) support domains.
- Researched and resolved all data variances prior to submitting required reports to various government agencies and/or clients like OCC, Fair Lending and CCAR.
- Assisted manager with central coordination, management and tracking of regulatory and internal CCAR reviews.
- Supported team with various ad-hoc and ongoing CCAR projects to aid in ensuring all key deliverables are completed in a timely manner.
- Conducted and analyzed technology processes by requirement performance modeling UML and prepared essential groundwork.
- Generated new content and managed writers.
- Published text with an eye to information architecture and usability.
- Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
- Documented user stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
- Coordinated with teams both onshore and offshore to set deadlines and participate in new software demonstrations and launch of new Interactive Intelligence software.
- Wrote documentation for AMT periodic Tracker application by acting as a liaison between application developers, testers, and project stakeholders.
- Assisted the Project Stakeholders of Asset Setup & Product group in setting, maintaining, and providing timely analysis of the Asset Pricing Product offering within the Global Reference Data Operations (GRDO) group
- Participated in technical/procedural and product meetings.
- Integrated new tools and developed technology frameworks/prototypes to accelerate data integration process and empower deployment of predictive analytics.
- Consulted with business partners and made recommendations to improve effectiveness of Big Data systems.
- Acted as a Scrum Master for tracking progress, identifying impediments, and estimating timeline during stand up meetings.
- Updated and maintained database of local commercial payment card clients to ensure compliance with regulations.
- Worked with a portfolio of Visa and Mastercard accounts to ensure adherence to compliance regulatory standards
- Determined requirements to asses impact on Payment card accounts from a compliance perspective
- Maintained a repository of documentation in SharePoint.
- Used Microsoft One Note to prepare software demonstration documentation.
- Worked with customer and vendors to ensure thorough system testing in the DEV/SIT/TEST/PROD environments.
- Strong experience in Global HR Compensation software tools such as Peoplefluent, Mercer, and Clarity.
- Provided timely resolution to issues to ensure quality service software delivery.
- Provided end-user support to Inspired e-Learning Software to identify vendor dependencies and prepared detailed Functional Specifications Documentation.
- Responsible for identifying and documenting business rules and creating detailed Use Cases.
- Coordinated and facilitated meetings and project activities between business stakeholders and implementation partners to define requirements and processes.
- Developed, executed, recorded, and communicated test results and provided support in preparation of test plan documentation throughout the Software Testing Life Cycle (STLC) using JIRA and ALM.
Environment: Hive, Pig and Hadoop Streaming, MapReduce, R, SPSS, SAS, Weka, JIRA, ALM, and AGILE, PCI (Chip & Pin)
Confidential, Smithfield, RIBusiness Systems Analyst
Responsibilities:
- Responsible for Setting up a User Setup Portal in the STP Track to automate process of new user setup for current and future business clients in an AGILE environment.
- Oversaw website content development and used analytics to ensure content effectiveness and quality of user experience.
- Acted as a liaison between the PGA (Pyramis Global Advisors) and the User Setup Portal group to understand system requirements.
- Worked as a liaison between the PR marketing and programming departments vis a vis message and branding in order to track and report site metrics and archive all written content.
- Improved on-site STP portal content and raised conversion rate by 88% through data analysis and UX/UI improvements.
- Applied the Subject Matter Expertise within Exchange Traded Securities pricing, OTC Derivatives, FX, Funds and Fixed-Income pricing, including hard to value MBS/ABS securities for managing Securities Operations.
- Created Effective Use cases and Integrated High level Use case Scenarios in the Project and identification of Basic/Alternative flows.
- Developed user stories with project teams. Extracted, discussed, and refined business requirement from business users.
- Performed requirements analysis and using Rational Rose and Smart Draw created UML specifics such as data flow diagrams (DFDs), ER diagrams, use cases, class, sequence, collaboration, and deployment diagrams.
- Participated in technical/procedural and product meetings with ESRI to ensure World Class Support standards.
- Provided analysis, conducted research, and provided Functional as well as Technical Design Documentation for the product team leads and Senior Management.
- Created gap analysis and specified all required business data for XML messages to place facultative reinsurance submissions, quotations and binder information on eReinsure.com web platform.
- Gathered and organized all relevant credit and guarantee information required to document mortgage loan files for suitable product type.
- Experienced in developing Rich Internet Application (RIA) using Microsoft Silverlight technology.
- Developed front-end code (HTML/CSS/Javascript) and created/followed coding standards across all central FIMT related web properties & services.
- Converted provided PSD's to valid HTML/PFS for both websites and for HTML emails.
- Analyzed, reconciled, and submitted loan packages for underwriting approval inside required timeframe.
- Created built-in and user-defined reports and graphical dashboards through ProVision.
- Used NFS’s Streetscape as a flexible broker-dealer workstation for commission and fee-based businesses.
- Managed risk and enhanced productivity of the business from anywhere wit 24-7 mobile access through NFS end-user investor portal.
- Closely interacted with application developers on the DEV/SIT/TEST/PROD environments to provide support for various phases of the Software Testing Life Cycle using JIRA and ALM.
- Interacted with Project Stakeholders from the Risk Department for Scope Management, Risk Management, and Timeline Management.
- Responsible for mapping and documenting input and output of data between client portal association Services and database to clearly understand needs of the client or end-user.
- Prepared work breakdown structure, dependencies, test plans, and implementation plans.
- Worked with developers for bug fixing on the Staging environment through the use of JIRA
- Created and maintained HR and succession planning models using Peoplefluent and Mercer.
- Participated in daily Stand-up meetings serving as a Scrum Master to discuss dependencies, impediments, and progress.
- Responsible for using graphical tools like charts and other visual aids in MS Visio and MS Excel for data flow mapping and manipulation.
- Responsible for interviewing Business Users, Stakeholders, and Developers to prepare business requirements and functional specifications
Business System Analyst
Responsibilities:
- Interacted with compliance systems to review Anti-Money Laundering requirements for various lines of Businesses (LOB’s) and identified gaps at system level around various aspects of Sanctions Scanning for Customers and Accounts, Currency Transaction Reporting, and Compliance Transformation Service.
- Coordinated with High Value Payments and Low Value Payments business stakeholders to identify dependencies and analyze impact on the compliance workstream.
- Demonstrated an in-depth understanding of banking, fraud, and anti-money laundering risks across all business units.
- Prepared DRAFT Suspicious Activity Reports (SARs) and other written investigative/intelligence products to support judgments, decisions, and recommendations.
- Analyzed information from investigation detail and escalated to higher level management and/or worked with AML/Fraud investigators to obtain any missing information.
- Constructed written narratives to support investigations in accordance with strict quality standards.
- Conducted investigative/intelligence research of potential fraud, money laundering, terrorist financing, and other financial crimes activities.
- Conducted investigative/intelligence analyses of collected information derived from varying internal, commercial, and open sources systems.
- Evaluated, adopted and where necessary, built services and frameworks for interactive distributed query processing over large volumes of financial data.
- Led company through successful launch of Web redesign, coordinating all content and layout with Web design team.
- Ensured Web content accuracy and taxonomy through development and analysis of end-user feedback channels.
- Followed UML based methods using Rational Rose to develop use cases and activity diagrams; assisted developers in creating sequence diagrams and collaboration diagrams.
- Developed high level and low level use cases on getting the specification document approved using UML.
- Coordinated with the Test Coordinator to identify defects using ALM and JIRA.
- Responsible for providing support to the Implementation of FACTA guidelines across the group.
- Created end-to-end Data Mapping for the Compliance Operational Data Store (CODS) as part of the Financial Crime Control (FCC) and Regulatory Compliance (RC) Data Warehouse Projects.
- Involved in data mapping projects as part of Project Greenfield.
- Created Product Backlog, Sprint Backlog and managed user stories.
- Led the change requirements of XML schema for facility letter generation and performed UAT.
- Responsible for developing functional requirements for the High Value Payments workstream.
- Responsible for modifying the version of Electronic Message Generation (EMG) functionality.
- Worked closely with SME’s and business users to understand and to document current processes.
- Developed current and future State Architecture Diagrams using MS Visio.
- Prepared Functional Design Documents for Data Modelers and ETL teams to identify all files and feeds used by Compliance Systems on Customer and Account feeds from various sources.
- Mapped data elements to Proprietary Software systems and developed data mapping documents to load data into the Compliance ODS using appropriate documentation techniques.
- Assisted with System Integration Testing and User Acceptance Testing by outlining scope of the Test Plan Document for various cycles of the Software Testing Life Cycle.
- Assisted Project Manager to create and maintain project plans in MS Project and Clarity.
Environment: Windows, MS Office, MS Visio, HP Quality Center, RUP, SWOT analysis, SQL Server, Clarity, JIRA, ALM, and AGILE.
Confidential, Atlanta, GASenior Business Analyst
Responsibilities:
- Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud.
- Prepared Mapping Documents for various CCAR Schedules.
- Developed use cases, workflow, screen mock-ups, and conversion requirements.
- In-depth understanding of data held and transmitted by 3 credit bureaus.
- Tested data delivered on export files via POWERSELLER database and validated new data fields added to the new export files created in XML format during ULDD phase 2.
- Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
- Tested new fields and Logic involved in Loan Origination Applications during multiple phases of ULDD such as LOANSPAN, SOAR, Processing Systems such as Cendant Achieving Servicing Heights (CASH) and other downstream systems such as SMARTS.
- Performed data analysis to prepare LCR reports.
- Tested the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories
- Created Business Requirement Documents and Functional Specifications.
- Provided assistance in implementing key financials inputs in the system and creation of automated forecasting model, performed various ratio calculations, and ROI analysis.
- Created use case scenarios and documents work flow and business process.
- Prepared Functional Specifications Documents (FSD) for Data Modelers and the ETL Teams.
- Interacted with users by interviewing them, preparing questionnaire, and obtaining feedback.
- Responsible for providing regular project communication to Project Manager and business areas.
Environment: Windows, MS Office, MS Visio, HP Quality Center, RUP, UML, SQL, SWOT analysis, and SQL Server.
Confidential, Dallas, TXBusiness Analyst
Responsibilities:
- Ensured Compliance with business standards and industry regulations.
- Implemented quality management plan to ensure compliance with required quality standards.
- Gathered requirements in stakeholder meetings.
- Analyzed, developed, and modified reporting and analytics framework to improve site functionality.
- Examined reporting functionality of multiple applications to identify and write requirements.
- Created documents including high-level Business Requirements Documents and Functional Requirements Documents.
- Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagram, ER diagrams & Data Mapping
- Facilitated stakeholder meetings and release plan meetings throughout entire SDLC.
- Analyzed impact of changes made across various applications/products on reporting and analytics framework.
- Planned and monitored project milestones.
- Performed User Acceptance Tests at end of each sprint to verify post-production functionality and verified compliance with HIPAA.
- Studied and analyzed data warehouse tables using SQL and Excel for writing requirements.
- Worked on process to eliminate Crystal Reports and conversion to SSRS reports to be available through a common reporting and analytics platform.
- Stored and shared documents in the SharePoint tool to facilitate consensus decision making at JAD sessions.
- Outlined business scope for designing marketing outreach for the University of Michigan Ross School of Business.
- Worked on Media and PR Management, contract management and access management for Harvard Business Review.
Environment: Windows, MS Office, MS Visio, HP Quality Center, RUP, UML, SQL, SWOT analysis, and SQL Server.
Confidential, Madison, WIBusiness Analyst
Responsibilities:
- Coordinated participation and sign-off on various business partners and customers.
- Prepared requirements document for Commercial Auto, Worker’s Compensation, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- Conducted JAD sessions with management, SME, vendors, users, and other stakeholders for open and pending issues.
- Prepared system documentation skills using use cases and functional requirement documents as well as for created Activity diagrams, State diagrams based on UML Methodology and business process flow diagrams using MS Visio
- Maintained current set of documentation for automotive customers.
- Created advertising slogans, managed marketing communications, and public relations for Princeton Information.
- Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in Requisite Pro.
- Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Used MS Visio for Process modeling and Business Process flow diagrams.
- Created business requirement documents and integrated requirements and underlying platform functionality for automotive customers.
- Establish documentation for Agile methodology for implementation with a Waterfall-centric development team.
- Ensured test cases and test process guarantee accountability to business and systems requirements.
- Involved in end-to-end testing phase.
Environment: MS Visio, MS Project, UML, RUM, XML, RUP, Business Objects, Mainframe, Microsoft Excel, Microsoft Word, and Microsoft Power Point.
Confidential, Richmond, VABusiness Analyst
Responsibilities:
- Understood and developed requirements and use cases for different types of cash adjustments and reporting for mutual fund accounts. These include derivatives (forward, options, swaps-OTC and exchange-traded), Foreign Exchange, Interest, Dividend, Equities, Wire/Fund Transfers (margins, collaterals and interbank and interfund loans) and Corporate Actions.
- Met with client groups to determine project scope, requirements and plan; managed project plans to maintain deadlines and track progress.
- Modeled processes using UML, flow charts, system data flow, task diagrams, sequence diagrams, data mapping, and use cases
- Scheduled one-on-one interviews with bank partners to understand current reconciliation process; used itemized general ledger and projected cash flow for actual current balance discrepancies.
- Worked with end-users and 7 custodian banks (business partners) to implement messaging for blotter variances, intraday adjustments, and failed trade reporting to replace current manual processes.
- Implemented market settlement guidelines into reconciliation process to improve efficiency of variance identification and research.
- Created a standard Excel template by identifying useful fields, creating required inputs to identify adjustment type, determining standard characteristics for each field, and analyzing which fields are required/optional for each adjustment type.
- Conducted analysis of client specifications that translate to middle office technology offerings.
- Ran SQL queries to pull account balances pooled by activity, actual, and current total balances.
- Identified enhancements to contents of cash projection file and reported detailed blotter variances.
- Responsible for user training and developing documentation/training guides before UAT testing.
- Developed test cases and for use-case models for reports interface.
- Used Clearquest to report bugs and defects during UAT.
- Provided asset managers, broker/dealers, custodians, and investment banks with palpable benefits, including greatly shortened processing cycles, reduced settlement risk, and lower operating cost.
Environment: UML diagrams, Agile Scrum, Rational Rose, Rational Requisite Pro, SQL, Microsoft Office, Data Warehousing, Lotus Notes 6.5, Adobe Acrobat, ATX tax, Quickbooks, Visual Basic, Informatica, Oracle DBMS, HP Quality Center, CSV, Java, and Clearquest.
ConfidentialBusiness Analyst
Responsibilities:
- Identified high-level requirements for developing and documenting detailed business requirements.
- Involved in meetings with SMEs and users for requirements gathering.
- Created system architecture and design using the UML Analysis Model and Design Model
- Analyzed various credit enhancements used by the companies and their inclusion in valuation of the company.
- Worked closely with software engineers, internal and external customers to gather comprehensive testing criteria and plan requirements to ensure accuracy and timeliness of projects.
- Performed informal benchmarking to analyze how competitors conducted business.
Environment: Rational Team Test 2000, Rational ClearQuest, Rational Test Manager Sun OS 5.8, Oracle, PL\SQL, and IIS 6.0.