Sap Hana Business Analyst

Anusha Dikkala

Mobile : 732-***-****

Mail :*******.******@*****.***

Consultant

CAREER SUMMARY:

Around 8+ years of experience in IBM Cognos BI, SAP BO and Microsoft Power BI Desktop technologies

Functional Expertise of SAP HANA modeling from an E2E perspective.

Experienced in various modeling artifacts of SAP HANA like Attribute Views, Analytic Views, Calculation Views and Other topics viz. Analytic Privileges, Decision Tables, Variables, Input Parameters, Calculated Columns, Restricted Columns

Manage data provisioning, migration and cleansing from legacy to target system using BODS

Knowledge of selecting BI client based on product capabilities and Business requirements

Good knowledge in Cognos 11 Report Studio and Cognos admin

Worked Extensively in SAP BO which includes SAP Business objects admin and CMC

Experience with cognos architecture and administrator in Linux environment

Hands on experience in building packages, universe in Framework manager and IDT respectively

Scheduling/Publication of Reports in Webi and Cognos

Experience in Administration side of Cognos and BO like Deployment, User access, Database connections.

Experience in Data Modelling and DAX Commands.

Experience in Creating relationship between data sets by using relationships and Calculation on columns and measures using DAX functions like Date &Time, Filter, Information, Logical, Mathematical, String, Text, Time Intelligence.

Involved in Admin activities like Publishing, creating groups and sites, give the Permissions etc.

Creating schedules and Tasks for Worksheets and Dashboards according to the client requirement

Research on tools like design studio/Lumira

Programming, updating, and managing databases used in online and offline executions

Working with Business users to understand what they need/want to run the business

Working with technology team to confirm the needs and communicate effectively across multiple groups

Excellent organizational skills, attention to detail, Time Management

Advising on new technologies and methodologies

Education Qualification:

Masters Information Technology SRM University Chennai.

Professional Experience:

IT Analyst for Tata Consultancy Services (TCS) (Dec 2014 – Mar 2023)

Skills:

1.Business Objects

2.IBM Cognos

3.Power BI

4.Design Studio/Lumira

5.Sap HANA/BODS

Project 4: Marks & Spencer’s (Oct 2022 to Mar 2023)

Marks and Spencer’s group plc. Is a luxury brand that specializes in selling clothing, beauty, home and food products.

Role:

Involved in information gather phase Designed and implemented SAP HANA data modeling using Attribute View,

Analytic View and Calculation View.

Importing Custom Visuals from Microsoft Power Bi gallery as per client request.

Worked on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.

Scheduling the refresh and creating dashboards.

Creating Filters in Visual level, page level, Drill through and Report level.

Installing and configuring gateway services for Power Bi Desktop

Updating weekly status and keeping track of overall development status for the project

Involved in Collect the Technical Specification Document and Analyzing the User requirement.

Designing, developing and implementing Business Intelligence reports & dashboards with SQL Server sources.

Creating the Bar charts for daily/weekly/monthly transaction and historical data for Quality check of the data.

Creating interactivity between the user and dashboards with the help of Slicer and Interactions to compare data against different views.

Data Transformations done on Power Query, Power pivot and DAX functions

Responsible for designing and development of reports and dashboards from SAP BI/BW and the

Relational data sources from the warehouse

Closely worked with the Business Analyst, BI lead and the architect in understanding the BRS and SRS documents

based on the business requirements

Performed the gap analysis to understand the feasibility in designing the dashboard layout per business requirement

Expertise in working with business users and engrossed in gathering requirements to develop ad-hoc, canned reports.

Involved in the Migration activities

Prepared user documentation for hand on training for end user community

Featured in reinforcement of existing reports as per requirement.

Development of WEBI reports

Performed broadly on Web Intelligence for evolution and assistance to clients with reports as per business requirements.

Worked with Business Objects 4.3

Worked in development Environment involved in designing Universes also involved in enhancements of existing universes.

Conceived Dimensions and Measure Objects, Resolved Loops and Traps, used List Of Values, Applied Restrictions on Objects, used @Functions, Hierarchies, Derived Tables, Indexes, Aggregate aware, cross tabs based on requirements.

Substantial work on performance tuning of universe and linking universe.

Proficiency in generating sales reports, which embrace formatting options such as Charting, Mapping, Sorting, Alerting, Field highlighting, Drill-Down, Parameter prompts, Used Cascading LOV’s.

Operated on predefined conditions, Scope of analysis, global and report filters.

Instigated Pie and Bar charts with drill-down report.

Applied formatting to reports and induced reports with pre-requisites like formulas and variables.

Worked on Combined Queries to appraise complex business scenarios, which are grueling to formulate

Developed FM model for report studio developers

Cognos Administration: Defined roles and permission and matched them across all environments for multiple applications (linked the reports to dashboards)

Worked on report performance Improvement project - found issues and fixed them.

Created multiple Dashboard reports for multiple packages.

Project 3: ADIENT (Jul 2021 to Sep 2022)

Adient is an independent core company in automotive seating and beyond

Role:

Worked On Enhancements in web I 4.2

Support work for multiple reports in web I regarding to data issues

Regularly monitoring SNOW

Provide daily and weekly updates in the status calls to onsite coordinators

Hands on Analytics with tools like Business Objects and Admin activities

Responded expediently for requests to create, modify and fix reports. Developed production-level

Creating Power BI reports for the different product sales made in individual countries.

Data Transformations done on Power Query, Power pivot and DAX functions

Proficient in Report building using Cognos Report Studio.

Created List, Crosstab and Drill-Through reports using Report Studio.

Deployed the reports from development environment to test environment.

Importing the BW Models in to HANA using HANA Studio

Consuming the HANA Models in BW by creating the Transient Providers

Responsible for functional documentation gathering & built proper test cases as per QA best practices in ALM.

Reviewed end-to-end business scenarios, map them in SAP and ensure completeness of

test scripts and smooth deployment across SAP landscape.

Conducting daily phone sessions with various off-shore test leads for work assignments

and functional area coverage.

Assisting team to write clear precise test scenarios and validate the scenarios

and functional mapping with requirement

Project 2: AIG (American International Group) (Oct 2017 to June 2021)

The applications under American International Group taken care are AHEIS and EXS Reporting. The reports basically consist of information regarding the insurance details of customers.

Role:

Development of WEBI reports

Involved in the Migration of BOXI 3.1 to BO 4.0 Environments By using Import Wizard

Worked on Technical documentation of the reports for Onsite team.

Monitoring Scheduling Reports in Central Management Console

Enhancements in existing BO reports based on user requests

Business Objects install/upgrade/admin

User group roles creation

Developed letter templates as per Business Requirement.

Worked on Column and field adding. Comparisons of the Existing reports taking AS- IS Extracts and TO- BE Extracts.

Developed reports and jobs should be monitored daily

Users should be provided with access to reports

Cube data validations to be run whenever necessary

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.

Created Dashboards to present critical company data in a single report.

Created list reports & cross tab reports using cognos 10.1

Manually modified the SQL in Report Studio to tune and/or to write complicated reports.

Used union/Join objects in Report Studio

Experience in developing Framework Manager Models and analyzed those models in analysis studio.

Gathered and analyzed business requirements from users and business community.

Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.

Created Sophisticated Reports using Report Studio.

Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Experienced in the Reports formatting and making Dashboard Visualization attractive using the Colors and by designing with shapes, Images and Textboxes.

Have good Experience in Publishing the reports to power BI Service, creating workspaces, Providing the access, using the Analyze excel and scheduling the reports to refresh on time.

Merge and Append Queries and Utilized aggregation to improve query performance.

Group data to create Summary Queries in Power BI.

Create Chart Visualizations and interactive Charts, Creating Power View Slicers.

Using Tiles and Power View Filters and connecting slicers to more than one table.

Creating a Query, the Query Editor Window in Power BI.

Involved in gathering and analyzing the requirements and preparing business rules.

Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.

Documented required technical metadata such as source and target definitions

Providing overview of SAP S/4Hana and different modules within SAP and how they interact with each other to the automation team for better understanding for their automation assignments.

Project 1: Enterprise Analytics (Dec 2014 to Sep 2017)

The customer for Enterprise Analytics – Sales is Tata Consultancy Services Limited (TCS). TCS Limited proposed to build dashboards, analytics and reporting systems for its internal information systems. This is to help senior management in their decision making.

Role:

Developed CEO Dashboards, Self-Analytics, Sales notifications reports in Web intelligence

Data modeling in HANA for Account Dashboards.

Developed basic CV/AT, scheduling of BODS jobs to fetch data from source.

Cognos server maintenance and deployments

Cognos Migration from sp10 to sp12

Metadata modeling in the semantic layer (Creating Packages in Framework Manager).

Creation and execution of test cases.

Detecting security vulnerabilities and fixing them.

Deployment and monitoring of application after deployment.

Admin Activities in cognos maintaining servers and user access to reports have been done.

Research on new tools like design studio and lumira was done.

Implementation of trial dashboards in new tools to check the feasibility of script and performance

Develop and maintain executive, enterprise level analytics solutions and reports using Power BI Desktop

and hosted in Power BI Report Server.

Manage report security, folder security, database row level security, report schedules and distribution

Client: Datapro Pvt Ltd (June 2014 to Nov 2014)

Role: Internship

Responsibilities:

Learned and Implemented Fundamental concepts for Java

Worked on the maintenance of existing projects by adding new functionalities

Adding / modifying the design of existing code

Prepared various test cases to run on the module.

Developed a framework to parse large data bundles, collect useful information, and

Determine the validity of resulting data.

Learned various Technology across all layers of the development stack

Contact this candidate