Business Analyst Resume
Southfield, MI
SUMMARY:
- 6 plus Years Professional Experience as Business Analyst with understanding of Business Requirements gathering, Business Process Flow, Business Process Modeling
- Expert in writing, reviewing, executing Test cases and have exposure to all stages of SDLC and Agile/Scrum Methodology, Waterfall and Rational Unified Process RUP
- Experience in writing Business Requirements Document BRD and, Functional Requirements Document FRD
- Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Test Readiness Review Documents, Test Summary Reports.
- Experienced in all phases of the Software Development Life Cycle SDLC including requirements gathering, design, development, testing and deployment
- Knowledge on the phases of Agile methodology and scrum Methodology
- Excellent skills in facilitating Joint Application Development JAD for eliciting functional requirements that support the high - level business requirements
- Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
- Expertise with UML, applied for developing Use Case Diagrams and Sequence diagrams.
- Excellent skills in writing Test Strategies, Test Cases, Test Scripts based on BRD and TDD.
- Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center, Rational Clear Quest, Bugzilla.
- Experience in Smoke Testing, Functional Testing, System Testing, Regression Testing and UAT Testing.
- Hands-on experience with Facets support systems to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835 /271 transactions.
- Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
- Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
- Proficient in Word, Excel, Power Point & Visio. Knowledgeable in MS Access.
TECHNICAL SKILLS:
Project Tools:: HP AGM, HP ALM, Jira, SharePoint, Rational RequisitePro, Rational Quality Manager, MS Excel, Tableau.Operating Systems: Windows 95/NT/2000/XP, Unix, Mac OS 9/10
Databases: MS SQL Server, Oracle 9i
Methodologies/Frameworks:: Agile/Scrum, UML, ER Diagram
Languages:: J2EE, SOAP UI
Office Tools:: MS Access, Excel, PowerPoint, Word, MS Outlook Express, Outlook Exchange
Testing Tools: SOAPUI, HP ALM, Chrome Browser testing for Mobile devices
Data Modeling Tools: MS Visio, SQL, wireframe
PROFESSIONAL EXPERIENCE:
Business Analyst
Confidential - Southfield, MI
Responsibilities:
- Created new reports based on requirements. Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
- Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
- Collaborate with data modelers, ETL developers in the creating the Data Functional Design Documents.
- Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
- Configure MDM tables in the following sequence: Base Objects, Relationships Base Objects, and Defined and developed the ETL process to load the data into the landing tables during the land process
- Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
- Developed mappings using various cleanse and address doctor functions
- Developed the Match paths, Match Columns and Match rules (Exact) in the Match and Merge Process
- Did Data landing, staging and loading process using the batch viewer
- Worked on Hierarchy manager for hierarchical relationships between design objects using entities and hierarchies
- Worked on Security Access Manager (SAM) for creating roles and assigning users.
- Search/Extract Base Object data using SIF API from MDM Hub
- Define the list codes and code conversions between the source systems and the data mart.
- Worked with internal architects and, assisting in the development of current and target state data architectures.
- Reviewed daily compliance reports (CRD) and weekly audits, researching non-compliance issues and forwarding findings to Portfolio Managers for resolution
- Created business reports by joining multiple tables from multiples database using complex SQL queries.
- Created and manipulated datasets using SAS, Access, and Excel.
- Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
Environment: Windows XP Professional, Oracle9i, MS Access, Microsoft Office SharePoint, MS Excel, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, MS Office suite, MS Visio.
Business Analyst
Confidential - Ann Arbor, MI
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.
- Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
- Re-wrote the IBM Assembler version of the Average Cost Tax system as a set of COBOL programs. These programs calculate the tax owed on mutual funds transactions using an average cost basis.
- Created alerts against tableau dashboards and from different data sources using Metric Insights.
- Developed and Published Packages in Framework Manager
- Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
- Designed and developed Project document templates based on SDLC 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.
- Generated SQL queries to develop risk reports.
- 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.
Environment: Microsoft Office Suite, MS Visio, Windows, SQL, PLSQL, XML, VB, J2EE, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner.
Business Analyst
Confidential - Cedar Knolls, NJ
Responsibilities:
- Collaborated with the stakeholder and performed the requirement gathering through conducting workshops, interviews, JAD sessions, research and identified the business process for the implementations.
- Translated the business requirement into the functional and nonfunctional requirement documents and system requirement specification documents.
- Analyzed HIPAA 5010 related to 837(Claim),835(Payment & Remittance), 270, 271(Eligibility Enquiry response), 275 (Patient info),276 and 277(Claim Status Enquiry & Response) transactions and performed Gap Analysis between the 4010 and 5010 to improve and implement enterprise solutions to ensure compliance.
- Designed and developed Use Cases, Sequence Diagrams, Activity Diagrams, OOD (Object oriented Design) using Rational Rose and MS Visio.
- Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
- Designed and develops the logical and physical data models to support the Data Marts and the Data Warehouse.
- Performed Data Profiling of the current state of data in the Data Warehouse by doing Data Analysis using SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.
- Worked with ETL QA team to plan and create complete test cases, test plans, test data, and reporting status to ensure all the business requirements are successfully tested.
Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), HIPAA, ETL, Informatica, Rally, Jira, Agile, Windows XP/2000, Oracle, PL/SQL, MySQL, MS-Project, MS-Office Suite, MS Visio, MS Word, MS Excel
Business Analyst
Confidential - Richardson, TX
Responsibilities:
- Worked according to the activities/roles laid down in each phase of software development life cycle created using Agile.
- Assisted technical teams in creating ER Diagrams and Data mapping; wrote complex SQL Queries for Data Analysis; well versed with Data Modeling, Data Flow diagrams, System Architecture, User-Interface design, Data Warehouse, RDBMS.
- Gathered data from the legacy system (db2) to the present updated system using data warehouse tools such as Informatica.
- Based on the physical model, developed strategies for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
- Involved in gap analysis in changing old EDI and testing new EDI.
- Working within a growing knowledge of X12 5010 HIPAA 837 I, P, D, 835, 834, 820, 270, 271, 276, 277, 278, EDI, Privacy, Security, and Medicaid.
- Responsible for developing Front end edits for claims adjudication
- Involved in UAT of Medicaid client server claims processing system, Medicaid MCC / MCO and Medicaid Management Information System (MMIS)
- Worked on EDI transaction 835 to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
- Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
- Applied AGILE methodology with its various workflows, artifacts and activities to manage life cycle.
- 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.
- Prepared a Project Charter and a detailed Business Requirements Documents (BRD).
- Developed Use Cases in Microsoft Visio along with Activity Diagram to present the workflow in a visual form.
- Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
- Developed test cases and scripts based on business requirements for the functional, User Acceptance, Performance, Integration testing, System Back-end Testing and End-To-End testing.
- Interacted with the users and logged any defects, enhancements from the UAT and communicated them to the development team
Environment: AGILE, UML, Word, Excel, PowerPoint, SQL, Project, Visio, SharePoint, HP Quality Center, JIRA
Business Analyst
Confidential
Responsibilities:
- Involved in business analysis, requirement gathering, conducting requirement review meetings, addressing budget issues, creating functional requirement documents and creating test plans according to the business requirements.
- Identified and communicated points of conflict to the appropriate parties; proposed and outlined action plans for resolution.
- Manually executed test cases in Quality Center and ALM.
- Performed regression testing in UAT environment.
- Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
- Prepared Software Requirement Specifications (SRS) and was involved in the preparation of the Functional Requirements Document (FRD)
- Followed the UML based methods using MS Visio to create Business flow diagrams and Use Case diagrams.
- Maintained status report of the testing had been conducted.
- Worked with the Project Manager on various Project Management activities like Resource Planning, Resource Request, keeping track of Project Status, Deadlines, and Issues, Environment Request, and Compliance Issues
- Responsible for Documentation in each phase of the SDLC
Environment: HP Quality Center/ALM, Informatica, Cognos, IBM DB2, TFS, Erwin, MS Excel, MS Word, MS Viso, Teradata, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, Windows.
Business Analyst
GrowMar, CA
Responsibilities:
- Requirements elicitation and documentation - creating BRD (Business Requirement Document), FSD (Functional Specification Document), user stories, use cases.
- Creating reports and presentations and other project management duties. Performing Gap Analysis. Finalizing and prioritizing the requirements-creating product backlog.
- Involved in creating Dashboards to view our success rate with our potential customers(in healthcare industry), reports generation to check the area in which our services are doing great as needed using Tableau Desktop and Tableau Server.
- Creating users, groups, projects, Data connections, settings as a tableau administrator.
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Documenting the functional specifications of complex web and mobile applications.
- Creating business proposals as per RFP with cost and effort estimation and technology suggestions.
- Conducting extensive market and industry research as necessary to support content creation for deliverables.
- Designing email and calling campaign for healthcare business
- Involved in client Relation Management/ E-Learning / E-marketing Activities (SEO/Link Building/Blogging/Social Book Marketing etc) / E-commerce domain.