SUMMARY:

• Results driven professional with over 7+ years of full - lifecycle software development projects. Able to quickly understand the goals of the business and break complex issues into manageable components. Broad experience in developing IT Solutions for business requirements, functional / technical specifications and Code Components.
• Over 7+ years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server, Power BI Desktop, Power Service, Power BI Mobile and Data Analyst efficient in connecting various data sources.
• Around 4+ years of extensive data analyst, Tableau Experience in Enterprise Environment, in Tableau 10.5 and latest versions as a Developer and Admin.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 10 desktop/Server.
• Developed Tableau Data Extracts from the above mentioned data sources using Pentaho Data Integration ETL tool.
• Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Experience in writing Calculated Columns, DAX Measures, and Queries in Power BI desktop to show good data analysis techniques.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Design.
• Experience in deployment of Business Objects and Web Intelligence from various Sources oracle, Teradata, Ms Sql Server.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and sequel server reporting services (SSRS).
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility, SQL and Hive, Apache SOLR, Map Reduce, Amazon Redshift.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Used Chrome Developer tool and other testing tool to do the debug.
• Experience in conducting performance testing on applications using HP Load Runner and automated functional testing using SOAP UI and automated UI Testing using Karma.

TECHNICAL SKILLS:

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2

BI Tools: Tableau Desktop, Tableau Server, Tableau online, Tableau Public, Tableau Reader, Power BI Desktop, Power BI Service, Power BI Mobile, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services(SSIS)

Databases: SQL server, Oracle 8i,9i,10g, Teradata, SAP Hana, Redshift

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: MS-SQL, MySQL, hive, HTML5, CS3

Web Servers: Apache web server, Microsoft IIS 4.0, Jboss 6.4

OS: Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools: Microsoft Project, Microsoft Office, Microsoft Excel

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

Tableau Developer

Roles & Responsibilities:

• Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.
• As Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Solving P1 issues for the users in the production.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Experience in administration activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Server.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Analytic support for the company’s marketing campaigns; by predicting areas of promotion.
• Identify areas of opportunity to improve ROI of marketing activities by analyzing customer behavior.
• Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Implemented workbooks to display Year to Date, Month to Date, Quarter to Date analysis for Operational expenses for IT leaders based on Accounts, and generated bullet graphs.
• Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed PL/SQL triggers on master tables for automatic creation of primary key values.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Mapplet, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh.

Environment: Tableau Desktop, Tableau Server, MS Office Suite, SQL Server, PL/SQL, Teradata, MS Excel.

Confidential, Ann Arbor, MI

Tableau Developer

Roles & Responsibilities:

• Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.
• Interacted with Business/Application Users (CIO/VP's) and Business Analysts to gather Reporting Requirements, subsequently translate it into Functional specifications for Tableau Dashboards Development.
• Designed and Developed Reports/Dashboards like Service scorecard, Revenue Dashboard, Customer satisfaction, Order Management, Retail scorecard, Traffic Dashboard, Event log Dashboard, Inventory Management, TOP 6 Metrics, CEO Daily, and prepared user stories to create compelling Dashboards(Visualizations)to deliver actionable insights.
• Created customized Dashboards using various chart types like Bar, Pie, Tree maps, Heat maps and line charts in Tableau
• Worked extensively with Tableau Advance analysis of Actions, Calculations, Parameters, Maps, Trend Lines, forecast, sets, groups, Background images, bins and table calculations to develop Dashboards.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Developed Tableau Dashboards/Story's from multiple data sources using Data Blending.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Administrated Tableau Online Activities like Users/Groups/Site Creation and setting up access levels for each Dashboard.
• Published reports to Tableau online and made them available to Appropriate Business Group as per the access levels.
• Scheduled Dashboards using Tableau Bridge and made them available to users like Hourly, Daily, weekly, Monthly.
• Performed GAP Analysis and resolved the functional logic issues in BRD's with the help of Business Users.
• Interacted with Business users for controlled validation and push the report Production and user Training.
• Conducted Load and Performance Testing using Tab Jolt and resolved performance related issues on affected Tableau Reports.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Wrote Custom SQL scripts for creating aggregate tables and generating views.
• Worked on understanding of relational database structures, theories, principles and practices.
• Involved to create Documentation for debugging report for Tableau.
• Developing various dashboards in that would identify cost savings and highlight the errors.
• Developed Dashboards using Tableau Desktop.

Environment: Agile, Tableau Desktop/Server, Teradata SQL Assistant, Teradata Administrator/ Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), firebug, Notepad+.

Confidential

SQL Developer

Roles & Responsibilities:

• Designed ETL processes for extracting, transforming and loading of OLTP data into a central data warehouse.
• Integrated new systems with existing data warehouse structure and refined system performance and functionality.
• Performed physical and logical modeling and Created SSIS packages to migrate data from heterogeneous sources such as MS Excel, Flat Files, and CSV files and then transform and load into the data mart.
• Responsible for enhancement of database performance using database performance and tuning optimization tools and techniques
• Responsible for mentoring team members, helping with assignments, providing guidance and technical oversight, and making key decisions on the technical design
• Implemented replication in SQL Server for syncing up data across servers
• Optimized the performance of TSQL queries, established joins and created clustered/non-clustered indexes wherever necessary.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Used BCP utility inside SSIS packages to import and export bulk data across servers
• Utilized change data capture for data integration across various environments
• Created the Shell Scripts to automate the execution of the SQL subprograms and to move the data to store in historical/archive folders.
• Analyzing the gaps between the old source system and new source system and estimate the time frame to complete the gaps.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS). Created calculated measures, dimension members using MDX, named calculations using SSAS for generation of cube
• Created a number of cubes, dimensions using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS and created new and converted several Crystal reports into detailed SSRS reports.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers
• Developed Dashboards using performance point dashboard designer, which is a part of performance point services in Microsoft SharePoint server 2013.

Environment: MS SQL Server Business Intelligence Development Studio 2008/2008R2, SSIS, SSAS, SSRS, XML, Oracle, MS Visual Studio, SQL Server Management Studio, SharePoint 2013, T-SQL, Data Mining, Power Bi.