SUMMARY:

• A seasoned professional with extensive experience developing complex Business Intelligence applications supporting multiple business functions including Finance
• Sales and Marketing and Supply Chain in multiple industries including Pharmaceuticals, Consumer Products and Financial Services

TECHNICAL SKILLS:

Software: Oracle Essbase multidimensional database, Oracle EPM tools, OBIEE, BI Publisher, MS - Office

Languages: Visual Basic, VBA, VB.NET, C#, VB Scripts, PowerBuilder, SQL/PL-SQL, XML.

Relational DBMS: Oracle, Sybase, MS SQL Server, UDB and MS Access.

Operating Systems: Windows, UNIX, LINIX.

PROFESSIONAL EXPERIENCE:

Confidential, Ram Ridge, NY

Senior BI Developer, Business Intelligence Systems

Responsibilities:

• Partnered with internal stakeholders to better understand their data and reporting needs and present them with multiple options and guide them to analytic solutions that best meet their needs.
• Lead Developer of data modeling, and enterprise data warehouse implementations, data integration/ETL of large and complex data sets. Data staging and integrating multiple legacy and strategic source systems using Oracle PL - SQL.
• Lead Developer of OBIEE Models and Dashboards for Inventory Management and Supply Chain organizations which are used to track Inventory On-Hand, Backorder and Inventory Turns
• Lead Developer of OBIEE Dashboard for R&D Analytics which is used to track over $200 M of annual R&D spend
• Lead Developer of an OBIEE model which is used to track suspicious orders of controlled substances by end customers. Application has helped identify end customers who were potentially improperly distributing Opioids.
• Developed Suites of Reports and Dashboards for multiple areas of the Organization using Hyperion Financial Reports, OBIEE and Oracle BI Publisher for multiple functional areas
• Develop, update and maintain the conceptual, logical and physical data models capable of supporting existing and future reporting needs.
• Lead Developer of Proforma Essbase application which enabled company to do Proforma analytics and is used to rationalize product portfolio by doing product profitability analysis.
• Lead Developer for Inventory Management Essbase application which performed LCM and Excess Calculations and reduced the Supply Chain Finance workload during the monthly close by 2 man days
• Lead Developer for Sales Reporting Application for new acquired Sterile Business which in the first 3 years grew at over 25% annually
• Worked on annual optimization of Essbase applications reducing calculation times and improving overall reliability.
• Lead developer on the development of forecasting application integrating data multiple internal and external sources which would develop both Financial and Manufacturing Forecast.
• Integrated data from Revenue Management System (Model N) in the multiple OBIEE models and Essbase applications
• Design and implement MS Excel templates using VBA and Essbase API for data entries. Creation of different reports using MS Excel for data verification and representation of data to upper Management.
• Utilized Partitioning to move data across applications.
• Continually work to improve overall processing of data to ensure users have data in an extremely timely manner

Confidential, New York, NY

Senior Programmer-Analyst

Responsibilities:

• Design, develop and maintain Hyperion Essbase cubes. Creating Hyperion EIS models and metadata outlines. Created data load rules and calculation scripts. Optimize Essbase cubes and solve performance issues.
• Automation of Hyperion Essbase applications update process using MaxL, ESSCMD, C shell scripts, and AutoSys.
• Essbase cubes migration from version 7.2 to version 9.2. Migration of data sources for entire cubes.
• Supporting and maintenance security of entire system, creation and support of filters, groups, and users for approximately 1500 end users

Confidential, Greenwich, CT

EPM Solutions Analyst

Responsibilities:

• Interfacing with end users for initial system requirements and documentation for the newly designed Essbase Application. Created Project plans, and development of testing strategy. Created Reporting structure and capabilities interface with other Essbase and SAP applications.
• Design, develop and maintain Hyperion Essbase cubes. Created data load rules and calculation scripts. Optimize Essbase cubes and solved performance issues as well as data verification. Created ad-hoc reports and data querying templates.
• Design and implement MS Excel templates using VBA and Essbase API for data entries. Creation of different reports using MS Excel for data verification and representation of data to upper Management.
• Automation of update process of Hyperion Essbase applications using ESSCMD command and MaxL.
• Design and develop custom Visual Basic application used for supporting automation process of various systems, updating Essbase outlines, supporting MS SQL server databases.
• Uploading/processing data of the Supply Chain data to SAP for completion of Planning and Forecasting processes using MS SQL Server.
• Installation and configuration Hyperion System 9 software.
• End-users . 24 hours System support. Also responsible for System testing, support and maintenance.

Confidential, New York, NY

Senior Programmer-Analyst

Responsibilities:

• Supporting of General Ledger Accounting systems which is designed to use OLAP technology and give accessibility to critical financial data on a timely basis. Application was used by Controllers for US and international business units. Played a key role in the design, system development, end user support and maintenance.
• Modifying existing Hyperion Essbase applications and databases including outlines, data load rules, and calculation scripts using Essbase Application Manager. Automation of Essbase updating process using ESSCMD commands. Changes resulted in significant improvement in reliability of applications

Confidential, New York, NY

Senior Programmer-Analyst

Responsibilities:

• Systems analysis, support and maintenance of General Ledger Accounting and Clearance accounting systems. The applications provide access to critical Financial Data to Controllers and Senior Management for US and International operations. Design and developed new and modified existing Essbase applications and databases including outlines, data load rules, and calculation scripts using Essbase Application Manager.
• Interface with end users and vendors for problem resolution, system enhancements and integration of Essbase reporting structures and capabilities with general ledger applications. Responsible for financial reporting and analysis of division operating results presented in monthly, quarterly and annual reports to Executive Management and Board of Directors.
• 24 hours production support for Essbase applications. Development, maintenance, and modification custom applications: Specialist P&L, Fully Disclosed P&L, Specialist Adjustment, Investment Banking and Tax department applications written using Essbase API functions and Client/Server technology on PowerBuilder, VB, Crystal Reports and Excel VBA on the front-end and Essbase and Sybase on back-end. Participation in migration of Specialist P&L application to WEB technology using ASP. Excel template design and implementation. Developed System documentation and flow charts using Visio and HTML.