SUMMARY

• Around 8 years of experience of IT experience which includes Analysis, design, development, Testing and Implementation of complete Software development life cycle and all aspects of gathering Business Requirements.
• Experience in Tableau 10/9.0/8.2 / 8.1/ 7.0 , OBIEE 11g and OBIEE 10.1.3.4.1 , Siebel Analytics 7.8 which include building and configuring repository, creating and managing Oracle / Siebel Intelligent Dashboards, oracle/Answers, Oracle / Siebel Delivers and Oracle / Siebel iBots (ETL Informatica, Reporting - Siebel Analytics, Scheduling-DAC), Oracle data integration(ODI)
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.1,8.0, Tableau 7 and Tableau 6.
• In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience in Installation, Configuration and administrationof Tableau Server in amulti-serverandmulti-tierenvironment.
• Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Created Dashboard’s using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
• Experience in Administering user, user groups, and scheduled instances for reports in Tableau.
• Experience in Tableau Server 8, online publishing, Sharing, and Tableau online.
• Extensively worked with Administration Tool to customize the RPD in all the layers Physical, BMM and Presentation Layers.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Experience in Data Modeling using Dimensional data modeling, Star schema modeling, Snow-Flake modeling, Physical and Logical data modeling.
• Extensive experience in building and administering the metadata repository and front end reports in answers/dashboards for both standalone and integrated Siebel Analytics applications
• Expertise in debugging, optimizing the Performance Tuning of Oracle BI / Siebel Analytics Repository & Dashboards / Reports and Informatica / Mappings / Workflows.
• Strong experience in setting up a Multi-User Development Environment (MUDE)
• Created session & repository Variables to achieve desired functionality.
• Implementing Siebel Security Setup (groups, object and data level), LDAP, External Tables, Single sign on (SSO) etc.
• Used EBS to track the performance of the database.
• Performed relational database design and normalization, client-server development, object-oriented analysis and design.
• Very good at inter-personal skills, problem solving with good technical background able to complete the task very frequently and works hard.

TECHNICAL SKILLS

Business Intelligence: OBIEE11g/ 10.1.3.4/3/2 , Tableau 9.0/8.2/8.1/7.0 , BIPublisher,SiebelAnalytics7.8

ETL Tools: Informatica 5.1/6.2/8.6.1 (Power Center), Oracle SQL developer.

Databases: MSSQL 2008/2005/2000 , MSAccess, IBM Netezza, Oracle9iOracle10gand 11g

Operating Systems: Windows 7 vista/XP/2000/NT/9x, MS-DOS, UNIX, Solaris, LINUX.

Languages: SQL, PL/SQL, C, C++, Java

Web Technologies: HTML, XML, XHTML

Data Modeling: ER Diagram, Entities, Attributes, Cardinality, Relational ModelingPhysical Modeling, Logical Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions)Tools Toad, SQL*plus, DAC, Auqadata Studio

PROFESSIONAL EXPERIENCE

Confidential, Houston - TX

Tableau Developer/Specialist

Responsibilities:

• Collaborate with business users to capture and design the business requirements and then contribute to designing and defining of data ware house BI Solution.
• Worked on recent tableau 10.0/tableau9.0 for credit risk management and procurement dashboards.
• Build Interactive dashboards for executive level users for procurement module.
• Providing Support to Business users with issues facing with Tableau reporting system.
• Implementation of Tableau reporting solutions.
• Design, develop and implement complex BI user interface objects (e.g. reports, analytics, ad-hoc queries, dashboards etc.) using Tableau Reporting tool.
• Design and support developed Dashboards.
• Data blending, Multiple Data source, Solving print out issues with tableau for users.
• Develop technical design documents and BI specifications that in corporate BI development standards & best practices
• Worked with SAP BW Developer for designing of report requirements through back end from source system for better performance, Built hierarchy for report uses for better understanding and user friendly report
• Troubleshoot performance issues of a BI environment and evaluate existing logic for tuning possibilities

Environment: Tableau 8.2/9.0/10.0 , Tableau Server, SQL/PLSQL, SAP BW, Remedy and Window

Confidential, Leawood - KS

Sr. Tableau Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Created Heat Map showing current service subscribers by color that was broken into regions allowing business user to understand the customer distribution and density.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Management of cache and Querying the SQL from OBIEE server back-end.
• Taken Care of Catalog migration and RPD Deployment.
• Used Netezza Auqadata Studio for Data Validation of the Dashboards and Query Scripts for Better understanding of data flow and calculation of the Metrics.
• Troubleshoot existing import/export processes to increase efficiencies and develop solutions.
• Support and conduct Root Cause Analysis on existing ETL processes to detect and correct issues with supplied data sources.
• Perform data analysis and research and farm and mine data from both a technical and business point of view.

Environment: Tableau Server v8/v9, Tableau Desktop v8/v9, Oracle11g, OBIEE 11.1.1.7.0 , 11.1.1.7.1 .14 , 11.1.1.9.1 SQL*PLUS, Netezza Auqadata Studio, UNIX, Windows XP and windows 7

Confidential, Boston

Sr. Tableau Analyst

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Migrated existing Micro strategy Reports to Tableau workbooks.
• Created Tableau extract files for improving the performance.
• Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for CHOP Enterprise wide Tableau application consisting of multiple key functional business domains.
• Participated in building and visualizing dashboards using Tableau Desktop.
• Used Tableau visualization software to generate Tableau combination dashboards.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Occasionally worked on Cognos reports and promotion of reports.

Environment: TableauDesktop 7.0/8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel, Oracle11g, OBIEE 11.1.1.6.2 , 11.1.1.7.0 , 11.1.1.7.1 , PL/SQL, SQL*PLUS, SQL*Loader, TOAD, UNIX, Windows XP and windows 7

Confidential, Englewood, CO

Business Intelligence Developer

Responsibilities:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Involved in creating dashboards and reports in Tableau 6.1
• Created report schedules on Tableau server
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Involved in requirements gathering, analysis, design, development, change management, Developed backup restore scripts for SQL Server as needed
• Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Configured and Scheduled Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Designed and developed logical model in BMM in Repository.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.

Environment: Tableau 6.0/6.1, Oracle11g, OBIEE 11.1.1.5, Informatica 8.1.0, DAC 7.9.4, SQL*PLUS, SQL*Loader, TOAD, UNIX and Windows XP.

Confidential, Houston, TX

OBIEE Consultant

Responsibilities:

• Gathered the needs and requirements from business end-users, management and other users for setting up environment to start.
• Interacted with business analyst to know the functional requirements for the date base to build.
• Installed and configured OBIEE environment components.
• Used EBS to track the performance of the database.
• Monitoring the Active Session Histories, Database Diagnostics Monitoring, Resource Management, and Query Optimization using EBS.
• Identifying and importing the tables (facts and dimensions) from the OLTP server.
• Creation and customizing the OBIEE repository three layers (physical, BMM, and presentation layer).
• Built alias table in the physical layer so that we can use without importing the tables several times from OLTP server.
• Used dimension hierarchy, aggregation tables, and time dimension wizard to make the data small, easy and redundant.
• Developed reports using prompts, filters according to the requirements in bi answers.
• Created interactive dashboard pages using dashboard prompts, guided navigation, and presentation variable to view mangers according to the requirement.
• Developed security level (data and object) for different users and groups. Created different types of views like pivot table, chart, and column selector.
• Implemented multi user development (MUD) for different groups.

Environment: OBIEE 10.1.3.4.1 , Administration tool, OBIEE Answers/BI Publisher/ Dashboards, Oracle 10g, Informatica Power Center 8.1, PL/SQL

Confidential, Santa Clara, CA

OBIEE Consultant

Responsibilities:

• Installed and configured the Oracle BI server and resolved the installation issues.
• Worked closely with Business Analysts and DBAs on physical database design.
• Presented Functional and Technical requirements information in Group Settings.
• Involved in Siebel Analytics related to data model and ETL, creation of detailed design documentation, accurately mapping requirements into Siebel Analytics functionality.
• Configured Oracle BI Scheduler in an application and server that manages and schedules the job.
• Involved in Conceptual Data Modeling (CDM), Logical Data Modeling (LDM) and Physical Data Modeling (PDM).
• Customized Business Mapping Layer, created Marketing Segmentation Criteria for respective customers.
• Involved in developing Informatica Mappings / Mapplets for ETL per changes in requirements.
• Involved in migrating reports from Siebel Analytics to OBIEE and Configured Proxy Users.
• Created various Ad-hoc reports for day-to-day Business Requirements making use of Global and shared Filters with different views in accordance with the requirements.
• Created sales reports to compare Current cycle and previous cycle sales using Pivot table views.
• Generated iBots using the Delivers to send notifications to the end-users.
• Involved in Data level and Object Level Security model in Analytics Presentation Catalog to view reports according to the user level Privileges and Permissions.
• Performed Repository Testing and Data Validation before Migrating OBIEE objects to Production.

Environment: Oracle BI, Siebel 7.7.1.x, Informatica Power Center, Oracle 10G, Windows XP.

Confidential, Phoenix, AZ

OBIEE Developer

Responsibilities:

• Responsible for setting up OBIEE Server, OBI Applications for pharmaceutical business needs
• Requirements gathering and interaction with the client SME’s to draft business requirements
• Responsible for converting business requirements into Functional and technical requirements
• Design Data model for Repository development
• Design and development of complex reports to derive Target efficiency Index, Activities, Account and Contacts
• Design and development of OBIEE Answers and Dashboards
• Design and develop ad-hoc reports for Account and Contact history
• Design and develop custom and customization of ETL mappings and workflows
• Responsible for setting up DAC execution plans and Administration
• Responsible for Administration of Oracle BI Publisher
• Design and develop complex reports for Sales module with write back options for forecast analysis
• Design and development of Business model and mapping
• OBIEE server, web administration Customized analytics web user interface
• Design users groups and maintain authentication of user groups
• Design and development of HLD, LLD and UTP
• Responsible for user manual preparation and training

Environment: Siebel 8.0, OBIEE 10.1.3.4, DAC 10.1.3.4, OBIA 7.9.5, BI Publisher, Oracle Business Intelligence Standard Edition, Oracle Warehouse Builder 10gR2, Windows Server 2003

Confidential, Melville, NY

OBIEE consultant

Responsibilities:

• Effectively interacted with business user and gathered information and requirements to specific documentation.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Implemented Comprehensive Security Model, by creating User Roles and Web Groups, and setting up External Tables and LDAP Servers.
• Created new logical column in BMM layer and used expression builder to mapping and for certain calculation measures.
• Used static and dynamic repository variables and time measures like ‘ago’ and ‘To date’ columns.
• Created highly formatted Executive reports in BI Publisher using MS Word plug in.
• Created and implemented interactive dashboards, aggregation and cache management techniques to improve performance.
• Developed and migrated from development environment to quality assurance environment and to production environment.
• Involved in meetings with mangers and business analysis in during the testing and application development lifecycle.

Environment: Oracle Business Intelligence OBIEE 10gR3, BI Publisher, Oracle 10g, Toad, UNIX.

Confidential

OBIEE consultant

Responsibilities:

• Communicated with business analyst and various end users for gathering the required requirements to setup the environment.
• Installed and configured the OBIEE 10.1.3.2 server.
• Participated in all the meetings for gatherings business requirements with end-users and business people.
• Working closely with Business Analysts and DBAs on physical database design.
• Created/Modified Metadata repository (.RPD) and Configured Metadata Objects using Siebel Analytics Server Admin tool.
• Extensively used OBIEE Admin tool to import the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Implemented Security by creating role, responsibility, and web groups using LDAP Authentication
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Successfully developed row based calculations in a pivot table for the reports based on RPD.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.

Environment: Oracle 10g, oracle 9i, SQL Server 2000, Toad, SQL, PL/SQL, HTML.