SUMMARY

• 9 years of experience in the IT Industry and worked onTableauDesktop,TableauServer and efficient in connecting various data sources.
• 6+ years of extensiveTableauExperience in Enterprise Environment, inTableau10.1/ 9.x/8.x/7.x 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. inTableau10 desktop/Server.
• DevelopedTableauData 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 toTableauthroughTableauData Extract.
• SecuredTableauserver on AWS to protect theTableauenvironment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• As aTableauAdministrator, specializing in Server Worker Nodes Installation & Configuration. Setting upTableauPrimary and Worker Nodes (drivers, patches, command line utilities, etc.)
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Developed POCs by building reports and dashboards usingTableau10.1 to demonstrate quick wins.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement.
• Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool for most of the salesforce at CE.
• Experience in the maintenance and scheduling ofTableauData extracts usingTableauserver and theTableauCommand utility.
• 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.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Design.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and sequel server reporting services(SSRS).
• Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook.
• 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, Cloudera Hadoop and Hive, Apache SOLR, MapReduce, Amazon Redshift.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., inTableau.

TECHNICAL SKILLS

Reporting Tools: Tableau, Business Object Suite Business Objects BI 4.0, SAP BW, Web I XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client (3.1), Supervisor, Broadcast Agent, Info view, Crystal Reports Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius, Methodologies Waterfall, SCRUM and Agile, Complete Software Development Life Cycle, Iterative, Scrum.

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

Databases: Oracle SQL Server Sybase, Teradata, MS Assess, DB2.

Data Modeling Tools: ER Studio, VISIO, Dimensional Data Modeling (Star Schema, Snow - Flake, FACT Dimensions), ERWIN iGrafx

Languages: SQL, PL/SQL, C, C++, JAVA, J2EE, HTML, XHTML

Operating systems: UNIX, LINUX, Windows 98, XP, 2008/NT.

Application Servers: Web Logic, Web Sphere, Tomcat.

Software Packages: MS OFFICE, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin.

PROFESSIONAL EXPERIENCE

Sr Tableau Developer and Administrator

Confidential, Detroit, MI

Responsibilities:

• Involved in installation ofTableaudesktop 9.3,Tableauserver 9.3.Worked on latest versions ofTableau10.x.
• AsTableauDeveloper, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact forTableauand delivery of solutions adhering to BI industry best practices.
• CreatedTableaudashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations inTableau, using relational and aggregate data sources.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups ofTableaurepository.
• 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 aTableauSME, 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 thetableaudashboards 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 thetableauserver for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Demonstration of thetableaudashboards 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 withinTableauDesktop.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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 ontableauServer 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 onTableauServer 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: TableauDesktop 9.3,TableauServer 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 usingTableau.
• 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
• SecuredTableauserver to protect theTableauenvironment, 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 onTableauenvironment.
• 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 implementedTableaustandard operational process for granting user access and for publishing workbooks, data sources & migration betweenTableauServer environments.
• As aTableauAdministrator, specializing in Server Worker Nodes Installation & Configuration. Setting upTableauPrimary 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 varioustableaudashboards prototype for the future uses and conversion of current excel reports intotableau.
• 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 thetableaudashboards 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.
• Tableaudashboards embedding into Salesforce for the continuous data experience for the users,
• Built customtableaudashboards for the Salesforce for accepting the parameters from the Salesforce to show the relevant data for that selected object.
• Setting up active directory on thetableauserver for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Demonstration of thetableaudashboards and its functionality to the business users for the self-service business intelligence.
• Designed and developed the reports per the requirements usingTableauand 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 thetableauserver machines.
• Developedtableaudashboard 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 oftableaudashboards and speed for the embedded dashboards.
• Tableauadministration and development roles and helping the client with the issues of data connections, extraction and maintenance.
• Tableauserver and desktop upgrade from 8.3 to 9.0.

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

Sr.Tableau Developer

Confidential, NJ

Responsibilities:

• Built Strategic, Analytical and operational dashboards usingTableau.
• 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 withinTableauDesktop.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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-environmentTableauinfrastructure 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 theTableaureports per the user's requirements.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Tableauintegration for enhanced experience for the users.
• Created extracts and published data sources ontableauServer 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 onTableauServer 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,TableauServer, 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 thruTableaudesktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across theTableauBI 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 fromTableauDesktop toTableauservers.
• Assisted users to publish and collaborate reports via a web browser & embedTableauviews 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 onTableauDesktop, 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: Tableau7.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.

SQLDeveloper

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