Responsible for providing decision support through data analysis, reporting and optimization for fleet planning and strategy using Excel, Tableau, SAS, Teradata, Oracle .

• Responsible for converting business requirements into analytical specifications, performing analysis, translating results into actionable recommendations and presenting findings to business clients such as Revenue Management, Senior Leadership Team and Marketing.• Designed effective and timely reporting, dashboards and enterprise reports using SAS macros, SAS-ODS (Output Delivery System) reporting techniques and MS Excel Pivot tables for revenue management and other internal clients.• Provided dashboard reporting and executive summary for weekly multi-departmental performance meeting; designed monthly business review deck for key performance indicators(KPI) utilized by senior leadership to understand target vs performance for revenue, supply and demand and to identify weak areas of business.• Worked on data governance effort by standardizing data matrices and designing data structures; developed BI tools using SAS OLAP cubes; automated various existing Excel reports using SAS tagsets to reduce production time.• Assisted in new pricing tool launch by creating interactive reports and tools providing business insights, performance and feedback of the new system to the pricing team. Utilized SAS tagsets, user defined tagsets and conditional formatting to produce more efficient excel like data reporting; Converted SAS output reports into HTML files and published them on SAS WEB DAV Server for centralized viewing• Assisted Commercial Sourcing team in revamping inventory collection procedure by designing and developing Payback Recommendation Tool using SAS stored procedures.• Supported marketing to improve cross-selling by determining member search patterns and recommending supply availability.

• Provided analytical and software tool development support as needed for virtual peak capacity (VPC) programs, marketing and business development.• Analysis& Reporting: Standardized and documented data analysis procedures; Performed data analysis on temperature, electricity load and communications data; Determined correlations between data using statistical methods such as regression analysis and design of experiments; Prepared client reports and presentations; Recommended solutions to increase savings and revenue. • Tool Development: Designed data mining system using SAS, Access, VB and SQL Server; Designed and developed statistical analysis, demand forecasting and simulation tools to analyze demand response data using Base SAS and SAS Macro; Designed and developed reporting and querying tools for various utility clients for VPC management and pricing using Excel and SAS Graph.