Senior Sap Business Warehouse Resume Profile
NJ
HIGHLIGHTS:
- Over Twelve plus years of experience in client/server and web technology, including around 10 years of experience in OLAP/OLTP/DSS Data Warehousing presents distinctive competency in Oracle Database Administration, SQL, PL/SQL, Microsoft SQL Server 2005,2008 , and other Business Intelligence tools such as Business Objects, Cognos, Qlikview, Tableau.
- Extensive experience as a Team lead in designing and building BO Universes under Data warehouse environment, developing complex canned reports and maintaining Security with Business Objects and directing the team in a right way and mentoring the team.
- Experienced with various Data Warehousing activities includes right from gathering business requirements, conceptual designing, doing logical data modeling, creating approved data model as a Database, mapping from source to target includes ETL design , Designing Universes in Business Intelligence, creating Reports, development, testing and deployment.
- Expertise in all modules of Business objects suite comprising the BO Reporter, Designer, Supervisor, Web Intelligence XIR2, Desktop intelligence, Central Management console, Life Cycle Manager, Import Wizard, Publishing Wizard, Report conversion tool and Performance Management
- Commendable knowledge in resolving FAN Traps and CHASM Traps and resolving Loops in both OLTP and Data warehousing environments.
- Configured BO to get data from SAP BI 7.0 with SAP BO Integration kit.
- Developed and designed BO universes with Classes and Objects using SAP BW Info Cubes to generate WEBI Reports.
- Experienced to work with various version control tools like PVCS and Clear case.
- Highly experienced in implementing Dashboards using Dashboard Management / Performance Management in Business Objects 6.5/ XI R2.
- Experienced with various Data warehouse schema techniques like STAR, Snow flake, Hybrid, Multi STAR etc. and implementing techniques for slowly changing dimensions SCD .
- Willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal.
- Received several prestigious awards in GMAC/Ditech from Business world for implementing Business Objects Best practices.
TECHNICAL SKILLS:
Operating Systems: UNIX Solaries 2.x , IBM AIX 5.2, and Windows95/98/NT/ 2003 Server
Languages: SQL Plus, PL/SQL, XML, JAVA script, HTML DHTML VB Script and Visual Basic 5.0 6.0
RDBMS: Oracle7.x 8.x/9i/10g SQL Server, DB2 UDB, MS Access.
Software Packages: MS - Excel, PowerPoint, Word, TOAD, PVCS.
ERP Packages: SAP R/3, SAP BW 3.5, SAP BI 7.0
ETL: Datastage vers 5.x,6.x,7.x ,8.x- Designer, Director, Manager, Administrator, Informatica Power Center 8.x
OLAP/ DSS Applications: Business Objects 4.1.4 5.1.2,6.5,Xi R2 /R 3.0 - Designer, Supervisor, Business objects use module, Broadcast Agent, Central Management Console, Set Analyzer, BO Auditor and Report Conversion Tool, Import wizard, Xcelsius, Life Cycle Manager, BO SDK Web Intelligence2.5, 2.6, Xi, Info view, ZABO, Performance Manager and Crystal Xi., Cognos Impromptu, Cognos Transformer, Power Play, Report Net 8.x
EXPERIENCE:
Confidential
Senior SAP Business Warehouse
- Involved in interacting with various Module leads in identifying the BW Reports which currently being used.
- Involved in LIPA Regression Testing, analyzing the BW Reports for HCM, FI-CO, Procurement and Fleet modules.
- Involved in interacting with Offshore team in getting the deliverables and updating the management about the work status.
- Involved in Blue printing, Business requirements discussion, and developing business requirements document as per PSEG template.
- Creating and loading the data in to PSA and testing the results against Bex Query.
- Designing queries in Bex Designer and executing the Bex queries in Bex Analyzer for test results.
- Writing Unit Test documents as the process of Change Management.
- Involved in SAP BW and BOBJ Run books review and suggesting the changes to the development team.
- Developed Power point presentations and prototypes in SAP BO and BW functionalities and capabilities in transforming the data from other data sources and integrating into SAP BW and generating the reports using Business Objects.
- Loading and monitoring the data in DSO and infocube and testing the data with source in the process of unit testing.
- Involved in Crystal Reports Unit Testing, as part of Enterprise Change Management and test the results for any errors or any data mismatch.
Environment: SAP Business Objects 3.1, Crystal Reports, SAP Business Warehouse BW , Informatica
Confidential
Senior SAP Business Warehouse and Business Objects Consultant
- Involved in Webi Report Development of the Ticket status reports.
- Interacting with Business Analysts and also various functional teams like Finance GL, AP, AR, CO-PA and Logistics SD, and MM in understanding the client requirements and resolving the production issues.
- Created various Complex reports using Business Objects Universes and SAP BW BEx as the data providers.
- Involved in testing of DB2 database upgrade on DB1 system.
- Refreshing the Universe structure when the Base Queries are changed or enhanced to Multiproviders at the BW side.
- Analyzed BEx Queries and underline base queries in the resolution of the production tickets.
- Preparing Technical Design documents and Time Estimations for the L4- RAD projects.
- Analyzed Infocubes, MultiProviders, DSOs, and Infoobjects in process of developing the reports based on BEx queries as the data provider.
- Worked on Advanced Analysis reports created based of BEx queries.
- Creating Dashboards using Xcelsius.
- Involved in Production support and ticket resolution.
- Responsible for interacting with clients and other Business stakeholders in getting their reporting requirements completed.
- Creation of new universes and reports for various SAP modules and involved in migration of Business Objects platform 3.1 to Business Intelligence 4.0
- Involved in SAP BI backend support as well as converting Bex queries to Webi reports and involved in report enhancements from minor to major changes in the existing reports or to new project development.
- Provide time and resource effort estimation for any new development.
- Involved in creating new universes base of BeX queries.
Environment: SAP Business Warehouse 3.x, SAP Business Intelligence 7.3, ABAP Customer Exits, User Exits, SAP Business Objects 3.1, SAP Business Objects 4.0, MS Advanced Analysis, Business Objects Explorer, Crystal Reports, SAP Business Warehouse BI 7.3
Confidential
Senior SAP BI/Business Objects Architect
- Worked on SAP Business Objects BOBJ and SAP BI reporting applications for Hasbro Managerial Services.
- Involved in Process Definition and Release Management Process/Version Management for the BI Reporting for the organization.
- Interacting with Business Analysts and also various functional teams like Finance GL, AP, AR, CO-PA and Logistics O2C, and MM in understanding the client requirements and resolving the production issues.
- Involved in development of enhanced requests and defects resolution.
- Analysis of Business Requirements and documentation of Technical Design Document.
- Tasks include: Report Migration, Universe Migration, 24X7 on call production support, Break fixes, new Projects / Enhancements.
- Security Administration and maintenance of users and folders: Providing the folder access to users depending on their role viz, Analyst, Editor, Refresher, Viewer.
- Infoburst schedules, Monitoring bursts, Re-run the failed jobs, Analyzing the failed bursts.
- Server administration, monitoring slow running jobs, start up and shutdown the servers.
- Report Performance and Production Issues.
- Validation of the WEBI Reports post-migration 4.0.
- Working on On-Shore and Off-Shore Model.
Environment: SAP Business Objects 3.1, SAP Business Objects 4.0, HANA, ABAP USER EXITS, Crystal Reports, SAP Business Warehouse BW , Informatica Power Center 9.1, SQL Server
Confidential
Senior BI/ETL Analyst
- Worked on SAP Business Objects BOBJ and SAP BI reporting applications for Chase Global Finance Technology.
- Developed ETL mappings and transformations for complex requirements using Informatica Power Center 9.1
- Involved in Reverse Engineering process from Abinitio graphs to Informatica mappings.
- Working on On-Shore and Off-Shore Model.
- Developed generic reusable Mapplet to validate control file with the data file for Record Count and Hash Amount check.
- Worked extensively on different transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, Unconnected Connected lookup, Normalizer, SQL and Sequence generator.
- Extensively used parameters for Connection names, Schema names and File names. Parameter name and values are stored in a table and Parameter file is dynamically created using the shell script and extensively used Push Down Optimization on various stages of the project to increase the performance by pushing the transformation logic to Source/Target/Full.
- Prepared MACRO and MICRO design documents.
- Effectively used Teradata Parallel Transporter connection to load the data into Teradata tables.
- Extensively used Informatica client tools Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Workflow Manager.
Environment: Ab Initio, SAP Business Objects, Crystal Reports, BEX, SAP Business Warehouse BW , Informatica Power Center 9.1, Teradata, SQL, Flat files, DB2, UNIX Shell Script, Taradata SQL Assistant, Windows XP, Cognos Profile Tool, Abinitio
Confidential
Solution Architect
- Solutions architecture and consulting Architecture and designing solutions meeting the technical and business needs of an enterprise, and participating in consulting engagements for conducting enterprise architecture assessment and /or roadmap studies.
- Research and Innovation exploring latest technical trends in BPM, BI, Open source Business intelligence applications, and evaluating various BI tools and frame works.
- Business Development providing technical inputs to business proposals, participating in consulting or pre-sales engagements and other project management activities.
- Reviewing the technical architecture and design for various projects.
Environment: Informatica Power Center 9.1, SQL, SAP Business Objects XI 3.1, Qlikview
Confidential
SAP Business Objects Module Leader
- Developed DWBIS reporting solutions using Business Objects.
- Involved in report design document and sign off from the client and in preparing request for proposal.
- Interacting with the client for gathering requirements and freezing the scope of the requirements.
- Involved in designing the universe with multiple fact tables, aggregate tables with minute level granular data.
- Influencing the data model team as per the reporting requirements.
- Developing the Brokerage, Client analysis reports for survillence process
- Involved in TOP N Broker, Client and Security across all exchanges, Trade details and Order Details reports, with aggregate and second level granular data for the client and Broker reports.
- Implementing security across the SEBI Users for Survillence and Investigation departments.
- Involved in QA and UAT teams facilitating with BO Dev team in resolving defects encountered during QA and UAT.
- Primary contact in interacting with SEBI for any report mockups/technical issues/user training.
Confidential
Senior Business Objects/ETL Analyst
- Handled Incident Management through USD and involved in Change Management policies and procedures for promoting universes / reports in to different environments.
- Design, Develop and maintained very complex monthly Compliance reports to determine the Loans that are out of compliance in each channel. Highly visible since loan officers can be terminated if violation occurs more than three times.
- Created and administered various universes for the Consumer Lending Services division and financial data mart universe for the financial division of the company.
- Business Objects Best practices have been strictly followed while designing Universes as well as creating BO Reports.
- Involved in creation of Xcelcius loan-level dashboards for the senior management.
- Automated Document Scheduling, Publishing and Distribution of Webi and Deski reports to various users.
- Configured CMS database on XI R3.1.
- Used Import wizard to import all the content from XI R2 to XI 3.1
- Involved in major Migrations of Business Objects from 5.1/6.5.1/XI R2 and in migration from Business Objects XI R2 to XI 3.1.
- Created aggregated tables and materialized views in the oracle database for Business Objects reporting and created SQL scripts and PL/SQL stored procedures for HMDA reporting.
- Maintaining the production and development environments.
- Modified existing Universes by rectifying with appropriate techniques to meet all reporting requirements.
- High interaction with Business Users, Business Owners, ETL/data base team to know their Business views in developing and modifying Universe accordingly.
- Developed and maintained data and reporting applications including design, development and maintenance of Business Intelligence, data distribution and reporting functions directly accountable to over 1500 users.
- Extensively worked with CMC Central Management Console in implementing various levels of security for users and user groups.
- Participated in Disaster Recovery planning, Standard operating procedures, and Architecture of GMAC Busobj environment.
- Experienced with all Administration tasks of Business Objects Enterprise using Central Management Console of BO XI R2/R3.0
- Most complex Universes and WEBI Reports were created to meet the users reporting Requirements.
- Loops, Different Traps issues have been resolved while designing BO universes.
- Both Functional and Technical design documentation were created and conducted inspections for Business Approvals.
- Installed and implemented different patches like SP1, SP2 AND SP3 to take the advantage of new capabilities.
- Created profiles in conjunction with publications to personalize the content that users see while viewing Desktop Intelligence documents.
- Involved in writing stored procedures and sql scripts for the reporting purposes and involved in ETL process for Enterprise Customer Repository ECR .
- Extensively worked on Datastge Designer, Director and Manager Components of the Ascential Datastage.
Environment: Business Objects XI R2, Business Objects XI R3.1, Xcelcius, Microsoft Office, Crystal Reports, Desktop Intelligence, Web Intelligence, Dashboard Builder, Business Objects Designer, Central Management Console, Crystal Reports, Oracle 10g, Microsoft Excel, Microsoft Sharepoint Portal, Visio 5.0, Datastage Designer, Datastage Director, Datastage Manager 8.x
Confidential
Application Team Lead
- Involved in the implementation of Real time data on to the Portal for the real time metrics and involved in the preparation of the technical document from the user requirement Specs.
- Assigning the tasks to different BO users and Portal Developers.
- Coordinating with different teams viz, Data team, Data Model Team and also with Infrastructure team while deploying the applications in different environments.
- Meeting with the BO Development Team and Portal Development Team for the status updates etc.
- Involved with Portal Development Team in deploying the code on different environments and involved in understanding of Reporting Requirements for Loan Operations Reporting.
- Worked closely with Business Analysts in the understanding of the reporting requirements.
- Imparted the training sessions to the Business Analysts on Business Objects functionalities and capabilities which helps the Business Analysts for more analysis and feasibility of the user requirements.
- Designed Universes with multiple dimensional tables and fact tables for Stips and Vendor Management.
- Created the Business Objects Reports for the Loan Operations audience viz, Loan Managers, Credit Analysts, Associates etc.
- Created some of the reports like Team Reports Associate Reports, Credit Analyst Reports which are integrated to the Manager's Portal for the real time Metrics like and created Dashboards and Scorecards using Application Foundation for more personalization of the reports.
Environment: Business Objects 6.1.a, Web Intelligence 6.1a, Business Objects Designer, Business Objects Supervisor, Broad Cast Agent, Publisher, Application Foundation, Oracle 9i, Oracle Reports 6i, SQL Loader, Microsoft Excel, Visio 5.0, HTML, DHTML, CSS, Java, JMS, JSP, J2EE, XML, XSL, XSLT, Web logic portal 8.1, Web Logic Server 8.1, Informatica Powercenter 7.1, Informatica Power Analyzer 4.1.1
Confidential
Application DBA/ Data Modeler
- Involved in preparing Application Standards for Data warehousing Applications.
- Performed major role in understanding the business requirements and designing star schema and loading data into data warehouse ETL .
- Involved in the evaluation of OLAP tools like Cognos, Business Objects and Microstrategy.
- Extracted the data from RDBMS like Oracle 8i and Red Brick Database.
- Involved in Re-organization of the database, purging data and dropping of the tables, which are not required in Data staging area.
- Worked on Testing, Development and Q/A databases.
- Regular monitoring of Databases and generating a report of Health Checks.
- Creating Database Objects, Indexes and creating Database users, Roles and Privileges.
- Implemented Partitioning of tables, Bitmap indexes, Parallel Query and Materialized Views.
- Involved in developing of SQL Scripts, involved in Tuning of the applications and involved in size estimations.
- Installed SQL Server 2000 on Windows NT boxes.
Environment: Oracle 8.1.6, Brio, Microstrategy 7.0, Informatica 4.7, Abinitio, SQL Server 2000, SQL/PLSQL, HP-UX, Toad, Qdiagnostics, Erwin, UNIX Shell Scripting.
Confidential
Oracle DBA
- Involved in Installation of Oracle Server, Client and Application Tools.
- Database Monitoring.
- Creating and Managing Users
- Exports and Imports
- Configuring OEM, Management Server
- Creating RMAN and Recovery Catalog
- Implementing Sun Clustering, Parallel Server
- Tuning the test database
- Worked on Toad
- Monitoring Production database.
Environment: Oracle 8.1.6, PL/SQL, Sunsparc, Toad, Erwin