PROFESSIONAL SUMMARY:

• Over 8 years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server and efficient in connecting various data sources. 
• Strong experience using Tableau Server, Tableau Desktop and Tableau Public. 
• Involved in installation of Tableau desktop 8.0, Tableau server Application software and in server migration from 8.3 to 9.0. 
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect. 
• As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration. Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.) 
• Disaster Recovery setup, including Backup Primary setup and configuration. 
• 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 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. 
• 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 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 on 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 Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality. Dashboards and stories 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. 
• Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook. 
• Experience in SFDC Integration using Web Service and Apex Programming, Salesforce.com Service Cloud expertise. 
• 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. 
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers etc. 
• 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. 
• Knowledge in Cognos … BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio).
• 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:

OLAP Tools: Business Objects 4.1/4.0/ XI 3.1/ 6.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, CMC, CCM, LCM, Promotion Management Performance Management, Report Conversion tool, Import Wizard, Publishing Wizard, Upgrade Management Tool

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005 , MS Access 2000

Data Modeling tools: Star Schema Modeling, Snow Flake Modeling

Programming Languages: SQL, PL/SQL, Python, Java

Data Warehousing ETL tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2,

Visualization Tools: Tableau 10.1/9.1/8.1/8.0/7.0

Other Tools: Toad, Putty, Sub Version, Clear Case Explorer, SAS, OBIEE 10.1.3x/11g

PROFESSIONAL EXPERIENCE:

Sr Tableau Developer and Administrator

Confidential, Detroit, MI

Responsibilities:

• Involved in installation of Tableau desktop 9.3, Tableau server 9.3. Worked on latest versions of Tableau 10.x. 
• 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 Tabadmin and Tabcmd 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. 
• Experienced in developing Web Services with Python programming language. 
• As a Tableau SME, responsible for the design, development and production support of interactive data visualizations used across the company. 
• Solving P1 issues for the users in the production. 
• Built and maintained Microsoft Server 2012 R2.
• Installed and maintain Microsoft SQL Server 2016 to a Microsoft Server 2012 R2.
• Involved in creating a dual-axis bar chart with multiple measures. 
• Involved actively in coding PL/SQL based on business requirements. 
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards. 
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation. 
• Setting up 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. 
• Developed PL/SQL triggers on master tables for automatic creation of primary key values. 
• 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 story telling 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. 
• 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 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, Mapplets, 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. 
• Worked on Tabcmd to schedule the report's and setup email reports using command lines. 

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

Sr Tableau Developer and Administrator

Confidential, CA

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau. 
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions. 
• Process, filter, and publish large quantities of data. 
• 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. 
• Proficient in data integration between different sources to the EMC Greenplum and SQL environment and reporting the same on Tableau environment. 
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle database, Greenplum. 
• 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. 
• As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration. Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.) Disaster Recovery setup, including Backup Primary setup and configuration. 
• Designed and developed remarkable Data Visualizations utilizing R 
• Cleaned the crude data and loaded into R Studio to make an analysis. 
• Used 3-Dimensional Bar Graphs, Pie Charts to depict a pictorial representation in R. 
• Experienced in Service Cloud, Sales cloud, Collaboration Cloud and SFDC Customer Community for All partner portal, customer portal. 
• Developed Python/Django application for Google Analytics aggregation and reporting. 
• Participated in projects involving Data Quality and Data Governance Strategy and Implementation, MDM Assessment and MDM Implementation, Data Quality Assessment, as well Data Integration, Data Migration using ETL. 
• Wrote Python routines to log into the websites and fetch data for selected options. 
• Involved in creating a dual-axis bar chart with multiple measures. 
• Extensive experience in configuration, implementation and maintenance for disaster recovery solutions using log shipping, transactional & merge replication in SQL server 2012. 
• 24/7 on call support for production databases. 
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau. 
• Hands on experience on click stream. 
• Extensively involved in writing PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. 
• Extensive experience in Salesforce.com Setup, Configuration, Customization, Administration, Data Migration and Integration tools like Apex Data Loader, Work Bench. 
• Strong experience in mobile analytics tools. 
• Expert in writing java scripts for the front-end pages. 
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards. 
• Expert in UI/UX design and redesign. 
• Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook. 
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel. 
• Proficient in Databases such as Oracle, Microsoft Access, DB2, My-SQL, SQL server and Hadoop Hive. 
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation. 
• Worked on multiple projects by connecting to multiple data sources like SQL Server, SAS (Statistical Analysis System), Hadoop, SSAS (Microsoft Analysis Services) cubes data and Teradata, Hadoop. 
• 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 Salesforce to show the relevant data for that selected object. 
• Setting up 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. 
• Designed and developed the reports per the requirements using Tableau and Power Map. 
• Ensure user login access, server level, and database level access to application users and developers. 
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines. 
• Developed tableau dashboard landing page for the embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for the users. 
• Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data. 
• Creating daily, weekly and monthly reports in Cognos for the internal teams and external vendors. 
• Addressing the Performance and other Production issues with the Cognos reports.
• Best practices to enhance the response time of tableau dashboards and speed for the embedded dashboards. 
• Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance. 
• Tableau server and desktop upgrade from 8.3 to 9.0.  

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

Sr. Tableau Developer

Confidential, Hoboken, NJ

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau. 
• 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 story telling 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 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.
• Worked in ASDW team where solved issues raised by the front-end users and worked on the Tableau reports per the user's requirements. 
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets. 
• Tableau integration for enhanced experience for the users. 
• 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. 
• Used User row level security for data in the Dashboard. 
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes. 
• 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. 

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

Tableau Developer and Administrator

Confidential, Great Neck, NY

Responsibilities:

• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending. 
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop. 
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite. 
• Created complex data Views using multiple measures, also used sort, Filter, group, Create Set functionality. 
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation. 
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes. 
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers. 
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint. 
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement. 
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant. 
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards. 
• Published Reports, workbooks & data source to server and exporting the reports in different Formats. 
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards 
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure 

Environment: Tableau 7.0, SQL Server 2008 R2, SSRS, SSIS, MS Excel, T-SQL.

SQL Developer

Confidential

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements. 
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents. 
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases. 
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance. 
• Extracted data from xml and flat files using SSIS. 
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS. 
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing. 
• Designed, programmed, deployed and tested the requested Reports. 
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects. 
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application Database Tables, along with checkpoints for testing verification. 
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration. 
• Analyzed long running queries and tuned the complex queries to optimize application and system performance. 
• Developed user test cases and validated test results during user acceptance testing. 
• Assisted in test planning and execution. Created test plan for User Acceptance Testing. 
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2000/2005/2008 , Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML. 

SQL Developer

Confidential

Responsibilities:

• Managing of database objects like Tables, views, indexes. 
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment. 
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes 
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005. 
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers 
• Used Index Tuning Advisor for Database performance for proper indexes. 
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005. 
• Implementing Load Balancing Replication across the Databases. 
• Performed Database Refresh tasks from production to Development and Staging Servers. 
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments. 
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities. 
• Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs. 
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O. 

Environment: SQL Server 2000, SQL Server 2005. T-SQL, Windows Server, HTML, VBScript, JavaScript, Access