The Sime Darby industrial Group head quartered in KL Malaysia, Different domain data like oil, agricultural ,sales,marking,services , logistics, banking and finance holding into single Microsoft Ax dynamics tool., We set out on this journey fully aware that this is a complex challenge involving thousands of producers, and hundreds of thousands of small and big holders ,The main aim of the project is to track various business patterns can be analyzed using the different business dimensions Like Vendor, breach,The Different type of system is divided into single transformation process has been successful and we look forward to future opportunities to deliver similar state of the art projects within the sector.

The Sime Darby industrial Group head quartered in KL Malaysia, Different domain data like oil, agricultural ,sales,marking,services , logistics, banking and finance holding into single Microsoft Ax dynamics tool., We set out on this journey fully aware that this is a complex challenge involving thousands of producers, and hundreds of thousands of small and big holders ,The main aim of the project is to track various business patterns can be analyzed using the different business dimensions Like Vendor, breach,The Different type of system is divided into single transformation process has been successful and we look forward to future opportunities to deliver similar state of the art projects within the sector.

Responsibilities:

• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, control flow and Data Flow Task
• Providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages and deployment, configuration, manifest

• The multiple Ax Dynamics from data pull into sql database tables to daily mid night refresh data. Based on user requirement generate the SSRS and Power BI reports, dashboad and visualizations format its place into handing Power BI server and SSRS reporting server
• Create the SP based on user/customer requirement Load the data into temp table and separate table into Database then generate the reports
• Using sql script and SSAS cube data to create Power BI dashboard for different department and vendor, branch
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of the team
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per rules and the requirements of the end users.
• For different transformations like dataflow and control flow use and data conversion into destination

An integrated HR system called Workday is developed from the existing disparate systems and entire archive is archived and imported to Hadoop system using SSIS from the different sources (SQL, Flat files). It comprises HR modules like Payroll, Time and Attendance, Talent Acquisition and other benefits and Compensation of employees belonging to M&T bank. Based on requirement and limitations , developed a separate user presentation layer named Single-Instance-Lookup supplied by the specific application modules of interest to loop up the archival data for Legal and Business reporting , Routine employee data look up accessed by M&T AD Groups only. The Data access layer is configured with Hadoop system to retrieve the report data from Hadoop hive Views.

Responsibilities:

• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, control flow and Data Flow Task
• Providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages and deployment ,configuration, manifest

• The Archival multiple database tables to generate the TXT format its place into handing server then store the HDFS hadoop and unit testing and create the Views base on SIL requirement.
• In the hadoop based on txt file create metadata and Load the data into HRSD Database.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2016.\
• Based on user requirement generate the SSRS and Power BI reports,dashboad and visualizations format its place into handing Power BI server and SSRS reporting server.

This project provides ability to BOS NAM management to analyse Profit and Loss information across different dimensions of the SBU like ProfitCenter, CostCenter, WBS, Vendor, Vendor PO and Headcount related information by CostCenter. The overall effort of this project is to replace the manual entries and adjustments to calculate different type of costs and revenue across different dimensions and to replace the traditional reporting from files to reporting analytics using a single data warehouse. The manual adjustments have been replaced with automation through coding and user input forms to update the PNL data

Responsibilities:

• Used transformations like derived column, conditional split, aggregate, lookup, sort, merge join, union all, merge, data conversion to load data into data marts.

Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server reporting features such as drilldowns, drill through, sub-reports, navigation reports,(Hyperlink),Spotfire,Qlikview, Tableau reporting data visualization.

• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and Data Flow Task

The Hanover Insurance Group, Inc. headquartered in Worcester, USA is the holding company for a group of insurers that includes Worcesters Citizens Insurance Company of America, based in Howell, Michigan, Chaucer Holdings plc, London and their affiliates. The main aim of the project is to track various business patterns can be analyzed using the different business dimensions like Date, Time, Provider, encounter, Diagnosis, procedure, Medication and Order results and to find Various Premiums, Claim paid to the policyholder, Commission paid to the Agents and premium received from the policyholder. The entire system is divided into four modules as Chairman, Branch Manager, Agent and Customer. Chairman defines policies and Manager calculates policy amounts. Agent registers the policies and there by transformation process has been successful and we look forward to future opportunities to deliver similar state of the art projects within the insurance sector.

The Design Report Specification (DRS) is used for defining the requirements for a of Atos Service ? from an external point of view. It describes, based on the defined requirements delivery and the provision of reports via the defined and agreed interfaces. Based on the selected data, the point of view could be service-specific, product-specific or cross-service. This project provides the complete information Bos NAM of incidents,changes and problems etc., opened daily in multiple ticketing systems SDM12, USD6, Clarify and PPM. Provides the flexibility to tower heads, to analyse the number of incidents and changes opened against customers and analyst group managers, to monitor and alert the group mangers to get resolve the tickets created in the systems within SLA. The Raw data for this report is being captured from multiple ticketing systems SDM12, USD6, Clarify and PPM. The information of table names is described in chapter 4 Data Sources and logic to extract, transform and load is described in Database.

The Business domain in these projects is banking which deals with Giving the loans and auto Finance. Any Bank before giving the loan needs the information about the customer or business organization to which it is giving the loan. This bank deals with two kinds of customers-individual customers and business customers. For individual customers it needs the customers name, its DOB, address details, contact details etc. For ? business customers it needs the organization name, address details, contact details etc. There can be many address types like legal addresses, trading addresses and mailing addresses. Also there can be many contact types like home phone, work phone, email addresses. we need to store the different address and contact types. The Bank also needs the suppression details like types of suppression, which customer has what suppression etc. It has also needs to history of data and history of changes made to the data. The present system does not provide the functionality to duplicates and the groups associated with the customers, does not maintain the diff types of address and contact information and do not reduce customer, eliminates the duplicates, maintains the different types of customer addresses and contact information, reduces the maintenance cost and stores the historical information.

The ANV Insurance Group, The main aim of the project is to track various business patterns. Import Export data using ETL transformation.(different type of databases,sqlserver,oracle,mysql,DB2,Excel file ,Flat file, unit testing, writing sql script) Different type of Reports, Matrix, parameter, subreport, drilldown, drill through Report. Unit testing ,Writing Script