Data Sap

GS DEEPTHI

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

SUMMARY:

. Having experience on various applications in SAP as BO Consultant and

as HANA Technical consultant.

. Have in depth knowledge of SAP HANA architecture.

. Experience in various source data replication mechanisms,

(ETL/Log/Trigger based).

. Experienced in designing the data modeling in different levels in

End2End SAP HANA solutions.

. Experience of Hana Studio to Create Attribute Views, Analytical views

and calculated views and using the SQL scripting V 2.0 in Calculation

Views.

. Experience with SAP HANA Data Provisioning and using SAP LT

Replication Server (SLT)

. Experience with Data Extraction Transfer Loading (ETL) using SAP BOBJ

Data Services 4.0

. Experience with SAP HANA Data modeling using Attribute View, Analytic

View and Calculation View

. Proficient in Business Objects tools - Universe Designer, Web

Intelligence.

. Expertise in Data integration, Data modeling, Extraction,

Transformations, Loading (ETL) and Scheduling ETL jobs using Data

Services 4.0.

. Experience in designing and building the Universe (business view of

the database), and updating the existing Universes, developing

canned/ad-hoc reports, scheduling the processes using Broadcast Agent

and administering the BO activities.

. Heavily worked with WEBI reporting and Web Application Designer.

. Proficient in resolving Join problems using Contexts and Aliases.

Created complex and Ad-hoc reports using slice and dice, drill down,

cross tab, multiple data-providers, multiple table/section and master

detail type reports.

. Worked with Transform types like Integrator, Quality and Platform in

BODS.

. Experienced in loading data into Hana Data base using SAP BODS from

SAP ECC and Used Data Services as an external system for ETL between

ECC and CRM for cleansing the data using Data Quality transforms like

Match, Associate, Address Cleanse and Data Cleanse Transforms for US

Data Cleansing in Data Quality.

TECHNICAL SKILLS:

SAP HANA 1.0, SAP BODS XI 3, Business Objects XI

Primary skills 4.0.

and reporting

Reporting: Web/Desktop/OLAP Intelligence, Designer,

BO UNIVERSE

DataBase Oracle 10g, MS SQL Server, SQL Developer, Sap hana

Management studio.

Systems and Tools

Languages/Web/Mob C, HTML, JAVASCRIPT

ile

ERP Tools Baan ERP Tools (3 tier architecture, 3 GL, 4 GL,

Embedded SQL, Dynamic SQL, Sessions, Forms, Reports,

DLLs, Data Export / Data Import etc.)

PROJECT EXPERIENCE:

Google India Pvt. Ltd., feb 11 to

august 12

Business Objects Developer

Google's brand is only as strong as the users' trust. For further analysis

of HR implementation like Payroll, Time Mgt, Employee Relations, Learning

& Dev,, Performance Appraisal.

Responsibilities:

Modeling

. Changed the settings through Modeler Preferences window

. Created Attribute, Analytic, Calculation views through graphical and

SQL Script methods

. Created 'Calculated Attributes', 'Calculated Measures', 'Counters',

'Variables', 'Input Parameters' in the views

. Created 'Level Hierarchies' and 'Parent Child Hierarchies' in

Attribute Views

. Performed client side import and export of information models

. Performed 'Mass Copy' and 'Mass Activation' of information models

. Created tables, views, joins, projections, aggregations, unions, unit

conversions and control structures of SQL Script.

. Performed Source System Analysis(OLTP). Analyzed the Source and Target

Data elements, created Mapping documents, Unit and System Test Plans.

. Designed and Debugged ETL process to extract data from Sources systems

(SQL Server, XML and Flat Files etc) using BODS.

. Transform as per business requirements and load the data into SAP HANA

database using SAP Business Objects Data Services (BODS) and SAP

Landscape Transformation (SLT).

. Gathering requirements and developing flexible universe reporting

solutions, working with the HR department and Community of Practice

(COP) to prioritize requirements and deliver reporting solutions.

. Developed Universe to meet the business requirement and report

requirement.

. On creating Universes using the Business Objects Designer and

connected to the different heterogeneous database like Oracle, SQL

Server.

. Created connections, complex joins; shortcut joins outer joins and set

the cardinalities.

. Created contexts and Aliases to resolve the loops problems in universe

and used derived tables to access the tables from other databases.

. Manage Universe and make changes to meet business needs.

. Used multi data providers from various sources.

. Created reports used with web intelligence and applied drill mode to

drill down the data.

. Developed multiple cross tab reports, charts and tabular reports in

web intelligence.

. Developed reports using Business Objects various functionalities like

Calculations, Sections, Breaks and Hyperlinks, Merging Dimensions

etc...

. Created hierarchies to bring out the unwanted object in drill mode and

used Scope of analysis in report level to drill up and drill down the

reports.

. Involved in Preparing Detail design Documents for Universe and

Reports.

. Formatted Reports as per client requirements using options like custom

sort, Alters, fonts, colors.

. Deployments done at various levels from development to test and pre-

prod using Import Wizard.

Environment: Business Objects Xi3, Xir2, Universe Designer, Business

Object, sap hana, QAAWS, Webi infoview, Webi Rich Client, SQL, and

Windows NT/XP Windows NT

Uniparts India, Vizag, India may

10 to dec 10

ERP Ln (Baan ERP) FP 7 implementation (& Customizations)

Customization Consultant (Technical)

Responsibilities:

. Worked as Technical consultant and involved in development using Baan

ERP tools.

. Developed below customizations:

. Purchase functionality for Supplier order tracking

. Goods flow integration customization for Subcontract orders

. Report development for Purchase order documents, Production order

documents, Shipment documents etc

. Responsible for User Interface designing, Data modeling, Application

Programming, Report Development in above customizations

. Worked as key developer in Data Migration from Uniparts Legacy systems

to Baan ERP Ln by using Import / Export utilities and by using file

handling

Environment: Designing Skills, 3GL, 4GL, Embedded SQL, Dynamic SQL,

Performance oriented Programming, Sessions, Forms, Reports, Tables, DLLs,

DAL, Data Export / Data Import utilities, File Handling

EDUCATION:

. Bachelor of Technology (B.Tech) in Information Technology from JNTU,

India.

. Trained in RDBMS

Contact this candidate