Sap Bobj Sr. Consultant Resume
San Ramon, CA
CAREER SUMMARY:
- SAP BI/BOBJ Senior Consultant with 10+ years of SAP BI 7.x/7.3, SAP Business Objects 3.x/4.0/4.1, SAP HANA SP6, BODS 4.2 with four Full Life Cycle
- Implementation experience in BI and 1 implementation experience in HANA/BODS, with a mixed blend of technology and management skills, Mentored, managed and lead IT teams across countries from India, US and Germany.
- Excellent team player and can thrive in challenging situations. Able to think critically, multitask and work under tight deadlines and rapidly changing priorities.
- Involved in all phases of implementation from Business Blueprinting, Solution Designing, Data Modeling, ETL, Report Designing and Development, Production Deployment/Support and End - User Training.
- Worked extensively in Retail and Banking domains.
- Played Technical Architect, Lead, Business Analyst and Sr Consultant Roles.
- Strong interpersonal and communication skills. Ability to work independently and also as a team. Very comfortable interacting with customers and technical teams. Strong analytical & problem solving skills.
- Involved in Project Kick-off, Release Management & Status meetings to discuss testing status, configuration management, deadlines and all QA related aspects.
- Hands on experience with SAP Lumira, SAP BOBJ Analysis Edition for OLAP and Microsoft Office 4.1
- Experience with Remedy, HPQC (Quality Center), SAP SolMan, CHARM, Tableau.
- Using SAP HANA SP7 as a data source and also working with SAP BI 7.3 with SAP HANA as a database.
- Experience with SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
- Hands on experience with writing custom SQL for HANA modeling.
- Knowledge of SAP HANA Life Cycle Manager for Transporting Information Model in HANA Landscape.
- Configuring BODS Import server to read SAP ECC tables to SAP HANA.
- Experience with Extracting Internal sales/customer data from SAP and Non-SAP sources to HANA box using SLT.
- Hands on experience on SAP HANA sidecar approach and scenarios.
- Worked with Flat file, BODS to load data CRM (CRM PRICING/VA02/VA05), SD to HANA.
- Understanding of SAP BODS Workbench to extract SAP ECC extractors to HANA.
- Experience with using Query, Case, Source Based CDC, Target Based CDC, History Preservation, validation, Merge and SQL Transforms.
- Working knowledge on SAP HANA Live - for SAP HANA delivered calculation views.
- Working knowledge to map KPI to Reporting Dashboards requirements.
- Validating HANA Models and knowledge of comparing Object Versions.
- Setup and Working with SAP HANA SLT replication and Audit Trails.
- Create Data Source for SAP ECC and BODS and Connecting to SAP HANA.
- Working knowledge on SAP BODS workbench to bring in SAP ECC data to HANA.
- Ability to create Schemas, Packages and Analytical Privilege.
- Knowledge of SAP HANA administration and hands on experience in modelling HANA views.
- Expertise in Dashboards Design/Xcelsius/Design Studio, Web Intelligence, Crystal Reports and Advance Analysis for OLAP
- Dashboards Design using WSDL links, and Query Browser(OLAP)
- Strong experience in creating WebI reports with BEx queries.
- Organizing, Publishing & Scheduling Reports from BI Launch Pad
- Experienced in creating BICS-OLAP Connections, Data Foundation Layer, Business Foundation Layer, Multi-Sourced Universe with Information Design Tool (IDT)
- Experience in pulling data from multi-source systems like Teradata and SAP.
- Excellent knowledge in Report Publications and Scheduling.
- Involved in BOBJ Upgrade Experience from 3.1 to 4.1 and 4.0 to 4.1
- Experience in migrating Webi, universes and crystal reports BOBJ upgrade from 4.0 to 4.1.
- Ability to work on CMC, user security, OLAP connections. Debug issues related to report performance.
- Monitor CMC core services and back up/shadow BOBJ admin activities’.
- Sync Users with BI Security using SSO.
- Experience in BOBJ auditing activities, User Management, Content Management, Application Management and Server Management
- Creating SAP BOBJ Design Studio dashboards to replace existing Web Application Designer Reports
- Extensively use of Business Objects reporting functionality such as Master Detailed, Dynamic Filter, Slice and Dice, Drilling methodology, Ranking, Sections, Input Controls, Graphs, Breaks, and highly formatted reports with cross tabs tables.
- BI Reporting & Analysis - Ad-hoc Queries, Query Designer, BEx Analyzer, Information Broadcaster
- Built Data Models using Multi-Dimensional Modeling (MDM).
- BW Operations - Data load management, Job scheduling, Loading (Full /Delta Up-Load), Process Chain Monitoring, Data Reconciliation, APD & Open Hub Services.
- Experience in implementing and working with Self-service cubes. Multiproviders, DSO and infoobjects.
- Expertise in preparing of user manual/guides and conducting various workshops for user training.
- BW Extraction - FI -AP, AR, GL, HR (LSO, ERC, PA, OM, PD, Benefits, Payroll), MM, SD-LO-Cockpit, Extractions from ECC. Generic Extractors based on Tables, Views & Function Modules.
- Experience in HR- LSO Module and building reports.
- Performance Tuning - Data load and Query performance by maintaining Aggregates, Compression, Partition, Indexing of Infocubes, Number Range Buffering, OLAP Cache Monitoring and use of BW Statistics.
- Experience in building complex BEx queries and user exit variables.
- Strong experience in SAP Production support and Enhancements, coordinating business requirements and offshore team leading capabilities.
- Strong experience with SAP BOBJ Publications and bursting to large user base
- Strong experience in Process chain monitoring and database sizing activities PSA, Change log maintenance activities.
- Experience with Month close activities with business users using R1410.
- BW Transports - Transport strategy, Object Collection & Transports Movements across Landscapes
- BW Security - Security Role Matrix Requirement Gathering & Analysis, User Profile Maintenance & Testing
- Followed & Implemented ASAP methodology, creating Functional, Technical specifications.
- Used Solution Manager for Document repository and Change control management
- Involved in POC and COE activities at Infosys for SAP BOBJ 4.0 BOBJ Data services (BODS).
- Ability to create and assign Analytics Privileges to User groups.
- Creating user dashboards with SAP Lumira, Visual Intelligence and Predictive Analysis tools.
- Knowledge of configuring Modelling Content and Metadata Import.
- Experience with creating SAP HANA Attribute Views, Analytical Views and calculation views.
- Build universes on top of HANA Analytical views and integrating with BOBJ Reports.
- Experience in building and maintaining SQL Stored procedures, both from Oracle DB and HANA standpoint.
- Working knowledge of UNIX, shell scripting.
- BO XI R2, BOBJ 5.1.7, BOBJ 6.5, Desktop Intelligence, Universe Designer, Supervisor modules, Report bursting and scheduler.
- Administrative activities, maintaining user groups across Functional Departments with supervisor module.
- Experience in migration projects from BOBJ 5.1.7 to BO XI R2.
- Sound knowledge of Testing practices and Informatica.
- Vast experience in executing, leading Production support projects in SLA models.
- Building new SLA models and strategic meetings with business partners.
- Experience in mentoring teams at onsite and offshore.
- Experience in managing all stakeholders like upstream / downstream business partners, offshore, onsite, business and Client technology teams.
- Experience in working with various teams for GAP analysis of requirements and project Assessment.
- Responsible for Resource planning, estimation and pipeline projects prioritization.
- Good knowledge and exposure to client presentations.
TECHNICAL SKILLS:
Database(s): ORACLE 9i/10g, OWB 11, DB2 UDBMS SQL Server 2005, MS Access, Teradata, SAP BW.
ETL Tools: Informatica Power Center 6.2, Business Objects Data Integrator
Data modeling Tool: Star Schema, Snowflakes Modeling, Erwin 4.0
BOBJ Tools/Modules: BusinessObjects XI R3.1/R2/6.5.1 SP4/5.1.8, Web Intelligence, Advanced Analysis,XI R3.1/R 2/6.5.1/5.1.7 , WebI SDK, Broadcast Agent, ZABO, Crystal, Xcelsius 2008, Voyager, QAAWS, Live Office, Admin Tools including CMC, CMS
Reporting Tools: BusinessObjects, Crystal Reports, ActuateExcel 2000/XP, OBIEE and Hyperion IR, Tableau 8.1
GUI/ Development Tools: Designer and SQL Navigator, TOAD, Java Script, CSS
Programming Languages: C, C++, XML, Oracle PL/SQL, ASP and NT Shell Script
Operating System: UNIX, Windows 95/98/2000 /NT/XP, Sun Solaris 6.x/7.x
AREAS OF EXPERTISE:
- SAP BI 7.0
- Agile/Iterative development methodologies
- SAP BOBJ 4.0
- On - site/offshore coordination
- Data modeling and universe design.
- End to end Implementation and production support
- Leading user requirements sessions
- Defect Management. FRS, TRS and testing documentation
PROFESSIONAL EXPERIENCE:
Confidential, San Ramon, CA
SAP BOBJ Sr. Consultant
Responsibilities:
- Involved in Design, Development and stabilization of BOBJ HR Enhancement Project.
- Designed and developed 4 Webi reports for Managers Self Service reporting for supervisor level employees.
- Designed and Developed HR operational Dashboard with 6 Metrics for namely TTA, TTS and Span using QAAWS connection sourced from SAP BEx query.
- Worked on Building New Universes and Modification of Headcount Universes in BOBJ 3.1
- Responsible for migrating reports from Dev to QA and related admin activities.
- Consolidation of BICS connections for the Module and Transport Management for BOBJ.
- Designed and developed 3 HR LSO reports for HR learning Team
- Involved in Requirements gathering, Technical Specs, design, Implementation and test phases of the project.
- Involved in Stabilization of total 18 reports + 1 Dashboards and fixing user queries and Data testing in QA.
- Good understanding of the BOBJ security roles for MSS reporting.
- Involved in developing Tableau reporting for HR Power user group.
Confidential, Santa Clara, CA
SAP BOBJ HANA Sr Consultant/ Business Analyst
Responsibilities:
- Lead overall BOBJ/HANA implementation
- Experience in building reporting solutions for BPC data - Balance sheet P&L Reports and Headcount.
- Building complex BEx queries and connecting to Business Objects Suite tools for reporting.
- Building Universes in IDT for SAP HANA Views and Customer analytics data in SQL databases.
- Building SAP Dashboards for headcount data using Query Prompt filters, BPC EPM Connector to achieve complex “What-If” kind of scenarios.
- Extracting data from SAP BI using SLT and Flat file approaches for quick Data - Analysis.
- Experience with BODS building Data flows and transformations and load to HANA.
- Experience working with Query, Merge, Case, lookup transformations.
- Setting up Custom access levels and security in BOBJ CMC.
- Defining processes for BOBJ version management through CMC- Promotion Management.
- Vast experience in creating highly formatted reports in Web Intelligence.
- Creating End to end solutions for reporting including BOBJ admin and User security.
- End user training on Explorer and Information Views,
- Connecting Report Elements to Dashboards with QaaWS for Headcount BPC reports.
- Adding EPM component data grid for “What if”, Write back functionality to cube from Dashboards.
- Connecting Web Intelligence reports with Live office and user training.
- Creating SAP BOBJ Design Studio dashboards for Headcount data.
- Extensively worked on Element Linking and Document Linking reports using charts, tables, double sliders for reporting. Analyzing data with detailed and summarized reporting scenarios
- Extensively used IDT universes for HANA and SQL databases as source data. project creation and Synchronization for Multi-user environment.
- Creating Power user and Business users community and assigning access roles in BOBJ CMC
- Adding CSS components to BOBJ servers for unified template model across enterprise
- Setting up BOBJ SSO in BOBJ Dev and QA boxes.
- Experience in migrating WebI, universes and crystal content- BOBJ upgrade from 4.0 to 4.1
- Implementing WebI reports with multiple data providers in the sane WebI tab.
- Improving WebI report runtime by reducing the number of parallel call to OLAP cubes and filtering the same in BOBJ report.
- Creating Cascading prompts, using Custom Hierarchies in BLX of IDT for Universes
- Developed POC reports on SAP Lumira for user community and training.
- Publishing WebI report and dashboards on Mobile devices through WebI Rich Client.
- SAP BOBJ Analysis Edition for OLAP 4.1, Exporting Analysis workspaces to BOBJ Design Studio and Connect to an SAP Business Explorer (BEx) query using an OLAP Connection.
- Experience in building WebI report with Drill features with tables and Charts. Summary and detailed reports.
- Creating SAP Lumira visualization documents and storyboards combining data from Multiple sources like SAP HANA, Excel and CSV. performing operation like merging datasets and creating complex visualizations.
Confidential, Sacramento, CA
SAP BOBJ Front End Lead
Responsibilities:
- Lead overall BOBJ Frontend implementation for Finance Implementation.
- Requirements gathering and Architecture BOBJ solutions, in SAP IS Retail.
- Identifying Report requirements, connecting with Customers to finalize on Functional Specifications and Technical specifications.
- Lead the Internal Bi Team on BOBJ reporting and user training.
- Developing Finance Balance Sheet, Profit & Loss Reports
- Presenting Architecture strategy for BI Reporting
- Guide Internal team on the various aspects of BOBJ and BI development.
- Reports review and validate performance of the BOBJ and BEx queries.
- Experience with Improving BEx Query performance using RSRT, RSTT, ST05 techniques
- Building aggregates and compresses cubes for great performance.
- Developing Process Documentation and Global Definitions to enable re-use of Metrics across reporting.
- Design, develop, test all BOBJ reports for Finance
- Experience in Publishing and SMTP server setup.
- Experience working on BOBJ admin CMC to create user groups, folders and access related issues mapping to Sap BI Security model.
- Setup process for technical signoff, documentation and Version control.
- Experience in requirements gathering for complex merchandising reports and developing POC for user sign off.
- Hands on experience in creating OLAP connections
- Experience using Input and output contexts and complex formulas at WebI and BEx Query side.
- Handled SAP Hierarchies as prompts in WebI reports and Input controls.
- Experience transporting Web intelligence, Crystal reports from Dev to QA environment using promotion management.
- Experience with Performance improvements for Dashboards and WebI reports run times.
- Creating Finance Dashboards with BEx Query as a source (Query Browser) and linking to WebI reports.
- Maintaining and gathering requirements for Report Publications and scheduling.
- Handled Design review meeting and approach meeting with Customer and technical teams.
- Experience working with Dynamic visibility and Dashboards components like Canvas, Selectors and Charts.
- Preparation of Unit test cases and Integration testing and communication to PMO.
- Experience with Improving BEx Query performance using RSRT, RSTT, ST05 techniques
- Building aggregates and compresses cubes for great performance.
- Working on FI Extractors and pulling data to build staging and reporting layers (0FIGL 4 and 0FIGL 10)
- Experience in writing Customer Exits for BEx variables. using CMOD.
Confidential, Fort worth, TX
SAP BW/BOBJ/HANA Production/Enhancement Lead
Responsibilities:
- Leading the overall SAP BI/BOBJ engagement in onsite/offshore capacity.
- Manage client expectations, status reporting, and feasibility for new requirements.
- Interacted with various internal business users & stakeholders to implement BW/BOBJ reporting projects from initial scope definition through analysis, design, implementation and On-going support
- Provided program and project management support for several BW releases
- Experience in working with IT teams and coordination with various business parties like, other Technology team, third party vendors and offshore onsite teams.
- Worked with BNSF Leads on various Business Value Adds, like: Query Optimization, Automating manual processes, Database savings techniques that brought a whole lot of savings to the client.
- Managing Integration issues & Features Supported/Not supported between SAP BW/BEx & SAP BOBJ 4.0 and project kick and UAT support.
- Designed and developed complex WebI reports and Self Service Environment
- Experience in handling SAP BEx- BOBJ 4.0 integration issues and workarounds.
- Converted BEx Analyzer Workbooks to BO Analysis and Report Designer report to Crystal report.
- Building Crystal report for displaying master and transaction data, using Group headers and sub-queries in the main report.
- Passing key values from sub reports to main reports for building crystal reports
- Experience with crystal reports, edit Data sources and re-mapping objects to the new data source selected
- Knowledge of building Advanced Analysis reports in BOBJ
- Designed and implemented passing of current user from WebI repot to crystal report where source is BEx query as username as prompt.
- Experience in building complex crystal reports with multiple data sources, Query Filters and Group Headers and calling from WebI reports.
- Building WebI Intelligence reports using Hyperlinks to detailed Charts
- Responsible for all BOBJ scheduling for various Business depts. For Month end, quarterly and yearly activities.
- Categorization of BEx reports based on priority, business need and availability for migration to BOBJ 4.0.
- Experience in setting up Scheduling and notifications for priority reports.
- Experience transporting Web intelligence, Crystal reports from Dev to QA environment using promotion management.
- Designed and maintained complex reports using multiple data providers, sub-queries, complex variables, filters, alerts, slice and dice, performed Drill Down Analysis.
- Participated in setting up process for Business Object 4.0 Change Management and Governance.
- Experience working with universe designer and IDT for OLAP connections based reports.
- Documented all the new 4.0 best practices for IDT, Analysis for OLAP, WebI and Explorer development.
- Building WebI Reporting, dashboards Design & Advance Analysis:
- Building Dashboards for HR-LSO modules for training /classroom and participations data, using Query Browser with Details tabs flowing to detailed Web Intelligence reports.
- Biding chart with query data using query data measure and query data dimension.
- Building alerts in dashboards using % and value based alerts.
- Conduct user interaction session for dashboards requirements by mock-up/static data presentation in PPT.
- Developing WebI reports for P2P, C2C, and H2R Business Areas.
- Working with extensively with OpenDocument URLs in Dashboards, for passing Multivalued prompts for dependent reports.
- Ability to create parent /child dashboards using flash variables.
- Experience in using various dashboards components such as radio buttons, sliding picture menu, and image component and query prompt selector.
- Identified use cases and bottlenecks to adopt SAP HANA in BNSF landscape.
- Knowledge on SAP HANA studio, creating universes on Analytic Views and using it SAP BOBJ.Responsible for end to end Projects and support functions.
- Involved in Business Blueprinting, Gap Analysis, Solution Designing, Data Modeling, ETL, Report Designing and Development, Production Deployment/Support and End-User Training
- Analyzed, Created & Reviewed Transport strategy during Cut-over activities & communicated the same with SAP Basis Team
- Experience in building/ maintaining custom extractors, user exit variables, start/end routines.
- Worked SAP Security team & Business to identify Security Matrix for Reports & LSO Self Service Environment.
- Planning for Nightly data loads for any new Module implemented and working on various performance initiatives to reduce loading time for timely data availability.
- Worked with Production Support team for performance Improvements of loads/Reports by creating Aggregates, Indexes for lookup & parallel processing of loads
- Worked on various minor and major enhancements projects for existing BW Reports across modules like HR - LSO, HR - ERC, HR - PA, HR - OM, HR- PD, HR - Benefits, HR- Payroll, FI - AP, FI - AR & FI - GL and CRM modules.
- Experience with SAP MM Purchasing modules 2LIS 02 HDR and 2LIS 02 ITM, Activation of Standard reports.
- Experience in improving query performance using Query Cache, RSRT debug and defining aggregates.
- Working with CKF and RKF for BEx reporting.
- Working with CMOD code for master and transaction data.
- Experience in debugging issues on IDOCs and daily loads failures.
- Build Info Objects, Info Sources, Data Sources, PSA, InfoCubes Multi Providers, Data Store Objects (DSO), APDs, Info Packages, Transformations (BI 7.0), DTP - Data Transfer Process, Aggregates & Open Hub Destination.
Technologies and Tools: SAP BI 7.0, SAP BOBJ 4.0, Solution Manager, HPQC and Remedy.
Confidential
SAP BI BOBJ consultant
Responsibilities:
- Building Complex Universes with pre-defined Conditions
- Develop Highly Complex BO reports using Drills, Hierarchies and Prompts
- Handling Client calls, users requirements, building Functional and Technical specs.
- Estimation for end-to-end reporting requirements and Data Modeling.
- Participating in all the Data Modeling. and Design Discussions to proceed for the Tech Spec.
- Handling the BCA scheduler, where reports are busted directly to users as required.
- Tested business critical reports in Business objects R3.1 environments and converted some of the key reports to use connections on top of BEx queries.
- Resolving Complex Tickets, resolving with SLA.
- Handling all BO admin Tasks with supervisor module like creating user groups.
- Preparation of Unit test cases and Integration testing
- Experience with migrating BW BEx reports onto enterprise portal.
- Working with BOBJ admin, BASIS team for security and user groups’ access. And migrating users to BOBJ using windows AD sync up.
- Exported the Reports to the Broadcast Agent, and used the Broadcast Agent server to Schedule and Monitor the Reports.
- Created WSDL using Query as a Web Service (QaaWS) from different Data sources.
- Using Java SDK, configure the sever with plug-ins and build scalable web applications that manage and distribute reports and documents, and also provide functionality for administrative and client tasks.
- Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
- Created Cascading Prompts on the Reports.
- Handling batch Monitoring issues and resolution of Production batch issues from the report front.
- Communication with multiple stake holders, to ensure the production system functions smoothly and the system is up before the user’s business hours.
- Collection of stats and Daily reports to client on the performance and suggesting the batch performance improvements and supporting month /year end SAP BI and BO activities.
- Handling all small enhancements, migration and architectural aspects of the project.
- Responsible for Version control of code and documentation
- Scheduling Crystal report to File server and linking to SAP NetWeaver portal for Organizational wide usage.
- Resource planning, allocation and project planning
- Experience working on sample mock up reports for Departments heads using Xcelsius.
- Presentation of Value adds documents to the Client Managers and accommodate for further enhancements.
Technologies and Tools: SAP BI 7.0, BOBJ 6.5, BOBJ XI R2/R3, Oracle Warehouse Builder, Unix.
Confidential
SAP BW BOBJ Sr Consultant
Responsibilities:
- Developing Infoobjects, DSO, Infocubes, Multiproviders and BEx queries using Query Designer
- Requirements gathering and user training sessions
- Creating Meta data repository for all queries by megaspores/areas and acted as a QA control.
- Building Business Objects Web Intelligence reports.
- Experience in designing DTP’s and Transformation.
- Created several ABAP user exits for BEx reporting purposes.
- Extracted data for various data sources FI-GL, FI-AP, and FI-AR data from R/3 to BI.
- Used the extractors 0FI GL 14, 0FI GL 10, 0FI AP 4 and Custom data sources for the above Data sources.
- Extracted the GL data onto the open hub interfaces which the business uses.
- Extracted data for CB-COPA from R/3 to BI
- Responsible for Onsite/off-shore Coordination, preparation of detail design, code walkthrough, resolving technical and design issues and performing independent unit testing
- Preparation of Technical and Functional Spec documentation
- Process chains monitoring and resolving issues and developing complex Excel formulas based BEx workbooks.
- Designed, developed, deployed and maintained universes using Business Objects designer.
- Created Web Intelligence Rich Client reports with Metadata using Metadata Universe.
- Used Aggregate Navigation with compatibility filters in universe to restrict the hierarchy.
- Tuned and Enhanced Universes with SQL Queries for the Report Performance.
- Created user defined @prompts and complex conditions at Universe level for better performance
- Handling Quarterly and Monthly maintenance activities and communication with business users.
- Integration and regression testing of all defects moving to production.
- Generated Reports from Different Data Providers in Business Objects using Oracle Database.
- Created Analytics on top of Metrics for the Performance Manager.
- Implemented Filters, conditions in the Universe to the run the Reports quickly.
- Created Single Sign-On for many reports using the URL functionality to access them directly.
- Created Analytic Dashboards for upscale users on the Financial Actual Budget and Target Budget.
- Created Views, Stored Procedures and validated data for the Performance.
- Used the Broadcast Agent Server to Schedule and Monitor the Reports.
- Prepared universe for Ad-hoc query functionality to educate users.
- Audit reporting system implementation on UAT and Production Environments.
- UAT was one of the important processes developed during this project.
- Handling allocation of tasks and effort estimations and participation in all design level meetings with onsite and business teams.
Technologies and Tools: SAP BI 7.0 Business Objects 6.5.1, XI R2, Oracle 10g, Essbase Hyperion Analyzer, DB2, Sun Solaris, Web Logic
Confidential
BOBJ Sr Consultant
Responsibilities:
- Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL*Plus, SQL*Loader and Handled Exceptions.
- Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
- Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
- Designed the front end interface for the users using Forms 6i.
- Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
- Created custom reports using Metadata Manager repository as a source
- Building universes and managing the check integrity options to ensure no syntax errors in universes
- Ensure no loops in universes, if any resolved them by creating aliases and fan traps
- Run batch jobs for loading database tables from Flat Files using SQL*Loader.
- Transporting universes and WebI intelligence reports and version control management
- Opened tickets in the Tracker for Reporting purpose to track all the Report statuses purpose.
- Created Process Chains for all the above data models that I developed to automate the loading process.
- Working closely with end user with info view and user training issues.
- Provided end-user training and knowledge transfer on all aspects on the implementation process.
- Performed Production Support Activities to take care of loading Adjustment files for supporting month end closure. Resolved several production support issues like fixing load failures during the execution of process chains.
Technologies and Tools: Windows XP, Oracle 9i/10g, TOAD, Business Objects XI R2, 6.5.1 SP2-SP4, Web Intelligence 6.5.1 SP2- SP4 and InfoView
