SUMMARY:

• 2 years of experience in python programming & 5 years experience in QA(Automation/ Manual).
• Experienced in WAMP (Windows, Apache, MYSQL, and Python) and LAMP (Linux, Apache, MySQL, and Python) Architecture.
• Developed web - based applications using Python, HTML, CSS, JavaScript and JQuery.
• Good experience of software development in Python (libraries used: pandas, numpy, scipy, matplotlib, network, flask framework, MySQL dB for database connectivity, SQLAlchemy for SQL tool).
• Strong knowledge in SQL concepts: CRUD operations, sub queries, stored procedures, triggers, cursors, and functions.
• Experience in performing GET and POST request in AJAX call of HTML, JSON/XML using JavaScript and JQuery
• Familiar with JSON based REST Web services.
• Good understanding of Object-Oriented Programing concepts.
• Extensive knowledge of working on Statistical Analysis, Reporting involving analysis, Design, Development, testing and validating the applications.
• Have good Knowledge of Agile Methodologies (Scrum).

SKILL:

HTML 5 PYTHON 3 CSS Bootstrap PANDAS NumPy FLASKs

EXPERIENCE:

Python Developer

Confidential, Baltimore, MD

Responsibilities:

• Created numerous reports using xlrt/xlwt python packages.
• Performed different DataFrame operations using panda, flask and SQLAlchemy combination.
• Developed Business Logic using Python and worked with request module web services in Python.
• Designed and developed corporate website using the Flask framework.
• Used Pandas API to put the data as time series and tabular format for east timestamp data manipulation and retrieval.
• Working with Panda library to calculate statistics of system.
• Used Postman for getting response from server and feed that data to HTML content.
• Worked with Redis to store key value pair to maintain data into session.
• Involved in development of modules like CSV import, XLSX import, bulk content upload.
• Implemented discretization, binning and data wrangling: cleaning, transforming, merging and reshaping data frames.
• Involved in building database Model, APIs and Views utilizing Python, to build an interactive web-based solution.
• Created automated daily jobs using Job Scheduler Software.
• Developed the required XML Schema documents and implemented the framework for parsing XML documents.
• Worked with ETL procedure for database functions to pull data out of one database and place it into another database.
• Performed different CRUD queries on data for Database.
• Used different Store procedures, JOIN and used CTE (common table expression) in SQL using DBvisualizer.
• Built farm Web data and load into the Postgres database using SQL Alchemy
• Used JavaScript library JQuery to create a Single Page Application (Phases) which can bind data to specific views.
• Expertise in unit and functional testing using JavaScript frameworks (jasmine and karma).
• Maintaining the code using different version control tools like GIT

QA Automation Engineer

Confidential, Baltimore, MD

Responsibilities:

• Developed Automation frameworks from scratch in UFT by VBscript in Human Research application called WORKDAY.
• Extensively worked on Descriptive Programming in HP UFT 12.54
• Used Loops and Conditional statements in UFT with the help of VB scripts as well as shell scripts.
• Developed test scripts in UFT using VB Script for automation of Web Based Applications. During web-based application automation worked on Web element, Web edit, web table, link, etc.
• Worked on number of Automation frameworks (Data driven framework, Keyword driven frame work, Modular Framework, Hybrid framework)
• Attended daily Scrum Calls and guided QA and Developer regarding the defects, Technical Specification Documents and Mapping Documents Agile Process was followed, and testing was done simultaneously.
• Developed automation VB scripts using UFT to automate functional and regression testing.
• Mentored and trained Team members for the effective use of automation framework and to develop UFT scripts and installing UFT, connecting to UFT through ALM and executing the UFT scripts from ALM.
• Developed test scripts, Object Repositories and function libraries using VBScripts.
• Extensively used Data table for test data and saved Test data sheet in ALM.
• Worked with the Developing Team to develop web elements and to interact with the MYSQL Data base.
• Walkthrough with Business Analysts and developers on the Test Plans that were designed.
• Executed Test cases in timely manner and Reported defects in HP Quality center ALM

QA Automation Engineer

Confidential, Winstom Salem, NC

Responsibilities:

• Designed Functional Libraries, Functions, Common functions, Regular Expressions and Environmental variables in UFT using VB script.
• Extensively used Shared Object Repository in QTP. In some cases, use Shell script along with VB script.
• Created Data driven Framework, Keyword driven framework, Modular framework, Hybrid Framework in UFT
• Execute the Automation scripts on a daily basis, quarterly and also on request bases.
• Followed Agile Methodology and attended Scrum meetings.
• Automation scripts execution through ALM, updating test results and uploading relevant files/screenshots back to ALM.
• Automation of Database (Backend) testing, preferably for Oracle and Teradata databases
• Created Traceability matrix between requirements & test cases in HP ALM.
• Created Automation frameworks (Data driven framework, Keyword driven framework as well as Hybrid framework) in VB Script using QTP/UFT and Tool respectively.
• Created complex SQL queries in MYSQL / Oracle server against source and target database to pull out specific data report.
• As a project lead coordinated with business and technical teams for day-to-day information, issues, project status as well as future goals and deadlines.
• Tracked and managed defects using HP ALM. Generated and Maintained Defect reports using HP ALM.

ETL SYSTEM ANALYST

Confidential, Madison, WI

Responsibilities:

• Created Data driven framework, Keyword driven framework as well as Hybrid framework using QTP/UFT.
• Worked with SQL queries to validate the data in database. I also worked on Source (text file or dB or mainframe) to Target data validation to make sure transformation logic.
• Worked with TriZetto Facets: Group/Class/Plan/Product, Member/Subscriber, Claims Processing, Customer Service, Provider, Subscriber/Member enrollment.
• Tested and validated ANSI X12 5010 Transactions such as 834, 837, 835, 270, 271, 276 and 277.
• Tested the loading of claims data into Facets 4.71/5.01.
• Tested the Adjudication of Claims and Migration Process.
• Developed Test Strategy, Test Cases and Test Scripts for enrollment, billing,, Claims, Payment, Authorization and Eligibility of claims in Claims Processing System.
• Created and Tested 834 Files. Worked on HIPAA 5010 Project included Medicaid and Commercial entities including claims and enrollment testing as well as NPI and medical coding, ICD-9 and ICD-10 EDI testing
• Tests are managed using Quality Center/ALM, Created Claims for Medical / Hospital and Dental Claims Processing.
• Tested the Eligibility applications (Eligibility Request and Eligibility Response).

ETL System Analyst

Confidential, Winston Salem, NC

Responsibilities:

• Actively discussed and gathered the complete project information from Business Analyst and Technical Team by BRD and FSD created by BA and Tech team, respectively.
• Created Test Plans to fulfill all Business Requirements for the particular project.
• Executed test cases and if any code was not working as expected I opened up Tickets in particular manner to track easily.
• Wrote SQL queries for both MS SQL server and Oracle server to validate transformation logic.
• I have used SOAP UI tool to validate XML file process for Web Service.
• Validated Data Models of source (database/ flat file/ UNIX) and target database with the expected Data Models.
• Efficiently handled multiple projects in Different environments like SIT, UAT and Prod.
• Performed Functional Testing, Regression Testing, Load testing, Performance testing and many more for Different applications.

Software Validation Engineer

Confidential, Boston, MA

Responsibilities:

• Executed validation scripts and OQ scripts with Watson 7.4.1
• Wrote SQL statements to extract data from the Tables against Oracle and MS SQL database.
• Wrote up defects and updated traceability matrices.
• Maintend CAPA report which is a mechanism for correcting and recording defects and Non-conformances.
• Worked all task under strict cGXP environment.
• Experience with the Review of Executed test scripts according to SOP and 21CFR Part 11 guidelines.
• Managed and Validated Nautilus 9.0.
• Evolved in workflow creation using appropriate workflow nodes in laboratory-based environment according to user requirements with Nautilus LIMS 9.0.
• Reported progress and issues to team lead in an effective manner.
• Followed Quintiles System Life-Cycle (SLC) and Computer System Validation (CSV) procedures, as appropriate.