Ajeet Kumar Email – adklrd@r.postjobfree.com

Sr. BI/Power BI/ Tableau Developer Phone – 872-***-****

Over 10 years of IT experience in software Analysis, Design, and Development in fields of Databases, Business Intelligence, Client Server Technologies and Web-based applications.

5+years of extensive Tableau Experience in Enterprise Environment, in Tableau 2019.2/2018.1/10.1/ 9.0/8.0 as a Developer and Admin.

Expert in Data Visualization development using Tableau to create complex, instinctive, and imaginative dashboards.

Proficient in all periods of the Report improvement lifecycle, including necessities get-together, Design, Development, System Testing and User Acceptance & Support.

Worked with SAP Technical Architect, BI team and other functional teams on solution designs, business warehouse strategy and end-to-end testing

Designed visualizations of new high-impact visual applications to make data actionable and facilitate decision making for the clients

One year of Data Preparation experience with Alteryx

Familiarity with Tableau’s JavaScript API

2+ years of experience in development of Tableau API’s using Javascript and Python

Working with product teams to provide subject matter expertise throughout the production implementation of visually oriented products and applications.

Experience using Tableau’s JavaScript API

Proven capacity to deliver and guarantee achievement in high-weight/high-hazard circumstances.

Defined best practices for Tableau report development.

Good comprehension of ideas for example, Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, & Dimensional Tables.

Involved in making dashboards and reports in Tableau 8.2, 9.3 & 10.4/2018.1 Made report plans on

Tableau server.

Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9 desktop/Server.

Created Python-MATLAB integration that saved 3 hours per week for the business analyst team.

Worked on moving Tableau Dashboard from Development to Production Live Environment.

Worked broadly with Advance investigation Actions, Calculations, Parameters, Background pictures, Maps, Trend Lines, Statistics, and Log Axes. Groups, chains of command, Sets to make point of interest level synopsis report and Dashboard using Tableau's Advanced Capabilities.

Experienced with ETL tools like Informatica, SSIS, SSRS, SAS.

Expertise in Tableau Desktop development, inconvenience shooting, report design, execution tuning, determining issues and distributed dashboards, exercise manuals in Tableau server

Expertise in ASP.NET Development alongside SQL Scripting and Stored Procedure.

Specialist in planning Universes and creating complex and Ad hoc Reports utilizing the Business Objects Reporter/Desktop Intelligence and Web Intelligence Tools

Extensive experience in modeling and developing logical/physical data models using entity relationship modeling tools like ERWIN

Developed perspectives using advanced calculations like channels, Parameters, Actions, Table computations, Logical estimations, date figuring, and Trend Lines.

Designed Tableau Data Extracts for improving visualizations perform better.

Strong learning and comprehension of SQL and capacity to write SQL queries.

Good Working Knowledge in Agile Project administration (Scrum process)

Data Visualization Tools:

Tableau 8.0, 9.2, 10.3, 2019.2, Tableau Server v9/v10/v2019.2, High Charts, High Maps, MS Office, Excel, Business Objects, Alteryx 11

ETL Tools:

Talend, Informatica, Data Stage, Microsoft SQL Integrated Services

Structural Databases:

Sql Server, SAP HANA, Teradata, Impala, Netezza IBM, Orcale, Hive, MS Access, MariaDB, IBM DB2,MySql, MS SQL Server, Teradata,Oracle, Python.

Document Management:

Share point, Confluence page, TFS, Ultra Edit

Data Modeling:

Toad, ERWIN Data Modeler, ER Studio, Erwin

Operating Systems:

Windows/Mac

Quality Tools:

HP Quality Center 10.0, Jira, Rally

Web Tools and Cloud Technologies

HTML, XML, AJAX, JavaScript, Schemas.

AWS, Azure, Python.

Testing API:

Junit, Python, R, Alteryx 11.0

Bachelors Degree in 1997

Vizient- Chicago, IL Jun 2020 - Present

Sr. BI/Power BI/ Tableau Developer

Responsibilities:

Provide performance management and tuning

Develop in a number of BI reporting tool suites

Provide technical oversight to consultant partners

BI development for multiple technical projects running in parallel

Participate in development and implementation of product roadmap

Create technical blueprints and solution architecture diagrams

Troubleshoot and resolve incidents

Tableau APIs: Javascript API, Document API

Work closely with ETL developers, DBA’s and other BI developers

As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company .

Created Python-MATLAB integration that saved 3 hours per week for the business analyst team.

Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices, Alteryx 11.0.

Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across same and various data sources .

Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard. .

Excellent SQL skills for daily testing of data using various SQL queries.

Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.

Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.

Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.

Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions .

Maintain and develop effective actuarial reports of historical performance, including core performance triangles

Independently creates or assists in the creation of tracking performance metrics

Create business intelligence tools or systems. Assist in design of related databases

Create ETL/ELT to translate and structure data into a model that makes visualizations render in less than 2 seconds

Act as the liaison between Business Stakeholders, Developers, Infrastructure teams and project management groups

Mentor other developers for support of newly created reports

Provide performance management and tuning

Develop in a number of BI reporting tool suites

Provide technical oversight to consultant partners

BI development for multiple technical projects running in parallel

Participate in development and implementation of product roadmap

Create technical blueprints and solution architecture diagrams

Troubleshoot and resolve incidents

ENVIRONMENT: TableauDesktop2019.2/2018.3, Tableau server/Administrator, SQL developer, Impala SQL, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.

COTIVITI, Atlanta, GA Jan 2019 – May 2020 Role: Sr. Tableau and Alteryx/Power BI Developer

Responsibilities:

Involved in working with Analytics team to volunteer Semantic layer development project.

Transforming the data 6000+ tables from TERADATA to SAP HANA and need to define the columns with high levels and generate views in teradata and using toad to validate the data.

Alteryx was used for Data Preparation and Tableau for Visualization and Reporting.

Working on modifications to develop dashboard for Boeing global services (BGS) & Boeing commercial frighters (BCF).

Investigating some metrics & especially consumption logic for SMEs.

Working on various metrics like purchase order on-time to need, PO cycle time, uplanned demand/short flow, warehouse receiving backlog, top impacting suppliers, sales order, inventory(bin & receipt inventory quantity)

Developed data models on top of existing views in SAP HANA and documented the objects as per SOX Compliance.

Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting

Upgraded Tableau Server from 10.4.0 to 2018.1. SKILLS

Work with Business investigators and SME’s and get requirements.

Designed Tableau dashboards and reports that summarize data for Pricing, Shipments, Deliveries, Sales, Purchase Orders, Customer Partner Functions, & Inventory metrics.

Experienced working in data integration, reporting & dashboard development, data modeling and KPI Analysis.

Worked on SAP HANA views and procedures for complex scenarios helped customer developing dashboards and business-related changes in data staging or extension/reduction in a data model.

Adhoc data cleansing and standardization using Alteryx

ENVIRONMENT: TableauDesktop10.4/9.3, Tableau server/Administrator, SQL developer, Impala SQL, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office, SAP HANA Studio, Teradata, Sql Assistant, Toad, TFS, Alteryx 11

JP Morgan, Chicago, IL Jul 2017 – Dec 2018

Role: Sr. Tableau Developer

Responsibilities:

Upgraded Tableau Server from 9.3.0 to 10.4.0

Leading the complete lifecycle of visual analytical applications, from development of mock-ups & storyboards to complete production ready application.

Created various Tableau dashboards for Bidding Platform team to enhance Impressions, Clicks, Requests, CPM, Spend, Fillrate etc.

Worked with the solution architect on a day-to-day basis.

Ensuring product quality through unit testing, system testing and continuous integration.

Investigating new technologies and continually updating technical knowledge and skills.

technologies (e.g. TibcoSpotfire, Qlikview, etc.)

Hands on experience in JavaScript, & HTML5.

Created Tableau workbooks from multiple data sources using Data Blending and publishing reports using Tableau Server.

Developed Live dashboards using web data connectors.

Generated data driven alerts to key people users when data reaches important thresholds.

I used SQL, Cloudera Hadoop and Hive, Apache SOLR, MapReduce, Amazon Redshift.

Used Impala to analyze the partitioned and bucketed data and compute various metrics.

Written multiple Imapala Queries to extract data for extraction, transformation and aggregation from JSON &other compressed file formats.

Scheduled extract refresh and subscription.

Also involved in administration tasks like creating and managing sites, setting permissions, managing ownerships and distributing access to the users using user filter and adding them to the definite group.

Involved in creating complex Stored Procedures, triggers, cursors, tables and views and other Impala SQL joins and reports for applications.

Experienced in open source tools like Highcharts, Highmaps & Highstocks.

Use of Java Script for making the customer side approvals in the website pages with dashboards

Use of Java script for installing the dashboards on the pages.

ENVIRONMENT:TableauDesktop10.4/9.3, Tableau server/Administrator, SQL developer, Impala SQL, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office and Java script, Confluence, High charts

Lucid Technologies, Irving, TX Jan 2016 – Jul 2017

Role: Sr. Tableau Developer

Responsibilities:

Gathering necessities and comprehension the source systems to actualize DW/BI

Data Analysis and giving proposals to higher administration.

Present the investigation to inside and outer groups and Explain information from a business point of view and importance to Key Performance Indicators (KPI)

Extracted data from the database using SAS/Access, SAS/SQL procedures to create datasets.

Interacted with Business Analysts and Data Modelers and characterized Mapping reports and Design process for different Sources and Targets.

Developed and audited SQL questions to validate data.

Using Tableau extract to perform offline investigation.

Blended data from different information sources by utilizing connecting component as a part of Tableau Desktop.

Developed perspectives using modern counts like Table estimations, Logical computations, date figuring, and Trend Lines.

Developed Views and intelligent Dashboards using Parameters, Filters, Actions, Bar/Bullet/Dual Axis graphs, Area/Geo/Heat maps, scramble plots/Bubble Charts and so forth, in Tableau Desktop.

Developed various Views and consolidated them into Dashboards for intelligence by giving Quick Filter and Parameters to further information penetrating ability.

Creating Users, Groups, Projects, Sites, and Permissions in Tableau Server.

Working on creating different dashboards in Tableau server utilizing different sources.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including specialized bolster, investigating, report plan and checking of framework use.

Presenting training to Business users in using tableau.

ENVIRONMENT: Tableau 8.x/9.x, Amazon EC2/S3, Windows 7, MS Access, SAS, SQL developer

First Data and Spirent, Dallas, TX May 2011 - Dec 2015

Role: Tableau Developer

Responsibilities:

Assisted as Business Systems Analyst meeting due dates and spending plan prerequisites.

Prepared task reports for administration and helped the project manager in the improvement of week by week and month to month status reports, strategies and methods

Broadly used Visio to make Use Cases Diagrams, Activity Diagrams.

Improving and keeping up abnormal state diagram of the venture and configuration streams utilizing MS Visio.

Worked on Business Intelligence standardization to create database layers with user-friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.

Analyzed dimensional and truth tables in a crusade data mart that points of interest Inclusion, rejection and Segmentation criteria, Offer task and battle reaction by battle.

Creating and altering Business Intelligence diagnostic reports using Tableau.

Used geographic perspective, which plainly gives the execution of a specific state.

Migrated every one of the reports, dashboards, and scorecards from Tableau 8.0 to Tableau 9.0 in the wake of testing the form on Sand Box.

Created different activities in database like channel activities to send data to other tableau worksheets and to interface the same in scientific streams, URL activities to associate views of information to outer assets and Highlight activity to give rich visual connection between the perspectives on the sheet.

Designed business intelligence dashboard utilizing Tableau Desktop and distributed the same on Tableau server, permitting official administration to view present and past execution deals patterns at different geographic areas.

Worked on Performance tuning of report with tremendous questions using simultaneous inquiry execution for better execution of report.

Responsible for day by day interchanges to administration and internal associations with respect to status of every single appointed projects and tasks.

Use MS Excel, Word, and Power Point to process information, make reports, implement measurements, actualize confirmation strategies, and fulfill client requests for information.

ENVIRONMENT: Tableau 8.2/8.1,8.0,7.0, Tableau Server, Tableau 7.0/8.0, Teradata 13.10, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica

PROFESSIONAL SUMMARY

TECHNICAL SKILLS

EDUCATION

PROFESSIONAL SKILLS

Contact this candidate