P K Email & Phone Number

South San Francisco, California, United States

Designed and developed mappings for loading data from Oracle to SQL Server (Staging model), ensuring accurate data transfer and data integrity.Leveraged Source Analyzer and Target Designer to efficiently import sources and targets, streamlining the data integration process.Demonstrated expertise in developing a wide range of mappings that effectively executed Extraction, Transformation, and Loading (ETL) of source data into the OLAP Schema. Employed various transformations, including Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, and Joiner, among others.Created and managed workflows using Workflow Manager, orchestrating different tasks such as email notifications, timed events, and session executions for seamless mapping operations.

Philadelphia, Pennsylvania, United States

Los Angeles County, California, United States

Participated actively in new development requests, enhancements, and strategic project initiatives, focusing on delivering operational reporting and analytical solutions in alignment with business requirements.Effectively managed and integrated diverse transactional applications such as Remedy, Facets, SAP, and CRM databases running on the Oracle Database.Utilized the Repository Manager to create and manage repositories, user groups, and users, efficiently configuring their privileges to ensure secure access and data management.Implemented Integration Services to facilitate seamless communication between the Repository Manager and client tools, ensuring a smooth workflow.

Farmington, Connecticut, United States

Effectively managed user access and privileges by creating and configuring repositories, user groups, and user accounts using the Repository Manager.Implemented Integration Services to facilitate seamless communication between the Repository Manager and client tools, streamlining workflow processes.Designed and developed mappings to ensure accurate data transfer from Oracle to SQL Server (Staging model) for effective data loading.Efficiently imported sources and targets using Source Analyzer and Target Designer, optimizing the data integration process.Demonstrated proficiency in creating various mappings that executed Extraction, Transformation, and Loading (ETL) of source data into the OLAP Schema. Utilized transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, and Joiner.Managed workflows using Workflow Manager, enabling tasks such as email notifications, timed events, and session executions to ensure seamless mapping operations.

Bengaluru, Karnataka, India

Utilized Source Analyzer and Target Designer functions to streamline the process of importing source data and defining target structures.Showcased proficiency in crafting diverse mappings that effectively executed Extraction, Transformation, and Loading (ETL) operations, transferring source data into the OLAP Schema. Employed a spectrum of transformations, including Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, and Joiner, among others.Actively orchestrated workflows using the Workflow Manager, overseeing various tasks such as email notifications, timed events, and session executions. This orchestration ensured smooth execution of mapping operations.