BI ETL Developer Resume

Technical Skills:

PROFESSIONAL EXPERIENCE

Confidential

BI ETL Developer

Responsibilities:

Requirement Analysis, Logical & Physical Database Design, Data Modeling
Maintain Marketing and Sales reports in the server.
Support Retention Marketing programs and campaigns run by Confidential partners like Amazon, Netflix, and Blockbuster.
Design and develop a dashboard.
Business users: Marketing and Sales departments

Technology used: PL/SQL, SQL, SQL Loader, Hyperion, Excel, Tableau

Confidential

Data Warehouse

Responsibilities:

Technology used: PL/SQL, Apex Loader & Unix Shell Scripting

Confidential

Data Warehouse

Responsibilities:

Designed tables to facilitate the creation of self - serve dashboard in Tableau to meet the needs of Marketing Email campaigns.
Coordinated with offshore team to build and test post processing steps like randomizing across the lists, de-duping logic etc.
Assisted in maintenance and delivery of various ad-hoc requests from Sales, Marketing and Finance.

Technology Used: Hyperion Interactive Reporting, Hyperion Workspace, SQL, Oracle, MS Access

Confidential

BI Data Analyst

Responsibilities:

Developed a dashboard to illustrate the number of POP numbers available to Confidential customers geographically using Tableau and MS SQL Server.
Worked on a Hyperion dashboard which reported various metrics such as activations, broadband, login for the entire customer base of International Confidential customers.
Designed the queries using Hyperion to generate randomized survey lists for User Research.
Maintain the Finance automated report in the server. Modify the report according to business requirements.
Wrote numerous queries to generate targeted email lists for promotional emails, newsletters sent by Marketing.
Created ad-hoc temporary reports for Sales, Marketing and Finance departments.
Participated in the audit meetings with KPMG.
Maintain Month-end, weekly and daily reports. Maintain manual report to run in Hyperion on need basis, maintain the excel file, create charts, pivots.

Technology Used: Hyperion Interactive Reporting, Excel, Tableau, Ms Access, MS SQL Server