SUMMARY

• Around 10+ years of experience in IT industry as Developer with Tableau with strong background in Databases and Data warehousing concepts.
• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online.
• Experience working on interactive dashboards with Filtering, highlighting, LOD expressions and worked on joins and blending multiple data sources.
• Extensively used parameter actions to drive reference lines.
• Strong understanding of advanced Tableau features including calculated fields, table calculations, row - level security, R integration and dashboard actions.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems, all in one dashboard.
• Worked on newer versions 2019.x, 2018.x and fluent with new features like button filters, dashboard extensions, Tableau Cataloging, explaining data and tableau server management add on.
• Experienced in developing and implementing a BI solution for sales, product and customer KPIs.
• Strong knowledge in designing and developing complex reports such as Sub-Reports, Parameterized Reports, Drill-Down Reports, Drill-Through Reports and Snapshot Reports in SQL Server Reporting Services (SSRS) and deploying to end users through Data-Driven subscriptions and SharePoint Server.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Built dashboards for measures with forecasts, trend line and reference lines.
• Ability to introduce Tableau to Client, to produce different views of data visualizations, and provide expert advice in the interpretation of data in for reporting in various business domains.
• Strong experience in Trouble Shooting, Performance optimization of dashboards and resolving issues within source data and reports.
• Experience in Designing and deploying AWS solutions using EC2, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling groups.
• Experience in migrating the existing BI system to the AWS cloud and Redshift.
• Deployed SSRS/Tableau monthly reports and applied business rules to maintain the data security and integrity prior to the disclosure of the information. Gathered and prepared the requirements from clients for product design and enhancement.
• Proficient in using multiple data sources - Oracle, SQL Server, Teradata, SAS datasets, CSV files & TDEs
• Implemented SSIS packages to extract data from Excel spreadsheets to SQL Server, automated all of the SSIS packages and monitored errors.
• In-depth knowledge of the HIPAA security Rule and other government technology laws
• Familiarity with FISMA, HIPAA, and NIST guidelines
• Used security on dashboards to comply with HIPAA regulations
• Experienced in writing SQL Queries using joins, derived tables, sub-queries, and correlated sub queries for validating data on reports and for generating data extracts to suffice source data requirements in Tableau.
• Created Parameterized Reports and linked reports and thorough knowledge of report server architecture using SSRS
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server Reports Services.
• Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle, SQL), Teradata, MS Access and client/server applications.
• Used Alteryx to provide analysts the unique ability to easily prep, blend, and analyze all of their data using a repeatable workflow.
• Used Python libraries like NumPy and SciPy to filter unstructured data.
• Used combination of Python and R for predictive analytics.
• Experience in analyzing using statistical methods such as Z-score, Linear Regression, Lognormal Regression, Polynomial Regression and Moving Averages.
• Experience working with Bloomberg Terminal for Bond Pricing, Trends Visualization, Back test, Relative Rotation Graph, Data Extraction.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau Desktop, Tableau Server, Tableau Online, Microsoft Power BI, SAP Business Objects, Crystal Reports, AlteryxOperating Systems: Windows, MAC OS LINUX/UNIX.

Databases: MS SQL Server, Oracle, Bloomberg Terminal, Teradata, MS Access, SAP HANA, SAP TERP10, AWS S3 Bucket, Snowflake Schematic T-SQL, PL/SQL

Document management: Airtable, Share point

Project Methodologies: Agile (SCRUM), Waterfall, Iterative

Other Tools: Oracle Crystal Ball, MS Excel for Financial Calculation, Ready Ratio, Financial Statement Analysis

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover for reporting and analysis projects within Tableau Desktop.
• Experienced in design and development of Tableau visualization solutions and creating business requirement documents.
• Used user filters and custom access levels to enable security on Tableau server and Tableau desktop to in corporate HIPAA standards for security
• Involved as a technical expert, in providing input to application design regarding production tuning and administration requirements.
• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Deployed SSRS/Tableau monthly reports and applied business rules to maintain the data security and integrity prior to the disclosure of the information. Gathered and prepared the requirements from clients for product design and enhancement.
• Worked Closely with different Product owners to get more business insights.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refreshes for the weekly and monthly dashboard reports on Tableau Server.
• Used Groups, hierarchies and sets to create detail level summary reports and dashboards using KPI's.
• Experienced in SQL performance tuning and writing complex SQL queries.
• Proficient in creating New Schedule's and checking the task's daily on the server.
• Worked extensively with Advance Analysis Actions, LODs (FIXED, INCLUDE, EXCLUDE) Calculations.
• Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Developed reports for MicroStrategy Web users.
• Debugged the ETL packages by using breakpoint in SSIS.
• Connected to the AWS Redshift directly from Tableau10.4 to access cloud data warehouse and quickly perform visual analysis.
• Connected Tableau to various databases and performed Live data connections, query auto updates on data refresh.
• Created, developed and deployed multiple drilldown and drill through reports by using SSRS.
• Developed, deployed and monitored SSIS packages. Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Desktop/Server Reports.
• As per business requirement, designed developed and maintained MicroStrategy based reports.
• Worked with AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Deployed and created tableau dashboards and data source refresh on tableau online using tableau bridge client.
• Upgraded the MicroStrategy 8.0.1 version on Windows to the 9.0.1 Version on UNIX.
• Experienced in planning and implementation of overall analytics and business intelligence strategy.
• Worked on an Alteryx fed AJAX enabled, browser based, system that was consolidated to the extent that one core group of logic reported on hundreds of tables in one, simple to use and intuitive user interface.
• Experience in integrating Alteryx and tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on server though Web data connector into tableau Desktop.
• Developed complex T-SQL codes such as Stored Procedures, functions, triggers, Indexes and views for various applications.
• Analyzed user and business requirements, attended periodic meetings for changes in the application requirements and documents.

Confidential, Boston, MA

Sr. Tableau Developer

Responsibilities:

• Experienced in creating Prototypes, Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI).
• Modeled User filters to enable the row level security in tableau within client's premises.
• Assembled Advanced Analysis actions and created Interactive Dashboards using Tableau 10.4.
• Transformed all the existing tableau dashboards from 10.3 to 10.4 based on the tableau server requirements of the client.
• Involved in project status meetings, QA review meetings, and System Test meetings.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu options and Parameters using Tableau.
• Ability to execute end to end compliance risk assessment and monitoring & testing program management.
• Fabricated User filters to enable the security of Tableau dashboards within client premises.
• Engaged in publishing the developed reports to production Tableau server environment.
• Improved Report performance in tableau using extracts and context filters.
• Installation of Tableau desktop and Tableau server on AWS Virtual private Cloud on EC2 instance.
• Created report schedules, data connections, projects and groups in Tableau server.
• Worked on troubleshooting issues that are encountered during the testing cycles.
• Accessed and transformed massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Ensured data integrity, compiling charts, graphs and reporting views in Tableau and PowerPoint, and publishing/distributing the final monthly version for enterprise wide consumption.
• Worked on creating report schedules, data connections, projects, groups in Tableau server. creating custom admin views to monitor tableau server activities on periodic basis.
• Created reports involving Multiple Data providers, Merged Dimensions, Synchronization, Combined Queries and Sub queries.
• Performed security implementation to Tableau server reports based on user community.

Confidential, St Louis, MO

Sr. Tableau Developer/Data Analyst

Responsibilities:

• Created report schedules, data connections, projects, groups in Tableau server.
• Created incremental refreshes for data sources on Tableau server.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created and modified Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Created reports for users in Tableau by connecting to various data sources (MS SQL Server, Oracle, MS Excel, Netezza, .CSV).
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Reviewed complex SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Well versed with the usage of variables to make the packages dynamic and scheduled the package in SSIS (sequential scheduling).
• Migrated data using different SSIS packages and integrated data into the data warehouse.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly, with the usage of quick filters for on demand information.
• Monitored VizQl server, Application Server and data server activity to track performance and system stability.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions with stakeholders and business groups.

Confidential, Baltimore, MD

Data Analyst/Tableau Developer

Responsibilities:

• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Integrated R with Tableau and utilized Reserved package to perform deep statistical analysis
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Used level of Detailed Functions, Trend Lines, Statistics and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Administered documentation of Infrastructure, Architecture, Network, conduct audit of events, troubleshoot issue and educate users
• Created User filters to enable the row level security in tableau within client’s premises.
• Created Interactive Dashboards and Advanced Analysis actions using Tableau 9.2/9.1
• Converted all the existing tableau dashboards from 9.1 to 9.3 based on the Tableau server requirement of the client.
• Create customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Created stack bars, bar graphs, Heat map, Gantt charts, Bullet Chart, Spark Line with alert mechanism

Confidential, McLean, VA

Data Analyst

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Analyzed the data using statistical features in Tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL.
• Performed functional testing of the application.
• Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement.
• Created dashboard using parameters, sets, groups, and calculations.
• Created visualizations with multiple measures and dimensions.
• Involved in creating of data blending in case merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in creating calculated fields, mapping, actions, and hierarchies.