SUMMARY

• Analysing business requirements to understand and compile report development specifications
• Interacting with business teams and SAP functional, technical, basis, data, test teams
• Developing functional and technical specifications for new Business Objects reports
• Maintaining report specifications for changes to existing production reports
• Developing new BeX queries or changes to existing production queries
• Maintaining Business Warehouse specifications (for data model) for new development or changes to existing production data models (e.g. infoCubes etc)
• Business Warehouse development for all functions including but not limited those found under transaction RSA1 (e.g. infoObjects, infoAreas, cubes, multiproviders, data transfer processes)
• Setup of BW process chains, Building transports to move changes (using Solution Manager - Change Request Management) from development to test systems and production
• Unit testing business object reports in teh development system with supporting unit test documentation
• Development of new universes or BI consumer services (BICS)
• Changes to existing universes or BI consumer services
• Debugging/Trouble-shooting problems (for either teh Business Objects report or BW backend system): o In teh development system during unit testing or o In teh QA systems by teh business users
• Providing solid guidance in teh areas of data warehouses concepts, architectures and processes
• Providing noledge of SAP best/leading practices for SAP Business Objects and BW Development
• Providing expertise in loading, transforming and extracting data in teh SAP Business Warehouse
• Experience with teh OLAP implementations using Business Objects
• Deploying Business Objects reports to SAP Enterprise Portal
• Coaching and mentoring City staff in teh areas of Business Objects and BW Development
• Weekly noledge transfer with documentation to teh City staff

PROFESSIONAL EXPERIENCE

Confidential

Sr. Reporting & Analytics Consultant

Responsibilities:

• Installing, configuring, and upgrading Business Objects application suite (BO3.x, BO4.1x, BO4.2x), and maintaining software patch levels and set Analytics Roadmap ahead.
• Providing technical and thought leadership to onboarding Application Teams to BO platform
• Setting up and supporting teh overall Security Management and Content Management of BOE Platform.
• Customizations of BO integration with SAP BW, Oracle DB & HANA.
• Should be able to develop Java SDK scripts needed for BO functionality enhancement
• Monitoring system performance using Central Management Console and third party tools like SCOM/Operations Manager identify and resolve performance issues and tuning teh Business Objects system whenever needed.
• Providing mentoring, assistance and feedback to teh development team on all teh technical matters and issues, acting as a primary support to teh Development team and Business users for all content development projects and day-to-day support.
• Installing and deploying third party auditing and activity tools like, 360 Suite by GB & Smith and coordinated with APOS for product POC.
• Conducting end-to-end product testing for new 360-suite version me.e.2020.2-1, to identify product defects and enhancements. Created maintenance/housekeeping jobs on 360 portal for back up of Folders (public/personal)/Users & Groups/Events/Instances, Auto Promotion jobs, Temp file clean up jobs etc.
• Performed end-to-end business Objects upgrade from 4.2 SP4 to 4.2 SP7.
• Lead internal BO Admin initiative to move all non-generic OLAP connections (connections by a BEx query) to generic connections (Common gateway connection for all BEx queries) across all non-production and production environment.
• Created customized report scheduling solutions for teh business, in conjunction with teh BW team to resolve teh delays in data availability after a data load completes on teh BW side.
• Working with Business Managers, End users and all teh stakeholders in gathering & documenting requirements, providing estimates, creating High and Detail Level design specifications.
• Coordinating with offshore team for code deliveries and other activities. Experienced in interacting with business users to analyze teh business process and requirements and transforming requirements into screens, designing, documenting and rolling out teh deliverable.
• Monitoring system performance and availability to identify and resolve performance issues tuning teh Business Objects system for optimum performance. Meet with BI users to understand how they are using Business Objects - understand performance, support issues/blocker, and work on resolving them.
• Created PowerShell scripts for each of teh Weekly maintenance tasks in preparation of automation of weekly maintenance scripts for all BO servers.
• Gather Visualization requirements from teh users and create dashboards and reporting solutions.

Confidential , Canada, ON

Sr. Reporting/Analytics Advisor

Responsibilities:

• Providing overall development, administration and infrastructure support of SAP Business Objects Business Intelligence platform.
• Working with technical peers to design, develop and implement new reporting solutions. Working with business end users to ensure that teh BI platform is meeting teh expectations of self-service reporting & analytics.
• Development of dashboards, visualizations, and report development using SAP Lumira, Power BI & Tableau.
• Business Intelligence and Visualization using SAP Lumira, Design Studio & Power BI Desktop/Service.
• Using Power Pivot, Power Query, and DAX for shaping and modeling data
• Creating & Maintaining Tables, Stored Procedures, and Views using SQL Server.
• Investigating & troubleshooting existing BI solutions.
• Providing application & infrastructure support for teh Business Objects suite, following existing service level agreements.
• Leveraging 360 suite of products to manage and administer Business Objects platform, commonly used products include but not limited to 360 plus, 360 View, 360 Univ, 360 Live
• Administrating Business Objects 4.2 environment including user account provisioning, report promotion, and application upgrade.
• Supporting application infrastructure of Business Objects 4.2 environment across physical and virtual machines.
• Provide technical expertise in teh analysis, design, enhancement and implementation of business applications to support internal business functions.
• Perform BOBJ Administration tasks such as management of security, patching, performance tuning, publishing, promotion management.
• Resolving technical issues by working with teams across IT, such as server support, database administration, IT security and data services teams.
• Proactively engaging SAP for any issues that require vendor support.
• Resolving data integration issues/incidents by liaising with other support resources across IT and Business areas.
• Maintaining up-to-date product noledge by leveraging teh vendor noledge base and product roadmaps.
• Working closely with teh data services team supporting SAP Business Warehouse.
• Providing end user support and training, as needed, for teh Business Objects suite of products, such as Crystal Reports, Web Intelligence, Analysis for MS Office & OLAP, Lumira, Dashboards and LiveOffice.
• Ensuring that all systems are available in accordance with outlined service level agreements.
• Preparing documentation in teh form of process flows, system environment diagrams, and support documentation as required.
• Defining maintenance activities and openly communicate any associated impacts to environment stability/availability.
• Promoting self-service model for reporting & analytics.
• Developing new BeX queries, changing existing production queriesto accommodate changing business requirements.
• Developing new universes, Changing existing universes to accommodate changing business requirements

Confidential, ON

Sr. Reporting Analyst

Responsibilities:

• Working with technical peers to design, develop and implement new reporting solutions and business users to ensure that teh BI platform is meeting teh expectations of self-service reporting & analytics.
• Collect & analyze requirements, design visualizations leveraging teh most appropriate BOBJ reporting tools.
• Providing systems administration of Business Objects 4.2 environments, including user account provisioning, report promotion, and application upgrade. Overall systems administration and infrastructure support of SAP Business Objects Business Intelligence platform.
• Resolving technical issues by working with teams across IT, such as server support, database administration, IT security and data services teams.
• Presenting reporting & analytics solutions to a variety of audiences from IT to Business stakeholders and owners.
• Adopting, Implementing and following Service Management best practices, Information Technology Infrastructure Library (ITIL), to ensure a systematic and professional approach to teh management of IT services.
• 7 years of experience in Business Objects Reporting, Universe Design & Development, CMC Administration, BOE SDK Development, Xcelsius, Product Development & Testing, Data Modeling and Report Migration, currently working as BO Developer.
• Turning all business requirements into technical design specifications, managing teh report development process from beginning to teh end in all aspects of report design, development, implementation and support.
• Designing and developing new Universes using Universe Designer and Information design tool based on requirements gathered from teh business, updating and enhancing existing universes as and when required.
• Building and designing BI reports, dashboards and all forms of user facing analytical functionality using Hyperion reporting, Webi, Dashboards, Crystal reports, lumira, Analysis, Query designer etc.
• Designing report development process from start, considering all operational, analytical, forecasting and decision making needs of teh business, Identifying resources and defining a systematic channel for teh business to submit report specifications, enhancements and using teh same network to ensure smooth release of reports to end users.
• Creating, developing and maintaining custom Bex queries for each line of business ensuring all business logics and rules are defined and teh queries are ready to be used by end users via Analysis for office/OLAP, Webi, dashboards and several other BO applications.
• Coaching, guiding and training teh IT team on SAP tools and functionality. Creating various kinds of WebI Reports like On-Demand reports, Scheduled reports and complex reports
• Training end users and report leads on Webi, Analysis for Office and Dashboards to promote self-service functionality of teh tools and create an independent environment within teh business.
• Meeting with user groups, report leads business and process owners periodically to discuss modifications, progress, requirements and approvals on open tasks.
• Analysing, maintaining and recommending improvements in system requirements and processes.
• Researching and implementing industry best practices and creating common core standards within teh BI model.
• Smoke testing teh reports in Production environment to make sure all teh components is working properly. Working with development staff to translate requirements for analysis, design and development activities for BI reporting and analytics.
• Establishing a system of Bursting/publishing reports for teh sales force team to present better insight on individual sales numbers, trends and market info.
• Working extensively on Query designer to create dynamic Bex queries as data source on Analysis for Office, modifying these queries from time to time to support a wide variety of report consumers.
• Conducting Report Leads and end user’s trainings to promote self-service functionality of teh tools.
• Reviewing teh task in hand with teh IT team on a daily basis to ensure deadlines are met and any new concern does not go unobserved.
• Validating results of reports by comparing and corresponding to ECC, BW, and legacy systems - JD Edwards, Hyperion Essbase and Salsa etc.
• Migrating/Transporting WEB INTELLIGENCE / BW reports from one environment to teh other (DEV-SIT-UAT-POD) for better business user’s accessibility.
• Coordinating system sign-off, move to production, and support of application
• Providing on call and after hours support to teh business.

Confidential, ON.

SAP Business Objects Analyst

Responsibilities:

• Creating and maintaining Universe designer and Information design Tool (IDT) as per business requirements. Defining Joins, cardinality within teh schema, resolving Join path problems, loops and traps in teh Universe.
• Supervising process and functional design activities, creating functional requirements as an input to application design, developing and testing detailed functional designs for business solution components and prototypes.
• Testing teh reports in Production environment to make sure all teh components is working properly and help users test validate reports.
• Designed and established a Report development process within teh business, catering to a number of reporting, analytical and Operational needs based on teh underlying Universe.
• Developing, Scheduling and Bursting teh reports using Web Intelligence, Analysis for Office, Analysis for OLAP, Bex Analyzer, Crystal Reports and creating analytical, tactical and operational Dashboards using Xcelsius/Dashboards 4.2, Visual Intelligence (Later Lumira) for a better insight into teh business.
• Creating and maintaining BOBJ security groups, folders and categories to assure only authorized personnel can access Universes. Administrating security authentication of users and groups. Add, maintain & delete user accounts.
• Extracting data from SAP BI system using Ms. SSIS to SQL Server database and periodically transforming and loading data into SAP BW using Ms. SSIS as Data source.
• Maintaining and up keeping teh ETL process and data flow for in depth insight into business questions.
• Performing/creating multidimensional ad-hoc analysis of OLAP sources in Excel using SAP Business Objects Analysis edition for Microsoft Office creating BI presentations in PowerPoint .
• Training of internal staff (end user) on teh SAP Business Objects and BI Toolset and provide leadership in resolving short and long term business concerns including identifying continuous improvement opportunities.
• Creating Web Intelligence ad-hoc and canned reports and Identifying performance triggers by implementing Query filters, Alerts and Data Tracking.

Confidential

BI Analyst

Responsibilities:

• Developing, Implementing and maintaining new analytical tools as per business requirements.
• Developing reports and dashboards based on teh operational data stored in teh data warehouse.
• Installation and Administration of Business Objects, implementation of SAP Business Objects.
• Working with departmental teams to assist in teh creation of project deliverables throughout teh project life cycle.
• Broadcasting reports to portals and intranet for individual analysis. Liaison with UK based client’s top executives to ensure standardized process implementation across teh department.
• Extracting program progress reports from teh repository to identify KPI standings.
• Analyzing teh opportunity areas and create a plan of action for process improvement.
• Defining database usage concepts, selects records, organizes data and formats reports; exports (distributes) reports; builds, applies and removes report templates.
• Extracting data from outside sources, transforming it to fit operational needs and loading it into teh end target.
• Working with huge data retrieved from variety of sources.
• Integrating Business Objects XI 3.1 with SAP (ERP and BW), designing teh semantic layer using OLAP universe designer, designing and Implementation of Ad-hoc Reporting using Web Intelligence, design and Implementation teh Enterprise Reporting using crystal reports, Design and implementation of Dashboard using Xcelsius.
• Running batch processes to keep teh database updated.
• Managing a team of 3-5 MIS specialists, conduct pre-shift/post-shift sessions to stream line teh job in hand to speed up teh response time to teh requirements.
• Teaming up with IT department to enhance teh performance of reporting tools and queries for fast and better data processing.
• Preparing dashboards using SAP Crystal Dashboard Design (Crystal Xcelsius) to bring several dimensions to teh data for better business decisions.

Confidential

Business Analyst

Responsibilities:

• Working closely with teh SAP sustainment team to add, update and maintain teh data in teh server while interacting with teh end user to ensure data validity and requirements fulfillment.
• Preparing, reviewing and sharing performance reports on a regular basis for performance excellence.
• Extracting individual employee report to dynamically view each employee’s overall contribution to teh total sales for teh year, highlighting key opportunity areas.
• Identifying performance triggers by implementing Query filters, Alerts and Data Tracking.
• Organizing workflow to meet customer deadlines.
• Reviewing estimates and invoices for accuracy.
• Responding to ad-hoc request for competitive and strategic issues and communicates with all levels of leadership.