RADHA OGETY

SENIOR BI REPORTING ANALYST

+919*********

ad0ehu@r.postjobfree.com

linkedin.com/in/radhaogety/

EDUCATION

May 2010

Master of Business Administration

International Technological University

California, USA

Aug 2006

Bachelor of Industrial production Engineering

Osmania University

Hyderabad, Telangana, India

RELEVANT SKILLS

BI Tool: Business Objects XI 3.2/4.x, BI (Business Intelligence), WEBI,

SAP Crystal Report,

SAP Design Studio,

SAP Lumira,

SAP Analytics Cloud, Microsoft Power BI, Tableau

Programming:

SQL server and PL/SQL

Development Skills:

DAX

Data Visualization

Technical Writing

Reporting efficiency and Accuracy Creative problem solving

CERTIFICATION

Microsoft Certified: Power BI Data Analyst Associate

PROFESSIONAL SUMMARY

Highly motivated Power BI/ SAP BO developer with around 11+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, SSRS, Azure, Power BI for building, deploying, and managing applications and services through a global network of Microsoft - managed data centres.

Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.

Good experience with SQL Server, Oracle Database Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.

Having good hands-on Experience in Power BI, Report Builder, Power BI Pro, Power BI Mobile

Expertise in Development support solutions for Business Objects XIR3.2, 4.0, 4.1, 4.2 Web Intelligence, SAP Crystal Reports, SAP Dashboard, SAP Design Studio and SQL server 2008, 2016

Expertise in gathering, analysing, and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports

Having expert skills in Universe designing, developing, and generating Ad-hoc reports, canned reports, and dashboard Reports

Experienced in developing complex reports using Business Objects and Crystal Reports having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports

Handling Development projects along with Production Support on call tasks with zero defects and no escalations by far

Having good skills in SAP Design Studio dashboard development, support, maintenance, and fixing issues with existing dashboards.

Guided, trained, instructed, and assisted technical members on trouble shooting of technical issues and involved in code review

Have knowledge in BW BEx Query Designer and Analyzer.

Having good hands-on Experience in Tableau Server, Tableau Desktop

Good Knowledge: SAP Lumira, SAP Cloud Analytics, Snowflake cloud technology

Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.

Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

WORK HISTORY

ENTERPRISE RESOURCE PLANNING SPECIALIST

NTT Data Global Delivery Services Limited

Bangalore, Karnataka, India - December 2013 - Current

Client: TOKIO MARINE KILN GROUP LIMITED (Feb2018 – Till Date)

Project: TMK Projects and Support

Position: Team Lead

Responsibilities:

Developed Dashboards and Reports with Excel, SQL Server and Report Server data sources using Power BI Desktop tool.

Involved in converting SAP BO Universe into Power BI model and migrating existing Web Intelligence (WEBI) reports to Power BI reports and dashboards

Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.

Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Restricted data for users using Row level security and User filters.

Developed Power BI Dashboard used for Heat application.

Good experience in writing complex DAX functions in Power BI and Power Pivot.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.

Weekly presentation to the business users about the reports and their changes as required.

Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.

Experience in developing Dashboard Report, Parameterized Reports, and Sub reports by Region, Year, Quarter, Month and Week.

Converting Crystal reports to paginated reports in Power BI using Report Builder

Developed POC’s Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.

Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc. Used SQL server as data sources for designing Tableau Reports and Dashboards.

Provided customer support to Tableau users and Wrote Custom SQL to support business requirements

Involved in requirement gathering for the Development of new reports using SAP Crystal report 2016

Developed Complex Crystal Reports, Summary Reports, Drill-down, Dynamic grouping, graphical reports

Expert in writing complex formulae at the summary level and group level to implement the business logic

Modified existing SQL Server stored procedures, views, and functions for data as per user request for the Crystal Reports

Wrote efficient Stored Procedures for the Optimal Performance of the system.

Modified existing reports according to the user's requirement and exported reports to PDF format.

Enhanced Universe using IDT to include the finance related objects according to the requirements

Modifying Universes Defining BO Classes, Objects, Cardinalities, Contexts, Joins and Aliases,

Proven abilities in creating Webi reports using functionalities like prompts, conditions, Combined queries, variables, formulas, drill down, merged dimensions, crosstab, Sections, break, alerts, ranking, Input controls and charts/graphs.

Experience in developing dashboards (with using SAP and Non-SAP data source)

Involved in End-to-end testing of all the Universe and Reports

Handled interactive UAT sessions with the users and worked with them to understand and fix issues on the go.

Co-ordinate with the Admin team and get the developed objects moved across environments.

Scheduled reports to run on daily/weekly/monthly basis and to distribute the output in different formats to various users

Conducted meetings with Business Analyst and users to get the requirement correctly and finished the tasks within the time frame

Configured the universe parameter settings to optimize the performance of the universes

Coordinated the unit testing, system testing and user acceptances test (UAT) for universe, reports, and security management

Worked in production Roll out and ensured smooth usage of reports by users.

Developed work schedules, time estimates and budgetary factors for report development.

Prepared and maintained Activity tracker to complete deliverables within deadlines

Environment: SAP BO 4.2, SAP Crystal report2016, SQL Server 2012, Power BI, Report Builder, Tableau Desktop, Tableau Server

Client: Honeywell Transportation Systems (Aug2017 – Jan2018)

Project: HOS Metrics Dashboard

Position: Senior SAP BO Developer

Responsibilities:

Involved in requirement gathering for the Development of Dashboard using SAP Design Studio tool

Designed wireframe Applications as per User requirement

Developed Summery dashboard and Detail Dashboard using BW as Data Source

Worked on integration from Summary to Detail Dashboard

Implemented Drill down functionality on Crosstabs to graphs to detail level data, Alerts in Dashboard

Followed Agile Methodology and participate in Sprint calls to meet deliverables

Involved in Upgrading Dashboards from Design studio 1.4 to Design Studio 1.6

Prepare Monthly Status reports for the application and Share with Business

Co-ordinate with the BASIS team to fix any issues with the server or services related to Design studio.

User creation and Promotion Management activities for support performed

Prepared and maintained Activity tracker to complete deliverables within deadlines.

Prepared weekly status reports and attended status call on Daily basis.

Good Knowledge on converting SAP Design Studio to SAP Lumira

Environment: SAP Design Studio, SAP BW 7, SAP Lumira

Client: Honeywell (Dec2013 – July2017)

Project: Honeywell PMT Projects and Support

Position: SAP BO Developer

Responsibilities

Good knowledge on enhancing Cubes and Multiproviders

Worked on the collecting and moving transports of the BW objects from the development to the quality and make ready for Production movements.

Worked on break fix and regular support activities on the BW objects

Testing the Bex queries and provides test case documents to the customer.

Creating and managing folders on the BO Launchpad based on the project needs.

Developed Web intelligence reports based on Bex queries using BICS connection type, testing, and migrating to the QA and PROD.

Have worked on charts, tables, and other report elements

Worked on developing AAO reports and publishing them to the Launchpad

Done testing for AAO reports with the Bex Analyzer output to ensure data accuracy

Regular Knowledge transfer sessions organized within the team to ensure all system updates shared with the team.

Handle training sessions on Business Objects WebI and Universe Designer for the fresher

Validation of the Bex and WebI reports to show they are in sync and match the requirement.

Enhance the existing Dashboards developed using Design studio tool and do end to end testing.

Do testing, peer review and validation of dashboards against BW data to project the correctness of data.

Co-ordinate with the BASIS team to fix any issues with the server or services related to BO and Design studio.

Do regular monitoring activity using the Audit universe and give report to the customer on list of inactive users and unused reports. This helps improve the performance of the system.

Regularly prepare and send weekly status report to the team, shared with the customer to track the work done for the week.

End to end BW and BO activities for development projects.

Follow Metrics and do peer and SQA review for the objects developed and ensure quality.

Environment: SAP BO 4, SAP BW, SAP Design Studio

SAP BO Developer\Crystal Report Developer

Optech Consulting Inc

Dallas, USA - September 2011 - April 2012

Responsibilities:

Interacted with the Business Users to analyse business processes and gathered the information as per User requirement.

Expertise in Planning, organizing, scheduling, and managing Business Objects report implementation

Extensively worked on design, development, and Problem Solving of Business Objects reporting solutions using Web Intelligence (WEBI), Crystal 2008 and Xcelsius 2008 using legacy data sources

Responsible for Coordinating with Application Developers in the integration and utilization of Crystal Tools in the development of applications

Reviewed User Requirements, Created detailed Functional Design Documents and Report design details documents for the reports

Using Crystal report 2008 created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Crosstab reports.

Responsible for both recommended and completed detailed report customizations to narrow report focus to meet specific business needs

Worked with the business analyst team to interview the business users and capture simple, moderate, and complex business requirements. Collaborated with business technicians to research existing business and system processes

Handled Incompatibility issues between Crystal Reports 2008 and Excel and between Crystal Reports and PDF

Created customized existing reports using sub-reports and charts to present information.

Created the Crystal reports using tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.

Wrote formulas to calculate the group summaries based on the group levels in Crystal Reports.

Created reports across the channels (Sub Reports Drill-down, dynamic grouping, Master/Detail, Crosstab, graphical, aging reports etc).

Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the data in Crystal Reports

Customizing the AdhocWebi reports as per the user requirements by using the Formulas, Drill Downs, Master/Detail and Cross Tabs.

Developed dashboards, KPI and scorecards for detailed analysis. Also, creating Dashboard (xcelsius) Manager using Application Foundation and Web Intelligence.

Optimize Universes using @functions (@prompt and @select) and Aggregate Awareness Functionality.

Applied security features of Business Objects like row level, report level & object level security in the universe to make the sensitive data secure.

Created dashboards using SAP Business Objects Dashboards 4.0 (Xcelsius)

Created WSDLs using Query as a Web Service (QaaWS) from different Data sources.

CMC: Scheduled the reports (PDF, Excel) in Info View to Business users

Implemented dynamic cascading prompts and defined business views

Organized complex data in the report by Inserting Filters, Sorting, Ranking and highlighting data. Created complex reports by utilizing the features on Web Intelligence like Optional Prompts, Functions, Alerters, Rank, and Merged Dimension etc.

Train users to use the tool and create Ad-hoc business objects reports (With my own documentation).

Demonstrating familiarity with standard business reporting processes and refines data needs in a changing environment to meet specific business objectives.

Environment: SAP BO XI R3, SAP Crystal report2008, Oracle 10g

Crystal Reporting Developer

SV Tech Inc.,

Herndon, Virginia, July 2010 – August 2011

Responsibilities:

Involved in Requirements gathering, analysis, documentation of business requirements, functional requirements and data specifications for Business Objects Universes and Reports

Performing extensive data analysis on reports and preparing proper explanation of reports, this task performed for senior executives in manner that they can present read through a particular report in the shortest amount of time and gain maximum insight into the data.

Created crystal reports from various sources of data

Developed critical reports (like drill down) for analysis of parts benefits and head count.

Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements

Created Reports using Web Intelligence, used multiple query panels to create reports, Combined Queries, Drill Down, and Cross tab.

Designed and developed Crystal Reports, which included standard reports, crosstab, summary reports according to the requirements. Reports developed contained Crystal Formulae, SQL Expressions, Selection Criteria, and Sub Reports etc.

Developed various charts and graphs like Bar chart (side by side, stacked), line graphs, pie charts etc by using chart expert utility of Crystal reports

Developed several complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.

Developed Crystal Reports from different data sources like Oracle

Generated the Business Objects reports involving complex queries, sub queries, Unions, and Intersection

Created Drill down reports based on Summary and Detail reports.

Worked extensively with the ETL team in creating summary tables to improve report performance.

Environment: Business Objects XIR3, WEBI, Crystal Reports 2008, Oracle 10g

Contact this candidate