Marichamy Muthiahpandian Email: adck0s@r.postjobfree.com

Phone: +91-953*******

PROFESSIONAL SUMMARY:

Over all 12 years of IT experience in delivering end to end Business Intelligence reporting solutions and Data Warehousing.

2+ Years of experience in Tableau

3 Years of experience in Power BI

edXMicrosft Certified in Analyzing and Visualizing Data with Power BI

https://courses.edx.org/certificates/07cd013a298941e3ab47d390275c7ba1

IBM certified Designer Cognos 10 BI Reports

Hands on experience on Tableau 2009.2 Desktop

Expert in designing and developing dashboards in Power BI and modelling data required for dashboard using Power query.

Expert in configuring on On-Premises Data Gateway for Power BI on Windows Server 2012 R2.

Expert in writing complex Analytic DAX expressions in Power BI, Tabular and Power Pivot.

Expertise in designing and developing Relational and Multi-Dimensional models (OLAP) in Framework Manager and authoring reports from all types of Dimensions.

Expertise in Cognos BI 7/8.4/10.1/10.2/10.2.2, Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio, Event Studio, Active reports and MSBI (SSIS, SSAS, SSRS), Power BI and Tableau.

Strong in Data warehousing concepts, Dimensional Star Schema and Snowflake Schema methodologies and proficient in understanding business processes / requirements and translating them into technical specifications.

Well versed in all phases of BI project including Planning, Estimation, Solution, Requirement gathering, Design, Development, Enhancement, Testing and Maintenance activities.

Strong experience in databases like Oracle 11g/10g, Db2, SQL Server and expertise in writing SQL queries for validating the data.

Ability to meet the deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Keen analytical skills with great attention to details, evaluating projects, reviewing data flow, data validation, problem identification and resolution.

Highly organized mentor, able to quickly assess needs and provide tools to resolve difficulties enhance learning and improve performance.

Trained and Proof-of-concepts work experience in other BI tools and technologies (Intelliprint Dashboard Reporting and SAP Business Objects)

TECHNICAL EXPERIENCE:

Reporting tools:

Tableau,Power BI (Power Pivot, Power View, Power BI Desktop ),Cognos 10.2.2/10.2/10.1.1/8.4/ 7.3, Framework Manager 10.2.2/10.1.1, Report Studio, Query Studio, Transformer, Powerplay 10.2.1, Business Objects 6.5, MSBI (SSIS, SSAS, SSRS) and Intelliprint Dashboard.

ETL tools:

SQL Server Integration Services (SSIS).

Databases:

Teradata, DB2, Oracle10g/9i/8i, SQL Server 2012.

Programming Skills:

VC++, C++, COBOL, Pascal. Visual basic 6.0.

Operating Systems:

Windows XP/NT/2000/2003/2008 R2.

Methodologies:

Star Schema and Snowflake Schema.

EXPERIENCE CHRONOLOGY:

Working as a Tech Lead for Tech Mahindra Ltd, Chennai from March 2011 to Till Date.

Worked as a Software Developer for Crazy Infotech Ltd, Chennai from Dec 2008 to May2010.

Worked as a Software Developer for Prithvi Information Solutions Ltd, Hyderabad from May 2007 to Jul 2008.

PROJECT PROFILE:

Project # 1: AMI M&S Data warehouse and Dashboard Oct, 2019 – Till Date

Client : Nissan

Role : Report Developer

Description

The aim of this project is to develop Tableau dashboards for management visibility of Logistics KPI – Stock and ageing with ETA to dealer. The data for this dashboard from SQL Server.

Responsibilities:

Designing the Reports as per client Requirement and created the reports using Excel file

And SQL Server as a data source.

Created complex reports utilizing the features like Hierarchy, Drill functionality, calculated

Field, Parameters, Sets, Groups.

Created various types of filters as per requirement of client.

Created Parameters to achieve desired functionality.

Implemented Blending concepts, Dual Axis concept in my Tableau Reports.

Ad-hoc reporting based on user requirements.

Analyzing requirements, validate available data, propose a usable design, develop and test reports.

Developed reports with key business metrics.

Utilizing capabilities of Tableau such as Data Extracts, Data Blending, Forecasting, Dashboard actions and Table calculations.

Deftly designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, score cards, Gantt charts, Bubble charts, etc.

Environment: Tableau 2019.2 and SQL Sever.

Project # 2: Aircraft Maintenance Dashboard May, 2019 – Oct, 2019

Client : Textron Aviation

Role : Tech Lead

Description

Textron Aviation can provide you with true factory-approved aftermarket parts, services and solutions to ensure optimal performance, increase the service life and enhance the resale value of aircraft. Connect with us to find the upgrade that suits your needs, our team is more than happy to discuss the following options for your aircraft. Aftermarket solutions for engines, propellers, avionics, cabin communications, as well as custom interior and paint designs. Continual innovations to keep your aircraft up to date with performance and regulatory requirements. Textron Aviation Service Centers provide maintenance inspections, parts, repairs, avionic modifications, equipment installations, interior and exterior refurbishment, and other specialized services for your aircraft.

Responsibilities:

Developed Interactive Dashboards, reports using Tableau Desktop

Involved in Requirement analysis and Data Analysis and Business analysis of Existing systems and utilized capabilities of Tableau such as Data extracts, Data blending, forecasting, Dashboard actions and Table calculations.

Created customized interactive dashboards in Tableau using Marks, Action, filters, parameter, and calculations.

Involved in unit testing of Reports.

Created Dashboards, Reports using Power BI.

Created custom calculations using various DAX functions.

Designed, Developed and Published Power BI Reports, Power BI Dashboard.

Created various charts and reports using power BI Desktop.

Created various Filters like slicers, Hierarchy slicer using power BI Desktop.

Developed Reports in Workspace Interface and provided the interactivity to the users.

Created Dashboards of reports containing the List reports, crosstab report and the chart reports like bar, column and pie with in a table and also used the prompts in the dashboard to show the sales in the selected regions.

Project # 3: Paper Prediction Dashboard Oct, 2018 – May, 2019

Client : Stora Enso

Role : Tech Lead

Description

Stora Enso develops and produces solutions based on wood and biomass for a range of industries and applications worldwide. Building on our heritage and know-how in forestry and trees, Stora Enso is committed to the development of products and technologies based on renewable materials and creating value in a sustainable bio economy. Solutions are found in such segments as building, retail, food and beverages, manufacturing, publishing, pharmaceutical, cosmetics, confectionary, hygiene and textiles. Tomorrow, we believe there is the potential to produce anything that’s made with fossil-based materials from a tree.

Responsibilities:

Created Dashboards, Reports using Power BI.

Created custom calculations using various DAX functions.

Designed, Developed and Published Power BI Reports, Power BI Dashboard.

Created various charts and reports using power BI Desktop.

Created various Filters like slicers, Hierarchy slicer using power BI Desktop.

Developed Reports in Workspace Interface and provided the interactivity to the users.

Created Dashboards of reports containing the List reports, crosstab report and the chart reports like bar, column and pie with in a table and also used the prompts in the dashboard to show the sales in the selected regions.

Project # 4: MTN Digital Dashboard May, 2018 – Oct, 2018

Client : MTN, South Africa

Role : Tech Lead

Description

MTN – Mobile Telecommunications Network. MTN was formerly M-Cell and it is a South African based multinational mobile telecommunications company, operating in many African, European and Asian countries. Its head office is in Johannesburg.

Responsibilities:

Created Dashboards, Reports using Power BI.

Design, Develop and Deployment of Power BI Bubble maps and configured On-Premises Data Gateway for data refresh on Power BI Maps.

Created custom calculations using various DAX functions.

Designed, Developed and Published Power BI Reports, Power BI Dashboard.

Created various charts and reports using power BI Desktop.

Created various Filters like slicers, Hierarchy slicer using power BI Desktop.

Developed Reports in Workspace Interface and provided the interactivity to the users.

Created Dashboards of reports containing the List reports, crosstab report and the chart reports like bar, column and pie with in a table and also used the prompts in the dashboard to show the sales in the selected regions.

Involved in unit testing of Reports.

Project # 5: Crystal Digital Dashboard Apr, 2018 – May, 2018

Client : BASF, Germany

Role : Tech Lead

Description:

BASF is a German chemical company and the largest chemical producer in the world. The BASF Group comprises subsidiaries and joint ventures in more than 80 countries and operates six integrated production sites and 390 other production sites in Europe, Asia, Australia, the Americas and Africa. Its headquarters is located in Ludwigshafen, Germany. BASF has customers in over 190 countries and supplies products to a wide variety of industries. Despite its size and global presence, BASF has received relatively for their analysis purposes they are using Power BI Desktop.

Responsibilities:

Created Dashboards, Reports using Power BI.

Design, Develop and Deployment of Power BI Bubble maps and configured On-Premises Data Gateway for data refresh on Power BI Maps.

Created custom calculations using various DAX functions.

Designed, Developed and Published Power BI Reports, Power BI Dashboard.

Created various charts and reports using power BI Desktop.

Created various Filters like slicers, Hierarchy slicer using power BI Desktop.

Developed Reports in Workspace Interface and provided the interactivity to the users.

Created Dashboards of reports containing the List reports, crosstab report and the chart reports like bar, column and pie with in a table and also used the prompts in the dashboard to show the sales in the selected regions.

Involved in unit testing of Reports.

Project # 6: Extended Reporting Services Oct, 2017 – Mar, 2018

Client : DHL, Malaysia

Role : Tech Lead

Description:

DHL Express is a division of the German Logistics Company Deutsche Post DHL providing international courier, parcel and express mail services. Deutsche Post DHL is the world's largest logistics company operating around the world, particularly in sea and air mail. For their analysis purposes they are using MSBI and Power BI.

Responsibilities:

Created Dashboards, Reports using Power BI.

Published Power BI dashboard on Mobile application.

Created Measures (Analytic Calculations), KPIs using various DAX Functions like Date and Time, Filter, Logical Functions in Power BI

Developed list, cross tab reports with prompts, and enabled dynamic functionality in drill through.

Worked with the report bursting depending on the customer requirement.

Worked on active reports for the requirements.

Created complex reports with multi querying, layout calculations, Dynamic headers, Master detail etc.

Updated the Framework model by adding new tables and created the relationships.

Analyzed the existing Framework Model for the new requirements and created the reports using the model.

Prepared technical specification document for the reports.

Tested the data after the report development by writing manual SQL at the database.

Scheduled the reports for the different user groups that available in the active directory.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server

Created various reports using different lists in single and multiple pages according to filter conditions.

Supporting all production BI applications.

Environment: Cognos 10.2.1 and Framework Manager 10.2.1, SQL Server 2012, Windows Sever 2008 R2 and Power BI.

Project # 7: Stockmann Steady Apr 2015 – Oct 2017

Client : Stockmann, Finland

Role : Tech Lead

Description:

Stockmann Oyj Abp is a Finland-based company active in the retail trade sector. The Company’s operations, along with its subsidiaries, are structured into two business divisions: Department Store and Fashion Chain. The Department Store Division offers shopping environment, which includes the Hobby Hall distance retailing business, the Academic Bookstores, the Stockmann Beauty stores, and the online stores of Stockmann, Hobby Hall and the Academic Bookstore in Finland. The Fashion Chain Division covers store chains, including Lindex and Seppala, which have a total of 689 stores in 16 countries. Lindex’s range of women’s wear, lingerie, children’s wear and cosmetics consists of a range of concepts. Seppala offers fashion for women, men and children. In addition to Finland, the Company operates in three geographical regions: Sweden and Norway, the Baltic countries and Central Europe, and the Ukrain.

Responsibilities:

Developed list and cross tab reports with prompts and enabled dynamic functionality in drill through.

Worked with the report bursting depending on the customer requirement.

Worked on active reports for the requirements.

Created complex reports with multi querying, layout calculations, Dynamic headers, Master detail etc.

Updated the Framework model by adding new tables and created the relationships.

Analyzed the existing Framework Model for the new requirements and created the reports using the model.

Prepared technical specification document for the reports.

Tested the data after the report development by writing manual SQL at the database.

Scheduled the reports for the different user groups that available in the active directory.

Worked in analysis, Development, enhancement, testing, data validation of Cognos reports

I have created Tableau workbooks from multiple data sources using Data Blending, generated Tableau Dashboards with quick/context/global filters, parameters, calculated fields, interactive views, trends and drill downs along with user level security etc.,

In Tableau Dashboards I have worked extensively with Calculations, Conditional formatting, Parameters, Sets, Groups, Various Hierarchies, Background images, Mapping, Actions etc.,

Environment: Cognos 10.2.1 and Framework Manager 10.2.1, Tableau Desktop, SQL Server 2010, Windows Sever 2008 R2.

Project # 8:OKQ8 Jul, 2014 – Mar, 2015

Client : KMD (Kommunedata) Denmark

Role: Tech Lead

Description:

OKQ8’s Business Intelligence and Data Warehousing Processes from IBM Mainframe to IBM Cognos 10.2.1 Servers in DEV, TEST and PROD environments for OKQ8 division. OKQ8’s 23 Business Intelligence Applications and Processes managed by the 23 Data Marts (Data Management) activities.

Responsibilities:

Developed models in Framework Manager and packages to the Cognos Connection.

Customized data by adding filters at both the Framework Level and Report Level.

Published different packages from Framework Manager to Cognos Connection.

Analyzed Relationships between tables in the schema and applied cardinality in the database layer.

Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention.

Used the parameter maps to show the sales in the region which can be viewed by the particular regional sales managers only.

Worked on creating and analyzing the complex reports like dynamic sorting.

Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.

Worked on conditional formatting, various type of prompts like value prompt, search and select prompt, Text Box prompt and Date & Time prompt an etc.

Created Ad-hoc Reports using Query Studio.

Environment: Cognos 10.2.2 and Framework Manager 10.2.2, SSIS, Cognos Workspace, Teradata 15,Windows Sever 2008 R2.

Project # 9: Pulse Cognos Initiative – Digital Energy Apr, 2013– Jun, 2014

Client : General Electric (GE)

Role : Team Member

Description:

Digital Energy, a division of GE, is a major solutions provider and thought leader in the effort to modernize and optimize how we generate, move and consume energy. GE Energy in a move to break the energy businesses into the following three independent sub-businesses: GE Energy Management, GE Oil & Gas and GE Power & Water.

Responsibilities:

Developed list, cross tab reports, Bar charts and Line charts to define the business trends with time.

Enabled Drill-through functionality depending on the reports as per the business requirements.

Worked on the Cognos product branding changes as required by the customer.

Worked on the active reports for the requirements at the initial stage of the project as a POC.

Analyzed the existing Framework Model for the new requirements and created the reports using the model.

Prepared technical specification document for the reports.

Tested the data after the report development by writing manual SQL at the database.

Environment: Cognos 10.1 and Framework Manager 10.1, SQL Server 2010, Windows Sever 2008 R2.

Project # 10: CSA DWH 2011 Jun, 2012 – Mar, 2013

Client : General Electric (GE)

Role : Team Member

Description:

GE Aviation is widely regarded as the world’s leading long distance airline and one of the strongest brand in USA. They also operate subsidiary business including other airlines and business in specialist engines and markets. This project provides the information on detail of flight engines. There are several applications like network performance, functions, etc…

Responsibilities:

Understand the reports requirement documents

Extensively developed reports as per the business requirements

Created metadata model using framework manager, created packages and published the packages

Created regular dimensions, measure dimensions and set the scope

Generating various reports List Reports, Cross-tab Reports, Chart reports

Created filter, prompts, and calculations for different report authoring.

Used Drill through operation done for different aspects of client business

Created variables and applied conditional style for highlighting the specific data.

Used Cascading Prompts to design User-friendly reports

Save the reports outputs to FTP.

Involved in Deploying the reports from DEV to QA

Involved in Designing Test Cases

Environment: Cognos 10.1 and Framework Manager 10.1, SQL Server 2010, Windows Sever 2008 R2.

Project # 11: Wireless Migration Mar, 2011 –May, 2012

Client : TELUS

Role : Team Member

Description:

TELUS is leading Telecom service provider of East region of Canada. Business Intelligence Application is implemented at TELUS to enable easy access to cross-functional data for effective business decision-making. The project involved in Migration of cubes from 7.3 to 8.4.

Responsibilities:

Preparing Technical spec’s for the Reports Data Mapping.

Created Model by importing tables from database by using Framework Manager

Created Dimensional Modeling in Framework manager.

Define the Joins and Created the Business view in Framework Manager for user Comfort ability

Creating and publishing the packages according the business requirement.

Developed Mockup reports and given demo’s to the users allowing them to visualize the final reports and suggest any changes they may require.

Working with Data Through Filtering, Sorting, Grouping Identical values, calculations, summarization, changing the data format. Using prompts to filter data & creating custom groups.

Environment: Cognos 7.3 and Cognos 7.4

Project # 11 : Online Shopping Dec, 2008 – May, 2010

Company : Crazy Infotech Ltd

Role : Team Member

Description:

This project deals with creation of online shopping website. By using this site we can sell products with easy-to-use shopping cart checkout. Shopping cart enable customers to add items, view their order, continue shopping and quickly check out. It also provides different types of searches that enable the customer to search products in an easy way and it provide a reliable online shopping experience. Admin can able to change the settings and basic configuration of the site and we can track the mall sales results. It can help to increase businesses productivity and growth rate.

Responsibilities:

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Created SSIS package to import meta data into SSAS dimensions

Created SSAS cube and multi dimensions to provide aggregated net energy consumption reports.

Designed and created OLAP database in SSAS

Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.

Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server

Created various reports using different lists in single and multiple pages according to filter conditions.

Supporting all production BI applications.

Environment: MS-SQL Server 2008, MSBI (SSIS, SSAS)

Project # 12: Sales Analysis and Super Market May, 2007 – Jul, 2008

Client : 7 to 9 Super Market (Retail and Stores)

Role : Team Member

Description:

This product is developed for largest store in India that decided to build a Data Warehouse to maintain the stores and to get the summarized results in a short time. The Performance Ranking Analysis application enables the user to determine the stores performance by ranking them based on products details, stores details, site details, Staff details, Time details, and sales variance, monthly and yearly growth.

Responsibilities:

Involved in the formulation and authoring of reports using Cognos 8.3 as reporting tool.

Involved in the Analysis of the Report Design documents.

Creating Complex Reports using conditional Formatting and conditional blocks.

Creating Complex reports using calculated columns in Cross tab and Chart Reports.

Customizing data by adding Filters Prompts and Functions like Conditional Block.

Customize data by adding Filters, Prompts, Calculations, Summaries and Functions.

Formatting the reports by applying Groups, Sorts and Filters.

Used Report Studio to develop various types of reports like List reports, Cross tab reports, Chart Reports.

Created reports using Cascading Prompts, Conditional Variables and Data Formatting properties.

Used Cascading Prompts to design User-friendly reports

Environment: Cognos 8.4 BI server and Framework Manager 8.4, SQL Server 2005, Windows XP.

CERTIFICATIONS:

edX Microsft Certified in Analyzing and Visualizing Data with Power BI

IBM certified Designer Cognos 10 BI Reports India, in 2012.

EDUCATIONAL QUALIFICATION:

MCA from Thanthi Hans Rover College, Trichy, Tamil Nadu (Bharathidasan University) in 1999.

B.Sc. (Mathematics) from SRNM College, Sattur, Tamil Nadu (Madurai Kamarajar University) in 1995.

Contact this candidate