Maribel V. Bawa Wilmette, Illinois ad2dw0@r.postjobfree.com US Citizen 847-***-****

Professional Summary: Dynamic Information Technology Business/Data Analyst with 10+ Years’ Experience Combining Business and Business Systems Analysis, IT Project Management; Relational Databases; Power BI, Sisense and Tableau Reporting, Database Analysis and Data Mapping, Data Reporting and Analysis Using Excel, SQL/MySQL; SQL Programming; Salesforce CRM; Data Mining; Workforce Management and Resource Planning; Healthcare, Pharma and Insurance Domain Knowledge; Business Process and Technical Presentations; Continuous Process Improvement Including Process Automation; System, User Acceptance, Quality Control and Validation/Beta Testing; Application Training and Development with End Users/Power Users; Coordination of Project Information Using MS Teams and SharePoint; Requirements Gathering and Analysis, Requirements Traceability Matrix, Writing of Use Cases, User Acceptance Criteria, Scenarios and Testing Scripts; Translation of User Requirements into Functional Specifications; As-Is and To-Be Process Flow Diagrams Using Visio and PowerPoint; Business Process Mapping and Analysis; Project Milestones Formation; Change Management, Risk Mitigation and Planning; Agile, Waterfall and Hybrid System Development Methodologies; Microsoft Office 365; Excellence in Interpersonal Communication, both Verbal and in Writing, Facilitation Skills, Trained on CVS Health and Baxter Quality Policies and Procedures; Trained on LEAN Six Sigma Concepts; Certified in Scrum and Agile Methodologies (SCRUMStudy Agile Master Certification), Yellow Six Sigma Certification; Currently Preparing for the PMP Certification Exam; Training and Teaching Expertise through Employment in North America, Europe and Asia; Knowledge in Sox Compliance (Sarbanes-Oxley Act) and HIPAA Policies

Professional Experience

CVS Health, Remote Oct 2021 – Dec 2023 Senior Analyst, 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

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

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

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

Ran and wrote work instructions 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

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

Senior Analyst, Resource Planning (April 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

Initiated a Dashboard Planning Document as part of a proof of concept to design a top-bottom drug-level forecasting process using forecast variances and month-over-month trends as KPIs

Took Excel courses to review the basics of Excel. Contributed insights and suggestions to improve the Excel Training Curriculum, which covered three levels – basic, intermediate, and advanced

Created charts 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 or VTO resource planning for the day is within or outside the acceptable forecast variance’s 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 will serve 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

Initiated the use of the NPS scoring system within Sales Ops, Strategic Initiatives and Sales Enablement teams

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; Assisted in the weekly and daily processing of the Return Ready Covid-19 Vaccination Opportunities as well as in the Aetna IBU opportunities 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

Migrated articles and briefing updates from a legacy content management application to HighSpot

Collaborated with content authors through the Voice of the Client initiative; propagated the new definition of issue management for content adoption

Hodgson Consulting & Solutions, 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

Provided technical assistance and trained end users and peers to become familiar with new technology and applications

Worked with cross-functional teams to gather, document, and approve business requirements for data analysis and reporting projects, as well as use BI and database tools to develop reporting solutions to meet business needs

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 Project Manager/BA/Business Data Analyst (Contract through RJT Compuquest Inc)

Lead 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

Proctored user acceptance testing; performed system and regression testing

Created process flows of current and proposed solutions, including a vendor-facing application to upload labeling artifacts that employed Identity Access Management processes (Okta tokens)

Managed user experience by soliciting feedback from users and tracking system issues

Assisted in the implementation of a comprehensive Knowledge Management strategy utilizing SharePoint lists and sites

Siemens Healthineers, Hoffman Estates, IL Mar 2019 – Sep 2019 Proj Coordinator/BA/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 Board and in other tools

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

North Shore Country Day School, Winnetka, IL Apr 2018 – Feb 2019 Business Analyst – Volunteer

Volunteered time and expertise in Instructional Learning via apps

Explored the lower school’s (K2 - Grade 5) technology needs

The Stakeholder Company, Singapore Aug 2014 – May 2015 Data Entry Analyst

Maintained data and work-flow processes to ensure a high level of quality assurance

Administered all content updates to both back office and production databases under strict guidelines

American Women’s Association of Singapore, Singapore Sep 2013 – Jun 2017 Interactive Website Deployment Analyst/Content Manager

Volunteered technical expertise to AWA Chairs and Leadership team in the proofreading and formatting of content

SAP Asia, Singapore Jan 2012 – Sep 2012 IT Project Management Support Executive (Contract through Softech Pte Ltd/Fujitsu Asia Pte Ltd)

Participated in alignment meetings with C-level executives and presented the result of the SAP Runs SAP APJ (Asia Pacific Japan) Design Thinking Strategy Workshop

Co-facilitated a four-day Design Thinking Strategy Workshop to formulate a sustainable strategy for the SAP Runs SAP program in APJ; Interviewed several business groups and stakeholders to create storyboards; documented current user needs in relation to the SAP Runs SAP program in APJ

Stamford American International School, Singapore May 2010 – Mar 2011 Database and Website Manager

Supported the enhancement activities of the Engage application, which was a school reporting platform with a database backend and a front-end user interface

Wrote requirements specifications and change requests on school reporting. This included attendance, pupil forecasting, health office, medical incidents, and financial reporting

Deutsche Post DHL, Singapore Jul 2008 – Nov 2009

Technical Assistant Manager – Customer Services Intelligence – Global Customer Solutions

Developed a Searchname Validation process which extracted unknown business partner names from various sub-systems found in a relational database. Utilized MS Access queries to perform the data selection and extraction. The database was part of a Teradata data warehouse

Mapped potential customer accounts into the corresponding GCS classification scheme. Created an accounts validation functional deployment diagram that highlighted the reports and data handovers between cross-functional teams

Prior Experience

From 1999 – 2008, technical roles with the following companies:

HSBC Singapore – Assistant Vice President – Business Transformation & Control – MIS; Compuware GmbH/Ford Motor

Company - Business Analyst; Goetzfried AG/Deutsche Bank – IT Specialist/New Data Center Shift Coordinator

Bank of America – Senior Technical Analyst; RL Canning/AMSDirect – Marketing Database Analyst; Exelon Corporation –

Associate Information Systems Analyst

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

Technical Summary

Databases: SQL Server, Teradata, Oracle, DB2; MySQL; 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++

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

Certifications

Sisense Modeling, Dashboard Design and Administration Certification, July 15, 2021

Yellow Six Sigma Certification, February 2021; SCRUM Agile Master Certified, May 2019

Contact this candidate