SUMMARY

• Over 7+ years of IT experience in System analysis, design, development, Data Warehouse, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions to Health Care, Financial, Retail Sectors and Banking.
• 5+ years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 9.x/8.x/7. x.
• Expertise in web integration of Tableau Reports with HTML or Asp.Net.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator. Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Involved in creating dashboards by using Level of Detail concept (LOD’s).
• Implemented Tableau/Oracle BI security at the Data (Data security) and Object (Roles and Permissions) security.
• Proficient in developing Entity - Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse
• Good experience in working with Self-service Data Analytics tool Alteryx Designer for creating repeatable workflow.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems
• Expertise in getting the data from different data source such as flat files, Excel, Microsoft SQL server, MySQL, T-SQL, PL/SQL, Netezza, Teradata as well as OBIEE.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Experience in writing complex SQL queries to perform End-to- End ETL validations and support Adhoc business requests.
• Experienced in requirement gathering, marketing/consumer analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Experience in L1 and L2 support of SLA defined applications across different tools (Informatica andCognos)
• Installation and configuration of Tableau Primary Gateway servers & Worker servers
• Tuned the performance of VizQL, Data Engine and Back ground task engines.
• Created python scripts to migrate dashboards and data extracts from Dev to UAT and UAT to Production.
• Created server monitoring dashboards using Postgres repository to measure performance and usage at server level.
• Responsible for Tableau Environment, Security, Architecture setup.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experienced working in both Agile/Scrum and SDLC based development environment.
• Customized the Tableau landing page with site listing as icons and descriptions
• Extensive experience in Tableau Administration Tool for Configuration adding users managing licenses and data connections scheduling tasks embedding views by integrating with other platforms like SharePoint
• Involved in publishing of various kinds of interactive data visualizations dashboards and work books from Tableau Desktop to Tableau Servers
• Hands on experience in deploying & publishing dashboards using Tableau migration scripts.
• Expertise in performance tuning of theTableauinfrastructure including the application configurations and the interaction, effective utilization of the hardware platform including memory, and CPU resources.
• Design, develop, and implement Tableau Applications for Financial Planning and Budgeting models with complex requirements.
• CreatedCognosList Report for Accounting and Operational Reporting.
• Excellent communication skills in both written and oral along with ability to tell a story through data.
• Ability to interact professionally with a diverse group including executives and managers.

TECHNICAL SKILLS

BI/Visualization Tools: Tableau Desktop 6/7/8.1/9.x, Tableau Public 8.x/9.x, Tableau Reader 8.x/9.x, Tableau Server 8.1/9.x, SAP Business Objects, Xcelsius 2008/ Dashboards, Alteryx Designer/Server, Big Data Analytics, MSBI Suite (SSAS, SSRS).

ETL Tools: Informatica, IBM Datastage, SSIS

Programming: SQL, UNIX Shell, XML, HTML, C, C#, NET, Java, Java Script API, Asp.Net VB.

Utilities: MS Office Suite, TOAD, MS SharePoint, MS Project

Databases: Oracle 10g/11g, DB2, Postgre Sql, Teradata, Cloudera Hadoop, SQL Server 2008 R2, MS Access, MS Excel, MS SQL Server 2005

Platforms: Windows7/8/2003/NT, MS Server 2008 R2, Mac OS

Methodologies: Agile, Scrum, Complete Software Development Lifecycle, Application Lifecycle Management, JIRA Suite, Iterative and Waterfall

PROFESSIONAL EXPERIENCE

Confidential -Grand Rapids, MI

Sr Tableau Developer

Responsibilities:

• Developed dashboards, work books and data views depending upon the business requirements and published in TableauServer
• Created actions in worksheets and dashboards for interactivity and to compare data against different views
• Customized geocoding, created calculated fields and applied filters
• Extensively used data blending, embed functionalities in Tableau
• Worked on the requirement gathering of the reports.
• Experience in performance tuning of reports in Tableau
• Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
• Used SQL for data mapping and querying.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Experience in working with Alteryx Designer and Alteryx Server.
• Performed Data Blending by using Alteryx. Also used for advanced Data Analytics.
• Installed and configured SSL certificates for multiple Tableau environments.
• Implemented Kerberos for Integrating Tableau with Single-Sign-on.
• Worked with Tableau Support for high severity issues and in addressing few product defects.
• Designed Architecture diagrams for Tableau, QlikView and Cognos during initial setup.
• Maintenance of Tableau Server & desktop licenses and renewals.
• Created a mechanism to alert the Production Support team in case of long running or delayed Jobs/CognosCubes.
• Setting up subscriptions and scheduled extracts for Tableau workbooks.
• Worked with WINTEL team and setup 24/7 Monitoring of Tableau performance & services
• Created automated scripts for backup & restore of Tableau production server.
• Created a backup primary for Tableau for a fail-over setup.
• Prepared documentation on various Proof of Concepts and Proof of Technologies while evaluating BI Tools.
• Performed Disaster recovery setup for Tableau instances.
• Created automated scripts for AD synchronization in Tableau server.
• Worked on POC for setting up Tableau on AWS (Amazon Web Services) to provide a cost effective solution.
• Laid process flow across Business & IT for successful execution of Tableau projects.
• Defined workflow for maintaining tableau production across departments.
• Defined the ETL Standardization process to setup new ETL using Informatica 9.5 mappings as part ofcognosto OBIEE conversion project.
• Conducted Training for both business and IT users on Tableau Desktoptool.
• Expertise in designing, data formatting, implementing best practices, naming conventions and optimizing Tableau Dashboards / Reports.

Environment: Tableau 9.2.4/9.3, Tableau Server 9.2.6, Cloudera Hadoop (Hive, Impala), SQL Server, Java Scripts, Big Data Analytics, Alteryx Designer/Server, SSRS, Excel and other internal data source applications

Confidential - Ashburn, VA

Sr. Tableau Admin/Developer

Responsibilities:

• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Created technical specification documents related to Tableau design and architecture.
• Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Connected Tableau to various databases and performed Live data connections, query auto updates on data refresh etc.
• Implemented Tableau Mobile across several lines of businesses.
• Implemented Tableau BI application creation, Tableau Administration, Installs and Server side functionalities.
• Developed BI Data Dashboard of all Critical Deliverables inCognos10 which provides information about the Status of the deliverables and Time of Delivery of the artifacts.
• Provided technical support to all team members during project execution
• Performed reports/dashboards performance optimization
• Involved in User Training of Tableau dashboards.
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Actively involved in creating a custom portal design hosting Tableau workbooks using JavaScript API.
• Created responsive workbooks for IPad /PC orientation views.
• CreatedCognosList Report for Accounting and Operational Reporting.
• Worked with end users in creating complex dashboards in an iterative process..
• Created several automated scripts to backup, restore and auto sync Windows AD users.
• Performed tuning of Tableau workbooks and extracts to make them functional with large sets of data.
• Conducted training sessions for Tableau Power users to use it as a Self-service BI tool.
• Managed and coordinated with offshore team on deliverables.

Environment: Tableau 8.2/9.1, Server and Desktop, Postgre Sql, Teradata, SQL Server 2012, Oracle 11g, SQL/PLSQL, IBM Datastage, Windows Server 2012, VISIO.

Confidential - Dallas, TX

Tableau Developer

Responsibilities:

• Involved in report and dashboard requirement gathering from the end users to define accurate requirements.
• Good understanding of the customer business and implementing the same over to the reporting needs.
• Implemented new universes using IDT and modified existing ones according to requirements and performed checks, resolving traps, using contexts, aggregate awareness, hierarchies and derived tables.
• Performed report/universe optimizations in greatly reducing the run time of reports.
• Created complex Webi reports with multiple queries, custom sql, complex functions, merge dimensionsdrill down/up/across/through, complex filters etc.
• Designed and Delivered the Business reports for the end users by usingCognosQuery Studio, Report Studio and Analysis Studio.
• Performed Admin tasks such as monitoring DB services, BO Server running with optimal performancemonitoring licenses, monitoring user activity/sessions, consulting SAP to define bugs in patches etc.
• Migrated reports/universes from Dev to QA to Prod
• 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 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 etc.
• Implemented Tableau Mobile across several lines of businesses.
• Provided technical support to all team members during project execution
• Performed reports/dashboards performance optimization
• Involved in User Training of Tableau dashboards.
• Created intuitive ways in Dashboards to implement multi - level drill through s, Ranking, Dual Axis, Geo
• Coded Mapped views, Histograms etc.
• Helped in testing and impact assessment on dashboards with changes to the data warehouse.
• Created test documents that help in validating reports and dashboards in QA.

Environment: Tableau 8.2 Server and Desktop, Oracle 10g and 11g, SQL Server 2012, TeradataSQL/PLSQL, Netezza, Windows Server/professional, VISIO.

Confidential, Arlington, VA

BI Analyst

Responsibilities:

• Successfully completed testing and migration of Business Objects from XIR2 to XIR3.1 and XIR3.1 to 4.0 in DEV and PROD environments.
• Implemented custom Infoview portal pages in development and production to enhance and improve splash screen view of the Infoview portal.
• Created new Xcelsius Dashboards for FSA using the congressional district and state data from Satori.
• Maintained and delivered several weekly dashboards to FSA as part of the maintenance plan.
• Created and maintained Universes, Web intelligence and Rich Client reports.
• Aided our teams by greatly reducing the manual process of creating reports in excel for each site location and aggregating them.
• 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 groups and maintained user access rights for Business Objects universes and reports using Central Management Console.
• Fixed problems with DEV servers for problems with scheduling and routine maintenance.
• Analyzed and improved performance of several ad-hoc reports (bug fixing) using Oracle SQL/PLSQL in SQL Developer.
• Created several pilot dashboards for user sampling. Created intuitive ways in Dashboards to implement multi-level drill through's, ranking etc that were not offered from the core software package.
• Created test documents that help in validating reports and dashboards in QA.
• Created or modified Detail Design and HLD documents for Universe and Reporting changes during maintenance.
• Created and maintained several FS, Design documents and Code related to reports, universes and dashboards in Version Manager.
• Utilized Team Track to create and update logs for project maintenance.
• Research of Pilot Projects include:
• Integrate Microsoft SharePoint Web Parts with Business Objects to display dashboards on SharePoint.
• Conversion of Deski reports to Webi reports.
• Automation of Xcelsius Dashboards and Scorecards using Live Office.
• Adding third party Xcomponents to the already existing components in Xcelsius 2008 to utilize more features.
• Identification and testing of other Dashboarding tools such as Tableau.
• Created and Maintained dashboards for Consumer Financial Protection Bureau (CFPB).

Environment: SAP Business Objects XI R3/ SAP BI 4.0 (CMC, Designer, Web I, Deski), Informatica 7.x, Crystal Reports XI, Xcelsius 2008/ Dashboards, Tableau 7.0 and 8.0, Oracle 10g and 11g, MS Project, TOAD, FLEXCUBE, PL/SQL, Windows 2000 Server/professional, Tomcat 4.0, Apache Server 1.3.

Confidential

SQL Developer

Responsibilities:

• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization.
• Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Recovered the backups of SQL Server production databases in test server environment.
• Analyzed poorly performing SQL queries to improve application performance.
• Handling the trouble tickets which come into an application from the users based on the priority level.
• Developed Complex queries to retrieve the data as per client requests based on certain parameters and restrictions.
• Used Exception Handling extensively to display the error messages in the application.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Experience in report writing using SQL Server Reporting Services(SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Coordinating with peer groups for Network, Infrastructure and DataCenterOperations.
• Built SSRS report to support reporting needs.
• Developing and processing of SSAS cube.
• Helping team members in developing the packages.
• Monitoring the team and their work so that the tasks are completed in time.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server, VB 6.0, and XML. SSRS, SSIS