PROFILE SUMMARY

• Around 7 years of diverse Information Technology experience with expertise in creating and implementing effective solutions using SAP Business Objects.
• Technical hands-on expertise using OLAP tool Business Objects XIR3/ XIR2/6.5/ (Reports, Designer, Web Intelligence, Desktop Intelligence, and Info view)
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries
• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain Business Objects, Web Intelligence and Crystal reports.
• Very strong at resolving Join problems using Contexts and Aliases.
• Experiences in converting excel spreadsheets data into analysis reports for use with Xcelsius
• Extensively used graphs, charts, demographic images, indicators, cross tabs, parameters in reports
• Worked on various development platforms like Windows NT 4.0/ Windows 2000/2003 Server/ XP/98/95, UNIX and RDBMS like Oracle, SQL Server and MS Access
• Hands on experience in Develop, Review, Execute, and Maintain Test Plans, Test Cases.
• Extensively involved in using Quality Center and Team Track to report defects for smooth transition between development and testing team
• Expertise in creating reports with features like Master Detailed, Drill down, Slice and Dice, Ranking, Alerts, Filters, Sections, Graphs and Breaks
• Strong understanding of Data warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP and Multi-dimensional Models for query and analysis.
• Good Understanding on Java, JSP, Servlets, JDBC, J2EE, HTML and XML.
• Strong at Trouble Shooting and Resolving issues with Business Objects Enterprise Reports.
• Developed Universes using Designer -Universe Methodology involving the creation of underlying db structure, resolving loops, creating classes & objects, conditions and testing the integrity of the Universe.
• Provided end user training and support on basic and advanced reporting training
• An enthusiastic and project oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Strong verbal and written communication skills with the demonstrated ability to develop written applications that include requirements, functional specifications, testing, application deployment plans and user guides for the developed applications.

TECHNICAL SKILLS

Business Objects XI R3.1, XIR2/6.X/5.X, CMC, Designer, Desktop Intelligence, WebIntelligence,InfoView,DataSource Migration Wizard,XCelsius2008,Crystal Reports

RDBMS:

Oracle8i/9i/10g, DB2, SQL Server 7.0/2000/2005, MS Access,

Languages:

.NET SQL, PL/SQL, MySQL, WinSQL

GUI Tools :

Visual Basic, Oracle Forms and Reports, Oracle Toad, Developer.

Operating Systems:

Windows NT /2000/XP/Vista/7, MS DOS and UNIX

Educational Qualification
Bachelors in Computer Science

PROFESSIONAL SUMMARY

Confidential,Charlotte, NC Feb 11- Present
Sr.Business Objects Developer

Confidential,was a diversified financial services company based in Charlotte, NC. Wachovia provided a broad range of banking, asset management, wealth management and corporate and investment banking products and Financial services. Wachovia chose to deploy Business Objects as a reporting application solution. The Project FINANCE FOCUS is one of the major undertakings which involved all of its business units. The application concentrated on integrating financial data from all the business units associated with Wachovia into a Data Warehouse. The system was primarily developed to generate financial reports for all Wachovia locations and its business units from a single source, rather than generating reports from many different sources.

Responsibilities:

• Participated in requirement gathering, analysis and structuring of Business Intelligence reporting based on user requirements.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Creation of the universe with Classes, Objects and Condition Objects.
• Created objects and prepared reports like financial reports, HR Reports, standard and adhoc reports and universes
• Prepared month end reports for General Ledger, Net Investment, Interest, Fees and Incomes
• Handled Embedded Functions like @Prompt, @Select and @Where in the Designer to handle User requests for report generators.
• Created hierarchies from providing drill down options for the end-user
• Created Parameterized reports, Cross-Tab reports, Drill down, Drill Up reports and Summary reports.
• Created various geographical and time dimension reports of Fiscal Year, Calendar year, Quarter, Month, week and daily reports.
• Tested the aggregate awareness to ensure query is pulling correct level of aggregation
• Creating new Connections and editing existing to run the report in different database test, development.
• Implemented Cardinality settings, Joins, Conditions and Global Filters in Universe
• Worked on Aliases and Contexts to resolve looping problems and used Derived tables methods.
• Implemented Custom Hierarchies for drill analysis and Worked with Aggregate functions
• Used Different Prompts, Cascading prompts and Filters to minimize data cost and meeting exact results
• Used Breaks and Sections in Webi reports; and used different graphical charts and bars.
• Scheduled Webi reports on daily basis and exported them in Excel/PDF format.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create reports
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert.
• Implemented SQL/PLSQL programs/Stored procedures/Views to test ad hoc reports
• Created custom LOV’s and Hierarchies for easy user selection drill down purposes.
• Creating the various ad-hoc reports for different business group users.
• Worked with Off-shore team on Business Objects Universe development.
• Trained Business owners in using BO XI R3
• Scheduled the reports based on business requirements.
• Performed unit testing and User Acceptance Testing (UAT) for universe and reports
• Interacted with the users to analyze the changes for improvement they needed in existing reports, and developed the reports to satisfy their needs and requirements

Environment: Business Objects XI R3, Universe Designer, Desktop Intelligence, Web Intelligence, CMC, Info view, Crystal Reports 2008, Oracle 11g, Windows XP.

Confidential,San Antonio, TX Dec 09 - Jan 11
Business Objects Analyst

Confidential,is a unit which provides reports to executives and business customers of AT&T. AT&T Wi-Fi service connects your laptop or other Wi-Fi enabled device (like iPhone), to an AT&T Hot Spot, enabling public wireless high-speed Internet access at speeds much faster than dial-up when you\'re within a 150-foot range of the public hot spot. Performance of hotspots in various locations had to be analyzed through reports using SAP BOBJ, Crystal reports and XCelsius.

Responsibilities:

• Requirements Gathering and Analysis for reporting efforts. Analyzed the requirements with Business users to come up with technical and functional specifications.
• Created Universes for various functional areas of high level reports group
• Created and modified existing universes by adding new classes, objects, prompts, hierarchies based on the business requirements
• Worked with multiple data providers including Personal Data files (MS WORD), Stored Procedures, and free hand SQL to create complex reports
• Created reports according to different cell phone plans like individual plan, family plan, family time plan
• Created Interactive dashboards and graphs using Xcelsius 2008. Personalized dashboards to reflect user specific alerts and metrics to track Key Performance Indicator (KPI)
• Utilized Crystal reports to develop and modify reports.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Developed complex reports and graphs in Crystal Reports using multiple sub reports and drilldown features and using conditional suppression formulas.
• Created Reports using Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the end user requests from Tables, Store Procedures, Views and Command Objects.
• Created Contexts and Aliases to resolve chasm and fan traps in the Universes
• Customized LOV’s in Universes for quicker performance of reports
• Created Joins, Contexts and Aliases for resolving loops and checked the Integrity of the Universe
• Used SQL against database to check data retrieved
• Created the joins strategies while designing the Universes
• Changed the universe parameter settings to optimize the performance of the universe
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Custom Sorts, Cross Tab, Master Detail, Formulae etc.
• Created hyperlink between Master/Details reports in webi.
• Used Aggregate Awareness feature of Business Objects for Optimization and Performance tuning of the Universe.
• Used Breaks and Sections in Webi reports; and used different graphical charts and bars
• Created universes which contain information about the customer like cust_name, address, phone no, plan_used, mins_used, mins_remaining, and rollover mins.
• Gathered information like attempted calls, type of call(long distance, local) originated number, destination number, rates, time of call, for creating report for billing a customer
• Worked on Business Objects Administration like user creations in CMC and handled security issues
• Created various analytical reports like Market Share, Trending, Rank, reports from multiple data providers
• Exported reports in various formats such as PDF, HTML, EXCEL AND WORD for users
• Involved in creation of Alerts with various report conditions
• Provided end user support and problem resolution for various issues related to BO
• Tested the created Universe and Reports before migrating to production.

Environment: Business Objects XI 3.1(Web Intelligence/Desktop Intelligence/webi Rich client), Designer, Import Wizard, Performance Management, Xcelsius 2008, Pl/Sql ,SQL Server, Windows XP.

Confidential,Warren, NJ Mar 09 - Nov 09
Business Objects Developer

Confidential,is one of the largest financial companies in America, which offer a variety of financial products and services. CCS Customer Contact Strategy is a system that prioritizes sales offers and other opportunities for card members. Citi Card Member Services and Marketing Services work to offer and capture the results of solicitations mainly use this. The projects aim is to get the customer information from the data sources, which were in different formats for analysis purpose.

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to technical specifications for designing Universes and reports accordingly
• Developed Business Objects universe based Design documents
• Designed, developed and maintained the Universes and reports with advanced formulas, joins and techniques
• Created Universe with Classes, Objects and Condition objects using Designer.
• Developed and created classes with Dimension, Detail and Measure Objects and specified the hierarchies.
• Resolved universe issues like loops by creating aliases and contexts, traps, joins hierarchy, lov’s and parameter issues
• Scheduled the reports to run daily, weekly and monthly and distributed the reports to users via email
• Developed reports with complex Calculations, Variables, Breaks, Sorting, Drill Down, Slice and Dice and Alerts.
• Resolved Join problems, Fan Traps and Chasm Traps using Aliases and Contexts
• 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 user.
• Used different formatting techniques like color highlighting, graphs and maps for intuitive reporting
• Exported the Business Objects reports to BO repository to be to be viewed by all users on the intranet using Web Intelligence.
• Worked on creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes to increase the performance of the universe.
• Used Breaks and Sections in Webi reports and used different graphical charts and bars
• Support and train the users on the reporting tools and the business logics.
• Worked and coordinated with Off-shore team in design and development.
• Periodical Scheduling for Reports to run automatically. Implementation and periodic maintenance.
• Performance tuning of BO reports and universe and maintaining the universes and reports.
• Trained the Business Users in BO XI R3
• Exported the Universe to the Repository using designer for users to develop their own personal reports.
• Support the development and production environment.
• Business Views were used in creation of new reports.
• Tested the Universe created and reports.

Environment: Business Objects XIR2/XIR3, Performance Management, Business Objects Designer, Web Intelligence, Desktop Intelligence, PL/Sql, Windows NT, Windows 2000 Server.

Confidential,Santa Clara, CA Oct 07-Feb 09
Business Objects Developer

Confidential,is the largest American drug retailing chain in the United States. Walgreens provides access to consumer goods and services, plus pharmacy, health and wellness services, in America through its retail drugstores, Walgreens Health Services Division and Walgreens Health and Wealth Division. Walgreens Pharmacy had chosen to deploy Business Objects as a reporting application solution for its sales, marketing and drug information departments.

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications about the system for Business Objects Universe and Reports
• Creating, developing, maintaining and testing the Universe for running the queries against the databases
• Analyzed the existing database and designed Universes using Designer module for generating reports
• Used various data sources like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance
• Resolved loops by creating Aliases and Contexts and checked integrity of the Universe
• Exported universes to the repositories making resources available to the users
• Created reports using the Universes and Free-hand SQL as data providers
• Worked on Query panel, Prompts, Report Layout and Re-formatting
• Created charts to display summary data using Universe as the main data provider
• Created reports showing the sales of various drugs in a particular Year, Quarter and Month using Business Objects and reports based on DDD (Drug Distribution Rx Data)
• Created reports to monitor the 21CFR PART 11 compliance information of various Drug’s provided to the physicians
• Key person to create reports/manipulating data through various presentation styles such as charts, cross tabs, standard tables and synchronization reports using both Desktop Intelligence and Web Intelligence tools
• Generated analytical reports using Slice and Dice, Drill down, Cross Tab, Master Detail and Formulae features
• Used Designer as a part of the Universe Development for Defining the parameters of the Universe, Inserting the table, making Join’s, resolving loops, Creating Classes and Objects
• Automated Document Scheduling
• Involved in creation of Filters, @Prompts, and set up Hierarchies for Multidimensional analysis
• Applied Sections, Breaks, Calculations, Report Filters and Query Filters and displayed information in different blocks
• Monitored and solved the issues encountered in the Universes and reports while migration and tested before moving to production.

Environment: Business Objects 6.5,XI R2,Universe Designer, Designer, Supervisor, Web Intelligence XI R2, Broadcast Agent Server, Full Client, Oracle 9i, PL/SQL,T SQL and Windows NT/XP.

Confidential,Mumbai, India Feb 05- Aug 07
Jr.Business Objects Analyst

Confidential,is the largest bank in India, having wide network of over 16000 Branches. Through its large network of authorized branches, the bank facilitates foreign exchange needs of its clientele engaged in export and import trade and the SITB provides rates for conversion of all major world currencies like U S Dollar, Sterling Pounds, Euro, Swiss Francs, Japanese Yen and other exotic currencies. The services to the customers of the Bank include hedging of foreign currency risks by providing forward covers and various derivatives product.

Responsibilities:

• Assisted in establishing a Business Objects environment.
• Responsible for fitting Business Objects into the Information Architecture of the company as well as supporting

Business users and developing existing reports.

• Generated several periodical reports like daily, fortnightly, monthly and yearly etc.
• Designed and developed extensive Business Objects reports, including complex reports using multiple queries, complex conditions on queries, combined queries.
• Designed reports that contain data from different data providers.
• Created several user objects according to the user requirements.
• Scheduled the documents using Broadcast Agent.
• Interacted with end users and business analysts to identify and develop business requirement and transform it into technical requirements and ultimately responsible for delivering the solution.
• Designed the Universes incorporating all the Business requirements.
• Created Aliases, Multiple contexts for catering different functional areas in a single user query and solved the loops problems.
• Created reports with Selection Criteria, Grouping, Sub reports, Cross tabs, Standard and Summary.
• Documented report parameters, fields, and logic used for developing of reports and universe in a word document.
• Generated Desktop Intelligence and Web Intelligence reports using open document methodology.
• Provided technical assistance/support to analysts, business community and respond to inquiries regarding errors, problems, or questions with programs/interfaces.

Environment: Business Objects XI 6.x, Universe Designer, Broadcast Agent ,Desktop Intelligence and Infoview ,MS SQL Server 2000, Oracle 8i/9i, Windows Server 2000,Windows NT , MS Access.