SUMMARY

• 8 years of experience in gathering Business Requirements, Developing Business Intelligence/Business Objects (BI/BO) enterprise solutions, designing and implementing Business Intelligence information & analytical solutions.
• Excellent understanding of Oracle, Teradata, MS - SQL Server, MS Access, SQL, PL/SQL, SQL*Plus.
• Experienced in different stages of the software development life cycle such as requirement gathering, analysis, and design, coding, and testing.
• Experienced in data Migration projects.
• Expertise in providing end-to-end business intelligence solution by configuring metadata & building Universe, dimensional modeling design, building business models, generating reports, creating Inter-active Business Intelligence Dashboards using SAP Business Objects 4.0.
• Excellent understanding of Star & Snowflake Schema methodologies & Dimensional Modeling.
• Worked in different Industry Verticals and well experience in Sales, Finance and Marketing Functional Areas.
• Expertise in BusinessObjects XI 4.0/3.1/3.0/XI R2/6.x/5.x (Desktop Intelligence,Web Intelligence,Universe Designer, Central Management ConsoleandBusiness Objects Administration).
• Extensive Experience inmigrationofBusiness Objects Universesandreportsto newer versions.
• Extensive database architecture and design skills of working on high performance solutions in large corporate environments.
• Adept Designing/Developing theBusiness Objects Universes, Ad-hoc/ Canned Reports,Complex Reportsusing predefined conditions.
• Experience in creating reports and accessing queries using Business Objects Query Builder, Web application designer.
• Provided 24X7 support to the users.
• Working noledge on Migration tools likeReport Conversion tool, Import Wizard and Publishing Wizard.
• Worked as a team player wif proven problem solving skills as well as independently wif excellentcommunicationandInterpersonalskills.
• Very good in Debugging, Optimizing and Performance Tuning of BI Dashboards/Reports.
• Worked on Tableau 7 to build interactive dashboard for the business users.
• Expertise in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x /8.6 and 9.1.
• Very good experience in developing Informatica Mappings/Mapplets and Workflows wif Worklets & Tasks using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure and Lookup) for ETL of data from Multiple Sources to Data Warehouse.
• Multi-platform experience on UNIX / Linux and Windows Server family.

TECHNICAL SKILLS

• SAP BI 4.0 & SAP Business Objects R2, 3.1
• Informatica 7.x/8.6/9.1/9.5 (PowerCenter & PowerMart) Tableau 7
• Teradata V6R12, TD12, TD13 & TD14
• Oracle 9i/10g/11g
• MS SQL Server 2000
• PL/SQL 8.x/9.x, SQL*PLUS 8.x/9.x HTML, XML
• Windows 95/98/NT/2000/XP/7, Linux, Unix
• MS Office 2003, 2007 and 2010

PROFESSIONAL EXPERIENCE

Confidential, CA

SAP BI Developer

Responsibilities:

• Information gathering - interacted wif the end user and business analyst to understand the requirement and business logic.
• Analyzed the existing OLAP system and designed/managed universes based on the Business Requirements.
• Designed, Developed and Maintained universes (unx) through information design tool (IDT) by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Used @functions like @select and @prompt function to create prompts which halps the user to select the values dynamically.
• Customized the list of values (LOV’s) which halps the end users to select the values.
• Created complex Condition Objects for easy reporting, Aggregate objects for better performance.
• Developed Business Objects Universes wif classes, objects and condition objects and developed hierarchies to support drill down reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Extensive testing and migrating the reports or objects from development to stage to Production system.
• Worked on the SQL tuning and optimization of the Business Objects reports.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Involved in performance testing of all the reports, which halped in analyzing its performance before moving into production.
• Involved in installing Web Intelligence, creating users, user groups and categories.
• Created Web Intelligence documents and published them to corporate documents.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions.
• Installed and Configured Tableau Server in clustered environment.
• Used Tableau Desktop to analyze and obtain insights into large data sets.
• Created visually compelling and actionable interactive reports and dashboards using Tableau
• Possess SQL and programming noledge to deal wif data transformations and translations
• Developed Webi reports through BI Launchpad to address diverse levels of the organizational requirements ranging from Individual employees to a complete line of operations.
• Involved in developing the financial reports for the financial services department and successfully published the highly formatted reports and met wif the end user requirements.

Environment: SAP Business Objects 4.0/3.1/R2, OBIEE 10x/11x Informatica PowerCenter 9.5.1/8.6, SQL, Oracle10g/11g, TD 13/14.

Confidential, CA

SAP BO Developer

Responsibilities:

• Gatheird the business requirement for the reporting structure.
• Apart from BO 3.1, worked extensively on BO 4.0 in this project. Well verse wif BO 4.0 features and Architecture.
• Enhanced the Universe in (Information Design Tool) by pulling new table from the backend data source (Teradata) and created new logical joins in data foundation layer and used the calculations in Business layer.
• Created Data Mapping Documents, by working closely wif ETL and Data Base developers.
• Involved in the designing and Building of Universes for new Components.
• Resolved loops using Contexts and Aliases
• Involved in creating Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc. to develop the reports.
• Created Web Intelligence reports wif multiple data providers and synchronized the data using the merge dimensions option.
• Created reports using multiple data providers such as Universes and personal data files in generating reports.
• Created Reports wif graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Responsible for developing all types of reports including Cross-tab.
• Involved in creating BV’s by working closely wif Database administrators and ETL developers for Universe development.
• Involved in production Support and gave training to the users. Extensively implemented the SSO (Single Sign on) for CDAS Application.
• Extensively used Kintana workflows for Application migration by creating packages and labels to dat particular package.
• Attend offshore calls on daily bases to resolve the day to day Production issues.
• Created ETL Mappings from Oracle Data source to Flat File to Teradata.
• Extensively worked on ETL Mappings wif different types of Transformations to filter the data from source to target.

Environment: SAP BO 4.0/3.1/R2, Informatica PowerCenter 8.6, PLSQL/SQL, Oracle10g/11g, TD 13.

Confidential, CA

SAP BO Developer

Responsibilities:

• Designed/developed/maintained Business Objects Universes.
• Developed Business Objects Reports based on the new business Specifications and Report Standards.
• Determined the dimension attributes, Fact and involved in Star Model design.
• Develop and export Business Objects Reports to refresh automatically via Broadcast Agent daily, weekly and monthly Confidential specific time wif pre-defined conditions (filters).
• Supported user’s requests for reports and resolved technical problems.
• Created User objects for already existing Universes.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Involved in development and deployment of Complex Reports.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Tested Business Objects reports and validated values as per user requirements.
• Setting different properties in WebIntelligence to test access restrictions.
• Developed snippets of SQL code to validate OWB and report values
• Developed WebIntelligence ad-hoc reports to validate values
• Combine process has been tested to check the WebI report combines.
• Developed test cases to run the test for Business Objects and Informatica migrations
• Performed Administrator tasks using CENTRAL MANAGEMENT CONSOLE to manage groups and users.
• Provided round the clock production support.

Environment: SAP 3.1, Oracle Warehouse Builder, Oracle 10g, SQL Developer, Erwin 4.0, LINUX, PLSQL/SQL.

Confidential, CA

SAP BO and OBIEE Developer

Responsibilities

• Developed Complex, Logical and Physical Data Models, using Erwin Tool.
• Designed/Modified the Universes as per the requirements adding new classes and objects as required.
• Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
• Migrated & upgraded Business Objects from XIR2 to XIR3.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
• Created Web Intelligence and Desktop Intelligence reports wif multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Worked on complex Crystal Reports dat require running totals, sub-totals, sub-reports, prompts, cross-tab, multiple groups, hierarchical grouping and conditional display of groups, fields, and messages.
• Written free hand SQL queries using Oracle database and defined full client reports and webi.
• Created reports on web using Info View Portal and published the reports into info view for different groups and users.
• Extensively used calculations, variables, drill down, slice and dice, alerts in the creation of reports.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Prepared ad hoc supporting documentation for senior financial management.
• Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.

Environment:Business Objects XIR2/6.5/6.1, Web me 6.1, DESKI, JSP, SQL, Erwin, SQL*Loader, UNIX Shell Script, Windows 2000/NT, ORACLE, PL/SQL, SQL Enterprise Manager.

Confidential, NJ

Oracle Business Intelligence/Informatica Consultant

Responsibilities:

• Gatheird Business Requirements by interacting wif IT and documented them unambiguously as System Requirements Specifications (SRS) combination of (FR/NFR).
• Created Highlevel Design Documents(HLD) according to the Business System Requirements(FR/NFR)
• Analyzed the HLD created by me and Source System to create the Application Design Documents.
• Worked as an Application Designer for Mapping & Designing RPD and ETL development.
• Documented Application Design Mapping & ETL Mapping, which halps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions (Metadata and Dashboards/Reports) using OBIEE platform.
• Developed the OBIEE Metadata repository (.rpd) model wif the necessary logic dat involved creating the Physical, BMM layers wif aggregates, dimensions & time series functions, Presentation layer wif catalogs & folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.
• Worked on DAC for creating Auto Execution and Scheduling Tasks.
• Involved in developing Informatica Mappings & Mapplets during enhancements.
• Developed Informatica mappings wif re-usable transformations and mapplets using various Transformations (Source Qualifier, Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, Joiner and Aggregator) for implementing Data Warehouse.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Performance Tuning of Informatica data warehouse loads, including Informatica server Manager and PL/SQL procedures.

Environment: OBIEE 10.1.3.4 & 10.1.3.3.1, Informatica PowerCenter 7.1.4, Oracle 9i/10g, PLSQL/SQL.

Confidential

Jr. Data Officer

Responsibilities:

• Responsible for requirement gathering, evaluating and problem investigation.
• Worked closely wif colleagues to try and identify data related problems and solve them by using SQL queries.
• Conduct research and collect data which will halp in continual product development dat will meet client needs.
• Processing of data and coming up wif reports on various projects.
• Analysis of information using various statistical methods, trying to see patterns in data.
• Conceptualization of data and sharing this noledge through TEMPeffective presentation of the data output wif the rest of our CMS team.
• Developing and preparing information products to be used by the organization.
• Responsible for Database design, data storage and management.
• Upgrading of database systems to meet the needs in the market.
• Ensuring smooth and proper running of database.
• Assisting in the marketing of products and working in close liaison wif the marketing department.

Environment: Oracle 8i, SQL, (Microsoft Office Access, MS Office Excel, MS Office Outlook, MS Office PowerPoint) 2003.