PROFESSIONAL SUMMARY:

• Around 7+ years of experience in Design development, implementation, and administration of various Business Intelligence tools, Databases and Data Warehousing Applications.
• Extensive experience working with Data Visualization BI tools specifically Tableau (7.0/8.1/8.2/9.0), Qlikview, SAP BO (BO XI 3.1/BI BO 4.0) and Cogno’s (8.1/8.2/8.3/8.4).
• Knowledge in reporting tools like BO, Microstrategy, OBIEE.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Online, Tableau Reader and Tableau Server.
• Experience in Installation, Configuration and administration of Tableau Server in multi-server and multi-tier environment. Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go-live and Reconciliation.
• Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
• CreatedTableauScorecards, Dashboards, Heat maps using show me functionality.
• 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.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Extensive knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.
• Experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Strong knowledge of how to create complex reports (ex: drill down reports) using cursors and multi-dimensional objects.Strong communication skills - strong presentation, communication, and facilitation (both oral and written).
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring high-level data analysis and data management services.
• Experience with major querying tools.
• Skilled in gathering and business requirements and transforming them in reports.
• Proficient in designing Star Schema, Snow Flake Schema, OLAP and OLTPData Modeling using Erwin.
• Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/analysis, design, development, testing and production rollover.
• Code migration between environments, testing and QA.
• Experience in EXCEL with VBA.
• Design and implementation of ETL and Tableau.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Proficient in Databases such as Oracle, Microsoft Access, DB2 and SQL server2005/2008 and Teradata, Hadoop Hive.
• Well versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• Experience in excel pivot tables.
• Knowledge on HTML and java scripting.
• Successful as a team player to work in conjunction with other DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality

TECHNICAL SKILLS

BI Tools: Tableau 7.0/8.0/8.1/8.2, Qlikview, SAP BO (3.x/4.x), Cognos (8.1/8.2/8.3/8.4).

Databases: Oracle 8i/9i/10g/11g, SQL Server 2008; Teradata, Access 2000, MS SQL Server, DB2, HANA.

Languages: C, C++, HTML, Java, Oracle ETL, Informatica, SQL, PL/SQL, .NET (ASP, C#, VB)

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, MS Share point.

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis.

Operating Systems: Windows XP/2000/Vista/7/8, Mac OS X, DOS, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

Tableau Admin and Developer

Responsibilities:

• Developed Tableau dashboards according to user specifications.
• Extensively used Data Blending techniques in dashboard development.
• Supported different user groups and business domains.
• Good knowledge of tableau server, administrative functions, installation, configuration, back up of servers and load balancing techniques.
• Defined architecture for Tableau - establish Dev/QA/Prod environments
• Responsible for security configuration including user/ group setup, permissions, security roles, configuration of trusted ticket authentication
• Administrates active directory to manage user logins.
• Troubleshooting erroneous reports.
• Platform monitoring, availability, performance management, and service reporting (KPI)
• Setup new projects, security groups, roles and administer users for all supported platforms
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitoring of Tableau Servers for its high availability to users.
• Worked on Tableau Server upgrades for new versions.
• Providing Tableau Demo’s to new on boarding users.
• Experience on hive tables and develop reports.
• Worked on ways to increase the tableau performance.
• Developed worksheets and data visualization dashboards with graphs and filters.
• Created report schedules on Tableau server.
• Develop monthly reports and dashboards and perform query optimization.
• Created calculated fields as per business requirement.
• Defined best practices for Tableau report development.
• Used Tabadmin and Tabcmd commands in creating and restoring backups of Tableau repository.
• Involved in Production support for Tableau.

Environments: Tableau Server V7.0/8.0/8.1/8.2/9.0, Tableau Desktop, Oracle, Netezza, Teradata, Hadoop, Salesforce, Excel, Windows 2008 R2, Tomcat, java API.

Confidential, Detroit, MI

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Salesforce, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Monitored Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• 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.
• Created report schedules, data connections, projects, groups in Tableau server.
• Manage report analysis, requirement collection, communication with clients and providing delivery estimates.
• Support post production system and resolve/fix bugs or defects.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX, Hadoop, salesforce.

Confidential, Irving, TX

Tableau Developer

Responsibilities:

• Interacted and worked with ETL team for improving performance on data from multiple data sources
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE. This is done to improve Report performance.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Involved in the complete process cycle; functional skills in analyzing the client requirements: translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• 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 with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience with Tableau for Data Acquisition and data visualizations
• Used parameters to make dashboards dynamic.
• Worked extensively with Date, String and Logical Functions.
• Created Inventory trends, sales integration and forecast accuracy related dashboards.
• Worked with ETL team for performance improvement using custom SQLs.

Environment: Tableau 7.0, Informatica 9.1, SQL Server 2012, Teradata’s, Windows

Confidential, Mclean, VA

BO Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements & data specifications
• Migrated reports from BOXI R2 to BOXI 3.0.
• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Created and tested classes and objects to organize the universe.
• Created complicated reports including sub-reports, graphical reports, formula based and well formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created Objects using different Business Objects functionalities in the process of designing the universes.
• Linked the Universes to share the common objects between them.
• Created Alerts in various reports according to user requirement.
• Used Broadcast Agent to schedule the reports depending on the user profile.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined Conditions to use in Business Objects.
• Involved in designing Business Objects Universes, Queries, and Reports.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.

Environment: Business Objects XI R2/R3/XI 3.0(Desk I, Web I), Import Wizard, Repository, Migration Wizard, Xcelcius, Crystal Reports, SQL server 2005, Oracle 10g.

Confidential

MS SQL Server Developer

Responsibilities:

• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Created and designed data models using Erwin data modeling tool.
• Designed physical data models.
• Created DDL scripts to create database schema and database objects.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package and schedule the jobs for batch processing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Environment: SQL Server 2000, Visual Basic 6.0, and ASP. NET, Windows NT