SUMMARY

• Confidential is Certified Tableau consultant having 6+ years of experience in Tableau and 10+ years of Experience in OBIEE, Siebel Analytics, INFORMATICA and ORACLE, Teradata Database. He has experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet & Client Server environments.
• Excellent knowledge in Data warehousing’s Concept and reporting Platforms. Sound knowledge’s in financial services domain Such as Fixed Income Portfolio Management, Derivatives, Equity and Middle office, Back office Operations and Settlements.
• Expertise in providing End - to-End business intelligence solutions using Tableau, OBIEE/Siebel Analytics
• Developed Tableau workbooks from multiple data sources using Data Blending Concept.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• 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.
• Restricted data for particular users using Row level security and User filters.
• Provided 24/7-production support for Tableau users.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Developed a 360 business dashboard with multiple panels and parameters that became a favorite Measure tool for Fixed Income Portfolio manager
• Develop reports, dashboards using Tableau 9.1 for quick reviews to be presented to Business and IT users.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Fine \tuned SQL Queries for maximum efficiency and performance
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Involved in (OBIEE 11G upgrade) up-gradation of OBIEE 10.1.3.4.1 to 11.1.5.1.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool - Physical, Business Model and Mapping, and Presentation Layers, Time Series Wizard, Event Polling, Usage Tracking Tables, User, Group level Security and variables.
• Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization.
• Expert level experience in BI Publisher and BI Publisher integration with OBI.
• Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports and navigational reports.
• Expertise in OBIEE Customization, Custom Graphics and CSS style sheet to change the Dashboard look and feel.
• Expertise in Multi user Environment Setup (MUD), Cache management configuration.
• Excellent understanding of Star Schema/Snow flake Schema methodologies and Dimensional Modeling.
• Very good Knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Reports.
• Expert knowledge in understanding the queries generated by OBI to fine tune OBI response time in ORACLE 10/11G.
• Strong Experience in Oracle Out of Box ETL mapping (SIL and SDE) and Informatica Workflow and ETL tuning and DAC Server Configuration
• Experience in creation and customization of ETL processes using Informatica Power Center.
• Experience in developing various Informatica Transformations and Mappings
• Very good Knowledge in developing Informatica Mappings / Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) for ETL of data from Multiple Sources to Data Warehouse.
• Expertise in SQL, Oracle PL/SQL and SQL server that involves Execution plan, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes.
• Multi-platform experience on UNIX / Linux and Windows Server family.
• Managing and supporting the entire testing life cycle (INT/UAT).
• Involved in OBIEE Admin/Production Support.

TECHNICAL SKILLS

• Tableau 8.*/9.*/10.*
• OBIEE
• BI Publisher
• Informatica
• Autosys
• Gentran
• IBM sterling Integrator
• Manifest
• Message Queue
• Charles River (CRD)
• Bloomberg AIM
• GNET GATEWAY
• AXIOM
• RMS MIU
• OASYS
• Perform
• INTEX
• Web Services
• Bloomberg API
• Fix Protocol
• SAPI
• XML
• JAVA SCRIPT
• SQL SERVER 7.0/2000/2005/2008
• ORACLE 9i/10g/11g
• Microsoft SharePoint Server 2003/2010
• Unix
• Shell scripting
• Toad.

PROFESSIONAL EXPERIENCE

Lead BI Developer

Responsibilities:

• Designing data model from scratch to aid team in data collection to be used for Tableau visuals
• Develop Tableau Data Extracts from the Oracle/Teradata data sources using Infomraica Data Integration ETL tool.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control
• Developed Ad-hoc reports using Tableau Desktop, Excel
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (9.x) reports
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created and developed Parameterized, Drill Down and AD Hoc Reports
• Interacted with the existing database developers and DBA to understand the existing schema.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
• Created visuals for Equity team workflow optimization using custom non-native Tableau charts such as Radar Graphs and Control Charts
• Consolidated multiple Tableau workbooks into single workbook for TIAA FI business group as single source Tableau report central
• Developed Tableau visuals for Controls and Compliance team mapping banking regulations to internal policies, standards, and processes to be used in presentations for TIAA leadership
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool
• Involved in Tableau Architectural design meeting and Administration, including deployment of Tableau Server in clustered environment and performing upgrades, as well as experience implementing Proactive Tableau Environment Health Checks and Performance Threshold Alerting.

Lead BI Developer

Responsibilities:

• Interact closely with business users & assist in enhancing existing dashboard design and visualization.
• Meeting with portfolio manager and Middle office user to understand the Ad-hoc reporting requirement
• Develop the Ad-hoc tableau dashboard and report based on the requirement.
• Draws upon a full range of Tableau features to design, develop, enhance and support Tableau visualizations including, but not limited to, highly interactive dashboards, scorecards and reports
• Design and develop Tableau visualization solutions.
• Work on generating various dashboards in Tableau server using various data source
• Install upgrade Tableau server and server performance tuning for optimization.
• Involved in Administer user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting.
• Effectively utilizes features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products.
• Developing dashboards using Tableau, and working with the associated server product to perform dashboard security and administration;
• Collaborates with Enterprise Data Warehouse (EDW) team to ensure data sources are available and/or developed to support Tableau work products.
• Collaborates with BI team to ensure metrics, benchmarks and related content are accurately represented in published content.
• Support peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting, analysis of results, Production Support, and identification of opportunities to solve clients’ problems through BI.
• Mentor and support less experienced Tableau developers.
• Provide assistance to Tableau users on use of existing reports.
• Communicate technical report requirements to non-technical business partners.
• Created Complex SQL query to fulfill tableau requirement and business need
• Involved in high level designs, development and unit testing of ETL using Informatica.
• Proof-read all documents and maintain accuracy of information and preparing SOP.

Senior BI Developer

Responsibilities:

• Performed GAP Analysis to gather functional mapping by coordinating with the Business Users.
• Involved in meetings/interviews with Users, BSA’s, and examined the business, functional and technical design documentation.
• Involved in creating POC’s (proof of concepts) for Tableau 9* new features and business functionalities with the architect team and business users.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.
• Involved in creating POC’s (proof of concepts) for OBIEE 11g- BI Publisher
• Develops OBIEE reporting platform using knowledge of Portfolio Management and security analytics that spans across multiple security types.
• Developed the repository (Physical layer, Business model and mapping layer and presentation layer).
• Created dimensions, dimension hierarchies, levels (to support drilldown), level based calculations and defined level attributes, level keys and Aggregation Navigation.
• Works in conjunction with System Administrators for migration, deployment and performance tuning of repositories.
• Designed reports with drilldown, pivot, bar charts, view/column selectors, guided navigation, direct database requests in Answers each with varying levels of complexity.
• Configured dashboards for different groups of users according to security level (high, medium, low). Expertise in Object level security (Web Catalog folder/group permissions) and Data Level Security.
• Created Agent to generate alerts and delivered it to target users.
• Provides Ad-hoc report and platform/dashboard development and design using the following Oracle BI features-(BI Answer, BI dashboard, BI delivers, Agent).
• Involved in leading the ETL team for various Development and Enhancement projects. Working closely with the business users to understand the requirements and converting them into project level technical capabilities. Worked with business analysts to identify the appropriate data elements for required capabilities.
• Involved in Project Effort estimation - Prepare a breakdown of tasks involved in a project, assess complexity, parallel tasks & estimate effort involved in each of the tasks
• Developed technical specifications of the ETL process flow using Informatica as ETL in Oracle & SQL Servers. Uses SSIS for multiple service call projects

Environment: Tableau 8.*,9*, OBIEE, BIP, Informatica, Oracle 9i/10g, OLTP Database, Teradata (OLAPdata base),Fixed Income Trading Application, Charles river, Bloomberg AIM, GENTRAN, Sterling Integrator, FTP, Eagle Pace, LVTS, Murex, UNIX, Windows XP.

BI Solution Architect

Responsibilities:

• Metadata Configuration - Physical Layer, Business Model & data mapping & Presentation layer.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source in OBIEE BMM Layer.
• Developed Custom warehouse tables to populate Account, Proposal, Product, Opportunity and Time Dimensions and Fact and aggregated Facts.
• Created users and groups and assigned explicit and individual permissions and privileges to access the data.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Responsible for making the end users understand the features of Answers. Object level security for each dashboards, pages and reports.
• Created Write back screen for the business user to modify the fact extension purpose
• Created Dash board for Mortgage Loan officer, Front office and back office
• Integration of BI Publisher with OBIEE dashboard and
• Worked on OBIEE Integration with External java application using Oracle BI Web services.
• Involved in Performance tuning in Database level and OBIEE application level.
• Develop appropriate ETL routines and mappings using Informatica based on the requirements and technical design.
• Created Execution Plans, Subject Areas, Tasks and Repository Management using DAC.
• Reviewed the ETL design done by ETL team and assist them for the successful ETL run in DAC.
• Coordinate and develops process automation/job scheduling, conduct code reviews, testing and defect analysis.
• Involved in all the migration process from DEV, INT, UAT and PROD.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Extensive Experience in testing and Production Support.

Environment: OBIEE 10g, Web & Admin Tool, Informatica 8.6.1, DAC, Oracle 9i/10g, UNIX.

OBIEE-Consultant

Responsibilities:

• Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications
• Provided Answer blocking Alert when the user not selecting appropriate criteria.
• Implemented the data level security/Object level Security according to the coverage team login.
• Worked in Informatica mapping and ran the full load and incremental load through Informatica and DAC Server.
• Implemented OBIEE fragmentation to improve the performance of the report.
• Involved in data modeling and designing of this project and worked as a meta data developer
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector and Tabular with global and local Filters), using Siebel Analytics Web.
• Configured OBIEE IBOTS to deliver Analytics content based on schedule, automated IBOTS queries to obtain daily and weekly reports.
• Worked closely with business users to resolve ongoing production problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Provided knowledge transfer and documentation to support group.

Environment: Siebel Marketing & Service Analytics (Web, Admin Tool & Segmentation), Informatica 8.6, DAC and Oracle 9i/10g & Siebel.

OBI Meta Data Developer

Responsibilities:

• Configured Oracle BI scheduler in an application and server that manages and schedules the job
• Configured Proxy Users.
• Worked in System Subject Area and Delivers.
• Worked in Setting Up Direct Insertion to Collect Information for Usage Tracking.
• Involved in Data level and object level security model in OBI presentation catalog to view their report, according to the user level/position and permission.
• Created metadata development in OBIEE Admin tool.
• Development, test, implement and supports all aspects of the OBIEE platform, Business Analytics and Reporting.
• Created physical joins, logical joins and complex joins in Physical and BMM Layer.
• Involved in Data drilldown, level based measure implementation
• Worked in LDAP configuration And External Database Authentication
• Created different types of Reports, views, dashboards and pages according to business requirement
• Involved in Unit Testing and QA Testing.

Environment: OBIEE, Web & Admin Tool, Informatica, Oracle 9i/10g, SAP, Siebel & People Soft.