SUBASH KC
SUMMARY
Business Analyst with *+ years of experience with primary focus in Product Design/Development and Professional Services.
Strong client vs. technical team interfacing and documentation skills including: Business Requirement Documents, Software Requirement Specifications, Functional Specifications, Textual Use Cases, and Object Oriented Models such as Use Case, Activity and Sequence Diagrams and Standard Operating Procedures (SOP)
Proficient working in a team environment with various stakeholders in requirement elicitation, analysis, validation, approval and conflict resolution processes
Working knowledge of software development methodologies such as Agile Scrum, SDLC and Rational Unified Process. Have knowledge of content management software/technologies as such ASP. Net Web Forms, ASP.Net MVC.
Experience performing Black-Box and User Acceptance Testing; Used boundary value analysis technique in designing test cases
Utilized IBM Rational Requisite Pro, Rational Rose, Rational Clear Quest, Rational Clear Case, MS Visio, e-QA Manager, MS Word, MS Excel, and MS PowerPoint, etc.
Knowledge of Project Management tools such as Team Foundation Server (TFS), Caliber R/M and SharePoint
Knowledge of Total Quality Management, Lean Six Sigma, ISO 9001 and CMMi, etc.
Performed Data Analysis using MS SQL Server Business Intelligence Management Studio and SSRS. Created Ad-hoc, Metrics and Tabular Reports using SSRS.
Used T-SQL scripts in extracting data from tables in databases. Used DML and DDL commands. Created different database objects such as views, stored procedures and functions. Used join, union commands, “& “, “or “operators aggregate functions and where clause etc.
Goal oriented, team player, focused, self-motivated, competitive and a value driven individual
EDUCATION
The University of Findlay, Ohio
MBA (Focus: Organizational Leadership) GPA 3.91
Asian College of Higher Studies, Nepal
Bachelor in Business Studies (Focus: Finance) TU Top 50 Students with 61%
Certifications/Training:
IBM Certified Requirements Management with Use Cases (Introduction to Requirements Management/Best Practices: Elicit and Specify Requirements, Manage Requirements, Manage Systems Scope, Managing Changing Requirements, and Use-Case Modeling - Registration No#V16DTT5048
Microsoft’s WPF Training: Hands on training on UI design using Blend Express 3 and Visual Studio 2008
APTECH Computer Education: Web and Database Program (HTML, DHTML, Front Page, MS Access, SQL)
EXPERIENCE
Hello Spanish.com (HSP) Aug 2013 – Dec 2014
Business Analyst
Hello Spanish.com is a web portal which lists information such as Spanish music, food, culture and language. It emphasizes “communication” for bringing people of Spanish interests together and connects them through various ways as public events and messaging etc. The goal of the website is to build Spanish community, to help website users learn Spanish and meet people of Spanish interests.
Responsibilities:
Performed GAP Analysis and observation to understand business requirements and solution scope
Used interview technique to elicit solution requirements
Used structured walk-through sessions to review requirements for completeness and to ensure they were aligned with solution scope and business goals
Documented and managed detailed requirements (Business, User and Solution)
Prioritized and validated requirements with Product Owner
Performed status updates on deliverables/product work, evaluated project progress and met project deadlines
Facilitated meetings for project related issues; prepared the agenda and scripted and communicated the minutes with the project team by email and gathered and communicated user feedback to the project team
Created requirement traceability coverage matrices to scope the project and to manage requirement changes and for future document analyses
Performed system modeling with use case and activity diagrams; used the MS Visio tool
Authored descriptive use cases and captured basic, alternate and exception flows to cover different scenarios
Collaborated with testing, development and implementation teams to clarify requirements, (functional requirements, user interface, business rules, constraints and non-functional requirements) and to oversee any issues
Performed requirement based testing based on test data provided by testers; identified, communicated and resolved defects to project team by using Unfuddle.com, created test cases and communicated defects
Environment: Waterfall, OOD, Java, PHP, AJAX, MY SQL, Macromedia Flash, Unfuddle.com (Defect Tracking), Mozilla, IE, Windows XP
SQA Labs Inc. Peoria, AZ (www.sqalabs.com) Aug 2006 – Aug 2013
Business Analyst / Data Analyst /Report Analyst
SQA Labs provides automation technology and expertise delivering Quality Assurance and Performance Management solutions.
Projects:
Camp Navigator.com: CampNavigator.com is a camp directory where Camps can list their information including camp photos/videos galleries, Podcasts. Magazines etc. Similarly, it allows Parents to view Camps and Summer Programs for their children based on their needs.
Responsibilities:
Performed situation analysis, competitive and gap analysis between similar products available in the market
Used As-Is and To-Be process analysis to understand stakeholders’ requirements
Gathered and obtained requirement approval from SMEs, Camp Directors, Campers, (Parents of Children) and Camp Suppliers
Used one on one meetings, questionnaires, group discussions, structured walkthrough sessions and surveys for requirement elicitation
Created Requirement Documents (Business/User/Functional/Business Rules/Constraints) using MS Word and MS Excel
Classified requirements based on Functionality, Usability, Reliability, Performance and Security (FURPS)
Analyzed and decomposed Requirements using UML diagrams with Use Cases, Activity, Sequence and Component diagrams
Used MS Visio for modeling
Created textual use case documents and wireframes
Created ER diagrams to capture attributes, relationship, and multiplicity between different entities
Performed black-box and white box testing based on system requirements and created test case documents
Managed defects using e-QA manager tool; created test review document and communicated the defects to all stakeholders using e-QA manager
Used the MS SQL Server 2008 R2 tool Reporting Services to generate reports
Used Data Manipulation Language in SQL such as Select, Join, and Union etc.; passed parameters to generate different reports and deployed them in the Report Server and created Standard Operating Procedures (SOP) for the same
Wrote and executed Stored Procedures and Functions; Used Stored Procedures in creating datasets and applied Expressions in the report as per user requirements
Working Knowledge of Excel; used v-lookup, pivot tables, bar and pie charts, formulas, conditional formatting, and filters while performing Data Analysis of large sets of camp data, their types, locations, memberships etc.
Environment: SDLC, UML 2.0, MS Visio, Erwin, e-QA Manager, MS SQL Server, C#, .Net, JavaScript, Web 2.0, HTML, AJAX, SaaS, ADO .Net, Web Services, XML, MS SharePoint, ASP. Net Web Forms, ASP.Net MVC.
Wishesh: Wishesh is a portal to connect Indians worldwide with portfolios of channels. It is influencing the way they live and respond to changing times. It provides breaking news focused on events of interest including featured news stories, interviews and social media reviews targeted for different states and countries where the Indian communities are bigger.
Responsibilities:
Used Agile Scrum to manage the project and for rapid project development
Worked with the Product Owner to develop and maintain Product Backlogs
Participated in Sprint Planning meetings to prioritize the product backlogs; used Daily Stand Up meeting to update project progress and challenges
Decomposed EPIC into user stories and elicited and documented details of user stories by conducting interviews with the Product Owner and incorporated this into Acceptance testing
Created Business Flow diagram such as use cases for Business Listing, Event Listing etc. using MS Visio to cover different scenarios
Created Business Process Modeling to show how different modules in Wishesh were interacting to gather the user information using MS Visio
Assisted & reviewed the test plans & test cases created by the QA team
Performed UAT for system approval, reported defects using e-QA Manager and also involved in QALC cycles by creating test cases & scenarios
Environment: Agile, Scrum, .Net, C#, HTML, JavaScript, AJAX, Web 2.0, SQL, MS SQL Server, Test Director, UML, MS Visio, Web Services, XML, MS SharePoint, e-QA Manager
WT Data Pro: WT Data Pro is an integrated asset management tool that provides an efficient means to manage all Well Assets, Data Collection, Reporting, Safety Training and Time Keeping/Expense tracking. It is done through browser technology independent of operating system with online and offline capabilities.
Responsibilities:
Used Rational Unified Proses Model (RUP) for project Management
Understood the scope of the project by analyzing Business Case Documents and analyzing To Be processes
Elicited and Analyzed requirements using Document Analysis, JAD Sessions, Interviews and Brainstorming Sessions
Created Business Requirement Documents
Designed use case diagrams and activity diagrams and authored/documented textual use cases for capturing user requirements
Worked with stakeholders for requirement document sign off
Used Rational Requisite Pro to manage requirements
Created projects and different artifacts such as Feature Documents, Use Case Documents, Supplementary Specifications, and Requirement Documents
Assigned requirements a subject, type, and number to manage the scope of the requirement and created different views, traceability matrices and hierarchical relationships for requirement traceability
Worked with the testing team to scope the testing process and created test cases and test scripts
Worked with developers to clarify the requirements
Environment: RUP, IBM Rational Requisite Pro, IBM Rational Rose, .Net, C#, WCF, T SQL, Erwin, SSRS, HTML5, UML, Mercury Quality Center, Web Services, XML