Experience

Benjamin Moore & Co.

• SAP BO Consultant

  • Jun 2016 - Present

  •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.•Responsible for design and develop… •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.•Responsible for design and develop complex BEx queries to meet reporting requirements adopt data modeling & data flow design best practices to develop robust & scalable solutions.•Developed Group Selection and Record Selection Formulas to display the desired data in Crystal Reports. •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•Involved in building BEX Queries using Calculated and Restricted key figures, Structures, Variables with User Entry/Default Value, Exceptions, Conditions and Formulas.•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.Environment: SAP HANA 1.0 SP11, HANA Studio, BI 4.1, BODS 4.1, IDT, WEBI, Lumira, SAP BW 7.4 SP 11, SAP ECC 6.0, Oracle 10g. Show more Show less



Wilmington University

• BI Report Developer/Monitoring Support

  • Jun 2015 - Apr 2016

  • 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.• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional… • 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.• 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. • Able to create Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Environment: - SAP HANA 1.0 SP9, HANA Studio, BI 4.1, BODS 4.1, IDT, BI Launchpad, BO Explorer, Lumira, SAP BW 7.4, SAP ECC 6.0, Tableau Desktop 8.x, 9, Oracle 10g,MS SQL server, Windows 7. Show more Show less



Sonata Software Limited (India)

• SAP BO Developer

  • Sep 2013 - Nov 2014

  • 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… • 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 BI/BW 7.1, SAP ECC, BEx Analyzer/ Explorer, BO 4.1, APO DP, Integrated Planning, GRC 5.3 AC Show more Show less