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.
• 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, 3 rd 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.

PROFESSIONAL EXPERIENCE

Sr. SAP Systems Engineer

Confidential

Responsibilities:

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

SAP-BI BUSINESS OBJECTS ADMIN/ARCHITECT

Confidential

Responsibilities:

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

TECHNICAL LEAD / SENIOR DEVELOPER

Confidential

Responsibilities:

• Interacted with Business Owners to know their Business views in creating/modifying Reports accordingly.
• Initiated DBA interactions for resource requirements and modifications.
• Re-designed/re-defined enterprise security model (close ended/open ended security model).
• Managed Business Objects securities at all levels (User and content management at Folder level, Group level, user level, application level and at Report level).
• Managed data access by applying Row level, Column Level securities at universe level.
• Managed/maintained Business Objects users, user access rights. Full versed on explicit access and access by inheritance.
• Modified the universe, created classes and objects by retrieving the data from various data sources.
• Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts, and Query Prompts . Involved in designing Business Objects Queries, and Reports.
• Worked extensively with @functions like @select, @prompt, @where and @aggregate aware to write flexible SQL queries.
• Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up and slice and dice.
• Created standard Desktop Intelligence and Web Intelligence reports.
• Involved in ad-Hoc Queries and reports using Business Objects Suite.
• Improved report response time by tuning BO queries.
• Constantly worked on complex reports providing for a report generation based on user needs.
• Preparing Technical design documents, unit & integration test plan and unit & integration test script for quality assurance.
• Unit testing, Regression testing of canned reports, ad-hoc reports and Universe as per the client request and migration of reports and universe to different environments.
• Providing Quality Assurance testing and User acceptance testing support and Implementation Support. Providing Primary On-call support on a 12*7 basis.

TECHNICAL LEAD / SENIOR DEVELOPER

Confidential

Responsibilities:

• Analyzing the Design Specification and Feasibility study. Interacted with Business Owners to know their Business views in creating/modifying Reports accordingly.
• Preparing component design documents, Application design documents, unit & integration test plan and unit & integration test script.
• Initiated DBA interactions for resource requirements and modifications. Defining the necessary ODBC Driver connections.
• Experience in Installation, configuration and maintenance of BO 6.5 and BOXI R2 (with different service pack and fix pack upgrades).
• Experience in migration of BO 6.5 to BOXI R2. User and content migration and security redesign at new destination server.
• Experience in creating different security models (close ended and open ended).
• Re-designing/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.
• Involved in Windows AD (kerberos)/NT (NTLM)/LDAP authentication and SSO.
• Created universes, classes and objects by retrieving the data from various data sources.
• 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 and 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 Full client (DeskI) reports and WebI reports and standard Crystal reports .
• Involved in ad-Hoc Queries and reports using Business Objects Suite.
• Improved report response time by tuning BO queries.
• Unit testing, Regression testing, System testing of canned reports, ad-hoc reports and Universe as per the client request, tracking defects in Test Director, and defect closure and turnover of reports and universe.
• Involved in report migration to different environments and Providing Implementation/post Implementation Support and warranty support.
• Involved in SAP BI integration with Business objects XIr2.
• Involved in creating Universes based on BEx Queries and created WEBi reports from these universes.
• Involved in creating Dashboards and xcelsius reports from BEx Queries.
• Created info-cubes, DSO, info-sets and multi providers.
• Involved in full-load and delta-load data extraction to the BW system from SAP R3 systems.
• Resolving post production NIR’s and production abends thereby giving permanent fixes for the Post Production Issues.
• Providing Primary On-call support on a 24*7 basis.
• Involved in collecting evidences for SOX (Sarbanes Oxley) Testing for Met-Life VRPS team.
• Involved in Quality Audits, preparing DP (Defect Prevention) and Monthly matrices, weekly and monthly status reports. Involved in Project related Communication between Onsite and Offshore by attending Status meeting, participating in QI’s, Leading teams at different levels.
• Participating actively in the knowledge transition sessions between onsite and off-shore, understanding the system. Participating actively in the questioner sessions and sharing knowledge on Banking and other Domains.
• Tracking the production abends occurring frequently and analyzing those abends so as to minimize its occurrence in production region.
• Analyzing the abend log for previous abends and making a good understanding of it.
• Helping the offshore team to prepare a well-versed production support schedule so as to minimize the overburden on individuals.
• Trained Business Users from time to time in report creation, Universe design and also new features of Business Objects XI.
• 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
• Developed transformations, staging cubes and open hubs for the interfaces to feed the data to BPC application
• 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.
• Generic data extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring Performance tuning and extracting