PROFILE SUMMARY:

• 7+ years of experience in IT Industry, with expertise in developing Business Intelligence and Data Warehouse applications.
• Business Intelligence Consultant with a skill set of Business Objects 4.0/3.1/3.0/XIR2 and Crystal Reports 2011/2008, Crystal Dashboard Design (Xcelsius) 4.0/2008.
• Expertise working with SAP BI 4.0 (IDT, Universe Designer, LCM, UMT, BI Launch Pad, WEBI, BI Workspaces), BW7.3.
• Expertise using BOBJ 3.1 (Designer, DeskI, WebI, Rich Client, InfoView, CMC, Import Wizard, QaaWS, Publishing Wizard, Report Conversion Tool, Live Office, BI Services).
• Good knowledge in overall BI/BO 4.0/XIR3 application architecture and able to Design, Deploy, Support the application.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Created simple and complex reports involving Filters, Contexts, Hierarchies, Variables, list of values (LOVS), local variables, Alerter, Ranking and multiple data providers.
• Involved in Universe designing, developing and generating complex, Ad - Hoc, dashboard Reports, Business views along with User Acceptance Test and data accuracy test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Create and maintain SQL queries required to support BO reporting needs.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Proficient knowledge on BO XI Architecture and new features.
• In-depth knowledge in creation of Dashboards using Crystal Xcelsius/Dashboard Design.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Proficient in using SQL, PL/SQL, T-SQL to study data in different systems and to validate reports.
• Experience working with BW 7.3 backend db system.
• Created Olap universes and Webi reports using BICS connection for BW.
• Created dashboard using BW as a data source querying BW using BEx.
• Experience using Query designer in BW 7.3.
• Good understanding of BW Info Cube.
• Involved in migration of BW to Hana db and testing and application migration.
• Worked with SAP HANA, created attribute view, analytic view, calculation view, store procedure, push calculation towards HANA to get maximum performance.
• Migrated Universe, reports, dashboard, user, groups etc from dev to qa, qa to prod using import wizard using best practices.
• Good knowledge and experience in using Oracle 9i/10g/11g, MS SQL Server 2005/2008.
• Process oriented thinking and problem solving approach.
• Ability to work under pressure and complete work on schedule. Having problem solving skills, quick and independent learning skills.
• Sound knowledge of waterfall, Agile methodologies.
• Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.

TECHNICAL SKILLS

Operating System: XP, 2003, Win7

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2008/2005, MS Access

Web Technologies: SQL, PL/SQL

BI Tools: SAP BI/BO XIR2/XIR3.0/XIR3.1/4.0, Crystal Reports 2011/2008, Dashboard Design/Xcelsius 4.0/2008, SAP HANA,BW 7.3

PROFESSIONAL EXPERIENCE

Confidential, New York

Business Objects & Dashboard Developer

Responsibilities:

• Created Universe using IDT (.unx) and Universe Designer(.unv), Working with star, snow flake, relation model.
• Expertise in upgrading from 3.1 to 4.0 using UMT and applying new security on Admin level.
• Created Dashboards and Scorecards using Dashboard desing 4.0 with QaaWS, Live Office, BI Services, XML as a data sources.
• Created WEBI reports involving complex queries, sub queries, Unions and Intersection using BI 4.0 and BO 3.1.
• Worked with SAP HANA, created attribute view, analytic view, calculation view, store procedure, push calculation towards HANA to get maximum performance.
• Created Universes on OLAP SAP HANA model using star schema approach.
• Created Deski reports using free hand sql, flat files, store procedures, universe as a data source.
• Created several Universes (joining the tables, creating prompts and queries and applied Contexts and Aliases to resolve loops) for finance, sales, promotions, manufacturing, SCM, HR, LMS Users.
• Involved in ETL Process using BODS/Informatica.
• Addressed chasm trap and Fan Trap using Multi Parse SQL.
• Imported data from Excel to compare Actual Vs Budget.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Used Toad to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct.
• Secured sensitive data by applying a security feature of object level security in the Universe and the report level security in the CMC.
• Heavily interacted with the Client users to gather the requirements of the KPI WebI report.
• Created various drillable WebI reports.
• Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on the server.
• Created Reports with heavy conditional formatting and functions to meet user requirement.
• Customized the reports with custom functions and loops to leverage the user reporting needs.
• Scheduled recurring daily, weekly and monthly reports (WebI, DeskI) in Info View and used Calendar based scheduling for the reports custom dates.
• Created various group based publications and distributed reports to the users.
• Designed a High Performance universe by joining several dimensions to the fact table like Accounts and Returns.
• Migrated Universe, reports, dashboard, user, groups etc from dev to qa, qa to prod using import wizard using best practices.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
• Interacted with the users to analyze the changes for improvement they need in existing reports and develop the reports to satisfy their needs and requirements.
• Created several dashboards using Crystal Xcelsius, opendoc command to locate report from dashboards as drill down detail.
• Used Live Office, BI Services and QAAWS (Query ads a web service) to get the data from the database into the dashboards.
• Designed and Developed Xcelsius dashboards / analytics and exported to several formats
• In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components, dynamic visibilities.
• Created Olap connection using BICS in IDT.
• Created Webi reports using BEx queries as a data source from BW db.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.
• Prepared user documentation for hands on training for end user community.

Environment: Win7, Oracle 10g/11g, BI 4.0,BO XIR 3.1, Crystal Dashboard Design(Xcelsius) 4.0/2008.

Confidential, New York, NY

Business Objects & Dashboard Developer

Responsibilities:

• Created several universes using Designer using star, snow flake, relational model.
• Provided cascading prompts Custom Hierarchies in the reports as well as the Universe to create more interactive reports for the users.
• Created Webi/Deski/Crystal Report reports for sales, HR, Finance, SCM Users.
• Wrote a full functional specification document for the security implemented in Business Objects.
• Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.
• Created Custom Hierarchies to provide drill down capabilities in Webi for the ad-hoc power/general users.
• Developed several Complex Reports, various features used include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports.
• Used prompts, alerts, drill down analysis as per the end user requirements.
• Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks.
• Created graphical representation of WebI reports such as bar charts, pie charts etc.
• Migrated reports, universes, dashboards, connection, users, groups from DEV to QA and QA to Prod using import Wizards.
• Scheduled reports for bursting/publication on daily, weekly, monthly, yearly basis.
• Improved query performance by implementing aggregate awareness.
• Created interactive Scorecards and Dashboards using summary level data and provided users drill down reports and used QaaWS as a data source.
• Created several Dashboards using alerts, highlight important metrics/KPI for VPs level.
• Involved in user training to the end users on working with Web Intelligence tool through infoView and WebI Rich Client.
• Involved in SDLC from the beginning to finish all the way from dev to prod, handed over complete project after documentation to sustaining team for support.
• Involved in production supports, troubleshoot, CR, SR with the users in production.

Environment: XP/Win7, Oracle 9i/10g, Business Objects 3.1, Xcelsius 2008, Crystal Reports 2008

Confidential, Uncasville, CT

Business Objects Developer

Responsibilities:

• Developed Universes from scratch for different departments using BO Designer.
• Provided cascading prompts in the reports as well as the Universe to create more interactive reports for the users.
• Extensively wrote PL/SQL procedures to get data from Oracle database.
• Wrote a full functional specification document for the security implemented in Business Objects.
• Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.
• Created Custom Hierarchies for several groups.
• Used Toad to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct.
• Developed complex reports in Business Objects using multiple data providers.
• Created graphical representation of WebI reports such as bar charts, pie charts etc.
• Implemented extensive use of derived tables in the process of building reports.
• Developed hierarchies according to demand to support drill down reports.
• Improved query performance by implementing aggregate awareness.
• Was involved in Star Schema customization / Design session.
• Developed new WEBI reports in XI.
• Developed new reports along with modifying existing reports to support new and additional Business requirements.
• Created scorecards and dashboard using Live Office and QaaWS.
• Used prompts, alerts, drill down analysis as per the end user requirements.
• Used Shared and Global variables to pass data from Main report to Sub report & Vice Versa.
• Developed several Complex Reports, various features used include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports.

Environment: XP, SQL Server 2005/2008, Business Objects XIR2/3.0, Crystal Report 2008, Xcelsius 2008.