Harikrishna Alla
- SAP BW / BO Consultant
- Thousand Oaks, CA
- Member Since Apr 02, 2023
Candidates About
Harikrishna Alla
Professional Summary
· Having 10.6 years of experience in IT industry, with 8 years of in SAP Business Intelligence and 2 years in Microsoft .NET and Software Testing
· Experience in Implementation, Support, Maintenance & Development
- Involved in Analysis, Design, Development, Testing, Implementation and Support phases of the Projects for both SAP BI and Microsoft .NET
· Extensively worked on Info Cubes, DSO Objects, Info Objects, Info Sources, Data Sources, Transformations, DTP’s, Multiproviders, Transfer rules and Update rules
- Good Knowledge in Generic extraction and LO Extraction
- Extensively worked on Web Analyzer and BEx Query Development for Reports creation.
- Experience in handling the Business Objects modules Designer, Web Intelligence, Central Management Console and InfoView
· Good Knowledge in handling the Business Objects modules Designer, Web Intelligence, Crystal Reports, Central Management Console and InfoView.
· Good knowledge in Creating Analytical, Calculation and attribute Views and generate reports in Business objects with reference to HANA.
· Good knowledge with all the Data Provisioning techniques (SLT, DXC, and SAP BODS), Modeling constructs (Attribute, Analytic, and Calculation) and Reporting solutions (BOBJ Suite of tools) with SAP HANA information models as a source.
· Good knowledge in Universe designing, developing and generating complex, Adhoc Reports, Business views, List of values, reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. SME in Dashboards, Best Practices in Dashboard Design, KPI Formulation & Web Reporting, developing information spaces and exploration sets in BOBJ
· Good analytical, problem solving, communication skills.
Technical Skill Set
ERP Packages : SAP BW 7.0, 7.3, 7.4, ECC 6.0
Business Intelligence Tools : SAP Business Objects (WebI, BO Explorer, Crystal reports Enterprise)
Data Visualization : BO Explorer, Lumira, Design Studio
ETL Tools : BODS 4.2
Data Replication Technique : SLT, DXC
Databases : SAP HANA 2.0, Oracle 9i, SQL Server 2005
Microsoft Technologies : .NET 2005, C#
Programming Languages : ABAP/4-BW (Beginner)
Education
· Bachelors Degree (B.Tech) from Jawaharlal Nehru Technological University(India)
Trainings
· SAP BI7.4 on HANA
· SAP Business Objects 4.0
· HANA hands on workshop by CoE
· BIG Data Insight
· SAP BPC 10.0
· SAP BODS 4.2
Assignment Summary
Project : AMGEN_RUN
Client : AMGEN (Biopharmaceutical),
Location : Thousand Oaks, CA
Role : SAP BW, BO Consultant
Environment: SAP BI7.4, BO 4.0, HANA, BODS
Project Type : Application Maintenance
Duration : July 2015 to till date
Description:
American multinational biopharmaceutical company headquartered in Thousand Oaks, California. Amgen is the world's largest independent biotechnology firm. Company’s largest selling product lines were Neulasta/Neupogen, two closely related drugs used to prevent infections in patients undergoing cancer chemotherapy; and Enbrel, a tumor necrosis factor blocker used in the treatment of rheumatoid arthritis and other autoimmune diseases. Other products include Epogen, Aranesp, Sensipar/Mimpara,
Nplate, Vectibix, Prolia and XGEVA.
Responsibilities:
- Handling priority/problem tickets/incidents/ housekeeping activities
- Monitoring and Scheduling process chains.
- Handling RFC’s through Service now tool
· Building Business Objects reports on HANA modeling constructs(analytic, Attribute & Calculation views)
· Functional verification activities of Development, Quality and Integration systems
Project : STATOIL
Client : STATOIL (Oil & Gas)
Location : India
Role : SAP BI, HANA Consultant
Environment : SAP BI7.0, BO 4.0, HANA, IP, BPC 10.0
Project Type : Application Maintenance
Duration : Jan 2014 to June 2015
Description :
Multinational oil and Gas Company headquartered in Stavanger, Norway. Fully integrated Petroleum Company with operations in thirty-six countries. By revenue, Statoil is ranked by Forbes Magazine (2013) as the world's eleventh largest oil and Gas Company and the twenty-sixth largest company, regardless of industry, by profit in the world. The company has about 23,000 employees. Statoil was formed by the 2007 merger of Statoil with the oil and gas division of Norsk Hydro.
Responsibilities:
- Involved in Statoil BW transition from IBM to CapGemini
- Handling priority/problem tickets/incidents/ housekeeping activities
- Monitoring and Scheduling process chains.
- Handling RFC’s through Service now tool
- SAP process area’s involved SD,CRM,HR, Treasury & Payments, Accounting & Controlling, Plant O&M
- Business Objects reports on HANA modeling constructs(analytic, Attribute & Calculation views)
Project : PES_BW
Client : Philadelphia Energy Solutions (Energy Oil & Gas)
Location : India/ Philadelphia, PA
Role : SAP BI Consultant
Environment: SAP BI7.3
Project Type : Implementation
Duration : June 2013 – December 2013
Description:
Philadelphia Energy Solutions is committed to delivering extraordinary value to customers, suppliers, employees and the community by efficiently refining and producing high-value, quality products. The refinery processes approximately 335,000 barrels of crude oil per day (42 U.S. gallons per barrel), making it the largest oil refining complex on the U.S. Eastern seaboard. PES is owned by The Carlyle Group and a subsidiary of Energy Transfer Partners
Responsibilities:
- Involved in designing technical specification document for PES_BW
- Involved in build phase of the project
- Developed BI data flows using FLAT file extraction
- Responsible for creation of test scripts and documentation
- Involved in Data Loading & Process chain Monitoring
- Involved in unit testing, test case reviews and documentation
Project : ISPA (INDIRECT SPEND PROJECT ACCOUNTING)
Client : Target (Retail Giant)
Location : India
Role : SAP BI Consultant
Environment: SAP BI7.3,BOXI R3
Project Type : Implementation & Support
Duration : December 2012 - June 2013
Description:
Target Corporation is the second-largest discount store retailer in the United States, behind Wal-Mart, and a component of the S&P 500 Index. Founded by George Dayton and headquartered in Minneapolis, Minnesota.
Responsibilities:
- Involved in requirements gathering, designing technical specification document for Project Systems Module
- Involved in BUILD phase and UAT phase of Project Systems Module(Master Data and Transaction Data)
- Responsible for creation test scripts and documentation
- Involved in planning and co-ordination of tasks
- Involved in Report testing, test case reviews and documentation
- Involved in unit testing, test case reviews and documentation
Project : British Gas Data Warehousing
Client : Centrica (British Gas & Energy)
Location : India
Role : SAP BI Consultant
Environment: SAP BI7.3,BO (WEBI), BODS
Project Type : Implementation
Duration : June 2012 – December 2012
Description:
Energy and Services Company. Focused on satisfying the changing needs of our customers. Parent company of British Gas, multinational utility company with its headquarters in Windsor, Berkshire. Its principal activity is the supply of electricity and gas to businesses and consumers in the United Kingdom, the Republic of Ireland and North America.
Responsibilities:
- Involved in designing technical specification document for British Gas and Dataware House
- Involved in build phase of BGDW (Master Data and Transaction Data)
- Developed BI data flows using LSA methodology
- Involved in enhancing CRM & ISU datasources
- Responsible for creation test scripts and documentation
- Involved in Data Loading &Process chain Monitoring
- test case reviews and documentation
- Involved in unit testing, test case reviews and documentation
Project : Fossil 7.3 Upgrade
Client : Fossil (Lifestyle brands)
Location : India
Role : SAP BI Consultant
Environment: SAP BI7.3
Project Type : Upgrade (sap 7.0 ->7.3)
Duration : December 2011 – May 2012
Description:
Fossil Group, Inc. is an American fashion designer and manufacturer founded in 1984 by Tom Kartsotis and based in Richardson, Texas. Their brands include Fossil, Relic, Abacus, Michele Watch & Now Coach NY, Skagen Denmark, and Zodiac Watches. Fossil also makes licensed accessories for brands such as Adidas; Emporio Armani; Karl Lagerfeld; Michael Kors; Marc by Marc Jacobs; Burberry; DKNY; Diesel; and Armani Exchange.
Responsibilities:
- Involved in requirements gathering technical pre-upgrade and technical post-upgrade activities
- Responsible technical pre-upgrade and post-upgrade activities
- Responsible for creation test scripts and documentation
- Involved in planning and co-ordination of tasks
- Co-ordination in India with respect to testing
- Involved in unit testing, test case reviews and documentation
Project : Recap Statements
Client : Vodafone (Telecom)
Location : India
Role : SAP BI Consultant
Environment: SAP BI7.0, ECC 6.0
Project Type : Implementation & Support
Duration : Feb 2011 – Nov2011
Description:
Vodafone Group plc is a British multinational telecommunications company, with headquarters in London. It predominantly operates services in the regions of Asia, Africa, Europe, and Oceania. Among mobile operator groups globally, Vodafone ranked fifth by revenue and second (behind China Mobile) in the number of connections (435.9 million) as of 2014.Vodafone owns and operates networks in 26 countries and has partner networks in over 50 additional countries.
Responsibilities:
· Interacting with Business Analysts for Requirements Gathering and clarifications. Provided the weekly status update on Project Progress.
- Created Cubes, DSOs, Multiproviders, Infoset, Transformations, InfoPackages and DTPs.
- Involved in implementing logic at Start Routine level
· Created Process Chains for automating data load process
· Created Open hub for extracting data from info cube into Flatfile/table.
- Involved in developing Interaction Analysis Queries using Restricted Key figures, Calculated Key figures, Filters, Free Characteristics, and Variables.
- Worked on Report to report interfaces(RRI) to drilldown to detailed Report
- Involved in Transportation of all Objects like: InfoObjects, Query’s and DSO objects, Routines, Programs, etc. into BI test system after validation and testing the same in development.
· Prepared Project documents like Transport Checklist, Go-Live check list, Support document and Provided the Support Training to the Support Teams
· Created Unit Test Cases and Performed Unit testing
· Extensively Involved in System Testing and User Acceptance Testing
Client : Vodafone (Telecom)
Location : India
Role : SAP Consultant
Environment: SAP ECC 6.0
Project Type : Support
Duration : Jan 2010 – Jan 2011
Responsibilities:
Managed and created parameterization for KMAT material type and Points and contract type based on Sales organization/Distribution channels for below transaction conditions
ZEC0 - Create Ecovalor tax condition
ZPR0 - Create Price Telecel condition
ZPRN -Create Negative price condition
ZDEM – Create Manual discount condition
ZCOM - Create commission condition
ZMDP – Create max.allowed discount condition
ZDEP – Create discount condition
ZDES – Create discount Telecel condition
ZDPN – Create Loyalty points discount condition
ZDPC – Create Loyalty contract discount condition
Project : UFE (UNIFIED FRONT END)
Client : Vodafone (Telecom)
Location : India
Role : Application Developer
Environment: C#, WINDOWS APPLICATION, SQL SERVER 2005
Project Type : Development
Duration : March 2007 – Dec 2009
Description:
The unified Front End (UFE) has been built as a unique interface for Vodafone stores and customer care services. The Legacy System which existed prior to UFE used Siebel and SAP applications to support Call Centre and Stores activities. These applications even when optimized were not process oriented, not allowing the optimal service time for repetitive easy operations, implicating substantial training period and requiring extensive software licensing.
The main objectives behind the creation of UFE are:
- To have a single interface which can be customized according to the user profile
- An interface which is independent of backend systems (Smart Client)
- Easy to use (reduced training for users and short handling time)
Responsibilities:
- Creation of (HLD) High Level Document from the Feasibility document
- Involved in preparing Detailed Design Document(LLD)
- Preparing Unit Test Plan and Unit Test Result document
- Decision making on UI design of new applications; Suggesting changes to customer
- Coding of the functionality from the Detailed Design Documents(LLD) document
- Database related activities and implementation
- Preparing Release Notes using open source software Wiki
- Writing scripts for database related changes
- Developing Windows Services, Web Services
Project : Safekeeping
Client : Royal Bank of Canada (Banking - CANADA)
Location : India
Role : Developer
Environment : C#, ASP.NET, SQLSERVER 2000, JAVA SCRIPT
Duration : July 2006 – Jan 2007
Description:
RBC is a Canadian multinational financial services company and the largest bank in Canada. The bank serves over 16 million clients and has 80,000 employees worldwide. The company corporate headquarters are located in Toronto. RBC Bank was the U.S. banking subsidiary with 439 branches across six states in the Southeast, which served more than a million customers
Responsibilities: Designing UI, Coding, Unit Testing.
- Safekeeping is banking project to generate fee file for specific range of Canadian regions. Ontario, International and Quebec
- Developed on OPS Tools framework and modules are Excluded Accounts,Feefile Generation,TaxMaster,Confirmation Page ,Fee file Generation Report.
- OPS Tools framework is designed with XML and WEB SERVICES using YDO0_DEV (sqlserver) as Database.
- Work flow of project: UI interface is user controls
- Excluded Accounts screen will display the previously excluded accounts, at the same time we can include these accounts for fee file generation.
- From Account Filtration page/Fee file generation page list of accounts are checked/unchecked with available checkboxes.Feefile will be displayed on Confirmation Screen as well as you can generate PDF report.TaxMaster which updates tax details GST,QST,HST for Ontario, International and Quebec regions