PROFESSIONAL SUMMARY:

• Over Ten years of experience working with major industries such as Financial/Capital Market, commercial banking and Pharmaceutical.
• 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.
• 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.
• Identifying and adapting industry best practices that should be adopted at Client.
• 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
• Good knowledge of report developing inBusiness Object & Tableau.
• Created Executive level dashboards/reports to help make the decisions which impacted the overall performance of the team
• 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.
• Advanced experiences in creating the data warehouse/excel reports.
• 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, XIBusiness Objects Performance Manager, Performance Tuning.
• Good knowledge of report developing inBusiness Object & Tableau.
• ReportinginBOBJ 4.X,Webi,BEx, AIX,AO,Tableau,Dashboard,Design Studio, Crystal Enterprise 7.X
• Wrote test cases for different Business Objects reporting scenarios for the UAT of the newly developed BO reports.
• Good knowledge on Business Process and Consolidation(BPC).
• Good understanding of Business Planning and Consolidation (BPC 10); including planning, consolidation and Intercompany, Ownership etc.
• 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.
• Configuring MOSS to display SAP iViews within SharePoint site using iView Web Parts.
• Displaying the business data fetched from SAP using Business Data Catalog in the form of Enterprise Search, SharePoint Lists, Web Parts, Excel Pivot Charts, Excel Services and custom applications.
• Integrating Microsoft InfoPath and Form Server with SAP & configuring to write data back to SAP.
• Display Business Server Pages (BSP) within SharePoint using Web Parts.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQLServer Integration Services (SSIS).
• Expertise in Developing and Extending MS SQL Server Analysis Services 2005/2008/2012
• SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objectsandwriting MDXqueries.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or
• Management decisions using MS SQL Server Reporting Services 2005/2008/2012 (SSRS).

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, PA

Sr. Business Objects Developer

Responsibilities:

• 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.
• Involved in migration and deployment of the universes and reports across multiple domains
• Creating standard full client reports and WebI reports.
• Documented BI launch pad guide for users to explore new features.
• Converted Desktop Intelligence reports to SAP BI4 Interactive Analysis Reports.
• Coordinate with SAP support team for maintenance and support.
• Interacted with users for designing specifications for the Projects.
• Conducted general requirement gathering activities for improvement of business process flow and business functionalities by researching and documentation of existing business process (Design Documents).
• Reviewed and verified technical specification to meet user requirement and approved architectural and design documents.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and created technical design documents.
• Part of Dimensional Modeling Team (Dimensional Modeling Techniques, Facts, Aggregation, conformed dimensions, Keys.
• Created Dashboard by usingTableauclient designer
• Designed Business Objects Universes and designed security for the Business groups.
• Designed functional and Technical Business object security model using Business structure.
• LOV’s, aggregate awareness, Implementation of aliases, contexts, resolved loops and traps.
• Worked on charts, filters, drill reports, linked reports (Open doc/Hyper linking through interactive reporting), sorting, sectioning, alerting, ranking, complex report formatting using various WEBI formulas, scheduling reports, profiling and publications thru CMC.
• Extensive data validation and testing reports using SQL.
• Developed Project life cycle documentation and User guide documentations.
• CreatedCrystal Reports,TableauandPredictive Analysis reports (BOBJ), as peruser requirements.
• Responsible for Data Collection and Preparation. Created BPC Data Model such as Application and Dimensions.
• Configured Data Manager Extraction from ECC and BI system for the actual, plan data in BPC 7.0
• Conduct overview analysis of the BPC system to monitor daily loads and reloading as needed.
• Developed web intelligence reports for Different business Tracks and involved in performance tuning.
• Integrating SAP NetWeaver with MOSS 2007 for Enterprise Content Management
• Created views and wrote complex T-Sql queries which are used as source for Datamart ETL
• workflows/Packages and SSRS reports.
• Generated different reports such as parameterized, cascading, drill down and drill throughreports using SSRS.
• Created packages to support FTP/SFTP processes using SSIS to sendreceive files from differentclients.

Environment: Business Objects BI4X (SIA/ Central Management Console, Information Design Tool (IDT), Universe Design Tool (UDT), SAP BW 7.2, BW Query Designer, BO Analysis, Interactive Analysis, Web Intelligence, Information Design Tool, Dashboard Design tool, Tableau, Performance Manger, Oracle 10g, SDQL Server 2005, Toad.

Confidential, NJ

Sr. Business Objects Developer/ Administrator

Responsibilities:

• Installed and configured Business Objects XI 3.1 on Windows platform.
• Designed and validated universe from multiple data sources with SAP BI4 Information design tool.
• 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.
• Creating standard full client reports and WebI reports.
• 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.
• Documented BI launch pad guide for users to explore new features.
• Involved in migration and deployment of the universes and reports across multiple domains.
• Created Dashboards using SAP BI4 Dashboard Design tool.
• Conversed .UNV universes to .UNX universes.
• Maintained security and rights for the Users and distributed to reports to user inboxes. 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.
• Maintaining and Troubleshooting of Business Objects Enterprise Objects Enterprise Servers and clustering.
• Setting up and Configuring Business Objects Servers like job servers and FRS.
• 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.
• 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.
• Migrated all current XI R2 prod business applications to BO XI 3.1 on DEV box, testing in progress.
• Expertise in deploying/elevating applications to UAT and Production.
• Maintaining current Business Objects Enterprise XI 3.1 Development/ Test and Production environments.
• 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.
• Scheduled SQL agent jobs and SSIS packages which process the cubes on completion of theETL.
• Optimized existing SSIS packages to run faster.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize.
• 24 X 7 production support.

Environment: Business Objects BI4/3.1 (SIA/ Central Management Console, Designer, Web Intelligence, Publishing, Migration and Schedule wizards), Crystal Reports, Oracle 9i,10g, SQL, SQL Server, TOAD, Windows 2000/2003/2008.

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.
• 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.
• 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.
• Creating standard full client reports and WebI reports.
• 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.
• 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 Unix 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.
• 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.
• 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:

• 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.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.
• Expertise in taking cold and hot backups of business objects repository and content as well.
• Successfully tested the DR in remote place.

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.
• 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.

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 Loaded etc.
• 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.
• 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, Web Logic Server 10.0.

Confidential, GA

Business Objects Developer

Responsibilities:

• Performed report requirement gathering
• 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