MUHAMMAD UMAIR

acwvob@r.postjobfree.com

252-***-****

PROFILE SUMMARY:

•7+ years of experience in IT Industry, with expertise in developing Business Intelligence and Data Warehouse applications.

•Business Intelligence Consultant with a skill set of Business Objects 4.1/4.0/3.1/3.0/XIR2 and Crystal Reports 2011/2008, Crystal Dashboard Design (Xcelsius) 4.0/2008.

•Expertise working with SAP BI 4.0 (Information Design tool(IDT), Universe Design Tool(UDT),Life Cycle Management(LCM),Upgrade Management Tool (UMT), BI Launch Pad, WEBI, BI Workspaces),BW7.3

•Expertise using BOBJ 3.1 (Designer, Desktop Intelligence(DeskI), WebI, Rich Client, InfoView, CMC, Import Wizard, QaaWS, Publishing Wizard, Report Conversion Tool, Live Office, BI Services).

•Good knowledge in overall BI/BO4.0/XIR3 application architecture and able to Design, Deploy, Support the application.

• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.

•Created simple and complex reports involving Filters, Contexts, Hierarchies, Variables, list of values (LOVS), local variables, Alerter, Ranking and multiple data providers.

• Involved in Universe designing, developing and generating complex, Ad-Hoc, dashboard Reports, Business views along with User Acceptance Test and data accuracy test.

•Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.

•Create and maintain SQL queries required to support BO reporting needs.

•Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

•Proficient knowledge on BO XI Architecture and new features.

•In-depth knowledge in creation of Dashboards using Crystal Xcelsius/Dashboard Design.

•Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.

•Proficient in using SQL, PL/SQL, T-SQL to study data in different systems and to validate reports.

•Experience working with BW 7.3 backend db system.

•Created OLAP universes and Webi reports using BICS connection for BW.

•Created dashboard using BW as a data source querying BW using BEx.

•Experience using Query designer in BW 7.3.

•Good understanding of BW Info Cube.

•Involved in migration of BW to Hana db and testing and application migration.

•Worked with SAP HANA, created attribute view, analytic view, calculation view, store procedure, push calculation towards HANA to get maximum performance.

•Migrated Universe, reports, dashboard, user, groups etc from dev to qa, qa to prod using import wizard using best practices.

•Good knowledge and experience in using Oracle 9i/10g/11g, MS SQL Server 2005/2008.

•Process oriented thinking and problem solving approach.

•Ability to work under pressure and complete work on schedule. Having problem solving skills, quick and independent learning skills.

•Sound knowledge of waterfall, Agile methodologies

•Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.

•Experience with Agile development methods and practices

•Assigned, updates and track Defects status on Application Lifecycle Management (ALM) tool.

•Perform Automation Testing from Unified Functional Testing (UFT) tool

•Performed Functional Testing through Application Lifecycle Management (ALM) tool.

•Used Translation Management Tool to translate report metadata (.wid files) and Universe metadata.

EDUCATION:

Bachelor in Computer Science

Xcelsius Building Visualizations, Business Objects, (Atlanta, GA)

Business Objects Web IntelligenceXI R1/R2 Report Design, Business Object(Edison,NJ)

Business Objects XI R1/R2 Universe Design, Business Objects (Edison, NJ).

PROFESSIONAL CERTIFICATIONS:

SAP Certified Application Associate (Edition 2013) - SAP HANA

Configuring Windows 7

Active Directory, Configuring (windows Server 2008)

Network Infrastructure (windows Server 2008)

Application Infrastructure (windows Server 2008)

Enterprise Administration (windows Server 2008)

TECHNICAL SUMMARY:

Operating System:

XP, 2003, Win7

RDBMS:

Oracle 11g/10g/9i, MS SQL Server 2008/2005, MS Access, Teradata

Web Technologies:

SQL, PL/SQL

BI Tools:

SAP BI/BOXIR2/XIR3.0/XIR3.1/4.0/4.1, Crystal Reports 2011/2008, Dashboard Design/Xcelsius4.0/4.1/2008, SAP HANA,BW 7.3

EXPERIENCE:

Ford Motors Company, Dearborn Heights, MI

Nov 2014 – Present

Role: Business Objects Developer & Reports Functional Tester

Responsibilities:

Implemented object/data level security within Business Objects.

Analyze and Design Business Objects components based on the data sources, data definitions, data relationships and business rules.

Write Business Objects Code and Test Business Objects Components against data warehouses and operational data stores.

Created Universe using Universe Designer(.unv), Working with star, snow flake, relation model.

Created Several Reports in SAP Web Intelligence Rich Client version 4.0.

Provided technical expertise on Design, Performance Tuning, Data modeling, Data Warehousing, and Data integration for applications.

Partner with Business Intelligence and Business operational teams to implement new requirements. Ability to lead and guide a team.

Troubleshoot and resolve application / system issues, Conduct peer reviews to ensure standards.

Developed and maintained Audit report, Demographic reports and other analytical reports.

Tested several reports in QA.

Create Documentation such as Report functional Specs, Report Design Specs,Universe Design Specs, Universe functional Specs

Migrated reports, Universe to Accurev in the form of LCM biar file by using Promotion Management and applied the code in the QA.

Writing Complex SQL to Validate Data.

Working within the business and other team members to build requirements and design functional specifications for the data warehouse and front-end dashboards and reports. Maintain a clear understanding of the potential impacts of proposed solutions on other areas of the system and/or project.

Developed and execute unit testing for all developed objects including testing documentation and validation.

Provide ongoing support of the existing BO Reporting, Resolves coding, configuration, and data issues in a timely fashion.

Develops and maintains accurate documentation and meta-data for the data warehouse.

Create Meta Data Universe for Business users to track all the metadata elements (Universe Objects, Reports Objects, Reports to Objects mapping, Folders, Universe to Objects mapping etc).

Working in Agile Methodologies to track and manage the User Stories and tasks and make it deliverable within assigned Time period.

Created Reports Functional Test Cases and performed reports functional testing from Application Lifecycle Management (ALM) tool.

Assigned, updates and track Defects status on Application Lifecycle Management (ALM) tool.

Validate and perform automation testing from Unified Functional Testing (UFT) tool.

Used the Translation Management Tool to translate report metadata (.wid files) created with Interactive Analysis or Web Intelligence and universe metadata

Performed User Acceptance Testing responsible tracking documentation & understand requirements, creating test cases based on requirements, requesting test data to establish baseline, participating on conference calls with Project Team to read through test cases and get approved and follow through to production

Collaborates with QA team members in the execution of Quality Assurance (QA) and User Acceptance Testing (UAT) for reports functionality involving business rules decision services

Environment: Win7, Oracle 11g, Teradata, BO XIR 3.1, 4.0, 4.1

Children's Mercy Hospital, Kansas City, MO

May 2014 –Oct 2014

Role: Business Objects Developer & Administrator

Responsibilities:

•Completed Installation of Business Objects version 4.1 (SP4).

•Migrated all Contents (users, groups, folders, security rights, access levels, universes, universe connections, ODBC connections, categories, instances, application etc) from 3.1 to 4.1 by using upgrade Management Tool (UMT) through BIAR file.

•Secured sensitive data by applying a security feature of object level security in the Universe and the report level security in the CMC.

•Scheduled recurring daily, weekly and monthly reports (WebI) in Info View and used Calendar based scheduling for the reports custom dates.

•Created Universe using IDT (.unx) and Universe Designer(.unv), Working with star, snow flake, relation model.

•Provided SAP Business Objects system administration solutions as Scheduling of reports, Publication of reports, Assign folder level securities, Assign user group level securities, Assign access levels

•Web Intelligence report writing support for several application systems including Cerner, GE, McKesson, and several homegrown databases, with a commitment to hospital employees/system analyst satisfaction.

•Provided technical support to IS analysts and/or associates and leads projects and/or technology initiatives through all phases of systems development including: planning, development, implementation and operation for complex computer projects.

Environment: Win7, Oracle 10g/11g, Sql Server 2005/2008,BI 4.1,BO XIR 3.1, Crystal Dashboard Design(Xcelsius)4.1/2008.

TyMetrix,Hartford,CT

Mar 2014 –April 2014

Role: Business Objects Developer

Responsibilities:

•Gathered requirement in short term project, convert into technical requirement and start developing webi reports for end users.

•Created Web Intelligence reports in 3.1 for end users using combined query, merge dimension, function variable, drill throw reports, alerter, ranking etc.

•Providing daily, weekly, monthly, quarterly, yearly reports for end client.

•Validated data from Toad to Webi sql and make sure data is correct.

•Created documentation and hand over project to sustaining team.

•Hyper care project for postproduction support.

•Modified Webi reports to add more objects and formatted according to requirement on page mode.

Environment: Win7, Oracle 11g,BO XIR 3.1.

Ann Taylor, INC. New York

Aug 2011–Feb 2014

Role: Business Objects & Dashboard Developer

Responsibilities:

•Created Universe using IDT (.unx) and Universe Designer(.unv), Working with star, snow flake, relation model.

•Expertise in upgrading from 3.1 to 4.0 using UMT and applying new security on Admin level.

•Created Dashboards and Scorecards using Dashboard desing 4.0 with QaaWS, Live Office, BI Services, XML as a data sources.

•Created WEBI reports involving complex queries, sub queries, Unions and Intersection using BI 4.0 and BO 3.1.

•Worked with SAP HANA, created attribute view, analytic view, calculation view, store procedure, push calculation towards HANA to get maximum performance.

•Created Universes on OLAP SAP HANA model using star schema approach.

•Created Deski reports using free hand sql, flat files, store procedures, universe as a data source.

•Created several Universes (joining the tables, creating prompts and queries and applied Contexts and Aliases to resolve loops) for finance, sales, promotions, manufacturing, SCM, HR, LMS Users.

•Involved in ETL Process using BODS/Informatica.

•Addressed chasm trap and Fan Trap using Multi Parse SQL.

•Imported data from Excel to compare Actual Vs Budget.

•Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.

•Used Toad to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct.

•Secured sensitive data by applying a security feature of object level security in the Universe and the report level security in the CMC.

•Heavily interacted with the Client users to gather the requirements of the KPI WebI report.

•Created various drillable WebI reports.

•Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on the server.

•Created Reports with heavy conditional formatting and functions to meet user requirement.

•Customized the reports with custom functions and loops to leverage the user reporting needs.

•Scheduled recurring daily, weekly and monthly reports (WebI, DeskI) in Info View and used Calendar based scheduling for the reports custom dates.

•Created various group based publications and distributed reports to the users.

•Designed a HighPerformance universe by joining several dimensions to the fact table like Accounts and Returns.

•Migrated Universe, reports, dashboard, user, groups etc from dev to qa, qa to prod using import wizard using best practices.

•Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.

•Interacted with the users to analyze the changes for improvement they need in existing reports and develop the reports to satisfy their needs and requirements.

•Created several dashboards using Crystal Xcelsius, opendoc command to locate report from dashboards as drill down detail.

•Used Live Office, BI Services and QAAWS (Query ads a web service) to get the data from the database into the dashboards.

•Designed and Developed Xcelsius dashboards / analytics and exported to several formats

•In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components, dynamic visibilities.

•Created Olap connection using BICS in IDT.

•Created Webi reports using BEx queries as a data source from BW db.

•Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.

•Prepared user documentation for hands on training for end user community.

Environment: Win7, Oracle 10g/11g, BI 4.0,BO XIR 3.1, Crystal Dashboard Design(Xcelsius)4.0/2008.

L’Oreal, New York, NY

Jul 2009 – Jul 2011

Role: Business Objects & Dashboard Developer

Responsibilities:

•Created several universes using Designer using star, snow flake, relational model.

•Provided cascading prompts Custom Hierarchies in the reports as well as the Universe to create more interactive reports for the users.

•Created Webi/Deski/Crystal Report reports for sales, HR, Finance, SCM Users.

•Wrote a full functional specification document for the security implemented in Business Objects.

•Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.

•Created Custom Hierarchies to provide drill down capabilities in Webi for the ad-hoc power/general users.

•Developed several Complex Reports, various features used include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports.

•Used prompts, alerts, drill down analysis as per the end user requirements.

•Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks.

•Created graphical representation of WebI reports such as bar charts, pie charts etc.

•Migrated reports, universes, dashboards, connection, users, groups from DEV to QA and QA to Prod using import Wizards.

•Scheduled reports for bursting/publication on daily, weekly, monthly, yearly basis.

•Improved query performance by implementing aggregate awareness.

•Created interactive Scorecards and Dashboards using summary level data and provided users drill down reports and used QaaWS as a datasource.

•Created several Dashboards using alerts, highlight important metrics/KPI for VPs level.

•Involved in user training to the end users on working with Web Intelligence tool through infoView and WebI Rich Client.

•Involved in SDLC from the beginning to finish all the way from devto prod, handed over complete project after documentation to sustaining team for support.

•Involved in production supports, troubleshoot, CR, SR with the users in production.

Environment: XP/Win7, Oracle 9i/10g, Business Objects 3.1, Xcelsius 2008, Crystal Reports 2008

Mohegan Sun Resort & Casino, Uncasville, CT

Nov 2007-Jun 2009

Role: Business Objects Developer

Responsibilities:

•Developed Universes from scratch for different departments using BO Designer.

•Provided cascading prompts in the reports as well as the Universe to create more interactive reports for the users.

•Extensively wrote PL/SQL procedures to get data from Oracle database.

•Wrote a full functional specification document for the security implemented in Business Objects.

•Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.

•Created Custom Hierarchies for several groups.

•Used Toad to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct.

•Developed complex reports in Business Objects using multiple data providers.

•Created graphical representation of WebIreports such as bar charts, pie charts etc.

•Implemented extensive use of derived tables in the process of building reports.

•Developed hierarchies according to demand to support drill down reports.

•Improved query performance by implementing aggregate awareness.

•Was involved in Star Schema customization / Design session.

•Developed new WEBI reports in XI.

•Developed new reports along with modifying existing reports to support new and additional Business requirements.

•Created scorecards and dashboard using Live Office and QaaWS.

•Used prompts, alerts, drill down analysis as per the end user requirements.

•Used Shared and Global variables to pass data from Main report to Sub report & Vice Versa.

•Developed several Complex Reports, various features used include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports.

Environment: XP, SQL Server 2005/2008, Business Objects XIR2/3.0, Crystal Report 2008, Xcelsius 2008.

Contact this candidate