SUMMARY OF QUALIFICATIONS

• 5 years of IT experience including 3.6 years of experience in QA Manual/Automation Testing and 1+ year of experience using Teradata/Big data Technologies.
• Experienced in Preparing Test Plans/Cases/Strategy/Scenario's, Test data, Test log and Defect Reports.
• Hands on experience on all levels of Integration/Regression/Configuration/Functional/System/Manual/Unit and Smoke testing to ensure web applications are Defect - free.
• Gained experience in Data analysis as we were using three sources at a time (Teradata, Impala and SAS datasets).
• Strong data analysis and SQL skills in Relational and Big data environments (Joins, Union, rank, group by, etc.).
• Performed compatibility testing of an application under using HTML IDs and XPATH in SeleniumWeb Driver.
• Developed core modules in large cross-platform applications using Java/JavaScript, XML, and HTML.
• Responsible for generating ongoing monitoring reports using Tableau on a Monthly/Quarterly basis.
• Involved actively in creating SQL scripts from scratch and testing/Debugging the scripts and fixing the code.
• Skilled in using Junit and TestNG to create test framework using selenium web driver.

TECHNOLOGIES:

• Apart from my Real Time Experience I am also very much strong in SQL (Teradata, MYSQL, Netezza) and No SQL (HBase, Elastic Search) Databases.
• I am also strong in Big Data Technologies like HADOOP, HIVE, SPARK, SQOOP, PIG.
• I also have real time Financial and personal sports Analytics experience.
• I have a strong Functional programming Experience using Scala and Python(Basics).
• I am also strong in Data warehousing/ETL Design/Data Modeling Concepts.
• I also have personal Cloudera Distribution experience.

PROFESSIONAL EXPERIENCE:

Software Developer

Confidential - San Francisco, CA

Responsibilities:

• Involved in creating PD, EAD, LGD data models on Credit cards, Auto loans, Mortgage loans products.
• Worked with Data Modelers, ETL staff, Business System Analysts in Functional requirements reviews.
• Involved in Using various software tools like Tableau, Toad, SVN, SAS, Teradata SQL/Teradata studio express.
• Involved in creating tables and debugging SAS datasets using Proc SQL.
• Involved in giving KT sessions to the newly joined and Created Models based on financial products.
• Experienced in database programming i.e. writing of the SQL, stored procedures, views on Teradata.
• As part of coding used complex SQL functions and performed Unit Testing on the developed code.
• Created SQL scripts for production models and monitored model performance of each product every month.
• Worked on databases including Netezza, Teradata, and Impala.
• Worked with Data Modelers, ETL staff, Business System Analysts in Functional requirements reviews.
• Extensively worked with Teradata utilities like Fast Export, Fast Load, to export and load data from flat files.
• Developed the Teradata stored procedures and scripts based on the technical design documents.
• Involved in Using various software tools like SVN, SAS enterprise guide, Teradata studio express, WinSCP.
• Part of code migration involved in creating tables and debugging SAS datasets using Proc SQL.
• Every Month/Quarter end was responsible for generating Ongoing Monitoring/Flash Reports through Tableau.
• Involved in data reconciliation by risk factors (segment, Fico score, date, etc.) and created data mapping documents.
• Created Internal/External/Volatile/Permanent tables as part of developing production data models using SQL.
• As part of data migration Involved in Impala data quality checks and make sure there are no nulls/blank records.
• Responsible to visualize the business requirements into tables/graphs/ with detailed data analysis using tableau.
• Used various flat files/Servers and Nested SQL queries to generate reports using Tableau.
• Converted developer’s logic into design documents which helped stake holders to understand the data models.
• Experience with analytical manipulation and interpretation of large SAS data sets.
• Developed nested SQL queries for Tableau dashboards and created calculated fields to show detailed trend analysis.

Environment: Teradata, Netezza, SAS, SVN, Tableau/Desktop/Online, Toad, SQL, Proc SQL, Fast Export, Excel, Fast Load, ImpalaExcel, Teradata SQL assistant/Studio Express, Data Modeling.

Programmer Analyst/QA Tester

Confidential

Responsibilities:

• Tested by publishing sample News on Media’s website.
• Written automation scripts for Regression test cases and executes using Selenium.
• Used to publish sample test releases from back end and used to test the content on client website (like more space between paragraphs is there or not, special characters are getting displayed are not).
• Prepared Test Plan, Test Cases, and developed multiple Test Scenarios for Automated Regression Testing.
• Involved in Testing web application and Documented all observations and bugs in an excel sheet.
• Taken ownership as QA Lead and responsible for building/maintaining the test environment/regression bed.
• Getting walkthrough on new requirements from clients.
• Prepared and Execution of test scripts using Selenium IDE/Web Driver, Eclipse.
• Involved in Test case design for Web/Mobile applications.
• Involved in Team meetings with development team to review the newly found Defects and observations.
• Tested compatibility under various cross browsers various elements identifying techniques (ID, Name, Xpath, CSS) using SeleniumFramework.
• Involved in Functional and Regression Testing.
• Involved in raising defects on Open source bug tracking tool JIRA and assigned it to developers.
• Involved in writing Functionality test cases and involved in QA Testing when a new build deployed.
• Performed functional testing to identify various critical points in the application and automated it by using SeleniumWeb Driver.
• Prepared weekly and daily status reports for onsite managers.

Environment: Eclipse, JUnit, Selenium IDE/Web Driver, Agile, JIRA, Firebug, windows, Fire path, MS Office, Manual/Regression Testing.

Programmer Analyst/QA Tester

Confidential

Responsibilities:

• Involvement in all the stages of (SDLC) like requirements gathering, reviews, test documentation, application testing, and defect reporting.
• Involved in all the Test cases design and Test execution whenever the new build is deployed.
• Used Travelers Product Designer to fix any bugs or any issues identified during the testing period.
• Written test cases for Unit testing using JUnit on eclipse.
• Tested and debugged HTML content to make sure correct version of a child UI view items is displayed when we select a parent view item.
• Involved in Configuration/ Manual/ Unit/integration/Smoke testing to ensure web applications are Defect-free.
• Used Product Designer tool to configure new UI drop down boxes, radio buttons and text boxes as per requirements.
• Involved in Waterfall Methodology and tested the web applications after development is completed.
• Involved in creating test cases for new defects and involved in Test execution once these defects are fixed.
• Created regression test cases for future s to make sure there won’t be any code break in future.
• Whenever new build is integrated to applications we used to test and run regression Test Cases using Selenium.
• Performed browser compatibility testing of an application using HTML IDs and XPATH in SeleniumWeb Driver.
• Experienced in developing Test scripts and automated them with Selenium IDE / Selenium Web Driver.
• We used to run XML’s using SOAP UI of a policy, to test whether the XML file values were prefilled or not.
• Creation and execution of automated software Test plans, Test cases and Test scripts using Selenium.
• We used to validate UMB, Master Pac/Plus customer polices accounts using SQL queries (MYSQL).
• Getting walkthrough on new requirements from my onsite leads and Prepared weekly/daily status reports.
• Used to Find the defects in system testing/System Integration Testing and we used HP ALM QC to raise the defects.
• Prepared high and low-level design documents for the business modules for future s and updates.

ENVIRONMENT: XML, Excel, Test case/Scenario design, HTML, JavaScript, HP Quality Center. Selenium IDE/web driver, Firebug, Fire path, Eclipse, SOAP UI, Product Designer, SQL, MySQL, Account manager, Web/System Testing, Waterfall, Citrix.