Mdm Systems And Data Analyst Resume
Silver Springs, MD
PROFESSIONAL SUMMARY:
- Senior Enterprise Data Governance Professional with 5+ years of experience in analyzing customer needs and delivering results - driven solutions for high-quality product development. Helping customers by leveraging Master Data Management (MDM), Data Cataloging, Business and Data Analysis, and IT Project Management skills in a collaborative environment
- Liaison between business stakeholders and developers to gather business requirements, deliver MDM analysis, MDM health checks, Data Management, and support system integration and system decommissioning
- Discover, profile, and evaluate internal source systems and third-party systems using SQL joins, ETL and data quality tools (IDQ, Informatica MDM, Spectrum Designer, EDC, etc.); write rules for cleansing, standardizing and validating data
- Recommend adoption of new tools based on costs evaluations, return on investment, system infrastructure requirements, etc.
- Visualize reports and present customers with best practices recommendations, and high-level analysis to optimize their data quality, data models, and overall data governance infrastructure
- Lead gap analysis for data models (using Erwin, etc.) and recommending baseline fixes and standardize business processes
- Prepare and enhance data dictionaries, business glossaries, system profiles for system domains
- Lead data governance tasks tools such as Informatica EDC to help discover data, lineage, and impact, optimize semantic search, and enhance data assets from custom attributes to business glossaries; experience with configuring and maintenance of EDC
- Support silo and ad-hoc customer requirements to support a system’s functional and technical needs
- Leverage pragmatic knowledge of Cloud based platforms to support data pipelines for IoT data, AI paradigms such as Fuzzy Logic, and statistical models such as Logistic Regression
- Collaborate with Project Managers in an Agile Scrum or Kanban work environment to support write user stories, run weekly status reports, groom backlogs, sprint planning, retrospective, WIP visual boards (on JIRA, Excel)
TECHNICAL SKILLS:
Programming and Languages: Java, C, C++, Visual Basic, R, HTML, CSS, XML
Database skills: SQL Server, SSIS, Oracle DB, MS Access, SQLite, PostgreSQL, T-SQL, PL/SQL, Cloudera, NoSQL
Software tools: IntelliJ Android Studio, MS Project, MS Visio, RapidMiner, MS Visual Studio, Power BI
Data Governance: Informatica MDM, Informatica Enterprise Data Catalog, Spectrum Enterprise Designer, Erwin Data Modeler
Other skills: Data Structures, Testing, Data Quality Analysis, Data Modelling, ETL, Business Analysis, Agile Scrum Practitioner
Domain/Industry Knowledge: FDA s regulatory drug system, Telecommunication, Transportation
WORK EXPERIENCE:
MDM Systems and Data Analyst
Confidential, Silver Springs, MD
Responsibilities:
- Analyzed CDER (Center for Drug Evaluation and Research) systems to determine data lineage, data quality, and business rules by mapping data attributes, evaluating data dictionaries and identifying relationships between FDA drug application forms and existing data models
- Supported system integration design for current MDM implementation by developing data profiling and data dictionary reports on conventional CDER applications such as Orange Book, Orphan Drug Designation, and Exclusivity
- Performed data extraction, data cleansing, and data standardization using SQL for relational databases using TOAD Database Developer, MS Access, and Informatica MDM
- Leveraged attribute level, table level, and data model level data profiling to gather data patterns, data, relationships, attribute definitions, and find data anomalies in CDER’s internal source systems
- Orchestrated Data Quality tasks such as data cleansing, data standardization using Informatica Data Quality and Informatica Multi-Domain MDM, and support enriching existing database structures to increase performance and data accuracy
- Diagnosed physical and logical data model gaps by validating entity attributes, cardinality notations, data types, and data model designs for multiple CDER systems
- Created statistical MDM analysis reports by collaborating with SMEs, Data Architects, and Program Managers and perform functions such as Data Cleanup, MDM health checkup using industry-based best data governance practices
- Delivered data quality reports to SMEs, address master data requests, lead MDM operations from data ingestion to data provisioning, and continuously improve data standards and data dictionaries to support Data Governance objectives
- Collaborated with the supporting teams and Project Manager to identify and manage tasks, define User Stories in an Agile SCRUM environment
Informatica MDM Consultant
Confidential, Erlanger, KY
Responsibilities:
- Profiled Supplier and Item data; providing expertise to interface SAP S/4HANA with Informatica MDM platform
- Analyzed data from conventional DRM/cross- dataset and master data from the party(supplier and customer) to build a lookup cross- platform
- Orchestrated development of new SAP S/4 interface architecture to support backward-compatible feature for existing Informatica MDM inbound platform, supporting the project compliance guidelines for interfaces
- Developed data quality rules by analyzing new inbound source systems, existing inbound systems, and creating data; create one-to-one mapping codes from SAP S4 to/from Informatica MDM
- Supported system integration, API mapping, system decommissioning
- Developed data mappings, data load routines extending towards ETL/ELT integrations
MDM Business Data Analyst
Confidential, Ashburn, VA
Responsibilities:
- Performed data analysis and data profiling using MDM related attributes, business glossary enrichment, and business requirement gathering for the Customer Address Data Consolidation and Data Enrichment MDM project
- Demonstrated Informatica MDM proof of concept - creating Base Objects for Customer Addresses, Match Rules, User Exits, Match and Merge, and analyzing APIs, interface-related requirements, and enterprise data security policies
- Generated Data Cleansing and Data Standardization rules; facilitating developers with sample datasets, Data Dictionaries and ETL Mapping reports to improve Data Quality in the pre-staging level
- Liaised between the Data Stewardship team and the Data Custodians to map requirements on data quality issues in the existing Geospatial databases and customer's non-geo address data
- Analyzed source data attributes, entity-relationships, and contributing towards data governance framework for 10+ internal and third-party cloud-based PostgreSQL databases such as Pitney Bowes, CoreLogic, Building Footprint, Infogroup, 5G, etc.
- Orchestrated project requirements, Match and Merge rules, Interface Specifications, analyzed data quality tools and services, and helped in designing data models
- Analyzed output from address standardizer - Spectrum Enterprise Designer; configured the tool accordingly to collect attributes corresponding to MDM Data Model requirements and production level compatibility
- Created Data Mapping rules and business logic for MDM Staging Tables (for golden records) and contributed towards Attribute Survivorship logic for Match and Merge operations
- Collaborated with Project Management teams and Tech Leads to identify and manage tasks, define User Stories in an Agile environment using JIRA platform
Master Data Management (MDM) Consultant
Confidential, Atlanta, GA )
Responsibilities:
- Collaborating with analysts and Senior MDM Consultants to analyze various business data models such as customer party, product, location models in Informatica MDM
- Performing strong understanding of business constraints, resource requirements, source system analysis
- Installed and configured Informatica MDM Hub server, JBOSS application server and database server on Windows platform; verified using Product Availability Matrix(PAM) documentation
- Designed and configured Schema, Base Objects, Staging tables, Landing Tables, Entity-key relationships, Lookup tables
- Validated associated business rules, mappings, and configurations to derive consolidated data
- Performed a strong understanding of data governance tools such as IDQ for data profiling, creating score cards, creating tables and documenting Data Quality metrics
- Exercised Enterprise Data Catalog (IDC/EDC) for enriching business data glossary using Data Lineage, Object Relationships, and EDC configuration and administration in a big data environment such as Hadoop/HDFS, YARN, and strong understanding of NoSQL databases
Systems Analyst (Volunteer)
Confidential
Responsibilities:
- Audited IT infrastructure, software licenses, storage management, organization’s financial capacity
- Implemented a secured Network Storage System and restored data from conventional storage devices
- Performed updates, back-up, and re-configuration of Windows and Mac systems for faster access and better availability
- Restructured IT operations and trained employees to use best practices; improved performance by 50%
- Redesigned computer lab for the children based on organizational policies; set up parental controls and user accessibility
Classroom and Lab IT Assistant
Confidential
Responsibilities:
- Troubleshot operating system configurations, computer hardware, and network connectivity problems and provided technical support to over 100 students and staff throughout the University campus
- Designed solutions by analyzing requirements, department budget; constructed workflow charts, maps, and system diagrams; verified specifications and recommended improvements
- Implemented best practices, built reports and security policies for the management team and lab users
- Trained students and staff for improving their productivity in using the Learning Management System (LMS)
Product Analyst
Confidential
Responsibilities:
- Consulted web solutions to the customers by closely analyzing requirements, business processes, and future scope
- Translate customer requirements into business requirement documentation, and developed use cases
- Developed project plans for the web development, SEO, and e-commerce solutions
- Monitored and analyzed product sales to identify business opportunities
- Performed SWOT analysis, assessed risks, and developed approaches for improving sales
- Reduced product delivery times by 30% through streamlining processes and merging departments for better collaboration
- Project: Improve Public Transit Routes using City Bus GPS system, and Pedometer Tracking App for City of Manchester
- Performed detailed research on public transport system, current users, and refugee settlement program in New Hampshire
- Developed an Android app using Google Maps APIs to provide navigation in the finding nearest public buses to users
- Implemented a pedometer tracking functionality using the Android’s Sensor Management to find details of the user’s step counts
- Designed SQL queries to collect application data and maintain data integrity; tested using SQLite and DB Browser
- Visualized App data, Lat/Long coordinates to help in designing better bus routes, availability and improve public safety
- Performed unit and integration testing on Android devices with API 27 and above
- : Received first prize at SNHU’s ‘STEM-o-vation’ event
- Defined success metrics, data sources and records to predict chances of second heart attack among heart patients
- Performed ETL and Data Visualization using RapidMiner tool to cleanse data
- Configured and applied Logistic Regression in RapidMiner; analyzed results, graphs, and confidence levels
- Determined the vulnerability of patients who might suffer from a second heart attack and help the insurance company to plan health-improvement programs for targeted patients
- Designed a relational database model for overcoming the challenges of traditional bookkeeping for a Vinyl store
- Addressed customer requirements related to tracking financial and inventory management of the Vinyl store
- Translated customer requirements, dependencies and objectives into business rules and business constraints; performed Work Breakdown Structure(WBS) analysis, analyzed project scope, timeline, and associated costs
- Developed data models such as entity-relationships, conceptual, enterprise, physical and logical diagrams in MS Visio
- Normalized tables in 3NF, ensured database performance tuning by testing SQL queries for redundancy in SQL Server
- Planned policies to manage upgrades, backup, and recovery