We provide IT Staff Augmentation Services!

Business System Analyst Resume

0/5 (Submit Your Rating)

Cleveland, OH

SUMMARY

  • Over 8+ Years of experience as a Business Analyst/Business System Analyst/Data Analyst in various domains including Banking Finance, Mortgage, e - Commerce, Pharmaceuticals, Life Insurance, Asset Management, and Pension Management.
  • 6+ years of experience working with Business Intelligence (BI) and Data warehousing tools like OBIEE, SSIS, and Informatica.
  • Expert communicator (written, verbal and presentation) involved in high level interaction and influence with variety of audiences (Senior Executives, Clients PMs, developers, SME) as well as PMO.
  • Experience analyzing and documenting project scope documents and SOWs, project plan, project/requirement change request forms, BRD, FRD, SDD, requirement traceability matrix, use cases/sequence diagrams, UML, wireframes/mockups, end user documentation and BPM notations.
  • Worked extensively with teams for development of Business Rule Engines to support SOA architecture and web services.
  • In depth knowledge of the Software Development Life Cycle (SDLC) using Agile and other methodologies such as Rational Unified Process (RUP) and Waterfall.
  • Experienced working with Business Intelligence (BI) and Data warehousing tools like Cognos, Hyperion Essbase and Informatica.
  • Experience in design, configuration, development and deployment of Business Intelligence applications using OBIEE.
  • Proficient in IBM Security Identity and Access Management (IAM).
  • In-depth knowledge of Project Management Book of Knowledge (PMBOK).
  • Proficient in creating and managing Requirement Traceability Matrix (RTM) for tracking and managing changes based on project’s evolving needs.
  • Facilitated Joint Application Design (JAD) and Rapid Application Development (RAD) teams with all IT group members for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy.
  • Working knowledge in writing SQL queryforidentifying databases involved in the application development.
  • Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
  • Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations.
  • Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income and Title functionalities.
  • Understanding of investment banking, asset management and other fund management functions.
  • Understanding of different mortgage instruments like Mortgage Backed Securities (MBS), Collateralized Mortgage Obligations (CMO), Asset Backed Securities (ABS), including the tranche structuring and credit enhancement processes to manage prepayment and credit risk. Knowledge and understanding of the functions of mortgage agencies like Ginnie Mae, Fannie Mae and Freddie Mac.
  • Extensive experience in developing and enhancing applications for financial processes including Hedge Funds Pricing, Trade and Settlements operations.
  • Worked with star and snow flat schemas to create fact and dimension tables.
  • Created tabular, matrix, pie, bars and column reports to meet client requirements.
  • Performed ETL and analyze different sources of incoming data and performed various transformations.
  • Performed GAP and cost-benefit analysis as required.
  • Worked extensively with application programmers to develop proposed solution prototypes.
  • Wrote use cases and Developed Test Plans and created Test Cases.
  • Obtained expertise in performing System, Acceptance, Regression, Integration and Functionality Testing.
  • Exceptional understanding of the QA life cycle, from test plan, test scripts, issue resolution to User Acceptance (UAT), System Integration (SIT) and end-to-end testing.
  • Performed financial analysis such as cost analysis, NPV, IRR, and ROI as well as risk analysis.
  • Worked on Reports based on the requirements and Test driven development (TDD).
  • Experience using DMAC and RASCI methodologies, root cause analysis etc.
  • Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.

TECHNICAL SKILLS

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Caliber RM, Enterprise Architect

Quality Management: DevTrack, Bugzilla, Jira, Quick Test Professional

Defect Tracking Tools: Rational Clear Quest, Quality center

Languages: C#, Java, HTML, .NET, XML

Operating Systems: Windows NT/XP/2000/7

Web dev tools: Dreamweaver, FrontPage

Databases: Oracle 11g, Oracle (8i/9i/10g), SQL Server, MS Access

Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office

BI/ETL Tools: Informatica, SSIS, OBIEE 11g

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Business System Analyst

Responsibilities:

  • Work closely with project stakeholders, business SME's for gathering requirements and specifications for the applications and preparing business requirements document.
  • Conduct requirement gathering, walkthrough sessions with business requestor, testing and Development team.
  • Review Business Requirement Documents (BRD) and prepare Use-Case Specifications and Functional specification documents (FSD).
  • Chair Requirement Gathering Sessions, Joint Application Development (JAD) sessions and lead the effort to get Business and System requirements baseline (stakeholder approval).
  • Utilize agile software development methodology SCRUM as a lightweight process we used to manage and control software and product development.
  • Take a major part of the Change Control process and followed up all the Change Request (CR) with impact analysis on Scope, Schedule and Budget constraints and worked with the Change Control Committee.
  • Create Use Cases to document alternate business scenarios and designed UML diagrams.
  • Gather and Document PCI regulations and requirements for credit card payments.
  • Propose requirements for the future state system by applying payment domain knowledge and information collected by interacting with legacy system users.
  • Develop the Business Requirement Document based on the research & analysis of PCI Standards.
  • Develop prototypes and screen mock-ups using MS Visio to facilitate interactive discussions with stakeholders and developers.
  • Document business rules, understood the business need, added new Customer experience features (Update Content for Enrollment, Add Payees) and provided Screen Layout Specifications for the SRS document.
  • Optimize the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
  • Review Logical and physical database design using Erwin Tool.
  • Using Business Intelligence development studio (BIDS) create Dynamic ETL SSIS Packages to validate, extract, transform, and load data from different sources like web services and also involved in checking data quality, data cleansing and data transfer.
  • Worked on huge data transfers from & to SQL Server Databases using SSIS and used configuration files for production deployment.
  • Determine the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.
  • Execute two week iteration and worked with the cross-functional mobile application team to ensure that all the requirements were compliant with overall project goal and scope for mobile and web based products.
  • Conduct Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment.
  • Clarify QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested the same.
  • Initiate and Exercise various strategies involved in website Usability, Functionality, and Compatibility testing.
  • Conduct User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues. Also familiar with testing tools to design and develop test plan and test scripts.

Environment: UML, Agile (SCRUM), Use Case Analysis, MS Word, MS Power Point, MS Excel, MS SQL server, MS Outlook, T-SQL, SSIS 2012, MS Visio, MS Project, Quality Center

Confidential - Kenilworth, NJ

Business Analyst/Data Analyst

Responsibilities:

  • Involved in gathering requirements and documenting the gathered requirements/Involved in meetings with the Team members to discuss the requirements.
  • Gather requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for user stories creation and obtain timely sign-off by all respective parties.
  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Lead Sprint Planning & Estimation sessions, Sprint Retrospectives and Reviews.
  • Develop detailed level process maps to facilitate requirements gathering for projects and s.
  • Developed Logical and Physical Data Model using Erwin, followed Star Schema to build the Data warehouse.
  • Tested different detail, summary reports and on demand reports.
  • Communicated discrepancies determined in testing to impacted areas and monitored resolution.
  • Wrote the test scripts for manual testing.
  • Extensively Used SQL and PL/SQL Scripts and worked in the both UNIX and Windows Environment.
  • Assisted in the process of preparation of the document Informatica Transformation Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.
  • Used Debugger to troubleshoot the mappings.
  • Implemented Slowly Changing Dimensions Type 1, Type 2.
  • Troubleshoot post production defects. Analyze the existing flow and prepare BRD documents for the defects and Change requests.
  • Involved in Code fixes and migration of code from Dev to SIT and Production.
  • Used SQL query to analyze the Pfizer source systems and existing data warehouse data. Prepared data mapping documents to build the new data mart and Tableau reporting.
  • Prepared Visualization Reports for quarterly and yearly reports for Supply chain higher management.
  • Supported SIT and UAT testing and documenting user acceptance criteria.
  • Monitoring SIT cycles and involved in Production support.
  • Handled change requests from the client.

Environment: Workflow Manager, Workflow Monitor, Repository Manager, Metadata Exchange, HP-UNIX, FTP, Oracle 11g, Erwin, SQL, PL/SQL, Unix Shell Scripting, Tableau, Quality Center

Confidential - Wayne, NJ

Business Analyst/Data Analyst

Responsibilities:

  • Worked with IT leads, business stakeholders and development teams to define detailed UI requirements for customer profile; My Account, Baby Registry, Shopping Cart, Checkout and OMS for Toys "R" Us and Babies "R" Us online storefront.
  • Documented detailed level requirements in the form of User Stories for various functionalities like Promotions, Product Detail Page, Shopping Cart and Checkout.
  • Worked on UI and data requirements with vendors and development team to successfully implement tax calculation, single use coupons, gift cards and payments (Credit Card and PayPal) with third party vendors like DMA, BAMS (Bank Of America Merchant Services), and PayPal to ensure that customer data flowing through the process is PCI compliant.
  • Led requirements clarification session with business stakeholders for shipping calculations and shipping charge in order to provide a direction to IT team to move ahead with development of key components of checkout process.
  • Worked on requirements to implement "R" Us brand credit card provided by third party vendor Synchrony Financial. Synchrony implementation provided Toys "R" Us shoppers with the ability to apply for a credit card and buy with the same card during checkout.
  • Worked closely with various business stakeholders to come up with wireframes and get functional requirements for Buy Online Pick up in Store (BOPUS), Buy Online Ship to Store (BOSTS), Auto Refill, Product Comparison and Product Bundling for desktop and mobile platforms.
  • Conducted process workshops to analyze AS IS process and define To-Be process to meet new business requirements.
  • Documented use cases, workflow diagrams, screen mock-ups and functional requirements specification documents for various functionalities like Site Search, Product Detail Page, Shopping Cart and Checkout Process for desktop and mobile platforms.
  • Worked as a single point of contact to integrate with Aisle 411, a third party vendor providing real time inventory availability and store maps that provide exact aisle location for products in Toys "R" Us and Babies "R" Us stores.
  • Assisted development and testing teams by providing clarifications on front end and back end requirements throughout the project.
  • Facilitated meetings to resolve conflicting business and development requirements with different third party vendors providing various functionalities to Toys "R" Us.
  • Worked with offshore developers to walkthrough wireframes and FRS on various functionalities like Site Search, Product Detail Page, Shopping Cart and Checkout process for desktop and mobile platforms.
  • Responsible for tracking bugs and replying to any clarifications needed by development, QA and business teams to get those bugs fixed via JIRA.
  • Worked with external front end vendor Sequence to get new visual design and HTML pages for the new Confidential redesigned website.
  • Identified risks for incoming bugs and work with business owners and project managers to mitigate risks in time before Go Live of big enhancements like Guest Checkout.

Environment: JIRA, MS Office, MS Visio

Confidential, Greenwood Village, CO

Business Analyst/Data Analyst

Responsibilities:

  • Designed application components in an AGILE environment utilizing a test driven development (TDD) approach.
  • Created and maintained project tasks and schedules.
  • Performed data profiling in the source systems that are required for New Customer Engagement (NCE) Data mart.
  • Manipulated, cleansed & processed data using Excel, Access and SQL.
  • Responsible for loading, extracting and validation of client data.
  • Analyzed raw data and developed recommendations.
  • Wrote SQL scripts to manipulate data for data loads and extracts.
  • Involved in defining the source to target data mappings, business rules, business, and data definitions. Responsible for defining the key identifiers for each mapping/interface.
  • Responsible for defining the functional requirement documents (FRD) for each source to target interface.
  • Coordinated with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
  • Documented data quality and traceability documents for each source interface.
  • Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
  • Involved in Data warehouse and Data mart design. Experience with various ETL, data warehousing tools and concepts.
  • Worked with internal architects, data warehouse developers by assisting in the development of current and target state data architectures.
  • Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
  • Also worked on some impact of low quality and/or missing data on the performance of data warehouse client. Identified design flaws in the data warehouse.
  • Developed OBIEE metadata repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer.
  • Worked on customizing Repository and configure metadata objects (Subject Area Table Column) and Web Catalog Objects such as Dashboards, Pages, Folders, and Reports.
  • Worked with BI/ETL developers to perform Data Modeling (Physical & Logical), Data Analysis and wrote High level and Low level Design Specifications for ETL and Business Intelligence (BI).
  • Created iBots to send preprocessed reports using OBIEE Delivers.
  • Generated tables, listings, and graphs using Excel also used Excel to generate end of day reports for input into OBIEE.
  • Utilized OBIEE Administration Tool components in both Application and Business modeling.
  • Responsible for developing/converting over 200 discoverer reports using OBIEE 11g.
  • Validated reports using OBIEE and Oracle data warehouse in comparison to current reports.

Environment: Oracle10 & 11g, MS-Office, Enterprise Architect, Informatica, ER Studio, XML, Informatica, OBIEE11

Confidential - NYC NY

Business Analyst/Data Analyst

Responsibilities:

  • Performed business specification (BRD) and data requirements, use case models, GUI, use cases, functional specifications and data flow diagrams, ER diagrams, unit testing and beta testing to create a library of financial modeling tools for our applications for the analysis and modeling of derivatives for valuation, pricing and simulation, interest rate risk assessment, cash flow forecasting, intraday quotations from data feeds, contract specifications, trade capture, trading, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications for various trading platforms including Bond trading.
  • Provided detailed FpMLAPIspecifications of various products on trade submissions for higher volume clients.
  • Responsible for Fixed Income and OTC Options part of the project. Involved in the Monte Carlo simulations using market data and to value the trades. Simulated yield curves with different spreads under various scenarios and used these curves to simulate the P/L path.
  • Analyzed the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows for the proposed system.
  • Business flows documented contained information flowing from upstream applications to the downstream applications and any impact made using GUI by the users.
  • Collaborated with Change Management Group and IT to prepare a detailed derivatives infrastructure for trading for implementing the derivatives trading application - a diagrammatic flow of investment process, trading, data transaction between application, pricing and analytics, database, data feeds and back office integration (trade confirmations, processing, settlement, collateral management, market data), portfolio valuation including bond rating and accounting
  • Made detailed research analysis & prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, and Exotic Options.
  • Coordinated with various data feeds (Reuters, Bloomberg, Markit) for market data, data, counterparty data, and credit data; mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics.
  • Involved in the trade submission to ICE, CME from MarkitSERV for clearing through MarkitWire APIs avoiding clients to build to multiple bespoke CCP interfaces.
  • Performed detailed analysis and work - flow diagrams for derivatives trading which included - preparation of market & data, analysis & decision support, modeling a contract, preliminary instrument setup on the application
  • Created tables, views, joins and store procedures to meet client requirements.
  • Analyzed systems and data to identify functionality gaps for front end module, Trade Worksheet and Back office Module for various CDS and asset management platforms which includes fixed income, annuity, mutual funds and bonds.
  • Involved in manual trade data reconciliations, analyzing the chart of accounts, tracking the GL transactions and validating them from their mainframe systems.
  • Worked closely with the business users to build the models and delivered based on the sign-off.

Environment: Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer

Confidential - Foot Hill Ranch, CA

Business Analyst

Responsibilities:

  • Worked as a business analyst to build Strategy Web application for financial statements and inspections.
  • Identify, research, investigate, analyze, define and document business processes.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
  • Conducted user interviews, gathered requirements, analyzed the requirements using Rational Rose requisite pro - RUP.
  • Documented functional specifications to automate the loan approval process for home Mortgage (online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review).
  • Acquired in-depth knowledge of the banking industry (Mortgage, Assets, and Accounts Receivables/Accounts Payables).
  • Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
  • Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
  • Involved in testing all the data elements in Mortgage Account Inquiry Service, which is called to obtain Mortgage loan data from MSP.
  • Worked on mapping of MSP Web services to Enterprise Interface Partners and coordinated with FIS on MSP.
  • Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
  • Developed timelines for project delivery and managed projects and resources to successful completion.
  • Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
  • Assisted in development of materials for new technology and process improvements.
  • Participated in developing of Materials for the new technology and User .
  • Worked effectively with Project Manager in handling the whole project.

Environment: SDLC, RUP Methodology, Rational Clear Quest, UML, Oracle, MS Project and MS Office.

Confidential

Jr. Business Analyst/Intern

Responsibilities:

  • Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
  • Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
  • Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
  • Developed business process models in RUP to document existing and future business processes.
  • Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
  • Involved in testing the Pharmacy Claims adjudication and Billing processing is done through PBM (Health Trans) and Claims Accumulation and Adjudication is done through Diamond.
  • Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Technical, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
  • Performed extensive Requirement Analysis including data analysis and gap analysis.
  • Assisted the integration team by creating Lombardi Teamworks services for data access.
  • Identified internal and external business requirements, design and configuration set-up, also created User Documentation and attended classes.
  • Developed business requirement specification documents as well as high-level project plan.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and OOD using UML.
  • Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations.
  • Documented and delivered Functional Specification Document to the project team. Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
  • Conducted User Acceptance Testing (UAT).

Environment: Microsoft Office Suite, Microsoft Visio, MS Excel, MS Access, Documentum, UML, J2EE, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, PL/SQL, UNIX, VBScript, VBA, C#. NET, ASP.NET.

We'd love your feedback!