Professional Summary:

• Over 8 Years of experience in Analysis, Design and Development of software applications and Business Intelligence projects under different environments.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
• Technical hands-on expertise in using Business Objects 4/5.x/6.x/XI r1/r2/r3 (Supervisor, Designer, Reporter, CMC, CMS, CCM, Web Intelligence, Desktop Intelligence).
• Installed Business Objects XI r1/r2 using Tomcat and Apache as Application and Web Servers.
• Extensive experience in designing Business Objects universes and reports. Created reports using functionalities like queries, slice and dice, drill down, functions, filters & formulae.
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
• Excellent understanding of Star Schema modeling, Snowflake modeling. Fact, Lookup and Dimensions Tables.
• Experience working with Oracle 8i/9i database, including analysis, design, coding, testing and maintenance of the database. Experience in data conversion activities.
• Expertise in writing SQL queries, PL/SQL scripting, Triggers, Procedures & functions on the Windows platform.
• Proficient in Visual Basic 6.0, SQL Server, HTML and C++.
• Worked on various development platforms Windows NT 4.0/2000/98/95
• Managed and delivered large and complex assignments within time/cost and service level parameters.
• Strong technical, communication, time management and interpersonal skills.
• Confident, independent, leadership skills, good decision-making abilities.

Professional Experience:

Business Objects Consultant

Confidential,is a financial services company with over $22 billion in assets provides consumer and commercial banking services with approximately 300 branches in Connecticut, Vermont, New Hampshire, Massachusetts, Maine and New York. At People’s we developed reports from 2 different data source systems (BIC and FIS). This BI implementation helped the regional operations unit located throughout the US to monitor their transactions and their performance. I was involved in requirement gathering, writing requirement specifications and designing the reports (Analyst and Developer).

Responsibilities:

• Gathered information from the user to design Web intelligent reports.
• Referred to the existing crystal reports and designed new reports.
• Modified the existing reports based on the changes done by user requirements.
• Documented the reports and SCR’s if changes are made in common share point.
• Captured all the data provider, variables and universe level information pertaining to the PC reports and documented the same.
• Created user variables and functions on the report side.
• Used multiple universes and linked them by merging the objects.
• Improved the performance of the reports by using filters and reducing the functions.
• Documented the web intelligence XIR2 reports for any further modification purpose.
• Closely working with ETL team to get the data in the required format.
• Did Data Cleansing on the report such as standardizing addresses.
• Used filters, breaks, sections, drill downs, sorts and calculations.
• Used merge and extended merge concepts.
• Used prompts for the users to generate specific reports.
• Formatted the reports, for the convenience of the users.
• Used basic universe and used a lot of functions in reporting side.
• Reports are stored in BO folder or as PDF or Spread Sheet.
• Identified issues with some of the reports with ambiguous data and resolved the issues.
• Scheduled Reports using scheduler based on the frequency of the reports.
• Performed data validation by writing SQL queries and creating ad hoc reports using Web intelligence.

Environment: Business Objects XI R2, Business Objects Enterprise XI R2, BO Designer, Infoview, Oracle 10G, Sybase, Windows XP/2003.

Confidential,VA Sep 2008 to Sep 2009

Business Objects Consultant

Confidential, is the wireless CDMA Carrier in the United States, with more than40 million subscribers who use the nation\'s largest digital voice network. The company\'s data come from different operational sources and is stored in a data mart and then data is transformed and loaded into a centralized data warehouse for various Strategic Business Reports. I was involved in requirements gathering from the business users and building the Reporting Applications.
These Reports give the marketing representatives and agent’s information about the product offering and revenue generated from different product lines.

Responsibilities:

• Created slides for data flow and process flows using PowerPoint and Microsoft Visio for better understanding of the business.
• Created Web Intelligence XIR3 reports, graphs and charts facilitating drill down.
• Involved in requirements gathering from the business users to build various strategic Business Reports.
• Created Categories and published Business Objects reports.
• Maintained and modified the existing reports depending on the user requirements.
• Captured all the data provider, variables and universe level information pertaining to the PC reports and documented the same.
• Resolved the loops using Contexts and Aliases.
• Pointed some of the reports to the new universe, tested and deployed them into production.
• Improved the performance of the reports by identifying the issues and recommending aggregate tables and creating indexes.
• Documented the web intelligence XIR3 reports from Management Reports folder.
• Involved in data maintenance process using Oracle9i, PL/SQL procedures, functions, triggers on Windows NT platform.
• Got the data from multiple data sources like Oracle 9i,Essbase cubes.
• Identified issues with some of the reports with ambiguous data and resolved the issues.
• Scheduled Reports using Scheduler.
• Created Visualizations using Crystal Xcelcius.
• Created multiple Dashboards using Crystal Xcelcius with consolidated data for better analysis.
• Hands on experience using Dashboard manager and Performance Manager.
• Created Hierarchies to facilitate drill down.
• Well versed with creating Derived tables in Universe.
• Performed data validation by writing SQL queries and creating ad hoc reports using Desktop intelligence and Web intelligence.

Environment: Business Objects 3.1, Designer, Webi rich client, Deski, Xcelcius 2008, live office, Oracle 9i, Windows 2003.

Confidential, Houston TX Jan 07 – July 08

Business Objects Analyst
Worked as a Business Objects Analyst cum Developer in Bank of America Project. Analyzed the existing reports and Developed new Reports as per the user requirements.

Responsibilities

• Analyzed the MsAccess reports in the old system. Created new Reports for their system and it requires both understanding of the business concept and in-depth skills of the Business Objects, Data warehousing concepts, Datamodelling techniques, Star schema and SQL language to implement the Universes and reports.
• Analyzed the data models and did minor changes as per the requirement using Erwin.
• Used techniques like @Aggregate Aware objects, Aggregate Navigation, Contexts, and Aliases.
• Created and modified the existing Targeted Query Universe as per the user requirements.
• Created new queries using Oracle 10G and Teradata as backend, pulling data from the DSS Data warehouse and compared with the existing MsAccess reports.
• Created the reports using universes as main data providers and using the Powerful business objects functionality\'s like @functions, Variables, user response and formulae.
• Created Derived Tables at the universe level and created reports using this as the data provider.
• Created reports using Crystal Reports XI R2.
• Created reports in crystal reports using universe as the data source.
• Created sub reports in crystal reports.
• Created reports like summary reports, cross tab reports, charts in crystal reports XI R2.
• Used the functionalities like Alerts, Parameters, Running Totals, and Formulas in crystal reports.
• Created the Groups and users in XI R2 using CMC.
• Converted the existing Desktop Intelligence Reports to WEBI reports using the Conversion Tool.
• Created a few static Xcelsius reports on top of Excel.
• Documented the system objects and screenshots of the reports in Project Work Book.
• Involved in Unit Testing and resolving the defects.
• Worked on Test Cases and documented the results in Test results template.
• Created SQL scripts to test the report results with the database results.
• Involved in user requirement gathering meetings and resolved the report issues by interacting with the end users.

Environment: Business Objects Designer XI R2, Desktop Intelligence, Web Intelligence XI R2, Business Objects 6.1,Central Management Console (CMC), Crystal Reports XI R2,Crystal Xcelcius 2008 Oracle 10G, Teradata, Erwin Allfusion Data Modeler 4.1, Windows XP Professional, Microsoft Office 2003,SQL Developer1.0, Sun Solaris UNIX.

Confidential,NE June 2005 to Oct 2006

Business Objects Consultant

Confidential,) provides transportation and storage services to approximately 75 utilities and numerous end-use customers in the upper Midwest. NNG also operates three natural gas storage facilities and two LNG peaking units. These storage facilities are fully contracted and are central to meeting the customers\' peak-day system requirements. The project was to audit their current deployment and performance and to create complex reports involving charts based on custom database queries.

Responsibilities:

• Involved in analysis, design, implementation, testing, and deployment phases of the software development projects.
• Used Business Objects report level functions like Alerts, Breaks, Customized filters to display relevant data.
• Created reports in Business Objects and Web Intelligence to query, report and analyze data; and schedule, publish and distribute them using Broadcast Agent
• Created BO reports containing multiple data providers and complex charts to present the end users with a better graphical representation of the data.
• Maintained the Data Warehouse for producing accurate results and take care of performance issues arising due to any inefficiency in the backend database or OLAP methodology.
• Created and managed users and user groups.
• Used BO Designer to create universes containing complex dimensions, measures, conditions and prompt objects to be used in BO.
• Created classes, objects, hierarchies, complex objects, prompts, pre defined conditions as a part of the universe creation.
• Exported the universes to the Repository making resources available to the users.
• Worked closely with the architect, DBA and business users to deliver reports on time

Environment: Netezza 3.1.2, Sybase 12.0, Business Objects Enterprise 6.5/ XI R2, BO Designer, Crystal Reports, Windows XP/2003, MS SQL DTS, Infoview, Web Intelligence.

Confidential,MI Sep 2004 to May 2005

Business Objects/Data modeling
Confidential, provides various kinds of services like interactive marketing, direct marketing, database marketing, program support materials, event management, and customer service center. Ford Motors is one of the major vendors for the company. I was responsible for installation, upgrades, analysis and development of reports.

Responsibilities:

• Interacted with Business Users, Business Owners to collect identify the classes and objects.
• Customized the existing Business Objects universe.
• Designed the Data Model using Erwin and integrating E - R models with the Oracle Database.
• Successfully installed, upgraded the Business Objects version 5.1.6 to enterprise 6.0 and configured them for better performance.
• Followed Star Schema and snowflake Schema for methodology to organize the data into database by using ERWIN tool.
• Developed various Reports for financial and marketing departments for better analysis using Business Objects.
• Used the Broad Cast Agent server for Scheduling and monitoring the Reports.
• Generated Master/ Detail reports based on user specification(s).
• Generated reports using Web Intelligence (thin client) and full client.
• Maintained security for the end users by giving privileges with supervisor module.
• Linked Universes to work with common objects.
• Worked on the Master Kernel and Component approach during the linking universes.
• Involved in creating packages, procedures, Functions & Triggers and also embedding dynamic
• SQL features advanced packages in PL/SQL, which generated the Flat Files.
• Designed and developed universes in Business Objects felicitated the end-users creating custom
• LOV, Prompts conditions, Dimensions, measures and details.

Environment: Business Objects 5.1/6.x, 5.1.6, 1b (Designer, Supervisor, Business Objects), Web
Intelligence (Webi) 2.3, Oracle 8i, DB2, SQL*Loader, PL/SQL, Windows NT, UNIX, Erwin 4.0