ENTERPRISE

Financial Industry

Excel C#.NET, VSTO, AddIn Project for price reporting:
Designed and developed an Excel VSTO AddIn in C# using Soft Artisan Framework. Integrate excel frontend with Microsoft C#.NET backend services using XML/REST. Customize the Excel Ribbon components for all versions of the Microsoft office platform. WPF using XAML; VBA required for templates; Microsoft JSOM; Integrate frontend with backend Java/J2EE components; Implement Agile methodologies and practices

Excel, VBA, Web Services Project for forecasting purposes:
Developed & implemented an Excel AddIn to import 3 years of actual data, via web services, from an Oracle OLAP database for selected entities. Analysts forecast for 5 years using formulas embedded in the templates we created. Calculated forecasts are written back to database through web services. AddIn functionality allows users to login, logout, retrieve missing mnemonics, upload forecasted data. Template contains formulas to supply forecast calculations and data import fuctionality. Agile scrums and Version One software to monitor stories and tasks.

Insurance Industry

Created custom database and tables to track broker commissions and report it monthly.

Fashion Industry

Converted complex financial Excel reports from Essbase source cubes to pull from SAP datasets. Aggregate ad-hoc WEBI queries of metric data from SAP into Excel. Consolidated numerous reports previously in separate workbooks into one logically regrouped report Revised large consolidated reports that connect to and import from MS Access data sources Created macros to update critical weekly reports and automate processes where needed.Revised large consolidated report that connected and imported a MS Access table as data source

Implement restructure of data on 5 historical Essbase cubes for migration to SAP. Parallel environment, replicating PROD environment on the DEV server. Tested all scripts in standalone mode to ensure no reference to PROD is retained. Upgrade all VBA scripts to process with restructured SAP data. Wrote scripts to automate the transformation of current data to the new format. Data restructuring performed on the DEV environment and jobs monitored for kick-outs. Loaded cubes with restructured data. All activities tested and validated against PROD. Excel reports (via data retrievals from the cubes) modified to take into account the restructured data. Tools: Essbase Application Manager, Excel Essbase Add-In, Toad for Oracle, Korn Shell Scripting

GOVERNMENT

New York City

FMS Vendor ID: 000-2444-124
New York City certified Minority Woman Business Enteprise - MWBE

Previously awarded RFP by New York City WasteMatch:
Custom online Excel calculator to measure the environmental impact in recycling various raw materials.

New York State

New York State Minority Woman Business Enteprise MWBE Re-Certification status: Pending

Previously selected for discretionary purchase by New York State Financial Control Board
Excel and Word template customizations.

Federal Government

DUNS Number: 14-868-1658
Commercial And Government Entity Number: 55D02
Woman-Owned Small Business WOSB classification