- First Name: Mohamed
- Last Name: Wasil M
- City: Dubai
- Country: United Arab Emirates
- Phone No: +971565855701
- Education: B.Tech - Information Technology
- Field of Study: Information Technology and Communications
- College or University: Anna University
- Time Period: 2014
- Job Title: Software Developer ( ERP / Data Warehousing - ETL / Oracle / BI Reporting )
- Listed: August 30, 2015 3:25 am
- Expires: This ad has expired
PROJECT 1 : April’2014 – June’2015
TITTLE : EDW Systems
CLIENT : Tries Cities Financial
ROLE : ETL - Application Developer.
ENVIRONMENT : Oracle10g, Informatica 8.6.1, Qlikview Reporting 11.0, WindowsXP
It is providing to customers with a comprehensive range of financial Products and services, including Commercial and Retail Banking, Credit Card Services, Electronic Banking, Trust and Asset Management, Brokerage and Insurance Services, Consumer Durable Loans, etc. This system is required to extract, transform, and load data from the different client system into a relational table environment that can be accessible for reporting purposes. A set of reports will be developed against the relational tables to deliver the information to its customers in the form of PDF files.
Roles & Responsibilities:
Involved in complete SDLC from Extraction, Transformation and Loading of data using Informatica.
Extracted data from flat files and oracle database, applied business logic.
Used transformations like Aggregator, Filter, Router, Sequence Generator, look up, Expression, update strategy and rank transformation extensively.
Developed mappings to load the data in slowly changing dimension and Actively involved in tuning the mappings for better performance.
Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions and Workflows and Involved in unit testing of the mappings.
PROJECT 2 : July’2014 – December’2014
CLIENT : Peoplesoft Applicaton Development
ROLE : ERP Application Developer.
ENVIRONMENT : People Tools 8.53 & 8.54, Web logic, Microsoft SQL Server 2008
This systems support HR capabilities and processes that are efficient and scalable and are designed from the ground up to handle global challenges, such as local regulations, local reporting requirements and multiple languages and currencies. They also generate global workforce data that is accurate and consistent, enabling business leaders to make better, timelier decisions.
Roles & Responsibilities
Worked on Technical Requirements and Business Requirements Documents with the Customer to understand the scenario
PeopleSoft Installation and Small development process and Creates a Report in BI Publisher & SQR report.
Testing the Functional Modules and Managing logins, Roles, Assigning rights and Permission.
This is M.Mohamed Wasil, Dubai, United Arab Emirates.
Contact No : +971 56 585 5701
I have done my B.Tech., Information Technology in Anna University, Chennai. 2014 Passed out.
Worked as a Software Engineer in Majestosys Technology Solutions India Pvt. Ltd., For 1 year 2 Months.
Worked as a Software Engineer in Freelancer Online Solutions , For 6 Months.
Handling the Functionalities like Database Analyst, Database Administration, Data Warehousing ETL Developer, Business Intelligence Reporting, BI Analyst, Java, C & C++, VB Programming, SQL Server 2008, Application Developer, Software Developer, ERP Developer – Oracle Peoplesoft.
Having 1 Year and 2 Months of experience in Datawarehousing Technology using Informatica Power centre 9.1 and Qlikview Reporting 11.0.
Having Six months of experience in PeopleSoft 8.53 PeopleTools Technology using PeopleTools 8.53 and 8.54.
Extensively worked on Designer, Workflow Manager and Workflow Monitor using Informatica and Generate the Reports using Business Intelligence Reporting..
Having experience in Design & Implementation of ETL processes, Transformation, mappings and loading using Informatica Power center 9.x/8.x, Oracle 11g.
Extensive experience in creation of ETL mappings and Transformation to reflect business rules using Informatica Power Center to move data from multiple sources into target area.
Most of the transformations were used like the Source qualifier, Update strategy, joiner, lookup, Filter and Sequence generator.
Good Knowledge on Data warehousing techniques using different Data Warehouse Schemas, SCD Dimensions and Fact tables etc.
I Know some Technical Languages, Oracle based functions and Peoplesoft Technologies. I have done data warehousing ETL Tool(Informatica 9.0) and Qlikview BI tool.