Created Tableau reports and dashboards that show KPIs such as unique web visitors, average time spent on site, pages, total sales, gross profit, visited, top 25 pages visited, and top 25 products week on week, and year on year.

Created Tableau to measure Web Reservation Conversions reports to measure visits to reservation based on video views, time spent on website, and type of referral source (Search Engine, Social Media, Direct, and Email).

Created reports and dashboard to measure effectiveness of Search Engine Marketing and email campaigns.

Designed and implemented several summary and aggregate fact tables to reduce report run time.

Confidential

Senior Hyperion Developer/ Tableau Developer

Responsibilities:

Worked in a team consisting of internal and external developers who migrated 318 Hyperion v8.5/v9.2 reports and dashboards to OBIEE Plus 10G.

Developing adhoc reports and queries in joint application development sessions with users.

Worked with Business Analysts to design the dimensional models needed for the creation of the datamarts/Essbase cubes for the dealer conversion project.

Developed web based BI reports to enable dealers to measure lead conversion with district, regional, and, national performance indicators.

Developed financial and audit reports as part of Confidential 's move to systematic loan charge off.

Assisted ETL developers in resolving inaccuracies between the transactional databases and the reporting data marts.

Confidential,Torrance,CA

Sr. Hyperion/BI Developer/Tableau Developer

Responsibilities:

Worked with users to identify the dimensions and attributes needed in the data-marts/cubes for the business credit history dashboard project.

Developed business credit history dashboard providing indicators to monitor loan applications, payment history and delinquency behaviour.

Provided Hyperion support and problem resolution to TFS users.

Worked with Oracle and SQL Server DBA to deliver proof of concept of moving OneSource(Oracle 10G) to Insight (MS SQL Server 2008) platform.

Involved in the design, development, and support of the PAS Management Report nightly batch cycle that consisted of 200 parameterized reports that 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.

Administered the test and production Hyperion Portals including user account maintenance, file uploads, and job scheduling.

Confidential,Boston,MA

Sr. Technology Strategist

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.

Participated in evaluation of Essbase Analytics - PRAC is intending to move to Essbase by the end of 2008.

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.

JavaScript Requires
Sorry this site will not function properly without the use of scripts.
The scripts are safe and will not harm your computer in anyway.
Adjust your settings to allow scripts for this site and reload the site.