SUMMARY

• 6 years of IT experience in Business Intelligence applications and Database management systems.
• Extensively worked on multiple versions of SAP Business Intelligence platform.
• Involved in Full Lifecycle implementations of SAP Business Objects applications.
• Extensive experience in Business Objects XIr2, XIr3.1, 4.1 versions and Crystal reports 11 and Crystal Xcelsius 2008.
• Experience in Administering the BI System using CMC (User Management, Migrations) for specific user group with Project level access.
• Extensively involved in Business Objects upgrade POC from 3.1 to 4.1 using LCM and played key role in application migration.
• Extensively involved in SAP BI upgrade process from 3.1 to 4.1 and worked on report conversions.
• Extensively involved in Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling and designed Data models.
• 3 years of extensive experience SQL skills building Free hand SQL reports and Good noledge in coding PL/SQL Packages, Stored Procedures, Views, indexes, Function and database Triggers. Experience in using SQL*Plus, Toad 7.6.
• Experience in designing multiple interactive dashboards in Advance Analytics using Spotfire.
• Mentored Business Users about creating Adhoc reports using WebI and Launchpad functionalities.
• Extensive experience in professionally interacting with all levels of the user community, Effectively executed multiple tasks and assignments on time.
• Expertise in troubleshooting complex issues like data issues or performance issues.

TECHNICAL SKILLS

BI Tools: SAP Business Objects (Version Xi3.1 to BIP4.0/4.1), OBIEE 10.1, 11.1, Micro Strategy (6.5, 7.x), Cognos 7/8 (IWR, Power Play), SAP Crystal Reports

BI Analytics: Tableau, Spot fire

ETL: Informatica, SQL LoaderData Transaction Server (DTS), Data Junction, Data Stage 7.0 and

Modeling: Erwin 3.5/3.5.2, Visio Enterprise

RDBMS: ORACLE 11i/11g, SQL Server 7.0, Teradata 12

Languages: C, SQL, PL/SQL, XML, HTML, JavaScript, VBScript and Shell Scripts

GUI: Visual Basic

Tools: Oracle Application Server, TOAD, Apache web server, TomcatDBArtisan, IIS 5.0

Web: ASP3.0,, MS Visual InterDev 9.0, FrontPage 98

OS: HP - UX 10.2, SCO UNIX, Solaris, Linux, NT, Windows ME/98/95, DOS

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Business Objects Developer

Responsibilities:

• Created prototypes of the reports for user presentation in the process of requirements gathering.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Interacted with Business community to gather and analyze the Business Requirements in developing and modifying or creating a new Universes and building the reports.
• Resolved Chasm traps, Fan Traps & Loop problems by using contexts and aliases to reduce the complexity of the universes.
• Extensively used the @functions, worked on back end functions, procedures, tables, views required by the business objects universes
• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.
• Improved the performance and reduced the coding with the use of @functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes.
• Created custom List of Values (LOVs) for better understanding of prompts by the end users.
• Defined Customized Hierarchies in Universe level.
• Applied User and Group Restrictions in selected objects in universe level based on User and Group.
• Designed and developed WEBI reports, created charts and graphs for quick analysis.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Preparation of Critical, Master Detail, Sub Reports, Cross Tab and Summary reports using Crystal Reports, features includes functions, running totals, parameters and conditional formats.
• Created Dashboards using Crystal Xcelsius for senior management for business decision making.
• Built POC developed Dashboards and Scoreboards for detailed analysis using Xcelsius.
• Provided user support and training in using Report Designer for creating Adhoc reports.
• Involved in Installation, upgradation and troubleshooting the Business Objects Enterprise install or configure issues.
• Created new users in XI 4.0 using Central Management Console and set restrictions, assign privileges based on their profiles.

Environment: Business Objects XI R4.0, CMC, Designer, Info view, Crystal Reports XI 2011,Toad, SQL, PL/SQL, Oracle 10g,WebLogic 10.3g, SQL Server.

Confidential, Overland Park KS

SAP Business Objects

Responsibilities:

• Performed Business Analysis and user requirements collection.
• Analyzed the data model and identified heterogeneous data sources.
• Created Report Templates for consistency in the look and feel of the reports.
• Created Sales, Financial, and Margin Analysis reports for different divisions within the company.
• Created Cascading dynamic parameters in Universe to allow the end user to select prompt filter data.
• Managed business objects application components including user groups, folders and repository objects and implement the row level security.
• Utilized advanced concepts like aggregate awareness for optimizing the universe
• Resolved loops using Contexts and Aliases.
• Resolved Chasm Trap and Fan Trap using Contexts and Aliases.
• Used various @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters) and @Select.
• Created various geographical and time dimension reports of Fiscal Year, Quarter, Month, Week and daily reports.
• Participated in Business user meetings, detailing reports delivered and solving relevant issues.
• Participated in status meetings and prepared status reports highlighting key issues and constraints and updating the status of work program items.
• Fixed #COMPUTATION, #MULTIVALUE Report errors.
• Worked as a part of Business Objects production support team to provide halp to the end users.
• Collaborated closely with client managers, architects, DBAs and business users.
• Extensively worked on translating end user reporting requirements into an optimal universe design.

Environment: Business Objects XI R3.1, Web Intelligence XI R3.1, Xcelsius, Crystal Reports XIR2/10, Oracle11/g/10g, SQL Server, SQL Developer, TOAD, Excel, MS Office.

Confidential, Chicago, IL

Business Objects Developer

Responsibilities:

• Analyzed Business Processes and the already developed Scope of the support project
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Involved in Installation and Configuration of all products of Business Objects.
• Worked on Business Objects Administration like CMC and CMS maintenance & security issues
• Assigned privileges to users and groups using Supervisor.
• Worked in setting up the CMS and Audit database, Input and Output FRS repository systems.
• ImplementingSecurity Features of Business Objects like row level, object level and report level to make the data secure
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Used designer to create Universes and resolve Join Path Problems utilizing contexts and Alias tables.
• Designed and developed Universes and reports according to user requirements.
• Constructed different types of reports, such as Master/Detail, Cross Tab and chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Created linked universes and developed Complex reports that involved multiple data providers, Master/Detail charts, cross tab charts and complex variables and calculation contexts.
• Created prompts, conditions and filters to improve report generation. And also used Alerts to the report.
• Scheduled the Business objects documents for automatic refresh and to different destinations.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Worked on Implementing the LOVs, Hierarchy's, Pre-Defined Conditions, Resolving Database Connections, Adding new objects to the Universes.
• Migration and Report life cycle management through different stages of production which includes Web Intelligence, Desktop Intelligence and Crystal Reports for BOXI R2,3.1
• Migrated the content from XIR2 to 3.1 using Import Wizard.
• Creating publications of both types me.e. Enterprise recipient and dynamic recipient
• Worked with SAP Technical Support to troubleshoot various Deployment and performance issues.
• Worked with DBA’s and System Administrators to back-up the repository and database and scheduled daily and weekly back-ups for both environment and repository.

Environment: Business Objects XI R3/R2, Designer XI R3/R2, XiR3.1, Desktop Intelligence, Crystal Reports 2008, Oracle 10g, SQL, PL/SQL, UNIX