SUMMARY:

• Seasoned and user focused Business Objects (XIR2/XIR3/BI4.X/Crystal Reports (2008/20011/2013/ SAP CR for Enterprise) Professional. Possesses wide ranging, progressive and advanced level experience as a Business Objects/Crystal Reports Developer to User/Application Support to a Business Objects Architect using best practices and best in class Customer/User Support
• ERP Reporting Solutions JD Edwards (JDE), SAP Business One, SAP ECC
• Extensive User experience
• Successfully authored, facilitated and customized user materials on Business Objects and Crystal Reports; on a weekly or bi weekly basis (introduction, intermediate and advanced level ) for Confidential, Confidential, HP Global and Confidential
• Business Objects Administrator - 10+years; latest version used is 4.2 - installation, configuration, managing and migrating content, APS, security user access, application/content access, facilitate user, development of user materials
• Central Management Console (CMC) - 10+ years; configuration and post implementation work using CMC; user and content management; managing BOBJ Licenses thru CMC - 10 years
• Consolidation/Migration projects on B.O 4.X Highlighted
• HP Global - approx. 80k users; from XI 3.1 to SAP BI 4.0
• Confidential - approx. 20k users;from XI 3.1 to SAP BI 4.1
• Microsoft Office
• Word/PowerPoint/MS Access/Excel
• Expertise with B.O, Admin Tools - CMC, Promotion Management, IDT, UMT, Dashboards, Designer, etc…
• SAP Dashboards/Xcelsius - 10 years; extensive dashboard visualization and development experience
• Web Intelligence - 10+ years; extensive Webi development experience with various relational database sources; development based on Universes BW queries and HANA views
• Advanced SQL Skills - complex stored procedures, triggers
• Excellent communication (effective oral and written), facilitation and interpersonal skills

TECHNICAL SKILLS:

SAP Business Objects/Crystal Reports/Visualization: Business Objects 4.0/4.1/4.2, XI r3, r2, r1, 6.5, CMC, CMS, SIA, Web Intelligence, UDT/IDT, SAP Business One, Data Services 4.2, 3.1; SAP HANA; Crystal Reports 4.1, 2013, 2011, 2008, XI; SAP Dashboards/Xcelsius 4.1, 2008, Lumira 1.30 (Visualization, Story), Design Studio (DS1.2 - DS1.6 SP3)

SAP System: FICO, CRM, BEx, ECC, BW, NetWeaver

Tableau (Visualization/Story): Tableau Desktop, Tableau Server

Languages: PL/SQL, SQL, Transact-SQL (T-SQL), JavaScript; Java, JSP, C, C++, HTML, DHTML, CSS, Python, Cobol

Databases: MS SQL Server 2014, 2012, 2008, 2005, 2000; Oracle 11g, 10g, 9i, 8, 7; Teradata, SAP HANA, MySQL, MS Access, SQL Anywhere, DB2, Sybase

Operating Systems: Windows Server 2012/2008/2003/ ; Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential

SAP BUSINESS OBJECTS REPORTS DEVELOPER

Responsibilities:

• Design/Create Web Intelligence report via JD Edwards (JDE E1) ERP financial data in SQL Server environment
• Collaborate with JDE Team to analyze JDE financial data and table structures to ensure database design/structure meet business reporting requirements
• Develop complex custom SQL Commands as needed per business requirements
• Provide report development support to users
• Provide maintenance for existing reports

Confidential, Houston, TX

LEAD SAP BUSINESS OBJECTS ADMINISTRATOR/DEVELOPER/ARCHITECT

Responsibilities:

• Performed 4.1 to 4.2 upgrade in Windows environment
• Develop customized BO JAVA SDK interface apps
• Develop SAP Business Objects universes using Universer Design Tool (UDT) and Information Design Tool (IDT)
• Conduct pre and post SAP Business Objects implementation assessments highlighting current state/future state sizing
• Design and create dashboards/visualization solutions using SAP Business Objects 4.1 Dashboards/LUMIRA 1.30/ Design Studio 1.5/1.6
• Design and create dashboards/visualization solutions using Tableau Desktop and Tableau Server
• Ongoing development of SAP Business Objects Best Practice assessment concepts and methods
• Develop complex SQL Server/Oracle/SAP BO Repository (CMS, Query Builder) queries
• Author assessment strategies that enhance ROI from SAP Business Objects investment
• Ongoing SAP Business Objects/BI 4.x application development
• Ongoing HANA development
• Developed SAP BOE platform/environment assessment concepts used in evaluating BOE system environments
• Performed 4.1 to 4.2 upgrade in Windows environment

Confidential, Chicago, IL

LEAD SAP BUSINESS ONE DEVELOPER

Responsibilities:

• Provided support for SAP Business One 9.0 (SAP B1) to end users on standardized and ad hocs reports
• Developed complex Crystal Reports and custom SQL Server DB Queries (SQL) for SAP Business One 9.0 (SAP B1) based finance reports
• Collaborated with end users to gather SAP Business One report requirements
• Designed and created business intelligence reporting/dashboards/rich visualization solutions using SAP Business Objects Web Intelligence/Dashboard/Lumira/Design Studio Tools, Tableau Desktop and Tableau Server
• Collaborated with end users to test and validate SAP Business One report data derived from SQL Server data sources

Confidential

SAP BUSINESS OBJECTS ADMINISTRATOR/ARCHITECT/LEAD DEVELOPER

Responsibilities:

• Provided Administrative/System Architect/User/Report Development support for SAP BO 3.1/4.1
• Installed SAP BO 4.1 in Windows environment
• Created Python programs to parse data files that sourced comprehensive daily success reports
• Provided HANA Administration
• Developed SAP Business Objects Web Intelligence Reports using HANA Views and HANA based Universes using Information Design Tool (IDT)
• Developed SAP Business Objects Web Intelligence Reports using SQL Server/Oracle/BW/BEx Queries
• Designed and created business intelligence reporting/dashboards/rich visualization solutions using SAP Business Objects Web Intelligence/Dashboard/Lumira/Design Studio Tools, Tableau Desktop and Tableau Server
• Created and managed Business Objects Data Services 3.1/4.2 Real-time and Batch Jobs (Projects, Workflows, Dataflows)

Confidential, Atlanta, GA

SAP BUSINESS OBJECTS ADMINISTRATOR/ARCHITECT/DEVELOPER

Responsibilities:

• Upgraded SAP Business Objects from XI 3.1 to SAP BI 4.1 in Linux/Windows environment
• Designed and created business intelligence reporting/dashboards/rich visualization solutions using SAP Business Objects Web Intelligence/Dashboard/Lumira/Design Studio Tools, Tableau Desktop and Tableau Server
• Developed customized interface apps using BO JAVA SDK
• Authored internal Enterprise Upgrade/Content Migration Guide
• Authored SAP BO 4.1 Enterprise Security Guide
• Conducted Sizing and Capacity Planning using best practice

Confidential

SAP BUSINESS OBJECTS ADMINISTRATOR/ARCHITECT/LEAD DEVELOPER

Responsibilities:

• Lead the way forward on best practice strategy for implementing resolution for SAP BO 3.1 Production performance issues.
• Develop customized BO JAVA SDK interface apps
• Performed assessment of current state of the SAP BO 3.1 Production environment that was used as point of to post implementation of resolution for SAP BO 3.1 Production perf issues
• Developed complex SQL Server/Oracle/SAP BO Repository (CMS, Query Builder) queries
• Developed High Level Project Plan for resolution strategy for BO 3.1 Production performance issues
• Developed Project Plan Activities with timelines for resolution strategy
• Developed various document templates to be used to supplement the resolution strategy for SAP BO 3.1 Production performance issues

Confidential

SAP BUSINESS OBJECTS LEAD SOLUTION ARCHITECT/LEAD DEVELOPER

Responsibilities:

• Provide trouble shooting/root cause analysis and resolution paths for reports/universes
• Utilize Information Design Tool (IDT) both convert unv universes to unx format
• Utilize Universe Design Tool (UDT) and Information Design Tool to create Universes
• Work with senior executives and regional managers to elicit standard report and dashboard requirements
• Developed requirement for reports/dashboards from XML, EDI, HL7 sourced data
• Adhered to HIPAA Standards
• Developed reports/dashboards from XML, EDI, HL7 sourced data
• Developed complex SQL Server/Oracle queries
• Designed and created business intelligence reporting/dashboards/rich visualization solutions using SAP Business Objects 3.1/4.1 Enterprise Client Tools, Tableau Desktop, Tableau Server
• Built Audit dashboards showing User/Report/Server Usage
• Develop Webi/Dashboards based on Relational (Oracle/SQL Server) data
• Build Dashboards using Xcelcius/BO Dashboards

Confidential, Atlanta, GA

SAP BUSINESS OBJECTS ADMINISTRATOR/ARCHITECT/LEAD DEVELOPER

Responsibilities:

• Performed Assessment of existing SAP Business Objects 3.1 Production environment
• Migration from XI 3.1 to SAP BI 4.1; approx. 20k users
• Authored, facilitated and customized user materials on Business Objects on a weekly or bi weekly basis (introduction, intermediate and advanced level )
• Developed Project Plan for implementing SAP BI 4.1 Installation/Upgrade/Migration Strategy
• Performed SAP BI 4.1 Installation of new Production and Test environments for Upgrade/Migration from Business Objects 3.1
• Developed customized interface apps using BO JAVA SDK
• Upgraded SAP Business Objects from XI 3.1 to SAP BI 4.0 in Windows Server 2012 environment
• Upgraded SAP BI 4.0 to SAP BI 4.1 in Windows Server 2012 environment
• Integrate SAP BI 4.0 to SAP BW 7.3
• Authored internal Enterprise Upgrade/Content Migration Guide
• Conducted Sizing and Capacity Planning using best practice
• Create User Access Levels (Security) using CMC
• Built Audit dashboards showing User/Report/Server Usage

Confidential

SAP BUSINESS OBJECTS ADMINISTRATOR/ARCHITECT/LEAD DEVELOPER

Responsibilities:

• Consolidation/Migration projects on B.O 4.X with approx. 80k users from XI 3.1 to SAP BI 4.0
• Upgraded SAP Business Objects from XI 3.1 to SAP BI 4.0 in Linux/Windows environment
• Authored, facilitated and customized user materials on Business Objects on a weekly or bi weekly basis (introduction, intermediate and advanced level )
• Developed customized interface apps using BO JAVA SDK
• Upgraded SAP BI 4.0 to SAP BI 4.1 in Linux/Windows environment
• Integrate SAP BI 4.0 to SAP BW 7.3
• Authored internal Enterprise Upgrade/Content Migration Guide
• Conducted Sizing and Capacity Planning using best practice
• Configured Apache-WebLogic configuration for Apache to direct requests to WebLogic
• Configured BO 3.1/BI 4.0/4.1 with Single Sign On (SSO) using Windows Active Directory (AD)
• Create User Access Levels (Security) using CMC
• Use Upgrade Migration Tool migrate BO content between the different versions
• Use Promotion Management to promote content between SAP BI 4.0/4.1 Development/Test/Production environments
• Provide trouble shooting/root cause analysis and resolution paths
• Develop complex SQL Server/Oracle/SAP BO Repository (CMS, Query Builder) queries
• Set up and customized Audit Reporting Environment for Webi and Crystal Reports
• Built Audit dashboards showing User/Report/Server Usage
• Develop Webi/Crystal Reports/Dashboards based on Relational (Oracle/SQL Server) an SAP BW data
• Build Dashboards using Xcelsius/BO Dashboards/Design Studio

Confidential

SAP BUSINESS OBJECTS ARCHITECT /LEAD DEVELOPER

Responsibilities:

• Create Webi reports using Rich Client and Infoview (BI Launch Pad XI 4.0) in SAP ECC/CRM and BW environment
• Customize/Develop/Maintain universes in Designer (XIR3) and Information Design Tool - IDT (SAP BI 4.0) based on SAP BW(BEX) queries
• Created Crystal Reports and SAP Business Objects Webi reports using Rich Client and Infoview (XI R3) based on Cerner PowerInsight data models
• Customized/Developed/Maintained Cerner PowerInsight based universes in Designer (XI 3.1)
• Created SAP Business Objects Webi/Crystal reports that tracked duplicate drug alert details Pharmacy Dept. based on PowerInsight data

Confidential

SAP BUSINESS OBJECTS ARCHITECT /LEAD DEVELOPER

Responsibilities:

• Created Crystal/ Webi reports (XI R3) using universes based on SAP BW (Bex Queries) pulling data from DSO
• Develop/Maintain Business Objects (XI R3) Universes based on SAP BW (Bex Queries) for FICO datasources
• Work with Offshore resources to evaluate SAP ECC/BW Development, Test and Production environments to ensure proper migration/availability/function of reports and datasources (Infocube, DSO, Bex Queries)

Confidential

SAP BUSINESS OBJECTS LEAD DEVELOPER

Responsibilities:

• Develop Business Objects (XI R3) Universes in Oracle environment
• Convert (re-created) Internal reporting application reports to Business Objects (XI R3) Webi Reports based on Salesforce.com Data sources
• Utilized SQL Server Integration Services (SSIS) to perform ETL operations
• Leverage SQL Views as data sets for Business Objects Webi reports
• Write SQL Queries based on Salesforce data to validate data retrieved by the Business Objects reports
• Design/Implement Row Level Security down to salesperson level

Confidential, Chicago, IL

BUSINESS OBJECTS XI CONSULTANT

Responsibilities:

• Developed Full Client (Deski) and Web Intelligence (XI R2) Reports using newly created universe(s).
• Designed/Created new relational database BOXI R2 universes for Oracle Financials/JD Edwards Data mart
• Analyzed table/ view to ensure database design/structure met reporting/universe design requirements
• Analyzed and tested data relationships to identify the tables and joins necessary for creating the appropriate universe objects
• Analyzed SQL/ PL/SQL and translated functionality in the universe design
• Utilized Data Integrator for ETL and universe design
• Developed Full Client (Deski) and Web Intelligence (XI R2) Reports using newly created universe(s).

Confidential, Atlanta, GA

SAP BUSINESS OBJECTS LEAD DEVELOPER

Responsibilities:

• Developed Business Objects (XI R2) and Crystal Reports from data based on Confidential and NextGen applications
• Utilize CMC to perform various Administrator tasks (i.e., manage users/folders/reports/security/access/rights)
• Utilize Application Foundation to create and maintain Dashboards using DashBoard Manager
• Utilize Designer to provide updates to GL and Portfolio Universes

Confidential

BUSINESS OBJECTS CONSULTANT

Responsibilities:

• Utilize HP UNIX/WNNT/ORACLE 8i/SYBASE/SQL/Business Objects/Platinum Technology for Report Solutions Project
• Utilize Business Objects Designer to create, modify and/or enhance the Business Objects Universe Designs
• Played major role in the successful development of more than 600 BO reports Accounting (GL/SL/TB)/JD Edwards reports
• Perform database/data analysis
• Provide extensive report/universe design and development knowledge to Team members to help address complex business requirements using Business Objects Reporting Tool
• Analyzed and optimized Business Objects queries (through universe, database modifications and/or hints)
• Develop Unix Shell Scripts to generate and export Oracle reports to Excel
• Created Stored Procedures and Packages to summarize and load data into Oracle Data Mart

Confidential

LEAD ARCHITECT/BUSINESS OBJECTS CONSULTANT

Responsibilities:

• Responsible for Business Objects Installations, configurations, deployments, creating and maintaining Business Objects Universes (Designer), converting Oracle Discoverer Reports based on PeopleSoft/JD Edwards HR data to Business Objects/Web Intelligence and SQR Reports in a SUN UNIX/ORACLE 9i environment
• Work as Administrator for Business Objects security (Supervisor), Designer and Users.
• Utilized Business Objects Application Foundation to create Benchmark and Metrics Reports for Bellsouth’s Latin America countries
• Installed and configured Cognos and Impromptu
• Developed Powerplay and Impromptu reports for Bellsouth’s Flow thru Project
• Created and populated Cognos OLAP cubes with Flow thru data from Microsoft and flat file data sources