SUMMARY:

• Over 10+ years of diversified IT experience working with Tableau/OBIEE Admin, OBIEE Analytics, Oracle BI Applications, which include creating and managing Dashboards with Tableau and building and configuring repository, Dashboards with Oracle BI Intelligent Dashboards, Oracle BI Answers, Oracle BI Delivers, Oracle BI iBots, BI Publisher and Extraction Transformation and Loading data using Informatica.
• Experience in Installation, configuration, upgrade i.e. simple Configuration, 2 servers Cluster and administration of Tableau Desktop/Server.
• Experience in Tableau Administration Tool for Configuration, adding users, managing licenses, technical support, report design and monitoring of system usage and data connections, scheduling tasks.
• Experience in implementing SSO with SAML in Tableau 10.2/8.1.6.
• Expert in tableau server commands like synchronization, Tabadmin, Tabcmd and Tableau server backup activity.
• Expertise in resolving the reports and dashboards performance issues and implementing best practices.
• Experience in designing and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Expertise in designing and development of various dashboards, reports utilizing various 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 business/client requirement.
• 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.
• Experienced in Installation, Configuration, Upgrade, Patch, Migration and Administration of OBIEE, Oracle BI Apps, and Informatica Power Center.
• Expertise in Business Model development with Facts, Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management, Usage tracking.
• Experience in Administering Weblogic 10.3.6, creating Application groups, Roles and users in OBIEE11g.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Expert in implementing and handling the complex environments which include clustering of servers, Back up and Failover Strategies with connected and disconnected analytics
• Experience in implementing Security at object level and data level using Session Variables.
• Experience in implementing BI Security using LDAP, Oracle Identity Manager (OIM), and external database authentication. Implemented Single Sign on (SSO) using Kerberos and Site Minder.
• Experience in creating Aggregate tables using materialized views and using Aggregate Persistence wizard.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of the Box(Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW,OBIEE RPD development, OBIEE reports and dashboards.
• Designed and developed efficient Error handling methods and implemented throughout the mappings. Hands on experience in tuning mappings, identifying and resolving performance bottlenecks.
• Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports generated from Informatica and OBI Analytics.
• Experienced in troubleshooting production issues and production support for projects.
• Extensive experience in working with RDBMS like Oracle, Sybase, UDB and SQL Server.
• Experience in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts.
• Ability to define project technical requirements, documenting and communication for conversion into robust system designs.

TECHNICAL SKILLS:

BI/Reporting tools: Tableau 8.0.1/8.1.6/9.1/10.2/10.5 , Hadoop 2.7.2/2.4, OBIEE 12.2.1.3, 12.2.1.1.0 , 11.1.1.9.0 , 11.1.1.7.13 .1.1.6/5/3 , 10.1.3.4/3/2 , BI Publisher, Oracle Business Intelligence Applications 7.9.3

Data Modeling/ETL/Scheduling Tool: Informatica Power center 7.x, 8.x, 9.x, Star and Snow flake Design, DAC

RDBMS: Oracle 11g/10g/9i/, SQL Server 2005/2000,EXADATA.

Database Tools: SQL*Plus, SQL * Loader, ISQL, Rapid SQL 7.5, SQL Navigator

Change Management Tools: Clear Case, Clear Quest, Remedy, HP, ALM.

Web Technologies: HTML, Java, JavaScript, JDBC, XML, XHTML.

Programming Languages: C, C++, SQL /PLSQL and Shell scripting, VC++, VB Script.

Operating Systems: Windows XP/2000/2003/NT, UNIX (Solaris, Linux, AIX, HP UX).

PROFESSIONAL EXPERIENCE:

Sr.Tableau/OBIEE Admin

Confidential, Charlotte, NC

Responsibilities:

• Worked with functional and technical leads, business groups to identify, analyze, and document business requirements.
• Prepared Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Installed and configured Tableau Server 10.5/10.2/9.1 in DEV, INT, UAT, PROD and DR environments.
• Installed and configured Tableau Sever 8.0.1 and upgraded to 8.1.6 in DEV, INT, UAT, PROD and DR environments.
• Deployed Tableau Server in cluster environment by mapping server nodes to primary machine. .
• Configured SSO with SAML in Tableau 10.5/10.2.
• Migrated Tableau Dashboards, data sources across all the environments.
• Handled Tableau Server Management (like Clustering, Load Balancing, User Management etc) .
• Created backup scripts using Tabadmin and Tabcmd commands to take the periodic backups for the content on the tableau server and start & stop of the Tableau servers.
• Experienced in writing scripts to remove inactive users on the server.
• Designed group level security standards for Tableau.
• Set the user preferences in tableau to subscribe the Dashboards to users through email weekly/everyday by scheduling.
• Created users, Groups and projects in Tableau environment.
• Used OData URL of Sales force connector table to connect to the Tables.
• Experience in configuring reports from different data sources using data blending.
• Connected to web-based data sources with the Extract API.
• Schedule data refresh on Tableau Server for daily and increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Point of contact for Admin activities of Tableau/OBIEE & lead the development of Tableau.
• Configured Email alerts to receive to keep track of servers.
• Responsible for building scalable distributed data solutions using Hadoop.
• Good Understanding of Big Data and Hadoop technologies experience in loading, processing and extracting data in Hadoop environment.
• Exposure to Big Data Hadoop environment and its components HDFS, Apache Pig, Hive, Sqoop, MapReduce, HBase, Flume .
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Created guided navigation links for Interactive dashboards in Tableau.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axis, and Dual Axis.
• Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability
• Connected Tableau server with SharePoint portal and setup auto refresh
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Involved in preparing material and training Business users.
• Upgrade of OBIEE 12.2.1.3/12.2.1.1 .
• In-Place Up gradation and Configured OBIEE 11.1.1.6.5 to OBIEE 11.1.1.7.131017 in DEV, INT, UAT, PROD & DR environments.
• Installed and configured horizontal Cluster Configuration.
• Administered web logic 10.3.6.0 for OBIEE.
• Developed/tested/migrated the RPD and Web Catalog across all the Environments (Dev, INT, UAT, PROD and DR) based on the Architecture and business user requirements.
• Implemented Single Sign on (SSO) using Site Minder.
• Implemented authentication & authorization using LDAP & external BISQL Group provider.
• Installed and enabled Mobile Apps Designer, Cache Management and Usage Tracking in OBIEE.
• Configured security and MUD environment for different projects like Equities, Fixed Income, Real Estate, Sales & Distribution, Derivatives, AM Technology, IRD, AM Services .
• Created the shell script for the long running OBIEE queries and cancel those queries and deliver the Email notification to the users by setting up the cron job.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Automated the scripts for taking regular backups of Repository and Web Catalog files.
• Developed automation tool to seed and purge the cache in Admin tool.
• Involved in Performance Tuning in BI by implementing aggregate navigation and cache management.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
• Developed KPI’s and Scorecard’s for user, which help them reviewing their Business performance.
• Involved in setting up Ibots (Agents) to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Designed and developed Security Strategy and worked with Middleware to implement this in FMW.
• Modified NQSConfig.ini, Instanceconfig.xml files for Server configurations and troubleshooting reports performance.
• Developed Ad-hoc and standard Reports/dashboards with different Analytics Views - Drill Down, Drill across Cascading Style sheets, Pivot Table, Chart, Column Selector and Tabular With Prompts, Global and local Filters, Contextual Navigation, Business rules with user identity and role within the OBIEE suite.
• Implemented security by creating roles & web groups, checks with LDAP Authentication(Active Directory).
• Implemented Data Level Security and Object level Security using LDAP and External Tables.
• Experienced in working with BI (XML) Publisher, Data Templates, RTF, and XSL Templates and provided the capability to download the reports in the user defined formats.

Environment: Tableau 8.0.1/8.1.6/9.1/10.2/10.5 , Tableau Server, Hadoop 2.7.2/2.4, MapReduce, Hbase, Windows XP, UNIX (Linux Red Hat 5.3), OBIEE 12.2.1.3/12.2.1.1 , 11.1.1.6.5 , OBIEE 11.1.1.7.131017 , BI Publisher 11g, Informatica 9.0.1, Oracle 11g, EXADATA, TOAD, Salesforce.

Confidential

OBIEE Admin/Developer

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and generated reports as per the user requirements.
• Converted the Functional Specs to technical design and designed the overall RPD metadata development methodology.
• Involved in RPD Modeling which includes building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Upgraded OBIEE 10.1.3.4.2 to OBIEE 11.1.1.6.0 .
• Worked extensively using the Aggregate Persistence Wizard to create customized aggregates to improve the performance of the reports being generated.
• Designed and implemented the Bulletproof Single Sign on (SSO) using Kerberos Native authentication process so that users can navigate from the portal to the OBIEE dashboard.
• Developed Role-Based Dashboards for Region Managers, CFO and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users to resolve ongoing Production Issues by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.
• Created iBots to deliver reports to business users via email and to speed up some expensive queries by enabling the cache seeding functionality .
• Implemented security by creating roles & web groups, checks with LDAP Authentication.
• Developed Dimensions and Time Series objects in the Business Model and Mapping Layer with Security settings in Analytics Admin Tool to setup groups, access privileges and query privileges.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.
• Configured metadata objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboard, Pages, Folders and Reports).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Developed Reports/Dashboards with different Analytics Views (Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters) using Analytics Web.
• Extensive Performance tuning in BI by implementing Aggregate navigation and cache management.
• Created templates for presenting results and Analytics and modified the Dashboard using cascading style sheets.
• Involved with support team in Deployment and Administration of the release code to various environments (SIT/UAT/PROD FIX/PRODUCTION).
• Responsible for Implementing DAC Process Life Cycle i.e. Setup, Designing, Execute, Monitor.
• Involved in Design and Data Modeling using Star schema, Logical & Physical Database Layout Design.
• Created ad-hoc reports, reports with parameter fields, complex reports running from stored procedure, sub reports on request from main report, reports from different databases and reports with complex calculations and Running totals report.
• Designed & assisted ETL developer to create new Aggregate and performed Data conversions.
• Involved in troubleshooting the load failure cases, including database problems.
• Performed extraction, transformation, and loading (ETL) for data warehouses by consolidating data from heterogeneous data sources.
• Involved in performance tuning of targets, sources, mappings and sessions.

Environment: Windows 2003,UNIX ( Linux Red hat 5.3), OBIEE 10.1.3.4/10.1.3.4.1/10.1.3.4.2 , OBIEE 11.1.1.6.0 , (Oracle BI Admin Tool, Answer, Presentation Services), DAC, Oracle 10g, TOAD, Informatica 8.1.1, BI Publisher 11g .

Confidential

UNIX Developer

Responsibilities:

• Enhance the product based on Client requirements using C++,Multi-threading, Socket Programming TCP/IP and SNMP.
• Analyze, Implement the change requests received for the multiple modules.
• Debug the code to fix the Production Issues and Software Quality Defects.
• Bug fixing and Maintenance of the Product.
• Created Cron job to schedule nightly batch execution.
• Involved in developing UNIX Scripts to Automate test scripts on batch process.
• Debug the code using DBX & GDB debuggers.
• Enhanced the existing UNIX scripts to achieve better performance and throughput.
• Experience in Multithreading concepts
• Experience in DLL development.
• Experience in Socket Programming, SNMP, TCP/IP etc. using Socket APIs.
• Strong OOAD Development Skills in C++ using Rational Rose, UML.
• Created proper documentation for each phase of development or enhancement.
• Reviewed documents prepared by team members and provided proper timely feedback.
• Prepared concise requirement definitions.
• Analysis and documentation of Server code in UML( Use-Case, sequence diagrams).
• Coordinating with team for the development part.
• Perform testing on Japanese OS using VPDC.
• Getting sign off from the users post implementation.

Environment: Windows & Unix (Solaris, Linux, HP-UX, AIX ), C, VB, C++, Visual Studio 2005, VB 6.0, Rational Rose, D-Oxygen, TeraTerm, FileZilla Cute FTP, VM Ware, Eclipse, Update Advisor, Pyxis, Atlas Translator, Microsoft Visual Studio 6.0, Microsoft Visio, PROASQ .