SUMMARY

• Around 9 years of experience in Data Visualization, Analytics, Data Management, Data Integration, Implementation and Maintenance of Business Intelligence, and the related Database Platforms.
• Extensive experience in Tableau and SAS BI Suite.
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau 9.1,9.0,8.3,8.2,,8.1,8.0, Tableau 7 and Tableau 6.
• Experience in implementing Tableau Online, a SaaS application with the same architecture as Tableau Server that enables cloud implementation of analytics.
• Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
• Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Experience in creating different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables that enable further data analysis.
• Efficient management of Tableau Server by managing & setting permissions, publishing various data sources and workbooks to Tableau Server.
• Expansive experience in preparing dashboards using calculated fields, parameters, actions, groups, sets and hierarchies in Tableau Desktop.
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Experience in administering users, user groups, projects and scheduled instances for dashboards in Tableau Server.
• Created data extracts for improving the performance. Have used different Mark labels and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Good working knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in Oracle, Teradata and MS SQL Server for data preparation and data validation.
• Expertise in creating mapping models to map the business models with the star schema logical database models using SAS Information Map Studio, and store in metadata server that enables business users to readily generate the analytical reports using SAS Information Delivery portal and SAS Web Report Studio.
• Expertise in Unit, System and Integration Testing and performed Data Validation for all the ETL’s and reports generated from various ETL sources.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proven experience in developing ad hoc queries for the business users and providing statistical expertise in the production of datasets, summary reports, tabulations, graphics and listings from the data retrieved from corporate databases and in the analysis of transactional data and data validation.
• Proven ability in gathering customer behavior data from a wide variety of marketing campaign data sources utilizing statistical modeling tools to identify actionable insights for improvement.
• Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading, and building Star schema.
• Strong analytical, logical, communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

BI/Reporting Tools: Tableau 9.0,8.3,8.2,8.1, 8.0, 7.0, Splunk 6.2, SAS Data Integration Studio 4.2/3.4, SQL BI Suite (SSIS,SSAS,SSRS), SAS Enterprise Miner, SAS Information Map Studio, SAS Web Report Studio

Operating Systems: Windows, UNIX, Linux

Relational Databases: MS SQL Server 2005/2008/2012, Vertica, Netezza, Oracle SQL Developer, Teradata, MS Access.

Languages: Base SAS, SQL, PL/SQL, T-SQL, C, HTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Tableau BI Analyst

Responsibilities:

• Created dashboards for Confidential Support Web Community Surveys, Search, Relevancy & Q-Metric Tests, Query Segmentation, Data requests for Advanced Machine Learning Team.
• Created CTR (click through rate) Trend line charts for search terms that belong to the long tail, and search terms with greater frequency for top 8 countries by country that involved a forecasted data range. Integrated all the discrete CTR’s that aggregated different locales by using parameters, calculated fields, and dashboard actions which made the dashboard highly interactive for users.
• Created multitude of bar charts, line charts, waterfall charts, tree maps, geo charts for the communities dashboard that illustrated measures like answer helpfulness and relevancy by term & country, ease of site navigation, likelihood to recommend Confidential, and resolution of tech problem.
• Created Search helpfulness dashboard that encompassed the volume of Search Term and Result document over the origin, results, and destination web page. Created an advanced custom SQL query with lag function and strtok function in Teradata that enabled to retrieve the ratings for different site visits which can correlate to the respective searches.
• Created multiple custom SQL queries in Teradata SQL Workbench to prepare the right data sets for Tableau dashboards. Queries involved retrieving data from multiple tables using various join conditions that enabled to utilize efficiently optimized data extracts for Tableau workbooks.
• Automated an array of Tableau DB’s by creating legacy tables that integrated historical and current data from various data sources (flat files), and updated the workbooks with new data requirements.
• As a member of the Analytics Team, took the ownership of multiple projects on Tableau Server, and was responsible for scheduling, authentication & publishing of various dashboards to Tableau Server and on an internal portal to view these reports.
• Worked in a global team that was highly collaborative, and reported the progress of tasks, new findings, potential opportunities and roadblocks in one-on-one and all hands meetings.

Confidential, Houston, TX

Tableau BI Developer

Responsibilities:

• As a member of the Tableau Build Out team of the Personal Systems Group (PSG), I was involved in developing multiple dashboards for the Personal Systems (Quality) and TCEQ team.
• Developed highly polished executive dashboards for Senior Business Intelligence team. The high end visualizations illustrated the Product Line Performance YoY along with the impact of annual replacement rate on various categories of products in Family Drilldown, Accessories, Raw Repair Data and Product Analysis Tool Dashboards.
• Created views that illustrated the drilldown of a particular family of products with annual goals. Developed Trend charts, Pareto charts, Bubble charts and Pie charts, and actions involving hyperlinks and filters to connect different vizs with in a dashboard and to connect other dashboards which utilize the same worksheets.
• Created waterfall charts to measure the replacement rate, installation base, AIR Impact across various subassemblies in a product line for QoQ, YoY, MoM .
• Created complex calculations to derive ARR, AIR, WIB for a week, month, quarter and year, and created parameters to compare and combine families, change the views layout from rows to columns, and including an array of views to dynamically select a required visualization for downstream data analysis.
• Developed and standardized the best practices in dashboard design and layout in terms of fonts, colors, container selection and size, incorporating the titles and logos in the right places, etc.
• Was involved in migration of the dashboards from Tableau 8.3 to Tableau 9.0 on the Tableau Server. Discovered effective techniques to develop worksheets and dashboards more efficiently in Tableau 9.0.
• Wrote custom SQL queries to optimize the extracts, and heavily relied on data blending as the end workbooks ultimately required multiple fields from different data sources.
• Queried SQL Server, Vertica for data validation along with developing validation worksheets in Excel in order to validate the dashboards on Tableau.
• Have extensively worked in AGILE environment by participating in daily stand up meetings, and Sprint planning at the end of every Sprint.
• Was actively involved in maintenance of dashboards on the Tableau Server by scheduling the refreshes of extracts, authenticating and setting up live connections, administering user access and permissions to the dashboards for various users.

Confidential, Charlotte, NC

Tableau BI Developer

Responsibilities:

• Developed various dashboards illustrating data visualizations using Tableau Desktop
• Performed installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Defined best practices for Tableau report development.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Dashboards using calculated fields, parameters, sets and actions in Tableau Desktop.
• Created drill through reports in dashboard for data analysis of the underlying data.
• Involved in creating data blending in case of merging different data sources.
• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Understanding of relational database structures, theories, principles, and practices.
• Monitored VizQL server, Application Server and Tableau Data server activity to track performance and system availability
• The ability to interact professionally with a diverse group, including executives, managers, and LOB..
• Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, SQL Server 2008.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA’s with Tableau support.
• Developed proof of concept for best practices in Tableau development & deployment, and ad-hoc reporting.

Environment: Tableau Desktop8.0, 8.1,8.2, Tableauserver, Oracle SQL developer, SQL Server 2008, Oracle 10g, PL/SQL, T-SQL,MS Access, Windows 2007 server, Teradata, MS Office 2007

Confidential, Southlake, TX

Tableau BI Developer

Responsibilities:

• Developed executive level dashboards for the Operations Research Consulting group which provides Business Intelligence for different Airlines to implement their decision support systems for developing competitive fares, low fare schedules, optimizing the codeshare data between partner airlines, etc.
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units and the associated data analysis.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports and to analyze the underlying data.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
• Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the POC.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.

Confidential

SAS Data Analyst

Responsibilities:

• Used statistical methods to analyze the consumer behavior, to segment targeted customers, and to identify the customer groups that generate the greatest returns Credit Cards using the customer databases.
• Designed correlation computation, hypothesis testing, and identified candidate predictors for model construction. Supported market segmentation analysis in defining and delivering marketing lists necessary to develop effective marketing strategies and campaigns across multiple channels, customer segments, product/service lines, and geographic markets.
• Worked with huge amounts of data (hundreds of millions of records) and using best practices and efficient SAS programming techniques to optimize the real and CPU times, memory and I/O resources and understanding the efficiency tradeoffs therein.
• Worked with SAS OLAP cube designer to build OLAP cubes in order to facilitate high performance analysis, flexible pre-summarization data and easy reporting of large volumes of customer data with an ability to view trends over time and other dimensions.
• Performed multidimensional data analysis and reports using the cubes to produce reports.
• Maintained large data sets combining data from various sources, and used SAS/ACCESS to extract and create SAS data sets.
• Created complex SQL queries to access the database; generated SAS data sets, and performed data cleaning and preparation.
• Experiencing in data cleansing and benchmarking the metadata jobs in the test environment before releasing to production
• Performing acquisition modeling and validation using SAS procedures including Proc Means, Proc Univariate, Proc Corr, Proc Reg, Proc Logistic, Proc t-test, etc.
• Generated ad-hoc and quality customized reports using Proc Report, Proc Tabulate, Proc SQL and Proc Summary.
• Used SAS/ODS to create HTML, RTF and PDF files that track the operations and evaluate progress toward achieving business goals.
• Participated in meeting with business users to collect specific requirements and document appropriated changes.

Environment: SAS 9.1, SAS/ODS, SAS Enterprise Guide 4.2, SAS Data Integration Studio, SAS Management Console, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, Teradata, UNIX, MS Access, MS Office

Confidential

SAS Data Analyst

Responsibilities:

• Worked with market segmentation, channel management and customer credit groups to benchmark company’s requirements and expectations.
• Created metadata objects by creating the data sources, targets and data transformations using the source, target and process designer of the SAS Data Integration Studio.
• Created Lookup, Fact and Dim tables and Identifying the mapping data into specific domains as per the data model using SAS Enterprise Guide by creating the DATA and PROC steps as process tasks
• Involved in the Administration of the user authentications, metadata repositories, job scheduling, stored processes, data cleansing.
• Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision support systems using SAS Data Integration Studio and publish the same for business users.
• Extensively used DATA NULL, TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOT procedures.
• Created and extracted Oracle tables from SAS and within Oracle by using PL/SQL using SAS/ACCESS and SAS/CONNECT.
• Produced multi-dimensional reports and tables using procedures PROC/REPORT, PROC/TABULATE, PROC/SQL and DATA NULL .
• Perform analysis of data for use in Cross-selling, created graphs using PROC GPLOT, GCHART. Created and updated permanent SAS formats for future analysis and reports.
• Implemented advanced statistical approaches to develop predictive models and profiles.
• Analyzed market characteristics using SAS/STAT procedures that include, Proc Univariate, Proc Reg, Proc Logistic, Proc Cluster, etc.
• Developed and executed approaches regarding segment based analyses and customer value changes;
• Worked extensively in sorting, merging and concatenating SAS datasets under Windows and Unix environments.
• Generated reports using SAS procedures including Proc Summary, Proc Report, Proc Freq, Proc Transpose, etc.
• Created functional specification, user manual and technical documentation.

Environment: SAS9.1, SAS/ODS, SAS Enterprise Guide 4.2, SAS Data Integration Studio, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, PL/SQL, MS SQL Server 2005, Oracle 9g, UNIX, MS Office, MS Access.