SUMMARY

• Over 8+ years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations of various functionalities of Data Visualization, Data Archiving, Data masking and Business Intelligence
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau
• Skilled in Tableau Desktop for Data Visualization, Reporting and Analysis
• Experience in creating and implementing dynamic/interactive charts, graphs, and other user interface elements using Tableau.
• Extensive experience working with Tableau as a dashboard developer, administrator and SME.
• Strong expertise in developing a high performance dashboards with Story points and Advanced calculations
• Expertise in project management of schedules, resource planning, dependency management, risk analysis, and issue resolution
• Functional and domain experience with Financial, Investment, Insurance, Telecom and Commercial applications
• Experience in configuring reports from different data sources using data blending
• Experience working in Amazon Web Services (AWS)
• Experienced on Tableau Admin activities, Multidimensional database and SQL
• Strong expertise in design and development of BI applications using Cognos, BOBJ 4.0 Suite, Tableau.
• Experience installing, upgrading and configuring Tableau Server for high - availability
• Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication
• Data modeling, data visualization, dashboard development using Cognos, BOBJ suite, Tableau
• Experience with T-SQL in writing triggers, indexes, tables, views, data integrity, user defined functions and relational database models
• Had experience in working in different environments as well as with the various process like Agile and Waterfall Methodologies

TECHNICAL SKILLS

Operating Systems: UNIX, WINDOWS 95/98/ NT/ 2000/2003/2008/ XP/7

Automation Tools: Autosys

Business Intelligence Tools: Tableau (7.x/8.x/9.x/10.x), Tableau Server 7.x/8.x/9.x/10.x, Crystal Reports, Splunk, Spotfire

Cloud Technologies: Amazon Web Services (AWS)

Web Technologies: ASP, HTML, DHTML, Java Script, VB Script, and XML

Database: ORACLE, MS SQL Server / 2008, DB2

Programming Languages: Visual Basic, VB Script, C, SQL, PL/SQL, R, Java Script, XML, PHP, JSP, and Java.

GUI: Visual Basic 5.0/6.0, VB.Net, ASP, ASP.Net, Developer2000

Other skills: MS Word, MS Excel, MS Access, MS Project2000, MQ Series, MS Visio, JIRA, PVCS, Serena

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential, NJ

Responsibilities:

• As a lead, gathered requirements and transformed the business to Data Visualization using Tableau
• Developed Executive Landing Page Dashboard and allowed Power Users to navigate dashboards of different functional units upon action
• Transformed raw data to Visual Analytics and showcased the key KPIs for wide range of business units such as Sales, Product Solutions, Customer, Inforce, Campaign, Claims, PFMC Events, Marketing and HR
• Developed Data source and Dashboard mapping by auditing server using TWB Auditor
• Created a Custom Admin View Audit TDE by selectively capturing historical events of User Traffic by connecting to Workgroup Database and successfully developed a customized Admin View Dashboard to monitor user traffic to Projects, Workbooks and Views
• Successfully created Tableau Semantic Metadata Dashboard and allowed users to Audit Metadata for 60 plus in house Tableau Data Sources
• Successfully developed Tableau Data Sources with improved performance to serve the needs of multi-functional units
• Accelerated Financial standard report development and forecasting reports as per the business requirement
• Successfully Blended the raw data from Oracle and SQL Server and created Data Source for Visual analytics
• Optimized Tableau Data Extracts and Workbooks Using Performance Analyzer (Power Tools for Tableau) and enhanced the performance
• Developed and maintainedRfunctionality for visual and statistical analytics
• Created Autosys JILS and successfully trigger Automation of TDE Refresh and subscription schedules
• Executed Tableau Doctor Session to business users, resolved the challenges and suggested the best practices
• Used Advanced functional features like LOD Calculations, parameters, actions, table calculations, representations which are not available in Show Me like Donut, Waterfalls and Pareto charts
• Successively initiated the data sources release using PVCS and Serena Dimensions and monitor the version control
• Followed SCRUM methodology, met the challenges and produced a value added Tableau Product
• Played a role of Admin in Tableau Customer Portal and monitor the license distribution for Tableau Content Developers

Environment: Tableau Desktop (9.x/10.x), Tableau Server (9.x/10.x), SAS, Hadoop, Flat files, SQL Server, Spotfire, Oracle, Excel, DB2, windows, PVCS, Serena (Dimensions), JIRA, Version One, Autosys.

Tableau Developer

Confidential, CA

Responsibilities:

• Developed a reports using KPI and allowed the business users to take key decisions
• Created a TDE s, published to Tableau Server and scheduled a Incremental refresh
• Created custom SQL to meet the requirements and shared the Tableau Data Source with end users
• Analyzed the data, performed the transformation and developed a analysis showcased the Story points
• Collected data from different data sources for building the data mining database
• Manage the application’s users, groups, and integration with Active Directory
• Experience in taking back ups and restoration of Tableau repository
• Developed reports in Tableau by connecting to various data sources like MS SQL Server, Oracle, MS Excel and CSV)
• Synchronized and audited the AD Groups
• Generated ad-hoc Tableau reports based on user requirements.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports
• Combined multiple data sources by joining tables and using Data Blending
• Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports
• Worked on groups, sets, different calculation functions including Table calculations
• Created dashboards with the security using filters for the clients to measure cost saving
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified
• Designed and developed Business Intelligence end to end solutions using Tableau
• Published Workbooks by creating user filters and security, so intended teams can view it
• Developed tableau dashboards with combination charts for clear understanding
• Build complex calculations using advanced functions
• Created visualizations in Tableau using Excel data extract source
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively

Environment: Tableau (8.x/9.x), SQL Server, Teradata, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel).

Tableau Developer

Confidential, TX

Responsibilities:

• Creating and managing schedules for users, performing maintenance activity for servers.
• Created Custom Dates, made the visualization dynamic and allowed the users to drive the representation using Yearly, Quarterly and Monthly.
• Ensured Table Calculation and created Control Charts with Standard Deviation distribution and allowed users to pin point the Outliers.
• Created Extracts, published data sources to tableau server and scheduled Incremental Refresh.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields, spotlighting to compare and analyze data in different perspectives.
• Created sets/groups to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs along with user level security.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.

Environment: Tableau Desktop 7.1, 7.2 Tableau Server 7.1, 7.2, SQL Server, Oracle, DB2, windows.

SQL Developer

Confidential

Responsibilities:

• Created stored procedures, scripts, views in Oracle database design and create SQL database, tables, indexes, and views.
• Created user defined functions, stored procedures, triggers, and suggested creating clustered and non-clustered indexes on tables for performance improvement.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing, fine tune complex SQL queries and stored procedures to increase performance.
• Extensively used XML documents to pass multiple parameters for stored procedures to read and write database table.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Worked on DTS Package, DTS import for transferring data from Oracle and lotus notes.
• Worked as a developer in creating complex stored procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, instances, linked servers and indexes.
• Created parameterized reports for the clients, based on requirements using SSRS and deployed reports on to the server for the end users.

Environment: MS SQL Server 2008, SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence tools, Windows 2003, SQL Server Query Analyzer, Oracle 8i, SQL Profiler, Crystal Reports.

SQL Developer

Confidential

Responsibilities:

• Involved in Optimization and normalization of database and tables
• Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement
• Performed query plans and making sure each and every query is using appropriate useful Indexes.
• Created and Modified T-SQL Stored Procedures/Triggers for validating the integrity.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS
• Packages
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using
• Report Designer as well as Report Builder.
• Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, de-normalized models, handling slow-changing dimensions/attributes
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS
• Scheduled Backups and performed Restore operations for system test data

Environment: MS SQL Server Management Studio 2005, T-SQL, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS)