SUMMARY:

• BO Consultant - Business Intelligence/Data warehousing experience with multiple end to end implementation experience, full-cycle SAP BI-BO implementation, Upgrade projects.
• Having IT experience in requirement gathering, technical analysis, estimation, solution design and architecture, development & implementation of business intelligence applications for University, Transportation and Manufacturing and Retail Industries.
• Having Tableau Experience in Enterprise Environment, in Tableau 9.1/9.2 as a Developer.
• The projects were related to ECC modules SD, FI-CO, COPA, MM, QM, SRM, HR, PP and CRM modules.
• Experience in BO Analytics project implementations like requirements gathering, KPI analysis, data modeling, extraction, reporting, reports designing using BEX, BO tools, Cutover and go-live activities, end-user training and support, change request analysis and performance tuning.
• Interacting key business stakeholder, understand existing reporting Capabilities and BI BW reporting solutions, Created requirement specification document, Design and develop Reports using BI 4.1 tools, SAP Dashboard, SAP Design Studio 1.5, Lumira 1.25, Explorer, Analysis OLAP, Analysis MS Office, Web intelligence, BO IDT.
• Developed Finance and controlling, P&L, Balance sheet, COPA, Production planning, MRP, Inventory, shipment, Gross profit, sales summary, Out of stock and Budget forecast Dashboards and Webi reports.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience in Publishing the BO reports, dashboards to the Mobile Devices and automatic report scheduling to send daily alert SMS and integration of Mobile APPS to reporting tools.
• Experience in Configuring and Creating Objects in BI clients such as Lumira, BO Explorer, and Tableau for Visualization, and Integration with BW-BEX and HANA Views.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as development, testing, Migration, Administration, security management and production support.
• Hands on experience in designing, developing and successful deployment of large scale projects from end-to-end.

TECHNICAL SKILLS:

ERP Tools: SAP ECC 6.0, SAP R/3 4.6.

Functional Modules: SD, MM, GL and FI/CO, PP, CRM, CO-PA, HR, SRM.

BI &ETL Tools: SAP BI 7.4/7.0, SAP BODS 4.X.

Databases: Oracle 11i/10g/9i, SQL Server 2008/2005, DB2, MS SQL.

Business Modeling: Information Design Tool (IDT), Data Warehousing Workbench (RSA1)

Programming/Web: SQL, PL/SQL, HTML5, CSS3, Web designing.

Operating Systems: Sun Solaris UNIX, Win 7/XP/NT.

Reporting Tools: SAP Business Objects BI 4.x, Analysis for Office, Analysis for OLAP, SAP BO Explorer, BI Launchpad, SAP Lumira, Design Studio, Crystal Reports for Enterprise, IDT, Dashboards(Xcelsius), Live Office, Webi, Bex Query Designer, MS Excel and Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

SAP BO Consultant

Responsibilities:

• Created complex WEBI reports with multiple queries, custom SQL, using complex functions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
• Created reports using various versions of Crystal Reports to satisfy the Business Users Report Requirements from Transactional Database.
• Developed Sub-reports, Formula Fields, Parameter Fields, Running Total Fields and Group Fields while developing Crystal Reports.
• Developed Group Selection and Record Selection Formulas to display the desired data in Crystal Reports.
• Created the CKF's & RKF's, formula variables, multi providers. Worked on Bex queries, Bex Analyzer, and back end with SAP BI, DSOs, Cubes and Info Objects to validate the data.
• Designed and implemented near-real-time monitoring Dashboards for Tableau Server and Visualization users
• Translated business and functional requirements into development objects in SAP BO.
• Developed 10 dashboards (Productivity, Cash bank balances, Sales summary, out of stock and Employee headcount dashboards). Worked closely with business to help them and come up with their desired visualizations
• Participated in requirements elaboration work-shops for Accounting and Finance business processes for users in the different corporate and business units including Accounting, Sales, General Ledger, Procurement, Planning & Budgeting, Incentives & Commission Management and Regulatory/Compliance.
• Created analytical, operational, relational, What-if Model Dashboards in Xcelsius 2008 using QAAWS and Live office developed Mobile APPS with design studio to enable executive's view of the business performance.
• KPI & Report requirements analysis, Data modeling, Technical Design documents & Development of reports related to FI-CO, Project Systems, COPA - Budgeting, SRM, SCM modules.
• User acceptance tests of BW reports and end-users training & go-live support. Worked on the post go live cut over activities and support issues through HPALM.
• Worked on the all the features of query designer like QTD, YTD variables, restricted, calculated key figures and cell references.
• Established data quality metrics, standards, improvement opportunities to better support Accounting and Finance business needs.

Environment: BI 4.1, BODS 4.1, IDT, WEBI, WebI Rich Client, Crystal Reports 2011, SAP BW 7.4 SP 11, SAP ECC 6.0, Oracle 10g.

BI Report Developer/Monitoring Support

Responsibilities:

• Responsible for gathering business requirements, doing gap analysis and documenting them textually or within models.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created different KPI’s using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions).
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created complex webi reports with multiple queries, custom SQL, using complex functions, merging dimensions at report level, drill down, and drill up, drill across, complex filters etc.
• Worked on information Design tool (IDT) to create universe from multiple data source. Involved in creating reports on the web using Business Objects Web Intelligence training and knowledge transfer to assigned project members.
• Has participated in project planning sessions with project managers and team members to analyze business requirements and outlines proposed solutions.
• Has scheduled and published web intelligence reports based on specific time, events and calendars in various formats such as Excel and PDF.
• Provided user support and training on Designer for creating Ad-Hoc reports. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode.
• Extensively worked in Oracle SQL and Microsoft SQL Server databases to query and provide clients with large data sets used for forecasting tools and identifying trends .Created and ran daily reports in Business Objects and Crystal Reports

Environment: - BI 4.1, BODS 4.1, IDT, BI Launchpad, BO Explorer, Crystal Reports 2011, Web Intelligence, SAP BW 7.4, SAP ECC 6.0, Tableau Desktop 9.1/9.2, Oracle 10g,MS SQL server, Windows 7.

SAP BO Developer

Responsibilities:

• Turned raw data into strategic information and propose creative solutions for presenting dashboards, KPI's and operational reports.
• Tested Universe and Reports, which includes Database connectivity. Resolved loops and contexts to ensure the correct results from the query Objects in the universe, to ensure the correct mapping of the objects
• User acceptance tests of BW reports and end-users training & go-live support. Worked on the post go live cut over activities and support issues in solmon.
• Worked on XCELCIUS, WEBI, POLESTAR and crystal Reports in Business objects.
• Designed, Created and maintained the universes and reports with advanced formulas, joins and techniques.
• Created and Maintained Users, folders, scheduled and published reports to Crystal Management Console. Monitored failed reports. Exported reports in Excel, PDF and saved on Shared Network drive, e-mail to users as per the requirements.
• Worked on Information Design Tool (IDT) to create universe from multiple data source.
• Involved in solving production issues raised by the user on both standard and adhoc reports.
• Provided extended support and resolved Informatica batch issues on regular basis.
• Modification of the Universe for the client and assist them in their reporting solutions.
• Worked on the Administration of BOXIR2 and BOXI CMC Security setup.
• Enable dynamic report linking by passing Variables (prompts) between reports.
• Worked on scheduling of reports in different export formats such as .csv, excel, word, .pdf and enabling user subscriptions to BI content.
• Extensive experience in creating reports and dashboards with Charts (bar chart, Pie chart etc), Cross-tabs and sub reports. Extensive work on Xcelsius 2008, Dashboard Design (Xcelsius 2011).
• Worked on different databases and connected to universe.

Environment: SAP BO 4.0, SAP BI/ BW 7.0, WebI, Dashboard.