• Dallas Texas

Talha Jawad

Business Intelligence & Data Warehouse Manager

Expertise Highlights

§  SAP Business Objects XI 3.1/4.0/4.1

§  Universe Designing Tool (UDI)

§  Web Intelligence (Webi)  

§  Crystal Reports 2011, Enterprise

§  Information Design Took (IDT)

§  SAP BI 7.0 – 7.4

§  Dashboard (Xcelsius)

§  Web Intelligence Rich Client

§  Business Explorer

§  QAAWS, Live Office

§  Business Intelligence Launch Pad

§  BEx Analyzer

Summary

  • Senior BI Practice Lead with over 12 years of global IT experience focused on Data Warehouse/Business Intelligence solutions in diverse industries applying best practices and ensuring customer delight. Strengths include BI thought leadership, Strategic planning, Business development, Vendor management, Outsourcing, Recruiting/ Training staff and representing companies at business/public settings.
  • With a proven track record in multiple areas of IT outsourcing operations, my goal is simply to use my experience and education to transform businesses through innovative technology solutions.
  • Organized and goal-oriented, with more than five years' experience in project management and a strong customer focus.
  • Analytical problem-solver, able to anticipate issues and create new systems that streamline operations, resolve concerns and improve efficiency.
  • Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.
  • Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
  • Define and initiate projects, manage cost, schedule, and performance of component projects, while working to ensure the ultimate success and acceptance of the program.
  • Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
  • Coach, mentor and lead personnel within a technical team environment.
  • Present periodic Dashboard reports on the current program, future opportunities and client issues.
  •  Able to delegate effectively and motivate team members to achieve on-time project completion.
  •  Experience in leading technical/functional team for technical realization of a BI solution.
  •  Fully experienced in handling and executing all Phases of Software Development Life Cycle (ASAP Methodology) Multiple full life cycle implementation experience on Netweaver 2004s BI 7.0, BW 3.5. and BOBJ XI 3.1,4.0 and 4.1
  •  Full understanding of business environment, excellent communication skills, leadership qualities and ability to work proactively in a fast paced environment
  •  Continually strive to enhance or improve business systems processes that drive efficiency through use of best practices.
  •  Conducted training for end-users
  •  Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability

Business Warehouse / Business Intelligence  Summary 

  •  Experience in development including the creation of InfoObjects Catalogs, InfoObjects, InfoCubes, ODS Objects, MultiProviders, InfoSets, Update rules , Transfer Rules and Transformations
  •  Developed ABAP user exits for transaction and master data in start/end and update routines.
  •  Proficient in performing analysis of BW Statistics and in deciding necessary actions for performance tuning
  •  Experience in creating Views, DataSources and enhancing standard DataSources in SAP ECC.
  •  Experience in CO-PA, LO Cockpit and Generic data extractions
  •  Expertise in Data Loading (initial/Delta Up-load), Scheduling and Monitoring
  •  Skilled in reporting using BEx Explorer Analyzer, Creation of Structures by using BEx Query Designer and implementing BEx Queries, Calculated and Restricted Key figures
  •  Experience in creation of Web Templates using various Web items in Web Application Designer(WAD) 
  •  Proficient in uploading master data and transactional data from flat files and SAP R/3 Systems
  •  Extensive knowledge and experience in collection, activation and use of Business content
  •  Involved in the post production support that required InfoCube management using Compression, Rollup, Reconstruction, Indexes and Aggregates.
  •  Created and maintained Aggregates to improve the Query Performance
  •  Extensive working knowledge of Oracle Database, Relational and Dimensional Data Modeling and Application Development 
  •  Experience creating and maintaining an extraction, transformation, and loading process (ETL) from source systems into a data warehouse, mart, or both
  •  Strong Knowledge OLAP application development.

Business Objects Summary

  • Experienced using Xcelsius Dashboards and determining the performance and progress of the business.
  • Created Web Intelligence reports using Sections, Breaks, Alerts, Rankingand using report level variables to mimic user requirements.
  • Strong RDBMS concepts and working experience using database Tables, Views, Stored Procedures, Functions, and Packages using
  • Extensively used Calculations, Variables, Drill Down, Slice and Dice for creating Business Objects
  • Comprehensive experience in gathering and analyzing the requirements from end-users and trained users in Business Objects.
  • Worked with various Relational Databases such as Oracle 10g/9i/8i, SQL Server 2000/2005/2008
  • Performed unit testing, system testing and user acceptances test (UAT) for universes, reports and security management.
  • Implemented Row Level, Object Level and Report Level Business Objects Security Features
  • Experience in created reports using Web Intelligence and Web Intelligence Rich Client
  • Excellent experience in creating Sub Reports, On Demand Reports, Linked Reports, Mailing Labels, Cross Tab Reports and Graphical Reports.

Work History

Work History

Business Intelligence & Data Warehouse Manager

Aug 2007 - Present
ABeam Consulting

Business Intelligence & Data Warehouse Manager

May 2003 - Jul 2007
Independent Consulting

Recent Projects

Project Name: Elo Touch (Global)

Position Held: Lead BI/BOBJ Consultant / Project Manager

Type of Industry: High Tech

Environment: SAP BI 7.4, BOBJ 4.1, SAP ECC 6.1, FI, CO, MM, PP and SD, BEx Analyzer, Query Designer

  • Global BI Development and Architecture Implementation. We redesigned existing BI data models & reporting structures implemented incorrectly by a previous third party.
  • Worked with company executives/managers/stakeholders to establish requirements and architectural design for the SAP BW/BOBJ implementation
  • Designed the data modeling flow from ECC, in addition to other data sources, to specific Data Targets for reporting in BEx based upon the clients’ parameters and reporting structure.
  • Provided long term support through constructing, and modifying numerous custom reporting objects (i.e. – DSO’s, InfoCubes, MultiProviders) to ensure the data for new and changed processes were properly represented in all reporting objects
  • Developed and created advanced enterprise reports for multiple business areas utilizing the spectrum of SAP’s BI/BOBJ reporting tools (e.g. BEx Analyzer, Xcelsius, Crystal Reports etc.) to ensure the organization was able to make predictive and informed decisions.
  • Managed Development of all Reports for this Project along with a Team of 4 on shore and 2 off shore resources
  • Designed Testing scenarios based on Functional Documentations and Requirements
  • Assigned duties, delegate assignments to developers and served as SME for Training Developments for the Client
  • Responsible for the build, test and deploy of the SAP Business Objects reports BO BOE 4.1 Environment, setup of client tools for entire development team.
  • Created Training Documents for end user trainings and Super User Trainings. Served as an SME
  • Implemented and Designed BOE Users Administration, Access Levels and worked closely with Security Teams to implement proper solutions
  • Conducted Lunch and Learns to educated business and other developers to user all client tools
  • Build 100+ Reports  for the entirety of this project.
  • Responsible of the front end Reporting side, including Build, Test and Deploy of multiple reports in specific SAP Finance and Sales functional areas.
  • Trained/Supported other team members in the build of their SAP Business Objects reports for the rest of the functional areas.
  • Resolve SAP Business Objects related issues during Build, Assembly Test, Product Test and ORT phases.
  • Tested the reports, Assigned defects to proper fix it teams.
  • Provided end user support during Product Test period.
  • Provided super user support during Training.
  • Provided  support to the Change Management team for the Training courses for SAP BOBJ, Webi Intelligence, and Analysis
  • Overlooked and supported the project from start to finish.
  • Creation of Universes in Information Design tool on a Oracle Database
  • Trained users to run  Reports and supported the project after Go Live
  • Worked extensively with the BASIS team in the implementation of the BOE Environment.
  • Supported BASIS in enhancing and fixing issues raised throughout the duration of the Project.
  • Communicated effectively with all the teams’ across the project.

Project Name: Maruchan Inc

Position Held: Lead BI Consultant / Senior BI Consultant

Type of Industry: Food Industry

Environment: SAP BI 7.3, HANA Design Studio 1.1&1.2, BOBJ 401, BEx Analyzer, SAP ECC 6.0, FI, CO, MM, PP and SD

 

Responsibilities

  • Architect reporting requirements into technical design and development.
  • Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports.
  • Architect the Re-org of BW objects to maintain standards.
  • Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need.
  • Performed clean-up activities for the pre-migration of BW on HANA implementation.
  • Optimized BW cubes for HANA.
  • Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA. Interacted with the finance business analysts on a daily basis for their KPI & reporting requirements.
  • Managed, Configured and Performed Transports between multiple BW environments.
  • Used RealTech Transport Manager to perform transports.
  • Maintained custom tables in BW to load Master data.
  • Performed BW Master and transaction data loads on ad-hoc basis.
  • Created and scheduled Process chain for daily Delta loads.
  • Troubleshooting data and technical issues related to SAP BW.
  • Managed Client BW environment to co-ordinate development, testing and transports to production.
  • Developed Universes modified existing universes, added new objects to existing Universes and working on the procedures for the development of reports.
  • Utilized Information Design Tool (IDT) and Universe Design Tool (UDT) in the process of creating Universes, Connections and Business Layers
  • Analyzed business problems and planned the universe solution that satisfies the user needs and reporting analysis.
  • Created Web Intelligence reports using Webi, Webi Rich Client, and BI Launch Pad. 
  • Created Dashboards Utilizing Dashboards Design 4.1.
  • Utilized Business Explorer to create views.
  • Used Business Objects common functionalities like Prompts, Breaks, Alerter, Sorts, Filters, Global Filters and Conditions.
  • Implemented row level security in the universe to allow the data to be viewed only by authorized personnel.
  • Deliver high quality results in support of new project initiatives as well as the day-to-day maintenance and support
  • Develop and maintain relationships with a variety of internal and external experts and specialists (solution architects, business analysts, external solutions providers) to provide technical guidance, continuously evolving reporting and analytics knowledge, expertise and capabilities

Project Name: KAO Brands (Global)

Position Held: Lead BI/BOBJ Consultant / Project Manager

Type of Industry: Consumer Products

Environment: SAP BI 7.3, BOBJ 4.0, SAP ECC 6.1, FI, CO, MM, PP and SD, BEx Analyzer, Query Designer

 

  • Lead a team of BW/BOBJ developers and managed multiple implementations
  • Gather requirements from business units and translate them into technical solutions
  • Write supporting functional specification and design documents
  • Develop and maintain a BI platform that conforms to consistent methodologies, standards and industry best practices
  • Universe design and developing web intelligence reports from ECC and BW
  • Develop dashboards, customized reports and score cards, based on business requirements and UI specifications
  • Fulfill ad-hoc reporting requests from customers
  • Troubleshoot production issues as they arise
  • Train and mentor user community

Project Name: NEC Latin America (Brazil)

Position Held: Lead BI Consultant / Project Manager

Type of Industry: High Tech

Environment: SAP BI 7.1, SAP ECC 6.1, FI, CO, MM, PS and SD, BEx Analyzer, Query Designer

  • Lead the Business Analytics team for a large Global Integration Enterprise initiative.
  • Developed the Business Intelligence implementation approach and strategy for Brazil.
  • Conducted workshops and business interviews to define the requirements and dimensionality needs for the Key Performance Indicators (KPI’s) in a “blank page” environment.
  • Responsible for delivering the Key Performance Indicators and Analytics as part of the Performance management and analysis.
  • Analyzed multiple legacy reports to create consolidated requirements.
  • Responsible for developing a high level Data flow and revising Gap Analysis.
  • Took the lead to gain consensus across the large global organization for those KPI’s and measures.
  • Developed the value statements for BI implementation further linked the value statements with KPI’s and measures to develop value driver trees.
  • Worked extensively with Finance & Controlling (General Ledger, AR and AP).
  • Developed complex InfoCubes for FI-GL, CO-PA, MM, PS and SD modules.
  • Configured custom and standard extractors in BW IMG .Directed development efforts and executed code reviews for multiple developers
  • Developed multiple complex queries on Query Designer.
  • Designed and developed optimized process chains for master data, text and transactional loads
  •  Set up authorization objects and roles; thoroughly tested reports based on various roles.
  •  Developed reporting authorizations and user profile maintenance.
  • Conducted training workshops for Super, Power Users & End Users.
  • Kept a thorough check on the system performance and database size; used that information to schedule the deletion of PSA Data Accordingly
  • Worked around international time zones to get requirements from the Business users spread across.
  • Responsible for leading a successful BI solution for the above modules in phased rollout across various regions.

 

Project Name: NEC Asia Pacific (Singapore, Malaysia, Thailand, Philippines, India & Indonesia)

Position Held: Lead BI Consultant / Project Manager

Type of Industry: High Tech

Environment: SAP BI 7.1, SAP ECC 6.1, FI, CO, MM, PP, PS and SD, CRM 7.0, BEx Analyzer, Query Designer

  • Responsible for working as a lead for the Business Analytics team for a large Global Integration Enterprise initiative.
  • Responsible for delivering the Key Performance Indicators and Analytics as part of the Performance management and analysis.
  • Worked on the developing the Business Intelligence implementation approach and strategy.
  • Conducted workshops and business interviews to define the requirements and dimensionality needs for the Key Performance Indicators (KPI’s) in a “blank page” environment.
  • Analyzed multiple legacy reports to create consolidated requirements.
  • Took the lead to gain consensus across the large global organization for those KPI’s and measures.
  • Developed the value statements for BI implementation further linked the value statements with KPI’s and measures to develop value driver trees.
  • Responsible for successful blueprint deliverable of the FI-GL, FI-AR,CO-PA, SD, MM, and SD modules BI solution. The sub-processes with OTC were Sales Orders, Backlog, Billings, AR, Quotes, Inquiries, OTD, Deliveries and Revenue.
  • Configured custom and standard extractors in BW IMG .Directed development efforts and executed code reviews for multiple developers
  • Worked around international time zones to get requirements from the Business users spread across.
  • Responsible for leading the BI solution for the above modules in phased rollout across various regions such Singapore, Malaysia, Indonesia, Thailand, Philippines & India.

 

Project Name: NEC America

Position Held: Lead BI Consultant / Senior BI/ETL Consultant

Type of Industry: High Tech

Environment: SAP BI 7.1, SAP ECC 6.1, FI, CO, MM, PP, PS and SD, CRM 7.0, Business Objects XI 3.1, Xcelsius 3.1, BEx Analyzer, Query Designer, Web Application Designer, Informatica V8

 

  • Lead a team of technical/functional consultants for implementing a BI/BO solution.
  • Gathered and analyzed requirements from business groups and senior executives.
  • Defined work packages and technical specifications for design, development, testing and roll out.
  • Analysis of data requirements and translation of these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques.
  • Worked with functional consultants for mapping the source data (ECC and non ECC) to target DataSources in BI. Defined the initial sizing requirements based on source data volume estimates.
  • Used Data Storage Object (DSO) to stage the data before transferring the DSO contents to the Info Cubes.
  • Performed analysis, design, development and implementation of customized Info Cubes, DSO’s and InfoSets for CO-PC and CO-PA modules.
  • Developed custom extractors on the ECC OLTP systems and defined the extract structures on the source and target systems.
  • Created various Transformations for restricting and transforming data.
  • Developed custom reports and designed WEB template based on user requirements.
  • Documentation for BI development process, Installation and Troubleshooting guide
  • Query development using the BEx analyzer/browser functionality of BI. Developed flexible queries using filters, Restricted Key Figures, Calculated Key figures, Counters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
  • Analyzed report performance for statistics and implemented proposals for aggregate creation and indexing.
  • Created and maintained Aggregates and time dependent and independent Hierarchies.
  • Involved in performance related issues of the system
  • Install and Activate the Business content.
  • Creation of custom DataSources, Enhancements and Replication of DataSources in  ECC 6.0 to BI 7.0,of  which include CO-PA, CO-PC, LO, FI,MM,SD,PS and PP
  • Use of BAdIs, user exit for extraction of enhanced extract structures.
  • Schedule the data by using various update modes like Direct delta, Queued Delta and Full Update
  • The automatisms of the integrated BI processes, central visualization and monitoring using Process-chains.
  • Using Transport connection for transporting BI objects and modifications over the landscape
  • BI Analysis authorization design and development (New SAP BI 7.0 Concept)
  • Developed prototypes and presented a demo session for user acceptance
  • Trained users in reporting functions
  • Managed multiple data sources including internal, external, and 3rd party source system data
  • Managed all technical aspects of the ETL process 
  • Extracted data from source systems. Transformed data via standardization, cleaning, data repair, matching, and de-duping 
  • Performance tuning of ETL processes
  • Responsible for integrating Business Objects reporting and analytics tools (ie. WEBI, Crystal, Live Office, etc) with information derived from an SAP ECC and SAP BW systems as well as information from an Oracle Data Warehouse
  • Evaluated, recommended, planned, executed, and managed the integration of new SAP/BOBJ functionality, business processes and data into existing applications environment. 
  • Ensured that product upgrades, enhancements, and future roll-out projects meet business requirements and goals, fulfill end-user requirements.
  • Liaised with Business Process Owners and colleagues to address system related issues and integration of functional requirements into our applications environment. 
  • Partnered with business colleagues to generate cost benefit analysis for requested system and/or process initiatives.
  •  Ensured production support service levels are met for all business applications.

 

Project Name:  ABeam Consulting: Establishment of Global AMS in US

Position Held:  Lead BI Consultant / Senior BI Consultant

Type of Industry:  Outsourcing

 

  • Establishing/Running of New Service
  • Supported the establishment of new outsourcing team in U.S.
  • Handled issue management system setup
  • Supported stabilization of a cooperative relationship with clients
  • Handling monthly closing trouble shooting and additional change requests in responsible areas
  • Business Development
  • Analyzed the market demand for outsourcing and developed new service line in order to acquire domestic clients
  • Created brochures for new service in multi-language format (English and Japanese)

 

Project Name: Maruchan Inc

Position Held: Lead BI Consultant / Senior BI Consultant

Type of Industry: Food Industry

Environment:  SAP BI 7.0, BEx Analyzer, SAP ECC 6.0, FI, CO, MM, PP and SD

 

  • Lead a team of technical/functional consultants for implementing a BI solution.
  • Gathered and analyzed requirements from business groups and senior executives.
  • Defined work packages and technical specifications for design, development, testing and roll out.
  • Analysis of data requirements and translation of these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques.
  • Worked with functional consultants for mapping the source data (ECC and non ECC) to target DataSources in BI. Defined the initial sizing requirements based on source data volume estimates.
  • Used Data Storage Object (DSO) to stage the data before transferring the DSO contents to the Info Cubes.
  • Performed analysis, design, development and implementation of customized Info Cubes, DSO’s and InfoSets for CO-PC and CO-PA modules.
  • Developed custom extractors on the ECC OLTP systems and defined the extract structures on the source and target systems.
  • Created various Transformations for restricting and transforming data.
  • Developed custom reports and designed WEB template based on user requirements.
  • Documentation for BI development process, Installation and Troubleshooting guide
  • Query development using the BEx analyzer/browser functionality of BI. Developed flexible queries using filters, Restricted Key Figures, Calculated Key figures, Counters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
  • Analyzed report performance for statistics and implemented proposals for aggregate creation and indexing.
  • Created and maintained Aggregates and time dependent and independent Hierarchies.
  • Involved in performance related issues of the system
  • Install and Activate the Business content.
  • Migrating BI content from 3.X to BI 7.0.
  • Creation of custom DataSources, Enhancements and Replication of DataSources in  ECC 6.0 to BI 7.0,of  which include CO-PA, CO-PC, LO, FI,MM,SD and PP
  • Use of BAdIs, user exit for extraction of enhanced extract structures.
  • Schedule the data by using various update modes like Direct delta, Queued Delta and Full Update
  • The automatisms of the integrated BI processes, central visualization and monitoring using Process-chains.
  • Using Transport connection for transporting BI objects and modifications over the landscape
  • BI Analysis authorization design and development (New SAP BI 7.0 Concept)
  • Developed prototypes and presented a demo session for user acceptance
  • Trained users in reporting functions
  • Assisted in developing data models, as well as logical and physical database design, with a major focus on dimensional modeling 
  • Developed processes using ETL tools (Data Integrator), PL/SQL and SQL to support business reporting requirements. 
  • Designed and developed ETL processes, data flows, and Data Marts based on business requirement specifications. 

Education

Education

Continuing course work in Management Information Systems

2006
Harvard University

Bachelors of Business Administration

2000
Institute of Business Administration

Certifications

Certifications

SAP Certified Application Associate - SAP HANA

Jul 2012
SAP America