Professional Summary:

• 8 + years of work experience in IT Industry in Analysis, Design, Development and Maintenance of various software applications mainly in Data Warehousing ( Business Objects, Inforamatica, Data Integrator), Oracle(SQL, PL/SQL ), , Crystal Xcelsius 2008/4.5, Live Office,Sales Force (SFDC), and environments in industry verticals like Banking, Financial, Telecom, Insurance & Pharmaceutical Industries.
• 5 + years of Data Warehousing Solid experience using Business Objects XI (CMS, Designer, Info view, Business Objects Reporting, Web-Intelligence 6.0/2.7/2.6/2.5, Broadcast Agent, Publisher & Dashboard Manager, Crystal Xcelsius 4.5
• 3 + years of ETL experience using BO Data Integrator 11.5 (Designer, DI Repository Manager, DI Server Manager), Informatica Power center 8.2/7.2 (Repository Admin, Rep Manager, Designer, Workflow Manager & Workflow monitor), Informatica Power Analyzer & Power Exchange.
• 5 years of database experience using Oracle 11i/10g/9i/8i, SQL, PL/SQL, SQL*Loader, Stored Procedures, Functions, TOAD, Explain Plan, TKPROF Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, IBM DB2 UDB 8.0/7.0, MSSQL Server & MS Access.
• Experience in all aspects of project development life cycle in Data Warehousing.
• Developed complex reports using features like slice and dice, Drill capabilities, Complex freehand SQL queries, Master Detail, and Cross Tab tables with multiple breaks.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Solid understanding of relational database system structure, Oracle Database architecture and design and having performed some DBA duties, such as creating and managing all kinds of Oracle Database Objects
• Created logical data model for two data warehouse projects. Created physical designs for implementation on Oracle.

Skills:

Business Intelligence: Business Objects 5.1/6.5/XI r2/3.0, Crystal Xcelsius, Live Office, Query as web server, Cognos, Crystal Reports& MS-Analysis Services
ETL Tools: Informatica PowerCenter, Data Stage 7.x, oracle Warehouse Builder.
Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical
and Logical Data Modeling, Erwin 3.5.2/3.x & Toad
RDBMS: Oracle11i/10g/8i, Oracle DBA, UDB DB2 & Sybase
Languages: SQL, PL/SQL, UNIX, Windows Scripting, C & .Net
Operating Systems: Windows 2000, UNIX AIX.

Work Experience:

Confidential, Eagan, MN Mar ‘07 – Dec’09
Business Objects Consultant / Admin

Job Responsibilities:

• Implemented a New Project by changing the current DW, written details design document & turn it over to the developers
• Helped the team in analyzing the reports to be able to identify the data quality issues
• Work with Business Analyst and business users to clarify requirements and translate the requirement into technical (Report) specifications.
• As a member of BI Team, developing universes, Web-based reports & Full client reports using Business Objects
• Exported the Business Objects reports to WebI to be viewed by all users on the Intranet using WebI SDK with JSP plug-in.
• Designed Scorecards & Dash Board formats with Metrics, Rules & sets.
• Defined Predictive Analytics, Set Analytics, Performance & process Analytics.
  
• Designed Visual Display models Like Graph, IMT , Gauges Using Crystal Xcelsius Designer4.5
• Migrated Business Objects 6.5 reports & crystal reports to BO XI r2.
• Implemented Import wizard & publisher for migrating reports & universes.
• Good working experience in Business Objects Migration.
• Constantly worked with Business users to provide them with the data in form of complex reports and excel sheets for analysis
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Trouble shooting with user on net meeting.
• Designing and developing universes for reporting generation.
• Created the dashboard using Crystal Xcelsius.
• Extracted data from Crystal Reporting using Live Office
• Good experience in communicating with offshore team

Environment:

Business Objects XI R2 (CMC, Designer, Desktop Intelligence, Web Intelligence ), Dashboard, Informatica Power Center, Oracle 9i/10G, Toad, , Crystal Xcelsius 4.5, Live Office, Operating system used are Windows XP & Unix AIX.

Confidential, Pittsburgh,PA Sep’ 05 to Feb’07

BO Consultant

My work at DE was to play a crucial role in developing universes, Web-based reports & Full client reports using Business Objects. All my work involved designing, developing, and maintaining the data in the Data Marts – BDW. Involved with all the phases of the full software life cycle starting from gathering the requirements for designing DW system, Data warehouse design with decision support in mind, development (The ETL was done through Informatica PowerCenter ) and maintenance

Job Responsibilities:

• Designed the Logical & physical data modeling to satisfy business objectives using ER-Win
• Good working experience in Business Objects Migration.
• Constantly worked with Business users to provide them with the data in form of complex reports and excel sheets for analysis
• Created the matrics using dashboard for analyze the revenue of DBS Bank
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Trouble shooting with user on net meeting.
• Installed Business Objects, Created Repository Users and User Groups.
• Created new users, Groups and their accounts privileges in supervisor module
• Created the reports using the universes as the main Data providers.
• Create Context Alias to resolve the Loops.
• Designing and developing universes for reporting generation.
• Created Dimensions, Details and Measures.
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Developed complex reports using features like slice and dice, Drill capabilities, Complex freehand SQL queries, Master Detail, and Cross Tab tables with multiple breaks.
• Universes were designed to support the user requirements.
• Create Context Alias to resolve the Loops and Chasm Traps.
• Modifying the existing universes, adding new objects, editing joins mapping the existing objects with renamed tables.
• Designed and developed full client reports in all different formats and modified, tuned the
• legacy reports.
• Creating new Connections and editing existing to run the report in test, development.
• Used Business Objects for Adhoc reporting.
• Expertise in retrieving data using Business Objects Universes, personal data files and free hand SQL methods.
• Writing Unix scripts & using Unix commands.
• Coordinating with user to gather the new requirements and working with existing issues.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations

Environment:
Business Objects 6.5/ XI (Central Management Console, Designer, Desktop Intelligence, Web Intelligence 6.5/ XI R2), Dashboard, Informatica Power Center, Oracle 9i/10G, Toad, Erwin 4.x, Operating system used are Windows XP, Unix AIX & Tivoli Scheduler

Confidential, Santa Clara, CA Aug’04 to Aug‘05

BO Consultant

Job Responsibilities:

• Good working experience in Business Objects Migration.
• Created various data marts from data warehouse and generated reports using Business Objects.
• Use of Designer Module to implement Universes, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Generated reports using business Objects Report Designer.
• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Use of Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down).
• knowledge of Dashboard application.
• Knowledge in installation, administration of BO desktop and server products on Windows environments.
• Good Working Experience in SQL, PL/SQL Scripts.
• Developed PL/SQL’s and scripts to load data from staging tables to entities and relationship entities tables in Enterprise Data Warehouse.
• Developed Oracle 9i B-Tree and Bitmap indexes for query optimization using Toad. Used Explain plan to identify query bottleneck.

Environment: Business Objects 6.5, Informatica Power Center, Oracle (PL/SQL Scripts) 9i , ER

Confidential, Cypress, CA Mar’03 – July ‘04

Job Responsibilities:

• Involved in the designing and Building of Universes, Classes and objects for Sales, Marketing.
• Used Business Objects Designer to implement Universe, Linkages between Tables, create prompts and queries, and parse the Universes, applied Contexts and Alias Tables to remove cyclic dependencies.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Involved in Installation and Configuration of all Components of Business Objects.
• Exported the universes to the Repository for making resources available to the users.
• Involved in Development and Deployment of Complex Reports using methods like Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc.
• Involved in Installation and Configuration of all Components of Informatica.
• Extracted data from different systems into Source.
• Worked on several transformations such as Source Qualifier, Aggregator, Filter, Joiner, Rank Sequence Generator Transformations, Lookup (Connected and Unconnected),Stored Procedure Transformations, Update strategy, Expression Transformations in Informatica.
• Created Mappings between Source and Target using Designer.
• Developed different Transformations to load the data into target.
• Loaded data into target database from source database using Server Manager.
• Defined the Source databases and Targets and created shortcuts for them in Informatica.
• Wrote precession shell scripts to truncate the staging tables.
• Wrote queries against system catalog tables to get max sequence numbers for a table.
• Created the Mappings, Mapplets in Informatica using designer and created sessions using workflow manager.
• Involved in migrating the mapping/sessions across the environments.
• Involved in creating, editing, scheduling and deleting of sessions and batch of session using workflow manager in Informatica
• Monitored workflows and collected performance data to maximize the session performance.
• Involved in stress and integration testing for the ETL process.
• QA and auditing the ETL data.

Environment:
Informatica Designer, Server Manager 4.5.2, Business Objects 5.1, BO Designer, WebInteligence2.x, Business Objects Supervisor, Oracle 8i, Windows NT.

Confidential, Bangalore, INDIA . Dec’01 to Feb’03
DW Developer/Jr.DBA

• Enhancing existing database objects (stored procedures, functions, packages

and triggers), forms and reports by using PL/SQL, SQL*PLUS, Pro*C, Forms4.5
And Reports2.5.

• Used Designer/2000, Developer/2000 to generate new applications and reports.
• Converting table data to flat file date vice versa by using Pro*C.
• Specifications and detailed documentation during design and development
• ORACLE server installation and configuration.
• Planning, Creation, Performance Tuning and reorganization of databases, monitoring table spaces, indexes, extents, and performance and tuning.
• Activities included server installation and configuration, tuning of init.ora parameters, allocation and maintenance of rollback segments, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Creation of database, table spaces, schemas, database tuning and SQL loading.
• Designed database for Client / Server based applications.
• Planned and implemented backup strategies for the database.

Environment:
Developer/2000 (Forms4.5, Reports2.5), Designer/2000, SQL, PL/SQL, Pro*C, Sun Solaris,
Windows3.1, Windows NT4.0.