SUMMARY

• Over Ten years of experience working wif major industries such as Financial/Capital Market, commercial banking and Pharmaceuticals.
• Defined the processes to implement the new contracts for the PBMs at Confidential Inc., and also worked wif the IMS Health data.
• Created Executive level dashboards/reports to help make the decisions which impacted the overall performance of the Supply Chain.
• Architected the technology/systems, and lead the implementation of BI related projects.
• Closely worked wif managers to understand and define the reports dat were required by them to make managerial level decisions involving the Forecasting, Production and Logistics of the vehicles.
• Lead, designed and oversaw complex, cross - functional, multi-platform business processes.
• Created Business Planning reports based on different scenarios for the future financial outlook of the organization.
• Experienced in End-User Interaction Incident/Problem/Release Management Project Life cycle.
• Server templates are created at Central Management server.
• Involved in Design of Database models Stat Schema and Snowflake Schema models.
• Identifying and adapting industry best practices dat should be adopted at Client.
• Created Reporting templates based on Organization standards for report development.
• Proficient in Installation and Deployment of Business Objects 5.x and Migration from Business Objects 6.x to SAP Business Objects XI R2/3.1.
• Outstanding experience in Supervisor/Supervisor over web in 6.5 and Central Management Console (CMC) and CCM(Central Configuration Manager) in SAP Business Objects XI R2/3.1 and noledge on SAP Business Objects 4.0
• Installation & configuration, administration and maintained security in SAP Business Objects XI R2/R3.
• Using the Xcelsius 2008 created Comparison Dashboards, Visual Sales Models, Profitability and Region Analysis.
• Advanced experience in creating the data warehouse/excel reports.
• Over eight Years of IT experience in Analysis, design, development, test and implementing Data Warehouse, Business Intelligence and Client Server applications.
• Experience in Customizing the Full Client Interface using BO SDK and Thin Client Interface using WEBI SDK using JSP.
• Expertise in Installing Desktop and Enterprise Server Products of Business Objects in Single and Distributed Environments on Windows.
• Proficiently developed use-cases and project documentation (user guides, standard report instructions, demos)
• Highly proficient at requirements gathering and testing planning/scenario creation/test case creation - Strong analytical/problem-solving skills, wif the ability to quickly gain alignment on proposed solutions.
• Expert in working wif all the modules of SAP Business Objects XI R3/R2/6.5 like Central Management Console, Central Management Server, Crystal Xcelsius, Desktop Intelligence, Scheduler, Supervisor, Designer, Application Foundation, Data Integrator, Web Intelligence, Web Intelligence Rich Client, BCA, ZABO, Business Objects Dashboard Manager, Dashboard Builder, XI Business Objects Performance Manger, Performance Tuning.
• Wrote test cases for different Business Objects reporting scenarios for the UAT of the newly developed BO reports.
• Created test scenarios for the Development, Testing and Production environments.
• Used the Rapid Marts to deliver information to the end users for the complex enterprise analytic requirements.
• Highly proficient at creating Business Object universes using Business Objects Designer Module.
• Experience in creating Customized, Ad hoc and canned complex reports using Business Objects.
• Expertise in security setup among groups, categories, users and successfully implemented windows authentication, single sign on among single and multiple Domains.
• Worked wif multiple Business Intelligence tools like OBIEE (Oracle Business Intelligence), Hyperion Brio and SAP Business Objects Products (Desktop Intelligence, Web Intelligence Rich Client, Xcelsius, Crystal Reports, Live Office, Query as a Web Service), QlikView.

TECHNICAL SKILLS

Languages/Tools: SAP Business Objects Suite 5.x/6.x/XIR2/XI3.1, Central Management Console, Central Configuration Manager, Infoview, Web / Desktop / OLAP Intelligence, Designer, Supervisor, Administrator, Application Foundation, Enterprise Performance / Information Manager, Dashboard Manager, Scorecards, QAAWS, Voyager, Crystal Decisions, Reports, and Xcelsius Data Visualization, Live Office, Import Wizard, Report Conversion Tool and Services, QlickView, Broadcast Agent Scheduler, Publisher and Auditor. Crystal Enterprise 9/10/XI/2008, Crystal Xcelsius 2008/4.5, Web Intelligence, SQL, Informatica Power center 7.1.1/8.1, ASP.Net, Java, BO SDK, Performance Management. OBIEE(Oracle Business Intelligence), ACBS(Advanced Commercial Banking System) REMS (Real Estate Management System), Varonis, Kazeon, NetApp, EMC, Hyperion/Brio 6x/8x/9 BI, Hyperion Reports, Essbase, QlikView 10x.

Databases: Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000/2005/7.0/6.5 , Sybase 12.0/11.0, MS Access 2003/2000/97/7.0 , Teradata V2R5, V2R4, DB 2 8.2/8.0/7.0/6.0 , (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5).

SQL Utilities: Toad, SQL, SQL*PLUS

Operating Systems: Windows NT/2000/XP/2003/2008 Server, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior SAP Business Objects Developer/ Administrator/ Architect

Responsibilities:

• Installed and configured Business Objects XI 3.1 on Windows 2008 SP2 platform.
• Migrated Business Objects 6.5 to SAP Business Objects Enterprise 3.1 SP3.
• Worked wif linked Universes and resolved issues during migration.
• Created dashboards wif Cyclic display expressions in QlikView.
• Used multiples data sources and edited the scripts for linking the tables at QlikView.
• Created drilldown groups and applied on charts for better analysis.
• Used system table functionality in QlikView to audit the tables, columns and rows.
• Created OLEDB, ODBC connections to retrieve data from Oracle and SQL server databases to build QlikView Dashboards.
• Extensively used Web intelligence functionalities like Input Controls, Optional Prompts, Tracking data functions.
• Created Complex reports from Multiple data providers and free had SQL.
• Resolved the issues related to contexts, loops and traps.
• Used functions like Index awareness, Aggregate awareness and optimized the universe performance.
• Tuned SQL queries to improved performance during the schedule refresh.
• Setup Windows Authentication wif Single sign on among multiple domains (transitive trust among domains).
• Strong noledge and Financial and Wholesale Banking domains.
• Experience in setting up of multiple deployments on clustered environment.
• Created reports in Desktop Intelligence, Web Intelligence, Xcelsius and QlikView
• Knowledge on SAP Business Objects Enterprise 4x.
• Involved in Import, export of metadata to facilitate data exchange between different tools (openness). Designed and established a metadata-reporting environment.
• Business Objects Web Intelligence, both self-service access to information and data analysis are available in one product, helping users turn business insights into effective decisions.
• Business Objects Self service reporting access is given to users to generate, filter, sort, personalize reports, and statements online
• Created Dashboard and Report templates for each portfolio to maintain the standards in the organization.
• Self service reporting, improve productivity, reduce operational cost, and increase customer satisfaction.
• Maintaining and Troubleshooting of Business Objects Enterprise Objects Enterprise Servers and clustering.
• Setting up and Configuring Business Objects Servers like job servers and FRS.
• Creating, maintaining and modifying the business critical reports using the Desktop Intelligence
• Generating the Standards and templates for the reports, interfaces and the universes.
• Responsible for developing thick/thin client canned reports using Business Objects and Web Intelligence
• Scheduled and monitored reports using Broadcast Agent Server and job servers.
• Profiles created for personalizing the documents based on the portfolios.
• Involved in training the end user in basic and advanced Ad Hoc reporting as well as to create queries, format results, and share them wif others wifin the enterprise and using Web Intelligence
• Interacted wif functional/end users to gather requirements of core reporting system to understand exceptional features users expecting wif reporting system and also to successfully implement business logic.
• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process.
• Configuration tool used to create backup plan.
• Maintained & Modified Universes using BO Designer and exported to the CMS Repository
• Administration console used to monitor process and users connections.
• Coordinated wif the users and business analysts to understand the scope of the business requirements, user expectations and ensure the accuracy of the reporting specifications.
• Allocating work to report developers based requirements and priorities.
• Modified the existing jobs to increase the job time and added new validations.
• Process flow diagrams created using Visio.
• Involved in design of the Databases wif Database administration team.
• The Migration project life cycle is documented wif Initiation, Planning, Execution and Closure Phases (noledge of Project management Book of Knowledge (PMBOK))
• Migrated all current XI R2 production Business Objects applications to BO XI 3.1 on DEV and Production.
• Expertise in deploying/elevating applications to UAT and Production.
• Maintaining current Business Objects Enterprise XI 3.1 Development/ Test and Production environments.
• Development and test environment were installed on VMware.
• Successfully implemented and followed the change management processes, Service Level Agreements and ITIL processes.
• Expertise in taking cold and hot backups of business objects repository and content as well.
• Successfully tested the DR in remote place.
• Monitoring scheduled key reports to FTP to remote location and these reports are input to downstream systems.
• Expertise in deploying to UAT and production via CCC tickets.
• 24 X 7 production support.

Environment: SAP Business Objects XI 3.1/R2/6.5 (SIA/ Central Management Console, Designer, Web Intelligence Rich Client, Publishing, Migration and Schedule wizards, QAAWS, Crystal Reports, Foot Prints, ACBS, NEO, EMC, Flexcube, NetApp, Oracle 9i,10g, SQL, SQL Server, TOAD, Windows 2000/2003/2008 , Info-burst, Auditing, OBIEE(Oracle Business Intelligence), Oracle Data Integrator, Informatica Power Center, PowerMart, Hyperion BRIO, Hyperion Reports, Essbase, Xcelsius 2008, Java Scripts Kazeon, Varonis, Autosys, QlikView 10x.

Confidential, Harriman, NJ

Senior Business objects Admin/Developer

Responsibilities:

• Migrated the security domain (users, groups and profiles) to XI R2 infrastructure.
• Migrated universes and all related documents from BO 6.5.1 to XI R2 file system using migration wizard.
• Configured all the scheduling jobs through XI R2 framework.
• Integrated mail component on the scheduling job server to send all refreshed documents via e-mail to respective users and groups.
• Used the load balancing by managing various services on different servers in a clustered architecture.
• Used advanced features like Cascading prompts in designer and desktop intelligence reporting.
• Worked wif multiple data providers on Web Intelligence reports using synchronized dimensions.
• Gathering and implementing user requirements/ feed backing reporting applications, testing QA and delivery. Extensively worked on Dashboard creation using Application foundation 6.5.
• Created complex Webi reports using all the latest features of Webi multiple data providers, variables etc. used sections, breaks, and filters.
• Created Complex reports using Cascading Prompts, Multiple data providers etc.
• Detected Cardinalities and Loops. Resolved loops using aliases & contexts.
• Scheduled and processed the reports at the server level through BCA.
• Conducted Training and Knowledge transfer session wif user for understanding tool and to create ad-hoc reports using Meta Topics.
• Developed Custom Hyperion Query reports wif complex user interface (Dashboards) to provide real time reporting capabilities.
• Designed workflow and dataflow to load the fact table using the source and Dimension tables.
• Used Data Integrator for extraction, transformation and loading of data mart
• Created Dashboard templates for reuse of the Scripts and Filters for Hyperion Brio Reports.
• Multiple data sources OLAP cubes and tables were used for creation of Hyperion Brio reports.
• Loaded the dimension tables using the staging tables as sources.
• Monitoring scheduled key reports to FTP to remote location and these reports are input to downstream systems.
• Interacted wif functional/end users to gather requirements of core reporting system to understand exceptional features users expecting wif reporting system and also to successfully implement business logic.
• Performed Server administrative tasks, including Manage Services - Starting - Stopping Server Services, Publishing, Migrating, Importing etc.

Environment: Business Objects 6.1.3/ 6.5.1 , XI R2, Central Configuration Manger, Central management Server, Import Wizard, BCA, Admin Console, Configuration Tool, Designer, Auditor, ZABO, WebI 6.5, App. Foundation 6.5, Hyperion/Brio 8x, 9 BI, IIS 6.0, JAVA 2.0, Apache 2.0, Tomcat 4.1.3, Oracle 8i/9i,, Windows-NT.

Confidential, FL

Business Objects Developer/ Admin

Responsibilities:

• Created Crosstab reports, Freehand Sql Reports and used multiple data providers and contexts to generate the reports.
• Used Informatica to design, code and test data extraction from multiple databases Oracle and SQL Server and loaded it in target database Oracle.
• Created Hyperion reports from RDBMS tables and Essbase OLAP Cubes.
• Created Data Model templates for reusability and stored templates in Source Safe for future use.
• Involved in the development of mappings. Most of the transformations were used like Source Qualifier, Aggregators, connected and unconnected Lookups, Filters and Sequence Generator.
• Developed BO Universes using Designer and Business Objects for the reporting solution for reporting System.
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created multi-dimensional reports and ad-hoc reports.
• Created reports in cross tab, master detail format and transformed them in 2-D, 3-D Column, Line, Area, Pie charts for graphical analysis.
• Created reports wif conditions and organized data in regions using slice and dice mode and created thin client reports wif Ranking, Sorting and Filter objects in Web Intelligence.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast Agent Server.
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router, Sorter and Stored Procedures.
• Design, development, implementation, and maintenance of systems, reports and databases Scripts to schedule reports at proper intervals.
• Security module dat restricts access to company’s data to the individuals allowed.
• Created a Whole New Infrastructure of BI Delivery mechanism for ease of use to different business groups.

Environment: Business Objects 6.1.3/ 6.5.1 , BCA, Crystal Reports, Hyperion BRIO, Essbase, Auditor, ZABO, WebI 6.5, SQL Navigator, Oracle 8i/9i, Windows-NT, REMS (Real Estate Management Systems).

Confidential, NJ

Business Objects Developer/ Admin

Responsibilities:

• Created and Maintained Users, User Profiles and Repository.
• Created Web Intelligence and Business Objects reports for sales management team for analysis.
• Reports were used on weekly basis for analyze the market trend.
• Call Average reports were created and analyzed the impact of the Call average Vs Sales.
• Analysis reports are used for the Focus of the products and analyze the market dynamics.
• Exported the reports to Broadcast Agent and Scheduled, Monitored the jobs.
• Developed Reports and used Slice and Dice Functionality for better user understanding.
• Involved in requirement gathering and presenting Proof of Concepts.
• Involved in Designing and Modifying the New and Existing Universes and Reports.
• Created new Universes and modified the existing Universes as per the new requirements. As a part of Universe development, created Classes, different kind of objects, cardinalities, Strategies. Created Adhoc Reports using User module in Business Objects. As a part of report development created the reports using universes as a main data provider and using the Powerful business objects functionality’s like @ functions, user response and formulae’s.
• Created thin client reports and publish them on the Webi. Customized the reports using Business Objects SDK. Created Macro and Add-Inns.
• Published the reports through BCA. Evaluated Publisher for report bursting.
• Involved in Q&A and moving the reports into different environments.

Environment: Oracle 8/8i, Business Objects 5.1.3, Designer, Supervisor, Admin Console, Broadcast Agent, Brio 8.3.2, BO SDK, Macros, Webi 2.6, ZABO, Publisher, BCA, Windows NT.

Confidential

Business Objects/ ASP Developer

Responsibilities:

• Created Business Objects reports and designed Universe, key elements of universe such as hierarchy building for data analysis and apply conditions in objects, resolving loops and other SQL problems.
• Gathering user requirements/ feed back, implementing them in reporting applications, testing, Q&A and delivery.
• Creating complicated queries, document centricity, calculations, variables, breaks, sorting, drilldown, slice and dice, alerts and formatting presentation styles (Graphical).
• Customized the Web Interface using ASP.
• Involved in SQL query tuning by rules based and cost based optimizers.

Environment: Oracle 8i, 9i, SQL * Loader, PL/SQL store procedures, Business Objects Enterprise 6.1/5.x, ASP, Windows 2000.

Confidential 

Business Objects/ VBA Developer

Responsibilities:

• Involved in logical design and physical design of database.
• Created Universes for report generation using the designer module in Business Objects. dis involved creating classes, various objects, cardinalities and strategies. Resolve any loops using aliases and contexts. Checked the integrity of the universes. Exported the universes to the repository for the user access.
• Created reports using stored procedures as one of the data provider.
• Created database object using SQL Navigator and Toad.
• Generated Standard templates for custom reports and standard reports.
• Automated report functionalities using VBA through broadcast Agent..
• Conducted unit and system testing for reports for their validation

Environment: Oracle 8.1.7, SQL, PL/SQL, Business Objects 5.1.6, VBA, Crystal reports 8.5