SUMMARY

• Around 8 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 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.
• 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.
• 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.
• Expert 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.
• 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.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, Houston, TX

Tableau 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 dashboards that contained high end visualizations which 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 viz, etc.
• 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, Southlake, TX

Tableau BI Developer

Responsibilities:

• Developed executive level dashboard prototype for the Operations Research Consulting group which provides BI 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.
• 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.
• 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, Charlotte, NC

Sr. Tableau Developer

Responsibilities:

• Developed various dashboards illustrating data visualizations using Tableau Desktop
• Proven experience in 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.
• Created drill through reports in dashboard.
• 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, Jersey City, NJ

Tableau Report Developer

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Performed SQL reporting with the ability to create SQL views and wrote SQL queries.

Environment: Tableau Desktop 7.0, Tableau Server 7.0, Oracle SQL Developer, Oracle 10g, Teradata, Microsoft Office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential, Reston, VA

Business Intelligence and Reporting Developer - Tableau

Responsibilities:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom SQL queries to import data from sql server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, PL-SQL, TSQL, UNIX, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service

Confidential

SAS Developer

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 test, and identified candidate predictors for model construction.
• Supported market segmentation 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 EDI Developer

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.