We provide IT Staff Augmentation Services!

Systems Analyst Resume Profile

PROFESSIONAL PROFILE

  • 7 Years Professional Experience as Sr. Business Analyst with Project Management Skills.
  • Strong Subject Matter Expert in Fixed Income securities and their Trading Life cycle, Including Corporate Bonds, Treasuries, MBS, ABS and Credit Derivatives
  • Solid experience in Finance Industry, Investment banking, Retail banking, Commercial banking, Trading and Wealth Management.
  • Strong subject matter expertise in financial statements, cash flow, financing structures, Capital Management, Asset Data, Fixed Income, Portfolio Analysis, Stock Valuation, Capital Structures and Budgeting, Value Based management.
  • Extensive experience in Investment Advisory, Wealth Management Services and Product Management.
  • Deep knowledge and experience of Performance Measurement and Reporting in Wealth Management and Portfolio Management. In depth knowledge of Billing procedures and the Accounting processes.
  • Experience with SSAS, SSRS, SSIS, OLAP, OLTP, T SQL.
  • Highly skilled in developing stored procedures, functions and SSIS.
  • Overall database design with logical modeling and physical modeling, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
  • Experienced in Workflow Analysis, Gap Analysis for implementing trading system.
  • Comprehensive knowledge of and solid experience in SDLC Methodologies, Agile, RUP, Waterfall, and RAD
  • Solid Experience in Creating and maintaining Timelines and Project Plan
  • Solid Experience in collection, analyses, and documentation of User Requirements, as well as organizing Interviews, User meetings, and JAD sessions
  • Extensive experience in documentation of business requirements and system functional specifications, including BRD and FSD
  • Strong knowledge in UML2.0, proficient in creating Use Cases, Use Case Diagrams, Sequence Diagrams, Collaboration diagram, Activity Diagrams and other Modeling
  • Experienced in Data Analysis, Data Mapping, Data Consolidation and Data Reconciliation
  • Extensive experience in Conducting Market Research, Feasibility Studies, Compliance and Risk Analysis
  • Extensive experience in the management of User Request Change and User Conflicts
  • Ability to organize, document and track changes and defects by using HP Quality Center, Rational Requisite Pro, Clear Quest, Clear Case
  • Expertise in developing Test Plan, Test Conditions, and Test Cases conducting and documenting UAT.
  • Excellent Communication and Presentation skills Experience working with business users, developers as well as Senior management Experienced in making Presentation to Senior Management.
  • Knowledge in the ETL Extract, Transform and Load of data into a data ware house/date mart.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, Data Warehousing concepts and web design and development.

COMPUTER SKILLS

  • Operating Systems: Win 95/98/NT/2000/XP, Unix/Linux, Solaris, HP-UX, AIX, Mainframe
  • Languages: PL/SQL, Java, C/C , and FORTRAN, J2EE, .NET
  • Databases: Oracle 8i/9i, and MS SQL server 7/2000
  • Tools: Microsoft Office - Word Excel, MS project, Visio, MS Access, UML, Rational Rose, RequisitePro, Rational SODA, Adobe Acrobat, Crystal Report, HP Quality Center

PROFESSIONAL EXPERIENCES

Confidential

Role : Sr. Business Systems Analyst

Essential Responsibilities

  • Met with Business Users, Project Manager and SMEs, discussed the project scope and main end-to-end pipelines.
  • Assisted the project lead to estimate timeline and country set up schedule.
  • Created periodic status reports and met with project manager on a regular basis to report project status.
  • Conducted extensive interviews with all stakeholders to gather business requirements.
  • Conducted interviews with SME to identify new end-to-end work flows in the system.
  • Worked with Technical Lead in preparing all Functional Design Documents.
  • Was responsible for creating System Overview Document, including all major System Use Cases.
  • Worked with SME's on reconciliation of Data between two interfaces.
  • Was responsible for creating Activity and Sequence Diagrams for all major business processes flows in the system.
  • Was responsible for creating System Data Mapping Documents.
  • Participated in briefing sessions with the development team and updated business on the progress.
  • Conducted JAD sessions with management, SME, users and other stakeholders for open and pending issues.
  • Created and reviewed test cases/scripts using HP Quality Center.
  • Involved in System Integration testing, Function testing, Regression Testing, Smoke Testing, UAT testing, OAT testing and PAT testing.
  • Raised QC's for resolving the defects found during testing.
  • Identified areas of risks, assessment, monitoring, having security and audit controls in place.
  • Trained end users on the enhancements or new features added to the application like KYC i.e. Know Your Customer PP Peer Profiling.

Environment

Windows, Oracle, MS Office Suite - Word, Excel Powerpoint, Java, Solaris, MS Visio, Control-M, Crystal Reports, Toad, HP Quality Center.

Confidential

Role : Senior Business Analyst

Essential Responsibilities

  • Established a business analysis methodology around Agile.
  • Defined project scope and objectives through internal project management methodologies.
  • Facilitating the daily scrum meetings, sprint planning, sprint review, and sprint retrospective.
  • Established effective communication for the department with consistency across development and business management.
  • Provided presentations, recommendations and updates regularly to the senior management.
  • Provided visibility to team impediments/risks and helped eliminate them.
  • Encouraged the team for self organization to boost the efficiency and coordination
  • Worked with stake holders / product owners to prioritize the requirements for sprint.
  • Worked collaboratively across multiple business units utilizing strong product knowledge regarding equities, fixed income, treasuries and derivative instruments.
  • Actively worked with various project stakeholders to build a process inventory for Money Market products like U.S. Treasury Bills and Repos.
  • Helped the product owners to come up with set of stories for better understanding for estimate and development.
  • Motivated the team to come up with quality shippable product and meet the product goals.
  • Tracked and reported status and other metrics against goals on an ongoing basis.
  • Managed offshore teams in different geographical places.
  • Ensured task completion to specification, on time and within budget.
  • Represented the team to report overall project status and upcoming risks and suggest solutions about it.
  • Managed and coordinated one or more large requirements research efforts performed specified data analysis and studied as requested, and developed and presented reports in support of various initiatives.
  • Coordinated and supported the development and implementation of special research initiatives related to specific research goals.
  • Provided consultative and technical support, as appropriate, to standing decision-making committees.
  • Performed miscellaneous job-related duties as assigned.

Environment

Windows, Agile Scrum, Oracle, MS Office Suite - Word, Excel Powerpoint, Java, MS Visio, Autosys, Crystal Reports, Toad, Quick Test Pro, Rational Rose

Confidential

Role : Business Analyst

Essential Responsibilities

  • Worked Closely with Portfolio management, fixed income trading, MBS, MSR, non-performing loan pool trading teams.
  • Worked as a liaison between Users and Tech team.
  • Identified business process models for International Business in Asset Management, fixed income, and mutual funds
  • Deep understanding of business flow of International Financial Services
  • Assisted PM with development of project plan, following Structured System Development Process
  • Extensively worked in Conducting Gap analysis, System analysis, data analysis
  • Organized and Scheduled user interviews, user meetings, group meetings, and JAD sessions
  • Performed data analysis by using SQL queries
  • Collected, analyzed and documented User Requirements
  • Used UML based methodologies to develop Business Requirement Document, Functional Specification Documents, Features Specification Documents, and System Design Documents
  • Designed and developed Use Cases, Class Diagrams, Activity Diagrams, and Sequence Diagrams
  • Extensively involved in Data Integration of different databases into a datawarehouse.
  • Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
  • Participated in the Logical and Physical Design sessions.
  • Worked with developers to make sure that they understood the Use Cases.
  • Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
  • Worked with Quality Control Teams to develop Test Plan and Test Cases.
  • Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment

Windows, MS Office Suite - Word, Excel Powerpoint, MS SQL Server, Informatica, WinRunner, Management Studio, Java, MS Visio, QualityCenter, SQL, RUP, Erwin

Confidential

Essential Responsibilities

  • Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
  • Involved in construction of data flow diagrams and documented the process.
  • Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
  • Reconcile internal external financial reports to ensure proper account balance are maintained and accurate data which are reflected on client accounts.
  • Worked with SMEs to understand various assets and security classes, exchange traded derivatives such as futures, options on futures, equity options and index options , OTC derivatives such as interest rate swaps, credit default swaps and total return swaps and portfolio allocation and management.
  • Worked with FAs and RAs to conduct Credit Risk Measurements like calculation of RWA Risk Weighted Asset .
  • Act as a single point of contact between Liquidity, Controllers and Treasury for Equities and Fixed Income products.
  • Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
  • Designed and developed all Use Cases and UML models using Rational and Visio
  • Participated in UAT and worked with Mercury QC for bug and defect tracking.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors.
  • Designed and developed Project document templates based on SDLC methodology.

Environment

Windows, MS Office Suite - Word, Excel Powerpoint, Oracle8i, TOAD, Informatica, Photoshop, MS Visio, Rational Rose, Bloomberg, Mercury QC.

Confidential

Role : Business Systems Analyst

Essential Responsibilities

  • Interpreted, evaluated, translated, analyzed and interrelated researched data, and developed integrated business analysis.
  • Lead meetings, collected and understood process based requirements gathering, and arranged end-user meetings based on objective facts.
  • Summarized all of the research gathered and defined the scope of the
  • solution, including what is not in the scope.
  • Worked with the project manager and development team to create real cost estimates.
  • Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
  • Established a business Analysis methodology around the RUP Rational Unified Process .
  • Used MS Access and Excel to cleanse and assemble accounting data and develop reports.
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
  • Created surrogate key tables to map the required dimensions.
  • Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Conducted User Acceptance Testing.

Environment

Windows, Unix, MS Office Suite - Word, Excel Powerpoint, Oracle, TOAD, Informatica, MS Visio, Rational Rose, Quick Test Pro, RUP.

Hire Now