Experience Summary

• 14 years of experience as Business Intelligence as Lead Analyst with extensive experience in Business Intelligence ETL and Reporting tools like BI 4.1,Business Objects XIR3.1/R2/6.5,Power Insight, Informatica Oracle Warehouse Builder OWB 11g ETL
• Extensive knowledge on Industries like Ratings, Banking, Manufacturing, Telecom, Retail and FMCG, Healthcare etc.
• Extensive experience in Business Objects Universe design and report development.
• Implemented Single Sign On SSO from Curam, a java based application to BO enterprise.
• Good experience in performance tuning of reports, universes ETLs.
• Designed and implemented the ETL transformations in Stating , Central Data Mart areas using OWB ETL tool.
• Strong background in Data warehousing and Reporting.
• Resolved issues related to Product by communicating to the Business Objects product support team across world.
• Good understanding on Business and reporting requirements and able to produce the requirements analysis document.
• Strong Experience in Developing Operational and Analytical Reports, Testing Reports and Creating and Executing Test Plans.
• Hands on experience on creating scalable - pre defined reports.
• Good Experience in preparing the Technical Specification Document TSD based on the understanding of given Business Specification Document BSD .
• Excellent Team Leading, Team Management and User Interaction Skills.
• Ability to follow standards for procedures and documentation
• Excellent communication skills, strong analytical, problem solving, and conceptual skills.
• Excellent understanding on Data warehousing concepts and strong experience in implementing data warehousing methodologies
• Excellent experience in implementing Dimensional Modeling Techniques like star-schema, snow flake schema etc.

Professional Experience

Confidential

Role: : Business Objects Lead Analyst Admin Development

Environment : BusinessObjects 4.1/3.1,Oracle 11g,OWB11,Curam 6,BOSDK,Ecplise

Contributions

• Involved in full reporting life cycle - requirements gathering through implementation including: preparing the functional, scope, mapping documents and high level and low level design specification documents.
• Expertise in installation and setup of Business Objects on DR/Prod/Test/Dev environments on AIX, Tomcat servers on clustered environments.
• Implemented Single Sign On SSO ,from the Curam application to Busienss Objects Enterprise system using BO JAVA SDK.
• Designed and implemented the ETL transformations in Stating , Central Data Mart areas using OWB ETL tool.
• Hands on experience on Universes Design and Development using UDT/ IDT with Dimentional Modeling techniques .
• Expertise in reports design development using Web Inelligence .
• Well versed with Business Objects Authentications and Authorizations, Creating/Administrating Users Groups, designated their User Security Levels in CMC, assigned Roles, Access Levels on the Applications and folders.
• Expert in Designing Dimensional Modeling Star Schemas, Snow flake schema and Operational Data store ODS in Data Warehouse design.
• Migration/ up gradation from BO3.1 content to BI4.1
• Performance tuning of BI /BO servers, Universes and reports on various levels.
• Implemented Security at Various levels like Global Security, Folder Level Security and Object level Security.

Confidential

Role: : Business Objects Reporting Lead

Environment : BusinessObjects3.1,Informatica 9.5 , SQL server 2005,ACTIMIZE

Contributions

• Design and development of universes and reports for Anti Money Laundering datawarehousing system.

• Hands on experience in tuning the performance reports and universes.

• Accountable for delivery of AML Reports and Universes.
• Migration from BO XIR2 to R3 using BIAR archives.

• Design and implemented the ETL transformations in Stating , Central Data Mart areas using OWB ETL tool.
• Implemented Security at Various levels like Global Security, Folder Level Security and Object level Security.

Confidential

Role : Business Objects Reporting Lead/Administrator

Environment : Business Objects XIR3.1 Web, Designer, and CMC , Power Insight Cerner's , BODI, and Oracle 10

Contributions

• Developed and designed the summary and detailed reports using Power Insight, as part of ESR package.
• Modified the existing Cerner's universes/semantic layers to develop the new set of EHR reports.
• Hands on experience in tuning the performance reports.
• Used Informatica for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Modified the EDW reports to improve the performance and ETL jobs as well.
• Unit testing the jobs and preparing the Unit test cases and system level test cases.
• Schedule and sequence the jobs according to the requirement.
• Involved in preparing Unit Test Cases and executing them
• Administration of Business Objects
• Experienced in integration of SAP and non-SAP data to load into the data warehouse.

Confidential

Role: Business Objects Reporting Lead

Environment: BusinessObjectsXIR3, Informatica 8, Live Office, Crystal Reports 2008, MS Access, Data Integrator.

Contributions

• Crystal Reports development for reporting needs of Octanner's data warehousing system.
• Created Universes for Live Office Reporting.
• Hands on experience in tuning the performance reports.
• Used Informatica for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Modified the ETL jobs to improve performance
• Parameterized ETL jobs to allow portability and flexibility during runtime.
• Extensively used Join, Look Up and Merge stages to meet different business requirements and performance.
• Experienced in Data Load Performance Tuning, Query Performance Tuning using Business Objects Data Integrator tool.
• Good knowledge on Data Services and Rapid marts.
• Created flat file data sources to extract data from non SAP source systems.
• Scheduled, maintained, and supported the distribution and access to reports through the use of several implemented web-based reporting tools, published generated reports on Crystal Enterprise.

Confidential

Role: Business Objects Lead

Environment: BusinessObjectsXIR3/R2 , Informatica 8, Live Office 6.5, Windows 2000

Contributions

• Development of Canned and Ad-hoc reports for Ratings Reporting Users and creating user friendly reports.
• Migration of Reports and Universe from Business Objects 6.5 to Business Objects Enterprise XI R2 deski and Webi.
• Report performance issues are resolved at various levels.
• Involved in migration of the reporting system from BO-XI development to Test and from test to production environments.
• Hands on experience in tuning the performance reports.

Confidential

Role: Senor Business Objects Developer /Administrator

Environment: Business Objects BOXI-R2 / 6.5, Informatica 8, Oracle 9i, Windows NT

Contributions

• Setting up and Installing Business Objects Enterprise XI R2 on Solaris box.
• Reports and Universe migration from Business Objects 6.5 to Business Objects Enterprise XI R2 Deski and Webi.
• Involved in Migrating Objects from Development to Production and having strong experience in Trouble shooting skills
• Created Users, Groups and Folders in Business Objects XI R2 and implemented security on all these levels.
• Implemented Object Level Security to Business Objects XI R2 Universes.
• Involved in all Analysis, Development, Testing, or Business Objects XI R2 Reports
• Implemented Security at Various levels like Global Security, Folder Level Security and Object level Security.
• Implemented Data warehousing schemas like Star-Schema.
• Resolved critical issues by giving best Innovative workarounds for some critical issues thus delivering the reports with in the timelines.