We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume Profile

VA

CAREER SUMMARY

  • 14 years of IT experience, with expertise in Business Analysis, Business Process re-engineering, System Analysis, Project Management and Software Testing in Mortgage, Banking, Health and Logistics domains
  • Adept in gathering requirements from stakeholders, conducting JAD sessions, System analysis and Project/Release planning.
  • Developed Use Cases, Data Flow Models, UI wireframes and created business process models using UML.
  • Proficient in documenting as-is and to-be business processes and conducted gap and impact analysis for iterative and incremental project releases.
  • Experience in implementing and integration of commercially off the shelf product COTS in mortgage domain.
  • Delivered precise functional and nonfunctional specifications that includes Business requirements document BRD, BPD , functional requirement document FRD , Interface specifications, Data mapping, Data definitions and User guides etc.
  • Well versed in various methods of software development like RUP, Agile and Waterfall SDLC process for software delivery. Aware of SOX Sarbanes Oxley controls governing business and technology and FASB Financial accounting standard board accounting guidelines.
  • Strong experience in creating test plan, test cases, test scripts, test procedures based on business requirements for System Test and UAT.
  • Experienced in working with external audit teams to support business process validation and supported project managers in creating scope, RFP, resourcing and budgeting for new initiatives.

TECHNICAL SKILLS

Business Modeling and Requirements Gathering Tools

Rational Requisite Pro, DOORS, MS Visio, Rational Rose, UML, BPMN.

Change Management and defect tracking Tools

Rational Clear case, Clear Quest, PCM tracker , MS SharePoint, MS Visual Source

Databases Language and Tools

Oracle, IDMS, MS Access, TOAD, SQL Plus, SQL

Operating Systems

Windows, MS-OX, Unix.

Software Languages

HTML, XML, Java, VB, VC , C, C , MATLAB, OOAD concepts

Tools and Packages

Microsoft Office Suite, MS Project, MS Front page, Business Objects, Humming Bird Exceed, Mercury Quality Center.

PROJECTS

Confidential

Sr. Business Analyst

SF REO Enhancement:

  • This project is enhancement of existing Singe Family REO system to address existing system deficiencies, defects and eliminate manual process surrounding the current system.
  • Worked as lead requirement analyst to elicit requirements from business/accounting team.
  • Wrote business requirement, created business process diagrams and analyzed gaps from as-is to To-be system.
  • Created data scenarios to aid stakeholders understanding of requirements, participated in UAT phase to help test team to draft and develop test case and test scripts.
  • Helped in creation of test plan and risk based test matrix to plan out progressive and regressive test cases.
  • Supported to create artifacts needed for SDLC 3.0 process.

Confidential

  • The project is first phase to implement Federal Housing Finance Agency FHFA mandate to develop system for Adversely classifying loans, REO and asset for special mention. This system identifies loans eligible for accelerate charge off prior to foreclosure.
  • Developed test cases, test data and test scripts based on business requirements.
  • Analyzed production data to provide required inputs for business requirements enhancement.
  • Created SDLC project artifacts and helped in post production support and analysis.

Confidential

  • Developed system and data mapping requirements to support EVLAS and FannieMae ETL integration.
  • Develop UAT full volume test cases, developed and executed test scripts.
  • Work with EVLAS vendor to analyze results for various test iterations and created SDLC artifacts and supported the process for system to be migrated to production.

Confidential

  • Reviewed conceptual LAI requirement for UAT process and helped in managing requirement in DOORS.
  • Identified data elements for data team to develop data glossary process.
  • Participated in requirement review process and assessed system impact analysis of integrating existing system to loan accounting platform.

Confidential

Sr. Business Analyst

  • Confidential, a member of the Confidential, is the largest global development institution focused exclusively on the private sector in developing countries. It allows companies and financial institutions in emerging markets to create jobs, generate tax revenues, improve corporate governance and environmental performance, and contribute to their local communities.
  • Confidential Corporate Business Technology group supports technology needs for Finance and Treasury portfolio. As a Sr. Business analyst worked on various projects in this area
  • Confidential: ACBS Advanced commercial banking system is a COTS product that is implemented in IFC. It is a transaction capture, processing and accounting system of record for Loans and other Debt products e.g., Guarantees . The current project involves upgrading older version to updated version ACBS to suit the current business needs
  • Worked on gathering new business requirements related to ACBS interfacing systems. Documented current state as-is system process related to affected systems.
  • Developing data requirements for straight through processing of data from source system to ACBS.
  • Assisting in developing to new Work desk web portal system that supports ACBS.

Confidential

  • Gathered new business requirements for IQMR reporting system.
  • Developed data mapping from all the source systems Data warehouse, Risk, Cost management, etc to IQMR.
  • Worked with BI architects to come up with design solution for Database and User interface.
  • Supported code development and performed system testing for the application.
  • Developed user guide, presentations and performed application demos for the business group across various country offices of IFC.

Cash Reconciliation:

  • Completely developed a cash reconciliation system in MS access using VBA to support specific account reconciliation between ACBS serving system , Cash Management and SAP accounting system.
  • Developed VBA code in MS access to support the requirements and performed system testing for the same.
  • Performed application demos for the business group across various country offices of IFC.
  • Supported production related queries and issues.

Confidential

Sr. Business Systems Analyst

  • Involved extensively in RFP Request for Proposal process to procure LLF COTS product through a competitive bid.
  • Worked with business user in gathering high level Business and System requirements for LLF system.
  • Created use cases BUC from business functionality that should be satisfied for LLF system.
  • Identify requirements related to model management, Cash flows, economic scenarios and reporting capabilities.
  • Closely worked Project manager in performing essential tasks for RFP process. It includes creating RFP score card, conducting supplier demos, gap analysis between suppliers and creating comparative cost proposal.
  • Worked with business stake holders to explore business operations benefits from the project.
  • Socialized with internal groups such as architecture, IT operations, Procurement, IT diligence in bringing COTS product in house.
  • Working on efforts to finalize a supplier and prepare for the project phase for LLF implementation.

Confidential

Sr. Business Analyst

  • Confidential secondary mortgage and it provide liquidity and home affordability in US housing market. The firm funds mortgage investments by issuing debt securities in domestic and international capital markets. Confidential Confidentialfee Gfee Consolidation project implements the new revised FIN46 R FASB rule. This rule replaces existing FIN46 FASB rule. The project involves in updating current system to generate new accounting transactions as per the updated rule. The project also involved enhancing existing ETL, preprocessing and interfaces within the system. Further a new interface with common sub ledger service Oracle FAH was implemented as per Fanniemae corporate wide initiative to post our SL accounts further making GL posting in People soft.
  • Served as liaison between technical team and business team to support requirement gathering and implementing new FAB FIN 46 R accounting policy.
  • Played a key role in application development. Developed system prototyping creating use case and developing UML diagrams.
  • Identified data sources for data mapping and wrote data transformation requirements.
  • Acted as a mid level project management person in organizing status meeting on requirement and testing phases of SDLC.
  • Maintained Use cases in Req Pro, Version Control in Clear Case, defect tracking using Clear Quest.
  • Created Test Scenarios and Test Cases for System testing in various releases of the project.
  • Ran system test autosys jobs in UNIX environment.
  • Maintained test cases and traceability in Mercury Quality Center.
  • Supported integration testing with various external systems validated test results and documented test summary in System testing.
  • Performed data extract's using SQL statements and Scripts for detailed data analysis and ad-hoc reporting. Performed Health checks on data sources consumed by system.
  • Developed specification for reports for Business Users. Used Business Objects to generate reports, analyzed those reports for Business users in integration test and production.
  • Resolved issues in UAT and production environment.

Confidential

  • Involved in system testing of Inbound ETL for the EVOLV product.
  • Developed test Scenarios and test Cases for System testing. Provided support for UAT team in validating the business scenarios.
  • Created mock data for EVOLV- SDA tables used to system test data staging for EVOLV. Developed various test scenarios and test events.
  • Used Mercury QC to maintain test cases and generated various test metrics to leverage QA work.
  • Developed SQL queries for data analysis and also to test quality of data.

Confidential

  • Developed System requirements for new enhancements to mainframe systems for Falcon Auto pay and Auto-Edit process.
  • Helped to automate strenuous manual process that existed in current mainframe system.
  • Developed test case for System/UAT test and checked test results in IDMS mainframe environment using Hummingbird Exceed tool.
  • Helped business users in developing and modifying existing business reports in mainframe system and also helped to develop new report for various business needs.
  • Supported production issues and involved in timely resolution of issues involving concerned stake holders.
  • Created documentations as Test plan, Business Validation to support new enhancements and assisted in developing document for migration and SOX-compliance.
  • Existing system developed in COBOL lacked proper system requirement documentation, over came this challenge and documented the system functionality by reverse-engineering process.
  • Explored possibilities and conducted GAP analysis to transition the system from mainframe to a newer robust technology platform. Created scope, business reasoning, RFP and organization structure for the new initiative.

Confidential

  • Lead requirements gathering, system testing and validation for GFAS system. System implemented FASB accounting policies FIN45, FAS140, FIN46 related to mortgage securities.
  • Developed Interface specifications ELSIF compliant and system control requirements.
  • Served as a liaison between business and technical team to develop detailed accounting requirements.
  • Played a key role in application development and was actively involved in project management.
  • Identified data sources for data mapping and wrote data transformation requirements.
  • Created test scenarios and test cases for system testing in various releases of the project.
  • Supported integration testing with various external systems validated test results and documented test summary in System testing.
  • Performed data extract's using SQL statements and scripts for detailed data analysis and ad-hoc reporting. Performed health checks on data consumed by system.
  • Developed specification for Business validation reports.
  • Assisted users in creating data, test scenarios, UAT validation and production support.

Confidential

Business System Analyst

  • Created requirement specification document by conducting interviews with all the stake holders. The system that was implemented was complaint to federal HIPAA rules and Alabama Patient Safety Organization PSO rule.
  • Involved in creating E-care GUI designs and developed UML modeling for IT team.
  • Prepared BRD Business Requirement document , FRD Functional requirement document UCN Use case narrative , Screen Specification details for the project
  • Worked closely with the development team to identify business process solution models. Collaborated with quality control team to explore key business scenarios and data variations.
  • Worked closely with UAT personnel to automate testing process from manual validation.
  • Received the Client and Business users' appreciation for the implementation of prescribed NPI update and E-care changes.

Confidential IT Analyst Handled conversion of data from EUC MV-Star to reporting system. Movie star MV-Star is the COTS project implemented to provide real-time data on traffic patterns Created detailed data mapping and transformation documents for inbound and outbound ETL process. Developed data and process flow diagrams, analyzed data exchange patterns and aided in design documentations. Checked data integrity by SQL scripts. Acted as a POC for identifying data discrepancies and managed correction through required DCU's. Created and managed technical reports, progress summaries and system utilization reports.

Confidential

System Analyst- Consultant

  • Analyzed data integration strategies to customize simultaneous analysis of data from new and old environments. System implemented business policies related customers regulation dictated by SEBI Security exchange board of India .
  • Created UI artifacts for development team and executed system testing.
  • Supported change management and defect tracking in clear quest.
  • Managed and coordinated issue resolution activities between the various testing organizations. Provide detailed test summary and test metrics on various production version releases.

Hire Now