Akmal Hussain Mohammed
Jeddah
Summary
- 5+ years of experience as a Business Objects Developer, Sap BO XI 4.0 and 4.1, Info view, Web Intelligence
- Proficient in managing all phases of data ware house life cycle, including requirements gathering, analysis, preparing Business specifications, Designing technical specifications, Software requirement specifications, designing and developing reports, performance tuning, testing
- Excellent understanding of Data Warehouse concepts, OLAP, Star Schema, Extended Star Schema,Business Process Analysis, Dimensional Data Modeling.
- Strong experience in Design, Development, Deployment and testing of Universes using Business Objects Designer against SAP BW and Relational databases (Oracle, MS SQL Server, DB2 sources)
- Good exposure and understanding on the new release BO XI 4.0, Knowledge and experience working on the new features and applications added in BO XI 4.0 IDT(Information Designer Tool), Workspaces, Data Foundation, Business Layers and Query Objects, Business Launch Pad, Web Intelligence, Interactive Analysis, Dashboard Designer.
- Good working knowledge on SAP BI/BW 7.0 with exposure on BEx queries, BEx Analyser, Info cubes
- Working Knowledge of ETL tools like Informatica 9.1/8.5/7.1, BO Data Services XI 3.2, BODI 11.5
- Expertise in working on SQL with Databases like Oracle 11g/10g/9i, MS SQL Server 2005, IBM DB2 V8 and Tera data V12
- Excellent ability designing, developing and troubleshooting simple to complex reports in SAP BusinessObjects.
- Applied functions, such as filters, conditions, breaks, sorting, drill down, slice and dice, Input Controls, Master/Detail, Cross Tab, Charts and alerts to name a few in Web Intelligence.
- Experienced in implementation of Business Objects, Crystal reports with Financial Banking, Public Sectors.
- Proven ability to work in cross-functional teams with high snese of ownership and strong customer focus
- Highly efficient and committed in demanding and rapidly changing environments
- Excellent Communication, interpersonal, analytical skills and a good team player.
Overview
6
6
years of professional experience
Work History
SAP Business Objects Developer
ITC Infotech India Ltd - Client SNB
09.2023 - Current
- Analyze, design, development and configuration of Web Intelligence and Crystal reports for high profile business users.
- Activities also included working with business users to establish requirement gathering for new reports and modify existing reports.
- Created various simple and complex reports , mainly using business objects universes as data providers.
- Created and defined the Hierarchies for various reports based on user requirement.
- Utilized Web Intelligence reporting tool to create graphical representation of reports such as Bar charts, Pie Charts as per requirement.
SAP Business Objects Developer
SOUXE Technologies Private Limited
04.2021 - 08.2023
- Created Web Intelligence reports utilizing SQL Queries, as per the Functional Specifications.
- Reading, writing, executing and maintaining Microsoft Access queries, logic, macros, reports, and forms.
- Used formatting options such as Cross Tab Representation, Section Breaks, Data Sort Options, Calculations, Fonts, Colors, And Conditional Formatting "IF", "Then" and "Else" in Web Intelligence.
- Developed various Charts, Graphs, drill down reports, Vertical and Horizontal Tables using Web Intelligence.
- Exported reports as Power Point, PDF, Excel or CSV.
- Involved in creating Conditions, Operators, Formulas, Filters, Ranking, Sorting, SubQueries, Combined queries, Prompt, Section, and Scope of Analysis (Input Controls) in Web Intelligence.
- Utilized Merged Dimensions feature to allow linking of two or more data provider (queries).
- Converted Deski reports to Webi using Report Conversion tools.
- Created various dashboards using Crystal Dashboards and Xcelsius.
- Assisted with developing Crystal Reports in team environment - Creating, formatting, applying templates, linking to proper data source, sorting, grouping, summarizing, and aggregating data.
- Involved in effort estimations for development of the reports and Universes.
- Requirement gathering from Business Analyst and create the specs for development of Universe using Universe Designer - IDT.
- Modified and maintained Universes using Designer module to include objects such as Dimensions, Details and Measures according to the functional specifications.
- IDT - Worked with Connection Layer, Data Foundation Layer, Business Layer, aliases, Contexts, Aggregate Awareness, Index Awareness, Navigation Paths and Predefined Conditions.
- Created Aliases and Contexts for resolving Loops, checked the cardinality and Integrity.
- Developed Universes using OLAP data sources.
- Assisted in Database Design Star and Extended Star Schemas.
- Assisted transfer of data from SAP/R3 to BI.
- Created Multiproviders on infocubes and DSOs.
- Assisted generating reports using BEx Analyze and Query Designer.
- Testing and Validating data values.
SAP Business Objects Developer
Virtusa Systems India Pvt Ltd
11.2020 - 03.2021
- Performed complex Web Intelligence report conversions from Excel workbook to Webi.
- Performed unit and integration testing and participated in report validation and QA efforts as they pertain to reporting and data analytics.
- Written simple and complex SQL queries.
- Excessively worked with internal teams to analyze and recommend reporting solutions to meet business requirements.
- Developing highly visual reports using Xcelcius Dashboard.
- Designed, programmed, and implemented new reporting documents and processes, modified existing reports and produced ad-hoc reports as needed utilizing Webi.
- Maintained and adhered to standard report writing practices to ensure consistency of data and format between various reports.
- Validated report data values.
- Scheduling reports utilizing CMC.
- Coordinate security requirements and administration.
- Design/Deletion and management of groups, users, and objects.
SAP Business Objects Developer
BYJUS
04.2019 - 09.2020
- Develop and Support Data warehousing reporting and maintenance requirements.
- Responsible for technical design and requirement Analysis.
- Responsible for effort estimations for Business Objects Universe and reports requirement.
- Created the new Universes as well as customizing the old Universes (using aliases, contexts, aggregate awareness, aggregate navigation and hierarchies) as per the requirements.
- Creating Deski Reports, Webi reports (used alters, merge dimension, filters, prompts, user response, multiple data providers) as per the request.
- Involved in dashboard maintenance including updating existing dashboards as per user needs, which involved updating the underlying Webi Reports and Queries and displaying the updated data in dashboard.
- Creating Unit test cases and conducting unit testing of individual reports.
- Participated in reviews of the reports and Universes and creating the review logs and review checklists.
- Responsible for migration of reports and Universes from BO XI R3 to SAP BO 4.0.
- and fixes after migration issues in Webi Reports.
- Worked on SAP BO 4.0 Webi rich client, Universe Design Tool and LCM tool.
- Interacting with customers to fix the issues found in UAT.
SAP Business Objects Developer
Little Genie
08.2017 - 02.2019
- Recreated the existing reports from Excel format to Webi (.Wid) format.
- Interacting with the client for understanding the project requirements and planning the project and resource accordingly.
- Creating low level design documents.
- Customizing the Universes as per the requirements.
- Recreating Webi reports as per the requirement specs.
- Designed reports that include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
- Creating Unit test cases and conducting testing of individual reports.
- Interacting with customers to fix the issues found in UAT.
Education
Bachelor of Technology - Computer Science Engineering
Jawaharlal Nehru Technological University HYD
Warangal, Telangana05.2017
Skills
- BI Tools: Business Objects XI 403/31/R2/65, IDT, Universe Designer, Desktop Intelligence, BI Launch pad, Web Intelligence/Info View, BEx Designer, BEx Analyzer, Info cubes, EPM Dash Boards, Crystal Reports 2008/XI/10/90
- ETL Tools: Informatica 91/85/71, BO Data Services XI 40/32, BO Data Integrator 115
- RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005, Tera data V12, IBM DB2 V8
- Programming Languages: SQL, PL/SQL
- Front End Tools: ERwin 41, TOAD and SQL Developer
- Operating Systems: WIN XP/2003/2000, UNIX
- ERP: SAP R3, SAP BW/BI 70
Timeline
SAP Business Objects Developer
ITC Infotech India Ltd - Client SNB
09.2023 - Current
SAP Business Objects Developer
SOUXE Technologies Private Limited
04.2021 - 08.2023
SAP Business Objects Developer
Virtusa Systems India Pvt Ltd
11.2020 - 03.2021
SAP Business Objects Developer
BYJUS
04.2019 - 09.2020
SAP Business Objects Developer
Little Genie
08.2017 - 02.2019
Bachelor of Technology - Computer Science Engineering
Jawaharlal Nehru Technological University HYD
Similar Profiles
Arief MohammadArief Mohammad
Lead Consultant at ITC Infotech Pvt Ltd To Support Client (BAT)Lead Consultant at ITC Infotech Pvt Ltd To Support Client (BAT)
Rakshith G AminRakshith G Amin
Business Analyst at ITC Infotech India LimitedBusiness Analyst at ITC Infotech India Limited
DILIP PALIWALDILIP PALIWAL
Associate IT Consultant at ITC Infotech India LtdAssociate IT Consultant at ITC Infotech India Ltd