Results-oriented Data Scientist experienced in utilizing SQL and Python for data analysis and enhancing customer satisfaction. Expertise in creating automation frameworks and guiding teams, consistently delivering high-quality results in fast-paced settings. Strong problem-solving skills and a collaborative approach drive project success.
• Analyzed data from various sources to generate insights into customers' issue resolutions for AA letters.
• Performed exploratory analysis on large datasets using SQL and Python, using Jupyter Notebook to analyze datasets for exception monitoring for multiple products.
• Promoted high customer satisfaction by resolving problems with knowledgeable, friendly service.
• Worked on preparing documentation, aided in policy and procedure documents, SOPs, strategy requirements, and issue remediations.
• Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
Provided support and guidance to colleagues to maintain a collaborative work environment.
• Assisted with customer requests and answered questions to improve satisfaction.
• Extensively worked on preparing and documenting Functional/Regression Test Scenarios using Excel Sheets/Share Point/One Drive for various Rules Products within Collection Rules and previously, Revolve Rules Team, for example: GPL, GPL Pay Monthly, PayPal Negative Balance, PPC, VENMO.
• Worked with Strategy Team, Governance Team, Platform Team, UNP Team and other Teams for example, User Domain, VENMO for Rules Changes, requirement understanding, any queries that we get from all the Teams, Test result/Testing walkthroughs.
• Worked with UAT Test Framework Team to get the automation done by UAT Testframework Team for the Functional/Regression Testing scenarios. Sometime, for report.xml file changes, updating fields myself for my testing. In Revolve Team, had worked on automating scenarios in UAT Parser to validate scenarios using JAVA.
• Provided Knowledge Transfer/Mentored co-workers as needed for multiple products.
• Lead the effort to create pull requests for Ruleset Jars to go live, co-ordination of validation/walkthroughs/approvals, Elmo changes etc.
• Attended daily status meeting, defect review, test data and test case review, requirements understanding meetings, post code go live monitoring meetings.
• Using DataTrek, and SQL queries, Wrapper log, RBO Dump, RADD schema detail/queries, worked on debugging issues, test data/test result validation.
• After Rules code goes live, using Cal Log/Splunk, worked on performing post release validation to make sure, rule set version/functionality shows fine.
• Developed Automation framework using Selenium Web Driver, TestNG, Maven, Eclipse based on Page Object Model.
• Extensively used Selenium Web Driver, Test NG, Maven, Java, Eclipse for automating smoke test and regression test scenarios.
• Involved in Production Testing and UAT environment smoke testing after releases/maintenance.
• Performed backend testing for Electronic Licensing System using complex SQL queries to validate test results.
• Developed automated test suites for Rest based Services Testing using Postman for functional and regression testing.
• Participated in daily scrum meetings and project status meetings.
• Documented steps to configure Selenium Web Driver, TestNG, Maven, Eclipse, JMeter from scratch and provided walkthrough for these to my co-workers.
• Documented smoke test/regression test scenarios/Test Plan/Test Approach scenarios using Share Point/Microsoft Azure.
• Extensively used Selenium Web Driver/Selenium Grid, Test NG, Maven, Java, Eclipse IDE/IntelliJ IDE for automating test scenarios.
• Involved in production live Testing of eBay.com and off-eBay sites and developed automated tests for running the regression on eBay and off-eBay sites on daily basis.
• Within PayPal Credit worked on BAU Services, Batch, CSA, WSS, Co-ordination with UAT Team, GCE (Global Credit Expansion), Migration Projects, eBay - PayPal Split Cutover, and Production Testing.
• Developed automated test suites for Services Testing using Soap UI Pro for functional and regressiontesting.
• Provided Knowledge Transfer/Mentored co-workers on PayPal/PayPal Credit Apps/Components/Services domain knowledge, Soap UI Pro testing, Existing Selenium Automated test scripts walk throughs and demos.
• Extensively worked on documenting Test Plan/ Test Strategy/Test Scenarios using Excel sheet, Rally, Confluence.
• Developed Selenium JUnit/TestNG frame works and mentored the test team on the implementation of framework for regression testing in selenium.
• Helped define process and workflow of bugs/defects for JIRA and for test management tools.
• Developed Automation Framework for testing Web Services in SoapUI and SoapUI Pro.
• Used Groovy scripting to test web services and maintain SoapUI automation framework.
• Designed requirement traceability and verification matrix (RTVM/RTM) of the test cycle.
• Hosted defect reviews to go through priority 1 and 2 defects in JIRA and get the Blocker defects resolved ASAP.
• Conducted daily test status meeting with QA team to raise questions/concerns/blockers during test cycles and to get test status from the team.
• Involved in problem solving and facilitating brain storming sessions to analyze requirements and testing of software.
• Attended daily scrum meeting, defect review, test data and test case review, requirements decomposition meetings, Agile scrum/stand up meeting, routine sprint planning meetings, grooming meeting, sprint retrospective, bi-weekly project meetings, on call review meetings, and design reviews.
• Interviewed QA testers for technical skills.
• Facilitated knowledge/brown bag sessions for selenium testing.
• Worked with multiple teams, multiple projects within PayPal/PayPal Credit.
• Followed Hybrid Methodology (Agile and Water fall model).
• Developed and executed test cases for Mozart decision engine based on RTM for different
scenarios.
• Performed web services testing using SOAP UI Pro.
• Participated in rule reviews.
• Worked with Selenium IDE and Selenium RC, JUnit to develop functional test cases.
• Created test scripts using selenium RC and Eclipse.
• Performed backend testing using complex SQL and PL/SQL Queries to validate the test results.
• Extensively used SOAP UI Pro to develop and execute test cases for rule testing for Quick App Request and Pricing Request.
• Using SOAP UI Pro created data source, data source loop, data gen, data sink performed property transfer and automated majority of my test cases for regression test suite.
• Provided training to my co-workers on SOAP UI Pro.
• Extensively used Team Track for reporting issues to project team and management during test cycles.
• Used Update Case Request to create cases in Mozart UI for reporting issues.
Software/Applications:
Jupyter Notebook, Big Query, Selenium Web Driver, Eclipse, Microsoft Azure, IntelliJ, Quick Test Professional (QTP), JMeter, Quality Center, SOAP UI, SOAP UI Pro, Team Track, Doors, Microsoft Visio, Visual Source Control, MS Excel, MS Word, MS Power Point, GIT, Git Hub, Load UI, Fusion, Subversion, MS Project, Adobe Photoshop, Remedy User, XML Marker,
Apache/Tomcat, Web Logic, Web Sphere, Share Point, Micro Strategy,
SCCM/SMS, PVCS Tracker, Version Manager, Mozilla Firefox, Chrome, Safari, Edge, Internet Explorer, Share Point, TOAD, BURP, My SQL Work Bench, MONGO DB, Firebug
Programming Languages:
C, C, Java, J2EE: Oracle 10g,11g, Ruby, Shell Scripting, SQL, PL/SQL, XML, HTML, XSD, XSLT, VB Script, Groovy, Python3
OS/Databases:
MS Windows, UNIX, Linux, Oracle, Microsoft Access, Microsoft SQL Server, DB2, Sybase, Firebird, Mongo DB