PROFESSIONAL SUMMARY:

• 10 years of IT experience in Data Visualization & Report developing, Business Analysis, System Analysis, Data analysis, Software Design, Development, Implementation and Maintenance of Business Intelligence and Data Warehousing Platforms across Airline Services, Banking, Retail, Insurance and Technology domains.
• Certified Tableau Desktop 9 Qualified Associate with extensive experience in Tableau Desktop, Tableau Server, Tableau reader, Tableau Mobile in various versions of Tableau (7.x to 10.x) and Vizql, Teradata, SQL and various ETL tools.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Knowledge on Hyperion planning 11.1.1.3/9.3.1 to support complex financial applications for budgeting and Forecasting.
• Highly Proficient in Agile, Iterative, and Waterfall software development life cycles.
• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Extensive experience on designing database using ER modeling and Normalization.
• Good experience on LOD expressions Comparative Sales Analysis, Customer Acquisitions, etc.
• Hands on experience in embedding Tableau reports and dashboards on external websites using Java API and Java API Scripting.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• In depth understanding of the Gap Analysis i.e., As - Is and To-Be business processes and strong experience in gathering requirements and converting these requirements into Technical Specifications documents.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements.
• Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, custom geo coding, Actions, LOD, Adhoc Calculations, etc.
• Implemented Tableau reports with Asp.Net web applications and extensive usage of JavaScript API for performance improvement.
• Experience in working on generating various dashboards to Tableau Server using different data sources such as Teradata, Oracle, SAS datasets, MS Excel etc.
• Worked on integrating several data sources like BIGDATA, Excel, SSAS, and HADOOP into Tableau reporting.
• Involved in the conversion of SAS code into Teradata SQLs by effectively using Teradata Ordered Analytical functions.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
• Created TDE's using Hadoop as the data source and using Hive and Impala connectors.
• Extensively used Tableau, Crystal Reports, Business Objects, SSRS, Informatica Power Center, SSIS, SQL Server, Oracle, Teradata, Hadoop and Hive.
• Implementation expert in data provisioning from SAP and non-SAP source systems, flat files into SAP HANA and other databases using various ETL tools including SAP BODS and SAP HANA SLT, HANA SDA, SAP HANA Studio.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Good Experience in working on Oracle/Sql Server/SAP HANA databases and worked on complex SQL queries.
• Have strong knowledge of SAP BW, SAP HANA and SAPBusiness Objects Architecture with the ability to design develop and implement Data Warehouse and Business Analytics solutions to support complex business requirements.
• Provided technical assistance in laying out Tableau Data extracts for transaction data residing on SAP BW.
• Resolved issues with Tableau workbooks connecting to SAP BW and Sharing/ Publishing BW source based workbooks.bw
• Expertise in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in developing Teradata databases, manipulating data and making change to dimensions in databases using Teradata Utilities
• Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Alteryx, Informatica, MicroStrategy, Tableau and Database technologies.
• Proficient in writing complex SQL queries, scripts in Python & automating the data pulling from multiple sources by creating Alteryx ETL workflows.
• Used Alteryx for Data Blending and Analytics.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleaning and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Used Python scripts to update content in the database and manipulate files.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Possess strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Analytical Tools: Tableau 10.x, 9.x, 8.x, 7.x (Desktop/Server/Reader/Public/Online), MicroStrategy (Desktop/Server), Google Analytics (Adobe Site Catalyst), SSRS, Business Objects.

Data Integration Tools: Alteryx, Informatica, MS SQL Server Integrated Service (SSIS), OBIEE

Data Modeling /UML Tools: Power Designer, MS Office (Visio, Word, Excel)

RDBMS: Teradata, Oracle, MS SQL Server, DB2, Sybase, Access, SAP HANA, SAP BO, SAP BW

BigData: Hadoop, Spark, Hive, Impala.

SQL Tools: Teradata SQL Assistant, PL/SQL Developer, Toad, SQL Server Management Studio

Service Management: CA Service desk, Lotus Notes

Document Management: SharePoint, Documentum

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Defect management tool: Mercury Test Director, HP Quality center

Scripting Languages: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, SAS and XML

Scheduling Tools: AutoSys, Control M

Operating Systems: UNIX, Linux, Windows 10/8/ 7/XP/2000 and MacOS High Sierra

PROFESSIONAL WORK EXPERIENCE:

Confidential, Memphis, TN

Sr.Tableau Developer /Sr.Data Visualization Analyst

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic
• Maintained and Installed Tableau Server in all the environments.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting usingHyperion Interactive Reports and Financial Reporting Studio.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Customized and developed the OBIEE Business Model and Mapping layer.
• Worked with business users to Gather Business Requirements, converted the requirements to functional and technical specifications for developing the OBIEE Reports/Dashboards.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement.
• Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle, Hadoop and performing data blending in reports.
• Secured Tableau server to protect the Tableau environment, security group and AWS Direct Connect.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Worked in the application UI to present to the end users with Tableau dashboards and visualizations in multiple platforms.
• Implemented AWS security features in Tableau server by providing AWS security features that Tableau Server can use to protect the environment, including Amazon Virtual Private Cloud, Security Groups, AWS Identity and AWS Direct Connect. Architecting Tableau Server is to scale up with more CPU cores and memory and scale out when you add servers.
• Effectively used data blending feature in Alteryx to combine the data from different sources like SAP Lynx, Vision etc. into a single report.
• Used Data Blending and combined Adobe Marketing Cloud data with other aggregated data, to compare and analyze data in different perspective using Alteryx.
• Developed Alteryx modules for big data analysis of geospatial information and SQL queries
• Expertises in writing JavaScript for advanced sorting and hide and show Reports.
• Connected Tableau server with share-point portal, setup auto refresh feature and Embedded Tableau views in to SharePoint using JavaScript to achieve.
• Develop ASP.Net and VB.net application with JavaScript pages to integrate dashboards into a coherent navigation and delivery system.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Experienced on working with Big Data and Hadoop File System (HDFS). Involved in creating Hive tables, loading and analyzing data using impala queries.
• Experienced in running query using Impala SQL, Spark SQL and used BI tools to run ad-hoc queries directly on Hadoop.
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics. Evaluated database performance issues and executed database optimization.
• Developed complex SAS programs, macros for data updates, data cleansing, and reporting. Involved in publishing of various kinds of live interactive data visualizations dashboards.
• Worked with statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses
• Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx.
• Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Hands on experience in Data Blending to merge Various Sources like Teradata, Oracle and Excel Files.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate
• Permission sets for Tableau server logins.
• Involved in Performance Tuning of the database, which included creating indexes, optimizing SQL statements and monitoring the server.

Environment: Tableau 10.5/10.x/9.x(Desktop/Server), Erwin9.1,Hyperion, Teradata, Teradata SQL Assistant, Oracle 11g, BigData/Hadoop, VISIO, JIRA, SAP HANA, SAP BW, SAS, Alteryx, JavaScript, MS Office Suite (Word, Excel, PowerPoint).

Confidential, Santa Clara, CA

Sr. Tableau Reports Developer / Sr. Data Analyst

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Worked in coordination with clients for feasibility study of the project in Tableau and with DB Teams for designing the database as per project requirement.
• Created Users, Groups and projects in Tableau environment.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Gathered data from different data sources like MySQL, Excel, Oracle, MSSQL, Hadoop and Hive etc.
• Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Used different Mark types and Mark properties in views to provide better insights into large datasets.
• Developed dashboards with interactive views, drill downs, and published them to the portal with user level security.
• Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
• Designed and developed Big Data analytics platform for processing customer viewing ps using Java, Hadoop, Hive and Pig.
• Designed Tableau dashboards connected to Oracle Server, SAP BW (Live), SAP BW (extract) and SAP HANA.
• Designing and implementing SAP HANA models (attribute views, analytical views, and calculation views) on the extracted survey data for reports.
• Provided technical assistance in laying out Tableau Data extracts for transaction data residing on SAP BW.
• Helped customer in understanding SAP BW extract limitations and finding a work-around for achieving desired solution.
• Visualized the objects created in SAP HANA using Tableau to demonstrate data and visual analysis.
• Created dashboards for analyzing POS data using Tableau on top of SAP HANA.
• Involved in automation of creating Tableau dashboard throughout the project by writing R script to pull the API data, SAS and R script to populate the data in Teradata and finally developed a custom SQL and essential visualization in Tableau.
• Provided all data analysis, ad-hoc and custom reporting of customer data. This involved extracting da­­ta from an Oracle database, XML files, and Flat files data used as input for SAS programs to create Excel spreadsheets, Access databases, and hard copy reports.
• Involved in campaign planning, contributed by determining the technical feasibility and analyzed the data availability for the segmentation of the specified targeting, using SAS and SQL assistance.
• Used JavaScript API to set and create filters, select and highlight elements in the view, and process the view to retrieve updated data.
• Utilized Alteryx for blending data from multiple databases to create a single source of truth.
• Data Manipulation using Oracle, SQL and automated creation of Tableau Data Extract by creating ETL workflow using Alteryx.
• Creating Scripts to load data from one server to another server using Alteryx.
• Created visual workflows in Alteryx for data blending and analysis using data quality, integration and transformation. ­­­­­­
• Worked on drill through reports by creating HTML s. Created URL filters while embedding the dashboard with a view using JavaScript.
• Involved in developing an ETL strategy to populate the Data Warehouse from various source systems feeds using Informatica Power Center and Teradata.
• Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc. to present users with various scenarios of predictive analysis.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Developed reports to analyze multiple measures using Blended Axes, and Dual Axes.
• Created and updated custom SQL scripts to serve as data sources for various reports and handled performance issues effectively.
• Integrated Splunk with ArcSight to provide ability to look for patterns and relationships across terabytes of data on the FAA/DOT network. The data that is collected by Splunk gives us the capabilities to renitent data for long term and the ability to drill into events and dynamically impose structure to provide metrics and reports.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau 9.x/8.x (Desktop/ Server), Alteryx, Splunk, JavaScript, Teradata, SAP HANA, SAS, Oracle, SQL Server, Bigdata/Hadoop, SSIS, VISIO, MS Office Suite (Word, Excel, PowerPoint).

Confidential, Raleigh, NC

Tableau Developer / Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD).
• Designed data marts to accommodate views/tables (AGG tables) with various calculated metrics from DW (Fact & Dimension) data to suffice source needs for Tableau reporting.
• Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/ data marts.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XLS.
• Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Used SAS to read from and write to another data files formats, including delimited files, DBF, Spreadsheet files and tab files.
• Administer a Splunk Distributed Environment including Index Clustering, Search Head Clustering and Forwarder Deployment Server.
• Evaluate, test and implement major and minor revision releases as they become available from Splunk.
• Ability to create custom Dashboards, Alerts and Reports to meet requirements of various user groups.
• Designed and developed Tableau visualization solutions by connecting to Google Analytics, Oracle and SQL databases.
• Developed custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Designed and developed trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Mentored power users to blend Google Analytics data and Offline data.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Established, maintained and ensured adherence to application standards for data reporting.

Environment: Tableau 8.x (Desktop/Tableau server), Splunk, Google Analytics, SQL developer, SQL 2008, Oracle, MS Access, Windows 2007 server, Java 1.5 platform, Microsoft office Suite (Office, Excel, PowerPoint) 5+.

Confidential, Charlotte, NC

Tableau Developer / Data Analyst

Responsibilities:

• Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.
• Involved in System Analysis & Design of the Enterprise Data Visualization Architecture.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Developing and maintaining high level overview of the data flows using MS Visio
• Thoroughly analyzed the current Architecture, databases and designed schemas on campaign data, the tables/views of which are used as data sources for Tableau reporting
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Involved in Extraction, Transforming and Loading (ETL) data flows to creating mappings/workflows to extract data from Flat File sources and load into DW environment.
• Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop.
• Created Executive Dashboard sourcing heterogeneous sources extracting huge records with decent performance.
• Excellent in performing data transfer activities between SAS and various databases and data file formats like XLS, CSV, DBF, MDB etc.
• Extraction, transformation and loading of data from various file formats like .csv, .xls, .txt and various delimited formats using Talend open studio and sql loader.
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Developed and published customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Defined best practices for Tableau report development.
• Created ad-hoc SQL queries for customer reports, executive management reports.

Environment: Tableau Desktop/ Server, Teradata, Teradata SQL Assistant, MS SQL Server, SQL, PL/SQL, SQL Developer, Control-M, MS Visio, MS Project, MS Office (Word, excel, PowerPoint)

Confidential, Louisville, KY

BI Developer / Data Analyst

Responsibilities:

• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Conducted Requirement walk-through meetings with key stakeholders.
• Performed detailed requirement analysis and created data mapping documents
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Actively participated in Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
• Built complex SQL queries to validate ETL/Reporting code in Teradata and Oracle.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
• Developed test cases and test plans for unit and system tests for new or modified programs and job streams.
• Involved and guided/mentored other team members in their problem-solving efforts.

Environment: Tableau Desktop/Server, Teradata 12/13, Oracle 10g/11g, Informatica 8/9, Power Designer, TOAD, Micro Strategy 8/9, Autosys, UNIX, MS VISIO, MS Office.

Confidential

SQL BI Developer

Responsibilities:

• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Created calculated fields, mapping, hierarchies and Drill through Reports by extracting the Data from Teradata and SSAS Data sources.
• Extensively used Informatica Power Designer to pull the data from various data bases and integrate the data.
• Design, Create and Monitor workflows using workflow designer and workflow monitor.
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Identify & record defects with required information for issue to be reproduced by development team.

Environment: Teradata, Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatica, MicroStrategy, Erwin, DB2, HP Open View, Lotus Notes, Windows XP, MS Office Suite (Word, Excel, PowerPoint).