Sales Test Cases
Resume:
Hima Bindu
***.*********@*****.***
Professional Summary:
Over 5 years of experience in Software Quality Assurance in Manual and Automation Testing with a thorough knowledge of Functional, GUI, Integration, System, Regression, E2E, Database testing and UAT.
Hands-on experience in design, development and execution of QA Test Plans, Test cases and Test Strategies for both Automated and Manual Testing, Excellent professional skills by working independently, as a team member for testing of E-commerce, ERP, Financial, Telecommunications, Client/Server, Mainframe and Web based applications.
Expertise in working with HP Test Suite (Rational Functional Tester (RFT), Win Runner, Quality Center, Test Director), Back End testing (Database Testing) using TOAD, SQL-Developer by using SQL.
Hands-on experience in diversified fields of theSoftware Development Life Cycle (SDLC), specializing in Quality Assurance Process and Methodologies like Water Fall, V-Model, Agile and Scrum.
Expertise in requirement analysis to prepare Test Scenarios and Test Plan.
Expertise in Development of test cases, Scenarios and strategies for automation.
Proficient in analyzing the SRS (Software Requirement Specifications), Functional Design Documents and AUC (Application Use Cases) to formulate Test Plans, Test Strategies and Test Cases for Manual as well as Automated Testing for various applications to ensure proper business compliance.
Extensive experience in developing Automation Frame Work. Interact with the development team, Test Planning, Monitoring Test Progress, Reporting the Business & Testing requirements and Test Metrics.
Extensive experience in Black Box Testing
Expertise in automating the Database testing using ODBC connections in RFT.
Expertise in designing Automation Architecture (Framework) by using Data Driven and Keyword driven techniques for the Automation.
Expertise in Defect Tracking, Report generation and requirement tracking throughout the test life cycle using QC, TFS and Clear Quest.
Expertise In developing external custom functions using RFT
Expertise and experience in performing different kinds of testing like Functional Testing, GUI Testing, Backend Testing, Regression Testing, Cross Plat form and Cross browser Testing.
Expertise in Descriptive Programming for developing QTP Scripts.
Expertise in writing and testing Queries, Views, Triggers, and Stored Procedures in Oracle and SQL Server.
Experienced in working with business analysts, development groups in analyzing business specifications and in Working with other testers to resolve technical and end-user issues.
Technical Skills:
Testing Tools
QTP, TFS, Clear Quest, Quality Center, Win Runner, SOAP UI,ALM, Guru, Cognos
Programming Languages
VB.NET, ASP.NET, VB Script, XML, XSLT.
Operating Systems
Windows NT 4.0/XP/2000/98, UNIX, Linux ES 5/4, OS/390
Mainframes
CICS, TSO, SPUFI, MVS, IMS, JCL, VSAM.
RDBMS
Oracle 10G/9i, 8i, SQL Server2000/ 2005, DB2, MS Access 2000.
Web/Application Servers
Web Logic, Web Sphere, IIS6, VMware Virtual Machine, Windows Server 2003 R2,WSSO,Microsoft .NET 3.5 SP1, WebSphere Liberty
GUI
Crystal Reports 8.0/8.5/11.0.,OBIEE 10g AND 11g, Business Objects, Cognos
Enterprise Applications
Active Directory, LDAP, Citrix.
Designing Tool
Microsoft Project Plan, MS Visio.
Data Warehousing
Informatics, Power center, IBM Datastage, Ab-Initio
App Server
Tomcat6, Web Sphere 5, Web logic 9
Scripting Languages
TSL, Perl 6, ASP, JavaScript, VBScript, UNIX Shell Script
Networking
TCP/IP, SOAP, HTTP, HTTPS, FTP, SSL
Version Control
PVCS Tracker 6.8, Clear Case.
Amdocs Applications
Amdocs-Billing, Enabler, Clarify, Ensemble, CSM, API, AMSS, AAM, SC
Professional Experience:
Simon Property Group July 2014 - Present
Simon Property Group Inc. (NYSE:SPG) is an S&P 100 company and a leader in the global retail real estate industry. The Company currently owns or has an interest in more than 325 retail real estate properties in North America and Asia comprising approximately 242 million square feet. Additionally, it has a 29% interest in Klépierre, a publicly-traded Paris-based real estate company, which owns shopping centers in 13 European countries. Simon is headquartered in Indianapolis, Indiana and employ approximately 5,500 people in the U.S.
QA Analyst
Continuous Forecasting and Budget – Anaplan July 2014 – Feb 2015
For the better visibility into the business finances, as a part of the Raptor Program, company kicked off a forecast and budgeting tool ‘Anaplan’ for the Continual look 6 – 8 quarters out, Forecasting and reporting of key performance measures (occupancy, spreads, occupancy costs) for future periods (Currently limited to 3 cycles per year), Reduce administrative work for revenue generators, more automated system, less manual intervention by Leasing, Organization doesn’t grind to a halt for the annual budget process and reduce back office log jam and more evenly spread the forecasting and budgeting work over time which should eliminate work taking place currently
Responsibilities:
Phase – 1
Individual Business models in Anaplan and Data Integrations July 2014 – Feb 2015
This Phase initiated with the development of all the models that include the need for the budgeting and forecast like Malls, Mills/Premium Outlets, Management Co., SPG Hub, User Configuration for security, Workforce Planning etc. Each Model has many functional areas that included Dashboards and then modules within them
Generated test plans, test scripts and documented test results
Worked closely with application developers and business analysts in performing comprehensive software testing, including quality assurance testing of databases, modules and documentation.
Performed and assisted Business Analysts with technical and process analysis
Created various types of reference documentation such as user, technical, and operations guides
Demonstrated understanding of the System Development Life Cycle and general project methodologies
Demonstrated excellent communication and interpersonal skills required in interviewing and conveying information between users and technical staff
Validated the data process integrated between the models in Anaplan by running actions
Involved in the Action and Module maintenance for Inputs and Outputs for Anaplan
Involved in the integration process and data movement from People Soft, JDE to SPG Hub and then to the individuals business models WorkForce planning, SPG Malls, Mills/Premium Outlets, Home Office to SPG Reporting via Budget and Forecast back to JDE
Phase – 2
Corporate Screen revise in Anaplan and PAF (Project Approval Form) March 2015 – July 2015
After the functionality has been complete on the 1st phase, this phase required more revise to the Home Office screens in Anaplan from the original implementation design. The current setup, while functionally complete, requires users to continually click back and forth among screens. Redesigning these screens to align with the current state workflow will significantly improve the productivity of home office staff as well as improving the usability of the application. The additional enhancements that are inclusive to Phase 2 changes in Anaplan were Gift Card Dashboard, Field Marketing Budgets, SBV and CapEx Forecast, Miscellaneous Income & Expense Accounts – Comments, Prop Mgmt Expense Units & Driver Export – Comments
Created Test Scripts for all the models and tested the data integrations within the models
Performed Regression testing to ensure the functionality from the previous design didn’t alter
Performed backend database testing at this phase
Worked with ETL group for understanding the graphs of budgets and forecast numbers
Tested and worked on creating open document reports for business
PAF (Project Approval Form) December 2015 – Feb 2016
This Phase also captured the creation of a new module in Anaplan that support the PAF (Project Approval Form) projects once they are been approved. The budget process currently does not include the PAFs therefore creating a gap in budget reporting. This will provide better visibility of the PAFs in the budget and forecasting numbers
Involved in testing the new 3 business process scenarios that included Newly Approved PAF, Re-PAF = Existing PAFs that have been submitted for Re-Approval and Forecast Adjustment
Tested the security of each role involved in the process of the business approvals in User Configuration Model by running actions between the models
Created test scripts and performed regression testing
Prepared the test data for positive and negative testing used in data driven testing
Phase – 3
Development capital forecasting/Budgeting & Reporting solution Oct 2017 - Present
This Phase emphasized on replacing excel which was the primary tool for the development capital forecasting and reporting process. Budgeting/forecasting of cash spend spreads is completely manual and Imputed interest and development fee calculations utilized the data included in the budgeting/forecast file, so if there is an error in the forecast information it will carry over to those calculations which impact the income statement. Hence, the need for an upgrade to a more automated and less reliance on people was much needed for this upgrade in Anaplan
Involved in the whole testing life cycle covering the entire project from initiation to completion
Clearly communicated and documented test results and defect resolution during all phases of testing.
Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
Participated in Project meetings attended Inspection and Review meetings and initiated conference calls to discuss issues originated while testing.
Analyze the requirements and prepare the Test specifications including test plan from requirements and test scenario development from use cases.
Salesforce – Simon Brand Ventures Replacement March 2015 – Sept 2015
Simon used SLIM SBV (Short term Leasing Simon Brand Ventures) which was implemented in 2004 as a derivative of SLIM and SSLE databases. In 2012, a solution was introduced for SBV which allowed proposal information (lease actions) to be entered and housed in Salesforce. Once the proposal becomes a deal, SBV must manually rekey into SLIM SBV. SLIM SBV can be cumbersome and less than efficient. If changes require a different workflow mid-stream, the user must start over. Reporting capabilities are limited in SLIM SBV. Hence Salesforce was used as a replacement
Responsibilities:
Involved in creating a strategic path of replacing Notes based applications and server dependencies / template for SLIM & SSLE replacement efforts with business analysts
Analyzing Requirements and Functional specifications.
Responsible for preparation of test scenarios and test cases
Created around 50-100 lease action deals in Salesforce for Integrated System testing
Involved in analyzing functional requirements documents for multiple projects.
Attended daily meetings, status meetings and defect tracking meetings
As QA Tester, performed responsibilities and involved in testing the scope of the Lease Actions deals that involve
Workflows
Provide workflows and approvals in Salesforce that currently exist in SLIM SBV.
Document Generation
Utilize DrawLoop for the generation of the Cover Letter, Lease Agreements, and other letters in Salesforce.
Reports/Dashboards
Create new or modify existing Salesforce Dashboards, Reports, and Views.
Integration
Replace data warehouse and JDE integrations of SLIM SBV data with Salesforce data
Helped UAT in setting up the deals in Salesforce and test the functionalities of all lease actions
Chrome River – ERS (Expense Reporting System) October 2015 – December 2015
Simon’s current ERS system is Global Expense Reporting System (GERS) software provided by IBM. IBM has announced that they will retire GERS in March 2016. In the desired future state, Simon will have a system that provides the features currently in use from GERS. In addition, Simon desires the replacement system to be an improvement over the system being replaced.
Responsibilities:
Created test scripts and scenarios that include any kind of expenses that could be logged in the new system
Monitored daily reports and any delayed approvals and control of any email notifications by the business
Involved in administration of business rules, based upon Corporate Operations policy
Executed weekly interface between ERS and JDE and travel card vendor
Closely worked with business analysts in gathering requirements
Performed extensive security testing with all the possible roles involved in the process of expense logging
Salesforce – SLIM Replacement January 2016 – June 2016
SLIM(Short Term Leasing) database was implemented in 2002. In 2010, Salesforce was introduced to Specialty Leasing as a platform to capture leads/contacts. The replacement of Slim database with salesforce is to have a continues strategic path of replacing Lotus Notes based applications (in accord with the recent SBVSLIM replacement project, Streamlined process from lead creation through Lease Completion, Improved data integrity in Salesforce, Better transparency into lease action conflicts early in the negotiation process between permanent leasing and specialty leasing, Improved Report/Dashboard Capabilities
Responsibilities:
Analyze the requirements and prepare the Test specifications including test plan from requirements and test scenario development from use cases.
Created Test Plan, Test Cases and responsible for execution Test cases.
Extensive testing was performed in Document Generation(DrawLoop) which provided the ability to generate the Cover Letters and Lease Agreements in Salesforce
Involved in integrated testing that replaced existing SLIM to JDE with a Salesforce to JDE integration
Created new and modified existing Salesforce Dashboards, Reports, and Views
Worked closely with the Enterprise business team in gathering the requirements
Responsible for coordinating and tracking proposed change requests
Participated in UAT with the new application testing
Sales Data – Cognos Reporting July 2016 – October 2016
Simon’s Sales reporting was predominantly done in Excel after manual extraction process from CTI data. Cognos Reporting was used as a tool for the business to create a consumable data mart with Flex File and other CTI data specific to Sales reporting and provide greater granularity and flexibility for ad hoc analysis reporting requests.
Responsibilities:
Managed the process to utilize Flex File data and other relevant data from CTI to create a Sales data mart where sales data and tenant attribute data is accessible for both reporting, querying, and consumption by other systems delineated with an 'as of' date.
Manage the testing process, schedule batch tests, log and track defects using Clear Quest
Involved in the development of the Test plan - Approach, scope, resource assignments & schedules and Testing Strategy
Prepared the Effort estimation for the project.
Responsible for preparation of test scenarios and test cases.
Prepared the test execution plan and tracking the execution
Collected the metrics and analyse the applications status
Automated extraction of Specialty Leasing from JDE into a Sales data mart delineated with an 'as of' date.
Involved in Creation of Business Rules/Data Glossary
Developed several SQL queries to perform backend testing and conducted database testing, passing SQL queries
Performed back end database testing by using SQL queries for inserting, retrieving & updating data.
Tested all the report to report comparisons
Involved and performed all the testing for the Total Sales Volume, Comparison Sales and Rolling 12 sales reports in cognos with multiple prompt selections for the variations in data
Salesforce – Automation Testing October 2016 – November 2016
IBM Rational Functional Tester, an automated tool used to create multiple lease actions in Salesforce
Responsibilities:
Developed test cases, test scripts using RFT
Created multiple lease actions in Salesforce for Short Term and Simon Brand Venture
Parameterize the scripts, handle errors and create checkpoints (GUI, text, bitmap) using RFT
Enhanced scripts by adding the GUI, text checkpoints.
Participated in automated scripts code Walkthroughs and QA Reviews.
Used Parameterization for testing the application with a set of data.
Involved in writing automation test scripts for regression testing using IBM RFT.
Lease Management Informations – Cognos Reporting November 2016 – May 2017
Simon Lease Management uses cognos as their reporting tool and upgraded to the newer versions with many enhancements on the prompt page selections for the corresponding outcome of any particular report
Responsibilities:
Extensive testing on the report to report comparison in cognos
Tested all the enhancements made on the prompt pages
Initiated the process for Creating test cases in quality center using reusable modules
Involved in Unit, Functional, System, Integration and Regression testing.
Created my own test data by developing and executing the SQL queries keeping in mind the different kind of investors.
Assisted the Business Analyst in writing the requirements for the application as I was involved in the UAT testing.
E-Signature – SBV Slim December 2016 – March 2017
Project introduces e-Signature as a signing option for SBV Lease Agreements in Salesforce. This project is considered a continuation of the ‘replacement projects’ & residual capital for those projects is being utilized. Enhanced Customer Experience – faster/easier for tenants to do business with simon. Efficiency/Improved Productivity - easier to track document progress electronically and reminder notices are automatically sent to the tenant. Higher Level of Document Security - more evidentiary elements in a digital contract; eliminates document compares. Cost Reduction - paper, ink, shipping costs
Responsibilities:
Created test scripts and test scenarios that involve all the parties for E-signature in the work flow process
Tested all the security roles in the work process and ensured only the users authorized for e-signature have access to it and the remaining are restricted
Created multiple SBV Lease actions in Salesforce for this particular project having covered all the scenarios that involve risk factors with legal team in the work flow process
Involved in all the requirement gathering meetings and worked with the business analysts to fulfill the primary scope of this project
Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
Involved in the whole testing life cycle covering the entire project from initiation to completion
Clearly communicated and documented test results and defect resolution during all phases of testing.
E-Signature – Specialty Leasing June 2017 - July 2017
This project is a continuation of the SLIM ‘Replacement’ Project which went live in April 2016 & provided full deal management in Salesforce. In March 2017, e-Signature technology was introduced to Simon for SBV deals in Salesforce. Currently, lease agreements are physically mailed to tenants where tenants must sign and send a hardcopy of the lease agreement back to Simon thus both Simon and the tenant incur postage costs in the process of executing deals and mailings must be tracked and cycle times are increased for the deal and also hardcopies are stored on premises at the respective properties
Responsibilities:
Tested the DocuSign integration with Salesforce (existing document generation and workflow functionality will continue to be utilized)
Worked with Business analysis team to prepare a detailed Business Requirement documents.
Involved in writing & implementation of the test plan, various test cases & test scripts.
Extensive security testing
Validated format of the reports and feeds.
Effectively communicate testing activities and findings in oral and written formats.
Created multiple test deals in salesforce using RFT that were used in the E-Signature project for both SBV and SBV Slim (Short Term Leasing)
Accounts Receivable – Cognos Reporting June 2017 – Oct 2017
To recreate a consumable Accounts Receivable data mart with CTI and FIRE data specific to Financial Operations Accounts Receivable, Lease Accounting, Legal Collections and Bankruptcy reporting currently done in Cognos from the legacy Accounts Receivable model. The new AR Mart model will be entirely sourced from the data vault table schemas and provide the ability for 'as of' date reporting, will switch the current method of aging from the due date to aging from the document date of billed charges, and provide greater granularity and flexibility for ad hoc reporting requests, including 'walk forward' reports.
Responsibilities:
Handle all testing units through Cognos framework according to the need of the project
Engaged in test planning, controlling, and strategies
Develop testing data and procedures before load processing
Arrange all project solution and transfer it to the testing and production unit
Focus on drawbacks and defects and make necessary changes immediately
Maintain the testing projects according to the planned schedule and prepare estimates
Prepare project documentation and report them to the management
Work with cross-functional teams effectively to deliver project work on time
Used Clear Quest for Defect tracking and scheduled regular weekly Defect triage meetings with the entire business and IS team
Tested and worked on creating open document reports for business.
Guru – Budget and Forecasting Application Nov 2017 – Dec 2017
Software Guru provides consulting services to the Financial Services community as well as Small to Mid-Sized Businesses. Simon uses GURU to project the sales and incomes and generate various types of reports that are used by executives and higher officials
Responsibilities:
Performed Regression testing on various reports on every phase of the project
Involved in smoke testing on Websphere Liberty IBM
Validated the reports and overridden occupancy sales
Created test data for the project summary of Promo and Media Sales
Involved in security testing with different roles in the app
Participated in UAT with the end users for every release phase of the project
Cognos Motio - Business Implementation Dec 2017 – Current
Cognos upgrade to Motio enhances the complete insight into the BI environment with control over processes and change which helps lower risk and support a smarter way of working. This upgrade helps in dealing the complex reports which are more prone to defects.
Responsibilities:
Create test case persistence which provide huge value to IS and the business
Validated the reports to break into groups as per department
Helped the business to setup the views in cognos for further testing
Involved in importing the views to create the test scenarios in cognos
Utilized the created pre-runs – views setup import into Motio to create test case
Catholic Health Initiatives, Kennesaw GA March 2014 – June 2014
CHI ICD-10
QA Analyst
Healthcare industry undergoes changes constantly, one of the major change is the conversion of ICD-9 codes to ICD-10 codes. ICD 9 has approximately 17000 codes that were replaced by approximately 141000 ICD 10 code. Testing the impact of conversion from ICD 9 to ICD 10 codes on Epic hyperspace modules like Ambulatory Epic Care, Prelude/ADT registration, Billing, Emergency (ASAP), Inpatient, Pharmacy/Willow and Cadence(Scheduling)
Responsibilities:
Utilized Agile and Scrum methodology to test the project.
Studied Requirement analysis and Gap analysis of Business System Design.
Created detailed test plan, test strategy and test cases based on functional specification, flow diagrams and use case documents.
Documented Test cases and Scripts referencing the business rules in HP ALM.
Performed Functionality, Integration, Regression, System and End to End testing.
Tested the Epic Modules - Ambulatory Epic Care, Prelude/ADT registration, Billing, Emergency (ASAP),Inpatient, Pharmacy/Willow and Cadence(Scheduling).
Validated the discreet data in EPIC my chart and created test EMR data.
Involved in validating the patient records and health information data in EPIC interfaces.
Reported the issues in ALM with proper priority and severity to the concerned developer.
Involved in writing automation test scripts for regression testing using HP QTP.
Created object repositories in QTP to store the objects in the application.
Created and executed the SQL queries to fetch data from the databases and Involved in database validation - check the updated data in the database.
Attended the bug triage meetings to discuss the issues with development team and BA's.
Updated and maintained the test scripts as per change in requirements.
Setup the data for UAT environment.
Environment: Epic Hyperspace, HP ALM, HP QTP, Oracle, HTML, Java EE 5, Windows 7,Jira.
Applabs / Farmers Insurance, India June 2009 – July 2010
Quality Assurance Consultant
Farmers insurance is an arm of Zurich Financial Services. It’s one of the US leading and trusted insurance provider. It provides insurance for Auto, Homeowners, Life, and Business. ebusiness applications for farmers facilitates Insurer to get online quote, to register online and to get online claims. It also helps for the agents of farmers to see their forms to be processed and agent can approve few things through these applications.
Responsibilities:
Analyzing Requirements and Functional specifications.
Verified that the requirements were testable, designed the test approach and ensured clear definition of roles and responsibilities.
Involved in the development of the Test plan - Approach, scope, resource assignments & schedules and Testing Strategy.
Prepared the Effort estimation for the project.
Given the KT sessions on requirements and application to the team.
Responsible for preparation of test scenarios and test cases.
Prepared the test execution plan and tracking the execution
Collected the metrics and analyse the applications status
Created & Executed Test Procedures manually before using the automated testing tool WinRunner.
Worked on WinRunner for Regression, Integration, and system Testing.
Developed and maintained automated testing scripts with WinRunner.
Enhanced scripts by adding the GUI, text checkpoints.
Participated in automated scripts code Walkthroughs and QA Reviews.
Used Parameterization for testing the application with a set of data.
Identified, Documented, and Tracked software defects using Test Director and discussed it with the development team to solve the defect.
Worked as software configuration coordinator to manage the Testing documents and updates
Environment: Test Director, WinRunner, ASP, JSP, Java, J2EE, JavaScript, WebSphere, HTML, XML, C, C++, SQL, SQL Server 2000
Contact this candidate