We provide IT Staff Augmentation Services!

Lead Business Intelligence Consultant Resume Profile

5.00/5 (Submit Your Rating)

Dallas, TexaS

Summary

  • I have been working as a Sr. SAP Platinum Level IT Consultant/ Solutions Architect for the past 14 plus years. I have managed teams of Solution Providers ranging from 8 to 30 resources at a time. I have successfully mentored junior and senior level professionals to the next level of succession in their professional development chain. I have managed an IT budget ranging from 2.5 million to 20 million per year and have been part of large SAP ERP implementation 100 million to 450 million . I have successfully delivered projects on time and under budget. I have implemented IT solutions that have been helpful to the organizations bottom line from the perspective of raising productivity and revenue dollars per resource utilized/employed.
  • I have a strong acumen for business intelligence reporting and the impact a good BI Development Reporting Group can have on an organization as related to BI reporting and Strategic Enterprise Management . I have successfully introduced and implemented SAP BI/BW Reporting solutions for many of my clients. I have provided current BI state assessments as well as recommended future BI reporting strategy/Roadmap. I continuously strive to learn new ways of improving BI, its place and value in the organization. At present I am involved in the roll out of BO 4.0 solution as well working on POC for the use of SAP HANA SAP COPA reporting using BO 4.0 for reporting . In addition to BI reporting I have successfully Upgraded SAP BW 3.1 to BI 7 to BI 7.3 platform.
  • As Lead SAP BI Integration Consultant, I am responsible for developing initial BI roll out strategy Reporting and Dashboard relevant . I have Developed and Supported SAP IS Oil Gas MM Logistics and IS-retail AFS . Developed, tested and implemented reports for SAP CRM, SRM, OTC, P2P SCM , FI/CO and BPC using SAP BI as the basis for reporting and as a source for data provisioning. I am a hands-on SAP BI/BW/BO and HANA Certified Solutions provider.
  • As Lead SAP BI Solution provider I have conducted individual and classroom training sessions for both process and customer support analytics this includes SAP BI/BW training for using, creating and enhancing Queries, Reports, Dashboards using SAP BI BEx Analyzer, SAP BI Query Designer, SAP Web Application Designer, SAP Business Objects both XI/BO4.0 Universe Designer/Information Design Tool, Xcelsius Dashboard Builder , Crystal 4.0 and WEBI and SAP HANA.

Employer History

Confidential

Lead Business Intelligence Consultant

  • Worked extensively with HANA Studio.
  • Created Attribute views, Analytical views and Calculated views graphical and SQL Script for data consumption by BOBJ Explorer.
  • Visualization and data movement in HANA
  • Experience working with Data Movement in HANA utilizing Data Services and Sybase Replication Server for real time access to data.

SAP Lead Business Intelligence Consultant

Confidential

  • Enabled SAP BI Mobility test environment .
  • SAP Lead BI Consultant.
  • Designed, developed, implemented and rolled out a complete BI/BW reporting solution for SCM MM, P2P and SRM.
  • Supported FI CAFR, Budget Grants and purchasing functional areas.
  • Set-up Query Optimization procedures using both Table Partitioning and info-cube aggregations
  • Developed/Implemented BI 7.0 Java reporting strategy using Federated Portal.
  • Designed, developed, implemented and rolled out a complete BI reporting solution for SCM MM, P2P and SRM.
  • Developed/Implemented BI 7.0 Iviews per BI reporting access via the Federated Portal
  • Developed Custom SCM reporting solutions per State and Management reporting using custom datasources developed ABAP FM modules and Generic Extractor functionalities .
  • As Lead BOBJ Architect, I developed a BI Roadmap/Strategy for BI/BO 4.0.
  • Conducted workshops for the end-user per initial BO 4.0 POC.
  • Architected server configuration for the worldwide deployment of Business Objects Enterprise version 4.x software supporting the Supply Chain and Purchasing function areas.
  • Provided guidance and support of all Business Objects software including desktop products, enterprise server products and Broadcast Agent server.
  • Architected a comprehensive security strategy based on corporate policy and functional roles to control product features, document and data access by user.
  • Developed universes to access data within the corporate data warehouse and data maintained in disparate databases. Universes designed included Funds management, Vendor Spend Analysis, Minority Vendor Analysis.
  • Developed SAP BI Mobility alerts per SRM bids and Shopping Cart Approval notification workflow .
  • Lead BI 7.0 to BI 7.02 upgrade effort total landscape DEV>QA>Prod.
  • Lead BI 7.02 to BI 7.3 upgrade effort Test landscape .
  • Developed a POC per HANA using FI-COPA and BO 4.0 as front-end solution.
  • Defined SLT procedures per HANA POC. Including:
  • Installed SAP LT Replication Server SLT
  • Identify the tables in ERP system using SE15 or SE84 to find the relevant table s
  • Configure the source data system for RFC access from the SLT component
  • Configure your target SAP HANA system for access by the SLT component
  • Setup replication using the SAP HANA In-Memory studio
  • Start replication from the source system to the target SAP HANA system
  • Preview the data in SAP HANA Studio
  • Load the Data in SAP HANA Studio
  • Analyze Data in SAP HANA using the Excel interface to SAP BO 4.0 tools
  • Scheduled reports
  • Schedule the URL of the BI documents via email to BOBJ 4.0 Mobility Users.
  • Created Alerts on Crystal Reports BI documents for BOBJ 4.0 Mobility Users.

Confidential

SAP Lead BI Consultant.

  • Worked with C-level executives in defining and creating the BI strategy within the project lifecycle.
  • Developed BI reporting proto-type to facilitate reporting workshops for gathering requirements, developing blueprints and functional/technical design.
  • Implemented a complete BI reporting solution for the Global business community work effort included a highly customized solution of over 260 reports that included core reporting for SD,SCM,FI and WM along with financial consolidation reporting using SAP BPC NW 7.5 .
  • Developed BI data model and reporting solution for all ECC areas such as OTC SD , SCM, FI-CO, COPA and Vistex royalties and commissions .
  • In addition, rolled out Business Objects XI 3.0/3.1 and SAP BI / BOBJ integration kit for creating adhoc reporting and Executive management Dashboards.
  • Overall, managed a team of 14 BI developers' on-shore and off-shore SAP Global Development .
  • Responsible for all BI development budgets as dedicated to the project

Confidential

SAP Lead BI Consultant :

  • Project included implementing SAP BI 7 Custom Reporting Solution for the US Army Logistics includes BI reporting capabilities for Customer and Vendor and all the associated components-This is all Classified .
  • Solution included sourcing data from external and internal partners via SAP Workflow ABAP Tables , MDM and SAP XI as basic sources of data input. Utilizing Generic SAP BI extractors and SAP Web Services/Proxies from XI to BI pushing data into BI-PSA via ABAP function modules and then sourcing data into the BI DSO's to populate data for further processing via BI for reporting needs. Once data has been normalized and placed into subject Info-Cubes/Multiproviders. Reports are delivered via query designer using BI 7 Broadcasting. All reports and the presentation layer are delivered via the SAP Portal EP 6.0 .
  • In addition to the Customer and Vendor solution also designed, developed and implemented the BAM Business Activity Management solution. Establish/set-up SAP BI 7 Data Integration with SAP BusinessObjects Edge BI.This solution monitors tactical activity points from the standpoint of delivering quality service to the trading partners.
  • Managed a team of 5 BI and XI developers along with making presentation to the client for gate reviews and approval checkpoints SDLC deliverables - SRR, PDR, CDR, TRR, PRR and go-live .
  • Initially this project was started as an IOC Initial Operating Capability for BI per PLM . This proof of concept was delivered via SAP Netweaver BI 7 and SAP BusinessObjects XI 3.1 using Universe Designer, Xcelsius, and WEBI. Worked with Basis to set-up both the BI server and the Enterprise portal from scratch set-up BEx reporting to interface with the Portal i.e. Java and ABAP interaction using BI Java Template installer .Also set-up change management promote technical objects from source system to destination system i.e. Dev, Qas and Prod per the SAP BI and BusinessObjects landscape using SAP TMS and LCM Life Cycle Manager for BusinessObjects.
  • Eventually BI proof of concept was delivered on time project development was approved and additional work streams were approved.

Confidential

SAP BI Lead

  • Installed BI 7 content for FI/CO, P2P and SCE SD and SCM utilizing SAP's recommend DCF for SAP Best Practice i.e. Building Blocks for a Jumpstart installation. Jumpstart was utilized to gather both the requirements and conduct fit-gap analysis.
  • Conducted workshops for design and build workshops.
  • Worked on a P2P Procure to pay project per BI/BW BI 7 NETWEAVER 2004S .
  • Installed business content for Procurement, QM, SRM, SCM, and ICH.
  • Developed custom content solutions i.e. custom data extractors, ODS's and info-cubes for queries and reports using BI 7.
  • Developed strategy/plan to upgrade existing BW 3.2 landscape to BI-7 Netweaver 2004s- BW/SEM-BPS and BCS landscape .
  • Set-up SAP BI 7 Data Integration with SAP BusinessObjects for BI reporting. This solution provided BI analytics reports Procure to Pay using Xcelsius Dashboards and scorecards and Webi analytical .
  • Managed and implemented BI 7 upgrade from all aspects of the project managing Technical BI Basis and BW functional resources plus testing all core aspects of the BW upgrade i.e. ensuring all upgraded objects work in the new environment.
  • Upgraded all existing BW/BPS and BCS content to BI 7 both back-end including old data sources i.e. update rules and new DTP driven transformation structures and front-end objects including modifying queries and workbooks to fit the new BI 7 landscape .
  • Set-up Business Objects BOBJ as a presentation layer using SAP BusinessObjects Data Integrator.
  • Developed a thorough checklist for the BI 7 upgrade landscape included development, quality and production . This checklist included tasks all the way from a copy a of BW 3.2 system to restore, acquiring new SID from SAP for the upgrade box, oracle upgrade, BI functional systems checks for the new BI 7 system to Post SAP go-live functional checks.
  • Researched and applied appropriate OSS notes per deemed fixes for the BI/BW landscape all the way from SP7 to SP13 . These notes included fixes for BW queries to BI 7/SEM 6.0 content.
  • Carried out user acceptance testing all the way from user acceptance test cycles 1, 2 3 to parallel system testing cycle 1 2.
  • Perform project workshops to define scope and gap analysis
  • Perform project review meetings
  • Attend steering committee meetings

Sr. SAP Business Intelligence Consultant

Confidential

  • Managed a large BI/ BW implementation consisting of FI/GL, FI/AR, FI/AP,SD, MM, PP, PM, PCA and CCA ODS's and cubes delivering both queries and reports. This effort included Project Planning, Blueprinting and the Realization phase.
  • Worked with the ABAP team during the upgrade of R/3 4.6C to ECC 5.0. Developed conversion plans for testing the upgrade.
  • Defined migration plan from BW 3.5 to BI 7 and EP 5 to EP 7
  • Activate the BC content for BI / CRM analytics
  • Deployed BW/BI reports to BI portal and Enterprise portal.
  • Converted old extraction methods for BW to new Transformation concept direct extraction
  • Created new BI Financial Cockpits for the EP environment
  • Institutionalized Business Intelligence/BW solutions throughout the organization including Europe and Asia.
  • Managed and developed a core BI/BW team to support the organizations current and future Business Intelligence needs.
  • Developed and implemented BW/BI reporting area for the organization
  • Data Modeler and Data Architect for the BW design creating design and blueprint documents with the ASAP tool.
  • Hired and trained BW resources to support the organizations BW/BI reporting needs. Developed and deployed BW-101 and BW- 202 BW training course work for the organization to enable an effective BI staff.
  • Managed and implemented Virsa Compliance Calibrator, Firefighter per Sarbanes Oxley SOX. This software managed roles and responsibilities per Segregation of duties SOD of an SAP process. In addition the software managed IT Access and Provisioning for SAP application security needs.
  • Worked with the accounting group in gathering requirements for BW/SEM BPS reporting needs for projects like weekly P L's and live operations reports identify key performance indicators for business analysis .
  • Defined, developed and implemented SAP BW business content per ODS's/Info-cubes, input screens, business planning areas, planning levels version planning , queries and reports for the weekly P L project.
  • Managed and implemented a Balanced Scorecard project BW-SEM/CPM . Worked with high level management CFO, CIO and VP levels in defining and designing the scoring mechanism for FITSG/shared services. Implemented corporate strategic objectives relative to their perspectives, objectives and measures supported by specific initiatives and projects.
  • Used SAP'S BW/ SEM-CPM Corporate Performance Management tool in designing, developing and implementing approximately 26 balanced scorecards individual business area stakeholders . Utilized BW/SEM-BPS Info-cubes to house and update individual scorecard's data as relative to a given measure. Produced BW/BEx queries, reports and graphs for individual measure against a given scorecard i.e. demonstrate actual vs. plan vs. target.
  • Developed dashboards, ticker tapes, management cockpit for high level management reporting needs. In addition developed and implemented methodology to deliver major business area reports on the Portal using SAP's Enterprise Portal.

Confidential

Sr. Consultant KPMG/Bearing Point

  • Worked on BW reporting project called Enterprise reporting. Performed analysis and requirement gathering for the project. Worked closely with both the technical and functional SAP teams in developing specifications for the business areas such as SD, SCM, CO-PA, FI-GL, CCA, PCA and FI-AR.
  • Data Modeler and Data Architect for the BW design creating design and blueprint documents with the ASAP tool.
  • Worked as Technical lead for the design/configuration and implementation of Enterprise reporting. Developed and managed deliverable timelines for the project.
  • Activated BW Business content for CO-PA, FI-AR and FI-GL modules.
  • Created custom ODS's, info-objects, cubes and multi-providers. Developed and implemented update and transfer rules for custom and standard business content. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups. Set up generic and custom extractors using LO-Cockpit.
  • Developed and implemented transaction cubes for SEM/BPS per budgeting and forecasting reports.
  • Developed custom templates and reports using WEB Application Designer.
  • Wrote Business Explorer BEx queries to create reports both as workbooks and as Crystal reports. Defined business area roles and access profile per authorizations.
  • Created calculated and restricted key figures. Defined variables and set up alerts and exceptions for reporting including reporting agent i.e. sending an e-mail for a given alert . Handled transports.
  • Started Quest project in the project Blueprint phase, assisting with system configuration and project management procedures. As a project manager, I worked closely with the development and functional teams and kept all the stakeholders abreast of project deliverable timelines.
  • Developed ABAP interfaces, data conversion components and SAPscripts.
  • Wrote specifications for SAP's MM module and the legacy Leaf accounting systems. Defined interface relationships between the legacy supply chain and SAP's Sales and distribution module SD .
  • Responsible for developing and maintaining interface AP FI-AP transactions from all legacy systems into FI-GL for month end and year end accounting processing cycle.
  • During the Realization phase, wrote and coded specification for conversion programs using Natural, COBOL and ABAP against the legacy systems OS/390, DB2 and Adabas to clean, map and convert data for use in the new SAP system.
  • Utilized SAP's Legacy System Migration Workbench LSMW to load into R/3.

Confidential

Sr. KPMG Consultant

  • Worked as a developer on a large SAP development project. Started in the project Blueprint phase, specifically working with SAP's FI, CO, SD and MM modules. Gathered requirements, designed and wrote specifications for SAP's SD module and the credit card processing system at ADS
  • Developed data mappings and converted legacy system files. Set up job schedules FTP procedures to send the converted data files over to the new SAP system. Developed the interface to the SAP ETL component for data loads using SAP's Data Load Manager.
  • Performed Fit GAP analysis to gather business requirements for BW/ BI reporting project.
  • Supported and maintained extraction delta setup and performance tuning of the existing system.
  • Setup periodic Data loads from R/3 and Legacy system flat files containing customer information.
  • Created queries for BEx reporting for Sales Lead report sales prospect monitoring , and Daily billing Reports.
  • Created ODS's, info-cubes, custom cubes and multi-providers.
  • Conducted optimization and performance fine tuning on Queries Bex with performance issues.

Confidential

KPMG Consultant

  • Managed implementation of a large ERP system namely SAP. Specifically helped install SAP's FI-CO, FI-GL, FI-AR, FI-AP, MM, SD and BW modules. Worked on the project all the way from Blueprint to the Realization phase. Through out the project life cycle, I worked closely with KPMG assigned consultant in gathering business functional requirements and implementing solutions.
  • Conducted JAD/RAD sessions to capture project scope and user requirements.
  • Managed and participated in the design and development of a corporate. Data Warehouse for Real Estate Tax payment and reporting, utilizing various Data Modeling techniques and tools.
  • Managed the development of several Real Estate Tax reporting applications for First American. The development was primarily a composition of mainframe and client server, where the large part of application is developed using the old legacy mainframe system and the front-end applications are developed using the Client Server B2B and B2C oriented tools.
  • As a technical delivery manager for a tax data search product Accelerated Tax service , I was able to enhance the product's gross sales from 500k per year to 20 million dollars per year over a 3 year product development life cycle.
  • During the development phase, state of the art development tools were utilized such as ADW and case tool code generators. .
  • Was a member of a development team responsible for developing a data warehouse This data warehouse was used for financial analysis and reporting. During design we used OO Analysis and design approaches including use cases, system sequence and entity relationship diagrams.

We'd love your feedback!