Anvesh

510-***-****

adlbm1@r.postjobfree.com

BI/Tableau/Power BI Developer

Professional Experience:

A qualified IT professional with 8+ years of extensive experience including 5+ years of experience as Tableau and

3 years of Power BI Developer. 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, Microsoft Excel as Developer in various companies.

Professional Summary:

Involved in creating dashboards and reports in Tableau 2019.x/2018.x/10.x/9.3/8.1/8.2. Created report schedules on Tableau server.

Expertise in Banking, Financials, Automotive and Retail domains.

Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Expertise in Data Extraction, Transforming and Loading (ETL) between different Systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP).

Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools.

Expertise in design and development of Power BI graphical and visualization reports as per business requirement documents (BRD).

Experienced in creating Databases Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency.

Extensive experience in Tuning SQL queries & improving the performance of the Database.

Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.

While design the Power BI reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.

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.

Proven Power BI development experience with desktop and pro versions, familiarity with Direct/Power Query functionality within Power BI.

Experience developing and supporting Microsoft BI and reporting capabilities (Power Pivot, Power BI, data mapping, Power View, and SSRS) &implementing enterprise software solutions.

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.

Administered user, user groups, and scheduled instances for reports in Tableau.

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.

Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts, and bullet chart.

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.

Involved in the process of data transformation from Oracle to Hadoop

Worked with Spark Developer to solve issues in SQL/Impala Queries for compatibility like indexing, functions, views, and tables.

Worked on multiple BI tools like QlikView, Power BI, and SAP BO.

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 10.5/9.0/8.2/8.1/8.0/7.0, Cognos 8.4, QlikView 10.0, SAP BO, Power BI

Visualization Tools

Tableau 10.5/9.0/ 8.3/8.2/8.1/8.X/7.X, Qlik Sense, Power BI

Web Technologies

XML, HTML.

IDE

TOAD, SQL Developer, HQL

Languages

Java, C, PL/SQL, MSSQL, Hadoop/Impala, HQL

Work Experience:

7-Eleven, Irving, TX Apr 2020 — Till Date

Role: Sr BI/Tableau/Power BI Developer

As part of 7-Eleven my role was to develop key metrics reports for all stores in USA, Canada. Created numerous Tableau Dashboards defining KPI's, Network Stability, Real-time Sales, and Ticket Performance system.

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.

Built and published dashboards with both Extract & Live connected data source. Created different refresh scheduling for each data source.

Embedded a dashboard to JavaScript and made some live dashboards.

Designed a dashboard that is easy for the clients to use and also 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 we 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 SSIS packages to handle both manual and incremental loads with proper partitions and schema variations.

While design the Power BI reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.

Involved in designing, developing, and testing ETL strategy to populate the data from various source systems feeds using SSIS.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

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.

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.

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.

Effectively used data blending feature in Tableau when there were more than one database's involved. Wrote basic custom SQL for tables with the help of DBA and basic joins for back-end level of data blending.

Involved in performance tuning of targets, sources, mappings, and sessions.

Environment: Tableau Desktop 2018.x/2019. x, MS SQL Server 2008 R2, SQL Server Management Studio, MS Excel, Tableau Data Extract (HYPER), MS Access, Tableau Server 2018.x/2019.x, Power BI, SSIS.

Synchrony Financial, Chicago, IL July 2019 – Mar 2020

Role: Sr BI/Tableau/Power BI Developer

Synchrony Financial is a consumer financial services company headquartered in Stamford, Connecticut, United States. The company offers consumer financing products, including credit, promotional financing and loyalty programs, installment lending to industries, and FDIC-insured consumer savings products through Synchrony Bank, its wholly owned online bank subsidiary. Created dashboards with several action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau and Power BI.

Responsibilities:

Developed several parameterized dynamic dashboards, scorecards, with drill down and drill through capabilities.

Worked with Hadoop database by connecting to Impala/Hive 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 in Data asset Inventory to gather, analyze, and document business requirements, functional requirements, and data specifications from sources SQL / Hadoop.

Worked with various data sources like Excel, CSV files, Flat files, Access Database, MySQL, Oracle tables.

Involved in the process of data transformation from Oracle to Hadoop.

Designed a dashboard that is easy for the clients to use and to analyze their growth and predict the requirements for the future.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.

While design the Power BI reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.

Experience in Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.

Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Generated the weekly, monthly, and quarterly reports by using SSRS, MDS.

Identified and worked with Parameters for parameterized reports in SSRS.

Proficiency in creating Ad-hoc Reports, Drill-Down, Drill-Through, Cascaded, Matrix, Sub-reports, Pie Chart Reports and Tabular Reports for different business domains depending on the specifications and requests.

Analyzed various metrics including forecast accuracy, gaps, presentation levels, and products sold activity.

Good experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.

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/Hive 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/Hive Queries for compatibility like indexing, functions, views, and tables.

Designed, Coded, Tested, Implemented Stored Procedures to get data for the reports.

Environment: Tableau Desktop 2018.x, Hadoop/Impala, Linux, Unix, MS SQL Server 2008 R2, SQL Server Management Studio, MS Excel, Tableau Data Extract (HYPER), MS Access, Tableau Server 2018.x, Power BI

Client: Gap, San Francisco, CA Oct 2018 – June 2019 Role: BI Developer

Involved in reviewing business requirements and analyzing data sources form SQL Server /Excel for design, development, and analysis projects within Tableau Desktop.

Responsibilities:

Created Tableau scorecards, dashboards, Heat maps using show me functionality.

Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked with various data sources like Excel, CSV files, Flat files, Access Database, MySQL, MongoDB, Oracle tables.

Worked with MongoDB by using MongoDB BI connector.

Created multiple dashboards by using MongoDB both by Live & Extract connection.

By connecting at user level, we used to get data from data from the assigned databases by passing certain conditions while sign in.

Developed several parameterized dynamic dashboards, scorecards, with drill down and drill through capabilities.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.

Developed, executed, documented, and maintained appropriate BI procedures.

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

While design the Power BI reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.

Published Power BI Desktop reports created in Report view to the Power BI service.

Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.

Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.

Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Generated the weekly, monthly, and quarterly reports by using SSRS, MDS.

Designed a dashboard that is easy for the clients to use and to analyze their sales and predict the requirements for the future.

Worked closely with all teams within the organization to understand business processes, gather requirements, understand complexities, and end goals to come up with the best plan of execution.

Environment: Tableau /2018.x10.5, MSSQL Server, Power BI, MS Access, MS Excel, MongoDB, Tableau Data Extract (TDE), Tableau Reader, Tableau Server 2018.x/10.5

Client OPT Integrated Solution, India Feb 2014 – Jan2016

Role: 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. Utilized Explain Plans to analyze and SQL Hints wherever required.

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.

Developed Various Reports in GL, AP and AR and customized them using XML Publisher.

Customized existing Dunning Report and Invoice Printing Report in Accounts Receivables using XML/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 database's involved. Wrote basic custom SQL for tables with the help of DBA and basic joins for back-end level of data blending.

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, TOAD, SAP BO, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER.

Client: ATG, Hyderabad, India Nov2011 – Jan 2014

Role: SQL/BI 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 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, Java, Oracle Database Connectivity (JDBC), SQL Scripts, PL/SQL packages and stored procedures, Perl, Shell scripting, Oracle Forms and Reports.

Educational Details:

Bachelor of Technology in Electronics and Communication Engineering (2011) affiliated to JNT UNIVERSITY, HYD.

Masters in Master of Science in Information Technology & Management (2018).

Contact this candidate