SUMMARY

• Having 7 years of Professional IT experience in Business Objects development.
• Expert technical skills in Oracle, SQL Server and SAP BI 4.0, BOXI R3.1 and BOXI R2.0.
• Good Knowledge on data warehousing concepts and different types of schemas like STAR and SNOW flake, Fact and Dimension tables.
• In depth Knowledge of designing Entity Relationship and dataflow diagram for business processes. Strong understanding of data modeling and dimension modeling concepts like slowly changing dimensions.
• Strong experience in Universe development using Universe Design Tool UDT and Information Design Tool IDT .
• Experience in developing complex WebI Reports as part of requirement.
• Used Translation Manager Tool to make the Universe ready for different language settings.
• Having experience in creating Users, User groups, security and scheduling the reports using Central Management Console.
• Implemented effective functionalities like derived tables, Aggregate awareness, Index awareness, object and Row level access restrictions during Universe development.
• Implemented contexts to fix the loops and traps at Universe level.
• Involved in end-to-end Project development lifecycle in terms of requirements analysis, system study, designing, testing, de- bugging, documentation and implementation.
• Skilled in interacting with business users to gather business requirements.
• Enthusiastic and project-oriented team player with good written and oral communication skills.
• Experience in Software methodologies like Waterfall model, AgileMethodology, Scrum.

Technical Skill Set

• Languages:SQL, HTML
• Tools:SAP BI 4.0 and BOXI R3.1, BOXI R2, Universe Designer, Web Intelligence, Desktop Intelligence, CMC, Import Wizard
• Operating systems: UNIX/Linux Solaris, Redhat , Windows 98/NT/2000/2003.
• Data Modeling: Microsoft Visio, Toad Data Modeler
• Standards Methodologies: Waterfall model, Agile Methodology
• Databases/Tools: Oracle 8i, 9i, 10g ,TOAD 8.6, 9.0.
• Change Management / Bug Tracking Tools:Remedy IT Service Management Suite, Ticketing console, 3 help.
• Other Tools and Softwares: Putty, Microsoft Office MS Word, MS PowerPoint, MS Excel, MS FrontPage , Citrix Metaframe
• Domains: Telecom, Health Care

PROJECTS EXPERIENCE:

Confidential

Role: BO Developer/Team Lead

Description:

This is a remarketing project. Once the customer contract term has concluded, the Confidential phones are remarketed based on quality. If the quality of the phones depreciates then the company will perform a service check and make sure the quality is maintained as a new phone remarketed for a lower price.

Roles, Responsibilities:

• Understanding the functional documents, Report templates, ER diagrams and database tables to meet the user's requirement.
• In this project ETL team integrates data from different sources to data warehouse we have different subject areas like finance and Remarketing. As part of business requirement we have developed universes and different Web Intelligence reports using BOXI 4.0 and Oracle 10g.
• Experience in developing, modifying and improving the performance of complex Webi Reports with multiple data providers and scheduling reports using Central Management Console CMC .
• Communicate with business users to determine business requirements and coaching them on the best way to utilize BOBJ for data analysis and reporting.
• Implemented Aggregate Awareness to improve the performance of a report at the Universe level.
• Performed security features like row level, report level object level security at Universe level to make sure the sensitive data is secure.
• Used different business objects functionalities like drill down and drill up, Crosstab, Ranking and Breaks in reports.
• Closely worked with database teams to ensure the data requirements are complete and accurate.
• Used remedy tool to communicate with business users.
• Trouble shooting of developed reports and Universes.
• Prepared release notes for Universe Reports as part of production releases.

Environment: Windows XP, SAP BI 4.0, Oracle 10g, Import Wizard, Toad9.0.

Client: Confidential

Role: BO Developer

Description:

• Confidential the world's largest research-based pharmaceutical company, discovers, develops, manufactures and markets prescription medicines in 11 therapeutic areas including oncology, cardiovascular, pain, neuroscience and infectious diseases, including HIV/AIDS.
• Confidential acquired Wyeth and all the systems in Confidential were combined into a new application Trackstar. Reports were developed to merge data from three systems PMC, GCMC and HA obligation into reports.

Roles, Responsibilities:

• Studying Business requirements document, and worked with business user to understand the requirement and performed several report mock-ups to conclude the requirements.
• Created new Classes and Objects in the Universe based on Functional Specifications.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity
• Involved in Reports Development using Rich client module of BOXI R3.1.
• Deployed Business Objects Universes and Reports in a Secure Environment from one Server to other using Import Wizard.
• Implemented derived tables at Universe level to meet the business requirements and to reduce report level complexity.
• Used Translation manager tool to make the Universe available for different languages settings.
• Created reports using Business Objects functionalities like drill down, Break and sectioning to produce flawless reports.
• Created reports in different formats like tabular and Cross-tab.
• Responsible for administration and configuration changes of business users using Central Management Console CMC .

Environments: Windows XP, BOXI R3.1, Oracle, Remedy

Client: Confidential

Role: BO Developer

Description:

• Confidential is one of the world's largest mobile telecommunications companies with operations in Confidential.
• Worked on many Confidential raised by Telenor and created new reports and modifying existing reports. Involved in end-to-end activities like requirements gathering, designing, build, test and release. Confidential tool is used for CR activities and also worked on incidents created on BO data warehouse and admin activities.

Responsibilities:

• Gone through the ER documents to understand the client requirements.
• Installed SAP BOXI R2 on Tomcat Apache.
• Involved in WebI and deski report development.
• Worked on sub reports, standard, cross tab reports graph reports by using chart expert of crystal reports.
• Created Business Objects reports like charts and tables.
• Used various Functions to customize the objects in Universe.
• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
• Generated various reports on daily, monthly yearly basis.
• Used different functions like logical, numeric, date functions and variables to fulfill the report requirements.
• Involved in Defect fixing at the time of UAT, and used Quality Center tool to track and update the status of the defect.
• Created Publications for various reports to burst the reports into various locations as per the client requirement.

Environment: Windows, BOXI R2.0, Oracle 9i, BMC Tiara ticketing tool, Quality Center tool