SUMMARY

• 6+ Years of Experience in Information Technology as a Tableau/SQL/ Confidential in creating, developing, analysing highly interactive data visualization reports and dashboards using concepts like Data blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures, etc.
• Having Strong Experience on multiple business domains like Pharmaceutical ( Confidential & Company), Health Care (CTCA - Cancer Treatment Centres Of Americas), Product Based (Citrix Systems), Financial (BMO Harris Bank), Logistics (Pregis Corporation), Product and Service based companies like (Xprudent Corporation) and (Shastra Confidential ).
• Expert in understanding of dimensional data modelling, Strong SQL optimization capabilities, Metadata management i.e., Connections, Data model and VizQL model.
• Highly skilled in Tableau Desktop/Server in creating data visualization, Reporting and Analysis.
• Expert in building Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trials and Density Chart.
• Expertise in designing and creating various analytical reports and dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Hands-on experience in troubleshooting, Performance tuning of dashboards, Tableau worksheets and resolving issues within Tableau Server and dashboards.
• Hand on experience in administrative tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Created and updated scheduling tasks analysed and resolved performance and served based issues.
• Experience in creating aggregates sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Experience with Relational Databases like SQL and Confidential Server environments.
• Worked on Migration project from SQL Server to Confidential Big Query ( Confidential Cloud).
• Wrote instructions guide for end-users how to use Tableau and created many Ad-Hoc reporting and Dashboards on the fly based on the User requirement.
• Used Alteryx to changed unstructured to structured data for better Tableau reporting and data analysis.
• Experience in integrating Alteryx and Tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on the server though Web data connector into Tableau Desktop.
• Investigated multiple data issues and fixed them for the better functionality and accuracy of the data.
• Using R-Programming and Python for effective analysis and Visualization in order to create an advanced level of Visualizations.
• Having the ability to handle multiple tasks simultaneously and to complete assignments given, aggressive in time constraints with giving high-quality work to my team.
• Can work individually with minimum guidelines from stakeholders and finish the tasks assigned by the business users to meet the deliverables in a timely manner.
• Conducted Internal Tableau to team members. Assisted with side by side for business users and new employees and conducted cross- for co-workers.
• Designed and developed Tableau content for the Users and co-workers for a better understanding of each concept.

PROFESSIONAL EXPERIENCE

Sr. Tableau / Azure Cloud Developer

Responsibilities:

• Interacted and engaged with business users to meet their immediate and future needs.
• Designed, developed, built, tested and maintained Tableau Analytics and functional reports based on user requirements.
• Created different KPI's using Table calculations and calculated key figures manipulating strings, arithmetic calculations, aggregation options and logical functions.
• Worked extensively with advance analytics like lines and bands, trend lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Developed Tableau workbooks to perform YTD, QTD, and MTD type of analysis.
• Extensively used advance chart visualizations in Tableau like dual axis, Box Plots, Bullet Graphs, Tree Maps, Bubble charts, Waterfall charts, funnel charts etc.
• Assisted business users in solving complex problems. Familiarity with best practices around visualization and design.
• Developed, published customized interactive reports and dashboards and managed report scheduling using Tableau.
• Published reports/dashboards on Tableau server and created & managed tableau server groups and permissions.
• Mastered in different formatting techniques, using annotations and mark labels.
• Developed effective and interactive dashboards using Parameters and Actions.
• Strong dashboard design experience with less performance issues in dashboard and passionate practitioner of effective data visualization.
• Provided production support to Tableau users and wrote custom SQL to support business requirements.
• Published and shared views on Tableau server, scheduled extract refresh and subscriptions
• Involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
• Develop simple/complex SQL queries, query tuning for data preparation for reporting.
• Written Complex queries in KQL (Kusto Query Language) to analyse the data in Confidential Azure.
• Built interactive dashboards in Azure AppInsights,
• Used Alteryx to extract the data from Azure App insights and loaded the data into Relational Database.

Environment: Tableau Server 2019.2, Tableau Desktop 2019.2, SQL Server 2016, Confidential Azure AppInsights, Azure Cloud, KQL (Kusto Query Language), SQL Scripting, Alteryx, Ms Excel.

Sr. Tableau Developer

Responsibilities:

• Having Extensive Experience in Agile Methodology
• Able to proactively give suggestions on the reporting data and come up with Poc’s where business can choose the best way, they wanted to look at the reports.
• Prepare Mock-ups and present them to the team and take feedback from the team and make suggested changes and finalize the Dashboard design.
• Used Tableau Desktop tool for building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboards color coding and formatting, Tableau designs, prototypes and Tableau mock up reports and Wireframes.
• Frame works, Design documents (HLD, LLD), Data mapping documents and reporting.
• Created actions to navigate from one dashboard to another dashboard and also created URL actions to navigate dashboards of tableau server based on parameters.
• I have designed and built various reports & dashboards activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau.
• I have also created reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
• Having good ability to design and deploy rich Graphic visualizations with Drill Down and DropDown menu option and parameterized using Tableau.
• Designed the converted the Tableau dashboards for the Devices like I-Pad’s, I-phone’s and Android Phones.
• Created, maintained, modified, and optimized SQL Server databases, database security, and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Created Sets, Groups and Data Bins as per user requirements. Created various views in Tableau like Treemaps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Creating Multiple Dashboards using SQL as a source and reducing the Performance Issues in the Tableau dashboards with Live connections with the Data Source.
• Having knowledge on Tableau Prep.
• Extensive experience creating Ad-Hoc Reports in Tableau Desktop.
• Exposure to Full Life Cycle Solution Development (Requirement gathering, Analysis, Design,
• Experience with Customer Relationship Management and Sales Force Automation systems such as Confidential .com to see detail level of customer data.
• Expertise supporting Tableau Server Environments (Production, Development, Self-Service), Tableau dashboards and web authoring.
• Developed different types of reports like tabular, matrix, drill down and drill through for different sales management hierarchies.

Environment: Tableau Desktop 2018.3 v, Tableau Server 2018.3 v, Jira 7.2 v, SQL Server 2016, SSIS, SSRS, SSAS, T-SQL, PL-SQL, R-Programming, Alteryx, Confidential, Confidential Excel, Power Pivot, V-Lookup.

Tableau Developer

Responsibilities:

• Responsible for creating and maintaining the Confidential Services, Managed care reports in Tableau Dashboards.
• Created Tableau dashboards for the commercial operations and media Investment and showing the trends in the dashboards for the Business model of CTCA.
• Designed Tableau dashboards as per the client requirement by using SQL database as a source for the data.
• Build standard reports and also able to work on ad-hoc reporting to deliver the projects with high accuracy and integrity within specific timelines.
• Created actions to navigate from one dashboard to another dashboard and also created URL actions to navigate dashboards of tableau server based on parameters.
• I have designed and built various reports & dashboards activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau.
• I have also created reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
• Used appropriate formatting headers, worksheets with different visualization color coding for showing non-cluttered view in dashboards.
• Created side by sidebars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Creating and managing groups, users, workbooks and projects as a part of administrator work, experience with tableau upgrade, backup and restore of Dashboards.
• Reduced the performance issues of the dashboards by several new techniques even though by using multiple sources to build the dashboards.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Confidential, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Having strong experience in HRIS and Develop and maintain HR-Talent Reports and Dashboards.
• Created multiple dashboards for HR and Talent team using SAP BO and Workday as a data source.
• Worked and having good knowledge of (SAP BO) Business Objects in designing & creating Web Intelligence, Dashboards, and Scorecards.
• Used Alteryx data-blending and scheduling tools to reduce weekly reporting time from 50 man-hours to 10.
• Experience in integrating Alteryx and Tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on the server though Web data connector into Tableau Desktop.

Environment: Tableau Desktop 10.4, Tableau Server 10.4, Adobe Analytics, MS Excel, V-Lookups, H- Lookups, SQL Server 2016, Pivot and Power Pivot, Visual Studio 2016, SSIS, Confidential, Alteryx 11.3, Workday, Taleo, SAP BO.

Tableau / Data Analyst

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively using data blending feature in tableau.
• Executing and testing required queries and reports before publishing.
• Having good ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and parameterized using Tableau.
• Working on the Confidential Big Query ( Confidential Cloud) migration project.
• Migrating all the SQL Database tables to Confidential Cloud.
• Designed the converted the Tableau dashboards for the Devices like I-Pad’s, I phones and Android Phones.
• Extensively working on SSAS (CUBE) for Connecting to Tableau and to extract the data from the Cube.
• Created SSIS Packages to reduce the performance issues in the Tableau Dashboard.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Responsible for the overall solution design from the data collection to visualization
• Hand on experience in administrative tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• I have developed, tested, implemented VBA program to reduce reporting from +60 mins to under -5 mins.
• I have worked on Automation of Financial manual processes by writing VBA code and used macros and formulas to speed up the processes and maximize accuracy.
• Created macros using Excel VBA to automate manual tasks in an Excel spreadsheet.
• Experience in creating aggregates sets Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Managed data into several analytical data models and designed star schema for dashboards.
• Created extract files for improving performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Moved files between the filegroups and partitioned the tables to improve the performance of Dashboard.
• Executing and testing required queries and reports before publishing.
• Using Advanced Excel functionalities like V-Lookup, Power Pivot.
• Creating Multiple Dashboards using SQL as a source and reducing the Performance Issues in the Tableau dashboards with Live connections with the Data Source.
• Experience with Customer Relationship Management and Sales Force Automation systems such as Confidential .com to see detail level of customer data.

Environment: Tableau Desktop 10.2v, Tableau Admin Roles, SQL Server 2014, SSIS, SSAS, SSRS, Confidential Excel, Power Pivot, VBA, V-Lookup, T-SQL, R-Programming, MDX, Alteryx, Confidential, Confidential Big Query ( Confidential Cloud).

Data Analyst / Tableau Developer

Responsibilities:

• Interacted with the Business users and Business Analyst for requirement gathering.
• Participated in the daily stand up meetings as part of an Agile process for reporting the day to day developments of the work done.
• Going through Report Specification Documents and Understanding the User requirements.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created of dashboards for business groups like finance and sales. Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins, and action filters.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Created Sets, Groups and Data Bins as per user requirements.
• Created various views in Tableau like Treemaps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based on data content.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with the huge volume of data.
• Created views using various axes like Individual Axes, Dual Axes, and Blended Axes.
• Used Trend Lines, Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input control to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis. Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created story showing the performance of each sales rep since sales territory assignment.
• Developed different types of reports like tabular, matrix, drill down and drill through for different sales management hierarchies.

Environment: Tableau Server 10.0, Tableau Desktop 10.0, SQL Server 2014, BIDS, SSRS, SSIS, MS Access, Ms Excel.

Data Analyst / Tableau Developer

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Having good ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.
• Created side by sidebars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analysing statistical billing data using Tableau 10.0.

Environment: Tableau Desktop/Server 10.0, Confidential, Confidential SQL Server 2014, Custom SQL, Confidential Visio, Windows OS.

Confidential

Master’s Degree / SQL Report Writer

Responsibilities :

• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot, and Power BI point.
• Used Confidential Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Created Report Snapshots to improve the performance of SSRS.
• Analysed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handling.
• Developed various Charts and graphs like bar chart side by side, stacked, line graphs, pie -charts, etc. by using chart expert of Crystal Reports.
• Rebuilt Indexes and Tables as part of performance tuning exercise.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.
• Created SSIS packages to populate data from various data sources.
• A created story showing the performance of each sales rep since sales territory assignment.
• Developed different types of reports like tabular, matrix, drill down and drill through for different sales management hierarchies.
• Set up subscriptions for automatic delivery of reports to the appropriate business teams.
• Written complex stored procedures to achieve the business logic required for displaying data in SSRS reports.
• Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and tracks on the update of versions.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Monitoring SQL server performance using Profiler.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Helped in writing T-SQL Scripts for database backup jobs and daily/weekly jobs.

Environment: Confidential Power BI Power, Crystal Reports, MS SQL Server 2012, SSIS/SSRS, T-SQL, SharePoint Server, Erwin, DTS Designer, MS Office 2013.

Confidential

Data Trainee Engineer

Responsibilities:

• Involved in requirement analysis, Design, Development, and Testing of the application.
• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2008, and MS Access databases.
• Involved in Partitioning tables that have bulk inserts, deletes, and updates to improve the performance.
• Extracted data from XML and flat files using SSIS. Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security, and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing verification. Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long-running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created a test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2012, Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.

Confidential

Jr. Embedded Engineer

Responsibilities:

• Gained knowledge on IR and worked on it for controlling any home appliances, in industrial Applications by controlling the loads and by varying the speed of the motor.
• I have done controlling the loads through IR communication in which an IR transmitter And IR receiver are used.
• Having Extensive Knowledge on IR transmitter what we use here is the ordinary remote of 38khz frequency and IR receiver is TSOP.
• I have worked on the loads to control through the buttons from the remote.
• I have worked on the stepper motor which is used for position control in applications such as disk drives, dot matrix printers, industries, manufacturing companies and robotics.