SAP Business Intelligence Consultant Resume Profile

SAP Business Intelligence Consultant

SUMMARY

Almost 7 years of professional experience in implementing Business Intelligence solutions.
Proven expertise in SAP HANA and Business Objects BI Tools
Prominently worked as Business Objects Application Architect, having strong hold on Universe design, Reports design Web intelligence, Xcelsius, Crystal Reports and object implementation
Having technical experience in using tool like Informatica ,Microstrategy and Databases-Netezza, MS SQL Server.
Possess extensive experience in developing Data Models in SAP HANA
Sound knowledge of OLAP/OLTP and Data warehousing concepts
Experience in design and development of DWBI and ETL End-to-End framework
Performed from the scratch BI solution development, starting from requirement gathering, source data analysis, conceptual/technical document creation, OLAP Data model architecture design engineering, developed loading strategies in ETL superior documentation , ETL code development followed by Business Objects code development to facilitate user needs to support their decision making process efficient and user friendly
Expertise in designing Universe s from scratch for multiple clients. Created Universe, resolved loops by creating aliases and context, created derived tables and ensured better
Extensively worked in Crystal reports and Crystal Enterprise environment
Developed complex reports that contained filters, prompts, multiple breaks levels, multiple data providers, cross tabs, levels of hierarchies for drill down and drill across reports, charts, sub reports.
Was responsible for schedule creations and report distribution in various user requested formats
Performed impact analysis, reviewed deliverables and ensured quality by doing various testing process
Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level
Possess proven experience in diversified areas of SDLC life cycle such as database design / management, ETL, Data modeling, reporting applications along with performance tuning, testing, production rollout support activities.
Performed various levels of Performance Tuning activity at both Business object environment as well as ETL level to get the optimum output effectively
Have performed Project Initiation Project planning, Execution activities along Effort Estimation, Resource, and Risk assessment activities
Project Leader for Onsite/Offshore model project execution
Diversified experience in implementation Business objects report management with in Finance, Sales and Marketing, Supply Chain Management sectors
Efficient in Optimizing, Debugging and testing SQL queries
Have worked for different clients in multiple locations, responsible for interaction with stakeholders, gathering and documentation business requirements, strategy, planning and effort estimates for project delivery.
Has good capability to prioritize task / plan and execute for the entire team effectively
Has managed tasks and/or resources with tight deadlines and proven to perform multi task

SKILL SETS

Databases	Netezza 6/4.0.1, Oracle 10g/9i, Microsoft SQL Server
BI Tools	HANA, Business Objects ,Crystal Reports, Xcelsius, Microstrategy
ETL Tools	SAP BO Data Services 4.1, Informatica 8.1.1
Language	T-SQL,UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential
ROLE	BI APPLICATION ARCHITECT

Responsibilities :

SAP HANA BODS Architect

Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
Worked extensively on Data Modeling design using different types of view in HANA.
Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
Created Universes using IDT Information design tool on top of HANA calculation views and developed the Webi reports
Created ETL mappings to load data from SAP ECC to HANA using BODS
Created projects, batch jobs, Real time jobs, work flows and data flow
Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations

Project Environment: SAP HANA Studio 1.0,Data Services 4.1

BOBJ Specialist

Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models
Expert in Universe Designing using Universe Designer and Information Design Tool.
Created many universes which involve more than one fact tables.
Created Contexts, alias to resolve loops and traps.
Created many complex and customized reports for specific business requirements
Hierarchies are implemented to support drill down reports
Created complex reports like using multiple data providers and various report level calculations
Used Query builder to query BOE Repository and retrieve various information.
Developed Web Intelligence reports making use of several Queries Union, Intersection, Minus
Applied most advanced Business Objects functionalities like conditional hiding, ranking, hyper linking, conditional sorts, alerter etc.
Used Metadata Manager to retrieve metadata reports.
Tuned and enhanced report queries to improve report performance
Conducted end user training for basic and advanced reporting skills
Trouble shooting and Performance tuning of the reports and Universe
Published the report to CMC and schedule it according to the requirement.
Created several Crystal Reports using sub reports.
Created various KPI dashboards using Xcelsius

Project Environment: Business Objects 4.0,Crystal Reports 2011, Xcelsius

Confidential
ROLE	BI APPLICATION ARCHITECT

Roles and Responsibilities:

BOBJ Specialist

Gathered requirements from different level of users for solution development
Interacted with the Business Group extensively in gathering requirements and analyzed needs
Analyzed and designed the Data model , EDW data analyses for Report objects development
Preparation of technical specification document
Developed the report standards and strategies
Have translated the Business requirement into technical specification
Have translated business-reporting requirements into universe strategies and design
Performed Requirement analysis, Impact analysis and have prepared effort estimation plans
Setting up Meeting with offshore team members for design development of Reports
Design and develop new Business Objects universes
Performed Production support activity , troubleshooting and maintenance
Supported testing team on Load Testing
Have performed report Enhancements in Business Objects
Holiday Performance tuning
Query tuning for performance improvement process
Provided support to the User's while testing of report
Event Support in terms of DB load
Involved in load monitoring
Issue fixing and Enhancements in the ETL process
Providing support for the Business Users in terms of Data Request
Performed task review and different level of testing process to ensure the quality of deliverables.

Project Environment: Netezza 4.0, Business Objects, Informatica

Confidential
ROLE	BI APPLICATION ARCHITECT

Responsibilities:

BOBJ Specialist

Analyzed and designed the Data model for module requirement
Involved in creation of Universe and resolved Loops by creating table aliases and contexts.
Create Aggregate aware, Prompt and Select functions.
Resolved Fan Trap and Chasm Trap.
Involved in creation of documents like Unit Test Plan UTP .
Involved in report creation using BO-Desktop Intelligence.
Create reports like Cross tab and Master Detail and applied breaks.
Create reports with Alerts which is used to highlight values with specific criteria.
Generated reports for various business areas like sales, inventory, finance and logistics
Developed SQL codes for different Modules.
Created objects, measures, hierarchies for the reports
Developed Business Objects reports based on Ad hoc Requirements
Performed testing, Bug fixing and enhancements
Done various report testing and documented test scripts
Performed testing to ensure data validation and documented the test cases
Done format check and have provided support for user verification test

Project Environment: Netezza 4.0, Business Objects XI R2

Confidential
ROLE	BI/ETL DEVELOPER

Responsibilities:

BI/ETL DEVELOPER

Performed Source data analysis and have done impact analysis
Have performed different levels of report enhancements
Implemented Modified critical logics of the query in free hand sql.
Involved in modification of the logic in the existing mappings.
Developed Business Object reports and objects in sync with the specifications
Was involved in Production support activity in Business Objects
Performed different levels of testing and documented the same
Created unit testing checklist for ETL mappings.

Project Environment: Netezza 4.0, Business Objects XI R2, Informatica Power Center 8.1.1

Confidential
ROLE	DATA INTEGRATOR

Responsibilities:

DATA INTEGRATOR

Performed Source data analysis
Developed the Informatica mappings for all the stages of ETL.
Performed extensive unit testing and documented the test scripts.
Generated reports for sales and performance comparison.

Project Environment: Business Objects XI R2, Microsoft SQL Server 2000, Informatica 7.1

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship