PROFESSIONAL PROFILE:

• Over 12 years of work experience in the field of Business Intelligence in domain of Telecom, Finance/Banking, and Healthcare using SAP Business Objects.
• Specialize in Reports Development, Universe Design & Development and administration.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise in Business Objects Enterprise Products SAP BO4.1 (Universe Designer, Desktop Intelligence, Web Intelligence, LaunchPad, Explorer, LCM, CMS & CMC) and its deployment.
• Have experience in migrating reports from BO5/6.1a/6.5.1 to BOXI.
• Have migrated system from BO XI R3 to SAP BI 4.0.
• Have upgraded system from SAP BI 4.1 to SAP BI 4.2.
• Experience working with Marketing, Business and IT stakeholders.
• Excellent data - analysis skills and ability to translate specifications into a working Universe/Report or Dashboards.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Installation and configuration of Xcelsius and designing complex reports and dashboards in monitoring business metrics.
• Experienced in Training & Supporting end-user reporting needs using Business Objects.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Developed and tested attributes/facts/metrics for Service Delivery Insight report according to the business requirements in Microstrategy.
• Responsible for designing and executing Application objects and Schema objects using MicroStrategy Desktop.
• Created Parent/Child relationships and set up dynamic attributes.
• Created migrations packages and assisted during promotions from Dev to Clone to UAT.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result-oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Having basic understanding of Lumira and Predictive Analysis.
• Good understanding of Agile Methodologies

TECHNICAL SKILLS:

• SAP BO 4.1, 4.0 XI 3.1/3.0, XI R1/R2, 6.5, 5.1
• BI Launch Pad
• UDT
• IDT
• CMC
• LCM
• Explorer
• Desktop Intelligence
• InfoView
• Import wizard
• Report Conversion Tool
• Xcelsius 2008
• Live Office
• Dashboard
• SQL
• db2
• Oracle
• Teradata

PROFESSIONAL EXPERIENCE:

Confidential

BO Consultant

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.
• Wrote Complex SQL Queries for Data validation purpose.
• Created Views, Stored Procedures and validated data for the Performance.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Documenting the upgrade/update BI Platform processes.
• Upgrading company's production reporting system from BO4.0 to 4.2 SP03 which included pre-checks, installation of the application and post-checks followed by extensive testing
• Documenting the upgrade/update BI Platform processes.
• Upgrading company's production reporting system from BO4.0 to 4.2 SP03 which included pre-checks, installation of the application and post-checks followed by extensive testing

Confidential

BO Technical Lead/ Data Analyst

Responsibilities:

• Responsible for collecting & understanding end user requirements, convert into functional/technical requirements, and support in preparing project plan.
• Designed, developed, maintained and tested universes for supporting canned reports & ad hoc queries according to the business requirements.
• Interacted with Users to know their Business views while gathering the report requirements and provided several Report Mock-ups to finalize the requirements.
• Created Technical Specification requirements, Use Cases, Interface specifications by translating business requirements.
• Upgraded system from BO3.1 to BO4.
• Created Dashboards for the top level Management using SAP BW (Bex queries).
• Designed, developed Universes and Webi Reports.
• Designed web intelligence reports for dimensional hierarchical data.
• Involved in unit testing and User acceptance testing.
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel).
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Implemented dynamic cascading prompts and defined business views
• Involved in Modifying and Performance tuning of the Existing Reports.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.

Confidential

Responsibilities:

• Worked as a Business analyst.
• Have managed the offshore team.
• Have done the monitoring activity in morning and the evening shift as per the roaster.
• Worked on GRS tool and closed many complex tickets.
• Have done the modifications in Stage for few reports and got them promoted to production environment once tested.
• Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system
• Crafted Monitoring activities to make it easy for better maintenance and help new members in the team.

Confidential

Responsibilities:

• Responsible for understanding end user requirement, convert into functional requirement, and involved in preparing project plan.
• Upgraded BEX queries from 3.x to 7.x.
• BO Webi reports created to match with BEX reports already available on e-report central.
• Extensive knowledge of working with company specific proprietary software and third party software.
• Created Technical Specification requirements, Use Cases, Interface Specifications by translating business requirements.
• Defined Security - Users/Groups/Folders based on Business Model.
• Done UAT of all the reports.

Confidential

Responsibilities:

• Responsible for capturing & understanding End User requirements and convert into functional requirement and involved in preparing project plan.
• Interacted with Users to know their Business views during requirements gathering and provided Several Report Mock-ups to finalize the requirements.
• Designed, developed, tested and maintained universes for supporting ad hoc queries and canned reports according to the business requirements.
• Created Technical Specification requirements, Use Cases, Interface Specifications by translating business requirements.
• Upgraded system from BO3.1 to BO4
• Created Dashboards for the top level Management using SAP BW (Bex queries).
• Exported Xcelsius to repository to make it available for users through info view.
• Implemented Open Doc to drill down to detail WebI report from Xcelsius Dashboard.
• Designed, developed Universes and Webi Reports.
• Designed web intelligence reports for dimensional hierarchical data
• Involved in unit testing and User acceptance testing.
• Deployed & Schedule the reports to CMC for the users to able to see the reports in Info View and export in different formats (PDF, Excel)
• Define formulas, parameters and conditions depending upon selection criteria.

Confidential

Software Engineer (BO Developer/SQL)

Responsibilities:

• Responsible for the development of BO report for the Corporate and Investment Banking (CIB) group at Mumbai.
• Performed report Migration from BO 5.1 to BO XI and publishing the same on the production server.
• Requirement gathering from the Paris team and analysis of MIS reports.
• Interacted with Business Users and Managers in gathering business requirements. 
• Responsibilities included analyzing data, evaluating past trends and current conditions, and communicating their conclusions and recommendations to senior management. 
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports. 
• Accounts receivable payment and trend analysis presentation to management committee to recommend strategic plans to increase revenue
• Prepared, analyzed and distributed monthly revenue report, quarterly historical performance report for finance SEC regulation
• Involved in the designing and building Universes, Classes and objects.
• Resolved loops and Traps using Contexts and Aliases while designing Universes. 
• Responsible for creating the Deski and Webi reports, On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc. 
• Making BO Portal available to different users. Granting Users with customized privileges.

Confidential

Software Engineer (BO Developer/SQL)

Responsibilities:

• Implemented Business Objects Enterprise 6.5.1 system that provides non-technical Business Users with access to information stored in data warehouses, data marts and packaged business applications in Reliance.
• Design and define Universe for each department using Designer module. As a part of Universe development, created classes, objects, cardinalities and Strategies and exported it to Repository.
• Requirement gathering and analysis of MIS reports.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables and User Objects in the creation of reports.
• Responsible for generation and publishing of reports,
• Managed & maintained 800 reports in daily, weekly, monthly and quarterly categories on BO server.
• Making BO Portal available to different users. Granting Users with customized Privileges.
• Administration of BO Server through Administrative Console.