SUMMARY

• 8+ years of IT experience in Business Intelligence technologies & tools like Business Objects, SSRS, and Hyperion IR and ETL tools like Business Object Data Services and SSIS for Extraction, Transformation and Loading.
• Expert in providing Business Intelligence solutions using Business Objects XIR3 Central Management Console, Universe Designer, Web Intelligence (WebI), Rich Client, Info View
• Strong ability to understand Business specifications, and translate specifications into reports/analytics.
• Strong ability to develop meaningful and consistent quality checks throughout the application development process and follow regulatory or industry standard validation procedures.
• Extensive hands - on experience in database/SQL programming and Performance tuning.
• Excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation
• Providing User-based training to all corporate customers about creating their own Ad-hoc reports.

TECHNICAL SKILLS

Business Intelligence: Business Objects XIR3 Central Management Console, Universe Designer, Web Intelligence, Designer, Info View, Rich Client, SSRS 2005/08, Hyperion IR 9.1

Data Modeling: Erwin 3.5

ETL Tools: BODS/BODI 4.0, SSIS

Languages: PL/SQL, SQL*PLUS

RDBMS: MS SQL Server 2005/2008, Oracle 10g

Operating Systems: Windows 9X/NT/2000/XP/7, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, MI

Sr. Business Objects/BODS Developer

Responsibilities:

• Analyzed and modified the rapid decision jobs and data stores to suit the requirement
• Built Function and Technical Documents and created Low level design documents Created new Jobs in BODS
• Performance tuning in the data flows
• Requirement gathering for reporting needs.
• Created Characteristic value, hierarchy, hierarchy nodevariables as and when needed.
• Improved the performance of the reports both in Report level and Universe levels.
• Creates new universes to meet the requirements and modified the universes available in rapid decision
• Built Dynamic Visibility functions
• As a process of moving the PeopleSoft systems into new EDW universe, built the reports in BO by analyzing the old sql’s.
• Hands on Experience on Teradata 13.
• Used Oracle sql developer and SQL Assistance to build and validate the queries.

Environment: Windows 7, UNIX, Oracle 10g, Business Objects XIR3, BODS 4.0, Oracle SQL Developer, WebI, Teradata 13

Confidential

Sr. Business Objects Developer

Responsibilities:

• Migrated the reports from Cognos to BO Webi.
• Worked in Migration Project from Cognos 8 to BOXIR3
• Created and reviewed the design document for BO reports
• Coordinated with off Shore Team during Development and Testing phases
• Worked with the reports built on SQL Server 2008.
• Some of the reports are built from Crystal Reports and Rich client
• Analyzed Cognos Cubes and implemented the same functionality in BO universe.
• Built OLAP Universes and made POC for Migration requirements.
• Gave production support to over 10 Universes and 115 reports
• Created Conditions and Exceptions based on the reporting needs.
• Activated Hierarchies in the queries for the reporting needs.
• Used Aggregate awareness and Aggregate navigation feature and also some functions like NODIM, NOERROR,Boolean etc.,in the formula calculations
• Created Formula Variables to use master data attributes key figures in the formula calculations.
• Created Formula Variable for data difference calculations.
• Created Characteristic value, hierarchy, hierarchy nodevariables as and when needed.
• Improved the performance of the reports both in Report level and Universe level.
• Used @functions like @Prompt, @Select, @variable and @where
• Identified and defined Universe structure required by business users for dashboards/report usage.
• Took active participation in UAT and User Training sessions to make them familiar with the tools
• Performed Admin roles using CMC

Environment: Windows 7, Business Objects XIR3, Universe Designer, WEBi and Rich Client, Cognos 8

Sr. Business Objects Developer

Responsibilities:

• Migrated the reports from Cognos to BO Webi.
• Worked in Migration Project from Cognos 8 to BOXIR3
• Created and reviewed the design document for BO reports
• Coordinated with off Shore Team during Development and Testing phases
• Worked with the reports built on oracle 10G.
• Some of the reports are built from Crystal Reports and Rich client
• Analyzed cognos cubes and implemented the same functionality in BO universe.
• Built OLAP Universes and made POC for Migration requirements.
• Gave production support to over 60 Universes and around 650 reports
• Created Conditions and Exceptions based on the reporting needs.
• Activated Hierarchies in the queries for the reporting needs.
• Used Aggregate awareness and Aggregate navigation feature and also some functions like NODIM, NOERROR,Boolean etc.,in the formula calculations
• Created Formula Variables to use master data attributes key figures in the formula calculations.
• Created Formula Variable for data difference calculations.
• Created Characteristic value, hierarchy, hierarchy nodevariables as and when needed.
• Improved the performance of the reports both in Report level and Universe level.
• Used @functions like @Prompt, @Select, @variable and @where
• Identified and defined Universe structure required by business users for dashboards/report usage.
• Took active participation in UAT and User Training sessions to make them familiar with the tools
• Performed Admin roles using CMC

Environment: Windows 7, Business Objects XIR3, Universe Designer, WEBi, Rich Client, Cognos 8, Informatica, Oracle 10g

Confidential, NJ

Sr. SSRS & Business Objects Developer

Responsibilities:

• Worked as an offshore lead to collect the requirements and share the work to team members
• Modifications to the existing Universes to accommodate the new requirements
• Created new reports from the scratch for new requirements and modified some of the existing reports in SSRS and BO.
• Developed reports in Web Intelligence
• Created new Attributes, Filters and Complex measure objects in the Universe.
• Created new stored procedures in sql server 2005 to use in SSRS reports.
• Created the new Views and Aggregate tables for report performance.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Gave production support for the users all over the world using the prime universes.
• Conducted training sessions for end users about using Business Objects Full client version and creating ad-hoc Reports.
• Created ad-hoc SSRS reports using report builder
• Conducted Parallel run for review purposes.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters as per business requirements.
• Trouble shooting all the issues in BO Reports. Maintained Proper Documentation for all the work for Future Reference

Environment: Windows XP, SQL Server 2005, Business Objects XIR3, SSRS, SSIS

Confidential, PA

BI developer

Responsibilities:

• Involved in designing and coding of functional specifications for the development of SSRS reports
• Involved in designing of Entity Relationship Diagrams
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Migrated the reports from SSRS to Hyperion IR 9.1 later based on the customer request
• Supported the reports after production move and modifications to the reports
• Created the Hyperion IR dashboards to achieve the same functionality.
• Proposed different designs to achieve the same functionality in Hyperion to the SSRS reports.
• Installation of Hyperion and responsible for all environment related things
• Coordinated the quality audit for the project

Environment: SSRS, SQL server 2005, Oracle 9i, Hyperion IR 9.1

Confidential, NY

SQL Developer

Responsibilities:

• Created SSIS packages
• Involved in designing and coding of functional specifications for the development of SSRS reports
• Developed PL/SQL scripts to validate and load data into interface tables
• Created SSRS reports
• Supported the reports after production move and modifications to the reports
• Coordinated the quality audit for the project

Environment: SSRS, SSIS, SQL server 2005