Sr. Business Analyst Resume
Peoria, IL
SUMMARY
- More all 8 years of professional experience as a Business / System Analyst in Finance/Banking Domain.
- Hands on experience in creating SQL Queries, Stored Procedures, Data modeling, Triggers, Views, Indexes in SQL Server wif a strong understanding of data analytics.
- Design and review of various documents including the Software Requirement Specifications SRS, User stories, Business requirements document BRD, Use Case Specifications, Functional Specifications FSD, Systems Design Specification SDS, High Level Design Document HLD, Requirement Traceability Matrix RTM and testing documents.
- Worked efficiently on multiple projects spanning over different releases at the same time
- Good Understanding of different phase of Trade Lifecycle such as Account Set - up, Trade Order Generation, and Trade Order Execution, Order Settlement etc..
- Involved in SWIFT, ISO XML knowledge, RTGS and Bank Application administration and maintenance, specifically on international settlement and banking transaction using SWIFT code system.
- Strong domain knowledge in Banking and Finance. Good understanding of basic principals of financial markets and instruments Equity Derivatives, Cash Equities Domestic and International, Fixed Income, FX, Derivatives FX Options, OTC Options, Swaps, Forwards, Futures, Market Link Investments, Deposits, Repos, CDS, Mutual funds, NAV, fund accounting
- Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
- Strong subject matter expertise in Investment/Retail banking, financial statements, cash flow, financing structures, Foreign Exchange FX Risk Management, Capital Management, Asset Data, Fixed Income, Portfolio Analysis, Stock Valuation, Capital Structures and Budgeting, Value Based management. Worked extensively wif Microsoft Excel Macros, VLOOKUPS, and Pivot Tables. Proficient Microsoft Word, Power Point, Access and Lotus Notes. Extensive experience on Mobile/E-Banking solution.
- Excellent in Developing and evaluating business process Models.
- Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
- Experience on Requirements Definition and Management (REQM).
- Extensive review and gap analysis of various proto types developed for critical modules- Transfers, Payments, Accounts, Supports Settings, Login and Self Enrollment and validation of the same in different browsers Safari, Chrome, Fire fox and IE-8 as per the specifications defined in the Functional and Technical Artifacts.
- Excellent understanding of EFT system (such as US ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage). Knowledge of Online Banking and the whole Fund Transfer process.
- Worked extensively in Payments in the Banking Domain wifin Financial Services.
- Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked wif high volume databases wif partitioned data.
- Strong experience in RUP Business Modeling process.
- Used Query Analyzer, Execution Plan to optimize SQL Queries.
- Extensive experience in conducting Market Research, Feasibility Studies, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management. Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
- Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
- Professional experience in business analysis, operations management and development, design, documentation and testing.
- Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
- Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage Multiple project tasks wif changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
- Demonstrated ability to work well wif a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, halp team resolve conflicts constructively and ability and willingness to communicate when halp is needed. A Self-starter wif a positive attitude, willingness to learn new concepts and acceptance of challenges.
TECHNICAL SKILLS
Domain: Payment processing, General Ledger master accounts, Fixed Asset invoices, Cash balance management, Cash Flow, Intraday Liquidity, Automated Clearing House payments, credit networks, wire transfers
Processes: Scrum, Kanban, Agile, XP, Lean
Operating Systems: Windows, UNIX
Testing Applications: Rational Test Manager, HP/Mercury QTP, HPQC
Language: SQL, HTML, XML, Visual Basic Script
Operating Systems: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS TFS, MS Visio, MS Project, Microsoft SharePoint, MS Access, MS-Office (Word, Excel, Power Point, Outlook, Adobe Photoshop)
Methodologies: Rational Unified Process, SDLC, Agile, Waterfall Methodology.
Defect Tracking Tools: Rational Clear Quest, Clear Case, Excel
RDBMS: MS Access, SQL Server.
Web Technologies: HTML, SQL.
Requirement and Document Tools: Rational Requisite Pro, Rational Clear-Quest, DOORS, VISIO, and MS Project.
Business Modeling Tools: Rational Rose, Enterprise Architect, Visual Paradigm, Microsoft Visio
PROFESSIONAL EXPERIENCE
Confidential - Peoria, IL
Sr. Business Analyst
Responsibilities:
- Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios
- Designed and developed all Use Cases and UML models using Rational and Visio
- The project was to develop a Real Time Payments (RTP) transfer to bank in the world and vice versa. The first phase of the project was just to receive payments from any bank in the world.
- Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
- Prepared detailed design documents to translate business process TEMPeffectively for developers and product managers using MS Visio.
- Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
- Executed Regression and IST sceneries in the Quality Center
- Assisted in system and User Acceptance Testing, performed client presentations.
- Assured that all Artifacts are in Compliance wif corporate AGILE Policies and guidelines.
- Experience from Front to back office, worked wif fund managers, financial advisors and technical team members.
- Designed asset management portfolio for its customers as per business requirements.
- Interacted wif Fixed Income business heads to finalize the Business Requirements for the application.
- Wrote SQL statements to extract data from the Tables
- Hand on Experience of ACH- Fedwire, BillPay, Cards networks, schemes CHIPS, Faster Payments, Swift & system solutions.
- Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
- Has deep Functional experience in various Payments processing systems including Fundtech GPP and Banks Legacy systems.
- Planned and defined system requirements to Wire Frame wif Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
- Assisted wif project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
- Created various reports, Data sets and tan used those for building Dash Boards and enabled flash mode as per user's request.
- Created Security roles, Security Filters and assigned them to groups and users to meet the corporate requirements.
- Used MS Visio for Process modeling and Business Process flow diagrams.
- Conducted interviews wif various business users to collect requirement and business process information using MS Visio, Requisite pro.
- Conduct extensive analysis on security trading cycles provide consulting on financial disclosure, regulatory and Compliance issues
- Performed Data mapping, data mining, data analysis, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
- Used SQL for data extraction and data analysis, Qlik view dashboards has been made to increase the data visualization.
- Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, and Transaction capture Execution and reporting requirements for the user interface.
- Conducted project due diligence and created testing document to meet Sarbanes-Oxley and other Compliance requirements
- Worked wif Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives Options and Futures, Portfolio Management, Sales and Marketing.
- Implemented the solution to process both ISO messages and SWIFT payment messages.
- Mapping the Payments engine wif Confidential ’s High-performance Banking for Payments.
- Implementation is for the following payment schemes - SEPA Direct Debit and SEPA credit transfer.
- Helped the client for the transformation from the banks legacy payments processing engine wif the Global Pay plus (GPP) engine.
- Involved wif the trading activities of Credit Derivatives, Credit default swaps, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives and Futures including Commodity Futures Contracts and Financial Futures
- Designed and developed project document templates based on SDLC methodology
- Gained understanding of the Asset management requirements for risk analytics and developed the equity reference data mappings and equity reference data dictionaries considering the source system and target system equity reference data.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Identified Use Cases from the requirements and wrote Use Case Specifications document.
- Linked business processes to organizational objectives, identifying opportunities for business process improvement and involved in the performance of cost/benefit analysis.
- Worked extensively on data mapping and metadata requirements. Wrote SQL queries to test the source to target data.
- Reported status to project management and project owners on a weekly and monthly basis.
- Actively involved in developing, executing and coordinating functional and user acceptance testing UAT .
- Maintained strong working relationship wif various business groups such as project technical/development team and external clients throughout the development process of the credit card processing system.
- Interacted wif business area experts, IT experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical teams across organizational lines
- Provided continuous support to the development team in order to make sure that business requirements are being converted into a desired software product
- System was created and implemented for both EMEA and ASIA payments processing -SEPA (Single Euro Payments Area) and G3 (Singapore Clearing).
- Extensive work experience in Payments domain. Worked on Faster Payments BACS, CHAPS, EDIFACT, SEPA Direct Debit and SEPA Credit Transfer. Extensive work experience on SWIFT 1,2,9 & SEPA messaging formats (ISO2022).
- Worked wif SME and Tech leads to gather the data regarding the Capital Markets and Asset Management.
- Prepared, analyzed AS IS and TO BE of existing architecture and performed GAP Analysis, created workflow scenarios, designed new process flows and documented the Business Process and various Business Process and various Business Scenarios and activities of the business from the conceptual to procedural level.
- Hands on experience on funds transfer application including the messaging system like SWIFT and FIX protocol. CHIPS and Fedwire.
- Strong teamwork, interpersonal, relationship and presentation skills
- Work wif the managers to ensure document reflects current policies and procedures and adheres to NACHA and Regulation E Requirements.
- Excellent understanding of EFT system (such as ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage). Knowledge of Online Banking and the whole Fund Transfer process.
- Review SWIFT files on a daily basis and Processing Swift payment.
- Analyzed process for handling banking process execution exceptions Resolved process flaws by sending midday and EOD CRD trade files via Swift 1,2,9 messaging, which resulted in a 30% reduction of next day exceptions and reconciliations theirby saving time and cost for firm
- Conducted JAD sessions and involved in all phases of software development life cycle in RUP framework.
- Followed UML based methodology using Rational Rose for creating Business Cases and Use Case Models after assessing the status and scope of the project and implementing technology based solutions that will meet their strategic business processes needs.
- Interacted wif the Subject Matter Experts SMEs and stakeholders to get a better understanding of client's business processes.
- Monitored client expectations and skillfully negotiated wif clients through client involvement and all types of communication wif the client's team throughout the lifecycle of the project.
- Walkthrough of all the critical functional modules- - Transfer, Accounts, Payments, Support Settings, e-statements, Login, Self-Enrollment, Bundles to the business partners to reflect all the essential WCAG/ADA, related compliance requirements as defined under the compliance guidelines.
- Actively involved in designing of the system wif the system architecture and the development team, supporting the technical team in the product development and delivery process and translated the business requirements into Functional Specification Document FSD .
- Elicited meetings on credit card application process and payments.
- Conducted Agile stand up meetings and created user stories
- Involved in the periodically held JAD sessions for the purpose of project updates as well as involved in the weekly meetings to discuss the current project status.
- Created ETL test data for all ETL mapping rules to test the functionality of the Informatica mappings.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Created requirements analysis and design phase artifacts using Requisite Pro, activity diagrams and Sequential diagrams.
- Implemented Front End to a Fixed Income Derivatives Trading System, including trade blotter and interfaces to risk management, accounting, and middle and back office.
- Transforming Bank’s Legacy payments processing engine into an Industry standard payments processing system.
- Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
- Supported User Acceptance testing UAT and collaborated wif the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge. Planned and defined system requirements to Wire Frame wif Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
- Interacting wif the developers to report and correct bugs.
- Worked wif the business users and wif different levels of management to identify requirements, use cases and to develop functional specifications.
- Support the SWIFT interfacing team
- Review Commercial loan documentation to ensure enhancements are meeting the proper audit standards.
- Developed a new Credit Card application which was all automated and replacing existing system
- Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized. Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
- Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose. Facilitated Joint Requirement Planning JRP sessions wif SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
- Integrated Requisite Pro wif Rational Rose to provide all teams visibility and maintain traceability among requirements, use cases and change requests.
- Led client facilitation meetings to gather Interface and Business Process Requirements from Subject Matter Experts in Trading shares, Equities and Fixed Incomes like Bonds, and converted them into functional requirements by implementing the RUP methodology, authored the same in Business Requirement Document (BRD).
- Created Business Process Diagrams (BPD) and Business Flow Diagrams using MS Visio.
- Prepared graphical depictions of Textual Use Cases, creating Use Case Diagrams, and Activity Diagrams.
- Performed Fixed Income Analysis (Pricing, Risk, Yield, Duration, and Recommended Strategy) in Excel to support trading, and reviewed wif portfolio manager and traders.
- Assisted Risk Management Group in Financial analysis and Risk analysis on calculation of PV, FV, and other key trade metrics (e.g. Breakeven Rate) to test new Risk Analytic Tool.
- Performed Data Analysis and used SQL queries for Data Mining and Data Validation.
- Run SQL queries from multiple databases (data warehouse) for research, data integrity, and validation provide Adhoc reports to investment, accounting, and risk and compliance groups.
- Managed all the requirements TEMPeffectively and made them available to all team members.
- Authored Data Flow diagrams, Sequence diagrams and Business models
- Prepared detailed reports of the Bugs, Pass-Fail report, Comparison Chart
Confidential
Business System Analyst
Responsibilities:
- Wrote database interface specifications and documented in Data Manager data dictionary
- Utilized detailed knowledge of application features; functions assess scope and impact of business needs throughout analysis.
- Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft Share Point.
- Acted as a resource in understanding how IS carry out business functions and assists in ensuring the timely and TEMPeffective implementation
- Developed timelines for project delivery, and managed projects and resources to successful completion
- Liaison for projects wif other corporate departments, including Executive, Legal and Information Services as well as vendor relationships
- Assisted in development of training materials for new technology and process improvements
- Worked as a business analyst to build Strategy Web application for financial statements and inspections
- Identified, researched, investigated, analyzed, defined and documented business processes.
- Successfully managed a large scale project from requirements gathering through implementation to automate the assembly and mailing prep for Homeowners, Automobile and Umbrella policies to Insureds, Agents and Lien holders.
- Very strong knowledge of Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
- Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
- Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs
- Provide customer service and support for Property Casualty risk management needs.
- Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, Visio and Business Process Modeling
- Designed and developed Project document templates based on SDLC methodology.
- Conducted user interviews, gatheird requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
- Worked extensively wif Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
- Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
- Escrow and Reserve Administration, Escrow processing, Escrow Analysis, Non-Escrow Loans Collateral Inspection and Monitoring, Property Inspection, Income and Expense Statement Review, Inspection Report
- Analyzing the existing reports, reporting system
- Maintained on-going technical assistance and provided halp desk support to customer's mainframe systems software that included problem determination and resolution. Executed volume/load/acceptance/performance testing.