SUMMARY:

• 15 Years+ of development experience in software design, development in fields of Business Intelligence, Data warehousing with extensive experience in BI Tools like Business Objects, Crystal Reports, Power BI, Arcadia Data and Zoom Data
• Expertise in working with Data warehousing and Business Intelligence applications.
• 15 Years of analytical reporting design and development experience using BI reporting and dash boarding tools
• Experience working with Financial, Pharmaceutical and Healthcare data
• Expert with Power BI and Arcadia Data on creating complex Dashboards using DAX and M queries
• Experience Migrating reports & Universe from Business Objects 6.5.1 to Business Objects 4.2
• Experience in handling of all the modules of Business Objects 4.2, UDT, IDT, Universe Designer, Web Intelligence Launchpad, Crystal Reports 2008, Infoview, CMS and CMC
• Expert in Universe Design and Complex Reports development
• Good Knowledge in writing and gathering the functional requirements. Ability to work under tight schedules
• Extensive experience in dissemination of work and coordinating with Off - shore resources to produce quality work within aggressive deadlines.

TECHNICAL SKILLS:

ROLAP Tools: BUSINESS OBJECTS 4.2 / XI 3.1/XI R 2/6.5.1/5.1.5 (BO Admin Tools, CMC, CMS, Designer, Reporter, InfoView, Web Intelligence), Crystal Reports 2008

BI Dash boarding Tools: Power BI, Arcadia Data, Tableau and Zoom Data

MOLAP Tools: MS Analysis Services and Proclarity 6.1

RDBMS: ORACLE 11i, Sybase 12.5, UDB DB2 9.1, SQL Server 2005 and Hive 2.2

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

BI Functional Architect

Responsibilities:

• Involved in BI Functional architecture activities
• Involved in BObj Admin activities
• Created BI dashboards using Power BI and Arcadia Data
• Created ETL jobs in Power BI using M query
• Created Calculated column, Measures and tables using DAX in Power BI
• Created KPIs and performed trend analysis using Power BI
• Developed Business Objects .UNX universes in BI 4.2 Information Design Tool with various custom hierarchies, resolving loops/traps through Contexts/Aliases, performance tuned through Aggregate Navigation with Table/Object Incompatibility setup
• Developed very complex Business Objects Summary/Detail Web Intelligence Reports with Drill Down and Open Doc Functionalities with Conditional Formatting/Input Controls etc.

Environment: Business Objects 4.2, Hive 2.2, Power BI, Arcadia Data and Zoom Data

Confidential, Nashville, TN

Business Objects Lead

Responsibilities:

• Converted Desktop Intelligence reports to WebI 4.2 documents
• Created BI dashboards using Power BI and Tableau
• Created ETL jobs in Power BI using M query
• Created Calculated column, Measures and tables using DAX in Power BI
• Created KPIs and performed trend analysis using Power BI
• Developed Business Objects .UNX universes in BI 4.2 Information Design Tool with various custom hierarchies, resolving loops/traps through Contexts/Aliases, performance tuned through Aggregate Navigation with Table/Object Incompatibility setup
• Developed very complex Business Objects Summary/Detail Web Intelligence Reports with Drill Down and Open Doc Functionalities with Conditional Formatting/Input Controls etc.

Environment: Business Objects 4.2, Oracle 11i, Teradata, DB2, Power Bi, Tableau

Confidential, Houston, TX

Business Objects Lead

Responsibilities:

• Developed Complex Collateral Consolidated Statement using Web Intelligence XI 3.1
• Developed Universe using Designer
• Worked on CMLD applications: COAST-Collateral, COAST-Client Valuations, COAST-CCM, DOX
• Migrated Universes and Reports from 6.5.1 to Business Objects XI 3.1 Environment - Desktop Intelligence Reports, Web Intelligence reports using Manual Methods and the Import Wizard

Environment: Business Objects XI 3.1 (Designer, Web Intelligence), Oracle 11i

Confidential, Thousand Oaks, CA

Business Objects Lead

Responsibilities:

• Created Universe using Designer
• Created complex reports using Web Intelligence
• Involved in Technical design document

Environment: Business Objects XI 3.1 (Designer, Web Intelligence), TeraData 12.0, Confidential Quality Center 10

Confidential 

Senior Business Objects Developer

Responsibilities:

• Involved in the designing and Building of Universes, Classes, Objects and Conditions
• Created complex reports using Crystal Reports 2008

Environment: Business Objects XI R2 (Designer, Crystal Reports 2008), Web Intelligence XI R2, UDB DB2 9.1

Confidential, Mesquite, TX

Business Objects Lead

Responsibilities:

• Involved on design the BO Server architecture and installed all Client-Server Environment
• Managed the users and security using CMC
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Created complex reports using Crystal Reports and WEBI

Environment: Business Objects XI R2 (Designer, Desktop Intelligence, Crystal Reports XI R2), Web Intelligence XI R2, Oracle 10g

Confidential, Montvale, NJ

Business Objects Lead

Responsibilities:

• Performed Data Analysis and identifying the logical relationships between tables and data quality for design.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in designing and building complex universes and reports
• Created WebI reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.

Environment: Business Objects XI R2 (Designer, Desktop Intelligence, Crystal Reports XI R2), Web Intelligence XI R2, Oracle 10g

Confidential , Savannah, GA

Senior BO Developer

Responsibilities:

• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in designing and building complex universes and reports
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.

Environment: Business Objects XI R2 (Designer, Desktop Intelligence, Crystal Reports XI R2), Web Intelligence XI R2, Oracle 9i

Confidential, NJ

Business Objects Lead

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in the designing and Building of Universes, Classes and objects

Environment: Business Objects 6.5.1 (Supervisor, Designer, Reporter, BCA Scheduler), Web Intelligence 6.5.1, Oracle 9i

Confidential, NJ

Business Objects and MS Analysis Services Architect

Responsibilities:

• Involved Lehman Global Architecture for Business Objects and MS Analysis Services
• Consulting on usage and developing proof of concepts
• Center of Excellence - evangelizing the usage across Lehman
• Involved in taking requirements from business users and project planning
• Deployment of all Business Objects Client and Server side Products
• Established user groups and users and assigned privileges
• Good experience in BO serve products - BCA Scheduler, Auditor, BO Publisher, Infoburst and Supervisor, Designer, BO Full Client.

Environment: Business Objects XI/6.5.1/5.1 (BO Admin Tools, Auditor, BO Publisher, Supervisor, Designer, Reporter, BCA Scheduler), Web Intelligence 6.5.1, MS Analysis Services, Infoburst, Proclarity, Crystal Reports, Oracle 9i, Sybase 12.5, UDB DB2 81 and SQL Server

Confidential, NY

Business Objects Analyst

Responsibilities:

• The project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.

Environment: Business Objects 6.1 (Supervisor, Designer, Reporter, BCA Scheduler), Web Intelligence 6.1, Oracle 9i