Sr. Business Objects/data Services/hana Developer Resume
Parsippany, NJ
SUMMARY
- Business Objects/Data Services and HANA Developer with over 10 Years of experience in “Full Life Cycle” Data Warehousing Implementations ranging from requirements gathering, designing, developing and implementing using SAP Business Objects Suite, along with ETL Experience using “SAP Data Services & Informatica PowerCenter” tools. Exceptional communication and interpersonal skills resulting in an outstanding rapport with customers, peers and executives of all levels. Creative and strategic planner utilizing management, problem solving and technical skills to exceed desired results.
- Vast experience in designing, developing and testing Business Objects Universes with various features like Aggregate Awareness, Pre - Defined Conditions, Cascading Prompts, Outer Joins, Custom Hierarchies, Custom LOV’s, Cardinalities, Aliases, Contexts, Short Cut Joins and Index Awareness.
- Experience in design and development of Relational as well as OLAP Business Objects Universes, creating canned and Ad-hoc reports and scheduling using InfoView and the BI Launch Pad 4.0/4.1.
- Extensively used Business Objects Reporting functionalities such as Master/Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Graphs, Section and Breaks.
- Experience in Business Objects XI R3 and BO BI 4.0 Central Management Console (CMC), in the creation of Business Objects folders, user groups, profiles, schedules, publications and security rights.
- Strong experience in Migration of Business Objects between versions: 6.5 to XIR2; XI R2 to XI 3.1 and XI 3.1 to BO BI 4.0.
- Proficient in various features of CA ERwin’s dimensional data modeling techniques: - a. Star & Snow-Flake Schema b. Physical & Logical Modeling c. Reverse & Forward Engineering.
- Created multiple “Dashboard-like” Web Intelligence documents and published them for offline consumption.
- Created SAP BO Dashboards, WebI and Crystal Reports using SalesForce.com driven data and embedded with Salesforce.com Portal using the embedded BI application-LaunchWorks LaunchPortal.
- Strong experience in tuning WebI reports built on SAP BW, resulting in faster execution, improved system resource usage and faster refresh time with the functionality “Query-Stripping”.
- Extensively used Information design tool (IDT) 4.0/4.1, to create ’.unx’’ universes on multiple Data Sources.
- Vast experience in report generation using Crystal Reports 2008, 2011 and Crystal Reports for Enterprise 4.0.
- Have in-depth knowledge of creating Dashboards using Crystal Xcelsius 4.5 Professional, Xcelsius Enterprise 2008/2011, SAP BO Dashboard Designer 4.0 and Corporate Dashboards using SAP BO Dashboard Builder 3.1.
- Created Reports with SAP Bex RRI Actions to Report Objects using Crystal Reports for Enterprise 4.0.
- Highly efficient in creating dynamic dashboards in Xcelsius 2008/2011and SAP BO Dashboard Designer 4.0 using Query as a Web Service (QAAWS), Live Office (LO), BI Services and by consuming XML data.
- Designed and developed Data Services batch jobs to extract data between SAP R/3 and SAP BW systems.
- Created Data Services batch job using “Merge Transformation’ to merge Disparate Data Sources into SAP HANA DB.
- Created Data Services batch job using ‘History Preserving Transformation’ to retain original records and create new records for updates identified during the ‘Table Comparison Transformation’ while loading data into SAP HANA tables.
- Hands on experience with SAP Data Services and Informatica PowerCenter in designing and developing complex mapping between the source and target definitions by using various transformations like Lookup, Query, Case, Table Comparison, History Preservation, Key Generation, Merge, Date Generation, Pivot and Validation.
- Extensively used Information Steward’s Data Cleansing Package Builder and Data Quality transformations like a. Address Cleanse b. Data Cleanse c. matching to cleanse, match and standardize loaded data in the target.
- Created various Dashboards with BO Dashboard Designer 4.0 on HANA DB by triggering queries and publishing WebI report block as a BI Web Service technique.
- Hands on experience in creating SAP HANA Information models such as Packages, Attribute Views, Analytical Views, Calculation Views with graphical and script based models, using SQL and CE functions and in creating BO(‘.unx’) universe(s) by consuming the HANA Information Models in Information Design Tool 4.0/4.1.
- Hands on experience with SAP HANA Data Provisioning/Replication techniques: - SAP Landscape Transformation (SLT) and BODS 4.2/4.3 to load data from SAP ECC system to SAP HANA.
- Created advanced visualization to examine billions of retail point of sales (POS) records in real time using SAP Business Objects Explorer 4.1 on top of HANA Information Model.
- Created advanced data visualization on a Hana View with huge amount of sales data into information quickly and in real time using Lumira 1.17.
- Created multi-dimensional data analysis of a Hana View to analyze large data sets real time using BO Analysis for Office 1.4.
- Substantial development experience in creating Oracle PL Stored Procedures and Functions, Triggers, Cursors, Packages and Exception Handlers.
TECHNICAL SKILLS
Business Objects Tools: BO BI 4.0/4.1, BO XI 3.1/R2, BO 5.1/ 6.5, Import Wizard, Publishing Wizard, Life Cycle Manager(LCM), Upgrade Manager, Report Conversion Tool, Universe Designer, Information Design Tool 4.0/4.1, BO BI Launch Pad, Desktop Intelligence, Business View Manager, Web Intelligence 4.0/4.1, WebI Rich Client, Bex Query Designer, SAP BO Voyager 3.1, SAP BO Analysis for Office 1.4, BO Explorer 4.1, BO Lumira 1.17, SAP BO Design Studio 1.0,Xcelsius 2008/2011, SAP BO Dashboard Builder 3.1, SAP BO Dashboards 4.0/4.1, Crystal Xcelsius 4.5, Crystal Reports 2008/2011, Crystal Reports Enterprise 4.0, Query As A Web Service (QaaWS), Live Office (LO), SAP BO Predictive Analysis 1.0, SAP BO Mobile 4.0, SAP HANA Studio 1.0
ETL Tools: BODS 4.0/4.2/4.3; Informatica PowerCenter 8.6/8.1
ERP: SAP R/3 4.6, 4.7C, SAP ECC 6.0
Data Warehouse: SAP BW 3.5, SAP BI 7.0/7.3
RDBMS: SAP HANA 1.0 SP7, Salesforce, Oracle 11g/10g/9.x/8.x, SQL Server 2008/2005, MySQL, Teradata V2R6/12, MS Access
Operating Systems: Windows Server 2000/2003, Windows Server 2008/ 2008 R2, Windows 8, Windows 7, Red Hat Enterprise Linux 4, Suse Unix, Ubuntu Unix
Programming Languages: XML 1.0, HTML 5.0, C, ASP, JAVA, JSP, SQL, PL/SQL, Ubuntu Unix Shell Scripting, ABAP/4
Utility Tools: CA ERWin 7.3/ 8.0, MS SharePoint 2010/2013, TOAD, SQL*Loader/Navigator, SQL Builder, Oracle Data Pump, SalesForce, Oracle VM VirtualBox, Adobe Photoshop CS3, MS Excel
Methodologies: SDLC, ASAP, ASAP Focus, Agile.
PROFESSIONAL EXPERIENCE
Confidential, Parsippany NJ
Sr. Business Objects/Data Services/Hana Developer
Responsibilities:
- Hands on experience with Data-Provisioning techniques using SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and Data Services Transformations to perform batch load replication in loading data from source system(s) into HANA DB.
- Extracted and loaded various business units’ SAP ECC modules data along with CO-PA data using SLT and Data Services replication techniques into HANA DB; modeled the data in HANA Studio by creating Information Models. Reporting and Analytics was carried on them using BO front-end tools through direct and indirect (via ’.unx’) connectivity mechanism.
- Created multiple batch jobs to extract data from legacy and various source systems into HANA DB using Data Integrator, Quality and Platform transformations available in Data Services.
- Created a Data Services batch job using ‘Match Transformation’ to identify and eliminate potential duplicate values in the merged tables in HANA DB to avoid data redundancy.
- Created Data Services batch job using ‘Case Transformation’ to split ‘Customer Orders’ into different tables in Hana DB.
- Created Data Services batch job using ‘Validation Transformation’ for auditing data in SAP HANA DB.
- Worked on various profiling options (Columns, Addresses, Dependency, Redundancy and Uniqueness) present in Data Insight of Information Steward to fix inconsistent, incorrect, and incomplete loaded SAP HANA Data.
- Created SAP Business Objects Universes (’.unx’) by building a data foundation on top of 1. HANA Information Models and 2. Selecting appropriate tables in HANA DB and creating joins using IDT 4.0/4.1.
- Created SAP Business Objects Universes (’.unx’) using data federation layer that exists in multi- source enabled data foundations; performed various transformations by including federated tables into the data foundation in Information Design Tool(IDT) 4.1.
- Created multiple Interactive Analysis, monthly and summary reports of CO-PA and Financial KPI present in HANA DB using Interactive Analysis 4.0.
- Created Interactive Executive and Sales Visualization Dashboards to review the health of the business by utilizing SAP HANA Views using the underlying binding mechanism(s): Direct Query, Triggering a Query for interactivity and Query as a Webservice (QaaWs) to track KPIs’ and summary data of various business units using SAP Dashboard Design Tool 4.0/4.1.
- Created multiple highly formatted, interactive and parameterized reports directly on HANA DB by consuming HANA DBs’ Tables, Views and Stored Procedures using Crystal Reports 2011.
- Created advanced data analysis of ‘Market Share Contract Entities - Finished Goods’ of a particular drug at Confidential ’ to identify trends and outliers using BO Analysis for Office 1.4.
- Created an agile Visualization highlighting Web Intelligence reports’ decline in net sales of a pharmaceutical drug by creating a HANA scripted calculation view and consuming within BO Lumira 1.17.
- Created Information Spaces for various Business Operations to search and explore Point of Sales (POS) data present in Hana Information Models; built Exploration Views on them to create Advanced Visualizations through multiple What-If Scenarios and Charts using BO Explorer 4.1.
Environment: BO BI 4.0/4.1, Information Design Tool 4.0/4.1, BO Analysis for Office 1.4, BI Launch Pad, Universe Designer, WebI Rich Client, SAP Dashboards 4.0/4.1, Crystal Reports 2011, Crystal Reports for Enterprise 4.0, SAP Design Studio 1.3, SAP Lumira 1.17, BO Explorer 4.1, Query as a Web Service (QaaWS), SAP HANA SP7, SAP ECC 6.0, SAP BI 7.3, SQL Server 2008 R2 and Windows Server 2008 R2.
Confidential, McLean VA
Sr. Business Objects Developer
Responsibilities:
- Involved in requirement gathering by working with business users, financial analysts, and project managers; was involved in the analysis and creation of an architecture that was deemed practicable and scalable.
- Installed and configured Business Objects BI 4.0 to test the functionality between BO XI 3.1 and BO BI 4.0 and migrated BOBJ Environments from BO XI 3.1 to BO BI 4.0 using Upgrade Manager as well as used Life Cycle Manager (LCM) to promote content between Development, Test and Production environment.
- Designed, developed and maintained Universes based on multiple data sources using Information Design Tool 4.0.
- Exported the data model(s) created in ERWIN 8.0 to Business Objects Universe(s) using its Meta Integration Bridge.
- Created dynamic filters and conditions at the Universe level adhering to the business requirements as well as used @functions like @select, @where, @prompt and complex conditions for improved performance.
- As a part of BO Universe development:- have created classes, different kinds of objects, cardinalities, strategies, resolved loops using Aliases and Contexts as well as used various functionalities like:- Default and Custom Hierarchies, conditions on list of Values (LOV), calculations, functions and derived tables for improved performance.
- Created Business Objects Universes on top of Information Models and base tables in HANA DB using Information Design Tool 4.0.
- Created multiple Crystal Reports on Tables, Analytic Views and Stored Procedures on data in the HANA DB using Crystal Reports 2011.
- Extensively used calculations, variables, filters, conditions, breaks, sorts, drill down, slice and dice, cross tab, charts and alerts in the Web Intelligence reports.
- Created Web Intelligence reports top of SAP BW OLAP universes using WebI rich client and InfoView.
- Developed BEx queries on Info Cubes and DSO for reporting and dashboard requirements.
- Developed dynamic dashboards using QaaWS and Live Office connectivity to retrieve sales data of home and auto loans from different branches and created a simulation model for further improvement in sales at those branches.
- Created Crystal Reports with static and dynamic RRI interface actions (Dynamic Jump Destinations) on report objects based on BEx data source(s) using Crystal Reports for Enterprise 4.0.
- Performed complete unit and system testing for Business Objects Universe(s) including: a. Creating Test Case Scenarios b. Test Stubs and c. Checking Integrity; and all the testing results were logged into Quality Center.
- Created BO Dashboards and Reports with SalesForce.com driven data and embedded with SalesForce.com Portal using LaunchWorks LaunchPortal application. As a result, the clients could access their home loans, auto loans and other portfolio information through SalesForce.com Portal.
Environment: BO BI 4.0,/XI 3.1 (Designer, WEBI, WebI Rich Client, Crystal Xcelsius 2008 Pro.), Crystal Reports 2008, Crystal Reports for Enterprise 4.0, Query as a Web Service(QaaWS), Live Office (LO), ERWIN 8.0, SAP HANA SP6, Sales Force Version 20, Teradata 12, SAP BI 7.3, Oracle 11g, SQL Server 2005, TOAD and Windows Server 2008 R2.
Confidential, San Antonio TX
Sr. Business Objects Developer
Responsibilities:
- Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications about the system for Business Objects Universes and Reports.
- Designed, developed and maintained BO Universes by defining joins, applying cardinalities between the tables and applying contexts and aliases between tables to remove cyclic dependencies.
- Used various functions such as @aggregate aware, @prompt, @select, and @where, custom list of values (LOV), filters, predefined conditions, index awareness and custom hierarchies during the Universe development.
- Implemented security features like row level and object level security restrictions at the Universe level to make report data more secure and predefined access levels for users and groups in the Central Management Console (CMC)
- Created several ad-hoc reports using functionalities such as use of: multiple data providers, merge dimensions, master/detail, cross-tab, multi-dimensional analysis, drill analysis, scope of analysis, filters, charts, alerts, breaks, section, ranking, sub-queries and combined queries(Union, Minus, Intersection)
- Designed and developed “Dashboard-like” Web Intelligence reports by linking across various charts and components through interactive use of input controls.
- Created dynamic dashboards on the top of SAP and non-SAP data sources using QaaWS, Live Office (LO) and BI Services connection mechanism in Xcelsius 2008.
- Implemented the OpenDoc functionality to link between multiple Xcelsius Dashboards as well as between Xcelsius Dashboard and Web Intelligence/Crystal Report(s).
- Created Crystal Reports using various functionalities like running totals, sub-totals, sub-reports, hierarchies, cross-tab, multiple groups and conditional display of groups, fields and messages.
- Migrated reports and objects from development to production environment using import wizard.
Environment: BO BI 4.0/ XI 3.1, Designer, SAP BI 7.0, InfoView, Web Intelligence, WebI Rich Client, Import Wizard, Xcelsius 2008, Crystal Reports 2008, Crystal Xcelsius 2008 and Windows Server 2008.
Confidential, Houston TX
Business Objects Developer
Responsibilities:
- Actively interacted with Business Users and Business Analysts to gather, analyze and validate the requirements resulting in detailed business rules, functional requirements and process design.
- Created Universes, including classes (subclasses), objects, prompts, predefined conditions, custom List of Values (LOV) and Custom Hierarchies by retrieving the data from various data sources like Oracle, MS SQL Server and Teradata.
- Defined cardinalities, checked integrity, detected loops and resolved them by creating aliases and contexts to remove the cyclic dependencies.
- Developed BEx Queries based on Infocube and DSO, using conditions, structures, calculated key figures(CKF), restricted key figures (RKF) and formula variables
- Converted DeskI reports to WebI using Report Conversion Tool for enhancements and created Derived Tables in Universe to meet specific requirements of WebI reports
- Developed multiple analytic Web Intelligence reports utilizing key WebI features including but not limited to Drill Down, Alerts, Input Control and OpenDoc.
- Extensively used functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master/Detail and Formulas in developing analytical WebI reports.
- Developed Analytical Dashboards using Xcelsius with QaaWS and Live Office connectivity mechanism.
- Created Crystal Reports on top of various data sources like Universes, BEx Queries, OLAP Infocube, Personnel data files like notepad, excel as well WSDL URL.
- Created Crystal Reports with various options including but not limited to conditional formatting techniques by using formulas, creation and use of derived fields, the use of sub-reports(linked, unlinked) and hyperlinks in the report.
- Extensively worked on Informatica Power Center tools - Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor
- Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level and created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
Environment: Business Objects XI 3.1 (CMC, CCM, Designer, DeskI, WebI, InfoView, Import Wizard), Crystal Reports 2008, Live Office, Crystal XI R2, Crystal Xcelsius 2008, SAP BI 7.0, Oracle 10g, SQL Server 2008, Teradata V2R6, TOAD, PL/SQL, Informatica Power Center 8.6 and Windows Server 2003.
Confidential, Denver CO
Business Objects Developer
Responsibilities:
- Interacted with end-users and Business analysts to identify and develop business requirements and transform them into technical requirements.
- Integrated and linked multiple WebI reports and Dashboards to third party portal using OpenDoc functionality of Business Objects
- Linked various elements of the components in WebI reports by defining each component as input control to achieve the Web Intelligence’s Drill Across functionality
- Implemented Row Level and Object Level security for data restriction at the Universe Level.
- Resolved Chasm traps, Fan Traps and other join path problems by using contexts, aliases and creating shortcut joins to reduce the complexity of the universes.
- Extensively performed the User Management, Server Management and Content Management tasks in BO XIR2 Central Management Console (CMC)
- Created multiple Desktop intelligence reports using universe as data source and published the reports to the Business Objects Repository.
- Enhanced the interactive analysis of Web Intelligence reports by incorporating cascading prompts, conditional formatting, input controls, tracked changes and use of multiple queries
- Created dynamic and engaging Executive Dashboards by consuming data from various universes, Web Intelligence and Crystal Reports using QaaWS and Live Office (LO) connectivity mechanism.
- Developed various Canned, Master/Detail, Sub Reports, Cross Tab and Summary Reports in Crystal Reports using features like running totals, functions, parameters and conditional formats.
- Extensively used Life Cycle Manager (LCM) in transporting the content across the Business Objects Systems.
- Designed and developed complex aggregate, join, look up transformation rules to generate consolidated summary data identified by dimensions using Informatica Power Center Designer.
- Extensively used ETL to load data using Informatica PowerCenter from source systems like XML Files, Flat Files and Excel Files into staging tables and load the data into the target database (Oracle, SQL Server).
- Developed mappings to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner, Normalizer transformations.
- Developed Slowly Changing Dimension mappings (Type 1 and Type 2) to capture deleted as well as inserted records in the source systems.
Environment: Business Objects XIR2 (CMC, CMS, CCM, Designer, Desktop Intelligence, Web Intelligence, InfoView, Import Wizard), Xcelsius 3.0, Live Office, Crystal Reports XI R2, Oracle 10g, SQL Server 2008, TOAD, SQL, PL/SQL, Informatica Power Center 8.1 and Windows Server 2003.
Confidential, Lake Forest, IL
Business Objects Developer
Responsibilities:
- Actively involved in gathering, analyzing and documenting business requirements, functional requirements and the data specifications about the financial system for the sake of Business Objects Universes and Reports.
- Involved in the design and development of Universe, Classes, and Objects with conditions for Business Analysis and Report Generation
- Used different functionalities of Universe such as Cardinalities, Contexts, Shortcut Joins and Aliases for resolving loops and checked the integrity of the Universes.
- Exported reports to Broadcast Agent (BCA) scheduled, monitored and published them.
- Created Standard reports, Cross Tab reports, Ad-hoc reports using features like Ranking, Sorting and @functions to analyze the data.
- Created Desktop Intelligence/Web Intelligence reports using different BO functionality like Breaks, Section, Alerts, Queries, Slice and Dice and added graphical representation with bar charts, line charts, pie charts, scatter plot etc.
- Developed dynamic Crystal Reports with powerful filtering ability by incorporating Dynamic Cascading Parameter fields into Record Selection.
Environment: Business Objects 6.5/XI R2, Web Intelligence 6.5, Desktop Intelligence, Designer, Supervisor, Broadcast Agent, InfoView, Oracle 8i, SQL Server 2000 and Windows Server 2000.
Confidential, Farmington Hills MI
Business Objects Developer
Responsibilities:
- Designed, developed and maintained BO Universes by defining joins, setting cardinalities between tables, creating contexts and applying aliases to the tables to remove the join path problems
- Used @Functions like @Prompt (user defined queries), @Where (creating conditional filters), and @Select to create duplicate objects in the process of building the Universes.
- Designed and developed Desktop Intelligence and Web Intelligence Reports using Business Objects Functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master/Detail and Formulas etc.
- Created parameterized Crystal Reports and customized existing sales reports for presentation using List reports, Aging reports, Grouped reports, Detail reports, Sub-reports and Cross-Tab reports
- Exported the reports to the Broadcast Agent (BCA), monitored, scheduled and published.
Environment: Business Objects 5.1(Desktop Intelligence, Designer, Supervisor, Broadcast Agent, InfoView, Web Intelligence 6.5), Crystal Reports 8.5, Oracle 8i, SQL Server 2000 and Windows Server 2000.