Summary

• Versatile developer with 14 years solid development experience.
• Expertise in the development of Business Intelligence, data warehousing, and ETL applications using tools such as Hyperion Interactive Studio Reporting, Hyperion Production Reporting (SQR), Hyperion Workspace Administration, Web Analysis, and XML.
• Extensive experience of developing applications that interface Oracle, DB2, and MS SQL Server RDBMS. As well as ERP applications such as Oracle EBS 11.5 and Peoplesoft.
• Involved in many aspects of the SDLC and having formal methodologies such as Multi Dimensional Design (Kimball) and Summit-D.
• Extensive experience in the Financial Services, Insurance, and Pharmaceutical Sectors, with leading clients such as Brown Brothers Harriman & Co. (Bank), Plymouth Rock Assurance, Roche, and Procter & Gamble.

Professional Experience

Confidential,King of Prussia, PA Dec 2009 – Present

Hyperion Consultant

Role outline: Consultant to IKON Corporation transition to Hyperion IR Fusion v11.1.1.3 suite of tools.

Technology Environment: Oracle 10g, Hyperion Interactive Studio v11.1.1.3, Hyperion Dashboard Studio 11.1, Hyperion Workspace 11.1, SQL, and PL/SQL.

Responsibilities

Provided user training on Hyperion IR Fusion v11.1.

Analyzed existing Excel spreadsheet reports as to identify dimensions required in initial iteration of data mart.

Worked with DBA to design Star Schema based Data marts that will be used to perform analysis on Sales Promotion and Commissions.

Created dashboard driven reports to enable user to analyze Sales Promotion and Commissions data.

Created Hyperion Master Data Model documents for Business Analysts and Power Users.

Setup reporting Metadata repository.

Confidential,, Braintree, MA Mar 2009 – Dec 2009

Sr. Hyperion Developer

Role outline: Senior Developer for interactive reporting development in Haemonetics’ transition to Oracle E-Business Suite 11.5 from BPIX legacy system.

Technology Environment: Oracle 10g, Transact SQL, Oracle EBS 11.5.2, Hyperion Interactive Reporting 9.3.1, Hyperion Dashboard Studio 9.3.1, Hyperion Essbase 9.3.1, SQL, PL/SQL, SQR, Hyperion Workspace 9.3.1, and Agile..

Responsibilities

Gathered reporting requirements from Haemonetics’ Oracle EBS user community and Subject Matter Experts.

Worked with Business Analysts to create requirement documentation and development specifications.

Developed reporting and dashboard templates for development team.

Created and maintained interactive reports that reported on the Financial, Manufacturing, Costing modules within Oracle EBS.

Developed and maintained common/global functions to be used in all Interactive Reporting Documents.

Created Materialized Views to improve execution of reports delivering KPI data.

Administered Development Hyperion Workspace – including creating OCEs, creating new user accounts and user groups, maintaining user/group access privileges, and uploading new reports for testing.

Confidential,Boston, MA Jul 2008 – Jan 2009 Sr. Hyperion Developer

Role outline: Software Developer working in BBH’s Private Account Services, which is responsible for the development and support of the data warehousing and reporting infrastructure for BBH’s European clients.
Technology Environment: Oracle 10g, Hyperion Interactive Reporting, SQR, Hyperion Portal, SQL, PL/SQL, XML, Converg-e Real-time Asset Management and Custody System, and Serena Version Management.

Responsibilities

• Involved in the design, development, and support of the PAS Management Report nightly batch cycle which consisted of 200 parameterized reports which are executed daily through the Hyperion Portal and Windows batch scripts.
• Developed reconciliation scripts to pin point inaccuracies in custodian and client account roll ups.
• Developed Dashboard driven reports to aid tax reporting.
• Developed XSL transformation scripts to convert from XML format to PDF format using XML-FO.
• Developed various audit, operation, and tax reporting scripts.
• Responsible for researching and finding solutions to slow running data load processes.
• Administered the test and production Hyperion Portals including user account maintenance, file uploads, and job scheduling.

Confidential,Boston, MA Jan 2008 – Jul 2008
Sr. Technology Strategist

Role outline: Developed reports and dashboards in preparation for the introduction of the Massachusetts Automobile Insurance Program (MAIP) which is being introduced in April 2008.
Technology Environment: DB2, MS SQL Server, Hyperion Intelligence Client 8.5/9.0, SQR, Hyperion Essbase, JOOLE, and Fiserv 3.10.

Responsibilities

• Developed and modified Interactive Hyperion Dashboard driven reports that enabled users to analyze new MAIP business.
• Developed SQR, SQL scripts and Stored Procedures to extract new and updated policy and claims data from ODS and Enterprise Reporting Marts, then formatted output in AL3 (Insurance Standard) format to enable easy data interchange between the business and its agents.
• Converted some existing Hyperion Client reports to Essbase Analytics to show some of the features of the products – PRAC is intending to move to Essbase by the end of 2008.
• Conducted Hyperion Intelligence 8.5 Clients training sessions and presentations for users and management.

Role outline: Software Developer working in the Private Account Services and Custody Banking, which is responsible for the development and maintenance of the data warehousing and reporting infrastructure for BBH’s European clients.
Technology Environment: Oracle 9i/10g, SQL, PL/SQL, Hyperion Portal 8.5, Brio 8, Hyperion Intelligence 8.3/8.5, Brio Intelligence 6.6, XML, Java 1.5, PVCS/Serena Version Management, Windows XP, and Converg-e Real-time Asset Management and Custody System.

Responsibilities

• Involved in the design and development of the PAS Management Reporting System; the system consisted of more than 150 production and adhoc SQR scripts and BQY documents.
• Developed various scripts to extract data from the on-line transactional system and import the resulting data into the reporting database.
• Developed adhoc scripts to generate data files in CSV, XML, PDF, and Text formats.
• Administered the test and production Hyperion Portals including user account maintenance, file uploads, and job scheduling.
• Developed GUI forms to enable users to upload various file formats, manipulate this data, and then store the resulting data in XML format in the reporting database.
• Developed various scripts and interactive reports to calculate portfolio performance, customer asset allocation, accrued interest for bonds, and taxation liabilities for several legal jurisdictions.
• Carried out database analysis and script performance tuning.
• Providing out of hours technical support.

Role outline: Brio Consultant responsible for making enhancements to the reporting system that enables P&G to monitor and measure key performance indicators from the country level to the postcode level.
Technology Environment: Oracle 8i, PL/SQL, Brio 8, Brio Intelligence 6.6, JavaScript, HP-UX (UNIX), and Windows NT.

Responsibilities

• Liaised with country and regional managers to obtain user requirements.
• Created design specifications.
• Modified existing ETL scripts.
• Developed Interactive Brio Dashboard queries which interfaced the Oracle datawarehouse.
• Trained users on the adhoc query features within Brio 8.

Role outline: Brio Consultant responsible for developing the reporting system around Adecco’s contract hires management and payments system.
Technology Environment: Oracle 9i, Brio SQR, Brio One Portal, JavaScript, SQR, and Windows 2000.

Responsibilities

• Obtained user requirements.
• Designed reporting database using Star Schema design methodology.
• Developed ETL scripts that extracted data from Peoplesoft data repository to the reporting datawarehouse.
• Created Brio Interactive Dashboard queries that reported on Adecco UK’s key performance indicators.
• Setup Brio One Portal to schedule execution of the SQR scripts, and despatch the results to the required individuals.
• Produced all required documentation including training material and user guides.

Role outline: Brio Consultant responsible for developing an application that enables users to measure the performance, activity, and reach of P&G’s sales personnel.
Technology Environment: Oracle 8i, PL/SQL, SQL, Brio Designer 6.3, JavaScript, HP-UX (UNIX), and Windows NT.

Responsibilities

• Obtained user requirements
• Designed reporting summary tables.
• Developed ETL scripts used to extract data from the Transactional System and load into the summary tables.
• Developed Interactive EIS Dashboards monitor the key performance indicators of sales activity, product performance, geographical performance, employee performance, sales team performance, and specialty performance.
• Set up and administered the Brio OnDemand Server so that users could access EIS Dashboards over the corporate Intranet.
• Provided database and Brio training to users.

Confidential,California Oct 1999 - Jul 2001
Oracle/ Brio Developer

Role outline: Oracle and Brio Developer within Roche’s Drug Safety Unit, which is responsible for the development and maintenance of systems used to record and report on adverse drug reactions to the FDA.
Technology Environment: Oracle 7.3.4, PL/SQL, Brio Designer 6.2, JavaScript, Oracle Form 6i, Sun Solaris 2.8, Summit-D, and Windows NT.

Responsibilities

• Played an active role in the design data warehouse using Star Schemas and Snowflake methodology.
• Developed EIS Dashboards that enabled users to measure and report on key indicators such as average time taken to submit reports to regulators, average processing time, reports currently in process, employee productivity, and average activity time.
• Developed data warehouse ETL scripts.
• Oracle performance tuning.
• Developed various GUI and Web-based data entry screens using Oracle Forms 6i.
• Set up and administered the Brio OnDemand Server so that users could access EIS Dashboards over the corporate Intranet.
• Evaluated range of reporting products including Business Objects, Brio Query and Oracle Discoverer.

Education

Enterprise Solution Development Program.

BSc (Hons) Computer Science.

Accountancy Foundation Course; Grade: Merit.