Alejandro Garcia Email & Phone Number

Columbus, Ohio, US

Columbus, Ohio, US

Columbus, Ohio, US

• Ingested new data sources via Fivetran into BigQuery warehouse
• Transformed raw source claims data using dbt and tested transformations/pushed to production using Git CI/CD
• Created reporting in Qlik and Looker for claims stakeholders

US

• Developed and deployed data and analytic solutions to drive increased efficiency and effectiveness across Property & Casualty and Corporate Services (Payroll, Aviation, Real Estate, Source to Pay) audit engagements
• Normalized and streamlined cleaning process for Nationwide Realty Investments (NRI) data using zoo and dplyr R packages, resulting in an annual time savings of 40 hrs for the NRI team
• Developed Tableau Training materials & onboarded all new Internal Audit associates (20+ total) to Tableau on a quarterly basis
• Member of OCFO Diversity Equity & Inclusion council and Internal Audit IDEA committee focused on creating a diverse, equitable and inclusive environment for our workforce and marketplace.

US

• Executed on the national communications strategy for Nationwide's Latino Associate Resource Group
• Curated a monthly newsletter for NLA membership to highlight the latest ARG updates and opportunities for ARG members
• Developed a Sharepoint site for enterprise-wide celebration of Hispanic Heritage Month at Nationwide
• Created ad-hoc Tableau dashboards for NLA leadership to gather insight into membership demographics and event engagement by pulling HRIS Workday data and joining to ARG Admin system data

US

• Designed and operationalized Continuous Auditing Program through R scripting and Tableau dashboards for 20+ data analytics projects to test and validate controls on an ongoing basis
• Created & maintained team-wide project inventories, sites, and project management dashboards to foster successful collaboration, knowledge retention, and a self-organized agile team
• Managed Internal Audit Tableau Server - user access permissions, server updates, etc.

US

• Maintained and delivered monthly Executive Packet of 30+ Tableau dashboards to provide operational, performance, and compliance metric insight to FSSC Controllership Vice President
• Built interactive Tableau dashboards and ad-hoc reports to provide insights to Accounting Operations, Regulatory Reporting, Finance Data Governance, Procure to Pay and Strategic Account Management business partners on.

Minneapolis, MN, US

• Promoted U.S. Bancorp products by making the necessary referrals to those who specialize in the bank's outstanding product line.
• Represented U.S. Bank at offsite events including tabling events, financial wellness seminars, and workplace banking events.
• Advised and assisted all new customers with the process of opening student checking accounts.*Note: 4 mo. Internship

Pullman/Spokane/Tri-Cities/Vancouver/Everett/Global, Washington, US

• Provided financial aid assistance and advising to students and parents through phone, email, and in person
• Utilized university-wide PeopleSoft imaging database to gather, track, and update student financial aid records
• Guided students through the Special Circumstances, Independency Appeals, and Satisfactory Academic Progress Appeals
• Streamlined FAFSA/WASFA application procedures by creating “how-to” videos to assist students in avoiding common pitfalls
• Managed distribution of communication materials for “Early FAFSA Gets the Aid” campaign to 46 campus departments
• Assisted in the preparation and delivery of mass communications to students using MaxBulk Mailer

Austin, Texas, US

• Managed the process of founding a new student chapter by researching requirements, recruiting executive board members, expressing interest to the national board and submitting required documentation
• Facilitated effective weekly executive meetings to plan events for ~30 general members
• Encouraged the involvement of the other officers and members of the organization through one-on-one meetings
• Created and managed budgets by researching estimated costs and developing Excel reports to track expenditures
• Awarded 2017 & 2018 ALPFA National Convention scholarship (Las Vegas, NV)

Professional Credential, Data Analytics

Bachelor’S Degree, Managment - Innovation & Change