CHITRA PARYANI
actpyf@r.postjobfree.com
SAP Certifications:
SAP Certified Application Associate(Edition 2015) - SAP HANA (C_HANAIMP141)
SUMMARY
SAP HANA Certified Consultant with more than 7.5 Years of SAP BW Experience along with SAP HANA implementation expertise.
SAP HANA:
Good understanding of the complete Architecture (Data loading, Data modeling & Reporting).
Expert in creation of Analytical and Attribute Views and complex models by using Procedures.
Created Analytical Privileges and Procedures for modeling
Good understanding of various components of SAP HANA.
Working knowledge with SAP BO Data services & SLT replication methods.
SAP BW:
Experienced in designing solutions and developing technical specifications based on functional requirements.
Expertise in Data Loading (Full/Delta Up-Load) of Master and transactional data from SAP R/3(LO and Generic Extraction) and Flat files.
Data Modeling using Write- Optimized DSO (for staging), Standard DSO, Infocubes, SPOs, Multiprovider, Infosets.
Worked on performance tuning aspects like creating aggregates, indices, Repartitioning and compression of cubes.
Extensive experience in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, BEX analyzer.
Worked on Creating APD’s and Open Hub Destination.
Worked on Creating and modifying Users, roles.
Analyzing authorization issues.
Worked on BI Security & having Basic Administration knowledge.
EXPERIENCE
Company: Tata Consultancy Services
Duration: Aug 2015 till Present
Project: Ericsson
Role: SAP HANA Developer
Project Overview: Order to Cash [O2C Visibility] project in Ericsson is to replace QlickView with SAP BO Dashboard and ‘Pangea Core Data Base’ with SAP HANA.
Objectives:
Migrate PANGEA Ordering & PANGEA Invoicing Database & Application Servers to Global Landscape.
Build PANGEA Core Database on HANA
Integrate PANGEA Ordering, PANEGA Invoicing & PANGEA Core with the Source Systems
Build Dashboards
Role:
Designed, Developed and debugged various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
Designed and implemented SAPHANA data model :
oCreated Analytic Views for Purchase Orders, Sales Order, Billing View, Contract View, and Information Traceability.
oCreated View for Region, Customer Unit, Key Account, Customer group, Bill to for Master data.
oCreated Calculation view for Sales flow (Graphical, Script view using CE functions).
Data is extracted from Pangea Ordering system. The Extraction approach is Via BODS. Tables and data replicated into HANA landing layer (3 Schemas are used to represent 3 layers into HANA i.e. Landing, Staging, Atomic).
HANA Views are built using Atomic tables.
Worked on Currency Conversion based on the input parameter provided by the user.
Worked on Calculated columns for extracting Year, Month, Day, Quarter, Week.
Applied filters for restricting data for 5 years.
Involved in SAPHANA Security including User Management, Roles, and Privileges
Reporting – Accessing Analytical and Calculation views from MS EXCEL.
Company: Accenture
Duration: July 2014 – June 2015
Project: Carlton Crystal
Role: SAP HANA Developer
Project Overview: Carlton Crystal Project is to built Crystal reports from SAP ECC Via BODS.
Role:
Extracted tables, data via BODS.
Created Universe via IDT tool.
Build Finance crystal reports for Company showing Current year, last year, Current month, and last year month’s Revenue Comparison data.
Company: Accenture
Duration: Dec 2012 – June 2014
Project: Arcelor Mittal
Role: SAP BI/BW Developer
Project Overview & Scope: The project involved SAP BW reporting of FI, SD, MM Data
Role:
Involved in planning sessions with project managers to analyze requirements and outline the solution.
Involved in configuration of BW Objects like Info Cubes, Data Source, and Data Store Objects.
Worked on LO and Generic extraction for full and delta loads.
Performed Data reconciliation (ECC to BW side) and Unit testing for full flow.
Worked on BEx Query Designer, Calculated and Restricted Key figures, Exceptions and Conditions.
Worked on APD’s, Open Hub’s, InfoSpoke and RSCRM_BAPI.
Involved in Performance Tuning of Cubes and Reports using Aggregates, Indexes, Partitioning, Compression
Company: Accenture
Duration: Oct 2011 – Nov 2012
Project: Entergy
Role: SAP BI/BW Developer
Project Overview & Scope: The project involved SAP BW reporting based on FICA module.
Role:
Involved in mini project for performing archiving of data for 10 years.
Involved in daily, monthly, yearly activities.
Worked on solving incidents, Enhancements.
Involved in Performance Tuning of Cubes and Reports using Aggregates, Indexes, Partitioning, Compression
Worked on HPQC tool for testing Scripts after migrating system.
Company: Accenture
Duration: Dec 2010 – Sep 2011
Project: CIO
Role: SAP BI/BW Developer
Project Overview & Scope: The project involved SAP BW reporting and planning using SAP Integrated planning for Finance data.
Role:
Involved the change management process in analyzing converting an incident to enhancement
Performed roll up activities, and Compressing the infocube to improve query performance.
Maintained Aggregates and Indexes for Info Cubes to improve performance.
Worked on BEx Query Designer, Calculated and Restricted Key figures, Exceptions and Conditions.
Monthly, weekly and Daily schedules of Data Loads.
Loading of flat files
Worked on solving incidents, Enhancements
Involved in configuration of BW Objects like Info Cubes (Standard & Real time), Data Source, and Data Store Objects, Multiprovider.
Company: Accenture
Duration: Aug 2008 – Nov 2010
Project: BHPH
Role: SAP BI/BW Developer / SAP Security Developer
Project Overview & Scope: The project involved SAP Security, BI Security and HR Security, SAP BI
Role:
Worked on Solving incidents, Enhancements.
Worked on Daily, Weekly, Monthly activities.
Worked on solving Process Chain related issues within SLA.
Worked on LO Cockpit & Configured DataSource, InfoSource, PSA, InfoPackage, DSO, Cube, MultiProvider, Reports.
Creation of Users and maintain Authorizations Profiles.
User locks and password maintenance.
Proficient in troubleshooting and handling user issues.
Experience in working with Transports (STMS) in transporting roles between Development, QAS and Production R/3 systems and users.
Experience in SAP HR Security using position based Security.
Very good knowledge of producing and analyzing reports in SAP using SUIM, and security related tables (AGR*, USR*, etc.), and customized Query reports.
Extensive experience with resolving ticket issues and troubleshooting security authorization problems while adhering to Service Level Agreements (SLA).
Set up security by Info Area, Info-Cube, Info-Object, QUERY and WORKBOOKS.
CERTIFICATION
SAP HANA Certified
SAP HANA Certified (TCS Internal Certification Program)
ITIL Certified
EDUCATION
Bachelor of Science, Information Technology May 2008
Smt. C.H.M College, Mumbai
SKILLS
SAP : SAP BI 7.0, SAP BW 3.5, SAP HANA
ERP : SAP ECC 6.0
Operating systems : Window 95/98/2000/XP, 2000/2003 Server
RDBMS : Oracle, MS-SQL Server 2000/2005, MS Suite
Tools & Utilities : BODS, SLT
Reporting Tools Languages : SQL