Sr. Business Object Informatica Engineer Resume Profile
NC
Career Objective:
- Seeking for challenging career where I can use my educational and professional experience for the development of the organization and also I can enhance my professional and personal skills.
- An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
Technical Skills :
OLAP On-Line Analytical Processing Tools:- Business Objects XI R3.1/R2/6.5,
Designer, Supervisor, Desktop Intelligence Deski , Web-Intelligence Webi , Info-
View, CMC Performance Management, Report Conversion Tool and Import Wizard
RDBMS:- Oracle 9i/10g, MS Access 2000, SQL, PL/SQL, Oracle Toad, MS Office
2000/2003/2007
Languages: - VisualBasic6.0, C,
Operating Systems: - Windows NT/XP/2000/98, MS DOS and UNIX
Total Experience as Business Object Administration: 6 Years 9 Months
Confidential
Role : Sr. Business Object Informatica Engineer
Designation : Sr./Lead Infrastructure Engineer
Client : Symantec Corporation
Team Size : 10
Role and Responsibilities:
Environment: Business Objects XI R2/R3.1, Designer, Desktop Intelligence Deski , Web-Intelligence Webi , Info-View, CMC, Import Wizard, Report Conversion Tool, Oracle Client 10gR2.
- Expertise in Creation of complex reports using multiple queries.
- Created row level security and user level security.
- Used breaks on reports to get desired results after converting the documents.
- Expertise in creation of Reports, Formatting reports, generation of charts, as per user requirements.
- Created User conditions, Filters to improve report generation readability of report and displayed the summary of data by creating Charts.
- Deployed and scheduled reports.
- Migration of the report/Universes using BIAR from XI R2 to XI R3.1 version.
- Forward and backward migration DEV-QA-PROD PROD-QA-DEV .
- Created Auditor reports and tracked user access of reports and Universes.
- Upgraded Business Objects universes and reports from version BO XI R2 to version BO XI R3.1.
- Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
- Created Alerter, Filters, Ranking and Inserted Breaks in designing reports.
- Checked the integrity of the Universes for existence of loops and resolved them by using aliases and contexts.
- Modified the Universes, add additional Dimension, Detail, and Measure Objects according to the requirements
- Adding and Removal of Row level and Object level restrictions.
- Setting rights for user accounts using CMC for BOXI R2/R3.1,
- Giving access of Universes and assign them to respective domains.
- Used the import wizard to import existing user accounts, groups, categories, Webi documents, universes, connections and universe restrictions to BOXI R3.1 environment.
- Involved in Conversion of Deski reports to Webi reports using Report Conversion Tool.
- Interacted with the end users and provided Production Support.
- Created PPT Dashboards for internal use.
- Doing the trend analysis for arrival of the service request.
- Involved in the Requirement Analysis and Preparation of System Requirement Specification Document.
- Handling all the priority cases within SLA using action request system called BMC Remedy 7.1.
- Preparation of Technical documents.
- Query Optimization using Toad 9.7.2.
- Providing on-call support
- Informatica Access Request: User Account Creation in all the environment DEV, STAGE, QA PROD .
- Taking Informatica Prod Repository Backup.
- Editing Rights on folder level. Creating folder and granting access to the folder.
- Migration of workflow from PROD to DEV, QA UAT.
- Creating connection for Teradata Repositories.
- Aborting/Re-launching the workflow and Session as per request.
Confidential
Role : Sr. Application Support Analyst
Client : Cisco Systems Offshore Development Centre
Team Size : 18
Role and Responsibilities:
Environment: Business Objects XI R2/6.5, Designer, Desktop Intelligence Deski , Web-Intelligence Webi , Info-View, CMC/Supervisor, Import Wizard, Report Conversion Tool, Toad for Oracle 9.7.2, Oracle Client 10gR2.
- Installed and configured the BO Deski XI R2/6.5 in client system.
- Resolving Issues in the access of Business Object XI/6.5 resolving through NetMeeting, Webex
- Connect, Phone, and mails as well.
- Creating an Internal Case for giving access for the installation folder of BOXI/6.5.
- Setting permissions for access using CMC/Supervisor Performance Management for BOXI/6.5,
- Giving access of Universes and assign them to respective domains.
- Resetting Password, and Activating Account for new user, Deactivating account which is no more in use.
- Deployed and scheduled reports.
- Creating of webi report and migrating and scheduling as per client request.
- Migration of the report using BIAR from older version to the newer one.
- Forward and backward migration DEV-QA-PROD PROD-QA-DEV .
- Created internal reports and tracked the incident and appreciation details.
- Webi Reports were created and deployed through Info View.
- Preparation of Technical documents.
- Handling all the priority cases within SLA using action request system called BMC Remedy 7.1/Remedy 6.
- Involved in the Requirement Analysis and Preparation of System Requirement Specification Document.
- Query Optimization using Toad 9.7.2.
- Providing on-call support through pagers.
- Sending out communications for top priority issues using P1/P2 communication tool.
Other responsibilities handled:
- Preparing MIS Reports DPR- Daily Productivity Report, Quality Report, Attendance, and Schedule Adherence .
- Taking responsibilities of in absence of Team Lead. Handling all the escalation and assigning priority work to team.