We provide IT Staff Augmentation Services!

Business Analyst/business System Analyst Resume

Columbus, OH

PROFESSIONAL SUMMARY:

  • Highly skilled IT and business professional with over 7 years of proactive experience as a Business Analyst with expertise focused in finance, Mortgage and Insurance domains for full project life cycle implementation.
  • Extensive knowledge and understanding of investment instruments like Stock, Bonds, portfolio management, Mutual fund, Options, Futures, Fixed Income, ETF, Mutual Funds, Futures & Forwards. Trained and helped developers to understand the logic of these instruments.
  • Excellent knowledge in Mortgage Underwriting process, Web Banking/ Mortgage Application .
  • Acute understanding of concepts related to Student Lending, Consumer/Business Credit Cards and Consumer loans.
  • Strong experience in conducting Interview, Joint Application Development (JAD ) and brainstorming sessions with end - users, Developer and QA teams for requirement gathering and documenting the requirements in Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
  • Effectively monitored the Defect Tracking process, executed and assisted testers in User Acceptance Testing (UAT), Integration, Functional, using Excel, Quality Center and Jira. Conducted UAT, provided user guide, user manual , demonstrated the entire application and prepared test cases.
  • Excellent understanding of Data integration services, Data ETL using SQL query tools and applications.
  • Performed back end testing, data validation, Integration and manipulation using SQL queries.
  • Experienced in reviewing Test Procedures, defining Test cases, executing test plans, analyzing bugs and interacting with team members in fixing errors using Quality Centre and JIRA based on functional and technical specifications.
  • Extensive experience in creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
  • Adept at project documentation and expertise with UML diagrams such as activity diagrams, wireframes and swim lane diagram using MS Visio .
  • Thorough knowledge in implementing all seven phases of Software Development Life Cycle (SDLC) such as initiation, planning, design, development, testing, deployment and maintenance by using Agile, Rational Unified Process (RUP) and Waterfall methodologies .
  • Experienced with Sprint planning, Backlog grooming, Release planning and provided Demo to business users.
  • Proficient in many software packages including (but not limited to) MS Office (Word, PowerPoint, Excel), Visio, MS Project, SharePoint, Adobe.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities. software using Informatica, Shell Scripts .

TECHNICAL SKILLS:

Databases: MS SQL server, Access 2000, Oracle

Operating System: Windows XP/95/98/NT/2000,2007, UNIX

Language: Java, Spring Framework, Hibernate

Activity and bug Tracking Tools: HP ALM, Jira and Rally, QTP

Financial data search: Bloomberg

Front end tools: MS office, Oracle Crystal ball and Visual basis

Methodologies: Waterfall, RUP (Rational Unified Process) and Agile

Modeling tools: MS Visio and Financial analysis modeling using Excel

WORK EXPERIENCE:

Confidential, Columbus, OH

Business Analyst/Business System Analyst

Responsibilities:

  • Facilitated Joint Sessions for communicating and managing expectations
  • Identified processes for developing and documenting detailed business requirements. Data was collected from end-users and analysts.
  • Created User Stories and from requirements.
  • Perform treasury cash allocation procedures including daily funding of business units and departments
  • Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
  • Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same.
  • Ensured Use-Cases were consistent and covered all aspects of the Requirements document.
  • Maintained documents and the effect of proposed changes on the project schedule and costs.
  • Managed and tracked Defects using JIRA.
  • Worked directly with software engineers to ensure clear communications on requirements and defect reports.
  • Designed and developed scenarios based on business requirements.
  • Used SQL statements for Back-end Testing.
  • Interacting with other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.
  • Validated the scripts to make sure they have been executed correctly and meets the scenario description.
  • Use Informatica debugging techniques to debug the mappings and use session log files and bad files to trace errors that occur while loading

Confidential, Columbus, OH

Technical Business Analyst/ Business System Analyst

Responsibilities:

  • Wrote test plans and test cases based on the business requirements which involved market risk analysis and risk management like continuous time finance & asset pricing, stochastic processes & simulations, credit derivatives, structured products, documentation, value at risk, risk & return optimization, mortgage rules and procedures, ACH methods and workflow.
  • Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts.
  • Created Use-Cases and Requirements documents to document business needs.
  • Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
  • Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same.
  • Supported Users in understanding the Version One Test Management Process during User Acceptance Testing (UAT)
  • Was responsible for Business Process Management (BPM) for development of various projects.
  • Created and maintained the Requirements Traceability Matrix (RTM).
  • Ensured Use-Cases were consistent and covered all aspects of the Requirements document.
  • Maintained the Business Impact Analysis Template (BIAT) to analyze and document the effect of proposed changes on the project schedule and costs.
  • Creates complex SQL queries using SQL Server tools to produce Ad-Hoc reports for data quality validation.
  • Developed and executed SQL queries to verify test results.
  • Worked directly with software engineers to ensure clear communications on requirements and defect reports.
  • Designed and developed scenarios based on business requirements.
  • Developed requirements integrating E-R diagrams and designed the testing process flows.
  • Interacting with other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.
  • Created Business Components in HP ALM for the reusable scenarios in reports testing.
  • Validated the scripts to make sure they have been executed correctly and meets the scenario description.

Environment: Agile, Postgres, DB2, Web logic, MS Office, MS Visio, MS Project, Version one, Windows, UNIX, Informatica, Super Putty, Java, Spring boot, Hibernate

Confidential, Albany, NY

QA/Business Analyst/ Business System Analyst

Responsibilities:

  • Outstanding knowledge of HIPAA standards, EDI (Electronic Data Interchange), Implementation and Knowledge of HIPAA code sets and ICD-9, ICD-10 code sets.
  • Reviewed, collected and documented business requirements, application infrastructure and modules/ interfaces.
  • Provide /develop domain knowledge (SME) for 5010 conversion projects.
  • Highly Dynamic environment with sprint team using agile methodology.
  • Performed Gap Analysis to estimate the Gap between As-Is and To-Be states of the business.
  • Participated in the logical and physical design sessions, produced design documents using UML process.
  • Participated in periodical JAD sessions with the management and IT teams; technical design walk-through to gauge extent of compliance with stake holder's expectations.
  • Worked on Testing Data migration, FACETS upgrades, Reports Implementation, letters, Inbound/outbound Interfaces and FACETS Extensions.
  • Quick setup, execution and reporting of findings for smoke test for each build.
  • Experienced in Claims, Subscriber/Member, Plan/Product, Claims, Provider, Commissions and Billing Modules of Facets.
  • Extensive knowledge on the Inbound and Outbound HIPAA 834 transaction.
  • Worked with providers and Medicare and Medicaid entities to validate EDI transaction sets.
  • This includes HIPAA 4010; 837, 834 (Benefit Enrollment and Maintenance) and others. Provided healthcare provider problem resolution. Work as a medical coding SME, including ICD-9, HCPCS; Procedures and diagnosis testing
  • Hands on experience with daily claim processing and uploading 837, 834 files into database.
  • Identify project specific requirements (Technical) and notify QA lead /Manager.
  • Tested, Developed test cases and test scripts for all EDI Transactions.
  • Documented, analyzed, prioritized and maintained defect logs using Quality Center.
  • Tested the, enrollment, and eligibility, claims, and provider's end to end application.
  • Worked as Quality Center admin for the project.
  • Use Informatica debugging techniques to debug the mappings and use session log files and bad files to trace errors that occur while loading

Environment: Agile, Rational Suite, Crystal Reports, MS Project 2007, MS Visio 2007, MS Office suite 2007, SQL, Java, Facets.

Confidential, Cleveland, OH

Business Analyst/ Business System Analyst

Responsibilities:

  • Involved in requirements gathering, design, and development and testing phases of Software Development Life Cycle SDLC.
  • Created functional business requirements, Interface Design Documents, System Design Document and associated System Requirement Specifications utilizing Microsoft Team Foundation Server in a waterfall environment
  • Prepared and presented Business Requirement Document (BRD), System Requirement Specification (SRS) and Functional Requirement Document (FRD.). Gathered requirements for SharePoint and other Software Application Projects.
  • Collected requirements (using) Brain storming, Document analysis, Focus Groups, Interface analysis, Interviews, JAD, survey, reverse engineering and user task analysis for various reporting types like CLUE (Comprehensive loss underwriting exchange, Change Report, Claim Count, Claim summaries).
  • Assisted with product evaluation, product customization and system integration. Conducted GAP analysis around the identification of business rules, Risks involved, business and system process flows, user administration, requirements and assumptions.
  • As business analyst was responsible for preparation of function specification documents for application enhancements involving screen changes, based on feasibility study of the requirements and target system.
  • Conduct business user walkthrough for the functional documents prepared. And secure sign-off from business teams.
  • Prepare screen mock ups and snap shot screen representation to aid development team and QA team.
  • Review functional test design, test script preparation and test execution. Contribute towards defect triage and fixing.
  • Wrote functional specification document, flow diagrams and use case diagrams.
  • Responsible for project plan creation using Microsoft project.

Environment: Power Point, MS Project 2007, MS Visio 2007, MS Office suite 2007, SQL,

Confidential

Business Analyst/ Business System Analyst

Responsibilities:

  • Reviewed, analyzed and evaluated business processes procedures and user needs.
  • Provided data analysis to support, compiled, and reported key information for operations and business objectives.
  • Responsible to driven processes and improvement initiatives by gathering and documented business requirements.
  • Performed and participated in the analysis, design, implementation of the business procedures following appropriate standards.
  • Analyzed and interpreted data to identify trends, patterns and opportunities for the business and clients.
  • Communicated analysis and interpreted to appropriate audience.
  • Produced, published and distributed operational reports relating to the development and performance of products and processes.
  • Conducted tests and test planning sessions, provided input for feasibility and prepared user documentation and followed up evaluation.
  • Acted as a liaison with various departments, management and staff to resolve problem and improved process and procedures.
  • Performed project management leadership functions as a project manager or team member

Environment: Photoshop, MS Project 2007, MS Visio 2007, MS Office suite 2007, MY SQL.

Hire Now