Sr. BI Developer Resume

SUMMARY

8 years of professional experience developing Business intelligence applications using BI tools like Tableau, Qlik Sense, QlikView, PLX, Data Studio.
Excellent knowledge of SQL databases like Oracle, SQL Server. Proficient writing complex SQL for data mining.
Experienced PL/SQL developer. Developed PL/SQL packages, procedures, functions, triggers for ETL of data from staging to data warehouse environment.
Experienced designing logical and physical data models using ER and UML diagrams .
Expertise in Developing business intelligence dashboards, user stories, static and dynamic reports.
Excellence in data and dashboard optimization. Verify explain plan and use query hints, indexes or other performance tuning techniques to tune the code.
Experienced working with Confidential BigQuery and Clarinet scheduler for ETL.
Excellent communication and problem solving skills.
Experienced working with Agile Product Development life cycle to manage timely deliverable.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau 2019.2, Qlik Sense 3.2, Qlikview 12, Tableau Prep 2018.1, Data Studio

Database Technologies: Oracle 18c, SQL server 14.0, Confidential BigQuery

ETL Tools: Informatica PowerCenter 9.6

Reporting Tools: SSRS 2018, Crystal Reports 14.0, BIRT Report Designer, PLX

IDE Tools: SQL developer 17.2, Toad 1.0, Eclipse, Visual Studio Code

Languages: Python, C++

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Fact Constellation Data Modeling

Agile Development tools: Tortoise GIT, SVN

Operating Systems: Windows 7, Windows 10, macOS Mojave, Unix, Linux - Ubuntu, Chrome OS

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI Developer

Responsibilities:

Understand the data model and create BRD to suffice the business cases.
Use BigQuery Legacy SQL to develop script for data extraction from Base to Business and from Business to Presentation layers.
Use clarinet to schedule extraction batches for Pentaho ETL jobs.
Maintain and support Pentaho pipelines for ETL
Create ETL Design Specification documents.
Manage data migration from PLX to Bigquery and vice versa.
Design, develop, maintain and test Tableau dashboards.
Extract data from BQ to PLX and develop PLX dashboards.
Develop various dashboards in Data Studio and bug fixes to enhance existing Data Studio reports.

Technologies Used: Clarinet, Tableau 2019.2, Data Studio, Confidential BigQuery(Legacy and Standard SQL), PLX

Confidential

Sr. BI Developer

Responsibilities:

Gather requirements from the key stakeholders. Validate the requirements with Analyst team and create business requirement document.
Use SQL queries to mine data from Oracle data warehouse and combine this data with other static data files and extract in Tableau Desktop.
Develop PL/SQL code procedures, functions, packages for doing data extraction from data warehouse.
Use bulk inserts and effectively enable or disable use of indexes in the queries for performance tuning.
Invoke and execute sql script through python.
Combine, shape and clean the extracted data and establish relationship between data chunks using Tableau data interpreter and Tableau Prep
Develop and design various statistical reports and dynamic dashboards to highlight data analysis trends and various analytical KPIs as per business requirements.
Work on optimization techniques to reduce response time and improve availability of Tableau dashboards.
Deploy and support the dashboards through various phases of development lifecycle and manage product delivery by agile methodology.

Technologies Used: Tableau 10.5, Oracle 18c, Tableau Prep 2018.1, GIT, Python 3.5, SQL developer 17.2