Sap Data

Sabina Chaulagain

Phone: 732-***-****/732-***-****

Email: ******.*******@*****.***

PROFESSIONAL SUMMARY:

●Over 6 years of experience in all the phases of Software Development Life Cycle (SDLC) using SAP HANA, SAP Business Intelligence (BI) / Data warehousing (BW) and SAP Business Objects.

●3+ years of experience in SAP HANA Modeling, Data Provisioning & Reporting using SAP Lumira.

●Competent professional with 3+ years of experience as a SAP BOBJ 4.1/4.0/ XI 3.0/ 3.1.

●Experience in define Design Documents for HANA Models (Information Views), Security Management including User Roles and Privileges.

●Extensively worked to create Attribute View based on Master Data, Analytical View based on measures & attribute view, Calculated View based on combination of tables, column views, Attribute Views and Analytic Views.

●Experience in Calculation Views (Graphical and SQL Script Using CE Functions) by creating joins, unions, projections and aggregation levels based on the business logic.

●Experience in Developing Stored Procedures using SAP HANA SQL-Script - CE Functions & SQL Script Debugging.

●Experience on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Packages, Table definitions, Attributes (Simple, Calculated, Local), Measures (Simple, Calculated, Restricted, Counters) and Hierarchies, Input Parameter, Variables, Data Foundation, Semantics, Performance Analysis etc.

●Extensive knowledge in Displaying Audit Trails of Information Models, Export/Import of Models, Activating Impacted Objects, Checking Model References, Comparing Object Versions.

●Experience to set Modeler Preferences like Case Restriction on attribute view, analytic view, calculation view, procedure and Field Name Preferences, specify a location for job log files.

●Experience on import SAP Net Weaver BW models - InfoCubes, Standard DataStore Objects, Query Snapshot Info Providers and Info Objects of type Characteristics to SAP HANA modeling environment.

●Experience in Data Provisioning Using Trigger-based replication (SAP Landscape Transformation (LT) Replication Server), SAP HANA Direct Extractor Connection (DXC) and ETL-based replication (SAP DATA Services - BODS).

●Experience in data provisioning using SAP BODS to HANA from a SAP and Non-SAP Sources like Microsoft Server Environment.

EDUCATION:

Bachelor's in Business Management Studies

TECHNICAL SKILLS:

OLAP Tools

SAP Business objects 4.0, Web- Intelligence, Info view, BO Excel Analysis

ETL Tools

BODS 4.1 & OWB

Databases

SAP HANA DB, SQL Server

Programming Languages

C/C++, SQL

Web

HTML & DHTML

Operating Systems

OSX, Microsoft Windows XP, SUSE Linux

Data warehousing tools

SAP BI 7.0

Reporting Tools

Universe Design Tool (UDT), Information Design Tool (IDT), Web Intelligence (WebI), Crystal Reports, Dashboard, SAP Lumira

PROFESSIONAL EXPERIENCE:

Barclays, New York, NY Jan ‘14 – Till Date

Role: SAP HANA Consultant

Description: Barclays is a multinational banking and financial services company. It is a universal bank with operations in retail, wholesale and investment banking. It deals in wealth management, mortgage lending and credit cards. The company is structured within business clusters like Corporate and Investment Banking, Wealth and Investment Management and Retail and Business Banking.

Responsibilities:

●Involved in writing the technical specifications, standard modeling and Implementation, documentation for HANA.

●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.

●Migrated HANA content from development, testing environment to Production environment using Delivery Units.

●Gathered and analyzed the requirement to replicate the ECC content in HANA using the Real-time SLT Process.

●Involved in ETL Based replication to provision the data from SAP ECC to HANA system through BODS.

●Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).

●Reconciled the data with the existing BW Reports with the new HANA Models.

●Created Calculation Views using database tables, attribute views, analytic views and created SQL Script based calculation views.

●Called the Calculation View to BOBJ 4.0 IDT Tool to create Universes.

●Created the Visualization Reports in SAP BOBJ Explorer 4.0 based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces.

Environment: SAP HANA 1.X, BOBJ Lumira 4.0, BOBI, SAP ECC, SQL.

Mondelez Inc. (formerly Kraft Foods), Chicago, IL Jul ‘12 – Dec ‘13

Role: SAP HANA Consultant

Description: Mondelez is an American multinational confectionery, food and beverage conglomerate. It comprises the global snack and food brands of the former Kraft Foods Inc. The company is headquartered in Deerfield, Illinois (a Chicago suburb) and is a manufacturer of chocolate, biscuits, gum, confectionery, coffee and powdered beverages.

Responsibilities:

Created the necessary Calculated Attributes, Restricted Measures, Calculated Measures and Input Parameters using the HANA studio tool.

Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.

Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.

Understanding the existing SAP BW Models and documenting the business flows in SAP HANA.

Developed the Attribute Views based on Master Data Tables in the SAP ECC.

Developed the Analytic Views based on Transaction Data Tables in the SAP ECC for SD, FSCM, CO modules.

Created the Analytic Views based on the Info cube models in SAP BW/BI system.

Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins based on the business logic.

Worked on designing SAP BW data Flows (DSOs, Transformation and DTPs) in the BW (on HANA database) Scenarios and imported the DSOs, Info cubes to the HANA studio tool.

Created Security for the BOBJ reports for the business users.

Environment: SAP HANA 1.X, Business Objects Data Services 4.0, BO BW/BI, SAP ECC, MSTR.

Nationwide Mutual Insurance Company, Columbus, OH Oct ’10 – Jun ’12

Role: Business Objects Consultant

Description: Nationwide Mutual Insurance is a group of large U.S. Insurance and Financial services companies based in Columbus, OH. The company is recognized as one of the largest companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments.

Responsibilities:

●Designed universes named Accounts Payable, Purchasing and Capital Projects using Oracle 10g/11g, Teradata 13.

●Converted DESKI reports to WEBI reports using Report Conversion Tool as per business user’s needs.

●Involved in heavy interaction with the Business Analysts in the process of gathering Reporting requirements, preparing specification documents and report writing.

●Created many WEBI reports like Balance Sheet, Profit and Loss Statements, G/L Balance, and Statement of Cash flow reports with high complexity.

●Converted few existing WEBI reports to Crystal reports to overcome the limitations of output data rows in WEBI.

●Developed Crystal Reports on top of Universes, SAP ECC and Oracle. Implemented row level security in the crystal report using the security table and Current CE User function.

●Scheduled and published WEBI and Crystal Reports using Info view, and trained users on creating reports.

●Developed Xcelsius Dashboards with multiple selector components and Bar/Pie charts for MTD, QTD and YTD data comparison. Used Live Office to import data from necessary WEBI and Crystal reports.

●Administered and supervised the Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.

●Migrated all the developed reports from Business Objects development team to test and then test to production using LCM (Life Cycle Manager).

Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Server Reporting Services 2008, SSAS 2008, SQL Server Management Studio, T-SQL, Performance Point Server.

Reliance Group, Hyderabad, India Sep ’09 - Sep’10

Role: Business Objects Developer

Description: Reliance Group is among India's top private sector business houses serving over 250 million customers across Telecommunications, Power, Financial services, Infrastructure, Media, Entertainment and Healthcare sectors. Through its various consumer-facing businesses, the Group offers state-of-the-art products and services.

Responsibilities:

●Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

●Interacted with Users, Managers, and Business Analysts for understanding the business logic and also interacted with technical leads to understand the Database.

●Created Universes by retrieving the data from data base, defining the connections necessary, complex formulas and generated various reports.

●Involved in writing detailed level documentation for Reports and Universe design.

●Used @prompts in the Universe to create user interactive condition objects.

●Built Full Client reports using Business Objects reporting module according to end user requirements.

●Converted the existing full client reports to WebI reports using Report Conversion Tool.

●Created various types of reports such as Drill Reports, Cross Tab Reports, Standard Reports and Master Detail Reports.

●User/System documentation, user training and testing developed reports for final deployment.

●Performance tuning of Business Objects reports including testing and modification of universe objects as required.

Environment: Business Object XI R2, Central Management Console XI R2, Designer XI R2, Web Intelligence XI R2, Crystal R2, Oracle, SQL, PL/SQL, MS Access, MS Excel.

Contact this candidate