Abdul Ahad Email & Phone Number

Dallas/Fort Worth Area

- Analyzed the reporting requirements with the business users and designed the technical specsCreated derived tables, implemented cascading prompts, checked the cardinalities, created joins, created contexts, and aliases for resolving loops, chasm traps and fan traps in the universe- Improved performance and reduced the coding of the marketing, finance universe with the use of @functions (@aggregate aware, @select, @prompt, @where), created new and modified existing hierarchies, defined Alias and Contexts to resolve loops, exported the universe to the repository, updated and maintained existing Universes based on changing user requirements and based on changes in data source- Created restrictions on objects and classes based on universes privileges, and generated List of Values (LOV’s) from lookup tables using Information Design Tool- Created WEBI reports using SAP Business Objects functionality’s like queries, slice and dice, drill down, charts, cross tab, and custom variables etc. - Created reports merging data from multiple sources, and conducted training for ad-hoc users- Created reports in WEBI-Rich Client for the quarterly and annual revenue and utility usage analysis- Designed and developed standard reports and summary reports- Developed complex interactive and dynamic dashboards using BI Dashboard with Live Office and QAAWS as the data sources, developed what if analysis and forecasting using BI Dashboard, redesigned the data by using various V-lookup and H-lookup functions- Created user groups, users, database connections, managed user privileges, migrated objects between environments, and managed Business Objects services using the Central Management Console (CMC)- Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces, and optimized the existing reports in production

- Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports- Involved in the designing and building of universes, classes and objects for the HR universe, created cardinalities, contexts, joins and aliases for resolving loops, checked the Integrity of the Universes, used various @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters) and @Select- Generated various numbers of reports on a daily, weekly and monthly basis. Interacted with end users regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas- Scheduled reports through CMC and BI Launchpad- Responsible for Designing and Developing Reports according to client’s Requirement using SAP Business Objects and Tested Reports by querying the Financial and Customer Information Systems - Designed and developed various Dashboards for sales, and marketing, and helped developed the data sets (Web Intelligence) for Dashboards, and provided training for Xcelsius Dashboard users- Created Users, Profiles, User groups and implemented inheritance based security for all users, groups, folders, categories, reports, and universes

- Analyzed the reporting requirements with the business users and designed the technical specs, Developed issue log and prioritized the issues- Involved in building of universes, classes and objects, created cardinalities, contexts, joins and aliases for resolving loops, checked the Integrity of the Universes, used various @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters) and @Select, Created user defined objects to manipulate the data by using database specific functions to fulfill the reporting requirements.- Suggested modifications in Universe in existing objects or creating newer objects which are necessitated from Reporters perspective, Implemented row & object level security for different user group requirements- Using Business Objects 3.1 Created templates for standardizing reports using company logo, header and footer settings, color coding, fonts and maintained consistency in viewing cross-tabs, blocks in report- Created reports using data from multiple data providers in Web Intelligence by merged dimensions functionality.- Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports- Converted Business Data requirements into Conceptual and logical data models- Used Xcelsius to create Dashboards, pulled data from Universes using QaaWS and Live Office as middle ware, Commonly used excel functions ("VLookup, Hlookup, Index, Match and Conditional statements"), Exported Dashboards to BOE Server in various file formats (pdf, ppt, and html, flash).