SUMMARY

• 9+ years of professional IT experience with Software Application Development, Data Warehousing, Design, Analysis, Development, Implementation, Administration and Maintenance using Business Objects BO 4.1/4.0/XI 3.x/XI R2/6.x,WebI 4.1/4.0/XI3.1/R2/6.x, Crystal Reports XI, Oracle 10g/9i/8i/7.x.
• Experience in Installing and Upgrading BO XI 3.1 Suite to BO 4.1/4.0 SP6
• Experience in designing and building the Universe using Information Design Tool (IDT) and Universe Designer, and updating the existing Universes, developing canned/ad - hoc reports, scheduling the processes/reports and administering the BO activities.
• Experience in creating the Dashboards using Dashboard Design 4.0/Xcelsius, Live Office, QAAWS
• Experience in creating Dashboards using Design Studio 1.2
• Using Universe & Webi Reports as a Data source of Xcelsius to build the dashboards thru Use QAAWS & Live Office to get the live data.
• Using SAP Netwear BW Connection to connect the SAP BEx queries into getting the data to Xcelsius Dashboards.
• Created Dashboards with Crystal XCelsius Dashboard/Dashboard Design 4.0 using excel functions ("VLookup, Hlookup, Index, Match and Conditional statements").
• Experience in upgrading Business Objects Client and Server products from BO 5.1.8 to BO 6.5.2 and BO XI 3.1 to BO 4.0
• Experience in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using Business Objects XIR3/XIR2/6.5
• Expertise in creating, organizing, publishing and scheduling reports using Central Management Console.
• Migration of Business Objects 6.5 to Business Objects XI R2 Enterprise. Conversion Desktop Reports to WEBI reports using Conversion tool.
• Good knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• Good knowledge in designing and deploying data visualizations using Tableau
• Good Data Warehousing ETL experience of using Informatica Power Center 8.x/7.x/6.x, Mappings, Mapplets, Transformations, OLAP, OLTP.
• Experience in ETL (Extract-Transform-Load) using MS BI SQL Server Integration Services (SSIS 2008).
• Exposure in creating and managing SAP BW and HANA connections using CMC
• Creating reports using BO 4.0 applications on top of SAP HANA and SAP BW
• Experience in building Universes, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
• Extensive Experience in setting up environment for BOXI, which involves creating the groups in CMC, adding users, mapping the row level and object level securities, migrating objects and universes.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, grouping, sub reports etc.
• Expertise in Administrative activities of Business Intelligence tools such as Business Objects 4.1/ 4.0/XI 3.1/XIR2
• Technical hands-on expertise in using Business Objects BO 4.1/ 4.0/XI 3.1/XI R2/6.5 (IDT, Designer, Reporter, CMC, CCM,BI Launchpad, Web Intelligence, Desktop Intelligence) and creating Dashboards using Dashboard Designer/Designer Studio
• Trained the end users in working with the Business Objects user module and provided technical expertise
• Excellent analytical and communication skills that are required to effectively work in the field of applications development and maintenance

TECHNICAL SKILLS

OLAP: Business Objects 4.1/4.0/XI3.x/XIR2/6.5.2 (BI Launchpad, IDT, Universe Designer, Promotion ManagementUpgrade Management Tool (UMT), Supervisor, InfoView, Broadcast Agent, BO AuditorWebI 4.1/4.0/XI3.1/6.5, Broadcast Agent Publisher, CCM, CMC, Desktop Intelligence, Import Wizard), SSRSCrystal Reports,Tableau

ETL: Informatica PowerCenter/PowerMart 7.1, MS BI (SSIS 2008), Data Services 4.0

Databases: Oracle 10g/9i, MS SQL Server 2012/2008 R2, DB2, SAP HANA 1.0

Tools: Toad, SQL Server Management Studio, Visual Basic6.0/5.0

SAP: BEx Query designer and BEx Analyser

Programming: SQL, PL/SQL, UNIX Shell, C, Java, JSP, VB 6.0, ASP

OS: UNIX, Solaris 2.7, Windows NT, Windows XP/2000/95

PROFESSIONAL EXPERIENCE

Sr. Business Objects Admin / Developer

Confidential, Houston, TX

Responsibilities:

• Interacted with Business Users to understand and document the requirements.
• Worked with the Business Analysts and end users in analyzing the requirements.
• Documented user requirements, translated Functional requirements into Technical Requirements.
• Involved in Preparing the Work Breakdown Structure (WBS) for the new report Requirements.
• Monitoring the day to day BO Services.
• Made necessary changes in Webi processing and Adaptive processing servers to stabilize the BOBJ environment.
• Created complex Webi reports on SAP BEx Queries using BICS.
• Created linked reports using hyperlinks by passing prompts with Open Document functionality.
• Passing Input Control Values from the Main Report to Child Report.
• Promote content from Dev to Test to Prod environments using Promotion Management after testing and user signoff.
• Created Pareto and Trending Charts at Region, Country and Facility Level to track the WO processing and efficiency over a range of time.
• Created Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries.
• Created dashboards using SAP Design Studio as POC
• Experience in Training & Supporting end-user reporting needs using BO 4.0/4.1

Environment: BO 4.1 SP02 / 4.0 SP6 /XI 3.1 (BI Launchpad, IDT, Web Intelligence, Universe Designer, LCM, Dashboard, Designer 4.0, Promotion Management, Upgrade Management Tool, CMC, CCM), SAP BI/BW, BEx Query, TomcatSAP Design Studio 1.2/1.3, Windows 2008 R2

Sr. Business Objects Developer

Confidential, Fort Mill, SC

Responsibilities:

• Interacted with Business Users to understand and document the requirements.
• Installation of BO 4.0 in all phases of environment i.e Development and Production environment.
• Migrating the content from BO XI 3.1 to BO 4.0 using Upgrade Management Tool (UMT).
• Installation of BO 4.0 SP 6/BO 4.1 Support Packs, Patches and upgrades to ensure the SAP Business Objects systems are up to date with latest bug fixes.
• Resolving the Post Upgrade issues from BO XI 3.1 to BO 4.0/BO 4.1
• Made necessary changes in Webi processing and Adaptive processing servers to stabilize the BOBJ environment
• Created simple to complex Webi reports and also used the new features in BO 4.0.
• Creating users and groups assigning the access levels.
• Used the @ Functions such as @ AggregateAware, @Select, @Prompt in designing Universe
• Monitoring the day to day activities on the servers.
• Migrating the Universe/Reports from Development to Production using Promotion Management.
• Configuring SAP BI Mobile application on both iPad and Android.
• Deployed BO universes and reports from Development environment to Production environment using Promotion Management (UMT)
• Creating webi reports based on Multi Data Providers.
• Migrating the Reports and Universes between different environments using Promotion Management.
• Designed and developed Dashboards using Dashboard Design 4.0 and deployed to display on Android and iOS based Tablets.to
• Migrating the Dashboards between different environments.
• Managed scheduled and notification options for documents to the desired users.
• Experience in Training & Supporting end-user reporting needs using BO 4.
• Created Dashboards using Design Studio 1.2 as POC
• Created Dashboards using Cascading Prompts and Dynamic Visibility functionality in Design Studio
• Administered Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM), and Publishing.
• Involved in helpdesk support for resolving user issues

Environment: Business Objects BO 4.1 SP02/4.0SP6/XI 3.1 (BI Launchpad, IDT, Web Intelligence, Designer, LCM, Dashboard Designer 4.0,Promotion Management, Upgrade Management Tool, CMC, CCM), Live Office, Design Studio 1.2, SQL Server 2008, Tomcat, Windows 2008 R2

Sr. Business Objects / ETL Developer

Confidential, NJ

Responsibilities:

• Interacted with Business Users to understand and document the requirements.
• Creating the Universe with required classes and objects, and specified the hierarchies.
• Created simple to complex Webi reports
• Migrating the Universe/Reports from Development to Production using Promotion Management.
• Deployed BO universes and reports from Development environment to Production environment using Promotion Management.
• Managed scheduled and notification options for documents to the desired users.
• Involved in preparing reports for the project manager, these reports include routine reports such as status reports.
• Experience in Training & Supporting end-user reporting needs
• Administered Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM), and Publishing.
• Creating users and groups assigning the access levels.
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation
• Extracted data from flat file sources and loaded it into SQL Server.
• Created Agent Job and Scheduled the Driver Package based on client requirements.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation
• Monitoring the day to day activities on the servers.
• Involved in helpdesk support for resolving user issues

Environment: Business Objects XI 3.1 (Designer, Web Intelligence, LCM, CMC, CCM), Live Office, MS BI (SSIS), SQL Server 2008, SSIS 2008, Tomcat, Windows 2008

Sr. Business Objects Developer

Confidential

Responsibilities:

• Requirements gathering from the business users to build the reporting application
• Migration of BO Enterprise 6.5.2 to BO Enterprise XI R2 and WebI 6.5.2 to Enterprise XI R2
• Upgrading Universes and Reports from BO Enterprise 6.5.2 to BO Enterprise XI R2 and WebI 6.5.2 to Enterprise XI R2
• Designed and developed Universe against AQR Data Mart and DataWarehouse
• Administration of Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM) and Publishing
• Used Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XI environment
• Created Reports using various Data Providers using Business Objects XI R2/6.5
• Involved in migration and deployment of the universes and reports across multiple domains
• Developed Reports using Desktop Intelligence and WebI
• Creating conditional objects and used Universe level security restrictions
• Creating user-friendly objects using @ Functions at Universe Level
• Created Derived Tables for report generation
• Interaction with users in analyzing requirements for report development and also involved in helpdesk support for resolving the user issues

Environment: Business Objects 6.5.2/BO XIR2 (Supervisor, Designer, Reporter, CCM, CMC, Desktop Intelligence, Import Wizard, WebI 6.5.2/XI R2, InfoView), Oracle 10g, ASP, TOAD, IIS, Tomcat, Apache, Windows 2003

Sr. Business Objects Developer

Confidential, WA

Responsibilities:

• Installation and upgrading Business Objects Client and Server Products from BO v5.1.8 to BO v 6.5.2
• Requirements gathering from business users to build the reporting application and training them on Universes and generating reports
• Used Universes as source for the Business Objects reporting and analysis
• Developed new reports based on Business Requirements
• Scheduling and distributing documents through Broad Cast Agent
• Designed and Developed Technical User Documentation and involved in training the end users
• Involved in migration and deployment of the universes and reports across multiple domains
• Resolving loops using contexts and aliases to remove the cyclic dependencies
• Gathering business requirements, functional requirements & data specifications
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, @Functions, etc
• Supporting and Maintaining Business Objects Deployment
• Responsible for attend the tickets - analyze, fixing them within the specified time limits
• Used Broadcast Agent for Scheduling Reports refresh periodically

Environment: Business Objects 5.1.8/6.5.2 (Supervisor, Designer, Reporter), WebI 2.7/6.5.2, InfoView, Oracle 9.1, ASP, TOAD, IIS, Windows 2003

Business Objects / ETL Developer

Confidential, CO

Responsibilities:

• Designed and developed Universes for reports generation
• Created Users and Users Groups and assigned profile to Users using Supervisor
• Used Broadcast Agent Publisher for Report Bursting, so that each individual receives only his particular information in Excel format
• Gathering business requirements, data transformation, data loading, SQL and performance tuning
• Developed mappings using different transformations to transform the data and load it to Target Database
• Created and configured Sessions to load the data from source to target database using Server Manager
• Maintained stored definitions, transformation rules and targets definitions using Informatica Repository manager
• Handled rejected data, corrected the rejected file and loaded in to target using reject file utility
• Created the batches to run several sessions sequentially and concurrently
• Interacting with end-users by training them on Universes and generating various reports according to end-user requirements
• Created Dash Boards using Application Foundation and made the environment an End User friendly interface

Environment: Business Objects 5.1.3, Broadcast Agent Publisher, WebI 2.6 (Reporter, Explorer, InfoView), Oracle 8.1, WebLogic Application Server, Application Foundation 2.5, UDB, Informatica PowerCenter 5.1, Windows 2000

Programmer/Analyst

Confidential

Responsibilities:

• Created the mappings according to the design documents.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Created workflows.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Responsible for designing the documents, Unit test plans and system integration test plans.

Environment: Informatica 6.1, Oracle 9i, PLSQL, HP UNIX.