We provide IT Staff Augmentation Services!

Systems Analyst Resume Profile

5.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Over 7 years of experience as a Business Analyst with strong domain knowledge in Banking, Mortgage and Investment banking industries.
  • In depth knowledge of Capital Markets, investment risk and return, portfolio management and retail banking industry.
  • Strong knowledge in Capital Markets, Equities, Debt, ETFs, Mutual Funds, Mortgage, Portfolio Management, Performance Analysis, Securities and Valuation, Trading systems, Derivatives, Risk Analysis and Wealth Management.
  • Strong knowledge of fixed income securities Treasuries, Corporate Bond/Notes, Munis, MBS , fixed income derivatives CMO, ABS, TBAs, CDS , equity/equity derivatives Stocks, Options, Futures, Indexes
  • Excellent knowledge and understanding of TAXONOMY.
  • Knowledge in Data Quality Analysis, Data Modeling, Data Mapping, Data Validation, MetaData Trending Analysis and creating Data Modeling, manage business Taxonomy database.
  • Assisted to develop of a normalized, hierarchical categorization schema for all product types this taxonomy increased the utility of the data by making parametric searches and side-by-side product comparisons possible
  • Worked in BW/BI reporting tools in SAP and Knowledge in Financial Accounting, Accounts payable, Accounts Receivables, Excellent Sarbanes Oxley Act SOX , and GAAP.
  • Extensive experience in Excel, Word, PowerPoint, MS Project, MS Visio, Quality Center and SQL.
  • Knowledge in Data Quality Analysis, Data Modeling, Data Mapping, Data Validation, Trending Analysis and creating Data Modeling
  • Worked on high level analysis using OBIEE along with Oracle Financials, and Oracle answers
  • Extensive experience in Business Analysis, Business Process Re-engineering, Business Process Design, Modeling and other core areas of Business Analysis like Effective Requirement Gathering and Documentation.
  • Experience in developing and imparting pre and post implementation training, conducting GAP Analysis and User Acceptance Testing UAT .
  • Working expertise in Software Development Life cycle SDLC , Project Life cycle, Business Process Modeling BPM , and Software Development Methodologies including Agile, Rational Unified Process RUP and Waterfall.
  • Actively used Joint Requirement Planning JRP , Joint Application Development JAD and Rapid Application Development RAD , Sessions with Business Users, SME's and Stake holders to gather requirement.
  • Extensive experience in producing documents like Business Requirements Documents BRD , Functional Requirement Specifications FRS .
  • Extensive knowledge and working experience in converting business requirements into UML diagrams using Rational Rose and MS Visio.
  • Experience with SharePoint for maintaining document repository.
  • Highly motivated self-starter with excellent communication, presentation and interpersonal skills, can perform well independently as well as part of a team, always willing to work in challenging and cross-platform environments.
  • Ability to work independently and within groups to meet deliverables with an action and result oriented approach to work ability to build and maintain strong working relationship with all levels of management along with cross-functional team with a minimal supervision in a fast pace and changing environment.

FUNCTIONAL Skills:

Business

Subject Areas

Capital Markets

Investment Securities

Debt

Equity

Compliance

Private Banking

Portfolio Management, Mortgage Back Securities, Bonds.

10k Reporting, Risk Rating, Business Reporting, Client Reporting.

Disclosures, Loan Acquisitions, Loan Servicing Loan Originations, QRM, Loan IQ

Data Quality Data correction process.

Corporate Governance, SOX, Anti Money Laundering.

Deposits, Credits, and Investments.

Technical Skills:

Operating Systems:

Windows 2000/XP/Vista, UNIX

RDBMS:

Mainframe, DB2, MS SQL Server, Oracle, MS-Access, TOAD

Testing Suites:

Mercury Quality Center, QTP, TeamTrack, Remedy

Web Tools:

MS Visio, Rational Rose, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, CVS, DOORS, iRise, CaliberRM

Project Management:

MS Project, Team Track, MS Excel, MS office Suite, MS SharePoint, CMMI

Programming Languages:

HTML, XML, Java, J2EE, SQL, JavaScript, Visual Basic, SAS

Other Tools:

ERP SAP R/3 Systems

Blueworkslive, eRoom, OBIEE, Content Management, Test Manager, UML, Data stage, ETL, Micro Strategy etc.

Working Knowledge of SAP BI/BW

Confidential

Business Analyst

Responsibilities

  • Worked as a business analyst to build enterprise reporting system to support risk analysis, securities and their valuation, asset management- risks and returns, bond pricing, analyzing financial statements, cash flow etc, financing structures, capital management, portfolio analysis, stock valuation
  • Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, and stakeholders to baseline the scope of the work and enable development of the plan.
  • Implemented the full project lifecycle phases including requirements gatherings, development and quality assurance.
  • Identified, researched, investigated, analyzed, defined and documented business processes requirements and Use Case scenarios.
  • Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
  • Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
  • Prepared Business Requirement Document BRD and Functional Requirement Documents FRD , defined Use Cases created Use Case diagrams, activity diagrams, Scenarios, OOD using UML and Used Case Narratives.
  • Assisted testing team and engaged in writing test plans, test cases, conducted functional testing, UAT User Acceptance Testing , developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
  • Worked with BI/BW team to create tables, reports, graphs
  • Worked on Metadata repository to generate reports.
  • Analysed BI/BW reports and provided recommendations to the management
  • Extensively worked on Access, Excel, Word, PowerPoint, SQL, MS Project.

Environment: Agile Scrum, Windows XP, Rational RequisitePro, Rational ClearQuest, Rational ClearCase, Rational Rose, MS Visio, SharePoint 2007, PlanView, MS Visio and MS Excel.

Keywords: Portfolio Performance Attribution System Risk Management, Sensitivity Analysis, Equity, Fixed Income, Mutual Funds, Alternative Investments, Asset Allocation, Security Valuation, Investment Mix, Market Timing, Capital Markets.

Confidential

Business Analyst

Responsibilities:

  • Updated scope document during the pre-initiation stage for project approval by the management.
  • Conducted the review meetings for scope document sign-offs with SMEs, stakeholders and SOX team and involved in project planning, project monitoring and control.
  • Developed UML diagrams, Activity diagrams Business process maps using Visio, UI screen shots and conducted JAD sessions with business team and IT team.
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives
  • Gathered business requirements from SME and translated business needs in to technical specifications through requirements analysis and wrote detailed requirements for counterparty management, counterparty credit review reports and managed requirements using Rational Requisite Pro tool
  • Maintained comprehensive understanding of business functions and interrelationships among operational data stores and data warehouse systems as well as relational table structures.
  • Created data mapping document for ETL transactions for creation of data mart for reporting needs and ad-hoc queries.
  • Worked with design team and performed analysis and design of implementing a Star Schema Data Mart using logical/ physical data models using Erwin data modeler.
  • Reviewed and analyzed data on review reports and made some recommendations to the business team to improve the effectiveness and efficiency of report and created release notes for the release management team to deploy the code.
  • Produced reports using SQL queries for the Business Area
  • Served as the liaison between project manager and other team members also between business team and IT team.
  • Closely worked with testing team for Functional testing and business team for User Acceptance Testing UAT
  • Involved in user group discussions, provided training materials and training to users.
  • Responsible to gather, analyze and coordinate all the weekly updates from business team, design, development and testing team and present it to PMO and Director.
  • Responsible for documenting meeting minutes and distributed to PM and team members and created risk log document.
  • Managed project resources to successful completion and involved in review sessions with SMEs, stakeholders, system architects, developers and testers to resolve open and pending issues and updated business continuity plan.
  • Managed and controlled change using Clear Quest, associated requirements to specific change requests/enhancements/defects within the change requests guidelines as per CCB Change Control Board .
  • Generated BI reports from SAP and analyzed it
  • Worked as a point of contact POC to users, design, development, testing team and PM.

Environment: Microsoft Office Suite, MS Visio2007, MS Project2007, Share Point server2007, Windows XP, ClearQuest7.0, QualityCenter9.0 etc.

Confidential

Business Analyst

Responsibilities:

  • Involved in requirement gathering, analysis of the requirements from the business owners and users.
  • Interacted with users for verifying user requirements, managing change control process, updating existing documentation
  • Prepared Business Requirement Document BRD and used Rational RequisitePro to manage, analyze, and convert business requirements into functional specifications
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives.
  • Documented and maintained Requirements Traceability Matrix RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan
  • Assisted in design review meetings making sure all the requirements are covered in the development project scope.
  • Developed work flow diagrams, activity diagrams, sequence diagrams and Use cases by covering all the business needs using MS Visio.
  • Initiated and improved upon existing business processes and re-engineered processes where necessary.
  • Performed continuous monitoring and updates to ensure that implemented processes met changing business needs.
  • Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing efforts on their applications
  • Worked closely with the UI team to model the screens, which met user, defined requirements and also company standards
  • Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in requirement gathering and finalization of the User Requirement Documentation.
  • Prepared Test Plan Test Cases from the Business Requirements, detected defects tracked and reported bugs using Quality Centre.
  • Worked as a point of contact POC to users, design, development, testing team and PM.
  • Involved in User Acceptance Testing and contributed on developing training materials and training to end users.

Environment: UNIX, TOAD, Rational ReqPro, MS Office, Quality Centre, SQL Navigator

Confidential

Business Systems Analyst

Responsibilities:

  • Served as a liaison between business team/ SME and the Project team by assisting them in identifying, understanding and documenting their business needs.
  • Documented and maintained business rules related to various business units and facilitated the Business User and Project Managers' discussion in defining the high level Functional Requirements Document FRD .
  • Assisted the project manager in setting realistic project expectations and in evaluating the impact of changes Impact Analysis on the organization and plan accordingly.
  • Reviewed business requirements as well as technical specifications.
  • Maintain documentation related to difficulties, complexities and anomalies that may occur during the project life cycle.
  • Assisted in documenting the end-user's AS-IS and TO-BE business processes Gap Analysis to ensure that the system initiatives are met.
  • Analyzed user statement of requirements to develop new reports and provided technical recommendations for concise reporting format.
  • Wrote SQL queries to perform data profiling, data validation, report validation, data integrity, and test effort.
  • Held regular meetings with the system architects, developers, database administrators, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
  • Developed Test Scenarios, Test Cases and implemented User Acceptance Test Plan, Performed User Acceptance Testing UAT with users by providing test data and recommended and coordinated development efforts and enhancements.
  • Developed data flow diagrams using UML modeling techniques.
  • Translated the business needs into system requirements, communicating with the business on a non-technical level and with the IT team on a more technical level.
  • Managed Change Control Requests CCR and updated the scope with the new changes.
  • Collaborated with development team, data architects and the business team to develop both high-level and detailed application architecture to meet the business needs.
  • Responsible for Customizations, Enhancements, Updates and changing functionalities of the system.

Environment: Rational Enterprise Suite2002 Rose, Requisite Pro, Clear Case, Clear Quest , CVS, VB, ASP, Crystal Reports 8.0, Oracle9i, Oracle Financials, DB2, Documentum.

We'd love your feedback!