SUMMARY

• 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.
• Involved in creating dashboards and reports in Tableau 2020.x/2019.x/2018.x/10.x/ 9.3/8.1/8.2. Created report schedules on Tableau server.
• Expertise in 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 withDAXformulae 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.
• 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.
• Extensively worked with large databases in Production environments, UAT, and DEV environments.
• 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.

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.

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

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Lead BI/Tableau/Power BI Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server.
• Assisted in development of data formatting and cleaning criteria from various data sources.
• Performed ad hoc analysis of data sources for all external and internal customers.
• Formulated procedures for data extraction, transformation, and integration of health care data.
• Converted, cleaned, analyzed, organized, and documented large data files (10,000 - 30 million records).
• Conducted assessment to ensure data quality and completeness with validation techniques.
• Developed several parameterized dynamic dashboards, scorecards, with drill down and drill through capabilities.
• 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.
• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and SQL joins for applications.

Environment: Tableau Desktop 2020.x, Teradata, SAS, MS SQL Server 2008 R2, SQL Server Management Studio, Tableau Server 2020.x, Power BI.

Confidential, Irving, TX

Sr 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.
• Built and published dashboards with both Extract & Live connected data source. Created different refresh scheduling for each data source.
• 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 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.
• Effectively used data blending feature in Tableau when there were more than one database involved.

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.

Confidential, Chicago, IL

Sr BI/Tableau/Power BI Developer

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 inData asset Inventoryto 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

Confidential, San Francisco, CA

BI Developer

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.
• 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.

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

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. 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 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 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.

Confidential

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.