SUMMARY

• 7+ Years of experience in Business Intelligence (BI) and Data Warehousing (DW) implementations.
• Extensive experience in BusinessObjects 5x/6x/XI/XIR1/XIR2/XIR3/XIR3.1/XIR4.0 Administration, Universe Design, Report development (Desk I/Web I, Rich Client), Import Wizard, Publishing Wizard, Performance Manager, Dashboard Manager, Broadcast Agent, and Data Integrator
• Proficient in Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2, Crystal Decisions and Crystal Xcelsius 4.5/3.5/3.0.
• Very Strong Knowledge of all phases of Software Development Life Cycle (SDLC) such as Installation, Developing, Testing, Migrating, Maintenance, and Troubleshooting.
• Expert in Administration, Building and Managing Repositories, security management and production support on various platforms like UNIX, Windows NT/2000/XP/98.
• Strong understanding of Data warehousing concepts such as Star Schema, Snowflake Schemas and Multi - Models.
• Proven abilities in creating highly complex reports by linking data from multiple data providers, Free hand SQL, Stored Procedures, Personal Data Files, and XML Data Providers.
• Experienced with creation and maintenance of OLAP universes based on SAP BW data sources.
• Extensive experience in Developing and Testing the PL/SQL (Procedures, Cursors and functions, Triggers) scripts while developing the reports.
• Involved in training users and external vendors on creating complex reporting.
• Expertise in SQL, PL/SQL, My SQL, Stored Procedures, Functions, Cursors, Packages, Views, Indexes.
• An excellent team member with good interpersonal relations, strong communication skills and ability to quickly adapt to different project environments.
• Work well in teams and accomplish difficult tasks independently within time frame.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP/2000 Server, UNIX, Sun Solaris.

BI/DW Tools: Business Objects R4/XIR3.1/XIR3/XIR2/XIR1/XI/6X/5X (Supervisor, Designer, Reporter), Performance Manager, Dashboard Manager Web Intelligence 2.x/6.x/XIR2, Info View, Broadcast Agent, Application Foundation, BO XIR2 (CMC, CMS, CCM, Designer, Desktop Intelligence, Web I), Data Federator, ACTUATE, Data Integrator, Crystal Xcelsius.

Reporting Tools: Business Objects, Crystal Decisions, Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2, (Business View Manager), Excel 2000/XP, Qlikview, Actuate.

Project Management Tools: Software Design Life Cycle (SDLC), Agile, SCRUM, Joint Application Development (JAD)

Data-modeling Tools: Erwin 3.5/4.0.

Languages: Shell Scripting, C++, SQL, PL/SQL, C/C++, VBA, JAVA/J2EE, XML, UML

SQL Utilities: TOAD, SQL* PLUS.

ETL Tools: Informatica Power Center/Power Mart 7.1/6.2/5.1

Web Technologies: HTML, DHTML, Java Script, MS front Page, Adobe Dreamweaver CS3.

Animation Tools: Macromedia Flash CS3 Professional, 3D Max, Autodesk VIZ, Maya.

Imaging Technology: Adobe Photoshop (CS3 & Elements 6.0), Photo Pos Pro, and Picasa.

RDBMS: ORACLE 8i/9i/10g, MS SQL Server 2000/2005, MS Access, Sybase12.0.

Scripting: Perl, UNIX, and Java Script.

PROFESSIONAL EXPERIENCE

Confidential - Middletown, NJ

Sr. Business Objects Admin

Responsibilities:

• Hosted Weekly & Monthly status meetings to discuss the day to day progress keeping in mind deadlines.
• Headed the team of Business Objects Report Developers, developed the reports as well as got them done by team on time for the releases.
• Responsible with 24/7 on call support for Incident Management, Change Management and Production Management tickets.
• Responsible for designing 12 complex Universesfor 5 different programs such as Auditing, Marketing, Finance, Investments and Insurance.
• Trained and Developed documentation for administrators and developers to follow steps to add, modify, delete or change rights for different users of different departments.
• Trained Internal Program Managers, External Vendors and Developers on Best Practices.
• Implemented row level, object level and report level Security Features to make the data secure.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.
• Install, Maintain and Trouble shoot the Business Objects Enterprise Servers
• Design and Recommend changes to Datawarehouse schema’s like Star and Snow Flake designs.
• Develop the Stored procedures and Views to be able to customize the report according to specifications.
• Responsible for synchronizing Reports, Folders, User Security on Dev, UAT and Pre Prod environments with Production Environment
• Responsible to work with Business Program Managers and Power Users to finalize any reports requirements.
• Designed, Developed and Implemented 75 plus reports for 3 departments on Production
• Interacted with the Multiple Program Managers to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Worked with Performance Manager to go beyond basic Dash boarding to provide advanced goal management and score carding capabilities, as well as guided analysis of metrics.
• Implemented 20 plus new internal security groups and folder structure to handle security for 5 different programs
• Converted 200 plus Deski reports to Webi using Report Converstion Tool and fixed all the migrations issues.

Environment: Business Objects Enterprise XIR3.1 (CMC, CCM, CMS, Designer, Desk I, Web I), XIR4.0, Qlikview,Oracle10g, Xcelsius 2008, Microsoft SQL Server 2000/2005/2008, Netezza, SAP BW (OLAP/MOLAP), Apache Tomcat and TOAD and Windows 2000 Server.

Confidential - OWINGS MILLS, MD

Sr. Business Objects Administrator

Responsibilities:

• Hosted Weekly & Monthly Project planning sessions with Project Managers, Business Analysts and team
• Members to analyze business requirements and outline the proposed solution.
• Worked on Installation and Configuration of Business Objects XIR2 Enterprise Suite in the development environment.
• Involved in migration from existing 6.5/ 6.5.1 systems to BO XIR2 in Development Environment.
• Migrated Users/Groups, documents (Web I and Desk I), Universe, Document, and folders and objects using Import Wizard.
• Added/deleted, enabled/disabled various BO servers using Central Configuration Manager.
• Created users/ groups and defined their roles and set privileges using the CMC.
• Used the schedule manager to schedule reports in the Web I module of XIR2.
• Interacted with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Reports.
• Installed & Configured Business Objects Enterprise XIR2 on Windows 2000 server and created Repository.
• Worked in the development team on the new change requests, fixing defects in Business Objects reports and enhancements from the business.
• Created new reports using both Desk I and Web I in Business Objects XIR2 and validated the reports.
• Converted .rep reports to .wid reports using the report conversion tool.
• Involved in building, Testing and Tuning Simple and Complex Full Client and Thin Client Reports.
• Worked with Complex filters, alerters and user defined objects (UDO).
• Created reports in Web I from multiple data providers and synchronized the data using the merge dimensions feature.
• Worked as a team in developing business objects Crystal XCelsius Dashboards.
• Exported business object reports to Web Intelligence 6.5.1 to be viewed by all users on the Internet.
• Worked on Microsoft and Business Objects Interoperability using SharePoint and Business Objects XI Portal Integration Kit thus helping to View and Manage Information within a Single Interface.
• Also used different data sources like free-hand sql, personal data files creation of various reports.

Environment: Business Objects XIR2 (CMC, CMS, Designer, DESKI), 6.1/6.5.1 (Supervisor, Designer, Reporter), Web Intelligence, Desktop Intelligence, Info View, Toad 9.0, Import Wizard, Conversion Tool, 3-Tier BO, Broad Cast Agent (BCA), Crystal Reports 2008, Xcelsius 4/5, Oracle 9.1,qlikview Teradata V2R6.0, SAP BW (OLAP/MOLAP), Microsoft SQL Server 2000/2005, Windows 2000/XP Server

Confidential - NYC, NY

Business Objects Designer

Responsibilities:

• Involved in production Support and giving training to the users.
• Involved in migration from Business Objects 5.1 to Business Objects 6.5
• Involved in creating repository and setting up of groups and users for BO users.
• Exporting the Reports to the Broadcast Agent and Used the Broadcast Agent to Schedule, Monitor and Refresh the Reports.
• Upgraded Business Objects universes and reports from version 5.1 to version 6.5.
• Constantly worked with Business Users to gather, analyze and record requirements / specifications.
• Resolved loops, chasm traps and fan traps using contexts, aliases and integrity checks.
• Used various join methods like Equi-join, Theta-join, Outer-join in designing the universes.
• Created Master Detail and Cross Tab reports.
• Worked on the Master, Kernel and Component approach during the linking of universes.
• Scheduling reports from the Broadcast Agent Server to only requested users.
• Created Web Intelligence documents and published them to corporate documents.
• Trained the end users in working with the Business Objects user module provided technical expertise.

Environment: Business Objects 5.1/6.5, Oracle 9i, MS Access, SQL, Toad, WEBI 6.5.1, Broadcast Agent, Business Objects 5.1.4 (Supervisor, Designer, Reporter), Web Intelligence 2.x (ZABO, Broad Cast Agent), Broadcast Agent, Oracle 9i, PL/SQL, SQL Windows NT.

Confidential - SFO, CA

Sr. Business Objects /Crystal Reports Developer

Responsibilities:

• Scheduled crystal reports and Implemented dynamic cascading prompts
• Designed crystal reports with dynamic content & Custom UI.
• Designed Universes based on the data marts existed in the Data warehouse and to be used them as a source for the reports.
• Created universes from BEx Querries and customized with variables and filters Confidential Universe level.
• Created WebI reports as well as Deski reports from OLAP universes those were built from SAP BW data.
• Installed and configured SAP Front end tool and Integration kit on my machine.
• Exported universes, reports and dashboards from one environment to other using Import wizard and Life cycle manager.
• Created few reports and presentations using SAP Business Objects Advanced Analytics 1.0 tool.
• Involved in KPI meeting discussions and prepared the KPI matrix as per as the client requirements.
• Created Dashboards using Xcelsius with Live office and QAAWS and used most of the components.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with Crystal Xcelsius.
• Involved in the migration of Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing).
• Customized reports by adding prompts, Filters, Calculations, Summaries and Functions.
• Created custom List of Values (LOVs) for better understanding of prompts by the end user.
• Created complex variables, breaks, sorts, filter and conditions for various reports in Business Objects XI 3.1 environment.
• Support the quality assurance/quality control process for CTDN data.
• Responsible for service level Metrics
• Develop a Business Objects Universe for a portfolio management tool.
• Generated complex reports using the various data Providers like Universes, Personal Data Files and Free Hand SQL.
• Responsible for development methodologies.
• Created complex reports involving for the development of Drill reports, master-detail Reports, Linked reports and cross-tab reports.
• Implemented Row Level Security on Business Objects documents.
• Managed Users, Groups and their access privileges on the Universe and Report documents stored in central Repository database.
• Develop and publish new reporting solutions according to specifications identified and approved by the IT business
• Did Performance tuning of the reports, optimization of queries and fixing data issues in the developed reports.
• Develop, deploy and maintain reporting operations using the Business Objects Reporting Java SDK.
• Worked on Informatica Power center while tuning and to resolve data issues of the BO reports performance and data loading.
• Written PL/SQL stored Procedures and Functions to capture the changed records in the source systems and loading them into EDW using TYPE 2 Slowly Changing Methodology.
• Created Stored Procedures while generating the reports in BOXI and tested them against on to the Enterprise Database.
• Experience with Business Objects Installation, configuration, patching and maintenance.

Environment: Business Objects XI3.1/XI R2, Business Objects Universe Designer, Infoview, WEBi, Import Wizard, Crystal Xcelsius, Live Office, QAAWS, SAP BW, SAP BI 7.0, SAP Netweaver, SAP Front End, SAP Integration tool kit for BO, SAP Business Explorer (BEx Query designer, BEx analyzer), Life Cycle Manager, Central Management Console, Informatica Power Center, Oracle10g, PL/SQL, SQL Server 2005, Windows, Unix.

Confidential - ATLANTA, GA

Business Intelligence (BI) Developer

Responsibilities:

• Hosted Weekly & Monthly Project planning sessions with Project Managers, Business Analysts and team members to analyze business requirements and outline the proposed solution.
• Interacted with Internal Business Super Users to understand report requirements and translate these to Technical Specifications for Universes and Business Object Reports development.
• Conducted BO Training Sessions for Internal Program Managers, External Vendors and Auditors.
• Developed BO Training Manuals for internal super user reference.
• Installed & Configured Business Objects Enterprise 6x/XI/R2//R3.1 and created Repository.
• Converted Full client documents to Web I documents using Report Conversion Tool.
• Responsible to Maintain and Migrate Universe & Reports on Dev, Test, Pre-Prod and Production.
• Responsible to synchronize the QA, DEV environments with Production on every release and upgrade.
• Headed a Team of BO and Crystal Reports Developers in developing reports, bug tracking, as well as documenting Sign-Offs from Business during every release.
• Managed advanced User Access restrictions using Central Management Console (CMC).
• Defined LDAP Groups using Tivoli security and Enterprise groups to manage Internal and External user security.
• Implemented Vendor security Confidential Universe & report level, in order to simplify the security on CMC.
• Implemented “Single Sign on” on application portal to support Web I report access on company portal.
• Designed and Implemented Security Features such as row level, object level and report level to make output data secure.
• Assisted in developing data models, as well as logical and physical database designs.
• Accessed multiple data sources including Oracle, SAS, Teradata, Web services, and XML using Data Federator. Designer Responsibilities (Universe and Reports):
• Responsible for discussing with business to finalize changes with Application Enhancements and New reports during release.
• Created around 12+ Universes to support 8 new programs on Gas and Electric business.
• Responsible for Universe & Report Testing, Query Optimization, and Performance Tuning during upgrade.
• Created 200 + complex reports using the multiple data providers, multiple prompts and synchronized the data security to create common report for different program users and vendors.
• Created reports to visually represent data using Xcelsius 4/5/2008.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Objects Enterprise XI/R1/R2/R3/R3.1 (CMC, CCM, CMS, Designer, Desk I, Web I), Business Objects 6.5 (Supervisor, Designer, Reporter), Web Intelligence 6.5, Info View, Enterprise Performance Manager (EPM), SQL, PL/SQL,Oracle 9i/10g, Crystal Reports 2008, Xcelsius 4/5/2008, Teradata V2R6.1, Microsoft SQL Server 2000/2005/2008, SAP BW (OLAP/MOLAP), Apache Tomcat and TOAD and Windows 2000 Server.

Confidential

Software Engineer

Responsibilities:

• Designed and developed Universes by defining joins, cardinalities between tables, linked the existing Universes using Business Objects.
• Created Aliases, Multiple contexts for catering different functional areas in a single user query.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Customized LOVs in Universes for quicker performance of reports.
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Experience in universe migration across repositories
• Performed queries to fetch new data, and create reports in Business Objects 6.5 by connecting to Oracle Data Sources
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and sub queries.
• Used calculations, variables, breaks, sorting, filters, alerts and prompts while developing and creating reports.
• Involved in migrating reports and universes from 5.x to 6.5 and WebI reports using the report migration utility.
• Created and maintained Business Objects & Web Intelligence reports
• Published existing reports to corporate intranet through Web Intelligence.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Build and test universes and reports catered to end user requests.
• Associate with ETL team to build a data warehouse environment and provide constant updates about the necessary changes required.
• Developed Dashboards using Crystal-Xcelsius with data source as Live Office.

Environment: Business Objects 6.5.1, Web Intelligence 6.X, BCA 6.5, Publisher 6.5, Auditor 6.5., Informatica Power Center, Oracle 8i, Windows XP, Win 2000 Server, Sun Solaris 2.8 (Unix).