Cerner is the world’s largest publicly traded health IT company providing leading-edge solutions and services for health care organizations worldwide with solutions licensed at more than 25,000 facilities in over 35 countries. There is effort replace the tradition ETL jobs with Data pipeline running in distributed environment & modernize data platform. • Working towards implementation of Big Data and Data Management platform for Cerner’s corporate data• Worked on setting up Microsoft Azure data lake for large scale, structured/semi-structured/unstructured datasets• Architect the self-service infrastructure, defining catalogs to meet data privacy and security objectives along with establishing data ingestion patterns and reporting/visualization options in the data lake platform• Implemented data stream platform utilizing Apache Kafka on Azure HDInsight cluster and developed connectors in Java for Azure Data Lake, MongoDB and SQL Server • Developed ingestion pipelines using Apache Kafka, Azure Data Factory, Dell Boomi, Apache Sqoop• Developed processing pipelines using Databricks Spark, Azure uSQL processing pipelines with visualization in PowerBI & Tableau• Performed logical modeling in Azure analysis service and physical modeling in HDFS, Mongo DB, RDBMS and MPP systems• Developed microservices using Spring Boot architecture and deployed with Docker containers on Kubernetes cluster • Performed proof of concepts on various areas in Spark including evaluation of Spark streaming vs KStreams, Spark batch processing vs Azure u-SQL processing

Financial reporting solutions for executive Create a BI road map corporate reporting , internal reporting & leadershipAutomated rollout (Build and Release) for OBIEE .Replacing the legacy reporting systemsSkill: OBIEE,Hyperion ,ODI,PL SQL, Tableau

Part of OBIEE Center for Excellence team  6+ work experience in DW Modelling, OBIEE reporting Application 11G (11.1.1.9) Finance and Procurement, Hyperion Planning & ESSBASE integration, which also comprised of Informatica Experience. Hands-on experience in configuring and developing the Analytics/OBIEE Repository (.rpd), which involves Schema Imports, Implementing the Business Logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, Fragmentation, Cache Management, Utilities, Subject Areas. Experienced on vanilla reports for Financial Analytics and Project Report and Oracle BI Applications, configuring the database through DAC and customizing mappings in Informatica.  Proficient in building analytical repository, business models, generating reports, and creating dynamic Dashboards using OBIEE. Widely experienced and skilful in working with various features of Siebel (OBIEE) Server components, Web server, scheduler and portal. Experienced in Configuring and publishing the iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions to all the departments in the organization by Emails. Experienced in migrating the Web catalog developments by using the Catalog manager and Repository developments to Production from the Test environment. Hands-on data warehousing experience using Informatica powermart, Informatica Powercenter (Source Analyzer, Data Warehousing Designer, Mapping Designer - data transformation and mapping issues, Mapplet, Transformations). Hands-on experience in Oracle 11g, SQL Server 2016, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL

• Interacted with the business users directly for the requirements and to understand the current system process and created business requirement documents and prepared the effort estimates.• Conducted workshops to gather user requirements and performed Gap Analysis and translate them to technical requirements.• Scoping exercise to find out technical feasibility to meet client requirements.• Understanding the client requirements clearly from the business requirements and design the technical specifications.• Design, develop and document the HR data mart based on the requirements information collected from HR business users. This will include the Core data and reporting fundamental fields as well as KPIs, Scorecards and reports that will be developed by the Reporting COE.• Design, develop and document the data loading modules to copy HR related data from the following three data sources into the HR data mart.• Design, develop and document a new OBIEE presentation/semantic/physical layer based on the single HR data mart.• Provide Self Service functionality to end users enabling the creation/updating of reporting elements within the HR subject area. • Design and Develop testing reports only. These testing reports will be built to support System and UAT testing cycles ensuring the accuracy of the data displayed. • Establish and implement a repeatable and operational User Access Model for end users based on the information provided by the HR business and the existing security standards as defined by IM-BI.• Provide user guides and training material for the Reporting CoE and HR end users.• Provide training to the Reporting COE in relation to developing reports, analytics, KPIs, scorecards and dashboards using the OBIEE platform.• Responsible for formulating the OBIEE development standards, best practices and guidelines.• Part of the SME team which helps the development teams to overcome any technical difficulties pertaining to OBIEE.

• Conducted workshops to gather user requirements and performed Gap Analysis and translate them to technical requirements.• Scoping exercise to find out technical feasibility to meet client requirements.• Understanding the client requirements clearly from the business requirements and design the technical specifications.• Worked closely with the Siebel team to know the complete workflow and on identifying the customizations.• Scoping exercise to find out technical feasibility to meet the customer requirements.• Organizing the presentation layer in a format that is easy to navigate for end users to use as basics for reporting.• Helped team in creating Interactive Business Intelligence reports and dashboards using Oracle Business Intelligence 11g.• Designed and implemented Security solution in OBIEE in sync with Siebel application groups and roles.• Configured the Usage tracking functionality

Worked on Microsoft Technolgies for various implementations