Senior Business Analyst Resume
CincinnatI
PROFILE:
- Have over 9 Years of experience as a Business Analyst with Quality Assurance, Testing and Text Mining in Manufacturing, Content Management, Banking and Mortgage applications
- 4 Years of onsite experience as a Senior Business Analyst
- Proficient in Software Development Life Cycle and QA Methodologies
- Strong experience in Agile Methodology
- Worked as a liaison between business stakeholders and development team to gather and communicate requirements
- Adept at clearly defining business requirement documents
- Good experience in business process analysis, process modeling and mapping documents
- Document artifacts that provide end to end workflows to clearly define business functionality
- Strong experience in manual testing of Client - Server applications, Web applications and applications linked to Database Systems
- Proficient in creating effective Test Plan, Test Documents for features and stories based on FRS and SRS
- Proficient in Installation, Smoke, Functional, Regression, User Acceptance, Recovery, Compatibility, Reliability and Reference application testing
- Experience in Installation testing of client components in UI and Silent mode on different operating systems
- Experience in automating test cases using NUnit, QTP and Web Services testing using SoapUI
- Experience in using Rational Pure Coverage Tool for code coverage
- Expertise in Web applications testing by using FTP, SMTP, DB, JMS and Web Services in design and run time
- Experience in testing integration of Configuration Management Tools ClearCase and Perforce with client products
- Good experience in back-end testing using SQL queries and ETL Testing
- Good experience in testing Remote Commands using SECSIM Pro+ based on Factory Automation Standards
- Proficient in creating clear and concise test summary and defect reports for every release for client product review meetings
- Good experience in direct customer interaction and escalation management
- Served as Defect Prevention Analyst to the project and implemented best practices to improve the process
- Strong customer relationship, team building, and organizational skills
TECHNICAL EXPERTISE:
Front-End Tools: MS Office, MS Visio, MS Access
Testing Tools: Clarabridge, QTP 9.0, NUnit 2.4.8, Rational Pure Coverage v7.0, SoapUI
Operating Systems: Windows 2000/03/XP/NT/7
Networking & protocols: FTP, HTTP and SMTP
Web/App Servers: Apache Tomcat 7.0
Languages: SQL, C#.Net
Defect Tracking Tools: HP Quality Center 9.2, JIRA 6.0, iNotion, RTC, ServiceNow
Configuration Management Tools: ClearCase, Perforce
PROFESSIONAL EXPERIENCE:
Confidential, Cincinnati
Senior Business Analyst
Responsibilities:
- Managing over 12 Card campaigns in Project Place
- Gathering the requirements for various card campaigns like balance transfer, pre-approval, income capture, credit limit increase etc. from marketing line of business.
- Document the business requirements based on MPPs, test plan, test design and business inputs
- Acts as a liaison between marketing LOB, Development team, QA, email and direct mail vendors, Decision science group and Digital team for both inbound and outbound campaigns
- Research on data for the new campaigns based on LOB inputs
- Organizing daily standup meetings and ensure that deliverables are on schedule
- Weekly card campaigns dashboard update to the execution partners
- Prepared presentations on detailed campaign process to higher management
- Prepared monthly and yearly card campaign schedules for the whole year based on MPPs and LOB inputs
- Created level of effort (LOE) estimated hours for development, email and mail vendors for the campaigns to be automated.
Environment: SAS, AQT, MS Visio, MS Excel, Pega, Project Place, Plan View
Confidential, Cincinnati
Test Lead - SQL Testing
Responsibilities:
- Validated the migration of data from Netezza to MapR in production environment on huge amount of data
- Testing of database columns in MapR are migrated as per the Netezza data
- Created temporary tables with the required columns from Netezza and exported data to tsv files to compare with MapR data using joins between tables
- Calculated the percentage of discrepancy records between MapR and Netezza
- Ticket submission and updating the test results in Asana
- Tracked the tickets in testing bucket and reported the progress to the director on weekly basis
Environment: Netezza, Drill, Hive, DBeaver, MS Excel, Asana
Confidential, San Antonio
Senior Business Analyst
Responsibilities:
- Interview with SMEs for requirements elicitation for Doubly Stochastic Short Term Forecasting model
- Created AS-IS Process flow diagrams
- Validation of process flows with SMEs
- Documented data lineage for Doubly Stochastic Model
- Analyzed gaps and pain points in the model
- Documented Forecasting outputs comparison process flow and test data flow diagrams
- Tested and compared huge volume of Contact Center data collected from various source systems
- Automated data comparison of forecasted and actual Call Volumes, Average Handling Times for 30mins interval on a particular date for current CCM and Doubly Stochastic models using Access DB
- Tested data comparison and created various interactive reports and graphs
- Drafted recommendations for TO-BE process
- Supported ETL testing activities for the IAM project
- Involved in preparation of test cases and creation of technical specification documents for the source systems
- Engaged in Testing Datastage jobs for the different source systems
Environment: Access DB, MS Excel (V Lookup), MS Visio, MS Power Point, Datastage, SQL
Confidential, San Antonio
Senior Business Analyst
Responsibilities:
- Led Mortgage Cadence Production support team
- Good knowledge in Mortgage Cadence- Loan Origination System
- Triaged reported business issues and identified defect/Gap/Enhancement
- Requirements gathering for Cadence application enhancements
- Created stories, tasks and defects in RTC
- Analyzed Bank ICE ideas and identified which require IT changes or Process Improvements
- Identified the size of the effort and the application where the ICE idea has to be implemented
- Interaction with Innovators for further analysis
- Created test scenarios for Federal Income Tax Calculator
- Led the team for testing
Environment: Mortgage Cadence, RTC, ServiceNow
Confidential, San Antonio
Business Analyst
Responsibilities:
- Worked with DPO and created intent document as per the business requirements
- Analyzed social media data and built 37 category groups, categories and touch points under Products and Services, Life Events with an accuracy of 80 percent
- Built common filters across all categories such as Jobs, Retweets, Advertisements, Unhappy Confidential members
- Performed fine tuning and several self-audits
- Participated in peer, tech team and business audits
- Facilitated daily standups, retrospective and big room planning meetings
- Updated wiki on regular basis about the categories rules
Environment: Clarabridge, MS Word, MS Excel, RTC, Radian6
Confidential, San Antonio
Business Analyst & QA Lead
Responsibilities:
- Gathered requirements for about 45 business areas
- Led the team for Requirements Gathering for FSB Front Door and Workload Management Tool
- Led meetings with Business Users and Sponsors for Requirements Gathering
- Created AS-IS and TO-BE Process Flows describing for all Business Areas
- Created swim lanes for the process flows
- Created mapping document for the front door form fields by analyzing Mockup, Prototype and existing tools
- Coordinating the requirements with development team
- Leading the testing team for Front Door
- Created testing strategy and test suites for all business areas
- Presented demos and training of the tool to all business areas
- Coordinated with Change Management for Procedures and Reference Manuals documentation
- Participated in daily stand up and sponsor meetings
- More interaction with customers to help them understand the usage of tool
Environment: Sales Force, MS Word, MS Excel, RTC, MS Visio
Confidential
Project Lead
Responsibilities:
- Participated in Agile Planning, Daily scrum meeting, Review and Retrospective meeting
- Coordinated with product/business owner and documented Agile scrum user stories
- Provided detailed business scenarios for development and QA
- Created "As is" and "To be" system documents to show the current and proposed functionality of the system
- Learn, Understand, Map and document all interdependencies so that an appropriate level of support can be provided and solutions can be identified to meet business requirements
- Completely owned story handling and other QA activities for Integrations module
- Led and participated in Functional, Regression, Smoke, Installation, Compatibility and Reference application testing
- Setup environment with Content Server, Documentum Administrator, FTP, SMTP(POP3, IMAP), DB, Tibco Server, James, WebSphere JMS and SoapUI for testing
- Designed case process using FTP, SMTP, DB, JMS, Web Services and executed run-time with different browsers on different Operating Systems
- Tested integration of product with Perforce
- Overlooked team defect leakage to be less than 8%, which is a client’s bench mark
- Executed over 500 Regression test cases of Case-Process in a span of 25 days
- Created Backend image and cloned it onto 100 PC’s for all team members
- Served as Defect Prevention Analyst to the project and implemented best practices to improve the process
- Involved in Database and Reference Application Testing
- Attended Story reviews, Peer Reviews, daily standup meetings and customer interaction on functional or technical changes
- Status update meetings with clients internally and handling them completely
Environment: Java 1.7.0.17, SQL Server 2008(Content server), Oracle, Documentum Administrator 7.1, Tc server/Apache Tomcat 7.0, Firefox 7.0, FTP/ SMTP/ POP3/ IMAP/ Tibco EMS Server/ James/DB/ WebSphere JMS Servers, FileZilla, Telnet, Soap UI, Quality Center, Jira, Version One, VMware, MS Visio, MS Excel
Confidential
Senior Consultant
Responsibilities:
- Primary client-facing resource and focused on client requirements
- Gathered requirements and created BRD and FSD
- Experience in creating Process flow diagrams, Gap analysis etc
- Created test documents for components and features based on SRS and FRS
- Involved in Test Documents, SRS, UTD Peer reviews, Client Reviews and created peer review documents
- Created Acceptance test scenarios for the product
- Installation Testing of Confidential components in UI and Silent mode on different OS
- Involved in Security, Functionality and Regression testing of Confidential components
- Performed acceptance testing on different client environments
- Tested Feature and Incident Verifications based on release notes for every release
- Tested the integration of Clearcase with iNotion
- Organized Software Change Control Board Meetings in the team
- Tested the components using Rational Pure Coverage Tool and thereby improved code coverage by analyzing the code and adding additional test cases
- Test case management and bug tracking using iNotion
- Led cross training sessions for new joiners on several components of the project
- Experience in creating Test Plan and Test Strategy
Environment: C# .Net, Windows 2000, XP, 2003, WIN 7, SQL Server 2005, iNotion, Rational Pure Coverage
Confidential
Consultant
Responsibilities:
- Automated the regression test cases using QTP
- Documented and formatted the test data using Excel
- Created and Executed Automation Test Scripts for Functional and Regression Testing using QTP
- Divided the Test Scenario into Multiple Actions and converted the into Reusable Actions
- Involved in QTP Data Driven Framework
- Participated in Functionality and Regression Testing
- Involved in team meetings and interaction with customer
- Worked with developers to resolve any defects, assisted in problem root cause analysis and coordinated required changes to achieve Quality Control
Environment: C# .Net, Windows XP, SQL Server 2005, iNotion, QTP
