EXPERIENCE SUMMARY:

• 6 years of extensive experience in Data Governance, Data Privacy, Data Analysis, Data Quality Management, Data Warehouses, Agile Project Management, Eliciting Requirements, Facilitating Stakeholder discussions, Software Testing and Prod Support
• Understanding and knowledge of: Data Security, encryption, data privacy standards, confidentiality classification, password practices, user authentication, data security audit, data quality requirements specifications, data quality profiling and analysis, structured and unstructured data management
• Hands on experience in configuring Collibra as per enterprise metamodel, managing Data Stewardship activities in Collibra, Data Cataloging in Informatica EDC and data quality using Informatica DQ
• Excellent relationship building ability with clients and has halped clients implement major operations and technology initiatives by process analysis, designing and implementing complex assessments, developing implementation roadmaps, improving application platforms
• Supported and developed compliance assessments for information governance, data protection, and privacy including development of controls to measure risk
• Processed, evaluated Data Subject Access Request (DSARs) by working with the Privacy Team
• Proficient in Data Analysis, System Analysis and Business Requirements Gathering in an Agile fashion
• Organized JAD sessions to gather requirements at various stages. Good understanding of Project Process and ability to analyze business problems and identify solutions
• Worked extensively with the team to meet business requirement, create mockups and analyze workflow
• Created Communities, Domain, Roles and its associated permission in Collibra DGC
• Excellent analytical skills to understand the business process, functionality, requirements and to translate them into System Requirement Specifications
• Worked on Data Mapping for Data Migration for thousands of records in the system using Excel, SQL DB and Visual Studio
• Good understanding of IBM Infosphere Information Governance Catalog (IGC)
• Defined Test Cases / Test Design Documents, analyzing defects, interacting with team members in fixing bugs and User Acceptance Testing (UAT)
• Comfortable at presenting data lineage and data management concepts to business and technical audiences and ensuring dat the data lineage is clear, and signed off, with any assumptions or dependencies clearly identified and mitigated
• Maintained all the stories and tasks in JIRA which was used to know the status of requirements
• Documented and guided in preparing the release notes during the production and deployment phases of the project
• Experience operating the Data governance tool Collibra
• Expert in using Symantec Data Loss Prevention (DLP) tool using the Exact Data Matching (EDM) functions
• Advanced operational experience using the Dataguise tool DgSecure to perform data masking

TECHNICAL SKILLS:

Business Process Modeling Tools: MS Visio, Lucid Charts

Databases: MS SQL Server 2008 R2, Oracle 11g, SQL

Data Governance Software: Collibra, Informatica Axon

Data Cataloging: Collibra, Informatica Enterprise Data Catalog (EDC)

Defect Tracking and Testing Tools: JIRA, MS TFS

Requirements Management Tools: Rally, Doors, Confluence, JIRA

Version Controlling: Microsoft SharePoint, One Drive

ETL Tools: Informatica, Talend

Programming Languages: SQL, Python, R programming, HTML, JavaScript, JSON, XML

Data Masking: DgSecure

Scanning tools: Symantec Data Loss Prevention (DLP)

Data Visualization/ Bi Tools: PowerBI, Tableau, Excel, SSRS, R, Weka, SAS, Qlikview, Looker

Web Analytics & Scrapping: Google Analytics, Google Ad words, Puppeteer, Automate, PowerShell, VBA, VBS

PROFESSIONAL EXPERIENCE:

Confidential

Data Security Analyst - Cybersecurity (SIOC)

Responsibilities:

• Performing security assessments utilizing custom security control framework.
• Co-ordinating and collaborating with cross functional teams, IT teams as required to halp identify and protect sensitive data & Tracking Metrics.
• Worked closely with the Risk team to analyze potential risks and create a risk dashboard.
• Prepare monthly reporting dashboard to the leadership team on remediation and scanning efforts.
• Performing a key role in establishing and strengthening an enterprise data governance implementation to:
• Improve the quality and protection of sensitive data
• Respond to regulatory protection requirements
• Understanding of privacy laws, regulations (ex. CCPA)
• Experience in an organization with large-scale data and oversight
• Become the liaison between multiple lines of business, groups and stakeholders involved in the data security program
• Ability to develop constructing working relationships and manage challenging situations
• Performed Data analysis and analyzed data from multiple sources and generated multiple reports.
• Working closely with technical team and consolidate information in tracking sheets.
• Updating Metrics data and populating dashboards.
• Supporting team on Analyzing risks, gather audit information, follow-up on remediations and Tracking Data governance Metrics.
• Supporting team on Security Assessments on sensitive and restricted data in structured repositories.
• Documenting findings and implement remediations as part of Data Security Program.
• Maintaining Data Inventory on Collibra or Excel tools.
• Collaborating with internal PG&E teams/stakeholder/working groups and vendors in implementing remediations.
• Expert in using Symantec Data Loss Prevention (DLP) tool using the Exact Data Matching (EDM) functions and setting up targets for scanning and generating reports for the same.
• Performing data analysis on EDM indexes using SQL and automating the feed by writing queries.
• Writing PowerShell Scripts to automate different processes like multiple nslookup etc which would cut down manual work.
• Masking sensitive information from lower level environment wherever PII is found using the Dataguise tool DgSecure
• Creating data classification PII policies for the data security program using Excel and Symantec Data Loss Prevention (DLP)
• Created process flow workflows in Miscrosoft Visio.

Confidential

Data Governance/Privacy Analyst - Privacy and Security

Responsibilities:

• Analyzed data and partnered with domain owners, data stewards and other business and IT stakeholders to ensure governance functions are adhered to and the business has a full understanding of their data
• Collaborated across business and technical associates to identify and resolve data errors/issues, escalating material issues dat could impact business decision-making
• Worked on different modules of Privacy dashboards like risk assessments, onboarding business processes, data sharing agreements and third-party vendors
• Utilized data quality tools, worked on data profiling & techniques to halp ensure dat data accuracy is appropriate for the intended business use
• Performed an end to end Data Lineage on Collibra which maps relationships between data to show how data sets are built, aggregated, source and used providing complete end to end lineage visualization from source to Target
• Modeled Workflows in Microsoft Visio to get visual representations of Process and Work/Dataflow
• Developed the naming conventions and taxonomy(classification) standards in Microsoft Visio dat served as a starting point for other subsequent teams standing up a Data Governance program
• Ensured dat business rules are maintained, and data anomalies are resolved appropriately
• Elicited the requirements from WireWheel team to enhance the development efforts associated to the CCPA module in WireWheel
• Gathered and documented metadata requirements using standardized project documentation and maintained the document versioning in Confluence
• Understanding of Collibra system admin/backend and providing support
• Works with the Data Governance lead to define and document requirements for Collibra implementations and Integrations
• Used SQL to extract data from repository to build dashboards on Tableau
• Created custom extracts, reporting, metrics, and dashboards from Collibra using REST APIs

Confidential

Data Governance-Metadata Analyst

Responsibilities:

• Collaborated with the Data Governance leadership team and developers to ensure consistency across reports in terms of data definitions and lineage, as well as enlist business unit support to take ownership and responsibility for data definitions and data quality
• Liaison between business partners and metadata engineers
• Gathered and documented metadata requirements using standardized project documentation
• Authored Enterprise Data Governance Center Onboarding Questionnaire, Checklist and Guide which halped the teams to facilitate the Collibra onboarding process with Business Stakeholders
• Acted as a project manager expert to guide the Data Governance projects from start to completion
• Performed Collibra support functional activities including setting up Data Governance operating model, developing workflows, importing, or exporting information, customizing dashboards & widgets, views, etc.
• Onboarded Communities, Domains, Assets, Relationships and Users in to Collibra DGC
• Performed Data cataloging using Collibra, Informatica Enterprise Data Catalog (EDC) and Data quality using Informatica DQ
• Provided Collibra consumer and author support, to include batch imports of content, building data, business glossary and lineage.
• Set up Collibra Communities, Domains, Types, Attributes, Status, Articulation, Workflow and customize attributes and solution including custom dashboard with metrics, status, workflow initiation and issue management for each domain specific requirements
• Gathered requirements to build custom workflows in Collibra and written test cases to validate the workflow functionality
• Performed testing and supported metadata implementations
• Documented User Guides on how to create communities, domains, domain type, assets, asset types, relationships, traceability, lineage etc.
• Managed and reviewed logs via Collibra Console
• Worked on data mapping and data movement for Amazon S3
• Worked on data extraction using SQL and created reports on PowerBI and Tableau.
• Built scorecards to understand number of data assets and their source cataloged for example AWS, Azure, Oracle etc
• Maintained and promoted key data governance deliverables / assets, including data policies, data standards and data management roles and decision frameworks
• Maintained Data Stewardship framework (Defined data roles and responsibilities) within Collibra as per enterprise data governance team
• Created various documents including the Business Requirements Document (BRD), Functional Requirement Document (FRD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Collaborated with the Data Stewards, Architecture, and Information Technology to prioritize and resolve: data sourcing, business rules, data aggregation, data distribution, and data consumption
• Used Microsoft SharePoint to keep different version of document and configuration management, and to report bugs/defect
• Created Product backlog with halp of user stories collected through requirements gathering and gap analysis
• Served as an escalation support for data management and led the development of documentation for users

Confidential

Data Intelligence/Governance Analyst

Responsibilities:

• Analyzed source system entities, transformation logics and downstream reports such as collecting, organizing and manipulating SAP data in Oracle to provide American Express with their requirements for Spend Analysis in various payment categories
• Created interactive dashboards for the Global Sourcing and Procurement Team in tableau using visualizations such as bar graphs, scatter plots and box plots. Data manipulation was done in SAS
• Acted as a liaison between the Data Governance team and the IT team to implement Data Governance policies and standards across the organization
• Expertise in conducting various requirement gathering tasks including - pre-analysis, setting up requirement gathering calls, spec walk-thru calls, control management, change management, requirement freezing task and identifying and fulfilling the gaps
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the Project Manager and the Technical Lead
• Well-versed with the technologies and products used in a Business Units. Possess experience working with Enterprise Architects, Business Stewards and Data Stewards and Stakeholders to transform Metadata to BUs
• Maintained business requirement documentation and technical specification documentation using web-based application, Microsoft SharePoint
• Used ETL Informatica and Talend for refreshing the data for the monthly dashboard update
• Identified, analyzed, and interpreted patterns in vendor master data MDM for the low ranked vendors using SQL

Confidential

Business Data Analyst

Responsibilities:

• Used the Agile methodology guidelines to carry out every step of thebusinessmodeling process
• Lead discussions and JAD Sessions to gatherbusinessrequirements and discuss possible solutions documenting them Software Requirement Specifications (SRS)
• Elicited demands from the stakeholders and analyzed them for consistency, flexibility and completeness
• Organized workshops with Subject Matter Experts (SME) to obtain domain level information
• Coordinated with thebusinesspartners in conducting the UAT (User Acceptance) Testing
• Facilitated Interviews & Questionnaire Sessions with end users,businessintelligence team, and SME's
• CreatedBusinessRequirement Document (BRD) & assisted in developing Functional Requirement Documents
• TranslatedBusinessRequirements and Functional Specifications into Scenarios to make developers understand the requirements in easier way