TECHNICAL SKILLS:

SKILL SET: Advanced Excel, Sql, VBA, report automation, GUI, power BI, access, SSRS, SSAS, Oracle Hyperion Essbase, SDLC

Other skills/knowledge: SAS, statistics/data analyses, Python, HTML, Javascript, Wordpress/Php/MySql

WORK EXPERIENCE:

Confidential

Responsibilities:

• Using advanced Excel, VBA, Power BI, Access and Sharepoint, prepares several Excel tracking templates for migrating computer and user profiles to new computer environment for thousands of machines in over 40 countries
• Wrote Excel VBA - driven mechanisms/tools to collect and maintain/update machine/user information, migration progress
• Wrote Excel VBA to automate sending of daily emails: includes a complex process of selecting sets of recipients, make adjustments according to World time Zones, open Outlook, determine appropriate Outlook template to use, modify template contents and actual release of the email
• Build status visualizations for operational and executive levels

Confidential, East Rutherford, NJ

Excel VBA Programmer/Analyst

Responsibilities:

• customizes a VB-based bill of materials software conducts user meetings to enhance methods and processes analyzes window models, their infinite combinations for high-rise buildings drafts new/enhanced report templates designs and writes customization code creates GUI for friendly, accurate and efficient automation authors user guides and operation manuals

Confidential, Englewood Cliffs, NJ

Excel VBA Programmer/Analyst

Responsibilities:

• Reduced over 30 Hyperion Essbase/Excel VBA applications into one parameter-driven master application to automatically produce over 130 daily reports daily; by identifying commonalities and patterns that enabled me to construct sets of parameters thereby reducing code and template maintenance work thereby improving efficiency and accuracy.
• Designer/developer for the automation of daily and weekly sales report production using Excel VBA with embedded SQL strings for pulling data
• Conceptualized and developed Quality Assurance Excel/VBA-based procedures that: automatically check report errors that forces diagnostic aborting; automatically check failures to save reports and automatically send failure emails to operators & programmers that include links to the failed locations for easy resolution.
• Conceptualized, developed and installed “drivers” - that controlled sets of parameters fed to common sets of report templates to standardize reporting by dimension and measures
• Refreshed regular Nielsen reports
• Supervised and supported eight (8) people running daily and other periodic reports

Confidential, New York City, NY

Excel Programmer/Developer

Responsibilities:

• Designed, coded, and implemented a GUI-driven Excel/VBA based healthcare enrollment application for an advertising/marketing firm.

Confidential, Maywood, NJ

Excel VBA Programmer/Developer

Responsibilities:

• Using Access VBA with PeopleSoft data, redesigned/rewrote receivables reconciliation application for a large bank
• Collected requirements for a hospital patient tracking system, starting from patient registration, patient movements; procedures conducted, treatments administered, court appearances and discharge, including statistical and census reports.
• Designed and developed a system using MS Access/Excel pulling data from SQL Server, complete with user interface and forms; tables, fields, relationships, using VBA and SQL for maintenance and the generation of reports.

Confidential, Clifton, NJ

Business Analyst/Excel VBA Programmer

Responsibilities:

• Designed and developed business reports for senior management and other levels
• Developed an Excel VBA-based software for project time-lines and product pricing
• Tracked product and customer performance using OLAP, advanced Excel & VBA
• Developed dashboards for margins, sales, forecasts and inventory
• Coordinated with the finance department in reconciling financial reports.
• Developed a VBA-based software that generated Item Fact Sheets from Excel line lists
• Developed and maintained an Access database for product pricing
• Coordinated with (7) product managers for product pricing and new product launches.

Confidential, Rutherford, NJ

Business Analyst/Excel VBA Programmer

Responsibilities:

• Wrote VBA in Excel to extract material and other information from the Access database to prepare tables of materials with dimensional adjustments for precise cutting instructions, including timber and brake metal reinforces and spacers plus screws and other connectors
• Standardized forms and created Excel templates for listing materials, dimensions and building information from architectural and engineering drawings
• Developed an Access database of window types and curtain walls; aluminum frame materials, glazing, timber and metal accessories and connectors including standardized cutting adjustments for precise assembly and installation.
• Created a user interface with ActiveX controls for convenient navigation and execution of code modules.

Confidential, Los Banos, Laguna, Philippines

Research Associate

Responsibilities:

• Involved in developing an application to resolve a multi-stage operations research (OR) problem using SAS and Visual Basic.