SUMMARY

• Over 8+ years of professional experience as a software developer in designing and development of Data warehouse and Business Objects Reporting Applications up to the releases of BO 4.1.
• Expertise in using Business Objects Enterprise products like UDT/IDT, Dashboards, CMC, Web Intelligence (Web I)3.1/4.0, Crystal Reports Enterprise, Xcelsius 2011.
• Extensively worked on Dashboards in SAP BI 4.0 for Visualization of Complex Dashboards Development with multiple tabs, graphical objects, to present the data using Universe and other data sources.
• Worked Extensively on Business Objects Xcelsius, Performance Manager, Dashboard Management and Scorecard Manager. Created Dashboards with connections like QAAWS & Web services with Live Office as a Middleware in prior BOBJ versions.
• Worked on creating, organizing, and scheduling reports using Central Management Console (CMC), Infoview and BI Launch Pad. Created User profiles, groups and security for BI end - users.
• Expert in designing/maintaining security using Central Management console.
• Created security at object level and row level in Business Objects
• Strong working experience on Xcelsius Dashboards Using Universe & Crystal Reports and WebI Reports as a Data sources and also used SAP Netweaver BW Connection for SAP BEx queries.
• Good working experience on Tableau 8.0 as Developer and Administration.
• Participated in all phases of Project Life Cycle including Analysis, Design, and Development, Test and Deployment cycles and Performance Tuning.
• Involved in 3 full life cycle implementation projects
• Strong Hands-on Experience in Large-scale Data Warehousing Projects.
• Extensive knowledge of SQL and PL/SQL including creating and maintaining Stored Procedures, Functions, Packages, Triggers and Cursors.
• Strong Experience working as the Integrator between Business and Technology solutions. Prepared Technical specifications for the development of Universes and Reports.
• Strong data analyzing experience in designing and implementing Universes using Business Objects Designer.
• Experience in Interacting with Business Users to analyze the business process and transforming requirements into screens, designing database, documenting and rolling out the deliverables.
• Experience in dealing with customer especially in Business Analysis and Production Support Phase.
• Expertise in complex Data-Architecture design & Data-Modeling: consolidating diverse platforms & legacy systems into ODS, Source systems analysis, Gap analysis and Impact analysis.
• Experience in creating Customized and Adhoc reports using Business Objects Full Client and Web Intelligence (WEBI) tool.
• Experience in Designing, Testing and Deploying BO Universes. Developing WebI reports with various functions like Input Controls, Graphs and Breaks, Drill down& Drill Up, Slice and Dice.
• Expert in resolving Business Objects Loops and Traps.
• Experience in migration of universes, classes, objects and reports from one BO Version to another.
• Experience in the usage of Live Office Function to embed data from Business Objects into MS Office tools.
• Had hands on experience developing complex Dashboards using Universe and BEx data sources.
• Developed interactive Dashboards using different data sources using QaaWS, SAP Net weaver BW Connections and Query Browser (BO 4.0) on top of both SAP and Non-SAP sources.
• Extensive experience in Performance Tuning Measures like using of Aggregate Tables, and Shortcut Joins.
• Expert in dimensional modeling for Data marts.
• Expert in the BI Testing process in functional unit testing, data validation & integration testing.
• Hands on experience with the extended star schemas, multi-dimensional Data modeling.
• Comprehensive experience in gathering and analyzing the requirements from end-users and trained users in Business Objects.
• Flexible in learning New Systems, Programs and Procedures. Exploring the New BO Products like Explorer, Design Studio, OLAP Analysis for MS Office, SAP HANA as part of expanding skills.
• Excellent Communication, Leadership, Trouble-shooting and Self-motivation skills.

TECHNICAL SKILLS

BI Tools: Business Objects BI 4.1/4.0/3.1 SP3/XIR2/R3,XI/6.5 (UDT/IDT, Dashboards, Xcelsius, Webi, Crystal Reports, CMC, Design Studio); Tableau 8.1/8.0/7.0

ETL Tools: Informatica Power Center 7.1.1, SSIS

RDBMS: Oracle 7.2/8i/9i/10g, SQL Server 2000/2005,IBM DB2 UDB8.0/7.0, Teradata vR5

Operating System: Unix/Linux, Windows (9x/NT/XP/2000), Sun Solaris 7/8

Programming Languages: C, Java, COBOL, SQL & PL/SQL, ASP.Net

Web Servers: Apache Web Server, Tomcat 5.5 & IIS

Others: TOAD, Erwin, SQL*Plus

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

Tableau Resource

Environment: Tableau 8.1/8.0, Business Objects 4.1/4.0, Oracle11g.

Responsibilities

• Develop efficient visualizations using Tableau 8.1 desktop to provide details and insights of performance of key metrics of web analytics data to analyze Sales and Marketing performance.
• Use Tableau Desktop to analyze and obtain insights into large data sets.
• Create visually compelling and actionable interactive reports and dashboards.
• Created Parameters, Quick filters and Action links to achieve desired functionality and filter data on dashboard.
• Used various components like scorecards, alerts, tabs, dropdown boxes, Combination chart, bar chart, Radio buttons, and value in user interface.
• Developed Performance Management Dashboards to set Goals, Measures and monitor KPI for Balance Scorecard initiatives.
• Designed & Developed Supplier Scorecard system Dashboard using Tableau tool, to automate rating of suppliers and to generate a scorecard that helps in evaluating the performance of suppliers on a regular basis.
• Created executive summary and vendor and category scorecard dashboards, including hierarchical selectors, KPI level sales and marketing information based on live SAP data.
• Created Delivery, Quality, and Price factor universes built in Information Design Tool (IDT).Analyzed the data in charts using slice/dice, drill up/drill down.
• Built Multiple Adhoc Web I reports connected to BI services pointed at Web Intelligence blocks.
• Solution is an integrated system it makes use of Dashboards and Web I together and solution is published in the Client’s portal for access by Users based on their respective Authorizations & Roles.
• Modified/Migrated some of the existing dashboards/sheets and published them on server and portal using Tableau tool.
• Performed Unit Testing, Integrated Testing coordinating with Business Users. Provided Functional & Technical Documentation as required by Client.
• Involved in Writing Detailed Level Documentation for Dashboards, Reports and Universe design as well.
• Provided Post Go-live support and addressed any issues at each implementation / Phase.

Confidential

Senior SAP BOBJ Dashboard Developer

Environment: Business Objects XIR3.1/BO 4.0, Webi XIR3.1 / 4.0, Xcelsius 2008, SAP BW 7.0, Windows XP

Responsibilities:

• Gathered the reporting requirements & analyzed the Gaps. Created the Report Layouts & Design Documents for development.
• Based on the OLAP Connection to SAP Bex Queries, I have created WEBI Reports and graphs for multi-dimensional analysis using Slice & Dice, Drill Up and Drill Down functionality.
• Used various functionalities like Breaks, Sorts, Ranking, Report Filtering, Query Filtering, Alerts, Sections, Slice and Dice.
• Developed Desk I Reports using functionalities like cross tab, master detail, drill down, using filters, breaks, alerts and formulae.
• Created user response objects, user prompts in various Desk I Reports.
• Created Xcelsius Dashboards based on the Webi reports.
• Created custom Functions and exported them to the repository and used them in other reports.
• Created Change Impact Analysis Document to estimate the time involved in Changes to the project.
• Worked with Business Objects performance manager.
• Created reports in Business Objects using functionalities such as Master/Detail, Slice and Dice, Cross Tab, Drill Down, Alerts, Breaks, Sorting, Ranking and Charts. Solved Chasm Traps, Fan traps and Loops using Contexts methods.
• Modified Core Universe by creating objects according to the requirements.
• Linked Universes to share the Universes which had common dimension tables and the classes and objects.
• Created Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created full client and Web I reports. Modified the existing by adding new columns based on the result set.
• Responsible for developing all types of reports including Cross-tab reports.
• Responsible for Migrating the Business Objects Universes/Reports across the Servers/Repositories (Development to Production Servers).
• Involved in support, for fixing the bugs reported from System and UAT test and keeping track of the bugs
• Conduct Quality Assurance and Performance Tuning of the reports in BOEXIR3 environment.

Confidential, Culver City, CA

BI Developer

Environment: Business Objects XIR3.2, Crystal Reports, SQL Server 2005, Visual Studio.Net, Access, Windows XP

Responsibilities

• Working on design, development and implementation of different modules at different stages.
• User Interface deployment for all Live Venue, Music Payrolls and provided functionality for different Payrolls into automation.
• Developed User Interface for all Weekly, Bi-Weekly, Monthly and Semi Monthly Payrolls.
• Worked with a Team to develop a complex universe and generated reports exclusively using WebI.
• Created Deski Reports using user variables, aggregates and other functionalities.
• Created Web I reports with more than 10 data providers and synchronized the data using the merge dimensions option.
• Designed reports by using different functionalities like drill down, using calculations with variables, comparing with previous year data to get change % etc.
• Developed Adhoc reports for end users like Cost Code Reports, Positing Reports, Payroll Summary Reports, Check Register and Several Invoice reports using Business Objects and Crystal Reports.
• Used Visual Source Safe as version control tool and followed strict procedures to eliminate code duplication and redundancy.
• Analyzed existing data towards new requirements and created Queries, Stored Procedures and Functions for the system and implemented them using T-SQL.

Confidential, Downey, CA

SAP Lead/BO Consultant

Environment: Business Objects XI 3.1, Universe Designer 3.1, Web Intelligence 3.1 (WebI),Import WizardCentral Management Console (CMC), ODS, Data Warehousing, Erwin, Data Mart, Microsoft SQL Server2005, SQL Server Management Studio, T-SQL, Scripting

Responsibilities

• Successfully led the Business Intelligence reporting component of the Human Resource System (HRS) project. The new BI reporting component replaced an existing legacy reporting tool while adding additional functionality, speed, and flexibility.
• Facilitated JAD Sessions with business users. Gathered requirements for 200 operational reports to be distributed to over 135 active school districts. Determined the Key Performance Indicators (KPIs) and ad-hoc reporting requirements.
• Created Users/Groups/Sub-Groups & assigned profiles there by restricting un-authenticated access to resources.
• Designed, developed, and implemented the Business Objects HRS Universe includes creation of classes, objects, measures and solves loops by creating contexts.
• Provided user training for the HRS Universe as well as documentation, maintenance, and ongoing design upgrades when translating from the ODS to the Data Mart.
• Created and provided oversight for over 50 Business Objects WebI 3.1 reports
• Documented business rules to assist with verification of the reports and ad-hoc data.
• Associated with Team in Migration from Business objects XIR2 to Business Objects XI R3.
• Dealt with issues involved in migrating Crystal Reports from 7.5.1 on Oracle 9i to XI, which is on SQL Server 2005.
• Worked closely with the DBA’s and end users in the development of SSIS mappings and tuned existing mappings for better performance

Confidential, Costa Mesa, CA

Sr. BO Developer/User Support

Environment: Business Objects XiR3/R2, Import Wizard, Info view, SQL, Web Intelligence 6.5, Xcelsius and Apache TOMCAT 4.1/5.0.27, MS SQL Server 2008, Teradata VR3, Microsoft Visual SourceSafe.

Responsibilities:

• Responsible for ongoing user support to help developers, end users in resolving technical and environmental issues which involves development, access related and performance issues.
• Worked with other business analysts to interview clients and capture simple, moderate and complex business requirements. Collaborated with business technicians to research existing business and system processes.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users
• Responsible for creating universes and reports for the management based on the sales data, Membership, IM and insurance using Designer and WEB I.
• Created complex variables/formulas, multiple breaks, sorts in the reports according to the Business Requirements
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, list of values (LOV), calculations, etc. Created Objects, Predefined Conditions, and Joins in the Universe.
• Applied aggregate awareness to speed up query time.
• Involved in the Migration of various objects(crystal reports, desktop intelligence reports, web intelligence reports, universes, business views) from one environment to another
• Creating Link objects in the universe to implement the report linking in reports to drill to a detail report.
• Used Open Document Function in link objects and also Open Analytic function to use reports in Application Foundation Portal.
• Trained the power users/end users in Business Objects.

Confidential, Reston, VA

Sr. BI Consultant

Environment: Business Objects Xir2, Live Office, Info view, SQL Server 2005/2008, SSRS, C#, Dundas Enterprise, Windows XP, Web Intelligence 6.5,Xcelsius and Apache TOMCAT 4.1/5.0.27, MS Office 2003, Microsoft Visual SourceSafe.

Responsibilities:

• Gathered User Inputs and incorporated business requirements to generate functional specs and subsequently created customized reports.
• Created Universe from the scratch and deployed it in different environments.
• Created various objects in Designer using built-in @functions, aggregate awareness, short-cut join, Derived Tables at Universe Level for Query performance Enhancement.
• Created Complex Reports using Drill down, Cross tab and Charts (time series graphs, column, line, pie). Used the drill functionality, ranking, sorting, complex alerter and complex variables in full client reports.
• Created WEBI Reports using Alerts, Filters, Breaks, Sorts and Ranking.
• Used multiple data providers such as Universes and Personal data Files in Generating reports.
• Provides Support to the Web Users and Full Client users for any specific or performance Issues related to deployment.
• Scheduled Reports and also delivered them to end users to their email through the Scheduler.
• Created Dashboards, Scorecards using Business Objects Xcelsius.
• Designed and developed required design patterns which frequently repeat throughout the development
• Developed front end using Html Server Controls, ASP.NET Web Controls, CSS and AJAX.
• Created Web User Controls using C#, ASP.NET.
• Designed and developed some business intelligence reports using SQL Server Reporting Services 2005 and integrating it to the front end application.
• Developed Application level tracing and configure the application using Web.config.
• Developed Charts using AJAX and DUNDAS v6.1

Confidential, Sunnyvale CA

Sr. Developer

Environment: Informatica 7.1, Erwin, Business Objects 6.5/Xir2 Designer, Supervisor, CMC, Web I, BCA Scheduler, Crystal Reports 9.0, SQL Server 2005, Oracle 9i,Seibel ERP, PL/SQL, Win NT

Responsibilities:

• Involved in Relational modeling with data analysis and normalization, Construction of Logical and Physical data models, Forward & Reverse Engineering and Data Warehouse/Data Mart Dimensional Data modeling with Dimensions & Fact Tables using Star Schema.
• Analyzed, the existing OASIS system for problem solving.
• Designed the ETL processes using Informatica to load data from DB2 UDB, SQL Server, Flat Files, (Fixed Width) and Excel files to staging database and from staging to the target Seibel ERP Data Warehouse.
• Mainly Worked on Seibel ERP for Install Base, Renewals, Product and Pricing.
• Performed data cleansing, data manipulations using various Informatica Transformations.
• Setting up batches/sessions to schedule the loads at required frequency using Informatica Server manager (Workflow manager/ Workflow monitor)
• Created various transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Sequence Generator etc
• Generated Reports with Universes using Business objects.
• Developed a complex universe and 2 other simple universes on oracle database and finally merged all the 3 universes into a single Universe according to the user requirement.
• Part of Report development created reports by extensively using multiple data provider’s @functions and inner query concepts to generate Thin client Reports.
• Created different Categories in the repository and published full client reports corporate documents to their respective categories.
• Migrated BO 6x repository to BO X1R2 repository using Import Wizard.
• Migrated universes and reports to PROD and DEV environments from BO 6x to BOXIR2 version to their respective folders using Repository Migration Wizard.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with reporting system and also to successfully implement business logic.

Confidential, NJ

Developer

Environment: Business Objects 6.5, Oracle 8i, PL/SQL, SQL Tools, Web I & Windows XP and Apache TOMCAT 4.1/5.0.27, Test Director 7.2.

Responsibilities:

• Converting high-level design specifications to detailed functional and technical specifications.
• Interviewing and coordination with end user communities, Finalized the BI strategy.
• Gathered Reporting Requirements and arrived at the Best Reporting Model using Business Objects teams.
• Designed, developed, modified and maintained Business Objects universe using Designer for adhoc and canned queries
• Created Joins, checked the integrity of the universe and resolved loops and traps using aliases and contexts.
• Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe
• Designed cascading prompts in the universe to filter the list of account names based on business units.
• Import and export universes and reports to and from the repository
• Created users, users groups and maintained user access rights for Business Objects universes and reports.
• Created reports and compare the daily sales using both tabular reports and 3-D graphical chart reports (bar graphs and pie charts.)
• Created variables, formulae and objects at report level.
• Generate reports using prompts, filters and conditions and testing these reports with all possible data for consistency.