PROFESSIONAL SUMMARY:

• Over Nine years of experience working with major industries such as Financial/Capital Market, commercial banking and Pharmaceutical.
• Defined the processes to implement the new contracts for the PBMs at Pfizer, Inc and also worked with the IMS Health data.
• 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.
• Proficient in Installation and Deployment of Business Objects 5.x and Migration from Business Objects 6.x to Business Objects XI R2/3.1/ BI4
• Outstanding experience in Supervisor/Supervisor over web in 6.5 and Central Management Console (CMC) and CCM(Central Configuration Manager) in BO XI R2/3.1/BI4
• Installation & configuration, administration and maintained security in BO XI R2/R3.
• Using the Xcelsius 2008 created Comparison Dashboards, Visual Sales Models, Profitability and Region Analysis.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results
• Created the reports using BOBJ functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Created Xcelsius dashboards for the ORM (Owner Relation Management) application
• Configured the Data services to connect to the SAP R/3.
• Used QaaWS to provide dynamic functionality.
• Deployingon Tomcat, IIS, Web sphere and Weblogic with Apache,IIS as the front end web server
• Unit testing, system testing and user acceptances test (UAT) for universe, reports and security management for customers
• Identified the CTQ (Critical to quality) KPI’s and Metrics as a part of the requirements gathering.
• Involved in server side components of Zero Administration Business Objects (ZABO) applications.
• Created reports using SAP BICS conncetion.
• Experience in creation of ADHOC reports.
• Convert the raw requirement to HLD (High Level Design) and LLD (Low Level Design)
• Interacted with the Administrators in the Performance Tuning of the Dashboards.
• Experienced in coding Teradata 13.1, SQL Server 2000/2005.
• Working on Agile Scrum team in collaboration with ETL, Reporting team, Testers and DBAs.
• Developing mappings using BODI (Business Objects Data Integrator/ Data Services).
• Experience in working with XI3, migration and EPIC.
• Knowledge in working with HANA in Integration scenarios.
• Knowledge in working with EPIC under certain scenarios.
• Knowledge in working with HCI under specific instances.
• Converted business requirements (FRD) to technical requirement documents.
• Good in development of Data warehouse/Data Marts, Data Modeling, designing the STAR and SNOWFLAKE schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Proficient in working with error handling and performance tuning to enhance database performance.
• Created Universes from SAP BW/BI infocubes, infosets.
• 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.
• 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 Business Objects BI4 /XI R3/R2/6.5 like CMC,CMS, 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.
• 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.

TECHNICAL SKILLS:

Languages/Tools: Business Objects Suite 5.x/6.x/XIR2/XI3.1/BI4, Central Management Console, Central Configuration Manager, Infoview, Web / Desktop / OLAP Intelligence, Designer, Supervisor, Administrator, Crystal Decisions, Reports, and Xcelsius Data Visualization, Live Office, Import Wizard, Information Design Tool, Universe Design Tool, Promotion Management, Report Conversion Tool and Services, 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.

Databases: Oracle 10g/9i/8i/8.0/7.x, Teradata 14/12, MS SQL Server 2000/2005/7.0/6.5, Sybase 12.0/11.0, MS Access 2003/2000/97/7.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 Navigator, TD SQL Assistant, SQL*PLUS

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

PROFESSIONAL EXPERIENCE:

Confidential, NC

SAP Business Objects Developer/ Administrator

Responsibilities:

• Designed and validated universe from multiple data sources with SAP BI4 Information design tool.
• Created Dashboards using SAP BI4 Dashboard Design tool.
• Experience in working with XI3, migration and EPIC.
• Knowledge in working with HANA in Integration scenarios
• Involved in documentation for the mapping, technical specifications, data validations and Test cases
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Working on Agile Scrum team in collaboration with ETL, Reporting team, Testers and DBAs.
• Knowledge in working with EPIC under certain scenarios.
• Involved in migration and deployment of the universes and reports across multiple domains
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Experienced in coding Teradata 13.1, SQL Server 2000/2005.
• Creating standard full client reports and WebI reports.
• Identified the CTQ (Critical to quality) KPI’s and Metrics as a part of the requirements gathering.
• Performed the Integrity check and finally exported to the repository.
• Involved in requirements study, design reviews and analysis of input/output flow
• Migrated content from BOE 3.1 to SAP BI4 with Upgrade SAP Business Objects SAPBI4 LCM Tool.
• Visual Difference used to compare and validate the reports after migration.
• Installed SAP BI4 on Windows 2008 server.
• Created reports using SAP BICS conncetions.
• Documented BI launch pad guide for users to explore new features.
• Converted Desktop Intelligence reports to SAP BI4 Interactive Analysis Reports.
• Reports were build and modified at Interactive Analysis Desktop.
• Created .Unx Universes with Using of Information Design Tool(IDT).
• Server performance tracked at Monitoring tool and created Alerts top monitor to the server status.
• Co ordinate with SAP support team for maintenance and support.
• Maintenance of Dashboard Builder and Performance Management tool.
• Conversed .UNV universes to .UNX universes.
• Maintained security and rights for the Users and distributed to reports to user inboxes.
• Created new access levels to implement the best security standards
• Maintenance and Monitoring of the FRS and Event based Scheduled Jobs.
• 24/7 Support for the application support.
• Worked with both SAP authentication, Windows and Authentications.
• Reports were distributed with Reports bursting and personalized Profile techniques.
• Interacted with users for designing specifications for the Projects.

Environment: Business Objects BI4/3.1 (SIA/ Central Management Console, Information Design Tool (IDT), Universe Design Tool (UDT), Web Intelligence, Information Design Tool, Dashboard Design tool, Oracle 10g, Teradata 14/12, SQL Server 2005, Toad, Teradata SQL Assistant.

Confidential, NY

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.
• Knowledge in working with HCI under specific instances.
• Developing mappings using BODI (Business Objects Data Integrator/ Data Services).
• 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.
• Good in development of Data warehouse/Data Marts, Data Modeling, designing the STAR and SNOWFLAKE schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Identified the CTQ (Critical to quality) KPI’s and Metrics as a part of the requirements gathering.
• 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.
• Administered rebates, since large Pharma companies pay rebates for having their drugs on formulary (aka preferred drug list), assisted in managing the negotiations and billing of the rebates.
• Provided technical leadership, and created documents how the migration should be implemented keeping in consideration the future design modifications.
• Held weekly status review meetings with the upper management.
• Met all the key milestones and deliverables on time to the management.
• Deployed customized Dashboards using the Dashboard Manager XI.
• Used Business Objects Dashboard Manager to create Metrics report which is used to track and monitor critical business measures.
• Defined the goals and Key performance indicators for the PBMs using the Dashboard Performance Manager.
• Created test case scenarios for the QA Testing Center.
• Tested about 80 Business Objects full Client reports in the BO XI R3/ Crystal XI/2008 environment.
• Developed and deployed data integration solutions for the contract information group by using the Xcelsius 2008.
• Analyzed and designed the processes to move data from the source operational and external environments to the target environment using the Data Integrator.
• Used Business Objects Rapid Marts to provide packaged data integration and extract,

Environment: Oracle 10g, Business Objects 3, Brio 8.3.2, BO SDK, Macros, Web Intelligence, Desktop Intelligence, CMC, Designer, Import Wizard and Life cycle Manger.

Confidential, NY

Business Objects Developer/ Administrator

Responsibilities:

• Installed and configured Business Objects XI R2 on Windows platform
• Migrated Business Objects 6.5 to Business Objects Enterprise XI R2
• Setup Windows Authentication with Single sign on among multiple domains.
• Convert the raw requirement to HLD (High Level Design) and LLD (Low Level Design)
• Schedule Data Integrator jobs using Data Integrator Administrator.
• Involved in Import, export of metadata to facilitate data exchange between different tools (openness). Designed and established a metadata-reporting environment.
• Created Complex, General Ledger, Account Receive (AR) and Account Payable (AP) Reports.
• Created Dashboards with Cyclic display expressions in QlikView.
• Created OLEDB, ODBC connections to retrieve data from Oracle and SQL server databases to build QlikView
• 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
• 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.
• 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.
• Modified the existing jobs to increase the job time and added new validations.
• Process flow diagrams created using Visio.
• Migrated all current XI R2 prod business applications to BO XI R2 on DEV box, testing in progress.
• Expertise in deploying/elevating applications to UAT and Production.
• Maintaining current Business Objects Enterprise XI R2 Development/ Test and Production environments.
• 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: Business Objects R2/6.5 (SIA/ Central Management Console, Designer, Web Intelligence, Publishing, Migration and Schedule wizards), Crystal Reports, Oracle 9i,10g, SQL, SQL Server, TOAD, Windows 2000/2003 Info-burst, Auditing.

Confidential, NY

Business Objects Admin - Migration Planning/Implementation

Responsibilities:

• Successful Implementation of the new Business Reporting System.
• Led a migration from Business Objects 6.5.1 to Business Objects XI R2 for the Guardian Life Insurance.
• Held weekly status review meetings with the upper management.
• Held meetings with the users of all applications to define and implement the new security model for BO XI R2 using CMC.
• Implanted the Row Level Security for the users in the Designer module of BO XI.
• Fixed the reports, which used VB script macros, and worked on the formatting and Dynamic Cascade Prompts.
• 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
• 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.
• Worked with the Publisher, Scheduler, and server groups.
• Performed the security mapping and Windows AD integration.
• Collaborated with the client's Windows administrators, database administrators, and a line-of-business manager for business requirements.

Environment: Oracle 10g, Business Objects Enterprise XI R2 Suite, Crystal Reports XI/Xcelsius, Business Objects Enterprise 6x Suite (2-tier, Web Intelligence, 3-tier, BCA, Auditor),Teradata, Windows 2000/XP Pro, MS Access, IIS.

Confidential, MI

Sr. Business Objects Developer/Admin

Responsibilities:

• Worked with the managers of the Supply Chain such as Ordering, Production, Distribution and Logistics of the vehicles.
• Understand the concept of Vehicle Forecasting, Ordering, Production and the tools used such as AIM, VIM, COPS and PVP.
• Worked as a data integrity analyst to make sure that all the information regarding the Stop Orders, PIAs and Parts etc are sent correctly by the 5 ports used by the VW Logistics.
• Sent Daily reports to the Port Mangers on the Vehicle Inventory, Dealer Stock, Truck Loadedetc.
• Understood the Vehicle Ordering system and created reports for the mangers to review the performance of the FOMs assigned to each carline.
• Gathering of the requirements, analyzing the needs of the users.
• Created a large number of Full Client and Crystal reports. Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
• As a part of report development, created the reports using universe as a main data provider and using the Powerful business objects functionalities, and formulae. Involved in trouble shooting of various reporting errors.
• Analyzed data sources and target data models -Designed and developed scalable, reusable ETL jobs.
• Gathering user-requirements/feedback, implementing them in reporting applications, testing.
• Modified and corrected many existing reports as per the change requests from users.
• Involved in trouble shooting and Performance tuning of the existing and new reports.
• Web Intelligence was greatly used in the report generation.
• Scheduled and monitored the reports using BCA.
• Acted as a liaison between Business Objects team and Ordering, Production, Transport and Distribution teams to evaluate, support and enhance all levels of reporting and analysis.
• Continuous interaction with the financial department to obtain related data and reports.
• Implemented single sign on for the users.
• Implemented Row level security with user level.

Environment: Oracle 9i, Business Objects Enterprise 6x Suite (2-tier, Web Intelligence, 3-tier, BCA, Auditor), Crystal Reports X, Windows XP, MS Access, IIS, SQL, WebLogic Server 10.0.

Confidential, GA

Business Objects Developer

Responsibilities:

• Performed report requirement gathering
• Data being retrieved from SQL Server 2000.
• Created Universe containing contexts and aliases
• Created Reports consisting of Master Detail and crosstab reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, filters, breaks,prompts and alerters
• Tested the data output by querying SQL Server and verifying the data with the detail report.
• Interacted with Business Users, Business Owners to know their requirements in developing and modifying Universes and Reports accordingly.
• Extensively used Business Objects clients - Supervisor, Designer and Business Objects. Scheduled the actions like Refreshment and Distribution of Documents, using Broadcast Agent.
• Worked on creating Universes using the Business Objects Designer and connected to the database using ODBC. Resolved join problems, traps using aliases and contexts.
• Extensively worked on Slice and Dice, Sorting, Hierarchies, Drill up, Drill down, Filter, Calculations, @ functions and formatting the reports.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Generated and Published web reports in Info View using Web Intelligence.
• Created scheduled and AD hoc Reports according to the user requirements.
• Used Data Integrator Tool to transfer the data from one System to another System.
• Performed ETL operations with Data Integrator and extracted data from Flat file and XML file.
• Used BO Data Integrator to extract and load the data from OLTP System into Warehouse.

Environment: Business Objects 6.1, Web Intelligence 6.1, ZABO, Business Objects SDK, Windows 2000, and Microsoft SQL Server 2000