SUMMARY

• Experience in Data Management including Business Analytics, Data Analytics, Data Management, Data Governance, Data Privacy, Data Lineage, Data Steward, Data Dictionary, Metadata Management, Data Quality, Database Systems, Quality Control and ETL Processes
• Successfully executed large IT projects through all phases of SDLC. Responsible for cost, schedule and stakeholder management
• Strong cataloging experience using Collibra Catalog and Informatica EDC
• Hands on experience in establishing CCPA and GDPR frameworks using the WireWheel, Big ID and Collibra
• Experienced in working with the key components of the Collibra DGC such as Business Glossary, Reference Data Stewardship, Data Dictionary, Data Helpdesk, Policy Manager, Issue Management and Data Catalog
• Strong experience in Data Extraction, Transformation and Loading (ETL) using various tools such as SSIS, data cleansing and profiling. Relational Databases (Oracle and MS SQL Data Warehouse)
• Good understanding of the Collibra operating model with self - driven capabilities in implementing the use cases with minimal supervision
• Utilized Tableau Online and Tableau Server to enable user interaction of Tableau dashboards with clients
• Strong experience in building visualizations, performing data modeling and data transformation in Power BI Desktop
• Facilitated and contributed to Data/Information Governance workshops to define Data Policies/Principles, Data Governance Processes & Procedures, Stewardship Roles and Responsibilities, Data Principles
• Document technical design artifacts, process flows, and user guides for business processes
• Develop sophisticated BPMN based workflows by leveraging Collibra JAVA and REST APIs, writing groovy scripts, and builds user forms using Eclipse/Activiti and Flowable such as to automate the governance process for enterprise metadata management initiatives
• Define and configure email directories and templates to send notifications through workflows
• Develop API based integration solutions to read/write data from other platforms into Collibra
• Migrate outdated governance enabled solutions to existing API supporting versions (currently on version 2)
• Work with data architects, leads, business users and stakeholders to define the DGC operating model to be used to govern data
• Define roles, permissions, asset relations, characteristics, statuses, articulation score, scoped assignments and workflow configurations
• Create dashboards for internal business teams, roles based, reports, and views
• Write validation rules to validate assets
• Engage closely with leads and business teams to understand governance standards, policies, data privacy and protection laws - GDPR (General Data Protection Regulation), CCPA (California Consumer Privacy Act) in order to follow Walmart enterprise standards
• Conduct unit testing, UAT (user acceptance testing) to test the functionality of business processes
• Support production rollouts of business solutions in all higher environments

PROFESSIONAL EXPERIENCE

Confidential

Collibra Techno-Functional Consultant

Responsibilities:

• Managed Collibra DGC across the enterprise, driving governance activities for all participating business units and ensuring all work activity is completed on time and to standards, while mitigating risks as needed
• Responsible for the intake process, ensuring all requests or issues are handled in a timely manner and assigned to appropriate parties for review, resolution, and escalation
• Developed workflows for Request New Business Term, Life cycle of Policy Management, Change Request, and Data governance Support
• Created Glossary with terms and definitions, mapping between logical elements and physical elements, simple relations and complex relations for mapping
• Worked with system owners and business data stewards to document existing change control processes and defined new processes
• Authored Enterprise Data Governance Center Onboarding Questionnaire, Checklist and Guide which helped the teams to facilitate the Collibra onboarding process with the Business Stakeholders
• Lead discovery and documentation of data lineages for key reports
• Set up Collibra Communities, Domains, Types, Attributes, Status, Articulation, Workflow and customize attribution and solution including custom dashboard with metrics, status, workflow initiation and issue management for each domain specific requirements
• Customized dashboard for show metrics to business users
• Migrated Collibra Software from V4.6 to V5.2
• Build and implement Data Governance Standards and contents to meet internal and external needs
• Produced and maintained Data Governance documentation and artifacts
• Collaborated in creating a center of excellence (COE) around Informatica Data Quality (IDQ) and Informatica Data Validation Option (DVO)
• Automated the Test Creation Process and Data Validation by using Informatica Data Validation Option (DVO)
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 10.x Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Used different algorithms like Bigram Distance, Edit Distance, Jaro Distance, Reverse Distance, Hamming Distance to determine the threshold values to identify and eliminate the duplicate datasets and to validate profile and cleanse the data. Created/modified reference tables for valid data using IDQ Analyst tools.
• Used the Address Doctor to validate the address and performed exception handling, reporting and monitoring the system. Created different rules as mapplets, Logical Data Objects (LDO), workflows. Deployed the workflows as an application to run them. Tuned the mappings for better performance.
• Design for high availability and business continuity using self-healing-based architectures, fail-over routing policies, multi-AZ deployment of EC2 instances, ELB health checks, Auto Scaling and other disaster recovery models.
• Implemented security best practices in AWS including multi-factor authentication, access key rotation, encryption using KMS, firewalls- security groups and NACLs, S3 bucket policies and ACLs, mitigating DDOS attacks etc
• Used AWS system manager to automate operational tasks across AWS resources
• Designed and deployed dynamically scalable, highly available, fault tolerant and reliable applications in AWS
• Used flat files and databases to generate Tableau Adhoc reports
• Generated Tableau Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Developed various dashboards, used context filters, sets while dealing with huge volume of data

Confidential

Collibra Technical Consultant, Data Technical Lead

Responsibilities:

• Worked very closely with Data Governance Lead and other team members to execute the Collibra Data Governance implementation and developed custom workflows
• Designed, installed and configured Collibra Operating Model and helped enterprise architects to model enterprise Metamodels
• Developed technical specifications, processes, and documentation to produce required data deliverables
• Configured and standardized application UI screens to display customized forms
• Developed custom BPMN workflows using Eclipse EDI
• Used APIs, JAVA classes and scripting for workflow development
• Developed application interface workflows using scripting and out of the box REST APIs
• Managed workflow deployments in Collibra
• Responsible to work with the business users for RACI activities and incorporate them in Collibra
• Responsible for analyzing the current state of the data management environment and the issues impacting the business capabilities to function smoothly
• Responsible for the intake process, ensuring all requests or issues are handled in a timely manner and assigned to appropriate parties for review, resolution and escalation
• Responsible for assessing the Business Intelligence and Analytics needs and propose alternate methods to realign the Data Migration strategy as per industry best practices complementing the Business Value Streams.
• Managed, mentored and provided timely clarifications and guidance to the involved teams in onsite and offshore model throughout the implementation process, ensuring the implemented architecture is adhering to the defined architectures.
• Collaborated in creating a center of excellence (COE) around Informatica Data Quality, Database Design (best practices, standards, re-usability etc.)
• Involved in analyzing and fixing Informatica MDM related issues
• Assisted with all other Informatica MDM Administrative tasks and project implementation tasks