SUMMARY:

• Versatile developer with over 15 years solid development experience.
• Expertise in developing business intelligence, data warehousing, and reporting applications using tools such as Tableau, Oracle, Google BigQuery, OBIEE, and Hyperion.
• Extensive experience in developing applications that interface both proprietary and in - house repositories such as Remedy, Oracle EBS, Converg-e Real-time Asset Management.
• Involved in many aspects of the SDLC including requirements gathering, proof of concept delivery, implementation, user support and maintenance.
• Experience in the Internet, Telecoms, Financial Services, and Pharmaceutical Sectors with leading companies such as Google, Facebook, Motorola Mobility, and Toyota Financial Services.

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau (5), OBIEE (2), Hyperion BI (11).

Databases: Oracle v7/8/9/10/11G (15), PL/SQL & SQL (15), Google BigQuery (3), Hyperion Essbase (2).

Operating Systems: Windows (15), UNIX (10), OSX (3)

Programming Languages: JavaScript (5), PERL (4), Java (2), Pro*C (2), C (3).

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

BI Developer

Technologies: Tableau v6/v7, Oracle 10/11G, Hyperion BI, OBIEE 10G, and JavaScript.

Responsibilities:

• Created Tableau dashboards to monitor clickstream data such as unique web visitors by segmentation, average time spent on website, pages visited, total sales, gross profit, top 25 pages visited, and top 25 product pages visited 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 dashboards to measure effectiveness of Search Engine Marketing and email campaigns.
• Involved in the development of reporting abstract layer in order to simplify query building for reports users.
• Attended daily scrum sessions consisting of developers, data architects, and user groups to review project progress, discuss hot issues, and acquire new requirements.

Confidential, Mountain View, CA

Tableau Consultant

Technologies: Tableau v9, Oracle 11g, Google BigQuery, and Remedy Workflow.

Responsibilities:

• Attending meeting with business stakeholders to obtain business requirements.
• Lead developer in the creation of self-service query and reporting environments.
• Lead developer in the creation of hardware, technical support, and finance datamarts.
• Actively involved in datamart progress and review meetings.
• Developed load scripts for Type 2 slow changing dimensions used in datamarts.
• Developed dynamic Tableau dashboards to develop the number of requests that flowed into the business unit, the time that these requests took to be responded to and the time to resolution.
• Creating and administering Tableau site, creating project folders, and updating user and group access to Tableau workbooks.
• Creating and administering server base Tableau sources and extracts.
• Developed Sankey dashboards to display the source and destination of requests entering the business unit.
• Lead developer/analyst in the creation of dashboards to provide insights into hardware asset management in an effort to reduce over stocking and related costs.

Tableau Consultant

Technologies: Tableau v8/9, and Oracle 11g.

Responsibilities:

• Attend daily meetings with stakeholders to obtain user requirements.
• Developed Tableau dashboards to measure traffic entering the FB campus in order to meet the reporting requirements of the City of Menlo Park.
• Developed Tableau dashboard to measure the occupancy and punctuality of the employee shuttle bus program.
• Developed Tableau dashboards to measure costs relating to employee catering program.

Tableau Consultant

Technologies: Tableau v8/v9, Oracle 11g, Google BigQuery, and Remedy Workflow.

Responsibilities:

• Developed Tableau dashboards to measure key performance indicators within Google's Unified Ticketing Systems including ticket throughput, ticket resolutions, time to initial response versus SLA, and time to resolution versus SLA.
• Developed ETL scripts to extract data from Remedy Workflow into Oracle. Ensured that data was at level to produce meaningful and insightful dashboards as well as return live queries within a reasonable amount of time.
• Developed script that together with the Tableau datasource filter enforces the row-level security model that exist in the source system.
• Worked with ETL developers to setup initial load and incremental load script in order to have Tableau datasources connecting live to BigQuery rather Oracle RDBMS.
• Creating and administering Tableau site, creating project folders, and updating user and group access to Tableau workbooks.
• Creating and administering server base Tableau sources and extracts.

Tableau Developer

Technologies: Tableau v7, Oracle 11g, MySQL, PL/SQL, and JQuery.

Responsibilities:

• Setup Mobile Analytics high availability Tableau cluster consisting of: master server, 7 worker server servers, and slave server.
• Migrated Tableau Workbooks from MySQL to Oracle 11G.
• Perform weekly Tableau server backups and apply server upgrades.
• Developed Tableau dashboard to monitor mobile application usage, server log activity, device activations, device O/S upgrades, and device O/S upgrade failures.
• Migrated embedded SQL logic from Tableau to Hive SQL.
• Developed guided Tableau dashboards to monitor upgrade to new software versions.
• Modified Tableau Extracts to use incremental refreshes in order to reduce extract runtime and increase the number Tableau workbooks that can be run in a given time period.
• Created Oracle Materialized Views to create aggregated roll-up of source data in order to improved Tableau Extract Performance.
• Participated in daily stand-up meetings to address outstanding issues and new development.