SUMMARY

• 14 years of experience in Data Analytics, Data Visualization and Software QA Testing.
• 5+ years of extensive working experience in Data Analytics and Business Intelligence Technologies understanding large and complex data, deriving data insights, data transformation, planning, developing and maintaining reports/dashboards using tools/platforms like MS Power BI, Incorta, Excel.
• Expertise in writing SQL query, Power query, DAX formula and designing skills to present data in innovative, interactive and understandable reports/dashboards.
• Basic understanding of Informatica and Splunk.
• Possess strong experience in Testing - Web applications, Desktop Applications, Mainframe testing, Web Service Testing, Cloud Server Provisioning Testing, AirWatch Managed iPhone Testing
• Well versed with Estimation, Requirement Analysis, Risk Analysis, Scheduling, Test Strategizing, Resource Planning, Test Planning & Execution, Defects Management and Reporting.
• Proficient in Stakeholder management and working with Product owners to understand business requirements and expected deliverables.
• Experience in both Waterfall and Agile methodologies.
• Good knowledge of ITSM - IT Service Support workflows.
• Strong Analytical, Decision Making and Communication skills.
• Received Client appreciations and recognition for understanding their requirements and delivering quality work within planned timelines.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile (Scrum)

Databases: MS SQL Server, MySQL, Oracle, IBM DB2

Data Analytics: MS Power BI, Incorta, Power Query, Power Pivot, Excel, M query, DAX, SQL

Project/Test Management Tools: Micro Focus ALM, JIRA, Azure DevOps Server, IBM Rational Quality Manager, IBM Rational ClearQuest, qTest Manager, Rally

Test Automation: Micro Focus UFT

Web Service Tools: SoapUI, Postman

Version Control: IBM Rational ClearCase

Ticketing Tool: BMC Remedy, ServiceNow

Others: MS Office tools, Notepad++, Beyond Compare, BMC Server, Automation (BSA), BDSSA, VMware, vSphere, vRealize Automation, (vRA), vRealize Orchestrator (vRO), Putty, SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Requirement gathering and wireframe design for reports/dashboards.
• Develop Power BI Dashboards for Test Management, Resource Management
• Environment Management, Performance Testing, Application Security Testing and Test Deliverables/Process Hygiene check.
• Create data connections in Power BI and extract data from various data sources e.g.
• Excel, SQL, MySQL, PostgreSQL, Amazon Redshift, Web, SharePoint, JIRA, ALM, Azure DevOps Server (Boards Only), OData Feed.
• Data Transformation at ETL Level using Incorta tool or at Power BI level
• Writing complex SQL queries/logics to extract data from multiple tables for reporting purpose.
• Handling Performance Tuning activities and query optimization for SQL queries.
• Relationships management among different data sets in Power BI.
• Creations of measures / calculated columns to achieve metrics logics.
• Use different visuals like cards, charts, graphs, tables, matrix, slicers etc. to display required metrics in reports/dashboards.
• Use date dimension, bookmarks, What If parameter, different types of filters, buttons etc. to develop reports/dashboards.
• Configuring Power BI data sources under Power BI gateway, scheduling data refresh and publishing reports/dashboards in Power BI Cloud.
• Fixing issues reported in published reports.
• Status Reporting and Review meetings with Client Manager and stakeholders.
• Software Testing Process Compliance check and data governance.
• Documentation and Trainings for reports/dashboards developed.

Confidential, Hartford, CT

Technical Test Lead

Responsibilities:

• Web service testing and automation using SOAP UI.
• Usability Testing for Windows 10 Upgrade.
• AirWatch Managed iPhone Testing.
• VM Provisioning validation in vShpere client and vCenter Server.
• Estimation using SMC Estimation Model tool and Resource Planning.
• Requirement analysis.
• Preparing Test Strategy and Test Plan.
• Test Management and Defects Management in HP ALM.
• Execution of complex Test scenarios.
• Exploratory and Negative case testing to validate robustness of tools integrations.
• Test Results Reporting and Production Checkout support.
• Walkthrough of QA deliverables to clients and get their sign offs.
• Support HP ALM Upgrade Testing.
• Support PQL activities for tools integration, application server sunset etc.
• Coordinating with clients, stakeholders and offshore team.
• Ensure Process Compliance and Best practices followed during STLC.

Test Analyst

Responsibilities:

• Coordinating with clients and offshore team.
• Estimation using SMC Estimation Model tool and Resource Planning.
• Requirement analysis
• Preparing Test Strategy and Test Plan.
• Test Management and Defect Management in HP ALM.
• Execution of complex Test scenarios.
• Test deliverables Review and Results reporting.
• Production Checkout support.
• Walkthrough of QA deliverables to clients and get their sign offs.
• Ensure Process Compliance and Best Practices followed during STLC Documentations and knowledge sharing within/across teams.

Confidential

Test Analyst

Responsibilities:

• Validate mainframe and windows-based applications under Network & Provider area.
• Co-ordinate with clients, Business Analyst and Developers at various stages of STLC and manage team.
• Subject matter expert for Strategic Contract Management (SCM) Application Test data creation for downstream applications.
• Requirement analysis.
• Test designing and execution in HP QC.
• Executing Automated scripts using HP UFT.
• Defect Management using IBM Rational ClearQuest.
• Test Results review and reporting.
• Production Checkout support.
• Configuration Management using IBM Rational ClearCase.

Confidential

Test Engineer

Responsibilities:

• Validate functionalities of applications under Network & Provider area.
• Requirement analysis.
• Test designing and execution in HP QC.
• Executing Automated scripts using HP UFT.
• Defect Management using IBM Rational ClearQuest.
• Test Results review and reporting.
• Production Checkout support.
• Configuration Management using IBM Rational ClearCase.

Confidential

Test Engineer

Responsibilities:

• Validate User Interface and Post Order functionalities of retail e-commerce websites.
• Test Case Designing.
• Test Case Execution.
• Defects Management using JIRA tool.
• Test Results reporting and coordination with stakeholders.
• Maintaining Test artifacts using SharePoint and VSS.