SUMMARY

• Around 8+ years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server and efficient in connecting various data sources.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Wrote T - SQL queries in SQL Server, AWS's Redshift environment using SQL Management Studio/Visual Studio 2012.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle database, Greenplum.
• As Tableau Architect, 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.
• As a Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Proficient in data integration between different sources to the EMC Greenplum and SQL environment and reporting the same on the Tableau environment.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.3 to Tableau 9.0.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Having knowledge of Salesforce Service cloud-like, Case Management, Solution Management using Assignment Rules, Auto-Response Rules,and Escalation Rules.
• Solid experience in building interactive reports, dashboards, and/or integrating Modeling results and have strong Data Visualization design skills and analytic background
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Experience in the maintenance and scheduling of Tableau Data extracts using Tableau server and the Tableau Command utility.
• Experience in SFDC Integration using Web Service and Apex Programming, Salesforce.com Service Cloud expertise.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt chart, etc. using show me functionality.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting, etc. and Dashboard prompts
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing,and migration from development to production.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Extensive knowledge of tableau architecture and Dimensional Modeling experience.
• Expert in Modeling, Extraction Transform Loading (ETL) using DTS and SSIS.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS. Proficient in handling parameterized reports in SSRS.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical Modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server.

TECHNICAL SKILLS

BI Tools: Tableau 10.x,9.x, 8.3/8.2/8.1/8.0/7.0 , SAS, SSRS, Salesforce, Crystal Reports 9.0/8.5,OLAP, Power BI

Databases: SQL Server 2012,SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g

Languages: UML, Oracle ETL, SQL, PL/SQL,SAAS

Application Packages: MS Visio, MS Project, MS Access, MS Office Suite

PROFESSIONAL EXPERIENCE

Tableau Developer and Administration

Confidential, Lutherville, MARYLAND

Responsibilities:

• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on a business change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Secured Tableau server to protect the Tableau environment, security group,andAWS Direct Connect.
• Proficient in data integration between different sources to the EMCGreenplum and SQL environment and reporting the same on the Tableau environment.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle database, Greenplum.
• Maintained Service Grid platform and SAAS environments.
• Setting up an active directory on the tableau server for the effortless password management for the single sign-on in the Salesforce and to view the embedded dashboards.
• Demonstration of the tableau dashboards and its functionality to the business users for the self-service business intelligence.
• Act as administrator of web analytics tool, working internally to support and train others on the effective use of the tool
• Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using filters and actions.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Setting up and optimising Google Analytics properties and views in line with current product structure
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Created complex dashboard using parameters, sets, groups,and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Tableau administration and development roles and helping the client with the issues of data connections, extraction,and maintenance.

Environment : Tableau Desktop 10, SAAS, Tableau Server 10, MS Office Suite, SQL Server, PL/SQL, Snowflake, MS Excel,Alteryx 11.0 & 11.3.

Tableau Developer and Administration

Confidential, Peoria,Illinois.

Responsibilities:

• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Secured Tableau server to protect the Tableau environment, security group,and AWS Direct Connect.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Analyzed requirements for various reports, dashboards, scorecards and created a proof ofconcept/prototype the same using Tableaudesktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in TableauDesktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs,Treemaps, Bubble Charts, to assist business users in solving complex problems.
• Utilized advanced 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.
• Setup sites, projects & local user groups as per functional teams of the organization and implemented Tableau standard operational process for granting user access and for publishing workbooks, data sources & migration between Tableau Server environments.
• Experienced in Service Cloud, Sales Cloud, Collaboration Cloud and SFDC Customer Community for All partner portal, customer portal.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Developed various data connections from the data source to Tableau Desktop for report and dashboard development
• Advanced proficiency in Adobe Site Catalyst (Omniture) or similar web analytics software
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Tableau dashboards embedding into Salesforce for the continuous data experience for the users,
• Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforceto show the relevant data for that selected object.
• Strong knowledge of Google Analytics, as well as other analytics apps, like Chartbeat, Mixpanel, Crazy Egg, etc.
• Setting up an active directory on the tableau server for the effortless password management for the single sign-on in the Salesforce and to view the embedded dashboards.
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.
• Tableau administration and development roles and helping the client with the issues of data connections, extraction,and maintenance.

Environment: Desktop 8.3/9.0, Tableau Server, MS Office Suite, SQL Server, PL/SQL, R Programming, Teradata, MS Excel.

TableauDeveloper

Confidential, HuntingtonBeach, CA.

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end-users to understand the data on the fly with the usage of quick filters for on-demand needed information.
• Worked on claims data of the company like the healthcare data.
• Utilized standard Python modules such as CSV, itertools,and pickle for development.
• Developed Wrapper in Python for instantiating multi-threaded application.
• Involvement in the end-to-end activity of dashboard development from requirements gathering to deployment phase.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting,and general systems maintenance
• Gather client business requirements and work with a web analytics implementation consultant to translate them into technical requirements
• Worked in the ASDW team where solved issues raised by the front-end users and worked on the Tableau reports according to the user's requirements.
• The ideal candidate will be familiar with Google Analytics
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created extracts and published data sources on Tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on a business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Desktop 8.1, Tableau Server, MS Office Suite, SQL Server, SSRS, SSIS, MS Excel, Sales, Teradata.

BI/Tableau Developer

Confidential

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in TableauDesktop that were published to the internal team for review and further data analysis and customization using filters and actions.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in TableauDesktop that were presented to BusinessUsers, Program Managers, and EndUsers.

Environment : Tableau Desktop 6, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel.

Jr. Data Analyst

Confidential

Responsibilities:

• Designed, modeled, validated and tested statistical algorithms against various data sets including behavioural data and deployed predictive models using R-studio.
• Created interactive Dashboard using PowerBI for Key Performance Indicators for business by connecting various data sources like Excel and SQL Database.
• Contributed implementing models to identify, extract, summarize, and reduce or categorize the relevant qualitative financial input information like sentiment/feedback/news according to specific structures (templates) from a source text (digital news) to support decision making.
• Performed tasks related to data reporting, including summarizing, documenting, validating, and creating charts.

Environment : Agile, MS Office, SQL Database, PowerBI, Excel