SUMMARY:

• Over 8 years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server and efficient in connecting various data sources.
• Strong experience using Tableau Server, Tableau Desktop and Tableau Public.
• Involved in installation of Tableau desktop 10.2 and above, Tableau server Application software and in server migration from 9.0 to 10.4/10.5.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration. Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.)
• Expertise in Automation of backup and logs maintenance on Tableau server.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background.
• Involved in creating Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality. Dashboards and stories as needed using Tableau Desktop and Tableau Server.
• Involved in integration of Tableau JavaScript API Filters in web application
• Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Extensive experience working on cross database joins, unions extracting data/connecting live to data source.
• Worked on the development of Dashboard reports for the Key Performance Indicators KPI for the top management.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Design and development experience of reports and dashboards in Tableau using data in Hive (Hadoop) using Hive ODBC.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle database, SQL Server, Sybase database.
• Creating New Schedule's and checking the task's daily on the server.
• Experience in Production and Technical Support activities and managing production rollouts
• Worked on multiple projects from requirement gathering to training end - users
• Involved in writing detailed as well as high level documents for reports and repository design
• Identifying and removing bottlenecks in order to improve the performance of dashboards and reports.
• Writing and reviewing technical documentation like functional specifications, design specifications, project standards, test plans and test scripts, product documentation.
• Experience troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements
• Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Good Knowledge on other BI tools like QlikView, Microsoft Power BI, Tibco Spotfire.

TECHNICAL SKILLS:

BI Tools: Tableau 10.x/9.x/8.x, Datastage 8.x, Oracle Business Intelligence Enterprise Editions 10.1.3.x, Microsoft Power BI , DOMO

Languages: SQL, UNIX Shell Scripting.

Databases: Teradata v15/13/12, SQL Server 2000/2005, Sybase, MS Access, Oracle 9i/11i

Operating Systems: Linux (Red Hat) AS4, Unix, WINDOWS 95/98/2000/NT/XP, 7, 8, 10

Dimensional Modeling: Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables

Application Software: MS Word, MS Excel, MS Access, MS Power Point.

Other Tools/utilities: Sybase Squirrel client Oracle TOAD; Teradata Utilities: SQL Assistant, BTEQ; DataStage Suite: Designer, Director, JSON.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey city, NJ

Sr. BI/Tableau Developer

Responsibilities:

• Analyzed business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Converted Legacy Reports to Tableau dashboards connecting to SQL server.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content Viewed by customers in each category including interaction between the two charts for drill down analysis.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau Desktop which added more user friendly navigation and drill-down features.
• Creating the data sources for the required reports.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, Gantt charts, Bubble charts, Word maps, Geospatial visualizations etc.
• Created URL Actions to navigate from one Dashboard visual to another Dashboard for a smooth eye-catching presentation along with using Tableau Data Extracts for better performance on rendering the visualizations.
• Creating basic calculations including string manipulation, basic arithmetic calculations, custom Aggregations and Ratios.
• Effectively used data blending feature in Tableau when there were more than one database involved.
• Generated Tableau reports with Trend lines.
• Defined best practices for Tableau Report development by adhering to style guidelines and making visual pop-out.
• Working with Business Analysts to streamline any data issues which involve Unit Testing of all the worksheets.
• Handling change requests and providing support/maintenance for deployed projects.
• Creating the data sources for the required reports.
• Experience on KPI (key performance Indicators) in Tableau.
• Involved in Client interaction when further clarifications are needed.
• Tableau server performance tuning and optimized extracts for Tableau dashboards.
• Resolved the performance issues of the Reports.
• Publishing the applications in Tableau server.
• Blended data from multiple databases such as MS Excel and SQL database by assigning primary key from each database.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created URL's, Hyperlinks in dashboards

Environment: Tableau Desktop, Oracle, SQL server, Excel, Windows Server 2008, SQL/SSIS/SSRS/SSAS/Power BI Developer

Confidential, Atlanta, GA

Sr. Tableau Developer

Responsibilities:

• Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
• Deep experience with the design and development of Tableau visualization solutions.
• Extensive experience with the design and development of Tableau visualization solutions.
• Worked with ETL team (DWH) to extract data into Tableau using custom SQL to filter data source
• Solving P1 issues for the users in the production.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Built and maintained Microsoft Server 2012 R2.
• Installed and maintain Microsoft SQL Server 2016 to a Microsoft Server 2012 R2.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved actively in coding PL/SQL based on business requirements.
• Implemented row level security for the tableau dashboards and used various advanced table calculations
• Developed various reports using freehand SQL for Inventory Management and Innovations team in accordance with Business Strategies
• Involved in troubleshooting, optimizing, fine-tuning SQL queries and debugging for efficiency
• Involved in documentation, review, analysis and post production fixes while adhering to the defined SLAs
• Design and development experience of reports and dashboards in Tableau using data in Hive (Hadoop) using Hive ODBC.
• Extracting data into tableau through BIGSQL from Hortonworks Hadoop Data Lake.
• Developed POC tableau visualizations connecting to servers like Hortonworks Hadoop Hive, Confidential BIGSQL

Environment: Tableau Desktop 10.0/9.3, Oracle10g/9i, Crystal Reports, SQL Server 2008/2012, MS Visio, MS Excel.

Confidential, Sacramento, CA

Data Analyst/Tableau Developer

Responsibilities:

• Created adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau adhoc reports.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Took backup of the Tableau server on regular basis by using Tabcmd, Tabadmin commands also developed restoration procedures to restore the server during system failures.
• Created users, groups, security roles and SSL authentications.
• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# code as required.
• Perform Code review of Stored Procedures and prepare for database build steps for weekly change cycle.
• Extracted data from SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Support and resolve any issues that occur with SSRS and SSIS packages that run daily.
• Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues.
• Troubleshoot and resolve various database processes impacting production and provide root cause analysis to prevent and/or improve upon daily transactional throughput.
• Created reporting process (SSRS) for management to get timed reports on various database counters pertaining to resource consumption.
• Automated KPI metrics reporting using Visual Studio Team.

Environment: Tableau Desktop 9.2/8.0, Oracle10g/9i, Crystal Reports, SQL Server 2008/2012, MS Visio, MS Excel.

Confidential, Rosenberg, TX

ETL Informatica Developer / SQL developer

Responsibilities:

• Worked closely with project Business Analyst, Data Architect and ETL Developer to ensure that the end to end designs meet the business data requirements.
• Develop ETL strategy using Informatica PowerCenter application including Mappings, Maplets and reusable transformations
• Develop test plans for ETL processes and fine tune Informatica Sessions and ETL processes consisting of complex SQL
• Implemented ETL Informatica designs and processes involved in enabling loading of data from the sources to the target warehouse.
• Perform administrative tasks using Admin Console (Version 8.1.x).
• Responsible for data cleansing process and for setting up the rules for customer matching using Trillium software with Informatica
• Involved in performing extensive GAP as there were numerous 'As-Is' and 'To-Be' conditions in the project.
• Extracted data from various sources like SQL Server, data files, Oracle by the use of data blending and joins.
• Translating business requirements into Business Object Reports and Dashboard design -Communicated with stakeholders, business groups as well as participated in meetings and user group discussions.
• Involved in creating New Schedule's and checking the task's daily on the server.
• Scheduled data extracts on a daily basis.
• Developed SQL scripts to Insert/Update and Delete data in the database tables
• Created Stored Procedures for implementing business logic
• Consolidate multiple data silos that exist on campus to one location.
• Extensive Backup and Recovery procedures using Full, Differential, Transactional backups.
• Work on improving standard DBA procedures and document SQL DBA team best practices for primary and offshore teams.
• Configured server memory for maximum performance and effective utilization.
• Tune database processes and fine-tune maintenance procedures based on application behavior.
• Resolve issues with Clusters (2 Node Active/Passive). Process log of various daily backup jobs to ensure backups are current for disaster recovery events.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Good experience on using EDI library on Informatica Data Transformation.

Environment: ETL: Data Warehouse, Informatica 8.1.1, HP UNIX, Sun Solaris Oracle 9i, 10g,MS Office 2007/2010, T-SQL, SQL Server Team Foundation Server (TFS).

Confidential

SQL Developer

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005.
• Implementing Load Balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, P erformed Uploading of bulk data migration with BCP Utilities.
• Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000, SQL Server 2005. T-SQL, Windows Server, HTML, VBScript, JavaScript, Access.