We provide IT Staff Augmentation Services!

Business System Analyst Resume

3.00 Rating

Mount Laurel, NJ


  • Over 6+ years of experience as a Business System Analyst with the ability to understand and analyze complex business requirements. Have a detailed and thorough understanding of various domains like Mortgage, Banking (BFSI), Finance, Insuranceand HealthCare.
  • Experience on both Agile and Waterfall Software development methodology.
  • Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks
  • Experienced in requirements gathering, authoring functional and interface specifications documentation, testing, workflow configuration and trade blotter.
  • Strong Knowledge of Software Development Life Cycle (SDLC) and project life cycle.
  • Wide ranging experience working on IT projects within InvestmentBanks, Financial services, Insurance, data migration, integrations, separations, upgrades & outsourcing.
  • Finance (Investment/Asset/Cash management) experience in trade settlement (foreign & domestic equities, fixed income, term loans, repos and corporate actions), wire transfers, foreign exchange settlement, derivatives, and income relating to dividends & interest.
  • Strong subject matter expertise in fixed income asset markets, bond pricing, equities, derivatives, and emerging markets product knowledge across life cycle, trading cycles, money markets, mortgage - backed securities, risk management (interest rate, credit & liquidity risk), portfolio management & corporate action and also good experience in standard treasury instruments (Bills, Notes and Bonds) and have a clear understanding on Debts, Derivatives, Investments and Collateral concepts.
  • Accounting experience, reconciliation, GL, amortization, cash flow, control reporting, match funding, financial statement analysis and budgeting.
  • Proficient in creating use cases, sequence diagrams, collaboration diagrams, activity diagrams & class diagrams.
  • Proven experience working with Technical Teams and Project teams on Microsoft SharePoint (MOSS)2010 Platform
  • Knowledge of industry practices and regulatory expectations as they relate to commissioning, qualification, and validation programs.
  • Knowledge of industry practices and regulatory expectations(DOD-Frank) as they relate to commissioning, qualification, and validation programs.
  • Excellent team player to work in conjunction with testers, developers and other team members in validating and testing complex scenarios in projects and in the maintenance of quality standards in projects.
  • Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
  • Create business requirement documents (BRD), System requirement specification(SRS), use cases, functional requirement documents (FRD), test cases, test reports and other documents requires in software development life cycle (SDLC) and software testing life cycle (STLC).
  • Strong knowledge of business intelligence, data warehousing and business architecture.
  • Proficient in corporate data confidentiality, release management, requirements gathering and preparing business as well as technical requirements.
  • Extensive experience in domains like Mortgage Originations, Capital Markets, Pricing, Investor Delivery, Automated Underwriting Solutions, Third Party Mortgage Oversight Reporting, Mortgage-Backed Securities, Freight - Logistics and Insurance.


  • Microsoft Office Suite
  • Excel - Pivot Tables
  • Vlookup & Macros
  • Project
  • PowerPoint
  • Word
  • Visio
  • FrontPage and Outlook)
  • Microsoft SharePoint 2010
  • Lotus Notes 6.5
  • Adobe Acrobat
  • Bloomberg
  • Cognos
  • QuickBooks
  • Empower
  • SPSS regression analysis
  • Oracle
  • Teradata
  • Informatica
  • HP Quality Center.
  • Java/JEE
  • C
  • C++
  • PL/SQL
  • HTML
  • XML & VB.
  • PL/SQL
  • Microsoft SQL server
  • MS Access
  • SQL.Win XP; Win Vista
  • 2000
  • Windows 7
  • UNIX
  • Software Development Life Cycle.
  • Waterfall
  • RUP
  • Agile (Scrum).
  • HPQC (HP Quality center)
  • Ab into
  • Informatica
  • Cognos and SAP BW
  • SAS
  • Oracle SCM


Confidential, Mount Laurel, NJ

Business System Analyst


  • Responsible for owning complete requirements related activities on Dodd Frank Reform Program and related deliverables.
  • Reviewed models and studied in detail the functionality of multiple regulatory reporting models of various departments.
  • Developed a complete business test strategy for the implementation of the program.
  • Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Extensively worked on the ETL mappings, analysis and documentation of reports requirements
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
  • Interacted with database developers for formulating the ER diagrams and data flow diagrams.
  • Undertook back end testing using SQL and wrote queries.
  • Held regular JAD meetings with the system architects, developers, database developers, and 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.
  • Facilitated smooth transition of the project from the project environment to the live environment.
  • Interacted closely with developers and stakeholders to make sure that all the milestones of the different phases of project are accomplished and the project dead line is met.

Environment: RUP, UML, Oracle, SQL-PL/SQL, Java, Unix Red-Hat, MS-Office, MS Project, MS Visio. ETL Extract, Axiom.

Confidential, Auburn Hills, MI

Senior Business System Analyst


  • Acted as a liaison among the working partners of the project to agree and document global posting business standards (GPS).
  • Created multiple Global Posting Rules detailed business requirements documentation as business standards information became available.
  • Interviewed Subject Matter Expert’s to record requirements that could be reviewed and understood by management and all other stakeholders.
  • Responsible for the mapping of the data from global and domestic platform by using various functions in Excel.
  • Carried out regular meetings and walk-throughs with development team members, Project Managers and Quality analysts to better understand the system functionality in order to improve quality.
  • Created and managed projecttemplates, usecaseprojecttemplates, requirementtypes and traceabilityrelationships on SharePoint2010.
  • Facilitated changes to the SharePoint governance policies, procedures and processes.
  • Maintained burn down charts, sprint backlog and product backlog sheets; used all SCRUM rituals such as stand-up meeting, sprint planning, sprint review and sprint retrospect.
  • Implemented and monitored AML (anti-money laundering) data and information and also created data integrity to enforce data consistency by working with data governance team and data stewards.
  • Assisted in the maintenance of corporate data dictionary.
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
  • Facilitated withJAD sessions with the management groups, vendors, users and the IT Group for open and pending issues to develop specifications.
  • Developed Requirements Traceability Matrix (RTM) to trace each software requirement to test case.

Environment: MS SharePoint2010, MS Excel, MS Access, MS Visio, MS SharePoint, UML, Oracle, ALM, Windows 7

Confidential, Richmond, VA

Senior Business System Analyst


  • Lead a small team for the Legacy system replacement covering end-to-end Mortgage LOS (Loan Origination System) solution framework for all channels ofOrigination involving various business groups.
  • Responsible for Business requirements gathering and helping the IT with functional specs.
  • Coordinated with systems partners to finalize designs and confirm requirements with Agile methodology.
  • Reviewed the Business requirement specification (BRS) documents and prepared the system requirement specification (SRS).
  • Comprehensively worked on ETL mapping, analysis and created RFD for technical design.
  • Extensively use trillium for data cleansing activities by using different SQL queries.
  • Developed SQL scripts and stored procedures to test ETL and data quality as well as correct any data issue (duplicates, transforms, clean data etc.)
  • Managed and maintained the coding and configuration requirements on ALM (Application Lifecycle Management).
  • Prepared Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements for EMPOWER LOS a web based application.
  • MaintainSharePoint2010 intranet portal for the department. Create custom lists,shared folders, picture libraries,documentlibraries, and dynamicInfoPathforms.
  • UseSharePointDesigner2010 to make upgrades and enhancements to the intranet portal.ImplementSharePointworkflows to run simple automated tasks. Create InfoPath 2010 forms.
  • Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS
  • Generated Information Maps using Information Map Studio and created Ad-Hoc reports on need basis using SAS Web Report Studio
  • Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
  • Preparation of Requirements Document, AGILE Story cards.
  • Using Agile Methodology, the entire project was broken into sub tasks which were performed in parallel.
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Worked with QA team for designing Test Plan and Test Cases for User Acceptance Testing (UAT) and verified reliability, performance, and fault tolerance issues
  • Acted as an internal advocate by taking a ownership of implementation project, worked with the testers and fulfill the commitment to meet the deadlines.
  • Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, sponsor, and stakeholders to baseline the scope of the work and enable development of the plan.
  • Coordinated with Project Management to make sure all the constraints and goals are achieved right from the initiation phase to closing, also performed risk evaluation, reviewed design and program development, made reports, and make sure that product meet work plan.

Environment: EMPOWER, STMP, MEDB,XML, Workflow Manager, ALM,Informatica, Data warehouse, MS SharePoint2010, Rational Rose, Visio, Windows,Oracle, Toad and Microsoft Excel

Confidential, Chevy Chase, MD

Senior Business Analyst


  • Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
  • Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
  • Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
  • Designed and implemented basic SQL queries for QA testing and report / data validation, Streamlining Data Warehouse and ETL models.
  • UAT testing performed along with call center managers to make sure that application meets their requirements.
  • Conducted routing Internal inspections of regulated systems (GMP, GCP, GLP) to assure validation procedures have been followed in compliance with company, divisional and departmental policies and predicated rules.
  • Responsible for testing the Quote & Online Purchase for both Auto and Home Property Insurance and Business Owners of the customers.
  • Reviewed with the QA team to ensure adequate testing is done on the application.
  • Authored OQ and PQ test scripts to challenge all regulatory and security requirements.
  • Performed workflow analysis toward automated disability claims process. Detailed comparison of two competing proposals, including HR interfaces.
  • Analysis of business requirements and system requirements of the client and also for Property and casualty modules.
  • Created the Web Publishing configuration using Documented Administrator for publishing content to the website by using Web Cache.
  • Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).

Environment: MS Office, Visio, Oracle, RUP, UML, Win Runner, SQL

Confidential, Milwaukee, WI

Business Analyst


  • Documented High Level Logical Data Models and BRD supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
  • Created Use-Case diagram, Sequence Diagram and Activity Diagram after accessing the scope of the Project and understanding the business processes.
  • Create tasks and update tasks in the MS Project and Project Management Directory for the senior management reviews.
  • Involved in project management, developing project plans, setting project schedules and milestones, scheduling tasks and activities using MS Project.
  • Involved working in Medicare and Medicaid projects.
  • Tested different functionality of the application like Medicaid eligibility data, state available funds program, Medicaid claim processing etc.
  • Responsible for testing Medicaid Claims using MMIS.
  • Conduct high level requirement walkthrough with Tech Managers to come up with Preliminary Estimates
  • Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
  • Coordinated the process for users, which analyzed their current business practices, user, needs, and then used that information to define functional requirements and Request for Proposal (RFP) for a new system.

Environment: MS Office, MS Visio

We'd love your feedback!