Data & Services Engineer, Mdm Consultant Resume
PROFESSIONAL SUMMARY:
Detail - oriented with 11 years of experience of high quality technical and functional experience providing Multi Domain Master Data Management (MDM) solutions, Data Analysis, Data Quality, Data Modeling, Data Migration, System Support and configuration. Subject Matter Expertise in designing and building Master Data management solutions using Informatica MDM product suite and Amazon cloud services. Collaborative, creative and critical thinking team player with strong interpersonal and leadership skills. Experience working with agile methodologies and cross-function teams in Telecommunications, Consulting, Healthcare, Insurance and Retail domains.
AREAS OF EXPERTISE:
- Informatica MDM 9.x, 10.x - MDM Hub, IDD
- Informatica Data Quality (IDQ)
- Relational Database - Oracle, MySQL, Amazon RDS
- Non-Relational Database - Cassandra
- Strong PL/SQL programming skills
- Unix Shell Scripting
- MDM solutions on Amazon Cloud using Elastic Beanstalk, EC2, Route 53, S3, Certificate Management, ELB, Lambda
- Datadog and Tableau dashboard reporting
- Control-M Scheduler
- Data Profiling, Data Quality Analysis
- Data Modeling
- Data security and Data Governance
- Process Design and Implementation
- Full life cycle development
- Functional and Technical Documentation
- Interpersonal Skills
- Strong technical, functional, Result - Oriented and Problem-solving skills.
- Agile Methodologies, Sprint Planning and Backlog Refinement.
PROFESSIONAL EXPERIENCE:
Data & Services Engineer, MDM Consultant
Confidential
Responsibilities:
- Work closely with cross functional teams for Requirement gathering and Analysis.
- Identify process inefficiencies and implement process improvements to save time and manual intervention.
- Drive Data mapping and implementations with internal and external owners and Vendor Data for multiple acquisitions and internal consolidations.
- Develop connected Data quality reports for Vendor MDM Business Users.
- Sprint Planning and efficiently breaking the epics to features, sprint level user story and backlog Grooming.
- Functional and Technical Documentation.
- Created User friendly How-To Documentation for business users on IDD and external Vendor Data Search UI.
- Manage on-prem Unix servers and Informatica MDM infrastructure
- Design and develop Business rules, data model in Informatica MDM and IDD.
- Implemented Data Migration strategy from on-prem Oracle Database to AWS Cloud Aurora Database using Unix shell scripting and Java programming
- Design and create data model for RDS Aurora MySQL.
- Experience with implementing MDM solution using Amazon Cloud infrastructure including Elastic Beanstalk, Route 53, S3 Certificate Management, ELB, Cloud watch.
- Responsible for creating and managing multi node Cassandra cluster
- SQL performance tuning for handling large data volumes.
- Creating and maintaining Control-M jobs for batch loads.
- Datadog dashboard for application services.
MDM Consultant
Confidential
Responsibilities:
- Identify process inefficiencies and implement process improvements to save time and manual intervention.
- Develop connected Data extracts for Org MDM Business Users using Oracle PL/SQL.
- Define and Implement Data security and Data steward rules in Informatica MDM.
- Manage Soap Services for Org Data.
- Functional and Technical Documentation.
Data Analyst, Technical Lead and Sr.Developer
Confidential
Responsibilities:
- Requirement analysis and mapping the requirement to technical implementation.
- Lead team of 6 with technical solutions and day-to-day task assignment, status reports to customer.
- Gap analysis between requirements and functional design.
- Performed Data quality analysis on source data to identify data issues, data patterns.
- Created profiles, join profiles, applets, rules, scoreboards, reference tables using Informatica developer and analyst for data profiling and data analysis.
- Created ETL transformations, mappings, workflows for loading data into MDM landing and staging tables.
- Build MDM Hub schema objects, match merge configurations, custom validation rules Data steward role and groups in MDM Hub.
- Create match rules, hierarchy configurations to build data model relationships.
- Build hard delete detection to identify hard deleted data at source
- Build IDD application with custom charts, dashboard, task workflows as per business rules,
- Used ActiveVOS to build custom IDD task workflows in Informatica MDM 10.1.
- Primary responsibility to handle production data load issues and performing root cause analysis.
Senior Developer
Confidential
Responsibilities:
- Requirement analysis and mapping the requirement to technical implementation.
- Developing Tibco adapter and BW services.
- Building xpath to integrate incoming data to target output data based on implementation patterns.
- Unit Test Plan preparation and Unit testing
- Code deployment in TIBCO Administrator and Implementation support.
Team Lead, Designer, Sr Developer
Confidential
Responsibilities:
- Offshore Team lead handling development and implementation support deliverables.
- Requirements analysis
- Preparing detailed technical level design.
- HUB developer - creating schema objects, match rules and trust configuration, notification services.
- Test cases creation, testing, post-implementation, enhancement and maintenance support
- Configuration controller
Developer - MDM Implementation & Maintenance
Confidential
Responsibilities:
- Implementation - Schema design and configuration Match and Merge strategy. Trust and Business Validation rules, Schema integration.
- Code migration
- Unit testing and post implementation support
- Configuration Controller
Developer
Confidential
Responsibilities:
- Process Manager Developer.
- Unit testing and integration testing
- Code migration
