We provide IT Staff Augmentation Services!

Business System Analyst Resume



  • Around 6 years of experience in Analysis, Design, Development, Testing, Maintenance and troubleshooting on Master Data Management (MDM), Business Analyst, data quality, data integration and Oracle database environment in various Verticals such as Retail, Banking, Healthcare.
  • Involved in various stages of Software Development Life Cycles (SDLC) including requirements analysis, design, development, testing and implementation with Agile and Waterfall methodologies.
  • Excellent writing skills in writing Business requirements documents (BRDs), USE Case Specifications, Functional Specifications (FRDs), Non - Functional Requirements, Systems Requirements Specifications (SRS).
  • Experienced in creating prototypes and mock-ups for user interface designs with Axure and MS Visio.
  • Worked on projects using agile methodologies implementing BABOK standards and BPMN techniques.
  • Experienced in facilitating Joint Requirement Planning (JRP), Joint Application Development (JAD) with Business User Groups, Subject Matter Experts, and IT to limit the change process and develop the design.
  • Experienced in creating Test Cases, Test Plan, and Test Data. Performed Integration Testing, System testing, User Acceptance Testing (UAT) working with team members.
  • Skilled in performing SWOT Analysis, Gap Analysis, Cost Benefit Analysis and to identify problem and make Business Decisions for improved Customer Value.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
  • Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
  • Good Data Warehousing concepts including Extract, Transform, Load (ETL), Meta data, Data Marts, Fact/ Dimension Tables, and Dimensional Modeling.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, and Metadata Management Services, and Configuration Management.
  • Researched and presented reporting and metadata crawl solutions to the Senior IT leadership.
  • Huge experience testing Dashboards, Prompted Reports, Ad-hoc reports and Documented Reports.
  • Expertise in Installing, Configuring core Informatica MDM Hub components such as Informatica MDM Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter (Address Doctor), IDD & Resource kit.
  • Experience in several facets of MDM implementationsincluding Data Profiling, metadata acquisition, data migration, validation.
  • Experience in defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, and packages.
  • Helping business to understand the Match rules configuration and decide the trust factor and Configure match/merge rules.
  • Successfully, setup the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
  • Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies.
  • Configured Informatica Data Director (IDD) for Data Governance to be used by the Business users, IT Managers and Data Stewards.
  • Experience with PM tools MS Project, Rally, Jira, TFS.
  • Implementing IDD applications to maintain/manage data, access relationship hierarchies and configured task management to route tasks to the Data stewards.
  • Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables) OLTP and OLAP.
  • Experience in Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Experience in data profiling for analyzing the Data Anomalies.
  • Experience in creating PDO, CDO and LDO to import data (flat file, relational database file etc.) in IDQ.
  • Experience in using various Transformation like Filter, Expression, Joiner, Sorter, Aggregator for designing and developing complex mappings.
  • Experience Knowledge on developing and debugging Mapplets and Mappings.
  • Working Knowledge in creating Scorecards and helping the business in deciding the threshold %.
  • Hands on Creating Reference Table using Informatica Analyst tool as well as Informatica Developer tool.
  • Working experience in front-end web technologies AngularJS, JavaScript, JQuery, Bootstrap, Html5, CSS3.
  • Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers, Views, Indexes, Joins, Sub-Queries to implement business rules and validations.
  • Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.


MDM Tools: Informatica MDM Multi-domain9.x, 10.x, IDD, SIF

Business Tools: MS Visio, MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Project

Reporting Tools: Cognos, SRS, SAP Business Objects.

Cleanse Adapters: Address Doctor 5.9,5.6.

Databases: Oracle 10g/11g, DB2 My SQL 5.0/4.1, MS-Access, Teradata

Database Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader SQL Navigator Erwin

ETL / Data Quality Tools: Informatica 9.x/10.x, Informatica Data Quality 9.x/10.x

Reporting Tools: BI Tableau, Power BI

Programming Skills: AngularJS, JavaScript, jQuery, HTML5, CSS3, SQL, PL/SQL, Java

Application Servers: JBoss 6.4/6.2, Web Logic 10.3


Confidential, LA

Business System Analyst


  • Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts.
  • Liaison between the cross-functional teams, top management clients, users and any stakeholder involved in the project.
  • Prepared the Business Requirement Document (BRD) for Lines of Businesses (LOB) Accounting, BSA/AML, Central Operations, Commercial Banking, Portfolio Lending, Private Banking, Risk, Warehouse Lending.
  • Prepared templates for technical design document and runbook.
  • Communicated technical terms and concepts for preparing technical design document.
  • Prepared technical design document with the help of Application Development team for a project by interviewing, using existing documents.
  • Demonstrated experience writing technical documentation for existing and new applications.
  • Conducted analysis and interviewed Subject Matter Experts as necessary to compile and write technical and accurate content.
  • Conduct data verification on projection data warehouse.
  • Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
  • Extensive experience in SQL testing for Validation of ETL Processes in Enterprise Data Warehouse (EDW).
  • Performed Requirement Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the current and future scope potential use cases for the MDM.
  • Documented source to target data mappings,businessrules,and businessand data definitions.
  • Performedbusinessrequest analysis, creatingbusinessrequest response, source system analysis, Trust/Match strategy design,MDMperformance/load count monitoring, User Acceptance Testing.
  • Used Hierarchy tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles.
  • Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
  • Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
  • Performed Data Analysis on unclean data and presented the scenarios and helped data stewards to find appropriate solution.
  • Conduct and lead meetings / sessions with clients to gather the requirements and creation of Business Requirement document to elicit the requirements.
  • Conduct walkthroughs with the Business, Development and QA teams on the Requirement Document for final sign offs.
  • Serve as a liaison between the Business, Development and QA teams to bring everyone on same page for successful production deployments.
  • Managed and lead teams to manage resources and bring successful completion of specific project goals and objectives
  • Coordinated meetings to gather requirements from end-users and kept track with evolution of requirements using JIRA and MS office tools.
  • Used SharePoint for as a part of our enterprise content management for the market marker web application to effectively communicate with our vendors and to publish content.
  • Performed extensive Functional and User Acceptance Testing and documented them along with additional trouble shooting documents and potential issue causing arenas and user feedback enhancements also documented.
  • Created Source to Target data mapping document for new data mart creation
  • Documented System specification identifying which included identifying data fields, transformations, calculations, and logic
  • Assist with integrations of IAM systems with in-house and third party applications for provisioning, identity authentication and developing connectors between IAM tools and system resources.
  • Lead and execute daily, weekly and monthly support activities to maintain overall IAM environments
  • Experience Microsoft Office 365 (SharePoint, Project, PowerPoint, Visio).
  • Created reports using Business objects and Virtual reporting tool Spotfire.
  • Developed and maintained RTM (Requirement Traceability Matrix) and conducted requirements and design walkthroughs with designers, developers and management staff.

Environment: Informatica Multidomain 10.2, Informatica Power Center 10.2, Informatica Data Quality 10.2, JBoss 6.4, SQL Server, Microsoft Office 365.

Confidential, Dallas, TX

Business System Analyst


  • Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts.
  • Prepared the Business Requirement Document (BRD) and Functional Requirement Document (FRD) for the enhancement of the existing services.
  • Acted as a primary contact in all the phases of Software Development Life Cycle SDLC, including Quality Assurance Testing, Performance & User Acceptance testing.
  • Conducted daily SCRUM meetings during the Sprint Development as a part of Agile Methodology. Also captured and addressed concerns from IT to Product Management or Business Team as needed.
  • Ability to read, understand and convert technical specifications.
  • Interact or interview SMEs, developers and end-users to obtain technical specifications and content for publications or documents.
  • Performed the GAP analysis to find the Root Cause of the issues.
  • Successfully used Agile/Scrum Method for gathering requirements and facilitated user stores workshop.
  • Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
  • Developed schemas for extraction, transaction, and loading (ETL) to expedite data integration between systems.
  • Worked with QA testing teams, while interacting with business users and gathering user’s requirements to develop necessary Test plans, Test Cases and Test script.
  • Liaison between the Lines of Business and Combine knowledge of what the business wants with knowledge of how the systems are built, how the data is managed, and used to create a functional design across applications.
  • Participated in workshops (new technologies, enhancement) with Service Now partner teams to help company implement Service Now using best practices in ITSM.
  • Gathered requirement from stakeholders for attributes needed to develop Service Catalog items. Identifies and Recommends the ITIL v3 methodologies to delivered technical methodologies around the Service Now platform.
  • Working closely with the business users to understand the current state and target state business processes.
  • Coordinated with System Analyst and Project Manager to set-up the pre-validation and validation
  • Collaborated with respective Application Team in fine tuning the data gathering requirements, field identification, data profiling and validation. Documented all the above and presented in weekly milestone meetings.
  • Written SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Worked on rebuilding and integration of the Business Objects reports into Tableau
  • Interpreted Use Case diagram, Sequence diagram and Class diagram.
  • Ensure project documents are complete, current, and stored appropriately.
  • Coordinated with technical lead and project manager to finalize the data model.
  • Participated in the logical and physical design sessions and developed design documents.
  • Worked closely with other groups to resolve the issues preventing alignment on milestones, resources and deliverable
  • Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
  • Used SharePoint for as a part of our enterprise content management for the market marker web application to effectively communicate with our vendors and to publish content
  • Extensively used Microsoft office 365.
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
  • Assisted in Conducting UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application and take sign off from Business to move production.
  • Involved in preparing User manual for the application and training for the same
  • Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
  • Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
  • Reported status, milestones, and project plan tracking to project management and project owners on a weekly basis.
  • Scheduled daily SCRUM meetings in an agile environment, retrospective meetings for issues, incorporated suggestions & decisions in code development.

Environment: Informatica Multidomain 10.1.0, Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, SQL Server, Dot Net, MS Office 365.

Confidential, Bellevue, WA

Business System Analyst


  • Working with Data Stewards and users to better understand their needs and present solutions using structured SDLC approach.
  • Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
  • Prepared various documents such as Business Requirement Documents (BRD), Functional Specification Documentation (FSD) and Impact documents.
  • Modeled Use Case Diagrams, Activity Diagrams and Data Flow Diagrams using MS Visio.
  • Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Officesoftware to perform required job functions.
  • Used MDM tool to support Master Data Management by removing duplicates, standardizing data, and incorporating rules to eliminate incorrect data.
  • Liaison between the various stakeholders in various business units and Technology build team.
  • Interact/work with Product owners (the Business), Product Development Managers (PDM), Business Owners, Quality Assurance (QA), Architects and Developers at various stages of Software Development Life Cycle (SDLC).
  • Analyzed Gap Analysis and Gathered the requirements through Interviews, discussions, questionnaires, and JAD sessions.
  • Worked with business users to define Product Feature Requests, Business Requirement Specifications and Change Requests.
  • Translating Business Requirements into detailed Functional Requirements and Designs that the technical developers use to develop products.
  • Developing Functional Specification Documents, Use Cases, Impact Matrix, Process Diagrams, Traceability Matrices and other project level documentation as require.
  • Facilitate Walk-through sessions with Business, Developers and QA engineers for functional and non-functional requirements and get sign off.
  • Ensure project documents are complete, current, and stored appropriately
  • Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Run SQL Queries to understand Data Flow for effective Data Mapping and for creating Data Flow Diagrams for better understand the impact of the application.
  • Played a key role in the planning, testing, and implementation of system enhancements and conversions.
  • Facilitate implementation of new functionality through training sessions, demonstrations and the development of appropriate documentation.
  • Work with Application Production team to resolve production issues.
  • Involve in Risk Analysis & Risk Management for creating and implementing documentation for technical team by supporting and also Designs systems and programs to meet complex business needs.
  • Proactively started initiative to begin Root Cause Analysis (RCA) on known issues, which had impacts on further upstream\downstream processes which reduced the number of issues\defects.
  • Worked with the testing team to finalize on the use case scenarios to be used for performing front-end and backend testing.
  • Designed structured functional testing, including review of test scenarios, test cases and execution/support of User Acceptance Testing (UAT).
  • Scheduled daily SCRUM meetings in an agile environment, retrospective meetings for issues, incorporated suggestions & decisions in code development.
  • Reported status, milestones, and project plan tracking to project management and project owners on a weekly basis.

Environment: Informatica MDM 9.7 (HUB/Cleanse), Informatica Data Director (IDD/User Interface), Oracle 10g Database), PL SQL Developer, JBOSS, Microsoft Office Suite, Microsoft Visio, SQL, JIRA.

Confidential, Boston, MA

Informatica MDM Business Analyst


  • Participated, Co-ordinated and executed Business Use Case requirement gathering for the Business Units.
  • Implemented Master Data Management solution for the Different source systems.
  • Conducted internal and external analysis of the existing business environment to identify the gaps that impede the business to reach the desired results.
  • Identified elements from source systems to formulate Data rules and Decisions.
  • Conducted and lead JAD Sessions twice a week with businesses. developers and Subject matter expertise to present the data rules established.
  • Experience in Microsoft office 365.
  • Interacted with the Business Team to understand the requirements and prepared technical documents for implementing the solutions as per Business needs.
  • Performed Data Analysis on unclean data and presented the scenarios and helped data stewards to find appropriate solution.
  • Worked closely with Data stewards to help resolve User Acceptance Testing Defects for Internal and Product Related Issues.
  • Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
  • Interviewed Subject matter expertise and Application Managers to identify additional business rules. For Defining the Base objects, Staging tables, foreign key relationships, lookups, queries, packages and query groups.
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
  • Built and executed High level and detailed general test Plan, Test summary report, and ongoing Defect summary report to ensure UAT coverage of ongoing Reference Data Management Lifecycle Acceptance Testing.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Worked with ETL team to identify the best way to test incoming data load and data profiling methods.
  • Created Requirement Traceability Matrix to keep track of development and testing.
  • Developed mappings using various cleanse and address doctor functions.

Environment: Informatica MDM 10/9.7, Oracle 11g, SQL Developer, MS SQL-Server, JBoss 6.2, MS Visio, Eclipse, Application Lifecycle Manager


Informatica Developer


  • Involved in analyzing Oracle based databases sources to figure out data quality issues.
  • Responsible for working with ETL Lead, MDM lead, Data Modeler and other stake holders to understand business requirements.
  • Using Informatica Developer Tool, created source PDOs from the Oracle tables, created Sources to Targets mappings for Data cleansing, validating, integrating and matching.
  • Responsible for developing Mappings, Mapplets and Rules using different types of transformations like Filter, Router, Case Converter, Lookup transformations, created PDOs and LDOs.
  • Migrated various rules as well as Mapplets developed at IDQ Developer tool to the Power Center.
  • Moreover, using Informatica Power Center, designed and developed two workflow variable driven solutions to process Flat file sources.
  • Provide high-level design walkthrough on how the solution will be built for each requirement.
  • Involved in Daily Scrum team meeting.
  • Implemented PC DQ mappings to test the standardized and cleansed new data.
  • Assist in code testing, migration, deployment, enhancement and bug fixes.
  • Performed Data Quality Checks, Cleansed the incoming data feeds as and profiled the source systems data as per business rules using IDQ.
  • Reviewed and demonstrated the abnormalities back to the business and made proper adjustments.

Environment: Informatica Power Center 9.1, Informatica Data Quality 9.x, Oracle 11g, SQL Developer, Linux


Business Analyst/ Scrum Master


  • Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
  • Involved in Business process reengineering (BPR) by conducting Process modelling, SWOT analysis, Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system.
  • Coordinated with the Stakeholders and project key personnel to gather multiple documents for the required enhancements to the system such as Functional Requirements Documents (FRD), Business Requirements Documents (BRD), User Guides, Test Cases, UAT Plans, and Requirement Traceability Matrices(RTM).
  • Conduct frequent meetings with subject matter experts (SME), stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams. Actively participated / arranged with number of iterations in order to gather and documentbusiness needs and translate them to deliver the following artifacts as needed.
  • Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Flow Chart Diagrams, Wireframe prototypes and document them using Microsoft Visio.
  • Involved in creating Test Cases, Test Plan, and Test Data. Performed User Acceptance Testing (UAT) working with team members.
  • Ability to organize and analyze large sets of data - experienced with software like Advanced Microsoft Excel (VLOOKUP and Pivot Tables) MS Access & SQL.
  • Write SQL queries for data retrieval and manipulation,Wrote SQLqueries using complex joins, grouping, aggregation, nested subqueries, etc.
  • Conducted UAT (User Acceptance Testing) to ensure that reports were developed in accordance with user's request and business process.
  • Worked closely with the developers and testers and conducted sprint planning meetings to review user stories to derive client requirements into technical implementations.
  • Worked closely with business power users to create reports/dashboards using tableau desktop, and presented to client.

Environment: JavaScript, Angular, HTML5, CSS3, Confluence, Jira, MS Visio, SQL Server, Java, Agile -Scrum, UML, MS Excel, PowerPoint, Tableau.

Hire Now