We provide IT Staff Augmentation Services!

Sr. Business Analyst/data Analyst Resume

0/5 (Submit Your Rating)

Baltimore, MD

SUMMARY

  • Seven years of experience in business analysis, business requirements modeling and development of Web Based, and Client/Server applications in diverse business domains of Finance, Banking and Service Industry Sectors.
  • Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications (FRS) and use Modeling tools like Rational Rose and Microsoft Visio for requirements modeling.
  • Expertise in Business Process Modeling, Business Process Re - design and in designing Process Architecture.
  • Sound understanding of Gap Analysis, requirement management, risk analysis and project plans.
  • Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
  • Participation in the Credit Risk Analysis like Estimation of PD, LGD and EAD.
  • Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
  • Experience in Risk Management process and technology reengineering, Sarbanes Oxley implementation, valuation review process and technology, strategic sourcing, metrics and benchmarking
  • Excellent in designing business models using UML diagrams such as use case diagrams, class diagrams, activity diagrams, sequence diagrams and collaboration diagrams using Rational Rose and MS Visio.
  • Expertise in using the testing tools such as Mercury Quality Center (QC)/Test Director and Quick Test Pro (QTP).
  • Highly efficient in using the change management tools of Version Control System like Document Center/Documentum and IBM Rational Clear Case.
  • Strong noledge and experience in writing and executing SQL queries for database testing.
  • Experience in developing QA test cases, test scenario and leading towards UAT and Beta Testing for ensuring the application’s successfulness.
  • Experience in conducting Joint Application Development (JAD) sessions and White Board Sessions with end-users, Subject Matter Expert (SMEs) team, Architects and design group development and QA team for project meetings, walkthroughs and customer interviews commensurate with excellent communication skills.
  • Creative and aggressive self-starter with integrative thinking skills, capable of communicating creative ideas through graphical analysis charts and statistical data display.

TECHNICAL SKILLS

  • Business Analysis
  • Business Architecture
  • Data Mapping
  • Data Modeling
  • Requirements Gathering
  • Functional Specification Design
  • Testing (Test Cases) (Manual Testing & Automated Testing tools)
  • Quality Assurance (QA)
  • Documenting Process Flow
  • Process Re-Engineering
  • Process Mapping
  • Business Contingency/ Business Continuity Planning (BCP)
  • GAP Analysis
  • SDLC
  • Rational Team Test
  • OOAD (OOA/OOD)
  • RUP
  • UML
  • Rational Rose
  • Clear Case
  • Clear Quest
  • WinRunner
  • Load Runner and Test Director
  • C
  • C++
  • Java
  • HTML
  • J2EE
  • VB 6.0
  • SQL
  • Windows 9x/NT/2000/XP
  • Unix
  • Linux
  • Solaris
  • Oracle
  • SQL Server and MS Access
  • TSL
  • SQL Basic
  • Shell Scripts
  • MS Visio
  • MS office
  • Silverlight
  • Adobe PageMaker
  • Adobe PhotoShop
  • MS Project 2002
  • Adobe workflow systems
  • Weblogic Server iRise
  • Mercury Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. Business Analyst/Data Analyst

Responsibilities:

  • Helped in defining Change Management Process for Release Management Team.
  • Mapped process flow; assess as-is a process through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
  • Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
  • Prepared Business Object / Business Process Models dat included modeling of all the activities of business from conceptual to procedural level.
  • Strong understanding of securities back office operations.
  • Worked on Investment/portfolio management in multicurrency securities, equities, Fixed Income, portfol0io accounting and related back office processing, lifecycle of a trade, Lifecycle of an account, Security setup, Account setup, Reconciliation.
  • Experience with set of online tools for TEMPeffective cash management by the back office.
  • Conducting requirement sessions and successfully translating of those requirements into Use Cases and GUI wireframes.
  • Documenting business and system needs via the creation of a variety of documents including Scope documents, Use Case Storyboards, GUI wireframes and Software Requirement Specifications.
  • Extensive experience in configuring data mapping between different Databases.
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
  • Gatheird user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).
  • Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
  • Responsible for gathering and analyzing business requirements, writing specifications of back/middle office interfaces, preparing use cases using Unified Modelling Language and Rational Rose.
  • Designed and developed Use Cases using UML and Business Process Modelling.
  • Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
  • Delivered presentations on Project Status and Current Open Issues Report to Users, Stakeholders and other involved groups.
  • Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users
  • Defined roles and responsibilities of participants in the business process.
  • Developed and maintain information and documentation related to developing and modifying business processes and systems.
  • Recommend system/process solution approaches to minimize risk and workflow impacts while capitalize strategic goals.
  • Assisted process owners in process training and implementation.
  • Streamlined the Restatement Financial Data Warehouse access review Process.
  • Gatheird requirements from users of the Clear Quest (CQ) tool for any Enhancements or change requests for any defects.
  • Involved in Six Sigma process analysis.
  • 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.
  • Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
  • Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
  • Designed and developed project document templates based on SDLC methodology
  • Established RUP (Rational Unified Process) methodology and provided assistance in developing Use cases and project plans.
  • Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.

Environment: Mainframes, COBOL, JCL, XML, Db2, Oracle, Rose, Basel II, MS Word, MS Excel, MS Visio, MS Project, MS SharePoint, LoadRunner, WinRunner

Confidential, Minneapolis, MI

Business Analyst/Data Analyst

Responsibilities:

  • Worked with the business community to define business requirements and analyze the possible technical solutions.
  • Worked extensively with SME in understanding and documenting their requirements pertaining to monitoring changes and portraying a trend to maintain and analyze customer needs and many other business areas.
  • Co-authored documents for Brokerage Trade Data using the Charles River Trading Tool.
  • Co-authored documents for capturing pricing data using Bloomberg and Reuters terminals.
  • Worked as Project Manager for time being, led a group of 15 plus people, modified timeline for program planning period in order to include Project Initiation Phase.
  • Facilitated JAD Sessions and handled change management.
  • Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market.
  • Mainly involved in Fixed income securities trading
  • Scheduled and conducted meetings with client work group (SME’s) to identify requirements, and documented them in SRS document and identified priorities
  • Created detailed requirements for Fixed income process workflow
  • Assured dat all artifacts are in compliance with corporate SDLC policies and guidelines
  • Analyzed the various kinds of risks dat had to be accounted such as the Asset Class Risk for e.g. Credit Card Risk, Personal Loan Risk, Mortgage Loan risk, etc
  • Modeled the risks in Excel spreadsheet and performed sensitivity analysis and shared this document with the managers and the technical team to facilitate more efficient communication
  • Used MS Projects to schedule and track the activities in the project
  • Involved in performance testing, functional testing and integration testing
  • Used Rational Rose to designed and develop Use Cases scenarios, Use Cases models, Activity diagrams, Sequence diagrams and State chart diagrams created Use Case model and process flow diagrams using MS Visio
  • Performed mapping of records layouts from disparate source systems
  • Traced Requirements to High Level Design, Test Cases and Product Requirements
  • Co-authored many business requirements document with project teams for Fixed Income and Brokerage documents. Extract, discuss, and refine business requirements from business users and team members.

Environment: MS Visio 2003, MS Word 2003, J2EE, MS Access 2003, Oracle 9i, Charles River IMS, Reuters 3000 Xtra, Bloomberg Terminal

Confidential, PA

Business Analyst/ Data Analyst

Responsibilities:

  • Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
  • Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
  • Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
  • Managed software artifacts for the suite of investment products such as Online Banking and Brokerage, BIDS, Insurance etc
  • Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
  • Write Detailed Business requirements documents (BRD) and assessment of current OTC derivatives instruction trade management processes for front, middle and back office, reference data, data attributes and security master database.
  • Organized and actively participated in requirements gathering workshops involving various key business users from the Portfolio Management Unit and Back Office Unit.
  • Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
  • Created wireframes to present the features of the application to stakeholders and business owners
  • Analyzed product fit with business plans, developed business requirements and functional specifications. Mapped navigation paths and data flows, developed wireframes of screen layouts and prototype designs to meet interface requirements
  • Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
  • Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
  • Worked on data modeling and produced data mapping and data definition documentation
  • Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
  • Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
  • Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: RUP, UML, SDLC, XML, MS Office, MS Project, MS Visio, DOORS, Project Management

Confidential, KS

Business Analyst

Responsibilities:

  • Gatheird legacy system requirements by shadowing Customer Service Representatives (CSRs), Customer Relationship Representatives (CRRs), preparing questionnaires, to identify limitations in the current system and GAPS in the proposed system.
  • Created an enterprise workflow application based on CRUD rules for Customer Data dat would allow for future integration of data infrastructure across various business areas into a single UI.
  • Prepared logical data model in the form of Business Context diagram to include various entities and attributes in order to facilitate the design of Data model in the form of ER Diagrams. Studied current information structures and data models of the current databases to better understand the design of target data source.
  • Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident and administrative tracking. Performed all data field mappings.
  • Interacted with client's front and back office personnel to define business requirements and software usage
  • Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Documented business and technical requirements along with UI wireframes.
  • 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.
  • Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
  • Used Rational Clear Quest to track required changes and Rational Clear Case to maintain different versions of the project documentation
  • Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
  • Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript.
  • Modeled Business requirements into workflows to depict various scenarios of system to request RFI and RFP responses from major vendors.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
  • Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis
  • Performed detailed comparative analysis of response to RFPs of vendors and Graphically Represented the recommended solutions in PowerPoint to Senior Management
  • Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
  • Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.
  • All the test scenarios which have been satisfied with the functionality are moved to automation testing using Quick Test Professional.
  • Prepared the test data and executed SQL queries to verify and do the database testing.
  • Prepared Test Cases based on base-lined Requirements Document, prepared Requirements Traceability Matrix and provided Performance Testing Requirements. Worked very closely with the Test team to Test all iterations during the Testing Phase and documented all the defects.

Environment: Windows, Oracle, SQL, XML, MS Visio, MS Access, MS Project, MS SharePoint,UML, Requisite pro, Rational ClearQuest.

We'd love your feedback!