Reshma Vadhavkar

571-***-**** ad2bcs@r.postjobfree.com

SENIOR IT FINANCIAL ANALYST

SUMMARY

Over 10 years of experience in IT, with 7+ years of experience as a Finance Data Analyst, Financial Modeling, and working to transform raw data into actionable strategic knowledge to gain insight into business processes, and thereby guide strategic and tactical decision-making for optimization of business processes.

Proficiency and application of data warehousing, data analysis, regression analysis, and strategic business analysis (SWOT) knowledge and compilation of trend and variance reports for management decision.

Reduced 20% of the cost by leading the implementation of a web-based expense module for all C-Suite and department heads for a mid-size IT solution organization. Login authentication & management for the module

Saved 10% of the cost by conducting organizational profitability analysis, synthesizing large-scale datasets, cash flow, trend/variance monitoring, and control.

Successfully performed MIS, IT Service project analysis and reporting to COO and CEO of a mid-size organization; Assisted in data analysis, budgeting and forecasting activities at the organizational level using trend, variance, anomaly detection, and allocation of overheads to the business units

Experience in Worked extensively with Tableau, MySQL, R-Programming, PowerPoint, Excel-Macros & VLOOKUP, H-Lookup and Pivot tables.

Core competencies include analytical skills, problem-solving, and attention to details.

TECHNICAL SKILLS

Subject Areas

Technical Skills

Tools & Software

Data Analysis & Visualization Reporting

R-Programming, R-Studio-ggplot2, Teammate Analytics, Data Mining & Warehousing, Management Info.System

Tableau, PowerPoint, Excel-Macros & VLOOKUP, Pivot tables

Financial & Data Modelling

SAP-FICO, QuickBooks Desktop / Online (QBO), Tally ERP, Relational Database management, GAAP, SEC

MS-Office, MS Excel & If function, Functions, Lookups, Power BI/Pivot, Power Query

Data Analytics, Data Science, Statistics

Python, Service Now, ACL, SQL, MySQL-Workbench, Predictive analysis

Pandas’ library, Excel-data analysis tools-Goal seek, solver, SQL Query

Project Management, Business Analysis

SSRS, Agile, Scrum, Waterfall, Kanban, PMLC, SDLC, Requirement Traceability Matrix, Six Sigma, Risk Management, Change Management

MS Project, Project-Libre (Beta), Gantt Charts, JIRA, SharePoint, ER diagram, MS Visio, Axure, Figma

Systems & Security

Risk Management, Linux, Assessment, Mitigation, NIST, FISMA, HIPAA, PCS-DSS compliance, Firewall monitoring, IDS, MBSA, GFI, VPN, Putty, Access Control (Remote Access & Encryption-File System/BitLocker)

Simple Risk, Azure-Active Directory, Power shell, Nmap, GNS3, PfSense, Snort, Wireshark, Kali Linux, Snort, OpenVAS (Green bone), Nessus, Malware removal, Group Policy (GPO), System Audit, Backups, Hardening Security-Windows Defender

EDUCATION

MS in Information Security & System, University of the Cumberlands, Williamsburg, KY, 2023 (Dec)

MS in Information Technology, University of the Cumberlands, Williamsburg, KY, 2022

MBA in with a focus in International Finance, Virginia International University - Fairfax, VA,2018

Certification in Taxation, L.N Welingkar Management Development & Research - Mumbai, India

Certification in Financial Management, L.N Welingkar Management Development & Research - India

Bachelor of Commerce, Bombay University - Mumbai, India

Graduate Certificate Project Management - May 2020

IBM-Building Cloud-based Mobile Solutions for the Enterprise - December 2022

WORK EXPERIENCE

IT Consultancy, Chantilly, VA Nov 2020 –Current

Sr. Financial Data Analyst

Work as a Technical & Financial Data analyst and help to perform sourcing of data to various locations and databases to improve business processes of timesheet management, payroll, receivables, and payables.

Decide operational goals by studying business functions, gathering information, and evaluating output requirements and formats.

Study system capabilities and write specifications. Construct workflow charts and diagrams using Visio.

Work with UI/UX team to review the wireframes as per the business requirements and during the development phase for HR & Payroll Module.

Used tools such as MS-Excel functions, Visual Charts, and Pivot tables for Data Analysis for Bank of America bank database.

Improved current accounting systems by studying current practices and designing modifications using QBO.

Define project technical requirements, scheduling, resource allocation & identify project milestones, phases, and elements for timesheet management module.

Contribute to team effort by conducting related results as needed for payroll and billing data analysis.

Monitoring Age-wise Receivables and Collection reports for monitoring and controlling collectables and ensuring robust cash flow management.

Conduct and coordinate financial, product, market, operational and related research to support strategic and business planning to scale up operational growth.

Translate Functional, Technical, Conversion and Performance requirement specifications for business process improvement.

Worked extensively with Tableau, PowerPoint, MySQL, R-Programming, Excel-Macros & VLOOKUP, H-Lookup and Pivot tables.

Use SQL Query to retrieve, analyze and escalate reporting of anomalies, based on number of databases.

Mission Square Retirement (formerly ICMA – RC), Washington, DC Jun 2019 – Dec 2019

Internal Auditor -IT

Verified and assessed SOC1 Type II key-controls in association with KPMG and E&Y.

Facilitated GCC & Fair valuation audit project, incidence-audit & evidence testing using Service-Now and documentation and flowchart using Visio.

Work as a Data Engineer and help to perform sourcing of data and work towards building reports using MS Excel – Pivot & documentation of findings using Teammate Analytics that are ad hoc as well as monthly/daily/periodical scheduled.

Perform data cleansing, transformation, mapping, and sourcing to other downstream applications as well.

Assisted in strategic decisions with management, operational projects, and special projects.

Documented walkthroughs of the processes in automated work paper tool CCH Teammate after control owners’ interviews ensuring the internal controls were in place.

Worked in Participants transaction project (Customer Service) for nine million Data/Rows for retirement investments in association with Ernst & Young (Internal/process groups - SPT, SPST, DSU, RSU, MSU)

Excelled in walkthroughs of the processes and documentation in CCH Teammate

COMMERCIAL LYNKS, Inc., Alexandria, VA Aug 2018 - May 2019

Staff Accountant

Responsibilities

Saved the company $100K on commission on sales 2017 and 2018 with data analysis skills.

Decreased number of person-hours by 70%; led the implementation of ‘borrowing base certificate’ submission process (monthly compliance with the working capital lending bank - M&T Bank).

Assisted Bank Audit (M & T Bank), Financial Audit (Schedules), and worked with CPA for financial modeling.

Monitoring M & T Bank accounts for controlling Customer and Suppliers transactions for consistent and regular cash flow for smooth functioning of working capital.

Worked with operations for getting accurate information for general ledger reconciliation and rectifications.

Provide insights about the weekly and monthly updates to the leadership team and gather functional and non-functional requirements and enhance the process.

Assisted in the revenue recognition working and accounted for deferred transactions periodically as per GAAP.

Experience working with Technology, Operations, Legal and Business partners to successfully deliver requirements and translate business logic into functional requirements.

NAISA Global, Washington, DC Feb 2018 - May 2018

Program Associate

Responsibilities

Saved 80% person-hour efforts on automation of accounting system project; automation, migration of data for US non-profit organization to comply for tax filing liability.

Lead efforts and contribute to success of organization by forming and maintaining customer database in accurate and professional demeanor. Save company’s time by automating functions and gathering data/information based on real-time. Prepare accurate and error-free inter-departmental communication and monthly reports by evaluating duplicate and incorrect data.

Created many dashboards and scrutinized reporting requirements to obtain visual representation of company's key performance indicators (KPIs).

Extracted, manipulated, and calculated information to meet data and reporting needs, in compliance with IRS rules 2017 and filing Tax form 990.

Acquired valuable insights into data mapping and transformation from sources to target data models.

Internal Revenue Service (Government), Arlington, VA Feb 2018 - May 2018

Basis Tax Preparer

Responsibilities

Individual Tax Filing for Seventeen taxpayers through proprietary software, TaxSlayer.

PCS Technology Ltd. (Patani Group) - Mumbai, India Apr 2004 - Mar 2011

Manager – Accounts & Finance (India, Dubai, Denmark, and US Projects)

Responsibilities

Excelled in preparation of Accounts, reconciliation of GL/Schedules cost center wise, Service-Tax & Periodical billing/revenue reports, and other operating reports and submission to management.

Coordinating with Financial Institution for operational and capital loans, credit rating (ICRA) and LC/BG & Buyers Credit, Foreign Exchange.

Formulated regular budgets (Production & Sales) and conducted variance analysis to determine difference between projected & actual expenditure and implemented corrective actions.

Review & Consolidation of annual accounts of the corporation and its all-subsidiary companies and collaborated with statutory auditors, International Audit consultants, CAG auditors, and cost auditors.

Inventory /Store materials accounting/valuation for input /process output/WIP/Finished Goods. Insurance Claims accounting for transit insurance (Damaged /Lost/ Fire).

Spearheaded Web Expenses Module project by structuring, creating authentication management and implementing module for C-Suite (CFO, CEO) and cross-functional department heads with large data sets; reduced operational cost by 20% and improved controls over payment to Vendors & from Suppliers.

Increased product line performance by 10% with segmental profitability analysis and led cross-functional team for planning and reporting for restructuring of the organization.

Developed and implemented Management Information System (MIS) for periodical organizational profitability, trend, and variance analysis; Complex data compilation with excel dashboards reports building and directed various teams for prompt, accurate reports.

Contributed towards SAP implementation project-FICO training, cost & inventory management, data Put into place an accounting system and administration of logical access; successfully led the project for working capital and e-banking with Commercial Bank of Dubai

Scheduled, coordinated, and monitored financial modeling for quarterly and yearly annual reports in Tally-ERP and ensured statutory compliances with labor and JAFZA laws.

Analysis and reporting of periodical cash flow, interest monitoring and resources management for decisions on operational excellence, business process improvements and optimization of working capital.

REFERENCE: Available upon Request

Contact this candidate