Prathyusha N

acn1gn@r.postjobfree.com

Phone Number: 513-***-****

CAREER SUMMARY:

. Knowledge in SAP Business Objects (Enterprise) 4.0 such as Web

Intelligence, Semantic Layer (Universe Designer) and Data Integration

(Data Services) 3.2, 4.0 and SAP Dashboards (Xcelsius 2008).

. Strong knowledge of SAP Business Objects Data Services tool

. SAP Certified Application Associate - HANA 1.0.

. Good understanding of the SAP HANA architecture. Ability to migrate data

from various sources into HANA using SAP Data Services.

. Knowledge of SLT Replication.

. Setting up and creating Data Models in HANA and generation of reports and

dashboards.

. Sound understanding of end to end Data Migration process including

Extraction, Data Profiling, Transformation and Generation of Load ready

data files in LSMW format

. Ability to interpret, configure and implement data mapping /

transformation business rules into Data Services

. Performed SAP Data Migration by using Business Objects Data Services as

the ETL tool

. Ability to install Data Services 3.2, Data Services 4.0, Information

Platform Services, and Information Steward.

. Experience in installing and using AIO (All In One)/BPDM templates in

Business Objects Data Services

. Experience in Data Quality module of Data Services. Extensively used

Match-Merge transform to perform customer address cleansing against USPS

address directories.

. Experience in building and managing Universes, creating Complex, Ad-hoc

Reports and/ or Charts using Business Objects.

. Created and modified the WEBI Reports for various Plant, Notifications

and Order groups using the Universe as a main data provider.

. Automated document Scheduling, Publishing and Distribution for WEBI.

. Sound knowledge of various transforms of Data Services like Query,

Validate, Case, Match, and Key Generation transforms.

. Strong knowledge of Object Oriented Programming (OOPS) and Object

Oriented Design (OOD) concepts.

. Analysis of WEBI, conducting studies on WEBI and Implementation of

reports.

. Experience in database development, administration, database design, and

support of oracle in development and production environment.

. Self starter and well disciplined Experience in teaching and research

work Excellent written and oral communications skills as well as

analytical skills.

Technical Skills:

Operating System: UNIX, Solaris, Linux, Windows NT

Languages: SQL Script, PL/SQL, T-SQL,C++,Java

Web: PHP, HTML, CSS, Adobe Flex 3.0, and Dream

viewer.

Databases: SAP HANA, MS SQL Server 7/2000/2005/2008,

Oracle

8i/9i/10g

ERP: SAP

ETL Tools: Data Services 4.0 Information Steward

Reporting Tools: Business Objects 4.0, 3.1/3.0-(Information

Design

Tool, Universe

Designer, Web Intelligence, Info View,

CMC, WEBI),

Xcelsius 2008, Dashboards 4.0

Experience/Project Work

Duration: Sept 2013 - current

Industry: Crawford & Co (Insurance), Lake Zurich, IL

Project Description/Scope:

Based in Atlanta, Georgia, Crawford & Company (www.crawfordandcompany) is

the independent provider of claims management solutions to the risk

management and insurance industry as well as self-insured entities, Based

in Atlanta, Ga., Crawford & Company is the world's largest independent

provider of claims management solutions to the risk management and

insurance industry as well as self-insured entities, with an expansive

global network serving clients in more than 70 countries.

Role: Data Migration Admin/Consultant

Responsibilities/Deliverables:

. Involved in gathering, analyzing, and

documenting business requirements, functional requirements and data

specifications for about 200 Business Users.

. SAP BI Administrator managed Users, Groups, Securities, Folders and

Connections.

. Administered BO platform through CMC.

. Develop batch jobs in SAP Business Objects Data Integrator/Data

Services 4.0 (BODS) and Maintenance of the System.

. Identify, analyze issues in client requirements, application systems &

architecture and design specifications.

. Perform functional and technical testing (System Integration Testing,

Data Integration Testing, Performance Testing, User Acceptance

Testing, Reconciliation Testing/Audit).

. Coordinate problems, issues, risks in the team, functional and

management for resolution, analysis on their side and decisions.

. Seeing and documenting if the business process requirements was

complied or according to the client requirements (provide reports on

project deliverables whether it is open, closed, re-open, in-progress,

or assigned to other team).

. Knowledge transfer and provided documentation.

. Develop Information Steward Cleansing Package Builder (CPB) and

cleansing it in Data Integrator or Data Services (Data Quality/Data

Cleanse).

. Configured and trained junior consultants for optimal performance as

well as SAP Tools such as BODS and Information Steward.

. Business Objects Installation and Configuration.

. Provide support and other tasks may be required.

. Develop reports using BI Launch Pad(Web Intelligence and etc) [BOE

3.1, SAP Business Suite 4.0 and 4.1]

. SAP Business objects Administration(CMC)

. Create Reports on different Business Objects Tools: Web Intelligence

and Xcelsius.

Duration: Aug 2011 - Aug 2013

Industry: Vesta (Oil & Gas Industry), Vernon Hills, IL

Project Description/Scope:

Vesta - EAM Maintenance Data and System Assessment

The Vesta system assessment is a site-based consultation which involves

exploration of SAP implementation, maintenance, and business practices, all

centered on the PM module and maintenance. Vesta will be providing strategy

consulting, implementation analysis, and

best practices suggestions pertaining to Enterprise Asset Management (EAM)

processes while we will analyze a sample of equipment and material data.

Role: Data Migration Consultant

Responsibilities/Deliverables:

. Developed EAM Maintenance Data and System Assessment Business Rules

provided by Vesta using complex validations in Data Services 4.0.

. Designed new Universes and modified the existing Universes based on

the business requirements.

. Created new events, folders, profiles, users and group in CMC.

. Created User Objects including Dimensions, Details and Measures.

. Created Dashboards for SAP Enterprise Asset Management (EAM)

implementation specifically in the PM using various components of

Xcelsius.

. Developed several complex Xcelsius Dashboards with high visibility

within Plant Maintenance processes(on Plant type, Notification type

and Order type)

. Developed Dashboards using (Query as Web Services) QAAWS on top of

Universe Designer as well as developed Dashboards using the complex

Excel Functions in Xcelsius 2008.

. Performed Unit testing on the Dashboard by comparing with the Source

tables, with the count of Valid and Invalid records.

. Involved in creating new Templates for the Reports.

. Dashboards identify the gaps and optimize the underlying Business

processes to achieve more efficient results and will be the key for

the assessment of the data for future recommendations.

. Extensively used SAP HANA Studio for modeling purposes.

. Created/Configured Attribute views, Analytic views, Calculation views,

Analytic privileges, Ownership privileges, GRANT & REVOKE privileges,

Global Authorizations, Decision Tables, Mapping tables, User defined

Schemas, Packages and sub-packages in SAP HANA Studio.

. Created complex reports by linking data from multiple data providers

using merged dimensions. Also used functionalities such as combined

queries.

Duration: Dec 2009 - Jun 2011

Industry: Amgen (Healthcare), Thousand Oaks, CA

Project Description/Scope:

Amgen is a leading human therapeutics company in the biotechnology

industry. For

more than 25 years, the company has tapped the power of scientific

discovery and

innovation to advance the practice of medicine. Amgen pioneered the

development

of novel products based on advances in recombinant DNA and molecular

biology and

launched the biotechnology industry's first blockbuster medicines. Today,

as a Fortune

500 company serving millions of patients, Amgen continues to be an

entrepreneurial,

science-driven enterprise dedicated to helping people fight serious

illness.

Role: Data Migration Consultant

Responsibilities/Deliverables:

. Tasks included multiple projects with deadlines, team cooperation to meet

these deadlines, and being held accountable for code style,

documentation, and project efficiency.

. Constructed reusable templates to speed ETL development in BODS and

provide auditing functionality. Led training sessions explaining usage of

templates and gathering ideas for improvement.

. Created and optimized executive summary, operating information, gross

margin, and framework (Xcelsius) dashboards, including hierarchical

selectors, flash variables (linking to dashboards.

. Significant contributions to dashboard and ETL architecture and design,

including best practices.

. Built reports connected to BI services pointed at Web

Intelligence blocks. Reports launched by and received prompts from

Xcelsius dashboard.

. Successfully migrated data from legacy to SAP system.

. Experience in Usage and Development of AIO (All In One)/BPDM 3.0 and AIO

3.2 and 4.0 Methodologies.

. Experience with the Central Management Console (CMC) to handle the

Administrator Issues.

. Provided administrative assistance, including fixing of scheduling

errors, performance tuning, permissions management, and migrating jobs

between systems.

. Creation of new repositories and configuration of existing ones.

. Acted as go-to for the team for technical concerns and idea development.

. It was necessary to become proficient with all of SAP Business Objects

software, especially Data Services Designer. General computing skills

and technical knowledge were also a huge advantage.

. Created the data flows, workflows, transformations and SAP target data

formats.

. Analyzed source data and created data profiling reports.

Duration: Oct 2008 - Nov 2009

Industry: HSBC (Banking), Vernon Hills, IL

Project Description/Scope: HSBC, is to be the world's leading

international bank. Since its formation in Hong Kong in 1865, the bank has

helped to facilitate trade. Today our network covers 74 countries and

territories in both established and emerging markets, making us well

positioned for future growth as the world economy becomes more connected

and trade and capital flows increase.

Role: Data Migration Consultant

Responsibilities/Deliverables:

. Involved in data migration from various corporate systems and interacted

with end users and functional consultants.

. Developed data transformations from source to target systems per the

business requirements

. Involved in data profiling and used validation and address cleansing

transformations by using data quality in SAP BODS 3.2.

. Involved in administrative tasks like Repository Configuration, Job

Server configuration, Central Repository configuration, Job Scheduling,

Monitoring.

. Involved in promotion of Jobs and workflows from Development to Test and

to Production Servers to perform the integration and system testing.

. Created Workflows using object library and tool palette to execute data

flows

. Involved in BW Backend Development, Design and Development of SAP BW

front end queries.

. Designed and developed simple and complex transformations in Data Flows

. Cleaned data in SAP DI using proper data types and mappings

. Developed Recovery Mechanism for unsuccessful batch jobs execution

. Extensively worked with local Repositories, Central Repositories, Job

Server and Web Admin client tools

. Created reusable components like Workflow, Data flows, batch and real

time Jobs using custom functions

. Extensively worked with SQL Server applications like SSIS, Stored

Procedures, SQL Querying, T-SQL and OLTP

. Extensively worked on Performance and tuning of the jobs

. Developed Try/Catch to handle exceptions and writing Scripting to

automate the Job Process

. Identified bugs in existing mappings by analyzing the data flow,

evaluating transformations and fixing the bugs and redesign the existing

mappings for improving the performance.

. Involved in Analysis of data formats and availability, ETL functionality

and data models and data mart constructs

. Designed and developed a dashboard capable of displaying reconciliation

exceptions and sending alerts.

Duration: Jan 2008 - Sep 2008

Industry: HSBC (Offshore)

Project Description/Scope: This Project includes handling various

activities of the project like information gathering, analyzing the

information gathered, documenting the functional or business requirements.

Role: Data Analyst

Responsibilities/Deliverables:

. Tasks included multiple projects with deadlines, team cooperation to meet

these deadlines, and being held accountable for code style,

documentation, and project efficiency.

. It was necessary to become proficient with all of SAP Business Objects

software. General computing skills and technical knowledge were also a

huge advantage.

. Created the data flows, workflows, transformations and SAP target data

formats.

. Analyzed source data and created data profiling reports.

. Successfully migrated data from legacy to SAP system.

Education & Certifications:

. SAP Certified Application Associate - SAP HANA

. SQL Certification - Querying Microsoft SQL Server 2012

. Best Employee of Year(2010) - Mphasis HP

. Bachelors in Information Technology- Jawaharlal Nehru Technological

University, India

Resume

Contact this candidate