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
• 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 SKILLS:

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 DesignerDatabases: 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

EXPERIENCE/PROJECT WORK:

Confidential, Pittsburgh, PA

SAP BODS Senior Developer/ Admin

Responsibilities:

• 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, St Louis, MO

SAP BO Admin/ Senior Developer

Responsibilities:

• Created BOBJ 4.1 Cut over Steps document to and 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, St Louis, MO

SAP BO Admin/ Developer

Responsibilities:

• 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 and 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, Peoria, IL

SAP BODS Developer/Hana Developer

Responsibilities:

• 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

Confidential, Los Angeles, CA

BODS/BO Lead Developer

Responsibilities:

• Downloaded and installed SAP BO 4.0 SP5 server & Client tools
• Downloaded and installed SAP BODS 4.0 and integrated with SAP BO 4.0
• Installed BOBI Crystal, Business Objects Explorer, Dashboard Designer FP3, SP2 Patch 11
• Involved in User Management, creation of Roles, and assigning Privileges to users and user groups
• Involved in supporting the administration team for upgrading SAP BI to BW 7.3
• Configured SSL, SSO using LDAP and SAP, Sync SSO and LDAP and Data SSO using SAP
• Created Prototypes in IDT, UDT, Dashboards, WebI document, Business Explorer and some extractions in Data Services
• Migration done from DEV to TEST and planning to go LIVE on third week of March
• Created documentation for installation, integration, configuration and deployment
• Created universes on top of Datamarts for AGDM, HGDM, Commercial and Claims applications
• Created Webi reports for AGDM, HGDM, Commercial and Claims applications and tested them thoroughly
• Created Infospaces using SAP BW relational universe developed in IDT along with Oracle and SQL Server db’s
• Created Queries using BEx Web Application from BI Launchpad and deployed directly in WebI
• Defined and designed KPI’s and Metrics and then developed four dashboards using BI Services in Dashboard Designer
• Worked and managed full projects from planning to delivery in SAP BO environment
• Worked as an developer & lead developer for multiple projects across different environments and groups in Farmers
• Fine tuning the performance of Servers, Universe and reports
• Involved in creating installation, migration, upgrade documents for future s
• Created BICS connectivity based WebI reports in SBOP BOBI 4.0 to connect direct BW Queries
• Created BW based relational multi source universes in 4.0 with Oracle and some flat files
• Created WSDLs using web service query, Web Service connections
• Created Merged Queries using Information Design Tool
• Created and maintained BEx Queries as per the BO reporting Needs
• Created dashboards using BICS connectivity and also used Query builder from Universe
• Created BO 4.0 Cut Over Steps document to and purpose
• Worked with a team to install and configure BO 4.0(CMC & Audit Database), Explorer on Windows 2008 Server R2 and SQL Server 2008 R2
• Installed and Configured Business Objects Data Services with SAP BO, BW, SAP R3 and SQL server database
• Used Business Objects Data Services as an ETL tool to extract the data from the Legacy systems
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from source to Target
• Created various transformations and cases to clean the data
• Installed & configured BO Data Services 4.0 in Development & Production Server
• Prepared the functional mapping to CREMAS, DEBMAS, MATMAS IDOC’s and prepared GAP analysis.
• 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 WEBI reports to generate the status of IDOCs using SQL Server database (repository tables)
• Moved the jobs into QA and production
• Created various transformations and cases to clean the data
• Maintain different Databases in data sources of SAP Business Objects Data Services
• Used SAP and Non SAP systems to pull the data using SAP Business Objects Data Services
• Maintained different Databases in data sources of SAP Business Objects Data Services
• Used SAP and Non SAP systems to pull the data using SAP Business Objects Data Services
• Installed and configured Business Objects Single Sign-On (SSO) with Active Directory
• Created various complex universe (UNX) on the Multi-Source and migrated exist UNV to BO 4.0
• Used Workspaces to seamless connectivity to reports throng advanced content linking
• Created Xcelsius Dashboard with direct access to universes, OpenDoc, Live Office
• 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

Environment: BODS 4.0, Business Objects 4.0 SP5, SP4/ FP3 / SP2, BO XI 3.1 SP2, SP4,SP5, Xcelsius 208, BOBJ Dashboard Designer, Crystal 2008, IDT & Universe designer, WebI Rich Client, Desktop Intelligence, BI Launchpad, CMC, ECC 6.0, BI 7.0, BO Explorer, Analysis Edition for OLAP & Office, BEx Query Analyzer, BEx Query Designer, Toad, HP QC, SAP BODS, Windows 2008 Server R2, Windows XP Professional, Ms Office, MS Access, SQL Server, Oracle, DB2, SQL, Lotus Notes

Confidential, Newbery Park, CA

Business Objects Admin

Responsibilities:

• Downloaded and installed BOBJ XI r3 patch 7
• Downloaded and installed BOBJ XI r3P 2 Patch 7 Client tools
• Installed BOBJ XI r3, Client Tools
• Involved in Analysis, Design, Development and Deploying reports into production environment
• Designed and Developed relational Universes and tested them
• Created reports using Webi Richclient and tested them
• Updated existing Webi reports as per the requirement changes
• Configured all the above applications each other
• Configured SSO using Windows AD
• Created Prototypes in UDT, WebI document, and some extractions using Data Integrator
• Migration done from DEV to TEST to SBX
• Created documentation for all the steps

Environment: SAP BOBJ XI R3, Client Tools, Business Object XI 3.1 SP2, Data Federation 3.0 SP2 pack 1, CMS, Designer, Universe Design Tool, Web Intelligence XI 3.1, Desktop Analytic tool, LCM, BO Advanced Analytics 1.0, Desktop Intelligence, WebI Rich Client, Data Integrator, MS Access, MS Excel, Oracle

Confidential, Phoenix, AZ

Sr. Business Objects Sr. Developer

Responsibilities:

• Installed BO Supervisor, Designer, and Reporter at all of the work stations and involved to setup the WebI on UNIX environment
• Created BO setup architecture for BO XI R1 in Development as well as testing environments
• Created and monitoring BO Users among the different groups
• Created and monitoring different domains for each of our customer (say for Zions Dev and Zions Int and Zions Pro, For FMB FMB Dev, FMB INT and FMB Pro) and giving support to transfer our production universes to their production servers
• Evaluated Business Objects & Cognos products for M&I 401 EDW projects
• Developed a Single Sign on application for the M&I Trust (A 401K online service using BO and WEBI), Involving with the DB team for the creation of database to support user access and their roles
• Created a Big universe recently with the 22 Facts and more than 2100 objects and giving support to the offshore team at their development phase
• Used Derived tables in Universe to club six universes into a single universe
• Created User document design templates, Technical Specs document, Integration document for the onsite and offshore communication
• Gave to the Zions Business users, technical users and other users at the time of production installation
• Transferred reports from one dev to int, int to production and then our production to Client production

Environment: Business Object XI r1/r2, 6.5.1/6.5.2/6.1 b, Supervisor, Designer, Web Intelligence XI/6.5,Desktop Intelligence, Crystal Reports XI, Cognos 8, MS Access, MS Excel, Oracle9I, SQL, PL/SQL, Toad, Data stage, Metastage, Sync soft, Control M, Windows 2000/NT, Unix

Confidential, Hartford, CT

Business Objects Specialist

Responsibilities:

• Worked with Various teams & people around the company for the analysis of the multi-dimensional tables
• Proposed new schema for the BOUNCE Project in terms of Aggregation levels and involved in the creation of BOUNCE Snowflake schema
• Involved in the creation of CAPTURA Star Schema implementation
• Worked with Business People(TM, SM and DM) to analyze new reporting requirements and created report metrics to understand clearly
• Used Star Schema and Snow Flake Schema extensively in the NBSA and BOUNCE Projects
• Created Three Universes using SYBASE and Oracle Data Warehousing
• Designed and Developed Drilled Reports in Full Client as well as in Web Intelligence
• Created Contexts and Aliases for resolving Loops in the Universes
• Created and Monitored User groups from Supervisor
• Created SQL test scripts for the reports testing and analysis
• Involved in Enterprise Data Warehousing data testing, Data Validation & Statistical Data Analysis in Reports as well as Enterprise Data Warehouse (EDW) and prepared test scripts and solved the data issues with Data Warehouse team
• Created Thin client reports using WebIntellignece 6.1 and used extensively Multi block and chart reports, User defined calculations, Formatted export to Excel to pdf files, Report sorting and filtering etc
• Created Reports using Business Objects Enterprise 6.1
• Converted Bunch of Crystal Reports to the Business Objects full client and thin client reports
• Mentored all Crystal Reports Users to get familiar with Business Objects Universes/Reports
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts for creating Business Objects 6.1 reports
• Responsible for 24 X 7 Technical support / Application support for the end users using Remedy Applications And all other BO applications

Environment: Business Object 6.1/5.1.7, Supervisor 5.1.7, Designer 5.1.7, Broadcast Agent 5.1, Web Intelligence 6.1/2.7.2, Infoview 2.6.1, Crystal Reports 8.1.5/ 9,MS Access, MS Excel, Oracle9I, SQL, PL/SQL, Rapid SQL7.0.1, Remedy Action System, Remedy Managementt, Remedy Support and Windows NT