SUMMARY:

• 8+ years of experience in developing business processes and solutions as Business Analyst and QA within Financial Services domain
• Extensive Knowledge and experience in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) process
• Adept at documenting and transforming business rules into BRD, FRD using UML, Use Case, Activity diagrams with Visio.
• Excellent understanding of equity reference data warehouse concepts such as equity reference data marts, disk utilization analytics Meta equity reference data, logical and physical equity reference data modeling.
• Experience in accounting and systems roles with exposure to a variety of unique business problems
• Strong understanding of Portfolio Construction process for institutional clients with background in Fixed Income Investments.
• Broad understanding and knowledge of investment management across Fixed Income and Derivatives.
• Experience with Merchandise Planning, Assortment Planning, Demandware Ecommerce, Item Management.
• Acquired extensive knowledge of financial products and services, such as Fixed Income investments, Equities, Derivatives, Mutual Funds, Brokerage, portfolio management, Cash Management & Asset management.
• Accounting and Business: US GAAP, Financial reporting, Audits, Financial analysis and forecasting, Reconciliations, Payroll and HR issues, Tax reporting, Leadership, Project Management, Developing KPI and metrics.
• Hands on experience in Quality assurance practices, SCRUM, Test Plan development, Test Strategy development, Test case and Test data review.
• Experience in creating Test Scenario & Test Cases, Test Execution and various Test Management aspects including Test estimation, Traceability Matrix, Defect Management etc.
• Experience in Test Management, Test Strategy and Test planning across various projects in different domains.
• Experience in testing the frontend functionalities using Selenium.
• Extensive testing of the internet sites/applications on different devices and browsers using cross browser and browser stack.
• Responsible for mentoring resources technically and training other QA Team Members.
• Knowledge on AGILE product lifecycle management software solutions.
• Experience in testing Web Applications/ecommerce Applications and Mobile commercial applications.
• Ability to gather and document Business Requirements, experienced in writing Use Cases. Proficiency in SDLC, understands the workflow concept, ability to gather and document the 'As - Is' and 'To-Be' processes
• Excellent analytical skills coupled with interpersonal, communication and self-organizing skills. Extensive experience in handling Requirements Management, Business Requirement Documents, Use Case Specifications, Functional Specifications, System Design Specifications, System Requirement Specifications, Requirements Traceability Matrix and Business Analysis.
• Proven track record in data collection, analysis and evaluation in Information Systems issues, analytical problem solving, decision-making, leadership, communication and inter-personal skills with ability to interact with individuals at all levels.
• Facilitated Joint Requirement Planning (JRP), Joint Application Development (JAD) and Rapid Application Development (RAD) sessions. Skilled in gathering user requirements by performing gap analysis.
• Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
• Extensive experience in Business Process Engineering and Software Development with expertise in Analysis, Design, Development and Implementation.

TECHNICAL SKILLS:

Methodologies: SDLC, RUP, UML, Agile/SCRUM, Waterfall

Change Management: Clear Quest, JIRA, Pivotal Tracker

Business Modeling Tools: MS Visio, Rational Rose, Rational Requisite Pro

Operating Systems: Windows, Linux

Databases: Oracle 10G/9i/8i, My SQL, SQL Server 2012/2008

Languages/Platforms: SQL, Python, Java, VB, HTML, CSS, PHP

BA Tools: Microsoft Office, UML, Microsoft Project, Microsoft Visio, Tableau

QA Tools: HP Quality Center, Rational Quality Manager, HP Load Runner, HP Quick Test Pro

Testing Strategies: Integration, Unit, System, Black Box, White Box, UAT

Productivity Tools: HP QTP, HP Performance Center, HP ALM.

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst/QA Tester

Responsibilities:

• Team lead of 3 junior developers to convert more than 100 Fixed Income Exposure and Attributions reports from Oracle to Jasper.
• Served as a liaison between Mortgage Specialists and the Project Team.
• Performed Automation of test with extensive VB Scripting for dynamic code in QTP.
• Wrote the functions in Function Libraries and associated the required function libraries to each test using QTP.
• Performed complex integration and regression tests on multiple applications using QTP.
• Developed a Hybrid Automation Framework to perform Functionality and GUI testing using QTP.
• Participated in walkthroughs for the evaluation of the test plan with the QA Lead and development team.
• Analyze and deliver solutions of the OTC derivatives impact of the MiFID II requirements on client documentation, transparency and disclosure to regulators, trade execution process and platform changes at both pre-and post trade levels
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Made sure the project delivery is met with quality and in time.
• Did Test case design for SMS, MMS and PAMENT API's.
• Created Test Scripts in SoapUI.
• Executed test cases for SMS, MMS and PAYMENT API's and updated the results in Quality Centre.
• Involved in status updates and discussions on new requirements and functionalities in Daily Scrum meetings.
• Worked on Black Knights Empower LOS for Retail, Wholesale, and Commercial Loans.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different Business Groups and Programmers.
• Created the Test strategy and made the team well versed with it.
• Coordinated with the team for the test execution and QA process.
• Communicated the overall status to the client and also took care of the excalations.
• Logged defects found during testing and followed up with the developers to find a solution for the same.
• Played an important role in Daily Scrum/Stand up meetings, Sprint Planning and Retrospective.
• Independently performed valuations for varied fixed income products to verify pricing and book settlement from front, middle, and back office by analyzing cash flows and executing simulations for cash/repo/ warranty.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Designed the system, prepared UML and Sequence Diagrams using Rational Rose and MS Visio.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Generated ad-hoc reports by writing custom SQL queries and processing with Python (numpy/pandas) and/or R. Frequent queries automated with use of Python.
• Gathered business requirements, created as-is and to-be process flows, provided recommendations to improve business processes, and prepared presentations.
• Involved in Backlog meeting which is to review and prioritize stories.
• Analyzed stories and defined the test case based on story's Acceptance Criteria.
• Interacted with Dev team on open defects and pending issues until. Shared the information in the daily scrum meetings.
• Discussed the status, defect count on daily basis in the meetings which involved QA Team Members.
• Involved in Pre-Release meeting, where we discuss about the release date/time for deployment and list of stories that are going as part of releas
• Evaluated the portfolio impact of investing/divesting in equities, mutual funds, and fixed-income investment instruments in order to diversify portfolio risk and increase return.
• Composed multiple new process flows for Derivatives processes such as Pricing, Settlements and Valuations
• Prepared Detailed Design Specifications (DDS) and Functional Specification Documentation (FSD) and communicated these to the Stakeholders.
• Performed quality assurance and testing of SQL server environment.
• Used MS Visio for Process modeling and Business Process Flow Diagrams.
• Collected requirements, designed a java based credit/debit/gift card Payments Web Services application, and translated these into Functional specifications (FRD) and detailed test plans.
• Extensively involved in Regression Testing during various phases of the application.
• Prepared Test Plans wrote Test Scripts and executed Test Scripts as the project develops.
• Developed Data Models and generated Database Schema Structures and developed Data Flow Diagrams.
• Participated in status meetings where such defects logged in Quality Center were reviewed.
• Used XML Spy for Data Mapping and Data Modeling for large scale System Integration with partner applications.
• Perform cost-benefit analysis and document return on investment on the proposed strategy

Sr. Business System Analyst

Responsibilities:

• Participate in a post-trade processing cost-save initiative, which involves liaising between senior managers in multiple areas of the business and multiple service providers including DTCC Omgeo, Bloomberg STP and SS&C to assess which service providers BNY Mellon wishes to utilize to ensure interoperability will be satisfied
• Managed and coordinated creation of SDLC documentation including business requirements, functional specification, testing (including test plans, test cases, test results and error tracking), change requests, and CAIR logs.
• Coordinated and implemented straight through processing for inbound and outbound interfacing applications (proprietary and third party) including SWIFT messaging.
• Performing business intelligence activities including data mining and analytical processing to identify trends in data. Reporting and charting findings for dissemination within the company; providing SQL support to data analysis team. Ad-hoc reporting as requested via SQL, Excel, and Tableau. Automating EDW course audit validations.
• Analysed collected data in R and Python for patterns and possible solutions to developing problems.
• Basel 2.5 reporting (Clean P&L) for FX (all products), Futures (interest rate) and Options (listed and OTC).
• Began Basel III planning for risk weighting, liquidity and capital equivalents.
• Business Analyst projects implemented include:
• Trade date reporting for future and option cash transactions.
• Initial margins calculation and settlement.
• Reconciling beginning balances, creating cross-functional worksheets for exchange rates, documenting data, diagramming "as-is" and "to-be" business processes etc.
• Liaised with both Subject Matter Experts for each individual procedure and the end user Derivatives Operations Managers spread across the globe in both the EMEA and APAC regions
• Constructed core curriculum for training of multiple divisions of the Derivatives team around the globe, to ensure full functionality on the end state derivatives platform
• Understand fully the order management workflow of various Portfolio Construction Tools across different assets say Fixed Income Portfolio Management, Portfolio Management Workstation.
• Analyze portfolios exposures, risk attribution and provide recommendations for the performance attribution for the Fixed Income portfolios in accordance with GIPS framework.
• Single currency margining (converting all margins to a base currency for settlement).
• Custodian reporting for outsourcing client processing
• Developed advanced SQL queries with multi-table joins, group functions, subqueries, T-SQL stored procedures and user defined functions for data analysis.
• Credit Default Swaps data input and settlement processing
• Dodd-Frank processing, including DTCC reporting and processing trades through SEFs for FX (forwards, swaps, NDF’s and options)
• FX and futures trade execution STP from ECN’s and liquidity providers into front and back office systems including data conversion (ETL)
• Processed manual trouble shooting and system updates using MS SQL server to execute and update SQL queries.
• Developed SQL queries for database verification
• Implemented changes and updates to legacy Money Market legacy application
• Extracted data from Excel source files into SQL databases using MS SSIS did necessary data transformation and loaded into database.
• Created Linux scripts (bsh and perle) to add checksum value to data files sent to downstream applications.
• Interacted with business users to analyze business needs, gather and document business and system requirements. Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.

Financial Business Analyst

Responsibilities:

• Created complex reports & dash boards using IBM Cognos Query studio and Reports studio.
• Designing relational package using Frame work manger metadata model.
• Collaborate with senior developers and the Data Architect to design and build BI and reporting solutions against Relational databases that satisfy all functional and technical requirements.
• Develop PL/SQL scripts to test IBM Cognos reports for accuracy.
• Coordinates the Enterprise Resource Planning (ERP) system operations and reporting needs with corporate level Financial Planning & Analysis and Budgeting & Forecasting functions.
• Served as a liaison for FHI360 country offices and government official in various countries of the world.
• Supported in oversight of the qualitative and quantitative progress of research and research implementation activities via telecommunications, letters and e-mail.
• Utilize Java, MySQL, and XML with Jaspersoft Studio
• Prepared procedure documentation by shadowing employees in the Billing & Credit departments using MS Word & Visio to capture "as is" processes
• Analyzed the "as is" process, showing how automation in SAP could streamline processes
• Wrote the business requirement documents (BRD) that depict proposed changes to the SAP system for the project team
• Create and maintain SQL Server Reporting Services projects and data models with SQL Server Analysis Services
• Management of security administration in the SQL/SharePoint environments
• Successful implementation of Microsoft Dynamics AX (365) Financial ERP system
• Assisted with oversight of study-specific reporting and tracking of key indicators for evaluation of site performance and study progress.
• Executed data mining, data quality profiling, and performing quality assessments by developing and adhering to current and future business rules.
• Managed technical support and product and market intelligence in FactSet and Bloomberg STP to support analysts and product management in research
• Creates dynamic templates, financial models and reports that support a wide range of global users.
• Documenting requirements for configuring ERP applications and uses ERP implementation methodologies.
• Involved in full project life cycle implementation (Requirements gathering to production phase).
• Applies implementation and operation control concepts to assess the exposures resulting from ineffective or missing control practices.
• Corporate Software Trade and Logistics team member implementing Microsoft Dynamics AX 2012 R3, analyzing business processes within multiple corporate divisions, modeling business procedures and process improvements.
• Acts as a project manager of designated projects that integrate various global financial data from all departments into final reports for the corporate office.
• Develops and deliver training related to ERP reporting tools.
• Responsible for maintaining intradepartmental communication sites on SharePoint.
• Supports system testing and report development activities.
• Responsible for "IBM Cognos" CER report development validation, User Acceptance Testing support (UAT) and follow-up.
• First-line support to the global users of the enterprise financial system (Costpoint, TESS, Gov. Win, TM1 and Cognos CER).
• Responsible to track the Entitlements and SOD violations as per application basis

Business Analyst/QA Tester

Responsibilities:

• Gathered requirements and developed processes to on-board 300+ business applications into Sailpoint IdentityIQ
• Maintain and update the onboarding application Questionnaire by getting inputs from the internal customers, application owners and application SME's
• Reviewed and Analyzed requirements (User Stories) to create test scenarios, test cases, test scripts for planning, scheduling, and running tests in ALM Quality Center
• Demonstrated skills in UFT automation testing by defining, implementing and executing automated functional, regression test strategy using data driven framework.
• Create automated tests for media service streaming and text-to-speech functionality
• Created user defined functions, reusable actions to develop VB script and enhanced the test scripts using Descriptive Programming to come up with the possible solutions for the business problems.
• Prepared detailed test execution schedule, including data setup and batch execution dependencies
• Coordinate the end to end onboarding of an application through the different phases of SDLC
• Created different artifacts such as BRD, FRD, Questionnaire document, project plan and PPT slides
• Frame set up for enterprise level Role mining, Role Based Access Control (RBAC), Multi Factor Authentication (MFA), Single Sign on (SSO), PAM (Privileged Account Management), Entitlement Management and Identity Management
• Established standards, designs and implementation of appropriate identity and access management processes and controls which help improve operations and lower risk
• Collaborate with client in implementation of the planning, training and operating of automated systems
• Provisioning and access governance experience with and understanding of security on systems such as AD, LDAP/Unix, Oracle and manual provisioned applications
• Monitor the JMS queue for ETL batch process.
• Working in SQL Server 2000 using SQL Server Management Studio; creating tables, views and scheduling SQL Jobs under SQL Server Agent
• Responsible to create AS IS and TO BE Business Process Flow diagrams in MS Visio
• Assist Project Manager to identify risks and create mitigation plans
• Understanding of directories (AD/LDAP) and group structures, policies etc.
• Responsible for design and implementation of SailPoint's IdentityIQ
• Excellent knowledge and experience in implementing user provisioning credential management, workflows, forms, application integration, connectors, reports and roles
• Performed data analytics to ensure data is accurate prior to staging and activating certifications
• Served as liaison between platform, technical and business teams for end to end business process
• Direct provisioning using direct connectors for integration of target applications
• Excelled in finding, documenting and reporting bugs, defects, UI flaws and other issues within the application using Jira for defect tracking.
• Insert, update info on front end and verified data within the database using SQL statements.
• Performed functional, regression, smoke, back-end, integration testing, and user acceptance testing throughout the system development and test life cycle.
• Attended and actively participated in weekly QA, Agile Scrum planning meetings and User Story sessions.
• Demonstrated methodical, detail-oriented and thorough approach to all assignments while adhering to compressed timelines.
• Consistently recognized for excellent problem-solving and analytical skills by programmers, peers and supervisors.
• Create design documents and functional specifications for development and enhancement work efforts
• Gather requirements by conducting meetings and brainstorming sessions with SMEs and senior management
• Involve in conducting JAD (Joint Application Development) sessions with the entire team
• Performed Integration with multiple applications such as AD, Exchange, RDBMS, Flat File & LDAP
• Liaison between stakeholders, system users, managers, software development team and the QA team to gather requirements.

Business Analyst

Responsibilities:

• Prepared Business Requirement Documents (BRDs) after the collection of Functional Requirements from System Users
• Partnered with internal business process owners, project manager, Subject Matter Experts and other Business Analysts to define and document the scope of the new project.
• Ensured appropriate action to add values to the working relationships, performed training, technical briefings, documentations, and tracked and captured the details of the events.
• Drafted appropriate plan documentations (project plan, communication plan, risk management plan, etc.); facilitated appropriate reviews and secure approvals as needed.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Liaised between the IT team and Business Users to resolve the gaps, defects/bugs identified during the course of UAT.

Business/ Quality Analyst

Responsibilities:

• Leading user interviews, gathering requirements, analyzing the requirements using Rational Rose requisite pro - RUP
• Designed the business requirement collection approach based on the project scope and SDLC methodology
• First point of contact as Team Lead for inquiries regarding system implementation, client policy/procedures, and technical questions
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Conduct workflow, process diagram and GAP analyses to derive requirements for existing systems enhancements
• Maintained and kept track of stakeholders request for enhancements and changes using Unified Change Management tool (UCM) such as Rational ClearQuest.
• Designed and implemented basic SQL queries for QA testing and report / data validation.

Quality Assurance Analyst

Confidential

Responsibilities:

• Analyzed business requirements, developed test cases for different scenarios using Excel and then loaded in to Quality Center
• Followed agile methodology and involved in life cycle testing, functionality testing, integration, regression testing, performance testing, volume testing, and defect tracking and testing for accuracy in work flow plans.
• Associated with team lead for developing System Test Plan and Test Cases with detailed the testing scope, strategy, hi-level test requirements, validation and necessary resources.
• Performed backend testing using SQL queries.
• Worked as a team member and performed manual testing of the application to test the system for both the functional and business requirements for positive and negative scenarios using Quality Center.
• Developed Data for individual test cases and coordinated reporting of defects and retesting of fixes with development teams