Rahul Soni
Jaipur, Rajasthan, India
(Mobile) : +91-787*-***-***/ 902*-***-***
(Email) : ***********@*****.***
Objective:
* ***** ** ** ********** (including 6 months of internship) in the field of Data Analysis, Data Warehousing and Requirement Negotiation areas. Expertise in multiple tools which gives the better perspective for suggesting practical solutions. Finding an environment where I can be challenged in day to day activities where I can utilize my advance skills and to grow them. Experience Summary:
• Around 4.5 years of experience in the area of data warehousing, data consistency, implementation of MDM and selection of specifications.
• Informatica Data Quality Exposure in all projects for Data Analysis using certain aspects of tools such as profiler and other mapping components for creating governance and cleansing rules for the import.
• Work with Solution Architect on data model creation, MDM data analysis and MDM application solution tracking.
• Lead a team of 5 people for development.
• Design Web-UI using Informatica IDD and Downstream using SQL-Sever script for batch processing.
• Analyzed complex structures and data sources for the integration and given practical solution.
• Understanding of the documents for Requirement specification and Design Specific.
• Developed a SOAP/REST web-service for customization for Microsoft Profisee for real-time integration. Certification & Internship:
• Certified from Informatica Integration Cloud Services.
• Certified from STIBO CMDM.
• Received twice Pat-on-the-back (Organizational level recognition) for two ventures and got customer appreciations.
• Certified Microsoft Profisee Master Data Maestro Administrator, Developer and Advance.
• C#.net certificate from SEED Infotech Ltd.
• Internship at Mr. P. Mediaworks with building C# application for 6 Month in C#.net. Skills & Abilities
Programming Languages C#.Net
WCF(REST/SOAP)
JavaScript
Operating System Windows
Tools (ETL, Data Quality, MDM) STIBO 9.3
Informatica Power Center Client 9.6.1 HF3
Informatica Data Quality 9.x, 10.4
Informatica MDM 9.5.1, 10.1 & 10.4HF1
Microsoft Profisee 6.3
Talend Data Integration Open.
Database SQL
MYSQL
Oracle
SQL Server
Data Modeling, Data Analysis & Requirement Negotiation. Education
Master of Computer Applications April 2016
Sinhgad Institute of Business Administration and Research (SIBAR), PUNE
• Percentage: 69%
• University: Savitribai Phule Pune University
Bachelor of Computer Applications April 2013
University of Commerce College, Jaipur
• Percentage: 68%
• University: Rajasthan University
Higher School Secondary Certificate MARCH 2010
D.A.V. Public School, Jaipur
• Percentage: 67.4%
• Board: CBSE
Secondary School Certificate MARCH 2008
Army School, Jaipur Cantt, Jaipur
• Percentage: 63.4%
• Board: CBSE
Professional Experience
Senior Data Engineer LTI 2016 August till 2021 January Oct’20—Dec’ 20
Project: MyLan Master Data Management
Client MyLan
Environment: Informatica MDM, Informatica Data Quality, Oracle, SFDC Role: Lead, Developer, Requirement Negotiation with Client. Brief description of the Project and Company:
Mylan N.V. is a global generic and specialty pharmaceuticals company domiciled in the Netherlands, with principle executive office at various other places. About the project, PIM MDM Architecture, it is an enhancement requirement where MyLan wants to add more source systems to the previous built MDM Architecture, by enhancing certain functionality for the previous built as well, Certain Loads are getting done via Informatica Data Quality and PowerCenter as well. New downstream functionality and certain MDM UI’s are built for the Data Stewards to carry out governance activities.
Jan’19—Sept’ 20 date
Project: Nets Master Data Management
Client Nets
Environment: STIBO, Oracle, SFDC
Role: Lead, Developer, Requirement Negotiation with Client. Brief description of the Project and Company:
Nets are among the top payment processors in Europe, focus on making it even easier and more intuitive for their customers to handle digital payments and related services. About the project, it was based on their one type of business channel Merchant Services which we repeated with many factors and also they were not having the legal proper hierarchy, so the main requirement from the client was to make the hierarchy in the legal way how it is been legally registered, some of the requirement was for the reports like what they have populated in the sources which are contradicting to the other source systems.
Sept’18—Dec’18
Project: Johnson & Johnson APAC MDM
Client Johnson & Johnson
Environment: Informatica MDM, Informatica Data Quality, Informatica PowerCenter, Oracle Role: Developer
Brief description of the Project and Company:
Johnson & Johnson is the foundation around more than 130 years of vibrant lives, thriving communities and forward progress. They have aimed to keep people well at every age and every stage of life. About the project, it was based on the Asia-Pacific region of their Business, we had to build the Hierarchy and the downstream for all the records once a week in the batch process. We were building some data quality rule and integration for loading the source data into MDM. There we utilized the IDD and the provisioning tool for building 6level hierarchy as IDD can only hold till 3 Level of Hierarchy. Sept’17—Sept'18
Project: OKQ8 Profisee MDM
Client OKQ8
Environment: SSIS, Microsoft Profisee Master Data Maestro, C#.net, SQL Server Role: MDM Developer, C# WCF Developer, Requirement Negotiation with Client Brief description of the Project and Company:
OKQ8 Scandinavia is one of the largest oil companies in Scandinavia with gross revenue of more than 30 billion DKK. It runs 243 service stations across Denmark and more than 700 service stations in Sweden. About the project, We have to integrate their legacy systems to MDM with using Batch process build by ETL using SSIS, and then the Real-time was with a SOAP web-services which was taking the data from the Biztalk tool which was sending the data in the XML format for all the source systems and the web-service was handling all the rules for data quality and rejects with the records. All the source systems were integrated real- time with the same WCF.
Personal Information:
Father’s Name : Mr. Anant Soni
Mother’s Name : Mrs. Chandrakanta Soni
Language : Hindi & English
Origin : Indian
Marital Status : Single
Date: 7th Jan. 2021
Place: Jaipur Rahul Soni