We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

3.00/5 (Submit Your Rating)

Iselin, NJ

SUMMARY:

  • Result - oriented, accomplished and spirited Business Analyst with a proven track record over 7+ years of work experience in Banking, Financial, Insurance, Mortgage.
  • Proficient in project management and SDLC methodologies like Waterfall and Agile, Scrum etc
  • Experience in Change management, Capital Markets, Fixed Income, Loan IQ, Equity or Derivatives Trading Technology for an Exchange, Brokerage/Financial firm and Communication Protocols with Banking Systems
  • Experience in Implementation, Production support, customization, upgrades and troubleshooting in Accounts Payable, Accounts Receivables and General ledger.
  • Experience in online banking, Credit Card, Debit Card, online bill pay, online mortgage loan processing and online brokerage on mortgage or securities.
  • Facilitated and lead multidisciplinary teams during JAD and JAR sessions with key stakeholders.
  • Extensive knowledge in UML Modeling to create flow diagrams
  • Planned all the RUP iterations and documented the artifacts throughout various phases. Conducted analyses of Business requirements and System specifications
  • Developed Data Flow Diagrams and Data mapping, illustrating the flow of data from the front end into the Application database Tables
  • Experience in writing Use cases and producing Use Case Model, Analysis model, Behavior diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology & Business process flow diagrams using MS Visio
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
  • Innovative, savvy and results-focused marketing professional with demonstrated experience in focused and creative online marketing strategies, PPC and B2B and B2C sales initiatives. Recognized for ability to in corporate avant-garde marketing techniques, systems, processes, and procedures to enhance product branding practices, increase productivity, that boost revenues.
  • Requirements Management using IBM Rational DOORS and Comply pro 2.Business Process Re-Engineering / System Analysis with Database Administration using IBM Rational DOORS and Comply pro 2.
  • Extensively worked with Data Testing, back-end testing, functional testing, end-to-end testing, integration testing, regression testing, data-driven testing, UAT, and Performance Testing using both manual and automation tools. Vast experience in Informatica, ETL, Database, HIPPA, EDI and develop SQL scripts for back-end testing and adhoc reports
  • Business writing skills in writing Business documents such as Use-Case, FRS, SDS, &SRS
  • Experience in conducting GAP analysis, SWOT analysis, Cost benefit analysis, ROI analysis
  • Experience in supporting strategic planning, goal setting, strengthen accountability, enhance decision making, and improve customer service.
  • Broad understand and knowledge of Insurance Industry operations with emphasis on Life and Long Term Care Insurance processes.
  • Work experience includes effective implementation of Requirement Management, Change Control Management, Defect Prevention Management, Release management and Project Management tasks throughout the project life cycle (PLC).
  • Domain knowledge of insurance industry with very challenging and demanding work environment. Broad experience in Property and Casualty Insurance including Auto, Home, and Marine Life insurance/Annuities.
  • Experience working with Property and Casualty, diversified portfolios, due diligence scenarios, market interest rates and investment product risk factors.
  • Good knowledge of Property and Casualty Insurance, Umbrella, Workers Compensation. Experienced in working with Auto, Commercial P& C rating system, Claim. Applied umbrella activities like risk analysis, tracking and control, and conducted technical reviews throughout the project.
  • Comprehensive knowledge of e-commerce business processes and e-commerce concepts and terminologies
  • Experience in conducting various analysis including ROI, AS-IS and TO-BE, Cost-Benefit analysis and Risk Analysis and Compliance document management.
  • Expertise in employee relations training payroll and state and federal laws. Adept at improving efficiency while meeting deadlines and budget requirements.
  • Extensive experience in managing IT Projects from establishing requirements to installation, providing follow-up maintenance, database website design and implementation, production system documentation and training, performing Quality Assurance testing and database administration.
  • Extensive experience in software modeling using various UML diagrams such as Class Diagram, Activity Diagram, Sequence Diagram, Deployment Diagram, Use case Diagram and Component Diagram
  • Strong analysis and communication skills with an ability to transform the needs of stakeholders into Functional/Technical requirements backed with experience and education in financial domain.
  • Strong experience in gathering requirements, documenting requirements, defining project plans and writing system test plans and developing test scenarios.
  • Gained solid experience as a primary liaison between business group and technology team throughout the Project Life Cycle.
  • Strong understanding and experience in Data analysis, Data warehousing, Business Intelligence systems
  • Knowledge of Sarbanes-Oxley Act (SOX), and Tax accounting rules.
  • Extensive knowledge and experience in GAP Analysis, Financial Statement Analysis, Valuation of companies, analyzing industry and market trends and Statistical analysis using SPSS.
  • Excellent knowledge with ETL, Data Warehouse and Business Intelligence (BI), Data Management and Database Design, Business Analysis and Information Engineering, Software Quality Assurance, Advance in Data Integration
  • Extensive workers’ compensation claim management experience
  • Experience in Retail Pro Planning, Retail Pro 9, and Retail Pro Prism
  • Experience in Business logic ASP .NET 3.5 application Support with C#, Web API, service-oriented architecture (SOA) and Restful API
  • Strong experience on JavaScript, HTML, CSS, JSon and riot.js
  • Strong Knowledge on WebMethods Integrations, J2EE/ Java Java servlets, JSP, JPA, JSM
  • Skilled in developing Test Plan and Test Cases as per the business process requirements.
  • Experience in project management tools, project lifecycle and analysis templates
  • Experience in Data manipulation, performance testing on MySQL and MS-Access using SQL scripts.
  • Mentored new team members and also involved in task assignment for offshore team members
  • Ability to work effectively, independently and in a team.
  • Expert level skills in MS Office products like, MS Project, MS Word, MS Excel, MS PowerPoint and MS Visio.

TECHNICAL SKILLS:

Programming Languages: SQL, Transact SQL, PL/SQL, C, C++, COBOL, Visual Basic, VB Script HTML,JAVA EE, J2SE, .NET framework, Informatica

Database Systems: SQL Server, Oracle, Sybase, DB2, and MS Access, Teradata, Metadata.

Modeling Tools: Agile, MS Visio, Rational Rose, Erwin.

Process Tools: Rational Rose Suite, MS Office Suite, MS Project, MS Visio, XP (Extreme Programming). HP Server Automation V

Reporting Tools( data Warehouse): Crystal Reports, Business Objects, Guidewire.

Operating System: Windows, UNIX, Sun Solaris

Version Control: PVCS, Rational Clear Case

Testing Tools: Rational Enterprise Suite, Quality Centre/ALM.

MS Suite: MS Office, Ms Access, Ms Power Point, Ms Excel, Ms Word, Ms Visio, XML Tools & Technologies: Design Patterns, XPath queries, XSL templates, XML, Turbo XML, XmlSpy, MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Iselin, NJ

Business Systems Analyst

Responsibilities:

  • Interacted with clients to assess needs, identify key challenges, and define project scope & deliverables.
  • Prioritized project efforts, developed project plans, process flows, Use Cases based on Tax accounting rules.
  • Performed Problem Analysis, Research Solutions and presented recommendations.
  • Developed additional processing and data models that will be added to existing system using MS Visio.
  • Gathered Business Requirements from users and used Requisite Pro for documenting the requirements.
  • Conducted Business Requirements, Functional and Technical meetings with Business groups.
  • Attended meetings with QA team members for SME in order to deliver quality documents.
  • Reported status, milestones, and project plan tracking to project management and project owners on a weekly basis.
  • Providing technical solutions, handling functional testing procedures, and planning e-commerce applications
  • Used MS Visio for flow-charting, process model and architectural design of the application.
  • Developed Test plans and scripts using Test Manager and utilized use cases as a basis for performing Integration and System testing.
  • Specified the system architecture and design utilizing the UML Analysis and Design Models
  • Worked extensively through Agile development methodology by dividing the application into iterations
  • Responsible Gathered user requirements and business requirements from business/user group and documented User, Business, Functional, and Technical requirements specifications using MS Word and MS Visio that provided appropriate scope of work for technical team to develop prototype and overall system
  • Managed and coordinated all phases of Software version update project and supported staff - met stringent deliverables and implementation date
  • Process mapped Operations, which identified redundancies, manual processes and backlogs, which improved efficiency of departments and service levels
  • Identifies Actors, Activities, Artifacts, and Workflows and developed use case diagrams using MS Visio
  • Implemented Rational Unified Process (RUP) as the software development methodology
  • Researched regulatory and legislative information, provided updates and adjusted compliance processes when necessary.
  • Compiled, processed and reviewed company sales and financial information to ensure end-to-end compliance.
  • Conducted compliance audits and examination of company data.
  • Focused on key operational, accounting, and financial reporting controls within the assigned areas and scope for SOX reviews.
  • Identified key controls, assessed controls for design deficiencies, and updated process.
  • Participated in the implementation of new processes and corrective action plans to ensure SOX compliance.
  • Involved in Functional testing, business requirement testing, data requirement testing, regression testing
  • Wrote test cases and test plans for the related and assigned scripts according to the test strategies defined in the project and testing team guidelines
  • Assisted the database modelers in preparing the logical and physical data models and ascertained that requirements have been met.
  • Responsible for creating risk assessment spreadsheet for each new project.
  • Regularly extracted precise data from company database to research projects.
  • Monitored financial trends in the insurance industry and applied those trends to risk management.
  • Analyzed and modified Test Cases and executed them. Developed application software in COBOL. Also extensively involved in Testing COBOL, VSAM, CICS and DB2 applications and has clear concepts of Testing Methodologies.
  • Created tables & Performed Data Driven Test to retrieve items from the Oracle database using SQL.
  • Utilized IS-strategic plan prioritization techniques of business goal alignment to document Project Initiation, Project Charter and applied project management competencies for HRM system
  • Developed the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease. Facilitated and managed meeting sessions with committee of SMEs (Subject matter experts) from various business areas including Credit Profiling, Treasury /Cash Management, and Marketing Analysis. Identified/documented data sources and transformation rules required populating and maintaining data warehouse content

Environment: Oracle, SQL Plus, ETL, Rational Suite Clear Case, Designer, People Code, SQR, Application Engine, Java, XML, Crystal Reports, SQL, MS SharePoint, COBOL, BPMN, COBOL,Adobe Experience Manager (AEM),Rally

Confidential, Columbia, MD

Sr. Business Analyst

Responsibilities:

  • Collected and evaluated business requirements, functional specifications, project schedules, documentation and test plans
  • 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
  • Launched the business requirement collection approach based on the project scope and SDLC Methodology
  • Collaborated with corporate accountants to analyze Financial Statements for Risk Estimation according to GAAP principles and comprehensively work with requirement gathering for Enterprise reporting system using RequisitePro
  • Used the BPMN to GAP Analysis to bridge the gap between business processes.
  • Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan and effective in multitasking and effective management of assignments according to work schedules with strong project management orientation
  • Worked to conduct Credit Risk Measurements like calculation of RWA (Risk Weighted Asset)
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk and designed and developed project document templates based on SDLC methodology
  • Experience in implementing PEGA (BPM) for streamlining operations in various areas of banking, including Credit Cards, Account Management, Customer Service, Campaign, and Marketing Accounting.
  • Conducted user interviews at both in-house and client locations.
  • Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams
  • Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
  • Developed and maintained successful relationships with business referral sources.
  • Communicated with and advised clients and partners during various stages of the loan process.
  • Provided underwriting with complete and accurate loan applications.
  • Ensured exceptional client experience by overseeing loan process from origination through closing.
  • Utilized training materials, reference tools, and other resources to provide accurate up-to-date loan program / policy information to clients and partners.
  • Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
  • Throughout the entire project used Agile methodology to smoothly work on the project and get process move faster.
  • Implemented numerous automated data collection systems utilizing MS ACCESS, SharePoint, Outlook, and Adobe Acrobat fellable electronic forms for reporting and analytics.
  • Worked closely with traders, portfolio managers, the equity and fixed income support team, project managers and developers to enhance functionality and to correct problems with fixed income, equity and derivative trade related systems
  • Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet, p performed extensive requirement analysis including data analysis and gap analysis
  • Explain Insurance Property & Casualty, Workers Compensation definition to the dev team .
  • Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts .
  • Worked Closely with Portfolio management and analysis, fixed income trading
  • Worked with project management to analyze change requests to determine what is being requested and programming required. Worked on data modeling and produced data mapping and data definition documentation
  • Documented existing and proposed process flow, analyzed current and target system, and conducted GAP analysis
  • Used the different types of views in Requisite Pro Attribute matrix, to display requirements of a specified type
  • Assist with cross-functional projects surrounding process re-engineering and process improvement as it relates to the financial systems
  • Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios
  • Designed and developed all Use Cases and UML models using Rational and Visio
  • Developed business process models in RUP to document existing and future business processes
  • Established a business Analysis methodology around the RUP (Rational Unified Process)
  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
  • Advised managers on organizational policy matters and recommend needed changes.
  • Helped revamp new employee orientation to foster positive attitude toward organizational objectives.
  • Served as a link between management and employees by handling questions interpreting and administering contracts and helping resolve work-related problems.
  • Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place
  • Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose and involved in all phases of software development life cycle (SDLC) in RUP framework

Environment: Windows, Microsoft Office SharePoint, SDLC, Mainframe, Cognos, ETL, Rational Requisite Pro, Misysloan IQ, MS Office, MS Visio, SQL Server, BPMN,MS Project, .Net, MS FrontPage, MS Access, Lunix.

Confidential, Raleigh, NC

Business Analyst

Responsibilities:

  • Met with client groups to determine user requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.
  • Monitored Month-end Process, Accrual Processes.
  • Experience in UAT, SIT testing and in-house Testing.
  • Conducted Surveys and Brainstorming sessions with SMEs for requirement gathering.
  • Extensively used Rational Requisite Pro for reviewing and analyzing the requirements.
  • Performed Gap Analysis of the As-Is and Should-Be process within the organization for implementation of RUP.
  • Conducted credit, underwriting, and financial analysis to qualify clients for loan programs.
  • Managed leads and account information for over 150 clients daily.
  • Formulated detailed marketing and sales strategies in order to increase team productivity.
  • Independently organized a daily schedule including: training, client relations, and team building.
  • Performed Data Mapping of the entire module and performed complete analysis to integrate Risk Analyzer with the online processing tool.
  • Explained Property & Casualty terms, Insurance Rules, Workers Compensation, Claim to the Dev team.
  • Formulated the ER diagrams of Property and Casualty data and data flow diagrams in order to interact with database developers.
  • Examined key Performance Indicators KPI for Property and Casualty such as Loss Ratio, General Operating Expense Ratio.
  • Documented report layouts and report mapping documents for ad hoc reporting based on Property Casualty FP A team's needs.
  • Extensive participation in Error Review Meetings.
  • Investigated and processed claims reports and supporting documentation.
  • Identified and removed obstacles to ensure highest quality claims outcomes.
  • Analyzed merits and financial impacts of injury circumstances.
  • Performed thorough reviews of all documentary evidence including investigative reports.
  • Conducted and evaluated legal strategy conference calls at regular intervals.
  • Conducted Error Analysis, by doing experiments and making measurements, drawing meaningful conclusions.
  • Expertise in Performance Management and implementing its benefits.
  • Used guidelines and artifacts of RUP to strategize the Implementation of the Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle (SDLC).
  • Derived Functional Requirement Specifications (FRS) based on User Requirement Specification (URS). Understand and articulate business requirements from user interviews and then convert requirements into technical specifications
  • Analyzing and interpreting the business requirements for QA and design teams using IBM DOORS.
  • Lead Administrator for requirement management using Comply pro 2 web Interface and IBM Rational DOORS database configuration.
  • Provide analytical and administrative support within an internal control environment. Assists team in gathering and organizing data that helps track, report and manage internal control gap issues and mitigation plans. work with internal customers to establish and perform quality control, and assists with analysis and development of recommendations.
  • Perform Post Fund Review of originated first mortgage transactions for federal regulatory compliance, adherence to underwriting conditions, and other key areas impacting salability and risk.
  • Created Data Strategy, architecture and defined system develop processes to deliver accurate and understandable information across the Defense Department
  • Documented the Use Cases and prepared the Use Case, Activity, Logical, Component and Deployment views using MS Visio and Rational Rose for a clear understanding of the requirements by the development team. Coordinated with testers in using Rational Clear Quest for defect tracking.
  • Reviewed Integration Test Plan for integration between modules.
  • Documented project processes and procedures and version controlled them using Rational Clear Case.
  • Created Artifacts and defined Milestones and iteration plans for Inception and Elaboration phases of SDLC.
  • Performed Smoke (Sanity) Testing to test the basic functionality of the application.
  • Implemented Rational Design, Test and Configuration tools like RequisitePro, Rose, CMM (Capability Maturity Models) Test Manager, Robot, ClearCase, ClearQuest, and SoDA.
  • Coordinated with the development team in documenting a User Manual for the LSS.
  • Documented and delivered Functional Specification Document to the project team.
  • Partnered with the technical areas in the research and resolution of system and process problems.
  • Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.

Environment: MS SQL Server, Misys Loan IQ, MS-Access, RUP, XML, Six Sigma, CMM, Rational Enterprise Suite, Test Director, MQSeries.

Confidential, Pittsburg, PA

Business System Analyst

Responsibilities:

  • Interfaced with the client as part of the Requirements Engineering team to finalize the project scope
  • Facilitated JAD Sessions and gathered Business Requirements
  • Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project
  • Provided recommendation for use of ATG Commerce for B2B and B2C business
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle
  • Coordinated with the business development teams in handling the project lifecycle
  • Developed detailed requirements of the project such as flow charts and diagrams
  • Coordinated with the senior staff in defining the project scope and developing complete business planning activities
  • Provide best practice recommendations in the areas of Order Management System and CRM
  • Provided insights about the enterprise e-commerce systems and new implementations
  • Identified the project gaps and designing enterprise solution architecture to meet the project requirements
  • Handled the finance and project resource and budget activities by coordinating with the organization staff
  • Prepared user training manual for merchandising team on managing commerce assets through ATG BCC (Business Control Centre)
  • Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite
  • Conducted interviews with end-users to collect requirement and business process information
  • Design and Architecture using BEA Weblogic’s latest features like Portal, Page Flow, Process Control, Java Control and Web-Services using Weblogic development IDE Workshop on Oracle database
  • Implementing and supporting Order Management System.
  • Used Retail Pro Planning to Manage Inventory and forecast the future sale.
  • Analyzing the software requirements and handling complete project planning and implementation activities
  • Developed business process models in RUP to document existing and future business processes
  • Performed extensive Requirement Analysis including data analysis and gap analysis
  • Designed and developed project document templates based on SDLC methodology
  • Participated in various stages of data and requirement analysis for project needs
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
  • Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes
  • Developed business requirement specification documents as well as high-level project plan
  • Worked with Rational Clear quest for defect management
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
  • Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts
  • Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
  • Relieved pressure off the PM by maintaining artifacts and portions of the project binder
  • Documented and delivered Functional Specification Document to the project team
  • Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs
  • Participated in the logical and physical design sessions, assisted and developed high and low level design documents
  • 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
  • Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
  • Helped with end user training
  • Conducted User Acceptance Testing (UAT)
  • Performed task decomposition, delegated tasks and monitored project milestones using MS Project
  • Assisted the PM in performing Risk Assessment, Management and Mitigation

Environment: Microsoft Office Suite, ATG, Borland Caliber RM, Unix, Documented, Windows, Oracle, SQL, VBScript, C#. DOORS, Micro Strategy, Quality Center

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

  • Converted business and user system needs into Vision Documents, Business Process Flows, Use Cases, and Non Functional Requirements.
  • Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
  • Wrote clear and concise detailed system requirements specification (SRS) documents and user documentation.
  • Spearheaded the creation of functional specification documents with SMEs clarifying strategy and setting client expectations for the development of Commercial Auto line of business.
  • Involve in verification process of auto insurance where the system check policy record, change of policy, compiling data on insurance policy change and canceling insurance policies as requested by agents.
  • Worked with the UI team to create the User Interface screenshots to be presented to the Business representatives.
  • Extensive skill on Guidewire Billing Center, Policy Center and Claims Center integrations.
  • Created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams for the detailed analysis of business objects.
  • Created and maintained Requirement Traceability Matrix to ensure that requirements were complete and consistent within budget and technical constraints.
  • Wrote multiple SQL queries for modifying records (insert, update & delete) in the backend database, performed JOINS on multiple-tables for data extraction.
  • Conducted regular status-update meetings with the developers, testers, and business users to ensure conformity with requirements.
  • Worked in various scrums/sprints all through the project to help and make the developers understand the functionality.
  • Maintained a Document Management Portal in MS SharePoint for an effective storage, maintenance and retrieval of client’s documents.

Environment: Window, MS Office, RUP, UML, SQL, Agile, Rational Rose, Ms Visio, Project, MS SharePoint,

We'd love your feedback!