Carolyne Nderi Aswani

SQL, Excel, Power BI Boot Camp Training

• Conducted detailed analysis of key trends and findings to summarize findings for leadership
• Extracted various real-life data requests, such as pricing, salaries, education level, job functions, and market data for real estate market analysis (Zillow) and employment labor (Glassdoor) data via MySQL
• Developed new reports, updated existing reports, and created routine reports based on defined requirements.
• Created and manipulated various real-life Excel reports, such as HR demographic, compensation, e-commerce sales, and restaurant industry data, while utilizing LOOKUPS, logical statements such as if/then statements, filtering and sorting, and text and date manipulation via CONCAT, TEXT, LEFT, and RIGHT functions
• Utilized formulas to extract data from queries into Excel spreadsheets

• Developed troubleshooting steps covered in CompTIA methodology, utilizing Virtual Box
• Collaborated with a partner to disassemble and assemble a CPU and laptop
• Maintained level head under extreme pressure and problem-solving

• Performed Data mining and analysis using a cloud-based software system (PointClickCare), maintained and reviewed aged receivable reports
• Presented regular status updates and workflow recommendations to senior management
• Participated in revenue cycle processes, working to maximize profitability and increase revenue
• Developed an automated email process to inform account holders of payment due dates, resulting in a 40% reduction in late payments
• Completed weekly account reconciliations to identify discrepancies
• Identified and corrected Medicare, Medicaid, and Managed Care billing and payment problems involving patients or third-party payers
• Planned, coordinated, mentored, and developed continuing education programs relevant to the needs of departmental personnel
• Managed submission, processing, and accelerating accounts payables vendor invoices using an AP automation cloud-based software system in accordance with company policies

Accounts Receivable

• Verified patient benefits, account data collection for private payers, and communicated to residents their benefits and patient financial responsibilities
• Calculated, monitored, and forecasted daily census activity including updating resident data, financials, and patient demographics information to determine business requirements
• Developed user cases for maintaining facilities, petty cash accounts, and replenishment processes
• Managed proper execution of patient trust fund accounts in accordance with applicable State, Federal laws and accrediting agency standards
• Promoted to Business Office Manager in ProMedica Senior Care

• Inventoried and ordered supplies for the office.
• Managed physical and digital files, monitored spreadsheets, and updated reports to coordinate project materials.
• Collected and issued receipts on our daily cash and checks for audit compliance
• Answered phone calls and emails to provide information, resulting in effective business correspondence.
• Promoted to Patients Accounts Data Analyst in ManorCare Health Services