We provide IT Staff Augmentation Services!

Business Analyst Resume

Southlake, TX

PROFESSIONAL SUMMARY:

  • Over 9 years of extensive thesis as Business Analyst and QA Analyst, with assignments related to different phases of SDLC involving in Project Management and Implementation, Planning and Scheduling, Requirement Gathering/Analysis, End to End Design, Testing (requirement traceability matrices, system and functionality) and Utilizing Quantitative and Qualitative Skills.
  • Defined configuration specifications and business analysis requirements
  • Performed quality assurance
  • Defined reporting and alerting requirements and knowledge of Benefits & Claims of health domain
  • Own and develop relationship with partners, working with them to optimize and enhance our integration
  • Help design, document and maintain system processes
  • Report on common sources of technical issues or questions and make recommendations to product team.
  • Analyzed the existing client's Payment Processing System and its integration with POS and other downstream systems to understand the Testing requirements
  • Communicate key insights and findings to product team
  • Research and analyze new software solutions whether it is for new modules or bolt - on’s, and present such findings to the pertinent business and IT communities, like Demantra
  • Solid experience in using Black Box test methodologies, database and backend testing using SQL Queries, scripts, Functional testing, Component testing, System Integration testing (SIT), Performance testing, Regression testing, and User Acceptance testing(UAT)
  • Experience in developing, updating and documenting Business analyst artifacts to include Business Requirement Documents, User Stories, Use Cases, RACI Matrixes.
  • Develop sales, late fees reports for South East region from flat file data, Oracle, MySql and MS SQL Server data. Tools used for reporting Tableau Desktop, QlikSense, SSRS,microstrategy
  • Proficient in leading Requirements Gathering process via different elicitation techniques such as Client Interviewing, Requirements Workshops, Interface Analysis, Prototyping, Survey/Questionnaire, Focus Groups, Job Shadowing, Document Analysis.
  • Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA Team in executing Test Plans&, Test Case scenarios.
  • Extensively used SharePoint during all the phases of SDLC and PLM, like initiation, design, requirement gathering, development and testing phases of Project.
  • Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD),Business document, Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
  • Knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Designed, developed and maintain cognos reporting solutions and PowerPlay (OLAP cube reporting) both for client and web versions of software.
  • Design & create documents for blueprint design, FRICEW in support of relevant TPM functions for business process.
  • Responsible for coordinating the manual end-to-end and UAT testing efforts for new release testing, environment and calendar set-up, planning, and coordination with other ET/QC groups for all applications that interacted with CPC, Siebel v7.5, and POS applications
  • Expertise in broad range of technologies, including business process tools such as Sybase Power Designer, MS Excel (Pivot table, v-look up), MS Access, MS Visio,iGrafx technical assessment tools, Microstrategy Data Warehouse Data Modeling and Design.
  • Perform business process reengineering by documenting current state and defining the to-be state/future state with the aid of GAP analysis.
  • Providing comprehensive enterprise level support across multiple applications, including the completion of development and maintenance activities within a fast paced and demanding working environment
  • Experience in tools like Rally, Jira, VersionOne, Jama Contour, TM1 and Rational Requirements Composer for requirements gathering and managing.
  • Experience in creating Tables, Procedures, Functions, Views and other database objects using SQL and PL/SQL and knowledge of Benefits & Claims .
  • Smoke test cases, High Regression Test cases and SCER related Test cases are automated to save manual and knowledge of Benefits & Claims of health domain projects .
  • Create and design data model, levels, worksheets, series, workflows and user security in Demantratro meet the business requirement
  • Build critical Business Excellence competencies and embed lean techniques in daily business management
  • Experienced in Functional Test data management, bug tracking and test execution tracking with the help of the Team Foundation Server (TFS), Visual Studio Team Foundation (VSTF).
  • Experience in writing complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
  • Involved in creating TFS Database Backup Schedules and TFS Disaster Recovery Plan.
  • Working Knowldege of Lean Six Sigma Principles
  • Experience in developing Requirement Traceability Matrix (RTM), conducting SWOT analysis, GAP analysis, Cost Benefit analysis, User Acceptance Testing (UAT) and ROI Analysis.
  • Excellent communication, interpersonal skills. Quick learner, versatile, adaptable and process -oriented with high customer orientation.

TECHNICAL SKILLS:

Programming Languages: C, C#, Java, SQL, PL/SQL,XML,API,XSD,.NET

Data Base: SQL Server, My SQL, Oracle, MS-Access

Operating Systems: MS-DOS, Windows98/NT/2000/XP/Vista/7/8

Modeling Tools: MS Visio, Rational Rose, Rational Clear case, Rational Requisite Pro

Reporting Tools: Crystal Reports, SSRS, SSIS

Bug Tracking Tools: Quality Center, Rational Clear Quest

Processes/Technologies: Rational Unified Process (RUP), Waterfall, Agile

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop, Axure, Adobe AEM.

Business Skills: Business Definition Requirements, Business Process Analysis & Research, Use Case Modeling & Analysis, Technical Requirements Development, JAD/RAD Sessions, Requirements Gathering, Gap Analysis and Impact analysis

Business/Technical Documentation: Business Case Development, Process Flows & Navigation Maps, Wire frames / Storyboards, Test Plans, Test Scripts & Test Cases, Usability Analysis

PROFESSIONAL EXPERIENCE:

Confidential, SouthLake, TX

Business analyst

Responsibilities:

  • CIS has helpdesk Information management system where all service requests are logged, based on the priority I have created User Stories and Test Scenarios
  • Crated user story templates and trained team on the user story adoption process
  • As a Business Analyst/ Data Analyst used Agile SCRUM process and managed the sprint planning, backlog grooming, daily standups, communication. Applied ATDD to further streamline requirements and delivery process.
  • Writing & documenting Business Plan, Requirements Document, Functional Specification Document, and Test Case.
  • Installed and Configured SQL Server 2008/2012/2014/2016 and knowledge of Benefits & Claims of health
  • Maintain network hardware (wired and wireless) and software in a small business environment
  • Worked closely with end users and development team to understand the POS process
  • Creation, implementation and standardization of lean Six Sigma performing statistical analyses, creating/run models to predict quality and performance.
  • Defined testing strategy, end-user training plan and managed user acceptance testing for POS and E-commerce team in web based J2EE, JCL and scheduler.
  • Responsible for maintaining SQL Server security and granting access to users as per requirement and database security policies, procedures.
  • Created Test templates needed, create test scenarios and created test cases
  • Created test scenarios and excuted test cases, tracked through test execution phase for failed test cases logged defects worked with team for resolution as need.
  • Assisted my Project Manager in coming out with a detailed Project Plan, Timeline, and a high level resource allocation and planning.
  • Created reports using SQL Server 2008(SSRS),cognos 10.1.1 and integrated into the web front end.
  • Collect the future Data Growth and History information and share along with the DBA's.
  • Relational Database OLTP Data Modeling Development.
  • Prepared test plans, and designed and prepared test data scripts for testing POS and E-commerce application
  • Monitor change control for front end changes, and ad-hoc and web accessible reports using Excel, JIRA, and TFS (Team Foundation Server).
  • Led the successful implementation of Demantra for Demand Forecasting and S&OP which included Territory Sales, Business Units-Planning and Finance.
  • Validating MEC (Month end closing) process of Funding &Trade Accrual posted successfully to TPM & ECC respectively.
  • Used Microsoft Management Studio to query several enterprise dB\'s to extract data using SQL statements/queries.
  • Reporting tools used Tableau, Qlik Sense,microstragegy and microsoftPower BI. Report tools data source is SQL Server 2012 DataWhse/DataMarts tables
  • Extensively interacted with the data/business analyst to understand the user requirement and the business logic in IDPS, EVMS, RTN Six Sigma methodology
  • Designing test Scenario's and Test cases based on use cases
  • Closely interacted with business users, Team Leads, Supervisors, and SME’s, Stakeholders and gathered business requirements and capabilities
  • Collaborate with leadership to develop a plant Continuous Improvement Roadmap, bridging business metrics gaps with either Just Do It improvements, Six Sigma projects, IDPS, EVMS, Lean Implementation projects .
  • Led Demantra upgrade to the latest version 7.3 to improve the user experince and performance.
  • Created needed artifacts for business process, meeting minutes and uploaded in the SharePoint for Collaboration with the Project Team.

Environment: cognos 10.2 FP2 Suite (cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio& Administration), Transformer, Oracle 11g, MDX,E SQL Server 2005, Toad 11.1,Windows 7/ XP

Confidential, Dallas, TX

Business analyst

Responsibilities:

  • Assisted my Project Manager in coming out with a detailed Project Plan, Timeline, and a high level resource allocation and planning.
  • As a Business Analyst/ Data Analyst used Agile SCRUM process and managed the sprint planning, backlog grooming, daily standups, communication. Applied ATDD to further streamline requirements and delivery process.
  • Expertise in managing project on store application including designing, developing and testing Retail ‘Point of Sales’, Fuel POS, Self-Checkout and Web Based applications, with excellent testing flare.
  • Developed Simple to complex map reduce Jobs using Hive and Pig
  • Helped the team in identifying and documenting the Risks, Issues, and Dependencies in a dashboard and tracked the status after assigning ownership and target dates.
  • Closely interacted with business users, Team Leads, Supervisors, and SME’s, Stakeholders and gathered business requirements and capabilities.
  • Experienced in documentation of the meeting minutes and upload in the SharePoint for Collaboration with the Project Team.
  • Involved in Supporting a custom Demand Side Management (DSM) web application integrated system solution .
  • Wrote the test script for mobile E-commerce and POS applications
  • Training users on installing and generating reports in excel, word, power point using cognos for Microsoft (Go Office 8)
  • Generated on-demand and scheduled reports in IS teams for business analysis or managementdecision using SQL Server Reporting Services.
  • Loaded the data into database tables using SQL loader from text and excel files. Involved in developing data model, SQL Queries, SQL Query tuning process and Schemas.
  • Involved in creating TFS Database Backup Schedules and create TFS Disaster Recovery Plan.
  • Conducted a thorough AS-IS analysis of the present processes, systems, and organisational aspects and identified potential pain points and high level business needs.
  • Involved in Developing Webpages by using HTML5, CSS3, JQuery, CMS, JavaScript and working knowledge of Node JS, bootstrap.js, Angular.js and various adobe analytic tools.
  • Defect Management using Visuat Studio Team Foundation (VSTF).
  • Test Case Automation in Visual Studio Team Foundation (VSTF) through Coded UI.
  • Extensive experience in Web services (As Provider) design and development using SOAP and HTTP nodes.
  • Wrote Business Requirements Document (BRD), Functional Requirements (FRD) and Non Functional Requirements (NFD) Systems Specifications (SSD) and documented them in the Requirements Traceability Matrix (RTM).
  • Assisted the team in testing approach, test data identification, and scenario review activities and acted as a single point of contact for all of their clarifications on business and functional aspects of the system.
  • Created Dashboard reports using cognos Insight in comparison with Qlikview
  • Implemented Web services message flow using SOAP nodes in IBM Integration Bus using Message broker. Developed message flows for content based routing of messages. Responsible for aggregation and http nodes in calling external web services.
  • Acted as a systems liaison, and facilitated efficient delivery and flow of deliverables like BRD, SSD, and Use Cases in the End to End Systems Development Lifecycle.
  • Collaborated with the testing partners and acted as an integral part of the Test Strategy formulation, Test Cases translation, and Test Scripts Review.
  • Reviewed functional and business requirements and created Test plan and Test cases.
  • Led the team for preparing the end user training manuals, Knowledge Management, and devised a project plan for post-production support for the business users.
  • Ensured all artifacts complied with corporate SDLC, PLM Policies and guidelines.
  • Provided procedure manuals for accounting system applications.
  • Working experience on service now tool like service catalog requests, Asset Management, Configuration management, Service-Now Administration, Incident and problem management, Knowledge management, Reporting, Integration and Web services.
  • Did integration for service now with BMC remedy tool for importing the data required for application development.
  • Involved in a team that administered MQ, Message broker in Development and test environments.
  • Experienced in the analysis, development and automation of various ITSM processes including Incident Management, Change Management, Asset Management, Service Request, Configuration.
  • Reviewed completed application enhancements and QA test results to ensure that they meet business requirements.

Environment: /Tools:cognos 10.1(cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio),cognos Transformer, SQL Server2005, Windows 2003 Server, IIS, Informatica

Confidential, Seattle, WA

Business Systems Analyst

Responsibilities:

  • Worked closely with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
  • Conducted and controlled brainstorming sessions with project focus groups.
  • Conducted analysis on business needs, critical success factor.
  • Involved mainly in GAP analysis and Data mapping.
  • Worked with the systems architects in designing the system, flows etc.
  • Documented High Level Design (HLD) and Low Level Design (LLD) Documents to define the system rules by creating Use cases, interface designs etc.
  • Designed wireframes and screen mockups to explain in details the business implication.
  • Created ad roc reports for the business management and following Indentity management.
  • Interfaces in and out of Telecom System CIS along with business.
  • Created Use Case diagram, activity diagrams, sequence diagram in MS Visio.
  • Determined proper File Directory group membership according to user role and access requirements.
  • Communicated on a regular basis with the BPM Project Manager and BPM analyst during different stages of the project.
  • Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
  • Analyzed and prioritized user and business requirements as system requirement that must be included while developing the software.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Documented defects/Frequently asked questions to client Amadeus using SharePoint
  • Provided workflows for change management in service now.
  • Involved in creating the Project templates, Use case specifications, Change request form.
  • Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, Object Oriented models using MS Visio .
  • Develop/modify TFS custom controls applications using C#, CMS, Visual Studio.NET 2013.
  • Establish and maintain customer relationship, time management, territory management, conduct weekly meetings. Involved in high level and low level transactions. Worked with the database design team to assist them in designing the database and also created data dictionary. Worked with accounting system staff.
  • Retrofitted processes and customizations previously implemented in the Oracle 11i EBS to function seamlessly within the upgraded R12 environment.
  • Involved in Implementing and Customizing Manage Access and Manage Identity modules as per customer requirements in SailPoint IIQ 7.0.
  • Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using SQL
  • Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.

Environment: Microsoft Office Suite 2007, MS Visio, MS Excel (Macro),Informatica, TOAD, HP Quality Center, Adobe AEM, SQL Server Management Studio 2005/2008, MS SharePoint.

Confidential, Seattle, WA

Quality Assurance Analyst / Sr Tester

Responsibilities:

  • Reviewed business requirements and specifications and understand the scope of the applications (Pay My Bill, Promotion programs, Notifications etc..)
  • Developed Test Plans, Test Cases and Test scenarios to map Integration Testing, system testing and User acceptance Testing using Business requirements and design documents.
  • Since it was agile methodology, I was actively involved and attended various JAD sessions and constantly interacted with business and development team.
  • Tracked, Managed and documented problems during UAT.
  • Co-ordinated with Off-Shore testing team. Conducted Functionality and Regression testing during the various phases of the product
  • Involved in both Back-End and Front-End testing.
  • Involved in daily stand-up meetings.
  • Used Agile Methodology
  • Interacted with Business Analysts to review the UAT / Functional Testing.
  • SOA implementation is combination of web services components and mid-tier components. SOA-Service oriented modeling Architecture principles using tools to model business process, workflow and service objects (object oriented design) and with integration technologies, including XML, XSD, and SOAP And WSDL.
  • Involved in preparing RTM (Requirements Traceability Matrix) with Visual Studio Management tool based on Test cases and procedures in order to track the business requirements which were met.
  • SOA integration is presented in each layer of service based, message based and transport based.
  • Detected and managed defects, and assigned to developers using Mercury Quality center.
  • Performed Regression testing and unit testing in various environments.
  • Validated the Data with SQL queries from Front end to back end Tables in Oracle Database and SQL server DB.
  • Participated in scheduled meetings with Development team and Business Analysts.
  • Monitored and Tracked High priority Defects and production issues on day to day basis.
  • Analyzing the Requirements from the client and created test plans
  • Preparing Test Scenarios and Test Cases for module, integration and system testing
  • Preparing Test Data’s for the test cases
  • Preparing Test Environment to execute the test cases
  • Analyzing the Test Cases prepared by other team members
  • Executing the Test Cases and logging bugs for failed test cases
  • Defect Tracking
  • Giving mandatory information of a defect to developers in order to fix it
  • Preparing Summary Reports
  • Preparing Lesson Learnt documents from the previous project testing experience
  • Preparing Suggestion Documents to improve the quality of the application
  • Communication with the Test Lead / Test Manager
  • Conducting Review Meetings within the Team

Hire Now