SUMMARY:

• Over 7 years of Experience in Designing, Analysis, Development and QA in the Business Intelligence, Client Server Technologies, Web - based Applications and Databases and Experience in industries such as Pharmaceutical, B2B, Financial, Educational, Marketing, Telecom/IVR Services, Government Projects.
• Experience in all the Latest BI Tools Tableau, Qlikview and Power BI.
• Experience in complex BI Reports, Dashboards, Project Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time Management.
• Proficient in data quality analysis for dashboards and other applications.
• More than 2 and ½ yrs Experience in Tableau Dashboards in latest Design and Presentation.
• Experience in analyzing/testing backend data for iPhone, iPad and Android apps.
• Experienced in in analyzing/testing data for web sites/applications as well as E-Commerce Applications in multiple platform developed using HTML, CMS(Wodpress and Drupal)
• Validation experience for Design Qualification, Installation Qualification, Operational Qualification, Performance Qualification (DQ/IQ/OQ/PQ).
• Expertise includes all levels of Quality Assurance and Testing - from development stage, software requirements definition and documentation to User Acceptance testing. Gathered requirements definitions, written validation plans, test plans, test scripts and test summary reports.
• Extensive Back end testing experience using SQLs
• Executed black box testing and white box testing, manual testing, system and regression testing. Extensive experience in manual testing as well as automated testing using Mercury tools and Selenium.
• Written documents for System testing. Editing and playback the scripts. Strong skills in SQL Queries and testing .net application.
• Extensive skills and working experience in Quick Test Pro (QP), Win Runner, Load Runner, Test Director, QC. Possess excellent organizational, analytical and problem solving abilities with strong interpersonal and written communication skills.

TECHNICAL SKILLS:

Analytics Tools: Tableau(Server/Online/Public/Reader), Qlikview(Knowledge), Power BI

Database & Tools: DW, SQL Server 2012, 2008, 2005 (SQL), Oracle 8.x/9i/10g (PL/SQL), MS-Access, Postgres, ETL(SSIS)

Testing Tools: Selenium, Quick Test Pro 8.2/6.5, ClearQuest, Win Runner 8/7.5, Load Runner 8/7.5, NUnit, JUnit, Defect Detecting Tools Quality Center, JIRA, Clarify.

Web Tools: ASP, HTML, DHTML, XML, VB Script, Java Script, Visual Basic, Internet Information Server, Apachi Tomcat, Personal Web Server, Python.

Version Control: Visual Source Safe, Surround SCM, SVN

Tools: MS Office, MS Project and Visio

Operating System: Mac(Mountain Lion), Jelly bean, iOS, Microsoft Windows 7/8/10, XP, Vista, 2000, 95, UNIX

Device: iPad(2, Air, Mini), iPhone(4, 4s, 5C, 5S), Android(Galaxy S3, S4), Ultrabook.

PROFESSIONAL EXPERIENCE:

Confidential, (Plainsboro, NJ)

Tableau Developer/Data Analyst/QA

Responsibilities:

• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location.
• Used different features of Tableau to create drill-down, filter and interactivity based on user requirement Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets.
• Participated in project initialization. Worked on creation of POC for the project.
• Understood the flow of entire Endowment process.
• Gathered the data and resolved various quality problems associated with the data..
• Developed dashboards using Tableau Desktop.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Performed duties as a Data Quality Analyst in Analyzing and documenting test cases.
• Wrote SQL on day to day basis to test and extract the test data.
• Analyzed and reviewed System design and client requirement.
• Compared the target data with the source data.
• Performed QA on BI application developed using tableau for clients.
• Validated system against the specified requirement.
• Participated in status update meetings.

Environment: Tableau, MS Office, Oracle, PL/SQL, SQL Loader, SQL Developer, MS Access, Python, HTML/DHTML, PHP, SQL Server 2008, JIRA, BI Dashboard, Tableau.

Confidential,

Tableau Developer/Data Analyst/QA

Responsibilities:

• Responsible for identifying, comparing and resolving various data quality problems.
• Run extensive test scripts to test the quality of the data.
• Performed duties as a Data Quality Analyst in Analyzing and documenting test cases for different projects.
• Used Tableau Analytic tool to visually present the data according to the client’s need.
• Wrote high level PL/SQL programs.
• Performed white box testing for PL/SQL codes written for data processing.
• Wrote SQL on day to day basis to test and extract the test data.
• Used SQL loader to load the data to the system collected from different source.
• Analyzed and reviewed System design and client requirement.
• Compared the target data with the source data.
• Performed QA on BI application developed using tableau for clients.
• Validated system against the specified requirement.
• Participated in status update meetings.

Environment: Tableau, MS Office, Oracle, PL/SQL, SQL Loader, SQL Developer, MS Access, Python, HTML/DHTML, PHP, SQL Server 2008, JIRA, BI Dashboard, Alteryx,Tableau

Confidential, Mendham, NJ

MLL/ (Data Quality Analyst)

Responsibilities:

• Performed QA on databases/Reports providing data to be used on multiple devices..
• Used multiple devices to run extensive test scripts.
• Participate in data quality investigations and analyses, and diagnose root causes and make recommendations.
• Heavy use of SQL queries to find the accuracy of data.
• Clean and scrub data, and implement data quality best practices.
• Performed duties as a QA Analyst in Analyzing and documenting test cases for one of the biggest app RCI for Wyndham.
• Worked for multiple clients(Wyndham, Novartis, MLL, Connell).
• Involved in creating test plans, test cases, test data for various projects with focus on manual testing.
• Prepared verification elements from user stories and wireframe with a very limited information.
• Created hundreds of test cases using JIRA for larger projects.
• Worked closely with developers.

Environment: MS Office (Mac Version), iOS, Jelly Bean, JSP, Java Script, HTML/DHTML, PHP, SQL Server 2008, JIRA, Windows8, Windows 7/XP, Java, Oracle Virtual Box.

Confidential (Mahwah, NJ)

Quality Analyst Backend and Frontend

Responsibilities:

• Grasped a better understanding of Speech technology and worked closely with Confidential and Confidential project as QA engineer for testing Confidential Dragon a new project of Confidential in Collaboration with Confidential which included design reviews, defining testing strategies, designing test cases and other testing requirements and was specially designed for next generation ultra-books.
• Worked in an iterative, agile environment, with the ability to react to changing priorities.
• Performed fact finding and analysis for problem solving for business applications.
• Worked for two of the major clients of Confidential.
• Involved in creating test plans, test cases, test data for various IVR projects and NON-IVR projects with focus on manual testing.
• Performed peer review on verification elements prepared by offshore team.
• Executed SQL queries on the various back-end databases extensively to verify GUI results on Confidential projects.
• Created and run test cases for IVR as well as internal admin tools (web application).Executed test cases manually.
• Worked as a QA lead on various projects which involved various design and quality metrics for IVR systems, worked closely with VUI designers, IVR developers, project managers and software developers.
• Involved in testing Web services and XML with tool called ‘SOAP UI’.
• Involved in both SOAP and Restful web services for DIVR application.
• Participated in daily scrum/status update meetings.
• Worked in the Agile environment with frequently changing requirements and features

Environment: SDLC, MS Office 2007, JSP, Java Script, HTML/DHTML, SQL Server 2008, JIRA, Windows8, Windows 7/XP, Borland star team, ATCG

Confidential, NYC

Lead/QA Analyst Backend

Responsibilities:

• Performed Web Site functional testing in SI and QA environment.
• Performed various data entry functions and verification.
• Worked on data verification and validation during database merge.
• Analyzed Functional Requirement Document and Developed test procedures. Organized and Documented test process like Developing Test Plans, Conditions and Test Scripts for front end and backend testing.
• Performed Crossed Browser testing using IE, Firefox, Chrome, Safari browser on different set of data.
• Performed mobile web sites testing using iPhone, Android, Blackberry.
• Performed database validation test using SQL server management studio.
• Performed report data validation testing on reports developed using Crystal Reports.
• Conducted Positive and Negative Testing .
• Performed integration, Regression and User acceptance testing
• Rechecking /Reassigning/Closing the defects depending upon its status.
• Involved in testing PayPal, Google web services for integration with the client payment processor and geo location integration.

Environment: SDLC, Clear Quest, MS Office 2003, JSP, Java Script, HTML/DHTML, Endeca Search, selenium, SQL Server 2008, CMS, JIRA, Windows 7/XP, Word press, PHP, XML, REST, UNIX, SOAP UI

Confidential, Somorset, NJ

TMW(QA Analyst)

Responsibilities:

• Performed System Integration testing in SI environment following FDA guidelines.
• Analyzed Functional Requirement Document and Developed test procedures. Organized and Documented test process like Developing Test Plans, Conditions and Test Scripts
• Worked using Agile methodology in a fast moving environment.
• Executed SQL queries for database testing
• Provided weekly update to Scrum master on defects (open/close/ready for validation) in the Clear Quest in System Integration Environment.
• Uploaded the output from System Integration testing on CMI Portal.
• Performed Backend and Report testing by executing the queries.
• Assigned defects to developers day to day basis, discussed with them about the defect before assigning.
• Rechecking the defects after it ready for validation.
• Reassign/close the defects depending upon its status.
• Performed extensive database testing such as update, delete and creating new patient record using SQL commands.

Environment: Agile Scrum, Clear Quest, CMI Portal, MS Office 2003, JAVA, XML, SQL Server, Crystal Report, MainFrame, QC.

Confidential, New Jersey

Mail Order Management (MOM)

Responsibilities:

• Performed Validation testing in Validation environment.
• Developed validation Quality Plans/Scripts, generate and support DQ/IQ/OQ/PQ and validation protocols and reports
• Based on FDA 21 CFR Part 11 validated the MOM system for electronic signature capture.
• Generated Signature Audit letters part of validation testing
• Performed System testing in ST environment.
• Analyzed Functional Requirement Document and Developed test procedures. Organized and Documented test process like Developing Test Plans, Conditions and Test Scripts
• Performed System Functional testing using IE browser.
• Experienced in writing NUNIT Test cases for applications developed in .Net framework.