SUMMARY:

• Over 8 years of IT experience with expertise in various aspects of manual testing, User Acceptance, Back - end, Regression, System integration and Functional testing.
• Strong understanding of project life cycle and SDLC methodologies including RUP, Waterfall and Agile Scrum.
• Experience designing and developing of SQL statements on Oracle Sybase, SQL Server 2000 database and SQL400 (AS400).
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Data Analysis, Validation, Cleansing, and Verification using SQL, Netezza SQL and PL/SQL scripts
• Hadoop ecosystem (Hive, Pig, Sqoop, Map Reduce, Flume)
• NoSQL database, HBASE or Cassandra
• ETL and DW testing (Data stage,Informatica, Abinitio and Autosys)
• Experienced in manual and automated testing for both front-end and backend.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical models.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, and Agile/Scrum.
• Excellent team spirit and leadership qualities with good communication and interpersonal skills.

TECHNICAL PROFICIENCIES:

Languages: T-SQL, PL/SQL and Netezza, Shell Scripting, JAVA, Python, Ruby, Perl, SQL, Pig, HiveQL, COBOL II & VS COBOL, JCL, SQL, XML, XSLT, VB, FOXPRO, CLIPPER

Software: Oracle RMS, AS400, Oracle RPM, Allocation, oracle RESA, PIM, Dematic IQ, OTM (Oracle Transportation Management, IBM Sterling Store version 9.2, IBM Sterling selling and fulfillment (OMS)version 9.2, OMS, Oracle SIM, People Soft, POS hub, JDA Application, Service now

Databases: RDBMS, HDFS, DB2, SQL Server, Aginity, DB visualizer, Oracle 9i/8i, Sybase, Oracle and MS Access 97, MS-IIS 5.0, Apache 1.3.9, MS Commerce Server 2000, JRun 2.33, Web Logic 7.x, Web Sphere 6.x,Oracle, MS SQL Server, DB2400, MS Access 2000, Squirrel, TOAD, Teradata

Tools: QTP, Load Runner, HP Quality Center 10.0, Microsoft Test Manager (MTM), HP ALM 12.5, Hive, Pig, Sqoop, Map Reduce, Flume, ServiceNow, Visual Test, Silk, Application Stress Tool (WAS), Informatica 8.5/ 8.1/7.1/6.2/5.1 (Power Center/ Power Mart), EDW, Tealium, Workbench, Eclipse Mars2, SQuirreL Data stage, Abinitio and Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Sr. QA Analyst

Responsibilities:

• Perform data migration checks for data migrated from EDW to Tereadata.
• Perform check for Best Customer Logic that identifies customer to email association for marketing.
• Validate SAS Customer Intelligence tool which generates Analytics data for audience list that is targeted for marketing email campaigns.
• Validate dynamic content files for Customer data that is being sent to Merkle for Email marketing campaign.
• Validate customer specific marketing email versions by modifying data in backend system
• Used Rational Tool for wrote scripts, Test Cases, Execution and Defects tracking.
• Validated Map Reduce programs using Pig Unit and Hive.
• Importing and exporting data into HDFS and Hive using Sqoop.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Responsible to manage data coming from different sources
• Participating in Daily Scrum Meeting to provide QA updates

Environment: Jira, Teradata, Netezza, Ab initio, SAS CI, BMC Remedy, I series navigator, SQL database, DB Visualizer, PDM, ATG, Framework, JDA,AMS,EOM, Workbench, Tealium, Hadoop, Amazon S3,Amazon Redshift, , CDP (Customer data platform),Microsoft Outlooks, Autosys(Merkle),Tealium IQ, Tableau

Confidential, New Jersey

Sr. QA Analyst

Responsibilities:

• Requirement gathering and understanding from Business meetings
• Used Rational Tool for writing Test Cases and Defects tracking.
• Creation of purchase orders and transfers for Vendor and warehouse AR receiving or Detail receiving
• Tested Initially load of supply chain exact data and AR Set programme
• Managing Code Promotion and set up Robot job in JDA Application for QA and UAT System
• Used ScannerWebAPP or RF gun device to receive Transfer and Purchase order
• Participating in Daily Scrum Meeting to provide QA updates
• Participation to UAT testing and support business for Validation and execute use cases

Environment: IBM I Series AS 400,JDA Application, Squirrel database, Lotus Notes, UC4OPS, Wireless HIP Printer, RF Gun Device (Wave link), Scanner Webapp Application, I series navigators data base, DB Visualizers database, JAVA, RPG,Rational Tool, Snagit 12

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Preparation of Test Plan & Test Cases
• Developed test scenarios and test cases based on user requirements.
• Used HP ALM for writing Test Cases and Defects tracking.
• Performed the initially load testing for merchandise Hierarchy ) Division, Groups, DEPT, Class and Subclass between RMS and WMS System
• Used RMS Application to create Reclass events for Division, Groups, DEPT, Class and Subclass hierarchy and heavily data validation between RMS,WMS,People Soft, RDF(Item Domain) and Class Domain, SAS, Sterling, NOVA PIM (Nacho) and POS.
• Providing Weekly Status Report to all stakeholders
• Using JIRA and HP ALM to track all issues and defects.

Environment: Oracle RMS, MQ Series, IBM I Series AS 400,People Soft,Nacho,RDF,SAS,POS, IBM Sterling Store version 9.2,POS,Lotus Notes, Carolina Logistics Service, Oracle SQL,HP ALM, UC4OPS, Wireless HIP Printer, RF Gun, TOAD, Squirrel database, As 400 data base, JAVA, RPG, middle ware ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Requirements gathering and understanding from Business meetings.
• Involved in the development and implementation of Test Plan, Test Scenarios and Test Cases for functional, system requirements.
• Performed Manual testing such Smoke testing, Integration testing, System Testing and Regression testing
• Used WCS web Application to create orders and sterling generated shipment number that unique identifies this customer shipment.
• Provided support to Business and BSA’s during the UAT phase.
• Managing the Code Deployment in QA Environment.
• Attended daily defect-triage meetings with developers to explain the defect details.
• Use to send test execution summary report and defects report to the project team on daily basis.

Environment: JIRA, Oracle RMS, MQ Series, IBM Sterling Store version 9.2, IBM Sterling selling and fulfillment (OMS)version 9.2 IBM I Series AS 400, Lotus Notes, Oracle SQL, HP ALM, UC4OPS, Wireless HIP Printer, RF Gun, TOAD,JAVA,RPG,middler ware ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Requirement gathering and understanding from Business meetings.
• Interacted with Third Party Vendors (Dematic) for testing third party applications as part of the end to end testing. This involved challenges around to setup test environment with WMS through MQ messaging end.
• Creating Business Test Scenarios and Test Scripts for WMS and Dematic multi shuttle system.
• Tested foundation data like Items, UPC, Vendor, Stores info with Dematic multi shuttle system. Performed inventory report corrections, cycle count, re-slot SKUs at DMS location
• Tested the interfaces which processes the voice picking instructions from Dematic and resolve the pick directives at Academy (WMS - AS400 system).
• Tested the Put to light and Divert Conformation interface between Dematic and Academy which creates the store containers at WMS system and diverted lane at WMS.
• Created Daily Status and Weekly Status Report for individual projects.
• Interacted with multiple teams for End to End validation.
• Used HP ALM to report/track all issues and defects.

Environment: JIRA, Oracle RMS, RPM, Allocation, SIM, MQ Series, IBM I Series AS 400, System i navigator, Lotus Notes, Oracle SQL, HP ALM, Dematic IQ, Service now, middle ware ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Requirement gathering and understanding from Business meetings.
• Performed Integration and System testing
• Used newly different kind of Release logics ( FIFO, Pick to Clean, Pick to Empty, Pick to Efficiency and Pick Store Pallet ) to generate dynamic pick instruction
• Backend testing; testing the database tables using queries to validate the database updates is happening properly and correctly.
• Participating in Daily stand up meeting and Using JIRA and HPQC to track all issues and defects.
• Provide weekly status report to the Project team and discuss issues related to project deadline.

Environment: Oracle RMS, Allocation, SIM, MQ Series, IBM I Series AS 400, System i navigator Lotus Notes, Oracle SQL, HP ALM, Wireless HIP Printer, Service Now, UC4OPS, Middleware System ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test cases. Developed test scenarios and test cases based on user requirements
• Used HP Quality Center for writing Test Cases and Defects tracking.
• Tested foundation data (UPC) and PO loads migration between OTM application and RMS
• Tested the interface for item and POs are from RMS to OTM when items and POs are added or changed.
• Tested the interface which sends different vouchers information from OTM to PeopleSoft.
• Tested the interface which sends the planned shipment data from OTM to Inbound Cargo.
• Co-ordinated with UC4OPS team to run the batch jobs which creates the invoices in people Soft.
• Defects and Issue resolution was conducted on a daily basis during the defect triage meeting.

Environment: Oracle RMS, Lotus Notes, Oracle SQL, HPQC, Oracle Transportation management (OTM), People Soft, Inbound Cargo, IBM Message broker, Middle ware system ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Developed Test Plan and wrote Test Cases.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases
• Extracted data from various sources like Oracle, flat files and ODS
• Co-ordinated with operations to run the ETL data stage batch Jobs and monitored the test results.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Validated reconciliation report based on the data Mapping rules.
• Tracked all issues & defects using the HPQC.

Environment: Oracle RMS, System I navigator, Lotus Notes, Oracle SQL, HPQC, UC4OPS, IBM I Series AS 400, DB Visualizer database, Allocation Application,UC4 job version 11

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Interacted with Business and BSA’s to get Fredo requirements finalized.
• Created Test Plan for each Scrum cycle during Functional Testing phase.
• Worked on Requirement Traceability with functional testing test cases using HPQC.
• Tested the RF function FRC for unplanned receiving and planned receiving.
• Tested dynamic labels creation (Different kind of labels) based on the scanned data.
• Recorded the defects in HPQC with priorities and coordinated with Development team.
• Prepared Defect Summary Report & involved in Bug Review meetings.

Environment: JIRA, Oracle RMS, RPM, Allocation, SIM, MQ Series, AS400, IBM I Series, Lotus Notes, Oracle SQL, HPQC, Wireless HIP Printer, RF Gun

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Responsible for testing the functionality of Oracle applications like RMS, SIM, Allocations, WMS and People Soft across all phases as a part of Oracle implementation.
• As part of testing, project had both Agile and waterfall Methodologies in place.
• Review and understand established Should-Be state for Purchasing (PO) and purchasing (ePro) business processes for strategic improvement including procurement Workflow Approval Process
• As part of Interface validation, performed testing on PeopleSoft Financial and Invoice Management Modules. Validated the data within PeopleSoft Application.
• Involved in testing Credit, Sales Order, Discounts and Invoice Approval Process
• Research and promote standard best practices in conjunction with other PeopleSoft modules (General Ledger, Billing, Receivables, Order Management, Inventory, Manufacturing and Supply Planning)
• Involved in project status meeting, requirements gathering meetings, daily stand up meetings, status update meeting with offshore teams located onshore and offshore.
• Extensively used HPQC for defect and issue tracking, which followed a defect life cycle.

Environment: Quality Center, JIRA, Bugzilla, Oracle RMS, RPM, RSM, SIM,OMS, PIM, RIM, PeopleSoft Financials, Java, MQ Series, AS400, Sterling, IBM I Series, POS, TOAD,SQL Server 2008, Lotus Notes, SQL View Point, UC4OPS, Middle ware system ESB and RIB, Service now