-Conduct monthly meetings with the Marketing Department to validate spend, improving reporting accuracy by 90 percent-Consolidate marketing spend for several platforms, including Bing, Google, Indeed, LinkedIn and Facebook-Produce marketing spend report by region for the accounting department, improving efficiency by 95 percent-Directed the Colombian office on building marketing reports in Tableau, improving the current process by 80 percent-Analyze revenue from different streams by utilizing pivot tables and graphs in MS Excel, improving efficiency by 75 percent-Collaborate in monthly reporting of KPIs, utilizing MS Excel and PowerPoint presentation for the CEO-Create ad hoc reports for the Accounting and Finance department

The mission of ABA Centers of America is to provide clients and their families with individualized and comprehensive care, helping to navigate the social, emotional, communication, and daily living challenges experienced by those with autism.

Agency specialized in media and marketing services. Provides media and marketing services for businesses. It also provides consulting services across marketing strategy, organization design, and marketing technology.Client: First Republic Bank-Created marketing campaign reports for several channels, including Digital, Print, OOH, Radio, TV, improving efficiency by 50%-Responsible for banking marketing campaigns for the following lines of business, Certificate of Deposits, Private Line of Credit, Private Wealth Management and Non-Profit-Improved current reports and dashboards by using DCM Google Campaign Manager 360, Alteryx Designer and Tableau, achieving 85% more efficient process-Created marketing reports utilizing MS Excel, pivot tables and charts, improving current reporting by 80%-Led the budgeting process of marketing campaigns by comparing budget vs. actuals, increasing efficiency by 75%-Analyzed vendor invoices and reconciled with amounts billed to the client, improving the process by 50%-Presented end of campaign reports and KPIs to upper management and to the client, by utilizing MS Excel, Tableau, and MS PowerPoint

-Run daily reports utilizing MS Excel to review correct set up on new bank accounts, improving the current process by 30%-Run daily reports utilizing MS Excel to review blocked reasons for bank accounts, improving the current process by 25%-Collaborated in the implementation and testing of Temenos T24 Core Banking Software-Ad hock reporting utilizing Olympic Banking System, NetX360 Pershing, JIRA, and T24 Core Banking Software

Cosmetic and beauty products company with over 15 years of experience using a scientific system to diagnose the Baumann Skin Type® and prescribe the optimal skincare regimen to improve skin health, designed by Dr. Leslie Baumann, M.D., New York Times bestseller author-Supported the IT Manager in uploading existing and new product information into the various databases-Reviewed PDF price lists for 2021 and converted them to MS Excel functional reports-Compared new pricing to existing database and updated product information by using VLOOKUP function in MS Excel-Managed projects online and shared information with a team by utilizing Asana Project Management Software-Updated out of stock products weekly on Skin Type Solutions Website, improving efficiency by 50 percent

-Supported the Project Manager by testing Temenos T24 core banking software, achieving 90 percent process improvement in the modules Teller, Draft, Checks, Securities and Money Market-Conducted interviews with cross-functional stakeholders in order to understand the process’ current state in the areas of Teller, Draft, Checks, Securities and Money Market-Reviewed the current state process flow in the areas of Teller, Draft, Checks, Securities and Money Market and updated the future state process flow after implementing Temenos T24 core banking software-Produced user guides for the banking software Temenos T24, in the modules Teller, Draft, Checks, Securities and Money Market utilizing MS PowerPoint, achieving 80 percent more efficient departments-Implemented test cases for banking software Temenos T24 for the modules Teller, Draft, Checks, Securities and Money Market, improving accuracy by 80 percent-Reviewed Temenos T24 core banking software to ensure the modules compliance with state and federal banking regulations pertaining to the United States

-Produced sales tracking reports utilizing SAP Business Objects and Pivot Tables, SUMIF functions, VLOOKUPs and other functions in MS Excel, providing accurate reporting by 95 percent-Created sales reports by volume, accounts sold, point of distribution for sales programs using MS Power BI and MS Excel -Worked with Supplier Team to set up and maintain the Supplier Hierarchy improving accuracy by 90 percent-Worked closely with suppliers to improve sales reporting capabilities by utilizing MS Excel and Business Objects for Applications-Provided analytical support to corporate and regional teams as required for supplier reviews, quarterly business reviews, and on-going business performance management improving current reporting by 80 percent-Participated in calls with Suppliers and Regional Marketing Directors by providing knowledge of sales reporting and sales goals

-Reported revenue analysis comparing actuals vs. budget for three MRO companies utilizing MS Excel-Updated margin analysis for three different companies using MS Excel, improving efficiency by 50 percent-Produced reports comparing budget, revenue and cost for top five clients, reaching 30 percent more efficient process-Created queries to retrieve data from Quantum ERP system by using MS Excel Power Query, improving reporting by 80 percent-Produced KPIs using MS PowerPoint and MS Excel graphs and charts describing budget, revenue and cost

-Improved Accounting departmental reports by 80 percent efficiency, utilizing MS Excel and Sage ERP Accpac-Supported the company in annual budget process by creating reports and meeting with overseas budget owners to evaluate variations of budget versus actuals, using MS Excel and Sage ERP Accpac-Collaborated in re-forecast process by evaluating year to date expenses versus company budget, utilizing MS Excel-Created monthly KPIs for upper management summarizing monthly and year to date budget, actuals and explanations of variances, using MS Excel-Built and maintained databases and ad hoc reports, including expense reports, variance reports and others utilizing MS Excel

-Produced monthly KPIs and dashboards by utilizing SAP Business Objects and MS Excel for the Default Management Department-Created monthly and year to date reports for the Default Management Department by using MS Excel, evaluating the performance of business lines and identifying trends -Implemented re-structuring of internal reports by using MS Excel and MS PowerPoint, resulting in 20 percent efficiency improvement-Produced headcount and staffing reports for the Default Management Department utilizing MS Excel-Created ad hoc reports by querying databases using MS Access, SAP Business Objects and SQL Programming Language, reviewed data accuracy and automated reports