SUMMARY:

• Around 7years of IT experience indata visualization, data analysis, data transformation and report development with 5+ years of exclusive experience in designing, development, Administration of Business intelligence application using Tableau 9.3/9/8.
• Extensive experience in working with Tableau, SSRS and SSIS.
• Have good understanding of Relational Database concepts and possess strong knowledge in writing SQL queries.
• Experience in Complete life cycle of the Project including Requirement Gathering, Analysis, Design, Development, Testing and Migration.
• Extensive experience working with Business Intelligence &data visualization tools with specialization on Tableau.
• Experience in using SQL Server Integration Services (SSIS)for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.
• Involved in the installation and configuration of Tableau server. Have also configured distributed installation for Improved Performance.
• Created and migrated Workbooks and Dashboards from one environment to another. Have also used Tabcmd commands.
• Well versed with Excel, MS Project, MS Office, MS PowerPoint for creating reports and analyzing data on large datasets using Pivot Tables, Vlookup and conditional formatting.
• Created Users, groups and Domains from Active directory and created different License level for each User. Have taken backup of the server on a regular basis by using Tabadmin commands and have also restored when there was a system failure.
• Extensive experience in working with Relational databases (RDBMS)such as Oracle, SQL Server, HP Vertica, Teradata and MS Access.
• Good skills in testing and debugging and knowledge of ETL procedures and strategies to extract data from different source systems.
• Have used different Mark types and Mark properties in views to provide better insights into large data sets.
• Good usage of Tableau JavaScript APIfor performance improvement of web page.
• Extensive experience in gathering requirements, gap analysis, design, development, testing and implementation of the ETL / Data warehouse projects.
• Hands on experience with Big Data technology like HIVE and implementing Tableau on cloud service like AWS.

TECHNICAL SKILLS:

Reporting Tools: Tableau 9.x/8.x, SSRS

ETL Tools: AVOS Informatica, SSIS

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2014/12/08R2, Teradata 13.0, HP Vertica, HIVE

Languages: T - SQL, PL/SQL, HTML, Java Script

Applications & Tools: MS Suite, ERWIN, SVN, TFS

Utilities: Toad 10.0/9.0, SQL*Loader, Putty, BMC Remedy, HP ALM Quality Center, Rally

PROFESSIONAL EXPERIENCE:

Confidential, MO

Tableau Developer/Administrator

Responsibilities:

• Part of Digital marketing and Analytics team, responsible for buildingcomplex Tableau reports by connecting them to Excel files, Hive/Hadoop, Oracle, MS SQL &HP Vertica.
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Develop, execute and analyze ad-hoc reporting and market research for VOIP and BVOIP services and accreditation to advocate for additional resources, new policies, reverse ineffective mandates for better customer experiences.
• Installed and monitored Tableau server on AWS environment.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client Confidential a glance, also interact with data as necessary
• Delivered dashboards tracking viewership, HUT and Advertising sales for Confidential .
• Created dashboards for System Services Company to measure performance of their field engineers and manufacturer defects.
• Worked with transforming huge volume of data out of and into Hadoop/Hive.
• Automated hive queries to join data from different sources and analyzed the data.
• Involved in integration of TableauJavaScriptAPI Filters in OCX web application.
• Installed patches on server and documented upgrade plan form Tableau 9.0 to Tableau 9.3
• Connected tableau server with SharePoint portal and setup auto refresh.
• Processed large Excel source data feeds for Global Function Allocations and loaded the CSV files into Oracle database with TOAD utility.
• Worked with MasterDataManagement and Published Workbooks and Dashboards to the Tableau server.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Maintained Test log and wrote Test Evaluation and Summary Reports.
• Redesigned the data source having data from different sources into one SQL Server and to tableau.
• Used Tortoise SVN as version control tool.
• Followed the Agilemethodology to implement the application and used rally as agile tool.
• Participated in discussions for Tableau Server architecture design on Cloud, enhancingperformance, scalability and highavailability.
• Dynamic cross-functional team player, fast learner, excellent written and verbal communication skills with strong research capability.

Environment: Tableau 9.3/9, Oracle 11g/10g, MS SQL Server 2014/12,HP Vertica, HIVE, T-SQL,PL/SQL, Toad 10.0, SVN, AWS, MS Excel, Rally

Confidential, IL

Tableau Developer/Reporting Analyst

Responsibilities:

• Performed descriptive and predictive statistics on warehouse data and responsible for different forecasting operations.
• Maintained data integrity and data quality among all the databases across the Teradata platforms.
• Gather requirements from business users, created technical specifications, estimation documents.
• Developed multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, Dual-axes charts, Geo-Maps,Histograms, HeatMaps etc.
• Designed and developed Tableau reports, dashboard and metrics to Support Claims Reporting and Business Intelligence strategy.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Performed Data filtering and troubleshooting of database activities, diagnosed the bugs and logged them in version control tool.
• Performed source data analysis and captured metadata, reviewed results with business. Corrected dataanomalies as per business recommendation.
• Performed the batch processing of data, designed the SQL scripts, control files and batch files for data loading.
• Performed the Data Accuracy, Data Analysis, Data Quality checks before and after loading the data.
• Actively involved in creating a custom portal design hosting Tableau workbooks using JavaScript API.
• Worked on back end ETL process to provide the reporting framework for developing reports.
• Created different Interactiveviews in workbook to visually analyze dataper client requirements.
• Used different Mark properties in views to provide better insights into large data sets.
• Used DataBlending, groups, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Developed and retrieved various Ad-hoc reports for the finance to match on deposit numbers.
• Created customhierarchies and bins for use in Tableau Dashboards.
• Created Dashboards with different Action filters, interactive views, trends and drill downs.
• Involved in creation of groups and users in Tableau server using ActiveDirectory settings.
• Star Schema and Dimensional Data modeling was used in creating data mappings between various data sources to the EDW.
• Participated in daily stand-ups with clients on daily design and development effort.
• Generated reports withSQL queries and prepared test scripts and documented user training modules.
• Worked closely on RCA, Problem Management, Incident Management and Change Management using BMCRemedy tool.
• Extensively involved in doing user acceptance testing (UAT) and generated Test Cases for each specification in Requirement Specification Document corresponding to each module.

Environment: Tableau 8.1/8.0, MS SQL Server 2008/2012, Teradata 13, Teradata SQL Assistant, SOAP UI, BMC Remedy, HP Quality Center 9.0, JavaScript

Confidential, AZ

BI Analyst

Responsibilities:

• Main objective was to work with the business to design the best possible solutionsfrom data warehouse design, ETL, reports, cubes, pivot tables and dashboards.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated.
• Monitored payouts, hit frequencies and revenues using SQL queries, employing root cause analysis to identify issues.Used statistical tests to ensure data quality.
• Created several SSIS packages using advanced transforms, lookups, fuzzy lookups, and script components.
• Created test SQL scripts and provided presentation documentation for review with the business.
• Produced custom, on demand BI reports for the Business Development and Content AcquisitionsTeam.
• Used SSIS in two different projects to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Have setup stand alone and distributed Tableau Server to publish and distribute dashboards easily.
• Created visualizations for logistics calculations and departmental spend analysis.
• Used SQL Queries Confidential the custom SQL level to pull the data in Tableau desktop.
• Improved collaboration between teams by implementing new business process data warehouse models and successfully integrated various business data models into one cohesive model.
• Developed Tableau objects like Filters, Parameters, Calculated fields, Hierarchies, Actions, etc.
• Extensively used Tableau Report Services to generate Report Documents.
• Created calculated fields for comparative reports like claims this year to last year (year to date and month to date).
• Developed reports using Pivot Tables and Excel to track all the infrastructure inventory in a quarterly report.

Environment: Tableau 8.0, MS SQL Server 2008R2, Oracle 10g, SSMS, Sharepoint, DB2, SQL, SSIS, MS Excel, TFS.

Confidential

BI Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
• Experience in writing Ad-hoc queries for Business analysts to extract required daily data, analyzing existing data and performing the data migration.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Worked on everyday tasks and tickets based on priority levels from TFSand saved/updated all scripts related to the tasks in TFS using Visual Studio.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Documented all database objects, procedures, views, functions & packages for future references.
• Organized Error and Event handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers in SSIS.
• Merged Data from Heterogeneous Data stores and Legacy System implementing SSIS on the System

Environment: MS SQL Server 2008R2, T-SQL, SQL BI Suite (SSIS, SSRS), MS Excel, TFS, Putty, Visual Studio.