PROFESSIONAL SUMMARY:

• Over Ten years of experience working with major industries such as Financial/Capital Market, commercial banking and Pharmaceuticals.
• Defined the processes to implement the new contracts for the PBMs at Pfizer Inc., and also worked with 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 with managers to understand and define the reports that 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 that 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 knowledge 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, with the ability to quickly gain alignment on proposed solutions.
• Expert in working with 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.
• Created Universes with BEX Cubes in SAP BW
• Worked with 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, ECC 5.
• 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, DB2 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

Senior SAP Business Objects Developer/ Administrator/ Architect

Confidential .Worked on ACBS Advanced Commercial Banking system , had several systems to initiate, originate service and report on their commercial lending activities and also used track and validated the accuracy of the reports. The ACBS Funding project's goal is to track the Inflow and outflow if the funds to various customers. NEO is our home grown application used to validate the transaction at Customer, Deal and Facility level. This project majorly deals with Guarantor, Pipeline, Real Estate, Defaulted customers. The Bankers Acceptance Project deals with the Interest on loans and profits made by banks on different Deals, Facilities and Loans.

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 with linked Universes and resolved issues during migration.
• Created dashboards with 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 with Single sign on among multiple domains transitive trust among domains .
• Strong knowledge 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 with others within the enterprise and using Web Intelligence
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with 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 with 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 with Database administration team.
• The Migration project life cycle is documented with Initiation, Planning, Execution and Closure Phases knowledge 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

Senior Business objects Admin/Developer

Confidential. In addition to full range of Commercial Banking facilities, the firm is among the leading providers of global custody, foreign exchange, private equity, merger and acquisition services, investment management for individuals and institutions, personal trust estate administration and securities Brokerage. Custom reporting is a part of Fund Accounting in Distributed Data Repository group. The goal of custom reporting tax reporting is to design and develop Business Objects Webi and deski reports for management decision making process.

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 with 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 with user for understanding tool and to create ad-hoc reports using Meta Topics.
• Developed Custom Hyperion Query reports with 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 with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with 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

Business Objects Developer/ Admin

REMS Real Estate Management System This Project is all about tracking and managing the Construction projects for CITI Group World wide. Through this system we track the Allocated Budgets, Utilized Budgets, Leases, Rentals areas and other Constructional requirements. We- BO Team created full decision support system for users and Top level Officials and Directors by providing Full client Webi reports for users and Dashboards for Top level officials. With this REM system Top level officials will be provided contracts information through dashboards which are very interactive and flexible, which is very supporting for them to take crucial decisions and provides infrastructure to develop flexible day to day reports.

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 with conditions and organized data in regions using slice and dice mode and created thin client reports with 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 that 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

Business Objects Developer/ Admin

Pfizer is one of the Leading Pharmaceutical Company Producing and Marketing different Molecules across the Globe. In the professional data ware housing Projects I have created, Developed and modified different reports. My role in this project is to create reports for the Management team about the sales, Marketing and Promotion activity of the field staff in the market. The reports are used for Analysis and decision making the reports I have developed are Call Activity, Detail activity Call Vs Details, Samples, AWR Average Weekly Recommendations and Sales reports Call Vs Sales, Details Vs Sales . The reports are analyzed to see the productivity of the field staff and changing the promotional activities to improve the sales in different markets.

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

• Project: COMPASS Comprehensive assessing system
• Confidential is a sales and marketing shipment system used for reporting and analysis. It has been designed to track sales and marketing as well as pricing. Created several reports based on the user requirements. Also all reports were deployed in both full client and thin client environments. Designed and developed a relational model for the data warehouse by gathering information form the different departments like marketing, sales, resellers and billing. Load the data from the production server and also customizing the web interface by using ASP.

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

• Project: CARE Customer account reporting and enhancing
• Confidential is worldwide research based pharmaceutical company, they are engaged in the discovery, development, manufacturing and marketing of new therapies and treatment programmes. Current report provides limited actionable information to support effective targeting and planning in field. The purpose of this project is to assist business users in delivering a solution the will increase the efficiency and productivity of business. The system collects all the customers' information and generates ad-hoc reports, which are required by various departments and branches, using Business Objects.

Responsibilities:

Involved in logical design and physical design of database.

• Created Universes for report generation using the designer module in Business Objects. This 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

Confidential

VB/Crystal Reports Developer

Description:

Confidential. These 14 states are divided into 3 regions, namely Eastern, Central, western regions. Each region maintains, it's own billing system. The billing system for the central region is called, Central Customer Records Information System CCRIS

Responsibilities:

• Study of the Requirement and getting Clarifications for the change request, trouble request and enhancements through client communications.
• Prepare analysis and low level design for the change request, trouble request and enhancements. Creating and front end screens, implementing the business logic and creating reports.
• Prepare test plan specifications and conduct unit testing.
• Coordinate the review and code walk through.

Environment: Windows 2000, SQL, Visual Basic, Oracle 8i, Crystal reports.