We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Cleveland, OH

SUMMARY

  • With over 8+ Years Professional Experience as Business Analyst in Banking Industry.
  • Extensive experience on Mobile/E - Banking solution
  • Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
  • Proven success as a data analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Strong experience in RUP Business Modeling process.
  • Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
  • Excellent in Developing and evaluating business process Models.
  • Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
  • Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.
  • Proven success as a data analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Excellent in Developing and evaluating business process Models.
  • 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).
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools.
  • Knowledge in the 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).
  • Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
  • Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
  • Experienced in with SQL and PL/SQL with familiarity in RDBMS such as MS SQL Server and Oracle.
  • Advised management on improvement strategies, Competitive & Profitability Analysis.
  • Financial products involved: Fixed Income, Equities, Bonds, Mutual Funds, Fund of Funds, Insurance, Retirement Planning, Generation Planning and complete Financial Planning
  • Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
  • Exposure to Client/Server, Web Application developmental tools and Software development and design.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Sr. Business Analyst

Responsibilities:

  • Facilitated meetings with user community to gather requirements and define project timelines.
  • Independently built a globally consolidated database of suppliers that became a benchmark in management decisions & reviewed enterprise asset management using advanced proprietary systems
  • Responsibile for gathering requirements, writing functional specifications, creating use cases and developing prototypes for conversion projects supporting multiple lines of business including Commercial, Investment Bank, Private Bank and Retail Bank.
  • Created AS-IS and TO-BE business process flow diagrams, Integrate process flow diagrams to show one end-to-end business model and process mapping exercise including swim lanes.
  • Served as Business Analyst on data warehousing projects,businessprocess design, identifyingand implementing system improvements and liaison to variousbusinessgroups throughout the company.
  • Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC.
  • Participated in an agile style atmosphere and participated in daily Scrum/Stand-Up meetings using Agile Scrum standards.
  • Planned and defined system requirements using Wireframes and provided detailed Use Cases in Unified Modeling Language (UML) methodologies.
  • Source Business analysis, analyzing and Designing mappings for data extraction
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
  • Prepared an ROI analysis report after evaluating the COTS product of the multiple business lines
  • Documentedbusiness, process, work, system, information flows using modeling techniques Unified
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Participated in the support of BI applications with IT applications and technical staff.
  • Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
  • Created Mock-up forms in MS word for better visualization and understanding of the software solution.
  • Tracked change requests and monitored workload and schedule.
  • Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
  • Utilized RUP (Rational Unified Process) and Agile methodologies to configure and develop processes, standards, and procedures.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
  • Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
  • 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.
  • Actively involved in migration of TNC and Sector CID legacy applications to new DW environment. Worked with MIS team/Business Users to understand the BI Data requirement and Business Metrics.
  • Developed and implemented processes and tools for requirements gathering, analysis, financial planning, tracking and delivery using Rational Rose requisite pro - RUP.
  • 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.

Confidential, Boston, MA

Business Analyst

Responsibilities:

  • Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
  • Implemented Scrum as a part of agile methodology for work management and part of The Team in the Framework.
  • Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
  • Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
  • Developed project artifacts like Requirement List, Process Models, Wireframes, Use Cases, Data Journal, and the Business Rules Catalog using MS-Visio and Rational Rose.
  • Worked on data modelling and produced data mapping and data definition documentation
  • Responsible for physical/logical data modeling; metadata documentation; user documentation; and production specs.
  • Developed detailed auditing and reporting of the current status and history of all components related to a product.
  • Involved in formatting data stores and generate UML diagrams of logical and physical data.
  • Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
  • Developed Business Process Flows using MS Visio.
  • Responsible for creating team specific agile process flow in JIRA to move tasks.
  • Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts.
  • Implemented SDLC which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
  • Used Microsoft Office suit to develop the documents such as Visio for creating wireframes, Word,Excel and Power Point for creation of Business Requirement documents.
  • Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
  • Also Used SnagIt for editing of the Screen shots and in Jad sessions for screen sharing and presentations.
  • Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis Created source table definitions in the DataStage Repository by studying the data sources.
  • Gathered requirements from all users, experts to understand the current functionality and the needs of the users using Agile methodology.
  • Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.
  • Prepared the UML Use Cases using Rational Rose.
  • Used MS Visio for flow-charting, process model and architectural design of the application.
  • Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
  • Reviewed Test Plans that contains test scripts, test cases, test data and expected results for the User Acceptance testing.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

  • Formulated and defined systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements following RUP.
  • Actively involved in validating the requirements and applying the RUP framework throughout the SDLC.
  • Obtaining a detailed knowledge of the business process being followed in the project environment.
  • Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level. Worked on their eBanking Module. eBanking is primarily the process of enabling clients operate his/her account Completely Online (Without having to reach for a branch).
  • Extracted the business requirements from the stakeholders keeping in mind their need for the application and documenting them using Rational ReqPro.
  • Created Wireframes using MS Visio, to effectively communicate the user-interface platforms to the system teams.
  • Involved in put or call options that protects an investor from foreign-exchange risk for a future sale or purchase of a specified foreign-equity portfolio. Involved in put or call options that protects an investor from foreign-exchange risk for a future sale or purchase of a specified foreign-equity portfolio.
  • The Credit Risk Evaluator Project is an integrated customer - controlled platform for credit risk management. It is a powerful tool for measuring and monitoring and managing credit risk, thereby offering a broad range of analytical Capabilities and user control.
  • Used MS word and Rational Rose for process modeling and business process flow diagrams.
  • Wrote Use Cases, prepared use case diagrams (using Rational Rose & UML) and followed Agile at every stage of the process.
  • Designed and developed project document templates based on SDLC methodology.
  • Created Test cases from scratch by using Business & Functional Requirement Specs, HLD and Wire Frames. Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
  • Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
  • Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
  • Interacted with database developers for formulating the ER diagrams and data flow diagrams.
  • Undertook back end testing using SQL and wrote queries.
  • Effective communication made possible between the developers and the end-clients to guarantee that development efforts were within the scope of the project and the development was as expected.
  • Created and updatedUserstoriesand tasks inRallyAgile testing tool.
  • Held regular JAD meetings with the system architects, developers, database developers, and quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
  • Carried out defect control and change control in ClearQuest.

Confidential, Oklahoma City, OK

Business Analyst

Responsibilities:

  • Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
  • Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
  • Identified internal and external system Requirements, design and configuration set-up.
  • Assisted with development of strategy for managing SharePoint permissions in conjunction with Active Directory and future implementation of Identity Lifecycle Management functionality
  • Constructed and maintained UML models using Visio and created use case diagrams, class diagrams and sequence diagrams for all the use cases
  • Identified Use cases from the requirements and wrote Use Case Specifications
  • Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
  • Help identify, define, and implement user-roles and create user stories during the transition from waterfall to agile methodologies.
  • Executed all efforts within the SDLC parameters of the IT organization leveraging existing technologies, proven system architectures and management team.
  • Designed and developed Project document templates based on AGILE methodology.
  • Developed Business Requirement Document as well as High-Level Project Plan.
  • Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
  • Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
  • Participated in the Logical and Physical Design sessions and developed Design Documents.
  • Worked with developers to make sure that they understood the Use Cases.
  • Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
  • Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
  • Worked with Quality Control Teams to develop Test Plan and Test Cases.
  • Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Confidential - Waterbury, CT

Business Analyst

Responsibilities:

  • Conduct user interviews, gathered requirements, analyzed, and documented business requirements based on theanalysis of loan processing workflow model Functioned as the primary liaison between the business line,operations, and the technical areas throughout the project cycle
  • Analyze various steps in the loan lifecycle and designed the system to identify and monitor the riskier loans
  • Analyze and prioritized key reports for day to day servicing needs for loan monitoring processing and InspectionAnalysis of Mortgage Processing workflow.
  • Mapped business processes to SAP functionalities
  • Worked on an agile project to in corporate nCino into the banks Small Business Associations (SBA)lending process, which included setting up an interface between nCino's cloud solution on the banks server-based loan processing system to move loan documents between the two systems, we held daily stand ups and wrote stories, use cases. We also trained the banks Loan Operations group on how to use nCino and on integrating the nCino product into their loan process flow.
  • Address all aspects of the loan lifecycle, starting from identifying a deal right up to loan closure
  • Able to read and write XML, Agile environment, understanding overall concepts of AWS and Angular because they are designing the UI, write some SQL.
  • Created complex integration diagrams (Sequence, Component & Activity) to visualize Business Process and their interaction with interfacing systems.
  • Assisted in performing liquidity risk & credit risk analysis on outstanding loans under different pressured scenarios.
  • Used standard Business Analysis methodology centered on RUP
  • Work with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus
  • Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
  • Extract data from Enterprise Data Warehouse to generate require ad-hoc reports using SQL
  • Wrote DDL scripts to create tables and views in the company Data Warehouse.
  • Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
  • Current practical knowledge of SQL, experienced in data mapping, data modeling, data analysis, ETL process, data warehousing concepts and Business Intelligence solutions.
  • Designed and developed the star schema Data mod Fact Tables to load the Data into Data Warehouse.
  • Prioritized and tracked defects using HP Quality Center and Jira. Created user manual/training docs for easy learning of web application.
  • Worked on building load rules and transformation logic for (ETL) of the data into the data warehouse.
  • As part of product backlog grooming sessions, created user-centered agile specifications (user stories).
  • Used Agile methodology to inspect and adopt also develop small incremental releases and iterate during testing phase
  • Involved in project scope meetings with the Pricing manager to understand the type of requests and issues handled by the pricing team and documented the high level business requirements to the product backlog using JIRA
  • Analyzed and researched the legacy systems for SAP implementation
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
  • Participate in the bug review meetings, Updated requirement document as per business user feedback andchange in functionality of the application
  • Managed and prioritized user stories using JIRA. Worked with the development team to identify blockers and provide resolution.
  • Conducted database analysis to assess product functionality and quality assurance, to support agile product development.
  • Designed and developed project document templates based on SDLC methodology.
  • Facilitate and managed meeting sessions with committee of SMEs from various business areas including

Environment: MS office, XML SPY, GOXML, Rational Rose,Agile/Scrum,Rational Requisite Pro, OOAD, .Net, Test Director, Windows, Oracle/SQL Server, SQL, MWS.

Hire Now