Yogesh Mahajan
About Yogesh Mahajan
Having an experience of over 20 years in IT and consulting, working on various transformation projects and technologies. My main areas of expertise are – Solution consulting and implementation for Master Data Management (MDM) and data quality (DQ) – • Data Modelling (Entities and relationships) • Data Validation, Data Matching , De-duplication, Data Enrichment • Data Stewardship (Business and technical) • Designing and implementing data quality rules and metrics • Designing and implementing data workflows for data authoring • Designing master and reference data family • Geographical and time zone referential • B2C ( Site, Product) and B2B ( Suppliers ) **Tools – Semarchy 5.2 and Informatica Data Quality Defining Data Architecture for OLTP, Data ware house, and data hub • Defining Data Dictionary • Designing Conceptual, Logical, Physical and Canonical Database Design • Database Performance Tuning • SQL and PL/SQL tuning **Databases : Oracle 8/8i/9i/10g/11g/12c **Tools : Erwin , Power Designer , Enterprise Architect Solution consulting and implementation for ERP to ERP data migration • Defining Source to Target Data Mapping • Designing Operational database • Profiling Source Data Quality • Designing data quality rules and transformation **ERP Systems : Peoplesoft, MS Dynamics Business Analysis • Elicitation, Requirement Management and Communication • Requirement Analysis, Fit-Gap analysis, Brainstorming and stakeholder meet • UML Designing, use case diagrams, activity diagrams, scope modelling etc. • Specification writing ( BRD, Functional Specification, Solution Proposals) • User Training ( Functional and Technical Users) Encompassing above, I specialize and have extensive experience in – • Data architecture, Database Design, Implementation, Reporting • Development Methodologies ( Waterfall and Agile) • Presales ( Capability Building, POC, Demo, Solution proposals, Response to RFP) • Management ( Project / Resources / Team) • Strong Domain Knowledge – Life Science, Retail, Finance