SUMMARY

• 7+ 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 TableauExperience 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.
• 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

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio.

Data Visualization tools: Tableau 9.3, Informatica, and Crystal Reporting. SQL Server Reporting Services, Business Objects.

Database: MS SQL Server, MS Access, Oracle, MySQL

Programming: T-SQL, PL-SQL, C, (Shell Scripting)

Web Technologies: HTML, XML

Operating Systems: Windows, UNIX, Linux, Mac OS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Access), ERWIN, Project

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

Confidential, Bridgewater, NJ

Tableau Developer

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Experience with the design and development of Tableau visualization solutions.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Connected Tableau server with share - point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Interacted professionally with a diverse group including executives, managers.
• Designed the Conceptual and Physical Data Models, as well as the major components of the user Created and assisted users in Tableau dashboard development
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users

ENVIRONMENT: Tableau Desktop 8.2, 8.0, 7.0, 6.02, Tableau server/Administrator, Oracle 10g, Microsoft Excel 2007, MS Access, Microsoft office 2007.

Confidential, Canonsburg, PA

Senior SQL Data Analyst /Tableau

Responsibilities:

• 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 to 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 the 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 in conducting training to a user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop
• Involved a key member in the development of E-R modeling (Logical design) of database incorporating business logic and user requirement
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Created detailed reports for the sales department to help them analyze the customer behavior and customer feedback and involve in supporting generating reports for end-users
• Performed ETL packages to extract data from OLTP data sources such as Excel, Access, Text files and Oracle, SQL Server using SSIS
• Implemented slowly changing dimension transformation to maintain the historical data in data warehouse.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases
• Created effective User Defined Function, Stored Procedure, Triggers, Transactions to facilitate data consistency and efficient data manipulation
• Developed dynamic SQL queries for reports on Enterprise Data Warehouse(OLAP) and Operational database(OLTP)
• Used Execution Plan to optimize the performance of database
• Created user defined financial reports to provide on demand financial data analysis
• Generated reports of various output formats as requested by the management such as drill down, drill through reports
• Performed complex expressions to group data, filter and parameterize reports
• Deployed the generated reports created using SSRS to the server
• Generated different types of visualization reports (Dashboard, Pie Chart, Bar Chart, Line Chart, Graph) using Tableau
• Published Reports, workbooks & data source to the server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards

Environment: MS SQL Server SQL Server Integration Services(SSIS) 2010, SQL Server Reporting Services(SSRS) 2010, SQL Profiler, Database Engine Tuning Advisor, Tableau 7.0, MS Office, Windows 7, SharePoint 2010.

Confidential, Bloomington, IL

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

Confidential

SQL Server Developer

Responsibilities:

• Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• 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.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.

ENVIRONMENT: MS SQL Server 2008/2005, Windows XP Server, MS Access.