Data Analyst Information Technology

Maribel V. Bawa Wilmette, Illinois ***********@*****.*** US Citizen 847-***-****

Professional Summary

Dynamic Information Technology Business/Data Analyst with 8+ Years’ Experience Combining IT Project Management; Business Systems Analysis, Statistical Analysis, Gap Analysis, Snowflake and Python; Data Mining and Data Visualization using Power BI, Sisense and Tableau; Jira and Confluence; Salesforce CRM including Lightning; Database Analysis and Source-to-Target Data Mapping of Business-Defined Attributes to SQL Server and Teradata Attributes; SQL Database Querying, Data Reporting and Analytics Using Excel, SQL/MySQL; Knowledge in Academic Data, Education-Related Technologies and Systems, Health Care, Pharma, Finance and Accounting Principles, Claims and Property Insurance, Technology and Workforce Strategy (People Analytics); Cybersecurity Best Practices; Knowledge and Experience in Alteryx and Informatica; Continuous Process Improvement Including Process Automation; System, User Acceptance, Quality Control and Validation/Beta Testing; Requirements Gathering and Analysis, Translation of User Requirements into Functional Specifications; Data and Process Flow Diagrams; Agile, Waterfall and Hybrid Project Life Cycle Methodologies; Microsoft Office 365 Products Including SharePoint, Visio, Project and PowerPoint; Knowledge and Experience in Azure DevOps (TFS); Excellence in Interpersonal Communication, both Verbal and in Writing, Yellow Six Sigma Certification; SCRUMStudy Agile Master Certification

Professional Experience

RT New Ventures LLC, Onsite Mar 2024 – Dec 2024 Business and Systems Analyst/Scrum Master/Senior BA/PM – National Merit Scholarship Corporation

Facilitated the agile ceremonies, in particular, the daily Stand Up, Sprint Planning, Backlog Refinement and Sprint Retrospective meetings

Performed deep dive and troubleshoot bugs and blocks reported during stand-up meetings

Managed and monitored the intake of projects using JIRA and updated ticket project status promptly

Managed risks brought on due to development delays, misalignment in business requirements

Collaborated with the necessary teams to move the sprint tasks to the next phases of the product life cycle

Worked closely with the corporation's management team to understand the business, mission, goals, and objectives

Gained in-depth knowledge of the corporate functions, processes, operations, and IT environment, and learned how business applications were used to achieve or facilitate the primary functions of the corporation

Improved systems by studying current practices and designing modifications; Maintained system protocols by writing and updating procedures

Performed the following project responsibilities: a) clearly defined the project objectives and scope; b) completed a project plan (i.e. project charter) and other management documents following project manager or PMI standards; c) monitored project progress by tracking activity, resolving problems, publishing progress reports, and recommending actions; d) worked with business stakeholders to understand priorities and ordered the Product Backlog accordingly

Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high level information into details, abstracted up from low level information to a general understanding, and distinguished user requests from the underlying true needs

CVS Health, Remote Oct 2021 – Dec 2023 Senior Analyst/Scrum Master, CGSO Analytical Insights (July 2023-December 2023)

Gathered and documented the functional requirements for the Clinical Government Services Operations Productivity Scorecard Rebuild and Automation project, which aimed to deliver employee performance metrics reporting via e-mail and via a Tableau dashboard

Facilitated the intake meetings of the team to assess the priorities and action steps regarding incoming and existing user queue requests

Performed data mapping of Excel-based performance metrics and fields to data warehouse attributes

Extracted daily Verint Queue headcount data using Alteryx workflows. The outputs were analyzed and powered the Resource Planning Optimization tasks of the CGSO Workforce Management team

Ran and wrote work instructions or playbooks to manage various processes, including the Verint Account Management of Agent Login IDs, Senior Production – Medicaid Monthly Scorecard reporting, ePA Loop 1 and IDP (IntraDay) Forecasting Load Processes and Verint Queue Analytics Extract Process

Analyzed and documented KPI calculations of Verint and other data attributes that enabled the extraction, transformation and loading of data into denormalized tables and views; maintained and documented Alteryx workflows

Performed quality control, quality audit, unit testing on the KPIs obtained from several data sources, comparing them with staging and/or Tableau development dashboards and existing Excel-based scorecards

Updated Client Value financial metrics for both the Government Coverage Determination and Appeals (CD and A, all segments) and the Clinical Services Operations (all segments) as part of the Monthly Operating Review metrics reporting to Senior Leadership

Executed SQL scripts which supported the analysis of the reference and denormalized tables as part of the Productivity Scorecard Rebuild project

Sent monthly communication including milestone reporting to business partners regarding project status of the Productivity Scorecard Rebuild and Automation Initiative and the transition of the Quality Audit and Support team’s responsibilities to the CGSO Analytical Insights team

Senior Analyst, Resource Planning (May 2022-June 2023)

Documented the data workflows of Aetna Part D and Aetna Part B budget and reforecasting processes

Delivered monthly MAPD (Medicare Advantage Prescription Drugs), Aetna Part D, Aetna Part B and PDP (Prescription Drug Plan) coverage determination and appeals case volume variance reports to Finance and Senior Leadership

Ran the drug-level forecasting Excel-based process as part of the end of month Monthly Operating Review metrics reporting and analysis; wrote summary reports on the top five and bottom five drug variance results; analyzed drug trends

Explored the feasibility of converting the drug-level forecasting Excel-based processing tool into a Power BI solution

Gained knowledge in time-series forecasting using Facebook Prophet with Python

Created graphs for the GSO lines of business that allowed the team to see the forecast in relation to a “safe zone” which helped determine if the OT resource planning for the day or week is within or outside the acceptable forecast variance thresholds

Delivered monthly capacity planning case volume metrics to CVS Health's PBM IT and Business Forecasting departments

Output reforecasting files (1RF, 2RF and 3RF) as well as budget forecasts (1st, 2nd and 3rd submissions) throughout the year to support the CGSO (Clinical and Government Services Operations) Strategic Resource Planning activities

Improved the existing Vendor Management Budget Forecasting tool through collaboration with Process Owners to build a working case volume calculation tool that that served as input to the Resource Planning team's workforce strategy

Executed SQL scripts that supported the budget forecasting and reforecasting data processes. Created forecast tables and views using Teradata SQL Assistant

Sales Ops Business Analyst - Contract through SGS Consulting (Oct 2021 – Mar 2022)

Developed the building blocks to the Monthly Operating Review Metrics reporting which involved gathering departmental data, research on the measurement of project success

Liaised with Sales Enablement, Sales Operations under Strategic Sales Solution, Sales Operations Communications, Specialty Carve-Out Governance, Strategic Initiatives, Bold Growth and Aetna IBU project leads and directors to obtain insight into their metrics reporting needs; documented their KPIs

Performed data analysis and modeled data using Excel

Participated in Continuous Process Improvement initiatives in data maintenance and data governance of both the Kidney Care and PBM Salesforce instances; wrote instructions to process data files prior to bulk upload and enhanced knowledge articles with greater depth and clarity

Assisted in the development of an Excel solution to support multiple validation columns in a Salesforce Compliance Audit initiative

Performed bulk upload to support several internal Salesforce initiatives that included User Provisioning, Client Care Access, and New Account Hierarchies – account subtype, account class and account indicator

Consulted with business users on optimal data management and reporting strategies, especially in Specialty Carve-Out Governance

Hodgson Consulting & Solutions, Ltd., Buffalo Grove, IL Apr 2021 – Aug 2021 Business Intelligence Specialist

Provided application analysis and data modeling design using Sisense

Facilitated information gathering sessions with stakeholders, identified and documented client requirements for business data analysis and reporting

Analyzed property damage Excel spreadsheet to predict areas where insurance claims would arise due to weather disruption

Created a project plan for a BI Implementation project using Excel and ConnectWise to document the tasks of environment preparation prior to database tables migration, establishment of database housekeeping routines, requirements gathering, modeling, and feedback gathering sessions during the pilot testing, UAT testing and roll out of the BI solution to a client

Baxter International, Round Lake, IL Jan 2020 – Dec 2020 Business Data Analyst/Scrum Master/PM/Database Analyst III (Contract through Apolis, RJT Compuquest Inc)

Led as the PM and Business Analyst Team Member, in the migration of a SharePoint-based application with MS Access in the front-end to a Dot Net SaaS solution in the AWS-RDS cloud environment with MS SQL Server database in the backend. The migration supported the Global Labeling Tracking requirements

Participated in troubleshooting sessions with development and DBA teams; proposed solutions and assisted in decision making to support business functions

Analyzed the database model constructed by the DBA team and assisted in the data mapping task from legacy data (source data) to new data models, new attributes (target data); assisted in data validation, transformation, and migration. Database used was SQL Server

Participated in Power BI metrics meetings with stakeholders to identify reporting needs; Identified measures or dimensions to add to the Power BI model

Planned application release and enhancement activities; maintained project plans and drove tasks to completion using MS Project

Facilitated CMB (Change Management Board) meetings and administered the Functional Requirements Log to support application releases

Performed SDLC technical processes including requirements analysis, use cases and functional specifications documentation, system and user interface design collaboration with offshore development team, disaster recovery planning, testing, training, and deployment; ensured quality was maintained in all business and technical specification documents and processes

Organized training and coordination channels in Teams and in SharePoint; Trained +70 users of a SaaS Dot Net solution on AWS; prepared role-based training materials using PowerPoint; assisted in the preparation of the initial Global Labeling System playbooks and handed over to the business for further releases

Siemens Healthineers, Hoffman Estates, IL Mar 2019 – Sep 2019 Business Analyst/Project Coordinator/Content Spec I (Contract through Viva USA, Inc.)

Analyzed the reporting requirements and prioritized them based on inputs from stakeholders

Assisted in the data gathering and Project Online input activities to report on the employees’ actual hours worked against the projected hours planned per project task

Updated and maintained project status content in an Azure DevOps-hosted Kanban Board and in other tools; Learned the concepts of DevOps as it related to the projects under the Cross Functional Excellence, IT group

Collaborated with offshore resources located in Germany to troubleshoot issues in rendering content packages in the Power BI service

Facilitated the procurement of Power BI and Project Professional licenses/access and configured role permissions in the Power BI service

Planned for the Project Online Project Web App’s rollout phase in conjunction with the Third-Party Business Partners, SHS IT Core Team Members, and Project Online Instance Administrators

Managed project requirements and took part in the different testing phases - unit, system, and regression testing; Maintained SOWs, Project Change Orders and Project Schedules

Arise Virtual Solutions, Remote Jan 2019 – Apr 2019 Customer Service/Support Professional (Seasonal Work through Freeman Consulting Services)

Certified and trained as a Customer Support Professional supporting the Intuit TurboTax Software users nationwide using Salesforce

Participated in Quality Assurance and Performance Improvement calls with a Quality Assurance Manager to raise the Net Promoter Score

Northshore Country Day School, Winnetka, IL – Business Analyst (Volunteer)

Prior Professional Experience

2007 – 2017, technical roles with the following companies in Singapore:

Please refer to my LinkedIn profile for details: https://www.linkedin.com/in/maribel-viray-bawa

2004 – 2007, technical roles with the following companies in Germany:

Please refer to my LinkedIn profile for details: https://www.linkedin.com/in/maribel-viray-bawa

1999 – 2004, technical roles with the following companies in United States:

Please refer to my LinkedIn profile for details: https://www.linkedin.com/in/maribel-viray-bawa

Education

Master of Science in Computer Information Systems, University of Phoenix, 2004

Bachelor of Science, with Honor, Information Systems, DePaul University, 1999

Achieved Dean’s List on two grading periods

Additional Professional Training in Power BI, Tableau, Sisense, PostgreSQL

Technical Summary

Databases: SQL Server, Teradata, Oracle, DB2, PostgreSQL; MySQL

Agile Tools: Jira, Confluence, Azure DevOps

SaaS Cloud Platform Technologies: SharePoint Online, Project Online, Dot Net Custom Solutions by Client Companies

CRM and Workflow Tools: Microsoft Office 365; Salesforce, Salesforce Data Loader, Toad

Web Programming Languages/Graphic Design Tools: Adobe InDesign, Adobe Photoshop, HTML, CSS, ASP, JavaScript

Programming Languages: SQL, VBA, C/C++, Java, JavaScript, Python

BI Tools: MS Access, Cognos, Power BI, Sisense, Tableau, Alteryx

Certifications

Yellow Six Sigma Certification, February 2021

SCRUMStudy Agile Master Certification, May 2019

Contact this candidate