SUMMARY

• 7 years of IT experience in Analysis, Design, Development and Implementation of Data Warehousing
• Business Intelligence: 6 years of Business Intelligence experience with complete life cycle Implementations using Business Objects 4.0/3.1/XI (Designer, Info view, Business Objects Reporting Business Objects SDK, Xcelsius, Web - Intelligence, Publisher, Data Integrator, Application Foundation & Dashboard Manager)
• Business Objects: 6 years of experience in installation and configuration of Business Objects. Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc. Experience in Business Objects Enterprise products namely Designer, Web Intelligence, CMC, Info View, Crystal Xcelsius, scheduling and publications.
• 2 years experience in loading huge amount of data into data warehouse using Business Objects Data Services. Development of mappings, Jobs, workflow, dataflow, transformations in Data Services to load the data from various sources.
• Data Modeling: 3 years experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals like Retail sales, Health Care, Financial and IT. Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake; FACT and Dimensions, slowly changing dimensions.
• Databases: 7 years of solid database experience in Oracle 11g/10g/9i, MS SQL Server 2008, (database triggers, materialized views, In-line views, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, TOAD.

TECHNICAL SKILLS:

Business Intelligence: Business Objects BI 4.0/3.1/3.0 (Designer, Info view, Web-Intelligence, Data Integrator XI, Xcelsius, Publisher, Designer and Dashboard Manager), SAP Business Objects Mobile, Business Explorer/Polestar XI 3.1.

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

ETL: BO Data Services 3.2 & 4.0 (Projects, Jobs, Workflow, Dataflow, Designer), Informatica Power Center 8.1 (Repository Manager, Workflow Manager).

Databases: Oracle 11g/10g, MS SQL Server 2008/2005, MS Access.

Programming: Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, Java, C, C++, Data Structures, Java Script, HTML.

Environment: Windows XP/7, Windows Server 20082003, Linux Servers.

SAP: SAP BW, BEX Query, SAP HANA Studio (Information modeler), System Monitoring, Attribute views, Analytical views, Calculation views, Data Provisioning, SLT Replication.

PROFESSIONAL EXPERIENCE

Confidential CA

Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather the Functional Requirements and business logics and converted the requirements to Technical Specifications
• Created Functional Requirements Documents, Technical Requirements Documents, Change Requests Documents.
• Developed universes, reports using Designer, Web Intelligence and created metrics and dashboards using Application Foundation.
• Exported the universes to the Repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main data Providers.
• Analyzed the existing Database and Data marts to design Universes by creating Classes and Objects
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts, Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equi joins as per requirement.
• Created objects using different Business Objects functionalities like @ prompt, @select, @aggregate aware in the process of designing the universes
• Tested Universes for Integrity and exported them to the Repository to make it available to the user groups
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters & Alerts for creating Complex reports.
• Created reports like Drill Down, Functions, Cross Tab, and Formulae for easy-to-use benefit information system by using Webi Reporting.
• Created Test scripts to test the universe and reports & Created UAT scripts for the business users to test the application.
• Manually performed System Testing, Regression Testing and Functional Testing. Generated Test data for identifying valid data, Invalid data, Partial data, and Bad data using SQL.
• Created Documentation to train end users.

Environment: Business Objects 3.1 SP3, Business Objects Enterprise, Xcelsius, Oracle 11g, SQL Server 2008/2005, Universe Designer, Web Intelligence Rich Client, Web Intelligence, Java Infoview.

Confidential, Wilsonville, OR

BI Developer- Business Objects/Admin

Responsibilities:

• Fulfilled the Business Objects development needs for various departments. And also performed the day to day admin tasks.
• Fulfilled Business Analyst requirements by completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test and Deploy & Maintain to successfully develop universes.
• Involved in establishing SAP BW connectivity with Universe Designer and Business Objects Infoview, using SAP Integration Kit.
• Worked with team of developers and administrator for Business Objects upgrade project.
• Involved in server sizing, server naming standards and 3-tier architecture during the upgrade
• Sunset existing publication tool (Info Burst) and re-create all the scheduled reports in the new Business Objects Publication.
• Worked as a backup administrator for Business Objects environment.
• Worked as a go-to person for Webi, Publication, QAAWS, BW/Business Objects Integration, Crystals.
• Extensively worked with CMC and Instance Manager.
• Responsible for HR (SAP HR) and IT (HP Service Manager) data mart support (End to End).
• Involved in Creation of Reports, Formatting reports, generation of charts and bars etc., as per user requirements using Web Intelligence and Xcelsius 2008.
• Created Webi Reports from multiple Universes and merged results in the report using Merged dimensions
• Worked with Database ranking, sub queries, combined queries and custom SQL queries
• Worked with tracking report changes.
• Created multiple Universes and implemented row-level security.
• Conducted Study to Build Universes Classes and Objects involving everyday terms that supports users. Object Properties defining measures, Dimension and Details were created.
• Designed Complex reports based on discussions with user groups and created various objects using built-in functions like prompt, select, where and Aggregate aware functions.
• Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using contexts and aliases. And also developed Hierarchies to support users with the option to drill down on reports. Also implemented user security.
• Used BEx Analyzer and Query designer to query and analyze SAP BW OLAP cubes.
• Developed Dashboards using Xcelsius 2008 components using maps, pie charts, Staked Bars, list views.

Environment: Business Objects 3.1/4.0 (CMC, Designer, Web Intelligence, QAAWS, Import Wizard, Report Conversion Tool, SAP Integration Kit), Xcelsius 2008, Oracle Data sources, SAP ECC 6.0 (HR), SAP BW, Business Explorer (Polestar) XI 3.1, BEX Query.

Cardinal Health, Ohio

Business Objects Developer.

Responsibilities:

• Interacted with Business Users and Business Analysts to gather the Functional Requirements and business logics and converted the requirements to Technical Specifications
• Created Functional Requirements Documents, Technical Requirements Documents, Change Requests Documents.
• Worked with Corporate Analytics Manager to understand different Data Sources (7) to support Xcelsius dashboard
• Created Views, Synonyms and PL/SQL Functions.
• Designed Multiple Universes from Oracle Data Sources and SQL Server Data Sources.
• Created Short Cut joins to improve query performance.
• Resolved loops in Universes using Table Aliases and Contexts to remove cyclic dependencies.
• Created multiple queries using multiple Universes and did Data Synchronizing using Merged Dimensions.
• Analyzed the existing Database and Data marts to design Universes by creating Classes and Objects
• Created Derived Tables, custom Measure Objects, Nested and Cascading LOV’s, Hierarchies for report Drill Down.
• Created Summary and Detail Reports by Creating different tab’s in the same report
• Tested Universes for Integrity and exported them to the Repository to make it available to the user groups.
• Experience with complex Business Objects reports including variables; alerts; using aggregate awareness; cross-tabs/Sub reports; slice and dice;
• Created Various graphs to show graphically the active and non-active projects and projects not completed on schedule
• Implemented security by using @BOUSER at the report Level
• Scheduled reports to Various Business Users, to refresh on schedules
• Categorized documents based on departments and users by creating folders
• Worked with Systems Administrators to resolve any environment related problems or outages, including managing and resolving trouble tickets for existing reports
• Provide input to project teams on best implementation strategy for potential customers, as well as provide guidance on the best use of the environment.
• Created Webi reports using Personal Data Files
• Created Complex queries in SQL using TOAD for Data Validation
• Created Audit Documents and Migration Requests to Move Reports and Universe from Development to QA Environment
• Created Test scripts to test the universe and reports
• Created UAT scripts for the business users to test the application
• Created Documentation to train end users
• Trained and Mentored the team members, Business Users, both IT and Non- IT on a continuous basis during the term
• Worked with Senior Management for Resource and Financial reports
• Worked with the Systems team to Migrate reports Through different Environments

Environment: Business Objects XI R3.1, Web Intelligence, Xcelsius 2008, SQL, TOAD, Oracle 10g, Microsoft Excel, SAP ECC, SAP Integration kit, SAP Business Objects (Polestar), Crystal 2008, SAP BI/BW.

Confidential, Lebanon, TN

Business Objects Developer

Responsibilities:

• Involved in Installation of all Components of Business Objects XI R2.
• Extensively worked on CMC (Central Management Console) in maintaining objects, Universes, Connections, Resources, Users, User Groups and Categories in Business ObjectsXI.
• Imported Users/Groups, documents (Web I and Desk I), Universe, Document, folders, categories and objects using Import Wizard.
• Managed the Servers using the Central Configuration Manager (CCM).
• Involved in the design/development of Universes, Classes, Objects and Conditioned Objects for Business Analysis and Report Generation.
• Used the functionality of linking universes so as to have the flexibility to use the objects defined in one universe in another.
• Created Shortcut Joins and Aggregate tables in Universe Designer to improve the performance.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
• Created Sub Reports and custom prompts in crystal Reports.
• Created Crystal reports using Business Views and Universes as data providers.
• Worked closely with Data Modelers in designing various Data cubes, Data marts, data warehouse schema techniques.
• Converting Logical data model into Physical Data Model and developed Oracle table creation scripts using Erwin tool.
• Responsible for reviewing and analyzing reporting requirements and translating them as per the requirement.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Developed Hierarchies to support drill down reports.
• Created various Analytics like Speedometer, Barometer and Interactive Metric Trends (IMT).
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries.
• Involved in User Acceptance Test (Universes and Reports) throughout the migration process.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Created Sub Reports and custom prompts in crystal Reports.
• Created Stored Procedures to retrieve the data faster and generate the reports quickly.
• Extensively work on scheduling and distributing the documents.
• Provided full support to the end user in production issues.
• Tested the reports and modified the relevant Objects in the Universe as per the user specifications.
• Involved in supporting end users in resolving issues related to Business Objects.

Environment: Business Objects XI R2 (CMS, CCM, CMC, Auditor, Webi),Oracle 9i, DB2,SQL*PLUS, Windows 2003 Server, Xcelsius, UNIX, Crystal Reports.

Confidential

Data Analyst/Business Objects - Data Integrator

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Data Extraction, Transformation and Data Loading.
• Exposure to Data Services Architecture, Data Services Objects, Data Services design interface, Data Stores, Importing metadata, File format.
• Involved in Validating, Tracing and debugging Batch jobs.
• Involved in extracting Data from JD Edwards using File Formats.
• Involved in complete life cycle implementation of Business Objects.
• Interacted with Business Users and Business Analysts to gather the requirements and business logics.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Design of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Creating and Formatting the Reports as per the Users Requirements using the features inBusinessObjectslike Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data. Creating and distributing Report Templates to Users.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.

Environment: Business Objects XI, Data Integrator, Web Intelligence 6.5, Crystal Reports, JD Edwards, Universe Designer, Data Integrator, Designer, Central Management Console, Oracle, MS SQL 2005.