Lead Bi/tableau/power Bi Developer Resume
Irving, TX
SUMMARY
- A qualified IT professional with 8 years of extensive experience including 7+ years of experience as Tableau Developer and 2+ years in Power BI.
- Most comfortable with Business Intelligence tools Tableau 2019x/2018x/10.x/9.x/8.2/8.1, Power BI and various applications in Client/Server OLTP, OLAP environment, Microsoft SQL Server, Oracle, MongoDB, Hadoop (Impala, Spark), IBM Netezza, Postgres, Microsoft Excel as Developer in various companies.
- Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.
- Involved in creating dashboards and reports in Tableau 2019.x/2018.x/10.x/9.3/8.1/8.2 and Power BI. Created report schedules on Tableau server.
- Preparing Dashboards using calculations, parameters in Tableau. Built complex formulas in Tableau for various business calculations.
- Expertise in Banking, Financials, Automotive, Retail and Health Care domains.
- Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
- Involved in creating database objects like tables, views, procedures, triggers, functions using T - SQL, PLSQL to provide definition, structure and to maintain data efficiently.
- Effectively used Data Blending feature in Tableau, worked on different table calculations for different Scorecards.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and dashboard using KPI's.
- Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
- Resolved various performance issues and analyzed the best process distribution for different projects.
- Experienced in creating calculations (creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
- Extensively worked with large databases in Production environments, UAT, and DEV environments.
- Identifying data for any new projects/analysis and Responsible for data quality, accuracy, and timelines.
- Hands on experience in writing SQL, PLSQL, HQL Queries. Extracting and Loading data into SQL Server Database using SSIS.
- Extensively involved in designing the SSIS packages to export data from SQL Server database to flat file source.
- Worked with Spark Developer to solve issues in SQL/Impala Queries for compatibility like indexing, functions, views, and tables.
TECHNICAL SKILLS
Operating System: Windows 95/98/2000/XP/Vista/7.
Databases: Oracle 8i/9i/10g/11g, SQL Server 08/12, MS Access, Hadoop, MongoDB.
Reporting: Tableau 2019.x/2018.x/10.5/9.x QlikView, Alteryx, SAP BO, Power BI
Web Technologies: XML, HTML.
Languages: Java, PL/SQL, MSSQL, Hadoop/Impala, HQL
PROFESSIONAL EXPERIENCE
Confidential, Irving, TX
Lead BI/Tableau/Power BI Developer
Responsibilities:
- Experienced in handling large volumes of data, optimized SQL scripts to improve the efficiency on the database and dashboards.
- Created Tableau scorecards, dashboards using stack bars, bar graphs, bullet charts, scattered plots, geographical maps.
- Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
- Created extensive custom joins for blending data from several different data sources.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
- Developed and demonstrated Tableau's advanced features including calculated fields, parameters, table calculations, row-level security, joins, data blending and dashboard actions for the users.
- Created URL actions to navigate from one dashboard to another dashboard. Created Action filters by passing filters and parameters to the actions.
- Created various User groups by assigning row and column level security at application level, folder level and user level.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
- Consistently attended meetings with the client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs.
- Created various User groups by assigning row level security at application level, folder level and user level.
Environment: Tableau Desktop 2019. x, MS SQL Server 2008 R2, SQL Server Management Studio, Netezza, DBeaver Enterprise, MS Excel, Tableau Server 2019.x, Power BI.
Confidential, Irving, TX
Lead BI//Tableau/Power BI Developer
Responsibilities:
- Effectively interacted with Business Analysts and Data Modelers to define requirement document and design processes for various data sources and reporting needs.
- Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server.
- Embedded a dashboard to JavaScript and made some live dashboards.
- Designed a dashboard that is easy for the clients to use and to analyze their sales and predict the requirements for the future.
- Scheduled data refresh on Tableau Server for weekly and monthly and for every 15 minutes increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Designed Dashboards where end user can see some live transaction counts and sales and predict the higher sales by time.
- Worked with advance analysis such as Table Calculations, calculated fields such as KPI's using various functions (SUM, IF, MAX, MIN, AVG, ATTR, DATE Functions, etc.), Parameters, Sets, Background Images, Logos, Totals, Forecast, Trend Lines, and Dual Axis to make robust reporting.
- Extracting and Loading data into SQL Server Database using SSIS. Extensively involved in designing the SSIS packages to export data from SQL Server database to flat file source.
- Scheduling & Maintaining ETL packages in terms of data validation and consistency.
- Created Mapping, Design, and technical Documentation for complex SSIS packages.
- Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
- As a Tableau SME, responsible for the design, development and production support of interactive data visualizations used across the company.
- Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
- Involved in the migration of Business Objects reports to Tableau reports.
- Experience in Alteryx platform, and involved in data preparation, data blending, and the creation of data models, data sets using Alteryx.
- Involved in Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
- While design the Power BI reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.
- Created URL Actions to navigate from one Dashboard visual to another Dashboard for a smooth eye-catching presentation along with using Tableau Data Extracts for better performance on rendering the visualizations.
- Customized various reports in Order Management, Inventory and Shipping. Some of them are Pack List, Bill of Lading, Sales Acknowledgement Report, Order Holds Report, Delivery Detail Report.
Environment: Tableau Desktop 2018.x/2019. x, MS SQL Server 2008 R2, SQL Server Management Studio, AWS, Azure, Hadoop/Spark, Alteryx, Python, Snowflake, Tableau Server 2018.x/2019.x, Power BI, SSIS.
Confidential, Chicago, IL
Data Analyst/Tableau/Power BI Developer
Responsibilities:
- Developed number of parameterized dynamic dashboards, scorecards, with drill down and drill through capabilities.
- Worked with Hadoop database by connecting to Impala as a data source and fetching tables.
- Develop Scripts to load data into Tableau and work with multiple data connections including Hadoop/Impala and by data blending.
- Involve inData asset Inventoryto gather, analyze, and document business requirements, functional requirements, and data specifications from sources SQL / Hadoop.
- Involved in the process of data transformation from Oracle to Hadoop.
- Supporting peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting and analysis of results. Acting as Tableau SME for other Tableau users across the enterprise.
- Designed a dashboard that is easy for the clients to use and to analyze their growth and predict the requirements for the future.
- Analyzed various metrics including forecast accuracy, gaps, presentation levels, and products sold activity.
- Well versed in using multi-dimensional expression MDX queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
- Designed, coded, and tested several SQL/HQL/Impala Queries to Support the System.
- Fixed bugs in the software that was used to support the Insurance product line system.
- Worked with DBA on team to solve issues in SQL/HQL/Impala Queries for compatibility like indexing, functions, views, and tables.
- Worked with MongoDB by using MongoDB BI connector.
Environment: Tableau Desktop 10.5, Hadoop/Impala, Linux, Unix, MS SQL Server 2008 R2, SQL Server Management Studio, MS Excel, MongoDB, Tableau Server 10.5, Power BI
Confidential
SQL/BI Developer
Responsibilities:
- Team member in development of an in house MRP package to integrate Material Procurement, Inventory Control, Spares Management, Preventive Maintenance Planning Module and Production Control System Projects.
- Developed various reports using Reports Builder and PLSQL: Manpower Forecast and Planning, Daily and Monthly Production, Goods Receipt Note, Inspection Report, Acceptance & Rejection Reports, Issue of Material, Material Utilization.
- Worked on fine-tuning of SQL queries and PLSQL procedures for improved performance.
- Customized the ‘OM: Generate Cost of Goods Sold Account’ Workflow to generate the COGS account that meets the business requirements.
- Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server.
- Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
- Customized existingDunning Reportand Invoice PrintingReport in Accounts Receivables usingXML/BI Publisher.
- Customized various reports in Order Management, Inventory and Shipping. Some of them are Pack List, Bill of Lading, Sales Acknowledgement Report, Order Holds Report, Delivery Detail Report.
- Effectively used data blending feature in Tableau when there were more than one databases involved.
- Involved in design, development, testing and migration meetings of QlikView applications.
- Involved in validating the QlikView data against the data in the database tables and views.
- Involved in writing stored procedures in PL/SQL to validate, select, insert, and update data in material procurement module.
Environment: Oracle Apps Release 11i (11.0.3/11.5.8 ), Tableau 9.0/9.1/8.2 Oracle Database (8i/9i), SQL*Plus, SQL*Loader, Forms 10g, UNIX, Postgres, SAP BO, SSRS, BI Publisher/XML Publisher.
Confidential
PL/SQL Developer
Responsibilities:
- Study and design of entire system.
- Design of the overall database using Entity Relationship diagrams.
- Installed Oracle 10g Database; was involved in gathering requirements for DB design
- Was involved in creating the Application Schemas, Table, Indexes and Views
- Wrote PL/SQL packages, Shell, and PERL scripts to monitor the growth of the DB and collect statistics.
- Worked closely with C/C++ programmers for developing programs to call the PL/SQL packages
- Troubleshoot DB problems and also involved in Performance Tuning
- Made changes to Oracle Apps Forms and Reports using Designer/Developer for testing purposes
- Used Oracle SQL*Plus tool for running SQL scripts containing statements and qu0eries
- Wrote triggers, menus, and stored procedures in PL/SQL
- Data loading and Extracting function using Oracle SQL Developer.
- Designed and developed all the Tables, Views for the system in Oracle.
- Designed and developed forms, validation procedures for query and update of data.
Environment: PL/SQL Developer, TOAD, C, C++, Java, Oracle Proc*C, Java Database Connectivity (JDBC), SQL Scripts, PL/SQL packages, Perl, Shell scripting, Oracle Forms and Reports.