Northbrook, IL

630-***-****

ac6mnt@r.postjobfree.com

SUMMARY

Overall 21+ years of experience in software support, design, development, administration and implementation of high quality business solutions, with major focus on Business Intelligence and Database-driven applications.

Over 13 Years of experience in SAP Business Objects Enterprise administration.

Over 16 years of experience in Client Server Technologies and Web-based Applications, SAP Business Objects 4.2 SP3 (CMC, PMT, Upgrade Management Tool, BI Launch pad).

Worked as Solution Architect in gathering business requirements and providing solutions to fulfill client needs.

Worked as a Product Manager, leading Data Analytics team to setup data warehouse for analytical reporting.

Extensively applied Agile/Scrum Methodology using JIRA tool to successfully implement projects.

Extensive experience in design and development of complex Universes, Ad-hoc and canned reports, complex reports, Publications, scheduling the BO processes using BI Launch pad and Administering BO activities / repository.

Excellent Universe Design and Development skills over SAP BW/HANA and Oracle/SQL database environment using UDT and IDT.

Worked with ETL tool such as SAP BODS (Business Objects Data Services).

Expertise in understanding of Relational Database Models, Data Modelling and Data Quality.

Extensive working experience with Microsoft Tools, Power BI, Tableau, Cognos and Crystal Reports from version 4.5 until 2016.

Extensive experience in SQL & PL/SQL & Store Procedures.

Experience in various industry sectors such as Insurance and Wireless.

Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem solving skills.

Good Interpersonal Skills, Commitment, result oriented, hard working with a quest and zeal to learn new Technologies and undertake challenging tasks.

PROFESSIONAL EXPERIENCE

Allstate, Northbrook, IL 2005 – present

Lead BI Consultant

Working as a member of a BICOE team in supporting SAP Business Objects 4.2 platform to large base user.

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Created Dashboards for the leadership in Tableau showing KPI’s and performance of different regions.

Created reports using BI tool such as Crystal Reports for different Business areas.

Involved in SAP Business Objects Enterprise Landscape Design and Report architecture design.

Led a migration life cycle from BO XIR2 to 3.1 to BI4.1 including project planning, assessment and analysis

Installed and configured SAP Business Objects 3.1 and 4.1 on both Production and lower environments

Worked in a team to implement SSO/Windows AD and Load balancer.

Using Import wizard and Upgrade Management tool migrated the BOE content (Security, groups, folders, universes, events, instances and favorite documents) from old system.

Designed and implemented Security model to support Business hierarchical roles.

Extensively worked on Post Upgrade issues and interacted with the users to quickly resolve the issues.

Created new Universes as per the user requirements by identifying the required tables from datamart and by defining the universe connections.

Used Views and Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in the Universe.

Implemented Row level and Object level security at universe level.

Identified the facts and dimensions based on business requirements and modeled tables using Star schema.

Designed and Build complex WEBI and Crystal reports to display data from various data sources.

Involved in writing Documentation of Universes and WEBI Reports.

Conducted user trainings and provided presentations on BI Launch pad and BI tools like Xcelsius Dashboards for users.

Verizon Wireless., Schaumburg, IL 1998 – 2005

Sr. Systems Analyst

Created and maintained project plans on implementing data security, Universes and WEBI reports.

Extensively worked with Universe Designer. Developed and tested many universes for supporting Ad-hoc and canned reports. Also, Implemented row and column level restrictions.

Used Views, Derived tables to create the universe for best performance, and used contexts and alias tables to resolve the loops in the Universe.

Created complex objects according to the business requirements.

Worked on new Report writing, Data access, Data validation, test cases generation and assisted users on adhoc report construction using WEBI.

Involved in data modelling key decisions to decide on measures required to generate required KPI’s.

Implemented Event based mechanism to generate report instances on daily, weekly and monthly basis.

Created Standard templates for future Ad-hoc reporting needs.

Migrated the content from Dev to QA, UAT and Prod.

Performed unit testing, system testing and user acceptance test (UAT) for universe and reports.

Conducted user trainings and provided presentations on WEBI report creation for users.

Documented the process of migration, Universe design and Report build standards and procedures.

Aerial Communications. Chicago, IL 1996 – 1998

System Analyst

Developed Complex reports in Business Objects Environment. Built queries to retrieve data through a universe and set up query conditions.

Laid out the Text objects on the Business Objects in a visually appealing fashion using special fonts and graphics.

Created Charts, and Cross-Tab Reports using Business Objects.

Formatted the reports as per the client needs with inclusion of new columns.

Created test reports to check functionality of stored procedures.

Implemented complex Formulas and Business Logic in Business Objects.

Sprint, Schaumburg, IL 1994 – 1996

System Analyst

Created reports using MS Access database for finance users.

Created an interactive application using VB platform.

Performed unit testing, system testing and user acceptance tests for reports.

EDUCATION

Bachelor of Science in Computer Science, DeVry University, Addison, IL. 1994

CERTIFICATE PROGRAMS

Developing reports and Universes with Business Objects Xir2, Chicago, IL 2005

Waseem Akhtar

Contact this candidate