Resume

Tableau Developer

Location:

Durham, NC

Posted:

March 11, 2020

Contact this candidate

Resume:

ARIJEE KHOLI

Address: *** ********* ******, ***#**, Jenkintown, PA-19046

PROFESSIONAL SUMMARY:

Outstanding Business Intelligence specialist with more than fourteen years of extensive experience in leading BI team. Strong communicator and excels in identifying client need and providing project consulting, preparation and planning, requirement gathering & analysis, estimations, architectural design and development, testing, deployment and production support activities.

Hands-on technical expert in Tableau, SAP BOBJ Reporting, BOBJ Data Services ETL process, Pentaho, SQL/PLSQL, SAP BW, SAP HANA, Xcelsius, Crystal Reporting, Rest API’s and R programming.

TECHNICAL SKILLS:

Reporting Tools

Tableau 2019.x/2018.x/10.x/9.x/8.x, Business Objects Reporting (BOBJ) 4.2/4.1/4.0/3.2/3.1/3.0 XIR2/XIR1, Crystal Reports 2013/2011/2008, Xcelsius Dashboards, OBIEE Reports

ETL/Data Provisioning

SAP Business Objects Data Services (BODS) 4.2/4.1/4.0/3.2/3.1/XIR2/XIR1, Pentaho, HANA SLT/SDA/SDI/DXC

SAP BI/BW

BW/4HANA, BW ON HANA 7.5/7.4, BW 7.3/3.5, BI 7.0

SAP HANA

Native HANA 2.0/1.0, S/4 HANA

ERP

Knowledge of SAP ECC

Programming Languages

SQL, PL/SQL, Shell Scripting, Java, R Programming, HTML, CSS, C, C++

Databases

Oracle, SQL Server, HANA, DB2, MS Access

Project Management

Microsoft Suite (Outlook, Project, Visio, Word, PowerPoint, Excel)

Testing Tools

HPALM

Operating System

Windows, Linux

Ticketing Tools

JIRA, Service Now, Clear Quest, ITS

API

Rest API’s

Domain

8 years in Energy (Oil and Gas, Utilities), Telecom (1 Year), Education (1 Year), Life Science (1 Year), Insurance (1.5 year), CRM Sales (1.5 year)

PROFESSIONAL EXPERIENCE:

Lead Business Intelligence Developer, Compunnel Software Group, Inc. Jan 2020 till Date

Client: CREE (Durham, NC)

•Leading Business Intelligence Tableau team in Agile framework

•Provide solution, estimate and architectural design for HAWK Migration of OBIEE to tableau project.

•Worked with clients to determine business requirements, priorities, define key performance indicators (KPI) and develop lean BI data warehouse design for CREE Lighting client.

•Involved in all parts of the software development lifecycle of BI solutions including preparation, planning, analysis, design, development, testing, deployment and support.

•Migrated all the OBIEE reports for CREE lighting business into a robust set of Tableau dashboard reporting and analytic deliverables.

•Created stored procedures, functions and SQL/PL SQL scripts to populate the history, live tables in Oracle database as a part of ETL process.

•Created combined Views in target reporting schema in Oracle for Tableau data source consumption.

•Created Tableau Data sources for all the 14 functional areas within CREE Lighting business.

•Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.

•Used Performance Recording feature in Tableau to understand the timeline, event and query aspect and optimize the dashboard hence reducing the run time.

•Performed Tableau server and site administration activities like publishing and sharing workbooks and data sources to tableau server, setting schedules, subscriptions, authorization and permissions, scheduling incremental refresh extracts and updating server data that are using extracts, single/multi modes, migrating contents, upgrades etc.

•Worked with business users to validate Tableau reports comparing with OBIEE reports for UAT process.

Senior Business Intelligence Developer, Compunnel Software Group, Inc. May 2019 – Dec 2019

Client: Comcast (Philadelphia, PA)

•Leading Business Intelligence reporting team in Agile framework

•Provide solution, estimate and architectural design for Xfinity Mobile project

•Worked with clients to determine business requirements, priorities, define key performance indicators (KPI) and develop BI and data warehouse (DW) strategy.

•Involved in all parts of the software development lifecycle of BI solutions including preparation, planning, analysis, design, development, testing, deployment and support.

•Used Jira to create Tableau dashboard tickets and track issues.

•Determine a clear strategy and roadmap for how to fully utilize and optimize Tableau with a thorough plan that defines vision, mission, goals, objectives, and prioritizes a work schedule.

•Translate requirements into a robust set of Dashboard reporting and analytic deliverables, primarily using the Business Intelligence tool Tableau.

•Work closely with the backend subject matters expert (SMEs) to understand the backend data foundation and develop ETL jobs using Pentaho to populate target Oracle table which is a feed to dashboard reporting framework will be.

•Work with REST APIs to extract data from JIRA to Oracle Database using ETL Pentaho jobs.

•Created and maintained Oracle tables which is the Tableau reporting data source.

•Develop, implement and maintain a process to manage and prioritize the intake of Tableau request for work (RFW) using Jira Tickets. Design an RFW that includes asking the requester how the Tableau Dashboard/ Report is going to be used- goal is to ensure that we are developing Tableau Dashboard / reports that will be used.

•Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.

•Used Performance Recording feature in Tableau to understand the timeline, event and query aspect and optimize the dashboard hence reducing the run time.

•Worked on creating optimized SQL query views for dashboard data source feeds.

•Strong experience on creating native SQL, stored procedures and debugging SQL script.

Lead Business Intelligence Developer/Analyst, Compunnel Software Group, Inc. Jun 2018 -Mar 2019

Client: University of Chicago (Chicago, IL)

•Leading Business Intelligence reporting team in agile methodology.

•Provide solution, estimate and architectural design for the new AURA Grants 8.0 project

•Worked with clients to determine business requirements, priorities, define key performance indicators (KPI) and develop BI and data warehouse (DW) strategy.

•Involved in all parts of the software development lifecycle of BI solutions including preparation, planning, analysis, design, development, testing, deployment and support.

•Worked on to consolidate and control changes management process by using Service Now.

•Currently working on Tableau 2018.1 and 2018.3 version.

•Designed and developed a total of six university research Tableau Dashboards. The major ones are Proposal, Awards and Expense Dashboards.

•Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.

•Used Performance Recording feature in Tableau to understand the timeline, event and query aspect and optimize the dashboard hence reducing the run time.

•Worked on creating optimized SQL query views for dashboard data source feeds. Reduced the time of SQL run by 90% in order to use both Live and Extract connection.

•Strong experience on creating native SQL, stored procedures and debugging SQL script.

•Developed SAP BODS Extraction Transformation and Load (ETL) jobs to populate various functionalities like Proposal, Awards and Expense DataMart.

•Developed SAP BOBJ universe using Information Design Tool by creating a semantic layer using Dimensional Modelling (Star schema).

•Developed SAP BOBJ web intelligence reports

•Worked on SQL Server, Oracle database

•Involved in administration activities such as user groups, projects, schedule reports and maintaining servers in BOBJ CMC

Business Intelligence Manager, Utegration LLC Sep 2013 - Mar 2018

Clients: CenterPoint Energy (Houston, TX), Southwest Waters (Houston, TX), LES Lincoln, NE), Huntsville Utilities (Huntsville, AL), NPPD (Columbus, NE), Alagasco (Birmingham, AL), TXU Energy (Dallas, TX)

•Managed and lead Business Intelligence team in both waterfall and agile methodology.

•Worked in various implementation projects in complex environments with many involved parties (technical team, business analyst team, client management, business users, software vendors, outsourcing partners etc.)

•Worked on multiple projects developing and supporting concurrently.

•Provide solution, estimates and architectural reviews on new projects as well as production support issue.

•Worked on process improvements, make appropriate recommendations, and facilitate change

•Worked in agile framework.

•Worked on to consolidate and control changes management process by using Jira and Service Now.

•Worked with clients to determine business requirements, priorities, define key performance indicators (KPI) and develop BI and data warehouse (DW) strategy.

•Interacted with strategic development team, business analyst to analyze business needs and developed technical specifications.

•Involved in all parts of the software development lifecycle of BI solutions including preparation, planning, analysis, design, development, testing, deployment and support. Actively tracked the projects using Microsoft project plan.

•Worked on various projects like Asset Management, Asset Investment strategy (AIS), Fleet reporting, Historical Trending analysis, Diversion, Customer Satisfaction Survey, Home Service Provider (HSP), Finance and Regulatory reporting, Data Migration of Finance Data.

•Worked on Tableau 10.4x, 10.2x, 9.0x and 8.0x version.

•Developed Finance, HR, Assets, Fleet, HSP, Billing/Bill print and invoicing, Customer Service dashboards using Tableau.

•Connected to SAP HANA views to create data sources for Fleet, HSP, Billing/Bill print and invoicing dashboards.

•Connected to Microsoft SQL server to create data source for Assets management and HR dashboards.

•Connected to Oracle to create data source for Customer Service and Operations dashboard.

•Worked on creating optimized SQL query views for dashboard data source feeds hence reducing the run time.

•Implemented row level security in Tableau Dashboards.

•Designed an interactive dashboard by using quick and context filters, user parameters, actions URL for business users to navigate from summarized data in Tableau to details reports in Business Objects Webi reports.

•Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.

•Used Performance Recording feature in Tableau to understand the timeline, event and query aspect and optimize the dashboard hence reducing the run time.

•Imparted Tableau user training sessions in order for business to get familiar with standard dashboard navigations as well as equip super users to create their own dashboards from available standard data sources in tableau online.

•Developed Xcelsius dashboards.

•Developed SAP BOBJ Data Services ETL jobs.

•Developed SAP BOBJ universe using Information Design Tool by creating a semantic layer using Dimensional Modelling (Star schema).

•Developed SAP BW workbench backend model and Bex Queries.

•Developed SAP BOBJ web intelligence reports and Crystal Reports

•Extensive experience in SQL/PLSQL coding.

•Hands on experience in Native HANA Information modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, Analytical view and Calculated views with graphical and script methods.

•Strong experience on creating native SQL, Hana SQL scripts, stored procedures and debugging SQL script.

•Performed administration activities such as Server installation and configuration, user groups, projects, scheduled reports and maintaining servers in BOBJ CMC.

•Worked on Machine Learning R programming for Home Service Provider project.

Lead Business Intelligence Developer, Accenture Jun 2010 - Jul 2013

Client: Royal Dutch Shell (Houston, TX)

•Worked on commodity trading of crude oil in order to support Shell downstream business. Oil data warehousing was implemented for deal capture/risk, operations, settlements and accounting functional areas.

•Worked with business users for requirement gathering and analysis of downstream business functions.

•Created target tables in Oracle database using SQL coding

•Developed complex SQL coding and embedded in ETL jobs.

•Created ETL jobs for Oil data foundation layer.

•Developed data visualization Tableau dashboard reporting for Deal capture and Risk, Operations and Settlement and accounting trading team.

•Designed an interactive dashboard by using quick/context filters and user parameters.

•Created Xcelsius Dashboards for Stock Option trade users

•Developed custom SQL and embedded in BOBJ universe using IDT and BOBJ web intelligence reports

•Created BOBJ universe design and web intelligence reports for DLC/RSK, OPS and STA trading team.

•Administered user groups, scheduled reports, transport management and server administration using BO CMC.

•Created user groups, projects and scheduled reports in Tableau server.

•Performed activities like internal testing, volume regression testing and supported business for UAT process.

•Extended production support activities post go-live.

Business Intelligence Developer, DuPont Jul 2009 - Jun 2010

Client: DuPont, Gurgaon, India

•Developed new planning process which provided a means of collecting data from multiple sources in a standard format thus enabling rapid development of DuPont Crop business growth.

•Worked with business users for requirement gathering and analysis of the data.

•Developed custom SQL and embedded in BOBJ universe using IDT and BOBJ web intelligence reports

•Designed and developed complex Web Intelligence reports using calculated measure, graphs and charts.

•Performed testing of reports and fixed bugs present in the reporting layer.

•Developed sales BI Dashboards using Xcelsius 2008 tool using Live Office connection.

•Scheduled reports using Central Management console.

Business Intelligence Developer, Satyam Computer Services Ltd. Mar 2006 - Jul 2009

Client: Max New York Life Insurance (Gurgaon, India), Satyam Corporate (Hyderabad, India)

•Consolidated data from multiple sources into one single system enabling the organization to use analytical data to make strategic business initiatives.

•Worked on MNYL Insurance project as well as CRM and HR process projects.

•Worked with business users for requirement gathering and analysis.

Created tables in SQL Server and Oracle database.

•Implemented Extraction Transform and Load (ETL) to target tables by using SAP BOBJ Data Integrator

•Created BOBJ Universe and Web Intelligence reports

•Tested ETL jobs, Universes and Web Intelligence reports and successfully deployed to production environment.

•Scheduled ETL jobs and Web intelligence reports using BODS and BOBJ administration console.

EDUCATION 2001 - 2005

Bachelor of Engineering in Computer Science and Engineering

Visvesvaraya Technological University, India

Contact this candidate