• Over 7 years of IT Experience in design, analysis, development and implementation of various applications in Client/Server OLAP environment using BI Tools in Manufacturing, Retail and Financial industries.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau Tableau 6.x/7.x/8.x Desktop, Server, Mobile, and Public , Micro Strategy, Business Objects and SSRS.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning JRP sessions with Business User Groups, conducting Joint Application Development JAD sessions with IT Groups.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix RTM which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Deep understanding of the Oracle E-Business Suite Procure to Pay and Order to Cash cycles.
• Managed cross-functional teams through Software Development Life Cycle.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints Primary key, Foreign Key, Unique, Default , Indexes.
• Well versed in using multi-dimensional expression MDX queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, , Informatics UNIX, DB2, Oracle and SQL Server technologies.
• Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load ETL routines for migrating data from non-relational or source relational to target relational.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Outstanding knowledge in Microsoft Office suite MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio .
• Deep experience with the design and development of Tableau visualization solutions.
• Knowledge of Alteryx.
• Experience on design data models.
• Experience setting up and managing Tableau Server with large volumes of data.
• Experience on Configuring installation and managing Tableau Server with large data volumes like
• Setting up Tableau data sources. Filters, blending, joins for optimum performance and
• Trouble-shooting issues.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• 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 in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow
• For efficient creation of reports.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Scheduled the reports as per business requirements.
• Enhancements to the Cognos reports.

Professional Experience:

Confidential

Role : Sr. Tableau Developer

Responsibilities:

• Experience in design and development of Tableau visualization solutions.
• Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Working on generating various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle.
• Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• Created drill down and drill up in worksheets in tableau.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly 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 change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Involved in license management SLA's with Tableau support.
• Prepared proof of concept for best practices in Tableau deployment.
• Developing a Dashboards and preparing ad-hoc Reporting.

Confidential

Role: Sr. Tableau Developer

Responsibilities:

• Currently working on Proof of Concepts POC presentation and review with project and IT lead along with developing Tableau Dashboards.
• Recommended OS configuration for installing Win Server 2012 R2, Tableau Server, and MS SQL Server 2012 R2.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO of a 600M firm.
• Adjust views/dashboards after initial POC presentation to CEO and CFO.
• Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
• Create views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by CEO and CFO.
• Cleanse and normalize data in MS Excel by combining from various data sources.
• Perform Tableau Server admin duties add users/groups from Active Directory and schedule instances in Tableau Server including weekly data dump.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
• Environment: Tableau Desktop 8.1, Tableau Server 8.1, MS Excel, MS SQL Server 2012 R2, Win Server 2012 R2, Active Directory

Environment: Tableau Desktop 7 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential

Sr. Tableau Developer

Hardware/Software:

• Extracting data from different sources connecting them and used the same to create dashboard
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Tableau Desktop, Tableau server / Administrator, Oracle 10/11g, Microsoft Excel, MS Access, Microsoft office MS SQL SERVER 2008, SSIS, SSAS, SSRS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access
• Responsibilities:
• Experience with the design and development of Tableau visualization solutions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• The ability to interact professionally with a diverse group including executives, managers.
• Creating data blending in case of merging two different datasets.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Working knowledge on Tableau Server / Administration.
• Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhones, and other smart mobile phones.

Confidential

Tableau Developer

Responsibilities:

• Worked as a Tableau admin, in charge of the report development and maintenance
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• Built and maintained many dashboards.
• Training classes to the employees on Tableau Software.
• Creating dataflow diagram and documenting the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Worked on the requirement gathering of the reports
• Analyzed the database tables and created database views based on the columns needed.
• Created dashboards displaying sales, variance of sales between planned and actual values.
• Implemented calculations and parameters wherever needed.
• Published dashboards to Tableau server.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Developed SQL Server Impersonation for Impersonation Requirements, How Impersonation Works,
• Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
• Good Knowledge and Worked on TABCMD TABADMIN, Database Maintenance and Troubleshooting.

Confidential

Business Objects Developer

Responsibilities:

• Worked with customer service based group and involved in modifying existing Universe and created various canned and ad-hoc reports
• Involved in gathering end-user requirements to modify and create reports.
• Created complex report variables
• Exporting importing universes across different domains and keeps maintaining universe versioning.
• Created standard and ad-hoc reports and published the standard reports on to the repository.
• Used prompts in the reporter level to create more interactive reports.
• Used business objects functionalities like break, sort, alerter, filter and condition.
• Used aggregate awareness in universe to tune the performance
• Scheduled Full client reports and thin client reports using BCA
• Linked different data providers and used sub queries in reports
• Published and scheduled Business Objects Reports to users using Scheduler.
• Developed complex reports using Functions like Prompt for user defined queries , Where for creating conditional filters , Select and Cross Tab tables
• Analyzed reports using Slice and Dice, Drill down and Master Detail
• Worked with the customers to resolve various issues associated with the reports.

Confidential

SQL Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration import export/BCP from Text to SQL Server.
• Configured Replication Server.
• Worked on a Terabytes of Data.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2000, ER-Win, T-SQL, Excel, Access and Windows NT.