Pavan Kumar Email & Phone Number

Bengaluru, Karnataka, India

Hyderabad, Telangana, India

Enterworks PIM MDM Implementation, Installation & Configuring Enterworks Enable Application as per Data Model, Creating Profiles, Repositories, Taxonomy, Hierarchy & Codesets, Writing Business Rules using Velocity Templates (VTL) & SQL, Linking Repositories &Implementing Attribute Security, Assigning Taxonomy, Hierarchies to Code set attributes, Promoting Records from Staging to Production using Workflows, Configuring & Uploading Digital Asset Management (DAM), Creating Export & Import Templates & Scheduling, Creating Workflows as per Business needs, Supporting & Troubleshooting the Enable Application.

Chennai, Tamil Nadu, India

Application validations (Informatica & Tableau). Understanding BRD data and its functionalities, Running the jobs/Workflows for ETL process. Prepared and run SQL queries to verify Dimensional and Fact tables. Verifying the data in target database by ETL process. Verified column mapping between source and target. Prepared test data for functional & Integration testing. Interactions with BA & Dev teams to resolve the issues. Reporting daily testing status. Designed, Reviewed & Executed Test cases.

Hyderabad, Telangana, India

Supporting the Informatica Application by analyzing the new and backlog Defects. Assigning and Tracking the Daily activities with Team of 12 resources including both offshore and onsite. Managed the team coordinating with counterparts on-site to gather additional information for resolving the defects.Developed new mappings using various transformations like Source Qualifier, Expression, Routers, lookup, Update Strategy for SCD type 2. Communicated with business customers to discuss the issues and requirements. Production Support has been done to resolve the ongoing issues and troubleshoot the problems. Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network. Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.

Chennai, Tamil Nadu, India

Played multiple roles like ETL Technical Lead & Developer, Support Analyst and Quality Analyst. Involved in design phase meetings for Business Analysis and Requirements gathering. Understood functional documents for new business source systems and applications and their integration into the existing Database and prepared the required application design documents based on functionality required.Responsible for ETL (Informatica), Report (Tableau) and Guidewire (CC) application validations. Understanding BRD data and its functionalities, Involved in functional study of the applications (Guidewire CC), Running the jobs/Workflows for ETL process. Prepared and run SQL queries to verify Dimensional and Fact tables.

Bengaluru, Karnataka, India

Played key role of Incident Management, Record and classify the received Incidents, Undertaken an immediate effort in order to restore a failed IT Service as quickly as possible, As Tier 1 & 2 support Investigate and Resolved the incidents as per the SLA, Logged all Incident/Service Request details, allocating categorization and prioritization codes, Informed users about their Incidents’ status at agreed intervals, Associate Incidents with other records (i.e. Incidents, Changes, Problems, Knowledge Articles, Known Errors, etc.), Verify resolution with users and resolve Incidents in ITSM tool