Portfolio - HKoduru
Educational Background
Welcome Here
Welcome to my portfolio! I'm Harika Koduru, an accomplished professional with 7.8 years of expertise in EDI, US claims processing, and software quality assurance. Currently pursuing a Master of Science in Information Technology with a focus on leadership and minors in cybersecurity at Clark University, my journey reflects a commitment to excellence and continuous growth.
As the owner of this content, explore my project highlights, including my role as a Test Engineering Analyst at Accenture. Within this capacity, I led and executed diverse testing phases for global healthcare clients, leveraging tools like JIRA, Rally, ALM, and QTest to deliver high-quality software solutions.
Discover a proven track record of excellence and dedication to evolving technology and cybersecurity landscapes. Join me on this journey as I transition into the dynamic field of cyber threat intelligence, poised to contribute innovative and efficient solutions to the digital era.
Master of Science in Information Technology
School of Professional Studies, Clark University
Period: 01/2022- 12/2023 (Spring 22)
Grade: A
GPA: 3.8
Bachelor of Computers and Information sciences
Osmania University college for women, Hyderabad- India
Period Attended: 09/2011-07/2014
Profile Summary
- Over 8 years of experience in Information Technology, with specializing in Software Quality Assurance Testing as EDI QA Lead/Analyst/Software Tester.
- Proficient in testing on Web based applications and good experience on Claims processing in US Healthcare.
- Extensive working experience on all phases of Software Development Life Cycle (SDLC), its methodologies such as Waterfall, V-model, Agile, SCRUM.
- Having Knowledge of medical claims processing and claim Adjustments.
- Sound knowledge on SQL, Workbench and basic knowledge on TestNG framework and Maven.
- Extensive experience in reviewing and analyzing Business Requirements and creating Test Plans, Test Cases, Test Scripts, Test Estimation & Requirement Traceability Matrix.
- Professional expertise in Smoke Testing, backed end Testing, Black-Box Testing, User Acceptance Testing (UAT), Functional Testing, Positive/ Negative Testing, System Testing, Regression Testing, GUI Software Testing, Ad-hoc Testing, Cross Browser/ Cross Platform Testing, UI Validation, Webservices, Boundary Value Testing.
- Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration, and Task Scheduling.
- Expert using opensource bug tracking tool JIRA, Fog bugs, Agile Accelerator, ALM.
- Having Experience in EDI 837, 835 ,834 and 277 file structures.
- Strong knowledge of Paper Claims, EDI Claims, electronic claims, member enrollment, and billing transactions.
- Strong knowledge on HIPAA standards, ICD9/ICD10, EDI transactions 4010/5010
- Strong experience in testing 837, 835, 834, 277 transactions, TA1/999 acknowledgements and Care and Disease Management application.
- Experience in using EDIFECS Spec builder and validated SNIP errors and transactions flow using EDIFECS Transaction Management.
Workshops, Licenses & Certifications
Professional Experience
Mastercard Cybersecurity Virtual Job experience by Forage
- Designing a Phishing Email Simulation
- Interpret Phishing simulation results
Certified Peer Educator by NASPA- Student Affairs Administrators in higher education
Academy Accreditation - Generative AI Fundamentals by Databricks
Skills : Generative AI
Issued on: July 25, 2023
Expires on: July 25, 2025
Pragmatic works Power BI Beginner to Pro Workshop 2024
- Event Overview: This free live event is designed for those who have little experience with Power BI to give a better understanding of how end-to-end solutions can be designed.
- This course covers how to load data with Power BI Desktop, how to use some basic DAX, and create amazing visualizations on your data. Power BI is an impressive, one -stop reporting and analytical tool. You can connect and shape your data, as well as build reporting solutions that help drive decision making.
- What I learnt here
- Connect and organize your data
- Create data cleansing processes in Power BI
- Organize your data model
- DAX Basics
- Build Interactive Reports
- Deploy and share your solution
Role: Asst. Operations Management Intern@ Le Boutique In style LLC, Quaker hill, CT- November'23- December'23
Responsibilities: Sales Management, Business Analysis and marketing analysis for the individual merchandise & Report monitoring change in day wise transactions across locations.
- Inventory management and financial analysis using POS-CRM, Card Machines are compliant by assisting in the evaluation of our Organizational adherence to PCI-DSS standards.
- Participating in the assessment of current risk management practices & identifying areas for improvement.
- Conducting gap analyses to identify potential risks and compliance short comings.
- Creating data insights on fraudulent transactions among square and heartland vendors.
Role: Wellness Ambassador@ Clark University, Worcester, MA August'22- August'23
Advocate for Well-Being: Be a visible and approachable advocate for wellness and mental health on campus, providing resources and support to students seeking guidance.
Peer Counseling and Support: Offer empathetic listening and peer counseling services to fellow students, directing them to appropriate campus resources when necessary.
Lead Wellness Workshops: Facilitate engaging workshops and discussions on various wellness topics, such as stress management, self-care, healthy eating, mindfulness, and more.
Coordinate Awareness Campaigns: Help organize and participate in awareness campaigns and activities related to mental health, sexual health, substance abuse prevention, and other well-being areas.
Create Wellness Resources: Contribute to the development of informative and engaging content, including articles, blog posts, and visual materials related to wellness topics.
Collaborate with Campus Partners: Work closely with campus departments, student organizations, and residential life staff to integrate wellness initiatives into various aspects of campus life.
Be a Positive Role Model: Demonstrate a commitment to personal well-being and be a positive role model for fellow students by practicing healthy habits and coping strategies.
Collect Feedback and Assess Impact: Gather feedback from students and measure the impact of wellness programs to continually improve and tailor initiatives to meet the needs of the campus community.
Maintain Confidentiality: Uphold strict confidentiality when dealing with sensitive issues and personal information shared by students seeking support.
Role: Analyst@ Mastercard Cybersecurity Job Stimulation by Forage - June 2023
- Completed a job simulation where I served as an analyst on Mastercard security Awareness Team
- Helped identify and report security threats such as phishing.
- Analyzed and identified which areas of the business needed more robust.
- Security training and implemented training courses and procedures for those teams.
Role: BA/Agile Test Engineering analyst @ Accenture Solutions, Hyderabad, India - July20- Dec21
Working Module: Salesforce Period: July 2020 – December2021
To automate the capture of Client Intent in Salesforce from pre-sales through sold and implementation processes. This will facilitate a central source for truth, audit tracking, and serve as a repository for key documents.
Role: BA and Agile Tester Client: Cigna NA, GHB QA
Responsibilities:
- Help estimate the scope and size of the testing effort for each user story in Sprint Backlog refinement.
- Actively involved in interacting with the product owner (the business owner of the system) and ensures that everyone is aligned with the functional and nonfunctional tests the user story will have to pass through.
- Involved in the design and execute automated and manual tests, including exploratory testing by working closely with developers to assess and advise on testability aspects.
- Involved in testing at the component and API level, as well as at the end-to-end and feature level.
- Identified, Reported and Tracked Defects using Agile Accelerator and ALM test management tool.
- Manually tested, verified and validated that the product meets user requirements.
- Performed End-to-End testing of database to check data integrity using SQL Work Bench queries.
- Handling a team of 4 QA resources within scrum team and reporting directly to the clients on daily stats, regression and sanity execution status.
- Expertise in creating SUD, Drafting User stories by gathering requirements from product owner.
- Hands on experience on IBM Cognos reporting tool.
- Involved in Unit Testing for work tags written in AWS services (Lambda) using python code.
- Responsible for identifying test cases for manual and Automation with Selenium WebDriver for Smoke Test, Functional and Regression Tests.
- Handling the Sprint meetings to clarify user stories and changes.
- Identified, Reported and Tracked Defects using Rally test management tool.
- Verified and validated membership and enrollment (EDI 834), and analyzed claim processing (EDI 837) transactions.
- Involved in Testing In-bound /Outbound EDI Transactions (837,834).
- Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835
Environment: Selenium WebDriver, Java, TestNG, Maven, XPath, Eclipse, GitHub, Rally, Agile/Scrum methodology, Rally, Agile Accelerator, Oracle/SQL Server database, AWS, Workbench, Sales cloud application, ALM, SharePoint.
Skills: Electronic Data Interchange (EDI) · Tableau · RCA · Problem Solving · Process Analysis · IT Strategy · Data Engineering · Customer Interaction · Teamwork · Skilled Multi-tasker · Attention to Detail · Agile Methodologies · Databases
Role: ETL& End to End QA Consultant@ Accenture Solutions, Hyderabad, India - Mar 2019 –July 2020
Period: Mar 2019 –July 2020
Working Module: End- to – End Testing
IT ETE validates the process and workflow of executing applications for both membership and claims from system entry points and track the data through all the systems. Testing includes validation of data, but not limited items identified in high level scenarios.
Role: End to End QA Consultant
Responsibilities:
▪ Formulating detailed Test Plan using QTest after analyzing software requirement artifacts.
▪ Tested and validated the developed Control-M jobs.
▪ Reviewed manual testing methods and developed and executed.
▪ Tested the HIPPA EDI 834, 837 transactions and code sets standards according to test scenarios and verify data in different modules/ applications.
▪ Performed backend integration testing to ensure data consistency on front end by executing SQL statements on the database (Oracle, Workbench, Teradata).
▪ Used Q Test, Test Rail and Jira for version control, tracking defects, enhancement requests, assigned work activities and assess the real time project status throughout the testing cycle.
▪ Provided daily and weekly status reports highlighting impediments/showstoppers in testing using QTest and Jira.
▪ Responsible for E2E validations for Member Enrollments via EDI (New, Change, Void, Reinstate, PCP, Term).
▪ Well known with EDI and frond end for the claims, subscriber/family, Benefit packages and with the providers.
Environment: Teradata, Java frond end applications, TestNG, QTest, Oracle/SQL Server database, Workbench, Sales cloud application, Confluence, SharePoint, Control M, Post Man API, Mailnator.
Working Module: Salesforce, MSQL, Teradata
To Migrate patient Admission, readmission and discharge data from salesforce CRM to My SQL then to Teradata.
Role: Senior ETL QA Test Client: Care Centrix – RI, FL
Responsibilities:
- Involved in testing activities for the project in which existing data was migrated to a new system and the ETL job was developed using IBM DataStage
- Responsible for preparing Test Strategy for the project.
- Responsible for reviewing Source to Target Mapping document and developed Test plan.
- Developed Test Scenarios, Test cases and Test scripts.
- Executed Test Cases using positive and negative data and reported results in Jira.
- Tested and validated the developed IBM DataStage
- Implemented mappings using IBM DataStage for Extracting, Transforming and Loading (ETL) data into various layers of the data warehouse.
- Performed database testing, Suggested performance tuning techniques for ETL.
- Provided daily and weekly status reports highlighting impediments/showstoppers in testing.
- Development of SQL Queries for checking Data Transaction and Database Integrity.
- Execution of defined test cases on each build.
- Worked on Smoke, Functional, System Integration, Regression and User Acceptance testing.
- Attended the daily scrum meetings and highlighted the showstoppers/bottlenecks along with the progress of the assigned tasks.
- Helped the clients/the users with the user acceptance testing (UAT).
- Reviewed and analyzed technical requirements, gained a thorough understanding of project scope and created a test plan that is aligned with project parameters and goals.
- Created documentation such as test management plans, use cases, test scenario templates, knowledge sharing documents and maintained in SharePoint.
- Detected all errors and bugs and reported in JIRA, researched the origin of errors and provided additional details which helped fixing the bugs effectively.
- Analyzed and implemented the types of testing to be performed and created test plan and test cases for functional testing, user interface testing, integration and regression testing for 834 enrollment and eligibility.
- Worked as a lead for both offshore and onshore QA
Environment: IBM Data stage, MySQL, Teradata, JIRA, SharePoint.
Role: QA Engineer @ Accenture Solutions, Chennai, India - Nov 2014 –Mar 2019
Working Module: Salesforce, MSQL, Teradata
Maintaining the patient information such as Diagnosis details, Assessment, Admission, Discharge details, Nurse coach information, event details in PAC.
Client: Care Centrix – RI, FL
Responsibilities:
- Involved in test cases review by development team, product management and modified the test cases based on their feedback.
- Drafted Test Plan which included testing objectives, testing phases, scenarios, and test environment after a thorough analysis of the business rules.
- Responsible for running test validations and estimating project resource.
- Develop and execute SQL Queries to fetch backend data, verify the database updates, inserts and delete of the records, to extract data from target tables and validate reports.
- Assigned the tasks of maintaining usage logs, performing test suite, and gathering technical requirements to meet project requirements
- Responsible for creating and tracking the bugs.
- Coaching the Junior members Assigned, Monitored and Tracked Tasks of Team Members.
- Hands on Experience in the 837,277,834 and 835 file structures.
- Extensively worked in preparing the EDI transmission files, dropping them in Inbound, Outbound Interfaces and validate the data according to our test scenarios.
- Worked on different file formats like X12, Flat files and pipe-delimited files.
- Created sample 834, 837, 835, 277 X12 files and run the files using EDIFECS Management and BizTalk tools.
- Sound knowledge on Claim processing (identifying the claims, Acknowledge the claim, payment and Adjustments on claims) using EDI
- Providing out of office hour support for the UAT Data seeding.
- Expert in using flat files, 834 to seed member enrollment that includes admission, facility transfer, readmission, terminated to tera data(EIW Tables) for post-acute care(PAC).
- Responsible for identifying test cases for manual and Automation with Selenium WebDriver for Smoke Test, Functional and Regression Tests.
- Involved in testing the application utilizing the Scrum (Agile) methodology.
- Execute browser compatibility and regression tests using Selenium WebDriver for testing UI for every new build release.
- Performed regression tests using Selenium WebDriver with data driven framework and documented results.
- Handling the Sprint meetings to clarify user stories and changes.
- Identified, Reported and Tracked Defects using JIRA test management tool.
- Manually tested, verified and validated that the product meets user requirements.
- Performed End-to-End testing of database to check data integrity using SQL queries.
- Used HP ALM to log test cases, execute test scripts to capture test execution and log all internal defects.
- Used HP ALM for requirement traceability, mapping requirements to test execution.
- Scheduled meetings with business users to go over the test results and get sign off.
- Tested change requests and participated in production support.
Environment: 837,835,277,834 EDI files, JIRA, Silk central, Fog bugs, Windows 7, Selenium WebDriver, Java, TestNG, Agile, SQL, Maven, XPath, Eclipse, GitHub.
Technical Skillset
Technical Skills⚡
- Python
- AWS CLI
- AWS S3 Bucket, AWS EC2
- Google Cloud Shell Basics
- Cybersecurity Tools: Wazuh, Virus total, Mitre
👌 Previously used
- Virtualization Tools: VM ware, Virtual box
- File Structures: EDI Files (837,835,834 and 277), JSON
- Languages: Basic JAVA, Basics of PL/SQL, Bash
- IDE/ RDBMS Querying skills: SQL Developer, Toad, Teradata, Salesforce Workbench.
- Processes: Agile-Scrum, V model, Waterfall, Iterative
📈 Skills
- Web Technologies: JSON
- DevOps: Docker, AWS, GCP, Kubernetes, Teraform
- Database Technology: MySQL, MongoDB, PostgreSQL, DynamoDB
- Platform & tools: GitHub, GIT, Postman
Create Your Own Website With Webador