SUMMARY:

• Over 12 years of strong IT experience as an BI Analytics, OBIEE Architect, OBIEE Technical Lead, Tableau Consultant and AWS Solution Architect, Informatica Admin and Informatica Lead Developer 9.5.1 and Managing OBIEE Team, Development of OBIEE Dashboards and Repositories, Designing the OBIEE Platform in OBIEE Versions of 11.1.7.1,11.1.6.11,11.1.5.4 and Migrating Siebel Analytics to OBIEE 11.1.7.1.
• Over 3 years of experience in delivering the data to users using Hive tables/ Parquet Tables and talend 6.4.1 and Horton works.
• Storing the data in Amazon S3 Buckets and sqooping the data to AWS redshift using copy commands and leveraging talend 6.4.1.
• Over 2 years of experience in Alteryx 11.x versions which is a Business ETL tool.
• Training users in Alteryx and helping them and scheduling them using Alteryx Designer and Helping them to schedule in Alteryx Gallery.
• Over 3 years of experience in creating Tableau data visualizations using 8.x,9.x,10.x
• Over 2 years of experience in administering tableau servers and migrating workbooks across different environments
• Over 2 years of experience in AWS and migrating servers to AWS platform including tableau and OBIEE servers.
• Tableau visualizations using Hive and created hive tables using Hadoop.
• Proficient in Implementing and Upgrading the Oracle Business Intelligence Enterprise Edition 11.1.6.11,11.1.5.11 and (OBIEE) 10.1.3.4.1 , Siebel Analytics Applications with versions Siebel Analytics 7.7.1, Siebel Analytics 7.8.2, S iebel Analytics Server Configuration.
• Experience in migration the OBIEE Versions from 10.1.3.4 to 11.1.5.4 and 11.1.5.4 to 11.1.6.1 1
• Experience as Informatica 9.5.1 Admin, installing and configuring.
• Created Mappings, Mapplets, Workflows and Worklets and monitored the jobs and scheduling the jobs in Informatica.
• Connected to EBS source and processed order management data from source to staging and from staging to target tables using Informatica 9.5.1
• Creating users in W eblogic Server Version: 10.3.5.0 and Managing the OBIEE servers in Weblogic Enterprise manager .
• Installing and configuring all the Versions of OBIEE software's in Linux Environment .
• Creating OBIEE Repository including Physical layer, Business Modeling and Mapping layer, and Presentation Layers as per the requirements with Analytics Security model.
• Extensive Experience in applying patches on all the OBIEE 11.1.5.4 and 11.1.6.11 Versions.
• Installing BI Publisher 11.1.6.11 and 11.1.5.4 10.1.3.4.1 and integrating to existing OBIEE 10.1.3.4.1 .
• Experience in OBIEE Publisher and sending templates to external users using bursting features in the OBIEE Publisher 10.1.3.4.1 .
• Experience in Configuring and Installing Hyperion 11.1.2 in UNIX environments.
• Experience in giving training on Siebel Analytics, OBIEE 11.1.X Versions and Tableau.
• Extensive experience in interacting with oracle support web to resolve issues that can’t be achieved using the tools.

Software Skills

Business Intelligence Tools: Oracle Business Intelligence 12C, 11.1.1.7.0 , 11.1.1.6.11 , 11.1.5.4 and 10.1.3.4.1 , 10.1.3.2Siebel Analytics 7.8.2,7.7,7.5Hyperion 11.1.2,and 9.3.1, Essbase Spreadsheet Services, Hyperion Smart View and Essbase Addin, Hyperion Admin Console, Cubes, Oracle Business Intelligence Publisher 10.1.3.4.1 , Tableau 9.1,9.3,10.0 and 10.4, AWS Redshift, AWS S3, Hive, Sqoop

CRM Tools: Siebel Tools, Siebel Call Center and Siebel Sales Application

ETL Tools: Informatica 7.7.1, Warehouse Builder, Talend 6.4.1

Languages: HTML, XML, Jscript,CSS,Perl

Database: Oracle 11G,10g/11g, Oracle 8i/9i, SQL ServerEssbase, Sybase, MYSQL

Operating Systems: Windows 2003,Windows XP, Linux, Windows 2008 and Windows 2012

Others: MS Office

Business ETL tools: Alteryx 11.0.6

PROFESSIONAL EXPERIENCE:

Confidential

Manager of Analytics/Data, Principal/Lead Business Intelligence Engineer

Responsibilities:

• Managing the BI team of 9 to gather requirements and bring the data to data lake using Talend 6.2.1 and Horton works and storing the data in S3 and creating Hive tables and providing data to users in the form of Hive tables.
• Educating users how to connect to Hive and how to create visualizations using tableau 10.4.1
• Installed Oracle Business Intelligence Enterprise Edition 11.1.5.4 and 11.1.1.6.11 versions in Linux Operating System in all DEV,QA,UAT and Production Environments.
• Migrated 10.1.3.4.1 version to 11.1.5.4 and applied patches to 11.1.5.4 to 11.1.5.5
• Upgraded the Environment 11.1.5.5 to 11.1.6.11.
• Installed all the cumulative patches of all versions to resolve issues .
• Interact with users to educate the new 11.X versions when we moved from 10.1.3.4.1 to 11.1.5.4 version.
• Creating Technical Design Documents for the RPD work and managing the Offshore team in getting the work done on timely manner.
• Enabling metadata dictionary to users.
• Enabling Usage Tracking and gathering stats for analysis.
• Work with DBA's to tweak the long running queries and asking them to create the Indexes if required.
• Implementing and designing Aggregates to give good performance on the reports.
• Caching and Purging the reports by using agents and creating the automatic cache purging scripts after the ETL load is completed.
• Cloning and reconfiguring the Entire OBIEE system and training the other team mates to know the basics of OBIEE system.
• Creating complex reports and shared dashboards to the users based on the requirements.
• Creating Users and Groups in the weblogic console and giving rights to create their own dashboards and reports and helping them to publish the reports to a shared dashboard.
• Created almost 19 Support Tickets to Oracle which are identified as Bugs in the 11.1.5.4 versions.
• Working with ETL team to design the Star schema model and come up with Dimensions and Facts to model the BI repository.
• Migrating the RPD and Web catalog across environments from DEV to QA and QA to UAT and UAT to PRODUCTION.
• Creating Level based measures based on the requirements.
• Creating the Dimensional Hierarchies and using them in the reports .
• Created a complex case statements in the OBIEE repositories and letting the ETL team to create them in the table instead of calculating them in the reports.
• I am recognized by CTO of the company when moved from 10G to 11G and for training the users how to use the new system and giving demo about new features .
• Involved in the design of each OBIEE project and creating the data models in Visio and word to handover the work to offshore team.
• Involved in server migrations when the OBIEE server is moved from California to Las Vegas .
• Created a Technical design document to connect the OBIEE system to MYSQL database and EBS applications directly.
• Created a condition based on agents to the ETL team to show when the data is not loaded properly alerting them to check the last ETL process was successfully completed or not .
• Configure BI Publisher to sent the reports to shared drive and used BI Publisher for bursting the reports to 20 different users .
• Implemented a data level Security on the reports based on the designation of the users.
• Implemented Write back functionality to enable power users to write the data to the underlying tables.
• Creating a shared dashboard to get the list of agents that are scheduled in OBIEE.
• Creating a documentation dashboard to users where users can find all the related OBIEE documents and Data models in one place.
• Working with DBA's and Business Users to automate the adjustments that we do for coaches .

Confidential

Business Intelligence Engineer

Responsibilities:

• Installed Oracle Business Intelligence 10.1.3.4.1 Versions in DT,QA and Prod Machines
• Using OBIEE Administration Tool to create repositories and merging across environments.
• Configuration of Production System in two machines.
• Configuration of Scheduler on all BI Server Machines.
• Creating dashboards and reports using OBIEE 10.1.3.4.1 and migrating web catalog across environments.
• Configuring Repository and web catalog based on requirements.
• Enabled caching and Event polling tables for cache Purge
• Created Jscript for caching and used NqCmd utility for caching.
• Implemented Clustering on 4 machines like two servers will act as BI Server and Two Web servers will be sharing a common web catalog in a NFS Shared file system.
• Installed Hyperion 9.3.1 and Oracle Business Intelligence 10.1.3.3 for integration of Hyperion cubes to Oracle BI admin tool.
• Create Rules files for Building Dimensions in the Hyperion.
• Create Application, Database and Outlines for Hyperion Cubes.
• Interact with Business users to collect requirements and convert them to TDD document.
• Imported all the tables required and created star schema in physical layer as per BRD
• Created BMM Layer and created Complex joins and created dimensional hierarchies
• Created variables initialization blocks that are used while creating reports.
• Implemented security by creating a table in database
• Applied data level security for Confidential dashboards based on the security table
• Create Custom Reports based on User request and schedule them according to the User specification.
• Involved in changing the CSS Files and Login page that Oracle BI Comes with to change to Confidential Login page.
• Involved in changing the look and Feel of dashboards and answers so that it will show Confidential company Colors (Ex: In dashboards it will show Confidential dashboards, Answers will show Confidential Answers and in Login Page it will show Welcome to Broadcast instead of Oracle Business Intelligence Version and name)
• Configure LDAP Authentication in the Repository so that users can login with Domian accounts
• Configure Time series functions using AGO Functions.
• Migration of the RPD, Webcatalog from DEV to QA and QA to Production machine.
• Used Catalog manager to merge catalogs from DEV to QA.
• Designed tables for Aggregate navigation and Implemented Aggregate Navigation in the repository for all the subject Areas for fast Data Retrieval to user reports and dashboards.
• Used Hints in Physical layer so that Oracle BI Server will use the hints for the queries that are sent to database for fast retrieval.
• Performance Tuning of the Dashboards and user queries.
• Interaction with ETL team for Specific Aggregate tables for Performance tuning
• Presentation variables are used for complex dashboard requirements.
• Built lot of Complex reports like Union Reports and Multiple Compound layouts and View selector as per business needs.
• Involved in training for other teams who want to know about OBI.
• Involved in User training for creating their own reports and own dashboards and Ibots.
• Production system support.

Confidential

Business Intelligence Engineer

Responsibilities:

• Imported all the tables required and created star schema in physical layer as per BRD
• Created BMM Layer and created Complex joins and created dimensional hierarchies
• Created variables initialization blocks that are used while creating reports .
• Implemented security by creating a table in database
• Applied data level security for Confidential dashboards based on the security table
• For applying data level security created row wise initialization blocks.
• Created level based measures for all dashboards that will improve performance
• Created Session variables for getting enough Log info for variables
• Have made Configuration changes to Instanceconfig.XML in order to reduce some reporting issues
• Created presentation layer and used same while creating reports
• Created all reports according to the Mockups and saved in respective folders
• Created dashboards, Pages and embedded all the created reports that business wants
• Created dashboard Prompts and embedded in Dashboard.
• Implemented caching for better query performance.
• Used dashboard objects for better understanding of report to Users
• Have applied conditional formatting for better understanding of data to Users.
• Implemented Usage tracking in order to know how frequently users are accessing Confidential Application
• Purging cache by Event polling tables
• Created lot of typical reports like union based and Filter based on results of another request.
• Configured scheduler and generating alerts to End users in the form of reports.
• Supporting production Support issues related to Siebel Analytics and resolving them in time.
• Created Outer Joins in order to satisfy business requirement.
• Testing the dashboard for all Consistency messages and dala level testing before it moves to production
• Interacting with ETL team in order to clarify them to create necessary columns that are necessary in lDW tables
• Deployng RPD and Webcat from Local machine to Cisco Unix servers and restarting them when ever we require.
• Allow access to dashboards via a web - based front-end.
• Restrict dashboard user access based on theaters defined by business.
• Interacting with Business to understand Analytics related issues that they are facing.

Confidential, Cincinnati

Siebel Analytics Developer

Responsibilities:

• Understanding requirements and customizing the Repository to meet the requirements.
• Developing and testing within Application.
• Tracking/Preventing defects.
• Effort estimation.
• Resolved the Symphony AAI Data mart-II SA issue in Analydev-001 server located in Client side using VPN network.
• Enhancement of the Symphony Market Measurements Subject Area by name Symphony European Trade Panel Data ETPD
• Created Dimensions and Hierarchies and Measures
• Tested the Repository and have written some test cases
• Created Reports for Symphony MM LA BIOS business model .
• Created the Reports for Usage Tracking Subject Area.
• Created Dashboards for usage Tracking SA and Shipments SA
• Created and made some Enhancement work for all the reports in order to get the reports in Plug n Play Standards.
• Included Narrative Views to all the reports developed for Shipments SA as per the new requirements.
• Added Guided Navigation Links for all the Dashboard Pages in order to make them Consistency according to Performance issues.
• Created and Implemented some Test cases for some of the Subject Area’s in order to clarify the joins are properly joined or not..
• Created some reports based on some other reports according to the client requirements.
• Implemented installing Service Desk in order to handle the support work for all the subject Area’s that went to production.
• Maintained the consistency in Service Desk in rectifying the issues for all the Subject Area’s that went in to production.
• Created the Dashboards and Dashboard Pages(100) for shipments Subject Area’s
• Used the Software by Name Toad 8.0.1 in order to see the results that we are getting from Siebel Answers (Based on Repository) and Toad (Hitting directly to Database) is correct or wrong.
• Provided support for testers. Participating in daily UAT meeting. Analysis variances and assigned them to developers.

Environment: Siebel Analytics 7.8.2 and Siebel Analytics 7.7.1,Oracle 8i, SQL Server 2000, Windows 2000, MS Office, MS Project and Toad.