SUMMARY

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

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management AndData Collection.

BI Tools: Tableau7.0,Tableau8.0/8.1,OBIEE 10g,11g,SSRS Relational

Databases: MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, MS Access.

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio

Languages: SQL, PL/SQL, C, C++, ASP.Net, HTML, XML, XSL

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, CA

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, LIVINGSTON, NJ

Sr. Tableau Developer

Responsibilities:

• Currently working on Proof of Concepts (POC) presentation and review with project and IT lead along with developingTableauDashboards.
• Recommended OS configuration for installing Win Server 2012 R2,TableauServer, andMSSQL Server 2012 R2.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementationproject, design and develop visualizationsas per requested by CEO and CFO ofa$600M firm.
• Adjust views/dashboards after initial POC presentation to CEO and CFO.
• Brainstorm ideas onwhattoinclude in views/dashboards from the data sourceand document on the fly business requirements.
• Create views and dashboards on end client'ssales data. Producepowerful 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 andCFO.
• Cleanse and normalize data in MS Excelby combining from variousdatasources.
• PerformTableauServer admin duties; add users/groups from Active Directory; and schedule instances inTableauServer including weekly data dump.
• Train endclient users onTableauDesktop by providing step-by-step guidancefrom basics to advanced functions ofTableauincludingworking with calculations,parameters, and date functions.
• Environment:TableauDesktop 8.1,TableauServer 8.1, MS Excel, MS SQL Server 2012 R2, Win Server 2012 R2, Active Directory

Environment: TableauDesktop 7 & 8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, New York, NY

Sr. Tableau Developer

Responsibilities:

• 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.
• 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.
• Creating data blending in case of merging two different datasets.
• The ability to interact professionally with a diverse group including executives, managers.
• 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.
• 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 theTableauServer 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, NY

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 TableauReports 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, Eagan, NJ

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.