SUMMARY:

• Versatile developer with 16 years solid development experience.
• Expertise in developing Business Intelligence, data warehousing, and ETL applications using tools such as Tableau, Hyperion Interactive Reporting Studio, Hyperion Production Reporting (SQR), Hyperion Essbase,
• Hyperion Workspace, and Hyperion Web Analysis.
• Extensive experience in developing applications that interface packaged applications such as Oracle EBS 11.5, Peoplesoft, Siebel CRM, and Converg - e Real-time Asset Management and Custody System.
• Involved in many aspects of the SDLC including requirements gathering, proof of concept delivery, implementation, and user support and maintenance.
• Extensive experience in the Financial Services, Insurance, and Pharmaceutical Sectors, with lea ding clien ts

PROFESSIONAL EXPERIENCE:

Confidential,Sunnyvale,CA

Tableau Developer

• Attended daily JAD sessions with developers, data architects, and user groups to review project progress, discuss hot issues, and acquire new requirements.
• Involved in the development of reporting abstract layer in order to simplify query building for Tableau users.
• Created daily and weekly Tableau extracts storing web traffic, traveller preferences, and reservations transactions.
• 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

• 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

• 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.
• Adding Java Oriented Object Linking and Embedding (JOOLE) scripts to existing IR dashboards in order to enhance formatting when exporting to MS Office applications.

Confidential,King of Prussia,PA

Hyperion Consultant/Trainer

• Provided basic, intermediate, and advanced user training on Hyperion IR and Workspace.
• Worked with DBA to implement Star Schema based data marts that support the data requirements for the Sales Promotion and Commissions dashboards.
• Developed dashboard driven Sales and Commission Hyperion IR reports.
• Created Hyperion Master Data Model documents for Business Analysts and Power Users.
• Setup reporting Metadata repository.

Confidential,Braintree,MA

Sr. Hyperion Developer

• 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, and Costing modules within Oracle EBS.
• Developed and maintained common/global functions to be used in all Interactive Reporting Documents.
• Created datamarts based on Materialized Views to improve the execution time of dashboards running against the transactional database rather than the reporting datawarehouse.
• 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

Sr. Hyperion Developer

• 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.
• 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

Sr. Technology Strategist

• 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.
• Conducted Hyperion Intelligence 8.5 Clients training sessions and presentations for users and management.

Confidential,Boston, MA

Sr. Brio/Hyperion Developer

• 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.

Confidential

Sr. Brio Consultant

• 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.

Confidential

Brio Reports Consultant

• 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.

Confidential

Brio Consultant

• 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 On Demand Server so that users could access EIS Dashboards over the corporate Intranet.
• Provided database and Brio training to users.

Confidential,Palo Alto,CA

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.

• 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.