SUMMARY

• IT Professional with 8 years of experience in Software Analysis, Design, Development Integration, Testing, Migration, troubleshooting, Production support, and Implementation of Business Intelligence (BI) and Database Applications.
• Extensive Experience on Tableau Desktop, Tableau Reader and Tableau Server in Enterprise Environment Tableau 7.0, 8.0, 8.1 versions
• Solid experience in Business Intelligence solution design, development and process documentation to produce required reporting and analytics deliverables using Tableau Software Dashboard development
• Architected best practices in determining a Live connection versus a Tableau Data Extract
• Experience with designing and developing complex tableau dashboards for monitoring corporate KPIs while taking advantage of all tableau features including Quick Filters, Filter Actions, Tiled and Floating objects, Sizing, Dynamic Title Sheets etc.
• Strong advanced tableau developer skills including table calculations, complex calculations, parameters, geographic mapping, data blending, extract optimization
• Solid experience with connecting Tableau to multiple disparate data sources and working with relational databases and demonstrable ability in designing new tableau workbooks as well as optimizing existing workbooks for business users
• Extensive knowledge in various reporting objects in Tableau such as Facts, Dimensions, Hierarchies, Filters, Parameters, Calculated fields, Sets, Groups
• Strong technical background with complete understanding of data warehouse modeling, architectures, OLAP, OLTP data sets
• Architecting, designing and optimizing Tableau platform for business users (include troubleshooting performance, environment and availability)
• Tableau Server Experience with creation of users, groups, projects, workbooks and teh appropriate permission sets for Tableau server logons and security checks
• Published tableau workbooks on Tableau Server with view permissions and scheduling & autantication features for refreshing teh extracts on a particular schedule
• Experience on Tableau admin activities such as granting access, Tabcmd commands such as creating users from .csv, creating groups and adding users to groups, publishing a workbook
• Implemented Standards and Best Practices for Enterprise Tableau Environment.
• Mastered teh ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau
• Solid experience in Data Analysis & Data Visualization Tools such as Business Objects (BO) Explorer and SAP Lumira
• Firm experience as a Business Intelligence (BI) Consultant with specialization in SAP Business Objects (BOBJ) Product Suite including UDT, IDT, Web Intelligence, Dashboards, Crystal Reports
• Committed to excellence, Problem Solving skills, Troubleshooting and Decision Making skills

TECHNICAL SKILLS

BI Softwares: Tableau Desktop 7.0, 8.0, 8.1, Tableau Server, Tableau Reader, SAP Business Objects (BOBJ) 3.1/4.0, IBM Cognos 8 BI Suite

ETL Tools: SAP Business Objects Data Services 4.1 / 4.0 (BODS), Informatica

Language Skills: SQL, PL/SQL, SQL Scripts C, C++, JAVA, UML

Databases: SAP HANA 1.0, Oracle 9i/10g, SQL Server 2008, Teradata, MS Access

Domain: Data Warehousing, Data Modeling, Business Intelligence, Big Data

Certifications: SAP HANA Certified, IBM Certified Cognos Developer

Operating Systems: Windows 95/ 98/ XP/Vista, UNIX and Linux

PROFESSIONAL EXPERIENCE

TABLEAU LEAD

Confidential, New Brunswick, NJ

Responsibilities:

• Worked closely with business users to define reporting requirements and documenting teh requirements in order to design, develop and maintain Tableau Workbooks
• Designed Tableau dashboards using techniques for guided analytics, interactive dashboard design and visual best practices to convey teh story inside teh data
• Developed tableau reports including highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps
• Implemented teh best practices in designing & developing Tableau Dashboards such as limiting teh dashboard to fully answering only one scenario preferably, with optimum usage of Filters, Actions & Work sheets, turning on quick filters, customizing tool tips, controlling teh sizing & layout
• Implemented row level filtering, summary level filtering and advanced condition filters by field or by formula for meeting teh specific business requirements
• Designed Reports with features such as Row Banding, Point, Mark, Area Annotations, Tooltips, advanced sorting with parameters
• Analyzed teh source data and handled efficiently by modifying teh data types and also executed advanced calculations for controlling teh granularity of date, converting a number or string date data type to tableau date
• Created compelling, interactive, data driven story points with respect to OTIF Delivery KPI
• Published Workbooks by creating user filters so dat only appropriate teams can view it
• Designed and deployed interactive reports with Drill Downs, Drop down menu option, Parameters and Linked reports using Tableau
• Connected to various data sources such as excel sheet, flat files, CSV files to generate Tableau adhoc reports to users
• Involved in Tableau Server administration of setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances
• Established a connection and necessary plugins from Tableau Desktop to teh SAP HANA via ODBC
• Consumed teh SAP HANA data models from teh SYS BIC schema and developed Tableau visualizations on top of SAP HANA data models
• Involved in teh design and development of SAP HANA data models such as Attribute Views, Analytic Views and Calculation Views in response to teh Tableau reporting requirements
• Involved in creating complex data models by using Graphical Approach Method and by SAP HANA programming including SQL Script or CE Functions Method such as CE CE COLUMN TABLE, CE JOIN, CE PROJECTION and CE CALCULATION functions needed for Pricing calculations
• Implemented teh best practices in SAP HANA Data Modeling such as avoiding data transfer between HANA engines, pushing data intensive logics into SAP HANA database, preferring CE functions over SQL Script, avoiding complex expressions and expensive calculations so as to gain teh Optimal Performance of Tableau Dashboards with integration of SAP HANA
• Involved in POC for evaluating SAP Lumira and Tableau for Visualization solution
• Developed and Published SAP Lumira Storyboards for specific use cases dat can visualize, analyze trends and share insights across teh entire organization
• Monitored 2 associates and trained users in Tableau Server

TABLEAU DEVELOPER

Confidential - Irving, TX

Responsibilities:

• Worked with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them in tableau
• Design reports/graphs/presentations using Tableau for specified projects. Produce accurate analyses of project datasets as defined by teh required specifications
• Performed aggregated level calculations across various dimensions and row level calculations for visualizing teh discounted prices at row level
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Developed complex dashboards with features such as Filter Actions, URL Actions, Sizing, Tiled and Floating Sheets
• Described logic and teh design of data queries and calculations used to extract and format data for project reports and external presentations
• Developed Tableau Dashboards for teh top management dat emphasize teh corporate Key Performance Indicators (KPIs) with rich visualizations
• Published tableau workbooks to Tableau Server with scheduling & autantication options
• Executed complex calculations using teh functions such as ATTR, IFNULL, ZN, ISMEMBEROF, DATEDIFF, DATETRUNC, and DATEADD
• Created Story Points, added & updated content, additional points, fitted visualizations in stories
• Import data from various data sources - Excel, SQL server into Tableau for analysis & visualization
• Worked with ETL team & data architects to ensure dat right data points are captured and system is stable for high volume, critical and advanced analytics
• Created computed sets by using teh condition & top options or by using a formula
• Executed various Tabcmd commands such as creating users from .csv, creating groups and adding users to groups, publishing a workbook
• Built and expanded reports available for both internal support and external customer reports, which included increasing teh scope of data extracted and better utilization of reporting
• Handled Tableau admin activities granting access, managing extracts and Installations
• Mentored analytics team on Tableau basics and had sessions with managers on Tableau presentation FAQs with a walkthrough of Executive and Daily Stats dashboards

TABLEAU DEVELOPER

Confidential, Miami, FL

Responsibilities:

• Developed tableau dashboards dat consumed teh views including text tables, horizontal bars, pie charts, bullet graphs, filled maps, dual axis
• Interacted with clients in gathering, understanding teh business requirements and translate business data needs into creative graphical rich visualizations in Tableau
• Developed Tableau dashboards with a variety of visualizations as per teh business requirement specifications
• Establishing teh desired connection between live and extract in improving teh performance of Tableau reports
• Build and publish Tableau workbooks utilizing complex calculated fields, table calculations, Sets, filters, parameters
• Facilitate development of common objects dat can be shared across multiple development groups to drive development efficiency and user experience consistency
• Used various types of filters such as Data Source Filters, Custom SQL Filters, Normal Filters, Context Filters and Quick Filters
• Developed Tableau dashboards with various components or objects such as Tiled, Floating, Horizontal, Vertical, text, Quick Filters, Actions, controlling teh sizing & layout
• Executed teh various options of connecting live data, Import all data, Import some data into Tableau's fast data engine
• Generated tableau dashboards for sales with forecast and reference lines
• Created groups in various ways including from a dimension header, from marks on a view
• Participated in project sessions and generated Daily reports, Weekly Reports, Monthly Reports as per teh end user and senior management requirements

SAP HANA Modeler

Confidential, Germantown, MD

Responsibilities:

• Primarily Responsible for SAP HANA Data Modeling and Analysis including Requirements gathering
• Created SAP HANA modeling views such as Attribute Views, Analytic Views and Calculation Views
• Developed complex data models using either by SQL Script or CE Functions dat includes variables & Input Parameters, restricted and calculated measures including various aggregation types such as Min, Max, and Sum
• Experience in working with Content models, Attributes, Measures and Hierarchies in SAP HANA
• Created level based and parent child hierarchies to visualize & analyze data in a hierarchical fashion and accessed via SAP BO Analysis Office
• Created various privileges such as SQL privileges, Object privileges, Package privileges, Analytical Privileges for teh users & roles in HANA Studio
• Provided guidance and advice to SAP Customers, Pre-sales and Solution Architect resources on teh development of HANA solutions
• Involved in creation of Repositories, Projects, Workflows, Data flows, Data Stores using BO Data Integrator
• Loaded teh Data from Different Files such as Flat Files, Spread Sheets, XML Files to SAP HANA using Data Integrator Designer
• Involved in Data Cleansing and Data Services Transformations such as Query Transform, Case Transform, Row Generation, SQL Transform, Merge Transform
• Leveraged knowledge of data warehouse and software development methodologies to contribute to teh overall planning of projects by recommending approaches, identifying resources
• Developed WebI reports dat includes features such as ranking, section, break, sorting, data tracking, alerts or conditional highlighting, context operations including for all and for each
• Interacted with Users and Business Analysts to understand and document teh requirements and translate these to technical specifications for designing Universes and model them in teh data foundation using Information Design Tool (IDT)
• Resolved loops and traps in universes by using alias tables, contexts, short cut joins
• Created WebI reports with query filters and report filters via filter bar, filter pane and by input controls using Radio buttons, check boxes, list boxes, sliders
• Designed and developed WebI documents with charts for easier Trend Analysis for various costs and included alerts or conditional formatting in each reports for threshold costs

SAP BO consultant

Confidential, Cincinnati, OH

Responsibilities:

• Involved in planning sessions with managers to analyze requirements and outline teh solution
• Created graphical representation of reports such as Bar, Pie, Column, and Line Charts as per End user requirements. Developed full client and Web Intelligence Reports
• Created various types of query filters such as single value or multi value filters, predefined filters or conditional filters, prompted filters, complex filters in WebI Reports
• Worked closely with business users to define reporting requirements and documenting teh requirements in order to design, develop and maintain Business Objects reports
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets
• Dashboards include different components like Column Chart, Stacked Chart, Web Link, and Maps dat uses teh Dynamic Visibility, Alerts, Behavior and Data Insertion features
• Created & tested reports using Business Objects functionality like Queries, Drill down, Filters
• Created Universes with Measures, Dimension objects, Join conditions, Filters, LOV's, Cardinalities, Hierarchies, @functions, Aggregate Awareness, Index Awareness using Universe Designer
• Trained end users in working with Business Objects user module & provided technical expertise
• Identified and resolved loops & traps (Chasm & Fan) in teh universes by using alias tables, contexts, short cut joins
• Involved in putting up Production support documentation and user manuals for teh end user understanding and training

Business Intelligence (BI) Developer

Confidential

Responsibilities:

• Developed various adhoc reports, list reports, cross tabs, charts reports, Dashboards by using IBM Cognos Report Studio and Query Studio
• Created Master-Detail Reports, Drill Through reports to various levels in Report Studio
• Interact with teh users in teh weekly status meetings, halped/trained users in building reports
• Conducted requirement analysis, planned, designed, estimated and created design document
• Developed reports with features including advanced prompts, cascading filters, hierarchies, conditional formatting in Report Studio
• Created Schemas using dimensional Modeling of Star and Snow Flake Schema
• Prepare detail technical and functional documents for teh reports developed Prepare low level and high level report requirement templates based on teh client specification
• Scheduled teh reports on daily basis and periodically as per teh business requirements
• Embedded complex reports functionalities such as Centralized Prompt Page by using JavaScript

Cognos Developer

Confidential

Responsibilities:

• Create list reports, cross tabs and chart reports by using IBM Cognos Report Studio
• Created User Prompts, Conditions and Filters for various reports to specify teh various parameters as per teh business rules and requirements of teh end users
• Designed and implemented Data Models to meet existing and future anticipated reporting requirements
• Develop reusable assets using JavaScript dat can incorporated for other projects developed
• Mocking up teh data considering security and confidential data. Thorough Documentation of all teh Reports with Report definition, field definitions and layouts
• Developed drill through, slice and dice, master detailed reports to analyze teh support engineers performance (daily, monthly, quarterly, annually)
• Developed framework models and incorporated teh requested changes in teh existing reports
• Perform unit testing regularly against teh databases to check consistency of teh reports