Created data analysis using Microsoft and Oracle SQL code. Created data visualization using Microsoft Power BI. Data management using Azure software.

Data Analysis:Researched financial issues for RSP partners both internal and external that affected the general ledger of GERan weekly and monthly Reports for partners to communicate the creation and tracking of RSP entitlement cycle Created queries out of SQL to retrieve and analyze large data sets and breaking them down to relevant information for customersTook part in regression testing and building test cases for software and system upgrades for better performancesTrained and certified in both Yellow Belt Six Sigma and LEAN certifiedProject Management:Oversaw management of software application tracking $2 billion Revenue Sharing ProgramLead a project to process records falling out of software and recovering $80 million in entitlement for our external partnersOversaw an IT team in tracking bugs and enhancement for the RSP system and tracking these issues for upper management communicating updates and resultsUsed Agile software to create user stories and track the progress of the storiesCoordinated meetings with management, finance, IT and external partners to discuss issues and give updatesLed a project that fixed reports that was missing data for entitlement transactions for partners that was worth $6 million in recovery

Data Analysis:Organized and interpreted monthly Commercial vendor spend data for managers to understand cash flowCreated spreadsheets to compare commercial spend data over monthly, quarterly and yearly comparisons of cash flowOrganized excel folders of commercial data to make them more accessible for other employees to useTrained in Sharepoint and created online library of excel and pdf files for access on the Sharepoint siteProject Management:Processed vendor invoices and entered them into database to be approved and paidProcessed which GL accounts that invoices would hit as to make sure payments where correctly paidTemporary Business Analyst, TriHealth - Blue Ash, OH February 2018 - March 2018Project Management:Optimization of daily processes to create better efficiencyManagement of databases and helping to oversee transition to a new databaseWorking on Ad Hoc projectsLeadership:Management of data entry team membersLeading meetings to discuss issues and how to improve them

Optimization of daily processes to create better efficiency.Leading meetings to discuss issues and how to improve them.Management of data entry team members.Management of databases and helping to oversee transition to a new database.Working on Ad Hoc projects.

Working with children building their English speaking and reading abilities, lesson planning, volunteering for after school activities, working one on one with students, educating about American cultureProgram Development and Management:Developing and following of strategy to produce better learning in classroom setting · Research and Utilization of resources for education strategy· Capacity building with customers· Evaluating current teaching standards and Recommending changes· Quick Adaptability to new environment and individuals and successful with challenging situations Leadership:· Cross Cultural Awareness and Flexibility, capacity to work in challenging and unfamiliar events· Assessing target audience to acquire specific information and ideas· Leading a weekly after school reading program for students to practice English Coaching and Mentoring:· Information Transformation, Analysis and Evaluation· Practical and field experience that transitions to the boardroom· Coached students for English speech contests

Project Management:Redesigned monthly report for an outside vendor to deliver better results through better time and efficiency on the analysis of the collections budget vs actualsPrioritize daily work of collections projects and processes so that deadlines are met with high quality Run weekly queries on RTR to evaluate payroll costs that affect the monthly budget Manage weekly scorecard of daily call statistics for collections done by outside vendorCollect and analyze Fraud data for weekly ROF sheet to be turned into Finance departmentData Analysis: Analyze weekly collections costs and tracks differences between monthly budget and actual costs to better balance the financial costAccesses outside vendor’s monthly invoices and tracks their costTracks monthly employee attrition and OT costs that affect budgetAnalyzes data from Oracle databases that affect monthly budget and correct account balancesTransfers dollars to correct accounts to make sure monthly budget is balancedBudget Forecasting:Collects data for biannual budget creation and forecast for collections budget Creates and analyze monthly capacity plan to track collection’s call stats and monthly costs for collectionsForecasts monthly collections costs including outside vendor costs, contest incentive and travel costsCreates monthly ROF sheet to track budget costs to be turned into finance departmentSKILLS Proficient in Microsoft Office (Word, Excel, PowerPoint, Access)Experience with Oracle databases which includes RTR and E Business Suite

Project ManagementDesigned an employee vesting status query and led a team which determined the accurate vesting status of all employees working at a store that was closing which allowed termed associates to receive their eligible 401k and pension benefitsPrioritizes daily work of 401K projects and processes so that deadlines are met with high quality Runs weekly queries on Peoplesoft to check for weekly transactions that could affect employees’ savings rates Coordinates 401K benefits for employees’ 401k accounts weekly so customer service for employees will be high qualityManages quality control for weekly loan closures and loan changes so employees will be up to date with their loan paymentsData Analysis: Analyzed monthly pension account performance compared to the performance of the stock market so the benefits department can track trends in the performance of company’s pension accountReviews 401k deduction rates and loans and updates for the week to ensure employees have correct savings on their payment statementsScrutinizes retired employees’ pension audits so as to make sure that correct benefits are paid Gained experience with Peoplesoft, Multiplan and different vendors’ software and uses these resources to help provide excellent business resultsGained experience with Microsoft Resources: Word, Excel, PowerPoint and AccessAnalyzes pension and 401K vesting so employees’ accounts are up to date to enable payment of future benefitsTraining and Development:Completed HIPPA Certification to protect the confidentiality of employees’ records and protect their right to privacyTrains fellow team members so they can succeed in their careers and be able to perform their tasks at a high level of qualityAttends company workshops on how to better skills in the corporate environment and develop leadership skillsReceives feedback well and gives feedback so as to communicate thoughts on current projectsVolunteers in corporate sponsored charities