SUMMARY

• 8 years of experience in development life cycle of BI products involving Analysis, Design, Development, Testing, Implementation and support for data warehousing applications
• 5+ years of experience in design, development, debugging and verification of Applications based on Business Objects.
• Clear understanding of Data warehousing concepts.
• In - depth experience in Performing analysis, design, implementation, and support of BO Universes and Reports; Expertise in Designing and developing Web Intelligence, DESKI reports, Hands on experience in designing and developing Xcelsius dashboards using Xclesius 2008; Well versed in handling Business Objects modules CMC, Designer-UDT/IDT, Web Intelligence rich client, Desktop Intelligence, Import Wizard and Xcelsius. (Setup, Configuration, Development and Deployment)
• Experience in creating Analytics and Dashboard using Xcelsius 2008 and Live Office connections.
• Expertise in Translating functional requirements into technical specifications / BO designs and supporting documentation
• Knowledge in writing SQL and PL/SQL code.
• Ability to work independently and as a team member in a problem-solving environment
• Excellent analytical skills, including ability to interpret, evaluate customer requirements and implement reporting solutions.

TECHNICAL SKILLS

Languages: C, C++, SQL

Databases: Oracle 8i/9i/10g/11g, MS Access, Teradata 12

Operating Systems: Windows, UNIX, Linux.

Query Tools/ software: TOAD, SQL Developer, SQL Navigator, SQL* Plus, iSQL * Plus

Other Tools: Oracle SQL Developer, Toad, SQL* Loader, Workflow and Win Runner, RVDK, Clear CaseClear Quest, Microsoft Visual Studio

BO XI R4 tools: UDT, IDT, WEBI Rich Client, CMC, BI Launch Pad

BOXI R2: Web Intelligence, XCelsius2008, Universe Design Tool (BO Designer)

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

BO Architect

Responsibilities:

• Gathering and understanding Business requirements.
• Creating Universe using Universe Design tool in BI R4 environment.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Wrote Complex SQL Queries for Data validation purpose
• Developed flexible queries using filters
• Efficiently mapped business requirements and processes to technical solutions.
• Created 135 canned reports to meet business requirements.
• 25 publications were developed to meet the scheduling requirement of the project.
• Created publications using Single Pass Bursting and Multiple Pass Bursting to meet different business requirements.
• Setting up custom calendars to run publications on specific dates.
• Designing and setting up data security on user profiles.
• Custom hierarchies, hyperlinks, drill were created in the report to make it more informative.

Environment: BO XI R4 tools- UDT, WEBI Rich Client, CMC, Launch Pad, Database-Teradata 12, Teradata SQL Assistant 12.0, and Teradata View Point.

Confidential, Mountain View, CA

Advanced BO Developer

Responsibilities:

• Designed, developed, maintained Business Objects Universes. Created Contexts and Hierarchies to handle user requests. Implemented data/row level security in the universe as per the requirement
• Designed and developed set of complex Web Intelligence reports, complex - cross tab, charts, Master Details and with multiple data providers
• Designed and developed Xcelsius dashboards using live connections.
• Scheduled the Reports on daily wise, monthly wise and weekly by using CMC
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Documented all the changes made to the Universes and Reports for future references.
• Testing reports- unit testing and validated data as per user requirements. Performed system testing
• Handled Application Support activities and Change Requests

Environment: BO XI R2 - Web Intelligence, XCelsius2008, Universe Design Tool, Oracle - SQL, Oracle SQL Developer

Confidential, San Jose, CA

BO Developer

Responsibilities:

• Gathering Business Requirements from senior management
• Understanding existing BO reports
• Creating Live Office connection between Business Objects Enterprise and Xcelcius
• Creating layered Xcelcius Dashboards using sliders graphs, charting and dynamic visibility
• Testing and verifying that data against reports and database.
• Publishing the dashboard in Info view.

Environment: BO XI R2 - Web Intelligence, XCelsius2008, UDT, Oracle 10g, Oracle SQL Developer

Confidential, San Jose, CA

BO Developer

Responsibilities:

• Analysis of existing reports and preparation of reports specifications.
• User Requirement Analysis and creation of the Business Requirement Documents.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• BO universe development and testing for ad-hoc reporting needs
• Development of Interactive, Complex Reports through Web Intelligence.
• Worked extensively with the major functionality of BO like Breaks, sections, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

Environment: BO XI R2 - Web Intelligence, UDT, Oracle 9i, Toad for Oracle.

Confidential, San Jose, CA

Oracle SQL Tester

Responsibilities:

• Writing SQL scripts to test the ETL functionalities.
• Involved in creation of overall test strategy.
• Creating test cases based on functional requirement.
• Writing SQL scripts to test the ETL code as part of unit testing.
• Writing system test cases to verify overall data transformation.
• Involved in executing User Acceptance test cases.

Environment: Oracle 9i, Quest Toad for Oracle, Informatica 8.6.1, UNIX Server, WinScp, Putty

Confidential

Graduate Engineer Trainee

Responsibilities:

• As a fresher my role was to understand the overall architectural design of the Monolis device.
• Handling the new change requests from the clients and implementing them and also fixing the issues raised during testing.
• Doing unit testing for different modules.

Environment: RVDK, Clear Case, Clear Quest, C, C++, Microsoft Visual Studio