SUMMARY:

• Over 7 years of Experience in Python, Data Warehouse / ETL Testing in AWS Cloud with working knowledge in Guidewire, AWS S3, Hive, MySQL Server, Oracle, AWS Redshift, Informatica
• Hands on experience in various levels of testing including End to End, System, and Integration testing
• Created and managed QA Estimates, Test Strategies, Test Cases, Test Strategy Presentations, Test Planning Document, Grooming sessions, Test Execution Status Reports, Defect Reports and UAT Handover Documentations
• Experienced in writing SQL Queries, Stored procedures, functions, packages, tables, views, triggers.
• Wrote SQL queries to handle data for multiple tables, including large volume data tables.
• Experienced in Spark s RDD, Data frame and API.
• Ensured Handling of expected application failures, logged errors to DB and files.
• Developed and stored Testing Data sets for various business scenarios of the Application development.
• Experienced in various types of testing such as Unit testing, Automated Testing, Integration testing, User acceptance testing, Functional testing.
• Experienced in python development using Object Oriented Concepts, test driven development practices
• Experienced in data driven application development with data acquisition, data validation and data cleansing using python scripts and PostgreSQL
• Developed and stored Testing Data sets for various business scenarios of the Application development.
• Enthusiastic to learn newer technologies and systems. Quick learner and up to date with industry trends, excellent written and oral communications, analytical and problem - solving skills and good team player, ability to work independently and well-organized.

TECHNICAL SKILLS:

Programming: SQL, Python, Spark, Spark, C, Java

AWS Technologies: EC2, S3, IAM, Athena, AWS Glue, cloud watch

Microsoft Office: Word, PPT, Excel

PROFESSIONAL EXPERIENCE:

Confidential

Python Developer

Responsibilities:

• The Purpose of this project is to combine existing five sources of data into a single MDM target. The client wants to build relationship between the customers of same family for the User /Customer to access all the policies related to his/her family.
• Guidewire (GW), Nextgen (NG), M1, Phoenix (PHX), Customer Data Management (CDM).
• QA Test Analyst ( Role )
• Analyze mapping documents, design documents and requirements and develop test cases for system testing using JIRA
• Involve in the process of analyzing the actual results with the expected results
• Check the Source DB and Target DB.
• Assign tasks to teammates, follow up and report the same to clients and onsite coordinators.
• SQL Server, AWS Redshift, JIRA, ARF,MDM.Project

Confidential,Austin, TX

Python Developer

Responsibilities:

• The Purpose of this project is to replace existing client’s on-premises Hadoop/Hive table framework with Confidential . Existing on-premises have several hive tables created against each source integration systems which in turn slowed the entire system and currently client is unable to run any analytical queries on top of the table structure.
• AWS ( Environment)
• QA Test Analyst ( Role )
• Analyze mapping document, design documents and requirements and develop test cases for system testing using JIRA
• Involve in the process of analyzing the actual results with the expected results
• Check the Source DB and Target PARQUET Files
• Involve in suggesting client to upgrade their system to AWS, hence 18 integrations were bought for immigration/development with new design on AWS.
• Involve in data preparation by picking up data from raw bucket and process with all required expectations/data cleansing/preprocessing/schema evaluation handling and convert to PARQUET.
• Athena, Redshift, AWS GLUE, S3, SQL, PySpark, Spark, Python, PyCharm Community Edition.( Technology & Tools )

Confidential,San Jose, CA

Python Developer

Responsibilities:

• RC Maintenance is an Agile Project which is handling customer data for a wellknown insurance-based company working in North America Region.
• The major line of businesses includes Personal Auto, Commercial Auto and Homeowners.
• The project is sourcing data from different sources - data bases like AWS Redshift and Oracle and consolidating all the info in AWS Redshift Target DB.
• From there the data is used to generate user reports using Micro Strategy Reporting Tool at the downstream.
• Guide Wire, MicroStrategy, SQL Server, QC, Jira, AWS Redshift, Hadoop
• QA Test Analyst ( Role )
• Analyze mapping document, design documents and requirements and develop test cases for system testing using Quality Center
• Involve in the process of analyzing the actual results with the expected results
• Check the Source DB and Target DB
• Execute all the test cases and log all the defects using defect tracking tool (HPQC/ JIRA) Prepare and Test MSTR Reports based on the changes and test data. Validate the Data Feeds and submit the reports for the same.
• Informatica Power Center, SQL Server, AWS Redshift, Netezza, HIVE, HP ALM Quality Center, JIRA, ARF.

Confidential, Minneapolis, MN

Python Developer

Responsibilities:

• Responsible for analyzing various cross-functional, multi-platform applications systems enforcing python, best practices and provide guidance in making long term architectural design decisions.
• Designed and developed Use-Case Diagrams, Class Diagrams and Object Diagrams using UML Rational Rose for OOA/OOD techniques.
• Involved in entire lifecycle of the projects including Design, Development, and Deployment, Testing and Implementation and support.
• Debugging Software for Bugs.
• Generated property list for every application dynamically using Python.
• Developed internal auxiliary web apps using Python Flask framework with CSS / HTML framework.
• Implemented Test Driven Development (TDD) strategy for the project.
• Handled all the client-side validation using JavaScript.
• Developed Python batch processors to consume and produce various feeds.
• Responsible for search engine optimization to improve the visibility of the website.
• Developed internal auxiliary web apps using Python Flask framework with CSS / HTML framework.
• Responsible for debugging the project monitored on JIRA (Agile).
• Used Pythonto interface with the jQuery UI and manage the storage and deletion of content.
• Built development environment with JIRA/Git.
• Involved in development of Web Services using SOAP for sending and getting data from the external interface in the XML format.

Environment: Python, HTML, CSS, Shell Scripting, PL/SQL, Linux and Windows.