We provide IT Staff Augmentation Services!

Resume

Sr Sap Systems, EngineeR

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.

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

SKILLS:

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.

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 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. 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.
  • 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.
  • 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.
  • Attended company sponsored HANA administration (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.
  • 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.

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

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.
  • Worked with external auditors like Deloitte & Touché to successfully complete several IT audits for Met-Life VRPS team on time.
  • 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

Hire Now