Profile

• Sr. SAP BODS/BOBJ Consultant with over 14 Years of IT Experience which includes over 10 years of BOBJ experience in Supporting, administering including BO Repository creation, migration, updating , Monitoring Business Objects, Web Intelligence and Broadcast Agent Server
• Over 7 years of experience with SAP BW/BI7.3,7.0 integration experience with SAP BO 4.1 SP2, 4.0 SP0, SP2, FP3 and SAP BO 3.X, and XI R2/R1
• Over 5 years of Hands on experience using SAP BO Data Services BODS as an ETL tools to load data from SAP ECC and Relational databases to Enterprise Data Warehouse
• Involved in Full life cycle analysis, design, networking, design, development and deployment of Business Objects reporting Applications with Web Intelligence WebI and Broadcast Agent
• 4 Full Life Cycle Implementation in BOBJ and 2 in BODS

BODS/BOBJ Experience includes:

• Worked for major SAP partners for their SAP BO 4.1, SAP BO 4.0, SAP BODS 4.1, SAP BODS 4.0 implementations in Ramp up as well as Go Live environments
• Implemented SAP BO 4.1 SP3, SP2 , SAP BO 4.0 SP5 Full install Upgrades in Sandbox, Dev, QA and Prod Environments
• Worked as an Admin/Architect/Senior developer role for SAP Business Objects customers using traditional BO SAP BO products and also worked on Subject Matter Expert in SAP BOBI 4.1/4.0/XI 3.X/ XI R2 products
• Extensive experience in previous SAP Business Objects products like Business Objects Designer/Information Design Tool/Supervisor/CMC/CCM /Web Intelligence/ WEBISDK/BOSDK/ Import Wizard/Upgrade Management Tool/ Life Cycle Manager/BO Explorer/Broadcast Agent /Info View/ Xcelsius/ Live Office/ QAAWS/ BO Auditor/Application Foundation / Crystal Reports X/XI/ and Business Objects XI R1/R2/R3/R4 and V3 in Intranet and Extranet Environments
• Hands on experience of installing the Business Objects Data Services 4.x and the Information steward 4.x
• Handled full Business Objects Suite All BO Products including BOBI 4.1 to BO 5.0 Installation Including WebIntellegence WebI , LCM, BO Explorer , BW Integration kit with Web Servers
• Integrated the Dataservices 4.0 to the frontend BO 4.0
• Experience in Data Quality and creating the cleansing packages
• Experience in SAP HANA Data Provisioning using SAP LT Replication Server SLT
• Involved in SLT replication process to bring data from SAP ECC system to SAP HANA
• Involved in requirements gathering and convert them into Design documents for creating the data models
• Involved in creating SAP HANA Information Models using HANA Design Studio for some of the SAP modules
• Implementation experience and knowledge of SAP reporting for different functional areas such as Finance, Supply Chain, IMWM, MM, and Sales
• Experience in SAP BW architecture Infocubes, Multi Providers, Infosets, DSO's
• Experience of creating User Interaction web page Reports Using WEBISDK WIBEAN , JAVA, JSP and IIS, Web logic, Web Sphere, Apache web servers
• Strong knowledge in Relational Data Modeling concepts Relational Data Sources , Database Design, Star schemas, Extended star schemas, Multi Dimensional Modeling OLAP Data Sources
• Industry experience includes: Semiconductor, Insurance, Financial, Manufacturing, Healthcare and Retail

Technical

• Reporting Tools: BO 4.1 SP3,SP2, BO 4.0 SP5,SP4, FP3, SP2, SP1/ XI R3.1/R3//XI R2/6.5, Webi,BOBJ Xcelsius, Crystal 2011/XI R2/CR 2008, BO Explorer, Alaysis for Office OLAP, Crystal Enterprise 10.0/9.0/8.0,Dashboard Design, Design Studio, Business Explorer, BEx Query Designer, BEx Query Analyzer, BEx Web application Designer,
• Databases: SAP HANA, Oracles 11g,10g/9i/8i/7.x, DB2, Teradata, WMS, IMS/DB, SAP BW, MS SQL Server 2005/2000
• Operating Systems: Windows XP/2008/2003/2000/NT, UNIX SUN Solaris, LINUX.
• Languages: SQL, T-SQL, PL/SQL, HTML, C, VB Script, ASP, JAVA. Visual Basic, .NET.COBOL,JCL,VSAM, REXX, C,C
• Web Servers: IIS, Apache, Tomcat.
• Tools/Packages: WF Dev Studio 7.x, SQL LOADER, DTS, SSIS, Erwin Data Modeler, MS Visio, TOAD, SQL Plus, Microsoft VSS, Rational Clear Case, Informatica, iSQL, MS Project, CA 7/CA 11 Scheduler and MS Office, HANA Design Studio.
• Data Modeling: ERwin 4.0/3.x
• ETL Tools: Data Integrator, SAP BODS 3.X,4.X, Informatica 8.4, and Data Stage,

Confidential

Role: SAP BODS Senior Developer/ Admin

Responsibilities/Deliverables:

• Involved in creating a Document to preserve the History for some of the SAP ECC tables and defined the process flow
• Created the datastores to connect to BPCS,JDE and ORACLE source systems and load into SAP ECC
• Installed the SAP best Practices, ATL files and worked on the AIO jobs
• Interacted with both legacy and Functional team to get the mapping to load the data in customer Master IDOC DEBMAS06
• Used the ABAP data flows to read data from the ECC and to load data into the BW
• Worked on the vendor master, customer master and material master IDOCS which are CREMAS, DEBMAS and MATMAS
• Worked on SRM and the FICO modules
• Installed global address cleansing and USA address cleansing packages
• Performed column, address, dependency, redundancy and uniqueness profiling
• Created validation rules and rule bindings for data profiling according to business requirements
• Performed CDC source level and target level transforms
• Used query, match, validate transforms and look up function for data integration purposes
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from various source to Target
• Created various transformations and cases to clean the data
• Installed configured BO Data Services 4.2 in Sandbox environment
• Used the SAP inbuilt AIO jobs for customer master, material master, vendor master
• Loaded SAP R/3 tables into staging area and by developing transformation according to the business rules requested by client loaded the data into target database
• Used ODBC connections extracted data according to requirements
• Interacted with both legacy and Functional team to get the mapping to load the data in customer Master IDOC DEBMA
• By referencing AIO CUSTOMER MASTER JOB, created the job to load into customer master segments
• Created Customer Master Data by using English North American Data cleansing and Query transform, USA non certified address cleansing, cleansed firm data using Match Transform
• Validated the Customer Master by using Validate, Merge transforms and lookup function
• To check the IDOC status Used WE05 transport code
• Created the Dashboards using Information Steward
• Moved the jobs into QA and production
• Created and monitor ticket status on a daily basis in Quality Center
• Created various transformations and cases to clean the data
• Maintain different Databases in data sources of SAP Business Objects Data Services

Environment: SAP BODS 4.2, BODS 3.2, Information Steward, ECC 6.0, SQL Editor, HP QC, Windows 2008 Server R2, Windows XP Professional, Ms Office, MS Access, SQL Server, Oracle, Lotus Notes

Confidential

Role: SAP BO Admin/ Senior Developer

Responsibilities/Deliverables:

• Worked as a Senior BO Admin, Developer for both SAP Non SAP based BO solutions
• Created BOBJ 4.1 Cut over Steps document to training and education purpose
• Worked with users closely to understand the Business requirements and recommended the BO tools as per the business needs
• Worked and managed full projects from planning to delivery in SAP BOBI environment
• Recommend strategies to improve performance and capacity of BI tools
• Defined BI standards, guidelines and best practices for business groups and technical teams
• Interacted with Data warehouse team to talk about the status of the daily loads
• Installed BO 4.1 SP3 in Dev environment
• Designed and developed distributed SAP BO Architecture for better performance and global needs
• Configured the APS server
• Designed and Dashboards in SAP BOBI 4.1 on the operational datamarts as part of the POC

Environment: BO 4.1 SP3, IDT Universe designer, WEBI, BI Launchpad, BO Mobile, , CMC, CCM, ECC 6.0, BI 7.3, Windows 2012 Server R2, Ms Office, MS Access, Microsoft Sharepoint, Redshift, Data stage

Confidential

Role: SAP BO Admin/ Developer

Responsibilities/Deliverables:

• Worked as a Senior BO Admin, Architect, and Developer for both SAP Non SAP based BO solutions
• Created BOBJ 4.1 Cut Over Steps document to training and education purpose
• Created and maintained project plan for migrating BO XI R3 to BO 4.1
• Worked with users closely to understand the Business requirements and recommended the BO tools as per the business needs
• Worked and managed full projects from planning to delivery in SAP BOBI environment
• Recommend strategies to improve performance and capacity of BI tools
• Defined BI standards, guidelines and best practices for business groups and technical teams
• Installed, migrated, upgraded from SAP BO XI R3 to BO 4.1 SP3 in all the SAP environments
• Installed All BO client tools as well as analysis tools like Analysis for Office, Design Studio
• Set up the BO Mobile server on a separate Node for better performance
• Solved lots of server performance issues and redesigned production lay out
• Designed and developed distributed SAP BO Architecture for better performance and global needs
• Mentored and trained full time resources for the ongoing support
• Created BICS based WebI reports , Dashboards in SAP BOBI 4.1
• Converted existing BEx workbooks into Analysis for Office workbooks and accessed them in SAP Design Studio to build dashboard
• Published the converted Analysis workbooks in BI Platform
• Configured SSL, SSO using LDAP and SAP, Sync SSO and LDAP and Data SSO using SAP
• Configured BO Monitoring using the Monitoring tool in CMC
• Installed Analysis for Office, OLAP, BO Explorer and Design Studio client as well as server based applications and scheduled the Analysis for Office Workbooks in BO Platform for end users
• Created Prototypes using IDT, UDT, Design Studio, WebI document, BO Mobile
• Migration done from DEV to TEST as well as production for all the BO content
• Created a list of BOBJ 3.x Objects to be moved to BOBJ 4.1
• Downloaded and Installed IBM DB2 i-series, Oracle Drivers on BO 4.1 platform Server, BO 4.1 Client tools and tested in DEV, QA
• Worked with a team to install and configure BOBI 4.1 CMC Audit Database , Explorer on Windows 2008 Server R2 and SQL Server 2008 R2
• Involved in coordination with Networking and infrastructure teams for the ongoing changes in the Network
• Used Fiddler and Splunk tools to troubleshoot the networking issues and identified the root causes for slowly running Crystal Reports
• Created BIAR File in BOBJ 3.x using Import Export Wizard for BOBJ 4.0 migration
• Use Upgrade Management Tool in BOBI 4.1 to migrate 3.x Objects
• Thoroughly tested all universes, reports, and connection after upgrade
• Worked On BI Launch Pad InfoView to create reports with high level user interface and Scheduled
• Scheduled automatically publishing for Crystal reports to a SAP portal KM Knowledge Management folder
• Provided technical support for existing Business Objects based reporting solutions, including the development of enhancement requests and defect resolution
• Installed a Web Tier for both static and dynamic content on Apache/Tomcat
• Addressed customer queries and issues in a timely manner
• Trained and mentored other team members on technical methods and procedures as required

Environment: BO 4.1 SP3, BO XI 3.1 SP7, BO Design Studio, Crystal 2008,2013, IDT Universe designer, WEBI, BO Explorer, BI Launchpad, BO Mobile, Analysis Edition for OLAP Office, BEX Query Designer, BEx Query Analyzer, BEx Report Designer, CMC, CCM, ECC 6.0, BI 7.3, Windows 2008 Server R2, Windows XP Professional, Ms Office, MS Access, Microsoft Sharepoint, SQL Server, Oracle, IBM i-series, DB2, SQL, Oracle 11G

Confidential

Role: SAP BODS Developer/Hana Developer

Responsibilities/Deliverables:

• Worked as a senior Developer, Admin and Architect for both SAP Non SAP based BO solutions
• Mentored and trained full time resources for the ongoing support
• Created Projects and maintain them using Management Console
• Created SAP HANA data models using SAP HANA Studio for some of the SAP module
• Created the information spaces using SAP BO Explorer tool
• Identified the better BO reporting tools for fulfilling the client requirements
• Involved in creating a Document to preserve the History for some of the SAP ECC tables and defined the process flow
• Created the datastores for the source and target applications
• Installed the SAP best Practices, ATL files and worked on the AIO jobs
• Interacted with both legacy and Functional team to get the mapping to load the data in customer Master IDOC DEBMAS06
• Used the ABAP data flows to read data from the ECC and to load data into the BW
• Worked on the vendor master, customer master and material master IDOCS which are CREMAS, DEBMAS and MATMAS
• Worked on Sales, MM, WM and the FICO modules
• Installed global address cleansing and USA address cleansing packages
• Performed column, address, dependency, redundancy and uniqueness profiling
• Created validation rules and rule bindings for data profiling according to business requirements
• Performed CDC source level and target level transforms
• Used query, match, validate transforms and look up function for data integration purposes
• Created Analysis workbooks using Analysis for Office and OLAP tools
• Created OLAP universes and build WEBI reports on top of the OLAP universe's
• Created relational universes on top of SAP BW Multi cubes and combined with existing SQL Server DB2 databases for multiple sources
• Involved in enhancing the current security model to meet the user needs and documented the process
• Involved in User Management, creation of Roles, and assigning Privileges to users and user groups
• Worked as an developer lead developer for MACH1 project across different environments and groups
• Involved in coordination with different teams of the same project for successful implementation of the project
• Interact with report developers, reporting power users and fine tune lot of OLAP based BO reports
• Scheduled automatically publishing for Crystal reports in the BI Platform
• Created a new folder structure to meet the user needs and applied best security model
• Provide technical support for existing Business Objects based reporting solutions, including the development of enhancement requests and defect resolution
• Trained and mentored other team members on technical methods and procedures as required

Environment: SAP HANA 1.x, BODS 4.0, BO 4.0 SP5/SP4/ FP3 / SP2, BO XI 3.1 SP5, BOBJ Xcelsius 2008, Dashboard Designer, Crystal 2008, IDT Universe designer, WebI Rich Client, Webi, Infoview, SAP HANA, CMC, ECC 6.0, BI 7.3, BO Explorer, Analysis Edition for OLAP Office, BEx Query Designer, BEx Query Analyzer, Windows 2008 Server R2, Windows 7, Ms Office, MS Access, SQL Server, Teradata, Data stage, Cognos, Oracle, DB2, SQL, Incident Management, Lotus Notes