Product Owner / Sr Business Systems Analyst Resume
Boston, MA
PROFESSIONAL SUMMARY:
- 10+ years of specialized professional experience working as a Business Analyst with global financial institutions for implementing straight - through processing (STP) trading applications involving securities specifications, pricing, trading, compliance, clearing & settlement, and risk management for wide range of instruments such as equities, bonds, futures, swaps, forwards, options, and credit derivatives products such as credit default swap, asset swap, and interest-rate swap
- Profound knowledge of various equities and fixed income securities such as Corporate Bonds, Munis, Treasury Bills, Treasury Notes, Treasury Bonds, Government Bonds, Rights, Warrants, Commercial Paper, FRA, Inflation Linked Bonds, CDO, CMO, ABS, MBS, Money Market Securities, and Agency Bonds
- Extensive experience in business analysis and project management using different SDLC methodologies (Waterfall, Modified Waterfall, Agile SCRUM, Agile XP, RUP, Iterative, Incremental, Hybrid and RAD)
- Proficient with requirement gathering and documenting BRD; translating requirements into clear functional specifications and documenting FSD
- Created Initiatives, Epics, features and stories, managed test and defect suites, and handled sprint related ceremonies like discovery, grooming, planning, demonstration and story acceptance
- Strong experience with complete trade lifecycle for exchange-traded and OTC instruments; collaborated with Front Office, Middle Office, and Back Office for requirements analysis, workflows, and production support
- Strong knowledge & working experience with financial securities data, financial analysis, FNMA, Dodd-Frank, EMIR, Basel II / III, Confidential for compliance / risk management, portfolio accounting & reconciliation, GAAP, and Sarbanes-Oxley (SOX) for Accounting, Charles River for straight through processing, compliance & post trade settlements, Sunshine ACT for Physician Financial Transparency Reports
- Extensive experience in business process modeling using MS Visio, Rational Rose, IBM WebSphere to develop various UML diagrams - Use Case Diagrams, Swim Lane Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams, Class Diagrams, Business Workflow Diagrams, and State Diagrams
- Proficient in capturing data requirements for market & reference data - by building data mapping documents documenting data source, data target, business rules; created metadata documents like data dictionaries; and performed data cleansing
- Extensive experience in identifying data specifications (source, target, transformation rules, validation rules, derivation rules) to construct ETL process to perform extraction, transformation, and load functions for the underlying data warehouse
- Solid experience in collaborating with Project Manager in managing project plan, facilitating daily status meeting, sprint scheduling, resource management, and change management
- Valuable experience in capital market products, equity trading, portfolio management, hedge funds, exchange-traded funds (ETFs), mutual funds, and financial risk management
- Hands-on experience in writing SQL queries for data analysis, ad-hoc reporting, and data validation; also assisted development team in constructing stored procedures and documented batch jobs specifications
- Well versed in assisting DBAs to conduct Data Modeling - designing database through building Conceptual, Logical, Physical data models identifying entities, relationships, data attributes, and constructed ER diagram using ERwin data modeler
- Excellent understanding of financial protocols such as SWIFT, FIX, and FpML
- Knowledge of the secondary Confidential market and securitization process, and have good understanding of the servicing market and the concepts like servicing fee, guarantee fee, gross note rate, etc
- In-depth knowledge of different types of financial risks like credit risk, market risk, liquidity risk, interest-rate risk, inflation risk, systematic risk, counter-party risk, operational risk; and other risk metrics like VaR, Yield, Duration, Convexity, YTM
- Excellent understanding of derivatives & fixed income pricing & quant techniques such as Black-Scholes, Binominal Options Pricing, Discounted Cash Flow, Time Series Analysis, Greeks, and CAPM with analyzing the variance and risk involved
- Strong experience in performing GAP Analysis and Feasibility Study to identify the variance between current and future application and to confirm the compatibility of existing IT infrastructure with future application
- Solid experience in structuring and coordinating different project meetings such as JAD sessions, user meetings, walkthroughs, and change request analysis
- Hands-on experience in supporting Quality Assurance team to document Master Test Plan, Test Cases, Test Scripts and perform Functional Testing, System Integration Testing, GUI Testing, Black-Box Testing, Performance Testing, Smoke Testing, Regression Testing, and assisted in User-Acceptance Testing (UAT)
- Proficient in creating Requirement Traceability Matrix (RTM) to capture relationship between project documents (Business Requirements, Functional Specs, Test Cases) and track business requirements through-out the development & testing process
- Strong experience in using QualityCenter, JIRA, BugZilla to manage the end-to-end defect tracking lifecycle identifying defects, logging defects, prioritizing defects, generating defects summary reports, and re-testing fixed defects
TECHNICAL SKILLS:
Operating Systems: Windows 98/2000/NT/XP/Vista, UNIX, Linux
Languages: JAVA, J2EE, HTML, VB Script, VB, XML, UML, SQL, C/C++, .Net, C#, Perl, Shell, Python
Databases: Oracle, MS SQL, Server, Sybase, DB2, My SQL, MS Access
Data Sources: Bloomberg, Reuters, Markit, Interactive Data (FTID), DTCC, TriOptima
ETL/ BI: Informatica, IQ ETL, SSIS, Crystal Reports, Cognos, Business Object, Teradata, Oracle E business Suite,Hyperion, OBIEE
Quality Assurance (QA): TestDirector QualityCenter, JIRA, BugZilla, ClearQuest, LoadRunner, WinRunner, QTP, Selenium
Tools: MS Visio, RationalRose, Erwin, Rational RequisitePro, Rational ClearCase, MS Office Suite, Tivoli, Autosys, PL/SQL, Management Studio, TOAD, Content Management System, Rally, Fiddler, Balsamiq, Axure
PROFESSIONAL EXPERIENCE:
Confidential, Boston, MA
Product Owner / Sr Business Systems Analyst
Responsibilities:
- Organized discovery sessions with business users to understand their needs and their priorities
- Perform data analysis to understand the data that we receive from different source
- Conducted grooming sessions with the technology team so they can have a better understanding of the stories
- Created the high-level plan and release plans for releases, quarter and year
- Wrote epics and features to be able to capture the business need and that were gathered and the gap analysis that was performed
- Write stories and review with the team and get feedback so that everyone has a clear understanding of the functionality, manage and prioritize the product backlog
- Created complex UML diagrams using MS Visio for showing business structure reengineering and changes in functionality and workflows
- Helped in developing the ETL by analyzing the trading algorithms for the best utilization of data and transforming it into information required by users
- Created screen mock ups and flow diagrams using MS Visio for provide more clarity of the business requirements
- Helped in preparing and updating the user guide and data dictionary which help the user to better use the application and also provide a comprehensive view of all the fields used in different widgets
- Created documents for system requirements-performance, concurrency, peak and monitoring requirements
- Conducted business overview sessions with business, development and testing teams
- Reviewed QA & BUAT test documents - test suite, test cases, and test scripts to make sure they align to the requirements
- Created documents to help in load and volume testing to effectively measure the capacity of the application
- Created, managed and analyzed defects so as to make sure that all the defects that were created where accurate and have been handled correctly
- Performed BUAT and Production checkout testing
- Reviewing and accepting the user stories on behalf of the business users
- Created release notes for management and business users
Environment: XML, Microsoft Excel, Microsoft Visio, Microsoft PowerPoint, SQL Developer, Ranorex, HP Unified Functional Testing, Tool Agnostic Framework, Tortoise SVN, Rational Team Concert
Confidential, Washington, DC
Product Owner / Lead Business Analyst
Responsibilities:
- Agile Scrum and Modified Waterfall methodology was used in this project
- Performed gap analysis to understand the discrepancies in existing systems and functionality
- Analyzed upstream and downstream dependencies and functionality to get a clearer understanding of the existing system functionality
- Hosted requirements gathering and discovery sessions to understand the business needs and provide solutions
- Created the high level plan and managed it in Rally
- For the modified waterfall project, compiled the BRD based on the requirements that were gathered and the gap analysis that was performed with clear and concise requirements for smooth system development
- Crafted the initiatives based on the requirements and the projects differentiation
- Wrote epics and features to be able to capture the business need and that were gathered and the gap analysis that was performed
- Write stories with constant collaboration with the team so that everyone has a clear understanding of the functionality
- Created complex UML diagrams using MS Visio for showing business structure reengineering and changes in functionality and workflows
- Created screen mock ups using MS Visio, Balsamiq and Axure
- Helped in creating the Data Dictionary which gave a comprehensive view of all the fields used in different screens and their data types, descriptions and error messages for different scenarios
- Created documents for system requirements-performance, concurrency, peak and monitoring requirements
- Drafted and presented high level overviews to senior management and conducted in-depth knowledge transfer sessions with peers
- Conducted business overview sessions with business, development and testing teams
- Created product and data mapping documents to handle the data coming in and going out to customers’ loan origination systems
- Assisted QA & UAT team by reviewing test documents- test suite, test cases, and test scripts to make sure they align to the requirements
- Performed created, managed and analyzed defects so as to make sure that all the defects that were created where accurate and have been handled correctly
- Generated and created reports for management reporting needs
- Assisted QA & UAT team by reviewing test documents - master test plan, test cases, and test scripts to make sure they align to the requirements
- Performed defect analysis so as to make sure that all the defects that were created where accurate
- Created RTM (Requirement Traceability Matrix) for better tracking of requirements from requirements to test cases and then to defects
Environment: Quality Center, IBM DOORs, Microsoft Excel, XML, Microsoft Visio, Microsoft Project, Rally, Fiddler, Balsamiq, Axure
Confidential, Chicago, IL
IT Business Analyst / Project Manager
Responsibilities:
- Adopted Iterative methodology for three of the four projects so as to have a working model before making changes to it.
- Helped the steering committee is creating the storyboard and the charter requirements which give a high level view of the project.
- Created project related documents like Project Timelines, Project scope and Project Plan for better understanding and direction for the team
- Created BRD with the help of change management gathering concise and measurable business requirements from product owners and SMEs and documented HLD, and Written Use Cases
- Conducted JAD sessions with various teams including Operations, Change management and technical to help analyze the goals and understand the road blocks identify the strategic goals & objectives, to resolve open issues, and to design the application for effective development
- Created Epics and stories for each iteration, assigned Fibonacci series story points for each story, managed the demonstration of functionality before release for technology
- Created Performance Metrics and handled Sprint Planning, Scrum meetings, De-Briefing, Retrospective etc meetings with Business Counterparts
- Acted as bridge between the management and the team and also handled upward reporting to senior management
- Communicated with upstream and downstream teams and handled cross functional teams
- Create presentations and diagrams and give high level overviews and knowledge sessions to onboard new resources
- Used MS Visio meticulously to perform UML modeling - use cases, activity diagrams, swim lane diagrams, business workflows, sequence diagrams, data flow diagrams used in high level design and screen mockups.
- Proficiently created data mapping document to handle the data coming from going to different upstream and downstream applications and also data going outside to TriResolve/TriOptima for reference data, market data which include PET data, MMS data, agreement data and counterparty data for CFTC project reconciliation project and margin calls valuation data, trade data and agreement data for Margin STP project
- Supported Project Manager in created the project plan and the RACI matrix and helped in designing the decision tree and identifying the timelines and defining tasks that are important and the time required for completing them
- Used TOAD extensively to write SQL queries to get required data from the database or for the ETL process to help in analyzing the data, back end testing, reporting or even testing to do the GAP analysis.
- Assisted data architecture team in creating data model - entity-relationships (ER) diagram and also helped them in database modeling and creating the data document that captures all attributes related to data.
- Assisted QA & UAT team in visualizing and creating master test plan, test cases, test scripts, and extensively used Quality Center for Defect Tracking and Prioritization
- Helped Perform system testing along with the QA team - used to perform Functional Testing, System Integration Testing, GUI Testing, Black-Box Testing, Performance Testing, Smoke Testing, Regression Testing, and UAT, also helped the developers with Unit testing
- Handling bugs and defects for the project and iterations which have already been released to production
- Worked on Enhancements requirements as a production support function
- Provided on-going support by continuous monitoring
- Used excel to build Requirements Traceability Matrix (RTM) for better tracking of business requirements from charter to test cases for each individual requirement
Environment: UML, Rational Requisite Pro, MS Visio, MS Office, MS Project, Java, J2EE, XML, Unix, QTP, Quality Center, Autosys, PL/SQL, Quartz, Python, Toad for SQL Server, Toad for DB2, Confluence, JIRA
Confidential, NY
Sr. Business Systems Analyst
Responsibilities:
- Adopted Agile Scrum methodology throughout the application development (SDLC) process to manage, validate, and implement the Confidential
- Employed different requirements elicitation techniques for gathering business requirements from product owners and SMEs and documented BRD, FSD, and Written Use Cases
- Extensively used MS Visio to perform UML modeling - use cases, activity diagrams, swim lane diagrams, business workflows, sequence diagrams, data flow diagrams, and screen designs
- Efficiently handled various incoming data feeds from Bloomberg, Reuters, Markit for market data, reference data, corporate actions data; built data mapping document mapping the feeds through the underlying database
- Used FPML, SWIFT for sending encoded financial messages to counterparties
- Supported Project Manager in identifying the project timelines for deliverables, managing resources, and resolving conflicts to ensure successful project delivery
- Extensively used SQL queries to validate the ETL process (data extraction, data transformation, data loading) and to conduct data analysis, back-end database testing, and user-based reporting
- Assisted database modeling team in building data model - entity-relationships (ER) diagram and data document capturing the data objects, relationships, and database dependencies
- Conducted GAP analysis by documenting current technologies along with enhancements to meet end-state requirements
- Facilitated several JAD sessions with product owners and team members to identify the strategic goals & objectives, to resolve open issues, and to design the application for effective development
- Assisted QA team in documenting master test plan, test cases, test scripts, and used Quality Center for Defect Tracking
- Performed system testing along with QA team - Functional Testing, System Integration Testing, GUI Testing, Black-Box Testing, Performance Testing, Smoke Testing, Regression Testing, and UAT
- Built Requirements Traceability Matrix (RTM) tracking user requirements against test cases to ensure that project meet the client expectations
Environment: UML, Charles River Investment Management Solution (CRIMS), Rational Requisite Pro, Content Management system, MS Visio, MS Office, MS Project, Java, J2EE, XML, Oracle, Unix, QTP, Quality Center, Autosys, PL/SQL
Confidential, NY
Lead Business Analyst
Responsibilities:
- Interviewed business users to understand business model, gather user requirements, analyze data flows, and identify project scope; transformed user requirements to system specifications, and created BRD & SRS
- Followed guidelines and generated project deliverables as per Rational Unified Process (RUP) methodology in different iterations and stages throughout application development process
- Widely used Rational Rose to construct UML diagrams such as use cases, business workflow, screen mockups, process workflows, activity diagrams, sequence diagrams, and system architecture
- Analyzed and designed Graphical User-Interface (GUI) screen layouts and continually re-designed to ensure a user-friendly interface for the business users
- Created data mapping spreadsheet - capturing the data source, data target, and validation rules for loading data into the targeted databases, via ETL process; assisted in creating ER models for database design
- Executed various SQL queries on respective databases to generate ad-hoc reports on market and reference/static data
- Conducted detailed GAP analysis to identify the project scope by capturing the current process flow and the future process flow making sure that system initiatives are fulfilled
- Performed different project management tasks like managing project plan, allocating resources, deliverables scheduling, and tracking the project development during the software development process
- Lead and organized several JAD sessions with the project stakeholders to build system architectural design, map functionalities towards user requirements, analyze, and prioritize system specs
- Supported QA team in creating test plan capturing testing objectives, testing timelines & schedule, and testing strategies
- Collaborated with QA team to identify test scenarios and build detailed test cases; thereafter performed functional testing, integration testing, system testing, performance testing, load testing, sanity testing, regression testing, black-box testing, and facilitated UAT with business users
- Built the Requirements Traceability Matrix (RTM) tracking the test cases against each business requirements and system specifications to ensure end-to-end 100% coverage
Environment: Windows, MS SQL Server, RUP, Rational RequisitePro, UML, MS Office, Java / J2EE, HTML, Rational Rose, JIRA, QTP, Tivoli, Management Studio
Confidential, NY
Lead Systems Analyst
Responsibilities:
- Implemented Waterfall methodology during all phases of application development lifecycle
- Conducted different project management responsibilities and managed the project lifecycle including project planning, dealt with change management, and defining the project scope
- Collected user requirements from end users, analyzed the project scope, and designed the application framework
- Adopted the UML methodology using MS Visio to create Use Cases, Data Flow Diagrams, Activity Diagrams, State Diagrams, and Swim Lane Diagrams to document the application workflow
- Conducted GAP analysis to understand the AS-IS and TO-BE process model evaluating the benefits and differences
- Performed data mapping defining data source, business rules, and data target to facilitate the ETL process to feed the data into data warehouse
- Extensively used SQL query to validate the database and generating user based custom reports
- Performed several JAD sessions with business users to gather project information - data sources, data feeds, and data format for input data file
- Supported testing team with developing master test plan, test objectives, test scenarios, test cases, and test scripts
- Conducted Functional Testing, Integration Testing, System Testing, GUI Testing, Black Box Testing, Performance Testing, Load Testing, Sanity Testing, Regression Testing, and User Acceptance Testing (UAT)
Environment: Windows, Rational RequisitePro, Rational ClearQuest, Rational ClearCase, Sybase, Informatica, Autosys, Java, C++, XML, MS Office Suite, MS Visio, HP Quality Center