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