Summary:

• 7 years of hands-on experience in providing solutions for Business Applications including Designing, Developing, Testing and Implementation.
• 6 Years of experience in creating Business Objects Reports using XIR3.1, XIR2, 6.5 and 5.1.
• 2 Years of experience in creating Crystal Reports using 9, 10, XI.
• 1 Year of experience in creating Xcelsius Dashboards using using 4.5, 2008.
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica Power Mart, Power Center and data Integrator.
• Worked with Oracle 11g/10g/9i, SQL Server 2005/2008, PL/SQL, Explain Plan, and Relational databases (database triggers, stored procedures, functions, and databases).
• Knowledge in Planning, Designing, Developing and Deploying Data warehouses/Data Marts with experience of both relational & multidimensional database design using Data Modeling tool Erwin (Physical and Logical data models).
• Involved in training end users, business users and customers on how to create modify and interpret BO reports and Web I reports.
• Excellent analytical and problem Solving skills. Quick learning capacity and positive attitude towards new challenges.

Technical Skills:

BI Tools:

Business Objects XIR3.1/XIR2/6.5/5.1, Crystal Reports 9i/10g/11g, Xcelsius 4.5, 2008.

RDBMS:

Oracle 9i/10g/11g, MS SQL Server 7.0/2000/2005 and MS Access 2000.

DB Tools:

SQL* Plus, TOAD

ETL Tools:

Informatica Power Center 7.x

Data Modeling Tools:

ERWIN 4.0, UML 2.0, MS Visio.

Languages:

SQL, PL/SQL, VB6, HTML, JavaScript, XML

Operating Systems:

Windows XP/2000, Unix.

Professional Experience:

Sr. Business Objects Developer Feb 09 – Till Date
Confidential, SFO, CA 

Responsibilities:

• Installed and Configured BO XI R2 and applied Service Packs and Hot-fixes.
• Migrated Universes, Connections, Desk I / Web I Reports from the existing version XIR2 to XI 3.1 using Import Wizard.
• Involved in the Designing and Building of Universes from different data sources like Oracle/SQL Server.
• Created standard Desk I / Web I reports, involved in Ad-hoc and Canned Reports for analysis.
• Monitored Daily reports and maintained all relevant Universes.
• Generated reports using free-hand SQL as a data provider.
• Created hierarchies to provide Multi-Dimensional Analysis (Drilldown Analysis) to the Users.
• Extensively used Calculations Contexts, Variables, Filters, Conditions, Breaks, Sorting, Master/Detail, Cross Tab, Charts and Alerts for creating Business Objects Reports.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Created complex condition objects for easy reporting, Aggregate-Aware objects for better performance.
• Applying Row level, Object level security in the universe to make the sensitive data secure.
• Exported the Business Objects reports to the repository so that the end users can view the reports through Web I.
• Converted Desktop intelligence report (.rep) to Web Intelligence (.wid) using Report Conversion Tool.
• Involved in the resolution of issues encountered during the Report Conversion from Desk I to Web I.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports
• Involved in Writing Detailed Level Documentation for reports.
• Good knowledge on ETL for data extraction from disparate sources, Data Transformations and Loading into the target database using Informatica. Well versed in Development of Transformations/Mappings using Designer/Workflow Manager and monitoring the sessions/worklets using workflow monitor.

Environment: BOBJ XI 3.1 (CMC, Designer, Desktop Intelligence, Web Intelligence Rich Client, Info View, Voyager), Informatica 8.6.1, OBIEE, Oracle 10g.

Sr. Business Objects / Crystal Reports Developer Mar 08 – Jan 09 
Confidential, Dallas, TX

Responsibilities:

• Involved in Migrating Business Objects system from version XI R2 to Business Objects XI 3.0
• Developed Universes for multiple Databases as per the design model and applied various securities for restricting the data.
• Detected Cardinalities and Loops. Resolved the loops by creating Aliases and Contexts and checked the Integrity of the Universes.
• Involved in creating web-based reports using Business Objects Web Intelligence Rich Client and Crystal reports.
• Formatting the Reports based on the Users requirements using the functionalities in Business objects like Slice and Dice, Drill Down, Alerters, User response, @Functions.
• Used Dynamic Cascading Prompts to narrow the search criteria for the end users.
• Extensively used Web Intelligence through Info View interface to generate reports
• Optimized and Tuned Reports performance by Analyzing tables, Checking Optimizer Modes and Partitioned tables.
• Created hyperlinks in BO reports to link summary and detail reports using open document syntax
• Used SQL commands to generate business objects reports using free hand SQL as a data provider
• Involved in QA phase to test the Classes, Objects and Connections in Business Objects
• Applied row level and object level securities to different groups and users.
• Created Web I reports with more than 10 data providers and synchronized the data using the merge dimensions option.
• Created MS Access report from Sql Server 2005
• Involved in Writing Detailed Level Documentation for reports and Universe design.

Environment: BOBJ XI 3.1/ XIR2 (CMC, Designer, Desktop Intelligence, Web Intelligence Rich Client, Info View, Voyager), Crystal Reports XI, OBIEE, Windows NT, Oracle 10g.

Sr. Business Objects /Crystal Reports Developer Mar 07 -Feb 08
Confidential, Boston, MA

Responsibilities:

• Installed and configured Business Objects Enterprise XI R2 Suite
• Managed the Servers using the Central Configuration Manager (CCM).
• Created Users/Groups, assigned privileges using Central Management Console (CMC).
• Analyzed the existing database and created/modified the Universes using Business objects Designer Module.
• Used the functionality of linking universes so as to have the flexibility to use the objects defined in one universe in another.
• Used Import wizard to import existing User accounts, Groups, Categories, Universes, Reports (Full Client and Web I), Connections and Universe restrictions to BO XI R2 environment.
• Created complex reports in Web Intelligence and Desktop Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Created Web I reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R2.
• Created Crystal reports using Business Views and Universes as data providers.
• Exported the universes to the Repository to make the resources available to the users.
• Converted the reports into different formats like Excel, PDF and HTML

Environment: Business Objects XIR2 (CMC, CMS, CCM, Designer, Desktop Intelligence, Web Intelligence, Info View, Import Wizard, Voyager), Crystal 10, Oracle 9i, SQL Server 2000, SQL, Windows 2003 Server.

Sr. Business Objects Developer Mar 06 – Feb 07
Confidential, Dearborn, MI

Responsibilities:

• Installed and configured all components for Business Objects Enterprise Edition Version E 6.5.1.
• Created repository, distributed the BO Main key, and created multiple document and universe domains for development and production environment.
• Created users, user groups, assigned privileges, restricted access, provided row and object level security for all the products of Business objects.
• Involved in linking of multiple universes to generate documents.
• Developed both full client(Desk I) and thin client(Web I) reports based on the business requirements
• Brought data from a personal data file into BO and combine it with data from a BO Universe query.
• Involved in writing Free Hand SQL for creating complex Reports.
• Worked on Dashboard Manager and created analytics for Executive reports.
• Trouble shooting and tuning of the reports to reduce the performance time of the reports.
• Used Broadcast Agent Publisher, which enabled us to distribute information via email using an easy-to-use, subscription-based mechanism.

Environment: Business Objects 6.5 (Supervisor, Designer, Business Objects, BCA), Xcelsius 4.5, Oracle, SQL Server 2000, MS Office, Windows 2000 Server.

Business Objects Developer Feb05 – Feb 06
Confidential, Louisville, KY

Responsibilities:

• Installed and configured BO on Windows NT server.
• Worked with Universes and Free Hand SQL as the main data providers.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
• Used the Drill Down/up function to analyze data and created multiple charts in Reports.
• Created Report Templates for consistency in the look and feel of the reports
• Created reports using Web Intelligence and published reports using Broadcast Agent Publisher.
• Creating Complex reports like Inventory, Buyers, Excess Materials, Products sales, revenues, regions wise on Demand and exported them to the corporate repository.
• Involved in data extraction and developed mapping using Informatica Power Center.

Environment: Business Objects 6.1(Supervisor, Designer, Business Objects), Info View, Broadcast Agent, Informatica Power Center 5.1, SQL Server 2000, SQL, PL/SQL, Toad, MS Live Office, Windows NT.

Business Objects Developer / Analyst Jan 04 – Jan 05 
Confidential, Moline, IL

Responsibilities:

• Analyzed the existing database and designed the Universes using the Business Objects Designer Module.
• Created Classes, Objects and Conditions. Tested the Universe by writing various queries and checking the results.
• Created several graphical reports using pie charts, bar graphs and line graphs.
• Used multiple Data Providers, complex formulae, functions, Drill, Slice and Dice, Filters and Hierarchies.
• Inserted special fields containing document information like Last Refresh Date, Last Print Date, Current Date, Page Number, Query Prompt etc.
• Maintained BO repository using Business Objects Supervisor by enable/disable command restrictions, reset passwords and for creating different Categories.
• Used Broadcast Agent to schedule the reports depending on the user profile.

Environment: Business Objects 5.1.4 (Supervisor, Designer, Business Objects), Info View, BCA, Oracle 8i, SQL Server 7/2000, UNIX, Windows 2000 Server.

Database Analyst Jun 03 – Dec 03
Confidential

Responsibilities:

• As an Oracle implementation team member, worked on writing custom forms and custom tuning the reports.
• Interacted with the end user to prepare system requirements.
• Worked as a technical support for a team that involved technical & quality reviews of program codes and PL/SQL blocks for optimization and maintaining standards & guidelines.
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Developed Custom forms to view edit the data in custom interface tables and event handling tables using template forms.
• Completed database architecture including developing stored procedures and functions in order to create shortcuts to frequently repeated tasks.
• Promoted the new code to production through unit and system testing.
• Supported technical teams involved with Oracle issues and operations.

Environment: Oracle 8i, Developer 2000, Forms 4.5, Reports 2.5, SQL, PL/SQL, Windows NT Client/Server.

Education: