SUMMARY:

• Over 8 years of IT Experience as a Data Analyst, Business Analyst in Data Warehousing and Business Intelligence Projects
• 4+ years of experience in Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 6/7/8 and 9 .
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Extensive experience in MSBI stacks like SSRS,SSIS,SSAS
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
• Experience in installation, Configuration and administration of Tableau Server in multi - server and multi-tier environment.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage .
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Expertise in development of Tableau visualizations which includes preparing dashboards using various reporting objects such as facts, attributes, transformations, filters, prompts, calculated fields, parameters, groups, sets and hierarchies.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Worked extensively on joining tables, multiple data connections using data blending, worked on Data Extracts and managing queries.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources
• Experience with creating the Tableau dashboards with relational and multi-dimensional databases including Oracle, MySQL and Teradata, gathering and manipulating data from various sources...
• Extensive Experience in Tableau Server includes Automatic Backup, Cluster Node environment.
• Experience in Administering user, user groups, and scheduled instances for reports in Tableau.
• Good knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in oracle.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like SSIS
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Excellent experience in designing OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.
• Have good knowledge on Data Modeling concepts
• Responsible for writing SQL Queries, Dynamic queries, sub queries and complex joins for generating Complex Stored Procedures, Triggers, User defined Functions, Views and Cursors.
• Proficiency in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Good experience in generating Sub Reports, Drill down reports, Drill through reports, and Parameterized reports using SSRS 2012/2008-R 2/2008/2005.
• Experienced in tuning long running SQL queries for better performance.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data. Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Extensive experience in development of T-SQL, PL/SQL, Functions, Stored Procedures, Triggers and ActiveX Scripts
• Strong knowledge of Software Development Life Cycle (SDLC).
• Good understanding and background in financial services, Health Care, media, and telecom industry.
• Excellent command & Sound knowledge of latest software related to business analysis.
• Quick learner, excellent communication skills and good performer both in team and independent job environments

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau 6/7/8.1/8.2/8.3 and 9.0, 9.2, Qlikview, Birst, SSIS, SSAS, SSRS

Programming: SQL, UNIX Shell, HTML,PL-SQL

Utilities: MS Office Suite, MS Share Point, MS Project

Databases: Oracle 10g/11g, SQL Server 2012/2008 R2/2008/2005, Oracle Business Intelligence, MS Access, MS Excel, DB2, Teradata

Platforms: Windows 7/8/2003/NT, Mac OS, DOS, UNIX.

Networking: TCP/IP, LAN/WAN Technologies.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Tableau Developer

Responsibilities:

• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop.
• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
• Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Involved in installation and configuration of Tableau Server. Maintained and Installed Tableau Server in all the environments.
• Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Created views in Tableau Desktop in Agile environment, that were published to internal team for review and further data analysis and customization using filters and actions.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Copied data from SQL server to Oracle thru .CSV files using SQL developer tool.. Implemented Data modeling as per the requirement and created new Data Mart.
• Configuring server health checks, Backup failover & Server Alerts
• Configured HTTP port opening(80,443), Single Sign on (SSO) using SAML and SSL
• Created automatic email alerts upon extracts failures, workbook performance issues
• Site, Project, User & group creations and permission settings using portal or TABADMIN
• Analyzing performance issues either in server or desktop by checking logs
• Facilitating Java API, Rest APIs, Web editing, importing Tableau metadata upon request by other projects using DB
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 8.2 and 9.0, 9.2, Tableau Server, DB2, Oracle SQL Server, Teradata, MS Access, SQL Server 2008 R2, TABADMIN, TABCMD, APIs, CSV files, Apache 2.2, Share point, TDE Files

Tableau Developer

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Configured and upgraded Tableau Server and Tableau Desktop.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau Desktop.
• Implement info graphics and Dash boarding for data visualization.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in converting OBIEE content into Tableau BI content.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Experienced with trouble shoot of Teradata connection.
• Tested reports and uploaded tableau dashboards onto server and provided production support for tableau users.
• Developed Tableau visualizations to support ad-hoc analyses and interacted with Business users in understanding their requirements.
• Created Heat Map showing current distributors by color that were broken into regions allowing business user to understand where we have most profitable vs. least.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.

Environment: Tableau server / Administrator, Tableau Desktop v7/v8, Windows Server Standard R2, Oracle 11g, Sybase, Crystal XI, TSQL.

Tableau Developer / Tableau Administrator

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau Desktop.
• Evaluated and worked on several Business Intelligence Platforms such as Birst and Qlikview in order to compare and contrast specific client’s needs against Tableau.
• Migrated content from Production, to QA to Development Environment
• Used Actions extensively to link and filter sheets for easier navigation in Dashboards
• Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Created calculated fields for implementation of color coding and proper aggregations coming from SAP BW
• Created extensive joins for data blending from several different data sources
• Helped customize Tableau Server with Company Logo and Company Pop-Ups
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Executed and tested required queries and reports before publishing.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Performing SQL Optimizing by using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Environment: Tableau 7/6, Oracle Server, Microsoft SQL Server, Rapid SQL, Birst, Qlikview, SAP BW

SQL Server Developer/SQL BI Developer

Responsibilities:

• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Migrated the data from the appropriate databases to end database and maintained batch log files. Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Implemented AD HOC reporting with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generating Drill- through, Drill down, Matrix, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration 2007.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Environment: MSSQL Server 2008/2005, SSIS 2008/2005, SSRS 2008/2005 with Microsoft Share point Integration 2007, SSAS 2008, Oracle 10g, Windows XP, MS EXCEL

Database Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access and Excel into MS SQL Server 2005 using SSIS Packages.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and Tuned SQL statements using Indexes and Stored Procedures
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries. Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Generated Sub Reports, Cross tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS .
• Ability to analyze, configure and troubleshoot networks.

Environment: MS SQL SERVER 2000/2005, SSIS, SSRS, Query Analyzer, MS Excel, MS Access, Windows