Senior Technical Business Analyst Resume
Dayton, OhiO
SUMMARY
- Eight plus years of experience as Technical Business Analyst/ Quality Assurance Analyst/ Accessibility Analyst/ UAT Analyst in Health care and E - commerce Domain
- Experience leading cross-functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals
- Experience supporting business solution software and analyzing business operation
- Strong Prioritization skills and analytical ability to achieve the goals of the company
- Analyze client’s business requirements and processes through document analysis, interviews, workshops, Joint Application Design Sessions and workflow analysis
- Communicate client’s requirements by constructing easy to understand data models
- Effective listening, critical thinking, problem solving and relationship building skills
- Perform Gap analysis to identify what needs to be done in a project to achieve goal
- Worked on Data migration, Data Mapping, Facets version upgrades, QNXT, Facets Configuration
- Prepared Test Plan, Effort Estimation and Regression Checklist
- Experience working on Agile Teams utilizing iterative and incremental engineering and Agile Methodologies including Kanban
- Experience in planning execution of Quality process with coordination of Project managers, team members, product owners, developers and business stakeholders
- Performed Defect reporting and tracking through the entire defect life cycle. Expertise in using defect-reporting tools like Team Foundation Server (TFS), Quality Center (QC), Jira
- Experience in backend database testing using Oracle, MySQL, Teradata, Toad, SSMS
- Excellent understanding of System Development Life Cycle (SDLC), Testing Life Cycle
- Experience on leading the Section 508 testing (Compliance/ Accessibility)
- Experience in using Extract, Transform, Load (ETL) tools like SSIS and SSRS, Power BI
- Experience with Team Foundation Server, ALM for business requirement and testing
- Excellent communicator, being able to manage time efficiently in various tasks
- Ability to lead the team, to work as an efficient team player, learn the new technologies and handle the job responsibilities with minimal direction
- Experience in manual testing and automation testing using testing tools like Soap UI, Rest, HP Quality Center (QC), Team Foundation Server, Application Life Cycle Management (ALM), JIRA, QNXT, Autosys, Tidal, Wave, Jaws, Acc verify, NVDA, Zoom Text, Color
- Extensive experience in Functional, Smoke, Negative, Regression, System integration (SIT),Database, Browser, End to end, GUI, Data Driven, 508 compliance (Accessibility) t
- Experience with accessibility standards and regulations like WCAG 2.0, and Section 508
- Experience with different modules of QNXT and Facets
TECHNICAL SKILLS
- Requirements Gathering & Analysis, User Acceptance Testing (UAT), Project Management, Elicit Requirements, JAD, Interview, Brainstorming
- Decision Marking, Problem Solving, Team Player, Great Communication, Gap Analysis, Data Mapping, Detail Oriented, Documentation
- Organization, Enterprise Implementations, KPI Dashboards & Scorecards, Application Life Cycle Management (ALM 11.5), HP Quality Center
- FACETS, QNXT, SQL, SSIS, SSRS, SAS, Power BI, Team Foundation Server 2015 (TFS), Autosys, Tidal, Data Mining, Data Mapping
- Crosswalk, Analytics, Risk Management, BI, Microsoft Office Suites, Software Testing, Fire Eyes, Waves, GDAX, JAWS, NVDA, JIRA
- SOAP UI, Zoom Text, Window Eyes, Voice Over, IE Accessibility Checker, Agile, Waterfall, Kanban
PROFESSIONAL EXPERIENCE
Confidential, Dayton, Ohio
Senior Technical Business Analyst
Responsibilities:
- Participated in Product Owner Team meetings (POT /Sprint) to elicit Business Model
- Documented features and capabilities for Business Rules Engine.
- Configure Georgia Marketplace, OH DSNP products in Facets system
- Configuration in Medical Plan, Subscriber/Member, Claims Processing and Billing modules
- Test configuration through payment of electronic and manual claims
- Conducted brainstorming sessions with the business users and SMEs to elicit requirements and worked in the creation of Agile user stories and acceptance criteria documents
- Facilitated JAD sessions and interview business users to determine their needs
- Gathering requirements and preparing functional documents for Facets upgrade 4.60.
- Involved in Facets Output generation, Interface development and Facets Migration Projects
- Planning, coordinating and tracking project activities to meet documented requirements
- Recognize inconsistencies and gaps in a complex business process
- Work with business to develop a business case on any regulatory/compliance issues
- Document effectively in requirements discovery sessions and meetings
- Conduct data mining, data modeling, statistical analysis, business intelligence gathering, trending and benchmarking.
- Document all data mapping and transformation processes in the Functional Design documents based in the business requirements
- Authored agile stories and facilitated story grooming sessions for highest priority stories in agile product backlogs, in collaboration with IT, Product owners and stakeholders
- Facilitate scoping and requirements elicitation sessions for projects
- Develop the requirements phase plan and schedule, planning, resource and scope issues
- Coordinate release activities with the project team members
- Partnered with developers to automate manual processes to save time and money
- Collaborated with stakeholder groups across the organization to ensure alignment
- Proposed solutions meeting defined specifications and needs to the business
- Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations
- Excellent analytical ability, facilitative, accountable, strong leadership, interpersonal communication and judgment skills including teamwork, building relationship
- Created Product Backlog, Sprint Backlog and managed User stories.
- Led daily stand-up meetings on the absence of the Scrum master
- Create and document test cases for all documented requirements
- Facilitated the Sprint Review and Spring Planning Session at the end of the Sprint with all the team members and the business requestors
- Report, track and determine priority of reported bugs and work on daily QA activities
Environment: Team Foundation Server 2015 (TFS), TIDAL, Agile, Service Now, .NET, MS SQL Server, SSIS, SSMS, Tidal, SSRS, Power BI, Teradata, Facets, Microsoft Suites 2010, ALM 11.5, Service Now
Confidential
System Analyst Lead/ Business/ Quality Analyst
Responsibilities:
- Gathered the business requirements through interview, brainstorming and meetings
- Analyzed and documented the business requirements from internal stakeholders as well vendors
- Defining the “As Is” current process and “To be” future process clear and concise
- Provided ad-hoc reporting and dashboard for live reporting capabilities
- Designed and built statistical analysis models on large data sets through data mining
- Used data gathered to develop an understanding of customer behavior, demographics and lifecycle. Presented data that helped guide decisions of the company
- Identified gaps in the business process through different turnaround time and sessions
- Thorough understanding of business analysis principles and available solutions •
- Coordinated User Acceptance testing for new functionality that was enabled
- Mapped data elements between existing databases and proposed new ODS data elements
- Wrote SQL statements to query data for Data validation and Data quality
- Assist on test planning, test execution with UAT and QA testing
Environment: Agile, Team Foundation Server (TFS), MS SQL Server, HP ALM 11.5
Confidential
Technical Business Analyst/ Quality Analyst
Responsibilities:
- Work with the Facets Configuration Team to build over 500 new products
- Conduct Facets claims (837 P, 837 I, 837 D) testing
- Configure Kentucky Medicaid and Kentucky Marketplace products in Facets system
- Configuration in Medical Plan, Subscriber/Member, Claims Processing and Billing modules
- Test configuration through payment of electronic and manual claims
- Run Access queries against Facets tables to validate configuration and identify defects
- Run reports to validate configuration
- Work with the Facets Configuration Team to build over 500 new products
- Conduct Facets claims testing
- Run reports to validate configuration
- Configure Product Tables (Service ID’S, Service Payment, Service Rule)
- Configuration of benefits based on newly added policy and tested claims scenarios
- Revised incorrect configuration and run reports to validate configuration
Environment: Team Foundation Server 2015 (TFS), Facets, TIDAL, Agile, Service Now, .NET, MS SQL Server, SSIS, SSMS, Tidal, SSRS, Power BI, Teradata, Facets, Microsoft Suites 2010, ALM 11.5
Confidential
Senior Health Care Business Analyst/ Accessibility Analyst
Responsibilities:
- Successfully project managed and implemented new benefits application and service to replace the legacy benefit plan administrator
- Conducted business transforming sessions with the business users and SME’s to elicit requirements and worked in the creation of Agile user stories, acceptance criteria
- Designed and developed database models for the operational data store, data warehouse to support the client enterprise information management strategy
- Reporting analyst responsible for gathering the reporting requirements from the business, developing reports in SQL, adhoc reports and Power BI dashboards, SSRS reports presented to the business users
- Uses extensive Facets configuration, business knowledge, and effective communication skills to lead, facilitate, and elicit requirements for projects
- Assists with the analysis and documentation of current and future states, defining user requirements in the design of the future state workflows, to optimize system functionality
- Develops business process artifacts (configuration design documents, process flow, work state diagrams, etc.) as they pertain to enterprise-level processes, spanning multiple functional areas. Documents and implements configuration and process improvements and control documentation
- Reviews change requests to ensure consistency and compatibility to existing systems and procedures, including researching, validating, and resolving issues for accurate processing. Identifies, communicates, documents, and escalates information from all levels to leadership
- Troubleshoots configuration and technical issues, and identifies modifications needed to meet changing user and regulatory requirements
- Reviewed Business Requirements, Functional Specifications and Test Cases to understand the functional and technical requirements in order to prepare a QA test plan with test cases
- Documents all data mapping and data transformation processes through STM in the Functional Design Document based on the business requirements
- Hold and facilitate test plan, test case reviews with cross-functional team members
- Identified and report the testing results to the management to ensure the functionality are met
- Executed Teradata scripts in the database to verify and validate data transactions
- Documented defects with Visual Studio Team Foundation Server 2013 (TFS) for detailed description emphasizing the point of failure, steps to reproduce the error
- Provided technical supervision of test execution to outsourced testers
- Implemented with Trizetto QNXT core administration platform to automates and streamlines critical business functions such as claims processing, member enrollment, premium billing
- Identified the test scenarios and performed Web Services testing using Soap UI
- Good understanding and experience with different modules of QNXT
- Extensive involved on testing Section 508 compliance for the web applications
Environment: Team Foundation Server 2013, QNXT 5.20, Autosys, Informatica 9, Facets, Cognos, Agile, Rest, IE Chrome, Mozilla Firefox, Opera, SSRS, Power BI, Soap UI, Teradata,Window Eyes, Achecker
Confidential
Senior Health Care Business/ Quality/ Accessibility Analyst
Responsibilities:
- Used different adhoc analysis, the report assist in defining strategy for each customer category where Informatica is used for ETL process and business objects
- Design the EDI 270/271 configuration based on the business requirements or benefit grid.
- Detailed knowledge of Facets Configuration and able to perform EDI 270/271 within Facets system
- Supported the work to troubleshoot and resolve claims issues introduced by user, configuration, system or reporting errors; working multiple issues simultaneously
- Support activities to update configuration within the core claims processing system, typically within the areas of Provider, Pricing or Benefit Plan/Adjudication Rules.
- Updated the credentialing variables and demographics (credentialed and non-credentialed providers), contract or fee schedule assignment and network affiliation
- Successfully used Agile/ Scrum methodologies, performed roles of Scrum Master and used excel extensively to write user stories and reviewed the defects with the team
- Facilitated the JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted
- Excellent experienced in data extraction, transformation and loading ETL using various tools such as SQL Server Integration Services (SSIS)
- Reviewed data dictionaries, STM document, Data Model based on the requirement document
- Responsible for system testing data warehouse ETL processes on platforms on Teradata
- Lead a testing team of 4 people including employees, across multiple time zone and locations
- Ensure quality standards and principles are used throughout the development lifecycle
- Lead and participate in a variety of quality assurance reviews on requirements, system design
- Provide quality assurance estimates for resource and project planning purposes
- Create test data and maintain regression test suites
- Support, follow up and troubleshoot the issues found by the QA offshore team
- Execute test suites, analyze and report results through QTP, Soap UI, Rest, Jaws
- Identify, track, and follow through on issues and defects with QC, ALM
- Testing commercial web applications and supporting backend systems
Environment: Waterfall, Agile SOAP UI, Rest, Jaws, NVDA, Facets, Color Contrast Analyzer, ALM, Bugzilla, JavaScript, Angular, HTML, MS Office, Windows 7, J2EE, MYSQL, SQL Server, IE 11, Firefox