SUMMARY

• Over 13+ years of professional experience in IT Industry deploying Business Intelligence and Data Warehouse applications.
• Knowledge on Universe design and reporting development, Implementation and Support.
• Experience in Design and build the Data Warehouse, Data Marts using Star Schema and Snow Flake Schema for faster and effective Querying for the Metadata Management solutions
• Experienced in Designing, Coding and Unit Testing with Demonstrated record Of high performance standards, including attention to schedules, deadlinesBudgets and quality work.
• Experienced in building canned reports, multiple tabs, multiple queries on single screen, listed and cross tabs, dash boards, charts etc.
• Technical hands - on expertise using Business Objects XI 4.1, XI 3.1/3.0/XI R2/6.x/5.x (Designer, CMC, Desktop Intelligence, Web Intelligence and Info View, Import Wizard, Report Conversion tool, Publishing Wizard, CCM
• Expertise in Content Migration technique using Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Dev, QA and Production & between different versions like BO 5.x/6.x to BOXIR2, XIR2 to XIR3/BI4.1 migration
• Working knowledge of the CMC and general Admin activities in BO 4.1 suite.
• Involved in Migrating the Universe and reports from 3.1 to 4.1 environment and make sure that performance, reports should not break.
• Expertise in Planning, Designing, Developing, Distributing and Maintaining Universes
• Strong at Resolving Loops / Traps in Universe Development using Contexts and Aliases.
• Strong knowledge in building Reports / Queries on different types of Data Providers Universes, Personal Data files, Stored Procedures, Free-hand SQL
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using Source Qualifiers, Expressions, Normalizers, Routers, Connected/Unconnected Lookups/Procedures, Update strategies and Mapplets.
• Configured Power Center Integration services to extract and load Relational, Non-Relational, and Changed Data during Batch, Change and Real- Time basis.
• Good Experience in Requirements Gathering, Documentation and Data Analysis
• Ability to work independently also a Team player.
• Ability to Switch New Technologies If required.
• Knowledge of complete development life cycle of Data Warehousing.
• Experience in Developing Reports on Large Scale Data Warehouse Systems On Teradata, Oracle, SQL Server
• Created Complex Reports using Slice and Dice, Drill Down, Cross Tab, Multiple Table/Section and Master Detail Type reports from Single and Multiple Data Providers (Databases & Excel)
• Experience in software development life cycle (SDLC) methodologies for Data Warehousing and Experienced in Agail methodologies
• Experience in SAP Business Objects Enterprise Administration involving Server Intelligence Agent, Central Management Console, Security Management setting up Folders, Categories and Users Groups, User Security and Management
• Experience in various industry sectors such as Financial, Sales and Telecom and Insurance.
• Good Communication and Result-Oriented with strong Problem Solving skills. Capable of working as a Team Member or Individually with minimum supervision.

TECHNICAL SKILLS

Business Intelligence: Business Objects XI 4.0/XI 3.1/3.0/ XI R2/R1 / 6.x / 5.X,Lumera 1.3,Design Studio 1.6,Tablue 9.8/10.3, CMC,CCM,Web Intelligence, universe Designer, IDT,Crystal reports 2013/2008,CRD reporting

Data Warehousing: Informatica Power Center 9.6.1/7.x/6.x/ (Workflow Manager, Workflow Monitor, Worklets, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations) OLTP, OLAP, Control M

Programming: SQL, PL/SQL, Unix

Databases: Oracle10g/9i/8i/8.0/7.0,SQL,PL/SQL,Teradata,SQLSeerver 2005/2000/7.0/6.5 , MS Access 7.0/2000

Environment: MS DOS 6.22, Win 3.x/95/98, Unix, Linux.

PROFESSIONAL EXPERIENCE

Confidential - LA

Sr.Business Objects Consultant

Responsibilities:

• Interacted with BSA to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports .
• Developed Universes by defining joins, cardinality between tables, creating prompts, applying contexts and alias to resolve loops/traps and checked the integrity of the Universe in Business Objects Universe Designer.
• Created derived tables at the Universe level to reduce the complexity of the Universes.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Exported the ad-hoc ready universes to making semantic layer available to the users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Involved into create the Tickets for promoting the reports in One environment to Other Environment
• Responsible for deliverables on a project which may include CRD reports as per process defined.
• UAT Support & Document preparation for every artifact that I involved.

Environment: BusinessObjects4.1,Informatica 9.6.1,WebI,Oracle, Unix,CRD(Charles river),Crystal 2013

Confidential - New York

BI Tech Lead

Responsibilities:

• Working closely with Business team to define BO requirements and documenting the requirements in order to design, develop and maintain BO Reports.
• Converting Business Requirements into Universe Design Document for reporting.
• Designed and developed BO universe in UDT, Web Intelligence Reports and Dash Boards with different functionalities based on user requirements.
• Involved in creation of Web Intelligence Reports with different functionalities like cascading prompts, drill down, linking reports, charts and graphs, ranking and alerts.
• Created standard Rich client/WebI reports, created canned and ad-hoc Reports Using Business Objects user module.
• Troubleshoot any report design and performance issues.
• Support end user questions related to reports and universe issues.
• Involved in Admin related activities to migrate Universe from Development to UAT and Production environments on demand basis and make sure that existing system doesn’t impact.
• Provide weekly metrics details to make better decisions to the higher managers.
• Responding with urgency to high priority requests from business users.
• Contributing to the design, development and maintenance of ongoing metrics, reports analysis dashboards etc. to drive key business decisions
• Involved in Business Requirements Gathering, Designing, Documenting, Developing, Testing and Deploying the Universe.
• Involved in migrating reports from 3.1 to 4.1 version and make sure that report working properly.
• Set up meeting with the customers to provide the necessary changes in the report for feature usage
• Working closely with DB team to resolve data related issues
• Providing training on how to Scheduling the reports in new BO Environment for new Users
• Involved in adhoc requests and report enhancements.
• Thorough Review of the Reports before moving to the Production
• Involved into create the Quotes for promoting the reports in One environment to Other Environment
• Responsible for deliverables on a project which may include Web Intelligence reports as per process defined.
• UAT Support & Document preparation for every release

Environment: BusinessObjects4.1,3.1,WebI,SQLServer2005/2008,Aquadata Studio 7.0

Confidential - Plano

Sr.Business Objects & Crystal report Developer

Responsibilities:

• Working closely with Business Analysts to define BO requirements and documenting the requirements in order to design, develop and maintain BO Reports.
• Creation of Low-level/Technical/Detailed Design documents for Web Intelligence Reports
• Make sure that all 4 part keys are in corporate in the SQL as well as in the report level.
• Prepare the report requirements to Up stream for data availability in table level
• Make sure that the developed report data is matching with the current production report or not
• Involved in performance tuning of Crystal Reports.
• Set up meeting with the customers to provide the necessary changes in the report for feature usage
• Work closely with Data analysts for getting the Sign off for each report
• Involved into create the daily tasks for off shore and onsite in Version 1 (Agail methodology)
• Involved in adhoc requests and involved in report enhancements.
• Thorough Review of the Reports before moving to the Production
• Involved into create the Quotes for promoting the reports in One environment to Other Environment
• Responsible for deliverables on a project which may include Crystal 2008 and Web Intelligence reports as per process defined.
• Supporting the UAT testing.
• Designed Test Cases based on the requirements and worked with Business Analysts to test the reports
• Involved in KT Transfer when ever the Confidential Core team required.

Environment: Crystal Reports 2008, Business Objects XI R2 WebI,Teradata, SQL Server 2008/2005.

Confidential, Richmond

S r. Business Objects Developer

Responsibilities:

• Managed as many as 3 on-shore and 5 off-shore resources at one time.
• Interacted with offshore and onsite resources on daily basis to provide requirements and consolidate status updates from multiple developers for reporting to senior management.
• Provided Standards, best practices and checklists for reports and universes to improve the performance and maintain consistency across the environment.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business objects Universe and Reports.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Used Crystal Xcelsius 2008 to display summary level business data in visually rich format.
• Used Publication to burst the report to different user groups based on their profile.
• Created and modified the crystal Reports for various financial groups .
• Designed developed and managed Universe in Business objects Designer for generating the operational reports for operational group users.
• Extensively used Calculations, Variables, Drill down and Slice and Dice for creating Business Objects Reports.
• Imported/Exported the Universe from/to repository to make them accessible to end users. Defined Hierarchies in Universe to provide the Users with Drill down option in reports and predefined conditions to use in Business objects.
• Defined Aliases and Contexts to resolve loops in the universes.
• Created user conditions and filters to improve report generation and readability of report and displayed the summary of data by creating Charts.
• Involved in performance tuning of BO Reports.
• Designed Test Cases based on the requirements and worked with Business Analysts to test the reports
• Involved in universe and reports documentation
• Involved in KT Transfer when ever the Confidential Core team required.

Environment: Business Objects XI R2, WebI, Crystal Reports 2008, DB2, Oracle 10g/11g, Teradata, SQL Server.

Confidential

Data Stage Developer

Responsibilities:

• Involved in understanding the existing Data Model and Business Requirements.
• Working closely with Business Analysts to define ETL requirements and documenting the requirements in order to design, develop and maintain Data Stage Mappings.
• Developed Data Stage mappings for staging area and distribution area to validate and cleansing the data and transforming the data as per the business rules (CRM, Ebanking, Trade Finance WMS modules).
• Designed and developed generic Mappings and psets to facilitate code reusability and reduction of development efforts.
• Involved into preparing the UTP and Utr’s for each table
• Involved in Develop the Master Sequence to run the Data stage mappings
• Involved into SIT to fix the bugs.
• Involved into maintain the Version control of each batch.
• Involved in Peer review of each Mappings which is developed by Team to provide Quality of code.
• Involved in preparing unit test cases
• Involved in unit testing
• KT transfers whenever the Dependent team required.

Environment: Data Stage 7.1, Oracle9i, Toed, Windows XP

Confidential

Sr.Business Objects Developer

Responsibilities:

• Working closely with Business Analysts to define BO requirements and documenting the requirements in order to design, develop and maintain BO Reports.
• Creation of Low-level/Technical/Detailed Design documents for Web Intelligence Reports
• Involved in Design the universe development by using Functions, Joins and Formulas and used Alias and Context to avoid the Loop problems at Universe level.
• Created Webi Reports using Universe as data provider.
• Created different types of reports like Cross tab and Master Detail report
• Involved in adhoc requests and involved in report enhancements.
• Responsible for deliverables on a project which may include Web Intelligence reports in the Business Objects product suite as per process defined.
• Involved in performance tuning of BO Reports.
• Designed Test Cases based on the requirements and worked with Business Analysts to test the reports
• Involved into resolve the issues raised by the Stakeholders
• Involved in universe and reports documentation

Environment: Business Objects XI R2, Oracle9i, Windows XP, Toed

Confidential

Sr.Business Objects Developer

Responsibilities:

• Working closely with Business Analysts to define BO requirements and documenting the requirements in order to design, develop and maintain BO Reports.
• Identifying and fixing hyper link and drill down issues in reports migrated from BO 5.1.6 to BO XI Identifying and fixing and formatting issues in reports migrated from BO 5.x to BO 6.5
• Created Webi Reports using Universe as data provider.
• Involved in adhoc requests and involved in report enhancements.
• Designed Test Cases based on the requirements and worked with Business Analysts to test the reports
• Involved in universe and reports documentation

Environment: Business Objects XI /5.1.6, Oracle9i, Windows XP

Confidential

Business Objects Developer

Responsibilities:

• Working closely with Business Analysts to define BO requirements and documenting the requirements in order to design, develop and maintain BO Reports.
• Creation of Low-level/Technical/Detailed Design documents for Web Intelligence Reports
• Involved in Design the universe development by using Functions, Joins and Formulas and used Alias and Context to avoid the Loop problems at Universe level.
• Created Webi Reports using Universe as data provider.
• Created different types of reports like Cross tab and Master Detail report
• Involved in adhoc requests and involved in report enhancements.
• Review of the Reports
• Responsible for deliverables on a project which may include Web Intelligence reports in the Business Objects product suite as per process defined.
• Supporting the System testing.
• Involved in performance tuning of BO Reports.
• Designed Test Cases based on the requirements and worked with Business Analysts to test the reports
• Involved in universe and reports documentation
• Involved in KT Transfer whenever the WMG team required.

Environment: Business Objects XI R2, Toad, Oracle10g, PL/SQL, Windows XP

Confidential

Informatica Production Support & Developer

Responsibilities:

• Prepared for Checklist for all mappings
• Monitoring the Jobs through the APPWORX.
• Fixing the Issues if the Load is aborted.
• Handle the Control runs as per the requirement.
• Test the Load count through the SQL developer
• Knowledge transfer wherever required to GEIT Production team

Environment: Informatica 7.1, Oracle, Windows XP, UNIX, Toed, Appworx.

National Brodcast

Business Objects Developer

Responsibilities:

• Verify migrated components (mentioned above) on Windows OS
• Identifying and fixing hyper link and drill down issues in reports migrated from BO 5.1.6 to BO XI Identifying and fixing and formatting issues in reports migrated from BO 5.1.6 to BO XI
• Creation of Test Plans and Test Cases Unit and Integration Testing
• Executing and testing reports in BO 5.1.6 and BO XI
• Running and validating Oracle SQL’s used in reports
• Working with the existing application team to fix hyperlinks in reports so that the reports are integrated to Portal.
• Documentation of the changed (Delta) modules.
• Knowledge transfer wherever required to NBCU team

Environment: Business Objects 5.1/XI Web Intelligence, Designer, Oracle, Windows XP.