- 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 31, 2015 5:52 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 6 Months.
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.
As you can see, I have had extensive vacation work experience in office environments, the banking sector and service industries, giving me varied skills and the ability to work with many different types of people. I believe I could fit easily into your team.
I am a conscientious person who works hard and pays attention to detail. I’m flexible, quick to pick up new skills and eager to learn from others. I also have lots of ideas and enthusiasm. I’m keen to work for a company with a great reputation and high profile.
BANKING PROJECT Description :
Tri Cities Financial is a multi-billion dollar, multi-state Financial Services company Headquartered in Evansville, Indiana. As the largest Independent banking company Based in Indiana, 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.
This company involved in amounts for various purposes like Personal Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc. The company requires different level of analysis regarding loan amount, type of customers’ type of payment schedules, interest rates, defaulters list and the penal interest calculations, etc. The data warehouse, basically it is a Data Mart as it covers only one domain of the business and captures data from their Historical Database.
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. The data from the different systems will be extracted into a set of text-based and Graphical reports.