Prabhanjan Rotti

1, BI Modernization, 08/2023, Present, HCL Technologies Ltd, US Foods, Product Owner, Gathering the requirements with cross functional stake holders and consolidating and building it with the concrete information for the data pipeline, Building the Sigma dashboards & Tableau dashboards for the Account Coordinators and Sales Coordinators based on the requirements.

2, IBDP - Big Data platform, 07/2022, 07/2023, HCL Technologies Ltd, NetApp, Product Owner, Gathering the requirements with cross functional stake holders and consolidating and building it with the concrete information for the data pipeline and API team, There are totally 7 source systems connected together to build analytics application where the end user can see the data for an Customer, opportunity, quote and asset with end to end data related to it. The analytics application is used by Renewals team and it helps them identifying the assets which are due for the renewal. Data from multiple sources will be loaded into parquet files (Amazon S3 environment) and then modified and transformed data will be loaded into the PostgreSQL layer.

3, Contact Master, 01/2022, 07/2022, HCL Technologies Ltd, NetApp, Product Owner, Gathering the requirements with cross functional stake holders and consolidating and building it with the concrete information for the data pipeline and API team, NetApp’s contact data of customers, partners, vendors etc are maintained in different systems and they are inconsistent. Contact Master data platform is a holistic 360-degree view of the NetApp’s contacts. Contact Data from multiple source systems are mastered and stored in MongoDB in the stage layer, applied multiple cleansing rules and transformations to make a file layer of SSOT. (Single source of truth)

4, MDM, BCO Items, 12/2021, Ongoing, HCL Technologies Ltd, NetApp, Product Owner, Gathering the requirements with cross functional stake holders and consolidating and building it with the concrete information for the data pipeline and API team, CMAT and EIM are the major projects where I am involved. CMAT deals with the customer’s data and EIM deals with the Renewals related data.

5, SAP HANA Migration and Hana Modeling, 07/2021, 12/2021, HCL Technologies Ltd, NetApp, Product Owner, Gathering the requirements with cross functional stake holders and consolidating and building it with the concrete information for the data pipeline and API team, NetApp, Inc. is a hybrid cloud data services and data management company. It has various sources and the data from them is extracted and loaded into the HANA database with the transformation logics as per the business rules. The transformed data will be used by the business users through tableau reports.

6, Datahub PhData Implementation, 11/2019, 07/2021, Infosys Ltd, Prime Therapeutics, Tech BA, Validating the different claims data flowing from RxClaims application to the data hub in the Kudu, HBase and Denodo reports. Validation of data reconciliation against the HBase and Impala tables. Validation of the claims data through NRT against the HBase.

7, Florida Blue Novation of Plans, 03/2019, 10/2019, Infosys, Prime Therapeutics, Tech BA, We will receive the patient details data files (FL Blue) from the customer and need to process the jobs to load the data from client server to the ETL area. Load the data from Prime and Non-Prime data and validating them as per requirements. Need to process the data from ETL to Data hub and store the client data in Data hub. Comparison of the data from ETL to Data Hub.

8, External Vendor Data Uplift, 11/2018, 02/2019, Infosys, Prime Therapeutics, Tech BA, We will receive the patient details data files (CMS & HMS) from the customer and need to process the jobs to load the data from client server to the ETL area. Need to process the data from ETL to Data hub and store the client data in Data hub. Comparison of the data from ETL to Data Hub.

9, Claims ODS, 10/2017, 11/2018, Infosys, Prime Therapeutics, Tech BA, Validating of data migration from traditional sources(DW) to Data Hub(target) based on the transformations. Executing Airflow DAGs to load the data from source to target and validating the logs if any issues encountered. Performing NRT process by submitting claims using SOAPUI and verifying them in Hbase. Performing the validations between Hive and Hbase databases based on the transformations. Validation of Reconciliation process for missing claims.

10, RARI COLO Migration, 03/2017, 09/2017, Infosys, Blue Shield of California, Test Lead & BA, ETL & Gathering requirements from stake holders and preparing the mapping documents and BRD and groom to DEV & QA., Validating the data migration from Informatica 9.1 to Informatica 9.6 with all transformations. Validating the data in both versions simultaneously.

11, APP Retirement, 12/2016, 02/2017, Infosys, Blue Shield of California(BSCA), Test Analyst, ETL Testing & Functional Testing, Archiving the data from the legacy applications and generating the report in SAP BO for each of the application based on the transformations.

12, Randomization & Trail Supply Management (RTSM), 12/2013, 11/2016, Parexel International, Novo Nordisk, AstraZeneca, Abbot, Software Validation Engineer, ETL Testing & Functional Testing, PAREXEL is the premier provider to the bio pharmaceutical and medical device industries for the development and commercialization of new medical therapies worldwide. Novartis has tie-ups with number of hospitals/clinics across the globe and clinical trials will be performed on patients all over the world for different types of drugs at different levels and there will be huge amount of data to analyze the reactions and performance of the drugs. The main objective of the project is to design and build a data warehouse for query & analysis purpose to take effective decisions. Data was extracted from Flat Files Source which is in ODS and transformed and loaded to Staging Area and Staging Area to Warehouse, hence to analyses.

13, 4seTrans, Visilog, 4seCustoms and 4seRating, 10/2010, 12/2012, Apollo Corporate IT & Associated with TCS, Jacobson’s, UTC Overseas, QA, Functional Testing, Performing the transactions in the logistics products based on the client requirements and validating them. Performing Ad-hoc testing for all the transactions. Generating daily status report and updating to all stake holders.