SUMMARY:

• Over 6+ years of experience in Data Analytics, Data Management, Data mining, Data Integration, Implementation and Maintenance of Business Intelligence, and the related Database Platforms.
• IT Experience in Data Warehousing and Business Intelligence applications in Retail, Financial, Health Care, Pharmacy, E - business and Manufacturing industries using Tableau.
• Experience problem solving with advanced predictive analytics, creating analytical datasets, segmentation & clustering, data Visualization in Tableau, Classification Models, A/B Testing for Business analyst, Time series Forecasting.
• Certified tableau 10 developer with more that 4 years experience exclusively on Tableau.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 6, Tableau 7, Tableau 8.x and Tableau 9.x,Tableau 10.x
• Extensive experience in UI/UX principles and visual encoding and grammar of data Graphics.
• Designing human centered visuals and graphs by using HCI principles in tableau.
• Extensive Experience in Installation, configuration, upgrading, creation of sites, projects, groups, users, maintaining security levels, user permissions and administration of the Tableau Server.
• 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.
• Strong work experience in AGILE SCRUM environment. 
• Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page, Dashboard reports, Dashboard Prompts and KPI’s.
• 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. 
• Expertize in creating the user level, Data source level, row level security filters for the workbooks, views, dashboards and data sources.
• Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin , creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks. 
• Linear and Non Linear Programming, Data Science and Analytics, Regression analysis, exponential smoothening, Trends, Stochastic Process Analysis and Stochastic System Analysis, Natural language Processing
• Big Data Hadoop / Spark Development Environment (HDFS, Map reduce algorithm and Programming, Pig, Hive, Sqoop, Flume, Kafka, Oozie, Zookeeper, Hbase, Spark, Spark Streaming, Mllib, Graph), Machine learning algorithms (Linear Regression, Logistic Regression, Decision Tree, Random Forest, SVM, Dimensionality Reduction)
• Wrote Hive scripts and queries to extract data from unstructured data sources(hadoop) into the BI tool, Visualization tool.
• Excellent understanding of Data modeling (Dimensional & Relational) concepts like Star-schema, Snowflake schema using fact and dimension tables. 
• Experience in creating ETL procedures, Cubes, Reports, Scorecards and dashboards using MSBI tool stack of SQL Server 2008R2 & 2012
• Good Experience in implementing Data Types, Basic SQLSELECT statements, restricting and sorting data, single-row functions, joins, aggregate and group functions, sub-queries, creating & managing DB Objects, manipulating Data (DML), Constraints, Views.
• SQL Server and Oracle Database development experience using tables, joins, union, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
• Capable of delivering well documented applications, adhering to quality standards and delivery dates.
• Excellent interpersonal and communication skills, creative, research-minded, technically competent and result-oriented with strong problem solving and leadership skills.

TECHNICAL SKILLS:

BI Tools: Python, Spark, Scala, Panda, Numpy, Scipy, Pydoop, PySpark

Libraries: Tableau Desktop 10.x, Tableau Server, Tableau online, Tableau Public, Tableau Reader, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services(SSIS), Alteryx 11

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

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

Languages: Python, PySpark, MS-SQL, MySQL, hive, HTML5, CS3, JavaScript and XML

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

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

FrontEnd Tools: Microsoft Project, Microsoft Office, Microsoft Excel

WORK EXPERIENCE:

Confidential, Boston

Tableau Developer/ Admin

Responsibilities:

• Developed Inventory reconciliation, Sales KPI summary update reports, Days Inventory on hand report for different channels, firms and products rolling up by month end.
• Created SQL views to pull data from SQL Server and developed reports using advanced calculations, filters and parameters.
• Training business users for all things Tableau and data analysis.
• Creating New Schedule's and checking the task's daily on the Tableau Server. 
• Maintaining server activities, user activity, and customized views on Tableau Server analysis. 
• Created Business requirement documents and plans for creating dashboards. 
• Migrated reports/universes from Dev to QA to Prod using import wizard. 
• Created Dashboards and visualizations using Tableau for several teams and delivered demo sessions to expand the tools reach in the IT environment. 
• Created users, user's groups and maintained user access rights in Tableau.
• Created Architecture Design documents and Technical Specifications Documents . 
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh. 

Confidential, Chicago

Sr. BI developer

Responsibilities:

• Developed Tableau reports/dashboards for Sales team to enable them on the follow ups and track day to day meetings, conferences and calls with Advisors for different corporate clients. 
• Provide business intelligence and customer data stewardship for the sales, marketing, product and service teams.
• Develop Predictive analytical capability : research and predict customer behavior, and provide insights to manager.
• 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. 
• Overlooked end to end tableau lifecycle from developing, UA / unit / string testing, deployment to maintenance. 
• Facilitated assignment of user roles/privileges, projects and security on tableau Server by collaborating with the Admin. 
• Developed Custom SQL scripts to view required claim data in developed dashboards.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• 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.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Implementing UI/UX principles such as cognitive walkthrough and Heuristic evaluation to design visuals

Environment: Tableau 10.1 (Desktop/ Server), Oracle, Sales page, MS SQL Server 2012, Alteryx, Redshift, Adobe Analytics

Confidential, IL

Data Analyst

Responsibilities:

• Played the role of the sole Tableau developer for the inventory management function.
• Created dashboard views from data coming from NetMining and UPTRACS. 
• Worked on Inventory, Sales and Service, Advertising, Social, Website, Leads, Website Metrics of E-business to create the visualization dashboards for the Dealers. 
• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each zone, region and nationally to gauge system performance using the Tableau.
• Created Rich Graphic visualization/dashboards to enable a fast read on sales and key business drivers and to direct attention to key area .
• Worked on evaluation and analysis of Hadoop cluster and different big data analytic tools including Hive, Hbase database and Sqoop. 
• Involved in creating tables in Putty and transferring those tables from Hive to Netezza via Sqoop process. 
• Involved in testing the Hive Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Connected Tableau directly to Hortonworks Data Platform through Hive interface so that business users can quickly find insight with Hadoop deployment . 
• Exported the analyzed data to the relational databases using Sqoop for visualization and to generate reports for the BI team. 
• Used filters, parameters, sets, groups, hierarchies (Customer and default), calculated fields and table calculations to create interactive, user friendly and creative dashboards. 
• Incorporated a regional and national comparative / benchmark metrics to give context to individual performance 
• Online and offline KPIs are included for sales and inventory data through Paid Search and CRM 
• Created a proof of concept for the optimal data integration process. 
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's 
• Created report schedules, data connections, projects, groups in Tableau server.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.

Environment: Tableau 9.2 (Desktop/ Server), Hadoop, hive, scoop, Netezza.

Confidential, Harleysville, PA

Data Analyst

Responsibilities:

• Preparing SAP HR dashboards highlight HR analytics dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extract data from SAP Business Warehouse import it to Excel and crunch the numbers to produce dashboards in Tableau.
• Configured SAML on tableau server.
• Pulling reports from SAP Hana.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in providing Tableau server and tableau desktop training.

Environments: Tableau Server 8.0, Tableau Desktop 8.0, Tomcat, Oracle 11i, Excel, Trillium, SAP hana

Confidential, Charlotte, NC

Tableau Developer/Admin

Responsibilities:

• Managed an IT data migration project by building interactive dashboards on Tableau 9.3 for IT leaders to track 30-60-90 day forecast progress via calendar visuals, view status matrix of stakeholders and app % complete tracker. 
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server. 
• Upgraded Tableau 7.0 to Tableau 8.0 and gathered requirements, analyzed from raw data. 
• 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. 
• 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. 
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant. 
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop. 

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, Microsoft Excel 2007, MS Access, Microsoft office 2007.

Confidential, Atlanta GA

Tableau BI Developer.

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).
• Set Up Row level security on Tableau dashboards
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Blended data using multiple data sources (primary and secondary).
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• 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. 

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, MySQL, SQL 2008, Microsoft Excel 2007, MS Access, Windows 2007 server, Java, jboss, Teradata