SUMMARY:

• 9+ Years of experience in IT Industry with thorough implementation of Software Development cycle and specialization in Reporting Data warehouse projects.
• 3 years of USA IT - experience and 7 years of Indian IT-experience.
• Experience of working with clients like Confidential Bank, Confidential, Confidential, Confidential .
• Sound knowledge of Data warehousing, RDBMS and Quality Process.
• 9+ years of experience as Business Objects Developer, Expertise in BOXI R3, DESKI, BOXI R4.
• 6+ months of experience as Microstrategy Developer, Having experience in designing and building MSTR Reports.
• 6+ months of experience as Xcelsius Developer, Having experience in designing and building Xcelsius Dashboards.
• Having basic experience in Oracle/Sql.
• Proficient in Business Objects-Universe Designing, Report Development, Xcelsius Dash boarding (Offline/Online), Microstrategy
• Expertise in Designing and building universes, identifying cardinalities, Integrity check. Have made use of Aliases and Context to resolve Join Path problems like loops, Fan Trap and Chasm Trap, Used Aggregate awareness and Index Awareness for performance tuning.
• Worked on Complex reports based on multiple data providers, Open Docs, Business Objects Live Office functionality.
• Generated analytical reports using Slice and Dice, Drill down, Cross Tab, complex formula using @Functions and @Prompts, use of graph and charts.
• Involved in development of reports with universe level or report level prompts and\cascading prompts.
• Developed/Enhanced complex, graphical and statistical reports using sub, cross tab, reports in BOXI R4, BOXI R3 and DESKI.
• Having experience on security structure in BOXI R3.1
• Having experience on Repository backups, Recovery from backup, Creating Users and User Groups, applying User and Group Level Security using CMC.
• Having experience in Microstrategy - Report development, Cube Creation.
• Extensively worked on Development and Testing activities.
• Design which includes high level design, low level design and facilitating design sign off.
• Experience in leading teams in delivering end-to-end solutions.
• Client interaction experience.
• Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.
• Ability to understand customer needs and manage expectations.
• Project Management (Knowledge/Experience).
• Familiar with onsite/offshore model.
• A strong communicator and team player with excellent inter-personal skills.
• A quick learner with the ability to make solutions-oriented, creative and innovative contributions in highly demanding situations.

TECHNICAL SKILLS:

DW Tools: Business Objects-XIR4/XIR3/DESKI, Xcelsius-Dashboarding, MSTR

Database: Oracle, SQL Server,DB2

Languages: Oracle-SQL

Others: AQT, Toad, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Warren, New Jersey

Environment: Business Object (BOXIR3), Oracle-11, Microstrategy 9.4

Responsibilities:

• As an Onsite Project Lead the only person responsible for the complete engagement and on timely Deliverables
• Participated in the complete development lifecycle of DW-Reporting including requirement gathering, Testing, Development and Migration.
• Interacting with the Business users and understand all the business requirements and convert them to Requirement Document.
• Evaluate Functional requirements and Reporting requirements provided by the business and identify the gaps in requirements if any and will provide recommendations on Universe optimization.
• Have prepared Analysis/Design/Technical document and Unit Test Plans according to business logic.
• Developed and enhanced Business Objects Universe and Reports.
• Developed and Extract SQL’s at the Back-end.
• Developed/Enhanced reports in BO XI R4, BO XI R3 and DESKI.
• Developed and enhanced Universe & Report & design documents as well.
• Developed WebI Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Drill-Down, Cross-Tab) Have trained and shared knowledge with the Business users to develop simple Ad-hoc reports as per their requirements.
• Designed and Developed WebI Reports using the features like Combined Queries, Merged Dimensions, Charts, Cross Tab, Drill Down.
• Performed the Code and Document Reviews, Unit testing and preparing deliverables.
• Extensive experience in data analysis to improve overall efficiency to support decision making.
• Involved in Creating and Maintaining the User /Group Creation
• Creating Security restrictions in universe and CMC based on different
• Adding/ removing users, Groups and Folders.
• Migrating report/ objects from the development, test and Production environments.
• Security configuration
• Project Management (Knowledge/Experience).
• Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.

Confidential, Cincinnati, Ohio

Environment: Business Object (BOXIR3), Oracle-11, Xcelsius-2008

Responsibilities:

• As an Onsite Project Lead the only person responsible for the complete engagement and on timely Deliverables
• Participated in the complete development lifecycle of DW-Reporting including requirement gathering, Testing, Development and Migration.
• Interacting with the Business users and understand all the business requirements and convert them to Requirement Document.
• Evaluate Functional requirements and Reporting requirements provided by the business and identify the gaps in requirements if any and will provide recommendations on Universe optimization.
• Have prepared Analysis/Design/Technical document and Unit Test Plans according to business logic.
• Developed and enhanced Business Objects Universe and Reports.
• Developed and Extract SQL’s at the Back-end.
• Developed/Enhanced reports in BO XI R3 and DESKI.
• Developed and enhanced Universe & Report & design documents as well.
• Developed WebI Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Drill-Down, Cross-Tab) Have trained and shared knowledge with the Business users to develop simple Ad-hoc reports as per their requirements.
• Designed and Developed WebI Reports using the features like Combined Queries, Merged Dimensions, Charts, Cross Tab, Drill Down.
• Performed the Code and Document Reviews, Unit testing and preparing deliverables.
• Extensive experience in data analysis to improve overall efficiency to support decision making.
• Involved in Creating and Maintaining the User /Group Creation
• Creating Security restrictions in universe and CMC based on different
• Adding/ removing users, Groups and Folders.
• Migrating report/ objects from the development, test and Production environments.
• Security configuration
• Project Management (Knowledge/Experience).
• Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.

Confidential

Environment: Business Object (BO XI R3), Xcelsius-2008, Oracle SQL

Responsibilities:

• Design which includes high level design, low level design and facilitating design sign off
• Client interaction & Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.
• Ability to understand customer needs and manage expectations.
• Project Management (Knowledge/Experience).
• Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.
• Preparing Analysis/Design/Technical document and Unit Test Plans according to business logic.
• Developing and enhancing Business Objects Universe and Reports.
• Developing Extract SQL’s at the Back-end.
• Developed/Enhanced reports in BO XI R4, BO XI R3 and DESKI.
• Developing and enhancing Universe & Report & design documents as well.
• Performing Code and Document Reviews, Unit testing and preparing deliverables.

Confidential

Environment: Business Object (BO XI R2), Informatica 8.1, Oracle SQL

Responsibilities:

• Design which includes high level design, low level design and facilitating design sign off
• Client interaction & Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.
• Ability to understand customer needs and manage expectations.
• Project Management (Knowledge/Experience).
• Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.
• Preparing Analysis/Design/Technical document and Unit Test Plans according to business logic.
• Developing and enhancing Business Objects Universe and Reports.
• Developing Extract SQL’s at the Back-end.
• Developed/Enhanced reports in BO XI R4, BO XI R3 and DESKI.
• Developing and enhancing Universe & Report & design documents as well.
• Performing Code and Document Reviews, Unit testing and preparing deliverables.

Confidential

Environment: Business Object (BO XI R3), Oracle SQL

Responsibilities:

• Design which includes high level design, low level design and facilitating design sign off
• Client interaction & Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.
• Ability to understand customer needs and manage expectations.
• Project Management (Knowledge/Experience).
• Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.
• Preparing Analysis/Design/Technical document and Unit Test Plans according to business logic.
• Developing and enhancing Business Objects Universe and Reports.
• Developing Extract SQL’s at the Back-end.
• Developed/Enhanced reports in BO XI R4, BO XI R3 and DESKI.
• Developing and enhancing Universe & Report & design documents as well.
• Performing Code and Document eviews, Unit testing and preparing deliverables.

Confidential

Environment: Business Object (BO 6.5), Oracle SQL

Responsibilities:

• Design which includes high level design, low level design and facilitating design sign off
• Client interaction & Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.
• Ability to understand customer needs and manage expectations.
• Project Management (Knowledge/Experience).
• Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.
• Preparing Analysis/Design/Technical document and Unit Test Plans according to business logic.
• Developing and enhancing Business Objects Universe and Reports.
• Developing Extract SQL’s at the Back-end.
• Developed/Enhanced reports in BO XI R4, BO XI R3 and DESKI.
• Developing and enhancing Universe & Report & design documents as well.
• Performing Code and Document Reviews, Unit testing and preparing deliverables.