Quality Assurance Power Bi

REBECCA A JOHNSON

Honolulu, HI ***** +1-808-***-**** ******@*****.***

LinkedIn: https://www.linkedin.com/in/rebeccaajohnson1 SUMMARY OF QUALIFICATIONS

Highly dedicated and dependable IT Professional with over 25 years of solid technical experience working with various technologies across many industries including Telecommunications, Retail, HealthCare, Finance, and Aerospace & Defense with experience working with cross-functional teams and business units including, but not limited to development, database architectural, system engineering, quality assurance, system administration, marketing, supply chain, business users, end users, project management, scrum, and product management. HIGHLIGHT OF SKILLS

Software Development Life Cycle (SDLC): Analysis & Requirements Gathering, Design & Prototypes, Development, Unit Testing, QA, Maintenance & Support. AI & Machine Learning: OpenAI (ChatGPT), Microsoft Copilot, Gemini. Programming Languages: PL/SQL, T-SQL, Python, HTML, IBM Cognos SDK, Visual FoxPro. Database Systems: Oracle, SQL Server, PostgreSQL, MySQL, SQLite, IBM DB2. DevOps & Cloud: Docker, Git, GitHub Repositories, GitHub Actions (CI/CD), Azure. Operating Systems: Windows Server, Unix, Ubuntu, Linux, macOS, VMWare. Data Modeling & ETL: IBM Cognos Framework Manager Modeling, SSIS, Decision First Modeler. Reporting & Analytics: Tableau, IBM Cognos Analytics, Power BI, SSRS, SAP BusinessObjects, Excel, SSAS (OLAP), IBM Watson Analytics. Category Management: Blue Yonder (formerly JDA), OneDoor. Project Management Tools: JTrac, Atlassian JIRA & Confluence, MS Project, CA Rally, Jama. Development Tools: SQL Navigator, SQL Developer, FTP/SFTP, Toad, IBM Data Studio, Azure Data Studio, MS Office, SharePoint, Visual Studio. EDUCATION

Master of Science (MS) in Computer Information Systems University Of Phoenix Phoenix, AZ

Oct 2005

BBA in Computer Information Systems

Georgia State University Atlanta, GA

Aug 1998

CERTIFICATIONS

Graduate Certificate in Foundations of Business Analytics University of Maryland University College Adelphi, MD Dec 2017

Graduate Certificate in Computer Science K-12 Teaching University of Florida Gainesville, FL

May 2024

PROFESSIONAL EXPERIENCE

Product Consultant Feb 2023 - Oct 2024

TATA Consultancy Services (TCS) Edison, NJ

I automated Quality Assurance (QA) tasks using Python scripting and SQL Server stored procedures and functions, improving efficiency, accuracy, and code coverage in executing test cases, verifying functionality, identifying defects, and streamlining the testing process to reduce manual efforts and ensure the overall quality of software releases. I conducted R&D in local environments using Docker, WSL, GitHub, GitHub Actions, and Ubuntu Runners to develop solutions for connecting on-premises SQL Server databases from within GitHub CI/CD pipelines, assisting another project team with the same challenge. I developed SQL Server databases for more efficient testing of DB processes, reducing dependency on data-intensive environments. I implemented DevOps and automation strategies for Continuous Integration/Continuous Delivery (CI/CD) within GitHub using YAML and GitHub Actions. Collaborating with the Center of Excellence (COE), I implemented the PyTest framework with Allure Reporting for automated test case validation of SQL Server stored procedures, ensuring error and warning checks during the LCM promotion process for the Merchandising environment in Category Management. I managed Docker containers and images within Docker Desktop for use in GitHub CI/CD pipelines.

I actively participated in daily scrum meetings with the Scrum Team, Scrum Master, and Product Manager, reviewing and updating Jira stories on the Kanban dashboard. I performed functional testing of customized SAPRO applications, including Floor Planning Plus, Space Planning Plus, Data Manager, CKB, and Open Access using Blue Yonder Category Management Suite. I collaborated with QA Engineers in conducting User Acceptance Testing (UAT) within Blue Yonder Category Management environments for various applications. I completed annual and ongoing compliance training while engaging in continuous professional development. I trained and supported QA Engineers in DevOps environments, focusing on GitHub Repositories and GitHub Actions (YAML) for CI/CD processing. I coordinated and conducted interviews for a Senior Data Engineer role, evaluating candidates’ expertise in Azure, Databricks, SQL, Python, and PySpark.

Working independently in challenging environments, I leveraged technologies like Python, Java, .NET, C#, DevOps, Sonar/SYNK security, Git, GitHub, Azure, Databricks, PySpark, and ADF with minimal mentorship. I utilized Visual Studio Code with extensions to build and evaluate software applications, verifying code specifications and requirements for functional and UAT testing, despite having no access to Visual Studio.

Data Analyst / Senior Project Program Manager Oct 2019 – Feb 2023 AT&T Retail Mobility – Retail Operations Atlanta, GA I collaborated with multiple business units, providing daily technical support for Blue Yonder’s (formerly JDA) Category Management Suite, including Citrix installations and connections. I supported the Category Knowledge Base (Oracle), which was used to create floorplans containing fixtures and planograms for over 6,000 retail locations, assisting more than twenty retail and corporate users in managing and maintaining product placements. I coordinated with various teams to implement, maintain, and support different systems and applications, including the implementation of single sign-on (SSO) using Halo.E over OAuth, SAML, or OpenID Connect, and I supported the upgrade of the Category Management Suite from version 2018 to 2019. I utilized Excel (Power Pivot/Query), Power BI, and Tableau to create pivot tables, tabular reports, and visualizations. I manipulated data using VLOOKUPs, XLOOKUPS, and various calculations to generate compliance reports that illustrated the percentage of completed tasks by channel, region, market, DOS, Area Retail Sales Manager, and retail location, updating and refreshing them for scheduled resets or releases. I developed reporting and analytic solutions using IBM Cognos Analytics 11.x, integrated with JDA Open Access, as part of the Category Management Suite (CMS) and Category Knowledge Base (CKB) within an AWS cloud infrastructure. My work included developing print quantity reports summarizing total facings across warehouses, categorized by new and replacement items, using prompt-based calculations for estimating entertainment store print quantities. I developed and modified Oracle PL/SQL stored procedures and functions within the CKB and JDACUSTOM Oracle schemas. I prepared complex SQL scripts, including subqueries and CTE queries, to extract data from CKB, troubleshooting issues, and correct data integrity problems based on business user requests. I modified source code in Visual Studio to update bulk edit templates for managing data related to stores, floorplans, fixtures, planograms, and products. I collaborated with corporate IT operations (ITO) to address system-wide issues affecting the project team, provided requirements for software updates, and visited retail locations to document and resolve reported system issues related to internet browsers, PDF downloads, and McAfee virus protection conflicts. I interviewed technical team members, including Database Administrators, as potential candidates for the retail operations technical team. I provided technical leadership and guidance on various solutions, including JDA Category Management Suite for floor and space planning, supply chain, retail operations, and user management. I assisted with database queries and report development in Tableau, Power BI, Open Access (Cognos), and Excel Power Pivot/Query. I conducted weekly status and technical planning meetings to review project statuses, database planning activities, action items, and ServiceNow tickets. I mentored a .NET Core Developer through a special program, assisting with testing and reviewing a .NET Core application written in C#, which used Azure Function App and App Services to process automatic data files into a SQL database directly from Azure storage accounts. I trained new technical team members on report development, project workflows, and technical requirements to integrate them into the retail operations team. I coordinated the implementation and support of a new Retail Operations database and web application within the Microsoft Azure Portal and SQL database as part of a Software-as-a-Service (SaaS) platform, maintaining compliance artifacts within MOTS and attending weekly technical team meetings to plan and implement new features and functionality.

I coordinated and supported external vendors, such as Archway, to ensure daily processing of inbound and outbound files, assisted with application support issues—including SPI Scans, SSO implementation, and application sunsetting—and troubleshot user access and role-based issues within CKB data files. I provided technical support for the retail chain’s task completion applications, including AIMM Task and iPOG, which ensured compliance with active releases and resets. I reviewed and analyzed Oracle database scripts and stored procedures to evaluate and document new or modified features before approving their implementation in production. I modified bulk edit templates and scripts in Visual Studio Code to adjust column settings for bulk-edit processes. I worked within the One Door Merchandising Cloud platform, providing solutions and user support for content, locations, fixtures, floorplans, planograms, and reporting while resolving data transfer issues between JDA Category Management, CKB, and the merchandising cloud. I verified new Microsoft Azure Function App and App Services solutions for processing data files from Data Router into Azure storage accounts and inserting incremental or full-load data into SQL databases. I used SQL tools such as Toad Data Points, SSMS, and Azure Data Studio to retrieve datasets and perform data analysis. I downloaded processed files from SFTP based on Category Knowledge Base updates made by business users and uploaded relevant files to OneDrive for business teams. Business Intelligence Developer - Contractor Apr 2019 - Aug 2019 IBM Watson Health Atlanta, GA

I conducted research and analysis on geocoding and geospatial analyses using integrated MapBox features within IBM Cognos Analytics. I researched and compiled critical materials related to the MITA Framework 3.0, administered by the Center for Medicare

& Medicaid Services (CMS), for state-based implementation of Medicaid Management Information Systems (MMIS) for the State of Georgia. I designed documentation templates for report specifications, unit test cases, professionally administered standard reports, peer-review plans, and business architectural designs. I implemented and managed an organized SharePoint environment for team collaboration and stakeholder reviews. I assessed and examined requests for proposals (RFPs) to gain a clear understanding of statewide Medicaid enterprise solutions for the State of Georgia and key BI components related to reporting and analytics. I reviewed infrastructure plans and internal project documentation to understand the interdependencies within the Enterprise Data Solutions implementation for Georgia. I created database objects and loaded data into tables used by external applications for BI solutions, including reporting, visualizations, and analytics. I designed metadata models, structured business and database layers with descriptive naming conventions, and published content to the web for BI solutions while using advanced Excel functions for report mockups. I queried and extracted data from IBM AdvantageSuite and IBM DataProbe environments for data analysis. I used WebEx, Slack, Sametime, and Jama for team collaboration, reviewing key business and functional requirements related to project implementation and process flows. I completed training in HIPAA, data security, Medicaid 101, risk management, scope management, communication management, and Agile methodologies. IBM Cognos/Tableau Developer Jan 2018 - Mar 2019

UnitedHealth Group (Optum) Eden Prairie, MN

I performed data analysis for accuracy validation checks and query performance tuning within the Oracle ODS. I developed database objects and complex SQL queries to fulfill data analytics requests for both internal and external customers. I created ad-hoc queries using direct SQL to generate tagging reports with relevant client-requested information, delivering outputs in Excel and Access. I generated and refreshed monthly files, uploading them to shared locations for customer access to support monthly reporting. I provided daily support for Cognos Analytics 11 and Tableau 10 applications, ensuring business applications functioned properly and executive dashboards and reports provided consistent, accurate information. I assisted with yearly Cognos Analytics audits and compliance requirements by gathering, compiling, and submitting necessary documentation for review by the auditing team. I also provided ongoing administrative support for Cognos Analytics 11, assisting the Cognos Administrator by delegating tasks and managing application support as needed.

I developed data models and complex reports utilizing prompts, drill-throughs, variables, links, JavaScript, security settings, and reporting templates while providing ongoing application support to business users and customers. My experience contributed to fraud, waste, and abuse prevention in healthcare claims by running claims through analytic algorithms to ensure payment integrity for healthcare providers, including UHC, Highmark, BCBS, and CVS. Report Developer - Contractor Aug 2017 – Nov 2017

Cognosante McLean, VA

I consulted with business users to define requirements for BI reporting and analytics solutions. I designed reporting and analytics solutions using Tableau and Microsoft Excel Pivot Tables, including the development of reports, visualizations, and dashboards. I imported weekly and monthly data files into Tableau, refining and transforming them into meaningful dimensions and measures to create moderate to complex visualizations and dashboards. I attended daily scrum meetings to discuss sprint progress and user stories, as well as daily technical meetings to address project- related technical issues and best practices for data modeling, reporting, and analytics. I performed data analysis on ODS and OLAP environments, ensuring data accuracy and integrity while documenting processes related to reporting and analytics solutions. I evaluated and recommended market-leading tools for a potential Tableau automation project. I validated and assessed SSAS tabular cubes used as data sources for developing Tableau and Excel reports. Additionally, I utilized Data Analysis Expressions (DAX) and Multidimensional Expressions (MDX) queries to validate SSAS OLAP data sources for designing, developing, and testing reports in Tableau and Excel.

I validated Tableau’s administrative features and functionalities, including running batch commands to refresh and publish data and workbook extracts to the Tableau server.

Software Engineer – Contractor Aug 2016 – Jun 2017 Camber Corporation Huntsville, AL

I engineered, evaluated, and documented database and software application solutions using the Microsoft BI toolset, including SSMS, SSIS, SSRS, SharePoint PerformancePoint Dashboard Designer, and SQL Server Data Tools. As part of a unified team effort, I contributed to the implementation of a system that automatically profiled and quality-screened source data by evaluating it against predefined metrics and rules. This process generated calculated metrics with min/max threshold values, pass/fail indicators, and error descriptions for each profiled object, such as source files, tables, columns, and field values. I developed complex Tableau worksheets and dashboards, including scorecards and detailed worksheets, to support internal customers and external clients. I attended monthly town hall meetings and completed all required company training while working toward company, professional, and personal development goals. This included participating in the implementation of modern technology initiatives and completing scheduled training aligned with SMART and professional development objectives. I utilized CA Rally to create and manage Agile projects and tasks, promoting each assigned task through the Software Development Life Cycle using Scrum and Kanban methodologies. I effectively managed my time to prioritize high-priority core development tasks for external clients while addressing internal development requests, ad-hoc tagging queries, and reporting needs. I also provided ongoing application and administrative support to both internal and external customers. In addition to my core responsibilities, I maintained my professional and personal development through online training and firsthand experience with my own BI environment to stay up to date with evolving technologies. Senior BI Developer Feb 2015 – Mar 2016

RelayHealth – McKesson Atlanta, GA

I documented artifacts related to various BI projects, including RTMs, HLDs, LLDs, function points, report specifications, and unit test cases. Using internal tracking systems like JTrac, I maintained project tracking details for development requests. My daily customer support consisted of fulfilling ad-hoc requests such as granting user access to BI solutions and updating production databases with new sponsors, drugs, and manufacturer information. I conducted peer reviews of code, reports, unit test cases, and technical documentation while developing BI data models, packages, reports, and database views for reporting and analytics solutions. Utilizing Excel, I created visual presentations, pivot tables, and VLOOKUP techniques as required. Additionally, I supported IBM Cognos administrative and security functions for business user communities and stakeholders.

I performed detailed data analysis to determine optimal query designs and troubleshooting issues with existing queries by testing SQL performance and structure. Supporting the SDLC process, I promoted IBM Cognos objects across different environments and provided ongoing maintenance for production reports. I collaborated with project stakeholders to ensure optimal design approaches for new development, regularly attending weekly and ad-hoc project meetings. JOB RELATED TRAINING

x Six Sigma, Generative AI, BusinessObjects Enterprise XI 3.1 Administration and Security, Business Objects Enterprise XI 3.1 Crystal Reports, BusinessObjects Enterprise XI3.1 Web Intelligence, IBM Cognos v10.2 Transformer, IBM Cognos v10.2 Dynamic Cube Design, IBM Cognos v10.2 Active Reports, Cognos TM1 10.2.

PROFESSIONAL DEVELOPMENT TRAINING

Java, JavaScript, R, PowerBI (DAX), Data Science, Machine Learning and AI REFERENCES

AVAILABLE UPON REQUEST.

Contact this candidate