Vinay Ambalihalli

• Data integration solution using Enterprise ETL Tools - Informatica and Oracle PL/SQL for pharmacy GL. DevOps solutions using Python for Business Teams.
• Building operational and interactive reports for pharmacy, care delivery business and KP International.
• Automation of dynamic report generation using PL/SQL, shell scripts and custom report delivery using Tableau rest API
• Designed and built CRM forms on oracle apex for program management to the new engagement. Understand, designed back-end transaction data model and reporting solution.
• Implemented python airflow and migrated cron jobs to airflow for ease of maintenance.
• Setup intranet portal on Apache server, integrated Tableau report for real time data refresh.
• Build SharePoint cloud site and KP Wiki page for data warehouse team to manage work intake and share/integrated reports. Project tracking, code management and SOX compliance reporting using DevOps Tools.

Skill Stack:
Informatica, Tableau, OBIEE, Oracle Apex, Oracle, MySQL, SAP BO, Linux, Cloud Services, JIRA, Git SCM, PLSQL, Shell, SoapUI, Apache Webserver and Python Airflow

• Evaluated and documented the legacy report design, i.e., the object and data level security and the report integration with internal applications.
• Identified critical and unique report with respect to functionality and technical complexity for prototyping to new BI Platform.
• Built a sandbox server to host OBIEE and Tableau servers on RHEL / Azure platform.
• Designed similar interface as legacy application, with added functionality on new BI platform. by creating a new interactive Home page. Demonstrate report drill-down, guided navigation, selection steps, agents, security and burst reports.
• Collaborate with System admin/ IT Team and created project sprint plans for migrating to the new Data Lake, EDW solution and BI platforms.

Skill Stack:
Tableau, OBIEE, BI Publisher, BIRT Actuate, PL/SQL, Cloudera, Oracle, AWS and SoapUI.

• Worked as BI Architect in Info Delivery Team in leading BI development and upgrade projects in OBIEE, and Tableau .
• Involved in project life cycle planning, gap analysis, resource mapping and implementation plan.
• Worked on requirement gathering with Retail Merchandising DMM and GMM. Analyze user stories and build custom data models on Oracle RMS, ReIM and Allocation.
• Analyze BI Server performance, diagnostics log files and collaborate with Oracle Support and Tableau vendor support in analysis. Patching and validating fixes.
• Used Python for cleansing user feedback data file and loading data for reporting and analysis.
• Profiling of data pertinent to various LOBs (Line of Business).
• Install, configure and upgrade OBIEE / BI Publisher and Tableau servers. scale out BI Servers: Horizontal scaling and vertical scaling.
• Worked on site root certificate and SSO configuration using Kerberos based Windows Authentication. 
• Worked on PL/SQL package and shell scripts for data jobs on Autosys.
• Automated email delivery and bi data refresh jobs on Tableau. CA SCM integration with Tableau application server for the migration.

Skill Stack:
Tableau, OBIEE, BI Publisher, PL/SQL, Oracle, Autosys, Unix, WSDL Services and SoapUI.

• Working on Business Requirement gathering and Analysis. Coordinated with various LOBs and involved in JAD sessions with information stewards
• Designed and developed BI Solution in OBIEE. Worked on repository modeling, creating schema in physical layer and configured logical layer, defining logical joins/keys to fulfill complex BI requirement.
• Worked on OBIEE Application upgrade and worked with Oracle Support services.
• Worked on data modeling, defining facts and dimensions, design dimensional hierarchy, level based measures and aggregate views.
• Built solution on Oracle BI Publisher and OBIEE Integrated platform for ERISA, by leveraging write-back, PL/SQL trigger and report burst function.
• Worked on OC4J and Weblogic servers to scaling bi server components.
• OBIA Type 1, Type 2 and Type 3 customization in Informatica and OBIEE out of the box solution for HR Application
• Developed Informatica mapping using various transformations, Aggregate, Router, Filter, Join, Expression, Lookup and Update strategy.
• BI Application security implementation. Authentication using LDAP and SAML 2.0 for sso.

Skill Stack:
Siebel CRM, Siebel Analtics, OBIEE, BI Publisher, Oracle, Teradata, Informatica, PL/SQL, Shell Scripting and SoapUI.

• Extensively worked on design and developing OBIEE Repository.
• Implement Row level security and setup permissions for users based on Siebel Roles / DB Authentication.
• Configuring scheduler, building Narrowcast reports and creating delivery profiles for the list of user’s handheld devices (Blackberry) with PIN.
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards, building ETL Source to Target Mapping.

Skill Stack:
Informatica, Tableau, OBIEE, Oracle Apex, Oracle, MySQL, SAP BO, Linux, Cloud Services, JIRA, Git SCM, PLSQL, Shell, SoapUI, Apache Webserver and Python Airflow

• Worked with business leaders on requirement gathering, creating functional design document, and understanding source system data.
• Develop custom OLAP Data Model and preparation of test data.
• Design and development of Siebel Analytics Repository.
• Developed interactive reports and dashboards, Analytics repository and the WebCatalog . 
• Optimize performance of ETL Jobs. 

Skill Stack:
Tableau, OBIEE, BI Publisher, BIRT Actuate, PL/SQL, Cloudera, Oracle, AWS and SoapUI.

• Worked as onshore lead. Involved in OBI Application Enhancement, worked on requirement gathering.
• Enhancement from custom build CRM solution to Oracle Business Analytics Warehouse (OBAW).
• Configuring LDAP Authentication and BI security.
• Integrated BI Reports on Siebel CRM Application.
• Report performance Tuning at Oracle database level.

Skill Stack:
Siebel CRM, OBIEE, Informatica, Oracle,

• Siebel Analytics Financial Application development and Customize Siebel Call Center ENU, Worked on out of the box Siebel Analytics and Informatica Enterprise solution.
• Involved in development of embedded contextual CRM data into Siebel applications
• Customize Data Warehouse, develop ETL Mappings and configure DAC
• Implement security in BI Application

Skill Stack:
Siebel CRM, Siebel Analtics, Informatica, Oracle.