QA Tester

Satbir Bhamrah

917-***-**** **********@*****.*** US Citizen Satbir Bhamrah LinkedIn

Summary

Experienced Business Data Analyst with a strong background in data analysis, reporting, and automation across finance, operations, and HR domains. Skilled in Power BI, Excel (advanced functions), SQL, Python, and SAP

(GUI, STORMS, SuccessFactors) for data-driven decision-making. Hands-on expertise with AWS cloud services, Workday HRIS, and CI/CD tools like JIRA and Confluence. Proven track record in developing dashboards, automating workflows, and ensuring data integrity for executive and operational teams. Skills

Microsoft Office Suite (Excel Expert).

Jazz/ Jira/ Azure DevOps.

SQL and Snowflake.

Methodology Agile/ Scrum and Waterfall.

Perform Regression, Unit and Smoke testing.

JSON Data Parsing & Transformation.

Public cloud: Amazon web services, S3, EC2, BitBucket add-ons, plugins, Elasticsearch. Generative AI for business with MSFT AZURE OpenAI Program. Experience

QA Tester DSA Remote Jan 2024 to Present

Designed and executed functional, regression, and UI tests using Cypress and Azure DevOps, ensuring robust coverage and stable releases.

Authored and managed test cases aligned with user stories and technical specs; tracked defects and coordinated resolutions with developers.

Conducted parallel run validations and UAT across stages, reporting discrepancies and ensuring data integrity.

Delivered tailored dashboards and reports to meet stakeholder requirements. Worked with large datasets from data warehouses to identify trends, patterns, and actionable insights. Participated in Agile development cycles, collaborating with cross-functional teams to deliver data solutions. Communicated findings through clear presentations and written reports for technical and non-technical audiences.

Assisted in data integration efforts across departments, enhancing data accessibility and usability. Sr. Financial Analyst National Grid Remote Jul 2023 to Jan 2024 Conducted daily CIAC reconciliations using SAP GUI and STORMS, ensuring data accuracy through report validation.

Collaborated with job owners and operations teams to resolve pricing discrepancies (GSB120), improving financial reporting accuracy.

Performed in-depth data analysis using SQL to extract, clean, and interpret large datasets for business insights.

Developed and automated reports and dashboards in Excel, utilizing advanced formulas, pivot tables, and data visualization tools.

Used SQl/ Python for data manipulation, statistical analysis, and automating repetitive data processing tasks.

Designed custom Excel-based project management tools, resulting in resolving more than 100 accounts discrepancies.

Lead Business Data Analyst Brillient Corp. Remote February 2022 to May 2023 Performed unit and regression testing across Elasticsearch, database, and UI platforms to validate code functionality and system stability.

Executed indexing services to populate QAQC Elasticsearch indices by scanning agency-specific buckets for new content.

Managed access provisioning for 90+ test users by updating SQL-based Users and Organization tables. Led migration of 25TB of data to Snowflake on AWS, achieving a 30% reduction in data access times. Ingested files into the UI via AWS S3 and ran ETL job batches, ensuring timely execution and resolving issues related to authorization and access control. Implemented AWS services including S3, Elastic Load Balancer, and Auto Scaling groups to support scalable cloud infrastructure.

Automated data cleaning, transformation, and analysis tasks using Python, improving workflow efficiency. Created documentation on user experience and UI-related issues, facilitating feedback loops between users and development teams.

Developed and deployed automation scripts for cloud platform operations, including monitoring and alerting systems.

Designed and executed complex SQL queries to extract, manipulate, and analyze large datasets for testing and validation purposes.

Conducted reconciliation between reports using Excel, involving extensive data formatting and comparison of usage vs. estimated materials.

Designed Power BI dashboards using data sourced from JSON files, enabling real-time insights for stakeholders.

Collaborated with engineering teams to optimize data pipelines handling semi-structured JSON data. Sr. Data Mapping Analyst Kaiser Permanente Remote June 2021 to May 2022 Collaborated with Kaiser’s data mapping team to design high-level data mapping solutions and database structures, providing SQL code support to developers. Delivered comprehensive technical documentation for data mapping and modeling logic, ensuring clarity and consistency across development teams.

Configured and maintained Epic modules (Ambulatory, Cadence, MyChart) to support clinical workflows and patient engagement.

Developed custom reports using Epic Clarity and Reporting Workbench to support quality improvement initiatives.

Validated, executed, and optimized SQL queries and stored procedures for efficient data loading and transformation.

Built and maintained SQL mappings for KP.org provider applications, offering technical guidance throughout the development lifecycle.

Used DAX formulas in Power BI to create calculated columns and measures for advanced analytics and reporting.

Connected Power BI to various data sources (SQL Server, Excel) to enable real-time and interactive data analysis.

Modified and implemented technical documentation in alignment with evolving project requirements. Created financial models and templates using Excel, incorporating Pivot Tables and Macros to streamline reporting and analysis.

Managed the complete defect tracking lifecycle using JAZZ: logging issues, generating status reports, prioritizing bugs, and maintaining detailed defect logs. Database Application Developer Freddie Mac. Remote Feb 2021 to March 2022 Designed and developed custom UI database applications tailored to healthcare needs, collaborating with SMEs to gather requirements and implement user-centric solutions. Built and maintained SQL Server-based applications, creating and validating SQL code, database objects, and performing peer code reviews to ensure data integrity. Applied SDLC principles across all project phases, from requirement analysis and scope documentation to development, testing, and deployment.

Utilized XAML and XML to build dynamic user interfaces and custom application components, aligning development with functional and user expectations. Data Analyst III Worldwide Flight Services Inc. Remote August 2018–August 2019 Executed data validation and reconciliation using advanced Excel functions (VLOOKUP, PivotTables, IF statements) to ensure accuracy across HRIS records and support audit readiness. Developed custom reports and KPI dashboards in Workday and Power BI, enabling data-driven HR decision-making and tracking of key metrics like time-off trends and benefit enrollments. Configured and maintained Workday modules (Time Tracking, Absence Management, Benefits), including security administration and role-based access controls, enhancing system efficiency and compliance. Led system upgrades and testing efforts, including UAT and deployment phases, ensuring seamless transitions and minimal disruption to HR operations. Clean up data in payroll systems HRIS, ADP and AE system (like: - Position status, Naming convention, duplicate file# etc.).

Data Analyst III Melrose Credit Union New York Jun 2017–August 2018 Provided clarification and support to ETL teams for accurate data extraction and transformation. Coordinated with regional database teams to ensure smooth data flow from source systems, using SQL queries for validation and troubleshooting.

Led extensive data mapping exercises to integrate source system elements into the Common Data Warehouse.

Automated manual data profiling processes using SQL and Excel, significantly improving efficiency and accuracy.

Compiled and analyzed data mapping findings, delivering regular reports to management for strategic decision-making.

Created interactive dashboards using Power BI with data sourced from SQL Server and Excel, applying DAX for effective data visualization and analysis. Lead Financial Analyst American Express India October 2014 - March 2017 Led business optimization initiatives by analyzing reporting tools, back-office systems, and paymentprocessing software to enhance operational efficiency. Facilitate month-end close process, invoicing processing, journal entries(accounting) and account reconciliation non-GAAP to GAAP figures.

Collaborated with cross-functional teams to align business and technology goals, delivering solutions that met stakeholder requirements.

Executed QA, system integration, and UAT testing, ensuring accurate and timely project delivery while supporting month-end close and invoice processing. Education & Certifications

Master Business Administration–Sikkim Manipal University, India 2014 Bachelor – Delhi University, India 2009

Agile at Work: Planning with Agile User Stories

Agile Project Management: Comparing Agile Tools

Learning JIRA software

AWS S3 Essential Training for Architecture

Awards

Stellar Teamwork & Accomplishment Recognition (STAR) Award at Brillient Corporation Spot Bonus Award Recognition (SOAR) Award at Brillient Corporation Awarded for best project and performance (ABPP) at American Express

Contact this candidate