Summary

• 6 years of IT industry experience with expertise in Data Warehousing and Business Intelligence, with key emphasis on Analysis, Design and Development.
• Hands On experience in Informatica 8 Power Center, Workflow Manager, Workflow Monitor
• Used Import wizard to migrate the universes, Corporate Documents, users and groups from BO XI R2 to BO XI R3.
• Extensively worked with SQL Queries, and capable of handling various Databases like Sybase Enterprise 12.5, Oracle 9i, and SQL Server 2000 databases and also have good experience in Database Tuning, and performance techniques.
• Good Knowledge of Dimensional Data Modeling using Star schema, multiple star schema and snow flake schema.
• to administer, deploy, install and configure Business Objects.
• Expertise of admin tasks using Central Management Console CMC which includes the ability
• Extensively worked on Business Objects BOBJ Ad-hoc Reporting by accessing data using Universes, Personal data files, Free-Hand SQL and Stored procedures.
• Experience in Designing Universes and development of reports both in Desktop Intelligence DeskI as well as in Web Intelligence WebI using BO XI R2 and XI R3.
• Excellent understanding of the software development life cycle SDLC .
• Excellent Analytic skills with the ability to recognize and translate business problems in to technology-based solutions.
• Strong experience with client interactions, understanding business applications, business data flow and data relations.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities and flexible in work schedules.
• Good Interpersonal and communication skills, technically competent and enthusiastic team player.
• Ability to work effectively with minimal direction/supervision

Technical Skills

Confidential

Role : Senior BO developer

Confidential different applications, which act as the source of data for the source system for Warehouse.IBD Warehouse has a collection of three universes, each one catering to a different business domain. It also has a set of about 120 reports, mostly in Desktop Intelligence, and few others in Web Intelligence and Crystal Reports. There are also a few reports which are built directly on application tables or on stored procedures.

Responsibilities:

• Interacting with the clients for understanding and analyzing the client requirements, both documented and undocumented
• Document reporting systems Functional Specification Docs, Impact Analysis Doc, and Design Doc.
• Troubleshooting support tickets for operational issues
• Designing the universe based on the report requirements.
• Implementing security through Universe and CMC, so that customer and company data is protected at all times.
• Check for existence of loops and trap in the universe, and resolve them.
• Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.
• Extensively used Calculations, Sorting, Rank, and Drill down, Drill thru, Slice and Dice, Formatting, Breaks, Filters, Changing Displays and Prompts for creating Business Objects Reports.
• Develop custom Webi and Deski reports and customize existing BI reports. Reports are based out of multiple data providers like Universe, Free Hand SQL, and Stored Procedure etc.
• Developing Cross tab reports, Drill up/Drill down reports, Drill through reports, Line charts, stacked charts and Bar graphs.
• Creating the sub reports and linking them with the master reports.
• Validating the report data against the database.
• Performance tuning of the reports and universe.
• Documented all the changes made to the Universes and Reports for future references.
• Responsible for migration of the universes and reports between DEV,QA,UAT and PROD environments , and managing user access in each environment.
• Use CMC Central Management Console to manage the universes, users/groups, reports and Security model to objects.
• Troubleshoot any issues or bugs discovered during the course of a project and provide ongoing application support.
• Analyze and decode existing Access reports and recreate them in Business objects.
• Coordinating with the Infrastructure team for migration from XI R2 to XI R3.
• Mentor junior consultants.

Business Domain: Investment Banking

Environment: Business Objects XI R2/XI R3, Informatica 8, Sybase Enterprise 12.5, MS Access Reports, Crystal Reports, Windows XP, Perforce, DBArtisan

Confidential

Role : BO developer

Confidential namely volume, global trades, nostros matched, nostros unmatched, depot matched, depot unmatched, global fails loader, payable receivables and Exception manager loader XMAN . Each KRI ETL Extract, transform and Load processing is done by following ways namely preprocessing, validation, enrichment and summarization. UNIX shell script, Java 1.4 technologies are involved in this project. Oracle, Sybase and DB2 databases are involved.

Responsibilities:

• Develop Webi/Deski drill up/down reports and cross tab reports.
• Resolve universe problems like loops and traps.
• Creating classes, objects and hierarchies in the universe
• Responsible for end user training to work on reports.
• Responsible for delivery of Business Objects Reports environment on time.
• Involved in scheduling the Custom reports and process them for Business users.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Understanding business requirements and preparing System Requirement Specifications.
• Developing the sub reports and linking them with the master reports.
• Maintain and enhance existing reports in Webi/Deski.
• Validating the report data against the database using SQL.
• Document reporting systems Functional Specification Docs, Impact Analysis Doc, Design Doc
• Performance tuning of the reports and universe.
• Create transformations in Informatica using Power Center
• ETL testing using Workflow Monitor, Workflow Manager and UNIX for running scripts.

Business Domain: Investment Banking

Environment:. Business Objects XI R3, Informatica 8, Oracle 9i, Windows XP, Visual Source Safe, DBArtisan

Confidential

Role : BO Developer

Confidential Data Management and Managed Services is integration into managed services of Data Services Steady State and Data Solution for STeP. This contains the Loan level information from the Loan origination to the Loan Disbursement.The reports were developed to know the loan related information in different phases of the loan life cycle. It helps the Loan Consultants, Processor, Underwriter and Managers to measure.

Responsibilities:

• Develop Webi/Deski drill up/down reports and cross tab reports.
• Maintain and enhance existing reporting system.
• Validating the report data against the database using SQL.
• Developing unit test case and reviewing of Reports to create Unit Test Logs.
• Creating classes, objects and hierarchies in the universe
• Creating Design Documents and Unit Test Plans.
• SCM Coordinator of the project
• Create Report design documents
• Document reporting systems.
• Create reports in WebI.
• Ensuring Quality Standards Practices