Engineer Sap

Vasuki P

Email: ************@*****.***

***************@*****.***

Ph : 994-***-****

Professional Summary

Have 7 years of experience in Business Intelligence using SAP Analytic cloud, SAP HANA, SAP BO4.0, SAP BO cloud analytics, SAP Lumira, Tableau, SQL, Microsoft Power BI.

Created Digital boardroom dashboard using SAP analytic cloud.

Created dashboard using Microsoft power BI.

Created chart and graphs in microsoft power BI

Created the calculation view and analytics view in HANA.

Extensively worked various input parameter such that Column, Derived from Table, Direct, Static List, Derived from Procedure/Scalar Function.

KPIs can be created on an ad hoc basis within a report in SAP Analytics cloud.

Creating HANA views and building reports on top of HANA.

Experienced in Developing various Charts, Graphs in SAP analytics cloud.

Created stories using chart in Sap analytics cloud.

Presented data graphically using charts, tables, geo maps, text, images, and shapes in SAP Analytic cloud.

Creating Dashboards/Analysis applications over HANA. Created multiple HANA SQL Procedures and expose the data in the HANA models.

Involved in gathering, analyzing and documenting business requirements, functional requirement and data specifications for SAP analytic cloud and HANA.

Experienced in Developing Reports and Customizing reports using Alerts, Breaks, and Filters and Sorts etc.

Extensively worked in Designing the Universe (Inserting Tables, make the Joins, Resolving the loops, creating the classes and objects, creating the custom Hierarchies, Testing and distributing the universe) and resolving the loops using the alias and context.

Experienced in creating reports using Web Intelligence in Bex queries.

Experience in creating the SSIS package with SQL script. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Technical Skills

Skill : HANA,Microsoft power BI analytic cloud, BOBJ,SSIS, Lumira

Operating System : Windows XP, HP-UX, Windows Vista, Windows 7

Scripting Language : SQL

Professional Experience

HP as Software Engineer from Feb 2011 to April 2014

working in TCS as System Engineering from April 2014

Academic Profile

MCA - Master of computer application 2007 -2010

86 % - first class with distinction.

B.sc - Mathematics with Computer application 2004- 2007

77 % - first class with distinction.

Projects

Project Profile #1

mailto:***************@*****.**********

GMAR Dashboard

Role

BI consultant

Period

Aug 2015

Project Description:

Telstra Corporation Limited ("Telstra") is a leading Australia-based, tier one telecommunications and media services company, offering a full range of communications services. Telstra Global Enterprise and Services (GES) is a division of Telstra that focuses on growth opportunities outside Australia through onward investments, deploying disruptive technologies across the world and growing international and local customer relationships.

Roles & Responsibilities:

Created Digital boardroom dashboard using SAP analytic cloud.

Created the calculation view and analytics view in HANA.

Extensively worked various input parameter such that Column, Derived from Table, Direct, Static List, Derived from Procedure/Scalar Function for HANA view .

KPIs can be created on an ad hoc basis within a report in SAP Analytics cloud.

Created dashboard using Microsoft power BI

Experienced in Developing various Charts, Graphs in microsoft power BI.

Created stories using chart in Sap analytics cloud.

Presented data graphically using charts, tables, geo maps, text, images, and shapes in SAP Analytic cloud.

Creating Dashboards/Analysis applications over HANA. Created multiple HANA SQL Procedures and expose the data in the HANA models.

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Web Intelligence Reports.

Defined aggregate SQl functions on measure to improve performance.

Created Universes, Classes Dimension and Measure Object by retrieving the data from various data sources and defining the necessary connections.

Detected/resolved data cardinalities and loops, check integrity of universes, created list of values. Resolved Chasm, Fan traps and loop problem using aliases and context in the universe and exported to repository.

Created Web Intelligence report using Prompt, Break, Filter, Rank, Alerter, Slice & Dice and Drill up/down functionality.

Modified the report as per user requirement. Worked with hyperlink functionality to link the reports.

Designing/Developing Complex Reports using predefined conditions.

Created bar charts, pie charts and exported them to power point, PDF and presented them in user meetings.

Involved in migration activities. Created group and users for SAP BO administration part.

Project Profile #2

Project

SAP_Business Operating standard

Role

SAP BO developer

Period

APR 2014 – Aug 2015

Roles & Responsibilities:

Developed Web Intelligence Reports as per the business requirements.

Created new objects and classes in the Universe based on the report creation requirements.

Designed the Queries in web-Intelligence Query Panel.

Developed the Web-I reports using Cross-Tab, Vertical table, Pie charts, Column stacked charts and Line Charts as per Requirement.

Modified the report as per user requirement.

Designing/Developing Complex Reports using predefined conditions.

Created bar charts, pie charts and exported them to power point, PDF and presented them in user meetings.

Modified and maintained Universes using Designer module to include objects like Dimensions, Details and Measures according to the Functional specifications

Created Input controls and drill filters depend on requirement.

Worked extensively with the major functionality of BO like Breaks, Alerter, Variables, Formulas, Filters, Sorts, Query prompt in Web Intelligence.

Project Profile # 3

Project

CDW

Project Role

Data Engineer

Period

Feb 2013- April 2014

Client

Telstra

Project Description:

Telstra Corporation Limited ("Telstra") is a leading Australia-based, tier one telecommunications and media services company, offering a full range of communications services. Telstra Global Enterprise and Services (GES) is a division of Telstra that focuses on growth opportunities outside Australia through onward investments, deploying disruptive technologies across the world and growing international and local customer relationships.

Roles & Responsibilities

Created the BO universe on top of SAP Cubes and Bex queries.

Created the Universe using custom hierarchies, cascading prompts, securities, @prompt, aggregate aware, and index awareness.

After creating the universe on top of cubes renaming the objects and deleted the unwanted objects etc.

Created the webi reports using universe as source.

Developed the webi reports using user response, relative date and relative position.

Created the webi reports using merge and combined queries.

Designed and Developed Webi Reports using Break, Section and Charts, Cross Tabs, Drill Down, Functions and Formulae to analyze the data.

Created Webi reports using BEx queries. Created Rich dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.

Connected Tableau server to publish dashboard to a central location for portal integration.

Responsible for interaction with business stake holders, gathering requirements and managing the delivery.

Creation of metrics, filters, reports, and dashboards created complex calculations to manipulate the data.

Project Profile #4

Project

CDW-HSPM

Project Role

Data Engineer

Period

Feb 2011 – Feb 2013

Client

Telstra

Roles & Responsibilities:

Have created SSIS package to automation as per user requirement and created to process improvement. Developed, deployed, and monitored SSIS Packages.

Have implemented the multiple packages at the same time.

Involved in designing, developing and deploying reports in MS SQL Server environment using SSIS in Business Intelligence Development Studio (BIDS)

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Modify the Web Intelligence reports as per user requirement. Used drill down analysis in business object, which will allow the user to view data at a more detail level and fro different angle.

Involved the performance tuning in Packages

Extensively worked with formatting the report according to the user requirement.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Fully coordinating change management, release management, incident management and fixed issues within SLA.

Contact this candidate