a Business Analyst and VBA developer

Senior Financial Reporting Professional / CarePlus - Humana

Mar 2021 - Feb 2024

Created multiple Power Apps application to support daily operations, including SharePoint lists, and Power Automate. Automated process to assist providers contracting cycle informing involved parties via MS Access, Outlook, Excel integration. Generated automation to ad hoc reports, regular datasets, and multi-steps information for end-users using system tools and data warehouse queries and scripts.

Financial Accounting & Reporting - Senior Level / FedEx under Aston Carter contract

Jun 2019 - May 2020

VBA applications development to integrate Oracle Essbase to Excel-Access via Oracle Smart View to extract operations and accounting data from Essbase to be used in Power BI. Help to develop end to end Power BI reports. Ensure data quality and uncover exceptions. Programmed models to track hierarchies and to forecast shipping rates.

Outlook - Excel Application Improvement / ADT Security Services under Kforce contract

Sep 2018 - Nov 2018

VBA applications improvement. Refactored and added functionality to applications --AIP, Merit— to be multiyear, able to create, read, and email Excel files with single command. Applications able to create thousands of PDF statements and email blast them. Served as project manager, application architecture, business analyst and VBA programmer. Improved code maintainability and optimize performance

Salesforce API integrator - Add-In Excel / HOTWIRE COMMUNICATIONS under RHT contract

Mar 2018 - Sep 2018

Built Excel Add-ins to integrate to Salesforce REST API to multiple Excel models. Used multiple tools to download data from Salesforce: VBA, JSON, SOQL, HTML, OAuth2. Applications connect to Salesforce, authenticate, run SOQL, and download JSON data to populate Excel files with thousands of records. As per business requirements, the project helps improve data quality by finding duplicate records. Worked on application architecture, created ribbon (menu) commands, and performed JSON data manipulation

Business Analyst, Programmer / EXTERACTIONS under 1099

Oct 2016 - Feb 2018

Responsible for assessing the operations, gathering technical and business requirements, define technical approach and top-level architecture for VBA Applications. Created applications that integrate MS Office Access, Excel, and Word. Helped to control costs and specifications through the projects. Created scope documentations, as well as processes and projects flowcharts

Operations Financials and Reporting Consultant / CROSS COUNTRY HOME SERVICES Kforce contract

Mar 2016 - Sep 2016

Reengineering of operational reports. Project required reviewing operations and actual metrics for service delivery. The project presented contact center metrics, claim job full-process reporting schema, service delivery regression analysis, and plan to rebuild operation with nine-million-dollar target savings plan. Helped to review Oracle Business Intelligence (OBI) and proposed new reports, including main KPIs and management reports.

Excel Guru - Business Analyst / ADT Security Services under Kforce contract

Jun 2015 - Feb 2016

Built multiple MS Office tools to perform Annual Incentive Plan (AIP), Equity Plan, Merit Incentive Plan, Canada Incentive plan, and Q5 Plan. Integrated Excel and Outlook to generate, send, and read Excel files, as well as create employees’ individual PDFs statements and email blast them. Served as project manager, application architecture, business analyst and VBA programmer. Developed SQL in VBA to query data to create Excel files.

VBA Developer for Access and Excel Applications / EXTERACTIONS

Sep 2007 - May 2015

Worked with business owners, project managers and final users to develop applications to improve processes. Modeled business processes to define architecture/relational-database requirements. Created applications that integrate MS Office Access, Excel, and Word. Helped to control costs and specifications through the projects. Created scope documentations, as well as processes and projects flowcharts. Execute programming to various modules when required, using VB.NET, ASP.NET, VBA, HTML.

Senior Operations Research Analyst / INTERVAL INTERNATIONAL

Nov 1999 - May 2007

Supported and trained others in Excel automation and database programming. Created databases to help perform annual budgeting. Conducted reports for operations analysis using computer systems and software applications. Designed solutions and software tools to improve OR departmental productivity, particularly created database that house OR reports by analyst. Produced and managed different reports.

Designed and developed integrated systems that summarize data by office, by month, and by term; keeping transaction details to help monitoring transaction exceptions. Assisted IT department, Business Intelligence Team, in designing reports. Gathered information by product and office to support preparation of revenue budget.

Created daily, weekly and monthly international operations production reports based on IBM AS-400 database. Automated many steps to improve efficiency and correctness.