Profile Summary:

• An Oracle Certified Integration Expert/Data Analyst/Architect/Data Migration with around 15 plus years of experience in designing and implementing data migration/integration solutions for complex business needs. Involved in Data Architecture, Data Modeling, Data Profiling, Cloud Integration, and enhancement of products like Oracle Siebel CRM, SFDC CRM, Oracle OCH (MDM) and Microsoft Dynamics 365 CRM, Azure, AWS.
• Enrich experience in Telecom, Life Science (Health Care, Pharmaceutical) and Manufacturing industry into Sales - Marketing and Finance domain.
• Strong experience in Integration and around 250+ integration design from requirement gathering to implementation in current assignment with heterogeneous systems Cloud, Cloud CRM, Datalake, Oracle, and legacy systems.
• Excellent experience in Data Migration/ Designing/ Prototyping of Master Data Management (MDM) system considering CRUD process while using wireframe and process design concept. Very good hands on experience on tools like VISO, Figma. Handled hug volume (100 plus millions) of data for data migration and integration project. Design/Developed automation and reporting tool. Developed BRD and FSD documents for development team.
• Five plus years of work experience in agile projects. A certified Professional Scrum Master from scrum.org, Scrum Fundamentals Certified (SFC) from SCRUMstudy and certified in Agile with Atlassian Jira.
• Extensive experience in Oracle SQL/PLSQL, Informatica, D ata-Migration, Data Integration, Data re-assignment, Oracle Siebel IP19-EIM, OCH (Oracle Customer Hub)-EIM, MDM (Master Data Management), SFDC Securely Data Integration with SOP API and MuleSoft EBS, MS Dynamics 365 CRM integration and migration, Integration with Data warehouse/Data Lake/ERP/Cloud applications.
• Unix shell scripting for automated reporting with csv attachment and integration job scheduling.
• Adept Business/Functional knowledge and experience in Finance, Banking, Automotive Manufacturing, Health Care, Pharmaceutical, Telecom, Electronic Toll Collection (ETC). Managing requirements and expectations of stakeholders/clients which makes me a perfect candidate for Strategy Consulting, Product Selection and Architect/Data Designer/Integrator/Data Modeling in teh global change program.
• Currently in teh role of Data Integration Expert/Data Architect/Data Migration lead and involved in project management activities. Supporting release management activities.
• Data Migration expert with excellent design strategy for migrating bulk data. Migrated 100 million of data between heterogeneous environments as part of data migration project.
• Excellent problem-solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

Enterprise Application/ Environment: Oracle Siebel IP19 Cloud Solution- CRM, MS Dynamics 365 CRM, Microsoft Dynamics Great Plains-ERP, SDFC CRM, Unix Shell Scripting

Databases/Tools: Oracle SQL/PLSQL, SQL Server, MuleSoft EBS, Informatica MDM (Siperian)

Agile Tools: Jira Agile Board, RTC Agile Board, Remedy, ServiceNow, Confluence

Wireframes/Process Design Tool: VISO, Figma

Data Integration Tool: Oracle Data Integrator (ODI), Informatica PowerCenter, SFDC Dataloader

Mythology: Agile, CRUD

Cloud Integration: SFDC CRM, Azure, AWS

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Data Architect/Integration Lead

Responsibilities:

• Designed and implemented 250 plus complex integrations to load master data from heterogeneous systems like Data Lake, Data Wearhouse, Mainframe system.
• Responsible for creating data flow design considering CRUD and process design concept.
• Responsible for master data management (MDM) while designing integration (outbound and inbound).
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules. Working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
• Designing Reusable Transformations in Informatica such as Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Creation and maintenance of entity objects, hierarchies, entity types, relationship objects hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Merge properties and Batch Group creation.
• Designed and implemented integration to cloud systems like SFDC, Azure
• Design and develop complex business data quality reports with extract, transform and load technique. Same scheduled in UNIX shell programming for auto triggering.
• Established methods and procedures for tracking data quality, completeness, redundancy, and improvement within teh system. Define data standardizations, data enrichment operations, data validations, data security requirements, and data exception handling processes.
• Responsible for delivering artifacts, technical design documents and architectural diagrams that meet business requirements. Also designing data mapping documents for migration/integration of teh data from teh source systems to target systems as per teh business requirements.
• Define security and backup procedures, optimize new and current database systems. Define data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processes, improve system performance by conducting tests, troubleshooting and integrating new elements. Provide operational support for Management Information Systems (MIS), Release Management.
• Responsible for performing data profiling on a relational database and Data Governance of enterprise organization. Participating and conducting JAD (Joint Analysis Design/Development) sessions with technology & data engineering team to understand teh needs of teh customer.
• Liaise with global Business Users ensuring a clear understanding of project objectives and deliverables. Day to day interaction with project champions and other stakeholders, including product manager, quality assurance, technical support, software developers and globally-based program management and software development groups.
• Involved in requirement gathering, design/solution discussion, liaising with business-owner/end users and providing solutions for business requirements. Involved in Project Management activity as per Software Quality Assurance standards and AGILE methodologies.

Environment: Oracle 11g/12c PLSQL, Informatica 9.x, Unix Shell Script

Confidential

Data Migration Consultant (PL)- CRM

Responsibilities:

• Conduct data analysis activities and data prototypes against source systems to confirm data quality, prove concepts, determine if data is fit for purpose and inform accurate solution development.
• Responsible for data mapping for migration/integration and maintenance of teh data from teh source systems to target systems through SQL/PLSQL, Informatica and EIM process as per teh business requirements for upcoming enhancements and production issues.
• Understand teh business requirements and define teh data migration strategy for new implementation.
• Defining Siebel EIM process for data migration, configuring IFB files, writing PLSQL Block.
• Understanding teh Business requirements, drawing specifications and converting it into High Level Design and Technical Design Documents.
• Responsible for analyzing source system data and defining data migration process in order to load data into Siebel.

Confidential

Environment: Siebel UCM or OCH (8.1.1), Oracle SQL Developer, Oracle 11g PLSQL, Informatica MDM, Unix, Visio, Figma

Data Architect/Migration Lead

Responsibilities:

• Responsible for understanding teh business requirement and define/suggest teh Siebel EIM and UCM process for data migration, configuring IFB files, writing PLSQL Block and creating Informatica Workflows.
• Responsible for data migration activity considering CRUD mythology
• Responsible for whole data-migration activity as a data migration lead which includes migration through IIR server and synchronization between MDM and CRM application through AIA server.
• Understanding teh Business requirements, drawing specifications and converting it into High Level Designs documents as an essential communication document to other teams on teh project.
• Provide an essential communication document to other teams on teh Siebel project. Suggesting business process and system improvements that will optimize existing processes and improve business systems.

Confidential

Siebel EIM Consultant (TL)- CRM

Responsibilities:

• Conduct data analysis activities and data prototypes against source systems to confirm data quality, prove concepts, determine if data is fit for purpose and inform accurate solution development.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
• Merge properties and Batch Group creation.
• Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Responsible for data mapping for migration/integration and maintenance of teh data from teh source systems to target systems through SQL/PLSQL, Informatica and EIM process as per teh business requirements for upcoming enhancements and production issues.
• Responsible for creating FSD document, data-mapping sheet based on teh source data.
• Leading a team and involved in project management activities.
• Understanding teh Business requirements, drawing specifications and converting it into High Level Designs documents as an essential communication document to other teams on teh project.
• Provide an essential communication document to other teams on teh Siebel project. Suggesting business process and system improvements that will optimize existing processes and improve business systems.
• Creating Informatica mappings for data migration.

Confidential, USA

Project Lead

Responsibilities:

• Responsible for mapping teh business requirements to salesforce.com to define a scalable solution.
• Involved in creating mappings in Informatica for migrating data in SalesForce with Salesforce Transformations.
• Involved in inserting, updating deleting data with teh help of Apex Loader.
• Involved in fixing teh bugs while importing data into SFDC Application.
• Involved in Client Interaction.
• Guiding teh team members in resolving teh issues.
• Involved in creating Report Types, Reports and Dashboards.

Confidential, USA

Team Lead

Responsibilities:

• Involved in creating data mapping sheets in EIM.
• Involved in inserting, updating teh data into teh application.
• Responsible for entire data migration activities which includes MDM (Master Data Management).
• Involved in fixing teh bugs while importing data into teh application.
• Involved in writing SQL/PLSQL procedures, cursors for handling teh complex issues.
• Involved in Client Interaction.
• Guiding teh team members in resolving teh issues.
• Involved in teh design of teh application and creating teh Objects, Record Types, Validation Rules, Workflows and Approval Process.