SUMMARY:

• SAP Certified Business Objects 4.2 consultant with over 14 years of experience in IT industry with over 12 years of experience in SAP Business Objects/Business Intelligence & Business Warehouse with 4 complete lifecycle implementations involving data modeling, data extractions, installation, configuration, report development, administration and performance tuning. Extensive front - end experience with BEx Query Designer/Analyzer; Expertise in BW-HANA-BO integration development using BOBJ tools - BI Launchpad, CMC, CMS, CCM, Universe Designer, IDT, Confidential, Crystal Reports, Xcelsius, Design Studio, BODS, BOBJ Explorer, Mobile BI, QaaWS, Live Office, JCo, BIWS & BICS, SAP Design Studio, SAP Lumira.
• A dynamic professional with more than 14 years of rich experience in BI tools, Architecture Design Technology Integrations, System Analysis, migration processes, Requirement gathering, Reports and Dashboards design and Distribution, Data Warehousing Technologies.
• Extensively worked on BI 4.1 suite, Installation, configuration and integration of systems, design, development and production rollout of Business Objects reporting Application.
• Extensively worked on SAP BI 7.3/BW components like Info Cubes, Multi-Providers, Info Source, Info Objects, ODS/DSO objects, Update/Transfer rules, Transformations, Extraction structures such as LO Cockpit and Generic.
• Extensively worked on Data services and developed complex mappings as per the requirement using almost all transformations and effectively used Debugger for identifying errors and resolving them.
• Experience in complete automation of all BW Daily, Weekly and Monthly loads (Info Package Scheduling) using Process Chains
• Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake, FACT and Dimensions tables, slowly changing dimensions (SCDs).
• Worked on Transfer Structures, Transfer rules, Communication Structures, Update Rules, User Exits, Scheduler, Roles, Info sets.
• Proficient in IT Change Management Operations with experience in configuring and troubleshooting various networking, hardware / software related issues and Strategic planning to slash support expenditures by leveraging offshore resources.
• Adept in end-to-end development of software products from requirement analysis to system study, designing, developing, testing, de- bugging, documentation and implementation.
• Excellent people management, mentoring skills with the ability to train and motivate cross cultural teams in optimizing their abilities in Customer Relationship Management.
• A proactive team leader with abilities in devising effective strategies geared towards enhancing business, evaluating client’s requirements, custom designing solutions.

SIGNIFICANT STRENGTHS:

SAP BI 7.3: Having profound experience in BI 7.3 version and Administration workbench (RSA1), Customized Info Objects, Info Sources and Info Cubes. BW front end both in BEX and Web Application Designer.

BI Suite: BI 4.1/4.2(BOBJ), XIR3, BO 6.5, Design Studio 1.6, Analysis for office, Xcelsius, BI4.0 Crystal Enterprise, Live Office, Lumira.

Data Warehousing: Data Services4.2 (Data Integrator11.7/11.5 DI Scripting Language, Profile Server, DI Designer, BO Composer). Informatica Power Center V7, Informatica Power Mart 6.2/5.1/4.7/4.5/3.5 , Repository Manager, Designer, Erwin 4/3.

Dimension Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modelling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modelling, Erwin 4.5/4.0/3.5/3. x, Oracle Designer.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, Teradata 14.0, MS SQL Server 2005/2008, Db2, AS400, Informix (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints).

Operating Systems: AIX Servers Windows 2003 for Citrix servers

Languages: Java, C, C++, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Seattle

BI Architect

Responsibilities:

• Designed and developed the long-term reporting strategy on Episode of care, Appointments, Surgical case and Encounter modules.
• Involved in development of Hospital billing data marts and integration of Epic and Cerner data marts
• Developed the universes on Physician profile, Surgical case data marts and developed the Confidential reports based on user stories.
• Involved in Epic upgrades and updated the universes and fixed the report issues based on the Clarity changes.
• Developed the prototype Episode of care universe on based on user stories and trained the users on ad-hoc reporting.
• Oversee the Epic Crystal reports schedules and provided the support for BI 4.2 enterprise administrative tasks like user security and server monitoring.
• Developed the gap analysis on Encounter data mart and involved with Data model team building the Encounter data mart based on the reporting requirements.

Environment: BI 4.2, Epic, Cerner, Netezza, SQL server, Aginity work bench

Confidential

Sr. BI/HANA Consultant

Responsibilities:

• Extensively worked on design studio and developed the execute Key KPIs dashboard on Billings, Bookings and Inventory areas for the higher management team.
• Extensively worked on CSS Class (Using HTML5), On select, Conditional Formatting, assigning target data sources for selected components
• Developed components using Eclipse as extension from Design Studio to make the dashboards more interactive and used the visual studio components
• Experience in developing composite providers in BW and developed complex Bex queries based on user’s requirements
• Extensively worked on BW on HANA and created composite providers, ADSO and developed the information model on HANA with complex SQL scripts in Calculation views.
• Involved in SAP HANA Administration including creation and management of schemas for different SAP systems, data model objects, and import/export content.
• Created and maintained delivery units and packages in SAP HANA for import export process.
• Extensively worked on Data provisioning options like SLT, FLAT file and DXC.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Extensively worked on BODS and loaded data from SAP application to HANA database with ABAP data flow and used lot of transformations like merge, validation and lookup.
• Developed components using Eclipse as extension from Design Studio to make the dashboards more interactive
• Created complex Confidential reports on Bex queries and extensively worked Analysis for office for analyzing the data.
• Experienced in data modelling and developed analytical views for the transactional data, attribute view for the master data and the calculation views as final model in Hana studio.
• Worked on Finance OLAP data analysis with SAP LUMIRA tool and involved in users training.

Environment: BI 4.2, Data services 4.2, Design Studio 1.6, Windows Server 2003/2008, Oracle, SQL Server, DB2, BW 7.5, Hana and Tomcat, Web sphere.

Confidential, CA

Sr. BI Consultant

Responsibilities:

• Involved in Housekeeping administrative tasks, monitoring EPIC schedule processes with info burst tool and involved in on-call routines.
• Extensively worked on Cadence data mart and involved in development of Appointment universe.
• Involved in developing the Transplant data mart and developed the Transplant universe based on user stories.
• Developed the complex Confidential reports on case-management, ClinDoc, laboratory, and therapy departments
• Worked extensively on Info Burst tool for distributing the reports to different user groups.
• Extensively worked on Hospital Billing data model and developed financial reports on EPIC clarity data base.
• Worked on Tableau reports and developed the dashboards on clinical/census data and oversee the administration of Tableau.
• Developed complex crystal reports on clarity database with command objects and scheduled the reports to shared drives.
• Extensively worked on performance tuning of complex Confidential reports, Crystal reports and tuned the Confidential servers.
• Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones

Environment: BI 4.2, Design Studio 1.5, EPIC application, Windows Server 2003/2008, Oracle, SQL Server, and Tomcat, Web sphere.

Confidential, FL

Sr. BI Developer/Lead

Responsibilities:

• Interacted with business users in understanding the reporting requirements and functional specifications
• Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones
• Serviced as Project Manager and successfully managed complex projects with rapidly evolving requirements through implementations, coordinated with project leads, development teams and testing teams
• Providing status updates and participating in calls with the client
• Managed user, user groups and controlled user access using Central Management Console. Involved in installation 4.0 and upgraded 4.1 sp4.
• Designed and developed small data marts basing on report requirements.
• Involved in requirements gathering, data modeling, planning/scheduling data extraction from source systems
• Created various Confidential reports on FMS system universe using input controls and drop-down filters and provided interactivity to the reports.
• Worked with SharePoint Team to integrate Dashboards, Reports into SharePoint Portal and Info View for end user access
• Created OLAP Universes on Hyperion cubes using Universe Designer and Information Design Tool
• Created Xcelsius Dashboards for HR Metrics (Head count/Turnout), MRS system (Delay count analysis)
• Connected to the BW (Bex Query) back end and Universe to design the Design studio application
• Worked on CSS Class (Using HTML5), On select, Conditional Formatting, Assigning target data sources for selected components
• Developed complex dashboards using with QAAWS and query browser connections.
• Extensively used design studio1.3 to develop the POS system dashboards.
• Extensively used HP Quality Center for developing test cases and development life cycle.
• Hands on experience in HTML 5 code and extensively used in design studio dashboards.
• Provided end user training for interacting Confidential reports and the dashboards and created help documentation and provided as a link within Confidential reports and dashboards

Environment: BI 4.1, Design Studio 1.5, Windows Server 2003/2008, Oracle, SQL Server, DB2, BW 7.3, Teradata and Tomcat, Web sphere.

Confidential, FL

Sr.BI Consultant/Architect

Responsibilities:

• Worked closely with SME’s, functional specialists (SCM) and process owners to gather detailed business requirements and translated the requirements in to technical design documents.
• Worked extensively on BEX Analyzer in building Queries for BO reporting and user reporting also build workbook for users and broadcasted on daily /weekly / monthly schedule.
• Extensively developed Bex queries using Variables, formulas, Hierarchies, Calculated and Restricted Key Figures, also used conditions, Exceptions & Structures.
• Developed and Enhanced Profit Center Accounting cubes, Accounts Payable cubes, Accounts Receivable cubes, Purchasing, Sales Order, Sales Delivery and Sales Billing Info Cubes
• Expert in Data modeling, Designing, Creating & Maintaining Multiproviders, Info Cubes, ODS, Info Objects, Infosets, Info Sources, Data Sources. Worked through layered architect model.
• Worked with ABAP team to build customer exist variables, lookup and extraction user exists.
• Created Info Areas, Application Components, Info Objects and Info Sources to build Master Data Tables, ODS Objects, Info Cubes and Aggregates.
• Created Virtual Providers from HANA models
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View
• Involved in Information Design Tool - Creation of Data Foundation, Universe for HANA reporting
• Designed and executed migration plan to migrate data from existing SAP ECC and BW to the SAP HANA database
• Configured SAP HANA Studio and BOBJ reporting engine to prepare a POC for subsequent use in customer projects and engagements
• Responsible for creating and maintain QS BI dashboards like Spend, Key KPI and Transactional.
• Developed numerous classical and interactive reports for MM, SD, SCM, and FI/CO modules. Developed bank reconciliation report
• Responsible for creating PDF documents automatically from existing QS BO dashboards and
• Users will be able to pick-n-mix multiple charts/graphs from different dashboard areas (e.g. Channel Spend from Spend area and Collections from Transactional area).
• Designed complex Crystal sub reports with Linked and Unlinked sub report and used different Custom functions.
• Extensively worked in data analysis on Hana views with SAP LUMIRA tool.
• Worked extensively on design and development of complex Confidential Reports with multiple data providers like universe and BW BEx Queries.
• Excellent experience in Building and Maintaining Interactive Dashboards using SAP Business Objects Dashboards with Query as a Web Service (QaaWS), Live Office, Query browser, Business Intelligence Web Services (BIWS) and SAP Net Weaver BI Connections in business areas like sales performance, inventory, implant trend, pricing, forecast, profit & loss, finance, compensation.
• Extensively worked on creating BICS and RDMS multiproviders connections in IDT (Information Design Tool)
• Designed Data Foundation (. dfx) using multiple data sources using IDT.
• BI 4.0 SP 2.0, Windows Server 2003/2008, SAP BI 7.3, SAP Net Weaver 7.3, SQL SERVER 2012.

Confidential, FL

Sr.BI Consultant/ Administrator

Responsibilities:

• Involved in BI4.0 installation process and extensively used Upgrade management tool and migrated content from BO3.1 to BI4.0 and report conversion process t from Confidential to Confidential .
• Created Server groups, Nodes, SIA (server Intelligent Agents) for efficient management of BI4.0. Added services and configured the servers to improve the performance.
• Improve the impact of Business Objects reporting on D3 - target the reports consuming the most in D3 resources, educate the users on their individual impact, modify reports and universes that are high consumers (BI reporting, Visual Analytics)
• Developed complex Confidential reports that involved complex calculations, grouping of dimension objects and measures with extensive usage of linking Confidential reports and using advanced functionalities like Optional prompts, Merge function, Custom SQL at Report level.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Designed Universe Schema by inserting tables (from backend data source) into the structure pane in designer and developed Classes and Objects (according as per business terminology) in the Universe pane
• Responsible to acknowledge all new incidents, Tickets were opened by all business objects users. Complete the RM’s within the given lead time, assigned by the Team manager.
• Responsible to providing day-to-day support with emphasis on maintaining the stability and availability of the Business Objects Enterprise environment.
• Optimize processes running on D3 - identify the most impactful processes and improve them (BI reporting).
• Providing expertise on report tuning against multiple data sources including Oracle, SQL Server, DB2, Informix and Teradata.
• Prepared all the documents related to project - Business Blue Print, Technical Design Document, Traceability Metrics, Design document for Optimization process on - Scheduling process, ETL, Source Tables Mappings, etc.

Environment: BI 4.0, AIX 5.3, Windows Server 2003/2008, Oracle, SQL Server, DB2, Informix, Teradata and SAP BI7.0, Tomcat, Web sphere.

Confidential, Redlands, CA

Bobj Architect

Responsibilities:

• Involved in gathering business requirements, functional requirements and data specifications for BW cube, Confidential reports and Xcelsius dashboards on various modules like SD, CRM, MM, FICO, and SCM.
• Connected Xcelsius dashboards with Confidential reports by using Open document functionality.
• Developed the Xcelsius Dashboards with multiple drilldown functionality and connected Confidential reporting with OpenDoc functionality.
• Developed various Multi-chart models that connect to real-time enterprise data using Query as a Web Service (QaaWS).
• Developing Standard POS reports (Daily POS, Assortments, Daily Bulletin, Product Line Detail, Product Movement, Weekly Summary, and Year-end Inventory Carryover) Confidential reports.
• Worked extensively on BEX analyzer and BEX browser. Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Used ODS to stage the data before transferring the ODS contents to the Info Cube. Done ODS reporting to give details of delivery and schedule line items

Environment: BOBJ 3.1, Oracle 11, SQL SERVER 2005, ECC 6.1/ R3, SAP BI7.0, Windows.

Confidential, Providence, RI

Sr. Business Objects Developer/Lead

Responsibilities:

• Developed and implemented Universes by defining joins, cardinality between tables, created derived tables, prompts and queries, Hierarchies, applying contexts and alias tables to remove cyclic dependencies using Business Objects Designer.
• Developed complex Web Intelligence Reports & Crystal Reports using Merged Dimensions and Ranking features.
• Extensively used various techniques like Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alters and sections to develop the Confidential reports.
• Created Dynamic & customizable data visualization Dash Boards using Xcelsius 2008.
• Expertise in developing Static and Live Flash enabled Xcelsius dashboards with dynamic refresh.
• Involved in Configuring integration between Business objects Enterprise and SAP BW servers through Integration kit.
• Created real time reports using crystal report connecting to tables and Info set in SAP ECC.
• Analyzed BW Crystal reports and converted in to Confidential reports.
• Implemented Best Practices in Universe designing and Reports Development.
• Trained and mentored less experienced BO and Crystal Reports developers on building their skills to assist in the development and testing of new reports.
• Working with linking universes and developed Confidential reports by using multi data providers.
• Controlling senior management and corporate reports to ensure consistent information delivery and complete data validation.
• Worked with various business groups and arranged multiple user hands on training sessions for ADHOC reporting
• Created Confidential reports with multiple data providers and synchronized the data using Merge Dimensions option in BO

Environment: BOBJ 3.1, SQL SERVER 2005/2008, ECC 6.1/ R3, SAP BI7.0, Windows.