We provide IT Staff Augmentation Services!

Bo Frontend Analyst Resume Profile

SUMMARY

  • 10 Years of IT Experience including SAP BODS, HANA 1.0, SAP Business Objects, Actuate SAP Business Objects, Business Objects Data services, Salesforce.com, XCELSIUS, Crystal Reports, SAP Business Intelligence, SAP Business Warehouse, SAP ABAP Objects, Java, Design and Development of Universes and Reports using Business Objects Enterprise products namely - BI 4.0 and Business Object XI R3.1/R3/R2/6.5, Crystal Reports and Xcelsius.
  • Diversified experience in implementation Business Objects report management with in Finance, Sales and Marketing, Pharmaceuticals and Telecommunication.
  • Expertise in Universe designing/developing and generating reports with complex, business views, ad-hoc reports, dashboards.
  • Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production.
  • Experience in creating users and user groups, restricted access of the users as needed using Central Management Console CMC . Involved in managing users, groups, folders and published reports using Central Management Console.
  • Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling
  • Migrated Business Objects environment from Business Objects Enterprise 6x to XIR2 and also from XIR2 to XIR3.
  • Experienced on creating dashboards using Xcelsius 2008/SAP Dashboards by importing data files to create the visualization utilizing QAAWS and Live Office connections. Expertise creating Executive dashboards for the Top Management showing summary metrics for the Key performance Indicators KPI's .
  • Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite. Strong skills in interfacing Business Objects with Databases like Oracle, SQL Server etc.
  • Experienced in interacting with Business Users to analyze the business process and requirements and transforming requirements into screens, designing/analyzing database and documenting.
  • Articulate with excellent communication and leadership skills and the ability to develop creative solutions for challenging client needs.
  • Proficient in 3-Tier SAP BW Architecture including ETL with BW backend development, Data/Metadata Administration and Reporting.
  • Experienced in all phases of Software Development Life Cycle SDLC , quality management systems and project life cycle processes. Highly skilled in Salesforce.com SFDC development and implementation
  • Skilled as a Business Analyst, worked on requirements gathering and app design
  • Worked Extensively on CRM, SD, MM and FI reporting.
  • Knowledge in Business Objects Predictive Workbench and Data mining.
  • BW operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading Full /Delta Up-Load , Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
  • Proficient with planning, Gap analysis, design implementation
  • Expertise of various data design models - Entity Relationship ER , Multi-Dimensional/Star Schema and Extended Star Schema models.
  • Extensively worked on data modeling Designing custom info objects, info providers, info cubes, DSO objects, multi providers, infosets, info sources, source systems and dimension modeling.
  • Proficient in 5 modes of extraction supported by SAP BW - DB Connect, XML, Flat files and extraction from 3rd party ETL tools.
  • Performed extensive FI, CO-PA, LO Cockpit and generic data extractions.
  • Customizations - Datasource enhancements, generic extractors, CMOD enhancements, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
  • Expertise in performance tuning using Aggregates, Rollup, collapse, Partition, Compression and query cache maintenance.
  • Configured and implemented BW reporting using BEx analyzer/browser, BEx Broadcaster, WAS, XI, Enterprise Portals integration, iViews, Visual Composer, KM and Collaboration Rooms.
  • Worked extensively on query development and formatting techniques in BEx, Crystal Reports, Xcelsius, Web intelligence and Web reporting. Has a hand on experience with BO Data integrator.
  • Experienced in Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise.
  • Followed and implemented ASAP methodology.
  • Ability to interpret and write ABAP routines.
  • Involved in BW work for scheduling background jobs, creating BW/BI Security, user profiles, roles, authorizations and extensive performance tuning work on databases.
  • Capable of developing, documenting, and enforcing guidelines for application development to ensure high standards for usability and customer experience.
  • Involved in presentations, end-user training, documentation
  • Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, Productivity, and profitability.
  • Excellent communication, presentation, and interpersonal skills.

COMPUTER SKILLS

  • ERP: SAP R/3 4.7, 4.6c, 4.6b, 4.0b, and 3.x, ECC 5.0, 6.0, SD, MM, HCM, FI/CO.
  • Data Warehousing: SAP BI NW04s BI 7.0 , BW v 3.5., BODI 3.0, BODS 3.2, BODS 4.1 and BODS 4.2
  • Reporting Tools: Bex and web reporting, Web Application Designer, Visual Composer, Crystal Reports 2008.2011,4.0, BOXI 3.0, Web Intelligence 3.0, Rapid Marts
  • Databases: HANA1.0 SP6, Oracle 9i/8i/8.0/7.x, SQL Server 7.0, Teradata, MS SQL Server 2000 and MySQL.
  • Programming
  • Languages/Protocols: ABAP/4, C, Java, C , SQL, PL/SQL, HTML/DHTML and JavaScript.
  • Operating Systems: AIX, UNIX, Windows NT/XP/2000/98/95.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

  • Requirement Gathering and Analysis on the requirement from different countries like Columbia, India, Egypt, Russia Brazil ,South Africa etc from SAP ECC ,BPCS ,SAP BW , SQL server and Excel Source Systems.
  • Provide Recommendation on Hardware Sizing and Architecture
  • Involved in Design and development of EIM Master Data Migration...
  • Interacting with Client, Managers, SME's, BA and Database team.
  • Extensively in meetings and interviewing Business and Power users, to determine the sources, data Layout, Business needs, and naming conventions of the column and table names.
  • Involved in Developing WEBI and Crystal reports
  • Involved in Developing Universe and Parameters in IDT.
  • Performed complex troubleshooting, root cause analysis, solution development and implement reporting systems to address the issue.
  • Loaded excel data to HANA and reported on top of HANA database.
  • Involved in migration from SAP BODS 4.1 to SAP BODS 4.2
  • Coordinate with Linium Team and web methods team to ensure availability of Source Files and mapping files
  • Data Modeling, Designed Logical, Physical models using DBDesigner and MySQL.
  • Defined Technical Design document.
  • ETL Design use of Complex ETL routines to extract data from DSO converting business functional specifications into mappings/workflows .
  • Meeting with Business users and Business Analysts regarding requirements.
  • ETL Design converting business functional specifications into mappings/workflows and testing
  • Performance tuning for large data files by working on excel block size.
  • Error handling in scheduling in Production. Challenge in Handling OLE error
  • Performance tuning using Recovery mechanisms.
  • Implemented Server groups to use advance performance tuning feature such as parallel data flow.
  • Involved in writing DS scripts and also used some built-in functions like Search, Replace, Lookups and Custom Functions for ETL audit process.
  • Involved in System integration testing along with other team members of BW and Teradata using various source data scenarios.
  • Involved in code enhancement, Create CR and testing based on change request CR from end users.
  • Experience in debugging execution errors using Data Services logs trace, statistics and error and by examining the target data.
  • Worked with security teams to setup user access levels, and server sizing based on country and Package level access.
  • Guiding the development team right from requirement to deployment.
  • Leading a Team of 6 in both IBM onsite/ Offshore.
  • Involved in ETL end to end implementation.

Confidential

Responsibilities:

  • Interaction with the Business Users to analyze the source data and gather requirements, technical specifications in migration of the data to the target SAP BW system and Teradata
  • Staging the source data into Data Services Engine from SQL server, flat files and Excel spread sheets implemented necessary transformations to transform as per the target SAP architecture and loaded into the SAP BW system
  • Worked extensively in Data Analyzing, Data Profiling, Data Validation and data reconciliation.
  • Involved in Data Cleansing, De-duplication and Data Enhancement activities to enrich the Master and Transactional data.
  • Created complex source to target data mappings as a part of building the design according to the mapping requirements.
  • Built and Unit tested the jobs for migrating objects using SAP Business Objects Data Services best practices to load Master and Transactional data objects into SAP ECC.
  • Extensively used Lookup ext, Lookup seq and also created custom functions.
  • Used Global variables, Local Variables and Parameters between Work flow and Data flow as per mapping requirements.
  • Performed the Correctness test by running the DS jobs and validated the results by comparing the data from the test results of original legacy data.
  • Tuned and monitored Data Services Jobs and Transformations for the better performance of jobs.
  • Migration of jobs between different Central repositories and executed from Central Management Console as a part of different loads.
  • Involved in error Handling, development of custom scripts.
  • Leading a Team of 3 in Capgemini onsite/ Offshore.
  • Involved in transports of DS objects to QA and PROD.

Confidential

Responsibilities:

  • Designing the Database to extract data from different database.
  • Mapping the legacy database fields to SAP ECC
  • Worked on modeling of SAP ECC data in SAP HANA and loading data through SAP BODS.
  • Created universe on SAP HANA database.
  • Created Model and developed EIM Master Data Migration using SAP BODS.
  • Created WEBI reports on Universe and launched the reports to infoview.
  • Worked with MDM team and highlight any issues / dependencies Customer Master, Employee Master, Product Master, Sales Align Data, Distributor master, Contract Master
  • Modeling the Database on Teradata and SQL Server 2008.
  • Experience with Standardizing and customization of Master Data
  • Worked in ABAP in developing the ABAP dataflow in BODS
  • Extracting the data using BODS from the legacy system and SAP ECC to Teradata and SQL Server 2008.
  • Designing and Modeling the SD, MM, FI, OM and HR SAP Modules to fit the legacy system to SAP System.
  • Developing the Rapid Marts for Reporting
  • Developing the Universe using the Universe Designer 3.1 on the Teradata Database
  • Developing WEBI Reports on universe designer.
  • Involved in Data Cleansing Data Validation

Confidential

Responsibilities:

  • Working on information Design tool IDT to create universe from multiple data source.
  • Working on Multiple Data source like Oracle, SQL server, Teradata, BW and ECC to extract LMS and GWS data.
  • Worked in development of ABAP function module to extract real time data from SAP ECC to build universe.
  • Working on Crystal reports direct connection to function module of ECC through Information design tool.
  • Working on Arcos State Regulatory reports using web intelligence.
  • Worked on Client work - List for Collections Billing reports in both BEX and Crystal report.
  • Worked in Customer Build /Update reports using Crystal reports
  • Worked on migration of universe and reports from BOXI.3.1 version to BOBJ 4.0.
  • Extracting the data using BODS from the legacy system and SAP ECC toTeradata.
  • Worked in returns Count report using web intelligence
  • Worked on creating universe on SAP HANA
  • Created WEBI reports on universe and published to Launchpad.
  • Worked in EDI vs. Manual by Customer type report using Crystal reports
  • Worked on Client sales recap report using Xcelsius
  • Worked on Creation of generic extractor using view for Credit and release report.
  • Worked on Price Override Audit report
  • Worked in migration of teradata to HANA through Data services.
  • Worked on Customer Master Report Using Crystal reports
  • Worked on Credit s and Debits reports using Crystal reports
  • Involved in performance tuning of reports in crystal reports.
  • Involved in Installation and trouble shooting of Business Objects 4.0 and Crystal reports from the service market place.
  • Developed Universe connecting to SAP ECC system using the Data Federator.
  • Developed reports in WEBI using Universe designer.
  • Involved in Production Support and post Go-Live
  • Working in Universe designer BOXI reports and upgrade to BOBJ 4.0
  • Worked both in Relational and OLAP database.
  • Worked in UNV UNX conversion.

Confidential

Role: Lead SAP BI/BO Frontend Analyst

Responsibilities:

  • Worked with Business users in collecting and designing the Report requirements.
  • Created Reports using Xcelsius Dashboards and Crystal reports.
  • Primary role required analysis of the implemented Salesforce.com CRM system, and requirements gathering for modifications to it
  • Studied the implemented CRM solution, understanding its design
  • Interacted with various business user groups for gathering the requirements for the modification
  • Developed a new schema to better satisfy the needs of the users
  • Helped prepare the scope document for the modification
  • Used various means to extract sensitive and important data before making the modifications
  • Worked with various salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports, and Dashboards
  • Developed and configured various Custom Reports and Report Folders for different user profiles based on the need in the organization
  • Maintained user roles, security, profiles, and workflow rules wherever necessary
  • Extracting data from SAP ECC system to Teradata using BODS.
  • Business Object Universe, Business Objects Reports and Business Objects repository extensively used, and new universe were designed and developed to support the user requirements.
  • Responsible in creating Reports which enables customers to create predictive models which is utilized to solve horizontal and industry-specific business problems using data mining.
  • Customized extractors for campaign and marketing analyses.
  • Developed CRM reports to win/loss customers.
  • Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases.
  • Involved in designing, developing and deploying using Universe Designer
  • Working in BIW for performance Tuning.
  • Worked in designing the Avnet SAP Portal.
  • Involved in testing the queries in HP QC.

Confidential

Role: SAP BI/BO Lead

Responsibilities:

  • Worked closely with the business owners/users to create user requirements, functional specifications, design specification.
  • Worked on what if Analysis Report using Xcelsius.
  • Worked on Data services to load data from SAP R/3 system to SQL server.
  • Managed a team of developers to realize the development effort.
  • Business Object Universe, Business Objects Reports and Business Objects repository are extensively used, and new universe were designed and developed to support the user requirements.
  • Involved in full life cycle of Business Objects reporting Application.
  • WEBI Reports were created and deployed through Info View.
  • Created Auditor reports and tracked user access of reports and Universes.
  • Developed Open Hubs, DTPs, transformations, update rules and modified DSO's, Infocubes, Multi-providers and queries to meet new requirements.
  • Responsible in creating Reports which enables customers to create predictive models which is utilized to solve horizontal and industry-specific business problems using data mining.
  • Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases.
  • Involved in designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC. Configured BO and SAP BI integration.
  • Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports, Standard Reports, Cross-tab Reports, Sub Reports and Drill down Reports by accessing the Universe.
  • Used Crystal Reports and Xcelsius, for advanced data analysis and dashboard reporting.
  • Provided technical assistance in identifying reports to meet user requirements.
  • Performed defect resolution in Unit Test UT , System Test ST , Integration testing and User Acceptance Test UAT .

Confidential

Role: SAP BI/BO Lead. Team

Responsibilities:

  • Facilitated requirement gathering sessions by interviewing business owners / users and prepared User requirement specification, Functional specifications as part of the Business Analytics Team.
  • Created training, data modeling and technical documentation for the business users.
  • Also, created and maintained procedural documentation of business processes specific the functional area.
  • Compared and managed expected results versus actual results to resolve errors.
  • Performed UAT and System Testing prior to go-live.
  • Provided intensive production support functionality for financial planning / reporting users after the implementation.
  • Ensured that the deliverables meet the deadlines.
  • Trained users in using BI reporting tool for maximum efficiency.
  • Developed BI Financial reports for COPA.
  • Created Queries, Workbooks, and Dashboards using BEx Designer and Analyzer for reporting purposes.
  • Responsible for up gradation from 3.5 to 7.0.
  • Created reports in DESKI and WEBI of Business Objects XIR2.
  • Created query as Webservice using the data from the universe.
  • Created Xcelsius Dashboards for Analysis.
  • Worked on performance of the universe created
  • Wrote complex queries/formulas and created Calculated Key figures, Restricted Key figures in BW Query Designer to generate required Reports.
  • Developed, updated and maintained SAP BI reports and end-user training manuals specific to the financial planning.
  • Created universes, classes and objects by retrieving the data from SAP data sources and defining the necessary connections.
  • Used Business Objects Developer Suite Publisher View, CMC, Designer, and Infoview to perform various tasks specific to every component.
  • Closely worked with Application team to realize BW application requirements.

Confidential

Role: Senior BI/BO Consultant

Responsibilities:

  • Worked closely with business owners to gather requirements and prepare User requirement specification, Functional specifications.
  • Created Design specifications and Configuration control documents based on User specifications.
  • Closely worked on Application team to realize BI reporting requirements.
  • Installed and activated Business content for Sales/MM/Purchasing.
  • Performed migration process of BW 3.5 to BI 7.0
  • Worked on BW Data Modeling- Design of Info objects, ODS, Info Cubes, Queries, Info set, Multi-providers and custom Update and transfer rules.
  • Created flat file data sources, Performed extracting, Transforming loading of flat files to BI.
  • Enhanced Business content data sources and also created custom data source, performed CMOD enhancement to fulfill user requirements.
  • Worked extensively to enhance business content Data sources and create custom data source.
  • Created Queries, Workbooks, and Dashboards using BEx Designer and Analyzer for reporting purposes.
  • Wrote complex queries/formulas and created Calculated Key figures, Restricted Key figures, Custom Reporting Formula/Text Variables in BW Query Designer to generate required Reports.
  • Involved in creating Security/Authorization for BI reporting.
  • Created Dashboards using Xcelsius and web intelligence.
  • Created Reports for SAP R3 using Crystal reports
  • Worked with test group and business users to perform unit, Integration, user acceptance testing.
  • Involved Support Activities for Daily Load monitoring, daily process flow consistency, recover failed data loads.
  • Transported enhancements to Production based on change requests by business users/owners.
  • Involved in training end-users and BI support team.

Hire Now