Arpit

17 plus years of progressive consulting experience in Data Analytics space with prime focus on configuration, Implementation, Operate, Analysis, Design, Development, Customization of Data Analytics Applications in an effective way to deliver leading edge software solutions. Experience / Specialization in deploying Data Warehouse / data lake solutions using [OAS] Oracle Analytics Cloud Server [IaaS], Oracle Analytics Cloud [PaaS], Oracle Fusion Analytics Warehouse [SaaS], Informatica / ODI / Hadoop big data from various source system such as ERP [SaaS], EBS / SAP/ Salesforce.com / Taleo / custom API / Essbase / FTP / web logs / XML / Hadoop. Working closely with users, developers, data scientist, data engineers and administrator to resolve on-going problem by reviewing design changes for production system.

Leading the technical team for successful implementational for Oracle Analytics Cloud / OAS for large utility, consumer, package shipment services client.
Designed architecture for Oracle Analytics Server including all technical pre-requisite & configuration to sustain the top-notch performance for production.
Rationalize OAS Application ROLE / Group for Analytics data level security, Integrate OAS with ERP using custom ODI Marketplace on oracle Autonomous Datawarehouse to support financial / supply chain/ custom analytics dashboards.
Strategized and upgraded OAS with desired level of OBIEE 12c version including all security / customization / visualization.
Designed the analytical data model for financial analytics, supply chain analytics [De normalize Start Schema].
Designed the semantical data model [RPD] to support analytical requirement using customization and hierarchy definition.
Customize the data model for Account Payable, Account Receivable, Cash Management, Fixed Asset, General Ledger [Income Statement / Balance Sheet].
Worked closely with Oracle Product Team success manager / Client Partner and technical team to designed solution end to end.
Enhance the process for SOX compliance and governance for infrastructure, creating specific analytics model for ERP data and Oracle Analytics warehouse data reconciliation.
Defined the process for data level security in analytics model with customization, designed the governance model for administrator for application access [SSO okta] with OAS.
Created data model for snapshot fact table where data warehouse capabilities add the values to retain the data over financial transaction system.
Leverage machine learning model for oracle analytics AI pre-build model [linear / logistic regression] for specific forecasting use case.

Configured end to end OBIEE on premise architecture using industry-based model of high availability cluster nodes to sustain the Development / UAT / Production system.
Implemented development / migration / deployment best practices with end to end successful execution.
Creating multiple option / methodology / best practices for version control using git / MUDE/ SVN / patching repository process.
Successfully installed and upgraded from OBIEE 12c to OAS 5.5 while working with business / IT / support to mitigate any technical risk.
Successfully implemented advance “cache” strategy based on OBIEE server with automation of period purge.
Successfully Implement SSO with cluster OBIEE model working with AD team.
Implemented lift and shift from OBIEE 12c on premise to OAC 5.5 using Oracle Data gateway.
Configure communication channel ssh encryption key from oracle cloud to on premise oracle data gateway.
Installed Oracle HTTP server for web compression performance tuning and configurating with cluster OBIEE and F5 load balance.
Implemented best practices and model for performance tuning in end to end stack of BI such include various strategy as connection to data source, JVM, CPU, RAM, load balancing etc.
Created repository documentation for OBIEE system administration / Oracle Advance Cloud Analytics Implementation / Oracle Analytics server Configuration.
Automated and schedule system ibots to send advance usage of system in oracle analytics cloud.
Configure SMPT server for Oracle Analytics Cloud and On premise OBIEE application.
Configure BI Publisher tuning to get the best formatted output data for business on time and quick.
Perform successful lift and shift to OAC and validated proof of concept in oracle cloud analytics.
Implemented and documented customization of analytics application using oracle standards practices.
Perform the lift and shift upgrade process of OBIEE 11g on premise to Oracle Classic cloud successfully.
Implemented SSO for all AD users synchronization between IDM and OAC classic application.
Implemented OBIEE load balancer cloud URLS access with configuration with network team using DNS.
Creating process for advance analytics Hadoop BIG DATA architecture based on industry standard best practices “Leap Frog” Architecture.
Creating the dataset ETL pipeline for forecasting which was consumed in advanced analytics and machine learning process.
Rolled out successfully POWER BI solution of business where source utilizing data such as Oracle EBS / Sales force.com / SharePoint.

Demonstrated the detail level architecture design OBIEE/BI Apps, Power BI , Tableau reports and catalog design to leverage the OUT OF THE BOX features and capabilities for custom new reports and catalogs.
Created and configured the Usage Tracking for auditing for Linux Clustered OBIEE environment.
Configured the MUDE for concurrent development and avoid any additional efforts for RPD design.
Created the Best Practices design task for RPD and Report development/deployment/migration.
Worked with Business users for executive and super user for aggregated report of various data like sales order, forecast, revenue, backlog, shipment etc.
Configure the RPD data model with Oracle Leading Best Practices.
Integrated OBIEE and BIP report in LDAP SSO configured environment.

Installed and configured OBIEE11G cluster model architecture for scaling out the environment (Solaris 64bits).
Configured multiple currencies for BI Apps Financial Analytics dashboards using ETL DAC and Informetica.
Configured and designed sales analytic / order management and inventory balance module and leveraged the Oracle BI Best Practices for OOTB and customization.
Created custom reports using Time series measure function YTD, AGO in OBIEE11G.
Created reports using dynamic filter by applying session and dynamic variables in reports.
Created BI Publisher reports by using OBIEE as data source and integrated in OBIEE Dashbaords.
Installed and configured Oracle Endeca Information Discovery for unstructured data analysis.
Installed and configured Presentation Sever, BI Server, Admin Server/Weblogic Server, IIS and Oc4j.
Involved in Migration between Development, Test and Production Servers for OBIEE11G.
Administered and installed critical patches and bug fixes to OBIEE through OPatch.
Worked on JAVA Clover ETL to design and populate the MDEX engine for structure and unstructured data.
Worked closely with business for creating studio application of Endeca Information Discovery.

Configured BI component in DEV, INT, UAT environment including BI Publisher scheduler.
Configured Cluster environment in UAT and implemented cache by using SAN storage.
Configured multiple instances of BI Presentation services by changing the shell script.
Successfully merged different rpd of all business and reviewed POC by making single rpd and web catalog as per Oracle Best Practices.
Designed overall architecture diagram for OBIEE environment, created Migration strategy , BI best practices documentation.
Created Usage Tracking using the existing security authorization table.

Created various projects in rpd to work in concurrent development from ground up.
Set up the MUD access for individual OBIEE developer and secured the shared directory path.
Created Store procedure, Opaque view and Write back in rpd to provide advance features in OBIEE.
Created Siebel Responsibility groups for more than 1000 users and given the access to dashboard by using row level and object level security.
Configured OBIEE scheduler, BI Publisher on server and gave access to developer and front end users as per roles and responsibilities.
Created more than 100 reports in OBIEE over 15 dashboards for the entire implementation of USOL projects.
Integrated Hyperion Essbase database to the relational database.
Implemented Disconnected Analytics for the sales rep users to sync the rpd and dashboards for disconnected mode.

Lead offshore OBIEE team and actively interacted with them to go through the Functional Requirements, Design reviews and Development Requirements in OBIEE.
Configured and installed the OBIEE 10.1.3.3.4/3.3/3.2/3.1 with all the required upgrade and updates for Development, SIT, UAT and Production on Linux.
Designed the physical layer, BMM layer, Presentation Layer in RPD, created the session variable and Dynamic variable in RPD.
Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
Designed and created more than 150 reports in OBIEE.
Achieved the Radio Button functionality in OBIEE (That was present in the Existing Interface that was built in Java) by creating the prompts and using those prompts as the presentation variables.
Created and Developed the Groups in RPD and implemented Dashboard and Report-level security.

Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.
Triggers, procedures and functions are developed in data model.
Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
Troubleshooting problems and worked effectively with other team members to identify and address problem.