We provide IT Staff Augmentation Services!

Data Warehouse Analyst/tester Resume

2.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • SAP Tester with 7 years of extensive experience in SAP Testing. An expert in different projects with different modules in SAP ECC6.0 and R/3, Net weaver Portal, MM, SD, FI/CO, IM,WM, PP, LE, PS & BW.
  • Experienced in testing Manufacturing applications, SAP GUI module like Financial Accounting and Controlling (FICO), Inventory Management (IM), Warehouse Management (WM), Materials Management (MM), Sales and Distribution (SD), Logistics PP & HR, CRM, Advanced Planner and Optimizer (APO) and ABAP.
  • Understanding & analyzing customer’s ‘AS - IS’ Business Processes and mapping ‘TO-BE’ processes.
  • Have been actively involved in various stages of SAP Implementation like Requirements gathering, System study, Freezing of documents, Design of Functional and Technical specifications, Test case design, UAT, Support and Documentation.
  • Involved in identifying the cause of Defect and reporting the same to developers
  • Involved in Data Validation, Data Conversion and Data Reconciliation Testing
  • Diverse work experience on Unit Testing, Smoke Testing, Functionality Testing, Integration Testing, GUI Testing, System Testing, Regression Testing, Sanity Testing, Performance Testing, Database Testing, User acceptance testing (UAT), Compatibility Testing and Product Assurance Testing for Web based and Client/Server applications.
  • Developed design, configuration, and user documents in Solution Manager
  • Extensively involved in using Mercury Test Director and Quality Center for defect tracking and defect management.
  • Conducted Joint Application Development (JAD) sessions and worked with executives, developers, and end-users to define the exact requirements needed by a software solution.
  • Experience in conducting Functional, Regression, User Acceptance, Integration, Backend, Load and Performance Testing using Load Runner, QTP, HP Mercury Quality Center.
  • Involved in GUI, String, Integration, Security, Regression, Business Component, Data, Interface Testing, Performance, Volume and UAT Testing.
  • Responsible for reporting daily status and progress of testing to the project team.
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Involved in Defect prevention, Productivity improvement and knowledge management activities
  • Proficient with developing Test Plans, Scripts. Experience in both Manual and Automated testing methods

TECHNICAL SKILLS

ERP Systems: SAP R/3 4.6C, 4.7, ECC 5.0, ECC 6.0

SAP QA Testing on: PS, HCM (HR), SRM, CRM, SD, MM, FICO,SCM,PP- PI, WM

ERP Tools: ABAP Query, Quick Viewer, CATTS, eCATT and LSMW

Operating Systems: Windows 95/98/2000/NT/XP/Vista, UNIX (AIX, HP).

Databases: Oracle 8i, SQL Server 7.0/2000, AS/400, MS Access

Application Packages: MS Office, Word, Excel, Access, Outlook Express, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Warehouse Analyst/Tester

Environment: Informatica 8.1/ 7.1.4, Oracle 8i/9i/10G, Teradata V2R5/V2R6 Teradata SQL Assistant, SSIS, SSRS, Flat files, PL/SQL, TOAD 8.0, SQL, UNIX, Cognos, Maestro 8.0 (Tivoli Work Scheduler), Charm, Remedy, Test Director/Quality Center, SUN SOLARIS, Power Connect, PowerAnalyzer4.1, synapse

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Written several UNIX scripts for invoking data reconciliation.
  • Validated documented user requirements.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Validated business reporting requirements with internal and external customers.
  • Used SQL for Querying the DB2 database in UNIX environment
  • Tested the Oracle Applications and Portals like Executive Dashboard, Bank One Portal built on Oracle. Used TOAD Software for Querying ORACLE.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus.
  • Tested different detail, summary reports and on demand reports developed by Report Studio.
  • Validated the reports to make sure all the data is populated as per requirements.
  • Performed front-end testing on JPMC Portal and Executive Dashboard portal
  • Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
  • Tested several data migration application for security, data protection and data corruption during transfer.
  • Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
  • Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Worked with Data Conversion projects for testing data quality after migration.
  • Tested Operation Data Store process of ODS/DWL product
  • Used workflow manager for session management, database connection management and scheduling of jobs.

Confidential, NJ

SAP Tester

Environment: ECC 6.0

Responsibilities:

  • Was a team member, involved in Project Management, Configuration, and Testing support of various functionalities in FI, MM, SD modules.
  • Created customer master and vendor master records linking with General ledger using reconciliation account.
  • Tested EDI IDocs, 850 (Purchase order), 856 (ASN), and 810 (Invoice) in outbound and inbound scenarios. Other EDI transactions 945, 944, and 820 inbound and outbound, 816, 812, 860 IDoc mappings with Gentran system.
  • Created Vendor master, Customer master, and specified Screen layouts.
  • Synchronized master data between customer master data and business partner. Did automatic payments to multiple Vendor Bank accounts.
  • Configured and tested automatic interest calculation procedure, payment terms, correspondence and dunning procedures.
  • Configured customer and vendor account groups for domestic, foreign and one-time customers and vendors. Defined number ranges and customer tolerance limits.
  • Configuration of Automatic Payment Program for vendors.
  • Developed and executed Test Scripts, recorded test results and maintained errors and bug tracking using HP Quality Center (QC).
  • Created credit control areas in Credit Control Management and defined credit limits for customers according to their risk categories, configured credit representative groups and assigned company code to credit control areas.
  • Built Final Test Plans comprising of Test Cases and Test Data for Functional, System, Regression, Integration, Back End and Users Acceptance Testing (UAT).
  • Worked on Supply Chain Management Movement and storage of materials, work in progress inventory and finished goods.
  • Configured settings for creation of house banks, bank accounts, lockbox file formats and other criteria required for Lockbox processing expediting customer payments.
  • Performed unit testing and integration testing for business process procedures like quote to cash and procure to payment. Used Infopak for creation of BPPs.
  • Involved in Functionality testing of various customized transactions in SAP R/3 for settlement orders, GL recurring entries, vendor invoice, vendor credit memo, customer invoice, and
  • Tested Pricing, Account Determination other Basic Functions, Revenue Splitting, Material groups, Shipping and Billing.
  • Involved in manual testing using Test Director, regression testing, and functional testing.
  • Interacted with business analysts for designing and implementation of user cases and test plans.

Confidential, Alpharetta GA

SAP Tester

Environment: SAP SCM 7.0, ECC 6.0

Responsibilities:

  • Tested reusable test cases using eCATT.
  • Creation of Test scripts for every transaction under SD, MM module.
  • Responsible for Functional and Integration testing of the FI/CO, SD, Logistic & MM modules.
  • Tested vendor master records, accounts determination, default account assignments, payment methods, house banks, bank accounts and ranking order of bank accounts, check management and automatic outgoing payments in Accounts Payable.
  • Testing the inbound and outbound interfaces related to SD, MM modules from legacy systems to SAP.
  • Using the Test Requirements was also responsible in creating Test Scenarios.
  • Responsible for creation and implementation of system test plan.
  • Used QTP and Load Runner for test automation, used Test Director as bug reporting and testing tool.
  • Analyzed Product Requirements, Business and System Requirements and also participated in the inspection and walkthrough.
  • Performed Integration and System testing.
  • Evaluated critical functionality of application wrote Test cases for automated test tool Win Runner and executed the same.
  • As part of transaction testing, wrote and executed SQL queries and created views extensively, verified data and tables residing in the database.

Confidential, Columbus, OH

SAP Testing Consultant

Environment: SAP ECC 6.0

Responsibilities:

  • Responsible for functional specifications based on the business requirements and interaction with the subject matter experts, developers and users
  • Developed test scenarios for Customized Accounts Receivable and Accounts Payable modules including Creation of Vendor Master Records, Customer Master Records
  • Manually checked the interface between SD & FI modules.
  • Testing the inbound and outbound interfaces related to SD, MM modules from legacy systems to SAP
  • Generated Invoice Verifications by entering invoices with order references
  • Experience in Business Analysis, Manual Testing, GUI Automation Testing, System testing, including Functionality, UAT(User Acceptance Testing), Integration Testing, Performance, Stress and Regression Testing of Client/Server and Web based applications
  • Involved in setting up the Testing Methodology for the QA department and generated various documents to enable uniformity in recording the test process and results
  • Involved in Test Specifications and Unit test plans for all the developed objects
  • Reported the defects to the development team. The defects are reported to the development team using Mercury Test Director

Confidential, Marysville, OH

SAP QA Tester

Environment: ECC 6.0

Responsibilities:

  • Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
  • Responsible for functional and Integration testing of the FI/CO, SD, Logistic & MM/IM/WM modules
  • Involved in testing of overall business process of OTC & P2P & integration
  • Tested Create Sales Order and Order processing.
  • Tested Post Goods Issue for Shipment. Tested Change Recipe, Update Recipe for Commercialization, Transform General Recipe and Change Master Recipe.
  • Analyzed User Requirement Document and developed test plan, which includes test objectives, test strategies, test environment, test priorities, test cases etc
  • Executed SQL and PL\SQL commands to do the Data Base Testing
  • Tracked Defects, reviewed, analyzed, compared and stored in Test Director
  • Created and documented test plans and Generated test scripts and test data for functional and regression testing, Unit testing & UAT
  • Participated in Project meetings attended Inspection and Reviews meetings and initiated conference calls to discuss issues originated while testing
  • Have provided on call support executed the Test Cases Manually and reported the defects to Developers.

Confidential

SAP Automation Tester/TCoE

Environment: SAP & Web, SAP SCM, FICO, QTP 11.0, HP ALM 11.0, SAP TAO, Load Runner, Accelera Test.

Responsibilities:

  • Working closely with SAP Configuration Team to create manual test scripts, scenarios, test data and test conditions in Quality Center.
  • Understanding of client requirements, manual execution and creation of automated scripts for E2E flows.
  • Preparation of test plans, which specify testing overview, testing approach, testing strategy, roles & responsibilities and scope of testing.
  • Conducted various types of testing like Functionality Testing, Regression Testing, System Testing and Interface testing.
  • Review of the Test Cases, End to End test Scenarios, and completeness of test results.
  • Involved in BPT testing by using the SAP TAO, QTP and Quality Center.
  • Effort estimation for projects under TCoE.
  • Co-ordinate with functional team members to identify the automation test script for validated string, UAT and Regression test cycles.
  • Review/Audit for projects for process adherence.
  • Created/Updated and executed SCM, FICO test scripts with ECC 6.0 upgrade functions.
  • Testing of SAP, web and .Net applications
  • Site Administration activities for HP ALM & training for users on tools such as HP QC/ALM, QTP, SAP TAO
  • Onsite/Offshore coordination for issues resolution and successful timely delivery
  • Interface testing for inbound and outbound IDOCS from different vendors in SAP
  • Worked with testing and modifying test scripts and defects for updated business Process.

We'd love your feedback!