SUMMARY

• Over 8 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Solid understanding of SQL, understand and have worked with various data source types like Oracle, Neteeza, SQL server.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Used OData URL of Sales force connector table to connect to the Tables.
• Experience in configuring reports from different data sources using data lending.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML
• Improved Reports performance in tableau using extracts and context filters
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x, OBIEE 11g/10.1.3.4

ETL Tools: Informatica7.x/8.x (Power Center)

RDBMS: Oracle 9i/10g/11g, MS SQL Server 2008, Teradata

Languages: HTML, XML

Operating Systems: Windows 95/98/NT/2000/XP/7

FTP ToolsWin: SCP 5.X, FileZilla 3.5.x, Putty

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Sr. Tableau Consultant

Responsibilities:

• Develop various data connections from data source to Tableau Server for report and dashboard development
• Creation of metrics, attributes, filters, reports, and dashboards, created advanced chart types, visualizations and complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and published them to the web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Utilize Tabadmin and Tabcmd commands to create backups and restore backups of Tableau repository.
• Hands on experience in Tableau server maintenance and Tableau server backup activities.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Environment Support to User community, Service Request & Resolution.
• Expertise in failed over activities in production Environments.

Environment: Windows XP, Tableau 8.1/7.0, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and JavaScript.

Confidential, New Jersey

Tableau Consultant

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tab.leau server
• Used commands in Tabcmd and Tabadmin utility tool.
• Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads, process flow of the mappings, and provided Knowledge Transfer to the end users.

Environment: Tableau 7/8.0, Tableau 7 Desktop, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Confidential, Boston, MA

BI Consultant

Responsibilities:

• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Experience in Preparing Design Specification documents based on functional requirements and involved in the preparation of Technical Design Documents.
• Used MUD environment during development of the project.
• Responsible for Creating the Physical Layer, Business Model and Mapping Layer and Presentation Layer in ANA Repository (.RPD) using Oracle BI Administration Tool.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Ago(), To Date based on the Requirements.
• Created Attributes and Metrics in the BMM layer.
• Created Aggregated Tables to improve the Performance of the Reports.
• Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and established the various standard queries, in order to support the presentation layer.
• Security settings in Oracle Administration Tool to set up groups, access privileges, query privileges, and manage security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to 11.1.1.6.0.
• Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.
• Used theCatalogmanager and maintained the web catalog to manage Dashboards and Answers.
• Test the reports and data in OBIEE against Micro strategy and validate them.
• Responsible for documenting the OBIEE framework and track the progress.

Environment: OBI 10/11g, Informatica Power center 7.1.2/8.1,Oracle 11g, Microsoft Windows Server 2003, MS VISIO.

Confidential, CA

BI Consultant

Responsibilities:

• Upgraded the existing Siebel Analytics Application on 7.8.4 to Oracle Business Intelligence 10.1.3.2
• Migrated the existing Web Catalog using SAW Migrate utility.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Added Aggregate measures using Aggregate Persistence Wizard.
• Configured Business Intelligence Delivers
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sing on (SSO) functionality.
• Involved in setting up Clustering of Oracle BI servers for Load Balancing.
• Developed automation tool to seed and purge the cache in Admin tool.
• Migrated the Repository from Development to Production using UDML Utilities.
• Designed Interactive Dashboards and created dashboard prompts.
• Involved in configuring sources, targets, tasks and execution plans using DAC.
• Have developed requests/custom reports using Siebel Answers based on Sales and Promotion subject areas in order to analyze and understand the Sales Opportunities and Promotion details by Brands/Promotions, Forecast to Estimated spending.
• Involved in development of reports like campaign budget, Breakeven(CBAB) and campaign management reports
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Used Informatica to extract the data from Siebel CRM, transform and load to warehouse.
• Acted as a single point of contact for the Global data mart for coordinating the development across the platform. Responsible for onsite- offshore co-ordination.

Environment: Oracle Business Intelligence 10.1.3.2,Siebel Analytics 7.8.2/7.8.4, Siebel 7.5.3.4, Informatica Power center 7.1.2/8.1, DAC 7.7,Oracle 10g.

Confidential, Austin, TX

BI Developer

Responsibilities:

• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Experience in Preparing Design Specification documents based on functional requirements and involved in the preparation of Technical Design Documents.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Added Aggregate measures using Aggregate Persistence Wizard.
• Enabled Usage Tracking Table and Dashboards.
• Configured Business Intelligence Delivers
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sing on (SSO) functionality.
• Developed automation tool to seed and purge the cache in Admin tool.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level.
• Involved in designing STAR schema and developed complex Mappings / Mapplets using various Transformation / Re-usable Transformations (Update Strategy, Filter, Router, Expression, Lookup, and Aggregator) for implementing Dealer Data Warehouse.
• Designed and developed Pre and Post session tasks and data extracted from Transaction System into Staging Area.
• Developed custom SDE and SIL mappings to extract and load the data into Warehouse.
• Experience in customizing out of the box reports to support the business requirements.
• Experience in configuring sources, targets, tasks and execution plans using DAC.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Involved in assigning and managing privileges and rights given to the appropriate users and groups using Oracle BI Presentation Services Administration.
• Involved in the creation of Presentation groups and users to provide access to the appropriate reports and dashboards.
• Involved in managing the users to access Interactive dashboards by using the security matrix.

Environment: Oracle Business Intelligence 10.1.3.2,Siebel Analytics 7.8.2/7.8.4, Siebel 7.5.3.4, Informatica Power center 7.1.2/8.1, DAC 7.7,Oracle 10g.

Confidential

BI Developer

Responsibilities:

• Created custom functions, stored procedures and packages to retrieve the data from tables.
• Involved in creating synonyms to reduce the usage of base tables to securing the data.
• Extensively used cursors, cursor for loops to fetch the data from different tables.
• Involved in writing UNIX shell scripts.
• Developed and deployed the User Interfaces using Oracle Developer 6i Forms.
• Developed and deployed the reports using Developer 6i Reports.
• Performed optimization of SQL queries (Used Explain Plan, TK-prof and Hints to tune SQL Queries.)

Environment: Oracle 8i, PL/SQL, Sun Solaris 5.0, Forms 4.5i, Reports 5, TOAD, SQL * Loader