Vijaya Lakshmi Hardagari
Cumming,United States
Summary
Around 10+ years of total IT experience in the Design, Modeling, Development and Testing of Data warehouse & Reporting applications. Expert in Data Visualization development using Power BI and Tableau to create complex intuitive and innovative dashboard. Extensive experience in strategizing for Power BI Architecture and implementing for projects with SAP HANA/SAP BI/SQL Server/Salesforce as data-sources. End to end experience in designing and deploying data visualization using Power BI. Hands on Experience in Creating Tables, Views and Stored Procedure in Snowflake. Developed Source and Target mapping documents for the Dimensions and Fact tables. Worked on creating Universes in IDT on SAP BW, SQL & Oracle environment. Solid understanding of Relational Database, Data modeling, data analysis and reporting Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload to acquire the data into SAP HANA Data Mart. Strong knowledge on BOBJ CMC and security in CMC. Extensively worked in Power BI for Reports and Dashboards connecting to SAP BW and HANA. Proficient in troubleshooting, code fixing for production reporting problems. Have working experience in designer creating Projects, Batch Jobs, Data Flow, Data Stores, Query transforms in SAP BODS (Data Services). Capable of working independently with business and understand the requirements and deliver what they require for business needs. Demonstrated ability to complete multiple assignments simultaneously and maintain high standards of client organizations.
Overview
11
11
years of professional experience
Work History
Data Engineer
Equal Force
- Worked on interacting with business and resolving the data issues and enhancing the fields based on the requirement
- Worked on investigating data issues in BW and fixing them in source and Webi reports
- Worked on DTP’s & Transformations and on Semantic cubes & Multiproviders
- Worked on tuning the performance on BW and even in BOBJ for Webi reports
- Worked on resolving Crystal report issues
- Strong experience in the integration of BODS with SAP modules and Non-SAP data sources
- Created complex Jobs, Work Flows, Data Flows, and using Transforms (Integrity, Quality, and Platform) to successfully load data from multiple sources into a desired target
- Extracted SAP ERP tables data using ABAP Interface in BODS
- Experience to developed Navigate the interface Creating Dynamic Dashboards
- Data can be exposed different levels By Drill down functionality
- Using these Reports the end user can analyze data at different levels like \'By age Group\', \'By Gender\' \'By Brand\' \'By Product\'
- Experience using functionalities like Scope of Analysis,Breaking, Section, Alerting, Filtering and Grouping
- Worked on merge dimension in Webi based on Plant & Container & generated the reports
- Worked on Advanced Analysis for OLAP in BI Launch Pad
- Supported Process Chains in BW
- Involved in Monitoring Batch jobs
- Involved in Recovery of the Batch jobs when failed
- Environment: SAP BW 7.3, Net weaver 06 , SAP ERP Central Component 6.0, SAP Enterprise Portal , BEx Analyzer, WAD and Windows XP, and MS SQL,BOBJ 4.1 SP5
- Industry: Medical Technology
SAPBI/BO/Power BI developer
Gwinnett
01.2020
- County – County is located in the north central portion of the U.S
- State of Georgia
- It forms part of the Atlanta metropolitan area
- In, , the population was 957,062, making it the second-most populous county in Georgia
- Worked in collecting requirements from business and developed Power BI dashboards for Solid Waste Management, Solid Waste Management Survey & Tax Consumption Reports
- Worked in Power BI with languages SQL & DAX and implemented business logic in dashboards
- Designed Power BI reports and published on Power BI server
- Expertise in writing complex DAX functions in Power BI
- Worked on Calculated Columns, Measures queries in Power BI desktop to show good data analysis techniques
- Worked in SAP BW IS Utilities, supporting daily jobs and working on enhancements base up on the business requirements
- Worked in SAP BOBJ 4.x in supporting the daily schedules, created & supported Webi reports and enhanced existing Webi certified reports
- Worked extensively in connectivity to SAP BW through Power BI and SAP BOBJ
- Trained business users to execute the reports in Power BI and Webi reports
- Worked on Data definition specification and Source to target mapping while creating the SAP BW models and Power BI dashboards
- Extensively worked on SAP BW data issues and debugged the data models and fixed the issues
- Worked on increasing the performance of the BW schedules and enabled alert mechanisms
- Supported Budget loads on Weekly / monthly basis to the business in SAP BW & BPC
- Extensively worked on SAP BW process chains and worked closely with Basis on moving the schedules to Redwood scheduling server
- Industry: Medical & Healthcare devices
Report Developer
UnitedHealth Group Inc, UnitedHealth Group
01.2016
- Is an American for-profit managed health care company based in Minnetonka, Minnesota
- It is sixth in the United States on the Fortune 500
- UnitedHealth Group offers health care products and insurance services
- UnitedHealth Group is the largest healthcare company in the world by revenue $184 billion in, subsidiaries companies together serve approximately 115 million individuals in 2016
- (SAP BO /Tableau)
- Worked on state dashboards related to Health Insurance
- Worked on Tableau, SAP Business Objects (BOBJ) and SAP BI reporting applications for different segments of the Health care business
- Involved in planning, gathering requirements, design, development, enhancement, break fix and publishing of Business Objects reports and Tableau Dashboards
- Trained different teams & users on Business Objects (Universes, Web Intelligence, Web Rich Client) and Tableau applications and conducted hands-on sessions and monitored the progress
- Handled administrative tasks such as creating users and user groups, creating sites, managing security and server management both on Tableau 10 Business Objects and Data Services (CMS)
- Created and documented a list of tables, fields, joins, derived tables, hierarchies and filter prompts needed for the complete reporting
- Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
- Supported daily/ weekly/monthly data refresh in source and in dashboard
- Worked on new enhancements in dashboard as per the requirements
- Automated dashboards based on the requirements and trained users on how to analyze and view the dashboard
- Worked in Tableau dashboard both in desktop and in server to publish the dashboard in portal
- Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web
- Developed various data connections from data source to Tableau Desktop for report and dashboard development
- Involved in project planning, scheduling for database module with project managers
- Created new Data source and replaced with existed Data source
- Created Schedules and Extracted the data into Tableau Data Engine
- Environment: Tableau 10.x, MS SQL 2008, 2012, BOBJ 4.1,4.2 SP5,Windows 7/10, Management Studio,SAP ECC6.0 , BW 7.5, APO , EP
- Industry:
BW/BO Consultant
SAP
04.2022 - Current
- Requirement gathering sessions with business users from various departments like Billing, Inventory, SD & COPA
- Preparation of technical specification document, estimates, schedule, and training to end user’s
- Worked on design and implementation of data models and data flows to support reporting and analysis
- Scheduled the jobs, managed users and repositories in Management Console
- Extensively worked on HANA view performance improvement using Viz tool
- Worked with Basis on HANA patches and upgrade and verify the HANA system post release
- Worked on troubleshooting data issues in HANA and resolved
- Created multiple data store configurations in Data services local object library with different databases to create unified data store
- Designed and developed APD to move data from Query to DSO
- Worked extensively on administration workbench (RSA1), customized Info-Objects, Info Sources and Info Cubes
- Supported the Power BI dashboards for any data issues and scheduling issues
- Trained and supported users how to run the dashboards
- Monitoring of Info packages and analyzing the reasons for failures of
- Info packages
- Indexing, compression, roll up and db statistics of cubes has been done wherever required
- Developed process chains according to the dependencies for master data and transaction data
- Done scheduling and monitoring of the process chains and addressing issues of process chain failures
- Unit, Integration and regression testing has been done according to business standards and documented respectively
- Worked Pre/post system activity closely with Basis during Ramp down/up task
- Involved in creating few BEx and BOBJ reports for the project
- Excellent knowledge on Data Replication Techniques using SLT to Native Hana
- Developed Analytical, Attribute views and Calculation views for on Hana Studio to consume by BOBJ, Tableau and other third-party tools
- Extensively worked on migration of standard Info Cube and DSO to HANA Optimized Info Cubes and DSOs using Tcode ‘RSMIGRHANADB’
- Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements
- Providing dedicated support during Month end and Fiscal Period End Closing activities
- Housekeeping activities to reduce the size as much as possible
- Industry: Control & Automation
Abbott Laboratories
11.2019 - 01.2022
- Is an American multinational medical devices and health care company with headquarters in Abbott Park, Illinois, United States
- The company was founded by Chicago physician Wallace Calvin Abbott in 1888 to formulate known drugs; today, it sells medical devices, diagnostics, branded generic medicines and nutritional products.
Honeywell, Honeywell International Inc
08.2018 - 11.2019
- Is an American multinational conglomerate company that produces commercial and consumer products, engineering services and aerospace systems
- The company operates four business units, known as Strategic Business Units – Honeywell Aerospace, Home and Building Technologies (HBT), Safety and Productivity Solutions (SPS), and Honeywell Performance Materials and Technologies
- Role: SAP BW Support:
- Worked on BW production support activities for Orders and Billing
- Heavily worked on loading data to DSO’s and Infocubes on daily basis
- Worked on Process chains and monitored process chain’s supporting global environment
- Supported data issues in reports and fixed it by reloading and troubleshooting any transformation issues
- Supported BW security issues by investigating the roles and assigning it correctly
- Worked on BODS data loads for Non-SAP data loading to HANA BHP
- Worked on HANA calculated views and models for SPS & HBT SBG’s for Billing & Booking
- Worked on BOBJ 4.2 supporting UNX universe Webi reports and schedules for Billing and Booking Universes
- Worked on SAP Analytics on Cloud supporting dashboards and user setup and training
- Have experienced in BI Webi scheduling and Publications & In Tableau
- Worked on scheduling in Autosys jobs supporting globally across NA, EMEA & APAC regions
- Worked on Supporting ETL jobs to HANA and troubleshooting data issues for replication in SLT
- Worked on creating Calculated views specifically for master data and creating models on utilizing the master data views in models.
Health Care Insurance, Optum
07.2016 - 11.2017
USAA, The United
03.2016 - 07.2016
- Services Automobile Association (USAA) is a Texas-based Fortune 500 diversified financial services group of companies including a Texas Department of Insurance regulated reciprocal inter-insurance exchange and subsidiaries offering banking, investing, and insurance to people and families that serve, or served, in the United States military
- Role: SAP BO with HANA
- Responsible for technical analysis, design, development, and testing of data connections, universes, and dashboards/reports
- Review of functional requirements, performance criteria, and data consumption needs to complete the design of technical components
- Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning
- Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload to acquire the data into SAP HANA Data Mart
- Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
- Design and modification of Database objects related to reporting schema
- Design and development of relational universes using SAP IDT based on Sql server
- Created Universe on top of HANA calculation views and developed the webi reports and dashboards using IDT(Information design tool)
- Creation of test scenarios for report testing in Business objects
- Promotion and management of Business objects reports users using CMC
- Design and creation of security rights matrix in CMC and in universes
- Performance tuning of Business objects report queries and universes in conjunction with Webi reports
- Environment: SAP BW 7.3, Net weaver 06 , SAP ERP Central Component 6.0, SAP Enterprise Portal , HANA 1.0 SP3
- Industry: Pharmaceutical
Mechanical Engineering
HD Smith
02.2015 - 07.2015
- H
- D
- Smith is among the largest national wholesalers, providing services and solutions for manufacturers and healthcare providers
- Headquartered in Springfield, Illinois, the company has distribution facilities throughout the country, in all major markets.
Sr SAP BW/BOBJ Consultant
Boston Scientific
12.2013 - 01.2015
- BSC is a worldwide developer, manufacturer and marketer of medical devices whose products are used in a range of interventional medical specialties, including interventional radiology
- It has 12 manufacturing facilities worldwide and approx
- 24,000 employees worldwide
- ECRIB-WPA Project :
- Worked in eCRIB - WPA project as a SAP BOBJ consultant
- Involved in BOBJ project full life cycle management, responsible for requirement gathering, technical design, development and testing
- Developed Data stage Parallel Jobs Using Sequential file, Dataset, Sort, copy, Funnel, Remove Duplicate, Switch, Filter, Surrogate key, Transformer and Change Capture
- Used extensively Reject Link, Job Parameters, and Stage Variables in developing jobs
- Worked in Data Extraction, Transformations and Loading from Source to Target system using Data Stage Stages
- Development of Data Stage Jobs
- Worked on Data Stage client tools like Data Stage Designer, Data Stage Manager, and Data Stage Director
- Worked on data analysis in SQL to build schema in IDT 4.0
- I had worked on creating IDT Universe on top of SQL server
- Worked on creating Adhoc reports on top of IDT
- Worked on creating Webi complex reports like Material of Animal Origin (MoAO) and Device Material Assessment (DMA) reports
- Worked on maintaining the Parameters and List of values in IDT
- Worked on resolving loop issues chasm trap and fan trap issues using Aliases and Context
- Worked on creating formula variables, conditional formatting, sorting, breaking etc.
Mechanical Engineering
Nike
07.2013 - 11.2013
- Services project as a SAP BW/BO developer
- Worked on designing and creating DSO’s in MES project
- Worked on DTP’s & Transformations and on Semantic cubes & Multiproviders
- Worked on creating complex Bex queries like Management Yield & Task list yield report
- Worked on BOBJ 4.0 Web Intelligence reports using BICS connection
- Worked on creating Webi reports with summary level data with graphs in one tab and table in another tab
- Worked on tuning the performance on BW and even in BOBJ for Webi reports
- Worked on splitting the Bex query in two parts and moved all the CKF’s in the backend and increased the performance of the reports
- Worked on merge dimension in Webi based on Plant & Container & generated the reports
- Involved in Unit testing
- Environment: SAP BI 7.31, Netweaver 04, SAP ERP Central Component 6.4 EP4, SAP Enterprise Portal 6.0, BEx Analyzer, WAD and Windows 7, Business Objects 4.0, 4.1 SP4,IBM Data Stage 8.5
- Industry: Apparel & Footwear Solution, Nike, Inc
- (NYSE: NKE) is a major publicly traded sportswear and equipment supplier based in the United States
- The company is headquartered near Beaverton, Oregon, which is part of the Portland metropolitan area
- It is the world's leading supplier of athletic shoes and apparel[4] and a major manufacturer of sports equipment with revenue in excess of US$24.1 billion in its fiscal year 2012 (ending May 31, 2012)
- As of 2012, it employed more than 44,000 people worldwide
- Role: SAP BW
- Worked closely with analyst to analyze the flow of business requirements and prioritized them based of business impact, global usage and technical difficulties
- Coordinated with Development/support team and achieved the good customer satisfaction
- Created multiple BEx reports and designed complex Credit Webi reports using merge functionalities, input controls, hyperlinks etc.
- Designed standard template for web intelligence reporting with auto generation of user prompts and infoprovider details
- Interacted with Business Users and Managers in gathering business requirements
- Involved in the designing and Building of Universes, Classes and objects
- Created Standard Reports utilizing all the features on Web Intelligence in BOE 4.1 like Optional Prompts, Input controls, Functions, Alerters etc
- Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports
- Worked on Migration of Universes, WEBI reports and Dashboards from XI 3.1 to 4.0
- Deployed Dashboards and Webi Charts to Mobile devices like Ipad, Iphone etc
- Had experience working on Analysis for OLAP tools and Lumira
- Involved in SD Exposure complex Data model to support SD Reporting using custom data source
- Created SD Reports as a global report for broader audience with RRI functionality
- Created Custom Data models for Sales & Distribution using standard data source 2LIS_11_VAHDR,ITM & Schedule line
- Actively worked on Reporting performance optimization project to improve the BEx report, Webi & Dashboard Report run times
- Supported IS-Retail data for Retail ledger, Retail Material and Plant attributes data loads to the SAP BW retail cubes
- Built complex Dashboards with many charts on SD & Manufacturing areas with drill through functionalities and passing of user parameter capabilities within the dashboards and supporting reports
- Used BW Statistics and Query Monitor (RSRT) to understand the query performance and periodic deletion of OLAP Cache
- Worked on identifying the slow running reports and improved the report performance by changing the report settings, creating the variables on Characteristic restriction area etc.
- Built universes on HANA tables and views using Information Design Tool(IDT)
- Extensively worked with formatting the reports according to the user requirements
- Used Web intelligence to create, edit and set different options for the corporate documents
- Worked in support team as well and handled the high priority Remedy Incidents
- Worked very closely with both Business analysts & SAP functional team in understanding and resolving the tickets
- Worked on various enhancement projects and supported Go Lives and resolved production issues
- Worked with Basis team to implement the BW security for BW Finance reports
- Involved in building the standards for BO CMC folder, group, access levels etc.
Education
Bachelor of Science - Electrical & Electronics Engineering
Visveswaraya Technological University
Belgaum, Karnataka09.2004
Skills
Data Modeling Techniques
Python Programming
Infrastructure as Code
Tableau Software
Data Mining Techniques
Data Warehousing
Natural Language Processing
Predictive Analytics
Alteryx Platform
Data and Analytics
SQL and Databases
Workauthorization
Work Permit, Employment Authorization document (GC-EAD)
Personal Information
Title: Data Analytics Consultant
Languages
English
Full Professional
Telugu
Full Professional
Kanada
Native or Bilingual
Timeline
BW/BO Consultant
SAP
04.2022 - Current
SAPBI/BO/Power BI developer
Gwinnett
01.2020
Abbott Laboratories
11.2019 - 01.2022
Honeywell, Honeywell International Inc
08.2018 - 11.2019
Health Care Insurance, Optum
07.2016 - 11.2017
USAA, The United
03.2016 - 07.2016
Report Developer
UnitedHealth Group Inc, UnitedHealth Group
01.2016
Mechanical Engineering
HD Smith
02.2015 - 07.2015
Sr SAP BW/BOBJ Consultant
Boston Scientific
12.2013 - 01.2015
Mechanical Engineering
Nike
07.2013 - 11.2013
Data Engineer
Equal Force
Bachelor of Science - Electrical & Electronics Engineering
Visveswaraya Technological University
Similar Profiles
Laketa BanksLaketa Banks
Equal Opportunity Investigator / GS7 – GS11 at Equal Employment Opportunity CommissionEqual Opportunity Investigator / GS7 – GS11 at Equal Employment Opportunity Commission
Sherlyn FloresSherlyn Flores
Food Bank Americorp at Americorp Equal Heart @ El Pasoans Fighting HungerFood Bank Americorp at Americorp Equal Heart @ El Pasoans Fighting Hunger
Jeanne PangJeanne Pang
Equine Trainer/ EAL Facilitator at Equal ArkEquine Trainer/ EAL Facilitator at Equal Ark
Danielle FayeDanielle Faye
Radiation Therapist at Central Alabama Radiation OncologyRadiation Therapist at Central Alabama Radiation Oncology
Jeffrey N. SimcoxJeffrey N. Simcox
Plumbing Supervisor/Correctional Officer at Department of JusticePlumbing Supervisor/Correctional Officer at Department of Justice