Karthik Pidaparthy

C*C only – 415-***-****- ac4ck9@r.postjobfree.com

SUMMARY

• Certified Informatica MDM Multidomain 10: Developer, Specialist

• Over 4 years of hands on experience as a MDM Hub Developer specialized in design, development, testing and maintaining MDM systems using Informatica MDM product suite (MDM hub, IDD, Hierarchy Manager tool and SIF) and Power Center 9.5/8.6.1 (Designer, Workflow Manager, Workflow Monitor and Repository Manager).

• Masters graduate in MIS with hands-on experience design, build and implementation of MDM applications

• Deep product knowledge on Informatica MDM Hub, Informatica Data Director (IDD), Business Entities, Business Entity Services, Hierarchy Management(HM), Match/Merge process, ETL, SIF, IDD Java User Exits

• Certified Java developer

• Team player with strong problem-solving skills, analytical skills and excellent communication skills

WORK EXPERIENCE

Informatica MDM Hub & SIF Developer Feb 2017- till date Intel, Folsom, CA

• Configured IDD application by developing cleanse functions, custom cleanse functions and Java user exits well versed in implementing SIF

• Worked as an Informatica MDM Developer/ Consultant using Informatica MDM 10.2

• Designed data model along with the hierarchies, relationships and entities for product and customer domains

• Developed Business Entities, Business Entity Views and transformations using provisioning tool to generate a business entity schema that can be utilized by Entity 360 and Business Entity services

• Configured AVOS workflows and integrated them with MDM so that the tasks can be monitored using ActiveVOS console

• Developed transformations, mappings, mapplets, Java transformations in Informatica Power Center to consume the SQL server data and expose the mapplet as a web service

• Integrated MDM with Informatica Address Doctor Cloud for Address cleansing.

• Created IDD reports using Jasper Report Tool and modify/deploy BDD configuration to add reports

• Writing Unix Scripts to call MDM jobs (Stage and Load) using Crontab time based job scheduler

• Worked with Informatica support team to resolve existing MDM and Data Analyst product bugs

• Performed Admin Tasks using Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment

• Applied Data Governance processes and best practices Informatica MDM Developer Feb 2013 – July 2015

Infosys Ltd.- PricewaterhouseCoopers (PwC), India

• Worked as an Informatica Master Data Management (MDM) developer for PricewaterhouseCooper, USA (PwC) global data repository – a large scale MDM project handled by Infosys

• Actively participated in discussions, via telephone, email and in person with the onsite as well as offshore team, where requirements, design, build, testing defects and implementations were discussed

• Developing mappings using in-built cleanse functions, custom Java cleanse functions and Address Trillium functions for staging process as well as for IDD

• Developed Match paths, Match Columns, Match rule sets and Match rules (Exact and Fuzzy) for Match and Merge Process in Informatica Hub.

• Configured staging, loading, cleansing, matching, merging of MDM data to get single reference of golden data

• Created and Developed Informatica Data Director (IDD) application to allow Data Stewards to search, view and edit and delete the master records

• Analyzed the data and defined Trust scores and Trust score validation rules to get golden record BVT for Party and Customer data

• Used SIF APIs (GET, SearchMatch, PUT, CleansePut) to search, update, cleanse, insert and delete data

• Created Subject Area Group, Subject Areas, Subject Area Child and Subject Area Grandchild to organize data in IDD

• Developed IDD user exits using JAVA, Object oriented programming concepts, SQL, RDBMS concepts on Address, Relationships and Party data for MDM IDD application development

• Created very complex SQL queries on Oracle 11g/12g database to check record count and data integrity issues

• Configured data security in IDD to restrict unauthorized users from accessing and enriching IDD data

• Created search queries for each subject area in IDD to allow the Business users to search for the required data

• Configured schema, landing tables, staging tables, base objects, lookup tables, batch jobs, queries and packages

• Created Tasks in IDD and added actions to the tasks as part of the IDD workflow configuration

• Created custom Java cleanse functions and bound those cleanse functions to the columns in the IDD to cleanse the data and report validation errors

• Created PL/SQL Stored Procedures, Packages, Indexes, Views and Triggers to validate data on Informatica Hub

• Worked independently during UAT and Go-Live activities and fixed critical issues to ensure successful release

• Conducted Knowledge Transfer(KT) sessions on Informatica Data Director (IDD), Informatica MDM Hub and User Exits ACADEMIC PROJECTS

Analytics- Data Warehousing(SSIS)

• Designed and developed a Data warehouse to categorize the interest trends of customers

• Implemented ETL logic through SQL Server Integration Services (SSIS) Database for recording University Grades

• Developed a relational database for a university using Oracle 11g database

• Created Entity-Relationship diagrams and Database diagrams to shows various entities, relationships and cardinalities

• Created Stored procedures to illustrate performances of each section SKILLS

Technical Skills Informatica Master Data Management(MDM), SIF APIs, IDD, Business Entity GUI Tools Informatica MDM Hub, IDD, Eclipse Indigo, TOAD for Oracle 11g, SQL Developer, SQL Server Management Studio, Visual Studio, MS Office Tools, Power Center, SOAPUI Programming Java, C#, C, C++, SQL, PL/SQL, T-SQL, ASP.NET, JavaScript, HTML, CSS, JQuery Web Services REST, SOAP

CERTIFICATION

Informatica MDM Multidomain 10: Developer, Specialist EDUCATION

Masters in Management Information Systems GPA - 3.8 Northern Illinois University, IL

Bachelors in Engineering GPA- 3.6

Osmania University, Hyderabad, India

Contact this candidate