Sr. Business Analyst Resume
Temple, TX
SUMMARY
- More than 7 years+ of experience as Business Analyst in the Banking & Insurance, Retail, E - commerce, Healthcare domain with knowledge of Business Case Development, Development of IT Enabled Business Solutions and Business Analysis.
- Have very good experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methods like Rational Unified Process (RUP), Agile and Waterfall Method
- Experienced in Personal Property & Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
- Knowledge and Experience on Membership, Billing, Claims Payment Processing in relation to HIPAA, EDI X12, HL-7 ICD-9 & ICD-10, codes 834.
- Worked on trade capture (OMS), Middle office operations and Back office settlements with DTCC.
- Experience in designing Test Strategies, Test Cases, and Test Scripts and conducting User Acceptance Testing (UAT).
- Excellent understanding of web-based and client-server B2B workflows and e-Commerce, Banking processes including accounting transactions such as General Ledger, Revenue Determination, Payment Reconciliation, AR and Tax
- Solid experience of Defect/Test Management tools like HP ALM / Quality Center.
- Solid knowledge of applications provided by Asset Management & Wealth management trading platforms offered by major financial institutions.
- Skilled in preparing Business Cases, Business Requirements Documents, Use Cases, Functional and Technical Specification Documents, Requirement Traceability, Traceability matrices, Test plans, Test scripts and Software Development Plans.
- Experienced with gathering requirements and analysis for a Service Oriented Architecture (SOA), Identity Management, Legacy Migration, COTS Solution and working with global teams.
- Strong Subject Matter expertise (SME) in Healthcare: MEDICAID Functional Areas - Document Capture, Document Management (EDMS), Contact Management System (CTMS), Letter Generator, Interactive Voice Response System (IVR), and Service Desk
- Track and maintain Stakeholder requested enhancements and changes using SharePoint.
- Diverse experience includes developing reporting and procedural standards
- Experienced in managing client-interactions, project planning, scheduling, and development teams
- Knowledge of risk management, performance measure development, process development, and WBS development.
- Full 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).
- Expertise in creating Business Requirement Document (BRD), Requirement Traceability Matrix (RTM), Functional Requirements Document (FRD), Use Cases Specification, Non-Functional Requirement Document.
- Experience with the technical integration requirements which included the Warehouse Management System (WMS), Retail Management System (RMS), Point of Sales (POS) System, ECommerce Ship from Store, and the BI data warehouse, as a result of retiring a major legacy application (Island Pacific)
- Experience working in iterative and Agile and Scrum project environments
- Conducted Joint application development (JAD) sessions with relevant Subject Matter Experts to assess and document current configuration.
- Extensive experience in end-to-end (E2E) and Business-to-Business (B2B) testing.
- Skillful GAP analysis, Cost benefit analysis, Risk assessment, and SWOT analysis.
- Experienced in using different UML diagrams including Use Case Diagrams, Sequence Diagrams, Activity Diagrams and Collaboration Diagrams.
- Hands on experience with Data Warehousing, Dimensional Modeling, Data Analysis, Data loss prevention, Data Mapping, and Data profiling.
- Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
- Excellent Team Building and Problem Solving skills in conjunction with strong Technology and Engineering background
- Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
- Skilled in converting legacy reports to more contemporary programs such as Crystal Reports, Business Objects, MS Excel, MS Access, and SQL, and condensing number of reports to simplify processes
- Ability to articulate alternative solutions and reasoning behind the alternatives.
- Excellent communication and presentation skills along with strong interpersonal & analytical skills.
TECHNICAL SKILLS
Bug & Defect Tracking tools: JIIRA, HP ALM/Quality Center, Rally, BugZilla
Databases: MS Access, SQL Server, Oracle10g/11g, DB2
Business Intelligence (BI) Tools: Cognos, Tableau, Business Object
Web Technologies: HTML, XML, JavaScript, VB Script
Operating Systems: Window, Unix, Linux
SDLC Methodology: Agile, Scrum, Waterfall, SAFe, Kanban
Business Modeling Tools: MS Visio, UML, Rational Rose, CognosProject Management MS Project, MS Office, JIRA
PROFESSIONAL EXPERIENCE
Confidential, Temple, TX
Sr. Business Analyst
Responsibilities:
- Publish weekly POS (Point of Sales) reports internally and call out category trends, opportunities and risks.
- Assisted with User Acceptance Testing, developed and maintained quality procedures ensuring that appropriate documentation is in place.
- Tracked defects using JIRA and generate defect summary reports.
- Created and maintained Quality Database to track Quality Assurance audit results and trends to management and training team
- Responsible for integrating ERP, Payment gateway, Tax System to Hybris as a part of ecommerce systems.
- Worked with gathering information from the initial Change Requests, initial user stories, and meeting notes and converting them into a User Story document; updated and created Process flows.
- Designed and developed use cases, activity diagrams, and sequence diagrams.
- Conducted user interviews, gathered requirements, and analyzed the requirements using Rational Rose, Visio and Requisite pro.
- Performed extensive GAP analysis, Data Analysis, Data Requirement Analysis and Data Mapping.
- Provided walk-throughs of User Stories, Mock Ups and User Acceptance Criteria to Development team, QA and Stakeholders during the work item Kick-Off Meetings.
- Supported Development team & QA during the development and testing phase to define scope and communicate with the users in case of questions and to avoid scope creep.
- Participated in the Project Retrospection to review the project and discuss learning and improvement areas; utilized detailed knowledge of application features, scope and impact of business needs throughout analysis.
- Support major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
- Attend meetings on behalf of the Global POS (Point Of Sales) team.
- Visit local merchants for on-site installations, technical support and training of POS (Point of Sales) devices
- Worked with the users to finalize the user stories and gather their approval; participated in the grooming meetings to breakdown the work items into testable units.
Environment: POS (Point of Sales), Requisite Pro, HP ALM/Quality Center, ERP, CRM, MS Office (MS Word, MS Excel, MS Access), Crystal Reports, Java, Oracle.
Confidential - San Francisco, CA
Business / Functional Analyst
Responsibilities:
- Gathered business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME's)
- Provided support to developers with requirement classification, travel domain expertise and testing during Agile/Scrum iterations.
- Captured high-level requirements from different functional groups like Market Risk, Credit Risk, Operations, Financial Reporting and Trade Accounting and Product Control.
- Worked on restructuring the Listed Options front-to-back office trading model. Listed options mainly involved equities as the underliers.
- Monitored progress against business functionality, requested objectives to ensure that projects meets the specific release criteria.
- Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in definition stage.
- Conducted interviews with traders, Front office support and front office technology to understand the trading of equity derivative products and capturing the impacts on the future state.
- Designed UI Screens to maximize user experience, created and incorporated the wireframes into BRD/FSD
- Signed-off all releases before they enter production
- Designed and developed scenarios based on business requirements.
- Designed and deployed the custom objects, custom tabs, validation rules, workflow rules, auto-response rules to suit the needs of the application.
- Wrote complex SQL queries using joins, sub queries to retrieve data from the database.
- Analyzed Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification
- Involved in End-to-End testing of the Application, to ensure right data is being validated through all the interfaces, Reservations, Specials & Packages.
- Involved in planning and executing complex category of management data studies with large volumes of data.
- Assisted in Data analysis by generating reports in salesforce.com and MS Access.
- Worked directly with software engineers to ensure clear communications on requirements and defect reports.
Environment: MS Office, MS Visio, UI/UX, UNIX, Documentum, Windows, SQL, SQL Server, VBScript, C#. Cognos Data warehouse, ETL tools, DOORS, Database
Confidential, Seattle, WA
Business Analyst
Responsibilities:
- Partner with continuous product engineering teams on investigating systemic issues.
- Action upon ad hoc tasks requested by business partners to support day to day operations.
- Give clear and concise feedback on questions/concerns made by the business regarding database logic.
- Work with key business stakeholders, engineering development, and PMO on developing system enhancements.
- Collaborate with the development team on designing clear and concise project requirements.
- Participate and provide signoff based on User Acceptance Testing results.
- Create and execute SQL queries to find clues on what may be causing the opportunity.
- Perform root cause analysis on production issues.
- Developed functional specification and implements store-side order entry system that interfaced with electronic catalog and POS system.
- Drive and lead execution of new product initiatives through strategic development ensuring target scope in both ecommerce applications and back-end systems using Waterfall and Agile development methodologies.
- Gather and write functional/business requirements used by engineers and programmers on multiple ecommerce applications as well as collaborate with User Experience/Interface designers to develop wireframes/schematics that support such requirements.
- Got involved in requirements elicitation and analyzing requirements during the requirements analysis phase of the projects.
- Coordinating workflow across ecommerce, IT, UI, retail and UAT teams
- Performed the analysis of several websites like EBay, Amazon, Confidential, Target, JCPenney, Macy, Levi's, Calvin Klein, US POLO etc. to identify competitive advantages and value addition to Walmart.
- Provide product support to Enterprise, Supply Chain, Omni Channel and Order management applications.
- Follow up with engineering teams to provide a correction of errors document that provides solutions, which will prevent the issue from happening going forward.
- Involved in CRM processes like Design, development, planning, testing and integration of Salesforce
- Create internal monitoring alarms and reports by designing queries using SQL.
- Offer post implementation support on enhancements that have been introduced into production.
- Performed GUI testing and analyzed end to end functionality by testing the application manually.
- Track and report upon testing activities, including testing results, test case coverage, defects discovered and their status on a weekly basis.
Environment: Ecommerce, POS, SQL Server, .NET 4.0, UAT, Google Apps for Business, Windows, MS Project, Agile, JAD, MS Visio
Confidential -Franklin, TN
Business 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 Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
- Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes Used Test Director, PL/SQL for testing the application
- Designed and developed Use Cases using UML and Business Process Modeling.
- Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare)
- Involved in Trizetto Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPPA 837, 834,204,820, 271, 270, and proprietary format files and Reports development.
- 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.
- Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan)
- Identified gaps in the business process.
- 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.
- Assisted process owners in process training and implementation.
- Streamlined the Restatement Financial Data Warehouse access review Process.
- 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.
- Analyzed 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.
- Documented Requirements for Management Reporting out of Clear Quest using Crystal Reports.
- Facilitated Change Control Board and Governance Board meetings and acted as a liaison between parties impacted by the change requests.
Environment: MS Office, SQL Navigator, Clear Case, HTM, UML, MS Project, RUP, SQL, DB2, Oracle, Visio, ClearQuest
