We provide IT Staff Augmentation Services!

Business Systems Analyst/ Qa Engineer Resume

Eden Prairie, MN

PROFESSIONAL SUMMARY:

  • Around 5 years of comprehensive experience as a BA/QA in Pharmaceutical and Health Care organizations along with contact center environment.
  • Good understanding of software development life cycle, including planning, analysis, design, development, testing and implementation of software applications.
  • Well versed in different types of methodologies includes Agile, Agile Scrum, Waterfall and RUP methods.
  • Experience in analysis, requirements - gathering, documentation and leading efforts for application development projects.
  • Transformed business needs of users and stakeholders into functional requirements.
  • Advance proficiency on Database Management systems such as SQL database & Sybase.
  • Experience in conducting JAD sessions, Scrum sessions.
  • Expert at analyzing, designing, and reengineering systems applications and business processes
  • Created technical specifications and test scripts based on use cases.
  • Communicated effectively and in a timely manner to the project lead, technical lead, business partners/ stakeholders, clients and management throughout the life of the project.
  • Worked with teams to examine and solve business problems by accurately analyzing the requirements of the clients and helping them achieve improved quality and value to the customers.
  • Adapt at reducing development costs and providing traceability of projects.
  • Familiar with MS Project to manage schedules, deadlines, resources, collaborate with different teams, and analyze project information.
  • Experience on Agile approaches like Kanban, Scaled Agile (SAFe), Crystal, FDD and agile tool JIRA.
  • Responsible for project time tracking, status reports, updates, and related project administration tasks.
  • Possess good understanding of different relational databases, writing SQL queries, creating tables, and generating reports.
  • Manages large and important projects affecting business units across the Company.
  • Experienced in Tracking Defects and Creating reports using JIRA, Quality Center and ALM (Application Lifecycle Management)
  • Expertise knowledge in the Automation testing tool Selenium.
  • Hands on experience on Avaya CMS & Avaya site Administration software.
  • Create Custom Agent reports from the ACD (Avaya via ODBC) Microsoft Excel including but not limited to call data, Adherence data and Quality data for Agent KPI's and Minimum Performance Standards (MPS).
  • Monitor queues via CMS Avaya Supervisor; customer hold times, and representative availability, helping to ensure a proactive customer experience and timely communication and escalation of service quality metrics and the call routing balance.
  • Designing Contact Center Call Routing and Dial Plans/IVR routing tables
  • Good team player with strong analytical, reasoning, communication, research and problem solving skills.
  • Exceptional listener and communicator who effectively conveys information verbally and in writing.
  • Ability to handle simultaneous projects, meet critical deadlines and timely execution of several projects.

TECHNICAL SKILLS:

Methodologies: Agile Scrum, Waterfall

Work & Resource Management: Plan View, Clarity Tool, SharePoint

Customer Relationship Management: Veeva CRM, Salesforce.com

DBMS / RDBMS: MySql Server, Big Data, Teradata, Oracle, Excel

Business Modeling Tools: MS Visio, Rational Requisite Pro

Defect Testing Tools: HP ALM, Quality Center, JIRA, Selenium

Web Technology: PHP, HTML, R, XML, UML

Office Tools: MS Excel, MS Word, MS PowerPoint, MS Project

Reporting: Tableau, SQL BI, Cognos

PROFESSIONAL EXPERIENCE:

Business Systems Analyst/ QA Engineer

Confidential, Eden Prairie, MN

Responsibilities:

  • Gathering and Documenting Requirements for Reporting or Data Requests
  • Responsible for communicating with primary stakeholders and leadership in Work Force Management (WFM)
  • Creating and maintained the Requirements Traceability Matrix (RTM).
  • Researching issues or solutions using SQL Server Management Studio (SSMS).
  • Utilizing Tableau visual analytics and best practices like performance improvement, dashboard structure, view orientation, sizing and layout, data emphasis, highlighting, color, fonts, tooltips, and of complex dashboards/reports.
  • Developing cross tab, chart, line, and drill down through worksheets in Tableau.
  • Working with RITE application (internal application for ERA) to create user stories.
  • Worked as both Solution Analyst and developer to develop reports in SSRS.
  • Created test plans and facilitated UAT testing.

Environment: HIPAA, Tableau 10.5, Rally, SharePoint, SQL Server, SSRS, MS Excel, UAT, XML, RITE.

Business Systems Analyst/ QA Engineer

Confidential, St Louis, MO

Responsibilities:

  • Create complex SQL Queries for stored procedures, triggers, views, constraints and user defined functions to implement the business logic.
  • Code optimization for batch jobs to load data into Facet Database.
  • Developed user stories to automate Legal Records Management workflow
  • Worked with stakeholders as a distributed product owner to develop project backlog with use cases
  • Created user stories, acceptance criteria, and enhancement requests, along with user testing plans, prototypes, and other design artifacts across several simultaneous large-scale projects
  • Draft and maintain business requirements and align them with functional and technical requirements.
  • Using chart-in plugging wrote the JQL and filtered the Time in response status in JIRA.
  • Developing Dashboards in JIRA using gadgets to track the issues.
  • Works with outside organizations and business partners to coordinate cross-team dependencies in order to meet product objectives.
  • Creating and maintained the Requirements Traceability Matrix (RTM).
  • Used to write SQL queries & pull the data from FACETS front end. Writing Stored Procedures in SQL server.
  • Utilizing Tableau visual analytics and best practices like performance improvement, dashboard structure, view orientation, sizing and layout, data emphasis, highlighting, color, fonts, tooltips, and of complex dashboards/reports.
  • Developing cross tab, chart, line, and drill down through worksheets in Tableau.
  • Working with Trizetto Communication System tool to configure CMS letters in Facets.
  • Creating XML documents for embedding data into TCS tool to create placeholders.

Environment: HIPAA, FACETS 5.4/5.5, Tableau 10.3, JIRA, SharePoint, workday, SQL Server, MS Excel, TCS tool, UAT, XML, SAFe, Agile SCRUM.

Business Analyst/ Facets Tester

Confidential, Washington D.C

Responsibilities:

  • Performed requirements elicitation and requirement analysis including data analysis and GAP analysis.
  • Acted as the primary liaison between the business stakeholders and technical teams to make communication and development efforts more effective.
  • Owning the reporting section of the service operations.
  • Developed documentation on data elements, definitions and mapping.
  • Worked with reporting teams to educate about the new data model and data available to facilitate their reporting.
  • Tested the data feed for data validity for reporting team.
  • Analyzed the requirements for integrating key systems with Salesforce.
  • Manage the analysis, design, development and implementation of custom EDI, XML and proprietary format maps/processes supporting consumer product items distributed to mass merchandise and department store customers and banks.
  • Conduct EDI Kick-off meetings when bringing on new customers with Sales, Purchasing and Operations teams.
  • Produce daily EDI production support documentation and provide 24/7 support.
  • Implemented SSIS packages for extract, transform and load (ETL) product data to SQL server
  • Collaborated with project managers and business users for gathering project requirements
  • Developed Stored Procedures, Database Triggers, Functions and Indexes to manipulate the database and to apply the business logic according to the requirements
  • Adapted UML standards to define modularized Data Process Models. Checked all inbound/outbound HIPPA regulated EDI transactions FACETS.
  • Conducted JAD / JAR and Elicitation sessions for user interviews to gather requirements.
  • Reviewed, analyzed and created detailed documentation of business systems and user needs, including workflow, program functions and steps required to develop or modify application programs.

Environment: HIPAA, Workflow, Data Modeling, Integration, Tableau 10.1, FACETS 5.4, Medicaid, Medicare, UAT, Agile, Testing, JIRA, Quality Center, HP ALM, EDI transactions, Agile Scrum, Informatica 8.6.

BUSINESS ANALYST

Confidential, Princeton, NJ

Responsibilities:

  • Worked as SFDC Business Analyst/Product Owner for the Sales and Marketing Team of the second largest waste management company in the Confidential .
  • Acted as a SPOC for supporting the key CRM initiatives of National and Municipality Salesforce user groups within Republic.
  • Work with various business units to gather and document requirements for self-service IVR applications and contact center routing.
  • Performed administration and configuration of Avaya System Manager as part of the project.
  • Created custom reporting using Excel in conjunction with Avaya Contact Center Management.
  • Designed and developed project documentation using MS Office.
  • Experienced in working with both Salesforce Sales Cloud and Service Cloud.
  • Worked on various standard Salesforce objects like Accounts, Opportunities, Campaigns, Leads, Contacts, Cases, Reports and Dashboards.
  • Created and used Salesforce Email templates in HTML and Text formats.

Environment: Avaya Call Management System (CMS), Salesforce.com, IVR applications, MS Office tools, HTML

BUSINESS ANALYST

Confidential

Responsibilities:

  • Conducted one-on-one meetings with the project SMEs to gather the requirements.
  • Facilitated sessions with users and documented the change requests in the Change Request Form.
  • Facilitated business requirements gathering sessions with the business users, and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using MS Visio.
  • Created Use Cases and Business Requirement Document after accessing the status and scope of the project and understanding the business processes.
  • Articulated business requirements from user interviews and converted requirements into system requirements.
  • Conducted JAD sessions with end user community ensuring that the software addressed all business needs.
  • Clarified client requirements, business needs and project objectives via feedback sessions and client meetings in collaboration with all stakeholders.
  • Critically evaluated the information gathered from multiple sources, reconciled conflicts, and decomposed high level information into details to gain an understanding of the end-to end solution.
  • Create recursive jobs in SQL Server Agent to run multiple SSIS packages, T-SQL procedures and scripts.
  • Created Data driven Tabular, Drill-down, Charts, Aggregate reports using SSRS Report Builder
  • Fine-tuned SQL Queries for maximum efficiency and performance.
  • Collaborated with the QA team in reviewing and validating Test Plans and Test Cases, ensuring that the final application catered to the user requirements.
  • Performed requirement walkthroughs with the development and QA teams with the aim to develop Testing Strategies and Test Plans such that Test Cases reflect user needs.

Environment: MS Office tools, SQL, Agile, Waterfall, UAT, MS Project, MS Visio, UML, RUP, and MS Windows.

Hire Now