Suraj Kumar Email & Phone Number

Matthews, Nc, Us

Pella, Ia 50219, Usa

Responsibilities:• Work on end-to-end analytics tasks for multiple business critical projects by developing comprehensive product reporting, identifying KPIs for executives, designing and developing data flows on SSIS and reporting via Tableau.• Work with the various lines of businesses i.e., E&I, C&S and M&R to learn, discuss and finalize the logic calculation and KPIs for enterprise reporting. • Build report prototypes using sample medicalclaim data for dashboard design signoffs. • Querying MapR Hadoop Hive node for data sets. Develop dashboards for various lines of businesses for enterprise reporting.• Develop, test, implement and support end-to-end (data extract to data at rest) data integration solutions. Create, modify and deploy database schemas, queries, sub queries, joins, views, indexes, stored procedures, triggers and sequences using PL/SQL, T-SQL in the Production to integrate with the web application.• Translate client needs into usable mapping and coding instructions. Create and automate SSIS packages, stored procedures and create mockups and actual dashboards for reporting in Power BI in Azure platform.• Part of SME pool to support the Production team to help developers, testers to resolve the production defects. Manage project plans and schedules. • Manage resolution of project issues and conflicts throughout the System Life Cycle.• Manage the implementation of an end-to-end solution of a Tableau dashboard for detailed analytics for a Pharmacy Benefit Management system to gather the everyday Pharmacy (Rx) work and develop the comprehensive automated KPI dashboard to enable leadership to track the daily claims processing performed by the agents.• Implement LOD’s, metrics, filters, drill down the level of detail, reports, dashboards and create advanced chart types, using calculations to manipulate the data, to provide all the critical medical.

New Jersey, United States

Responsibilities:• Undertook end to end analytics tasks for multiple projects by developing comprehensive product reporting, identifying KPIs for executives, designed data models on MS Visio through, and storytelling via Tableau dashboards.• Translate client needs into usable mapping and coding instructions and created mockups for reporting.• Developed a comprehensive product dashboard for a sourcing platform to track activity of users by setting up a fully automated ETL script using Alteryx Designer to load data from an FTP into an Oracle Datamart, blending it with the sales data sources and finally writing them to Tableau Server, to build interactive dashboards.• Use MS Excel and Access to process the data, create reports/dashboards in Tableau, analyze metrics, implement verification procedures, and fulfill client requests for information. Automate the existing Excel, Access reports using Tableau/Power BI.• Master the ability to design and deploy rich graphic visualizations with Drill down and drop-down menu option and parameters using Tableau. Create, support Tableau hyper files and maintain the extract refreshes.• Configure email subscriptions on Tableau Server for the Tableau Dashboards based on the business needs and modified the dashboard to match the end user expectations.• Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python scripts.• Embed interactive Tableau reports, dashboards into web pages using Java Script.• Developed a detailed functional dashboard by setting up unit and system test environments for a virtual application to enable data pull from the device user interface, automated the data files into Amazon’s S3 system, included device metrics by setting up automated workflows using Alteryx designer and designed a tableau dashboard through data discovery and dashboard prototyping, followed by bug testing and data validation .

Austin, Texas, United States

• Synthesize and translate Business needs into creative and meaningful data visualizations in Tableau.• Designed website performance dashboards on Adobe Analytics, tracking user behavior using heat maps on tools like Lucky Orange and scheduled aggregated data extracts to be fed into Tableau dashboards.• Forecasted sales data including accuracy rates by the type of forecast models into a Tableau dashboard containing outputs from machine learning algorithms stored in Oracle, which drove high priority business decisions.• Implemented a KPI Health dashboard by blending complex data sets from Sales data, Heap (user behavior), Dynatrace monitoring tool, Adobe Analytics and ServiceNow to showcase health of digital KPI metrics for leaders• Assisted product owners in the development of KPI frameworks to enable the visualization of utilization, satisfaction and impact related metrics, by detailed documentation of requirements, data sources, targets and insights.• Built report prototypes using sample data, querying databases for data sets, scan data log files, enable performance recordings, and set up logical databases on Amazon Athena and Oracle to allow data querying of raw data.• Actively troubleshooted the performance issues, optimizing the data source build created using Tableau Prep which were associated with Tableau reports.• Develop Tableau workbooks from multiple data sources using Data Blending through Alteryx.• Design and built ETL workflows resulting in system integration and business intelligence source table from multiple data sources. Implemented an efficient migration process to move ETL objects from development to test and from test to production environments.

Greensboro, North Carolina, United States

• Worked with business team and stakeholders to understand the functionality and business requirements.• Designed, developed, and tested an interactive Tableau Story which is used as a presentation deck for an enterprise level IT Leaders meeting.• Created TDE (Tableau Data Extract) for most of the Projects and Scheduled Refreshes on Tableau Server for Hadoop Hive Data Lake.• Converted the existing SSRS reports to Tableau Dashboards with drill down and interactive visual reports on Hive data lake. Enhanced the custom SQL queries to improve the Dashboard performance.• Alteryx is used to develop various ETL activities, including importing Ascii-delimited and fixed text data, cleanse and map data, build lookup tables, update key information, and verify converted data.• Designed and developed a Tableau Server usage report for track the usage metrics to identify frequently used reports/dashboards and to monitor Server health.• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the groups and scheduled instances for reports in Tableau Server.

Hyderabad, Telangana, India

• Gathering requirements from business users for the development of Tableau visualization solutions.• As part of the agile process attended the scrum calls and daily catchup meetings to discuss the updates.• Added value by providing innovative solutions and delivering improved methods of data presentation by focusing on the Business need and the Business value of the solution.• Partnered with peers internal and external to the team to access and recommend opportunities to derive additional Business Value out of existing Data Marts.• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill-Down, Cross Tab, Master Detail and Formulae, etc.• Provide guidance and insight on data visualization and dashboard design best practices in Tableau.• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.• Developed complex reports using Business Objects WebI Rich Client &Crystal Reports Enterprise having Parameter/Formula fields and selection Formulas, Grouping and Sub reports.• Created extract files for improving the performance. Built reports in Tableau using advance functions like LOD, Parameters, Sets, Groups and Quick table calculations.• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data using Java Script API.