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 teh 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 teh 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 teh story inside teh 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 teh 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 teh 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 teh application configurations and teh interaction, effective utilization of teh 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 teh business requirements and published in TableauServer
• Created actions in worksheets and dashboards for interactivity and to compare data against different views Monthly
• Customized geocoding, created calculated fields and applied filters
• Extensively used data blending, embed functionalities in Tableau
• Worked on teh requirement gathering of teh reports.
• Experience in performance tuning of reports in Tableau
• Worked with Source System Subject Matter Expert (SME) to ensure dat teh extracts are properly mapped.
• Used SQL for data mapping and querying.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for teh 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 teh 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 teh 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 teh 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 teh 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 teh Status of teh deliverables and Time of Delivery of teh 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 teh end users to define accurate requirements.
• Good understanding of teh customer business and implementing teh same over to teh 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 teh 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 teh Business reports for teh 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 teh tools reach in teh 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 teh data warehouse.
• Created test documents dat halp 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 teh Infoview portal.
• Created new Xcelsius Dashboards for FSA using teh congressional district and state data from Satori.
• Maintained and delivered several weekly dashboards to FSA as part of teh maintenance plan.
• Created and maintained Universes, Web intelligence and Rich Client reports.
• Aided our teams by greatly reducing teh 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 teh tools reach in teh 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 dat were not offered from teh core software package.
• Created test documents dat halp 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 teh 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 teh 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 teh backups of SQL Server production databases in test server environment.
• Analyzed poorly performing SQL queries to improve application performance.
• Handling teh trouble tickets which come into an application from teh users based on teh priority level.
• Developed Complex queries to retrieve teh data as per client requests based on certain parameters and restrictions.
• Used Exception Handling extensively to display teh error messages in teh 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 teh packages.
• Monitoring teh team and their work so dat teh tasks are completed in time.

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