SUMMARY

• Around 71/2 Years of experience in the field of Information Technology with expertise in design and development of Semantic Layer (Universes)/Reports/Dashboards using SAP Business Objects Reporting Suite (6.5/XI R2/XI 3.1) on various relational databases (Oracle 8.x/9i/10g, MS SQL Server 2000/05/08, Teradata 8.5, SYBASE 15, DB2) and Data Warehouses (SAP BW 3.5, Informatica 8.1, SAP BODS).
• Experienced in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting.
• Expertise in designing, optimizing and maintaining complex Universes.
• Expertise in developing enterprise canned reports and ad-hoc queries/reports using Crystal reports and Web Intelligence.
• Well versed in designing and developing the "Universe" (business view of the database), updating the existing Universes and developing canned/ad-hoc reports.
• Expertise in developing executive Dashboards in Xcelsius 2008 using live data sources (Live Office, QaaWS, BI Web Services, and XML).
• Involved in migrating previous versions of Business Objects to the latest SAP Business Objects Enterprise XI 3.x.
• Clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL.
• Involved in performance tuning of SQL by implementing index awareness in the universe to avoid full table scans.
• Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level.
• Extensively worked with database development writing stored procedures, functions, packages and data base triggers using SQL, PL/SQL.
• Extensive experience in RDBMS like Oracle10g/9i/8.x/7.x, SQL Server 2000/8.0/7.0, IBM DB2, Worked on Windows XP/2000 adv server/2003 server/98/NT/95 and UNIX/Linux, windows based GUI tools for databases like TOAD, SQL Navigator, Rapid SQL and Enterprise Manager.
• Solid experience in Supervisor/CMC, Broadcast Agent, Auditor and Business Objects Server Administration.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs and did documentation for management and development for end-user training.

TECHNICAL SKILLS

Data Warehousing Informatica Power Center 8.6/8.1/6.2/6.1, SAP BW 3.5, SAP BODS 3.2.
Dimensional Data Modeling Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer
RDBMS Oracle 8.x/9i/10g, SQL Server 2000/05/08, Teradata 8.5, SYBASE 15, DB2
Oracle Tools Oracle9iAS, TOAD, SQL*PLUS, PL/SQL Developer, SQL Loader, SQL*NET
Reporting Tools Business Objects XIR3/XIR2/6.5 (CMC, Designer, Reports, Supervisor, Web Intelligence, BCA, Desk Intelligence, BO SDK), Crystal Reports.
Methodologies Object Oriented Design and Analysis, STAR & SNOWFLAKE Modeling, Multi-tier Application Design, Reverse Engineering
Operating System Windows 95/98/2000/XP, Windows NT, MS-DOS, UNIX, HP-UNIX, LINUX and Sun Solaris
Others Erwin, HTML, DHTML, ASP, MS Project, MS Office 2000/03, Oracle Designer, Microsoft VISIO
Environment Sun Solaris 2.6/2.7, HP-UX 11.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT 4.0, Sun-Ultra, Sun Classic, UNIX, HP9000, RS6000

EDUCATION

Bachelor's Deegri

PROFESSIONAL EXPERIENCE

Confidential, Owings Mills, MD Apr 2011 - Till Date
Sr. Xcelsius & BOBJ Developer
The GISbusiness intelligence pilot project involved creating eight executive dashboards and several WebI Reports for the Baltimore Business Management Department using Business Objects and development of data martthat increases the productivity of associates by providing for retention of historical data in support of trending analysis and simplifying the ad-hoc reporting capabilities using Business Objects in Agile Scrum development methodologies. These dashboards and reports represent business (Wins, Losses, Opportunities, Trends over years, Assets under Management) through various dimensions so that the Executives can better evaluate their clients and business.

• Interacted with business users to analyze the business process and requirements and transforming requirements into prototypes.
• Worked with ETL team to translate business requirements into ETL processes while developing the data mart.
• Designed, Developed and Maintained Universe by defining joins, and cardinalities between tables. Addressed cyclic dependencies issue by either applying contexts or creating aliases.
• Used @functions like @select, @where and @prompt to create prompts that help the user to select the values dynamically.
• Created many complex Web I and full client reports (used multiple data providers, Sub Queries, Master/Detail, cross tab, Charts) which includes special field, user variables and complex calculations using report level contexts (In context & Out Context).
• Leveraged the use of indexed and primary key columns in the where clause of the report to improve the performance of the query. Used aggregate awareness and short cut joins to improve query performance.
• Analyzed various connectivity options to optimize performance and design process of Xcelsius dashboards.
• Developed an exclusive home page (Launch Pad) to launch dashboards with interactive Components and implemented component level security in the dashboard.
• Created dashboards with drill down, dynamic visibility functionalities and user interactive Pop-up windows to show additional details of data.
• Created Webi Reports for more detailed and granular level data based on selections on dashboard through OpenDoc functionality.
• Documented Implementation plan for dashboards, Universe and Reports.
• Used LCM for migration and version control of Reports and Dashboards between environments (DEV/QUAL/PROD).
• Created Event based recurring report Schedules that gets triggered based on the ETL loading.
• Closely worked with platform administrator and SAP support team on several platform issues.
• Trained the end users on using the Web I environment by highlighting the user friendly concepts and the ease in developing Ad-hoc reports. Provided the end users with easy to read and understand documentation for the Web I reporting tool.

Environment: Business Objects XI r3/6.5, Xcelsius 2008, SQL Server 2005, Universe Designer, Informatica 8.0, Web Intelligence XI r3/6.5, BODS, PL/SQL, OLAP, Erwin 3.5.2, DBVisualizer v6.5.5, MS Office 2003, MS Project 2007, Windows XP.

Confidential, Salt Lake City, Utah January 2009 - Feb 2011
Business Objects & Xcelsius Developer
Confidential, the retail pharmacy division ofCVS Caremark is the second largest pharmacychainin the United States; the project involved developing Business intelligence reports using Business Objects Creation and development of universes and Objects. These Reports present the data along different dimensions of business which helps the senior management to make business critical decisions.

• Interacted with Business Users and Business Analysts to understand and document the requirements and Built Universes for end user reports generation using Business Object 6.5/XIR2/XIr3 and Crystal Reports 2008 Suite.
• Migrated Universes and Reports from Business Objects 6.5 to XIR2 and from BOXIR2 to BOXIR 3.1.
• Created custom features in Business Objects XIR2 for the customization of web pages using BO SDK.
• Good experience with CMC/Supervisor in creating users/groups and assigning privileges.
• Designed and developed complex Universes.
• Defined various Contexts and aliases in Universe.
• Implemented various Schema modeling techniques like star and snowflake schemas.
• Optimized different types of queries in enhancing the performance of the universe.
• Created various Object hierarchies to allow users to perform multidimensional analysis.
• Resolved fan traps and chasm traps and loops.
• Used various functions like @Aggregate aware, @prompt, @select in designing the universe.
• Implemented Multiple Linking of data providers using merge dimensions combining data from two Universes.
• Performed Indexing in coordination with the Business objects administrator improving the performance of reports.
• Did enhancements to the existing reports like linking the reports in the repository at the universe level.
• Developed a custom database using packages, Procedures and functions using SQL and Pl/SQL using Oracle 10g and SQL Server 2000/2005.
• Defined analytical functions for the function groups like ranking, accumulative aggregation.
• Managed universes like deploying, setting security controls and optimizing the universe.
• Developed several Complex Reports, various features include multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulas, Running Totals and conditional suppressing, formatting using Crystal Reports.
• Developed Summarized Cross-Tab, Master/Detail Reports by implementing various functionalities like Custom Filtering, Creating Alerts, Date and String functions.
• Created linked and Unlinked Sub reports and used different Custom Functions and worked with various Financial Functions.
• Visualized Data and enhanced reports using different types of charts like Histogram charts, Bar charts and Funnel charts.
• Carried out the performance monitoring and tuning of reports.
• Troubleshot database connectivity problems in the various designer components of Crystal Reports.
• Generated SQL scripts and Unix Shell Scripts for validating and testing reports
• Trained users in scheduling reports in BOXI server with on-shore and off-shore coordination.
• Created Xcelsius dashboards using Live office, QaaWS, XML data Providers.
• Configured Live office integration with Xcelsius.

Environment: Business Objects XI r3/r2/6.5, Teradata, Designer, Crystal Reports 2008, Xcelsius 2008, Discoverer, Informatica 8.0, Web Intelligence XI r2/6.5, Unix Shell Scripts, Business Intelligence, SQL Server 2005, Unix Shell Scripts, XSL/XML, Oracle 10g, PL/SQL, OLAP, Windows XP and AIX.

Confidential, San Jose, CA March 2007 - December 2008
Business Objects Developer
The main objective of the project is to develop reports for Gap Inc and for banana republic. The project includes developing of various reports such as Financial Overview Sales, Financial Overview Margin, Financial Overview Summary, Financial Overview Average Store, and Financial Overview Inventory. These reports give complete information about the performance of the company over particular period of time.

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Interacted with Business Analysts to understand business needs and requirements for developing the Reporting Application.
• Migrated the universes from Business Objects 6.5 to Business Objects XIR2.
• Used supervisor module for disabling / enabling access to documents and access to universes.
• Wrote Packages, Procedures, Functions using SQL* Plus Functionalism.
• Development of advanced SQL and PL/SQL code tuning based code in support of Reports for Oracle 10g and also developed Procedures and Functions using SQL 2005.
• Used Designer to create universes containing complex dimensions, measures, conditions and prompt objects to be used in Business Objects.
• Checked the universes for Integrity and exported them to make resources available to the user groups.
• Used different types of joins, set the cardinalities and resolved issues like loops by creating aliases and contexts to remove the cyclic dependencies.
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.
• Created custom List of Values (LOV's) for better understanding of prompts by the end users.
• Created Timeframe (Monthly, Weekly and Daily) basis reports using different Data Providers.
• Generated Cross Tab and Matrix Reports as per the business requirement using Crystal Reports XI.
• Created User-Defined Variable for Static, dynamic cascading Parameters using Crystal Reports XI Suite.
• Developed mockup reports for evaluation and user presentation.
• Created complex reports by linking data from multiple data providers and writing the Complex queries including Sub Queries and Correlated Sub Queries.
• Created different kind of Charts in the reports for the purpose of Analysis.
• Maintained and supported reporting engine developed in the Business Objects SDK.
• Created Report Templates for consistency in the look and feel of the reports.
• Used multi dimensional analysis (Slice & Dice and Drill through methods) to organize the data along a combination of "Dimensions" and "Drill-down Hierarchies" giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of the team.
• 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.
• Build complex reports by using functionalities like @Functions, master details reports, formulas and Cross Tab tables.
• Creation of Different News Index Folders and setting up the Access Rights and Scheduling of pre-run Reports on the Daily and Monthly Events triggered by the Data Mart Loads.
• Created Macros to automate the task and to customize the reports.
• Trained the team members to create the Reports and Charts.
• Used Test Director as a defect tracking tool.
• Migrated universes and reports to different environments.
• Installed Crystal Xcelsius, Query as Web Service, Live Office Add in (Client) and created dashboards.
• Used QAAWS, Live Office Connector to build the Xcelsius Dashboards.

Environment: Business Objects 6.5, Business Intelligence, Business Objects 6.5.1(Supervisor, Designer, Reporter) Web intelligence 6.5.1, Business Objects SDK, Crystal Reports XI, Info view, Broadcast Agent, Oracle 9i/10g, SQL Server 2005, PL/SQL, Test Director, Windows XP and UNIX - AIX.

Confidential, Franklin Lakes, NJ August 2006 - February 2007
Business Objects Developer/Analyst
Confidential, provides pharmacy services for private and public employers, health plans, labor unions and government agencies of all sizes, and for individuals served by Medicaid and Medicare Part D Prescription Drug Plans. As a Part of Medicare Part D PDP business, reporting needs to track enrollment for the Medco PDP which includes members represented by brokers and enhanced clients who are part of the Medco PDP.

• Gathered the requirements from users.
• Responsible for the creation of the data warehouse (Mart) by interviewing and gathering the business requirements of the users, design specifications, metadata, new schemas and enhancements to the existing schemas.
• Entity relationship diagrams were generated using Erwin 3.5.2 - Data Modeling tool for Relational modeling.
• Generations of physical and Logical data models.
• Creating the STAR schema & Dimensional data models for the Data Mart.
• Developed embedded SQL and Potential development of applications utilizing the Business Objects SDK
• Migrated the architecture and security models of Business Objects from BO 6.1 to BO XIR2.
• Designed and Created Universe, Classes and Objects for management system.
• Scheduled the reports Info view Using Crystal Reports 9.x.
• Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) to overcome the problems with database when integrating with BO.
• Development and Deployment of Complex Reports. Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.
• Created Templates for standardizing the Structure of our Corporate Documents.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Query Prompt and Drill filters.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Created test scripts using SQL to test the report calculations against the data mart.
• Used Broadcast Agent for scheduling and distributing the documents.
• Trained end users in the functionality of the software with on-shore and off-shore coordination.

Environment: Business Objects 6.1(Supervisor, Designer, Reporter), Infoview, Crystal Reports 9.x, Web Intelligence, Informatica 6.2, 3 Tier Business Objects, Business Objects SDK, BCA, Xcelsius, Oracle8i, SQL Server 2000, PL/SQL, SQL Tools, Windows 2000 Server, Forms 6i, Discoverer, OLAP, UNIX, Shell Scripts.

Confidential, Chicago, IL December 2005 - June 2006
Business Objects Developer
The main functionality of this project was to do the performance analysis of the marketing campaigns launched by Household Finance Inc., all over the world. The company's data comes from different operational sources like Asian, USA, European countries and stored in a data mart. The data is then transformed and loaded into a centralized data warehouse for various strategic business reports.

• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Created and managed the user groups with row level and object level security
• Worked on change control process from development to production level (3 middle layers)
• Created Finance and Financial Aid Universes for ad-hoc reporting. (Kernel approach)
• Enabled and disabled the services and modules to the users.
• Worked extensively on Business Objects SDK ( report engine SDKs) for delivering reports
• Used Universes as source for the Business Objects reporting and analysis
• Worked on Supervisor to create users, creating user groups, users and categories
• Resolved loops by detecting cardinalities and using contexts and aliases and checked the integrity of the Universes.
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc
• Used Broadcast Agent Publisher for Report Bursting, so that each individual receives particular information in Excel format
• Designed and Developed Technical User Documentation and involved in training the End Users
• Created user Prompts, Conditions and Filters for the report generation.

Environment: Business Objects 5.1, Broadcast Agent, Publisher, Web Intelligence 2.8/6.0 (Reporter, Info View), Db2UDB, JSP, OLAP, Windows NT

Confidential, Hyderabad, India January 2004 - September 2005
Developer
Financial Control Management System-The Purpose of the project is to build a Payment Interface between the Merchant /Service Provider e-commerce portal and Citibank payment gateway that provides complete transaction processing routing to meet the needs of fully fledged e-commerce network. By implementing this solution, the Customers will be able to use the Credit Cards/Debit Cards on the e-commerce portal sites to make payments. Currently the authorization of these cards is obtained manually in an off-line mode. By implementing the payment interface solution, the transaction will be routed to Citibank India Payment Gateway for authorization

• Designed the ETL processes using Informatica to load data from DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to target Oracle Data Warehouse database.
• Developedand validated appropriate mapping among transformations using Informatica 4.7.
• Designed the Architecture of database using ERwin.

Environment: Oracle 8i, Reports 2.5, SQL*Plus, PL/SQL, SQL*Loader, WindowsT