I am a seasoned Senior Data Analyst and BI Developer with extensive experience in data analytics, business intelligence, and financial reporting across financial services, insurance, energy, and technology-driven organizations. I have delivered ETL solutions, SQL-based analytics, SSIS/SSRS reporting, and executive dashboards for companies including Bank of America, AIG SunAmerica, and Masterplan, consistently supporting high-impact initiatives under tight deadlines. For the past 10 years, I have taken a purposeful career pause as a stay-at-home mom, where I strengthened my organizational, time management, and problem-solving skills while raising my children. With a strong foundation in financial analysis, forecasting, and variance reporting, an engineering background, and a strong willingness to learn and quickly pick up new tools and technologies, I bring a disciplined, adaptable, and detail-oriented approach to bridging data systems with business decision-making.

Ayesha Bholat

I am a seasoned Senior Data Analyst and BI Developer with extensive experience in data analytics, business intelligence, and financial reporting across financial services, insurance, energy, and technology-driven organizations. I have delivered ETL solutions, SQL-based analytics, SSIS/SSRS reporting, and executive dashboards for companies including Bank of America, AIG SunAmerica, and Masterplan, consistently supporting high-impact initiatives under tight deadlines. For the past 10 years, I have taken a purposeful career pause as a stay-at-home mom, where I strengthened my organizational, time management, and problem-solving skills while raising my children. With a strong foundation in financial analysis, forecasting, and variance reporting, an engineering background, and a strong willingness to learn and quickly pick up new tools and technologies, I bring a disciplined, adaptable, and detail-oriented approach to bridging data systems with business decision-making.

Available to hire

I am a seasoned Senior Data Analyst and BI Developer with extensive experience in data analytics, business intelligence, and financial reporting across financial services, insurance, energy, and technology-driven organizations. I have delivered ETL solutions, SQL-based analytics, SSIS/SSRS reporting, and executive dashboards for companies including Bank of America, AIG SunAmerica, and Masterplan, consistently supporting high-impact initiatives under tight deadlines. For the past 10 years, I have taken a purposeful career pause as a stay-at-home mom, where I strengthened my organizational, time management, and problem-solving skills while raising my children. With a strong foundation in financial analysis, forecasting, and variance reporting, an engineering background, and a strong willingness to learn and quickly pick up new tools and technologies, I bring a disciplined, adaptable, and detail-oriented approach to bridging data systems with business decision-making.

See more

Experience Level

Expert
Expert
Intermediate
Intermediate
Beginner

Language

English
Fluent

Work Experience

Sr Data Analyst / BI Developer (Contract – SMCI) at Bank of America HL&I
September 1, 2013 - June 1, 2014
Developed SSIS packages, stored procedures, views, table-value functions and scalar functions for new loan modifications process implementation. Automated ETL from SharePoint and processed daily uploads to Access DB. Maintained and administered production SharePoint site for the loan mods. Developed and maintained management reports in Excel; customized pivot reports for teams. Performed ad hoc SQL queries, developed stored procedures, and created Excel reports under tight deadlines for team leads and management.
Data Consultant / BI Developer (Contract – SMCI) at Bank of America HL&I
June 1, 2011 - June 1, 2013
Developed SSIS packages, stored procedures, views, table-value functions and scalar functions for delayed conversion modifications. Developed SSIS and SSRS reports for DataMart perm and trial mod mailings. Built SSIS packages to ETL data from AS400, and configured server jobs to run under service accounts. Built and maintained Data Dictionary for loan modification mailing database. Updated and Administered SharePoint lists as needed for delayed conversion requests. Maintained management reporting in Excel and created PowerPoint presentations for team project status updates.
Senior Analyst at Masterplan, Inc.
June 1, 2008 - June 1, 2011
Designed and implemented new processes for submitting Change Notification Forms (CNFs). Established metrics for tracking adds, deletes, and changes for revenue-based equipment in the field. Provided financial impact reports to senior management and created and maintained weekly dashboard reports. Performed ad hoc SQL queries, developed stored procedures, and analyzed data for management under tight deadlines.
Cost Analyst/ Financial Analyst at AIG, SunAmerica
March 1, 2007 - May 1, 2008
Submitted yearly budget in SAP and maintained monthly variance reports. Coordinated budget meetings with senior management and presented cost savings. Updated and reported monthly variance, tracked and monitored monthly accruals and submitted journal entry adjustments to accounting group. Maintained and updated infrastructure rate card model that impacted various AIG divisions. Responsible for developing and updating forecast model for offshore production, and presented cost analysis to executive team. Prepared monthly billing and cost analysis to management.
Financial Analyst at EDO Corp, CCS
March 1, 2005 - December 1, 2006
Responsibilities included calculating the Cumulative Estimate At Complete (CEAC) and presenting results to customer (Boeing). Maintained program schedule in MS Project and reported percent completes to the finance department for earned value calculation and departmental metrics. Assisted Project Engineers in calculating quarterly Estimates to Complete (ETC) and coordinated with Program Management in producing updated Estimates at Complete (EAC). Updated headcount/personnel model and analyzed areas of staffing needs, reported to management. Created a departmental database in MS Access for tracking documents and drawing releases.
Financial Analyst at Tara Energy
March 1, 2004 - November 1, 2004
Built and maintained corporate financial models and updated/tracked accounts on a monthly basis. Researched energy market and educated customers with a monthly energy updates newsletter in crude oil, gasoline, natural gas, and electricity sectors. Drafted energy proposals for various associations and companies, including the Department of Defense, Department of Homeland Security, Dresser Inc, and Kroger Co. Created financial forecasting models based on proposals and presented to management.

Education

Bachelor of Engineering - BE, Electrical and Electronics Engineering at Vanderbilt University
January 11, 2030 - January 21, 2026

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Professional Services, Software & Internet