| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLEDATA ANALYST SENIOR QA AUTOMATION / ETL TESTERSenior Business/Data Analyst with 12 years of experience specializing in requirement gathering, data modeling, and creating business intelligence solutions. Expertise in transforming complex data into actionable insights through advanced data visualization using tools like Alteryx, Tableau, and MicroStrategy. Committed to ensuring data quality, integrity, and driving strategic initiatives. Skilled in data validation, metadata management, and optimizing processes on AWS and Redshift, with a strong ability to collaborate in Agile environments to support business objectives.CORE COMPETENCIESStrategic Business InsightsAnalytical ExcellenceData VisualizationRedshift Data ManagementSimCorp, Alteryx, Reporting ToolsData ModellingAWS MigrationProcess OptimizationCross-Team CollaborationPredictive AnalyticsStakeholder EngagementData Security & GovernanceCreative Problem SolvingAdaptive & AgileTechnical ProficiencyTECHNICAL SKILLSAutomation Tools: Selenium, SOAP UI, REST API, POSTMAN, EMR Scripts, Locust, PyAutoGuiProgramming Languages: Java, Java Script, Python, .Net, SQLFrame Works: Data Driven, TestNg, Maven, Jenkins, Git, Cucumber, Robot Framework, PytestDatabase Technologies: SQL Plus, DBeaver, AWS Redshift, Oracle 11g, 12c, Toad, Informatica, Ambari, MySQL,PostgreSQL, MongoDBReporting tools: Business Objects 3.1, Tableau, MicroStrategy, Workday PRISM, Cognos, Power BI, LookerTest Management Tool: JIRA, ServiceNow, Quality Center, HP ALM 12.20, RallyCI/CD Tools: Jenkins, GitLab CIVersion Control: Git, BitbucketCloud and Big Data Technologies: AWS (S3, EC2, Lambda), Azure, Apache, Hadoop, Apache Spark, KafkaCERTIFICATIONSAWS Certified Solutions Architect - AssociateAZ-900: Microsoft Azure FundamentalsEDUCATIONMasters in Computer Science from San Francisco Bay University, CABachelor of Engineering in Computer Science from Kakatiya University, India.PROFESSIONAL EXPERIENCESr. Data Analyst FannieMae McLean, Virginia June 2020 PresentKey responsibilities:Data Validation and VerificationLed data validation initiatives to ensure data completeness, integrity, and accuracy across diverse datasets, performing comprehensive checks for duplication, null values, and consistency.Managed data validation processes during AWS migration projects, ensuring seamless transition and data integrity throughout the lifecycle.Conducted thorough validation of orchestration processes, ensuring accurate data loading into target tables in Redshift.Metadata Management and TransformationExecuted metadata validation for target tables in Redshift, ensuring alignment with business requirements and adherence to data governance standards.Validated data transformations in accordance with Source-to-Target Mapping (STTM) documents, ensuring accurate data flow and consistency.Data Analysis and VisualizationDeveloped robust data models using Alteryx and Tableau Prep Builder, facilitating enhanced data collection and visualization in Tableau.Created data blending solutions in Alteryx for comprehensive reporting, enabling insightful analysis of Business Objects and SimCorp Data.Authored clear documentation for Alteryx workflows, ensuring usability and clarity for downstream applications and stakeholders.Data Processing and OptimizationExtracted, transformed, and loaded large volumes of data from multiple sources, optimizing data workflows for efficiency using Alteryx.Enhanced SQL query performance for faster data retrieval, supporting timely decision-making and reporting processes.Analyzed backend database structures using SQL, ensuring data integrity and accurate mapping of data elements for reliable reporting.Test AutomationDeveloped and maintained automation frameworks using Selenium WebDriver (Java) and Python, implementing Page Object Model (POM), Data-Driven Testing, and API Automation for efficient test execution.Automated REST API testing using Python, integrating with tools like Jupyter Notebook and comparing data with backend systems like Redshift.Integrated test automation into CI/CD pipelines using Jenkins, managing test versioning through Git, and collaborated with cross-functional teams for Agile-based sprint planning and defect tracking using JIRA.Performance Testing with JMeterConducted Load Testing using JMeter to simulate concurrent user traffic and measure application performance under varying load conditions, focusing on response time, throughput, and error rates.Performed Stress Testing to determine the systems limits by gradually increasing the load beyond expected levels, identifying potential bottlenecks, and ensuring system stability.Executed Spike Testing to evaluate system performance during sudden surges in user activity, analyzing how well the application handles traffic spikes and recovers from overload scenarios.Data Integration and SecurityLed data preparation and blending efforts, creating data models to streamline operations and enhance data accuracy.Utilized Alteryx for integration tasks, supporting business reporting and improving overall data processes.Test Management and Defect TrackingDocumented project requirements and tracked stakeholder feedback using JIRA, ensuring alignment with business objectives and enhancing project outcomes.Collaborated in User Acceptance Testing (UAT) sessions, analyzing transactional data flows to validate solutions against user needs and ensuring functional alignment.Conducted analyses of system performance and usability, providing insights to enhance application functionality and user experience.Environment: STTM documents, SQL, ETL tools, Redshift, Data validation tools, SQL queries, EMR scripts, Data mocking tools, JIRA, SimCorp, Alteryx, Business Objects, Toad Data, DTF (Data Testing Framework), Confluence, Selenium, PythonAchievements: I led initiatives that improved data accuracy by 30% and reduced AWS migration time by 20%. I developed advanced data models in Alteryx, enhancing reporting efficiency by 40% and optimizing SQL queries for a 50% reduction in data retrieval time. My efforts ensured 100% data integrity and improved user experience through effective collaboration in UAT sessions.Senior Data Analyst & QA Tester Hilton Worldwide Headquarters McLean, Virginia May 2019 April 2020Key responsibilities:Data Analysis and VisualizationConducted comprehensive analyses of MicroStrategy reports to ensure data quality and accuracy, enhancing the overall presentation of visual elements.Developed Business Requirement Documents (BRDs) and Functional Specification Documents (FSDs) to effectively guide project implementation.Designed and executed data blending processes using Alteryx and Python to integrate diverse data sources, improving reporting capabilities in Tableau and Power BI.Created and maintained interactive dashboards and visualizations, transforming complex datasets into actionable insights for stakeholders.Data Processing and OptimizationExecuted ETL processes by extracting and transforming large volumes of data from various sources using Alteryx and Python, ensuring operational efficiency and accuracy.Utilized SQL in tools like DB Visualizer and Ambari to analyze backend data structures, verifying data integrity and proper mapping across datasets.Data Management and ReportingAnalyzed data to identify trends and provide actionable recommendations that support strategic decision-making within the organization.Created and executed SQL queries to validate data accuracy and consistency in reporting systems, ensuring reliable outputs for stakeholders.Leveraged Pytest to automate data validation tests, enhancing the efficiency and reliability of data verification processes.Implemented Locust for load testing data processing pipelines, ensuring optimal performance under varying data loads.Provided training and documentation to end-users, ensuring smooth adoption of data solutions and enhancing user engagement.Expertise in iOS Mobile Testing, Test Case Management, and Agile CollaborationDeveloped and executed test cases using ADO Test Plan and HP ALM for iOS mobile apps, ensuring functionality, usability, and backend integration.Collaborated with cross-functional onshore/offshore teams in an Agile/Hybrid Agile environment, utilizing Azure DevOps and JIRA for test management and defect tracking.Performed end-to-end testing on iPhone and iPad devices, identifying and resolving issues to enhance user experience and product quality.Test AutomationDeveloped and maintained automated test frameworks using Selenium WebDriver (Java) and Python for Hiltons backend systems, ensuring efficient regression and API testing.Automated REST API calls using Python for the HAB project, integrating with MicroStrategy and validating data accuracy by comparing Redshift reports with Jupyter scripts.Integrated test automation with Jenkins for continuous testing and nightly builds, managing version control through Git, and collaborating with cross-functional teams for Agile sprint planning and defect tracking using JIRA.Functional Validation and User Acceptance TestingDeveloped detailed documentation, including data specifications and validation plans, to ensure alignment with user expectations.Supported User Acceptance Testing (UAT) by executing test cases, including automated tests with Pytest, and verifying data workflows against business requirements, identifying and documenting discrepancies as needed.Contributed to the CI/CD pipeline by integrating automated tests into deployment processes, improving the efficiency of data release cycles.Collaboration and Stakeholder EngagementActively participated in daily Scrum meetings to discuss project progress and analytics needs, engaging with cross-functional teams to align data solutions with overall business strategies.Coordinated with technical teams to streamline data workflows and improve system integrations, enhancing overall project efficiency and effectiveness.Led workshops and brainstorming sessions to identify key analytics opportunities, promoting a collaborative environment for innovation and continuous improvement within the organization.Environment: Alteryx, MicroStrategy, Tableau, SQL, Python, Pytest, CI/CD Pipeline, JIRA, ServiceNow, Ambari (Hive) 2.7.5.0, DB Visualizer (Redshift) 9.5.8, Spark 2.4, JIRA, Selenium, PythonAchievements: I successfully enhanced data quality and accuracy through comprehensive analyses of MicroStrategy reports. I implemented data blending processes using Alteryx and Python, which significantly improved reporting efficiency and enabled actionable insights in Tableau and Power BI. My work in executing ETL processes led to faster data retrieval times, while thorough SQL validations ensured complete data integrity across various reporting systems. Additionally, I facilitated effective user engagement through training and documentation, contributing to a smoother adoption of data solutions within the organization.Senior Lead UAT Tester Bank Of New York-Mellon New York July 2018 April 2019Key responsibilities:User Acceptance Testing and Functional ValidationConducted User Acceptance Testing (UAT) to ensure developed data solutions met business client needs as specified in functional requirements.Developed and managed the UAT process, monitoring System Integration Testing (SIT) phases to ensure seamless functionality.Captured and validated modifications to functional requirements, ensuring alignment with client expectations through rigorous data analysis.Prepared test cases based on user stories in JIRA, ensuring comprehensive coverage for sprint allocations.Developed SQL queries and test cases for various data validations, performing extensive checks to maintain data integrity.Performed end-to-end testing of SAP ECC and iOS mobile applications for Bank of New York, ensuring accuracy in transaction processing and compliance with banking regulations.Performance Testing and Back-End ValidationExecuted data validation and testing within an interactive mainframe environment, ensuring accurate data handling.Utilized SQL queries to validate migrated databases, conducting Back-End Testing to confirm data integrity and successful migration.Conducted manual functional testing to validate application features, ensuring compliance with business requirements and specifications.Performed load and stress testing using JMeter, simulating concurrent users to assess system performance, response times, and throughput.Developed and executed test cases for regression, smoke, and performance testing, ensuring application stability and scalability under varying loads.Test Management and Defect TrackingIdentified data discrepancies and followed the bug life cycle in HP ALM to resolve defects efficiently.Participated in sprint planning meetings to assess user stories based on resource availability and project timelines.Developed and maintained data workflows using AWS services like Step Functions and Amazon Redshift, enhancing data integration and real-time processing capabilities.Multi-Project Management and ReportingUtilized strong time-management skills to manage multiple data analysis projects simultaneously, ensuring timely and quality delivery.Created various reports using Crystal Reports in line with end-user requirements, enabling informed decision-making.Optimized ETL pipelines on AWS using services like AWS Glue, AWS Lambda, and Amazon S3, ensuring efficient data handling and integration.Comprehensive Testing PracticesConducted Smoke, Integration, Functional, Regression, and System testing to ensure comprehensive quality assurance and data accuracy.Communication and Stakeholder EngagementMaintained regular communication with clients to clarify and ensure data solution functionality requirements were met.Collaborated with clients and cross-functional teams to produce high-quality applications within project timelines.Provided daily project updates to the Testing Manager, ensuring transparency and alignment on progress.Documented testing progress in SharePoint and coordinated with DBAs to allocate user access with the necessary privileges for database testing.Environment: Python, AWS (Glue, Lambda, S3), OLTP DB, SharePoint, JIRA, Toad for Oracle, SQL, Informatica, Business Objects 3.1 Web Intelligence, HP ALM, ExcelAchievements: I ensured data solutions met business needs by leading User Acceptance Testing and developing comprehensive SQL validation processes. My efforts in optimizing ETL pipelines and utilizing Python for data analysis improved data handling efficiency and integrity. I successfully managed multiple projects, delivering high-quality reports and insights that supported informed decision-making across the organization.ServiceNow / QA Tester Nationwide Insurance Columbus, Ohio Nov 2016 May 2018Key responsibilities:Test Case Development and ExecutionDeveloped comprehensive test cases derived from User Stories assigned for each sprint in JIRA, ensuring alignment with project requirements.Mapped project requirements to test cases using a Requirement Traceability Matrix (RTM) to guarantee full coverage and adherence to project objectives, thereby minimizing risk.Employed the Black Box testing method, systematically selecting both valid and invalid inputs to ascertain expected outputs across diverse scenarios, ensuring robust testing practices.Utilized Cucumber for Behavior-Driven Development (BDD), writing feature files in Gherkin syntax to enhance collaboration with stakeholders and ensure clear acceptance criteria.ETL Testing and Data ValidationCreated and managed ETL test data aligned with all ETL mapping rules to validate the functionality of Informatica workflows, ensuring data accuracy and consistency throughout the data pipeline.Wrote and executed complex SQL queries using TOAD to validate Enrollment Information, assess data integrity, and troubleshoot discrepancies in data processing.Integrated automated testing using Selenium WebDriver for web-based ETL dashboards, ensuring that data visualizations reflect accurate and timely information.Conducted data profiling and reconciliation to verify data quality and compliance with business rules.Test Automation and Behavior-Driven Development (BDD)Designed and implemented BDD test cases utilizing Cucumber and Selenium WebDriver to align automated testing with business requirements and user stories, fostering clear communication between technical and non-technical stakeholders.Integrated BDD practices into the CI/CD pipeline, enabling automated regression testing and reducing manual effort while enhancing test coverage.Developed step definitions in Cucumber to connect the Gherkin scenarios to automated Selenium tests, ensuring seamless execution of end-to-end test cases.User Acceptance Testing (UAT) and QA SignoffFacilitated UAT sessions with end-users, focusing on transactional data flow, performance testing, and gathering user feedback to identify potential issues and areas for improvement.Maintained an updated defect tracking list based on UAT feedback, prioritizing and addressing critical issues before production deployment.Established and meticulously reviewed QA signoff criteria, including software builds and testing processes, with the Scrum team to ensure that deliverables met quality standards and were production ready.Provided training and support to users during UAT, ensuring they were comfortable with the application and its features, which contributed to a smoother transition to production.Environment: ServiceNow, HP ALM, Excel, RTC, SQL, TOAD, Cucumber, Gherkin, PL/SQL, SOAP UI, REST API, Selenium, SAP Business Objects 3.1 Crystal Reports and DashboardAchievements: I have successfully developed comprehensive test cases based on User Stories, ensuring alignment with project requirements and enhancing overall project delivery. By implementing a Requirement Traceability Matrix (RTM), I guaranteed full coverage and adherence to project objectives, significantly reducing risk and improving testing accuracy. My rigorous Black Box testing approach identified and resolved discrepancies through the validation of both valid and invalid inputs across diverse scenarios. I created and managed ETL test data for Informatica workflows, ensuring data accuracy while executing complex SQL queries to validate Enrollment Information. Additionally, I designed and integrated BDD test cases using Cucumber and Selenium WebDriver, aligning automated testing with business requirements and improving stakeholder communication. I facilitated User Acceptance Testing (UAT) sessions, collected user feedback, and maintained a defect tracking list to ensure timely resolution of issues prior to production deployment. I also established QA signoff criteria with the Scrum team to ensure that quality standards were met.QA Tester OCLC Columbus, Ohio May 2016 Oct 2016Key responsibilities:Test Case DevelopmentCollaborated with Business Analysts (BAs) and Subject Matter Experts (SMEs) to gather requirements and application information through User Stories in TFS.Developed comprehensive test cases in HP ALM based on the gathered requirements and user stories, ensuring thorough coverage.Designed and executed User Acceptance Testing (UAT) test cases, documented defects identified during UAT and conducted retesting following bug fixes.API and Web Services TestingAnalyzed and validated WSDLs, XML, endpoints (URI), and resources utilizing tools such as Ready API and Postman to ensure accurate API functionality.Test Automation and Continuous IntegrationImplemented open-source automation scripts using Selenium for both functional and regression testing, enhancing testing efficiency.Worked on Continuous Integration (CI) using Jenkins to execute automation scripts with Selenium and SOAP UI, streamlining the testing process.Managed the test automation suite version in GitHub using Git commands (add, commit, push, pull requests) to ensure version control.Integrated Jenkins with GitHub to automate version control, scheduling, and execution of automation for build changes.Database Testing and Data ValidationUtilized SQL queries to verify data from Oracle and MS SQL Server databases, ensuring accurate data validation and integrity.Connected to databases using Toad for data verification and backend validation, enhancing data quality assessments.Validated backend data through SQL queries, log file analysis, and data grid cache analysis to ensure consistency.Comprehensive Testing PracticesParticipated in functional, system, database, and compatibility testing of applications, ensuring robust testing methodologies.Conducted smoke, functional, and regression testing across various environments, including QA, SIT, UAT, and PROD.Quality Assurance and Sprint ExecutionEstablished and reviewed QA signoff criteria, software builds, and testing processes with the Scrum team to ensure quality deliverables.Ensured acceptance criteria were met for each product increment at the end of every iteration/sprint, contributing to successful project outcomes.Environment: Sybase, Git, Jenkins, Selenium, Greenplum, Oracle, SQL, MySQL, Hadoop, .Net, UFT, Postgres, SOAP UI, Service now, TOAD.Achievements: Successfully collaborated with Business Analysts and Subject Matter Experts to gather requirements, resulting in the development of comprehensive test cases in HP ALM and thorough User Acceptance Testing (UAT). Enhanced testing efficiency by implementing open-source automation scripts using Selenium and integrating them into a Continuous Integration (CI) pipeline with Jenkins. Conducted detailed API and web services testing through analysis of WSDLs and XML, ensuring accurate functionality. Utilized SQL queries for effective database testing and validation, confirming data integrity across Oracle and MS SQL Server. Established QA signoff criteria and ensured acceptance criteria were met for each sprint, significantly contributing to the delivery of high-quality software products.QA Team Lead McKesson Charlotte, NC June 2015 Feb 2016Key responsibilities:User Acceptance Testing (UAT)Planned, designed, and executed UAT test cases, documenting defects and conducting retests post-bug fixes.Developed test plans and scenarios, ensuring comprehensive mapping to requirements in Quality Center.Data Analysis and Test AutomationDeveloped and maintained automation test cases using Selenium WebDriver and TestNG for Java-based applications, enhancing test coverage and efficiency.Utilized tools like SVN for version control and Maven for build management, integrating with Jenkins for Continuous Integration (CI) to automate deployment and testing processes.Managed script versioning using GIT and STASH, ensuring the integrity and traceability of automation code.Defect Tracking and Test ManagementConducted defect tracking and management using Quality Center 12.20 and ALM, facilitating timely resolution and effective stakeholder communication.Mapped test cases to requirements in Quality Center, ensuring thorough coverage and traceability for validation processes.Functional, System, and Database TestingEngaged in Functional, System, and Database testing, ensuring end-to-end validation of applications.Prepared and executed test cases for ETL processes based on technical specifications, focusing on data extraction, transformation, and loading to ensure data integrity and accuracy.Leadership and Continuous ImprovementLed team performance reviews and appraisals, fostering a culture of quality and accountability.Conducted iteration retrospectives to collect team feedback, driving continuous improvement in testing practices and methodologies.Environment: Sybase, Greenplum, Oracle, SQL, MySQL, Hadoop, PostgreSQL, Jenkins, Selenium, Restful API (Postman), Service now, Linux, TOAD.Achievements: Successfully enhanced the efficiency of UAT processes by developing and executing comprehensive test plans, leading to a 30% reduction in defect rates during production. Streamlined automation testing with Selenium and TestNG, improving test coverage by 40% and significantly reducing execution time. Implemented rigorous defect tracking procedures using Quality Center and ALM, resulting in a 25% faster resolution time for identified issues. Played a key role in ETL testing, ensuring 99% data accuracy through meticulous validation of extraction, transformation, and loading processes. Fostered a culture of continuous improvement within the team, achieving a 20% increase in overall testing effectiveness through regular feedback and retrospective meetings.QA Analyst Bank of America Charlotte, NC August 2014 May 2015Key responsibilities:Test Case Management and CoordinationCreated functional and regression handoffs to efficiently transition test cases from functional projects to regression projects, ensuring comprehensive test coverage.Coordinated meetings with the product committee, project manager, and functional management to discuss project impediments, required resources, and issues/delays in task completion.Analyzed test case data to identify trends and areas for improvement, leading to optimized testing strategies and resource allocation.Defect Management and ResolutionReported defects in Quality Center, collaborating closely with analysts and developers to resolve issues and update defect statuses accordingly.Assisted in recreating customer issues to ensure defects were accurately identified and resolved in a timely manner.Conducted data analysis on defect trends to determine root causes, facilitating better decision-making for future testing and development efforts.Functional and Regression TestingInvolved in end-to-end testing of Sales and Non-sales data in downstream applications, particularly focusing on key processes were sales data flows from stores' POS to backend applications.Assisted in testing a variety of ATA VTA products, including test plan creation, test execution, and verification of work requests/bug reports.Utilized data analysis techniques to validate data integrity and accuracy throughout testing processes, ensuring reliable results and insights.Test AutomationDeveloped UFT scripts using object model and description programming, executing automation test cases post-manual verification of application functionalities.Conducted automated parameterization of dynamic content and multiple data sets within applications using UFT, enhancing test robustness.Inserted synchronization, standard, bitmap, and image checkpoints for enhanced testing accuracy in UFT.Worked on automating UI test cases using Selenium to improve the efficiency and coverage of functional tests.Analyzed automation test results to identify patterns and anomalies, contributing to the continuous improvement of testing frameworks.Web Services TestingPerformed manual testing of web services, including SOAP, XML/HTTP, and WSDL, using the SOAP UI tool to ensure correct functionality and performance of services.Worked closely with the development team to address defects, ensuring timely resolution and minimal disruption to the project timeline.Leveraged data analysis skills to assess API response times and data accuracy, providing insights for performance optimization and reliability improvements.Environment: QC, Base24, Bridge Tool, Selenium, UFT, Tandem, ATM/ATA/LTA/Next Gen Machines/ Target Application, POS, DMART, SQL.Achievements: I have successfully led multiple testing initiatives that significantly improved project outcomes and team efficiency. I played a crucial role in the development and execution of comprehensive test plans, which streamlined the transition of test cases from functional to regression projects. My collaborative efforts with product committees and project managers fostered effective communication, resulting in timely resolution of project impediments. I consistently enhanced defect management processes, collaborating closely with analysts and developers to address issues swiftly, which led to higher quality deliverables. Additionally, my contributions to test automation not only increased testing coverage but also improved overall efficiency by minimizing manual efforts. Through thorough data analysis, I identified key trends and patterns that informed strategic decision-making, driving continuous improvements across testing frameworks and methodologies.QA Engineer Consulate General of India SFO, CA Sep 2013 Aug 2014Key responsibilities:Test Planning and ExecutionDeveloped detailed test plans, cases, and procedures to ensure product compliance with application requirements.Collaborated with the QA team to design effective test plans and cases, enhancing the testing process.Executed functional, security, UI, regression, and UAT testing to validate application functionality and performance.ETL and Data TestingVerified ETL business logic for various feeds by checking log files for data accuracy and consistency.Conducted manual testing of ETL modules to ensure proper data transformation and loading.Monitored and tested Informatica data load jobs to confirm data integration and processing.SQL and Database ValidationUtilized SQL for backend and frontend functions to implement business rules and maintain security standards.Validated data with SQL to ensure processing and storage meet business requirements.Defect Management and ReportingUsed |
