SUMMARY

• Around 10 years of experience in IT industry.
• An individual with accountability and responsibility for the development and execution of data profiling and related data quality analysis and remediation activities as part of issue or proactive data quality monitoring activities. A participating member of the Data Quality Board and Program Office, reports on data profiling and data analysis activities, makes recommendations on remediation approaches, and collaborates with other IT members to resolve data issues
• Experience in Identifying Business Risk, Critical Capability and Define Data Types.
• Define Business Rules from Business Processes
• Extensively worked for Creating Data Classification Matrix for Multiple Banking Projects
• Good Experience in Data Governance Presentation to Major Entities.
• Worked and Established Data Dictionary, Data Glossary, Data Discovery Setup.
• Actively participated in Data profiling, data analysis and providing metrics to data stewards
• Good exposure on Data Governance implementation methodology and Governance Structure with Multiple Entities and Compliance
• Working on beta - testing for Informatica Data Quality v9.5.1 with Informatica Corporation
• Point of contact for Data Quality framework and development
• Data parsing
• Data standardization
• Data cleansing & Data correction
• Address Validation
• Data Matching(Exact Matching and Fuzzy Matching)
• Data Integration
• Exception Management
• Data Enrichment
• Experienced in installation, configuration, management and deployment of HDFS, Hive,Sqoop, Oozie & KAFKA
• Development Experience in creating PL/SQL Stored procedures, Packages, Triggers and Functions.
• Worked with DUNS,MORNING STAR,FATCA third party Reference data for Data Quality.
• Working experience with devops practices in application technology including CI/CD deployment using Jenkins,Ansible tower and GIT.
• Performed all necessary day to day agile and sub version support for different projects.
• Experience in End to End release management for code delivery
• Involved and Developed Data Recon product for Data Quality(End to End) for Banking Domain.
• Extensively used Informatica Tools - Power Center, Data Quality, Data Analyst, PWX and Repository Management
• Demonstrated experience installing, configuring and tuning Informatica Data Quality Tool
• Demonstrated experience implementing Informatica Data Quality applications for both business and technology users across a full development life-cycle.
• Knowledge of DQ standard, guidelines and best practices
• Successfully implemented Exact match and Fuzzy match techniques across DUNS(DATA UNIVERSAL NUMBER SYSTEM), FATCA,Morning Star..
• Knowledge of Data Profiling guide lines and best practices.
• Knowledge of best practices on Process Sequence, Dictionaries, DQ Lifecycles, Naming Convention, Version Control
• Good Knowledge on Data Quality Exception Management Process.
• Involved in beta-testing on Informatica v9.1 (PC, IDQ, PWX)
• Done POC’s on new features in v9.1 (Look-up, SQL, Power Exchange, UDF, Data Profiling, IDA and Dynamic Partitioning)
• SPOC for Informatica Administration and SATYAM coordinator with Informatica Corp for all Informatica related issues
• Worked on Informatica Analyst, Profiling, Scorecards.
• Worked on new transformations specific to IDQ9.0.1 (Standardizer Transformation, Merge Transformation, Case Converter Transformation, Labeler Transformation, Address validator Transformations and Match Transformation)
• Involved in IDQ 9.5.1 configuration.
• Worked with different data sources like Flat Files, XML files, databases
• Expertise in ETL methodology in Data Extraction, Transformation and Loading. Experience in Performance Tuning of sources, mappings, targets and sessions. Ability to understand available technology, tools and existing designs and work on complex problems where Analysis of situations and Data gathering is required
• Ability to easily grasp new concepts. Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, capable of working efficiently under pressure
• Proven ability to work as a Team Player as well as an individual. Good Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities. Done Client interaction. Hard working and motivated.
• Coordination with the off-shore development team to fix release issues.

TECHNICAL SKILLS

Tools & Utilities: Informatica PC 8.6.1 & 9.1,9.5.1 IDQ, IDA, Informatica Power Exchange, PL/SQL, Oracle 8i/9i, Informatica Metadata Manager 9,Informatica Analyst, Informatica Administrator,Cognos,Abinitio Metadata Portal

Operating systems: Windows Server 2003/2008,Solaris 10

PROFESSIONAL EXPERIENCE

Confidential

Data Governance Process Lead

Responsibilities:

• Data Quality Rules Requirements gathering from Business Partners and Preparing HLD..
• Define Business Rules from Business Processes
• Creating Data Classification Matrix
• Providing Data Governance Presentation to Major Entities.
• Establishing Data Dictionary, Data Glossary, Data Discovery Setup.
• Working for Data profiling, data analysis and providing metrics to data stewards
• Working for Data Governance implementation methodology and Governance Structure with Multiple Entities and Compliance
• Regulatory data control automation project management
• Involving End to End Release management activity for the project deliverables.
• CI/CD Horizon workflow Implementation using Jenkins,Git and Ansible Tower
• Working in Agile Environment.
• Data Quality Team Management and delivery
• Member of Data Governance Team for Strategy discussions .
• Responsible for Data Quality Technical Issues.
• Point of contact for Informatica Data Quality service Teams.
• Coordinator for Beta Testing for IDQ Latest product versions.

Confidential

Sr. Data Quality Developer

Responsibilities:

• Participate in Meetings with counter parties for Data matching Requirement.
• DUNS Data Standardization
• Legal Data Standardization. implementing Exact match techniques.
• Implementing Fuzzy match techniques.
• Develop and validate deliverables with business process owners
• Report data quality issues, opportunities and recommendations to program management

Confidential

Sr. Data Quality Developer

Responsibilities:

• Participate in data quality profiling and cleansing tool training
• Paticipate in Meetings with business teams for Data Quality Requirement.
• Conduct data quality profiling training to Data Quality Workgroup members
• Coordinate data quality profiling project activities within a data quality workgroup; set up interviews and meetings to determine root cause if needed
• Participate in weekly data quality review meetings to understand data quality priorities and report status on existing workgroup projects
• Work with business Data Stewards and Data Custodians to profile data, review process models and data flows, perform root cause analysis, impact analysis and diagnose areas of risk or error
• Execute data quality processes to cleanse, integrate, transform and load data
• In corporate data specifications outlined by the business when developing or enhancing the systems
• Translate the business and data rules and requirements into logical data models
• Follow corporate standards for definition of data types and naming conventions for tables and data elements
• Develop functional knowledge of assigned application system areas
• Assist in data integration resolution
• Demonstrated experience installing, configuring and tuning Informatica’s Data Quality Tool
• Demonstrated experience implementing Informatica’s Data Quality applications for both business and technology users across a full development life-cycle.
• Knowledge of DQ standard, guidelines and best practices
• Knowledge of Data Profiling guide lines and best practices.
• Experience in Data Quality Exception Management process
• Knowledge of best practices on Process Sequence, Dictionaries, DQ Lifecycles, Naming Convention
• Develop and validate deliverables with business process owners
• Report data quality issues, opportunities and recommendations to program management
• Calculate measurements and metrics at regular intervals to monitor data improvement and report monthly to program management

Confidential

Data Quality Developer

Responsibilities:

• Creating Checklists for Data Quality Coding, Testing and Release for a smooth, better & error free project flow.
• Coordinate data quality profiling project activities within a data quality workgroup; set up interviews and meetings to determine root cause if needed
• Participate in weekly data quality review meetings to understand data quality priorities and report status on existing workgroup projects
• Work with business Data Stewards and Data Custodians to profile data, review process models and data flows, perform root cause analysis, impact analysis and diagnose areas of risk or error
• Execute data quality processes to cleanse, integrate, transform and load data
• In corporate data specifications outlined by the business when developing or enhancing the systems
• Translate the business and data rules and requirements into logical data models
• Follow corporate standards for definition of data types and naming conventions for tables and data elements
• Develop functional knowledge of assigned application system areas
• Assist in data integration resolution
• Demonstrated experience installing, configuring and tuning Informatica’s Data Quality Tool
• Demonstrated experience implementing Informatica’s Data Quality applications for both business and technology users across a full development life-cycle.
• Knowledge of DQ standard, guidelines and best practices
• Knowledge of Data Profiling guide lines and best practices.
• Experience in Data Quality Exception Management process
• Knowledge of best practices on Process Sequence, Dictionaries, DQ Lifecycles, Naming Convention
• Calculate measurements and metrics at regular intervals to monitor data improvement and report monthly to program management
• Worked on Oracle Cursor management and exception handling
• Worked on PL/SQL, Stored Procedures,Functions, Packages, Database triggers

Confidential

Sr. Developer

Responsibilities:

• Understanding the technical specifications / LLDs provided by the client
• Prepaired the Unit test cases
• Developed the IDQ, PC mappings based on design specification
• Doing peer reviews for other persons
• Testing - unit testing & integration testing.
• Create the IDQ mappings to provides the Qualitative data as per DA & BA and load the IDQ output data (output format of IDQ is files) to EDW and Mater tables using PC
• Updated the business Logic or any missing contents in design specifications
• Created complex mappings Using Standardizer, Labeler, Address Validator, Case Converter, Merge, Parser and Match transformation Using Informatica Developer.
• Implemented Data Quality techniques like Standardizing, merge, address validation, matching, Consolidation to get completeness, conformity, consistency and accuracy.
• Extensively used Data Quality Assistance for Exception Data Management
• Extensively using with different type of source format of data like XML and CSV and txt (output of IDQ).Worked on mapping parameters and variables for the calculations done in aggregator transformation.
• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.
• Created, Scheduled and configured workflows, work lets and sessions using Informatica workflow manager.
• Interacting with Client on regular basis.