Resume

Sign in

Sales Test Cases

Location:
Indianapolis, Indiana, United States
Posted:
January 29, 2018

Contact this candidate

Resume:

Hima Bindu

ac38l7@r.postjobfree.com

708-***-****

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