Srinivasulu M

About Srinivasulu M

15 years of Professional experience in IT in Data Engineering• Domains: Banking, Health care, Insurance & Pharmaceutical.• Led many teams with excellent Coordination & Communication skills and capable of handling Offshore, Onshore • Configured MDM landing, staging, Base Objects, Relationships and source systems for Multiple Domains like Application/Submission, Party, Product and Ingredient.• Configured Audit Trails and Delta Detection in Mapping Settings to load RAW and PRL tables• Created complex mappings by using cleanse functions and configured stage process.• Created match rules like fuzzy match for finding the probabilistic match of the records andexact match for finding the exact match of the records in Base Objects.• Configured queries and packages to view data in Base Object’s and PUT Packages for manualMerge Process• Configured Cleans match server for Cleanse functionality and other third party servers forscheduling and secure authentication• Created the Entity Relationship Modeling for Product 2.0, for Child, Parent, Landing & Base tables for informatica MDM tables. • Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD ( Informatica Data Director).• Extensive experience & proficient knowledge in writing Advance/complex Sql Queries, PL/SQL Sequences, Procedures, Functions, Triggers and Unix/Linux Scripting.• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files & XML. • Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.• Installed and upgraded Informatica IDQ and PowerCenter tools• Download and updated the latest Address Doctor Reference Files across Envs• Responsible in creating IS, RS, MRS, DIS, CMS, Email and Analyst services• Perform INFA Admin Activities such as creating, removing users and their privileges, LDAP & configuring connections• Had worked with INFA Tech Support team on various admin related activities such as log4j, PmDTM, Rest Api & HA• Perform code promotions across environments• Developed ETL Solution to read pdf & xml files using IDQ and ETL tools and write into database• Implemented data management solutions for multiple master data domains• Led data migrations from legacy systems into MDM

Experience

1. Informatica Etl(Iics, Idq, Power Center) Lead and Mdm Developer

   LumenData

   Oct 2017 — Present

   Installed and upgraded Informatica MDM, IDQ and PowerCenter toolsIdentified and resolved the Log4j issues in MDM, IDQ and PowerCenter application server Perform INFA Admin Activities such as creating, removing users, LDAP, connections and Services such as IS,RS,MRS,DIS,CMS and AnalystHad worked with INFA Tech Support team on various admin related activities such as log4j, PmDTM, Rest API & High Availability, Purge Mechanism on OPB Repo tablesDownload and updated the latest Address Doctor Reference Files across EnvironmentsDeveloped ETL Solution in parsing different PDF forms using Informatica B2B and embedded into PowerCenter Code and loaded into the database Designed and updated Parsing and Master Data modelsPerformed Analysis on Source data and identified the potential Mastered elements Have developed a IDQ Process to invoke Rest API TransformationConfigured MDM Landing, Staging and Base Object tables, Mapping, M&M Rule setup, queries and packagesConfigured IDD screens initially and later developed Entity360 screensConfigured MDM batch groups for Stage, Load, and match & MergeDeveloped ETL Batch processes to master data from different sources all the way up to MDM Baseobject and run M & MHave created L1 Materialized views on top of every Base Object and exposed to publish layerConducted the Match & Merge Tuning exercise and improved the matching criteria by 10% of entire data for Party and Product Domains. Enrich the party addresses using Google API where AD didn’t provide much infoHave created L2 Denormalized tables to flatten the master data per domain and exposed to downstream system for consumptionIdentified data quality issues and process design improvements to remediate existing data and prevent future issues.Designed and deployed IDQ scorecards to monitor data quality for 5 master data domainsEnabled GIT configuration on IDQ tool for versioningSupported data lineage for single source all the way to publish layer in EDC

Education

• Sree Vidya Nikethan Institute of Management, A. Rangampet, Tirupati

  Bachelor's degree on computer, Computer Science

Skills

• Servlets
• Informatica
• Pl/Sql
• Harvest
• Requirem
• Ofsaai
• Software Development Life Cycle (Sdlc)
• Endeavor
• Unix
• Data Modeling
• Databases
• Erwin
• Hp Alm
• Microsoft Sql Server
• Winscp
• Agile Methodologies
• Idq
• Oracle
• Requirements Analysis
• Tableau
• Etl
• Javascript
• Reveleus
• Sql
• Data Analysis
• Hpp
• Data Warehousing
• Shell Scripting
• Core Java