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