Business Objects Sap

Dilbag Singh

(SAP BO Developer)

Email id: *************@*****.***

Linked in: www.linkedin.com/in/DilbagSinghSaini

Contact#: 704-***-****

Summary:

Total 15+ years of experience in Business Intelligence using SAP Business Objects4.2/4.0/XI-R3.1/R2/6.x with Info view, Web Intelligence, Data Integrator & Quality, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008, Central Management Console (CMC), Promotion Management Tool, Central Management Server (CMS), Live Office, Business Explorer XI 3.1, Analysis for Office, Import Wizard and Report Conversion Tool, Tableau.

Exclusive Experience in SAP HANA connectivity with Universe Designer/Direct Calculation View and Business objects Bi Launch Pad

Strong Knowledge and Experience in SAP Business Objects from 2006. Strong knowledge and Skill in Data Integrator & Data Quality Tools using SAP and NON-SAP Databases.

Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.

Worked as Technical analyst was Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for BO Universes and Reports.

Applied Hyperlinking functionality from summary to detail reports.

Created reports from multiple sources & functionalities like slice & dice, drill down Reports.

Familiar with Robotic Process Automation (RPA) using UIPATH.

Extensive knowledge in SQL, PL/SQL& T-SQL programming and trouble shooting

Developed dashboards and reporting tools to meet client business objectives

Build custom data sources using your data wrangling skills

Provide support and training to stakeholders on reporting tools and reports, as needed

Partner with stakeholders to create a shared vision on how to solve client challenges

Created Data profiling and Data cleansing jobs to eliminate dirty data using Power BI.

Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.

Expert in Data Base, Script writing and manual Testing.

Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.

Gathered data inputs from multiple sources and develop queries

Validated and tested work to ensure accuracy and quality of data

Facilitated communication with clients regarding how to enable their data to solve business challenges

Complete SDLC experience including requirements gathering, analysis/design, development and testing.

Excellent communication, training, analytical and technical skills.

Good team player with excellent interpersonal skills

Technical Skills:

BI Tools: SAP Business Objects 6.5.x - 4.3, Crystal Report 9/10/ XI/ 2008, Xcelcius 4.5/2008, Info view, CMC, BEx Query, BEx Analyzer, Desktop Intelligence XI, Full Client, Web Intelligence, Business View Manager, Tableau, SAP Hana, SSRS, MicroStrategy 10, Analysis for Office, UIPATH, Live Office, Lumira, Power BI

ETL Tools: Informatica

Platforms: Windows (all flavors), Linux

Databases: SQL Server 2019/2012/7.0/6.5, Oracle 10g, 9i/ 8i, Access, DB2, SVN, AWS, DataGrip

Languages: Java, SQL, PL/ SQL,T-SQL, HTML/CSS

oProducts: SAP ECC, Microsoft Office, Erwin, SQL Plus, Clarity, JIRA, Service Now, Confluence, SSRS

Education:

Bachelor of Arts: Mathematics

Master of Arts: Mathematics - University of Kansas -Lawrence, Kansas

Professional Experience:

CSX, Jacksonville, FL Feb 2022 - Current

Technical Lead

CSX is a leading supplier of rail-based freight transportation in North America. CSX Transportation network encompasses about 20,000 route miles of track in 23 states, the District of Columbia and the Canadian provinces of Ontario and Quebec. Our transportation network serves some of the largest population centers in the nation. Nearly two-thirds of Americans live within CSX’s service territory.

Responsibilities:

Managed Onshore and offshore teams for on time delivery and nightly support.

Performed data queries and prepared reports on daily, weekly, monthly and quarterly basis.

Performed admin responsibility to give user access to universes, report and folders.

Used advanced Excel functions to generate spreadsheets and pivot tables.

Performed gathering and scoping in addition to performing the final build itself.

Created document template for requirement gathering.

Assisted junior report developers on the team.

Followed Make/Checker, Peer review, QA testing and approving for PROD.

Fixed production issues as a part of bug fix on daily basis doing unit testing and data validation.

Worked on cleaning repository on regular basis.

Created dimensions, Details, Contexts and Measures for universe development.

Designed report templates to maintain consistency for future use.

Helped design/modify Crystal reports.

Provided production support for daily user issues

Prepared documentation for upgrade from 4.1 to 4.3.

Resolved issue during BOBJ upgrade and post upgrade.

Helped team in creating new groups and granting/revoking access.

Resolved issues on priority basis and monitoring BOBJ servers.

Created summary to detailed reports using open document functionality.

Environment: Business objects 4.1/4.3, BI Launch Pad, WEBI, IDT/UDT, Service Now, Crystal Reports 2020 SP 3 Patch5, Oracle, SQL Server, CMC, Query Builder, DBeaver, CMS, MS Fabric, PowerBI, AWS, Azure.

Modivcare, Jacksonville, FL May 2021 – Feb 2022

Senior report developer

ModivCare helps state governments and managed care organizations run non-Emergency transportation services and integrated health care programs – affording more than 24 million covered plan members better access to care in their communities.

Responsibilities:

The Senior Report Developer produces SQL driven reports that are delivered to internal or external customers in satisfaction of contractual or operational reporting requirements using SAP Business Objects.

Prepared high quality reporting and project management

Performed gathering and scoping in addition to performing the final build itself.

Provided well written documentation for the final requirements of a report and can be counted on to serve as a reliable knowledge resource and owner for a report on an ongoing basis.

Assisting junior report developers on the team with reports they may find challenging to execute and/or scope.

Completed report conversion from Excel to Free Hand SQL and universe based WEBI reports.

Did Peer review, QA testing and approving for PROD.

Fixed production issues as a part of bug fix on daily basis doing unit testing and data validation.

Worked on GAP analysis on current and future systems and reporting.

Created dimensions, Details and Measures for merged dimension to apply context calculations.

Designed report templates to maintain consistency and for future use.

Analyzed the data using pivot tables and replication in WEBI.

Environment: Business objects 4.2, BI Launch Pad, WEBI, IDT/UDT, Mac Systems, Tableau, DataGrip, Service Now, Excel, Pivot tables, AWS, Smartsheet, Xcode, GitLab

Bayer, St Louis, MO April 2019 – April 2021

SAP Re-Engineering/ BI/BO Visualization Analyst

Responsibilities:

Applied process improvement and reengineering methodologies and principles to conduct business process improvement and process mapping activities.

Additional activity and data modeling, developing modern business methods, identifying best practices, and working closely with the project’s business team, business analysts, and training team.

Worked on existing mapping on Legacy Teradata DB and catalogued universes and WEBI reports to be replicated in the new system on SAP BW and SAP 4/Hana.

Created new SAP Hana connection and designed universe per calculation views. Validated the universe and mapped existing reports to new source.

Performed system improvements by identifying the problem, troubleshooting the issue, and working with the basis team to make the necessary changes.

Worked with Basis to enable new functionality within the system after system upgrades.

Applied BOBJ user security to accommodate new system changes or enable or disable functionality.

Coordinated with testers team to discuss to troubleshoot defects.

Provided meeting facilitation, interviewing, training and additional forms of knowledge transfer.

Directly responsible for defining reporting standards and frameworks while keeping ensuring consistency and quality with Legacy system.

Designed report templates to maintain consistency.

Helped Hana developer team on creating FDS.

Created models for business requirements conversion into SAP universe implementation.

Helped business team with report design, SIT testing, Regression Testing, Smoke Testing, Sanity testing and go live activities.

Data cleansing, storing and data validation for analytic purposes.

Fixed production issues as a part of bug fix on daily basis doing unit testing and data validation.

Worked on GAP analysis on current and future systems.

Conducted meetings and gathered new requirements for reports

Environment: Business objects 4.2, BI Launch Pad, WEBI, IDT/UDT, Windows 10, Power BI, Tableau, SAP BW, JIRA, SAP BW and S4Hana, AWS, SQL Server, DataGrip, Bex Query Analyzer/Designer, Service Now, Excel, Oracle, Teradata, Analysis for Office

Nestle, Minneapolis, MN Sep 2018 – March 2019

SAP BO Developer/ Vistex Data Analyst

Responsibilities:

Worked with business and IT stakeholders to help define a prioritized set of business outcomes and application work to accomplish those outcomes within the limitations of the applications budget.

Directly responsible for defining reporting standards and frameworks while keeping ensuring consistency and quality with Legacy system.

Worked with IT stakeholders to accomplish this application work in a way that improves the business and technical fitness of the application portfolio and minimizes ongoing support costs.

Help the applications organization's successful delivery of these business outcomes in partnership with business colleagues.

Modeled business requirements into SAP universe implementation.

Create report requirement and Technical and Functional Design Documents

Designed, deployed and Scheduled WEBI reports through BI Launch Pad.

Worked on optimizing the performance of the WEBI reports.

Help support activities in conjunction with infrastructure and operations to ensure the applications perform well in production.

Coordinated with testers team to discuss technical problems and troubleshoot defects.

Migrated reports from Legacy system to SAP BW(VISTEX) Universes based on Hana Views.

Designed Macros for data cleansing and formatting.

Environment: Business objects 4.2 SP05, BI Launch Pad, WEBI Rich Client, IDT/UDT, Windows 10, SAP BW, VISTEX, JIRA, SAP Hana, Power BI, SQL Server, Excel, Access DB, Service Now

Deloitte, Mechanicsburg, PA Jul 2016 – Dec 2017

SAP BO/CR/ Visualization Analyst

Responsibilities:

Designed Universes, WEBI and Crystal Reports per user requirements for State of IL project (SNAP).

Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports

Worked extensively on design and development of SAP HANA modeling objects such as Calculation views, Analytical views, Attributes views and SQL Views with good understanding of layered development approach and modeling process flow and consumed in Universe for WEBI reporting by creating relational and OLAP connection

Root cause issues and suggested solutions to resolve them.

Compiled and validated data, reinforce and maintain compliance with corporate standards.

Developed and initiated more efficient data collection procedures.

Worked with managing leadership to prioritize business and information requirements.

Environment: Business objects 4.1, CMC, BI Launch Pad, WEBI Rich Client, IDT/UDT, Windows 10, DB2, JIRA, Crystal Reports 2011, Unix, Analysis for Office, Business Explorer and Bex Query, Tableau, SVN

OCLC, Columbus, OH Apr 2016 – May 2016

Sr SAP Business Objects Analyst

Responsibilities:

Extracted, compiled and tracked data to generate reports.

Worked with other team members to complete special projects and achieve project deadlines.

Developed optimized data collection and qualifying procedures.

Performance Tuning to save time and resources.

Migrated/Designed Universe and reports from version 3.1 to 4.2 and fixed issues.

Leveraged analytical tools to develop efficient system operations.

Environment: Business objects 4.1 SP7, CMC, BI Launch Pad, WEBI Rich Client, IDT/UDT, Windows 7, DB2, Data Studio, JIRA

ConocoPhillips, Bartlesville, OK Aug 2015 – OCT 2015

SAP Migration Analyst

Responsibilities:

Migrated Universes and reports from lower to higher version.

Report conversion from DESKI to WEBI maintaining quality standards.

Suggested techniques to make visualization more effective.

Report analysis on old and new system and troubleshooting issues.

Environment: Business objects 3.1/4.1, Crystal Reports 11/2013, CMC Administration, BI Launch Pad, WEBI Rich Client, Windows XP, Oracle, BIWS, Bex Query, Analyzer, Business View Manager, Dashboard

Sonoco, Hartsville, SC Jul 2012 – Aug 2015

Project Manager/ SAP BO/CR/Data Analyst

Responsibilities:

Worked across Logistics, Finance, Sales and Manufacturing departments to improve product reliability, reduce machine down time, automate reporting, and minimize waste.

Managed Onshore and offshore teams for on time delivery.

Designed Visualizations and Reports to monitor plant health and each machine/Operator performance using IDT and Lumira.

Performed data queries and prepared reports on daily, weekly, monthly and quarterly basis.

Applied user security for users and groups.

Created materialized view for Performance tuning and designing new SSRS reporting.

Used advanced Excel functions to generate spreadsheets and pivot tables.

Suggested resolution for performance tuning to save time and resources.

Environment: Business objects 3.1/4.0/4.1, Crystal Reports 11/13, Crystal 8, CMC Administration, Info View, Xcelsius, Dashboard, WEBI, SQL Server 2012, SSIS, SSRS, Bex Query, Analyzer, Windows XP, Optivision, Oracle, Toad, HP Quality Center, Trello.

Phillips Exeter Academy, Exeter, NH Jul 2011 – OCT 2011

Universe and Report Analyst

Responsibilities:

Worked across school system to migrate data from Legacy system to Data Warehouse.

Created universes and reports for better and quick answers for educational organization.

Created reports for selecting bright students all over the world and make resources available for their boarding and scholarship programs.

Replicated existing legacy report to BO reports.

Gathered requirements for newly requested reports.

Anheuser Busch Inc, St Louis, MO Jun 2008 – Nov 2010

SAP Senior BO/BI/Data Analyst

Responsibilities:

Worked with sales and marketing team to generate more revenues by picking different ad choices and showing at different times to target different ethnic groups.

Created universes and reports for better and on time delivery and monitor scrap

Created reports for based on user requirements.

Participated in requirement gathering session.

Applied Row and Object level security.

Used/Created Macros for task automation.

Performance tuning of slow running reports.

Designed dynamic SSRS reports per requirements.

Modified and created new reports using MicroStrategy and SAP Business Objects.

Created graphical charts and components for better understanding and visualization.

Arch Coal Inc, St Louis, MO Feb 2007 – Nov 2007

Senior Business Objects/Re-Engineering Analyst

Responsibilities:

Migrated data from Legacy system to Data Warehouse.

Created universes and reports per new requirements.

Report conversion from legacy to BO reports.

Performed Root Cause Analysis on production issues.

Cross trained junior developers and created templates to maintain look and feel of reporting environment.

CIT Inc, Livingston, NJ Aug 2006 – Feb 2007

Senior Business Objects Analyst

Responsibilities:

Report conversion from SQL reports to DESKI and WEBI.

Created financial reports and graphical visualization for better understanding for LOANIQ system.

Created universe and applied data security for data management

State of Louisiana, Baton Rouge, LA Mar 2006 – Jul 2006

Business Objects Analyst

Responsibilities:

WEBI report development including KPI, Alerts, Drill down functionality.

Designed and developed the Business Objects universes using Designer for Financial, Contract and Procurement and Grants applications.

Applied functionality for Ad-Hoc reporting.

Used SVN for version control.

Created reports on REMEDYDB for Incident management and tracking, Claims, Deceased Employee, Agency Tracking, Worker’s Compensation, Arrears/Benefits, problem ticket.

Inspire Insurance Solutions, Fort Worth, TX Mar 2000 – DEC 2003

QA Tester/Analyst

Responsibilities:

Conducted testing and identified discrepancies within the web-based application.

Involved in writing detailed test plans and test cases.

Analyzed system specifications and business requirements.

Wrote complex SQL queries to do the back-end testing of the application and verified the data retrieved from data warehouse.

Extensively involved in scripting and enhancing TSL scripts related to this project.

Manually tested some of the functionality of the application.

Executed regressing, system and integration testing using WinRunner.

AIG Inc, Irving, TX FEB 1998-NOV 1999

QA Tester/Analyst

Responsibilities:

Gathering specifications and requirements from development personnel prior to System Testing

Participated in designing the Test Plan, prepared Test Case Index document and Test Cases based on the requirements.

Performing Black Box Testing, Smoke Testing, System Testing, Regression Testing, Functional Flow Testing and Ad-hoc Testing.

Executed automated tests using WinRunner and Manual testing

Coordinated with development team to discuss technical problems and reported defects.

Used Test Director for reporting and tracking defects.

Used LoadRunner to test the performance of the system for different scenarios with different load. Generated Virtual user scripts for the scenarios identified for performance testing.

Contact this candidate