Experience

• 

  Us army

  May 2015 - Aug 2019

  Area manager

  Presided over 40 security specialists and was responsible for team member performance, inventory management, and program management during field training simulation operations.• Improved individual and team-wide performance and morale through hands-on training, coaching, and leadership by example. Simultaneously aided team members with professional development and career progression.• Played a key role in planning and executing annual training programs and created an exceptional safety and compliance track record of zero discrepancies throughout all training exercises, with equipment valued in excess of $1MM.• Developed timelines to manage priorities effectively when participating in military face-to-face, telephone, and e-mail channels to spread awareness of NATO missions in the Ukraine.• Created an inventory management system to track equipment worth $5M and managed all infantry company equipment valued at $5MM. Show less

• 

  Nyc taxi and limousine commission

  Apr 2016 - Jun 2021

  • Manage Accessible Street Hail Livery (ASHL), a grant program for permit owners with accessible vehicles; increased the retention rate of such vehicles by 20 percent compared to previous years.• Automated the returned payments process using SQL and R and increased process efficiency by simplifying and developing reporting criteria for executive staff.• Reinvented the code for improvement surcharge taxes collected quarterly, by developing the testing cases in the code and implementing new data tables. This effort resulted in increased accuracy of TLC improvement surcharge invoices by 100 percent.• Manage and maintain the version control of project scripts utilizing Git.• Developed the mail merge script to send e-mails with individual attachments and track agency communication with external users.• Automate the agency financial data table updates with SQL stored procedures.• Gather information and create the data flow modes to show the management how data flows in the agency.• Automate accounting receipts process that saves time and resources for the company.• Managed process automation for TLC improvement surcharge taxes to move it on more frequently base that help the agency get the tax money three times as fast and give the clients able to pay the bill every month at the same time.• Support the product owner for IT financial automation processes, conduct the project proposal, user acceptance testing, regression testing, managed project timeline, and created bugs and user stories in DevOps. Show less Perform detailed analyses to produce accurate budget forecasts and generate complex financial reports to progressively improve operational efficiency and profitability.• Developed and launched the ASHL operational payment program; responsible for creating the program’s requirements, process flow, and timeline. The ASHL program awards drivers grant money for biannual inspections of all green, wheelchair-accessible vehicles in New York City.• Collected and managed $7MM in improvement surcharge taxes quarterly by generating invoices utilizing R, Tableau, and Microsoft SQL.• Contributed to the successful completion of forecasting of program costs based on estimated driver membership growth, utilizing SQL• Managed program weekly reports and key performance indicators with frequent utilization of Microsoft Excel (macros, VLOOKUPS, etc.), Access, and Word, SQL, Tableau and RStudio• Participated in the new rules-enhancement process and development for the Taxi Improvement Fund owner program requirements by utilizing Microsoft SQL for operational and hack-up payments.• Managed the program’s key performance indicator reports on a weekly basis utilizing SQL and Tableau.• Analyzed and reconciled the account receivables database and collaborated with senior staff to efficiently organize and present the data. Proposed solutions and SQL queries to reconcile the financial database, reconciled all financial statements with the database, and prepared a monitoring query for any mismatches.• Cleaned up 100K+ financial reports database records and automated the process for monitoring errors over time to ensure data accuracy and reliability. Show less

  • Senior Data Analyst

    Dec 2019 - Jun 2021

  • Data Analyst

    Apr 2016 - Jun 2021
• 

  Pwc

  Jun 2021 - Jul 2021

  Ifs intern

  • Coordinated and planned project timelines, project requirements, data analysis, and data visualization requirements for intern cohort.• Participated in technical development exercises focused on knowledge management, research, and conducting audits, earning recognition in human design thinking and business digital acumen.• Created custom data sets leveraging Alteryx and Tableau to forecast donor retention rates for Skill for Society project.

• 

  Deloitte

  Jan 2022 - Mar 2022

  Audit & assurance analytics intern

  • Performed an analytical audit for client journal entries and formatted all the client's data for import into the Deloitte system.• Coordinated the tie-out process with contractor accountants, provided guidance, and reviewed their work as part of approval process.• Created dashboards to monitor major clients’ account changes over time, to help audit team better define their sample testing at the end of the year.

• 

  Pwc

  Jun 2022 - Jul 2022

  Digital assurance & transparency tech & data intern

  • Analyzed complex problems to understand root causes and proposed viable solutions in Alteryx workflows and utilized data cleaning methodology to improve client data governance.•Created internal workflows in Alteryx for management team to track utilization for employers and created a forecasted dashboard for employees’ utilization rate for one year.• Performed SQL code reviews and Alteryx workflow reviews for global clients, documenting their process to provide the core audit team a better understanding of client data pulls and data manipulation. Show less

• 

  Pwc

  Jul 2023 - now

  Tech & data associate

  • Developed and implemented multiple Alteryx workflow automations for various clients, resulting in significant time savings by eliminating manual work and enabling more frequent testing.• Conducted a comprehensive analysis of clients accounts payable, payroll, and ITGC processes, utilizing Visio to create flowcharts and identify gaps.• Prepared GAP analyses and provided recommendations to clients on process improvements and segregation of duties, resulting in enhanced efficiency and resource savings.• Played a key role in multiple end-of-year deliverables, responsible for testing client processes and reports, as well as preparing EGAs.• Assisted the offshore team in converting SQL scripts to Databricks scripts for multiple client engagements.• Developed budgets and strategic plans for products and services clients, coordinating with the core audit team to scope future work and address backlog automations.• Tested the IIQ Sailpoint platform, established user access approval and recertification processes and created business requirements.• Created agendas for ESG client walkthroughs, analyzed client sustainability reports and supporting documentation, documented client processes, identified gaps and enhancements, and wrote recommendations for the final deliverable deck.• Managed end-of-year testing, including data acquisition, processing, SQL script updates, and preparing the deliverables after the core team updated their scope.• Selected for PwC's general AI super user group to test ChatPWC and participated in the ChatGPT Enterprise Pilot Program, providing feedback and recommendations. Show less