• Extract the Data from Teradata EDW system to SQL Server/Teradata staging database and Application Project view
• Creating Packages on SSIS by using different data Transformations like Derived Column, Conditional Split and Execute SQL Task in Dataflow level to load data into data warehouse.
• Scheduling Jobs to execute SSIS packages using SQL SERVER AGENT.
• Involved in Incremental loading.
• Involved in Error Handling using Event Handlers, Progress Tab & Logging.
• Implemented Breakpoints and Checkpoints.
• Involved in Cube, Dimensions & Partitions processing.
• Involved in Cube, Dimensions, Aggregations, and Partitions creation using SSAS.
• Debugging the CUBE solution for issues reported by the business.
• Managing Security (Creating users, logins and roles, granting permissions).
• Daily Log checking for errors on Production Server.
• Monitoring free space of database.
• Monitoring Database performance and optimizing performance.
• Monitoring the Performance of the servers.
• Implemented automated mailing to notify long running user queries on servers.

• Total experience 4 years.
• Having around 3 years of experience in Microsoft Business Intelligence (SSIS, SSAS, SSRS) Development & Maintenance data warehouse assignments.
• Having around 1 year of experience in Microsoft Power BI and DAX query .
• Having around 3 years of experience in Microsoft SQL server Management Studio (SSMS).
• Designed and Developed the SSIS Packages by using different data transformations to Load data into DB tables(truncate load and incremental load).
• Having good experience in data warehouse(DW) and data mart(DM) development .
• Good Experience with Package Configurations, Error Handling.
• Involved in Package Deployment for moving package to Production Server.
• Having good experience in Package Scheduling Using SQL SERVER AGENT.
• Good experienced in Creating Cubes, Partitions, Aggregations and Usage Based Optimization in SSAS.
• Experience in creating SQL Logins, Roles as a part of security policies for various categories of users.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages.
• Knowledge in creation of SSRS reports like Parameterized Reports, Sub-reports, Cascading report etc.
• Having around 1 years of Experience in JAVA Operational Service.
• Strong ability to understand new concepts and applications.

AP Moller Maersk Group has activities in a variety of business sectors, primarily within the transport and energy sectors. It has been the largest container ship operator and supply vessel operator in the world since 1996. As of September 2016, the company is in the process of splitting its shipping and energy interests into separate divisions. Maersk uses SAP and Oracle as data source. From this various data source data comes into Teradata database through informatica. Teradata is responsible for delivering the data to MSBI from source systems. Our team responsible for picks the data from Teradata layer to application staging database (Project View), from Teradata project view layer data will flow to CUBE. Business uses Excel reports/SSRS to view the data.