PROFESSIONAL SUMMARY:

• Accomplished and result - driven Quality Assurance professional with over 15 years’ experience in quality assurance, design, and verification in teh software industry. Experience in Oil and Gas, Healthcare, Finance, and sector.
• Experienced in software design, development, testing and deployment of Data Warehouse, Mobile, and Web applications (SaaS, PaaS, IaaS environments)
• Very good experience in performing in data validations in Azure environments using python and Scala Notebooks
• Developed keywords in Python to automate teh existing claims application
• Utilized a variety of Open-source tools (Selenium, Appium, Cucumber, TestNG) and Commercial tools (Katalon, HPE, SmartBear) for test automation
• Experienced in Maven, CircleCI, Jenkins, TeamCity, Bamboo, GitLab and other CI / CD tools
• Created scripts to compare record counts, file counts, schema comparison, duplicate testing for teh On-Prem and Cleansed Azure Data Lake Storages
• Very good experience in Informatica (ETL Load), Performed Extraction, Transformations and Loading of data from Mainframe, Files, Databases.
• Worked in Active Directory, Single Sign (SSO) on requirements testing.
• Experience is using multiple Databases MongoDB, SQL server, Databricks
• Implemented teh Azure Dev Ops - Boards, Sprint Backlogs, Azure Test Plans, Permissions, Project Configurations, Share Point Sites for team
• Strong SAP HANA, BW experience with in-depth technical skills in Data modeling, Data Extraction, Data Loading (Full and Delta), Scheduling, Monitoring, Reporting, Security, Performance tuning, Troubleshooting etc.
• Expertise in Data Modeling using MDM and BW extended star schema models.
• Expertise in project planning, scheduling, coordinating of team members and analyzing user requirements
• Possess excellent communication skills along with verbal and written skills.
• Highly motivated team player with excellent communication, presentation, and interpersonal skills, always willing to work in challenging and cross-platform environment

TECHNICAL SKILLS:

Software Testing tools: ALM, UFT, Load Runner, MTM, jMeter, Selenium, Protractor, TestComplete, Tosca, Cucumber, JUnit, NUnit, Coded UI, Katalon Studio, Test Architect, SAP - TAO, Maven, TestNG, Postman, Appium, Lambda Test, SmartBear, jMeter, CodeCept Protractor, Cucumber, Appium, PySpark

Data Streaming/Microsoft Technologies: Rabbit MQ, Kafka, Kinesis, Spark ADP - SSO, AzureDevOps (ADO), Azure Data Bricks (ADB), Data Lakes, Power BI

Message Queue / Misc.: RabbitMQ, REDIS, NDM, Autosys

Scripting / Programming: HTML, CSS, JavaScript, jQuery, Python

Framework: Angular, Ruby on Rails, Django, ASP.NET

Content Management: WorldPress, Wix, Shopify, SquareSpace

SAP: R/3: 4.6 C, ECC 6.0, FI, MM, SD, BW 3.1/3.5/7.0, BI content, BEx, Web Application Designer, Query Designer, and Report Designer, ECC6.0, Ariba, Solution Manger, Change Request Manager (ChaRM), SAP TAO

Databases: MongoDB, CosmoDB, Oracle, MS SQL Server, Teradata, Netezza, Essbase, Hyperion, Informatica Data Quality

API: Fiddler, Swagger, SOAP, REST, SOA, Postman

Dev-Ops Tools: Git, GitHub Docker, Jenkins, Azure Dev Ops, AWS, Bamboo

Webservers: WebLogic, WebSphere, Tomcat

Planning and Scheduling Tools: Microsoft Project, Microsoft Visio Data warehousing / Business Intelligence

ETL Tools: Informatica (Workflow Manager, /Monitor, /Designer), and Ab Initio, IBM-Cognos Impromptu, SAP-Business Objects, MicroStrategy

Atlassian Tools: JIRA, BitBucket, Confluence

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead / Automation Architect

Environment: Angular, Docker, GIT, Azure DevOps, Selenium, MTM, ADO, Azure Data Lake, Rabbit MQ, Teradata . Snowflake, Event Hub, Kafka, Azure Functions, Python, Pandas, SQL DW, Data Factory, SSIS, SSRS, SSMS, Power BI, SpotFire, Jira

Responsibilities:

• Established, implemented, and improved QA test procedures, process, and quality standards
• Ensure dat teh pharmacy data is Ingested from raw files from On Prem to Raw to Base to atomic and Consumption based on teh Target to Source Mapping documents.
• Tested teh Power BI reports generated based on teh Consumption data
• Created complex SQL joins in Azure Databricks Notebooks to test teh Anchor, Details, Array, and Relationships table using teh TTSM’s
• Designed and implemented automation framework using Selenium, TestNG, Jenkins, Python
• Used Selenium and Python and created frameworks, created scripts to read and Write to Files, Exception Handling, tested on multiple browsers, automated frames, child windows, Created HTML reports
• Performed Web services, SOA testing using SOAP UI
• Performed performance testing using JMeter and Gatling
• Reported on test group activities (Test Execution, Defect Reports) to Program Managers
• Reported on test group activities to Project Managers, Development Managers and Product Owners, (Test Execution, Defect Reports).
• Very good experience in performing data validations in Azure environments using Python and Scala Notebooks
• ETL testing for teh data loads from On-Prem to RAW, Base, Cleansed and Consumption layers of teh Azure Data Lake storage
• Developed test cases for APIs testing using Postman and Swagger
• Created Performance Test Strategy for teh department scaling up to several hundred users. Used dat Strategy as a template for teh group to use going forward.
• Design and develop front end and Back-end test scenarios and Test cases
• Performed production deployment and teh Business verification testing.

Confidential

QA Lead / Automation Architect

Environment: Angular, Docker, GIT, Azure DevOps, Selenium, MTM, ADO, Salesforce, Power BI, Informatica, SQL Server, Amazon EC2, RDS, S3, Cloud Front, VPC, SNS, Beanstalk, Lambda, IAM, Salesforce, ServiceNow

Responsibilities:

• Established, implemented, and improved QA test procedures, process, and quality standards
• Reported on test group activities (Test Execution, Defect Reports) to Program Managers
• Designed and implemented automation framework using Selenium, TestNG, Jenkins, Python
• Used Selenium and Python and created frameworks, created scripts to read and Write to Files, Exception Handling, tested on multiple browsers, automated frames, child windows, Created HTML reports
• Integrated teh framework to Jenkins
• Testing of teh Salesforce application
• Testing of teh Oil and Gas Mobile App testing (Android and iOS) using Emulators, Simulators, and actual devices.
• Performed performance testing using JMeter
• Be an evangelist to stakeholders about test automation, continuous integration, continuous delivery, and agile practices
• Testing of teh ServiceNow applications for Confidential
• Reported on test group activities to Project Managers, Development Managers and Product Owners, (Test Execution, Defect Reports).
• Very good experience in performing data validations in Azure environments using Python and Scala Notebooks
• ETL testing for teh data loads from On-Prem to RAW, Base, Cleansed and Consumption layers of teh Azure Data Lake storage
• Developed test cases for APIs testing using Postman and Swagger
• Created Performance Test Strategy for teh department scaling up to several hundred users. Used dat Strategy as a template for teh group to use going forward.
• Design and develop front end and Back-end test scenarios and Test cases
• Performed production deployment and teh Business verification testing.

Confidential

Sr QA Analyst

Responsibilities:

• Worked with teh entire department and was able to convince them to shift left and was able to take teh product to production 60 days ahead of teh schedule
• Merged BA and QA teams as a cost-TEMPeffective approach to closing teh communication gap between teh two groups
• Establish key process Indicators (KPI’s) and implemented preventive and corrective actions to eliminate teh root cause of poor quality and delivery problems
• From scratch created a highly successful Quality Assurance department dat consistently exceed stretch goals for all teh quality metrics
• Development of teh test automation framework (Hybrid)
• Performed Web services, SOA testing using SOAP UI
• Scheduling and executing teh scripts in batch and unattended mode by using QTP’s Automation Object Model.
• Extensive use of teh Data table object, Windows Shell object, ADODB Connection and Record set objects, Checkpoints, Output values, Descriptive programming, Regular expressions, Functions & Environment variables

Confidential, CA

Sr QA Analyst

Responsibilities:

• Oversee testing conducted by Quality Assurance Analysts
• Coordinated teh testing tasks for each Build and Release for all software components.
• Worked with Customer Support group to halp perform root cause analysis of issues found in teh production environment

Confidential -CA

QA Analyst

Responsibilities:

• Developed test plans, validation plan, test cases and traceability matrix
• Maintained Requirements Traceability Matrix, developed test scripts,, executed test scenarios and reported bugs for Ariba to SAP Integration, Forecast to Stock, Order to Cash, and Quality Management
• Ensure dat all documentation complies with required standards for appropriate compliance organizations (i.e. FDA, SOX, OIG, GxP, GAMP)
• Conducted Functionality and Regression testing during teh various phases of teh application using QTP
• Installation and Configuration of QTP, and SAP - TAO (Test Acceleration and Optimization)
• Created TAO Test Components, Test scripts, Consolidated and executed test scripts
• Used HP BPT to design, create, execute, maintain tests and manage data

Confidential

SAP QA Analyst

Responsibilities:

• Created teh test plan, test strategy and test cases to test teh SD and MM Modules in Mercury Quality Center
• Created test plan and test cases for teh Mylan One Portal application
• Tested teh InfoObjects & InfoSources and InfoCubes
• Tested teh data extracting using LO Cockpit from SAP R/3 and using Flat Files
• Tested teh Formula Conversion Routines to create formulas for Date Change and String Manipulation.
• Scheduled process chains for periodic data loads.

Confidential

Test Coordinator / Performance Engineer

Responsibilities:

• Used teh ETL processes using Informatica tool to load data from Mainframe, MS SQL Server, Oracle, into teh target Oracle database.
• Responsible for managing Autosys Jobs and Events (Run Command Jobs, Run File Watcher Jobs, View Processing of Events, Force Start Job)
• Configured and installed teh Sitescope to measure teh App and Database server metrics like CPU Utilization, Memory, Disk Space
• Installed and configured Wily Introscope and provided teh Development teams with teh End-to-end transactions visibility from teh browser to teh back end systems
• Used vmstat to capture teh sever metrics, CPU, KB Free, KB Swap, Context Switch rate, Disk Utilization
• Developed and maintained teh Performance scripts Vusers scripts for teh AJAX transactions
• Created Load Runner scenario for Load, Stability tests to measure teh baseline performance, degradation points, and if teh apps could meet teh SLA
• Provided teh detailed analysis of teh Load Runner Analysis graphs