Quality Assurance Analyst Resume
Redwood City, CA
EXECUTIVE SUMMARY
I have a total of 9 yrs Experience in IT, 6 yrs as an "Analyst". I have a technical background (both as a developer and Tester) and also have extensive experience as in Requirement Gathering, System Analysis, Business Process Design and Mapping. Experience in Finance (loans, lease, mortgage, insurance, risk analysis), health care, E commerce and supply chain/logistics Industries with complete understanding of different phases of Project Life Cycle (PLC).
CORE COMPETENCIES
- Requirements Planning and Management
- Requirements Analysis and Documentation
- Solution Assessment and Validation
- Risk Analysis and Design
- Change Control Management
- Quality Assurance/Control
- Business Process Management
- Scope and Time Management
- Data Analysis and Reporting
- Project Coordination and Management
TECHNICAL EXPERTISE
Business Analysis Use Case, Map and Gap Documents, Seed Data, Process Flows, Status Flow Diagrams, Data Dictionary, Integration document, Technical Design Documents, Template Design, Prototyping, Entity relationship diagrams, UML standards for analysis models, JAR/JAM Sessions.
Project Management: MS Project, MS Share point, Microsoft Office (PowerPoint, Excel, Visio, and Word), UML (Unified Modeling Language), BPM (Business Project Management), MS Visio, SDLC, RUP (Rational Unified Process), AGILE, JAD/RAD, SAD (Structure Analysis and Design), IMB Rational Suite [Requisite Pro, Rational Rose, Clear Case, Clear Quest], SCRUM (Rally Dev), Enterprise Architect, OmniGraffle, OmniPlan, Iwork( Keynote, Pages and Numbers).
Quality Assurance: HP Testing Tools (Mercury QC, Mercury QTP, Win Runner, Test Director, Load Runner), JIRA, Rally Dev, User Acceptance Testing (UAT) at client site, Test Plan, Test Cases, Test Design Document, Trace ability Matrix.
Languages/Web Tools: C, C++, Visual Basic, PERL, J2EE Development (JSP, Servlets, EJB, Web Services) and Web Development (XML, HTML, DHTML, PHP, ASP, .NET, CSS, VB Script, Java Script)
Databases & OS: RDBMS- Teradata, Oracle-9, Erwin Data Model, MS-Access, My SQL, Windows, UNIX, Table design (PL/SQL), JDBC/ODBC, SQL. Protocols and Area networks [LAN,WAN,MAN, VOIP, IP, UDP, TCP]
Business Intelligence ETL (Extract, Transform and Load), Data warehouse (OLTP), Metadata, SAP Business Objects, BI tools [OLAP, Data mining and Business Objects for reporting]
Process Impv./ERPs: CMM Levels, ISO Standards, [ERP(human resource management systems (HRMS), Supply Chain management(SCM), Oracle Lease Management(OLM), Order Management(OM), Oracle - Seibel Customer Relationship Management(CRM)]
Confidential , Cupertino [May 2011– Dec 2011]
Position: Sr Business Analyst/ Program Project Manager( intermediate)
Employer: Kforce
Project Description: Worked with Apple Online Store Ops team as a Sr Business Analyst/ lightweight project and program management. Measure UAT, Publishing needs, interact with AOS group, AOSS and IS&T Engineering group to identify the resources, R&Rs. Work with the SAP group and Contact Center to evaluate the resource requirement based on project size, define processes and write documentation around team readiness.
- Worked primarily with the UAT Teams and Publishing teams for defining the processes around UAT and resource management.
- Created documents such as flow charts, time lines, matrix , Dossier and templates using Omnigraffle and Keynote to define processes and activities around UAT Release dates and other Apple Online Storeoperations such as OPS readiness and Contact Center Readiness.
- Worked with about 11 PM’s and Site Managers to gather info from them on what projects they are working on, when resources are coming available, measuring UAT, and update on publishing help with site changes.
- Performed coordination activities with UAT team and technical team to identify order transactions and testing and how it affects countries, as they will need to fold this into a resource plan. Created Scorecards and Resource graphs for EMEA, APAC and AMRs.
- Worked with the Sales and Services group, AOSS group and AOS Engineering Group to identify resources roles and responsibilities, estimates and planning. Updated Wiki and Twiki with various documents.
- Gathered and consolidated all AOS project and release schedules – IS&T, IT, UAT, Business Validation phases. Worked with the UAT , Ecommerce, order processing , QA, ERP, SAP teams to identify and evaluate requirements and create schedule for all Business resources required to support the project.
- Provide updates to the schedule and Highlight risk or exposure areas for AOS programs and provide Support to the network team ( IS&T) related to Wide Area and Local area Networks(LAN), Qos( Quality of Service), wrote integration document for protocols and data packets(IP).
Software/Tools.: iwork(Keynote, Pages and Numbers), OmniGraffle, OmniPlan, ical, FastTrack Schedule, OmniOutliner Pro, Filemaker Pro, Enterpise System (SAP at Apple), Wiki, Twiki, SAP Business Objects.
Confidential [Feb 2010–Dec 2010]
Position: Business Analyst/Project Coordinator
Employer : Kforce
Project Description: Currently working as a Project Coordinator at Wells Fargo Bank within the Web Channel Management (WCM) group [part of the Internet Services Group (ISG)]. Managing the web (WWW) and Online Sales Platform (Apps2k) projects and handling reporting, data analysis and project prioritization tasks based on sizing, budgeting, mapping and Cost Analysis.
- Responsible for researching, compiling, analyzing and reporting various operational data from multiple sources, including unit production, productivity and/or quality statistics.
- Analyzing trends and produces management reports on Ad hoc basis such as Ideas, Funding reports, project roadmaps, Scorecards and Resource Planning Reports.
- Generate and deliver management reports using existing workbooks containing VBA procedures to import and transform data.
- Define user requirements, perform user acceptance testing and/or troubleshoot systems-related operational issues. Assist ongoing production and workflow improvement efforts; manage small projects and/or small segments of larger projects.
- Analyzing the PDDs (Project Definition document) for multiple projects and identifying the systems impacted, Stakeholders, funding, initial sizing, final sizing, assigning projects to project managers, sending out weekly notifications.
- Coordinating within various PMO groups and task force to gather information and update respective internal bank software.
- Supporting and developing Excel solutions using VBA, calculated fields, charts, and ETL processes, writing XML docs, working on Doors for business requirements.
- Researching, compiling, and performing basic analysis on operational data. Independently provides basic summary of operational data. Performing basic troubleshooting and resolution of various project specific requirements.
- Working with Excel VBA to generate complex reports, create new automated solutions/workbooks as needed by different integration project groups.
- Responsible for gathering requirements from different groups and generating reports based on business requirements.
Software/Tools: Technologies used are: Clarity, Rational Clear Quest, Confluence, AGILE, SCRUM, Rational Unified Process, Doors, XML.
Employer: Confidential [July 2007– Dec 2009]
Position: Business Analyst
Third Pillar Systems is the industry-leading provider of engineering-driven software solutions for financial institutions looking to streamline their current commercial lending and leasing process. Worked on main product called as Loan Path, an Enterprise Credit Management (ECM) System that eliminates multi vendor issues of compatibility and integration costs by providing an end-to-end, standards based solution. Some of the modules of this software are: - Vendor Management (Partner), Program, Quote, Credit adjudication for customer, Pricing, Reports. Worked for two major clients of Third Pillar Systems: -
1) Dell Financial Services (DFS)
2) Citibank (Citi Financial)
Confidential (Feb 2009 – Dec 2009)
Employer: Confidential
Project Description: Dell Financial Services is looking for professional implementation services for two major business segments namely Commercial (MLA) for LE and (SNAP) for SMB. The commercial segment is supported by one primary legacy system called the Automated Booking Tool (ABT). ABT is a system used by Dell Financial Services to process contracts under Master Lease Agreements (MLA). Small and Medium Business - Lease/Loan (SNAP) is supported by two primary legacy systems called the Lease Management System (LMS) and the Credit Management System (CMS). Loan Path is currently being customized and configured to replace ABT, LMS and CMS.
- Worked on modules – Partner, Program, Request and Order Management. Partner is used to setup and credit adjudicate DFS Vendors and channel partners. Program is used as a set of rules to drive and default values on various parts of the application.
- Wrote Software Requirements Specification (SRS), Use Cases, Business Requirements Document (BRD). Handled responsibility of extracting functional requirements from various departments of client such as Operations, Sales, Credit and translating those requirements into detailed requirements.
- Provided leadership in facilitating and conducting information gathering, data analysis for Pricing, documentation of information, and presentation of findings. Led the requirements definition Map and Gap Sessions, vendor and partner review for a collaboration system that included a business rules engine component using Merlin.
- Created flow diagrams for order management including – invoice, schedule, order pricing, order management and release. Integration of loan path with OLM interface document describing J2EE web interfaces.
- Used Business Objects Enterprise Report (Crystal Reports) for generating reports through Loan Path and formatting/ auditing requirements for these reports such as Nightly Batch processing.
- Wrote technical interface document to describe processing of data via services between Loan Path and Teradata Database.
- Worked collaboratively with business units, Project Managers, and varied IT teams to develop and implement the specific technology and architecture necessary to deliver business solutions. Created Status Transition Diagram, Business Workflow and updated seed data using Loadables. Wrote technical Data Dictionary, Standard Template Design documents and Traceability Matrix.
- Extensively worked on Risk Analysis using Moody’s , S&P defining the process of retrieving financial data for both borrowers and guarantors from Moody’s Risk Analyst (FA) 5.0 and imports them directly into the LoanPath data model. This data can then be incorporated into RACs (Risk Acceptance Criteria), credit scoring (Dun & Bradstreet, Experian, Trans Union, Equifax) and can be exported to other documents in different formats.
- Worked with data mapping and analysis for various back offices such as AFS, IMPACS, Infolease.
- Designed process flows for customer credit adjudication using compliance checks such as OFAC, SIC, NAICS, GI (Global Interdict).
Software/Tools: TIBCO, XML, MS VISIO, ERWIN, MERLIN, MS ACCESS, OLM (Oracle Lease Mgmt),Oracle Order management ERP, Subversion, UML, AFS, Infolease, Oracle, Wintip, Supertrump, Java, Oracle, J2EE.
Confidential (July 2007 – Jan 2009)
Employer: Confidential
Project Description: Citi Financial is a provider of various Loans such as SBA, Home mortgage, Revolving LOC, BIL (Business Installment Loan), BCA(Business Credit Account) and Retail Banking. The current Citi business process used to review; book, and fund contracts require a paper intensive process with many manual steps to complete the transaction. Loan Path was customized to provide a straight through process to automatically perform Loan Setup, credit scoring and evaluation, booking, and funding of transaction using information passed from the Loan Path to back office.
- Major role in the project was to work on Risk Analysis for large ticket applications ( >250K)and wrote business requirements around qualification of these applications.
- Wrote Use Cases, Mapping documents, Interface design docs, Deploy Diagrams for Banking Support, test cases for this module and perform UAT (User Acceptance Testing) at the client site.
- Responsible for creating process flow and analyze requirements to design loan path screens that will show historical review and five years projections of the customer financials using customer statement datesand business valuation practice including Income Statement, Balance Sheet and Cash Flow Statement--into appropriate schema. Capture business rules and calculation points around these for Items such asDebt Coverage Ratio.
- Provide clarifications to the development team throughout the development process by writing Java Interface Docs, conduct unit testing for complete module, log results via Rally and JIRA tools.
- Accelerated the process of reporting and analysis of data using Business Objects, ER Diagrams and various Business Intelligence tools such as OLAP (online analytical Processing). System interacted using BI to quickly answer multi-dimensional analytical queries. Data Mining and Data Mitigation was used to extract pattern from data and use ETL to reduce redundancy.
- Used JMS and ETL to transform and solve complex business problems, manage performance to achieve measurable business objectives and drive sustainable growth through innovation.
- Project duties included multiple task project assignments, scheduling and tracking; facilitating meetings with all levels of the business community for requirements gathering, writing meeting minutes, design considerations, impact and risk analysis.
- Conducted various Knowledge Transfer Sessions for peers, project leads and testers of the project.
- Managed and led analysis for functional specification team, coordinating and agreeing business requirements, enhancing the requirement methodology and work on change control coordination for system problems, managing the process and coordinating technical solutions.
- Facilitated on-site JAD Sessions to gather input from the departments involved in implementing the plan. Negotiated business unit requirements in order to ensure that the project team can develop solutions that meet the business unit\'s real needs and deliver documents on time.
Software/Tools: TIBCO, XML, MS VISIO, ERWIN, MERLIN, MS ACCESS, AFS Para lender, ICV (Integrated Client View), LAN/WAN/MAN (Area networks),Business Objects, BI, datawarehousing, ETL, Java Messaging Services.
Client - Confidential, Redwood city, CA [March 2007- June 2007]
Employer - Confidential
Position: Technical Business Analyst /Project coordinator
Project: Agistix is a web-based, flexible shipment processing platform with a rules based routing guide that is accessible to all authorized users to process any type of shipment, via any mode, from/to any location by any carrier. Beyond what a TMS traditionally addresses, Agistix can also handle Inbound supplier shipments, including drop-ship material sent directly from a supplier to a customer/end user. Logistics Management Automation (LMA) fills a void between homegrown shipment processing systems and external ERP based software packages.
- Made sequence diagrams for the entire Agistix application to show the various flow of information and data between various classes (OOAD) using Rational Rose.
- Wrote Documents such as bidding process, system guides for the entire application using MS word, worked on design of shipping and logistics industry process such as commodity library, freight management, andDocument management using Adobe.
- Used all fours phases of RUP – inception, elaboration, construction and transition to perform iterative tasks such as Business Modeling, Requirements, Analysis and Design, Implementation, Test, Deployment and three supporting disciplines - Configuration and Change Management, Project Management, Environment.
- Converted Agile Unified Process (AUP) and agile database techniques of the Agile Data method to fit in RUP.
- Translated business and system requirements into system deliverables. Analyze the impact of solutions on current processes and existing systems and recorded in Rational Requisite Pro.
- Conducted and participated in walkthroughs and reviews to validate quality and obtain approval for system and business requirements, conceptual and logical models designs.
- Managed and led analysis for functional specification team, coordinating and agreeing business requirements, enhancing the requirement methodology and work on change control coordination for system problems, managing the process and coordinating technical solutions.
- Wrote User Guides, User Manual and Technical Specification for the Tech team.
Software/Tools: MS Word, RUP, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, Rational Rose, AUP (Agile unified process), Oracle SCM (Supply chain ) – ERP.
Client - Confidential, Redwood City, CA [Oct 2006 - March 2007]
Employer - Confidential
Project: Assurz, Inc. provides satisfaction guarantee programs to online shoppers for Retail e-Commerce Transactions and merchandise. It offers Assurz guarantee, a satisfaction guarantee program that enables shoppers to evaluate their purchases and, if dissatisfied, receive full reimbursement of their purchase, as well as prepaid return shipping directly from the company. The Project involved implementation of merchant and its site implementation. Worked on the Merchant Info UI - PRD Fragment addendum that defines requirements for the Zoyto CRM case management flow.
- Worked on Assurz- merchant portal and made complete logical and physical data models using Microsoft power point that showed all the relations between various tables.
- Made complete organization change management plan for handling the merchant implementation
- Acted as a liaison between the development team and management team and documented complete Assurz service platform model for guarantee processing.
- Made a business process model (BMP) for merchant implementation, claim processing, billing and reporting and case management also gained good exposure to business process reengineering.
- Gained experience with Partner relationships, Zoyto CRM in order to manage sales, marketing, and customer services processes for optimal advantage, and maximum return on investment
- Wrote detailed functional requirements document for the Assurz Consumer Case Management service and the Assurz/CRM Gateway for the Beta version.
- Assurz case Management integrated with Oracle\'s Siebel CRM software to collect information about customers using oracle customer hub solutions. When gathering data as part of a CRM solution, information about customer privacy and data security, as well as the legislative and cultural norms was also recorded and documented.
- Gained experience with QuickBooks, documented the entire procedure of importing and exporting the IIF files from Assurzs merchant server into QuickBooks for invoices and bill generation.
- Made various case workflow state diagrams and activity diagrams for various cases like MBG (Money back guarantee) inquiry, complaint, claims (open, cancel, close, escalate) and Returns.
- Wrote business requirements and made use cases for their current merchant portal (Merchant implementation). Used EA for all the data flow diagrams including activity, deployment, object and class diagrams.
Software/Tools: Enterprise Architect, Zoyto CRM, QuickBooks, Enterprise Architect, MS Visio, Oracle\'s Siebel CRM, Enterprise Architect.
Employer - Confidential [Jan 2004 – June 2005]
Position - Software Automation Tester
Project [First Project]: Bug Tracking System has been designed to identify and trace the bugs in particular software. This software provides with a communication channel by means of which this bug, which is caught by the users of the software is send to the concerned process owners for its rectification. This helps in smooth running of the software as well as the system
- Performed black box and white box testing, both manual as well as automated testing for the bug tracking system.
- Used Win Runner as an automated functional GUI testing tool to record and play back UI interactions as test scripts.
- Worked on QTP and used it as a Functional test suite. Quick Test Professional supports enterprise quality assurance. QTP replaced the entire test that we were doing using Win runner.
- Worked extensively on Mercury Test Director to enter details about high-quality applications consistent, repeatable process for gathering requirements, planning and scheduling tests, analyzing results, and managing defects and issues.
Employer - Confidential
Position - Software Automation Tester
Project [Second Project]: Online Interaction System is complete web based software, which is designed for online monitoring. This software exploits best practices to provide enterprise wide solutions for complete interactions between all the employees presently working in the organization .The main objective of OIS is to keep a track of daily tasks and responsibilities of each employee in the organization (strength 4000 employees) in the form of User-Super User paradigm. Another facet of the OI System is to contribute towards synchronization of work
.
- Wrote Test Plans, Test design documents, Test cases, Traceability Matrix.
- Used Load Runner to monitor software performance. Used various Loan Runner protocols to isolate bottlenecks with minimal impact to systems. Loan Runner was used for suite of network, application server, web server and database server monitors accurately measures the performance of every tier, server and component of a system during load test, also by correlating performance data with end-user loads and response times.
- Wrote test Scripts for white box and black Box testing, the test results were logged and debugged.
- Used MS word and MS excel to log these results and later they were exported in flat files for developers to use and fix the bug.
Confidential [Jan 2003 – June 2003]
Position: Software Developer
Project -Small Arms Training Simulator (SATS):- The Mahindra Small Arms Training Simulator (SATS) is a versatile and state of the art training device for imparting effective Marksmanship and Situational /Judgmental training to Armed Forces personnel in an indoor set up. This software has three basic modes Marksman, Snap Shooting, Course and Interactive Scenario. This software is presently implemented in Indian Army .The operations are done on various Platoons, Sections and Groups. There were complete record of the firing range, carbine, pon, caliber and after every session there were reports generated.
Language: Visual Basic 6.0
Software Tool: Crystal Reports
Database: MS Access
The main role was to understand the requirements by having sessions with clients, database design, coded for reports using Crystal reports, also wrote extensive code using visual basic 6.0 for UI. Wrote detailed user Guide and technical document describing functionality and implementation details for the complete software system. We used ODBC for database connectivity.
Confidential Position: Software Developer
Project Electrical Goods Merchandise Management (EGMM) - This software caters to several business applications like Purchasing, Inventory, Store Replenishment, Invoice matching, Debit Notes and stores sales for the electrical items. Automatic system for complete Bills generation, Debit notes were generated against vendors to claim the amount resulted of difference in the items ordered and items received both in terms of price and quantity.
Language: Visual Basic
Software Tool: Crystal Reports
Database: Developer 2000, Oracle
Responsibilities:
- Wrote Software code for the purchase module that handles the inventory of EGMM system.
- Worked on the main objective of EGMM is to keep track of electricity consumption, consumer records, and create electricity management database (oracle) in addition to issuing periodical bills for electricity consumption.
- Due to the individualized delivery and measurement device, which is located at the consumption point of each individual consumer, billing system should be flexible to handle individual exceptions. This was done usingDeveloper 2000(Forms 4.5 & Reports 2.5)
- Another facet of the billing system is to contribute towards the capital recovery of sunk costs of the utility towards deployment of network infrastructure through demand-based billing. Coded for the files upload module using Visual Basic and Crystal reports (ODBC Connectivity) .
- Network topology was used and various Sockets were managed using ASP and Scripting.
EDUCATION & CERTIFICATIONS
- MCA (Masters of Computer Applications)
- Diploma inBusiness Administration
- Bachelors in Science
- Certification in Software Quality Management