SUMMARY

• With 6 years of IT - experience in SAP Business Objects and Tableau with experience in Administration, Designing, Development, Production Support, Application Maintenance and Testing using wide range of reporting systems with SAP Business Objects BI 4.1/4.0, Business Objects XI 3.1 & Crystal Reports 20011/2013, Tableau 9.2/9.1.
• Involved in requirement gathering, gap analysis and developed functional specifications, technical Specifications and prepared business blueprint documents.
• Expertise in Design, Development and Deployment of BI solutions for Corporate reporting requirements and involved in 2 full life cycle implementation projects and 1 production support project.
• Extensive knowledge of applications like Web Intelligence, Desktop Intelligence, Crystal Reports, Design studio 1.3, Dashboard 4.0/4.1 (Xcelsius 2008), Universe Designer, Information Design Tool, Central Management Console, Microsoft Live Office, BEx Query Designer, BEx Analyzer, Tableau 9.2/9.1, BIRT 2.6.
• Proficient in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.2/9.1.
• Developed captivating interactive Xcelsius Dashboards using QaaWS, SAP Netweaver BW Connections and Query Browser (BO 4.0) on top of SAP data sources as well as on Non-SAPs sources.
• Developed highly formatted Crystal Reports using options such as Grouping, Sorting, Sub-reports, Formula Fields, Alerts and Field highlighting on top of any data sources.
• Experience in Designing, Testing and Deploying BO Universes. Developing WebI reports with various functions like Input Controls, Graphs and Breaks, Drill Down & Drill Up, Slice and Dice.
• Had a formal internal training with SAP on the interactive data analysing and visualization tool- SAP LUMIRA.
• Worked on creating, organizing, and scheduling reports using Central Management Console (CMC), Infoview and BI Launch Pad. Created User profiles, groups and security for BI end-users.
• As part of Information Consumer Layer designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path.
• Expert in BI Testing process in functional Unit Testing, Data validation, System &Integration testing.
• Accessed Analytic and calculation views from BO Analysis via ODBC connection (BOBJ Integration).
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence (Webi), BO Analysis. Enabled BO Explorer to search data present in HANA.
• Successfully installed RStudio and gone through R Language basics on Data Camp website.
• Analysed different Data Science algorithms such as linear regression, Logistic regression, Random forest. Implemented Logistic regression on opportunity data and found out the probability of opportunity being closed based one the trained and test data.
• Implementation, training and maintenance of client/server Data Warehouse and Data Mart systems in multiple domains.
• Expertise in writing SQL queries, functions, stored procedures, triggers.
• Expertise in Vlookup, Hlookup, Pivot tables, Nested formulas, Macros in Microsoft excel.

TECHNICAL SKILLS

Tools: SAP BO XI R3/ BI 4.0/BI 4.1 (SP2), Tableau Desktop 9.2/9.1, SAP HANA 1.0 (SP4 & SP5), Universe Designer, Deski, WEBI/WEBI Rich, Info View, SAP BW 7.3/ BI 7.0, BEx Query Designer, Broadcast Agent, CMC Performance Management, Report Conversion tool, Import Wizard, Crystal Reports 2011/2013 and Crystal Reports Enterprise 4.0, IDT 4.0, BIRT 2.6.

Dashboard Tools: Design Studio, Dashboard Designer, Xcelsius 2008.

Reporting: BEx, WebI, Deski, Analysis-Edition for OLAP/ MS Office, Explorer and Live

Operating Systems: Windows NT/XP/2000/7/Vista, Linux.

Databases: Oracle 11.2, Oracle 9i/10g, MS Access 2010, SQL server 2010 & 2012, SAP BI 7.0

Program Languages: C, C++, PL/SQL, SQL*PLUS, R

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SAP BO Developer/ Data Science (Machine Learning)

Responsibilities:

• Have attended daily scrum calls to update the daily status and to escalate current issues.
• Have been prime responsible for Universe level changes which helped BO reports to be separated based on different business users.
• In the process of Universe level amendments dealt with loop problems and resolved those using methods like Alias, Context.
• Performed unit testing on amended Universes in QA environment and exported to production.
• Created webi reports as per the new business user’s requirement and performed unit testing.
• Created webi reports based on functionalities like merged dimensions, context functions, sub queries.
• Applied functionalities like input filters, ranking, sorting, creating measures, purging.
• In the process of performing unit testing on webi reports, tested them based on number of records retrieved by the query, product dimension data and business user data against the database.
• Have worked on outstanding dashboard issue log and made bug fixes, enhancements accordingly.
• Engaged with users for new requirements gathering and provided training to them on BO reports functionalities which are implemented. Data Science/Machine Learning
• Attended business meetings to understand business scenarios regard to opportunity data and how efficiently those can be implemented in machine learning methodologies.
• Successfully installed RStudio and gone through R Language basics in Data Camp website.
• Analyzed different Data Science algorithms such as linear regression, Logistic regression, Random forest.
• Implemented Logistic regression on opportunity data and found out the probability of opportunity being closed based one the trained and test data.
• Calculated the model accuracy based on the True performance rate VS False performance rate and plotted the graph.

Environment: Business Objects 4.1 (IDT, UDT, BI Launch pad, Rich client, Dashboard Designer), Dashboard Designer, Oracle 11.2, Oracle SQL Developer 4.0.3.16, PL-SQL, R, RStudio Desktop 1.0.153, Microsoft Outlook, Windows 7.

Confidential, San Francisco, CA

SAP BOBJ Developer

Responsibilities:

• Involved in project migration BO XI R3.1 to 4.1 and carried out migration testing in QA &Prod environments. and extensively worked on issues after migration.
• Created Web Intelligence reports using BO 4.1 Rich client and performed unit testing.
• Created user Prompts, Conditions and Filters for various reports to specified the reporting parameters.
• Created graphical representation of reports such as bar charts, pie charts etc as per the user requirements.
• Extensively used Information Design Tool (IDT) to create the Universe and successfully exported to Business Objects repository.
• Created Universe using functionalities such as Prompts, Pre-defined conditions; Customized LOV’s.
• Resolved the problem like Chasm Trap, Fan Trap and Loops using Aliases and Contexts, Aggregate Tables, Derived Tables, Index Awareness, Shortcut Joins, Functions, Custom Hierarchies.
• Created derived table in Universe by selecting required objects from different tables as per business needs.
• Defined row level security and column level security by creating Data security profile and Business security profile, applied access restrictions to certain users.
• Analysed the business logic built into the warehouse and gathered user requirements for the reporting work.
• Using Design studio 1.3, created overall drug trend, average prescription rate, generic substation rate dashboards which helps users to take strategic decisions.
• Extensively worked through existing Dashboard request and issue log and done major enhancements and bug fixes.
• Monthly processed Dashboard Intermediate file which acts as ETL to produce latest data in form of heavy volume CSV files.
• Manually processed data loads to the Dashboard which are not available at Business Objects Universe level.
• Created Static Dashboards and Business presentations by importing data from Excel sheets.
• Involved in modifying SQL queries to meet reporting requirements.
• Created Database Designed and implemented Tables, Functions, Stored Procedures and Triggers in SQL server.
• Attended offsite meetings to understand organization long term goals and challenges

Environment: Business Objects 4.1 (BI Launch pad, Rich client, Dashboard Designer, CSV connector), Design Studio 1.3, Business Objects XI R3 (Designer, Web Intelligence, Info view), SQL Server Management studio 2012, SQL server 2012.

Confidential, Reston, VA

Tableau /SAP BO Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Converted Deski reports to Webi reports using report conversion tool.
• Created Webi reports from scratch and applied input filters as per user requirements.
• Created Master/detail reports and applied functionalities like charts, alerters, ranking.
• Performed unit testing on created reports and got the sign off from the users, created well defined user manual and provided training to users.
• Using Crystal reports 2013, Created complex reports and charts to produce the amount of repossessions.
• Created reports that contained information detailed information on loan and lease accounts.
• Created a report containing loan, lease and combined account information by inserting 8 sub reports to display the information in one report.
• Created several crystal commands the produced reports containing collateral and assessment information based on shared variables and complex formulas. These reports also displayed a pie chart containing repossession summaries.
• Gone through Tableau requirements study and thorough training by the technical lead.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Created and modified Business Intelligence analytical reports using Tableau.
• Responsible for creating Metrics, Filters, calculated fields, parameters using Tableau Desktop.
• Developed customized calculations when required.
• Extensively used Tableau Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Created Unit Test Cases and documented the Unit Test Results.
• Bug fixes during unit testing and system testing.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9 desktop/Server.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: SAP BO XI R3.1(Deski, Webi, Infoview), SAP BO 4.1 (Webi Rich Client, Report conversion tool, BI Launch pad), Crystal reports 2013, Tableau Desktop 9.2/9.1, Tableauserver / Administrator, oracle, Microsoft Excel 2007, MS Access 2010, Windows 2007 server, Microsoft office 2007.

Confidential

SAP BO Developer

Responsibilities:

• Involved in Business Requirements Gathering, prepared functional Design & technical Design Documents, designed the Purchasing Scenario and activated business content data sources.
• Administered for a while on installation, maintenance, assigning roles and upgrading patches.
• The role involved in building data mart and linking universes and working on reporting tools in order to create different sales reports like purchase orders etc for different clients.
• Involved in the project from project realization phase, testing and go live phases.
• Gathered user requirements for BO reports and Dashboards. Prepared Business Blueprint Documents (Report Specs) to understand process design and flow.
• Developed SAP Dashboards using Dashboard 4.0, on top of SAP BI Queries (Bex Queries) using SAP Netweaver BW Connection for KPI representation and to reflect user adoption Metrics at department level for the ease of user.
• Acted as the dashboard specialist for Revenue dashboard, Loans and Inventory dashboard.
• Involved in Tuning and server configurations for different environments.
• Involved in Design of data models and data mart constructs.
• Used the BO tool Analysis Edition for OLAP to reflect the BI queries in more viewable and presentable format for analysis of the data.
• Worked on data modelling such as creation of info objects, application components, info areas, data sources, DSO, Cubes, transformations.
• Design & Development of IDT universes with calculated measures and custom filters.
• Manage incidents, including complex troubleshooting across technologies.
• Coordinate configuration, change, release, capacity and availability capabilities.
• Designed Sales planning and Order life cycle Dashboard Using Dashboard Designer 4.0 with BICS and as well created user groups for Webi & Crystal report email bursting with user specific data.
• Extensively involved in training users for Web intelligence, Crystal Reports, and Xcelsius.
• Published Crystal Reports to BI Launch Pad and provided access to the end users.
• Developed Crystal Reports with Web Elements. Where they use a Custom Function library for Crystal Reports which allows you to easily embed web controls on to the report.
• Created Packages, Schemas (Universes), Attribute Views, Analytical Views, Calculation Views, Analytical Privileges, Functions and also modified the system generated joins.
• Had an internal training in HANA1.0 application for creating Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Experience working with large volumes of data and being able to build summary tables for the dashboard.
• Closely interacted with business team and completed the QA testing, conducted workshops (Trained Business Users how to use Reporting)

Environment: SAP BOBI 4.0, Webi Rich Client, Dashboard Designer and Crystal Reports 2011, Mobil 4.0, HANA 1.0, Linux, Ms Office, Visio, MS Outlook, Oracle 10g, BI 7.0.

Confidential

Business Intelligence Developer

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Extensively worked on SAP Business Objects BI 4.0 suite tools like Information Design Tool (IDT), WebI, WebI Rich Client, BI Launch Pad, Dashboard Designer and QaaWS.
• Created universes in IDT which facilitated requirements of adhoc, canned reporting and Dashboards.
• Created a multisource universe for bringing the data from different sources along with managing and personalising the information spaces for analysing the financial data using the BO Explorer.
• Created the Exploration view sets and exploration views. Scheduled the information spaces for indexing.
• Created Universe using functionalities such as Prompts, Pre-defined conditions; Customized LOV’s, resolved the problem like Chasm Trap, Fan Trap and Loops using Aliases and Contexts, Aggregate Tables, Derived Tables, Index Awareness, Shortcut Joins, Functions, Custom Hierarchies.
• Created Ad-hoc and standard reports using functionalities such as Conditional Formatting, Input Controls, Combined Queries (Union, Intersection, Minus), Alerts, Breaks, Sections, Scope of Analysis, Ranking, Sorting, Formulas, Variables, Merge Dimensions, and used different formatting such as Vertical, Horizontal, Cross tab, Charts etc.
• Resolved Loop Problems by creating alias tables and checked the integrity, to find join problems and detect keys.
• Preparing detailed Technical Specification for the Dataflow, Data Marts and Reports based on the client requirement.
• Designed and created a Financial Dashboard that gives the overall perspective of the financial system.
• Created the Column Charts that provides the comparison of the Planned, Budget Update and Actual data.
• Used the Dynamic visibility functionality of the Dashboard designer and also the BIWS from the scheduled WebI reports to improve the performance of the Dashboard.
• Used Open document to connect Webi report to Dashboard for drill down purposes.
• Extensively used BIRT to create reports with various chart selections.
• Created and implemented the design plan for the data warehouse in the SQL Server 2008.
• Involved in Unit Testing of Reports and validating the Report Data against the source systems.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Provided training to end users to use various functionalities of Business Objects.
• Tuned reports for the better performance, reduced dependencies using aggregate tables.
• Involved in writing complex functions and stored procedures and triggers in SQL server management studio.

Environment: SAP BO BI 4.0/BOXI 3.1, WebI, WebI Rich Client, Information Designer Tool, Dashboard 4.0, BO Explorer, BIRT 2.6, SQL Server 2008, Visual Studio 2008.