PROFESSIONAL SUMMARY

• Over 9 years of IT experience, quick learner, easily adapts to various environments and very effective communication, interpersonal skills and able to handle multiple tasks and projects simultaneously.
• Experience inSAPBusiness Objects suite (XIR4.1, XIR3.1, XIR3, XIR2 & 6.x) with experience in Central Configuration Manager (CCM), Central Management Server (CMS), Central Management Console (CMC), Web Intelligence, Desktop Intelligence, BI Launch Pad, Info View, IDT, Universe Designer, Explorer, Design Studio, Analysis, Dashboard/Xcelsius 2008 andCrystal Enterprise/2011/2008.
• Experience encompasses a wide variety of industries including Investment, Finance, Healthcare, IT industry and Communication.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and Business levels as part of setting up reporting infrastructure.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Proceduresand free hand SQL and involved in the data modeling process.
• Gathered business requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME’s).
• Participated in Tableau 9.0 Beta program, both in Tableau Desktop and Tableau Server
• Experience in Software Development Life Cycle (SDLC) that include duties like providing
• documentation on design, testing and migration from development to production.
• Involved in creating Dashboards as needed usingTableau Desktop and published to

TECHNICAL SKILLS

Operating Systems
WINDOWS 7/ Vista/ NT/XP/ME/98/95, UNIX, MS-DOS

DataWarehousing
Informatica Power Center 9.x/8.6/7.1.3, Mapping Designer, BODI XI R2. Oracle CDC for 9i/ 10g

BusinessIntelligence
SAP Business Objects 4.1/4.0/XI R2/R3.1/6.1/5.1 (IDT, Universe Designer, BI Launch Pad, DESK I & WEBI), BO Explorer, BO CMC, Business View Manager, Upgrade Management Tool, Design Studio, Analysis,Crystal Reports 2013/2011/2008/9/8.5/8.0 , SAP BI 7.0, Dashboards/Xcelsius 2008, Tableau 8.3 Desktop, Tableau Server 8.3

DataModeling
Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling, FACT & Dimensions.

Programming
C, C++, ASP, SQL, PL/SQL, Core JAVA

Utilities & Tools
Make, SCCS, PVCS, OLAP/OLTP, Rational Rose, GDB, Toad for Oracle 9.5.x.

Testing Tools
ALM/Quality Center 11.x, Test Director, Test Manager

Networking tools
FTP, Connect Direct.

Database
Oracle 11g/10g/9i/8i, MS Access, SQL Server 2008R2/2005, IBM DB2, SAP BW 7.0, SAP ECC 6.0

Project Management
MS Project, MS Access, MS Visio and MS Excel.

PROJECTS UNDERTAKEN IN DETAIL

Confidential, Chesterbrook PA
Sr. SAP Business ObjectsDeveloper
Confidential is a market leader in pharmaceutical distribution handling about 20% of all of the pharmaceuticals sold and distributed throughout the country and ranked 32nd on the Fortune 500 list for 2013. They have recently built a Customer Tool for ordering and purchase management named as ‘PASSPORT’. This project handles the customer facing reports (CFR) developed using Crystal Reports 2013 and WebI 4.1
Responsibilities:

• Analyzing existing WebDyn Pro reports and their functional documentation.
• Gathering requirements from the stakeholders and SMEs for the enhancements of the existing reports and converting the reports to Crystal reports and WebI depending on complexity.
• Performing GAP analysis and converting ABAP WebDyn Pro functional documentation into reporting technical micros.
• Demonstrated customer solutions with regards to Business Objects BI 4.0 and Crystal Reports Enterprise to high level Management and Business Users.
• ImplementedOracle11gas a data sourcefor external reporting project, which includes 12 Complex Crystal Reports.
• Microsoft SQL server 2008 is the data source for internal reporting project which includes 2 universes and 5 Crystal reports on top of the universes.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Created BI OLAPuniverses over BEx queries using Universe Designer and created reports on SAP BW HANA Env.
• Working on developing new BI 4.1unx universes using bex queries on the snow flake schema using Information Design Tool (IDT) and developed adhoc/self-service Webi reports to be run with the report prompt for any Customer Id(s).
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations
• Created Tableau Scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Customized the Geo maps to use custom shapes and converted latitude/longitude sets to City/state using Reverse Geocoding utility.
• Created out of the box charts for complex end user Requirements. Converted Heat map to Funnel chart, Pie chart to a donut chart, Bar chart to a waterfall chart and many others.
• Analyzing data using Slice and Dice and Drill Mode methods and formatted the reports.
• Designed universes using various @ functions like @prompt, @aggregate aware, @variable and @bouser.
• Resolved fan and chasm traps in universes and created predefined conditions, prompts filters, Classes and Objects, aliases, contexts in the universes. The objects include dimension, measure and detail etc.
• Used Input Control functionality of WebI to avoid performance issues populating the LOVs.
• ImplementedFolder level security in BI Launch Pad and used the access restrictions to define the Object level security for developers and Power users
• Created 12 complex parameterized Crystal reports2013with monthly buckets and Single layer Crosstab reports.
• Created complicated ranking SQL procedure to support the business requirement owing to the limitations in Crystal Reports.
• Implemented Masking in Crystal Reports and WebI using hard coded SQL procedure.
• Created Custom and Cascading List of Values (LOVs) for better understanding of business logic for the end users.
• Modified and maintained existing universe based on enhancements and updates requested by the business users.
• Created complex Condition Objects for easy reporting, Aggregate-Aware and Index Aware objects for better performance.
• Created and maintained linked universe for this project. Linked the universe to core universe whose data source is oracle 11g
• Defined hierarchies and created drill down reports through to the most granular level for Data analysis using Crystal reports.
• Created a Dashboard using SAP Lumira for a POC presentation using excel sheets as the data source.
• Created reports using SAP Analysis for excel and migrated the reports to Web-I using the plug-in.
• Uploaded the technical micros to ALM (HPQC)/Requirements
• Performing unit testing and executing the test scripts in HPQC/Test Lab.
• Data validation/Analysis using SAP ECC tables which is the OLTP system to start with and followed by Oracle and SQL server.
• Created, Converted and Validated 4 Business Unit level reports using WebI.
• Worked on the migration of the reports from Development Env to QA (STG Env) and after successful testing in Stage env, and closing all the defects/issues, moved the BO reports to production.
• Working on fixing the issues in the report and the universe and updating the status of the defects in the Quality Center.
• Created functionality unit test scripts to test Dynamic prompts, Filters, Export, Masking and Personalization functionalities.
• Created Functional test scripts for unit testing reports, Hierarchy level reports and Business Unit Level reports.
• Discussing future enhancements with SMEs and documenting the same to make sure we deliver a better product.

CFR Mobile Analytics Project

• Analyzing of newly developed BOBJ reports and their functional documentation.
• Had RAS sessions and workshops with business stakeholders to have stable and consistent conversion functional Docs.
• Converted BOBJ Macros to Micros for QlikView Mobile reporting development team.
• Created functional documents with mock-ups and screenshots of the functionality in Qlik View.
• Uploaded the requirements to SAP Solution Manager.
• SAP BW/HANA is the backend database for this reporting project taking the future enhancement into consideration.
• Discussed with QlikView development team about the feasibility of the requirements.
• Created one to one GAP analysis from BOBJ reports to QlikView reporting requirements.
• Designed 3 consolidated micros and FDs for this project.
• Uploaded the requirements to ALM/Requirements.
• Documented the test scripts for the approved functional documentation of reports and uploading them to HPQC/Test Plan.
• Performed manual testing and executing the test scripts in ALM/Test Lab.
• Data validation using SAP BW/HANA tables.
• Created functionality test scripts to test report complicated Filters, Export, Masking and Personalization functionalities and toggle switches in QlikView.
• Discussed future enhancements with SMEs and documenting the same to make sure we deliver a better product both for QlikView and BOBJ.

Environment: SAPBusiness Objects 4.1/ XI R3.1 (BI Launch Pad/ Web I), Crystal Reports 2011, SAP Lumira, QlikView, WebDyn Pro, Tableau 8.3/8.2 Oracle 11g, Microsoft SQL Server 2008, HPQC 11, SAP BW 7.4, SAP HANA, ECC 6.0, SAP BASIS SOLMAN, ABAP, Windows 7.
Confidential , Philadelphia PA
Business Objects Developer/Report Data Analyst
Confidential is an investment banking company, which provides Investments plans, Loan accounts, 401K, 403B for Lincoln and Non-Lincoln Employees. Lincoln has recently built its own Data warehouse and migrated from XI 3.1 to 4.0 to build reports against newly developed Oracle data warehouse. Crystal Reports 2011 was used initially for quick reporting purposes.
Responsibilities:

• Involving in business requirement gathering from the SMEs and report users.
• Sharing the Raw data analysis to help BAs and SMEs in designing the BRDs and Macros
• Convert the Macros to technical docs (micros) and share with development team and Testing team.
• Working along with DBA/s, BA’s for data design and report design.
• Implemented IBM DB2 database and Oracle 11g as the data source for Crystal Reports and BO Universes
• Converted Crystal Reports to Web Intelligence by rebuilding the reports using Universes and Web I 4.0
• Created universe inInformation Design Tool (previously Universe Design Tool) from scratch, maintained and updated the ‘Data Foundation’ & ‘Business Layer’ for the Investment Banking trust reports, based on Logical Model, linked other Database which has Vested Money bucket information, by Data Foundation in Information Design Tool, by creating multisource Relations Connections, for the information using Business Objects 4.0.
• Demonstrated customer solutions with regards to Business Objects BI 4.0 and Crystal Reports Enterprise to high level Management and Business Users.
• Supported BO Admin team for Migration and Scheduling reports
• Created Complex custom Calendars (Daily, Monthly, Quarterly, Yearly, Specific Day of the month, Avoiding long Weekends and Holidays) for scheduling Crystal reports and WebI reports.
• Dealt with complex Loan Accounting data, 401K data and 403B data for reporting purposes.
• Migrated assets from old legacy 3.x servers to the new BO4.0 servers using Upgrade management Tool.
• Performed an Admin role of migrating the reports from Dev environment to QA, and then to Prod.
• Worked on the solution to develop a single report for both On-demand and scheduled, especially with the date range parameters.
• ¨ Extensively worked with new designer tool IDT 4.0 using Projects/Shared Projects, Data Foundation, Business Layer and Security Profiles.
• Detected/resolved data Cardinalities and loops, checked integrity of ‘Data Foundation’s in ‘Information Design Tool’.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Maintained Business Layer with multi Data Foundations by using Advanced Parameter option & created folders based on User requirements.
• Created complex Condition Objects for easy reporting, Aggregate-Aware and Index Aware objects for better performance
• Defined hierarchies and created drill down reports through to the most granular level for Data analysis.
• Created complex Web I reports by linking objects from different data providers and using Merge Dimension Option. Used @functions(@select, @where, @prompt) to create predefined conditions and prompts to filter the data and for dynamic user selectionDefined conditions using @bouser functionality to apply mandatory security filter on the respective class or universe
• Created different types of reports such as Master/Detail, Cross Tab and Chart, use of Filters, use of alerters, Conditions, and Calculations
• Created complex reports using complex variables, multiple breaks,sorts, cascading prompts, decode objects etc. Used breaks for white spaces and sections for better navigability.
• Involved in implementing Folder level security in BI Launch Pad and Implemented Row Level and Column Level Security as per user roles with BO Admin.
• Using Import wizard or LCM to migrate the Universe from one environment to other environment
• Used the access restrictions to define the Object level security for developers and Power users
• Built WebI reports using various Web Intelligence features like alerters, hyperlinking, sections, breaks, sorts, formulas, functions and operators.
• Created Data Integrator mappings to load the IBM DB2, Flat File and SQL Server 2008 tables to Staging area then to Oracle 11g Data Warehouse
• Worked with BODS Designer 4.0 for creating complex mappings, which includes several workflows and data flows to load the data first from source table, which are Flat files and DB2 to staging table. And from staging table to the target table which is “Oracle 11g”.
• Developed dashboards and scoreboards for detailed analysis using different analytics like Speedometer, Interactive Metric Trends, and Barometers using Xcelsius 2008
• Created stored procedures to support the business requirement owing to the limitations in Crystal Reports.
• Migrated 20+ reports from Crystal 2008 to Crystal 2011 so far and resolved the design breakage issues occurred.
• Worked with SAP Technical support team on limitation and issues regarding Cross-tab reports of Crystal reports 2011.
• Worked along with QA team to get the SIT and UAT process to be complete align with Unit Testing and perform code reviews.
• Involved in the process of GAP analysis between requirements and data warehouse to develop universe.
• Implemented high data intensive reports using Crystal Reports against Crystal enterprise Business views.
• Interacted with Informatica ETL team for issues related to workflows involving Data Store and Data Warehouse.
• Working with ETL team in data modeling to build new tables and columns necessary for reporting.
• Working on the development and implementation of Business Views to deploy dynamic LOVs in Crystal reports 2011/2008.
• Prepared and documented the documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents and System testing documents.

Environment: SAPBusiness Objects 4.0/ XI R3.1 (BI Launch Pad/ Web I), Crystal Reports 2011/2008, Xcelsius 2008, Business Objects Data Services 4.0/3.2, Performance Manager, Dashboard Manager, IBM DB2, Oracle 11g, SQL Developer 4.0, SQL Server 2008. Windows 7.
Confidential , Warren, NJ
BI Consultant
Confidential dealing with products like credit cards, mortgage, auto finance and personal loans. The credit card division under US card was involved in migrating Business objects reports from v6.5 to vR3.1 along with fix packs and creating new Web I Reports, Xcelcius dashboards and crystal reports against the US card data for Card business users.
Responsibilities:

• Working on Installing and configuring BO XI R3 servers, along with configuring User groups, folder structures for card team.
• Working on Requirements gathering and raw data analysis for business users and for report development.
• Working on design and developing business objects WEBI reports against multiple data domains like SCRA, CDA, CDW and home loans.
• Designed and developed complete universe by creating joins, contexts, aliases, hierarchies, classes and sub-classes.
• Developed Drill down reports using Hierarchy design in universe for detailed Data analysis.
• Provided Business Objects Universe design changes to address performance, usability and data reliability issues.
• Created reports against Oracle database doe CDW/ SCRA team, Oracle database for home loans team.
• Responsible for administering BO CMC servers and implementing various security levels.
• Created performance analytics dashboards using Xcelsius 2008 against Web I reports using live office.
• Migrated legacy report from 6.5 to XI R2 and then Involved with Development team for Migration of SAPBusiness Objects from XIR2 to XIR3 version and also involved in CMC to provide the User Security settings and Creating User groups in Rich Client 3.1.
• Defined cardinalities, Performed Check integrity, Resolved Loops by creating aliases and contexts to remove the cyclic dependencies.
• Created Web Intelligence Reports (canned & Ad-hoc) that include functionality like Sections, breaks, Grouping, Sorting, Drill-down, Variables and Slice and Dice using Universes & SQL as Data Providers.
• Standardized BI development by creating Design document, BI checklist, SQL checklist for developers and CBT’s for new users.
• Followed data governance instructions for NPI and non-NPI data.
• Involved in System testing, unit testing and UAT for deployed reports and dashboards.
• Created Training manuals for the deployed User reports and conducted Status meetings with developers.
• Involved with Business Users one to one session of all Reports and pointed to defects log for any formatting issues, data issues and any other changes or performances issues and validated Reports.
• Involved in Unit Testing, Integration Testingand Performance Testing of reports and Universes.
• Currently, working on Performance dashboards based on revenue, finance charges, Payments due, Balance transfer, Overdraft and Stop payments using Xcelsius for the divisional managers.

Environment: SAPBusiness Objects XI R3.1 (Web I/ Desk I), SAP BO XI R2, BO DI, Business Objects V6.5, Crystal Reports 11.5, Xcelsius 2008, Performance Manager, Dashboard Manager, Project Management, SQL Server 2005, Pl/SQL.
Confidential , Sacramento, CA
Senior SAP Business Objects Developer/Analyst
Confidential is a technology company that operates in more than 170 countries around the world. We explore how technology and services can help people and companies address their problems and challenges, and realize their possibilities, aspirations and dreams.
Responsibilities:

• Responsible for creating the reports in the development environment and to promote them to production using the import wizard.
• Installed Business Objects Enterprise Product client tools on local machine.
• Analyzed the Functional Design requirements and converting them to technical requirements.
• Preparation of Detail Design Specification documents for Universe and Report Development.
• Assisted the Data Services team in the design of database summary tables and preparing the detail design document on ETL Process to load these tables.
• Involved in development of Business Objects data integrator jobs, workflows, data flows to extract, transform the source data and loading the target tables.
• Used Data Integrator3.0/11.5 for migrating data from SQL Server 2005 and Flat files to the Oracle 10g Data Warehouse
• Created SAP Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows
• Created Universes in such a way, that would enable to create Ad-hoc reports and analyze them in different angles using techniques like slice and dice, drill down, using Oracle as backend data bases.
• Created Classes, Objects, Measure objects, Joins, short cut joins, @prompts and predefined conditions in the universes.
• Defined Custom Hierarchies at Universe level to implement drill down functionality in the reports.
• Defined cardinalities, Performed Check integrity, Resolved Loops by creating aliases and contexts to remove the cyclic dependencies.
• Implemented Aggregate aware function and set up aggregate navigation with objects derived from standalone tables within the universes.
• Applied index aware functionality on non indexed column objects to increase the performance by directing the report query to select the index fields from the database for faster retrieval of data.
• Created Cascading Prompts at universe level for dynamic selection of data within a hierarchy as per the user requirement.
• Built drill-down reports using Scope of Analysis and drill filters functionality within Business Objects Web Intelligence.
• Created templates to customize style and structure according to the employer's needs.
• Involved in writing and documenting unit test cases and exporting the results to HP Quality Center.
• Involved in system testing of already existing universes in Production Test Environment.

Environment: Business Objects XI3.1(SP3), WebI 3.1(SP3), Designer, Info view, Crystal Xcelsius 2008, WebI Rich Client, Import Wizard, Report Conversion Tool, Query as Web Service, SQL, PL/SQL, SQL Server 2005, Oracle 9i/10g/11g, Oracle SQL Developer 1.5.5, Toad 9.5.x, SQL Plus, BO Data Integrator 3.0/11.5, Quality Center, Windows XP
Confidential , Woodbridge, NJ
Lead SAP BO Developer/ Data Analyst
Confidential subsidiary of Tokyo-based Sankyo Co. Ltd., the second-largest pharmaceutical company in Japan and produces the highest quality prescription drugs
Responsibilities:

• Involved in constant Requirements gathering and business needs with executives and traders for Dashboard design and development.
• Lead a team of 4 developers and 3 BA’s for business Objects implementation.
• Converted legacy BO 6.5 and BO 5.1.8 reports to SAP BO XI R3.1 Reports.
• Converted Reporting business requirements in to Functional design and Technical design documents for Developers and testers.
• Working along with DBA/s, BA’s and Data modelers for data design and report design.
• Involved and designed the Enterprise level data security, report security level set up folder structure and User group access.
• Created Unit Test cases, Test scripts for Unit testing, UA testing and System testing.
• Administered user privileges, access, training and implementation for SAP BO XI R3.1.
• Worked along with QA team to get the SIT and UAT process to be complete align with Unit Testing and perform code reviews.
• Upgraded the Medicare XI R2 environment on to XI R3.1 environment.
• Created multiple Universes specific to Medicare and Providers subject area. Implemented user friendly universes for users to create Ad hoc reports.
• Implemented aggregated data for Xcelsius dashboards and Imported Xcelsius on to BO environment (Info view).
• Wrote Autosys jobs and scripts for scheduling BO reports.
• Implemented SAP Business Objects Data Integrator XI R3 as a Standard ETL tool to retrieve and clean up data from multiple scattered data sources.
• Implemented IBM DB2 database as the data source for BO Reporting.
• Involved in DB2 data modeling and data structures during the initial stages of the product.
• Linked Performance management dashboards to Xcelsius dashboards.
• Xcelsius dashboards include drill down from reports, Combination charts, Goal declaration, Medicare History Score card and IMS forecast.
• Created Executive dashboards with Drill, Drop down, details, Linking to BO Reports, Tabbed and also with Open doc statement.
• Implemented Snow flake design and modeling based on the report requirements.
• Implemented high data intensive reports using Crystal Reports against Crystal enterprise Business views.
• Interacted with Informatica ETL team for issues related to dataflow.
• Created stored procedures to support the Crystal Reports.
• Defined Metadata information for the reports.
• Implemented IMS health data as a 3rd party data source for Health reports.
• Created hands on 40 + interactive reports and designed them to satisfy 3rd party front ends like Compleo and TMHP.com
• Implemented .Net based frame work using BO SDK to convert Crystal Report files in to PDF documents to a local LAN folder for Auditing purposes.
• Implemented in total of 45 scheduled and daily reports developed using Crystal reports and Desktop intelligence based on the Data intensity.
• Implemented live office via QAAWS to generate reports against MS products.
• Created Technical Support documentation for Reports and universes.
• Implemented and trained Developers as well as users on new BI standards.
• Created PL/SQL based stored procedures for data intensive reports.

Environment: SAPBusiness Objects XI R3.1 (Web I/ Desk I), SAP BO XI R2, BO DI, Business Objects V6.5, Crystal Reports 11.5, Business views, Info Cubes, Xcelsius 2008, Performance Manager, Dashboard Manager, Project Management and IBM DB2.
Confidential
Business Objects Developer
Responsibilities:

• Played an admin role, in establishing user access and system set up in various environments (Clustered Network).
• Participated in Project planning, Performed analysis, Design and created Functional Design and Detail design Documents.
• Created a standard SOA to have MARS work with other front end applications.
• Worked as an Application developer in designing BO Universes and BO Web I (XI R2) Reports.
• Involved in setting up of folders, groups, LDAP security, Objects Migration and Performance tuning.
• Converted Data Design in to Report design and Universe design through Functional Design documentation and Technical design documentation.
• Implemented and Involved in Onshore – Offshore Delivery model during design, development and testing phase. The Offshore involved 4 developers and 2 Testers.
• Filtered and Cleaned up data from various flat files using BO DI and merged it with standard SQL database for specific Stand alone reports.
• Provided timelines to Design and development sessions.
• Implemented new BO XI R3 environment against UNIX systems.
• Worked along side with BA’s to consolidate the User requirements and interpreted them in to Technical language for DBA’s and Designers.
• Created multiple canned and scheduled Crystal Reports using standard procedures.
• Implemented SQL stored procedures for performance intensive reports, which also requires constant Scheduling.
• Derived and Created Xcelsius dashboards like Health score cards, Medicare beneficiary by period, Medicare audit by region and Forecast Goals.
• Imported data from different data sources and loaded it to the Targets.
• Merged Market research data (IMS) with Cost based reports.
• Created multiple universes to support ad hoc reporting environment.
• Member of an offshore team of 4 for report design and development of SP’s and Reports.
• Implemented Xcelsius as the dash boarding tool, created links to flash files from the web I content.
• Designed and Developed Test cases for Unit and UA testing.
• Introduced Business Objects voyager for report development using cubes.
• Used Clear case and PVCS for versioning for the reports.
• Planned, Designed and scheduling the training power users on Ad – hoc reporting.
• Implemented and created a plan for BO XI R3 migration from SAP BO XI R2.
• Implemented BO XI R3.1 against the Sql server database.
• Set up and Implemented Qaaws to generate reports against live office.
• Involved in BI information assessment for data maturity and technology updates.

Environment: Business Objects XI R2 (Web I XI R2) and SAP BO XI R3.1 (Web I R3.1), BO Voyager, Crystal Reports 11.5, Business Views and 2008, DB2, Performance Manager XI R2, Qaaws, Windows 2003, OLAP, SQL Server 2005.
Confidential
Business Objects Developer
Responsibilities:

• Extensively worked on stored procedures functions using SQL, SQL Plus and PL/SQL.
• Used PERL programming for developing web scripts, to process data passed via CGI from HTML forms.
• Involved in D.B.A work and performed maintenance of database, created indexes, synonyms, etc.
• Updated tables daily and weekly according to the requirement
• Designed and developed Essbase cubes through extracting data from Oracle/SQL databases to generate multidimensional reports for marketing management
• Designing and developing programs for the investment management using Business Objects at front end and Oracle at back end.
• Designing and development of Universes, Classes and Objects.
• Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops and Checking the Integrity of the Universes.
• Implemented Parameterized sorting wherein the reports had the sort values driven by a formula.
• Created Complex formulas using CASE, IF STATEMENTS and STRING CONVESRION and DATE CONVERSION functions.
• Exporting the universes to the Repository in order to make the resources available to the users.
• Created new data stores, Projects, Jobs, data flows and Real time jobs using BO data integrator to move data from spreadsheets and COBOL logic on to new data warehouse environment.
• Creating reports for various Portfolios using the Universes as the main Data Providers
• Creating the reports using Business Objects functionalities such as Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.
• Created customized LOV's and cascading prompts for easy access to business users
• Created a wide variety of charts like pie chart, 2D and 3D charts reflecting the current information versus the forecasted information.
• Exporting the Reports to the Document Agent Server and Using the Doc Agent server to Schedule and Monitor the Reports
• Production Support and gave training to the users.
• Worked on Balanced Scorecard for a strategic feedback system that helped program managers to make better decisions faster.

Environment: Business Objects6.x (BO Designer, BO Supervisor, Document agent server, BO Miner, BO query),BO XIr1, PERL, Webintelligence2.5, Desktop Intelligence, XML, JRun Oracle8i, Pl/Sql, Windows NT.