SUMMARY

Data scientist candidate having around 5 years of experience working in various domain with demonstrated data, analytics, reporting and problem-solving skills. Proficient in R, solid understanding in statistics and in-depth training in Tableau visualizations. Adept at analyzing and manipulating data to develop and serve valuable insights.

GitHub link: https://github.com/jishakarthik/Capstone-Final-Project

EXPERTISE

Exploratory data wrangling, analytics and visualizing important characteristics and statistical properties of dataset using R and ggplot2. Experience in applying a variety of predictive modeling and machine learning techniques

Demonstrated data analysis experience using Kaggle’s competition data set. Experience with using linear and logistic regression, decision tree and random forest. Basic competence in probability and statistics

Experience in cleaning and analyzing data in R. Familiarity with relational databases and SQL-like query languages

Knowledgeable in various versions of Tableau desktop and server, familiarity with UI designing

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization, making use of actions, other local and global filters optimized connections, data extracts, prepping, cleaning and refreshes. Created and maintained complex dashboards in Tableau. Perform migration and deployment of dashboards across multiple Tableau servers

Experience including technical support, troubleshooting, report design and monitoring of system usage

Expertise in designing and creating various analytical reports and interactive dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization

Administer and supervise all Tableau servers which include creation and maintenance of users, user groups, roles, assigning security on projects/sites, automate background tasks and maintaining the servers

Good working knowledge of metadata management in consolidating metadata from disparate tools and sources including data warehouse, ETL, relational databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis

Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications. Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile. Experience in facilitating requirement planning sessions with business user groups

Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM), remarkable ability to set QA testing objectives

Strong knowledge of test automation and data analysis, created and executed end-to-end test plans

Expertise in functional and nonfunctional testing of web based applications, and batch applications

Experience in Selenium and QTP to develop automated solutions for testing.

Successful teamwork experiences and demonstrated leadership abilities in fast paced environments

SKILL SET

Specialties

Data Visualization, Business Intelligence (BI), Software Management and Data Collection.

BI Tools

Tableau 8.x/9.x/10.x, OBIEE 10g,11g, SSRS

Relational Databases

MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, MS Access.

Tools and Packages

SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, HP Quality Center, Fire bug, QTP, Jira and Selenium, RStudio, ggplot2

Languages

C++, VB Script, SQL, PL/SQL, Java, R

Operating Systems

Windows 2000/2003,2008 Server, Windows 95/98/2000/XP, Linux

PROFESSIONAL EXPERIENCE

Dec 2013 – Sep 2014

Global Experience Specialists

Las Vegas, NV

EBS Tester

Global Experience Specialists, Inc. (GES) are a leading global provider for live events, offering a comprehensive range of services, including creative design, strategy, audio visual, show production, and event accommodations – all with an unrivaled global reach.

Roles and Responsibilities

•Prepares test plan documents, Documents test cases and identified system defects as required

•Creates, updates, and runs test scripts. Analyzes failure/success of scripts and makes modifications as required. Utilizes documented test cases to perform multiple tests on software systems

•End-user experience on Oracle EBS or comparable ERP platform, General understanding of basic database structure concepts and familiarity with data queries using SQL

•Verifies all possible software end-user scenarios to ensure functional and technical requirements have been met. Oversees execution of test plan, continually analyzing test efforts for completeness

•Performs system integration, functional, and user interface testing on modifications and enhancements prior to production releases. Document test data requirements as needed for system test execution

•Provides feedback to Project team on the current status of modifications and enhancements being tested

•Attends requirements/design review, project team meeting and user meetings as required

•Reports project test metrics to include such items as time allocated, problems found, and enhancements requested as a result of new functionality, and defect status

Environment: Linux, Windows, CA, Oracle EBS, MS Office, Jira

Oct 2012 – Nov 2013

Corinthian Colleges

Camarillo, CA

QA Analyst

Corinthian Colleges, Inc. (CCI) is the largest post-secondary education companies in North America. Acted as a QA analyst, performing various functions within the QA group to build, continuously enhance, maintain bug free, reliable and simple quality products and internal application software.

Roles and Responsibilities

Analyzed system requirements specifications, developed test plans, test cases, and test data for testing the functionality, GUI, compatibility, performance, usability and user acceptance of the application

Executed test cases and collaborate with development team to remediate issues. Wrote SQL queries to retrieve data from the database. Involved in GUI, functional and regression testing using QTP

Use SQL injection and cross site scripting tools to test for vulnerabilities on browser

Use tools like Firebug to look for error logs when testing browser based applications. Errors displayed in the Firebug console tab were added to defect tracking report to assist developers in troubleshooting the defect. Perform normal analog and low-level recording

Run test cases in batch mode. Created recovery scenario manager. Modify, add, edit and update object properties in object repository. Expert with creating shared object repository

Use GetROProperties for capturing property values from application for creating customized check points.

Totally comfortable with modifying test report for using reporter event functionality

Thorough experience with various check points such as standard check point, bit map check point, text check point, text area check point, data base check point, xmlcheck point, table checkpoint

Assisted developers in isolating and resolving defects

Analyzed application, system, and security errors. Escalated issues to developers and verified fixes

Maintained test logs, test summary reports and participated in defect review meetings

Identified and implement improvements to current QA processes and test standards

Environment: Linux, Java, VB Script, MS Office, HTML, Oracle

Nov 2010 – Jul 2012

DIRECTV

Thousands Oaks, CA

QA Analyst

DIRECTV Broadcast Systems Engineering group which is responsible in leading the concept, design, development, integration, and test of all new head-end audio/video technologies. DIRECTV is the industry leader in introducing new audio/video technologies to the world. As a test engineer, responsible for functional test, verification and quality assurance of the systems test activity for new Broadcast Systems projects and initiative.

Roles and Responsibilities

Reviewed project specifications and working with other organizations (both within and outside of Engineering) to understand the systems requirements of the project, including the system architecture, design, internal and external interfaces, use cases, etc.

Generated system test plans to validate system requirements and functionality as documented in the system specifications. Generated test reports to document all test results

Developed test scenarios and generate test procedures to properly and rigorously test the system requirements and functionality. Identified, analyzed and document defects discovered during testing

Performed software integration and troubleshooting of multiple applications involved in the projects under test. Performed regression testing as needed for current Broadcast Systems projects

Executed tests to validate the requirements and functionality for the project specifications as detailed in the test procedures. Worked with the development teams to troubleshoot and resolve issues

Environment: Java, C/C++, XML

Feb 2010 – Oct 2010

Automatic Data Processing

Camarillo, CA

Software Tester

Automatic Data Processing, Inc. (ADP) is one of the largest providers of business processing and cloud-based solutions – including payroll, talent management, human resource management, benefits administration and time and attendance – to employers and automotive dealerships around the world. Software tester collaborates on product design, test strategy, test case creation, manual and automated testing, scheduling of work, test case execution, troubleshooting, test data analysis and reporting.

Roles and Responsibilities

Worked within team to test new software developments, documented test results, undertaken maintenance work

Produced documentation required to release the software products as defined by the test plan. Ensured that all test results are documented, signed off and any remediation items are planned for delivery

Participated in periodic peer reviews. Worked with the test analyst to ensure that defects are tracked and documented and results communicated to developers and stakeholders

Executed test plans based on approved quality standards, ensuring that there is traceability with requirements and documentary evidence of adherence to the plan

Prepared data for testing the test cases and highlight potential discrepancies to senior QA leads and if required, product owners. Conducting re-testing based on the application

Created test scripts based on business & functional requirements and design documents

Performed functional testing manually and constructed positive and negative test scenarios as per requirements. Executed tests automated and manual performance, scalability, load and stress

Prepared the final test reports and reviewed with the lead and managers

Environment: Unix, Linux, Oracle, SQL/PL SQL, MS Windows, HTML, XML

EDUCATION

Montessori Teacher Certification, American Montessori Society

Certification in Medical Terminology, University of Houston

Certificate Program in Public Relations, UCLA Los Angeles

Diploma in Software Engineering, Datapro Institute of Technology

Bachelor of Arts in Political Science, University of Calicut

Contact this candidate