SUMMARY:

• Over 13+ years of experience in IT, worked on multiple domains and major clients as such State Street(Financial services), Toyota (Warehouse), WL Gore (Manufacture), FedEx(Logistic), All - State(Insurance),GE Finance and Confidential (Card and Payment).
• Functional experience on manual testing, ETL Testing (Abinitio), Performance Testing (Big data),Data Masking Testing, System Testing of client server and web-based systems. Experienced working on project development activities as well
• Good experience of successfully delivering projects, able to work in a team environment or independently with minimal supervision and able to learn and apply new technical information quickly.
• Extensive experience with Agile/Scrum and Waterfall Methodologies.
• Strong knowledge and experience in User Story Writing along with Story Boarding and Story Mapping.
• Proficiency in applying sound software testing techniques to reduce defects, improve quality, and enhance business success.
• Ability to thrive in a cross-functional team-oriented environment
• Trained in Data masking Tool and implemented in GLSR

TECHNICAL SKILLS:

Test Management Tools: JIRA, HP ALM & RTC

Programming Skills: Python, XML, RPGLE, RPG400, RPGIII, RLU, Hive, PIG

Development Tools: Hadoop, SQOOP, Flume, HBase, Ab initio, AS/400, Data masking, Axiom and UNIX

Data Base: DB2/400, QUERY/400, SQLRPG, SQL

PROFESSIONAL EXPERIENCE:

Confidential, Boston

Project Leader

Responsibilities:

• As a member of the Scrum team participated in daily standup, backlog grooming, sprint planning, project status meetings, retrospective meeting as well as end of the sprint demo
• ESP-ETL Testing on Confidential and Axiom Report testing
• Validate whether the data is transforming correctly according to business requirements
• Validate that the projected data is loaded into the data warehouse without any truncation and data loss
• Make sure that ETL application reports invalid data and replaces with default values
• Automation Testing for 13F and Regulatory Report .
• Make sure that data loads at expected time frame to improve scalability and performance
• Report well written bugs and track it through closure in co-ordination with developer and scrum master to contribute proactively to better the software testing process and following AGILE development lifecycle
• Interacted with Business Analysts and Developers in requirements analysis, design reviews, testing and documentation for application developed in Agile environment
• Analyzed the Business Requirements Document (BRD) to develop a high level Test Plan and Test strategy
• Work with stakeholders to gather A/B testing requirements, create a data for A/B testing and setup the environment for A/B testing
• Experienced in creating Requirement Traceability Matrix (RTM) and identifying missing specifications.
• Coordinate with QA’s and development teams onshore and offshore throughout the life cycle of the project.
• Extensive experience in preparing Test Plans, Test Scripts and Test Cases on JIRA
• Highly proficient in writing user stories and facilitated story point discussions to analyze the level of effort on project specifications.
• Co-ordinated and assisted in System and User Acceptance Testing on all final business process and system products prior to operational deployment.
• Work Closely with Product Owner to maintain backlog, review stories, clarify requirements, prioritize defect, create epics and help story mapping. Conduct working sessions and walkthroughs of new functionality.
• Provide QA time estimates and assist in creating schedules, determine project scope and drive projects to completion.
• Represent the team in strategy meetings with Stakeholders to discuss and suggest possible future enhancements of existing functionality.
• Collaborate with site developers to modify and improve the data layer to improve analytics
• Work closely with the stakeholder, review development specification, identify and work to resolve tagging/ analytics gaps
• Performed End to End Testing, Regression and User Acceptance Testing.
• Involved in different test phase like Dev, QA, PRE-PRODS and PRODUCTION environment
• Performed Back End Testing by using Siebel and SQL developer tools for loyalty and rapid reward project.
• Developed and performed SQL queries to verify the database updates, delete and inserts of the records, extract data from target table and validate reports
• Verified request and response logs in corresponding log boxes by logging into the remote Linux machines through PUTTY
• Performed Security testing for unauthorized access of the application with positive and negative testing

Confidential, Kansas

Testing Lead

Responsibilities:

• ESP-ETL Migration testing with GLSR Reporting using Data masking Tool
• Verification of data transformation calculations and aggregation rules
• Data integrity and quality checks in the report system and Test data comparison between the source and the report system
• Reviewed and validated business requirements with Business Analyst, Technical Lead and SMEs.
• Interacted with developers and users to analyze the business requirements and functional specifications in an AGILE Development Environment.
• Validating Map reduce process, data, aggregation and seragation rules
• Generating reports for business users to validate if the data in the reports are as per expectation. It involves finding deviation in reports and cross-check the data in the target system for report validation
• Validating User Screen data, Error Messages that populated from database.
• Validation on Comparing the Source data landed on Hadoop
• Testing on Screen update values are loaded into the database
• Developed Test plan and created/executed manual test cases/test scripts to test the core functionality of the application
• Participated in all the AGILE ceremonies - Daily Standup, Grooming, Sprint Planning, Retrospective, End of the Sprint Demo and Product Backlog Meeting.
• Worked with POS System and involved in testing functionalities related to sales tracking, POS scanning, ordering forecast, adjustments, custom retail price and promotions in POS
• Involved in Integration, Regression, Performance, Validation, Functional and End-to-End testing on store and merchandising applications that interface with POS
• Created and maintained SQL queries to perform back-end testing. Created and executed scripts manually for Functionality testing.
• Involved in testing specific application features like adding/removing products to cart, order flow through, Email configurations as part of application testing
• Performed cross-browser testing to check the functionality of the application in various browser.
• Actively participated in the Review meetings for Functional Specifications Document and Technical Design Documents.
• Worked closely with stake holders and partners to lead the UAT efforts
• Logged defects in HP ALM and worked with Dev team to fix all of these.
• Assist Test Manager in managing day-to-day testing activities, such as test monitoring and status reporting at the end of the testing day.
• Created Traceability Matrix between requirement and test cases.
• Participated in Project Status and Defect triage meeting for the review of defects in Quality Center along with Business Analyst and Developers.

Confidential, Chicago

Responsibilities:

• Execution Monthly & Weekly cycle and completion of cycle within SLA.
• Need to analysis the compatibility between versions on New X86 server
• Validating the Data in backend updated by Batch Job.
• Validating Performance through Data ingestion, throughout and processing.
• Fixing the bugs and defects in data in the target system and running the reports again for data validation.
• Code review and providing solutions and performance improvement and optimization of the code
• Regular meetings with SME and developers and client on issues during Monthly cycle execution.
• Scheduling jobs at Tivoli and monitoring.
• Performance testing on Batch Program
• Project required in-depth analysis since it is directly installed on new Production Server.
• Customizing the graph based on the Data Load Request.
• On Any failure of job need to fixed immediately without affecting the production
• Co Coordinators with Onsite and requirement gathering

Confidential, Tennessee

Responsibilities:

• Analyzed functional specification and business scenarios.
• 7 Layer Migration project, performed analysis on all 20 Application’s Business flow and technical involved.
• Designed, developed and Performed unit tested Ab Initio graphs for the All-Bridge Matric projects.
• Extracted data from various sources like databases, delimited flat files and XMLs.
• Designed and developed parameterized generic graphs.
• Improved performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups in memory joins and rollups to speed up various Ab Initio graphs.
• Co Coordinators with Onsite and requirement gathering
• Coordinating with team during UAT defects
• Attending team meetings

Confidential

Development and Testing

Responsibilities:

• Analysis of Business requirements
• Coding using .Net and performing unit testing
• Coordinating with team during code review and debugging
• Attending team meetings

Confidential

Tech Lead

• Bug Fixing in Production Issues with in SLA Time on RPG IV, Pl/SQL,TRA/X, Triggers and Day-End Activities
• Created new automate Tool for Transfer Process Which it Transfer the Record From one system to other system and Sending Reports (RPG IV and PL/SQL)
• Maintaining and create new Programs in PL/SQL based on the Issues and client Requirement
• Involved in Designing and creating Indexes, primary Key and secondary key in DB2/400.
• Used structured programming input/output and logic control operations using RPGIV, RPGLE and CL.
• DB2 UDB Architecture/Server knowledge

Confidential

Senior Programmer

• Co-ordinate with UAT Team and fixing the bug immediately and ensure that it will move to production with in SLA.
• Unit and integration Testing and preparation of test results documents
• Prepare new enhancements and support other teams. Provide technical/business
• Project Path to keep track of code changes, object's modifications and history.

Confidential

Senior Programmer

• Review of Functional specifications which prepared by team member and raising the defects in People soft application.
• Unit and integration Testing and preparation of test results documents.
• Data storage & retrieval process using SQLRPG, SQL/400 and DB2/400.
• Adhere to the Project Execution Process to meet all department process standards
• Generating RPG IV and sub files through SYNON tool

Confidential

Programmer

• Developed complex SUBFILE using RPGIV,DB2 and RPGLE with handles multiples files at a time
• Used structured programming input/output and logic control operations using RPGIV, RPGLE and CL.
• Involved in designing and creating the Reports using SDA and RLU
• Validate and manipulate data using Query/400 and SQL/400