SUMMARY:

• A dedicated SAP-Business Objects Admin/Architect and Technology Leader with more than a decade of strong SAP-Business Objects Enterprise Development, installation, configuration, maintenance and management experience in a customer focused environment.
• Also an active ASUG Americas' SAP Users' Group member for Illinois, Michigan and Ohio chapters when time permits and a member of SAP Business Objects Business Intelligence Platform Influence Council.

PROFESSIONAL SUMMARY:

• More than 12 years of experience in all-round Software Development includes server installation, configuration and maintenance migration, upgrade, patching , Universe Design, Canned and Adhoc Reporting, Performance tuning, Maintenance, Enhancement and Production Support of complex universes and canned reports using SAP service marketplace to download SAP-BO products and SAP BI/BOBJ/BW suite of products, Tableau software, Every Angle, BW on HANA, SAP HANA administration and mainframe system.
• Core competencies include SAP BI 4.0, BUSINESS OBJECTS XI R3.1, BUSINESS OBJECTS XI R2, BUSINESS OBJECTS 6.5, SAP ECC6.0, BW 7.3, CR XI, CR 2008, CR 2011, CR Enterprise, Xcelsius, dashboards, QaaWS, IDT, UDT, Report Conversion Tool, WebI Rich Client, BODS, TABLEAU client and server, Every angle client and server, BW on HANA, HANA administration, JAVA Basics, .NET fundamentals, OS/390, MVS, COBOL, JCL, NATURAL, ADABAS, DB2, Informix, VSAM, TERADATA, SQL SERVER 2000, SQL SERVER 2005, SQL SERVER 2008, SAP BW, CICS, COMPARX, ENDEVOR, EXPEDITOR, FILE-AID, INFOMAN, PLATINUM, SUPER-C, VIASOFT, INFORMATICA, ERwin, Remedy, BMC Patrolling, TM ART, MS SourceSafe, Test Director, HP quality center.
• Service packs and hot fix installation, server maintenance for SAP BI, BOBJ, Tableau and Every Angle.
• Good understanding of SEI-CMM software quality practices and processes.
• Experience in Installation and configuration of SAP-BI4.0, SAP BW BOBJ Integration, SAP-BOXI r3.1, BOXI R2 with different service pack upgrades , Tableau and Every Angle on both windows and Unix environments.
• Experience in migration of SAP-BOXI 3.1 SAP BI4.0, BOXI R2 to SAP-BOXI 3.1 and BO 6.5 to BOXI R2.
• Universe and report migration for SAP BI.
• Experience in creating different security models close and open ended for SAP BI, Tableau and Every Angle.
• Managing Business Objects securities at all levels Row level, Column Level, Folder level, Group level, user level, application level and at Report level . Managing Business Objects users, user access rights. Full versed on explicit access and access by inheritance.
• Managing Tableau and Every Angle Securities at all levels.
• Created info-cubes, DSO, and multi providers.
• Created maintained info Objects, custom data sources, transformations and DTP's
• Created new queries and changed the existing queries using BEx Analyzer
• Modified Process Chains and developed new Process Chains
• Maintained transformations, staging cubes and open hubs for the interfaces to feed the data to BPC application
• Was part of the BW on HANA Migration project
• Worked on BW part of the migration which included migration of data flow from BW 3.5 to BW 7.3
• Involved in full-load and delta-load data extraction to the BW system from SAP R3 systems.
• Trained on HANA administration SAP HANA 200 and working as a stand by HANA administrator.
• Creating and maintaining Windows AD/NT groups, importing groups to Enterprise and mapping groups to folders.
• Experience in managing SQL server 2005 and 2008 databases, creating and maintaining users and their access rights, performing routine validation of user access rights from time to time
• Experience using SQL Query Analyzer for SQL server 2000 and SQL server management studio for SQL server 2005 and 2008 , SQL Developer 3.0 for Oracle 10 and 11 for SQL creation, execution and performance testing.
• Involved in creating, debugging and execution of stored procedures, Views, SSIS packages and its deployment.
• Involved in scheduling jobs using SQL server Agent to automate SSIS package execution.
• Involved in nightly loads by loading different databases from different applications.
• Monitoring the servers for CPU, I/O usage thru NAGIOS, BMC Patrolling, TM ART, 3rd party tools and thru SQL server activity monitor.
• Experience in Performance tuning of Business object Applications.
• Experience in Developing, Updating and Distributing of Universes using Business Objects. Strong knowledge of Star Snow Flake schemas.
• Experience in Business Objects Full-Client Desktop Intelligence , Web Intelligence, Universe designer, Information Design, dashboard Designer, QaaWS, Tableau Client and server, Every Angle Client and server tools.
• Experience creating Tableau Views using extracts and live data and publishing it to the Tableau server.
• Managing Tableau sites, Projects etc.
• Experience configuring and managing Every Angle servers and report migration and validation post migration.
• Involved scheduling Every Angle Daily, Weekly and on-demand loads and RFC configuration.
• Experience rolling out Tableau and Every Angle Client to end users using Citrix and App-V.
• Experience in retrieving data using Business Objects Universes, personal data files and stored procedures.
• Worked on Web Intelligence Webi to develop and publish thin client reports. Created standard Crystal reports.
• Working on incidents thru Remedy.
• Tracking defects using HP Quality Center.
• Created Dashboards from Excel Sheet, using Query As Web Services QaaWS and Live Office. Exporting dashboards to Business Objects Enterprise.
• Integrating Sharepoint and iView portals with BI4.0.
• Experience in Quality testing of the Business Objects reports as per report standards.
• Involved in SAP BI integration with Business objects XIr2 and BOXI r3.1.
• Involved in creating Universes based on BEx Queries and created WEBi reports from these universes and using BICS in BI4.0.
• Involved in creating Dashboards and xcelsius reports from BEx Queries.
• Overall well versed with SAP-Business Objects Adminstration, Universe designing, Report writing, and Maintenance of various reports using SAP BI4.0, BOXI R3.1 and Business Objects 6.x.
• Domain knowledge in Retail, Banking Financial Services, Insurance, Health Care and food services Industries.
• Technical Lead with extensive expertise in developing and leading Enterprise level software development projects using stringent SEI CMMI Level 5 and SIX SIGMA quality metrics.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

EXPERIENCE:

Sr. SAP Systems Engineer

Confidential

• Coordinated with Windows and Network team to setup the new BI4.0 landscape Sandbox, DEV, QA, ALT and PROD
• Coordinated with the Procurement team to evaluate CAG's future reporting need and obtaining licenses.
• Installed SAP BI4.0 SP4 in all the landscapes and clustered BOBJ servers for load balancing.
• Configured Windows Authentication, SSO, SAP authentication, SAP Role Mapping and BOBJ certification over BW.
• Involved in SQL server and Oracle client installation for nonSAP data in SAP BI servers and CITRIX machines.
• Installed client tools Information Design Tool, Universe Design Tool, CR 2011, CR enterprise, Data Federation Administration Tool, QaaWS Designer, Report Conversion Tool, WebI Rich Client and Live Office in CITRX Boxes.
• Involved in horizontal and vertical scaling of the environment splitting BOBJ servers/Services across the landscape for better performance.
• Involved in different services provided by SAP such as TIK, SMA Solution Management Assessment , SIZING, BPPO and VTO Volume Test Optimization exercises as a part of Performance management and capacity planning and to make sure the newly built system is stable, robust and well performing and can sustain CAG's future growth.
• Utilizing the new monitoring tool for better monitoring of our BI4 servers apart from BMC Patrolling tool and TM ART.
• Use REMEDY for incident management and HP Quality center for Defect tracking.
• Evaluating the Version Management tool in CMC for better change control of report modification.
• Involved in RoamBI ES4 mobile BI installation and configuration for BI4.0.
• Involved in Disaster Recovery plans for new BI4 environment.
• Configuring Wily Introscope, a monitoring tool SAP recommends using for better trouble shoot of different BOBJ issues.
• Involved in Installation of Analysis for Office 1.2 and patches and Analysis for OLAP 1.2 and Patches .
• Evaluating the possibilities of using HANA models for reporting.
• BOBJ3.1 to BI4 Migration/Upgrade:
• Working as a lead in migrating Contents from 3.1 to BI4.0 SP4
• Coordinating with ERP Security in re-defining security in new BI4.0 landscape. Created close ended security model for BI4. Imported SAP roles to BI4.0 SP4.
• Involved in migration strategy of CIL system, CAG's old BOXIr2 to BI4.0.
• Created PID Project Initiation Document . Created C-Projects using SAP's Resource planning tool and added capacity demand to projects. Followed up with Resource managers to line up their resources for user validation.
• Involved in project negotiation and approval at director's board meeting.
• Followed the ADKAR Awareness, Desire, Knowledge, Ability and Reinforcement model for change management. Communicated to Business/department owners and making them aware of the changes coming in and making sure their teams adapt it.
• Used the audit universe to find the Report usage and then coordinate the customer facing teams to define what to migrate.
• Used Upgrade Management Tool to migrate contents Universes, Crystal and Webi Reports, connections, Dashboards, QaaWS from both SAP IDD and nonSAP BOBJ3.1 to BI4.0 in phases.
• Involved in post migration validation View-on-demand, scheduled instance and data compare etc. .
• Used Promotion Management Tool LCM in BI4 SP2 to Promote objects between BI4 SP4 Landscapes Sandbox, DEV, QA, ALT and PROD .
• Working as a point of contact for our offshore resources.
• Working with SAP support engineers from different regions, back office and TQM Technical Quality Manager to fix BI4.0 post migration issues.
• Training customers of the new features available in BI4.0 and Coordinating UAT effort and fixing issues from time to time.
• Involved in defining the new BICC at ConAgra.
• Involved in Share point and iVIEW portal integration with new BI4.0
• Interactive Visualization Tableau Installation:
• Worked with CAG's Architecture review board for Tableau landscape approval and implementation.
• Coordinated with Windows and Network team to setup the new Tableau landscape DEV and PROD
• Coordinated with the Procurement team and Tableau negotiating licenses.
• Installed Tableau8.0 in all the landscapes and clustered for load balancing. Configured Windows Authentication and SSO.
• Installed different necessary drivers in the servers.
• Worked with App Hosting team for Tableau client installs. Used App-V for tableau client Install.
• Utilizing BMC Patrolling tool for better monitoring of Tableau servers.
• Involved in Disaster Recovery plans for new Tableau environment.
• Defined CAG process for obtaining Tableau client licenses and server access.
• Evaluating the possibilities of using HANA models for reporting.
• Every Angle Reporting Tool Installation Configuration:
• Worked with CAG's Architecture review board for Every Angle landscape approval and implementation.
• Coordinated with Windows and Network team to setup the new Every Angle landscape DEV and PROD for RQI and separate the environment from the rest of the enterprise.
• Coordinated with the Procurement team and Every Angle negotiating licenses.
• Installed Every Angle 2012 SP3 in all the landscapes. Configured the RFC connections. Configured the tables and fields.
• Worked with App Hosting team for Every Angle client installs. Used App-V for Every Angle client Install.
• Migrated the RQI specific EA reports to new environment.
• Utilizing BMC Patrolling tool for better monitoring of Every Angle servers and hard drive usage as EA is very space consuming.
• Involved in Disaster Recovery plans for new Every Angle environment.
• Moved tables to HANA for better data load performance.
• BW on HANA Migration and BW Maintenance:
• Worked as a part of BW on HANA implementation and cutover. Responsible and a point of contact for SAP BI validation.
• Responsible for making necessary changes to SAP BI platform including BOBJ and Data Services and making the system ready for validation.
• Worked as a validation lead and coordinated with Customer facing teams validating their reports in new BW on HANA system. Reported testing status to the management on a daily basis.
• Created info-cubes, DSO, and multi providers.
• Created maintained info Objects, custom data sources, transformations and DTP's
• Created new queries and changed the existing queries using BEx Analyzer
• Modified Process Chains and developed new Process Chains
• maintained transformations, staging cubes and open hubs for the interfaces to feed the data to BPC application
• Was part of the BW on HANA Migration project
• Involved in full-load and delta-load data extraction to the BW system from SAP R3 systems.
• HANA Administration:
• Attended company sponsored HANA administration Training SAP HANA 200 from SAP.
• Working as a standby HANA administrator for my team.
• We are still implementing HANA. Future roll will be defined soon.
• BOBJ3.1 Maintenance:
• Involved in Performance enhancement of BOBJ3.1. Re-defined the maintenance procedure and splitting of services for better performance. Setting up instance limits for different environments.
• Involved in creating Control-M jobs for creating scheduled instances for BOBJ host server reboots.
• Managing existing contents from time to time.
• Managing Business Objects securities at all levels Row level, Column Level, Folder level, Group level, user level, application level and at Report level . Managing Business Objects users, user access rights. Full versed on explicit access and access by inheritance.
• Defining/maintaining SQL server ODBC, OLEDB etc , Oracle client and SAP Driver connections and TNS Entries.
• Involved in Performance management reports and dashboards creation, using Xcelsius 2008.
• Publishing Crystal reports and Web Intelligence reports.
• Involved in Win AD authentication and SSO Single Sign On .
• Involved in WAR file and BIAR file recovery.
• Customization of different JSP files based on requirements.
• Involved in INFOVIEW Customization.
• Report/universe performance validation before deployment.
• Involved in reports and universe migration to different environments and providing Implementation/post Implementation Support.
• Work experience in BW, SQL server 2005 and 2008, Oracle 10 and 11 databases.
• Experience using SQL Query Analyzer and SQL server management studio and Oracle SQL Developer 3.0 for SQL creation, execution and performance testing.
• Monitoring the servers for CPU, I/O usage thru BMC Patrolling, a 3rd party tool and sending advance notification incase issues.
• Providing Primary On-call support on a 24 7 basis.
• Supporting Every Angle reporting environment as an administrator and responsible for performance tuning of the system.
• Trained on SAP HANA.
• Involved in designing Business Objects Universes, Queries, and Reports. Well versed on resolving loops using contexts and aliases to remove the cyclic dependencies, functions like select, prompt and where to write flexible SQL queries, Multi-Level Scope of Analysis using drill down, drill across, drill up, slice and dice, Cascading Prompts, Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts, and Query Prompts.
• Involved in Webi, crystal reports creation, report performance tuning.
• Created Dashboards from Excel Sheet, using Query As Web Services QAAWS and Live Office and exporting dashboards to Business Objects Enterprise.

EXPERIENCE:

SAP-BI BUSINESS OBJECTS ADMIN/ARCHITECT

Confidential

• Involved in Installation and configuration of SAP-BOXI R2 with different service pack upgrades and SAP-BOXI r3.1 with different service pack upgrades on both Windows and Unix environments.
• Involved in SAP-BOXI R2 to SAP-BOXI r3.1 upgrade.
• Creating and maintaining Windows AD/NT groups, importing groups to Enterprise and mapping groups to folders.
• Involved in creating different security models open ended and close ended , managing Business Objects securities at all levels Row level, Column Level, Folder level, Group level, user level, application level and at Report level . Managing Business Objects users, user access rights. Full versed on explicit access and access by inheritance.
• Defining/maintaining the necessary ODBC Driver connections.
• Involved in designing Business Objects Universes, Queries, and Reports. Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Worked extensively with functions like select, prompt and where to write flexible SQL queries.
• Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up, slice and dice.
• Worked extensively with the major functionality of BO like Cascading Prompts, Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts, and Query Prompts.
• Created standard Web Intelligence reports.
• Involved in ad-Hoc Queries and reports using Business Objects Suite.
• Involved in crystal reports creation, report performance tuning.
• Involved in Performance management reports and dashboards creation, using Xcelsius 2008.
• Created Dashboards from Excel Sheet, using Query As Web Services QAAWS and Live Office and exporting dashboards to Business Objects Enterprise.
• Publishing Crystal reports and Web Intelligence reports.
• Involved in Win AD authentication and SSO Single Sign On .
• Involved in WAR file and BIAR Business Intelligence Archive Resource file recovery.
• Customization of different JSP files based on requirements.
• Involved in INFOVIEW Customization.
• Report/universe performance validation before deployment.
• Involved in reports and universe migration to different environments and providing Implementation/post Implementation Support.
• Trained the Business Users in report creation, creating and interpriting universes and also new features of Business Objects XI.
• Experience in managing SQL server 2005 and 2008 databases, creating both Windows and SQL server user accounts and maintaining their access rights, performing routine validation of user access rights from time to time.
• Experience using SQL Query Analyzer for SQL server 2000 and SQL server management studio for SQL server 2005 and 2008 for SQL creation, execution and performance testing.
• Involved in creating, debugging and execution of stored procedures, Views, SSIS packages and its deployment.
• Involved in scheduling jobs using SQL server Agent to automate SSIS package execution.
• Involved in nightly Data Warehouse loads by loading different databases from different applications.
• Monitoring the servers for CPU, I/O usage thru NAGIOS, a 3rd party tool and thru SQL server activity monitor.
• Preparing component design documents, Application design documents, unit integration test plan and unit integration test script.
• Unit testing, Regression testing of canned reports, ad-hoc reports and Universe as per the client request and turnover of reports and universe.
• Providing Primary On-call support on a 24 7 basis.
• BO V6.5 to BOXI R2 Migration:
• Gathering Requirement, Analysis, Setting up Dev. / UAT and Production server.
• Installed and configured Business Objects XI Suite. Created Pre-Migration Assessment for all departments and Identified Reports Complexity.
• Implemented securities at all levels Row Level, Column Level, Report, Folder Level and Group Level
• Migration of Canned Reports/Universe/Personal Documents/Inbox
• Implemented Single Sign on and Windows AD Authentication. Implemented SSL layer on production environment
• Handled Incremental Migration for various departments of Aetna.
• Handled parallel production of BO V6.5 and BO XI R2, eventually decomposing BO V6.5.
• Customized Infoview as per user requirement.
• Created, modified/maintained Products Universe.