We provide IT Staff Augmentation Services!

Data Governance Analyst/ Collibra Consultant Resume

5.00/5 (Submit Your Rating)

Parsippany, NJ

CAREER SUMMARY:

  • 6+ years of experience as a Business Analyst in Finance industry within Agile and Data Governance Space.
  • Experienced in gathering requirements for application development projects involving Agile Scrum and Waterfall methodologies and created Use Case Models, Data Flow Diagrams (DFD) and Activity Diagrams.
  • In - depth knowledge of Software Development Life Cycle (SDLC) methodologies like Waterfall & Agile.
  • Proficient in designing workflows and elaborating them with respect to change management principles; Business Process Mapping and Business Process Re-engineering utilization in mapping, modeling and structuring of the Enterprise Business Process Hierarchy.
  • Highly proficient in technical andbusinesswriting,businessprocess flow,businessanalysis and testing various methodologies.
  • Proficient in Data integration and developing Data Operating Models/Framework and implementing data management tools.
  • Strong understanding of project life cycle and SDLC methodologies including agile- scrum/safe.
  • Competent in creating unified modeling language (UML) diagrams such as use case diagrams, activity diagrams, class diagrams and sequence diagrams.
  • 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, Catalog, etc.
  • Strong knowledge in Data Quality, Data Profiling, Scorecards, Data Quality Metrics, Metadata Management.
  • Expertise with Informatica Data Quality (IDQ) toolkit, data cleansing, data matching, data conversion, data profiling, exception management, reporting and monitoring functions.
  • Strong experience in Integration using Mule ESB in integrating various third party solutions.
  • Proficient in performing checks for data completeness, accuracy, transformation and quality to reconcile the data.
  • Well versed in test planning, test preparation, test execution, issue resolution and report generation to assure that all aspects of a project are in compliance with thebusinessrequirements.
  • Strong experience in conducting User Acceptance Testing (UAT), documentation of test cases, test plans and test scripts.

TECHNICAL SKILLS:

Modeling Tools: Enterprise Architect, MS Visio, Smart Draw

User Interface Modeling: Balsamiq, SnagIt, Moqups.com, Axure RP

Requirements Management Tools: JIRA, Rational DOORS, RALLY, Team Foundation Server, Confluence

Testing Management Tools: Bugzilla, JIRA, Quality Center, QTP

Methodologies: Agile, Waterfall, Hybrid SDLC, Scrum

Enterprise Data Management: Collibra, Informatica, Abinitio, Mulesoft

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Data Governance Analyst/ Collibra Consultant

Responsibilities:

  • Managed the strategy and vision of the Enterprise Data Management to support the Data Governance program.
  • Assisted the Data Governance Manager with the formation of a new data documentation processthat improved data usage, quality for the entire organization.
  • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Collibra.
  • Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
  • Created Communities, Domains and Assets within Collibra.
  • Built the code values, code lists, attributes in Collibra DGC.
  • Designed and managed process workflow to identify, classify and define critical data elements that mitigated risk.
  • Integrated the Abinitio Metadata Hub with the Collibra Data Governance Center.
  • Expedited root cause analysis for the Data Governance Team by assuring the authentication of metadata, detailed reports and priorities of data quality issues among various lines of work.
  • Utilized Informatica Data Quality(IDQ) to determine the data quality issues for the MDM data.
  • Identified critical data element failures used for reporting and analysis across credit, financialanalytics, regulatory and operational reporting.
  • Defined the business glossary, rules, processesand metrics that identify gaps and ensured compliance with standards across the enterprise data stewardship.
  • Implemented data lineage and controls working with project and business leaders to analyze the impact of future changes on critical data elements and mitigated any potential risks to data quality.
  • Designed and developed several flows for new requirements and variety use cases using the MuleSoft Anypoint Studio of Mule ESB
  • Developed the integration workflows using a MuleSoft ESB 3.7.3 framework.
  • Performed cost-benefit and return-on-investment analysis for proposed systems to aid management in making implementation decisions.
  • Interpreted data, analyzed results using statistical techniques and provided ongoing reports.
  • Developed and implemented databases, data collection system, data analytics, and other approaches to optimize statistical efficacy.

Confidential, Dallas, Texas

Business Systems Analyst/Data Governance Analyst

Responsibilities:

  • Worked with business partners to identify critical data elements for the projects in scope. Performed initial analysis and partnered with MIS and Business teams to define and capture metadata, lineage, business rules and transformation logic.
  • Owned end-to-end governance process within Collibra across all the identified domain. Analyzed root cause for issues identified and engaged the right parties across the teams for timely resolution.
  • 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.
  • Integrated IDQ Mappings and Mapplets with Collibra and scheduled jobs to run the workflows.
  • Managed integration of Collibra Connect with various 3rd-party sources using Mulesoft ESB.
  • Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
  • Worked with IT to establish processes for an on-going maintenance and set up exception reporting and metadata changes.
  • Managed workflow process in Collibra.
  • Responsible to work with the business for RACI activities and in corporate them within Collibra.
  • Developed key relationships with SME’s and data owners and driven discussions to standardize attributes & metrics and assisted with establishing clear ownership of data elements.
  • Assisted Data Quality team with establishing data quality rules, thresholds, quality reports & dashboards.
  • Collaborated with reporting analysis and data strategy functions to represent needs of the domain, assessed and identified impacts across multiple projects.
  • Contributed to the development of training materials and coached small groups on the new processes across the data governance lifecycle.
  • Created MULE ESB artifact and configured the MULE configurations files and deployed.
  • Developed ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
  • Escalated project timeline and quality issues appropriately to ensure overall program success.
  • Supported the development and implementation of new data policies.
  • Supported the creation of program business definitions and data management goals and principles for execution.
  • Performed data analysis for various enterprise wide data quality initiatives.
  • Coordinated the analysis of data gaps by collaborating with appropriate data owners and business partners.

Confidential

Business Systems Analyst

Responsibilities:

  • Acted as a product Subject Matter Expert (SME) to answer questions from staff regarding new functionality, system inputs, process and outputs for the Loan Fulfillment Center NextGen product.
  • Acted as a liaison between the Product owner and the scrum team to define business requirements and collaborated in defining design options through a hybrid agile methodology.
  • Worked closely with Product owners, developers, quality assurance and application support teams to implement software requirements and communicate system enhancements.
  • Applied mortgage software industry knowledge to help continue process improvement and team communication.
  • Generated SQL queries and researched databases to verify and troubleshoot issues.
  • Successfully loaded data into SQL Server, analyzed and explained the result using Server and Access.
  • Retrieved and modified data using SQL server and acquire product information from different database.
  • Created and maintained database for ERP system to tracking business resource.
  • Created and maintained database for work orders, workflow management.
  • Managed deliverables for initiatives and adhered to Mortgage Cadence product development methodologies.
  • Extracted detailed system requirements from user story scenarios and high level business requirements.

Confidential

Business Analyst Intern

Responsibilities:

  • Planned, facilitated and conducted requirements gathering / blueprinting sessions, meetings and presentations with business and IT Stakeholders.
  • Translated business needs into functional & technical specifications as needed.
  • Documented the business needs into requirements documents that included user stories, process, data flows and mock-ups.
  • Identified data transformation/mapping requirements as needed to support business requirements.
  • Reviewed QA test scripts and provided inputs to the QA Team.
  • Participated in UAT planning & execution to make sure that the business users are comfortable with the implementation and provide a user acceptance sign-off.

Confidential

Business Analyst Intern

Responsibilities:

  • Learned SDLC process to develop and deploy software applications.
  • Conducted Sprints, Sprint Planning Meetings, Sprint Reviews and Sprint Demos.
  • Coordinated with the product owner, Scrum Master, customers and developer to write user stories.
  • Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings.
  • Documented functional requirements after extensive interaction with the SME.
  • Worked extensively with risk manager and SME loans reporting software to gather and analyze critical information for loan modification system.
  • Got trained on Functional processes and SQL Programming, handling Onsite - Offshore Co-ordination of development team, estimation for developments and testing, planning and scheduling for projects executionadhering to Standards and Quality management process.
  • Trained on implementing stored procedures and views and creating checks for inserting and updating data based on the requirements.

We'd love your feedback!