Sunil Guntupalli

This project revolves around Tower Power, a system leveraging a cloud-based, microservice architecture to dynamically calculate available open space for customer availability. It involves real-time drone data ingested by another team's API to ensure an accurate, up-to-date depiction. By integrating real-time data and automated calculations, it enables the marketing team to confidently identify available space for promotion.

• Played a pivotal role in designing and implementing automated test frameworks and solutions, utilizing Selenium WebDriver and Java coding within Eclipse IDE.
• Managed test cases and tracked defects efficiently using the QMetry tool.
• Maintained version control with Bitbucket for streamlined source control.
• Implemented Behavior-Driven Development (BDD) framework for API automation using Cucumber.
• Executed test strategies, plans, and cases, advocating for quality engineering in agile ceremonies and throughout the organization.
• Collaborated closely with Agile teams to develop test cases aligned with business capabilities.
• Worked closely with Product and Development teams to validate acceptance criteria and requirements.
• Provided mentorship to junior Quality Engineers, ensuring adherence to QE tools and proficient test application.

This project deals with a Currency Transaction Report (CTR) - a report that U.S. financial institutions are required to file with FinCEN for each deposit, withdrawal, exchange of currency, or other payment or transfer, by, through, or to the financial institution which involves a transaction in currency of more than $10,000. The CTR is part of anti-money laundering efforts to ensure that the money isn't being used for illicit or regulated activities. Banks, government agencies, or public corporations are exempt from needing CTRs when they transact large amounts.

• Developed automated test frameworks and solutions leveraging Selenium WebDriver, Java coding, and Cucumber to implement Behavior-Driven Development (BDD) framework for API automation.
• Utilized ALM tool for effective test case management and defect tracking.
• Employed Bitbucket for streamlined source control.
• Conducted meticulous analysis of client requirements.
• Formulated comprehensive test strategies and plans.
• Orchestrated the setup of Test Environments to facilitate test case execution.
• Generated concise Summary Reports and facilitated review meetings.

EOS is focussed on enterprise merchant offers which administers heterogeneous database platforms spanning relational and NoSQL DBMS engines.

• Led end-to-end application lifecycle management, including design, coding, testing, documentation, and deployment.
• Evaluated current data platforms and emerging technology trends, supporting organizational growth initiatives.
• Provided support in programming, building, testing, and deployment processes.
• Enhanced software by addressing code errors, implementing code changes, conducting code reviews, and optimizing code performance.
• Conducted use case analysis to identify opportunities for automation. Developed and implemented Java-based automation solutions that reduced manual testing time.
• Architectured, designed, constructed, tested, tuned, deployed, and supported Data Integration solutions for Hadoop.
• Re-engineered existing systems and implemented automation where necessary.
• Successfully implemented and delivered solutions utilizing Big Data platforms like Hadoop.
• Ensured delivery of high-quality products with BDD Cucumber support.
• Proficiently tested Restful APIs and web-based Applications.

EQUIP reporting application which supports and plays crucial role in running of Nissan manufacturing plants in day to day

operations. Contributed to the Total Customer Satisfaction (TCS) team, focusing on enhancing customer experience.

• Actively participated in Sprint planning, Sprint Backlog, Sprint Retrospective meetings, and Go-NO Go meetings to ensure project alignment and progress.
• Developed comprehensive test cases using Zephyr for Jira, a sophisticated test management tool.
• Utilized Jira for efficient bug tracking and management.
• Conducted Source to Target Data Validation, Transformation, and Business Rules analysis.
• Built and executed SQL queries in Oracle for various testing purposes.
• Engaged in System testing, Integration testing, and Regression Testing to ensure software quality.
• Conducted Data validation and Database integrity testing through SQL statement execution.
• Automated business processes by developing Oracle PL/SQL data structures.
• Authored Test Cases for ETL processes to validate Source and Target database systems.

Contributed to the development and maintenance of Fusion Financials, a comprehensive accounting solution built on Fusion middleware.

• Played a key role in implementing Oracle Fusion Tax, providing centralized management of transaction-based tax requirements across Oracle Fusion Applications.
• Automated transaction tax calculation, determination, and reporting functions using Oracle Fusion Tax, enabling efficient handling of tax-related tasks across business documents.
• Empowered tax calculations for transactions involving remote locations from the taxing jurisdiction.
• Developed and tested test scripts and functional libraries, ensuring robustness across different environments.
• Analyzed script failures to identify root causes and implemented corrective actions for script fixes.
• Coordinated with internal teams to ensure smooth execution of developed scripts and resolved bottlenecks as needed.

• Bulk Administration Tool (BAT), a component of Cisco CMUI is a web-based application that performs bulk transactions to the CISCO Call Manager database. BAT automates the process and achieves faster add, update and delete operations and hence a key component of Cisco CMUI
• Managed communication errors between BAT and CMUI systems, resolving issues to ensure smooth processes.
• Monitored and rectified failed scheduled BAT jobs, including checking log files, fixing errors, and rescheduling jobs for completion.
• Modified existing code in failed scheduled jobs to address code errors and deployed new code to Production to prevent recurrence.
• Rectified Report generation codes for Phones, Users, Gateways, and Ports from BAT, ensuring accuracy.