We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

2.00/5 (Submit Your Rating)

Dallas, TX

SUMMARY:

  • A Senior Business Analyst with over 8 years of experience in Business Analysis, Business requirements gathering, Database Design and development of Web Based, and Client/Server applications.
  • Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
  • Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
  • Good Knowledge of various financial products like Stocks, Bonds, Mortgage Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
  • Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.
  • Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity - Relationship Diagrams ( ERD ).
  • Experienced in writing Test Plan and Test Cases and aggressively involved in Regression Testing and Performance Testing using automation tools like Win Runner, LoadRunner, Test Director, Quick Test Pro, Silk Test and Oracle table manipulation using SQL
  • Knowledge in the Informatica/ ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.
  • Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
  • Extensive experience with Sox compliance and guidelines
  • Performed GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Experienced in various industries, including title / escrow, insurance, financial services
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
  • Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
  • Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS:

  • Rational Rose
  • Rational Enterprise Suite
  • MS Visio
  • MS Project
  • Rational Requisite Pro
  • Crystal Reports
  • Lotus Notes
  • Test Director
  • WinRunner
  • LoadRunner
  • Quick Test Pro
  • MS Office
  • Quark Express
  • Load Runner
  • MS PowerPoint
  • Erwin
  • HTML
  • Java
  • Java Script
  • interwoven
  • E-Commerce
  • BIZ Talk
  • IIS
  • DHTML
  • VB Script
  • Visual InterDev
  • ASP
  • XML
  • Cobol
  • Web Application Server (3.0B)
  • Internet Transaction Server
  • Business Explorer
  • RS-Logix (Allen Bradley)
  • RS-Works (Allen Bradley)
  • Intellution (ABB Systems).

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Business Analyst

Responsibilities:

  • Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
  • Implemented and integrated RUP solutions with complete line of traceability for all the artifacts of web development projects.
  • Expertise in defining and documenting Business process flows and "As-Is" & "To-Be" processes.
  • Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifacts.
  • Involved in customer segmentation, Portfolio Analysis/Management, FDR , TSYS processes and FICO score generation.
  • Design & Implementation of a data access layer to communicate with various services via Web services Access Gateway based on XML SOAP protocol
  • 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
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams
  • Developed Use cases and functional specifications. And provided UML diagrams.
  • Gathered requirements from JAD/JAR sections with developers and business clinets.
  • Involved in development and maintenance of workflow plans and artifacts.
  • Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
  • Managed Scope and change throughout the SDLC process of the product.
  • Developed Use Case Models using Rational Rose to depict Actor and Use-Cases in various Business processes and identification of Basic/Alternative flows and definition of preconditions and post conditions of the System.
  •  Performed GAP analysis between source and target data elements and executed reports for different module such as: Escrow, Fair Market Value, Real Estate Owned, Repurchases, Interest Income, Amortization, Home Equity line of Credit and Remittances. 
  • Worked with ETL team during the upload process.
  • Designed and developed Quality Assurance standards and processes to all levels of project team.
  • Performed GAP Analysis for the modules in production, conduct feasibility study and performed impact analysis for proposed enhancements.
  • Verified the functional aspect as per the Business Process and validated interface with other systems and data conversion from the legacy system.
  • Performed basic sanity testing via navigation and workflow of the application.
  • Created PAD’s in conjunction with System’s architect to baseline system performance. Identify expected bottlenecks and set load and stress targets.
  • Maintained and kept track of stakeholder’s request for enhancements and changes using Unified Change Management Tool ( UCM ) such as Rational ClearQuest.

Environment: Visio, Winrunner, Test Director, J2EE, Excel, MS Project, MS Office, Lotus Notes Scripts, ODBC, LSX Team Studio, Sametime VB Script, PL/SQL DHTML, Windows NT/2000/XP, SQL Server/Oracle, ROMP, MS Access IE

Confidential, Newport Beach, CA

Business Analyst

Responsibilities:

  • In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Working with clients 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.
  • Modified System flow diagrams using SDLC.
  • Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
  • 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).
  • Worked with ETL team during the upload process.
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Using Shared Containers and creating reusable components for local and shared use in the ETL process.
  • Helped with data modeling and defining the conceptual and logical model of the data warehouse.
  • Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
  • Created job schedules to automate the ETL process.
  • Analyzed data and created class diagrams and ER diagrams for designing databases.
  • Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
  • Comprehensive experience in writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
  • Tracked change requests and monitored workload and schedule.
  • Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
  • Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
  • Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
  • Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
  • Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
  • Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
  • Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
  • Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
  • Helped in creating end user manuals and procedure manuals.

Environment: Java, J2EE technology, Escrow, Windows 2003 Advanced Server, UNIX / Oracle Platform, MS office, MS Visio, RUP, Rational Rose 2002, interwoven, Rational Clear Quest, Rational ClearCase, Rational requisite pro, ROMP, rational test manager, Rational Robot

Confidential, Salt Lake City, UT

Business System Analyst

Responsibilities:

  • Gathered high level requirements and developed scope of the project for the implementation of Microsoft Office Share Point
  • Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
  • Gathered requirements for the integration of POS system with the supply chain system
  • Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
  • Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
  • Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
  • Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
  • Responsible for creating Business Requirement Specifications, to capture functionalities at all E-Commerce touch points.
  • Responsible for data mapping and for governing the data quality (Data Governance)
  • Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High-Level Requirements.
  • Provided technical and procedural support for User Acceptance Testing (UAT) and Coordinated with the QA Team in the sign-off process before deployment.
  • Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
  • Enforced rules of Scrum during development phase, which involved facilitating meetings, updating Burn-down charts, backlog refinement and removing impediments affecting project goals
  • Assisted with the BRD for the POS implementation project
  • Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
  • Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Planned and documented procedures for data processing and prepared data flow diagrams for the application.
  • Create technical design documentation for the data models, data flow control process, metadata management.
  • Wrote detailed specifications for various reports generated using Cognos
  • Analyzed the data collected and process maps to determine the root causes and identify opportunities.
  • Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
  • Created business requirement documents and integrated the requirements and underlying platform functionality.
  • Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
  • Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
  • Developed Data Conversion Strategy for converting data from the existing site to the new site.

Environment: Windows XP/2000, Oracle, PL/SQL, SharePoint, Unix, Doors, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Access,

Confidential, NY, NY

Business System Analyst

Responsibilities:

  • Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
  • Wrote Business Requirements, analyzed them and tested them.
  • Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
  • Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data. Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
  • Reverse-engineer several databases, such as research, business, and clinical in order to extract metadata to leverage it for ETL design and reporting.
  • Designed the universes by creating the Business Objects data model. Developed reports including line and pie charts, trend analysis and sub-reports using SQL Server Reporting Services (SSRS). 
  • Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
  • Developed UNIX scripts, JCLs and PROCs to run the Software applications for testing purpose.
  • Prepared test Data sets and performed data testing using the PL/SQL scripts. Also, used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Worked with SQL queries using MS Access for data manipulations.

Environment: TOAD, Crystal Reports XI/XI R2, Oracle, DB2, SQL Server 2000, OBIEE, Rational Suite, XML, VBA, Mainframes, COBOL, Oracle, UML, MS Project, MS Office, MS Vision

Confidential, Chicago IL

Business Analyst

Responsibilities:

  • Gathered business requirements by developing Specification Documents, Use Case scenarios for translating requirements into an application design.
  • Developed documentation for POS Systems including Corporate Policies.
  • Primarily responsible for End to end integration of Merchandising systems (ORMS) with the Warehouse Management systems (ORDM and PKMS), Direct to Customer systems (CWD), Allocation Systems (SIMS), Point of Sale (POS)
  • Worked with the BRD for the POS implementation project
  • Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs that insures any critical requirements are not missed.
  • Conducted Joint Application Development (JAD) sessions with IT groups & stakeholders to identify key changes in existing system.
  • Organized meetings to discuss outstanding issues with QA and developers.
  • Prepared graphical depictions of Use Cases, UML diagrams, created mockup design (UI screen)/ prototype using Microsoft Visio for new system.
  • Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions
  • Used Rational Unified Process (RUP) guidelines to strategize the efforts in overall software development process while assisting developers in system development.
  • Provided day-to-day project management supervision to clearly communicate the project path, timelines for project delivery, and managed resources to successful completion.
  • Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on business requirements, technical specifications and/or product knowledge.
  • Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
  • Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members

Environment: MS Visio, MS Word, MS Excel, MS Power Point, MS Project, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro

We'd love your feedback!