Kiran Vaduguri

Data Governance & Security

• Analyze existing data sources and make relationships in Informatica Axon
• Implement and govern technical metadata and business metadata in Informatica Enterprise Data Catalog and Informatica Axon
• Read existing and new Client Renewals data models in Idera ER Studio and implement Axon data sets aligned to physical model
• Data lineage for legacy and modern FMGlobal Digital Client Platform which includes Operational systems, Azure SQL Warehouse , PostgreSQL, SSAS, Power BI
• More than 500+ Data assets onboarded for Client Renewals Domain so far into FMGlobal Data Governance Platform
• Configuring and execute Enterprise Database resources in Informatica Enterprise Data Catalog
• Collaborate with Product Owners, Data Modelers, Business Analysts, Application Architects to govern enterprise applications data assets
• Perform Business Title curation for Enterprise Technical Metadata in Informatica EDC and leverage Informatica machine learning algorithm to improvise Axon Business Glossary term associations
• Work with internal Subject Matter Experts to identify knowledge and capture in Informatica Data Governance tools
• Work with FM Global application support team and Informatica support team to resolve systems & attribute level data lineage
• Collaborate with Infrastructure team, Access Management team, system administrators to enhance Informatica EDC and Axon product usage
• Provide suggestions and best practices for Informatica EDC & Axon performance tuning and troubleshooting
• Provide consultative services on Data Governance Platform technical aspects to internal project teams

Enterprise Data Management Platform

• Informatica Data Management Product Strategy/Technology Roadmap for TFS Enterprise Data Management Platform
• Collaborate with Business Product Owners, Technology Product Owners and chalk out plan to deliver EDM Technology strategy and design & development timelines
• Responsible for Enterprise Data Management Platform Enablement & Infrastructure leveraging Informatica products ,LDAP configuration, SSO, Users/Groups creation, Access Management to enable business users to perform Data Management activities
• Responsible for Informatica Data Quality (10.x),Informatica Enterprise Data Catalog(10.x) ,Informatica Axon Data Governance(6.x,7.x) ,Informatica Test Data Management (10.x) , Informatica ILM Data Archive (6.4.4,6.5) Installation & configuration and migration from legacy on-prem to Amazon Cloud environment
• Develop Data Profiling jobs for Enterprise Data Platform & Application Databases , generate Scorecard patterns & Automation scripts for DQ dimensions where Data Origination starts in TFS and report DQ issues to Operational Systems which provides insight into quality improvements performed at Source Systems over a period of time and also ensuring clean data is provided to Data Analytics for accurate reporting
• Create DQ Web Services for downstream consumer teams aligning with Enterprise API first multi-tenant architecture
• Informatic DQ Code Development and Configuration for loading Informatica MDM Vehicle Master & Customer Master Application tables batch processes
• EDC Metadata scan, Data Lineage for Enterprise Data Platform , Application Databases & Integration patterns to generate End-to-End Lineage ,find out Data Silos that impact Cloud Modernization efforts, What-If Analysis, providing technical support for Data Stewards to curate Data Domains for various EDC resources
• 1.1 million assets onboarded for various resources in EDC Production
• Custom rules developed for CCPA Data Domain Group in EDC Catalog and scan enterprise applications impacted so that data stewards can curate CCPA impacted data domains
• Perform metadata scans through EDC Advanced Scanners for DB2 Mainframe, Snowflake External Tables & Stored Procedures
• Integration of Axon with Informatica EDC to connect Business Glossary Metadata and Technical Metadata, integration of Axon with Informatica Data Quality to tag Data Quality rules for Business Glossary Terms to display DQ dimension score patterns at Glossary level
• Integration of Data Quality with Axon Data Governance Platform for comprehensive DQ metrics at Data Concept level
• Enable users to create Glossaries, Terms, Entities in Axon and link to Informatica EDC technical metadata which helps business to understand how projects are impacted for changes, how organization depends on each other for deliver, EDM Business Policies, Regulations tagged at attribute-level, System to System Lineage
• Data Masking Architecture, Design approach to mask sensitive data elements in Universal Customer Master, CRM, Consumer Web , Credit Risk Applications so that enterprise applications adhere to TFS Information Security & Compliance Requirements
• Data Masking Automation framework for Enterprise Data Platform saving almost 70% of development time, Universal Customer Master DB Golden Copy creation for masking PII Data elements
• Developed ETL Process to perform transactional restore from Customer Master Archive Database to Customer Master Application Database through ILM Data Archive Asynchronous API so that EDM Compliance Data Retention policies are met
• Mentored team members and assists them in all Design aspects
• Resolved conflicts and negotiated mutually beneficial agreements between parties

P&C Data Analytics

• Understand P&C Umbrella Data Model to design ETL jobs and develop code for P&C Umbrella Insurance Policies files to downstream systems realignment to P&C Datawarehouse and retire Legacy sources
• Generate Umbrella Policies File for Active members & Inactive members ~ 580K record size and send to Marketing System where SAS libraries are called to generate reports
• Develop ETL code in Informatica Power Center to create Mappings, Sessions, & Workflows
• Configuring jobs in ETL Framework and schedule jobs in Control-M scheduler
• Create Design and Tech specs documents

Business Technology Solutions - Data Integration

• Implemented integration process to migrate ~5 million Vehicle Titles from Legacy Siebel CRM Application to Salesforce Service Cloud CRM
• Integration of External Applications data for Title related attributes into Salesforce
• Near-real time ETL process handling of Title synchronization for better Customer Service
• Migrated and converted ~ 200 million Salesforce Standard Cases to Salesforce Custom Activities and System Events which are Service Requests in Legacy Siebel CRM Application
• Implemented Data compliance project of Purging of ~ 75 million Standard Cases , ~120 million Custom Activities in Salesforce CRM , archived to On-premise Database and configured OData Connector feature to populate archived data on Salesforce
• Purged Cases, Activities, System Events data from TFS Salesforce.com which saved significant dollar amounts in cloud storage costs
• Implemented integration process for Phone Scrub in Universal Customer Master Application for ~7 million Customers deriving Phone Type Indicator, Phone Ownership Flags from Neustar Inc
• Implemented integration process for sending Phone scrub attributes information to Genesys Telephony Application for Lease Vehicle Customer retention dialing and compliance
• Implemented integration process for Bankruptcy Flags update for Customers in Universal Customer Master Application and this is critical for Credit Risk application to tailor suitable interest rates for Auto Loan Customers
• Salesforce workbench SOQL queries execution for data quality checks
• Informatica Cloud and Salesforce PK chunking configurations for data extraction from Salesforce repository
• Designing ETL Strategy & Architecture of projects, tasks & deadlines
• Work Breakdown Structure(WBS) into tasks and estimate simple, medium and complex methodologies
• Review ETL code design , Unit Testing Strategies with developers
• Assist in ongoing ETL Development for Salesforce Interface Applications, Siebel Applications , Host Applications, Unstructured Data sources
• Using Informatica PowerCenter Designer to Extract & Transform from various source systems (Mainframe, Salesforce and flat files) by integrating business rules using different objects and functions that tool supports
• Leverage Informatica B2B Parser Transformation to read Auto generated Dealers invoice PDF files and convert into relational structures
• Created and Configured Workflows and Sessions to transport data to target Oracle database tables using Informatica Workflow Manager
• Developed ETL Unix Shell utility scripts to generate batch process dates , custom emails about ETL jobs status, publish near-real time customer attributes updates from Customer Master Application to Salesforce Customer Servicing Platform
• Schedule jobs in Autosys scheduler

Auto & Property Loss Reserving ADS Realignment to P&C Warehouse

• Sourced P&C Loss Data from > 2 TB volume of P&C Warehouse hosted on Netezza and data transform to Loss Reserving Data Mart which generates ~12 million Loss data at Customer level for Data Reporting Analytics
• Managing tasks and deadlines for ETL both Onsite and Offshore
• Create Technical Specs and Low Level Design
• Understand Dimensional Model of P&C Datawarehouse and Loss Reserving DataMart and conduct knowledge sharing sessions with Onshore and Offshore team members
• Using Informatica PowerCenter Designer analyzed source data to Extract & Transform from various source systems (DB2, Netezza and flat files) by incorporating business rules using different objects and functions that tool supports
• Using Informatica PowerCenter created mappings and mapplets to transform data according to business rules
• Used various transformations like Source Qualifier, Joiner, Lookup, Router, Filter, Expression and Update Strategy
• Implemented slowly changing dimensions (SCD) Type1 & Type 2 for Loss Reserving Data Mart Dimension tables
• Created and Configured Workflows and Sessions to transport data to target warehouse Netezza tables using Informatica Workflow Manager
• Implementing best practices, tuning and optimization for ETL code
• Configure ETL Unix Shell scripts in ETL Framework process and schedule jobs in Control-M Scheduling tool

BI Rapid Application Development – Enterprise IT Reporting

• Established integration process for Project Milestones, Workforce data projected to Salesforce Sales Cloud CRM through IBM Datastage ETL
• ~ 20K volume of data is projected into Salesforce CRM
• Prepare ETL design documents and flow diagrams
• Construct ETL to load source files into DB2 target database through IBM Datastage
• Move components to Test ETL and deploy code to Production Environment
• Production Data validation and approval from BO reporting team
• Schedule jobs through Control-M Scheduler

Data Integration Infrastructure & Support

• Starting and stopping Informatica & Datastage during SAN maintenance and in the event of Major Incidents
• Typically managed over 4-5 Infrastructure Major Incident calls in a month and handled huge number of Informatica Deployment requests through automation
• Creating Datastage/Informatica users across USAA
• Code optimization and recommendations for IBM Datastage
• Standard UNIX directory creation for all Projects in Datastage/Informatica
• Creating Datastage projects across Dev/Test/Prod environments and parallel set up of UNIX structure
• Setting up sticky-bit and maintaining service account security at all levels in Unix Tree
• Monitoring server health like CPU usage, throughput, Job statistics on Datastage & Informatica
• Setting up .profile & .ssh keys for service accounts
• Informatica code migration across Dev/Test/Prod
• Database Cataloguing and setting up ODBC connections for Datastage & Informatica

Customer - United Services Automobile Association(USAA)

Enterprise Financial Crimes Management

• Study the Norkom Fraud & AML application management process, procedures, identifying areas for improvements and implementing the same
• Designed and developed IBM Datastage Parallel Jobs and Sequencers based on business user requirements and business rules to load data from source flat files and oracle tables to target tables
• Worked on various kinds of stages like Transformer, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Column Import, Column Export and Merge
• Developed reusable parallel jobs
• Involved in monitoring parallel jobs and in optimizing load times
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications
• Created technical specification documents based on the requirements by using S2T Documents
• Preparing Unit Test Plans and UTR documents

Customer - Scottish Widows(subsidiary of Llyod's TSB Bank), Scotland UK

ETL Application Support & Development for Chatham Applications

• Developing and Enhancements of Datastage parallel jobs
• Extracting data from different databases including DB2 UDB,Oracle and loading into data warehouse and different data marts
• Understanding logical and physical data models for Slowly Changing Dimension loads
• Identify and Remove Bottlenecks in order to improve performance of parallel jobs

Customer - Indian National Center for Oceanic Services (INCOIS),India

Design and Develop Tsunami Early Warning System

• Development of IBM Datastage Parallel jobs for ETL operation of ocean related data from different sources which includes Flat files, CSV files ,Excel Files and loading into IBM DB2 target database, by running parallel jobs
• Created environment for Staging area, loading Staging area with data from multiple sources
• Involved in Data Migration from IBM p570 development server to IBM p590 which is partitioned(DB2 DPF) and clustered(HACMP) production environment
• Participated in Database creation, Logical node creation for physical nodes, Table Space &,Buffer Pools creation, and Table creation
• DB2 DBA related activities
• Handling PMRs raised with IBM
• Analyzed business process workflows and assisted in development of ETL procedures for moving data from source to target systems
• Created UNIX shell scripts for Datastage ETL to automate execution
• Scheduling Parallel Jobs in Unix Crontab Scheduler
• Monitored jobs using Datastage Director, which were scheduled, running, completed or failed